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

Yellow Creek Township - Time Series For Statistical Variables

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

Yellowdine - Time Series For Statistical Variables

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

Yellow Grass - Time Series For Statistical Variables

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

Yellowhead County - Time Series For Statistical Variables

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

Yellowhead Township - Time Series For Statistical Variables

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

Yellowknife - Time Series For Statistical Variables

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

Yellow Pine - Time Series For Statistical Variables

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

Yellow Springs - Time Series For Statistical Variables

@datacommons.cities.yellow_springs_geoid_3986940
  • 3.19 MB
  • 356,736 rows
  • 12 columns
Loading...
CREATE TABLE yellow_springs_geoid_3986940 (
  "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
);

Yellow Springs - Time Series For Statistical Variables

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

Yellow Springs - Time Series For Statistical Variables

@datacommons.cities.yellow_springs_geoid_4287006
  • 992.64 kB
  • 64,530 rows
  • 12 columns
Loading...
CREATE TABLE yellow_springs_geoid_4287006 (
  "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
);

Yellow Springs Township - Time Series For Statistical Variables

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

Yellowstone Township - Time Series For Statistical Variables

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

Yell Township - Time Series For Statistical Variables

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

Yell Township - Time Series For Statistical Variables

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

Yellville - Time Series For Statistical Variables

@datacommons.cities.yellville_geoid_0577330
  • 3.03 MB
  • 353,852 rows
  • 12 columns
Loading...
CREATE TABLE yellville_geoid_0577330 (
  "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
);

Yelm - Time Series For Statistical Variables

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

Yelnya - Time Series For Statistical Variables

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

Yel’sk - Time Series For Statistical Variables

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

Yelverton, Devon - Time Series For Statistical Variables

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

Yelvington - Time Series For Statistical Variables

@datacommons.cities.yelvington_geoid_2185224
  • 1.02 MB
  • 64,803 rows
  • 12 columns
Loading...
CREATE TABLE yelvington_geoid_2185224 (
  "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
);

Yemanzhelinsk - Time Series For Statistical Variables

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

Yemassee - Time Series For Statistical Variables

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

Yemmiganuru - Time Series For Statistical Variables

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

Yemva - Time Series For Statistical Variables

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

Yenakiieve - Time Series For Statistical Variables

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