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

Aloha - Time Series For Statistical Variables

@datacommons.cities.aloha_geoid_4101650
  • 3.59 MB
  • 369,312 rows
  • 12 columns
Loading... 
CREATE TABLE aloha_geoid_4101650 (
  "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
);

Aloha Township - Time Series For Statistical Variables

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

Aloja - Time Series For Statistical Variables

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

Alondra Park - Time Series For Statistical Variables

@datacommons.cities.alondra_park_geoid_0601150
  • 3.18 MB
  • 359,443 rows
  • 12 columns
Loading... 
CREATE TABLE alondra_park_geoid_0601150 (
  "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
);

Alonei Abba - Time Series For Statistical Variables

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

Alonnah - Time Series For Statistical Variables

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

Alonsa - Time Series For Statistical Variables

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

Alor Setar - Time Series For Statistical Variables

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

Alorton - Time Series For Statistical Variables

@datacommons.cities.alorton_geoid_1700958
  • 2.88 MB
  • 322,783 rows
  • 12 columns
Loading... 
CREATE TABLE alorton_geoid_1700958 (
  "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
);

Alotau - Time Series For Statistical Variables

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

Alpartir - Time Series For Statistical Variables

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

Alpaugh - Time Series For Statistical Variables

@datacommons.cities.alpaugh_geoid_0601164
  • 2.85 MB
  • 343,307 rows
  • 12 columns
Loading... 
CREATE TABLE alpaugh_geoid_0601164 (
  "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
);

Alpedrinha - Time Series For Statistical Variables

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

Alpena - Time Series For Statistical Variables

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

Alpena - Time Series For Statistical Variables

@datacommons.cities.alpena_geoid_2601740
  • 3.35 MB
  • 361,552 rows
  • 12 columns
Loading... 
CREATE TABLE alpena_geoid_2601740 (
  "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
);

Alpena - Time Series For Statistical Variables

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

Alpena Township - Time Series For Statistical Variables

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

Alpena Township - Time Series For Statistical Variables

@datacommons.cities.alpena_township_geoid_4601060
  • 98.18 kB
  • 15,430 rows
  • 12 columns
Loading... 
CREATE TABLE alpena_township_geoid_4601060 (
  "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
);

Alpha - Time Series For Statistical Variables

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

Alpha - Time Series For Statistical Variables

@datacommons.cities.alpha_geoid_2601800
  • 2.78 MB
  • 339,097 rows
  • 12 columns
Loading... 
CREATE TABLE alpha_geoid_2601800 (
  "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
);

Alpha - Time Series For Statistical Variables

@datacommons.cities.alpha_geoid_2701162
  • 2.79 MB
  • 340,798 rows
  • 12 columns
Loading... 
CREATE TABLE alpha_geoid_2701162 (
  "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
);

Alpha - Time Series For Statistical Variables

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

Alpharetta - Time Series For Statistical Variables

@datacommons.cities.alpharetta_geoid_1301696
  • 3.85 MB
  • 379,746 rows
  • 12 columns
Loading... 
CREATE TABLE alpharetta_geoid_1301696 (
  "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
);

Alpha Township - Time Series For Statistical Variables

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

Alpha - Time Series For Statistical Variables

@datacommons.cities.alpha_wikidataid_q2839458
  • 38.42 kB
  • 4,464 rows
  • 12 columns
Loading... 
CREATE TABLE alpha_wikidataid_q2839458 (
  "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.