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

Yerington - Time Series For Statistical Variables

@datacommons.cities.yerington_geoid_3285400
  • 3.11 MB
  • 352,031 rows
  • 12 columns
Loading... 
CREATE TABLE yerington_geoid_3285400 (
  "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
);

Yering - Time Series For Statistical Variables

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

Yermo - Time Series For Statistical Variables

@datacommons.cities.yermo_geoid_0686720
  • 996.85 kB
  • 63,065 rows
  • 12 columns
Loading... 
CREATE TABLE yermo_geoid_0686720 (
  "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
);

Yermolino - Time Series For Statistical Variables

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

Yerong Creek - Time Series For Statistical Variables

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

Yerranderie - Time Series For Statistical Variables

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

Yershov - Time Series For Statistical Variables

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

Yessentuki - Time Series For Statistical Variables

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

Yettem - Time Series For Statistical Variables

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

Yetter - Time Series For Statistical Variables

@datacommons.cities.yetter_geoid_1987375
  • 1.25 MB
  • 178,350 rows
  • 12 columns
Loading... 
CREATE TABLE yetter_geoid_1987375 (
  "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
);

Yevlakh - Time Series For Statistical Variables

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

Yevlakh - Time Series For Statistical Variables

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

Yevpatoria - Time Series For Statistical Variables

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

Yewa North - Time Series For Statistical Variables

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

Ye - Time Series For Statistical Variables

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

Yeysk - Time Series For Statistical Variables

@datacommons.cities.yeysk_wikidataid_q135616
  • 37.78 kB
  • 3,925 rows
  • 12 columns
Loading... 
CREATE TABLE yeysk_wikidataid_q135616 (
  "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ōga - Time Series For Statistical Variables

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

Yibin - Time Series For Statistical Variables

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

Yichang - Time Series For Statistical Variables

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

Yicheng - Time Series For Statistical Variables

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

Yichun - Time Series For Statistical Variables

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

Yichun - Time Series For Statistical Variables

@datacommons.cities.yichun_wikidataid_q363326
  • 4.84 MB
  • 556,302 rows
  • 12 columns
Loading... 
CREATE TABLE yichun_wikidataid_q363326 (
  "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
);

Yidu - Time Series For Statistical Variables

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

Yielima - Time Series For Statistical Variables

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

Yilan City - Time Series For Statistical Variables

@datacommons.cities.yilan_city_wikidataid_q680842
  • 52.65 kB
  • 6,908 rows
  • 12 columns
Loading... 
CREATE TABLE yilan_city_wikidataid_q680842 (
  "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.