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

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

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

@datacommons.cities.wikidataid_q20549183_wikidataid_q20549183
  • 56.9 kB
  • 7,012 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20549183_wikidataid_q20549183 (
  "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/Q20549197 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q20549216_wikidataid_q20549216
  • 54.48 kB
  • 6,670 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20549216_wikidataid_q20549216 (
  "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/Q20549256 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q20549256_wikidataid_q20549256
  • 54.79 kB
  • 7,012 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20549256_wikidataid_q20549256 (
  "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/Q20549296 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q20549296_wikidataid_q20549296
  • 58.48 kB
  • 7,903 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20549296_wikidataid_q20549296 (
  "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/Q20549318 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q20549318_wikidataid_q20549318
  • 52.28 kB
  • 6,670 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20549318_wikidataid_q20549318 (
  "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/Q20549388 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q20549388_wikidataid_q20549388
  • 54.38 kB
  • 7,012 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20549388_wikidataid_q20549388 (
  "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/Q20549417 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q20549417_wikidataid_q20549417
  • 52.28 kB
  • 6,670 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20549417_wikidataid_q20549417 (
  "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/Q20549431 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q20549431_wikidataid_q20549431
  • 52.62 kB
  • 6,670 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20549431_wikidataid_q20549431 (
  "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/Q20549441 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q20549441_wikidataid_q20549441
  • 52.02 kB
  • 6,506 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20549441_wikidataid_q20549441 (
  "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/Q20549442 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q20549442_wikidataid_q20549442
  • 60.1 kB
  • 8,054 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20549442_wikidataid_q20549442 (
  "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/Q20549447 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q20549447_wikidataid_q20549447
  • 52.26 kB
  • 6,670 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20549447_wikidataid_q20549447 (
  "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/Q20549482 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q20549560_wikidataid_q20549560
  • 43.15 kB
  • 5,224 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20549560_wikidataid_q20549560 (
  "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/Q20549564 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q20549564_wikidataid_q20549564
  • 57.05 kB
  • 7,659 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20549564_wikidataid_q20549564 (
  "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/Q20549600 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q20549600_wikidataid_q20549600
  • 53.91 kB
  • 7,012 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20549600_wikidataid_q20549600 (
  "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/Q20549656 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q20549656_wikidataid_q20549656
  • 52.48 kB
  • 6,670 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20549656_wikidataid_q20549656 (
  "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/Q20549678 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q20549678_wikidataid_q20549678
  • 53.89 kB
  • 6,670 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20549678_wikidataid_q20549678 (
  "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/Q20549686 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q20549686_wikidataid_q20549686
  • 60.42 kB
  • 7,012 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20549686_wikidataid_q20549686 (
  "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/Q20549689 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q20549695_wikidataid_q20549695
  • 53.86 kB
  • 7,012 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20549695_wikidataid_q20549695 (
  "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/Q20549698 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q20549698_wikidataid_q20549698
  • 55.63 kB
  • 7,012 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20549698_wikidataid_q20549698 (
  "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/Q20549724 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q20549724_wikidataid_q20549724
  • 53.78 kB
  • 7,012 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20549724_wikidataid_q20549724 (
  "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.