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

A1 Mine Settlement - Time Series For Statistical Variables

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

Aabenraa - Time Series For Statistical Variables

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

Aabybro - Time Series For Statistical Variables

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

Aachen - Time Series For Statistical Variables

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

Aagaard - Time Series For Statistical Variables

@datacommons.cities.aagaard_wikidataid_q2725853
  • 53.07 kB
  • 6,016 rows
  • 12 columns
Loading... 
CREATE TABLE aagaard_wikidataid_q2725853 (
  "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şağı GĆ¼zdək - Time Series For Statistical Variables

@datacommons.cities.a_a_g_zd_k_wikidataid_q599649
  • 62.41 kB
  • 7,457 rows
  • 12 columns
Loading... 
CREATE TABLE a_a_g_zd_k_wikidataid_q599649 (
  "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 Airoa - Time Series For Statistical Variables

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

Aakirkeby - Time Series For Statistical Variables

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

Aalborg - Time Series For Statistical Variables

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

Aalestrup - Time Series For Statistical Variables

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

Aalst - Time Series For Statistical Variables

@datacommons.cities.aalst_wikidataid_q13121
  • 76.5 kB
  • 10,706 rows
  • 12 columns
Loading... 
CREATE TABLE aalst_wikidataid_q13121 (
  "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
);

Aalst - Time Series For Statistical Variables

@datacommons.cities.aalst_wikidataid_q21770022
  • 75.72 kB
  • 10,704 rows
  • 12 columns
Loading... 
CREATE TABLE aalst_wikidataid_q21770022 (
  "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
);

Aamby Valley City - Time Series For Statistical Variables

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

Aarau - Time Series For Statistical Variables

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

Aardenburg - Time Series For Statistical Variables

@datacommons.cities.aardenburg_wikidataid_q955
  • 73.52 kB
  • 10,232 rows
  • 12 columns
Loading... 
CREATE TABLE aardenburg_wikidataid_q955 (
  "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
);

Aarhus - Time Series For Statistical Variables

@datacommons.cities.aarhus_wikidataid_q25319
  • 71.37 kB
  • 10,138 rows
  • 12 columns
Loading... 
CREATE TABLE aarhus_wikidataid_q25319 (
  "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
);

Aaronsburg - Time Series For Statistical Variables

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

Aaronsburg - Time Series For Statistical Variables

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

Aarschot - Time Series For Statistical Variables

@datacommons.cities.aarschot_wikidataid_q12358108
  • 77.59 kB
  • 10,939 rows
  • 12 columns
Loading... 
CREATE TABLE aarschot_wikidataid_q12358108 (
  "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
);

Aarschot - Time Series For Statistical Variables

@datacommons.cities.aarschot_wikidataid_q273442
  • 77.49 kB
  • 10,940 rows
  • 12 columns
Loading... 
CREATE TABLE aarschot_wikidataid_q273442 (
  "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
);

Aars - Time Series For Statistical Variables

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

Aarup - Time Series For Statistical Variables

@datacommons.cities.aarup_wikidataid_q3405593
  • 45.66 kB
  • 5,649 rows
  • 12 columns
Loading... 
CREATE TABLE aarup_wikidataid_q3405593 (
  "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Ʊasco Zona Urbana - Time Series For Statistical Variables

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

Aasiaat - Time Series For Statistical Variables

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

Aastad Township - Time Series For Statistical Variables

@datacommons.cities.aastad_township_geoid_2700100
  • 82.75 kB
  • 13,172 rows
  • 12 columns
Loading... 
CREATE TABLE aastad_township_geoid_2700100 (
  "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.