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

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

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

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

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

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

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

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

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

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

@datacommons.cities.wikidataid_q20542764_wikidataid_q20542764
  • 50.67 kB
  • 6,162 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20542764_wikidataid_q20542764 (
  "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/Q20542773 - Time Series For Statistical Variables

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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