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

@datacommons.cities.wikidataid_q12552098_wikidataid_q12552098
  • 93.27 kB
  • 14,726 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12552098_wikidataid_q12552098 (
  "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/Q12552099 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12552099_wikidataid_q12552099
  • 81.79 kB
  • 12,766 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12552099_wikidataid_q12552099 (
  "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/Q12552126 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12552126_wikidataid_q12552126
  • 66.9 kB
  • 11,970 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12552126_wikidataid_q12552126 (
  "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/Q12552762 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12552762_wikidataid_q12552762
  • 102.97 kB
  • 15,575 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12552762_wikidataid_q12552762 (
  "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/Q12552963 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12552963_wikidataid_q12552963
  • 97.73 kB
  • 15,655 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12552963_wikidataid_q12552963 (
  "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/Q12553746 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12553746_wikidataid_q12553746
  • 96.48 kB
  • 15,275 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12553746_wikidataid_q12553746 (
  "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/Q12554061 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12554061_wikidataid_q12554061
  • 86.53 kB
  • 13,937 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12554061_wikidataid_q12554061 (
  "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/Q12554391 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12554391_wikidataid_q12554391
  • 99.78 kB
  • 15,804 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12554391_wikidataid_q12554391 (
  "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/Q12554781 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12554781_wikidataid_q12554781
  • 100.82 kB
  • 15,805 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12554781_wikidataid_q12554781 (
  "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/Q12554801 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12554801_wikidataid_q12554801
  • 107.06 kB
  • 15,932 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12554801_wikidataid_q12554801 (
  "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/Q12555948 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12555948_wikidataid_q12555948
  • 98.06 kB
  • 15,639 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12555948_wikidataid_q12555948 (
  "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/Q12556475 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12556475_wikidataid_q12556475
  • 97.47 kB
  • 15,567 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12556475_wikidataid_q12556475 (
  "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/Q12556476 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12556476_wikidataid_q12556476
  • 98.28 kB
  • 15,492 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12556476_wikidataid_q12556476 (
  "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/Q12556477 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12556477_wikidataid_q12556477
  • 111.59 kB
  • 15,512 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12556477_wikidataid_q12556477 (
  "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/Q12556566 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12556566_wikidataid_q12556566
  • 100.3 kB
  • 15,779 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12556566_wikidataid_q12556566 (
  "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/Q12557873 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12557873_wikidataid_q12557873
  • 100.1 kB
  • 15,920 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12557873_wikidataid_q12557873 (
  "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/Q12558352 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12558352_wikidataid_q12558352
  • 109.55 kB
  • 15,794 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12558352_wikidataid_q12558352 (
  "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/Q12558974 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12558974_wikidataid_q12558974
  • 96.94 kB
  • 15,422 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12558974_wikidataid_q12558974 (
  "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/Q12559006 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12559006_wikidataid_q12559006
  • 97.87 kB
  • 15,500 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12559006_wikidataid_q12559006 (
  "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/Q12559406 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12559406_wikidataid_q12559406
  • 92.3 kB
  • 14,203 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12559406_wikidataid_q12559406 (
  "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/Q12559407 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12559407_wikidataid_q12559407
  • 82.6 kB
  • 13,024 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12559407_wikidataid_q12559407 (
  "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/Q12559677 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12559677_wikidataid_q12559677
  • 91.64 kB
  • 15,235 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12559677_wikidataid_q12559677 (
  "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/Q12560253 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12560253_wikidataid_q12560253
  • 70.47 kB
  • 10,738 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12560253_wikidataid_q12560253 (
  "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/Q12560411 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12560411_wikidataid_q12560411
  • 99.28 kB
  • 15,837 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12560411_wikidataid_q12560411 (
  "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/Q12560740 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12560740_wikidataid_q12560740
  • 80.42 kB
  • 13,634 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12560740_wikidataid_q12560740 (
  "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.