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

Zhongwei - Time Series For Statistical Variables

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

Zhongxiang City - Time Series For Statistical Variables

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

Záhony - Time Series For Statistical Variables

@datacommons.cities.z_hony_wikidataid_q246723
  • 71.47 kB
  • 8,290 rows
  • 12 columns
Loading... 
CREATE TABLE z_hony_wikidataid_q246723 (
  "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
);

Zhoukou - Time Series For Statistical Variables

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

Zhoushan - Time Series For Statistical Variables

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

Zhovkva - Time Series For Statistical Variables

@datacommons.cities.zhovkva_wikidataid_q864836
  • 74.95 kB
  • 9,009 rows
  • 12 columns
Loading... 
CREATE TABLE zhovkva_wikidataid_q864836 (
  "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
);

Zhovti Vody - Time Series For Statistical Variables

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

Zhuanghe - Time Series For Statistical Variables

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

Zhuangwei - Time Series For Statistical Variables

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

Zhubei - Time Series For Statistical Variables

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

Zhucheng - Time Series For Statistical Variables

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

Zhudong - Time Series For Statistical Variables

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

Zhuhai - Time Series For Statistical Variables

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

Zhuji - Time Series For Statistical Variables

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

Zhukovka - Time Series For Statistical Variables

@datacommons.cities.zhukovka_wikidataid_q136411
  • 71.61 kB
  • 8,953 rows
  • 12 columns
Loading... 
CREATE TABLE zhukovka_wikidataid_q136411 (
  "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
);

Zhukovsky - Time Series For Statistical Variables

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

Zhukov - Time Series For Statistical Variables

@datacommons.cities.zhukov_wikidataid_q136383
  • 33.16 kB
  • 2,936 rows
  • 12 columns
Loading... 
CREATE TABLE zhukov_wikidataid_q136383 (
  "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
);

Zhumadian - Time Series For Statistical Variables

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

Zhunan - Time Series For Statistical Variables

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

Zhuolan - Time Series For Statistical Variables

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

Zhuoxi - Time Series For Statistical Variables

@datacommons.cities.zhuoxi_wikidataid_q708017
  • 27.36 kB
  • 2,728 rows
  • 12 columns
Loading... 
CREATE TABLE zhuoxi_wikidataid_q708017 (
  "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
);

Zhuozhou - Time Series For Statistical Variables

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

Zhuqi - Time Series For Statistical Variables

@datacommons.cities.zhuqi_wikidataid_q718362
  • 37.95 kB
  • 4,555 rows
  • 12 columns
Loading... 
CREATE TABLE zhuqi_wikidataid_q718362 (
  "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
);

Zhushan - Time Series For Statistical Variables

@datacommons.cities.zhushan_wikidataid_q708400
  • 37.54 kB
  • 4,555 rows
  • 12 columns
Loading... 
CREATE TABLE zhushan_wikidataid_q708400 (
  "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
);

Zhutang - Time Series For Statistical Variables

@datacommons.cities.zhutang_wikidataid_q718340
  • 52.3 kB
  • 6,904 rows
  • 12 columns
Loading... 
CREATE TABLE zhutang_wikidataid_q718340 (
  "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.