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

@datacommons.cities.wikidataid_q20484190_wikidataid_q20484190
  • 93.16 kB
  • 14,916 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20484190_wikidataid_q20484190 (
  "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/Q20484211 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q20484211_wikidataid_q20484211
  • 88.54 kB
  • 14,127 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20484211_wikidataid_q20484211 (
  "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/Q20484258 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q20484369_wikidataid_q20484369
  • 38.93 kB
  • 5,904 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20484369_wikidataid_q20484369 (
  "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/Q20484423 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q20484423_wikidataid_q20484423
  • 101.06 kB
  • 15,841 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20484423_wikidataid_q20484423 (
  "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/Q20484433 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q20484433_wikidataid_q20484433
  • 102.53 kB
  • 16,200 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20484433_wikidataid_q20484433 (
  "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/Q20484436 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q20484436_wikidataid_q20484436
  • 82.42 kB
  • 13,418 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20484436_wikidataid_q20484436 (
  "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/Q20484570 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q20484570_wikidataid_q20484570
  • 66.91 kB
  • 11,673 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20484570_wikidataid_q20484570 (
  "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/Q20484637 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q20484637_wikidataid_q20484637
  • 101.63 kB
  • 15,726 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20484637_wikidataid_q20484637 (
  "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/Q20484762 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q20484762_wikidataid_q20484762
  • 96.87 kB
  • 15,467 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20484762_wikidataid_q20484762 (
  "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/Q20484859 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q20484859_wikidataid_q20484859
  • 103.22 kB
  • 15,866 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20484859_wikidataid_q20484859 (
  "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/Q20484864 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q20484864_wikidataid_q20484864
  • 108.54 kB
  • 15,813 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20484864_wikidataid_q20484864 (
  "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/Q20484870 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q20484870_wikidataid_q20484870
  • 99 kB
  • 15,373 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20484870_wikidataid_q20484870 (
  "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/Q20484993 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q20484993_wikidataid_q20484993
  • 96.37 kB
  • 14,925 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20484993_wikidataid_q20484993 (
  "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/Q20485010 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q20485010_wikidataid_q20485010
  • 103.13 kB
  • 15,694 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20485010_wikidataid_q20485010 (
  "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/Q20485019 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q20485019_wikidataid_q20485019
  • 77.42 kB
  • 12,676 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20485019_wikidataid_q20485019 (
  "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/Q20485029 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q20485029_wikidataid_q20485029
  • 100.28 kB
  • 14,134 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20485029_wikidataid_q20485029 (
  "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/Q20485042 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q20485042_wikidataid_q20485042
  • 71.88 kB
  • 11,928 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20485042_wikidataid_q20485042 (
  "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/Q20485073 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q20485073_wikidataid_q20485073
  • 100.17 kB
  • 15,841 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20485073_wikidataid_q20485073 (
  "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/Q20485163 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q20485163_wikidataid_q20485163
  • 103.72 kB
  • 15,980 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20485163_wikidataid_q20485163 (
  "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/Q20485203 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q20485203_wikidataid_q20485203
  • 91.04 kB
  • 14,677 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20485203_wikidataid_q20485203 (
  "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/Q20485258 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q20485258_wikidataid_q20485258
  • 99.64 kB
  • 14,976 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20485258_wikidataid_q20485258 (
  "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/Q20485371 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q20485371_wikidataid_q20485371
  • 98.76 kB
  • 15,526 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20485371_wikidataid_q20485371 (
  "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/Q20485381 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q20485381_wikidataid_q20485381
  • 96.33 kB
  • 15,443 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20485381_wikidataid_q20485381 (
  "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/Q20485400 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q20485400_wikidataid_q20485400
  • 98.56 kB
  • 15,837 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20485400_wikidataid_q20485400 (
  "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.