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

WikidataId/Q15526156 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q15526156_wikidataid_q15526156
  • 68.98 kB
  • 12,626 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q15526156_wikidataid_q15526156 (
  "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
);

WikidataId/Q15526164 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q15526164_wikidataid_q15526164
  • 67.86 kB
  • 12,619 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q15526164_wikidataid_q15526164 (
  "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
);

WikidataId/Q15832689 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q15832689_wikidataid_q15832689
  • 46.83 kB
  • 8,631 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q15832689_wikidataid_q15832689 (
  "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
);

WikidataId/Q15934709 - Time Series For Statistical Variables

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

WikidataId/Q15987253 - Time Series For Statistical Variables

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

WikidataId/Q16118317 - Time Series For Statistical Variables

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

WikidataId/Q1619325 - Time Series For Statistical Variables

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

WikidataId/Q1620332 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q1620332_wikidataid_q1620332
  • 85.35 kB
  • 13,204 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q1620332_wikidataid_q1620332 (
  "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
);

WikidataId/Q1624998 - Time Series For Statistical Variables

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

WikidataId/Q16302793 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q16302793_wikidataid_q16302793
  • 79.53 kB
  • 13,605 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q16302793_wikidataid_q16302793 (
  "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
);

WikidataId/Q16303513 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q16303513_wikidataid_q16303513
  • 57.6 kB
  • 7,545 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q16303513_wikidataid_q16303513 (
  "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
);

WikidataId/Q16304164 - Time Series For Statistical Variables

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

WikidataId/Q1631755 - Time Series For Statistical Variables

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

WikidataId/Q16324228 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q16324228_wikidataid_q16324228
  • 63.75 kB
  • 8,296 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q16324228_wikidataid_q16324228 (
  "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
);

WikidataId/Q16324279 - Time Series For Statistical Variables

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

WikidataId/Q16324484 - Time Series For Statistical Variables

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

WikidataId/Q16327838 - Time Series For Statistical Variables

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

WikidataId/Q16339211 - Time Series For Statistical Variables

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

WikidataId/Q16339753 - Time Series For Statistical Variables

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

WikidataId/Q16358899 - Time Series For Statistical Variables

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

WikidataId/Q16371150 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q16371150_wikidataid_q16371150
  • 83.58 kB
  • 11,233 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q16371150_wikidataid_q16371150 (
  "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
);

WikidataId/Q16419514 - Time Series For Statistical Variables

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

WikidataId/Q16465942 - Time Series For Statistical Variables

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

WikidataId/Q16466470 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q16466470_wikidataid_q16466470
  • 21.71 kB
  • 2,367 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q16466470_wikidataid_q16466470 (
  "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
);

WikidataId/Q16480004 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q16480004_wikidataid_q16480004
  • 42.18 kB
  • 4,953 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q16480004_wikidataid_q16480004 (
  "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.