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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

@datacommons.cities.wikidataid_q20545064_wikidataid_q20545064
  • 58.73 kB
  • 6,730 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20545064_wikidataid_q20545064 (
  "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/Q20545077 - Time Series For Statistical Variables

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

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

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

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

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

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

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

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

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

@datacommons.cities.wikidataid_q20545284_wikidataid_q20545284
  • 59.42 kB
  • 7,012 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20545284_wikidataid_q20545284 (
  "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.