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

Alpiarça - Time Series For Statistical Variables

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

Alpiarça - Time Series For Statistical Variables

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

Alpine - Time Series For Statistical Variables

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

Alpine - Time Series For Statistical Variables

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

Alpine - Time Series For Statistical Variables

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

Alpine - Time Series For Statistical Variables

@datacommons.cities.alpine_geoid_0401920
  • 2.72 MB
  • 334,386 rows
  • 12 columns
Loading...
CREATE TABLE alpine_geoid_0401920 (
  "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
);

Alpine - Time Series For Statistical Variables

@datacommons.cities.alpine_geoid_0501090
  • 920.49 kB
  • 62,085 rows
  • 12 columns
Loading...
CREATE TABLE alpine_geoid_0501090 (
  "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
);

Alpine - Time Series For Statistical Variables

@datacommons.cities.alpine_geoid_0601192
  • 3.32 MB
  • 360,774 rows
  • 12 columns
Loading...
CREATE TABLE alpine_geoid_0601192 (
  "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
);

Alpine - Time Series For Statistical Variables

@datacommons.cities.alpine_geoid_0801640
  • 2.67 MB
  • 330,935 rows
  • 12 columns
Loading...
CREATE TABLE alpine_geoid_0801640 (
  "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
);

Alpine - Time Series For Statistical Variables

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

Alpine - Time Series For Statistical Variables

@datacommons.cities.alpine_geoid_4101700
  • 2.71 MB
  • 336,605 rows
  • 12 columns
Loading...
CREATE TABLE alpine_geoid_4101700 (
  "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
);

Alpine - Time Series For Statistical Variables

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

Alpine - Time Series For Statistical Variables

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

Alpine - Time Series For Statistical Variables

@datacommons.cities.alpine_geoid_5601695
  • 2.91 MB
  • 343,522 rows
  • 12 columns
Loading...
CREATE TABLE alpine_geoid_5601695 (
  "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
);

Alpine Northeast - Time Series For Statistical Variables

@datacommons.cities.alpine_northeast_geoid_5601888
  • 2.6 MB
  • 323,881 rows
  • 12 columns
Loading...
CREATE TABLE alpine_northeast_geoid_5601888 (
  "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
);

Alpine Northeast - Time Series For Statistical Variables

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

Alpine Northwest - Time Series For Statistical Variables

@datacommons.cities.alpine_northwest_geoid_5601936
  • 2.69 MB
  • 331,615 rows
  • 12 columns
Loading...
CREATE TABLE alpine_northwest_geoid_5601936 (
  "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
);

Alpine Northwest - Time Series For Statistical Variables

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

Alpine Township - Time Series For Statistical Variables

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

Alpine Township - Time Series For Statistical Variables

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

Alpine Village - Time Series For Statistical Variables

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

Alpine - Time Series For Statistical Variables

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

Alpine - Time Series For Statistical Variables

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

Alpine - Time Series For Statistical Variables

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

Alpirsbach - Time Series For Statistical Variables

@datacommons.cities.alpirsbach_wikidataid_q82781
  • 72.05 kB
  • 8,901 rows
  • 12 columns
Loading...
CREATE TABLE alpirsbach_wikidataid_q82781 (
  "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.