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

@datacommons.cities.wikidataid_q3084923_wikidataid_q3084923
  • 47.29 kB
  • 5,649 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q3084923_wikidataid_q3084923 (
  "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/Q30925791 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q30925791_wikidataid_q30925791
  • 62.9 kB
  • 8,225 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q30925791_wikidataid_q30925791 (
  "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/Q3094399 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q3094399_wikidataid_q3094399
  • 63.53 kB
  • 8,397 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q3094399_wikidataid_q3094399 (
  "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/Q3094556 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q3094556_wikidataid_q3094556
  • 55.63 kB
  • 7,236 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q3094556_wikidataid_q3094556 (
  "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/Q3098507 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q3098507_wikidataid_q3098507
  • 62.22 kB
  • 8,397 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q3098507_wikidataid_q3098507 (
  "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/Q31073747 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q31073747_wikidataid_q31073747
  • 66.33 kB
  • 9,372 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q31073747_wikidataid_q31073747 (
  "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/Q31073892 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q31073892_wikidataid_q31073892
  • 65.73 kB
  • 9,372 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q31073892_wikidataid_q31073892 (
  "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/Q3109440 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q3109440_wikidataid_q3109440
  • 51.2 kB
  • 6,535 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q3109440_wikidataid_q3109440 (
  "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/Q3111385 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q3111385_wikidataid_q3111385
  • 62.03 kB
  • 8,397 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q3111385_wikidataid_q3111385 (
  "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/Q3126323 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q3126323_wikidataid_q3126323
  • 40.26 kB
  • 4,953 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q3126323_wikidataid_q3126323 (
  "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/Q31281577 - Time Series For Statistical Variables

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

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

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

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

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

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

@datacommons.cities.wikidataid_q3136229_wikidataid_q3136229
  • 61.84 kB
  • 8,388 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q3136229_wikidataid_q3136229 (
  "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/Q3140961 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q31455237_wikidataid_q31455237
  • 92.16 kB
  • 13,747 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q31455237_wikidataid_q31455237 (
  "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/Q31455238 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q31455238_wikidataid_q31455238
  • 99.33 kB
  • 15,220 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q31455238_wikidataid_q31455238 (
  "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/Q31455249 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q31455249_wikidataid_q31455249
  • 100.02 kB
  • 15,884 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q31455249_wikidataid_q31455249 (
  "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/Q31455252 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q31455252_wikidataid_q31455252
  • 99.06 kB
  • 15,874 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q31455252_wikidataid_q31455252 (
  "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/Q31455253 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q31455253_wikidataid_q31455253
  • 98.68 kB
  • 15,879 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q31455253_wikidataid_q31455253 (
  "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/Q31455254 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q31455254_wikidataid_q31455254
  • 99.23 kB
  • 15,878 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q31455254_wikidataid_q31455254 (
  "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/Q31455255 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q31455255_wikidataid_q31455255
  • 100.05 kB
  • 15,895 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q31455255_wikidataid_q31455255 (
  "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.