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

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

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

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

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

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

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

@datacommons.cities.wikidataid_q12402714_wikidataid_q12402714
  • 55.48 kB
  • 7,124 rows
  • 12 columns
Loading...
CREATE TABLE wikidataid_q12402714_wikidataid_q12402714 (
  "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/Q12402734 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q12402977_wikidataid_q12402977
  • 57.41 kB
  • 7,659 rows
  • 12 columns
Loading...
CREATE TABLE wikidataid_q12402977_wikidataid_q12402977 (
  "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/Q12402994 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12402994_wikidataid_q12402994
  • 57.64 kB
  • 7,021 rows
  • 12 columns
Loading...
CREATE TABLE wikidataid_q12402994_wikidataid_q12402994 (
  "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/Q12402997 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12402997_wikidataid_q12402997
  • 48.15 kB
  • 5,997 rows
  • 12 columns
Loading...
CREATE TABLE wikidataid_q12402997_wikidataid_q12402997 (
  "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/Q12403002 - Time Series For Statistical Variables

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

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

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

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

@datacommons.cities.wikidataid_q12530186_wikidataid_q12530186
  • 100.14 kB
  • 15,795 rows
  • 12 columns
Loading...
CREATE TABLE wikidataid_q12530186_wikidataid_q12530186 (
  "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/Q12535419 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12535419_wikidataid_q12535419
  • 99.22 kB
  • 15,724 rows
  • 12 columns
Loading...
CREATE TABLE wikidataid_q12535419_wikidataid_q12535419 (
  "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/Q12535762 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12535762_wikidataid_q12535762
  • 95.48 kB
  • 15,251 rows
  • 12 columns
Loading...
CREATE TABLE wikidataid_q12535762_wikidataid_q12535762 (
  "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/Q12536050 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12536050_wikidataid_q12536050
  • 99.13 kB
  • 15,713 rows
  • 12 columns
Loading...
CREATE TABLE wikidataid_q12536050_wikidataid_q12536050 (
  "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/Q12536243 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12536243_wikidataid_q12536243
  • 81.05 kB
  • 13,006 rows
  • 12 columns
Loading...
CREATE TABLE wikidataid_q12536243_wikidataid_q12536243 (
  "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/Q12536268 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12536268_wikidataid_q12536268
  • 98.77 kB
  • 15,824 rows
  • 12 columns
Loading...
CREATE TABLE wikidataid_q12536268_wikidataid_q12536268 (
  "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/Q12537795 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12537795_wikidataid_q12537795
  • 107.81 kB
  • 15,639 rows
  • 12 columns
Loading...
CREATE TABLE wikidataid_q12537795_wikidataid_q12537795 (
  "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/Q12538082 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12538082_wikidataid_q12538082
  • 101.89 kB
  • 15,979 rows
  • 12 columns
Loading...
CREATE TABLE wikidataid_q12538082_wikidataid_q12538082 (
  "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/Q12538332 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12538332_wikidataid_q12538332
  • 98.99 kB
  • 15,750 rows
  • 12 columns
Loading...
CREATE TABLE wikidataid_q12538332_wikidataid_q12538332 (
  "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/Q12538663 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12538663_wikidataid_q12538663
  • 94.06 kB
  • 14,794 rows
  • 12 columns
Loading...
CREATE TABLE wikidataid_q12538663_wikidataid_q12538663 (
  "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.