Baselight
Sign In

Cities

Urban Statistics and Key Metrics

@datacommons.cities

Loading...
Loading...

About this Dataset

Cities

This dataset includes key statistical variables for worldwide cities, providing data on population, infrastructure, economy, and urban development.

Tables

Abutig - Time Series For Statistical Variables

@datacommons.cities.abutig_wikidataid_q3502865
  • 40.08 kB
  • 5,764 rows
  • 12 columns
Loading... 

CREATE TABLE abutig_wikidataid_q3502865 (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" DOUBLE,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

Abu - Time Series For Statistical Variables

@datacommons.cities.abu_wikidataid_q1349028
  • 51.97 kB
  • 6,405 rows
  • 12 columns
Loading... 

CREATE TABLE abu_wikidataid_q1349028 (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" DOUBLE,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

Abuzeydabad - Time Series For Statistical Variables

@datacommons.cities.abuzeydabad_wikidataid_q1764159
  • 35.15 kB
  • 3,983 rows
  • 12 columns
Loading... 

CREATE TABLE abuzeydabad_wikidataid_q1764159 (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" DOUBLE,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

Abyek - Time Series For Statistical Variables

@datacommons.cities.abyek_wikidataid_q783176
  • 36.96 kB
  • 4,215 rows
  • 12 columns
Loading... 

CREATE TABLE abyek_wikidataid_q783176 (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" DOUBLE,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

Ağcabədi - Time Series For Statistical Variables

@datacommons.cities.a_cab_di_wikidataid_q1983875
  • 36.12 kB
  • 3,882 rows
  • 12 columns
Loading... 

CREATE TABLE a_cab_di_wikidataid_q1983875 (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" DOUBLE,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

Acacia Villas - Time Series For Statistical Variables

@datacommons.cities.acacia_villas_geoid_1200075
  • 1.35 MB
  • 181,926 rows
  • 12 columns
Loading... 

CREATE TABLE acacia_villas_geoid_1200075 (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" DOUBLE,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

Acadia No. 34 - Time Series For Statistical Variables

@datacommons.cities.acadia_no_34_wikidataid_q4671576
  • 9.88 kB
  • 19 rows
  • 12 columns
Loading... 

CREATE TABLE acadia_no_34_wikidataid_q4671576 (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" DOUBLE,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

Acajete - Time Series For Statistical Variables

@datacommons.cities.acajete_undata_geo_c16801907
  • 9.21 kB
  • 1 row
  • 12 columns
Loading... 

CREATE TABLE acajete_undata_geo_c16801907 (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" DOUBLE,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

Acajete - Time Series For Statistical Variables

@datacommons.cities.acajete_wikidataid_q4059354
  • 61.58 kB
  • 7,651 rows
  • 12 columns
Loading... 

CREATE TABLE acajete_wikidataid_q4059354 (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" DOUBLE,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

Acala - Time Series For Statistical Variables

@datacommons.cities.acala_geoid_4801084
  • 828.85 kB
  • 55,359 rows
  • 12 columns
Loading... 

CREATE TABLE acala_geoid_4801084 (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" DOUBLE,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

Acalanes Ridge - Time Series For Statistical Variables

@datacommons.cities.acalanes_ridge_geoid_0600135
  • 2.88 MB
  • 343,006 rows
  • 12 columns
Loading... 

CREATE TABLE acalanes_ridge_geoid_0600135 (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" DOUBLE,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

Acalayong - Time Series For Statistical Variables

@datacommons.cities.acalayong_wikidataid_q2378079
  • 32.64 kB
  • 3,653 rows
  • 12 columns
Loading... 

CREATE TABLE acalayong_wikidataid_q2378079 (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" DOUBLE,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

Acampo - Time Series For Statistical Variables

@datacommons.cities.acampo_geoid_0600156
  • 2.72 MB
  • 336,081 rows
  • 12 columns
Loading... 

CREATE TABLE acampo_geoid_0600156 (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" DOUBLE,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

Acandí - Time Series For Statistical Variables

@datacommons.cities.acand_undata_geo_c07500458
  • 9.23 kB
  • 1 row
  • 12 columns
Loading... 

CREATE TABLE acand_undata_geo_c07500458 (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" BIGINT,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

Acandí - Time Series For Statistical Variables

@datacommons.cities.acand_wikidataid_q1575935
  • 9.4 kB
  • 1 row
  • 12 columns
Loading... 

CREATE TABLE acand_wikidataid_q1575935 (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" BIGINT,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

Acapulco - Time Series For Statistical Variables

@datacommons.cities.acapulco_wikidataid_q81398
  • 48.32 kB
  • 6,350 rows
  • 12 columns
Loading... 

CREATE TABLE acapulco_wikidataid_q81398 (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" DOUBLE,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

Acarigua - Time Series For Statistical Variables

@datacommons.cities.acarigua_wikidataid_q338059
  • 37.54 kB
  • 4,198 rows
  • 12 columns
Loading... 

CREATE TABLE acarigua_wikidataid_q338059 (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" DOUBLE,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

Acarlar - Time Series For Statistical Variables

@datacommons.cities.acarlar_wikidataid_q3233825
  • 36.85 kB
  • 4,024 rows
  • 12 columns
Loading... 

CREATE TABLE acarlar_wikidataid_q3233825 (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" DOUBLE,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

A Casagrande - Time Series For Statistical Variables

@datacommons.cities.a_casagrande_wikidataid_q12380294
  • 59.16 kB
  • 7,925 rows
  • 12 columns
Loading... 

CREATE TABLE a_casagrande_wikidataid_q12380294 (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" DOUBLE,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

A Casilla - Time Series For Statistical Variables

@datacommons.cities.a_casilla_wikidataid_q12380351
  • 62.98 kB
  • 7,903 rows
  • 12 columns
Loading... 

CREATE TABLE a_casilla_wikidataid_q12380351 (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" DOUBLE,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

Acatlán - Time Series For Statistical Variables

@datacommons.cities.acatl_n_undata_geo_c16801908
  • 9.22 kB
  • 1 row
  • 12 columns
Loading... 

CREATE TABLE acatl_n_undata_geo_c16801908 (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" DOUBLE,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

Acayucan - Time Series For Statistical Variables

@datacommons.cities.acayucan_undata_geo_c16801909
  • 9.22 kB
  • 1 row
  • 12 columns
Loading... 

CREATE TABLE acayucan_undata_geo_c16801909 (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" DOUBLE,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

Accident - Time Series For Statistical Variables

@datacommons.cities.accident_geoid_2400225
  • 2.95 MB
  • 348,653 rows
  • 12 columns
Loading... 

CREATE TABLE accident_geoid_2400225 (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" DOUBLE,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

Accokeek - Time Series For Statistical Variables

@datacommons.cities.accokeek_geoid_2400250
  • 3.24 MB
  • 359,885 rows
  • 12 columns
Loading... 

CREATE TABLE accokeek_geoid_2400250 (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" DOUBLE,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

Accomac - Time Series For Statistical Variables

@datacommons.cities.accomac_geoid_5100180
  • 2.99 MB
  • 353,217 rows
  • 12 columns
Loading... 

CREATE TABLE accomac_geoid_5100180 (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" DOUBLE,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

Share link

Anyone who has the link will be able to view this.