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

Antuñano - Time Series For Statistical Variables

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

Antwerp - Time Series For Statistical Variables

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

Antwerp - Time Series For Statistical Variables

@datacommons.cities.antwerp_geoid_3902204
  • 3.04 MB
  • 354,926 rows
  • 12 columns
Loading... 
CREATE TABLE antwerp_geoid_3902204 (
  "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
);

Antwerp Township - Time Series For Statistical Variables

@datacommons.cities.antwerp_township_geoid_2603140
  • 87.62 kB
  • 13,870 rows
  • 12 columns
Loading... 
CREATE TABLE antwerp_township_geoid_2603140 (
  "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
);

Antwerp - Time Series For Statistical Variables

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

Antwerp - Time Series For Statistical Variables

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

Antwerp - Time Series For Statistical Variables

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

Anuradhapura - Time Series For Statistical Variables

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

Anvik - Time Series For Statistical Variables

@datacommons.cities.anvik_geoid_0203880
  • 1.21 MB
  • 172,506 rows
  • 12 columns
Loading... 
CREATE TABLE anvik_geoid_0203880 (
  "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
);

Ançã - Time Series For Statistical Variables

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

Anyang - Time Series For Statistical Variables

@datacommons.cities.anyang_wikidataid_q324293
  • 4.83 MB
  • 557,399 rows
  • 12 columns
Loading... 
CREATE TABLE anyang_wikidataid_q324293 (
  "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
);

Anyang - Time Series For Statistical Variables

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

Anyells - Time Series For Statistical Variables

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

Anyinam - Time Series For Statistical Variables

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

Anykščiai - Time Series For Statistical Variables

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

Anzac Village - Time Series For Statistical Variables

@datacommons.cities.anzac_village_geoid_3503970
  • 2.67 MB
  • 331,804 rows
  • 12 columns
Loading... 
CREATE TABLE anzac_village_geoid_3503970 (
  "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
);

Anza - Time Series For Statistical Variables

@datacommons.cities.anza_geoid_0602294
  • 2.97 MB
  • 344,112 rows
  • 12 columns
Loading... 
CREATE TABLE anza_geoid_0602294 (
  "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
);

Anzhero-Sudzhensk - Time Series For Statistical Variables

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

Aobadai - Time Series For Statistical Variables

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

Aoi - Time Series For Statistical Variables

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

Aomi - Time Series For Statistical Variables

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

Aomori - Time Series For Statistical Variables

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

Aoraki/Mount Cook - Time Series For Statistical Variables

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

Aostri De Losa - Time Series For Statistical Variables

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

Aoto - Time Series For Statistical Variables

@datacommons.cities.aoto_wikidataid_q11661438
  • 66.67 kB
  • 8,900 rows
  • 12 columns
Loading... 
CREATE TABLE aoto_wikidataid_q11661438 (
  "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.