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

@datacommons.cities.wikidataid_q12539468_wikidataid_q12539468
  • 104.58 kB
  • 15,502 rows
  • 12 columns
Loading...
CREATE TABLE wikidataid_q12539468_wikidataid_q12539468 (
  "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/Q12539515 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12539515_wikidataid_q12539515
  • 99.53 kB
  • 15,926 rows
  • 12 columns
Loading...
CREATE TABLE wikidataid_q12539515_wikidataid_q12539515 (
  "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/Q12540592 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12540592_wikidataid_q12540592
  • 93.34 kB
  • 14,872 rows
  • 12 columns
Loading...
CREATE TABLE wikidataid_q12540592_wikidataid_q12540592 (
  "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/Q12541055 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12541055_wikidataid_q12541055
  • 95.7 kB
  • 15,256 rows
  • 12 columns
Loading...
CREATE TABLE wikidataid_q12541055_wikidataid_q12541055 (
  "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/Q12541090 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12541090_wikidataid_q12541090
  • 98.65 kB
  • 15,837 rows
  • 12 columns
Loading...
CREATE TABLE wikidataid_q12541090_wikidataid_q12541090 (
  "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/Q12546631 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12546631_wikidataid_q12546631
  • 89.03 kB
  • 14,044 rows
  • 12 columns
Loading...
CREATE TABLE wikidataid_q12546631_wikidataid_q12546631 (
  "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/Q12547673 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12547673_wikidataid_q12547673
  • 86.31 kB
  • 14,048 rows
  • 12 columns
Loading...
CREATE TABLE wikidataid_q12547673_wikidataid_q12547673 (
  "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/Q12547674 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12547674_wikidataid_q12547674
  • 95.81 kB
  • 15,452 rows
  • 12 columns
Loading...
CREATE TABLE wikidataid_q12547674_wikidataid_q12547674 (
  "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/Q12548032 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12548032_wikidataid_q12548032
  • 81.39 kB
  • 13,487 rows
  • 12 columns
Loading...
CREATE TABLE wikidataid_q12548032_wikidataid_q12548032 (
  "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/Q12548033 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12548033_wikidataid_q12548033
  • 101.12 kB
  • 15,851 rows
  • 12 columns
Loading...
CREATE TABLE wikidataid_q12548033_wikidataid_q12548033 (
  "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/Q12549210 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12549210_wikidataid_q12549210
  • 93.06 kB
  • 14,904 rows
  • 12 columns
Loading...
CREATE TABLE wikidataid_q12549210_wikidataid_q12549210 (
  "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/Q12549229 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q12549482_wikidataid_q12549482
  • 92.03 kB
  • 14,429 rows
  • 12 columns
Loading...
CREATE TABLE wikidataid_q12549482_wikidataid_q12549482 (
  "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/Q12549498 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12549498_wikidataid_q12549498
  • 100.32 kB
  • 15,860 rows
  • 12 columns
Loading...
CREATE TABLE wikidataid_q12549498_wikidataid_q12549498 (
  "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/Q12549538 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12549538_wikidataid_q12549538
  • 54.37 kB
  • 10,486 rows
  • 12 columns
Loading...
CREATE TABLE wikidataid_q12549538_wikidataid_q12549538 (
  "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/Q12549868 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12549868_wikidataid_q12549868
  • 85.21 kB
  • 13,765 rows
  • 12 columns
Loading...
CREATE TABLE wikidataid_q12549868_wikidataid_q12549868 (
  "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/Q12551519 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12551519_wikidataid_q12551519
  • 103.22 kB
  • 14,825 rows
  • 12 columns
Loading...
CREATE TABLE wikidataid_q12551519_wikidataid_q12551519 (
  "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/Q12551520 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12551520_wikidataid_q12551520
  • 96.97 kB
  • 14,415 rows
  • 12 columns
Loading...
CREATE TABLE wikidataid_q12551520_wikidataid_q12551520 (
  "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/Q12551704 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12551704_wikidataid_q12551704
  • 90.84 kB
  • 14,539 rows
  • 12 columns
Loading...
CREATE TABLE wikidataid_q12551704_wikidataid_q12551704 (
  "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/Q12551744 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12551744_wikidataid_q12551744
  • 97.53 kB
  • 15,044 rows
  • 12 columns
Loading...
CREATE TABLE wikidataid_q12551744_wikidataid_q12551744 (
  "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/Q12551881 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q12551910_wikidataid_q12551910
  • 81.66 kB
  • 13,129 rows
  • 12 columns
Loading...
CREATE TABLE wikidataid_q12551910_wikidataid_q12551910 (
  "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/Q12551911 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12551911_wikidataid_q12551911
  • 102.6 kB
  • 15,884 rows
  • 12 columns
Loading...
CREATE TABLE wikidataid_q12551911_wikidataid_q12551911 (
  "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/Q12552054 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12552054_wikidataid_q12552054
  • 99.41 kB
  • 15,163 rows
  • 12 columns
Loading...
CREATE TABLE wikidataid_q12552054_wikidataid_q12552054 (
  "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/Q12552097 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12552097_wikidataid_q12552097
  • 96.69 kB
  • 15,244 rows
  • 12 columns
Loading...
CREATE TABLE wikidataid_q12552097_wikidataid_q12552097 (
  "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.