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

Az Zubaydiyah - Time Series For Statistical Variables

@datacommons.cities.az_zubaydiyah_wikidataid_q12188056
  • 16.97 kB
  • 1,020 rows
  • 12 columns
Loading...
CREATE TABLE az_zubaydiyah_wikidataid_q12188056 (
  "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
);

Az Zubayr - Time Series For Statistical Variables

@datacommons.cities.az_zubayr_wikidataid_q227509
  • 45.2 kB
  • 5,742 rows
  • 12 columns
Loading...
CREATE TABLE az_zubayr_wikidataid_q227509 (
  "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
);

Baabe - Time Series For Statistical Variables

@datacommons.cities.baabe_wikidataid_q630177
  • 67.36 kB
  • 9,614 rows
  • 12 columns
Loading...
CREATE TABLE baabe_wikidataid_q630177 (
  "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
);

Baadarâne - Time Series For Statistical Variables

@datacommons.cities.baadar_ne_wikidataid_q22949037
  • 55.29 kB
  • 7,438 rows
  • 12 columns
Loading...
CREATE TABLE baadar_ne_wikidataid_q22949037 (
  "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
);

Baalbek - Time Series For Statistical Variables

@datacommons.cities.baalbek_wikidataid_q178835
  • 53.48 kB
  • 7,270 rows
  • 12 columns
Loading...
CREATE TABLE baalbek_wikidataid_q178835 (
  "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
);

Baan Ao Leuk - Time Series For Statistical Variables

@datacommons.cities.baan_ao_leuk_wikidataid_q14204506
  • 23.76 kB
  • 2,059 rows
  • 12 columns
Loading...
CREATE TABLE baan_ao_leuk_wikidataid_q14204506 (
  "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
);

Baan Baa - Time Series For Statistical Variables

@datacommons.cities.baan_baa_wikidataid_q4837155
  • 52.69 kB
  • 6,624 rows
  • 12 columns
Loading...
CREATE TABLE baan_baa_wikidataid_q4837155 (
  "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
);

Baandee - Time Series For Statistical Variables

@datacommons.cities.baandee_wikidataid_q4837165
  • 49.22 kB
  • 7,174 rows
  • 12 columns
Loading...
CREATE TABLE baandee_wikidataid_q4837165 (
  "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
);

Baarle-Hertog - Time Series For Statistical Variables

@datacommons.cities.baarle_hertog_wikidataid_q244959
  • 73.96 kB
  • 9,608 rows
  • 12 columns
Loading...
CREATE TABLE baarle_hertog_wikidataid_q244959 (
  "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
);

Baarle-Nassau - Time Series For Statistical Variables

@datacommons.cities.baarle_nassau_wikidataid_q9811
  • 73 kB
  • 9,609 rows
  • 12 columns
Loading...
CREATE TABLE baarle_nassau_wikidataid_q9811 (
  "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
);

Baarle - Time Series For Statistical Variables

@datacommons.cities.baarle_wikidataid_q797512
  • 72.82 kB
  • 9,608 rows
  • 12 columns
Loading...
CREATE TABLE baarle_wikidataid_q797512 (
  "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
);

Baarn - Time Series For Statistical Variables

@datacommons.cities.baarn_wikidataid_q33423050
  • 79.12 kB
  • 11,034 rows
  • 12 columns
Loading...
CREATE TABLE baarn_wikidataid_q33423050 (
  "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
);

Baar - Time Series For Statistical Variables

@datacommons.cities.baar_wikidataid_q64087
  • 79.17 kB
  • 11,013 rows
  • 12 columns
Loading...
CREATE TABLE baar_wikidataid_q64087 (
  "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
);

Babachō - Time Series For Statistical Variables

@datacommons.cities.babach_wikidataid_q11667908
  • 70.43 kB
  • 9,728 rows
  • 12 columns
Loading...
CREATE TABLE babach_wikidataid_q11667908 (
  "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
);

Babadag - Time Series For Statistical Variables

@datacommons.cities.babadag_wikidataid_q386945
  • 51.26 kB
  • 6,209 rows
  • 12 columns
Loading...
CREATE TABLE babadag_wikidataid_q386945 (
  "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
);

Babaheydar - Time Series For Statistical Variables

@datacommons.cities.babaheydar_wikidataid_q2613894
  • 35.63 kB
  • 4,126 rows
  • 12 columns
Loading...
CREATE TABLE babaheydar_wikidataid_q2613894 (
  "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
);

Babahoyo - Time Series For Statistical Variables

@datacommons.cities.babahoyo_wikidataid_q797568
  • 21.32 kB
  • 1,751 rows
  • 12 columns
Loading...
CREATE TABLE babahoyo_wikidataid_q797568 (
  "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
);

Babakin - Time Series For Statistical Variables

@datacommons.cities.babakin_wikidataid_q4837471
  • 51.72 kB
  • 6,794 rows
  • 12 columns
Loading...
CREATE TABLE babakin_wikidataid_q4837471 (
  "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
);

Baba Monir - Time Series For Statistical Variables

@datacommons.cities.baba_monir_wikidataid_q5799618
  • 29.2 kB
  • 3,136 rows
  • 12 columns
Loading...
CREATE TABLE baba_monir_wikidataid_q5799618 (
  "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
);

Babanango - Time Series For Statistical Variables

@datacommons.cities.babanango_wikidataid_q2516019
  • 40.69 kB
  • 4,684 rows
  • 12 columns
Loading...
CREATE TABLE babanango_wikidataid_q2516019 (
  "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
);

Bab Anar - Time Series For Statistical Variables

@datacommons.cities.bab_anar_wikidataid_q4811070
  • 33.38 kB
  • 3,948 rows
  • 12 columns
Loading...
CREATE TABLE bab_anar_wikidataid_q4811070 (
  "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
);

Baba Nur - Time Series For Statistical Variables

@datacommons.cities.baba_nur_wikidataid_q12195961
  • 10.93 kB
  • 155 rows
  • 12 columns
Loading...
CREATE TABLE baba_nur_wikidataid_q12195961 (
  "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
);

Babarashani - Time Series For Statistical Variables

@datacommons.cities.babarashani_wikidataid_q4359590
  • 9.46 kB
  • 1 row
  • 12 columns
Loading...
CREATE TABLE babarashani_wikidataid_q4359590 (
  "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
);

Babati - Time Series For Statistical Variables

@datacommons.cities.babati_wikidataid_q276746
  • 10.72 kB
  • 205 rows
  • 12 columns
Loading...
CREATE TABLE babati_wikidataid_q276746 (
  "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
);

Baba - Time Series For Statistical Variables

@datacommons.cities.baba_wikidataid_q20870856
  • 40.68 kB
  • 5,127 rows
  • 12 columns
Loading...
CREATE TABLE baba_wikidataid_q20870856 (
  "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.