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

@datacommons.cities.wikidataid_q16508510_wikidataid_q16508510
  • 47.68 kB
  • 5,701 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q16508510_wikidataid_q16508510 (
  "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/Q16509748 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q16509748_wikidataid_q16509748
  • 39.44 kB
  • 4,953 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q16509748_wikidataid_q16509748 (
  "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/Q16509800 - Time Series For Statistical Variables

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

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

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

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

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

@datacommons.cities.wikidataid_q16517618_wikidataid_q16517618
  • 55.42 kB
  • 6,879 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q16517618_wikidataid_q16517618 (
  "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/Q1652016 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q1652016_wikidataid_q1652016
  • 48.35 kB
  • 5,828 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q1652016_wikidataid_q1652016 (
  "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/Q16544329 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q16544329_wikidataid_q16544329
  • 13.61 kB
  • 463 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q16544329_wikidataid_q16544329 (
  "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/Q16628307 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q16628307_wikidataid_q16628307
  • 62.67 kB
  • 8,679 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q16628307_wikidataid_q16628307 (
  "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/Q16645100 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q16645100_wikidataid_q16645100
  • 48.72 kB
  • 6,712 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q16645100_wikidataid_q16645100 (
  "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/Q16676721 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q17043531_wikidataid_q17043531
  • 59.65 kB
  • 7,698 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q17043531_wikidataid_q17043531 (
  "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/Q170971 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q170971_wikidataid_q170971
  • 44.56 kB
  • 5,411 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q170971_wikidataid_q170971 (
  "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/Q171065 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q171065_wikidataid_q171065
  • 33.54 kB
  • 3,965 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q171065_wikidataid_q171065 (
  "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/Q17173916 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q17173916_wikidataid_q17173916
  • 34.76 kB
  • 3,982 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q17173916_wikidataid_q17173916 (
  "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/Q17280261 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q17280261_wikidataid_q17280261
  • 12.03 kB
  • 392 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q17280261_wikidataid_q17280261 (
  "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/Q1739042 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q1742031_wikidataid_q1742031
  • 88.2 kB
  • 15,067 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q1742031_wikidataid_q1742031 (
  "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/Q17584270 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q17584270_wikidataid_q17584270
  • 35.19 kB
  • 3,752 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q17584270_wikidataid_q17584270 (
  "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/Q17584302 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q17584302_wikidataid_q17584302
  • 16.16 kB
  • 895 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q17584302_wikidataid_q17584302 (
  "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/Q17586994 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q17586994_wikidataid_q17586994
  • 66.83 kB
  • 8,817 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q17586994_wikidataid_q17586994 (
  "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/Q1797552 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q1797552_wikidataid_q1797552
  • 30.36 kB
  • 3,055 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q1797552_wikidataid_q1797552 (
  "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/Q17991156 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q17991156_wikidataid_q17991156
  • 32.66 kB
  • 3,612 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q17991156_wikidataid_q17991156 (
  "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.