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

Algodones - Time Series For Statistical Variables

@datacommons.cities.algodones_geoid_3502210
  • 2.94 MB
  • 346,486 rows
  • 12 columns
Loading... 
CREATE TABLE algodones_geoid_3502210 (
  "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
);

Algoma - Time Series For Statistical Variables

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

Algoma - Time Series For Statistical Variables

@datacommons.cities.algoma_geoid_5501000
  • 3.13 MB
  • 355,111 rows
  • 12 columns
Loading... 
CREATE TABLE algoma_geoid_5501000 (
  "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
);

Algoma - Time Series For Statistical Variables

@datacommons.cities.algoma_geoid_5501025
  • 85.14 kB
  • 13,791 rows
  • 12 columns
Loading... 
CREATE TABLE algoma_geoid_5501025 (
  "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
);

Algoma Township - Time Series For Statistical Variables

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

Algonac - Time Series For Statistical Variables

@datacommons.cities.algonac_geoid_2601180
  • 3.2 MB
  • 356,382 rows
  • 12 columns
Loading... 
CREATE TABLE algonac_geoid_2601180 (
  "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
);

Algona - Time Series For Statistical Variables

@datacommons.cities.algona_geoid_1901135
  • 3.15 MB
  • 355,309 rows
  • 12 columns
Loading... 
CREATE TABLE algona_geoid_1901135 (
  "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
);

Algona - Time Series For Statistical Variables

@datacommons.cities.algona_geoid_5301290
  • 3.18 MB
  • 359,207 rows
  • 12 columns
Loading... 
CREATE TABLE algona_geoid_5301290 (
  "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
);

Algonquin - Time Series For Statistical Variables

@datacommons.cities.algonquin_geoid_1700685
  • 3.4 MB
  • 363,484 rows
  • 12 columns
Loading... 
CREATE TABLE algonquin_geoid_1700685 (
  "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
);

Algonquin - Time Series For Statistical Variables

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

Algonquin Highlands - Time Series For Statistical Variables

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

Algonquin Township - Time Series For Statistical Variables

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

Algood - Time Series For Statistical Variables

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

Algés - Time Series For Statistical Variables

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

Algueirão–Mem Martins - Time Series For Statistical Variables

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

Alhadas - Time Series For Statistical Variables

@datacommons.cities.alhadas_wikidataid_q1024149
  • 58.38 kB
  • 7,848 rows
  • 12 columns
Loading... 
CREATE TABLE alhadas_wikidataid_q1024149 (
  "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-Hadher, Syria - Time Series For Statistical Variables

@datacommons.cities.al_hadher_syria_wikidataid_q12206894
  • 46.08 kB
  • 5,714 rows
  • 12 columns
Loading... 
CREATE TABLE al_hadher_syria_wikidataid_q12206894 (
  "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-Haffah - Time Series For Statistical Variables

@datacommons.cities.al_haffah_wikidataid_q2371098
  • 44.77 kB
  • 5,715 rows
  • 12 columns
Loading... 
CREATE TABLE al_haffah_wikidataid_q2371098 (
  "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-Hajar Al-Aswad - Time Series For Statistical Variables

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

Alhama De Aragón - Time Series For Statistical Variables

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

Alhambra - Time Series For Statistical Variables

@datacommons.cities.alhambra_geoid_0600884
  • 4.15 MB
  • 398,463 rows
  • 12 columns
Loading... 
CREATE TABLE alhambra_geoid_0600884 (
  "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
);

Alhambra - Time Series For Statistical Variables

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

Alhambra, Montana - Time Series For Statistical Variables

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

Alhambra Township - Time Series For Statistical Variables

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

Alhambra Valley - Time Series For Statistical Variables

@datacommons.cities.alhambra_valley_geoid_0600898
  • 2.83 MB
  • 342,318 rows
  • 12 columns
Loading... 
CREATE TABLE alhambra_valley_geoid_0600898 (
  "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.