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

@datacommons.cities.wikidataid_q6027900_wikidataid_q6027900
  • 77.14 kB
  • 13,331 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6027900_wikidataid_q6027900 (
  "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/Q6028240 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6028240_wikidataid_q6028240
  • 84.14 kB
  • 14,317 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6028240_wikidataid_q6028240 (
  "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/Q6028352 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6028352_wikidataid_q6028352
  • 97.63 kB
  • 15,354 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6028352_wikidataid_q6028352 (
  "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/Q6028579 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6028579_wikidataid_q6028579
  • 83.94 kB
  • 13,620 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6028579_wikidataid_q6028579 (
  "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/Q6028601 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q6028621_wikidataid_q6028621
  • 86.93 kB
  • 14,034 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6028621_wikidataid_q6028621 (
  "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/Q6028671 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6028671_wikidataid_q6028671
  • 75.24 kB
  • 12,554 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6028671_wikidataid_q6028671 (
  "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/Q6028674 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6028674_wikidataid_q6028674
  • 91.85 kB
  • 15,043 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6028674_wikidataid_q6028674 (
  "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/Q6029176 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6029176_wikidataid_q6029176
  • 81.01 kB
  • 11,361 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6029176_wikidataid_q6029176 (
  "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/Q6029440 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6029440_wikidataid_q6029440
  • 86.8 kB
  • 14,071 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6029440_wikidataid_q6029440 (
  "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/Q6029484 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6029484_wikidataid_q6029484
  • 104.8 kB
  • 15,395 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6029484_wikidataid_q6029484 (
  "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/Q6029503 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6029503_wikidataid_q6029503
  • 87.81 kB
  • 14,473 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6029503_wikidataid_q6029503 (
  "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/Q6029572 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6029572_wikidataid_q6029572
  • 75.15 kB
  • 12,425 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6029572_wikidataid_q6029572 (
  "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/Q6029581 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6029581_wikidataid_q6029581
  • 91.37 kB
  • 14,047 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6029581_wikidataid_q6029581 (
  "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/Q6029823 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q6030033_wikidataid_q6030033
  • 85.52 kB
  • 14,309 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6030033_wikidataid_q6030033 (
  "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/Q6030114 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6030114_wikidataid_q6030114
  • 9.49 kB
  • 1 row
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6030114_wikidataid_q6030114 (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" BIGINT,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

WikidataId/Q6030289 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6030289_wikidataid_q6030289
  • 76.93 kB
  • 13,131 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6030289_wikidataid_q6030289 (
  "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/Q6030391 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6030391_wikidataid_q6030391
  • 89.61 kB
  • 14,250 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6030391_wikidataid_q6030391 (
  "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/Q6030636 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q6031126_wikidataid_q6031126
  • 90.28 kB
  • 14,276 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6031126_wikidataid_q6031126 (
  "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/Q6031145 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6031145_wikidataid_q6031145
  • 82.17 kB
  • 14,064 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6031145_wikidataid_q6031145 (
  "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/Q6031218 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6031218_wikidataid_q6031218
  • 95.87 kB
  • 15,349 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6031218_wikidataid_q6031218 (
  "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/Q6031355 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6031355_wikidataid_q6031355
  • 88.2 kB
  • 14,883 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6031355_wikidataid_q6031355 (
  "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/Q6031357 - Time Series For Statistical Variables

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