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

Yoyogi - Time Series For Statistical Variables

@datacommons.cities.yoyogi_wikidataid_q1190291
  • 68.6 kB
  • 9,728 rows
  • 12 columns
Loading... 

CREATE TABLE yoyogi_wikidataid_q1190291 (
  "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
);

Yozgat - Time Series For Statistical Variables

@datacommons.cities.yozgat_wikidataid_q210292
  • 28.24 kB
  • 2,612 rows
  • 12 columns
Loading... 

CREATE TABLE yozgat_wikidataid_q210292 (
  "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
);

Ypres - Time Series For Statistical Variables

@datacommons.cities.ypres_wikidataid_q102728
  • 58.64 kB
  • 7,827 rows
  • 12 columns
Loading... 

CREATE TABLE ypres_wikidataid_q102728 (
  "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
);

Ypres - Time Series For Statistical Variables

@datacommons.cities.ypres_wikidataid_q31824036
  • 57.7 kB
  • 7,825 rows
  • 12 columns
Loading... 

CREATE TABLE ypres_wikidataid_q31824036 (
  "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
);

Ypsilanti - Time Series For Statistical Variables

@datacommons.cities.ypsilanti_geoid_2689140
  • 3.42 MB
  • 365,207 rows
  • 12 columns
Loading... 

CREATE TABLE ypsilanti_geoid_2689140 (
  "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
);

Ypsilanti - Time Series For Statistical Variables

@datacommons.cities.ypsilanti_geoid_3888020
  • 2.66 MB
  • 332,148 rows
  • 12 columns
Loading... 

CREATE TABLE ypsilanti_geoid_3888020 (
  "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
);

Ypsilanti Township - Time Series For Statistical Variables

@datacommons.cities.ypsilanti_township_geoid_2689160
  • 111.89 kB
  • 17,598 rows
  • 12 columns
Loading... 

CREATE TABLE ypsilanti_township_geoid_2689160 (
  "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
);

Ypsilanti Township - Time Series For Statistical Variables

@datacommons.cities.ypsilanti_township_geoid_3888060
  • 90.08 kB
  • 14,488 rows
  • 12 columns
Loading... 

CREATE TABLE ypsilanti_township_geoid_3888060 (
  "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
);

Yreka - Time Series For Statistical Variables

@datacommons.cities.yreka_geoid_0686944
  • 3.29 MB
  • 358,805 rows
  • 12 columns
Loading... 

CREATE TABLE yreka_geoid_0686944 (
  "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ōrō - Time Series For Statistical Variables

@datacommons.cities.y_r_wikidataid_q153814
  • 67.5 kB
  • 8,572 rows
  • 12 columns
Loading... 

CREATE TABLE y_r_wikidataid_q153814 (
  "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
);

Ystradgynlais - Time Series For Statistical Variables

@datacommons.cities.ystradgynlais_wikidataid_q2720261
  • 46.17 kB
  • 5,661 rows
  • 12 columns
Loading... 

CREATE TABLE ystradgynlais_wikidataid_q2720261 (
  "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
);

Ystrad Meurig - Time Series For Statistical Variables

@datacommons.cities.ystrad_meurig_wikidataid_q3402138
  • 51.3 kB
  • 6,490 rows
  • 12 columns
Loading... 

CREATE TABLE ystrad_meurig_wikidataid_q3402138 (
  "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
);

Ystrad Mynach - Time Series For Statistical Variables

@datacommons.cities.ystrad_mynach_wikidataid_q1774850
  • 46.93 kB
  • 5,757 rows
  • 12 columns
Loading... 

CREATE TABLE ystrad_mynach_wikidataid_q1774850 (
  "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ūsui - Time Series For Statistical Variables

@datacommons.cities.y_sui_wikidataid_q1350873
  • 60.09 kB
  • 7,252 rows
  • 12 columns
Loading... 

CREATE TABLE y_sui_wikidataid_q1350873 (
  "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
);

Yuanchang - Time Series For Statistical Variables

@datacommons.cities.yuanchang_wikidataid_q710033
  • 36.24 kB
  • 4,277 rows
  • 12 columns
Loading... 

CREATE TABLE yuanchang_wikidataid_q710033 (
  "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
);

Yuanjiang - Time Series For Statistical Variables

@datacommons.cities.yuanjiang_wikidataid_q1374948
  • 28.46 kB
  • 2,837 rows
  • 12 columns
Loading... 

CREATE TABLE yuanjiang_wikidataid_q1374948 (
  "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
);

Yuanlin - Time Series For Statistical Variables

@datacommons.cities.yuanlin_wikidataid_q713331
  • 54.2 kB
  • 7,045 rows
  • 12 columns
Loading... 

CREATE TABLE yuanlin_wikidataid_q713331 (
  "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
);

Yuanli - Time Series For Statistical Variables

@datacommons.cities.yuanli_wikidataid_q713050
  • 53.33 kB
  • 7,045 rows
  • 12 columns
Loading... 

CREATE TABLE yuanli_wikidataid_q713050 (
  "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
);

Yuanping - Time Series For Statistical Variables

@datacommons.cities.yuanping_wikidataid_q1331388
  • 56.45 kB
  • 7,155 rows
  • 12 columns
Loading... 

CREATE TABLE yuanping_wikidataid_q1331388 (
  "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
);

Yuanshan - Time Series For Statistical Variables

@datacommons.cities.yuanshan_wikidataid_q707892
  • 53.09 kB
  • 6,908 rows
  • 12 columns
Loading... 

CREATE TABLE yuanshan_wikidataid_q707892 (
  "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
);

Yuasa - Time Series For Statistical Variables

@datacommons.cities.yuasa_wikidataid_q1345625
  • 59.03 kB
  • 7,351 rows
  • 12 columns
Loading... 

CREATE TABLE yuasa_wikidataid_q1345625 (
  "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
);

Yuba City - Time Series For Statistical Variables

@datacommons.cities.yuba_city_geoid_0686972
  • 4.02 MB
  • 387,831 rows
  • 12 columns
Loading... 

CREATE TABLE yuba_city_geoid_0686972 (
  "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
);

Yuba - Time Series For Statistical Variables

@datacommons.cities.yuba_geoid_5589625
  • 2.73 MB
  • 338,827 rows
  • 12 columns
Loading... 

CREATE TABLE yuba_geoid_5589625 (
  "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
);

Yubileyny - Time Series For Statistical Variables

@datacommons.cities.yubileyny_wikidataid_q198759
  • 67.09 kB
  • 8,373 rows
  • 12 columns
Loading... 

CREATE TABLE yubileyny_wikidataid_q198759 (
  "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
);

Yucaipa - Time Series For Statistical Variables

@datacommons.cities.yucaipa_geoid_0687042
  • 3.51 MB
  • 366,247 rows
  • 12 columns
Loading... 

CREATE TABLE yucaipa_geoid_0687042 (
  "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.