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

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

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

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

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

@datacommons.cities.wikidataid_q12390191_wikidataid_q12390191
  • 53.45 kB
  • 6,741 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12390191_wikidataid_q12390191 (
  "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/Q12390192 - Time Series For Statistical Variables

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

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

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

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

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

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

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

@datacommons.cities.wikidataid_q12390272_wikidataid_q12390272
  • 55.04 kB
  • 7,124 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12390272_wikidataid_q12390272 (
  "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/Q12390273 - Time Series For Statistical Variables

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

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

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

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

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

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

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

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

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

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

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

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