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/Q18016611 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q18016611_wikidataid_q18016611
  • 42.44 kB
  • 5,092 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q18016611_wikidataid_q18016611 (
  "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/Q18059321 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q18059321_wikidataid_q18059321
  • 51.15 kB
  • 6,330 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q18059321_wikidataid_q18059321 (
  "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/Q18071356 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q18071356_wikidataid_q18071356
  • 39.81 kB
  • 4,876 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q18071356_wikidataid_q18071356 (
  "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/Q1812847 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q1812847_wikidataid_q1812847
  • 49.27 kB
  • 5,912 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q1812847_wikidataid_q1812847 (
  "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/Q1821954 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q1821954_wikidataid_q1821954
  • 63.68 kB
  • 8,381 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q1821954_wikidataid_q1821954 (
  "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/Q1823612 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q1823612_wikidataid_q1823612
  • 59.06 kB
  • 11,362 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q1823612_wikidataid_q1823612 (
  "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/Q1824424 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q1824424_wikidataid_q1824424
  • 63.9 kB
  • 8,360 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q1824424_wikidataid_q1824424 (
  "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/Q1826223 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q1826223_wikidataid_q1826223
  • 87.75 kB
  • 11,692 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q1826223_wikidataid_q1826223 (
  "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/Q18377104 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q18377104_wikidataid_q18377104
  • 21.32 kB
  • 1,755 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q18377104_wikidataid_q18377104 (
  "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/Q18465837 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q18465837_wikidataid_q18465837
  • 35.66 kB
  • 4,204 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q18465837_wikidataid_q18465837 (
  "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/Q1847409 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q1847409_wikidataid_q1847409
  • 49.59 kB
  • 6,016 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q1847409_wikidataid_q1847409 (
  "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/Q18481499 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q18481499_wikidataid_q18481499
  • 50.26 kB
  • 6,282 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q18481499_wikidataid_q18481499 (
  "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/Q18523911 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q18523911_wikidataid_q18523911
  • 36.59 kB
  • 4,507 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q18523911_wikidataid_q18523911 (
  "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/Q18562735 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q18562735_wikidataid_q18562735
  • 75.77 kB
  • 10,536 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q18562735_wikidataid_q18562735 (
  "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/Q18590709 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q18590709_wikidataid_q18590709
  • 32.09 kB
  • 3,506 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q18590709_wikidataid_q18590709 (
  "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/Q18590721 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q18590721_wikidataid_q18590721
  • 34.03 kB
  • 3,506 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q18590721_wikidataid_q18590721 (
  "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/Q1868138 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q1868138_wikidataid_q1868138
  • 45.85 kB
  • 5,580 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q1868138_wikidataid_q1868138 (
  "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/Q1869939 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q1869939_wikidataid_q1869939
  • 79.78 kB
  • 10,382 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q1869939_wikidataid_q1869939 (
  "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/Q1876860 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q1876860_wikidataid_q1876860
  • 48.55 kB
  • 5,967 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q1876860_wikidataid_q1876860 (
  "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/Q18943508 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q18943508_wikidataid_q18943508
  • 30.23 kB
  • 3,136 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q18943508_wikidataid_q18943508 (
  "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/Q1916321 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q1916321_wikidataid_q1916321
  • 68.58 kB
  • 9,952 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q1916321_wikidataid_q1916321 (
  "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/Q1923666 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q1923666_wikidataid_q1923666
  • 49.75 kB
  • 6,228 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q1923666_wikidataid_q1923666 (
  "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/Q1926167 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q1926167_wikidataid_q1926167
  • 45.71 kB
  • 5,643 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q1926167_wikidataid_q1926167 (
  "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/Q1945489 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q1945489_wikidataid_q1945489
  • 72.75 kB
  • 10,375 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q1945489_wikidataid_q1945489 (
  "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/Q1949911 - Time Series For Statistical Variables

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