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

Zhuyeping - Time Series For Statistical Variables

@datacommons.cities.zhuyeping_wikidataid_q8071254
  • 48.14 kB
  • 5,827 rows
  • 12 columns
Loading... 

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

Zhuzhou - Time Series For Statistical Variables

@datacommons.cities.zhuzhou_wikidataid_q198266
  • 4.78 MB
  • 557,375 rows
  • 12 columns
Loading... 

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

Zhydachiv - Time Series For Statistical Variables

@datacommons.cities.zhydachiv_wikidataid_q997359
  • 69.89 kB
  • 8,916 rows
  • 12 columns
Loading... 

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

Zhytomyr - Time Series For Statistical Variables

@datacommons.cities.zhytomyr_wikidataid_q156713
  • 63.8 kB
  • 8,163 rows
  • 12 columns
Loading... 

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

Ziaabad - Time Series For Statistical Variables

@datacommons.cities.ziaabad_wikidataid_q2422793
  • 9.4 kB
  • 1 row
  • 12 columns
Loading... 

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

Zia Pueblo - Time Series For Statistical Variables

@datacommons.cities.zia_pueblo_geoid_3586420
  • 2.94 MB
  • 344,377 rows
  • 12 columns
Loading... 

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

Ziarat-e Ali - Time Series For Statistical Variables

@datacommons.cities.ziarat_e_ali_wikidataid_q2620749
  • 9.45 kB
  • 1 row
  • 12 columns
Loading... 

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

Ziarat, North Khorasan - Time Series For Statistical Variables

@datacommons.cities.ziarat_north_khorasan_wikidataid_q8071357
  • 27.88 kB
  • 2,908 rows
  • 12 columns
Loading... 

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

Ziar (Isfahan) - Time Series For Statistical Variables

@datacommons.cities.ziar_isfahan_wikidataid_q5712809
  • 9.45 kB
  • 1 row
  • 12 columns
Loading... 

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

Ziaurritz - Time Series For Statistical Variables

@datacommons.cities.ziaurritz_wikidataid_q12269314
  • 51.71 kB
  • 6,497 rows
  • 12 columns
Loading... 

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

Zibashahr - Time Series For Statistical Variables

@datacommons.cities.zibashahr_wikidataid_q80830
  • 38.48 kB
  • 4,490 rows
  • 12 columns
Loading... 

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

Ziębice - Time Series For Statistical Variables

@datacommons.cities.zi_bice_wikidataid_q207100
  • 59.26 kB
  • 6,892 rows
  • 12 columns
Loading... 

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

Zibo - Time Series For Statistical Variables

@datacommons.cities.zibo_wikidataid_q198370
  • 4.76 MB
  • 552,591 rows
  • 12 columns
Loading... 

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

Zickrick Township - Time Series For Statistical Variables

@datacommons.cities.zickrick_township_geoid_4673420
  • 69.3 kB
  • 11,415 rows
  • 12 columns
Loading... 

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

Ziegenrück - Time Series For Statistical Variables

@datacommons.cities.ziegenr_ck_wikidataid_q198831
  • 81.7 kB
  • 11,101 rows
  • 12 columns
Loading... 

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

Zielona Góra - Time Series For Statistical Variables

@datacommons.cities.zielona_g_ra_wikidataid_q104720
  • 57.94 kB
  • 7,897 rows
  • 12 columns
Loading... 

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

Zielonka - Time Series For Statistical Variables

@datacommons.cities.zielonka_wikidataid_q199017
  • 60.67 kB
  • 7,053 rows
  • 12 columns
Loading... 

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

Zierenberg - Time Series For Statistical Variables

@datacommons.cities.zierenberg_wikidataid_q199094
  • 71.7 kB
  • 9,496 rows
  • 12 columns
Loading... 

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

Zierikzee - Time Series For Statistical Variables

@datacommons.cities.zierikzee_wikidataid_q81076
  • 75.18 kB
  • 10,434 rows
  • 12 columns
Loading... 

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

Ziesar - Time Series For Statistical Variables

@datacommons.cities.ziesar_wikidataid_q199233
  • 66.89 kB
  • 9,492 rows
  • 12 columns
Loading... 

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

Zif Township - Time Series For Statistical Variables

@datacommons.cities.zif_township_geoid_1784194
  • 71.68 kB
  • 12,469 rows
  • 12 columns
Loading... 

CREATE TABLE zif_township_geoid_1784194 (
  "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úñiga, Navarre - Time Series For Statistical Variables

@datacommons.cities.z_iga_navarre_wikidataid_q615462
  • 55.45 kB
  • 7,285 rows
  • 12 columns
Loading... 

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

Zigong - Time Series For Statistical Variables

@datacommons.cities.zigong_wikidataid_q29015
  • 4.76 MB
  • 554,753 rows
  • 12 columns
Loading... 

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

Zigon - Time Series For Statistical Variables

@datacommons.cities.zigon_wikidataid_q13065889
  • 9.43 kB
  • 1 row
  • 12 columns
Loading... 

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

Ziguinchor - Time Series For Statistical Variables

@datacommons.cities.ziguinchor_wikidataid_q202776
  • 40.05 kB
  • 4,972 rows
  • 12 columns
Loading... 

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