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

Azandarian - Time Series For Statistical Variables

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

Azarshahr - Time Series For Statistical Variables

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

Azaz - Time Series For Statistical Variables

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

Azcapotzalco - Time Series For Statistical Variables

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

Azeitão - Time Series For Statistical Variables

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

Azinhaga - Time Series For Statistical Variables

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

Azle - Time Series For Statistical Variables

@datacommons.cities.azle_geoid_4805168
  • 3.3 MB
  • 358,775 rows
  • 12 columns
Loading... 
CREATE TABLE azle_geoid_4805168 (
  "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
);

Aznakayevo - Time Series For Statistical Variables

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

Azna - Time Series For Statistical Variables

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

Azángaro - Time Series For Statistical Variables

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

Azogues - Time Series For Statistical Variables

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

Azougui - Time Series For Statistical Variables

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

Azov - Time Series For Statistical Variables

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

Azpeitia - Time Series For Statistical Variables

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

Azpirotz-Lezaeta - Time Series For Statistical Variables

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

Aztalan - Time Series For Statistical Variables

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

Aztec - Time Series For Statistical Variables

@datacommons.cities.aztec_geoid_0404930
  • 2.47 MB
  • 319,452 rows
  • 12 columns
Loading... 
CREATE TABLE aztec_geoid_0404930 (
  "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
);

Aztec - Time Series For Statistical Variables

@datacommons.cities.aztec_geoid_3505780
  • 3.22 MB
  • 357,586 rows
  • 12 columns
Loading... 
CREATE TABLE aztec_geoid_3505780 (
  "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
);

Azuelo - Time Series For Statistical Variables

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

Azuga - Time Series For Statistical Variables

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

Azul - Time Series For Statistical Variables

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

Azumino - Time Series For Statistical Variables

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

Azure - Time Series For Statistical Variables

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

Azusa - Time Series For Statistical Variables

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

Az-Zawayda - Time Series For Statistical Variables

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