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

Aldrich - Time Series For Statistical Variables

@datacommons.cities.aldrich_geoid_2700892
  • 2.67 MB
  • 334,915 rows
  • 12 columns
Loading... 

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

Aldrich - Time Series For Statistical Variables

@datacommons.cities.aldrich_geoid_2900568
  • 1.36 MB
  • 186,393 rows
  • 12 columns
Loading... 

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

Aldrich Township - Time Series For Statistical Variables

@datacommons.cities.aldrich_township_geoid_2700910
  • 72.76 kB
  • 11,849 rows
  • 12 columns
Loading... 

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

Aldridge - Time Series For Statistical Variables

@datacommons.cities.aldridge_wikidataid_q1807596
  • 63.18 kB
  • 7,902 rows
  • 12 columns
Loading... 

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

Alectown - Time Series For Statistical Variables

@datacommons.cities.alectown_wikidataid_q4714312
  • 56.53 kB
  • 7,188 rows
  • 12 columns
Loading... 

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

Aledo - Time Series For Statistical Variables

@datacommons.cities.aledo_geoid_1700646
  • 3.13 MB
  • 355,305 rows
  • 12 columns
Loading... 

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

Aledo - Time Series For Statistical Variables

@datacommons.cities.aledo_geoid_4801744
  • 3.12 MB
  • 356,437 rows
  • 12 columns
Loading... 

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

Aleșd - Time Series For Statistical Variables

@datacommons.cities.ale_d_wikidataid_q851029
  • 56.78 kB
  • 6,539 rows
  • 12 columns
Loading... 

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

Aleknagik - Time Series For Statistical Variables

@datacommons.cities.aleknagik_geoid_0201420
  • 1.35 MB
  • 182,619 rows
  • 12 columns
Loading... 

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

Aleksandrów Łódzki - Time Series For Statistical Variables

@datacommons.cities.aleksandr_w_dzki_wikidataid_q664371
  • 57.7 kB
  • 7,716 rows
  • 12 columns
Loading... 

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

Aleksandrów Kujawski - Time Series For Statistical Variables

@datacommons.cities.aleksandr_w_kujawski_wikidataid_q325124
  • 57.45 kB
  • 7,674 rows
  • 12 columns
Loading... 

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

Aleneva - Time Series For Statistical Variables

@datacommons.cities.aleneva_geoid_0201560
  • 1.19 MB
  • 170,329 rows
  • 12 columns
Loading... 

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

Alenquer - Time Series For Statistical Variables

@datacommons.cities.alenquer_undata_geo_c20700012
  • 9.28 kB
  • 3 rows
  • 12 columns
Loading... 

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

Alenquer - Time Series For Statistical Variables

@datacommons.cities.alenquer_wikidataid_q31878333
  • 58.71 kB
  • 7,894 rows
  • 12 columns
Loading... 

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

Alenquer - Time Series For Statistical Variables

@datacommons.cities.alenquer_wikidataid_q988830
  • 60.25 kB
  • 8,115 rows
  • 12 columns
Loading... 

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

Aleppo Township - Time Series For Statistical Variables

@datacommons.cities.aleppo_township_wikidataid_q1751202
  • 104.98 kB
  • 15,706 rows
  • 12 columns
Loading... 

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

Aleppo Township - Time Series For Statistical Variables

@datacommons.cities.aleppo_township_wikidataid_q2919555
  • 89.03 kB
  • 14,397 rows
  • 12 columns
Loading... 

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

Aleppo - Time Series For Statistical Variables

@datacommons.cities.aleppo_wikidataid_q41183
  • 45.66 kB
  • 5,718 rows
  • 12 columns
Loading... 

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

Alera - Time Series For Statistical Variables

@datacommons.cities.alera_wikidataid_q8194499
  • 26.35 kB
  • 2,909 rows
  • 12 columns
Loading... 

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

Alerce - Time Series For Statistical Variables

@datacommons.cities.alerce_wikidataid_q4716204
  • 49.95 kB
  • 5,844 rows
  • 12 columns
Loading... 

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

Alert Bay - Time Series For Statistical Variables

@datacommons.cities.alert_bay_wikidataid_q1649005
  • 9.56 kB
  • 1 row
  • 12 columns
Loading... 

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

Aleshtar - Time Series For Statistical Variables

@datacommons.cities.aleshtar_wikidataid_q967701
  • 35.08 kB
  • 4,014 rows
  • 12 columns
Loading... 

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

Alexander Bay, Northern Cape - Time Series For Statistical Variables

@datacommons.cities.alexander_bay_northern_cape_wikidataid_q1856529
  • 34.99 kB
  • 4,187 rows
  • 12 columns
Loading... 

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

Alexander-Belle Prairie Township - Time Series For Statistical Variables

@datacommons.cities.alexander_belle_prairie_township_geoid_2001087
  • 81.29 kB
  • 13,308 rows
  • 12 columns
Loading... 

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

Alexander City - Time Series For Statistical Variables

@datacommons.cities.alexander_city_geoid_0101132
  • 3.25 MB
  • 354,787 rows
  • 12 columns
Loading... 

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