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

Altoona - Time Series For Statistical Variables

@datacommons.cities.altoona_geoid_1201050
  • 2.64 MB
  • 331,329 rows
  • 12 columns
Loading... 
CREATE TABLE altoona_geoid_1201050 (
  "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
);

Altoona - Time Series For Statistical Variables

@datacommons.cities.altoona_geoid_1901630
  • 3.36 MB
  • 360,219 rows
  • 12 columns
Loading... 
CREATE TABLE altoona_geoid_1901630 (
  "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
);

Altoona - Time Series For Statistical Variables

@datacommons.cities.altoona_geoid_2001625
  • 2.87 MB
  • 343,443 rows
  • 12 columns
Loading... 
CREATE TABLE altoona_geoid_2001625 (
  "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
);

Altoona - Time Series For Statistical Variables

@datacommons.cities.altoona_geoid_4202184
  • 3.51 MB
  • 364,806 rows
  • 12 columns
Loading... 
CREATE TABLE altoona_geoid_4202184 (
  "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
);

Altoona - Time Series For Statistical Variables

@datacommons.cities.altoona_geoid_5301745
  • 2.67 MB
  • 330,357 rows
  • 12 columns
Loading... 
CREATE TABLE altoona_geoid_5301745 (
  "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
);

Altoona - Time Series For Statistical Variables

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

Altoona Township - Time Series For Statistical Variables

@datacommons.cities.altoona_township_geoid_4601300
  • 101.99 kB
  • 15,426 rows
  • 12 columns
Loading... 
CREATE TABLE altoona_township_geoid_4601300 (
  "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
);

Alto Pass - Time Series For Statistical Variables

@datacommons.cities.alto_pass_geoid_1701205
  • 2.88 MB
  • 345,098 rows
  • 12 columns
Loading... 
CREATE TABLE alto_pass_geoid_1701205 (
  "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
);

Altory Township - Time Series For Statistical Variables

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

Altotonga - Time Series For Statistical Variables

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

Alto Township - Time Series For Statistical Variables

@datacommons.cities.alto_township_geoid_1701101
  • 95.23 kB
  • 14,869 rows
  • 12 columns
Loading... 
CREATE TABLE alto_township_geoid_1701101 (
  "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
);

Alto Township - Time Series For Statistical Variables

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

Altrincham - Time Series For Statistical Variables

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

Altstetten - Time Series For Statistical Variables

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

Altötting - Time Series For Statistical Variables

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

Altura - Time Series For Statistical Variables

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

Altura - Time Series For Statistical Variables

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

Alturas - Time Series For Statistical Variables

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

Alturas - Time Series For Statistical Variables

@datacommons.cities.alturas_geoid_1201100
  • 2.96 MB
  • 344,431 rows
  • 12 columns
Loading... 
CREATE TABLE alturas_geoid_1201100 (
  "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
);

Altus - Time Series For Statistical Variables

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

Altus - Time Series For Statistical Variables

@datacommons.cities.altus_geoid_4001700
  • 3.37 MB
  • 360,982 rows
  • 12 columns
Loading... 
CREATE TABLE altus_geoid_4001700 (
  "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
);

Altwies - Time Series For Statistical Variables

@datacommons.cities.altwies_wikidataid_q613576
  • 80.14 kB
  • 11,149 rows
  • 12 columns
Loading... 
CREATE TABLE altwies_wikidataid_q613576 (
  "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-Ubayyid - Time Series For Statistical Variables

@datacommons.cities.al_ubayyid_wikidataid_q309475
  • 37.48 kB
  • 4,687 rows
  • 12 columns
Loading... 
CREATE TABLE al_ubayyid_wikidataid_q309475 (
  "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-Ubeidiya - Time Series For Statistical Variables

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

Aluenda - Time Series For Statistical Variables

@datacommons.cities.aluenda_wikidataid_q20613100
  • 50.96 kB
  • 7,221 rows
  • 12 columns
Loading... 
CREATE TABLE aluenda_wikidataid_q20613100 (
  "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.