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

Awan Patti - Time Series For Statistical Variables

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

Awara - Time Series For Statistical Variables

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

Awasa (Hawassa) - Time Series For Statistical Variables

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

Awasa - Time Series For Statistical Variables

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

Awa - Time Series For Statistical Variables

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

Aweil, South Sudan - Time Series For Statistical Variables

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

Awendaw - Time Series For Statistical Variables

@datacommons.cities.awendaw_geoid_4503385
  • 2.92 MB
  • 343,704 rows
  • 12 columns
Loading... 
CREATE TABLE awendaw_geoid_4503385 (
  "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š - Time Series For Statistical Variables

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

Awjila - Time Series For Statistical Variables

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

Awka - Time Series For Statistical Variables

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

Axapusco - Time Series For Statistical Variables

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

Axe Creek - Time Series For Statistical Variables

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

Axel - Time Series For Statistical Variables

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

Axim - Time Series For Statistical Variables

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

Axioupoli - Time Series For Statistical Variables

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

Axis - Time Series For Statistical Variables

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

Axminster - Time Series For Statistical Variables

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

Axson - Time Series For Statistical Variables

@datacommons.cities.axson_geoid_1304700
  • 998.33 kB
  • 64,864 rows
  • 12 columns
Loading... 
CREATE TABLE axson_geoid_1304700 (
  "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
);

Axtell - Time Series For Statistical Variables

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

Axtell - Time Series For Statistical Variables

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

Axum - Time Series For Statistical Variables

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

Ayabaca - Time Series For Statistical Variables

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

Ayabe - Time Series For Statistical Variables

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

Ayacucho - Time Series For Statistical Variables

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

Ayagawa - Time Series For Statistical Variables

@datacommons.cities.ayagawa_wikidataid_q1156043
  • 59.15 kB
  • 7,309 rows
  • 12 columns
Loading... 
CREATE TABLE ayagawa_wikidataid_q1156043 (
  "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.