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

Yima - Time Series For Statistical Variables

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

Yinchuan - Time Series For Statistical Variables

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

Yingcheng City - Time Series For Statistical Variables

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

Yingde - Time Series For Statistical Variables

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

Yingkou - Time Series For Statistical Variables

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

Yingtan - Time Series For Statistical Variables

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

Yining City - Time Series For Statistical Variables

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

Yinnar South - Time Series For Statistical Variables

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

Yinnar - Time Series For Statistical Variables

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

Yinxu - Time Series For Statistical Variables

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

Yirrkala - Time Series For Statistical Variables

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

Yishun - Time Series For Statistical Variables

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

Yiwu - Time Series For Statistical Variables

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

Yixing - Time Series For Statistical Variables

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

Yiyang - Time Series For Statistical Variables

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

Yizheng - Time Series For Statistical Variables

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

Yizhu - Time Series For Statistical Variables

@datacommons.cities.yizhu_wikidataid_q718371
  • 58.31 kB
  • 6,800 rows
  • 12 columns
Loading... 
CREATE TABLE yizhu_wikidataid_q718371 (
  "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ōkamachi - Time Series For Statistical Variables

@datacommons.cities.y_kamachi_wikidataid_q11391258
  • 67.49 kB
  • 8,939 rows
  • 12 columns
Loading... 
CREATE TABLE y_kamachi_wikidataid_q11391258 (
  "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ūkarigaoka - Time Series For Statistical Variables

@datacommons.cities.y_karigaoka_wikidataid_q8062730
  • 64 kB
  • 8,367 rows
  • 12 columns
Loading... 
CREATE TABLE y_karigaoka_wikidataid_q8062730 (
  "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ūki - Time Series For Statistical Variables

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

Ylakiai - Time Series For Statistical Variables

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

Ylitornio - Time Series For Statistical Variables

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

Ylivieska - Time Series For Statistical Variables

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

Ylöjärvi - Time Series For Statistical Variables

@datacommons.cities.yl_j_rvi_wikidataid_q543800
  • 53.51 kB
  • 6,652 rows
  • 12 columns
Loading... 
CREATE TABLE yl_j_rvi_wikidataid_q543800 (
  "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ên Bái - Time Series For Statistical Variables

@datacommons.cities.y_n_b_i_wikidataid_q26019
  • 9.32 kB
  • 1 row
  • 12 columns
Loading... 
CREATE TABLE y_n_b_i_wikidataid_q26019 (
  "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.