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

Yangirabad - Time Series For Statistical Variables

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

Yangiyer - Time Series For Statistical Variables

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

Yangjiang - Time Series For Statistical Variables

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

Yangjiaotang, Anhua - Time Series For Statistical Variables

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

Yangju - Time Series For Statistical Variables

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

Yangon - Time Series For Statistical Variables

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

Yangquan - Time Series For Statistical Variables

@datacommons.cities.yangquan_wikidataid_q72907
  • 4.71 MB
  • 552,622 rows
  • 12 columns
Loading...
CREATE TABLE yangquan_wikidataid_q72907 (
  "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
);

Yangsan - Time Series For Statistical Variables

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

Yangzhong - Time Series For Statistical Variables

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

Yangzhou - Time Series For Statistical Variables

@datacommons.cities.yangzhou_wikidataid_q57906
  • 4.78 MB
  • 553,098 rows
  • 12 columns
Loading...
CREATE TABLE yangzhou_wikidataid_q57906 (
  "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
);

Yanji - Time Series For Statistical Variables

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

Yankee Hill - Time Series For Statistical Variables

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

Yankee Hill - Time Series For Statistical Variables

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

Yankee Lake - Time Series For Statistical Variables

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

Yankee Springs Township - Time Series For Statistical Variables

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

Yankeetown - Time Series For Statistical Variables

@datacommons.cities.yankeetown_geoid_1278925
  • 2.83 MB
  • 341,727 rows
  • 12 columns
Loading...
CREATE TABLE yankeetown_geoid_1278925 (
  "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
);

Yankton - Time Series For Statistical Variables

@datacommons.cities.yankton_geoid_4673060
  • 3.32 MB
  • 359,073 rows
  • 12 columns
Loading...
CREATE TABLE yankton_geoid_4673060 (
  "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
);

Yanping - Time Series For Statistical Variables

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

Yanpu - Time Series For Statistical Variables

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

Yanshi - Time Series For Statistical Variables

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

Yantai - Time Series For Statistical Variables

@datacommons.cities.yantai_wikidataid_q210493
  • 4.73 MB
  • 550,906 rows
  • 12 columns
Loading...
CREATE TABLE yantai_wikidataid_q210493 (
  "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
);

Yantis - Time Series For Statistical Variables

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

Yaotsu - Time Series For Statistical Variables

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

Yaoundé - Time Series For Statistical Variables

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

Yao - Time Series For Statistical Variables

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

Share link

Anyone who has the link will be able to view this.