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

@datacommons.cities.wikidataid_q79266732_wikidataid_q79266732
  • 46.41 kB
  • 5,429 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q79266732_wikidataid_q79266732 (
  "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/Q794088 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q794088_wikidataid_q794088
  • 54.86 kB
  • 6,880 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q794088_wikidataid_q794088 (
  "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/Q80697733 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q80697733_wikidataid_q80697733
  • 42.85 kB
  • 5,092 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q80697733_wikidataid_q80697733 (
  "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/Q80700527 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q80700527_wikidataid_q80700527
  • 42.97 kB
  • 5,092 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q80700527_wikidataid_q80700527 (
  "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/Q8123097 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q8124246_wikidataid_q8124246
  • 42.23 kB
  • 5,092 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q8124246_wikidataid_q8124246 (
  "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/Q817274 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q817274_wikidataid_q817274
  • 41.79 kB
  • 5,132 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q817274_wikidataid_q817274 (
  "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/Q81803420 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q81803420_wikidataid_q81803420
  • 42.47 kB
  • 5,092 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q81803420_wikidataid_q81803420 (
  "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/Q81804424 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q81804424_wikidataid_q81804424
  • 42.46 kB
  • 5,092 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q81804424_wikidataid_q81804424 (
  "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/Q81804810 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q81804810_wikidataid_q81804810
  • 42.26 kB
  • 5,092 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q81804810_wikidataid_q81804810 (
  "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/Q81805119 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q81805119_wikidataid_q81805119
  • 42.3 kB
  • 5,092 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q81805119_wikidataid_q81805119 (
  "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/Q81805446 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q81805446_wikidataid_q81805446
  • 42.52 kB
  • 5,092 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q81805446_wikidataid_q81805446 (
  "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/Q81805803 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q81805803_wikidataid_q81805803
  • 42.14 kB
  • 5,092 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q81805803_wikidataid_q81805803 (
  "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/Q81808243 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q81808243_wikidataid_q81808243
  • 42.24 kB
  • 5,092 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q81808243_wikidataid_q81808243 (
  "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/Q81808634 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q81808634_wikidataid_q81808634
  • 42.44 kB
  • 5,092 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q81808634_wikidataid_q81808634 (
  "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/Q81809019 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q81809019_wikidataid_q81809019
  • 42.32 kB
  • 5,092 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q81809019_wikidataid_q81809019 (
  "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/Q81809326 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q81809326_wikidataid_q81809326
  • 42.73 kB
  • 5,092 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q81809326_wikidataid_q81809326 (
  "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/Q81809928 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q81809928_wikidataid_q81809928
  • 42.45 kB
  • 5,092 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q81809928_wikidataid_q81809928 (
  "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/Q81810201 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q81810201_wikidataid_q81810201
  • 42.31 kB
  • 5,092 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q81810201_wikidataid_q81810201 (
  "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/Q8183946 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q8183946_wikidataid_q8183946
  • 25.49 kB
  • 2,436 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q8183946_wikidataid_q8183946 (
  "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/Q8183947 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q8183947_wikidataid_q8183947
  • 34.77 kB
  • 4,656 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q8183947_wikidataid_q8183947 (
  "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/Q8183998 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q8183998_wikidataid_q8183998
  • 34.69 kB
  • 4,656 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q8183998_wikidataid_q8183998 (
  "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/Q8196258 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q8196258_wikidataid_q8196258
  • 41.59 kB
  • 4,856 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q8196258_wikidataid_q8196258 (
  "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/Q8196644 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q8196644_wikidataid_q8196644
  • 19.22 kB
  • 1,355 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q8196644_wikidataid_q8196644 (
  "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/Q8196823 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q8196823_wikidataid_q8196823
  • 59.77 kB
  • 7,925 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q8196823_wikidataid_q8196823 (
  "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.