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

Ak-Dovurak - Time Series For Statistical Variables

@datacommons.cities.ak_dovurak_wikidataid_q103115
  • 33.53 kB
  • 3,827 rows
  • 12 columns
Loading... 

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

Akebanochō - Time Series For Statistical Variables

@datacommons.cities.akebanoch_wikidataid_q11515055
  • 67.73 kB
  • 8,939 rows
  • 12 columns
Loading... 

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

Akebonochō - Time Series For Statistical Variables

@datacommons.cities.akebonoch_wikidataid_q11515054
  • 71.42 kB
  • 9,728 rows
  • 12 columns
Loading... 

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

Akeley - Time Series For Statistical Variables

@datacommons.cities.akeley_geoid_2700496
  • 2.85 MB
  • 341,822 rows
  • 12 columns
Loading... 

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

Akeley Township - Time Series For Statistical Variables

@datacommons.cities.akeley_township_geoid_2700514
  • 81.12 kB
  • 12,720 rows
  • 12 columns
Loading... 

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

Aken (Elbe) - Time Series For Statistical Variables

@datacommons.cities.aken_elbe_wikidataid_q417336
  • 86.58 kB
  • 11,228 rows
  • 12 columns
Loading... 

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

Akhalkalaki - Time Series For Statistical Variables

@datacommons.cities.akhalkalaki_wikidataid_q500888
  • 48.79 kB
  • 5,802 rows
  • 12 columns
Loading... 

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

Akhaltsikhe - Time Series For Statistical Variables

@datacommons.cities.akhaltsikhe_wikidataid_q212546
  • 52.83 kB
  • 5,797 rows
  • 12 columns
Loading... 

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

Akhaura Upazila - Time Series For Statistical Variables

@datacommons.cities.akhaura_upazila_wikidataid_q3346701
  • 59.65 kB
  • 7,544 rows
  • 12 columns
Loading... 

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

Akhiok - Time Series For Statistical Variables

@datacommons.cities.akhiok_geoid_0200650
  • 1.22 MB
  • 172,391 rows
  • 12 columns
Loading... 

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

Akhmeta - Time Series For Statistical Variables

@datacommons.cities.akhmeta_wikidataid_q340566
  • 83.11 kB
  • 11,274 rows
  • 12 columns
Loading... 

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

Akhmim - Time Series For Statistical Variables

@datacommons.cities.akhmim_wikidataid_q340572
  • 13.81 kB
  • 840 rows
  • 12 columns
Loading... 

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

Akhtala - Time Series For Statistical Variables

@datacommons.cities.akhtala_wikidataid_q614157
  • 51.5 kB
  • 5,569 rows
  • 12 columns
Loading... 

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

Akhtubinsk - Time Series For Statistical Variables

@datacommons.cities.akhtubinsk_wikidataid_q104201
  • 69.21 kB
  • 8,914 rows
  • 12 columns
Loading... 

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

Akiachak - Time Series For Statistical Variables

@datacommons.cities.akiachak_geoid_0200760
  • 1.52 MB
  • 193,855 rows
  • 12 columns
Loading... 

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

Akiak - Time Series For Statistical Variables

@datacommons.cities.akiak_geoid_0200870
  • 1.49 MB
  • 189,610 rows
  • 12 columns
Loading... 

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

Akim Oda - Time Series For Statistical Variables

@datacommons.cities.akim_oda_wikidataid_q418402
  • 27.49 kB
  • 2,855 rows
  • 12 columns
Loading... 

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

Akins - Time Series For Statistical Variables

@datacommons.cities.akins_geoid_4000900
  • 2.86 MB
  • 343,351 rows
  • 12 columns
Loading... 

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

Akiruno - Time Series For Statistical Variables

@datacommons.cities.akiruno_wikidataid_q240480
  • 68.67 kB
  • 9,017 rows
  • 12 columns
Loading... 

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

Akishima - Time Series For Statistical Variables

@datacommons.cities.akishima_wikidataid_q212494
  • 69.26 kB
  • 9,075 rows
  • 12 columns
Loading... 

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

Akitakata - Time Series For Statistical Variables

@datacommons.cities.akitakata_wikidataid_q419392
  • 56.24 kB
  • 7,155 rows
  • 12 columns
Loading... 

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

Akiōta - Time Series For Statistical Variables

@datacommons.cities.aki_ta_wikidataid_q1204574
  • 65.73 kB
  • 9,097 rows
  • 12 columns
Loading... 

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

Akita - Time Series For Statistical Variables

@datacommons.cities.akita_wikidataid_q17139
  • 62.41 kB
  • 7,879 rows
  • 12 columns
Loading... 

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

Aki - Time Series For Statistical Variables

@datacommons.cities.aki_wikidataid_q417825
  • 58.46 kB
  • 7,216 rows
  • 12 columns
Loading... 

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

Akkad - Time Series For Statistical Variables

@datacommons.cities.akkad_wikidataid_q150996
  • 31.79 kB
  • 3,720 rows
  • 12 columns
Loading... 

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