Baselight

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

Zephyrhills North - Time Series For Statistical Variables

@datacommons.cities.zephyrhills_north_geoid_1279231
  • 2.92 MB
  • 344,623 rows
  • 12 columns
Loading...

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

Zephyrhills South - Time Series For Statistical Variables

@datacommons.cities.zephyrhills_south_geoid_1279237
  • 3 MB
  • 346,441 rows
  • 12 columns
Loading...

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

Zephyrhills West - Time Series For Statistical Variables

@datacommons.cities.zephyrhills_west_geoid_1279243
  • 3.12 MB
  • 353,611 rows
  • 12 columns
Loading...

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

Zerbe Township - Time Series For Statistical Variables

@datacommons.cities.zerbe_township_wikidataid_q1896203
  • 85.57 kB
  • 13,852 rows
  • 12 columns
Loading...

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

Zerbst - Time Series For Statistical Variables

@datacommons.cities.zerbst_wikidataid_q155981
  • 79.01 kB
  • 10,953 rows
  • 12 columns
Loading...

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

Zermatt - Time Series For Statistical Variables

@datacommons.cities.zermatt_wikidataid_q27494
  • 79.33 kB
  • 10,374 rows
  • 12 columns
Loading...

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

Zernograd - Time Series For Statistical Variables

@datacommons.cities.zernograd_wikidataid_q139840
  • 16.71 kB
  • 1,047 rows
  • 12 columns
Loading...

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

Zero Township, Adams County - Time Series For Statistical Variables

@datacommons.cities.zero_township_adams_county_wikidataid_q7994841
  • 84.19 kB
  • 13,373 rows
  • 12 columns
Loading...

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

Zeulenroda-Triebes - Time Series For Statistical Variables

@datacommons.cities.zeulenroda_triebes_wikidataid_q62268
  • 80.8 kB
  • 10,845 rows
  • 12 columns
Loading...

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

Zevenaar - Time Series For Statistical Variables

@datacommons.cities.zevenaar_wikidataid_q15884208
  • 71.62 kB
  • 9,376 rows
  • 12 columns
Loading...

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

Zeven - Time Series For Statistical Variables

@datacommons.cities.zeven_wikidataid_q197045
  • 75.24 kB
  • 10,520 rows
  • 12 columns
Loading...

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

Zevgolateio - Time Series For Statistical Variables

@datacommons.cities.zevgolateio_wikidataid_q8069864
  • 14.83 kB
  • 655 rows
  • 12 columns
Loading...

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

Zeya - Time Series For Statistical Variables

@datacommons.cities.zeya_wikidataid_q139867
  • 68.26 kB
  • 8,979 rows
  • 12 columns
Loading...

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

Zeydabad - Time Series For Statistical Variables

@datacommons.cities.zeydabad_wikidataid_q2420214
  • 30.03 kB
  • 3,332 rows
  • 12 columns
Loading...

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

Zgharta - Time Series For Statistical Variables

@datacommons.cities.zgharta_wikidataid_q25739
  • 44.94 kB
  • 5,020 rows
  • 12 columns
Loading...

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

Zgierz - Time Series For Statistical Variables

@datacommons.cities.zgierz_wikidataid_q104407
  • 63.76 kB
  • 7,717 rows
  • 12 columns
Loading...

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

Zgorzelec - Time Series For Statistical Variables

@datacommons.cities.zgorzelec_wikidataid_q147929
  • 82.14 kB
  • 11,548 rows
  • 12 columns
Loading...

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

Zhaisan - Time Series For Statistical Variables

@datacommons.cities.zhaisan_wikidataid_q18391009
  • 56.4 kB
  • 7,342 rows
  • 12 columns
Loading...

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

Zhangjiagang - Time Series For Statistical Variables

@datacommons.cities.zhangjiagang_wikidataid_q197377
  • 29.03 kB
  • 2,963 rows
  • 12 columns
Loading...

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

Zhangjiajie - Time Series For Statistical Variables

@datacommons.cities.zhangjiajie_wikidataid_q197379
  • 4.77 MB
  • 556,033 rows
  • 12 columns
Loading...

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

Zhangjiakou - Time Series For Statistical Variables

@datacommons.cities.zhangjiakou_wikidataid_q58650
  • 4.67 MB
  • 556,853 rows
  • 12 columns
Loading...

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

Zhangping - Time Series For Statistical Variables

@datacommons.cities.zhangping_wikidataid_q197378
  • 47.18 kB
  • 5,674 rows
  • 12 columns
Loading...

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

Zhangshu - Time Series For Statistical Variables

@datacommons.cities.zhangshu_wikidataid_q197394
  • 28.76 kB
  • 2,885 rows
  • 12 columns
Loading...

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

Zhangye - Time Series For Statistical Variables

@datacommons.cities.zhangye_wikidataid_q197402
  • 4.64 MB
  • 556,831 rows
  • 12 columns
Loading...

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

Zhangzhou - Time Series For Statistical Variables

@datacommons.cities.zhangzhou_wikidataid_q68814
  • 4.81 MB
  • 556,732 rows
  • 12 columns
Loading...

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