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

@datacommons.cities.wikidataid_q87956183_wikidataid_q87956183
  • 42.64 kB
  • 5,092 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q87956183_wikidataid_q87956183 (
  "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/Q88037774 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q88037774_wikidataid_q88037774
  • 60.75 kB
  • 7,925 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q88037774_wikidataid_q88037774 (
  "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/Q88211613 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q88211613_wikidataid_q88211613
  • 82.19 kB
  • 10,634 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q88211613_wikidataid_q88211613 (
  "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/Q88220438 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q88220438_wikidataid_q88220438
  • 76.1 kB
  • 10,634 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q88220438_wikidataid_q88220438 (
  "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/Q88296583 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q88296583_wikidataid_q88296583
  • 75.68 kB
  • 10,566 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q88296583_wikidataid_q88296583 (
  "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/Q88457230 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q88457230_wikidataid_q88457230
  • 51.26 kB
  • 6,337 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q88457230_wikidataid_q88457230 (
  "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/Q88537724 - Time Series For Statistical Variables

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

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

@datacommons.cities.wikidataid_q88631297_wikidataid_q88631297
  • 42.19 kB
  • 5,092 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q88631297_wikidataid_q88631297 (
  "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/Q88642584 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q88746787_wikidataid_q88746787
  • 52.07 kB
  • 6,506 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q88746787_wikidataid_q88746787 (
  "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/Q887858 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q887858_wikidataid_q887858
  • 42.07 kB
  • 5,311 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q887858_wikidataid_q887858 (
  "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/Q88975892 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q88975892_wikidataid_q88975892
  • 58.92 kB
  • 7,925 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q88975892_wikidataid_q88975892 (
  "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/Q88975942 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q88975942_wikidataid_q88975942
  • 59.46 kB
  • 7,925 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q88975942_wikidataid_q88975942 (
  "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/Q89020715 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q89021609_wikidataid_q89021609
  • 56.25 kB
  • 7,352 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q89021609_wikidataid_q89021609 (
  "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/Q89023121 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q89024924_wikidataid_q89024924
  • 47.15 kB
  • 5,691 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q89024924_wikidataid_q89024924 (
  "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/Q89027151 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q89206587_wikidataid_q89206587
  • 56.86 kB
  • 7,659 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q89206587_wikidataid_q89206587 (
  "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/Q89425316 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q89425316_wikidataid_q89425316
  • 10.56 kB
  • 80 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q89425316_wikidataid_q89425316 (
  "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/Q89572325 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q89572325_wikidataid_q89572325
  • 44.36 kB
  • 5,092 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q89572325_wikidataid_q89572325 (
  "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/Q9006599 - Time Series For Statistical Variables

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

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

@datacommons.cities.wikidataid_q9010230_wikidataid_q9010230
  • 50.56 kB
  • 6,336 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q9010230_wikidataid_q9010230 (
  "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.