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

@datacommons.cities.wikidataid_q27480650_wikidataid_q27480650
  • 44.55 kB
  • 5,226 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q27480650_wikidataid_q27480650 (
  "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/Q2748075 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2748075_wikidataid_q2748075
  • 63.95 kB
  • 8,397 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2748075_wikidataid_q2748075 (
  "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/Q2749525 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2749525_wikidataid_q2749525
  • 72.58 kB
  • 10,419 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2749525_wikidataid_q2749525 (
  "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/Q2752164 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2752164_wikidataid_q2752164
  • 65.4 kB
  • 8,382 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2752164_wikidataid_q2752164 (
  "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/Q27541457 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q27541457_wikidataid_q27541457
  • 10.63 kB
  • 140 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q27541457_wikidataid_q27541457 (
  "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/Q2760236 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2760236_wikidataid_q2760236
  • 37.75 kB
  • 4,362 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2760236_wikidataid_q2760236 (
  "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/Q2761268 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2761268_wikidataid_q2761268
  • 72.23 kB
  • 10,386 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2761268_wikidataid_q2761268 (
  "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/Q2761402 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2761402_wikidataid_q2761402
  • 63.55 kB
  • 8,349 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2761402_wikidataid_q2761402 (
  "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/Q2767334 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2767334_wikidataid_q2767334
  • 50.11 kB
  • 6,226 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2767334_wikidataid_q2767334 (
  "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/Q2779121 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2779121_wikidataid_q2779121
  • 72.67 kB
  • 10,426 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2779121_wikidataid_q2779121 (
  "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/Q2788612 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2788612_wikidataid_q2788612
  • 49.13 kB
  • 6,061 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2788612_wikidataid_q2788612 (
  "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/Q2791960 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2791960_wikidataid_q2791960
  • 82.98 kB
  • 11,750 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2791960_wikidataid_q2791960 (
  "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/Q2795917 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2795917_wikidataid_q2795917
  • 73.16 kB
  • 10,500 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2795917_wikidataid_q2795917 (
  "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/Q2798652 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2798652_wikidataid_q2798652
  • 71.92 kB
  • 10,304 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2798652_wikidataid_q2798652 (
  "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/Q2799295 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2799295_wikidataid_q2799295
  • 63.23 kB
  • 8,361 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2799295_wikidataid_q2799295 (
  "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/Q2800993 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2800993_wikidataid_q2800993
  • 72.16 kB
  • 10,249 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2800993_wikidataid_q2800993 (
  "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/Q2801613 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2801613_wikidataid_q2801613
  • 71.83 kB
  • 10,341 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2801613_wikidataid_q2801613 (
  "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/Q2819654 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2819654_wikidataid_q2819654
  • 57.17 kB
  • 7,545 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2819654_wikidataid_q2819654 (
  "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/Q2819657 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2819657_wikidataid_q2819657
  • 58.84 kB
  • 7,081 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2819657_wikidataid_q2819657 (
  "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/Q2819667 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2819667_wikidataid_q2819667
  • 57.58 kB
  • 7,545 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2819667_wikidataid_q2819667 (
  "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/Q2819668 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2819668_wikidataid_q2819668
  • 54.45 kB
  • 7,081 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2819668_wikidataid_q2819668 (
  "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/Q2819670 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2819670_wikidataid_q2819670
  • 57.27 kB
  • 7,545 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2819670_wikidataid_q2819670 (
  "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/Q2819803 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2819803_wikidataid_q2819803
  • 54.42 kB
  • 7,081 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2819803_wikidataid_q2819803 (
  "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/Q2819850 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2819850_wikidataid_q2819850
  • 43.61 kB
  • 5,156 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2819850_wikidataid_q2819850 (
  "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/Q2819851 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2819851_wikidataid_q2819851
  • 57.06 kB
  • 7,081 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2819851_wikidataid_q2819851 (
  "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.