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

Yverdon-les-Bains - Time Series For Statistical Variables

@datacommons.cities.yverdon_les_bains_wikidataid_q63946
  • 57.41 kB
  • 6,757 rows
  • 12 columns
Loading... 

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

Yzerfontein - Time Series For Statistical Variables

@datacommons.cities.yzerfontein_wikidataid_q993842
  • 49.96 kB
  • 6,195 rows
  • 12 columns
Loading... 

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

Yznaga - Time Series For Statistical Variables

@datacommons.cities.yznaga_geoid_4880686
  • 2.57 MB
  • 326,181 rows
  • 12 columns
Loading... 

CREATE TABLE yznaga_geoid_4880686 (
  "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'atara - Time Series For Statistical Variables

@datacommons.cities.za_atara_wikidataid_q2898722
  • 56.56 kB
  • 7,594 rows
  • 12 columns
Loading... 

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

Zabaykalsk - Time Series For Statistical Variables

@datacommons.cities.zabaykalsk_wikidataid_q24690
  • 32.14 kB
  • 3,688 rows
  • 12 columns
Loading... 

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

Zabok - Time Series For Statistical Variables

@datacommons.cities.zabok_wikidataid_q139018
  • 77.26 kB
  • 10,796 rows
  • 12 columns
Loading... 

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

Zaboli - Time Series For Statistical Variables

@datacommons.cities.zaboli_wikidataid_q587738
  • 9.38 kB
  • 1 row
  • 12 columns
Loading... 

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

Zabol - Time Series For Statistical Variables

@datacommons.cities.zabol_wikidataid_q139024
  • 39.15 kB
  • 4,244 rows
  • 12 columns
Loading... 

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

Zabrze - Time Series For Statistical Variables

@datacommons.cities.zabrze_wikidataid_q103892
  • 55.65 kB
  • 7,183 rows
  • 12 columns
Loading... 

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

Zabłudów - Time Series For Statistical Variables

@datacommons.cities.zab_ud_w_wikidataid_q1906311
  • 57.29 kB
  • 7,286 rows
  • 12 columns
Loading... 

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

Zacapu - Time Series For Statistical Variables

@datacommons.cities.zacapu_undata_geo_c16800885
  • 9.2 kB
  • 1 row
  • 12 columns
Loading... 

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

Zacatelco, Mexico - Time Series For Statistical Variables

@datacommons.cities.zacatelco_mexico_wikidataid_q2879423
  • 56.82 kB
  • 7,651 rows
  • 12 columns
Loading... 

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

Zacatepec - Time Series For Statistical Variables

@datacommons.cities.zacatepec_undata_geo_c16800922
  • 9.22 kB
  • 1 row
  • 12 columns
Loading... 

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

Zacatlán - Time Series For Statistical Variables

@datacommons.cities.zacatl_n_wikidataid_q20204353
  • 59.34 kB
  • 7,976 rows
  • 12 columns
Loading... 

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

Zacazonapan - Time Series For Statistical Variables

@datacommons.cities.zacazonapan_undata_geo_c16800773
  • 9.24 kB
  • 1 row
  • 12 columns
Loading... 

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

Zacharo - Time Series For Statistical Variables

@datacommons.cities.zacharo_wikidataid_q139595
  • 9.54 kB
  • 1 row
  • 12 columns
Loading... 

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

Zachary - Time Series For Statistical Variables

@datacommons.cities.zachary_geoid_2283405
  • 3.28 MB
  • 357,660 rows
  • 12 columns
Loading... 

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

Zachary - Time Series For Statistical Variables

@datacommons.cities.zachary_wikidataid_q3240452
  • 71 kB
  • 13,330 rows
  • 12 columns
Loading... 

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

Zacualpan - Time Series For Statistical Variables

@datacommons.cities.zacualpan_undata_geo_c16802105
  • 9.22 kB
  • 1 row
  • 12 columns
Loading... 

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

Zadar - Time Series For Statistical Variables

@datacommons.cities.zadar_wikidataid_q3370
  • 73.51 kB
  • 9,895 rows
  • 12 columns
Loading... 

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

Zadonsk - Time Series For Statistical Variables

@datacommons.cities.zadonsk_wikidataid_q136551
  • 78.38 kB
  • 11,001 rows
  • 12 columns
Loading... 

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

Zafarwal - Time Series For Statistical Variables

@datacommons.cities.zafarwal_wikidataid_q16319283
  • 44.04 kB
  • 5,207 rows
  • 12 columns
Loading... 

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

Zagazig - Time Series For Statistical Variables

@datacommons.cities.zagazig_wikidataid_q140304
  • 44.68 kB
  • 6,052 rows
  • 12 columns
Loading... 

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

Zagheh - Time Series For Statistical Variables

@datacommons.cities.zagheh_wikidataid_q2422675
  • 38.03 kB
  • 4,227 rows
  • 12 columns
Loading... 

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

Zagliveri - Time Series For Statistical Variables

@datacommons.cities.zagliveri_wikidataid_q3394308
  • 48.4 kB
  • 5,802 rows
  • 12 columns
Loading... 

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