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

@datacommons.cities.wikidataid_q1320775_wikidataid_q1320775
  • 55.67 kB
  • 6,231 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q1320775_wikidataid_q1320775 (
  "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/Q13638193 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q13638193_wikidataid_q13638193
  • 64.45 kB
  • 8,108 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q13638193_wikidataid_q13638193 (
  "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/Q1365648 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q1365648_wikidataid_q1365648
  • 71.99 kB
  • 8,995 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q1365648_wikidataid_q1365648 (
  "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/Q136705 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q136705_wikidataid_q136705
  • 56.19 kB
  • 6,336 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q136705_wikidataid_q136705 (
  "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/Q1382327 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q1382327_wikidataid_q1382327
  • 73.26 kB
  • 10,405 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q1382327_wikidataid_q1382327 (
  "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/Q1396549 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q1396549_wikidataid_q1396549
  • 50.03 kB
  • 5,717 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q1396549_wikidataid_q1396549 (
  "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/Q14204629 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q14204629_wikidataid_q14204629
  • 49.31 kB
  • 6,285 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q14204629_wikidataid_q14204629 (
  "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/Q14211334 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q14211334_wikidataid_q14211334
  • 107.02 kB
  • 15,494 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q14211334_wikidataid_q14211334 (
  "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/Q14214002 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q14214002_wikidataid_q14214002
  • 101.93 kB
  • 15,505 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q14214002_wikidataid_q14214002 (
  "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/Q14219428 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q14219428_wikidataid_q14219428
  • 60.05 kB
  • 7,598 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q14219428_wikidataid_q14219428 (
  "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/Q14219787 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q14219787_wikidataid_q14219787
  • 37.53 kB
  • 3,560 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q14219787_wikidataid_q14219787 (
  "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/Q14221464 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q14221464_wikidataid_q14221464
  • 47.5 kB
  • 6,022 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q14221464_wikidataid_q14221464 (
  "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/Q14221716 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q14221716_wikidataid_q14221716
  • 35.97 kB
  • 4,169 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q14221716_wikidataid_q14221716 (
  "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/Q14222661 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q14222661_wikidataid_q14222661
  • 34.01 kB
  • 3,390 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q14222661_wikidataid_q14222661 (
  "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/Q1436787 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q1436787_wikidataid_q1436787
  • 29.94 kB
  • 2,931 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q1436787_wikidataid_q1436787 (
  "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/Q14653839 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q14653839_wikidataid_q14653839
  • 12.22 kB
  • 406 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q14653839_wikidataid_q14653839 (
  "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/Q1500195 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q1500195_wikidataid_q1500195
  • 43.9 kB
  • 5,157 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q1500195_wikidataid_q1500195 (
  "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/Q15058363 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q15058363_wikidataid_q15058363
  • 62.03 kB
  • 11,193 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q15058363_wikidataid_q15058363 (
  "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/Q15120508 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q15120508_wikidataid_q15120508
  • 65.69 kB
  • 12,281 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q15120508_wikidataid_q15120508 (
  "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/Q15120509 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q15120509_wikidataid_q15120509
  • 88.48 kB
  • 14,889 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q15120509_wikidataid_q15120509 (
  "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/Q15134368 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q15134368_wikidataid_q15134368
  • 68.77 kB
  • 12,281 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q15134368_wikidataid_q15134368 (
  "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/Q1515541 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q1515541_wikidataid_q1515541
  • 49.67 kB
  • 6,267 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q1515541_wikidataid_q1515541 (
  "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/Q1529748 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q1529748_wikidataid_q1529748
  • 70.53 kB
  • 12,628 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q1529748_wikidataid_q1529748 (
  "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/Q15411354 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q15411354_wikidataid_q15411354
  • 30.8 kB
  • 3,357 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q15411354_wikidataid_q15411354 (
  "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/Q15526152 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q15526152_wikidataid_q15526152
  • 64.12 kB
  • 12,482 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q15526152_wikidataid_q15526152 (
  "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.