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

Alpuri - Time Series For Statistical Variables

@datacommons.cities.alpuri_wikidataid_q3305883
  • 22.26 kB
  • 1,821 rows
  • 12 columns
Loading... 
CREATE TABLE alpuri_wikidataid_q3305883 (
  "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
);

Alpurrurulam - Time Series For Statistical Variables

@datacommons.cities.alpurrurulam_wikidataid_q17904
  • 29.14 kB
  • 3,684 rows
  • 12 columns
Loading... 
CREATE TABLE alpurrurulam_wikidataid_q17904 (
  "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 Qadarif - Time Series For Statistical Variables

@datacommons.cities.al_qadarif_wikidataid_q311199
  • 31.31 kB
  • 3,763 rows
  • 12 columns
Loading... 
CREATE TABLE al_qadarif_wikidataid_q311199 (
  "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 Qa`idah - Time Series For Statistical Variables

@datacommons.cities.al_qa_idah_wikidataid_q9143904
  • 23.52 kB
  • 2,377 rows
  • 12 columns
Loading... 
CREATE TABLE al_qa_idah_wikidataid_q9143904 (
  "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-Qarara - Time Series For Statistical Variables

@datacommons.cities.al_qarara_wikidataid_q1814845
  • 56.57 kB
  • 8,121 rows
  • 12 columns
Loading... 
CREATE TABLE al_qarara_wikidataid_q1814845 (
  "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-Qaryatayn - Time Series For Statistical Variables

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

Alqosh - Time Series For Statistical Variables

@datacommons.cities.alqosh_wikidataid_q1150394
  • 36.49 kB
  • 4,256 rows
  • 12 columns
Loading... 
CREATE TABLE alqosh_wikidataid_q1150394 (
  "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-Quds (Jerusalem) - Time Series For Statistical Variables

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

Alquerías - Time Series For Statistical Variables

@datacommons.cities.alquer_as_wikidataid_q2884053
  • 52.16 kB
  • 6,903 rows
  • 12 columns
Loading... 
CREATE TABLE alquer_as_wikidataid_q2884053 (
  "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 Qunfudhah - Time Series For Statistical Variables

@datacommons.cities.al_qunfudhah_wikidataid_q3495996
  • 11.63 kB
  • 318 rows
  • 12 columns
Loading... 
CREATE TABLE al_qunfudhah_wikidataid_q3495996 (
  "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 Qurayn, Egypt - Time Series For Statistical Variables

@datacommons.cities.al_qurayn_egypt_wikidataid_q13634887
  • 38.48 kB
  • 5,176 rows
  • 12 columns
Loading... 
CREATE TABLE al_qurayn_egypt_wikidataid_q13634887 (
  "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-Qusayr - Time Series For Statistical Variables

@datacommons.cities.al_qusayr_wikidataid_q195410
  • 16.01 kB
  • 1,226 rows
  • 12 columns
Loading... 
CREATE TABLE al_qusayr_wikidataid_q195410 (
  "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-Qusayr - Time Series For Statistical Variables

@datacommons.cities.al_qusayr_wikidataid_q310751
  • 35.8 kB
  • 5,166 rows
  • 12 columns
Loading... 
CREATE TABLE al_qusayr_wikidataid_q310751 (
  "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 Quwaysimah - Time Series For Statistical Variables

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

Alquézar - Time Series For Statistical Variables

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

Alquízar - Time Series For Statistical Variables

@datacommons.cities.alqu_zar_wikidataid_q603163
  • 46.38 kB
  • 5,581 rows
  • 12 columns
Loading... 
CREATE TABLE alqu_zar_wikidataid_q603163 (
  "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-Ram - Time Series For Statistical Variables

@datacommons.cities.al_ram_wikidataid_q775087
  • 64.66 kB
  • 8,657 rows
  • 12 columns
Loading... 
CREATE TABLE al_ram_wikidataid_q775087 (
  "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-Rastan - Time Series For Statistical Variables

@datacommons.cities.al_rastan_wikidataid_q1867822
  • 46.94 kB
  • 6,182 rows
  • 12 columns
Loading... 
CREATE TABLE al_rastan_wikidataid_q1867822 (
  "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-Rumaitha - Time Series For Statistical Variables

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

Alsace Manor - Time Series For Statistical Variables

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

Alsace Manor - Time Series For Statistical Variables

@datacommons.cities.alsace_manor_wikidataid_q4735747
  • 96.33 kB
  • 15,222 rows
  • 12 columns
Loading... 
CREATE TABLE alsace_manor_wikidataid_q4735747 (
  "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
);

Alsace Township - Time Series For Statistical Variables

@datacommons.cities.alsace_township_wikidataid_q1893508
  • 95.78 kB
  • 15,252 rows
  • 12 columns
Loading... 
CREATE TABLE alsace_township_wikidataid_q1893508 (
  "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-Sadiyah - Time Series For Statistical Variables

@datacommons.cities.al_sadiyah_wikidataid_q12198999
  • 28.18 kB
  • 3,051 rows
  • 12 columns
Loading... 
CREATE TABLE al_sadiyah_wikidataid_q12198999 (
  "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-Safira - Time Series For Statistical Variables

@datacommons.cities.al_safira_wikidataid_q575774
  • 45.67 kB
  • 5,713 rows
  • 12 columns
Loading... 
CREATE TABLE al_safira_wikidataid_q575774 (
  "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 Safi - Time Series For Statistical Variables

@datacommons.cities.al_safi_wikidataid_q27125336
  • 31.98 kB
  • 3,703 rows
  • 12 columns
Loading... 
CREATE TABLE al_safi_wikidataid_q27125336 (
  "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.