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

Alizava - Time Series For Statistical Variables

@datacommons.cities.alizava_wikidataid_q2220618
  • 46.69 kB
  • 5,666 rows
  • 12 columns
Loading... 
CREATE TABLE alizava_wikidataid_q2220618 (
  "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 Jawf - Time Series For Statistical Variables

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

Aljezur - Time Series For Statistical Variables

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

Aljezur - Time Series For Statistical Variables

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

Aljubarrota - Time Series For Statistical Variables

@datacommons.cities.aljubarrota_wikidataid_q2623372
  • 39.75 kB
  • 4,671 rows
  • 12 columns
Loading... 
CREATE TABLE aljubarrota_wikidataid_q2623372 (
  "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 Jubayhah - Time Series For Statistical Variables

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

Aljustrel - Time Series For Statistical Variables

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

Aljustrel - Time Series For Statistical Variables

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

Aljustrel - Time Series For Statistical Variables

@datacommons.cities.aljustrel_wikidataid_q939511
  • 50.48 kB
  • 6,456 rows
  • 12 columns
Loading... 
CREATE TABLE aljustrel_wikidataid_q939511 (
  "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 Karak - Time Series For Statistical Variables

@datacommons.cities.al_karak_wikidataid_q31572
  • 32.34 kB
  • 3,704 rows
  • 12 columns
Loading... 
CREATE TABLE al_karak_wikidataid_q31572 (
  "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-Karmah - Time Series For Statistical Variables

@datacommons.cities.al_karmah_wikidataid_q4702665
  • 34.01 kB
  • 4,057 rows
  • 12 columns
Loading... 
CREATE TABLE al_karmah_wikidataid_q4702665 (
  "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 Kawa - Time Series For Statistical Variables

@datacommons.cities.al_kawa_wikidataid_q31873641
  • 21.02 kB
  • 2,031 rows
  • 12 columns
Loading... 
CREATE TABLE al_kawa_wikidataid_q31873641 (
  "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-Khader - Time Series For Statistical Variables

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

@datacommons.cities.al_khadraniyah_wikidataid_q28220248
  • 16.44 kB
  • 1,022 rows
  • 12 columns
Loading... 
CREATE TABLE al_khadraniyah_wikidataid_q28220248 (
  "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-Khalidiya - Time Series For Statistical Variables

@datacommons.cities.al_khalidiya_wikidataid_q4119728
  • 26.6 kB
  • 2,793 rows
  • 12 columns
Loading... 
CREATE TABLE al_khalidiya_wikidataid_q4119728 (
  "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 Kharaitiyat - Time Series For Statistical Variables

@datacommons.cities.al_kharaitiyat_wikidataid_q22948417
  • 39.7 kB
  • 4,894 rows
  • 12 columns
Loading... 
CREATE TABLE al_kharaitiyat_wikidataid_q22948417 (
  "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-Kishkiyah - Time Series For Statistical Variables

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

Al-Kiswah - Time Series For Statistical Variables

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

Alkmaar, Mpumalanga - Time Series For Statistical Variables

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

Alkmaar - Time Series For Statistical Variables

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

Alkmaar - Time Series For Statistical Variables

@datacommons.cities.alkmaar_wikidataid_q1757278
  • 42.91 kB
  • 5,244 rows
  • 12 columns
Loading... 
CREATE TABLE alkmaar_wikidataid_q1757278 (
  "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ūksne - Time Series For Statistical Variables

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

Allagash - Time Series For Statistical Variables

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

Allahabad - Time Series For Statistical Variables

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

Allakaket - Time Series For Statistical Variables

@datacommons.cities.allakaket_geoid_0201860
  • 1.27 MB
  • 176,310 rows
  • 12 columns
Loading... 
CREATE TABLE allakaket_geoid_0201860 (
  "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.