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

Abragão - Time Series For Statistical Variables

@datacommons.cities.abrag_o_wikidataid_q323340
  • 55.55 kB
  • 7,164 rows
  • 12 columns
Loading... 

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

Abram - Time Series For Statistical Variables

@datacommons.cities.abram_geoid_4801060
  • 2.87 MB
  • 342,394 rows
  • 12 columns
Loading... 

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

Abram-Perezville - Time Series For Statistical Variables

@datacommons.cities.abram_perezville_geoid_4801066
  • 78.32 kB
  • 14,108 rows
  • 12 columns
Loading... 

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

Abrams - Time Series For Statistical Variables

@datacommons.cities.abrams_geoid_5500150
  • 2.85 MB
  • 343,781 rows
  • 12 columns
Loading... 

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

Abrams - Time Series For Statistical Variables

@datacommons.cities.abrams_geoid_5500175
  • 95.17 kB
  • 15,112 rows
  • 12 columns
Loading... 

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

Abrantes - Time Series For Statistical Variables

@datacommons.cities.abrantes_undata_geo_c20700001
  • 9.28 kB
  • 3 rows
  • 12 columns
Loading... 

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

Abrantes - Time Series For Statistical Variables

@datacommons.cities.abrantes_wikidataid_q331191
  • 16.3 kB
  • 994 rows
  • 12 columns
Loading... 

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

Abraveses - Time Series For Statistical Variables

@datacommons.cities.abraveses_wikidataid_q168332
  • 50.62 kB
  • 6,282 rows
  • 12 columns
Loading... 

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

Abreus - Time Series For Statistical Variables

@datacommons.cities.abreus_wikidataid_q331384
  • 27.91 kB
  • 3,210 rows
  • 12 columns
Loading... 

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

Abrisham - Time Series For Statistical Variables

@datacommons.cities.abrisham_wikidataid_q2614216
  • 37.55 kB
  • 4,490 rows
  • 12 columns
Loading... 

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

Abrud - Time Series For Statistical Variables

@datacommons.cities.abrud_wikidataid_q331577
  • 59.25 kB
  • 7,277 rows
  • 12 columns
Loading... 

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

Absard - Time Series For Statistical Variables

@datacommons.cities.absard_wikidataid_q1771952
  • 10.31 kB
  • 42 rows
  • 12 columns
Loading... 

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

Absarokee - Time Series For Statistical Variables

@datacommons.cities.absarokee_geoid_3000175
  • 2.94 MB
  • 342,569 rows
  • 12 columns
Loading... 

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

Absecon - Time Series For Statistical Variables

@datacommons.cities.absecon_geoid_3400100
  • 3.31 MB
  • 361,733 rows
  • 12 columns
Loading... 

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

Absecon Highlands - Time Series For Statistical Variables

@datacommons.cities.absecon_highlands_geoid_3400160
  • 1.07 MB
  • 67,052 rows
  • 12 columns
Loading... 

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

Abu Dhabi - Time Series For Statistical Variables

@datacommons.cities.abu_dhabi_wikidataid_q1519
  • 33.56 kB
  • 4,015 rows
  • 12 columns
Loading... 

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

Abu Hamad - Time Series For Statistical Variables

@datacommons.cities.abu_hamad_wikidataid_q2439710
  • 33.24 kB
  • 4,553 rows
  • 12 columns
Loading... 

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

Abu Homeyzeh - Time Series For Statistical Variables

@datacommons.cities.abu_homeyzeh_wikidataid_q979176
  • 9.47 kB
  • 1 row
  • 12 columns
Loading... 

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

Abuja - Time Series For Statistical Variables

@datacommons.cities.abuja_wikidataid_q3787
  • 16.61 kB
  • 1,402 rows
  • 12 columns
Loading... 

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

Abu Kabir - Time Series For Statistical Variables

@datacommons.cities.abu_kabir_wikidataid_q335716
  • 14.12 kB
  • 723 rows
  • 12 columns
Loading... 

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

Abu Mena - Time Series For Statistical Variables

@datacommons.cities.abu_mena_wikidataid_q9278
  • 44.52 kB
  • 5,750 rows
  • 12 columns
Loading... 

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

Abu Musa - Time Series For Statistical Variables

@datacommons.cities.abu_musa_wikidataid_q4359113
  • 24.46 kB
  • 2,462 rows
  • 12 columns
Loading... 

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

Abu Qirqas - Time Series For Statistical Variables

@datacommons.cities.abu_qirqas_wikidataid_q3646152
  • 40.72 kB
  • 5,429 rows
  • 12 columns
Loading... 

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

Abu Qir - Time Series For Statistical Variables

@datacommons.cities.abu_qir_wikidataid_q139773
  • 45.7 kB
  • 5,703 rows
  • 12 columns
Loading... 

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

Abu Soma - Time Series For Statistical Variables

@datacommons.cities.abu_soma_wikidataid_q64019547
  • 27.77 kB
  • 3,282 rows
  • 12 columns
Loading... 

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