Baselight

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

AƱatuya - Time Series For Statistical Variables

@datacommons.cities.a_atuya_wikidataid_q794668
  • 9.46 kB
  • 1 row
  • 12 columns
Loading...

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

Abadan - Time Series For Statistical Variables

@datacommons.cities.abadan_wikidataid_q63049
  • 45.38 kB
  • 5,607 rows
  • 12 columns
Loading...

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

Abad, Bushehr - Time Series For Statistical Variables

@datacommons.cities.abad_bushehr_wikidataid_q4663189
  • 33.53 kB
  • 4,009 rows
  • 12 columns
Loading...

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

Abadeh Tashk - Time Series For Statistical Variables

@datacommons.cities.abadeh_tashk_wikidataid_q888291
  • 9.59 kB
  • 2 rows
  • 12 columns
Loading...

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

Abadeh - Time Series For Statistical Variables

@datacommons.cities.abadeh_wikidataid_q192928
  • 31.74 kB
  • 3,698 rows
  • 12 columns
Loading...

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

AbaújszÔntó - Time Series For Statistical Variables

@datacommons.cities.aba_jsz_nt_wikidataid_q305749
  • 67.79 kB
  • 7,721 rows
  • 12 columns
Loading...

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

Abakan - Time Series For Statistical Variables

@datacommons.cities.abakan_wikidataid_q875
  • 78.06 kB
  • 10,434 rows
  • 12 columns
Loading...

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

Abali - Time Series For Statistical Variables

@datacommons.cities.abali_wikidataid_q4371496
  • 9.39 kB
  • 1 row
  • 12 columns
Loading...

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

Abancay - Time Series For Statistical Variables

@datacommons.cities.abancay_wikidataid_q215238
  • 9.33 kB
  • 1 row
  • 12 columns
Loading...

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

Abanda - Time Series For Statistical Variables

@datacommons.cities.abanda_geoid_0100100
  • 2.66 MB
  • 329,368 rows
  • 12 columns
Loading...

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

Abanto - Time Series For Statistical Variables

@datacommons.cities.abanto_wikidataid_q24019768
  • 52.14 kB
  • 7,334 rows
  • 12 columns
Loading...

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

Abapura - Time Series For Statistical Variables

@datacommons.cities.abapura_wikidataid_q28182701
  • 24.58 kB
  • 2,521 rows
  • 12 columns
Loading...

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

Abapuszta - Time Series For Statistical Variables

@datacommons.cities.abapuszta_wikidataid_q305528
  • 73.29 kB
  • 10,311 rows
  • 12 columns
Loading...

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

Abarca De Campos - Time Series For Statistical Variables

@datacommons.cities.abarca_de_campos_wikidataid_q62128075
  • 57.77 kB
  • 7,668 rows
  • 12 columns
Loading...

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

Abarkuh - Time Series For Statistical Variables

@datacommons.cities.abarkuh_wikidataid_q919547
  • 9.39 kB
  • 1 row
  • 12 columns
Loading...

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

A Barrela - Time Series For Statistical Variables

@datacommons.cities.a_barrela_wikidataid_q12380018
  • 42.29 kB
  • 5,092 rows
  • 12 columns
Loading...

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

Abartzuza - Time Series For Statistical Variables

@datacommons.cities.abartzuza_wikidataid_q24012528
  • 55.66 kB
  • 6,879 rows
  • 12 columns
Loading...

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

Abasan Al-Kabera - Time Series For Statistical Variables

@datacommons.cities.abasan_al_kabera_wikidataid_q3303148
  • 56.89 kB
  • 8,121 rows
  • 12 columns
Loading...

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

Abasan Al-Saghira - Time Series For Statistical Variables

@datacommons.cities.abasan_al_saghira_wikidataid_q1814855
  • 56.85 kB
  • 8,121 rows
  • 12 columns
Loading...

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

Abasha - Time Series For Statistical Variables

@datacommons.cities.abasha_wikidataid_q1971402
  • 65.43 kB
  • 8,382 rows
  • 12 columns
Loading...

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

Abashiri - Time Series For Statistical Variables

@datacommons.cities.abashiri_wikidataid_q305640
  • 62.59 kB
  • 8,111 rows
  • 12 columns
Loading...

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

Abasolo - Time Series For Statistical Variables

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

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

Abastumani - Time Series For Statistical Variables

@datacommons.cities.abastumani_wikidataid_q305677
  • 49.76 kB
  • 5,940 rows
  • 12 columns
Loading...

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

Aba - Time Series For Statistical Variables

@datacommons.cities.aba_wikidataid_q202162
  • 24.06 kB
  • 2,217 rows
  • 12 columns
Loading...

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

Aba - Time Series For Statistical Variables

@datacommons.cities.aba_wikidataid_q304274
  • 45.74 kB
  • 5,484 rows
  • 12 columns
Loading...

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