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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

@datacommons.cities.wikidataid_q20549173_wikidataid_q20549173
  • 52.37 kB
  • 6,670 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20549173_wikidataid_q20549173 (
  "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.