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

Aston Township - Time Series For Statistical Variables

@datacommons.cities.aston_township_wikidataid_q1895441
  • 100.25 kB
  • 15,900 rows
  • 12 columns
Loading... 
CREATE TABLE aston_township_wikidataid_q1895441 (
  "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
);

Aston - Time Series For Statistical Variables

@datacommons.cities.aston_wikidataid_q649838
  • 59.29 kB
  • 7,911 rows
  • 12 columns
Loading... 
CREATE TABLE aston_wikidataid_q649838 (
  "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
);

Astor - Time Series For Statistical Variables

@datacommons.cities.astor_geoid_1202275
  • 2.87 MB
  • 342,508 rows
  • 12 columns
Loading... 
CREATE TABLE astor_geoid_1202275 (
  "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
);

Astoria - Time Series For Statistical Variables

@datacommons.cities.astoria_geoid_1702635
  • 2.99 MB
  • 346,172 rows
  • 12 columns
Loading... 
CREATE TABLE astoria_geoid_1702635 (
  "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
);

Astoria - Time Series For Statistical Variables

@datacommons.cities.astoria_geoid_4103150
  • 3.32 MB
  • 361,962 rows
  • 12 columns
Loading... 
CREATE TABLE astoria_geoid_4103150 (
  "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
);

Astoria - Time Series For Statistical Variables

@datacommons.cities.astoria_geoid_4602580
  • 1.38 MB
  • 186,279 rows
  • 12 columns
Loading... 
CREATE TABLE astoria_geoid_4602580 (
  "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
);

Astoria Township - Time Series For Statistical Variables

@datacommons.cities.astoria_township_geoid_1702648
  • 72.7 kB
  • 12,429 rows
  • 12 columns
Loading... 
CREATE TABLE astoria_township_geoid_1702648 (
  "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
);

Astoria - Time Series For Statistical Variables

@datacommons.cities.astoria_wikidataid_q2073812
  • 72.01 kB
  • 12,399 rows
  • 12 columns
Loading... 
CREATE TABLE astoria_wikidataid_q2073812 (
  "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
);

Astrakhan - Time Series For Statistical Variables

@datacommons.cities.astrakhan_wikidataid_q3927
  • 82.7 kB
  • 11,174 rows
  • 12 columns
Loading... 
CREATE TABLE astrakhan_wikidataid_q3927 (
  "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
);

Astravyets - Time Series For Statistical Variables

@datacommons.cities.astravyets_wikidataid_q261024
  • 30.53 kB
  • 2,974 rows
  • 12 columns
Loading... 
CREATE TABLE astravyets_wikidataid_q261024 (
  "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
);

Astráin - Time Series For Statistical Variables

@datacommons.cities.astr_in_wikidataid_q8207617
  • 51.81 kB
  • 6,336 rows
  • 12 columns
Loading... 
CREATE TABLE astr_in_wikidataid_q8207617 (
  "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
);

Astros, Greece - Time Series For Statistical Variables

@datacommons.cities.astros_greece_wikidataid_q752163
  • 47.03 kB
  • 5,857 rows
  • 12 columns
Loading... 
CREATE TABLE astros_greece_wikidataid_q752163 (
  "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
);

Astrup - Time Series For Statistical Variables

@datacommons.cities.astrup_wikidataid_q752209
  • 49.94 kB
  • 6,232 rows
  • 12 columns
Loading... 
CREATE TABLE astrup_wikidataid_q752209 (
  "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
);

Astrup - Time Series For Statistical Variables

@datacommons.cities.astrup_wikidataid_q752210
  • 50.71 kB
  • 6,070 rows
  • 12 columns
Loading... 
CREATE TABLE astrup_wikidataid_q752210 (
  "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
);

Asuka, Yamato - Time Series For Statistical Variables

@datacommons.cities.asuka_yamato_wikidataid_q752394
  • 63.67 kB
  • 8,228 rows
  • 12 columns
Loading... 
CREATE TABLE asuka_yamato_wikidataid_q752394 (
  "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
);

Asunción Nochixtlán - Time Series For Statistical Variables

@datacommons.cities.asunci_n_nochixtl_n_undata_geo_c16800999
  • 9.31 kB
  • 1 row
  • 12 columns
Loading... 
CREATE TABLE asunci_n_nochixtl_n_undata_geo_c16800999 (
  "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
);

Asunción Ocotlán - Time Series For Statistical Variables

@datacommons.cities.asunci_n_ocotl_n_undata_geo_c16801000
  • 9.29 kB
  • 1 row
  • 12 columns
Loading... 
CREATE TABLE asunci_n_ocotl_n_undata_geo_c16801000 (
  "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
);

Asunción Tlacolulita - Time Series For Statistical Variables

@datacommons.cities.asunci_n_tlacolulita_undata_geo_c16801001
  • 9.31 kB
  • 1 row
  • 12 columns
Loading... 
CREATE TABLE asunci_n_tlacolulita_undata_geo_c16801001 (
  "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
);

Asunción - Time Series For Statistical Variables

@datacommons.cities.asunci_n_wikidataid_q2933
  • 44.05 kB
  • 5,056 rows
  • 12 columns
Loading... 
CREATE TABLE asunci_n_wikidataid_q2933 (
  "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
);

Asvestochori, Thessaloniki - Time Series For Statistical Variables

@datacommons.cities.asvestochori_thessaloniki_wikidataid_q3394321
  • 48.54 kB
  • 5,802 rows
  • 12 columns
Loading... 
CREATE TABLE asvestochori_thessaloniki_wikidataid_q3394321 (
  "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
);

Aswan - Time Series For Statistical Variables

@datacommons.cities.aswan_wikidataid_q29888
  • 26.15 kB
  • 3,142 rows
  • 12 columns
Loading... 
CREATE TABLE aswan_wikidataid_q29888 (
  "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
);

Asylum Township - Time Series For Statistical Variables

@datacommons.cities.asylum_township_wikidataid_q1893527
  • 69.17 kB
  • 12,075 rows
  • 12 columns
Loading... 
CREATE TABLE asylum_township_wikidataid_q1893527 (
  "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
);

Asyut - Time Series For Statistical Variables

@datacommons.cities.asyut_wikidataid_q29962
  • 40.24 kB
  • 5,773 rows
  • 12 columns
Loading... 
CREATE TABLE asyut_wikidataid_q29962 (
  "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
);

Aszód - Time Series For Statistical Variables

@datacommons.cities.asz_d_wikidataid_q752838
  • 73.92 kB
  • 10,499 rows
  • 12 columns
Loading... 
CREATE TABLE asz_d_wikidataid_q752838 (
  "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
);

Atacames - Time Series For Statistical Variables

@datacommons.cities.atacames_wikidataid_q753121
  • 19.97 kB
  • 1,709 rows
  • 12 columns
Loading... 
CREATE TABLE atacames_wikidataid_q753121 (
  "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.