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

Aguas Blancas - Time Series For Statistical Variables

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

Aguas Buenas Zona Urbana - Time Series For Statistical Variables

@datacommons.cities.aguas_buenas_zona_urbana_geoid_7200874
  • 1.59 MB
  • 192,352 rows
  • 12 columns
Loading... 
CREATE TABLE aguas_buenas_zona_urbana_geoid_7200874 (
  "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
);

Aguascalientes City - Time Series For Statistical Variables

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

Aguas Claras Comunidad - Time Series For Statistical Variables

@datacommons.cities.aguas_claras_comunidad_geoid_7201003
  • 1.45 MB
  • 183,182 rows
  • 12 columns
Loading... 
CREATE TABLE aguas_claras_comunidad_geoid_7201003 (
  "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
);

Aguas Verdes - Time Series For Statistical Variables

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

Aguaí - Time Series For Statistical Variables

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

Agudos - Time Series For Statistical Variables

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

Aguiar Da Beira - Time Series For Statistical Variables

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

Aguiar Da Beira - Time Series For Statistical Variables

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

Aguila - Time Series For Statistical Variables

@datacommons.cities.aguila_geoid_0400730
  • 2.82 MB
  • 338,879 rows
  • 12 columns
Loading... 
CREATE TABLE aguila_geoid_0400730 (
  "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
);

Aguilares - Time Series For Statistical Variables

@datacommons.cities.aguilares_geoid_4801420
  • 2.57 MB
  • 327,712 rows
  • 12 columns
Loading... 
CREATE TABLE aguilares_geoid_4801420 (
  "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
);

Aguilar - Time Series For Statistical Variables

@datacommons.cities.aguilar_geoid_0800760
  • 2.86 MB
  • 342,996 rows
  • 12 columns
Loading... 
CREATE TABLE aguilar_geoid_0800760 (
  "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
);

Aguilita Comunidad - Time Series For Statistical Variables

@datacommons.cities.aguilita_comunidad_geoid_7201089
  • 1.48 MB
  • 183,224 rows
  • 12 columns
Loading... 
CREATE TABLE aguilita_comunidad_geoid_7201089 (
  "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
);

Aguilón - Time Series For Statistical Variables

@datacommons.cities.aguil_n_wikidataid_q24016521
  • 65.05 kB
  • 8,843 rows
  • 12 columns
Loading... 
CREATE TABLE aguil_n_wikidataid_q24016521 (
  "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
);

Aguinaga - Time Series For Statistical Variables

@datacommons.cities.aguinaga_wikidataid_q12252846
  • 62.07 kB
  • 8,388 rows
  • 12 columns
Loading... 
CREATE TABLE aguinaga_wikidataid_q12252846 (
  "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
);

Agui - Time Series For Statistical Variables

@datacommons.cities.agui_wikidataid_q1203868
  • 66.33 kB
  • 8,488 rows
  • 12 columns
Loading... 
CREATE TABLE agui_wikidataid_q1203868 (
  "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
);

Agui - Time Series For Statistical Variables

@datacommons.cities.agui_wikidataid_q4057168
  • 63.93 kB
  • 8,292 rows
  • 12 columns
Loading... 
CREATE TABLE agui_wikidataid_q4057168 (
  "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
);

Ahamansu - Time Series For Statistical Variables

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

Ahar - Time Series For Statistical Variables

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

Ahaus - Time Series For Statistical Variables

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

Ahdid - Time Series For Statistical Variables

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

Aheloy - Time Series For Statistical Variables

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

Ahfir - Time Series For Statistical Variables

@datacommons.cities.ahfir_wikidataid_q2544620
  • 66.53 kB
  • 8,446 rows
  • 12 columns
Loading... 
CREATE TABLE ahfir_wikidataid_q2544620 (
  "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
);

Ahipara - Time Series For Statistical Variables

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

Ahlen - Time Series For Statistical Variables

@datacommons.cities.ahlen_wikidataid_q1132
  • 79.25 kB
  • 10,824 rows
  • 12 columns
Loading... 
CREATE TABLE ahlen_wikidataid_q1132 (
  "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.