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

Yosano - Time Series For Statistical Variables

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

Yosemite Lakes - Time Series For Statistical Variables

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

Yosemite Valley - Time Series For Statistical Variables

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

Yosemite Valley - Time Series For Statistical Variables

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

Yosemite Village - Time Series For Statistical Variables

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

Yosemite West - Time Series For Statistical Variables

@datacommons.cities.yosemite_west_geoid_0686916
  • 926.61 kB
  • 61,757 rows
  • 12 columns
Loading... 
CREATE TABLE yosemite_west_geoid_0686916 (
  "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
);

Yoshida - Time Series For Statistical Variables

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

Yoshikawa - Time Series For Statistical Variables

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

Yoshika - Time Series For Statistical Variables

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

Yoshimi - Time Series For Statistical Variables

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

Yoshinogari - Time Series For Statistical Variables

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

Yoshinogawa - Time Series For Statistical Variables

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

Yoshino - Time Series For Statistical Variables

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

Yoshioka - Time Series For Statistical Variables

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

Yoshitomi - Time Series For Statistical Variables

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

Yoshkar-Ola - Time Series For Statistical Variables

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

Yotoco - Time Series For Statistical Variables

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

Yotsuba - Time Series For Statistical Variables

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

Yotsukaidō - Time Series For Statistical Variables

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

Yotsuyamachi - Time Series For Statistical Variables

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

Youanmite - Time Series For Statistical Variables

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

Youanmi - Time Series For Statistical Variables

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

Young America - Time Series For Statistical Variables

@datacommons.cities.young_america_geoid_1886156
  • 810.41 kB
  • 38,127 rows
  • 12 columns
Loading... 
CREATE TABLE young_america_geoid_1886156 (
  "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
);

Young America Township - Time Series For Statistical Variables

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

Young America Township - Time Series For Statistical Variables

@datacommons.cities.young_america_township_geoid_2772130
  • 81.8 kB
  • 13,076 rows
  • 12 columns
Loading... 
CREATE TABLE young_america_township_geoid_2772130 (
  "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.