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

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

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

@datacommons.cities.wikidataid_q5770185_wikidataid_q5770185
  • 49.23 kB
  • 6,495 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q5770185_wikidataid_q5770185 (
  "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/Q5784276 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q5784276_wikidataid_q5784276
  • 50.76 kB
  • 6,356 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q5784276_wikidataid_q5784276 (
  "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/Q5793218 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q5793218_wikidataid_q5793218
  • 16.19 kB
  • 1,298 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q5793218_wikidataid_q5793218 (
  "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/Q57937370 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q57937370_wikidataid_q57937370
  • 51.59 kB
  • 6,162 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q57937370_wikidataid_q57937370 (
  "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/Q5797649 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q5797649_wikidataid_q5797649
  • 92.67 kB
  • 15,377 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q5797649_wikidataid_q5797649 (
  "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/Q5798636 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q5798636_wikidataid_q5798636
  • 87.86 kB
  • 14,892 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q5798636_wikidataid_q5798636 (
  "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/Q58005508 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q58005508_wikidataid_q58005508
  • 54.37 kB
  • 7,116 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q58005508_wikidataid_q58005508 (
  "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/Q5800894 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q5800894_wikidataid_q5800894
  • 98.48 kB
  • 15,233 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q5800894_wikidataid_q5800894 (
  "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/Q5803012 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q5803012_wikidataid_q5803012
  • 16.39 kB
  • 915 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q5803012_wikidataid_q5803012 (
  "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/Q5805442 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q5814697_wikidataid_q5814697
  • 50.13 kB
  • 6,336 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q5814697_wikidataid_q5814697 (
  "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/Q5820956 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q5821614_wikidataid_q5821614
  • 32.1 kB
  • 3,784 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q5821614_wikidataid_q5821614 (
  "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/Q5823014 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q5823014_wikidataid_q5823014
  • 9.49 kB
  • 1 row
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q5823014_wikidataid_q5823014 (
  "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/Q5823228 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q5832333_wikidataid_q5832333
  • 42.82 kB
  • 4,948 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q5832333_wikidataid_q5832333 (
  "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/Q5832423 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q5832423_wikidataid_q5832423
  • 17.47 kB
  • 1,106 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q5832423_wikidataid_q5832423 (
  "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/Q5836482 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q5836482_wikidataid_q5836482
  • 70.26 kB
  • 12,457 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q5836482_wikidataid_q5836482 (
  "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/Q5839506 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q5840138_wikidataid_q5840138
  • 69.45 kB
  • 12,368 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q5840138_wikidataid_q5840138 (
  "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/Q5849331 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q5849331_wikidataid_q5849331
  • 50.61 kB
  • 6,336 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q5849331_wikidataid_q5849331 (
  "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/Q5854329 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q5854329_wikidataid_q5854329
  • 50.37 kB
  • 6,336 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q5854329_wikidataid_q5854329 (
  "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/Q5855853 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q5855853_wikidataid_q5855853
  • 73.61 kB
  • 12,472 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q5855853_wikidataid_q5855853 (
  "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.