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

Zarabad (Khoy) - Time Series For Statistical Variables

@datacommons.cities.zarabad_khoy_wikidataid_q5722929
  • 36.01 kB
  • 4,296 rows
  • 12 columns
Loading... 

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

Zarafshan - Time Series For Statistical Variables

@datacommons.cities.zarafshan_wikidataid_q147697
  • 61.88 kB
  • 8,413 rows
  • 12 columns
Loading... 

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

Zaragoza - Time Series For Statistical Variables

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

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

Zaragoza - Time Series For Statistical Variables

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

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

Zaragoza - Time Series For Statistical Variables

@datacommons.cities.zaragoza_wikidataid_q10305
  • 57.26 kB
  • 7,427 rows
  • 12 columns
Loading... 

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

Zaragoza - Time Series For Statistical Variables

@datacommons.cities.zaragoza_wikidataid_q31926034
  • 56.38 kB
  • 7,365 rows
  • 12 columns
Loading... 

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

Zaragoza - Time Series For Statistical Variables

@datacommons.cities.zaragoza_wikidataid_q4023866
  • 43.8 kB
  • 5,502 rows
  • 12 columns
Loading... 

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

Zarand - Time Series For Statistical Variables

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

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

Zaranj - Time Series For Statistical Variables

@datacommons.cities.zaranj_wikidataid_q475802
  • 34.58 kB
  • 4,235 rows
  • 12 columns
Loading... 

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

Zarantz - Time Series For Statistical Variables

@datacommons.cities.zarantz_wikidataid_q936065
  • 62.14 kB
  • 8,388 rows
  • 12 columns
Loading... 

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

Zarate - Time Series For Statistical Variables

@datacommons.cities.zarate_geoid_4880724
  • 2.54 MB
  • 321,753 rows
  • 12 columns
Loading... 

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

Zaraysk - Time Series For Statistical Variables

@datacommons.cities.zaraysk_wikidataid_q136692
  • 45.75 kB
  • 5,581 rows
  • 12 columns
Loading... 

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

Zaraza - Time Series For Statistical Variables

@datacommons.cities.zaraza_wikidataid_q147782
  • 9.35 kB
  • 1 row
  • 12 columns
Loading... 

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

Zarcero - Time Series For Statistical Variables

@datacommons.cities.zarcero_wikidataid_q975960
  • 44.56 kB
  • 5,686 rows
  • 12 columns
Loading... 

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

Zarch - Time Series For Statistical Variables

@datacommons.cities.zarch_wikidataid_q2450195
  • 37.87 kB
  • 4,477 rows
  • 12 columns
Loading... 

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

Zardab - Time Series For Statistical Variables

@datacommons.cities.zardab_wikidataid_q747796
  • 44.16 kB
  • 5,091 rows
  • 12 columns
Loading... 

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

Zarechny - Time Series For Statistical Variables

@datacommons.cities.zarechny_wikidataid_q136715
  • 70.1 kB
  • 9,165 rows
  • 12 columns
Loading... 

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

Zarechny - Time Series For Statistical Variables

@datacommons.cities.zarechny_wikidataid_q136758
  • 88.32 kB
  • 11,790 rows
  • 12 columns
Loading... 

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

Zarephath - Time Series For Statistical Variables

@datacommons.cities.zarephath_geoid_3483290
  • 2.6 MB
  • 327,842 rows
  • 12 columns
Loading... 

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

Zargarmahalleh - Time Series For Statistical Variables

@datacommons.cities.zargarmahalleh_wikidataid_q6672406
  • 41.3 kB
  • 4,769 rows
  • 12 columns
Loading... 

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

Zaria - Time Series For Statistical Variables

@datacommons.cities.zaria_wikidataid_q147975
  • 16.31 kB
  • 1,274 rows
  • 12 columns
Loading... 

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

Zarinsk - Time Series For Statistical Variables

@datacommons.cities.zarinsk_wikidataid_q136792
  • 28.14 kB
  • 2,925 rows
  • 12 columns
Loading... 

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

Zariquiegui - Time Series For Statistical Variables

@datacommons.cities.zariquiegui_wikidataid_q147965
  • 52.87 kB
  • 6,336 rows
  • 12 columns
Loading... 

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

Zarnaq - Time Series For Statistical Variables

@datacommons.cities.zarnaq_wikidataid_q719511
  • 33.59 kB
  • 3,628 rows
  • 12 columns
Loading... 

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

Zarneh - Time Series For Statistical Variables

@datacommons.cities.zarneh_wikidataid_q4023890
  • 30.02 kB
  • 3,113 rows
  • 12 columns
Loading... 

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