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

Asotin - Time Series For Statistical Variables

@datacommons.cities.asotin_geoid_5303075
  • 2.93 MB
  • 346,495 rows
  • 12 columns
Loading... 
CREATE TABLE asotin_geoid_5303075 (
  "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
);

Aso - Time Series For Statistical Variables

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

Aspatria - Time Series For Statistical Variables

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

Aspen - Time Series For Statistical Variables

@datacommons.cities.aspen_geoid_0803620
  • 3.31 MB
  • 359,351 rows
  • 12 columns
Loading... 
CREATE TABLE aspen_geoid_0803620 (
  "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
);

Aspen Hill - Time Series For Statistical Variables

@datacommons.cities.aspen_hill_geoid_2402825
  • 3.77 MB
  • 380,421 rows
  • 12 columns
Loading... 
CREATE TABLE aspen_hill_geoid_2402825 (
  "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
);

Aspen Hills, Gauteng - Time Series For Statistical Variables

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

Aspen Park - Time Series For Statistical Variables

@datacommons.cities.aspen_park_geoid_0803730
  • 2.98 MB
  • 350,394 rows
  • 12 columns
Loading... 
CREATE TABLE aspen_park_geoid_0803730 (
  "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
);

Aspen Springs - Time Series For Statistical Variables

@datacommons.cities.aspen_springs_geoid_0603026
  • 2.65 MB
  • 329,258 rows
  • 12 columns
Loading... 
CREATE TABLE aspen_springs_geoid_0603026 (
  "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
);

Asperen - Time Series For Statistical Variables

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

Asperg - Time Series For Statistical Variables

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

Aspermont - Time Series For Statistical Variables

@datacommons.cities.aspermont_geoid_4804408
  • 2.98 MB
  • 349,854 rows
  • 12 columns
Loading... 
CREATE TABLE aspermont_geoid_4804408 (
  "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
);

Aspers - Time Series For Statistical Variables

@datacommons.cities.aspers_geoid_4203312
  • 2.87 MB
  • 342,873 rows
  • 12 columns
Loading... 
CREATE TABLE aspers_geoid_4203312 (
  "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
);

Aspers - Time Series For Statistical Variables

@datacommons.cities.aspers_wikidataid_q5709452
  • 107.7 kB
  • 15,608 rows
  • 12 columns
Loading... 
CREATE TABLE aspers_wikidataid_q5709452 (
  "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
);

Aspetuck - Time Series For Statistical Variables

@datacommons.cities.aspetuck_geoid_0983430
  • 108.26 kB
  • 17,652 rows
  • 12 columns
Loading... 
CREATE TABLE aspetuck_geoid_0983430 (
  "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
);

Aspinwall - Time Series For Statistical Variables

@datacommons.cities.aspinwall_geoid_1903340
  • 2.65 MB
  • 335,010 rows
  • 12 columns
Loading... 
CREATE TABLE aspinwall_geoid_1903340 (
  "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
);

Aspinwall - Time Series For Statistical Variables

@datacommons.cities.aspinwall_geoid_4203320
  • 3.13 MB
  • 357,129 rows
  • 12 columns
Loading... 
CREATE TABLE aspinwall_geoid_4203320 (
  "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
);

Aspledon - Time Series For Statistical Variables

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

Asprovalta - Time Series For Statistical Variables

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

Asquith - Time Series For Statistical Variables

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

Assabu - Time Series For Statistical Variables

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

Assab - Time Series For Statistical Variables

@datacommons.cities.assab_wikidataid_q738496
  • 24.48 kB
  • 3,113 rows
  • 12 columns
Loading... 
CREATE TABLE assab_wikidataid_q738496 (
  "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
);

Assagay - Time Series For Statistical Variables

@datacommons.cities.assagay_wikidataid_q4808352
  • 62.86 kB
  • 7,577 rows
  • 12 columns
Loading... 
CREATE TABLE assagay_wikidataid_q4808352 (
  "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 Salif District - Time Series For Statistical Variables

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

Assamaka - Time Series For Statistical Variables

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

Assaria - Time Series For Statistical Variables

@datacommons.cities.assaria_geoid_2002850
  • 2.93 MB
  • 345,719 rows
  • 12 columns
Loading... 
CREATE TABLE assaria_geoid_2002850 (
  "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.