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

Xingcheng - Time Series For Statistical Variables

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

Xinghua - Time Series For Statistical Variables

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

Xingning - Time Series For Statistical Variables

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

Xingping - Time Series For Statistical Variables

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

Xingren - Time Series For Statistical Variables

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

Xingtai - Time Series For Statistical Variables

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

Xingyang - Time Series For Statistical Variables

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

Xingyi - Time Series For Statistical Variables

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

Xining - Time Series For Statistical Variables

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

Xinji - Time Series For Statistical Variables

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

Xinle City - Time Series For Statistical Variables

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

Xinmin - Time Series For Statistical Variables

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

Xinmi - Time Series For Statistical Variables

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

Xinpu - Time Series For Statistical Variables

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

Xintai - Time Series For Statistical Variables

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

Xinxiang - Time Series For Statistical Variables

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

Xinyang - Time Series For Statistical Variables

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

Xinyi - Time Series For Statistical Variables

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

Xinyi - Time Series For Statistical Variables

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

Xinyi - Time Series For Statistical Variables

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

Xinyuan - Time Series For Statistical Variables

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

Xinyu - Time Series For Statistical Variables

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

Xinzheng - Time Series For Statistical Variables

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

Xinzhou - Time Series For Statistical Variables

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

Xinzo De Limia - Time Series For Statistical Variables

@datacommons.cities.xinzo_de_limia_wikidataid_q24012318
  • 42.92 kB
  • 5,092 rows
  • 12 columns
Loading... 
CREATE TABLE xinzo_de_limia_wikidataid_q24012318 (
  "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.