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

Xenia Township - Time Series For Statistical Variables

@datacommons.cities.xenia_township_geoid_3986786
  • 98.73 kB
  • 15,355 rows
  • 12 columns
Loading... 
CREATE TABLE xenia_township_geoid_3986786 (
  "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
);

Xiamen - Time Series For Statistical Variables

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

Xiangcheng City - Time Series For Statistical Variables

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

Xiangtan - Time Series For Statistical Variables

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

Xiangxiang - Time Series For Statistical Variables

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

Xiangyang - Time Series For Statistical Variables

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

Xianning - Time Series For Statistical Variables

@datacommons.cities.xianning_wikidataid_q71373
  • 4.75 MB
  • 553,147 rows
  • 12 columns
Loading... 
CREATE TABLE xianning_wikidataid_q71373 (
  "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
);

Xiantao City - Time Series For Statistical Variables

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

Xi'an - Time Series For Statistical Variables

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

Xianxi - Time Series For Statistical Variables

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

Xianyang - Time Series For Statistical Variables

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

Xiaogan - Time Series For Statistical Variables

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

Xiaoshangqiao - Time Series For Statistical Variables

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

Xiaoyi - Time Series For Statistical Variables

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

Xichang - Time Series For Statistical Variables

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

Xico - Time Series For Statistical Variables

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

Xihu - Time Series For Statistical Variables

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

Xihu - Time Series For Statistical Variables

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

Xikou - Time Series For Statistical Variables

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

Xilinhot - Time Series For Statistical Variables

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

Xilitla - Time Series For Statistical Variables

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

Xiluo Township - Time Series For Statistical Variables

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

Xincheng - Time Series For Statistical Variables

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

Xinfeng - Time Series For Statistical Variables

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

Xingang - Time Series For Statistical Variables

@datacommons.cities.xingang_wikidataid_q718212
  • 36.55 kB
  • 4,318 rows
  • 12 columns
Loading... 
CREATE TABLE xingang_wikidataid_q718212 (
  "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.