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

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

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

@datacommons.cities.wikidataid_q20545794_wikidataid_q20545794
  • 55.28 kB
  • 7,116 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20545794_wikidataid_q20545794 (
  "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/Q20545807 - Time Series For Statistical Variables

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

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

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

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

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

@datacommons.cities.wikidataid_q20545879_wikidataid_q20545879
  • 50.79 kB
  • 6,337 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20545879_wikidataid_q20545879 (
  "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/Q20545893 - Time Series For Statistical Variables

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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