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

Xiulin - Time Series For Statistical Variables

@datacommons.cities.xiulin_wikidataid_q708004
  • 32.78 kB
  • 3,714 rows
  • 12 columns
Loading... 
CREATE TABLE xiulin_wikidataid_q708004 (
  "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
);

Xiushui - Time Series For Statistical Variables

@datacommons.cities.xiushui_wikidataid_q718437
  • 53.61 kB
  • 7,045 rows
  • 12 columns
Loading... 
CREATE TABLE xiushui_wikidataid_q718437 (
  "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
);

Xiyu - Time Series For Statistical Variables

@datacommons.cities.xiyu_wikidataid_q709034
  • 31.15 kB
  • 3,422 rows
  • 12 columns
Loading... 
CREATE TABLE xiyu_wikidataid_q709034 (
  "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
);

Xizhou - Time Series For Statistical Variables

@datacommons.cities.xizhou_wikidataid_q708820
  • 54.39 kB
  • 7,266 rows
  • 12 columns
Loading... 
CREATE TABLE xizhou_wikidataid_q708820 (
  "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
);

Xochihuehuetlán - Time Series For Statistical Variables

@datacommons.cities.xochihuehuetl_n_wikidataid_q3850273
  • 36.38 kB
  • 5,219 rows
  • 12 columns
Loading... 
CREATE TABLE xochihuehuetl_n_wikidataid_q3850273 (
  "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
);

Xochitlán Todos Santos - Time Series For Statistical Variables

@datacommons.cities.xochitl_n_todos_santos_undata_geo_c16801596
  • 9.32 kB
  • 1 row
  • 12 columns
Loading... 
CREATE TABLE xochitl_n_todos_santos_undata_geo_c16801596 (
  "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
);

Xo‘jayli - Time Series For Statistical Variables

@datacommons.cities.xo_jayli_wikidataid_q1400173
  • 53.35 kB
  • 6,677 rows
  • 12 columns
Loading... 
CREATE TABLE xo_jayli_wikidataid_q1400173 (
  "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
);

Xonobod - Time Series For Statistical Variables

@datacommons.cities.xonobod_wikidataid_q650208
  • 60.4 kB
  • 7,726 rows
  • 12 columns
Loading... 
CREATE TABLE xonobod_wikidataid_q650208 (
  "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
);

Xonqa - Time Series For Statistical Variables

@datacommons.cities.xonqa_wikidataid_q650699
  • 60.22 kB
  • 7,639 rows
  • 12 columns
Loading... 
CREATE TABLE xonqa_wikidataid_q650699 (
  "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
);

Xora - Time Series For Statistical Variables

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

Xoriguera - Time Series For Statistical Variables

@datacommons.cities.xoriguera_wikidataid_q67147295
  • 18.3 kB
  • 1,244 rows
  • 12 columns
Loading... 
CREATE TABLE xoriguera_wikidataid_q67147295 (
  "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
);

Xırdalan - Time Series For Statistical Variables

@datacommons.cities.x_rdalan_wikidataid_q642109
  • 57.87 kB
  • 7,489 rows
  • 12 columns
Loading... 
CREATE TABLE x_rdalan_wikidataid_q642109 (
  "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
);

Xuancheng - Time Series For Statistical Variables

@datacommons.cities.xuancheng_wikidataid_q360942
  • 4.79 MB
  • 554,327 rows
  • 12 columns
Loading... 
CREATE TABLE xuancheng_wikidataid_q360942 (
  "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
);

Xuanwei - Time Series For Statistical Variables

@datacommons.cities.xuanwei_wikidataid_q373629
  • 9.26 kB
  • 3 rows
  • 12 columns
Loading... 
CREATE TABLE xuanwei_wikidataid_q373629 (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" BIGINT,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

Xuchang - Time Series For Statistical Variables

@datacommons.cities.xuchang_wikidataid_q404529
  • 4.8 MB
  • 552,580 rows
  • 12 columns
Loading... 
CREATE TABLE xuchang_wikidataid_q404529 (
  "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
);

Xucheng, Jiangsu - Time Series For Statistical Variables

@datacommons.cities.xucheng_jiangsu_undata_geo_c07200026
  • 9.24 kB
  • 1 row
  • 12 columns
Loading... 
CREATE TABLE xucheng_jiangsu_undata_geo_c07200026 (
  "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
);

Xudun - Time Series For Statistical Variables

@datacommons.cities.xudun_wikidataid_q3388333
  • 9.3 kB
  • 1 row
  • 12 columns
Loading... 
CREATE TABLE xudun_wikidataid_q3388333 (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" BIGINT,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

Xuzhou - Time Series For Statistical Variables

@datacommons.cities.xuzhou_wikidataid_q57719
  • 4.82 MB
  • 557,087 rows
  • 12 columns
Loading... 
CREATE TABLE xuzhou_wikidataid_q57719 (
  "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
);

Xylokastro - Time Series For Statistical Variables

@datacommons.cities.xylokastro_wikidataid_q2248347
  • 12.83 kB
  • 399 rows
  • 12 columns
Loading... 
CREATE TABLE xylokastro_wikidataid_q2248347 (
  "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
);

Xızı - Time Series For Statistical Variables

@datacommons.cities.x_z_wikidataid_q2468528
  • 44.3 kB
  • 5,011 rows
  • 12 columns
Loading... 
CREATE TABLE x_z_wikidataid_q2468528 (
  "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
);

Yaak - Time Series For Statistical Variables

@datacommons.cities.yaak_geoid_3082130
  • 2.79 MB
  • 339,404 rows
  • 12 columns
Loading... 
CREATE TABLE yaak_geoid_3082130 (
  "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
);

Ya'an - Time Series For Statistical Variables

@datacommons.cities.ya_an_wikidataid_q427557
  • 4.77 MB
  • 556,154 rows
  • 12 columns
Loading... 
CREATE TABLE ya_an_wikidataid_q427557 (
  "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
);

Yaapeet - Time Series For Statistical Variables

@datacommons.cities.yaapeet_wikidataid_q8046313
  • 49.46 kB
  • 5,926 rows
  • 12 columns
Loading... 
CREATE TABLE yaapeet_wikidataid_q8046313 (
  "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
);

Ya'bad - Time Series For Statistical Variables

@datacommons.cities.ya_bad_wikidataid_q1828708
  • 44.28 kB
  • 6,049 rows
  • 12 columns
Loading... 
CREATE TABLE ya_bad_wikidataid_q1828708 (
  "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
);

Yabba North - Time Series For Statistical Variables

@datacommons.cities.yabba_north_wikidataid_q8046363
  • 56.75 kB
  • 7,294 rows
  • 12 columns
Loading... 
CREATE TABLE yabba_north_wikidataid_q8046363 (
  "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.