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

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

@datacommons.cities.wikidataid_q5728762_wikidataid_q5728762
  • 44.49 kB
  • 5,329 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q5728762_wikidataid_q5728762 (
  "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/Q57338438 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q57338438_wikidataid_q57338438
  • 47.05 kB
  • 5,690 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q57338438_wikidataid_q57338438 (
  "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/Q57414747 - Time Series For Statistical Variables

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

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

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

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

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

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

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

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

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

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

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

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

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

@datacommons.cities.wikidataid_q5755804_wikidataid_q5755804
  • 41.14 kB
  • 4,806 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q5755804_wikidataid_q5755804 (
  "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/Q5755819 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q5755819_wikidataid_q5755819
  • 16.47 kB
  • 915 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q5755819_wikidataid_q5755819 (
  "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/Q57558650 - Time Series For Statistical Variables

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

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

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

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

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

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

@datacommons.cities.wikidataid_q57594300_wikidataid_q57594300
  • 59.33 kB
  • 7,925 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q57594300_wikidataid_q57594300 (
  "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.