Baselight

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

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

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

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

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

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

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

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

@datacommons.cities.wikidataid_q6344000_wikidataid_q6344000
  • 46.11 kB
  • 5,629 rows
  • 12 columns
Loading...
CREATE TABLE wikidataid_q6344000_wikidataid_q6344000 (
  "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/Q63441503 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q6356825_wikidataid_q6356825
  • 45.47 kB
  • 5,713 rows
  • 12 columns
Loading...
CREATE TABLE wikidataid_q6356825_wikidataid_q6356825 (
  "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/Q63586980 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q63586980_wikidataid_q63586980
  • 50.84 kB
  • 6,531 rows
  • 12 columns
Loading...
CREATE TABLE wikidataid_q63586980_wikidataid_q63586980 (
  "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/Q63884249 - Time Series For Statistical Variables

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

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

@datacommons.cities.wikidataid_q63922537_wikidataid_q63922537
  • 56.12 kB
  • 7,351 rows
  • 12 columns
Loading...
CREATE TABLE wikidataid_q63922537_wikidataid_q63922537 (
  "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/Q63927881 - Time Series For Statistical Variables

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

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

@datacommons.cities.wikidataid_q64007639_wikidataid_q64007639
  • 58.75 kB
  • 7,990 rows
  • 12 columns
Loading...
CREATE TABLE wikidataid_q64007639_wikidataid_q64007639 (
  "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/Q640157 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q640157_wikidataid_q640157
  • 52.76 kB
  • 6,338 rows
  • 12 columns
Loading...
CREATE TABLE wikidataid_q640157_wikidataid_q640157 (
  "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/Q6407394 - Time Series For Statistical Variables

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

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

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

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

@datacommons.cities.wikidataid_q6459366_wikidataid_q6459366
  • 42.5 kB
  • 5,180 rows
  • 12 columns
Loading...
CREATE TABLE wikidataid_q6459366_wikidataid_q6459366 (
  "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/Q64697794 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q64697794_wikidataid_q64697794
  • 56.8 kB
  • 7,648 rows
  • 12 columns
Loading...
CREATE TABLE wikidataid_q64697794_wikidataid_q64697794 (
  "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/Q65061553 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q65061553_wikidataid_q65061553
  • 42.09 kB
  • 5,092 rows
  • 12 columns
Loading...
CREATE TABLE wikidataid_q65061553_wikidataid_q65061553 (
  "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.