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

@datacommons.cities.wikidataid_q60054250_wikidataid_q60054250
  • 16.26 kB
  • 952 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q60054250_wikidataid_q60054250 (
  "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/Q6005686 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6005686_wikidataid_q6005686
  • 53.96 kB
  • 6,722 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6005686_wikidataid_q6005686 (
  "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/Q6018078 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6018078_wikidataid_q6018078
  • 53.34 kB
  • 6,903 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6018078_wikidataid_q6018078 (
  "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/Q6022439 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6022439_wikidataid_q6022439
  • 41.95 kB
  • 4,718 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6022439_wikidataid_q6022439 (
  "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/Q6026356 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6026356_wikidataid_q6026356
  • 51.58 kB
  • 7,334 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6026356_wikidataid_q6026356 (
  "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/Q6026515 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6026515_wikidataid_q6026515
  • 102.17 kB
  • 15,632 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6026515_wikidataid_q6026515 (
  "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/Q6026520 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6026520_wikidataid_q6026520
  • 79.28 kB
  • 13,473 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6026520_wikidataid_q6026520 (
  "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/Q6026524 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6026524_wikidataid_q6026524
  • 72.98 kB
  • 13,039 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6026524_wikidataid_q6026524 (
  "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/Q6026527 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6026527_wikidataid_q6026527
  • 93.59 kB
  • 15,633 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6026527_wikidataid_q6026527 (
  "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/Q6026537 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6026537_wikidataid_q6026537
  • 92.88 kB
  • 15,634 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6026537_wikidataid_q6026537 (
  "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/Q6026548 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6026548_wikidataid_q6026548
  • 75.07 kB
  • 12,472 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6026548_wikidataid_q6026548 (
  "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/Q6026551 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6026551_wikidataid_q6026551
  • 86.99 kB
  • 13,472 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6026551_wikidataid_q6026551 (
  "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/Q6026557 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6026557_wikidataid_q6026557
  • 93.64 kB
  • 15,219 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6026557_wikidataid_q6026557 (
  "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/Q6026560 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6026560_wikidataid_q6026560
  • 93.96 kB
  • 15,631 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6026560_wikidataid_q6026560 (
  "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/Q6026563 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6026563_wikidataid_q6026563
  • 99.11 kB
  • 15,634 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6026563_wikidataid_q6026563 (
  "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/Q6026565 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6026565_wikidataid_q6026565
  • 80.13 kB
  • 13,472 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6026565_wikidataid_q6026565 (
  "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/Q6026573 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6026573_wikidataid_q6026573
  • 80.98 kB
  • 13,473 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6026573_wikidataid_q6026573 (
  "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/Q6026576 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6026576_wikidataid_q6026576
  • 73.91 kB
  • 13,039 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6026576_wikidataid_q6026576 (
  "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/Q6026579 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6026579_wikidataid_q6026579
  • 94.44 kB
  • 15,633 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6026579_wikidataid_q6026579 (
  "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/Q6026582 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6026582_wikidataid_q6026582
  • 93.77 kB
  • 15,634 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6026582_wikidataid_q6026582 (
  "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/Q6026585 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6026585_wikidataid_q6026585
  • 81.24 kB
  • 13,472 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6026585_wikidataid_q6026585 (
  "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/Q6026594 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6026594_wikidataid_q6026594
  • 84.53 kB
  • 14,307 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6026594_wikidataid_q6026594 (
  "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/Q6026599 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6026599_wikidataid_q6026599
  • 91.12 kB
  • 14,951 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6026599_wikidataid_q6026599 (
  "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/Q6026603 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6026603_wikidataid_q6026603
  • 77.92 kB
  • 13,344 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6026603_wikidataid_q6026603 (
  "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/Q6026606 - Time Series For Statistical Variables

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