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

Aousserd - Time Series For Statistical Variables

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

Apache Creek - Time Series For Statistical Variables

@datacommons.cities.apache_creek_geoid_3504030
  • 2.61 MB
  • 326,687 rows
  • 12 columns
Loading... 
CREATE TABLE apache_creek_geoid_3504030 (
  "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
);

Apache - Time Series For Statistical Variables

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

Apache Junction - Time Series For Statistical Variables

@datacommons.cities.apache_junction_geoid_0402830
  • 3.45 MB
  • 365,227 rows
  • 12 columns
Loading... 
CREATE TABLE apache_junction_geoid_0402830 (
  "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
);

Apalachicola - Time Series For Statistical Variables

@datacommons.cities.apalachicola_geoid_1201625
  • 3.06 MB
  • 353,336 rows
  • 12 columns
Loading... 
CREATE TABLE apalachicola_geoid_1201625 (
  "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
);

Apalachin - Time Series For Statistical Variables

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

Apamea - Time Series For Statistical Variables

@datacommons.cities.apamea_wikidataid_q617535
  • 16.95 kB
  • 1,025 rows
  • 12 columns
Loading... 
CREATE TABLE apamea_wikidataid_q617535 (
  "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
);

Apapa - Time Series For Statistical Variables

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

Aparan - Time Series For Statistical Variables

@datacommons.cities.aparan_wikidataid_q39618
  • 93.71 kB
  • 11,311 rows
  • 12 columns
Loading... 
CREATE TABLE aparan_wikidataid_q39618 (
  "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
);

Aparecida D'Oeste - Time Series For Statistical Variables

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

Aparecida - Time Series For Statistical Variables

@datacommons.cities.aparecida_wikidataid_q617702
  • 51.16 kB
  • 5,595 rows
  • 12 columns
Loading... 
CREATE TABLE aparecida_wikidataid_q617702 (
  "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
);

Apatity - Time Series For Statistical Variables

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

Apazapan - Time Series For Statistical Variables

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

Apeldoorn - Time Series For Statistical Variables

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

Apel, Limpopo - Time Series For Statistical Variables

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

A Peneda - Time Series For Statistical Variables

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

A Peroxa, Boente - Time Series For Statistical Variables

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

Ape - Time Series For Statistical Variables

@datacommons.cities.ape_wikidataid_q618119
  • 75.14 kB
  • 10,205 rows
  • 12 columns
Loading... 
CREATE TABLE ape_wikidataid_q618119 (
  "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
);

Apex - Time Series For Statistical Variables

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

Aphek - Time Series For Statistical Variables

@datacommons.cities.aphek_wikidataid_q4779536
  • 65.1 kB
  • 8,757 rows
  • 12 columns
Loading... 
CREATE TABLE aphek_wikidataid_q4779536 (
  "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
);

Aphrodisias - Time Series For Statistical Variables

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

Apiaí - Time Series For Statistical Variables

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

Apia - Time Series For Statistical Variables

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

Apiesdoring - Time Series For Statistical Variables

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

Apison - Time Series For Statistical Variables

@datacommons.cities.apison_geoid_4701480
  • 2.95 MB
  • 345,713 rows
  • 12 columns
Loading... 
CREATE TABLE apison_geoid_4701480 (
  "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.