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

Yolo - Time Series For Statistical Variables

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

Yomou - Time Series For Statistical Variables

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

Yonabaru - Time Series For Statistical Variables

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

Yonago - Time Series For Statistical Variables

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

Yonaguni - Time Series For Statistical Variables

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

Yonah - Time Series For Statistical Variables

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

Yoncalla - Time Series For Statistical Variables

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

Yonezawa - Time Series For Statistical Variables

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

Yongala - Time Series For Statistical Variables

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

Yong'an - Time Series For Statistical Variables

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

Yongcheng - Time Series For Statistical Variables

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

Yongin - Time Series For Statistical Variables

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

Yongjing - Time Series For Statistical Variables

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

Yongji, Shanxi - Time Series For Statistical Variables

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

Yongkang - Time Series For Statistical Variables

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

Yongzhou - Time Series For Statistical Variables

@datacommons.cities.yongzhou_wikidataid_q266014
  • 4.82 MB
  • 557,363 rows
  • 12 columns
Loading... 
CREATE TABLE yongzhou_wikidataid_q266014 (
  "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
);

Yonkers - Time Series For Statistical Variables

@datacommons.cities.yonkers_geoid_3684000
  • 4.42 MB
  • 413,544 rows
  • 12 columns
Loading... 
CREATE TABLE yonkers_geoid_3684000 (
  "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
);

Y-O Ranch - Time Series For Statistical Variables

@datacommons.cities.y_o_ranch_geoid_5686737
  • 2.7 MB
  • 332,696 rows
  • 12 columns
Loading... 
CREATE TABLE y_o_ranch_geoid_5686737 (
  "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
);

Yorba Linda - Time Series For Statistical Variables

@datacommons.cities.yorba_linda_geoid_0686832
  • 3.88 MB
  • 384,721 rows
  • 12 columns
Loading... 
CREATE TABLE yorba_linda_geoid_0686832 (
  "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
);

Yorii - Time Series For Statistical Variables

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

Yorkana - Time Series For Statistical Variables

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

York Charter Township - Time Series For Statistical Variables

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

Yorketown - Time Series For Statistical Variables

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

Yorketown - Time Series For Statistical Variables

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

York - Time Series For Statistical Variables

@datacommons.cities.york_geoid_0184096
  • 3.05 MB
  • 349,540 rows
  • 12 columns
Loading... 
CREATE TABLE york_geoid_0184096 (
  "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.