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

@datacommons.cities.wikidataid_q20485501_wikidataid_q20485501
  • 98.57 kB
  • 14,674 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20485501_wikidataid_q20485501 (
  "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/Q20485512 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q20485512_wikidataid_q20485512
  • 82.09 kB
  • 13,305 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20485512_wikidataid_q20485512 (
  "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/Q20485544 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q20485544_wikidataid_q20485544
  • 97.08 kB
  • 14,897 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20485544_wikidataid_q20485544 (
  "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/Q20485548 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q20485548_wikidataid_q20485548
  • 92.86 kB
  • 14,894 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20485548_wikidataid_q20485548 (
  "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/Q20485550 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q20485665_wikidataid_q20485665
  • 92.59 kB
  • 14,398 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20485665_wikidataid_q20485665 (
  "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/Q20485693 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q20485693_wikidataid_q20485693
  • 87.26 kB
  • 14,215 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20485693_wikidataid_q20485693 (
  "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/Q20485695 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q20485695_wikidataid_q20485695
  • 95.59 kB
  • 15,064 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20485695_wikidataid_q20485695 (
  "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/Q20485731 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q20485731_wikidataid_q20485731
  • 96.64 kB
  • 15,016 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20485731_wikidataid_q20485731 (
  "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/Q20485756 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q20485756_wikidataid_q20485756
  • 66.52 kB
  • 12,093 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20485756_wikidataid_q20485756 (
  "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/Q20485825 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q20485825_wikidataid_q20485825
  • 93.28 kB
  • 14,020 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20485825_wikidataid_q20485825 (
  "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/Q20485844 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q20485844_wikidataid_q20485844
  • 87.35 kB
  • 12,977 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20485844_wikidataid_q20485844 (
  "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/Q20485881 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q20485881_wikidataid_q20485881
  • 93.44 kB
  • 13,820 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20485881_wikidataid_q20485881 (
  "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/Q20485886 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q20485886_wikidataid_q20485886
  • 77.03 kB
  • 13,589 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20485886_wikidataid_q20485886 (
  "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/Q20485895 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q20485895_wikidataid_q20485895
  • 97.69 kB
  • 15,157 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20485895_wikidataid_q20485895 (
  "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/Q20485900 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q20485900_wikidataid_q20485900
  • 98.18 kB
  • 15,709 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20485900_wikidataid_q20485900 (
  "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/Q20485950 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q20485950_wikidataid_q20485950
  • 99.26 kB
  • 15,828 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20485950_wikidataid_q20485950 (
  "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/Q20485981 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q20485981_wikidataid_q20485981
  • 90.67 kB
  • 14,394 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20485981_wikidataid_q20485981 (
  "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/Q20485984 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q20485984_wikidataid_q20485984
  • 91.83 kB
  • 14,666 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20485984_wikidataid_q20485984 (
  "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/Q20486033 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q20486033_wikidataid_q20486033
  • 103.41 kB
  • 15,753 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20486033_wikidataid_q20486033 (
  "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/Q20486037 - Time Series For Statistical Variables

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

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

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

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

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