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

Airway Heights - Time Series For Statistical Variables

@datacommons.cities.airway_heights_geoid_5300905
  • 3.26 MB
  • 359,711 rows
  • 12 columns
Loading... 

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

Aisai - Time Series For Statistical Variables

@datacommons.cities.aisai_wikidataid_q269644
  • 66.26 kB
  • 8,509 rows
  • 12 columns
Loading... 

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

Aishō - Time Series For Statistical Variables

@datacommons.cities.aish_wikidataid_q1346806
  • 60.14 kB
  • 7,584 rows
  • 12 columns
Loading... 

CREATE TABLE aish_wikidataid_q1346806 (
  "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ñisoc - Time Series For Statistical Variables

@datacommons.cities.a_isoc_wikidataid_q2720938
  • 9.52 kB
  • 2 rows
  • 12 columns
Loading... 

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

Ait Aatab - Time Series For Statistical Variables

@datacommons.cities.ait_aatab_wikidataid_q87063191
  • 39.91 kB
  • 4,834 rows
  • 12 columns
Loading... 

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

Aitape - Time Series For Statistical Variables

@datacommons.cities.aitape_wikidataid_q1771821
  • 10.73 kB
  • 136 rows
  • 12 columns
Loading... 

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

Ait Bouada - Time Series For Statistical Variables

@datacommons.cities.ait_bouada_wikidataid_q2876453
  • 38.33 kB
  • 4,674 rows
  • 12 columns
Loading... 

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

Aitkin - Time Series For Statistical Variables

@datacommons.cities.aitkin_geoid_2700460
  • 3.06 MB
  • 354,102 rows
  • 12 columns
Loading... 

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

Aitkin Township - Time Series For Statistical Variables

@datacommons.cities.aitkin_township_geoid_2700478
  • 84.03 kB
  • 13,530 rows
  • 12 columns
Loading... 

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

Ait Melloul - Time Series For Statistical Variables

@datacommons.cities.ait_melloul_wikidataid_q2384142
  • 44.32 kB
  • 5,833 rows
  • 12 columns
Loading... 

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

Aitoliko - Time Series For Statistical Variables

@datacommons.cities.aitoliko_wikidataid_q1371634
  • 34.11 kB
  • 4,358 rows
  • 12 columns
Loading... 

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

Ai - Time Series For Statistical Variables

@datacommons.cities.ai_wikidataid_q403166
  • 65.9 kB
  • 8,757 rows
  • 12 columns
Loading... 

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

Aix-en-Provence - Time Series For Statistical Variables

@datacommons.cities.aix_en_provence_wikidataid_q47465
  • 73.21 kB
  • 9,998 rows
  • 12 columns
Loading... 

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

Aizkraukle - Time Series For Statistical Variables

@datacommons.cities.aizkraukle_wikidataid_q411715
  • 36.03 kB
  • 3,828 rows
  • 12 columns
Loading... 

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

Aizpún - Time Series For Statistical Variables

@datacommons.cities.aizp_n_wikidataid_q8192416
  • 54.97 kB
  • 6,336 rows
  • 12 columns
Loading... 

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

Aizpute - Time Series For Statistical Variables

@datacommons.cities.aizpute_wikidataid_q411723
  • 78.45 kB
  • 10,744 rows
  • 12 columns
Loading... 

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

Aizubange - Time Series For Statistical Variables

@datacommons.cities.aizubange_wikidataid_q1204988
  • 56.42 kB
  • 7,030 rows
  • 12 columns
Loading... 

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

Aizumisato - Time Series For Statistical Variables

@datacommons.cities.aizumisato_wikidataid_q1205357
  • 57.9 kB
  • 7,162 rows
  • 12 columns
Loading... 

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

Aizumi - Time Series For Statistical Variables

@datacommons.cities.aizumi_wikidataid_q1206365
  • 59.89 kB
  • 7,432 rows
  • 12 columns
Loading... 

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

Aizuwakamatsu - Time Series For Statistical Variables

@datacommons.cities.aizuwakamatsu_wikidataid_q237699
  • 60.78 kB
  • 7,240 rows
  • 12 columns
Loading... 

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

Ajab Shir - Time Series For Statistical Variables

@datacommons.cities.ajab_shir_wikidataid_q2718461
  • 30.99 kB
  • 3,436 rows
  • 12 columns
Loading... 

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

Ajak - Time Series For Statistical Variables

@datacommons.cities.ajak_wikidataid_q554250
  • 51.72 kB
  • 6,155 rows
  • 12 columns
Loading... 

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

Ajana - Time Series For Statistical Variables

@datacommons.cities.ajana_wikidataid_q4699538
  • 40.98 kB
  • 4,649 rows
  • 12 columns
Loading... 

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

Ajax - Time Series For Statistical Variables

@datacommons.cities.ajax_wikidataid_q386567
  • 105.64 kB
  • 14,425 rows
  • 12 columns
Loading... 

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

Ajdir - Time Series For Statistical Variables

@datacommons.cities.ajdir_wikidataid_q412703
  • 42.19 kB
  • 5,242 rows
  • 12 columns
Loading... 

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