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

Alang - Time Series For Statistical Variables

@datacommons.cities.alang_wikidataid_q587137
  • 29.51 kB
  • 3,321 rows
  • 12 columns
Loading... 

CREATE TABLE alang_wikidataid_q587137 (
  "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
);

Alan Manor - Time Series For Statistical Variables

@datacommons.cities.alan_manor_wikidataid_q4707236
  • 58.08 kB
  • 7,059 rows
  • 12 columns
Loading... 

CREATE TABLE alan_manor_wikidataid_q4707236 (
  "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
);

Alanreed - Time Series For Statistical Variables

@datacommons.cities.alanreed_geoid_4801612
  • 910.61 kB
  • 60,782 rows
  • 12 columns
Loading... 

CREATE TABLE alanreed_geoid_4801612 (
  "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
);

Alanson - Time Series For Statistical Variables

@datacommons.cities.alanson_geoid_2600860
  • 3.01 MB
  • 352,799 rows
  • 12 columns
Loading... 

CREATE TABLE alanson_geoid_2600860 (
  "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
);

Alanta - Time Series For Statistical Variables

@datacommons.cities.alanta_wikidataid_q4708295
  • 50.65 kB
  • 6,016 rows
  • 12 columns
Loading... 

CREATE TABLE alanta_wikidataid_q4708295 (
  "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
);

Alanya - Time Series For Statistical Variables

@datacommons.cities.alanya_wikidataid_q171810
  • 24.55 kB
  • 2,198 rows
  • 12 columns
Loading... 

CREATE TABLE alanya_wikidataid_q171810 (
  "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
);

Alapaha - Time Series For Statistical Variables

@datacommons.cities.alapaha_geoid_1301024
  • 2.89 MB
  • 343,731 rows
  • 12 columns
Loading... 

CREATE TABLE alapaha_geoid_1301024 (
  "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
);

Alapayevsk - Time Series For Statistical Variables

@datacommons.cities.alapayevsk_wikidataid_q103212
  • 26.11 kB
  • 2,361 rows
  • 12 columns
Loading... 

CREATE TABLE alapayevsk_wikidataid_q103212 (
  "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
);

Alaquines - Time Series For Statistical Variables

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

CREATE TABLE alaquines_undata_geo_c16801660 (
  "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
);

Alarba - Time Series For Statistical Variables

@datacommons.cities.alarba_wikidataid_q24016516
  • 51.84 kB
  • 7,334 rows
  • 12 columns
Loading... 

CREATE TABLE alarba_wikidataid_q24016516 (
  "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ßlar - Time Series For Statistical Variables

@datacommons.cities.a_lar_wikidataid_q558494
  • 65.28 kB
  • 8,354 rows
  • 12 columns
Loading... 

CREATE TABLE a_lar_wikidataid_q558494 (
  "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
);

Alashankou - Time Series For Statistical Variables

@datacommons.cities.alashankou_wikidataid_q5247247
  • 34.17 kB
  • 3,856 rows
  • 12 columns
Loading... 

CREATE TABLE alashankou_wikidataid_q5247247 (
  "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
);

Alasht - Time Series For Statistical Variables

@datacommons.cities.alasht_wikidataid_q336079
  • 29.74 kB
  • 3,035 rows
  • 12 columns
Loading... 

CREATE TABLE alasht_wikidataid_q336079 (
  "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
);

Alaska Township - Time Series For Statistical Variables

@datacommons.cities.alaska_township_geoid_2700586
  • 81.44 kB
  • 12,737 rows
  • 12 columns
Loading... 

CREATE TABLE alaska_township_geoid_2700586 (
  "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
);

Alatau - Time Series For Statistical Variables

@datacommons.cities.alatau_wikidataid_q3404617
  • 78.68 kB
  • 10,576 rows
  • 12 columns
Loading... 

CREATE TABLE alatau_wikidataid_q3404617 (
  "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
);

Alatna - Time Series For Statistical Variables

@datacommons.cities.alatna_geoid_0201305
  • 1.11 MB
  • 163,515 rows
  • 12 columns
Loading... 

CREATE TABLE alatna_geoid_0201305 (
  "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
);

Alatornio - Time Series For Statistical Variables

@datacommons.cities.alatornio_wikidataid_q830009
  • 84.49 kB
  • 11,221 rows
  • 12 columns
Loading... 

CREATE TABLE alatornio_wikidataid_q830009 (
  "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
);

Alatyr - Time Series For Statistical Variables

@datacommons.cities.alatyr_wikidataid_q103255
  • 84.45 kB
  • 11,530 rows
  • 12 columns
Loading... 

CREATE TABLE alatyr_wikidataid_q103255 (
  "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
);

Al-Auja - Time Series For Statistical Variables

@datacommons.cities.al_auja_wikidataid_q2895271
  • 63.5 kB
  • 8,528 rows
  • 12 columns
Loading... 

CREATE TABLE al_auja_wikidataid_q2895271 (
  "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
);

Alaverdi - Time Series For Statistical Variables

@datacommons.cities.alaverdi_wikidataid_q39545
  • 46.96 kB
  • 5,530 rows
  • 12 columns
Loading... 

CREATE TABLE alaverdi_wikidataid_q39545 (
  "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
);

Alavicheh - Time Series For Statistical Variables

@datacommons.cities.alavicheh_wikidataid_q2613921
  • 9.43 kB
  • 1 row
  • 12 columns
Loading... 

CREATE TABLE alavicheh_wikidataid_q2613921 (
  "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
);

Alavus - Time Series For Statistical Variables

@datacommons.cities.alavus_wikidataid_q5981
  • 55.57 kB
  • 6,712 rows
  • 12 columns
Loading... 

CREATE TABLE alavus_wikidataid_q5981 (
  "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
);

Al-Ḥawiyah - Time Series For Statistical Variables

@datacommons.cities.al_awiyah_undata_geo_c22700003
  • 9.29 kB
  • 1 row
  • 12 columns
Loading... 

CREATE TABLE al_awiyah_undata_geo_c22700003 (
  "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
);

Alawoona - Time Series For Statistical Variables

@datacommons.cities.alawoona_wikidataid_q4708901
  • 52.09 kB
  • 6,569 rows
  • 12 columns
Loading... 

CREATE TABLE alawoona_wikidataid_q4708901 (
  "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
);

Al-Bab - Time Series For Statistical Variables

@datacommons.cities.al_bab_wikidataid_q310892
  • 46.62 kB
  • 5,715 rows
  • 12 columns
Loading... 

CREATE TABLE al_bab_wikidataid_q310892 (
  "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.