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

Zhanjiang - Time Series For Statistical Variables

@datacommons.cities.zhanjiang_wikidataid_q59144
  • 4.72 MB
  • 555,957 rows
  • 12 columns
Loading... 

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

Zhaodong - Time Series For Statistical Variables

@datacommons.cities.zhaodong_wikidataid_q197495
  • 9.46 kB
  • 5 rows
  • 12 columns
Loading... 

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

Zhaoqing - Time Series For Statistical Variables

@datacommons.cities.zhaoqing_wikidataid_q59164
  • 4.76 MB
  • 555,655 rows
  • 12 columns
Loading... 

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

Zhaotong - Time Series For Statistical Variables

@datacommons.cities.zhaotong_wikidataid_q197519
  • 4.74 MB
  • 556,093 rows
  • 12 columns
Loading... 

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

Zhaoyuan, Shandong - Time Series For Statistical Variables

@datacommons.cities.zhaoyuan_shandong_wikidataid_q197524
  • 49.89 kB
  • 6,132 rows
  • 12 columns
Loading... 

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

Zharkent - Time Series For Statistical Variables

@datacommons.cities.zharkent_wikidataid_q2231416
  • 74.39 kB
  • 10,045 rows
  • 12 columns
Loading... 

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

Zhdanivka - Time Series For Statistical Variables

@datacommons.cities.zhdanivka_wikidataid_q2354450
  • 66.67 kB
  • 8,010 rows
  • 12 columns
Loading... 

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

Zheleznogorsk-Ilimsky - Time Series For Statistical Variables

@datacommons.cities.zheleznogorsk_ilimsky_wikidataid_q135968
  • 21.16 kB
  • 1,681 rows
  • 12 columns
Loading... 

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

Zheleznogorsk - Time Series For Statistical Variables

@datacommons.cities.zheleznogorsk_wikidataid_q135869
  • 65.36 kB
  • 8,523 rows
  • 12 columns
Loading... 

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

Zheleznogorsk - Time Series For Statistical Variables

@datacommons.cities.zheleznogorsk_wikidataid_q72536
  • 9.5 kB
  • 1 row
  • 12 columns
Loading... 

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

Zheleznovodsk - Time Series For Statistical Variables

@datacommons.cities.zheleznovodsk_wikidataid_q135829
  • 63.27 kB
  • 8,519 rows
  • 12 columns
Loading... 

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

Zhem, Kazakhstan - Time Series For Statistical Variables

@datacommons.cities.zhem_kazakhstan_wikidataid_q4179248
  • 62.67 kB
  • 8,327 rows
  • 12 columns
Loading... 

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

Zhengzhou - Time Series For Statistical Variables

@datacommons.cities.zhengzhou_wikidataid_q30340
  • 4.81 MB
  • 557,457 rows
  • 12 columns
Loading... 

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

Zhenjiang - Time Series For Statistical Variables

@datacommons.cities.zhenjiang_wikidataid_q57958
  • 4.75 MB
  • 550,219 rows
  • 12 columns
Loading... 

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

Zherdevka - Time Series For Statistical Variables

@datacommons.cities.zherdevka_wikidataid_q136223
  • 46.86 kB
  • 5,746 rows
  • 12 columns
Loading... 

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

Zhetikara - Time Series For Statistical Variables

@datacommons.cities.zhetikara_wikidataid_q1018868
  • 44.03 kB
  • 4,774 rows
  • 12 columns
Loading... 

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

Zhetisay - Time Series For Statistical Variables

@datacommons.cities.zhetisay_wikidataid_q2378055
  • 56.24 kB
  • 7,133 rows
  • 12 columns
Loading... 

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

Zhigulyovsk - Time Series For Statistical Variables

@datacommons.cities.zhigulyovsk_wikidataid_q136310
  • 84.21 kB
  • 11,246 rows
  • 12 columns
Loading... 

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

Zhijiang - Time Series For Statistical Variables

@datacommons.cities.zhijiang_wikidataid_q197789
  • 53.61 kB
  • 5,773 rows
  • 12 columns
Loading... 

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

Zhirnovsk - Time Series For Statistical Variables

@datacommons.cities.zhirnovsk_wikidataid_q136361
  • 44.32 kB
  • 5,130 rows
  • 12 columns
Loading... 

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

Zhizdra - Time Series For Statistical Variables

@datacommons.cities.zhizdra_wikidataid_q136340
  • 29 kB
  • 2,939 rows
  • 12 columns
Loading... 

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

Zhmerynka - Time Series For Statistical Variables

@datacommons.cities.zhmerynka_wikidataid_q956117
  • 71.28 kB
  • 8,909 rows
  • 12 columns
Loading... 

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

Zhongliao - Time Series For Statistical Variables

@datacommons.cities.zhongliao_wikidataid_q713745
  • 54.9 kB
  • 7,386 rows
  • 12 columns
Loading... 

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

Zhongpu - Time Series For Statistical Variables

@datacommons.cities.zhongpu_wikidataid_q718221
  • 38.32 kB
  • 4,552 rows
  • 12 columns
Loading... 

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

Zhongshan - Time Series For Statistical Variables

@datacommons.cities.zhongshan_wikidataid_q59223
  • 4.78 MB
  • 555,553 rows
  • 12 columns
Loading... 

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