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 Zab - Time Series For Statistical Variables

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

Alzada - Time Series For Statistical Variables

@datacommons.cities.alzada_geoid_3001300
  • 2.63 MB
  • 330,251 rows
  • 12 columns
Loading... 
CREATE TABLE alzada_geoid_3001300 (
  "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
);

Alzada - Time Series For Statistical Variables

@datacommons.cities.alzada_wikidataid_q3472450
  • 69.12 kB
  • 11,289 rows
  • 12 columns
Loading... 
CREATE TABLE alzada_wikidataid_q3472450 (
  "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 Zahra - Time Series For Statistical Variables

@datacommons.cities.al_zahra_wikidataid_q15178991
  • 49.13 kB
  • 6,288 rows
  • 12 columns
Loading... 
CREATE TABLE al_zahra_wikidataid_q15178991 (
  "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-Zahra - Time Series For Statistical Variables

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

Alzamay - Time Series For Statistical Variables

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

Alzenau - Time Series For Statistical Variables

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

Alzey - Time Series For Statistical Variables

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

Alzingen - Time Series For Statistical Variables

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

Alzira - Time Series For Statistical Variables

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

Alzuza - Time Series For Statistical Variables

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

Amacuzac - Time Series For Statistical Variables

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

Amada Acres - Time Series For Statistical Variables

@datacommons.cities.amada_acres_geoid_4802286
  • 1.19 MB
  • 167,979 rows
  • 12 columns
Loading... 
CREATE TABLE amada_acres_geoid_4802286 (
  "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
);

Amado - Time Series For Statistical Variables

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

Amadora - Time Series For Statistical Variables

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

Amadora - Time Series For Statistical Variables

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

Amador City - Time Series For Statistical Variables

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

Amador Pines - Time Series For Statistical Variables

@datacommons.cities.amador_pines_geoid_0601518
  • 1.03 MB
  • 63,305 rows
  • 12 columns
Loading... 
CREATE TABLE amador_pines_geoid_0601518 (
  "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
);

Amador Township - Time Series For Statistical Variables

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

Amagansett - Time Series For Statistical Variables

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

Amagasaki - Time Series For Statistical Variables

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

Ama - Time Series For Statistical Variables

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

Amagi - Time Series For Statistical Variables

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

Amagon - Time Series For Statistical Variables

@datacommons.cities.amagon_geoid_0501270
  • 1.3 MB
  • 180,697 rows
  • 12 columns
Loading... 
CREATE TABLE amagon_geoid_0501270 (
  "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
);

Amakusa - Time Series For Statistical Variables

@datacommons.cities.amakusa_wikidataid_q452634
  • 62.05 kB
  • 7,642 rows
  • 12 columns
Loading... 
CREATE TABLE amakusa_wikidataid_q452634 (
  "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.