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

Ahmadabad-e Mostowfi - Time Series For Statistical Variables

@datacommons.cities.ahmadabad_e_mostowfi_wikidataid_q5666673
  • 42.78 kB
  • 5,303 rows
  • 12 columns
Loading... 

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

Ahmadabad-e Sowlat - Time Series For Statistical Variables

@datacommons.cities.ahmadabad_e_sowlat_wikidataid_q4695617
  • 9.55 kB
  • 1 row
  • 12 columns
Loading... 

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

Ahmadabad - Time Series For Statistical Variables

@datacommons.cities.ahmadabad_wikidataid_q3606974
  • 9.4 kB
  • 1 row
  • 12 columns
Loading... 

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

Ahmad Pur Lamma - Time Series For Statistical Variables

@datacommons.cities.ahmad_pur_lamma_wikidataid_q4695970
  • 10.1 kB
  • 56 rows
  • 12 columns
Loading... 

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

Ahmadsargurab - Time Series For Statistical Variables

@datacommons.cities.ahmadsargurab_wikidataid_q4358679
  • 42.8 kB
  • 4,826 rows
  • 12 columns
Loading... 

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

Ahmedabad - Time Series For Statistical Variables

@datacommons.cities.ahmedabad_wikidataid_q1070
  • 57.74 kB
  • 7,658 rows
  • 12 columns
Loading... 

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

Ahmedabad - Time Series For Statistical Variables

@datacommons.cities.ahmedabad_wikidataid_q760153
  • 24.18 kB
  • 2,520 rows
  • 12 columns
Loading... 

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

Ahmeek - Time Series For Statistical Variables

@datacommons.cities.ahmeek_geoid_2600620
  • 1.36 MB
  • 185,492 rows
  • 12 columns
Loading... 

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

Ahnapee - Time Series For Statistical Variables

@datacommons.cities.ahnapee_geoid_5500600
  • 81.31 kB
  • 13,321 rows
  • 12 columns
Loading... 

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

Ahoskie - Time Series For Statistical Variables

@datacommons.cities.ahoskie_geoid_3700500
  • 3.21 MB
  • 356,901 rows
  • 12 columns
Loading... 

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

Ahram - Time Series For Statistical Variables

@datacommons.cities.ahram_wikidataid_q968057
  • 36.48 kB
  • 4,009 rows
  • 12 columns
Loading... 

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

Ahrensburg - Time Series For Statistical Variables

@datacommons.cities.ahrensburg_wikidataid_q16104
  • 83.8 kB
  • 11,242 rows
  • 12 columns
Loading... 

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

Ahtahkakoop 104 - Time Series For Statistical Variables

@datacommons.cities.ahtahkakoop_104_wikidataid_q4696379
  • 9.41 kB
  • 1 row
  • 12 columns
Loading... 

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

Ahtanum - Time Series For Statistical Variables

@datacommons.cities.ahtanum_geoid_5300800
  • 3.07 MB
  • 351,524 rows
  • 12 columns
Loading... 

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

Ahthibung - Time Series For Statistical Variables

@datacommons.cities.ahthibung_wikidataid_q24908961
  • 23.16 kB
  • 2,089 rows
  • 12 columns
Loading... 

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

Ahtopol - Time Series For Statistical Variables

@datacommons.cities.ahtopol_wikidataid_q341027
  • 28.63 kB
  • 2,838 rows
  • 12 columns
Loading... 

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

Ahuacatlán - Time Series For Statistical Variables

@datacommons.cities.ahuacatl_n_undata_geo_c16800925
  • 9.24 kB
  • 1 row
  • 12 columns
Loading... 

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

Ahuacatlán - Time Series For Statistical Variables

@datacommons.cities.ahuacatl_n_wikidataid_q4072347
  • 36.68 kB
  • 5,335 rows
  • 12 columns
Loading... 

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

Ahuachapán - Time Series For Statistical Variables

@datacommons.cities.ahuachap_n_wikidataid_q186935
  • 32.83 kB
  • 3,682 rows
  • 12 columns
Loading... 

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

Ahuacuotzingo - Time Series For Statistical Variables

@datacommons.cities.ahuacuotzingo_undata_geo_c16800321
  • 9.25 kB
  • 1 row
  • 12 columns
Loading... 

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

Ahuimanu - Time Series For Statistical Variables

@datacommons.cities.ahuimanu_geoid_1500400
  • 1.67 MB
  • 194,505 rows
  • 12 columns
Loading... 

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

Ahumada - Time Series For Statistical Variables

@datacommons.cities.ahumada_undata_geo_c16800035
  • 9.21 kB
  • 1 row
  • 12 columns
Loading... 

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

Ahvaz - Time Series For Statistical Variables

@datacommons.cities.ahvaz_wikidataid_q170366
  • 33.72 kB
  • 3,585 rows
  • 12 columns
Loading... 

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

Ahwahnee - Time Series For Statistical Variables

@datacommons.cities.ahwahnee_geoid_0600478
  • 2.9 MB
  • 341,746 rows
  • 12 columns
Loading... 

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

Ahwa - Time Series For Statistical Variables

@datacommons.cities.ahwa_wikidataid_q1964214
  • 24.68 kB
  • 2,521 rows
  • 12 columns
Loading... 

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