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

Amlwch - Time Series For Statistical Variables

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

Ammameh - Time Series For Statistical Variables

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

Ammanford - Time Series For Statistical Variables

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

Amman - Time Series For Statistical Variables

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

Ammerstol - Time Series For Statistical Variables

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

Ammon - Time Series For Statistical Variables

@datacommons.cities.ammon_geoid_1601990
  • 3.3 MB
  • 358,212 rows
  • 12 columns
Loading...
CREATE TABLE ammon_geoid_1601990 (
  "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
);

Amnat Charoen - Time Series For Statistical Variables

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

Amöneburg - Time Series For Statistical Variables

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

Amnicon - Time Series For Statistical Variables

@datacommons.cities.amnicon_geoid_5501825
  • 93.26 kB
  • 14,413 rows
  • 12 columns
Loading...
CREATE TABLE amnicon_geoid_5501825 (
  "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
);

Amod, Gujarat - Time Series For Statistical Variables

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

Amo - Time Series For Statistical Variables

@datacommons.cities.amo_geoid_1801450
  • 2.92 MB
  • 345,550 rows
  • 12 columns
Loading...
CREATE TABLE amo_geoid_1801450 (
  "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
);

Amol - Time Series For Statistical Variables

@datacommons.cities.amol_wikidataid_q331078
  • 41.46 kB
  • 4,778 rows
  • 12 columns
Loading...
CREATE TABLE amol_wikidataid_q331078 (
  "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
);

Amonate - Time Series For Statistical Variables

@datacommons.cities.amonate_geoid_5101752
  • 849.39 kB
  • 60,760 rows
  • 12 columns
Loading...
CREATE TABLE amonate_geoid_5101752 (
  "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
);

Amora - Time Series For Statistical Variables

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

Amorbach - Time Series For Statistical Variables

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

Amoret - Time Series For Statistical Variables

@datacommons.cities.amoret_geoid_2901072
  • 2.8 MB
  • 339,682 rows
  • 12 columns
Loading...
CREATE TABLE amoret_geoid_2901072 (
  "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
);

Amorita - Time Series For Statistical Variables

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

Amor Township - Time Series For Statistical Variables

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

Amor Township - Time Series For Statistical Variables

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

Amory - Time Series For Statistical Variables

@datacommons.cities.amory_geoid_2801260
  • 3.18 MB
  • 355,867 rows
  • 12 columns
Loading...
CREATE TABLE amory_geoid_2801260 (
  "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
);

Amos - Time Series For Statistical Variables

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

Amo Township - Time Series For Statistical Variables

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

Amoudah - Time Series For Statistical Variables

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

Amo - Time Series For Statistical Variables

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

Amozoc - Time Series For Statistical Variables

@datacommons.cities.amozoc_undata_geo_c16801418
  • 9.2 kB
  • 1 row
  • 12 columns
Loading...
CREATE TABLE amozoc_undata_geo_c16801418 (
  "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.