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

Assens - Time Series For Statistical Variables

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

Assentoft - Time Series For Statistical Variables

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

Assen - Time Series For Statistical Variables

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

Assequins - Time Series For Statistical Variables

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

Assiniboia - Time Series For Statistical Variables

@datacommons.cities.assiniboia_wikidataid_q704679
  • 61.94 kB
  • 9,883 rows
  • 12 columns
Loading... 
CREATE TABLE assiniboia_wikidataid_q704679 (
  "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
);

Assis - Time Series For Statistical Variables

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

Assomada - Time Series For Statistical Variables

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

Assorus - Time Series For Statistical Variables

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

Assos - Time Series For Statistical Variables

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

As Sulayyil - Time Series For Statistical Variables

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

Assumption - Time Series For Statistical Variables

@datacommons.cities.assumption_geoid_1702609
  • 3.01 MB
  • 352,076 rows
  • 12 columns
Loading... 
CREATE TABLE assumption_geoid_1702609 (
  "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
);

Assumption Township - Time Series For Statistical Variables

@datacommons.cities.assumption_township_geoid_1702622
  • 83.25 kB
  • 13,650 rows
  • 12 columns
Loading... 
CREATE TABLE assumption_township_geoid_1702622 (
  "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
);

Assumption - Time Series For Statistical Variables

@datacommons.cities.assumption_wikidataid_q575351
  • 85.98 kB
  • 13,620 rows
  • 12 columns
Loading... 
CREATE TABLE assumption_wikidataid_q575351 (
  "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
);

Assyria Township - Time Series For Statistical Variables

@datacommons.cities.assyria_township_geoid_2603860
  • 89.17 kB
  • 13,753 rows
  • 12 columns
Loading... 
CREATE TABLE assyria_township_geoid_2603860 (
  "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
);

Astacinga - Time Series For Statistical Variables

@datacommons.cities.astacinga_undata_geo_c16801923
  • 9.22 kB
  • 1 row
  • 12 columns
Loading... 
CREATE TABLE astacinga_undata_geo_c16801923 (
  "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ğstafa - Time Series For Statistical Variables

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

Astakos - Time Series For Statistical Variables

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

Astaneh - Time Series For Statistical Variables

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

Astaneh-ye Ashrafiyeh - Time Series For Statistical Variables

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

Astara - Time Series For Statistical Variables

@datacommons.cities.astara_wikidataid_q266896
  • 73.52 kB
  • 9,543 rows
  • 12 columns
Loading... 
CREATE TABLE astara_wikidataid_q266896 (
  "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
);

Astara - Time Series For Statistical Variables

@datacommons.cities.astara_wikidataid_q645855
  • 73.63 kB
  • 9,538 rows
  • 12 columns
Loading... 
CREATE TABLE astara_wikidataid_q645855 (
  "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
);

Astatula - Time Series For Statistical Variables

@datacommons.cities.astatula_geoid_1202250
  • 3.04 MB
  • 348,550 rows
  • 12 columns
Loading... 
CREATE TABLE astatula_geoid_1202250 (
  "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
);

Asti - Time Series For Statistical Variables

@datacommons.cities.asti_geoid_0603036
  • 87.04 kB
  • 14,235 rows
  • 12 columns
Loading... 
CREATE TABLE asti_geoid_0603036 (
  "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
);

Asti - Time Series For Statistical Variables

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

Aston Bay - Time Series For Statistical Variables

@datacommons.cities.aston_bay_wikidataid_q10420874
  • 62.53 kB
  • 7,340 rows
  • 12 columns
Loading... 
CREATE TABLE aston_bay_wikidataid_q10420874 (
  "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.