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

Ajdovščina - Time Series For Statistical Variables

@datacommons.cities.ajdov_ina_wikidataid_q15854
  • 53.57 kB
  • 6,408 rows
  • 12 columns
Loading... 

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

Ajigasawa - Time Series For Statistical Variables

@datacommons.cities.ajigasawa_wikidataid_q1347560
  • 57.88 kB
  • 7,313 rows
  • 12 columns
Loading... 

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

Ajin - Time Series For Statistical Variables

@datacommons.cities.ajin_wikidataid_q4699744
  • 9.44 kB
  • 1 row
  • 12 columns
Loading... 

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

Ajitgarh - Time Series For Statistical Variables

@datacommons.cities.ajitgarh_wikidataid_q1949069
  • 43.62 kB
  • 4,770 rows
  • 12 columns
Loading... 

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

Ajka - Time Series For Statistical Variables

@datacommons.cities.ajka_wikidataid_q206872
  • 49.29 kB
  • 6,008 rows
  • 12 columns
Loading... 

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

Ajloun - Time Series For Statistical Variables

@datacommons.cities.ajloun_wikidataid_q1141858
  • 48.93 kB
  • 6,349 rows
  • 12 columns
Loading... 

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

Ajman - Time Series For Statistical Variables

@datacommons.cities.ajman_wikidataid_q530171
  • 46.11 kB
  • 6,180 rows
  • 12 columns
Loading... 

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

Ajmer - Time Series For Statistical Variables

@datacommons.cities.ajmer_wikidataid_q200049
  • 31.18 kB
  • 3,323 rows
  • 12 columns
Loading... 

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

Ajo - Time Series For Statistical Variables

@datacommons.cities.ajo_geoid_0400870
  • 3.05 MB
  • 348,473 rows
  • 12 columns
Loading... 

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

Akabane-Dai - Time Series For Statistical Variables

@datacommons.cities.akabane_dai_wikidataid_q11635933
  • 66.77 kB
  • 8,900 rows
  • 12 columns
Loading... 

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

Akabane-Kita - Time Series For Statistical Variables

@datacommons.cities.akabane_kita_wikidataid_q11635930
  • 66.93 kB
  • 8,900 rows
  • 12 columns
Loading... 

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

Akabane - Time Series For Statistical Variables

@datacommons.cities.akabane_wikidataid_q11635923
  • 66.56 kB
  • 8,900 rows
  • 12 columns
Loading... 

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

Akabira - Time Series For Statistical Variables

@datacommons.cities.akabira_wikidataid_q413804
  • 63.67 kB
  • 8,108 rows
  • 12 columns
Loading... 

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

Akaiwa - Time Series For Statistical Variables

@datacommons.cities.akaiwa_wikidataid_q415372
  • 59.08 kB
  • 7,408 rows
  • 12 columns
Loading... 

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

Akçakale - Time Series For Statistical Variables

@datacommons.cities.ak_akale_wikidataid_q424700
  • 49.71 kB
  • 5,655 rows
  • 12 columns
Loading... 

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

Akanda - Time Series For Statistical Variables

@datacommons.cities.akanda_wikidataid_q21294265
  • 48.14 kB
  • 6,076 rows
  • 12 columns
Loading... 

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

Akan - Time Series For Statistical Variables

@datacommons.cities.akan_geoid_5500675
  • 84.7 kB
  • 13,646 rows
  • 12 columns
Loading... 

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

Akaroa - Time Series For Statistical Variables

@datacommons.cities.akaroa_wikidataid_q416098
  • 51.18 kB
  • 6,616 rows
  • 12 columns
Loading... 

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

Akashi - Time Series For Statistical Variables

@datacommons.cities.akashi_wikidataid_q26406
  • 65.12 kB
  • 8,376 rows
  • 12 columns
Loading... 

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

Akaska - Time Series For Statistical Variables

@datacommons.cities.akaska_geoid_4600540
  • 2.69 MB
  • 333,842 rows
  • 12 columns
Loading... 

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

Akatsukichō - Time Series For Statistical Variables

@datacommons.cities.akatsukich_wikidataid_q11514861
  • 67.23 kB
  • 8,939 rows
  • 12 columns
Loading... 

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

Akçay - Time Series For Statistical Variables

@datacommons.cities.ak_ay_wikidataid_q424715
  • 22.95 kB
  • 1,998 rows
  • 12 columns
Loading... 

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

Akbarpur - Time Series For Statistical Variables

@datacommons.cities.akbarpur_wikidataid_q416835
  • 24.76 kB
  • 2,376 rows
  • 12 columns
Loading... 

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

Ak Chin - Time Series For Statistical Variables

@datacommons.cities.ak_chin_geoid_0400940
  • 2.48 MB
  • 315,378 rows
  • 12 columns
Loading... 

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

Ak-Chin Village - Time Series For Statistical Variables

@datacommons.cities.ak_chin_village_geoid_0401090
  • 2.98 MB
  • 351,763 rows
  • 12 columns
Loading... 

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