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

@datacommons.cities.wikidataid_q6026718_wikidataid_q6026718
  • 92.55 kB
  • 15,474 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6026718_wikidataid_q6026718 (
  "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/Q6026720 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6026720_wikidataid_q6026720
  • 94.56 kB
  • 15,631 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6026720_wikidataid_q6026720 (
  "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/Q6026723 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6026723_wikidataid_q6026723
  • 92.82 kB
  • 15,209 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6026723_wikidataid_q6026723 (
  "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/Q6026725 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6026725_wikidataid_q6026725
  • 85.66 kB
  • 13,314 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6026725_wikidataid_q6026725 (
  "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/Q6026728 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6026728_wikidataid_q6026728
  • 81.53 kB
  • 13,344 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6026728_wikidataid_q6026728 (
  "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/Q6026735 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6026735_wikidataid_q6026735
  • 95.88 kB
  • 14,838 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6026735_wikidataid_q6026735 (
  "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/Q6026737 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6026737_wikidataid_q6026737
  • 87.65 kB
  • 14,849 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6026737_wikidataid_q6026737 (
  "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/Q6026741 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6026741_wikidataid_q6026741
  • 90.38 kB
  • 14,851 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6026741_wikidataid_q6026741 (
  "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/Q6026743 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6026743_wikidataid_q6026743
  • 94.42 kB
  • 15,224 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6026743_wikidataid_q6026743 (
  "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/Q6026747 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6026747_wikidataid_q6026747
  • 81.19 kB
  • 13,763 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6026747_wikidataid_q6026747 (
  "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/Q6026749 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6026749_wikidataid_q6026749
  • 94.06 kB
  • 15,631 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6026749_wikidataid_q6026749 (
  "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/Q6026754 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6026754_wikidataid_q6026754
  • 93.69 kB
  • 15,633 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6026754_wikidataid_q6026754 (
  "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/Q6026757 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6026757_wikidataid_q6026757
  • 89.77 kB
  • 14,869 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6026757_wikidataid_q6026757 (
  "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/Q6026765 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6026765_wikidataid_q6026765
  • 88.46 kB
  • 14,838 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6026765_wikidataid_q6026765 (
  "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/Q6026768 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6026768_wikidataid_q6026768
  • 88.89 kB
  • 14,851 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6026768_wikidataid_q6026768 (
  "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/Q6026772 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6026772_wikidataid_q6026772
  • 103.58 kB
  • 15,634 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6026772_wikidataid_q6026772 (
  "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/Q6026777 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6026777_wikidataid_q6026777
  • 91.81 kB
  • 15,106 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6026777_wikidataid_q6026777 (
  "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/Q6026780 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6026780_wikidataid_q6026780
  • 71.93 kB
  • 12,472 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6026780_wikidataid_q6026780 (
  "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/Q6026782 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6026782_wikidataid_q6026782
  • 75.32 kB
  • 13,703 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6026782_wikidataid_q6026782 (
  "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/Q6026785 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6026785_wikidataid_q6026785
  • 80.25 kB
  • 13,736 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6026785_wikidataid_q6026785 (
  "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/Q6026787 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6026787_wikidataid_q6026787
  • 92.29 kB
  • 14,848 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6026787_wikidataid_q6026787 (
  "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/Q6026794 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6026794_wikidataid_q6026794
  • 95.47 kB
  • 14,836 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6026794_wikidataid_q6026794 (
  "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/Q6026797 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6026797_wikidataid_q6026797
  • 73.21 kB
  • 13,033 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6026797_wikidataid_q6026797 (
  "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/Q6026800 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6026800_wikidataid_q6026800
  • 83.31 kB
  • 13,741 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6026800_wikidataid_q6026800 (
  "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/Q6026803 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6026803_wikidataid_q6026803
  • 102.55 kB
  • 15,634 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6026803_wikidataid_q6026803 (
  "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.