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

Amaranth - Time Series For Statistical Variables

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

Amarapura - Time Series For Statistical Variables

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

Amaravati - Time Series For Statistical Variables

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

Amara - Time Series For Statistical Variables

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

Amares - Time Series For Statistical Variables

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

Amares - Time Series For Statistical Variables

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

Amarete - Time Series For Statistical Variables

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

Amargosa - Time Series For Statistical Variables

@datacommons.cities.amargosa_geoid_4802290
  • 2.64 MB
  • 329,902 rows
  • 12 columns
Loading... 
CREATE TABLE amargosa_geoid_4802290 (
  "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
);

Amargosa Valley - Time Series For Statistical Variables

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

Amarillo - Time Series For Statistical Variables

@datacommons.cities.amarillo_geoid_4803000
  • 4.11 MB
  • 388,478 rows
  • 12 columns
Loading... 
CREATE TABLE amarillo_geoid_4803000 (
  "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
);

Amarkantak - Time Series For Statistical Variables

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

Amasa - Time Series For Statistical Variables

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

Amasya - Time Series For Statistical Variables

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

Amathus - Time Series For Statistical Variables

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

AMatikulu - Time Series For Statistical Variables

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

Amatitlán - Time Series For Statistical Variables

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

Amatlán De Los Reyes - Time Series For Statistical Variables

@datacommons.cities.amatl_n_de_los_reyes_wikidataid_q20135549
  • 57.28 kB
  • 7,739 rows
  • 12 columns
Loading... 
CREATE TABLE amatl_n_de_los_reyes_wikidataid_q20135549 (
  "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_wikidataid_q451661
  • 66.22 kB
  • 8,500 rows
  • 12 columns
Loading... 
CREATE TABLE ama_wikidataid_q451661 (
  "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_wikidataid_q685865
  • 60.31 kB
  • 7,702 rows
  • 12 columns
Loading... 
CREATE TABLE ama_wikidataid_q685865 (
  "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
);

Amaxac De Guerrero - Time Series For Statistical Variables

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

Amaya - Time Series For Statistical Variables

@datacommons.cities.amaya_geoid_4803008
  • 2.56 MB
  • 326,081 rows
  • 12 columns
Loading... 
CREATE TABLE amaya_geoid_4803008 (
  "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
);

Amayas - Time Series For Statistical Variables

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

Amayuelas De Abajo - Time Series For Statistical Variables

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

Amayuelas De Arriba - Time Series For Statistical Variables

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

Amazonia - Time Series For Statistical Variables

@datacommons.cities.amazonia_geoid_2901018
  • 2.84 MB
  • 342,290 rows
  • 12 columns
Loading... 
CREATE TABLE amazonia_geoid_2901018 (
  "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.