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

Zawidów - Time Series For Statistical Variables

@datacommons.cities.zawid_w_wikidataid_q167756
  • 86.08 kB
  • 11,548 rows
  • 12 columns
Loading... 

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

Zawiercie - Time Series For Statistical Variables

@datacommons.cities.zawiercie_wikidataid_q148827
  • 63.13 kB
  • 7,483 rows
  • 12 columns
Loading... 

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

Zaō - Time Series For Statistical Variables

@datacommons.cities.za_wikidataid_q1347874
  • 63.08 kB
  • 7,879 rows
  • 12 columns
Loading... 

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

Zawiya, West Bank - Time Series For Statistical Variables

@datacommons.cities.zawiya_west_bank_wikidataid_q9163181
  • 65.15 kB
  • 8,759 rows
  • 12 columns
Loading... 

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

Zayandeh Rud - Time Series For Statistical Variables

@datacommons.cities.zayandeh_rud_wikidataid_q80828
  • 35.62 kB
  • 4,127 rows
  • 12 columns
Loading... 

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

Zayante - Time Series For Statistical Variables

@datacommons.cities.zayante_geoid_0687090
  • 2.87 MB
  • 343,518 rows
  • 12 columns
Loading... 

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

Zazeran - Time Series For Statistical Variables

@datacommons.cities.zazeran_wikidataid_q2351813
  • 37.54 kB
  • 4,489 rows
  • 12 columns
Loading... 

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

Zbarazh - Time Series For Statistical Variables

@datacommons.cities.zbarazh_wikidataid_q1019899
  • 60.18 kB
  • 7,708 rows
  • 12 columns
Loading... 

CREATE TABLE zbarazh_wikidataid_q1019899 (
  "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ábřeh - Time Series For Statistical Variables

@datacommons.cities.z_b_eh_wikidataid_q246634
  • 54.8 kB
  • 7,044 rows
  • 12 columns
Loading... 

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

Zbiroh - Time Series For Statistical Variables

@datacommons.cities.zbiroh_wikidataid_q168234
  • 61.7 kB
  • 7,904 rows
  • 12 columns
Loading... 

CREATE TABLE zbiroh_wikidataid_q168234 (
  "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ąbki - Time Series For Statistical Variables

@datacommons.cities.z_bki_wikidataid_q248999
  • 57.11 kB
  • 7,052 rows
  • 12 columns
Loading... 

CREATE TABLE z_bki_wikidataid_q248999 (
  "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ąbkowice Śląskie - Time Series For Statistical Variables

@datacommons.cities.z_bkowice_l_skie_wikidataid_q246693
  • 53.28 kB
  • 6,880 rows
  • 12 columns
Loading... 

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

Zboriv - Time Series For Statistical Variables

@datacommons.cities.zboriv_wikidataid_q148928
  • 68.47 kB
  • 7,840 rows
  • 12 columns
Loading... 

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

Zbýšov - Time Series For Statistical Variables

@datacommons.cities.zb_ov_wikidataid_q168900
  • 60.39 kB
  • 7,722 rows
  • 12 columns
Loading... 

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

Zbąszynek - Time Series For Statistical Variables

@datacommons.cities.zb_szynek_wikidataid_q168902
  • 56.43 kB
  • 7,515 rows
  • 12 columns
Loading... 

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

Zbąszyń - Time Series For Statistical Variables

@datacommons.cities.zb_szy_wikidataid_q168905
  • 55.53 kB
  • 7,516 rows
  • 12 columns
Loading... 

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

Zdice - Time Series For Statistical Variables

@datacommons.cities.zdice_wikidataid_q169133
  • 79.8 kB
  • 11,244 rows
  • 12 columns
Loading... 

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

Zdolbuniv - Time Series For Statistical Variables

@datacommons.cities.zdolbuniv_wikidataid_q148979
  • 52.77 kB
  • 6,548 rows
  • 12 columns
Loading... 

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

Zduny - Time Series For Statistical Variables

@datacommons.cities.zduny_wikidataid_q169224
  • 11.92 kB
  • 260 rows
  • 12 columns
Loading... 

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

Zduńska Wola - Time Series For Statistical Variables

@datacommons.cities.zdu_ska_wola_wikidataid_q169237
  • 63.67 kB
  • 7,715 rows
  • 12 columns
Loading... 

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

Zdzieszowice - Time Series For Statistical Variables

@datacommons.cities.zdzieszowice_wikidataid_q1002944
  • 49.56 kB
  • 6,259 rows
  • 12 columns
Loading... 

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

Zealandia - Time Series For Statistical Variables

@datacommons.cities.zealandia_wikidataid_q1917781
  • 74.92 kB
  • 11,231 rows
  • 12 columns
Loading... 

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

Zeandale - Time Series For Statistical Variables

@datacommons.cities.zeandale_geoid_2080875
  • 910.69 kB
  • 63,427 rows
  • 12 columns
Loading... 

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

Zeandale Township - Time Series For Statistical Variables

@datacommons.cities.zeandale_township_geoid_2080900
  • 95.39 kB
  • 15,082 rows
  • 12 columns
Loading... 

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

Zearing - Time Series For Statistical Variables

@datacommons.cities.zearing_geoid_1987555
  • 2.95 MB
  • 345,020 rows
  • 12 columns
Loading... 

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