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

Ain Sukhna - Time Series For Statistical Variables

@datacommons.cities.ain_sukhna_wikidataid_q405881
  • 32.88 kB
  • 5,159 rows
  • 12 columns
Loading... 

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

Ainsworth - Time Series For Statistical Variables

@datacommons.cities.ainsworth_geoid_1900730
  • 2.9 MB
  • 344,441 rows
  • 12 columns
Loading... 

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

Ainsworth - Time Series For Statistical Variables

@datacommons.cities.ainsworth_geoid_3100415
  • 3.04 MB
  • 351,629 rows
  • 12 columns
Loading... 

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

Ainsworth - Time Series For Statistical Variables

@datacommons.cities.ainsworth_geoid_5500625
  • 86.68 kB
  • 13,736 rows
  • 12 columns
Loading... 

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

Ainsworth Hot Springs - Time Series For Statistical Variables

@datacommons.cities.ainsworth_hot_springs_wikidataid_q406129
  • 72.58 kB
  • 12,352 rows
  • 12 columns
Loading... 

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

Ain Zara - Time Series For Statistical Variables

@datacommons.cities.ain_zara_wikidataid_q3607155
  • 63.73 kB
  • 9,410 rows
  • 12 columns
Loading... 

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

Aioi - Time Series For Statistical Variables

@datacommons.cities.aioi_wikidataid_q406318
  • 48.31 kB
  • 5,988 rows
  • 12 columns
Loading... 

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

Aiquile - Time Series For Statistical Variables

@datacommons.cities.aiquile_wikidataid_q1617416
  • 9.56 kB
  • 2 rows
  • 12 columns
Loading... 

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

Aira - Time Series For Statistical Variables

@datacommons.cities.aira_wikidataid_q407947
  • 57.88 kB
  • 7,174 rows
  • 12 columns
Loading... 

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

Airdlin - Time Series For Statistical Variables

@datacommons.cities.airdlin_wikidataid_q4698599
  • 60.47 kB
  • 7,073 rows
  • 12 columns
Loading... 

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

Airdrie - Time Series For Statistical Variables

@datacommons.cities.airdrie_wikidataid_q408536
  • 65.82 kB
  • 9,386 rows
  • 12 columns
Loading... 

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

Airdrie - Time Series For Statistical Variables

@datacommons.cities.airdrie_wikidataid_q408537
  • 111.35 kB
  • 14,768 rows
  • 12 columns
Loading... 

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

Aireys Inlet - Time Series For Statistical Variables

@datacommons.cities.aireys_inlet_wikidataid_q120813
  • 54.74 kB
  • 6,921 rows
  • 12 columns
Loading... 

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

Air Force Academy - Time Series For Statistical Variables

@datacommons.cities.air_force_academy_geoid_0800870
  • 3.1 MB
  • 355,549 rows
  • 12 columns
Loading... 

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

Air Force Academy - Time Series For Statistical Variables

@datacommons.cities.air_force_academy_wikidataid_q2190340
  • 102.81 kB
  • 15,594 rows
  • 12 columns
Loading... 

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

Airlie Beach - Time Series For Statistical Variables

@datacommons.cities.airlie_beach_wikidataid_q408765
  • 58.46 kB
  • 7,058 rows
  • 12 columns
Loading... 

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

Airmont - Time Series For Statistical Variables

@datacommons.cities.airmont_geoid_3600408
  • 3.3 MB
  • 360,075 rows
  • 12 columns
Loading... 

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

Airmont - Time Series For Statistical Variables

@datacommons.cities.airmont_wikidataid_q408857
  • 103.66 kB
  • 15,106 rows
  • 12 columns
Loading... 

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

Airport Drive - Time Series For Statistical Variables

@datacommons.cities.airport_drive_geoid_2900424
  • 2.92 MB
  • 346,080 rows
  • 12 columns
Loading... 

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

Airport - Time Series For Statistical Variables

@datacommons.cities.airport_geoid_0600535
  • 2.99 MB
  • 350,662 rows
  • 12 columns
Loading... 

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

Airport Heights - Time Series For Statistical Variables

@datacommons.cities.airport_heights_geoid_4801500
  • 1.23 MB
  • 172,746 rows
  • 12 columns
Loading... 

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

Airport Residential Area - Time Series For Statistical Variables

@datacommons.cities.airport_residential_area_wikidataid_q20630217
  • 39.67 kB
  • 4,878 rows
  • 12 columns
Loading... 

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

Airport Road Addition - Time Series For Statistical Variables

@datacommons.cities.airport_road_addition_geoid_4801514
  • 2.68 MB
  • 334,567 rows
  • 12 columns
Loading... 

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

Airport Road - Time Series For Statistical Variables

@datacommons.cities.airport_road_geoid_5600417
  • 90.26 kB
  • 14,226 rows
  • 12 columns
Loading... 

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

Airport Township - Time Series For Statistical Variables

@datacommons.cities.airport_township_geoid_2900406
  • 98.48 kB
  • 15,650 rows
  • 12 columns
Loading... 

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