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

Adlersky City District - Time Series For Statistical Variables

@datacommons.cities.adlersky_city_district_wikidataid_q4262671
  • 80.53 kB
  • 10,926 rows
  • 12 columns
Loading...

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

Adler Township - Time Series For Statistical Variables

@datacommons.cities.adler_township_geoid_3800580
  • 86.76 kB
  • 13,325 rows
  • 12 columns
Loading...

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

Adlington - Time Series For Statistical Variables

@datacommons.cities.adlington_wikidataid_q2293656
  • 60.46 kB
  • 8,115 rows
  • 12 columns
Loading...

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

Adliswil - Time Series For Statistical Variables

@datacommons.cities.adliswil_wikidataid_q68210
  • 79.97 kB
  • 11,038 rows
  • 12 columns
Loading...

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

Admaston/Bromley - Time Series For Statistical Variables

@datacommons.cities.admaston_bromley_wikidataid_q4683344
  • 9.45 kB
  • 1 row
  • 12 columns
Loading...

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

Admire - Time Series For Statistical Variables

@datacommons.cities.admire_geoid_2000325
  • 2.79 MB
  • 341,156 rows
  • 12 columns
Loading...

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

Ado Ekiti - Time Series For Statistical Variables

@datacommons.cities.ado_ekiti_wikidataid_q359955
  • 13.02 kB
  • 546 rows
  • 12 columns
Loading...

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

Adolfo Ruiz Cortines - Time Series For Statistical Variables

@datacommons.cities.adolfo_ruiz_cortines_wikidataid_q18795368
  • 42.98 kB
  • 5,119 rows
  • 12 columns
Loading...

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

Adolfo - Time Series For Statistical Variables

@datacommons.cities.adolfo_wikidataid_q676044
  • 33.18 kB
  • 2,996 rows
  • 12 columns
Loading...

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

Adona - Time Series For Statistical Variables

@datacommons.cities.adona_geoid_0500250
  • 2.77 MB
  • 338,676 rows
  • 12 columns
Loading...

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

Adoni - Time Series For Statistical Variables

@datacommons.cities.adoni_wikidataid_q490906
  • 26.12 kB
  • 2,535 rows
  • 12 columns
Loading...

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

Adony - Time Series For Statistical Variables

@datacommons.cities.adony_wikidataid_q366220
  • 71.96 kB
  • 10,235 rows
  • 12 columns
Loading...

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

Adorf/Vogtl. - Time Series For Statistical Variables

@datacommons.cities.adorf_vogtl_wikidataid_q46853
  • 89.25 kB
  • 12,117 rows
  • 12 columns
Loading...

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

A Dos Cunhados - Time Series For Statistical Variables

@datacommons.cities.a_dos_cunhados_wikidataid_q300626
  • 59.17 kB
  • 7,865 rows
  • 12 columns
Loading...

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

A Dos Francos - Time Series For Statistical Variables

@datacommons.cities.a_dos_francos_wikidataid_q300627
  • 37.59 kB
  • 4,400 rows
  • 12 columns
Loading...

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

Ad Quintum - Time Series For Statistical Variables

@datacommons.cities.ad_quintum_wikidataid_q13046345
  • 44.53 kB
  • 5,384 rows
  • 12 columns
Loading...

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

Adrar - Time Series For Statistical Variables

@datacommons.cities.adrar_wikidataid_q251181
  • 38.99 kB
  • 5,009 rows
  • 12 columns
Loading...

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

Adrian Charter Township - Time Series For Statistical Variables

@datacommons.cities.adrian_charter_township_geoid_2600460
  • 91.09 kB
  • 14,807 rows
  • 12 columns
Loading...

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

Adrian - Time Series For Statistical Variables

@datacommons.cities.adrian_geoid_1300660
  • 2.81 MB
  • 339,293 rows
  • 12 columns
Loading...

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

Adrian - Time Series For Statistical Variables

@datacommons.cities.adrian_geoid_2600440
  • 3.44 MB
  • 363,026 rows
  • 12 columns
Loading...

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

Adrian - Time Series For Statistical Variables

@datacommons.cities.adrian_geoid_2700262
  • 3.03 MB
  • 353,049 rows
  • 12 columns
Loading...

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

Adrian - Time Series For Statistical Variables

@datacommons.cities.adrian_geoid_2900244
  • 3.06 MB
  • 354,433 rows
  • 12 columns
Loading...

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

Adrian - Time Series For Statistical Variables

@datacommons.cities.adrian_geoid_3600331
  • 80.29 kB
  • 13,120 rows
  • 12 columns
Loading...

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

Adrian - Time Series For Statistical Variables

@datacommons.cities.adrian_geoid_4100500
  • 2.8 MB
  • 341,668 rows
  • 12 columns
Loading...

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

Adrian - Time Series For Statistical Variables

@datacommons.cities.adrian_geoid_4801324
  • 2.78 MB
  • 338,139 rows
  • 12 columns
Loading...

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