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

@datacommons.cities.wikidataid_q12568388_wikidataid_q12568388
  • 87.72 kB
  • 14,274 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12568388_wikidataid_q12568388 (
  "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/Q12568626 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12568626_wikidataid_q12568626
  • 99.69 kB
  • 15,842 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12568626_wikidataid_q12568626 (
  "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/Q12568997 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q12569148_wikidataid_q12569148
  • 68.09 kB
  • 12,290 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12569148_wikidataid_q12569148 (
  "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/Q12569288 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12569288_wikidataid_q12569288
  • 98.66 kB
  • 15,559 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12569288_wikidataid_q12569288 (
  "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/Q12569520 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12569520_wikidataid_q12569520
  • 93.77 kB
  • 14,645 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12569520_wikidataid_q12569520 (
  "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/Q12569522 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12569522_wikidataid_q12569522
  • 95.98 kB
  • 15,062 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12569522_wikidataid_q12569522 (
  "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/Q12571390 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q12571796_wikidataid_q12571796
  • 100.66 kB
  • 15,980 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12571796_wikidataid_q12571796 (
  "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/Q12571804 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12571804_wikidataid_q12571804
  • 82.59 kB
  • 13,130 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12571804_wikidataid_q12571804 (
  "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/Q12571806 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12571806_wikidataid_q12571806
  • 97.08 kB
  • 15,423 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12571806_wikidataid_q12571806 (
  "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/Q1266611 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q1266611_wikidataid_q1266611
  • 83.28 kB
  • 13,535 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q1266611_wikidataid_q1266611 (
  "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/Q12680611 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12680611_wikidataid_q12680611
  • 77.91 kB
  • 10,425 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12680611_wikidataid_q12680611 (
  "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/Q1268459 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q1268459_wikidataid_q1268459
  • 84.6 kB
  • 13,614 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q1268459_wikidataid_q1268459 (
  "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/Q12720154 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12720154_wikidataid_q12720154
  • 35.17 kB
  • 4,357 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12720154_wikidataid_q12720154 (
  "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/Q12731572 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q12732033_wikidataid_q12732033
  • 28.02 kB
  • 3,050 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12732033_wikidataid_q12732033 (
  "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/Q12874581 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12874581_wikidataid_q12874581
  • 26.96 kB
  • 3,088 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12874581_wikidataid_q12874581 (
  "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/Q12881481 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12881481_wikidataid_q12881481
  • 52.2 kB
  • 6,474 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12881481_wikidataid_q12881481 (
  "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/Q12884102 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12884102_wikidataid_q12884102
  • 34.52 kB
  • 4,357 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12884102_wikidataid_q12884102 (
  "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/Q13146713 - Time Series For Statistical Variables

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

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

@datacommons.cities.wikidataid_q13147041_wikidataid_q13147041
  • 57.79 kB
  • 7,728 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q13147041_wikidataid_q13147041 (
  "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/Q13147845 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q13147845_wikidataid_q13147845
  • 57.46 kB
  • 7,492 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q13147845_wikidataid_q13147845 (
  "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/Q13148107 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q13148107_wikidataid_q13148107
  • 58.03 kB
  • 7,493 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q13148107_wikidataid_q13148107 (
  "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.