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

Apple Valley - Time Series For Statistical Variables

@datacommons.cities.apple_valley_geoid_3802820
  • 995.59 kB
  • 64,282 rows
  • 12 columns
Loading... 
CREATE TABLE apple_valley_geoid_3802820 (
  "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
);

Apple Valley - Time Series For Statistical Variables

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

Apple Valley - Time Series For Statistical Variables

@datacommons.cities.apple_valley_geoid_4901905
  • 2.9 MB
  • 343,992 rows
  • 12 columns
Loading... 
CREATE TABLE apple_valley_geoid_4901905 (
  "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
);

Applewold - Time Series For Statistical Variables

@datacommons.cities.applewold_geoid_4202752
  • 1.46 MB
  • 188,103 rows
  • 12 columns
Loading... 
CREATE TABLE applewold_geoid_4202752 (
  "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
);

Applewood - Time Series For Statistical Variables

@datacommons.cities.applewood_geoid_0802575
  • 3.25 MB
  • 359,366 rows
  • 12 columns
Loading... 
CREATE TABLE applewood_geoid_0802575 (
  "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
);

Appley, Isle Of Wight - Time Series For Statistical Variables

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

Appling - Time Series For Statistical Variables

@datacommons.cities.appling_geoid_1302536
  • 2.69 MB
  • 313,084 rows
  • 12 columns
Loading... 
CREATE TABLE appling_geoid_1302536 (
  "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
);

Appomattox - Time Series For Statistical Variables

@datacommons.cities.appomattox_geoid_5102072
  • 3.11 MB
  • 354,445 rows
  • 12 columns
Loading... 
CREATE TABLE appomattox_geoid_5102072 (
  "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
);

Aprelevka - Time Series For Statistical Variables

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

Apriltsi - Time Series For Statistical Variables

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

Apros - Time Series For Statistical Variables

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

Apsheronsk - Time Series For Statistical Variables

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

Apsley - Time Series For Statistical Variables

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

Apóstoles - Time Series For Statistical Variables

@datacommons.cities.ap_stoles_wikidataid_q2859097
  • 21.71 kB
  • 1,738 rows
  • 12 columns
Loading... 
CREATE TABLE ap_stoles_wikidataid_q2859097 (
  "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
);

Aptos - Time Series For Statistical Variables

@datacommons.cities.aptos_geoid_0602378
  • 3.18 MB
  • 358,587 rows
  • 12 columns
Loading... 
CREATE TABLE aptos_geoid_0602378 (
  "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
);

Aptos Hills-Larkin Valley - Time Series For Statistical Variables

@datacommons.cities.aptos_hills_larkin_valley_geoid_0602382
  • 2.9 MB
  • 344,916 rows
  • 12 columns
Loading... 
CREATE TABLE aptos_hills_larkin_valley_geoid_0602382 (
  "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
);

Apulco - Time Series For Statistical Variables

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

Aqaba - Time Series For Statistical Variables

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

Aqda - Time Series For Statistical Variables

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

Aqkand - Time Series For Statistical Variables

@datacommons.cities.aqkand_wikidataid_q4359042
  • 21.11 kB
  • 1,710 rows
  • 12 columns
Loading... 
CREATE TABLE aqkand_wikidataid_q4359042 (
  "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
);

Aqqala - Time Series For Statistical Variables

@datacommons.cities.aqqala_wikidataid_q2572706
  • 36.31 kB
  • 4,054 rows
  • 12 columns
Loading... 
CREATE TABLE aqqala_wikidataid_q2572706 (
  "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
);

Aquadale - Time Series For Statistical Variables

@datacommons.cities.aquadale_geoid_3701560
  • 2.76 MB
  • 337,529 rows
  • 12 columns
Loading... 
CREATE TABLE aquadale_geoid_3701560 (
  "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
);

Aquadale - Time Series For Statistical Variables

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

Aquasco - Time Series For Statistical Variables

@datacommons.cities.aquasco_geoid_2401925
  • 2.93 MB
  • 345,551 rows
  • 12 columns
Loading... 
CREATE TABLE aquasco_geoid_2401925 (
  "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
);

Aquebogue - Time Series For Statistical Variables

@datacommons.cities.aquebogue_geoid_3602374
  • 2.91 MB
  • 344,311 rows
  • 12 columns
Loading... 
CREATE TABLE aquebogue_geoid_3602374 (
  "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.