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

Alabaster - Time Series For Statistical Variables

@datacommons.cities.alabaster_geoid_0100820
  • 3.4 MB
  • 361,206 rows
  • 12 columns
Loading...

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

Alabaster Township - Time Series For Statistical Variables

@datacommons.cities.alabaster_township_geoid_2600760
  • 90.38 kB
  • 14,335 rows
  • 12 columns
Loading...

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

Alachua - Time Series For Statistical Variables

@datacommons.cities.alachua_geoid_1200375
  • 3.26 MB
  • 356,978 rows
  • 12 columns
Loading...

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

Alafaya - Time Series For Statistical Variables

@datacommons.cities.alafaya_geoid_1200410
  • 3.77 MB
  • 378,121 rows
  • 12 columns
Loading...

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

Alagir - Time Series For Statistical Variables

@datacommons.cities.alagir_wikidataid_q103196
  • 68.28 kB
  • 8,920 rows
  • 12 columns
Loading...

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

Alagonia - Time Series For Statistical Variables

@datacommons.cities.alagonia_wikidataid_q3773354
  • 47.49 kB
  • 5,858 rows
  • 12 columns
Loading...

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

Al-Ahsa Governorate - Time Series For Statistical Variables

@datacommons.cities.al_ahsa_governorate_wikidataid_q4702167
  • 33.87 kB
  • 3,997 rows
  • 12 columns
Loading...

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

Alaiedon Township - Time Series For Statistical Variables

@datacommons.cities.alaiedon_township_geoid_2600800
  • 95.52 kB
  • 15,308 rows
  • 12 columns
Loading...

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

Al-Ain Region, Abu Dhabi - Time Series For Statistical Variables

@datacommons.cities.al_ain_region_abu_dhabi_wikidataid_q12193915
  • 35.92 kB
  • 4,150 rows
  • 12 columns
Loading...

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

Al Ain - Time Series For Statistical Variables

@datacommons.cities.al_ain_wikidataid_q234600
  • 37.65 kB
  • 4,153 rows
  • 12 columns
Loading...

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

Alajo - Time Series For Statistical Variables

@datacommons.cities.alajo_wikidataid_q20644914
  • 39.71 kB
  • 4,878 rows
  • 12 columns
Loading...

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

Alajärvi - Time Series For Statistical Variables

@datacommons.cities.alaj_rvi_wikidataid_q5980
  • 54.24 kB
  • 6,851 rows
  • 12 columns
Loading...

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

Alajuela - Time Series For Statistical Variables

@datacommons.cities.alajuela_wikidataid_q37104
  • 45.95 kB
  • 5,736 rows
  • 12 columns
Loading...

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

Alajuelita District - Time Series For Statistical Variables

@datacommons.cities.alajuelita_district_wikidataid_q3410901
  • 45.37 kB
  • 5,833 rows
  • 12 columns
Loading...

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

Alakanuk - Time Series For Statistical Variables

@datacommons.cities.alakanuk_geoid_0201200
  • 1.43 MB
  • 184,287 rows
  • 12 columns
Loading...

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

Alakple - Time Series For Statistical Variables

@datacommons.cities.alakple_wikidataid_q16733344
  • 27.91 kB
  • 2,967 rows
  • 12 columns
Loading...

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

Al-Alani - Time Series For Statistical Variables

@datacommons.cities.al_alani_wikidataid_q4702175
  • 17.16 kB
  • 1,558 rows
  • 12 columns
Loading...

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

Alamance - Time Series For Statistical Variables

@datacommons.cities.alamance_geoid_3700640
  • 3.01 MB
  • 347,571 rows
  • 12 columns
Loading...

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

Alamarvdasht - Time Series For Statistical Variables

@datacommons.cities.alamarvdasht_wikidataid_q4370533
  • 16.33 kB
  • 1,243 rows
  • 12 columns
Loading...

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

Alambari - Time Series For Statistical Variables

@datacommons.cities.alambari_wikidataid_q513601
  • 33.25 kB
  • 3,021 rows
  • 12 columns
Loading...

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

Alameda - Time Series For Statistical Variables

@datacommons.cities.alameda_geoid_0600562
  • 3.95 MB
  • 389,326 rows
  • 12 columns
Loading...

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

Alameda - Time Series For Statistical Variables

@datacommons.cities.alameda_wikidataid_q704961
  • 79.86 kB
  • 12,252 rows
  • 12 columns
Loading...

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

Alamedilla Del Berrocal - Time Series For Statistical Variables

@datacommons.cities.alamedilla_del_berrocal_wikidataid_q8192997
  • 43.22 kB
  • 5,529 rows
  • 12 columns
Loading...

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

Alamillo - Time Series For Statistical Variables

@datacommons.cities.alamillo_geoid_3501640
  • 2.71 MB
  • 333,581 rows
  • 12 columns
Loading...

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

Alaminos - Time Series For Statistical Variables

@datacommons.cities.alaminos_wikidataid_q43162
  • 52.63 kB
  • 6,036 rows
  • 12 columns
Loading...

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