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

Andrews - Time Series For Statistical Variables

@datacommons.cities.andrews_geoid_1801612
  • 1.54 MB
  • 192,071 rows
  • 12 columns
Loading... 
CREATE TABLE andrews_geoid_1801612 (
  "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
);

Andrews - Time Series For Statistical Variables

@datacommons.cities.andrews_geoid_3701380
  • 3.05 MB
  • 351,723 rows
  • 12 columns
Loading... 
CREATE TABLE andrews_geoid_3701380 (
  "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
);

Andrews - Time Series For Statistical Variables

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

Andrews - Time Series For Statistical Variables

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

Andrews Township - Time Series For Statistical Variables

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

Andrew - Time Series For Statistical Variables

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

Andria - Time Series For Statistical Variables

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

Andrijevica - Time Series For Statistical Variables

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

Andros - Time Series For Statistical Variables

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

Andrup - Time Series For Statistical Variables

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

Andrushivka - Time Series For Statistical Variables

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

Andrychów - Time Series For Statistical Variables

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

Andsumäe - Time Series For Statistical Variables

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

Anduhjerd - Time Series For Statistical Variables

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

Anegam - Time Series For Statistical Variables

@datacommons.cities.anegam_geoid_0402270
  • 2.57 MB
  • 323,741 rows
  • 12 columns
Loading... 
CREATE TABLE anegam_geoid_0402270 (
  "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ïn El Aouda - Time Series For Statistical Variables

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

Anenii Noi - Time Series For Statistical Variables

@datacommons.cities.anenii_noi_wikidataid_q529282
  • 74.45 kB
  • 9,703 rows
  • 12 columns
Loading... 
CREATE TABLE anenii_noi_wikidataid_q529282 (
  "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
);

Anento - Time Series For Statistical Variables

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

Anerley, KwaZulu-Natal - Time Series For Statistical Variables

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

Aneta - Time Series For Statistical Variables

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

Aneth - Time Series For Statistical Variables

@datacommons.cities.aneth_geoid_4901530
  • 2.78 MB
  • 338,818 rows
  • 12 columns
Loading... 
CREATE TABLE aneth_geoid_4901530 (
  "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
);

Angadipuram Laterite - Time Series For Statistical Variables

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

Angamacutiro - Time Series For Statistical Variables

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

Angamaly - Time Series For Statistical Variables

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

Angarsk - Time Series For Statistical Variables

@datacommons.cities.angarsk_wikidataid_q103565
  • 92.01 kB
  • 11,787 rows
  • 12 columns
Loading... 
CREATE TABLE angarsk_wikidataid_q103565 (
  "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.