Baselight

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

Ackerman - Time Series For Statistical Variables

@datacommons.cities.ackerman_geoid_2800300
  • 3.03 MB
  • 350,069 rows
  • 12 columns
Loading...

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

Ackermanville - Time Series For Statistical Variables

@datacommons.cities.ackermanville_geoid_4200244
  • 2.82 MB
  • 341,245 rows
  • 12 columns
Loading...

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

Ackermanville - Time Series For Statistical Variables

@datacommons.cities.ackermanville_wikidataid_q4674256
  • 95.22 kB
  • 15,006 rows
  • 12 columns
Loading...

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

Ackley - Time Series For Statistical Variables

@datacommons.cities.ackley_geoid_1900190
  • 3.02 MB
  • 352,753 rows
  • 12 columns
Loading...

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

Ackley - Time Series For Statistical Variables

@datacommons.cities.ackley_geoid_5500225
  • 94.33 kB
  • 14,704 rows
  • 12 columns
Loading...

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

Ackworth - Time Series For Statistical Variables

@datacommons.cities.ackworth_geoid_1900235
  • 2.77 MB
  • 340,483 rows
  • 12 columns
Loading...

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

Acland - Time Series For Statistical Variables

@datacommons.cities.acland_wikidataid_q4674295
  • 67.03 kB
  • 8,876 rows
  • 12 columns
Loading...

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

Acle - Time Series For Statistical Variables

@datacommons.cities.acle_wikidataid_q341938
  • 72.72 kB
  • 10,250 rows
  • 12 columns
Loading...

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

Acme - Time Series For Statistical Variables

@datacommons.cities.acme_geoid_5300275
  • 2.67 MB
  • 331,340 rows
  • 12 columns
Loading...

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

Acme Township - Time Series For Statistical Variables

@datacommons.cities.acme_township_geoid_2600200
  • 92.46 kB
  • 14,703 rows
  • 12 columns
Loading...

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

Acme Township - Time Series For Statistical Variables

@datacommons.cities.acme_township_geoid_3800220
  • 93.7 kB
  • 14,048 rows
  • 12 columns
Loading...

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

Acme - Time Series For Statistical Variables

@datacommons.cities.acme_wikidataid_q341968
  • 77.36 kB
  • 12,440 rows
  • 12 columns
Loading...

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

Acolman - Time Series For Statistical Variables

@datacommons.cities.acolman_undata_geo_c16800655
  • 9.21 kB
  • 1 row
  • 12 columns
Loading...

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

Acoma Township - Time Series For Statistical Variables

@datacommons.cities.acoma_township_geoid_2700136
  • 80.57 kB
  • 12,870 rows
  • 12 columns
Loading...

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

Acomayo - Time Series For Statistical Variables

@datacommons.cities.acomayo_wikidataid_q2582682
  • 9.4 kB
  • 1 row
  • 12 columns
Loading...

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

Acomita Lake - Time Series For Statistical Variables

@datacommons.cities.acomita_lake_geoid_3500765
  • 2.79 MB
  • 338,964 rows
  • 12 columns
Loading...

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

Aconibe - Time Series For Statistical Variables

@datacommons.cities.aconibe_wikidataid_q2549481
  • 9.41 kB
  • 1 row
  • 12 columns
Loading...

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

Acorn - Time Series For Statistical Variables

@datacommons.cities.acorn_geoid_0500190
  • 932.54 kB
  • 61,321 rows
  • 12 columns
Loading...

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

Acornhoek - Time Series For Statistical Variables

@datacommons.cities.acornhoek_wikidataid_q13034180
  • 48.19 kB
  • 5,523 rows
  • 12 columns
Loading...

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

Acorn Township - Time Series For Statistical Variables

@datacommons.cities.acorn_township_wikidataid_q9035933
  • 74.6 kB
  • 12,285 rows
  • 12 columns
Loading...

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

A Coruña - Time Series For Statistical Variables

@datacommons.cities.a_coru_a_wikidataid_q6063659
  • 56.91 kB
  • 7,659 rows
  • 12 columns
Loading...

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

A Coruña - Time Series For Statistical Variables

@datacommons.cities.a_coru_a_wikidataid_q8757
  • 57.24 kB
  • 7,721 rows
  • 12 columns
Loading...

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

Acquackanonk Township - Time Series For Statistical Variables

@datacommons.cities.acquackanonk_township_wikidataid_q4674754
  • 106.24 kB
  • 16,174 rows
  • 12 columns
Loading...

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

Acquasparta - Time Series For Statistical Variables

@datacommons.cities.acquasparta_wikidataid_q6029
  • 49.9 kB
  • 6,160 rows
  • 12 columns
Loading...

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

Acres Green - Time Series For Statistical Variables

@datacommons.cities.acres_green_geoid_0800320
  • 3.04 MB
  • 348,932 rows
  • 12 columns
Loading...

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