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

Arcola - Time Series For Statistical Variables

@datacommons.cities.arcola_geoid_2801820
  • 2.81 MB
  • 341,177 rows
  • 12 columns
Loading... 
CREATE TABLE arcola_geoid_2801820 (
  "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
);

Arcola - Time Series For Statistical Variables

@datacommons.cities.arcola_geoid_2901720
  • 2.71 MB
  • 334,236 rows
  • 12 columns
Loading... 
CREATE TABLE arcola_geoid_2901720 (
  "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
);

Arcola - Time Series For Statistical Variables

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

Arcola - Time Series For Statistical Variables

@datacommons.cities.arcola_geoid_5102248
  • 2.91 MB
  • 341,050 rows
  • 12 columns
Loading... 
CREATE TABLE arcola_geoid_5102248 (
  "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
);

Arcola Township - Time Series For Statistical Variables

@datacommons.cities.arcola_township_geoid_1701894
  • 84.92 kB
  • 13,865 rows
  • 12 columns
Loading... 
CREATE TABLE arcola_township_geoid_1701894 (
  "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
);

Arcola - Time Series For Statistical Variables

@datacommons.cities.arcola_wikidataid_q512828
  • 102.98 kB
  • 16,006 rows
  • 12 columns
Loading... 
CREATE TABLE arcola_wikidataid_q512828 (
  "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
);

Arcola - Time Series For Statistical Variables

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

Arcola - Time Series For Statistical Variables

@datacommons.cities.arcola_wikidataid_q581328
  • 85.15 kB
  • 13,835 rows
  • 12 columns
Loading... 
CREATE TABLE arcola_wikidataid_q581328 (
  "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
);

Arco-Íris - Time Series For Statistical Variables

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

Arcosanti - Time Series For Statistical Variables

@datacommons.cities.arcosanti_geoid_0403140
  • 92.59 kB
  • 14,791 rows
  • 12 columns
Loading... 
CREATE TABLE arcosanti_geoid_0403140 (
  "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
);

Arcos De La Frontera - Time Series For Statistical Variables

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

Arcos De Valdevez (town) - Time Series For Statistical Variables

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

Arcos De Valdevez - Time Series For Statistical Variables

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

Arcos De Valdevez - Time Series For Statistical Variables

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

Arcot - Time Series For Statistical Variables

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

Arcozelo - Time Series For Statistical Variables

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

Arcozelo - Time Series For Statistical Variables

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

Arctander Township - Time Series For Statistical Variables

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

Arctic Village - Time Series For Statistical Variables

@datacommons.cities.arctic_village_geoid_0203990
  • 1.24 MB
  • 173,754 rows
  • 12 columns
Loading... 
CREATE TABLE arctic_village_geoid_0203990 (
  "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
);

Ardabil - Time Series For Statistical Variables

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

Ardakan - Time Series For Statistical Variables

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

Ardakan - Time Series For Statistical Variables

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

Ardak - Time Series For Statistical Variables

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

Ardal - Time Series For Statistical Variables

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

Ardanuç - Time Series For Statistical Variables

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