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

Yurihama - Time Series For Statistical Variables

@datacommons.cities.yurihama_wikidataid_q1156158
  • 60.46 kB
  • 7,632 rows
  • 12 columns
Loading... 

CREATE TABLE yurihama_wikidataid_q1156158 (
  "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
);

Yurihonjō - Time Series For Statistical Variables

@datacommons.cities.yurihonj_wikidataid_q602903
  • 61.39 kB
  • 7,800 rows
  • 12 columns
Loading... 

CREATE TABLE yurihonj_wikidataid_q602903 (
  "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
);

Yurimaguas - Time Series For Statistical Variables

@datacommons.cities.yurimaguas_wikidataid_q117625
  • 43.14 kB
  • 4,724 rows
  • 12 columns
Loading... 

CREATE TABLE yurimaguas_wikidataid_q117625 (
  "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
);

Yurtbaşı - Time Series For Statistical Variables

@datacommons.cities.yurtba_wikidataid_q5250167
  • 44.15 kB
  • 5,317 rows
  • 12 columns
Loading... 

CREATE TABLE yurtba_wikidataid_q5250167 (
  "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
);

Yuryevets - Time Series For Statistical Variables

@datacommons.cities.yuryevets_wikidataid_q198834
  • 56.66 kB
  • 7,341 rows
  • 12 columns
Loading... 

CREATE TABLE yuryevets_wikidataid_q198834 (
  "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
);

Yuryev-Polsky - Time Series For Statistical Variables

@datacommons.cities.yuryev_polsky_wikidataid_q198826
  • 9.61 kB
  • 1 row
  • 12 columns
Loading... 

CREATE TABLE yuryev_polsky_wikidataid_q198826 (
  "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
);

Yuryuzan - Time Series For Statistical Variables

@datacommons.cities.yuryuzan_wikidataid_q198842
  • 45.66 kB
  • 5,446 rows
  • 12 columns
Loading... 

CREATE TABLE yuryuzan_wikidataid_q198842 (
  "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
);

Yuscarán - Time Series For Statistical Variables

@datacommons.cities.yuscar_n_wikidataid_q1729098
  • 45.79 kB
  • 5,673 rows
  • 12 columns
Loading... 

CREATE TABLE yuscar_n_wikidataid_q1729098 (
  "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
);

Yusefabad - Time Series For Statistical Variables

@datacommons.cities.yusefabad_wikidataid_q16727067
  • 9.49 kB
  • 1 row
  • 12 columns
Loading... 

CREATE TABLE yusefabad_wikidataid_q16727067 (
  "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
);

Yushu City - Time Series For Statistical Variables

@datacommons.cities.yushu_city_wikidataid_q1026088
  • 57.36 kB
  • 7,467 rows
  • 12 columns
Loading... 

CREATE TABLE yushu_city_wikidataid_q1026088 (
  "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
);

Yushu - Time Series For Statistical Variables

@datacommons.cities.yushu_wikidataid_q1022251
  • 9.48 kB
  • 4 rows
  • 12 columns
Loading... 

CREATE TABLE yushu_wikidataid_q1022251 (
  "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
);

Yusuhara - Time Series For Statistical Variables

@datacommons.cities.yusuhara_wikidataid_q1206286
  • 49.14 kB
  • 6,098 rows
  • 12 columns
Loading... 

CREATE TABLE yusuhara_wikidataid_q1206286 (
  "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
);

Yutan - Time Series For Statistical Variables

@datacommons.cities.yutan_geoid_3154115
  • 2.96 MB
  • 347,241 rows
  • 12 columns
Loading... 

CREATE TABLE yutan_geoid_3154115 (
  "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
);

Yuty - Time Series For Statistical Variables

@datacommons.cities.yuty_wikidataid_q2475423
  • 25.3 kB
  • 2,242 rows
  • 12 columns
Loading... 

CREATE TABLE yuty_wikidataid_q2475423 (
  "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
);

Yuxi - Time Series For Statistical Variables

@datacommons.cities.yuxi_wikidataid_q496496
  • 4.79 MB
  • 551,872 rows
  • 12 columns
Loading... 

CREATE TABLE yuxi_wikidataid_q496496 (
  "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
);

Yuyao City - Time Series For Statistical Variables

@datacommons.cities.yuyao_city_wikidataid_q1011201
  • 35.52 kB
  • 4,087 rows
  • 12 columns
Loading... 

CREATE TABLE yuyao_city_wikidataid_q1011201 (
  "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
);

Yuzawa - Time Series For Statistical Variables

@datacommons.cities.yuzawa_wikidataid_q1204269
  • 10.74 kB
  • 112 rows
  • 12 columns
Loading... 

CREATE TABLE yuzawa_wikidataid_q1204269 (
  "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
);

Yuzawa - Time Series For Statistical Variables

@datacommons.cities.yuzawa_wikidataid_q633272
  • 47.64 kB
  • 5,682 rows
  • 12 columns
Loading... 

CREATE TABLE yuzawa_wikidataid_q633272 (
  "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
);

Yuza - Time Series For Statistical Variables

@datacommons.cities.yuza_wikidataid_q1347481
  • 65.77 kB
  • 7,758 rows
  • 12 columns
Loading... 

CREATE TABLE yuza_wikidataid_q1347481 (
  "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
);

Yuzhne - Time Series For Statistical Variables

@datacommons.cities.yuzhne_wikidataid_q586710
  • 83.07 kB
  • 11,015 rows
  • 12 columns
Loading... 

CREATE TABLE yuzhne_wikidataid_q586710 (
  "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
);

Yuzhno-Sakhalinsk - Time Series For Statistical Variables

@datacommons.cities.yuzhno_sakhalinsk_wikidataid_q7859
  • 73.04 kB
  • 9,461 rows
  • 12 columns
Loading... 

CREATE TABLE yuzhno_sakhalinsk_wikidataid_q7859 (
  "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
);

Yuzhno-Sukhokumsk - Time Series For Statistical Variables

@datacommons.cities.yuzhno_sukhokumsk_wikidataid_q198816
  • 32.1 kB
  • 3,532 rows
  • 12 columns
Loading... 

CREATE TABLE yuzhno_sukhokumsk_wikidataid_q198816 (
  "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
);

Yuzhnoukrainsk - Time Series For Statistical Variables

@datacommons.cities.yuzhnoukrainsk_wikidataid_q1013568
  • 50.88 kB
  • 6,193 rows
  • 12 columns
Loading... 

CREATE TABLE yuzhnoukrainsk_wikidataid_q1013568 (
  "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
);

Yuzhnouralsk - Time Series For Statistical Variables

@datacommons.cities.yuzhnouralsk_wikidataid_q198820
  • 69.77 kB
  • 8,961 rows
  • 12 columns
Loading... 

CREATE TABLE yuzhnouralsk_wikidataid_q198820 (
  "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
);

Yuzhou - Time Series For Statistical Variables

@datacommons.cities.yuzhou_wikidataid_q1344848
  • 26.08 kB
  • 2,430 rows
  • 12 columns
Loading... 

CREATE TABLE yuzhou_wikidataid_q1344848 (
  "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.