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

Abersychan - Time Series For Statistical Variables

@datacommons.cities.abersychan_wikidataid_q3304459
  • 47.91 kB
  • 5,823 rows
  • 12 columns
Loading... 

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

Abertamy - Time Series For Statistical Variables

@datacommons.cities.abertamy_wikidataid_q319731
  • 86.25 kB
  • 12,064 rows
  • 12 columns
Loading... 

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

Abertillery - Time Series For Statistical Variables

@datacommons.cities.abertillery_wikidataid_q2272537
  • 50.6 kB
  • 5,823 rows
  • 12 columns
Loading... 

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

Aberystwyth - Time Series For Statistical Variables

@datacommons.cities.aberystwyth_wikidataid_q213154
  • 51.62 kB
  • 6,494 rows
  • 12 columns
Loading... 

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

Abeytas - Time Series For Statistical Variables

@datacommons.cities.abeytas_geoid_3500240
  • 2.63 MB
  • 327,771 rows
  • 12 columns
Loading... 

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

Abezhdan, Andika - Time Series For Statistical Variables

@datacommons.cities.abezhdan_andika_wikidataid_q4667264
  • 29.55 kB
  • 3,137 rows
  • 12 columns
Loading... 

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

Abgarm - Time Series For Statistical Variables

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

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

Abhar - Time Series For Statistical Variables

@datacommons.cities.abhar_wikidataid_q643359
  • 9.37 kB
  • 1 row
  • 12 columns
Loading... 

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

Abha - Time Series For Statistical Variables

@datacommons.cities.abha_wikidataid_q190948
  • 30.4 kB
  • 3,519 rows
  • 12 columns
Loading... 

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

Abia De Las Torres - Time Series For Statistical Variables

@datacommons.cities.abia_de_las_torres_wikidataid_q24012249
  • 23.29 kB
  • 2,337 rows
  • 12 columns
Loading... 

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

Abiar - Time Series For Statistical Variables

@datacommons.cities.abiar_wikidataid_q8184000
  • 16.57 kB
  • 931 rows
  • 12 columns
Loading... 

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

Abi Beyglu - Time Series For Statistical Variables

@datacommons.cities.abi_beyglu_wikidataid_q4115196
  • 61.5 kB
  • 7,571 rows
  • 12 columns
Loading... 

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

Abidjan - Time Series For Statistical Variables

@datacommons.cities.abidjan_wikidataid_q1515
  • 52.26 kB
  • 6,679 rows
  • 12 columns
Loading... 

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

Abie - Time Series For Statistical Variables

@datacommons.cities.abie_geoid_3100205
  • 1.32 MB
  • 183,475 rows
  • 12 columns
Loading... 

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

Abiego - Time Series For Statistical Variables

@datacommons.cities.abiego_wikidataid_q24013454
  • 47.68 kB
  • 5,998 rows
  • 12 columns
Loading... 

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

Abiko - Time Series For Statistical Variables

@datacommons.cities.abiko_wikidataid_q243859
  • 65.84 kB
  • 8,543 rows
  • 12 columns
Loading... 

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

Abilene - Time Series For Statistical Variables

@datacommons.cities.abilene_geoid_2000125
  • 3.28 MB
  • 358,266 rows
  • 12 columns
Loading... 

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

Abilene - Time Series For Statistical Variables

@datacommons.cities.abilene_geoid_4801000
  • 3.81 MB
  • 375,056 rows
  • 12 columns
Loading... 

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

Abingdon - Time Series For Statistical Variables

@datacommons.cities.abingdon_geoid_1700113
  • 3.04 MB
  • 349,244 rows
  • 12 columns
Loading... 

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

Abingdon - Time Series For Statistical Variables

@datacommons.cities.abingdon_geoid_2400200
  • 1.13 MB
  • 68,552 rows
  • 12 columns
Loading... 

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

Abingdon - Time Series For Statistical Variables

@datacommons.cities.abingdon_geoid_5100148
  • 3.3 MB
  • 359,948 rows
  • 12 columns
Loading... 

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

Abingdon Historic District - Time Series For Statistical Variables

@datacommons.cities.abingdon_historic_district_wikidataid_q15177947
  • 92.73 kB
  • 14,998 rows
  • 12 columns
Loading... 

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

Abingdon-on-Thames - Time Series For Statistical Variables

@datacommons.cities.abingdon_on_thames_wikidataid_q321381
  • 79.53 kB
  • 11,257 rows
  • 12 columns
Loading... 

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

Abingdon - Time Series For Statistical Variables

@datacommons.cities.abingdon_wikidataid_q579672
  • 74.47 kB
  • 12,665 rows
  • 12 columns
Loading... 

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

Abington - Time Series For Statistical Variables

@datacommons.cities.abington_geoid_1800154
  • 785.08 kB
  • 36,214 rows
  • 12 columns
Loading... 

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