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

Yampa - Time Series For Statistical Variables

@datacommons.cities.yampa_geoid_0886475
  • 2.87 MB
  • 342,011 rows
  • 12 columns
Loading... 
CREATE TABLE yampa_geoid_0886475 (
  "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
);

Yampil, Vinnytsia Oblast - Time Series For Statistical Variables

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

Yamuna Nagar - Time Series For Statistical Variables

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

Yanagawa - Time Series For Statistical Variables

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

Yanahuanca - Time Series For Statistical Variables

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

Yanai - Time Series For Statistical Variables

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

Yanaizu - Time Series For Statistical Variables

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

Yanaka - Time Series For Statistical Variables

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

Yanakie - Time Series For Statistical Variables

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

Yan'an - Time Series For Statistical Variables

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

Yanaul - Time Series For Statistical Variables

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

Yancey - Time Series For Statistical Variables

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

Yanceyville - Time Series For Statistical Variables

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

Yancheng - Time Series For Statistical Variables

@datacommons.cities.yancheng_wikidataid_q57866
  • 4.77 MB
  • 555,940 rows
  • 12 columns
Loading... 
CREATE TABLE yancheng_wikidataid_q57866 (
  "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
);

Yanco - Time Series For Statistical Variables

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

Yanderra - Time Series For Statistical Variables

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

Yandilla - Time Series For Statistical Variables

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

Yandina - Time Series For Statistical Variables

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

Yandoit - Time Series For Statistical Variables

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

Yangan - Time Series For Statistical Variables

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

Yanga - Time Series For Statistical Variables

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

Yangchun - Time Series For Statistical Variables

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

Yangiariq - Time Series For Statistical Variables

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

Yangibozor - Time Series For Statistical Variables

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

Yangiqoʻrgʻon - Time Series For Statistical Variables

@datacommons.cities.yangiqo_rg_on_wikidataid_q4537936
  • 65.59 kB
  • 7,489 rows
  • 12 columns
Loading... 
CREATE TABLE yangiqo_rg_on_wikidataid_q4537936 (
  "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.