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

@datacommons.cities.wikidataid_q5641902_wikidataid_q5641902
  • 57.28 kB
  • 7,790 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q5641902_wikidataid_q5641902 (
  "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/Q5645772 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q5645772_wikidataid_q5645772
  • 55.87 kB
  • 7,658 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q5645772_wikidataid_q5645772 (
  "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/Q5648141 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q5648141_wikidataid_q5648141
  • 92.86 kB
  • 15,219 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q5648141_wikidataid_q5648141 (
  "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/Q56511649 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q56511649_wikidataid_q56511649
  • 57.11 kB
  • 7,493 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q56511649_wikidataid_q56511649 (
  "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/Q56541943 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q56541943_wikidataid_q56541943
  • 49.15 kB
  • 6,676 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q56541943_wikidataid_q56541943 (
  "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/Q5654710 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q5655025_wikidataid_q5655025
  • 49.01 kB
  • 6,496 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q5655025_wikidataid_q5655025 (
  "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/Q5655536 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q5656874_wikidataid_q5656874
  • 73.66 kB
  • 12,592 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q5656874_wikidataid_q5656874 (
  "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/Q56611683 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q5661422_wikidataid_q5661422
  • 89.24 kB
  • 14,364 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q5661422_wikidataid_q5661422 (
  "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/Q5662321 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q5662321_wikidataid_q5662321
  • 20.19 kB
  • 1,839 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q5662321_wikidataid_q5662321 (
  "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/Q5662654 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q56628114_wikidataid_q56628114
  • 58.63 kB
  • 7,493 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q56628114_wikidataid_q56628114 (
  "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/Q56677028 - Time Series For Statistical Variables

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

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

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

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

@datacommons.cities.wikidataid_q5678043_wikidataid_q5678043
  • 72.4 kB
  • 12,592 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q5678043_wikidataid_q5678043 (
  "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/Q5679523 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q5679523_wikidataid_q5679523
  • 85.33 kB
  • 14,387 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q5679523_wikidataid_q5679523 (
  "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/Q568046 - Time Series For Statistical Variables

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

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

@datacommons.cities.wikidataid_q5689367_wikidataid_q5689367
  • 55.94 kB
  • 7,371 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q5689367_wikidataid_q5689367 (
  "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/Q5694578 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q5694578_wikidataid_q5694578
  • 88.01 kB
  • 14,389 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q5694578_wikidataid_q5694578 (
  "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/Q5703573 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q5703573_wikidataid_q5703573
  • 58.86 kB
  • 7,990 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q5703573_wikidataid_q5703573 (
  "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.