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

Al Hamool - Time Series For Statistical Variables

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

Alhandra - Time Series For Statistical Variables

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

Al Hasahisa - Time Series For Statistical Variables

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

Al-Hasakah - Time Series For Statistical Variables

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

Al Hashimiyah - Time Series For Statistical Variables

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

Al Hashimiyya - Time Series For Statistical Variables

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

Al-Hay - Time Series For Statistical Variables

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

Alhos Vedros - Time Series For Statistical Variables

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

Al Hudaydah - Time Series For Statistical Variables

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

Al Husn - Time Series For Statistical Variables

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

Aliabad-e Katul - Time Series For Statistical Variables

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

Aliabad, Hunza - Time Series For Statistical Variables

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

Alianza Comunidad - Time Series For Statistical Variables

@datacommons.cities.alianza_comunidad_geoid_7201863
  • 1.43 MB
  • 181,592 rows
  • 12 columns
Loading... 
CREATE TABLE alianza_comunidad_geoid_7201863 (
  "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
);

Aliartos - Time Series For Statistical Variables

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

Alibunar - Time Series For Statistical Variables

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

Alicante - Time Series For Statistical Variables

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

Alice Acres - Time Series For Statistical Variables

@datacommons.cities.alice_acres_geoid_4801858
  • 2.75 MB
  • 336,627 rows
  • 12 columns
Loading... 
CREATE TABLE alice_acres_geoid_4801858 (
  "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
);

Alice Beach - Time Series For Statistical Variables

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

Alicedale - Time Series For Statistical Variables

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

Alice - Time Series For Statistical Variables

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

Alice - Time Series For Statistical Variables

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

Alice Springs - Time Series For Statistical Variables

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

Aliceton Township - Time Series For Statistical Variables

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

Aliceville - Time Series For Statistical Variables

@datacommons.cities.aliceville_geoid_0101228
  • 3.03 MB
  • 349,158 rows
  • 12 columns
Loading... 
CREATE TABLE aliceville_geoid_0101228 (
  "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
);

Alice - Time Series For Statistical Variables

@datacommons.cities.alice_wikidataid_q2003910
  • 49.22 kB
  • 5,606 rows
  • 12 columns
Loading... 
CREATE TABLE alice_wikidataid_q2003910 (
  "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.