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

Aghbal - Time Series For Statistical Variables

@datacommons.cities.aghbal_wikidataid_q23011118
  • 60.4 kB
  • 8,445 rows
  • 12 columns
Loading...

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

Aghir - Time Series For Statistical Variables

@datacommons.cities.aghir_wikidataid_q12180000
  • 43.5 kB
  • 5,662 rows
  • 12 columns
Loading...

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

Agia Marina - Time Series For Statistical Variables

@datacommons.cities.agia_marina_wikidataid_q1246364
  • 31.22 kB
  • 3,848 rows
  • 12 columns
Loading...

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

Agia Paraskevi Kallonis Lesvou - Time Series For Statistical Variables

@datacommons.cities.agia_paraskevi_kallonis_lesvou_wikidataid_q15635603
  • 44.67 kB
  • 5,523 rows
  • 12 columns
Loading...

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

Agia Paraskevi, Thessaloniki - Time Series For Statistical Variables

@datacommons.cities.agia_paraskevi_thessaloniki_wikidataid_q12181467
  • 48.26 kB
  • 5,802 rows
  • 12 columns
Loading...

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

Agiasos - Time Series For Statistical Variables

@datacommons.cities.agiasos_wikidataid_q2638873
  • 46.79 kB
  • 5,597 rows
  • 12 columns
Loading...

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

Agincourt, Mpumalanga - Time Series For Statistical Variables

@datacommons.cities.agincourt_mpumalanga_wikidataid_q15178360
  • 52.41 kB
  • 6,398 rows
  • 12 columns
Loading...

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

Agioi Apostoloi - Time Series For Statistical Variables

@datacommons.cities.agioi_apostoloi_wikidataid_q12181500
  • 51.85 kB
  • 6,585 rows
  • 12 columns
Loading...

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

Agios Athanasios - Time Series For Statistical Variables

@datacommons.cities.agios_athanasios_wikidataid_q2479112
  • 47.73 kB
  • 5,801 rows
  • 12 columns
Loading...

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

Agios Georgios Argirades - Time Series For Statistical Variables

@datacommons.cities.agios_georgios_argirades_wikidataid_q21555109
  • 51.16 kB
  • 6,133 rows
  • 12 columns
Loading...

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

Agios Kirykos - Time Series For Statistical Variables

@datacommons.cities.agios_kirykos_wikidataid_q393962
  • 9.58 kB
  • 1 row
  • 12 columns
Loading...

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

Agios Konstantinos, Fthiotis - Time Series For Statistical Variables

@datacommons.cities.agios_konstantinos_fthiotis_wikidataid_q16963918
  • 42.83 kB
  • 5,069 rows
  • 12 columns
Loading...

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

Agios Nikolaos - Time Series For Statistical Variables

@datacommons.cities.agios_nikolaos_wikidataid_q211463
  • 23.54 kB
  • 1,968 rows
  • 12 columns
Loading...

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

Agios Stefanos, Athens - Time Series For Statistical Variables

@datacommons.cities.agios_stefanos_athens_wikidataid_q2698815
  • 51.57 kB
  • 6,564 rows
  • 12 columns
Loading...

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

Agios Vasileios, Achaea - Time Series For Statistical Variables

@datacommons.cities.agios_vasileios_achaea_wikidataid_q12181489
  • 33.2 kB
  • 4,356 rows
  • 12 columns
Loading...

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

Agnes City Township - Time Series For Statistical Variables

@datacommons.cities.agnes_city_township_geoid_2000525
  • 87.24 kB
  • 14,097 rows
  • 12 columns
Loading...

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

Agnes Township - Time Series For Statistical Variables

@datacommons.cities.agnes_township_geoid_3800820
  • 94.86 kB
  • 14,685 rows
  • 12 columns
Loading...

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

Agnes Water - Time Series For Statistical Variables

@datacommons.cities.agnes_water_wikidataid_q2826929
  • 53.33 kB
  • 6,651 rows
  • 12 columns
Loading...

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

Agnes - Time Series For Statistical Variables

@datacommons.cities.agnes_wikidataid_q4692989
  • 51.91 kB
  • 6,068 rows
  • 12 columns
Loading...

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

Agnew - Time Series For Statistical Variables

@datacommons.cities.agnew_geoid_1700399
  • 84.32 kB
  • 13,577 rows
  • 12 columns
Loading...

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

Agnew - Time Series For Statistical Variables

@datacommons.cities.agnew_geoid_3100380
  • 886.48 kB
  • 61,999 rows
  • 12 columns
Loading...

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

Agnita - Time Series For Statistical Variables

@datacommons.cities.agnita_wikidataid_q313689
  • 64.61 kB
  • 7,324 rows
  • 12 columns
Loading...

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

Agón - Time Series For Statistical Variables

@datacommons.cities.ag_n_wikidataid_q24016523
  • 57.9 kB
  • 7,490 rows
  • 12 columns
Loading...

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

Agogo - Time Series For Statistical Variables

@datacommons.cities.agogo_wikidataid_q395201
  • 20.21 kB
  • 1,678 rows
  • 12 columns
Loading...

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

Agoitz - Time Series For Statistical Variables

@datacommons.cities.agoitz_wikidataid_q2142215
  • 50.78 kB
  • 6,370 rows
  • 12 columns
Loading...

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