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

Albufeira - Time Series For Statistical Variables

@datacommons.cities.albufeira_wikidataid_q373813
  • 40.03 kB
  • 4,759 rows
  • 12 columns
Loading... 
CREATE TABLE albufeira_wikidataid_q373813 (
  "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 Bukayriyah - Time Series For Statistical Variables

@datacommons.cities.al_bukayriyah_wikidataid_q20397010
  • 36.24 kB
  • 4,825 rows
  • 12 columns
Loading... 
CREATE TABLE al_bukayriyah_wikidataid_q20397010 (
  "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
);

Albuquerque - Time Series For Statistical Variables

@datacommons.cities.albuquerque_geoid_3502000
  • 4.67 MB
  • 417,457 rows
  • 12 columns
Loading... 
CREATE TABLE albuquerque_geoid_3502000 (
  "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-Buraimi - Time Series For Statistical Variables

@datacommons.cities.al_buraimi_wikidataid_q2829307
  • 35.83 kB
  • 4,155 rows
  • 12 columns
Loading... 
CREATE TABLE al_buraimi_wikidataid_q2829307 (
  "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
);

Alburgh - Time Series For Statistical Variables

@datacommons.cities.alburgh_geoid_5000625
  • 779.82 kB
  • 28,810 rows
  • 12 columns
Loading... 
CREATE TABLE alburgh_geoid_5000625 (
  "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
);

Alburgh - Time Series For Statistical Variables

@datacommons.cities.alburgh_geoid_5000850
  • 2.82 MB
  • 328,535 rows
  • 12 columns
Loading... 
CREATE TABLE alburgh_geoid_5000850 (
  "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
);

Alburgh - Time Series For Statistical Variables

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

Alburnett - Time Series For Statistical Variables

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

Alburtis - Time Series For Statistical Variables

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

Albury - Time Series For Statistical Variables

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

Alcains - Time Series For Statistical Variables

@datacommons.cities.alcains_wikidataid_q1024258
  • 27.95 kB
  • 2,563 rows
  • 12 columns
Loading... 
CREATE TABLE alcains_wikidataid_q1024258 (
  "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
);

Alcañiz - Time Series For Statistical Variables

@datacommons.cities.alca_iz_wikidataid_q24015190
  • 15.46 kB
  • 930 rows
  • 12 columns
Loading... 
CREATE TABLE alca_iz_wikidataid_q24015190 (
  "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
);

Alcalá De Ebro - Time Series For Statistical Variables

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

Alcalde - Time Series For Statistical Variables

@datacommons.cities.alcalde_geoid_3502070
  • 2.8 MB
  • 332,090 rows
  • 12 columns
Loading... 
CREATE TABLE alcalde_geoid_3502070 (
  "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
);

Alcalá De Gurrea - Time Series For Statistical Variables

@datacommons.cities.alcal_de_gurrea_wikidataid_q24013443
  • 34.75 kB
  • 3,872 rows
  • 12 columns
Loading... 
CREATE TABLE alcal_de_gurrea_wikidataid_q24013443 (
  "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
);

Alcalá De Henares - Time Series For Statistical Variables

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

Alcalá De La Selva - Time Series For Statistical Variables

@datacommons.cities.alcal_de_la_selva_wikidataid_q24015191
  • 40.04 kB
  • 4,579 rows
  • 12 columns
Loading... 
CREATE TABLE alcal_de_la_selva_wikidataid_q24015191 (
  "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
);

Alcalá Del Obispo - Time Series For Statistical Variables

@datacommons.cities.alcal_del_obispo_wikidataid_q24013442
  • 34.64 kB
  • 3,872 rows
  • 12 columns
Loading... 
CREATE TABLE alcal_del_obispo_wikidataid_q24013442 (
  "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
);

Alcalá De Moncayo - Time Series For Statistical Variables

@datacommons.cities.alcal_de_moncayo_wikidataid_q24016511
  • 23.4 kB
  • 2,216 rows
  • 12 columns
Loading... 
CREATE TABLE alcal_de_moncayo_wikidataid_q24016511 (
  "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
);

Alcan Border - Time Series For Statistical Variables

@datacommons.cities.alcan_border_geoid_0201390
  • 1.17 MB
  • 167,138 rows
  • 12 columns
Loading... 
CREATE TABLE alcan_border_geoid_0201390 (
  "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
);

Alcanena - Time Series For Statistical Variables

@datacommons.cities.alcanena_undata_geo_c20700008
  • 9.28 kB
  • 3 rows
  • 12 columns
Loading... 
CREATE TABLE alcanena_undata_geo_c20700008 (
  "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
);

Alcanena - Time Series For Statistical Variables

@datacommons.cities.alcanena_wikidataid_q31877477
  • 27.22 kB
  • 2,588 rows
  • 12 columns
Loading... 
CREATE TABLE alcanena_wikidataid_q31877477 (
  "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
);

Alcanena - Time Series For Statistical Variables

@datacommons.cities.alcanena_wikidataid_q986107
  • 27.67 kB
  • 2,605 rows
  • 12 columns
Loading... 
CREATE TABLE alcanena_wikidataid_q986107 (
  "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
);

Alcanhões - Time Series For Statistical Variables

@datacommons.cities.alcanh_es_wikidataid_q2296664
  • 15.94 kB
  • 922 rows
  • 12 columns
Loading... 
CREATE TABLE alcanh_es_wikidataid_q2296664 (
  "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
);

Alcácer Do Sal - Time Series For Statistical Variables

@datacommons.cities.alc_cer_do_sal_wikidataid_q850697
  • 11.33 kB
  • 319 rows
  • 12 columns
Loading... 
CREATE TABLE alc_cer_do_sal_wikidataid_q850697 (
  "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.