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

Albelda - Time Series For Statistical Variables

@datacommons.cities.albelda_wikidataid_q24013447
  • 53.49 kB
  • 6,974 rows
  • 12 columns
Loading... 

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

Albemarle - Time Series For Statistical Variables

@datacommons.cities.albemarle_geoid_3700680
  • 3.34 MB
  • 358,936 rows
  • 12 columns
Loading... 

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

Albergaria-A-Velha - Time Series For Statistical Variables

@datacommons.cities.albergaria_a_velha_undata_geo_c20700005
  • 9.35 kB
  • 3 rows
  • 12 columns
Loading... 

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

Albergaria-a-Velha - Time Series For Statistical Variables

@datacommons.cities.albergaria_a_velha_wikidataid_q1870321
  • 41.43 kB
  • 4,983 rows
  • 12 columns
Loading... 

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

Albergaria-a-Velha - Time Series For Statistical Variables

@datacommons.cities.albergaria_a_velha_wikidataid_q31877247
  • 39.28 kB
  • 4,610 rows
  • 12 columns
Loading... 

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

Alberite De San Juan - Time Series For Statistical Variables

@datacommons.cities.alberite_de_san_juan_wikidataid_q24016515
  • 57.85 kB
  • 7,490 rows
  • 12 columns
Loading... 

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

Albero Alto - Time Series For Statistical Variables

@datacommons.cities.albero_alto_wikidataid_q24013446
  • 34.57 kB
  • 3,872 rows
  • 12 columns
Loading... 

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

Albers - Time Series For Statistical Variables

@datacommons.cities.albers_geoid_1700555
  • 2.97 MB
  • 347,591 rows
  • 12 columns
Loading... 

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

Alberta, Alabama - Time Series For Statistical Variables

@datacommons.cities.alberta_alabama_geoid_0100916
  • 77.56 kB
  • 12,995 rows
  • 12 columns
Loading... 

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

Alberta - Time Series For Statistical Variables

@datacommons.cities.alberta_geoid_2700676
  • 2.74 MB
  • 338,663 rows
  • 12 columns
Loading... 

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

Alberta - Time Series For Statistical Variables

@datacommons.cities.alberta_geoid_5100724
  • 2.85 MB
  • 342,253 rows
  • 12 columns
Loading... 

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

Alberta Township - Time Series For Statistical Variables

@datacommons.cities.alberta_township_geoid_2700668
  • 96.03 kB
  • 15,129 rows
  • 12 columns
Loading... 

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

Albert City - Time Series For Statistical Variables

@datacommons.cities.albert_city_geoid_1900865
  • 3 MB
  • 352,633 rows
  • 12 columns
Loading... 

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

Albert Falls - Time Series For Statistical Variables

@datacommons.cities.albert_falls_wikidataid_q15179071
  • 53.8 kB
  • 6,663 rows
  • 12 columns
Loading... 

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

Albert - Time Series For Statistical Variables

@datacommons.cities.albert_geoid_2000825
  • 2.8 MB
  • 341,222 rows
  • 12 columns
Loading... 

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

Albertha Township - Time Series For Statistical Variables

@datacommons.cities.albertha_township_geoid_3801020
  • 71.23 kB
  • 12,144 rows
  • 12 columns
Loading... 

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

Albertinia, Western Cape - Time Series For Statistical Variables

@datacommons.cities.albertinia_western_cape_wikidataid_q2549949
  • 57.58 kB
  • 7,244 rows
  • 12 columns
Loading... 

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

Albertirsa - Time Series For Statistical Variables

@datacommons.cities.albertirsa_wikidataid_q578823
  • 51.15 kB
  • 6,031 rows
  • 12 columns
Loading... 

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

Albert Lea - Time Series For Statistical Variables

@datacommons.cities.albert_lea_geoid_2700694
  • 3.36 MB
  • 359,265 rows
  • 12 columns
Loading... 

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

Albert Lea Township - Time Series For Statistical Variables

@datacommons.cities.albert_lea_township_geoid_2700712
  • 77.3 kB
  • 12,653 rows
  • 12 columns
Loading... 

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

Alberton - Time Series For Statistical Variables

@datacommons.cities.alberton_geoid_3000700
  • 2.89 MB
  • 344,338 rows
  • 12 columns
Loading... 

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

Alberton West - Time Series For Statistical Variables

@datacommons.cities.alberton_west_wikidataid_q4712267
  • 59.93 kB
  • 7,171 rows
  • 12 columns
Loading... 

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

Alberton - Time Series For Statistical Variables

@datacommons.cities.alberton_wikidataid_q1637702
  • 57.97 kB
  • 7,058 rows
  • 12 columns
Loading... 

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

Alberton - Time Series For Statistical Variables

@datacommons.cities.alberton_wikidataid_q4712260
  • 60.01 kB
  • 7,171 rows
  • 12 columns
Loading... 

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

Alberton - Time Series For Statistical Variables

@datacommons.cities.alberton_wikidataid_q740843
  • 71.71 kB
  • 10,601 rows
  • 12 columns
Loading... 

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