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

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

@datacommons.cities.wikidataid_q12402280_wikidataid_q12402280
  • 54.14 kB
  • 7,012 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12402280_wikidataid_q12402280 (
  "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/Q12402287 - Time Series For Statistical Variables

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

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

@datacommons.cities.wikidataid_q12402311_wikidataid_q12402311
  • 53 kB
  • 6,670 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12402311_wikidataid_q12402311 (
  "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/Q12402324 - Time Series For Statistical Variables

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

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

@datacommons.cities.wikidataid_q12402349_wikidataid_q12402349
  • 51.71 kB
  • 6,162 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12402349_wikidataid_q12402349 (
  "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/Q12402351 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12402351_wikidataid_q12402351
  • 59.6 kB
  • 8,054 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12402351_wikidataid_q12402351 (
  "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/Q12402355 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12402355_wikidataid_q12402355
  • 51.81 kB
  • 6,503 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12402355_wikidataid_q12402355 (
  "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/Q12402358 - Time Series For Statistical Variables

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

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

@datacommons.cities.wikidataid_q12402370_wikidataid_q12402370
  • 59.96 kB
  • 8,054 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12402370_wikidataid_q12402370 (
  "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/Q12402408 - Time Series For Statistical Variables

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

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

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

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

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

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

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

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

@datacommons.cities.wikidataid_q12402574_wikidataid_q12402574
  • 52.86 kB
  • 6,670 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12402574_wikidataid_q12402574 (
  "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/Q12402605 - Time Series For Statistical Variables

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

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

@datacommons.cities.wikidataid_q12402694_wikidataid_q12402694
  • 54.28 kB
  • 7,012 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12402694_wikidataid_q12402694 (
  "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.