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

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

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

@datacommons.cities.wikidataid_q12387832_wikidataid_q12387832
  • 52.25 kB
  • 6,506 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12387832_wikidataid_q12387832 (
  "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/Q12387874 - Time Series For Statistical Variables

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

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

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

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

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

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

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

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

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

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

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

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

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

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

@datacommons.cities.wikidataid_q12388010_wikidataid_q12388010
  • 48.35 kB
  • 5,997 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12388010_wikidataid_q12388010 (
  "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/Q12388019 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q12388025_wikidataid_q12388025
  • 45.93 kB
  • 5,452 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12388025_wikidataid_q12388025 (
  "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/Q12388027 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q12388038_wikidataid_q12388038
  • 47.24 kB
  • 5,964 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12388038_wikidataid_q12388038 (
  "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/Q12388053 - Time Series For Statistical Variables

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

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

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