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

Zmiiv - Time Series For Statistical Variables

@datacommons.cities.zmiiv_wikidataid_q1106097
  • 71.51 kB
  • 8,397 rows
  • 12 columns
Loading... 

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

Znamensk, Astrakhan Oblast - Time Series For Statistical Variables

@datacommons.cities.znamensk_astrakhan_oblast_wikidataid_q141290
  • 19.08 kB
  • 1,414 rows
  • 12 columns
Loading... 

CREATE TABLE znamensk_astrakhan_oblast_wikidataid_q141290 (
  "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əngilan - Time Series For Statistical Variables

@datacommons.cities.z_ngilan_wikidataid_q249226
  • 39.49 kB
  • 4,364 rows
  • 12 columns
Loading... 

CREATE TABLE z_ngilan_wikidataid_q249226 (
  "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üünkharaa - Time Series For Statistical Variables

@datacommons.cities.z_nkharaa_wikidataid_q1028289
  • 50.64 kB
  • 6,831 rows
  • 12 columns
Loading... 

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

Znojmo - Time Series For Statistical Variables

@datacommons.cities.znojmo_wikidataid_q214956
  • 51.3 kB
  • 6,385 rows
  • 12 columns
Loading... 

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

Zoar - Time Series For Statistical Variables

@datacommons.cities.zoar_geoid_3988168
  • 2.83 MB
  • 342,340 rows
  • 12 columns
Loading... 

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

Zoar - Time Series For Statistical Variables

@datacommons.cities.zoar_geoid_5589760
  • 2.72 MB
  • 335,204 rows
  • 12 columns
Loading... 

CREATE TABLE zoar_geoid_5589760 (
  "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Å‚ocieniec - Time Series For Statistical Variables

@datacommons.cities.z_ocieniec_wikidataid_q249049
  • 53.53 kB
  • 6,632 rows
  • 12 columns
Loading... 

CREATE TABLE z_ocieniec_wikidataid_q249049 (
  "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Å‚oczew - Time Series For Statistical Variables

@datacommons.cities.z_oczew_wikidataid_q249059
  • 49.11 kB
  • 6,023 rows
  • 12 columns
Loading... 

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

Zodel - Time Series For Statistical Variables

@datacommons.cities.zodel_wikidataid_q160824
  • 67.42 kB
  • 9,747 rows
  • 12 columns
Loading... 

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

Zoetermeer - Time Series For Statistical Variables

@datacommons.cities.zoetermeer_wikidataid_q33528284
  • 76 kB
  • 10,721 rows
  • 12 columns
Loading... 

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

Zofingen - Time Series For Statistical Variables

@datacommons.cities.zofingen_wikidataid_q63986
  • 81.59 kB
  • 11,223 rows
  • 12 columns
Loading... 

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

Zogaj - Time Series For Statistical Variables

@datacommons.cities.zogaj_wikidataid_q8073411
  • 56.96 kB
  • 6,898 rows
  • 12 columns
Loading... 

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

Zohan - Time Series For Statistical Variables

@datacommons.cities.zohan_wikidataid_q83686
  • 9.33 kB
  • 1 row
  • 12 columns
Loading... 

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

Zokhawthar - Time Series For Statistical Variables

@datacommons.cities.zokhawthar_wikidataid_q24929741
  • 22.78 kB
  • 2,056 rows
  • 12 columns
Loading... 

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

Zolfo Springs - Time Series For Statistical Variables

@datacommons.cities.zolfo_springs_geoid_1279250
  • 2.97 MB
  • 343,797 rows
  • 12 columns
Loading... 

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

Zollikofen - Time Series For Statistical Variables

@datacommons.cities.zollikofen_wikidataid_q69675
  • 54.45 kB
  • 6,748 rows
  • 12 columns
Loading... 

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

Zollikon - Time Series For Statistical Variables

@datacommons.cities.zollikon_wikidataid_q218691
  • 78.65 kB
  • 11,027 rows
  • 12 columns
Loading... 

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

Zolochiv - Time Series For Statistical Variables

@datacommons.cities.zolochiv_wikidataid_q623594
  • 33.43 kB
  • 3,538 rows
  • 12 columns
Loading... 

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

Zolote - Time Series For Statistical Variables

@datacommons.cities.zolote_wikidataid_q582033
  • 52.5 kB
  • 6,642 rows
  • 12 columns
Loading... 

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

Zolotonosha - Time Series For Statistical Variables

@datacommons.cities.zolotonosha_wikidataid_q219769
  • 45.84 kB
  • 5,378 rows
  • 12 columns
Loading... 

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

Zomba - Time Series For Statistical Variables

@datacommons.cities.zomba_wikidataid_q219117
  • 16.08 kB
  • 969 rows
  • 12 columns
Loading... 

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

Zondereigen - Time Series For Statistical Variables

@datacommons.cities.zondereigen_wikidataid_q2611924
  • 73.21 kB
  • 9,669 rows
  • 12 columns
Loading... 

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

Zongolica - Time Series For Statistical Variables

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

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

Zongozotla - Time Series For Statistical Variables

@datacommons.cities.zongozotla_undata_geo_c16801609
  • 9.23 kB
  • 1 row
  • 12 columns
Loading... 

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