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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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