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

Aiacor - Time Series For Statistical Variables

@datacommons.cities.aiacor_wikidataid_q8210685
  • 16.39 kB
  • 914 rows
  • 12 columns
Loading... 

CREATE TABLE aiacor_wikidataid_q8210685 (
  "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
);

Aiani - Time Series For Statistical Variables

@datacommons.cities.aiani_wikidataid_q798872
  • 26.33 kB
  • 2,598 rows
  • 12 columns
Loading... 

CREATE TABLE aiani_wikidataid_q798872 (
  "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
);

Aibar - Time Series For Statistical Variables

@datacommons.cities.aibar_wikidataid_q1645830
  • 53.27 kB
  • 6,490 rows
  • 12 columns
Loading... 

CREATE TABLE aibar_wikidataid_q1645830 (
  "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
);

Aibetsu - Time Series For Statistical Variables

@datacommons.cities.aibetsu_wikidataid_q1355434
  • 63.43 kB
  • 8,096 rows
  • 12 columns
Loading... 

CREATE TABLE aibetsu_wikidataid_q1355434 (
  "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
);

Aibonito Zona Urbana - Time Series For Statistical Variables

@datacommons.cities.aibonito_zona_urbana_geoid_7201218
  • 1.67 MB
  • 195,127 rows
  • 12 columns
Loading... 

CREATE TABLE aibonito_zona_urbana_geoid_7201218 (
  "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
);

Aichach - Time Series For Statistical Variables

@datacommons.cities.aichach_wikidataid_q251678
  • 87.14 kB
  • 12,096 rows
  • 12 columns
Loading... 

CREATE TABLE aichach_wikidataid_q251678 (
  "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
);

Aichach - Time Series For Statistical Variables

@datacommons.cities.aichach_wikidataid_q31872780
  • 86.66 kB
  • 12,090 rows
  • 12 columns
Loading... 

CREATE TABLE aichach_wikidataid_q31872780 (
  "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
);

Aichtal - Time Series For Statistical Variables

@datacommons.cities.aichtal_wikidataid_q82684
  • 79.19 kB
  • 10,998 rows
  • 12 columns
Loading... 

CREATE TABLE aichtal_wikidataid_q82684 (
  "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
);

Aid Township - Time Series For Statistical Variables

@datacommons.cities.aid_township_geoid_3900562
  • 94.38 kB
  • 15,274 rows
  • 12 columns
Loading... 

CREATE TABLE aid_township_geoid_3900562 (
  "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
);

Aiea - Time Series For Statistical Variables

@datacommons.cities.aiea_geoid_1500550
  • 1.81 MB
  • 204,468 rows
  • 12 columns
Loading... 

CREATE TABLE aiea_geoid_1500550 (
  "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
);

Aigeira - Time Series For Statistical Variables

@datacommons.cities.aigeira_wikidataid_q1298059
  • 12.95 kB
  • 393 rows
  • 12 columns
Loading... 

CREATE TABLE aigeira_wikidataid_q1298059 (
  "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
);

Ai - Time Series For Statistical Variables

@datacommons.cities.ai_geoid_3900541
  • 1.01 MB
  • 65,353 rows
  • 12 columns
Loading... 

CREATE TABLE ai_geoid_3900541 (
  "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
);

Aigle - Time Series For Statistical Variables

@datacommons.cities.aigle_wikidataid_q43195
  • 73.23 kB
  • 9,651 rows
  • 12 columns
Loading... 

CREATE TABLE aigle_wikidataid_q43195 (
  "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
);

Aiguadolç - Time Series For Statistical Variables

@datacommons.cities.aiguadol_wikidataid_q67131397
  • 60.97 kB
  • 8,373 rows
  • 12 columns
Loading... 

CREATE TABLE aiguadol_wikidataid_q67131397 (
  "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
);

Aihara - Time Series For Statistical Variables

@datacommons.cities.aihara_wikidataid_q11581895
  • 70.54 kB
  • 9,752 rows
  • 12 columns
Loading... 

CREATE TABLE aihara_wikidataid_q11581895 (
  "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
);

Aihara - Time Series For Statistical Variables

@datacommons.cities.aihara_wikidataid_q11581928
  • 70.57 kB
  • 9,752 rows
  • 12 columns
Loading... 

CREATE TABLE aihara_wikidataid_q11581928 (
  "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
);

Aija - Time Series For Statistical Variables

@datacommons.cities.aija_wikidataid_q3317408
  • 23.92 kB
  • 2,442 rows
  • 12 columns
Loading... 

CREATE TABLE aija_wikidataid_q3317408 (
  "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
);

Aikawa - Time Series For Statistical Variables

@datacommons.cities.aikawa_wikidataid_q1203267
  • 70.22 kB
  • 9,810 rows
  • 12 columns
Loading... 

CREATE TABLE aikawa_wikidataid_q1203267 (
  "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
);

Aiken - Time Series For Statistical Variables

@datacommons.cities.aiken_geoid_4500550
  • 3.44 MB
  • 363,339 rows
  • 12 columns
Loading... 

CREATE TABLE aiken_geoid_4500550 (
  "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
);

Aikkarappadi - Time Series For Statistical Variables

@datacommons.cities.aikkarappadi_wikidataid_q28173946
  • 60.55 kB
  • 7,592 rows
  • 12 columns
Loading... 

CREATE TABLE aikkarappadi_wikidataid_q28173946 (
  "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
);

Ailey - Time Series For Statistical Variables

@datacommons.cities.ailey_geoid_1300828
  • 2.85 MB
  • 341,590 rows
  • 12 columns
Loading... 

CREATE TABLE ailey_geoid_1300828 (
  "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
);

Ainaži - Time Series For Statistical Variables

@datacommons.cities.aina_i_wikidataid_q405931
  • 57.1 kB
  • 7,405 rows
  • 12 columns
Loading... 

CREATE TABLE aina_i_wikidataid_q405931 (
  "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
);

Ainaloa - Time Series For Statistical Variables

@datacommons.cities.ainaloa_geoid_1501085
  • 1.6 MB
  • 192,125 rows
  • 12 columns
Loading... 

CREATE TABLE ainaloa_geoid_1501085 (
  "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
);

Ainan - Time Series For Statistical Variables

@datacommons.cities.ainan_wikidataid_q980346
  • 66.34 kB
  • 7,245 rows
  • 12 columns
Loading... 

CREATE TABLE ainan_wikidataid_q980346 (
  "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
);

Ainaro - Time Series For Statistical Variables

@datacommons.cities.ainaro_wikidataid_q1026949
  • 20.81 kB
  • 1,939 rows
  • 12 columns
Loading... 

CREATE TABLE ainaro_wikidataid_q1026949 (
  "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.