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

@datacommons.cities.wikidataid_q5856979_wikidataid_q5856979
  • 86.83 kB
  • 14,864 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q5856979_wikidataid_q5856979 (
  "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/Q5857980 - Time Series For Statistical Variables

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

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

@datacommons.cities.wikidataid_q5869516_wikidataid_q5869516
  • 47.98 kB
  • 5,691 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q5869516_wikidataid_q5869516 (
  "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/Q5905917 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q5905917_wikidataid_q5905917
  • 36.15 kB
  • 4,389 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q5905917_wikidataid_q5905917 (
  "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/Q59240823 - Time Series For Statistical Variables

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

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

@datacommons.cities.wikidataid_q5936372_wikidataid_q5936372
  • 76.64 kB
  • 13,169 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q5936372_wikidataid_q5936372 (
  "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/Q5938233 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q5938233_wikidataid_q5938233
  • 90.36 kB
  • 14,844 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q5938233_wikidataid_q5938233 (
  "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/Q5938642 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q5938642_wikidataid_q5938642
  • 53.13 kB
  • 6,242 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q5938642_wikidataid_q5938642 (
  "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/Q5941844 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q5941844_wikidataid_q5941844
  • 78.66 kB
  • 12,755 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q5941844_wikidataid_q5941844 (
  "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/Q5944744 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q5944744_wikidataid_q5944744
  • 73.09 kB
  • 13,230 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q5944744_wikidataid_q5944744 (
  "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/Q5954281 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q5954281_wikidataid_q5954281
  • 33.33 kB
  • 3,707 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q5954281_wikidataid_q5954281 (
  "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/Q59569181 - Time Series For Statistical Variables

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

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

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

@datacommons.cities.wikidataid_q5963243_wikidataid_q5963243
  • 46.76 kB
  • 5,869 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q5963243_wikidataid_q5963243 (
  "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/Q5963264 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q5963264_wikidataid_q5963264
  • 57.31 kB
  • 8,146 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q5963264_wikidataid_q5963264 (
  "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/Q5963433 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q5964295_wikidataid_q5964295
  • 52.33 kB
  • 6,938 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q5964295_wikidataid_q5964295 (
  "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/Q5972666 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q5972666_wikidataid_q5972666
  • 41 kB
  • 4,806 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q5972666_wikidataid_q5972666 (
  "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/Q5979311 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q5979311_wikidataid_q5979311
  • 58.34 kB
  • 7,990 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q5979311_wikidataid_q5979311 (
  "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/Q5979357 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q5979357_wikidataid_q5979357
  • 50.89 kB
  • 6,722 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q5979357_wikidataid_q5979357 (
  "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/Q5980063 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q5980063_wikidataid_q5980063
  • 51.04 kB
  • 6,722 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q5980063_wikidataid_q5980063 (
  "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/Q5990071 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q5990071_wikidataid_q5990071
  • 26.27 kB
  • 2,364 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q5990071_wikidataid_q5990071 (
  "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.