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

Ayodhya - Time Series For Statistical Variables

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

Ayoquezco De Aldama - Time Series For Statistical Variables

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

Ayothaya - Time Series For Statistical Variables

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

Ayotoxco De Guerrero - Time Series For Statistical Variables

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

Ayoun El Atrous - Time Series For Statistical Variables

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

Ayr - Time Series For Statistical Variables

@datacommons.cities.ayr_geoid_3102865
  • 2.76 MB
  • 338,591 rows
  • 12 columns
Loading... 
CREATE TABLE ayr_geoid_3102865 (
  "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
);

Ayr - Time Series For Statistical Variables

@datacommons.cities.ayr_geoid_3804020
  • 1.22 MB
  • 172,123 rows
  • 12 columns
Loading... 
CREATE TABLE ayr_geoid_3804020 (
  "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
);

Ayrshire - Time Series For Statistical Variables

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

Ayr Township, Adams County, Nebraska - Time Series For Statistical Variables

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

Ayr Township - Time Series For Statistical Variables

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

Ayr Township - Time Series For Statistical Variables

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

Ayr - Time Series For Statistical Variables

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

Ayr - Time Series For Statistical Variables

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

Aytos - Time Series For Statistical Variables

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

Ayutla - Time Series For Statistical Variables

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

Ayvacık - Time Series For Statistical Variables

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

Azabu-Mamianachō - Time Series For Statistical Variables

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

Azabu-Nagasakachō - Time Series For Statistical Variables

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

Azadshahr - Time Series For Statistical Variables

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

Azagra - Time Series For Statistical Variables

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

Azalea Park - Time Series For Statistical Variables

@datacommons.cities.azalea_park_geoid_1202850
  • 3.25 MB
  • 356,728 rows
  • 12 columns
Loading... 
CREATE TABLE azalea_park_geoid_1202850 (
  "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
);

Azalia - Time Series For Statistical Variables

@datacommons.cities.azalia_geoid_1803052
  • 790.89 kB
  • 37,241 rows
  • 12 columns
Loading... 
CREATE TABLE azalia_geoid_1803052 (
  "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
);

Azambuja (town) - Time Series For Statistical Variables

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

Azambuja - Time Series For Statistical Variables

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

Azamino - Time Series For Statistical Variables

@datacommons.cities.azamino_wikidataid_q4832207
  • 68.28 kB
  • 9,728 rows
  • 12 columns
Loading... 
CREATE TABLE azamino_wikidataid_q4832207 (
  "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.