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

@datacommons.cities.wikidataid_q24004051_wikidataid_q24004051
  • 53.55 kB
  • 6,974 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q24004051_wikidataid_q24004051 (
  "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/Q24004465 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q24009550_wikidataid_q24009550
  • 9.72 kB
  • 39 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q24009550_wikidataid_q24009550 (
  "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/Q24012343 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q2413665_wikidataid_q2413665
  • 57.54 kB
  • 6,163 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2413665_wikidataid_q2413665 (
  "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/Q2426780 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2426780_wikidataid_q2426780
  • 49.24 kB
  • 5,783 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2426780_wikidataid_q2426780 (
  "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/Q2429820 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2429820_wikidataid_q2429820
  • 63.4 kB
  • 8,345 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2429820_wikidataid_q2429820 (
  "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/Q2432303 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2432303_wikidataid_q2432303
  • 72.14 kB
  • 10,287 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2432303_wikidataid_q2432303 (
  "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/Q2439669 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2439669_wikidataid_q2439669
  • 63.66 kB
  • 8,398 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2439669_wikidataid_q2439669 (
  "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/Q2440196 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q2441356_wikidataid_q2441356
  • 64.39 kB
  • 8,537 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2441356_wikidataid_q2441356 (
  "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/Q2441798 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2441798_wikidataid_q2441798
  • 91.92 kB
  • 11,715 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2441798_wikidataid_q2441798 (
  "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/Q2454250 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2454250_wikidataid_q2454250
  • 72.37 kB
  • 10,356 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2454250_wikidataid_q2454250 (
  "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/Q2454964 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2454964_wikidataid_q2454964
  • 46.74 kB
  • 5,667 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2454964_wikidataid_q2454964 (
  "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/Q2456823 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2456823_wikidataid_q2456823
  • 66.15 kB
  • 8,279 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2456823_wikidataid_q2456823 (
  "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/Q2466767 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2466767_wikidataid_q2466767
  • 45.96 kB
  • 5,275 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2466767_wikidataid_q2466767 (
  "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/Q2471667 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2471667_wikidataid_q2471667
  • 53.09 kB
  • 6,793 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2471667_wikidataid_q2471667 (
  "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/Q2480902 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2480902_wikidataid_q2480902
  • 63.58 kB
  • 8,343 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2480902_wikidataid_q2480902 (
  "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/Q2487864 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q2501372_wikidataid_q2501372
  • 40.5 kB
  • 4,674 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2501372_wikidataid_q2501372 (
  "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/Q2506946 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2506946_wikidataid_q2506946
  • 72.72 kB
  • 10,264 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2506946_wikidataid_q2506946 (
  "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/Q2509173 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2509173_wikidataid_q2509173
  • 61.75 kB
  • 7,944 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2509173_wikidataid_q2509173 (
  "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/Q2509444 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2509444_wikidataid_q2509444
  • 83.02 kB
  • 11,692 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2509444_wikidataid_q2509444 (
  "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/Q2512230 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2512230_wikidataid_q2512230
  • 41.37 kB
  • 4,763 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2512230_wikidataid_q2512230 (
  "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/Q2516470 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2516470_wikidataid_q2516470
  • 72.21 kB
  • 10,416 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2516470_wikidataid_q2516470 (
  "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.