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

Ariamsvlei - Time Series For Statistical Variables

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

Arianshahr - Time Series For Statistical Variables

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

Arica - Time Series For Statistical Variables

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

Aridagawa - Time Series For Statistical Variables

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

Aridaia - Time Series For Statistical Variables

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

Arida - Time Series For Statistical Variables

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

Arietta - Time Series For Statistical Variables

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

Ariguaní - Time Series For Statistical Variables

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

Ariha - Time Series For Statistical Variables

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

Arimo - Time Series For Statistical Variables

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

Ariogala - Time Series For Statistical Variables

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

Arion - Time Series For Statistical Variables

@datacommons.cities.arion_geoid_1902755
  • 2.76 MB
  • 338,468 rows
  • 12 columns
Loading...
CREATE TABLE arion_geoid_1902755 (
  "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
);

Arion Township - Time Series For Statistical Variables

@datacommons.cities.arion_township_geoid_2002275
  • 98.44 kB
  • 14,656 rows
  • 12 columns
Loading...
CREATE TABLE arion_township_geoid_2002275 (
  "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
);

Ario - Time Series For Statistical Variables

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

Aripeka - Time Series For Statistical Variables

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

Aripeka - Time Series For Statistical Variables

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

Ariranha - Time Series For Statistical Variables

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

Arish - Time Series For Statistical Variables

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

Arispe - Time Series For Statistical Variables

@datacommons.cities.arispe_geoid_1902800
  • 2.76 MB
  • 338,735 rows
  • 12 columns
Loading...
CREATE TABLE arispe_geoid_1902800 (
  "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
);

Arispie Township - Time Series For Statistical Variables

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

Aristóbulo Del Valle - Time Series For Statistical Variables

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

Aristes - Time Series For Statistical Variables

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

Aristocrat Ranchettes - Time Series For Statistical Variables

@datacommons.cities.aristocrat_ranchettes_geoid_0803015
  • 2.95 MB
  • 346,057 rows
  • 12 columns
Loading...
CREATE TABLE aristocrat_ranchettes_geoid_0803015 (
  "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
);

Arita - Time Series For Statistical Variables

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

Ariton - Time Series For Statistical Variables

@datacommons.cities.ariton_geoid_0102428
  • 2.9 MB
  • 344,941 rows
  • 12 columns
Loading...
CREATE TABLE ariton_geoid_0102428 (
  "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.