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

Alcubierre - Time Series For Statistical Variables

@datacommons.cities.alcubierre_wikidataid_q24013439
  • 53.23 kB
  • 6,776 rows
  • 12 columns
Loading...

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

Alcuéscar - Time Series For Statistical Variables

@datacommons.cities.alcu_scar_wikidataid_q1630122
  • 43.83 kB
  • 5,047 rows
  • 12 columns
Loading...

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

Alda - Time Series For Statistical Variables

@datacommons.cities.alda_geoid_3100625
  • 2.92 MB
  • 346,851 rows
  • 12 columns
Loading...

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

Aldama - Time Series For Statistical Variables

@datacommons.cities.aldama_undata_geo_c16800036
  • 9.2 kB
  • 1 row
  • 12 columns
Loading...

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

Aldan - Time Series For Statistical Variables

@datacommons.cities.aldan_geoid_4200676
  • 3.06 MB
  • 348,697 rows
  • 12 columns
Loading...

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

Aldan - Time Series For Statistical Variables

@datacommons.cities.aldan_wikidataid_q103273
  • 75.58 kB
  • 9,745 rows
  • 12 columns
Loading...

CREATE TABLE aldan_wikidataid_q103273 (
  "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-Dar Al-Kabirah - Time Series For Statistical Variables

@datacommons.cities.al_dar_al_kabirah_wikidataid_q4702331
  • 46.63 kB
  • 6,182 rows
  • 12 columns
Loading...

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

Aldara Park - Time Series For Statistical Variables

@datacommons.cities.aldara_park_wikidataid_q4713440
  • 58.51 kB
  • 7,074 rows
  • 12 columns
Loading...

CREATE TABLE aldara_park_wikidataid_q4713440 (
  "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-Darbasiyah - Time Series For Statistical Variables

@datacommons.cities.al_darbasiyah_wikidataid_q2419911
  • 50.24 kB
  • 6,229 rows
  • 12 columns
Loading...

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

Alda Township - Time Series For Statistical Variables

@datacommons.cities.alda_township_geoid_3100660
  • 97.51 kB
  • 15,196 rows
  • 12 columns
Loading...

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

Aldatz (Larraun) - Time Series For Statistical Variables

@datacommons.cities.aldatz_larraun_wikidataid_q8193895
  • 63.48 kB
  • 8,397 rows
  • 12 columns
Loading...

CREATE TABLE aldatz_larraun_wikidataid_q8193895 (
  "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-Dawha - Time Series For Statistical Variables

@datacommons.cities.al_dawha_wikidataid_q4702335
  • 63.17 kB
  • 8,657 rows
  • 12 columns
Loading...

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

Aldea Del Rey Niño - Time Series For Statistical Variables

@datacommons.cities.aldea_del_rey_ni_o_wikidataid_q8193904
  • 43.53 kB
  • 5,529 rows
  • 12 columns
Loading...

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

Aldeburgh - Time Series For Statistical Variables

@datacommons.cities.aldeburgh_wikidataid_q2077402
  • 81.31 kB
  • 11,489 rows
  • 12 columns
Loading...

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

Aldehuela (Aliaga) - Time Series For Statistical Variables

@datacommons.cities.aldehuela_aliaga_wikidataid_q16301120
  • 21.66 kB
  • 1,971 rows
  • 12 columns
Loading...

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

Aldehuela De Liestos - Time Series For Statistical Variables

@datacommons.cities.aldehuela_de_liestos_wikidataid_q22827982
  • 56.02 kB
  • 7,334 rows
  • 12 columns
Loading...

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

Aldeia Do Carvalho - Time Series For Statistical Variables

@datacommons.cities.aldeia_do_carvalho_wikidataid_q2119186
  • 38.61 kB
  • 4,640 rows
  • 12 columns
Loading...

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

Alden Center - Time Series For Statistical Variables

@datacommons.cities.alden_center_geoid_3601121
  • 99.8 kB
  • 15,934 rows
  • 12 columns
Loading...

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

Alden - Time Series For Statistical Variables

@datacommons.cities.alden_geoid_1700594
  • 923.24 kB
  • 62,073 rows
  • 12 columns
Loading...

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

Alden - Time Series For Statistical Variables

@datacommons.cities.alden_geoid_1901045
  • 2.99 MB
  • 349,708 rows
  • 12 columns
Loading...

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

Alden - Time Series For Statistical Variables

@datacommons.cities.alden_geoid_2000950
  • 2.79 MB
  • 340,848 rows
  • 12 columns
Loading...

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

Alden - Time Series For Statistical Variables

@datacommons.cities.alden_geoid_2601060
  • 2.76 MB
  • 339,132 rows
  • 12 columns
Loading...

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

Alden - Time Series For Statistical Variables

@datacommons.cities.alden_geoid_2700838
  • 2.98 MB
  • 351,104 rows
  • 12 columns
Loading...

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

Alden - Time Series For Statistical Variables

@datacommons.cities.alden_geoid_3601088
  • 3.12 MB
  • 357,128 rows
  • 12 columns
Loading...

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

Alden - Time Series For Statistical Variables

@datacommons.cities.alden_geoid_5500950
  • 76.34 kB
  • 12,745 rows
  • 12 columns
Loading...

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