Smart Cities Index Datasets

Data Collected from Different Types of IoT Devices

@kaggle.magdamonteiro_smart_cities_index_datasets

Table List

1 table(14.16 KB)

Smart City Index Headers

@kaggle.magdamonteiro_smart_cities_index_datasets.smart_city_index_headers

14.16 KB
102 rows
11 columns

id Id	city City	country Country	smart_mobility Smart Mobility	smart_environment Smart Environment	smart_government Smart Government	smart_economy Smart Economy	smart_people Smart People	smart_living Smart Living	smartcity_index SmartCity Index	smartcity_index_relative_edmonton SmartCity Index Relative Edmonton
1	Oslo	Norway	6480	6512	7516	4565	8618	9090	7138	666
2	Bergen	Norway	7097	6876	7350	4905	8050	9090	7296	823
3	Amsterdam	Netherlands	7540	5558	8528	8095	7098	7280	7311	839
4	Copenhagen	Denmark	7490	7920	8726	5580	5780	7200	7171	698
5	Stockholm	Sweden	6122	7692	8354	4330	6743	7730	6812	340
6	Montreal	Canada	7490	4848	6624	6180	8465	9920	7353	880
7	Vienna	Austria	5683	7608	6232	5415	8580	7500	6771	298
8	Odense	Denmark	6160	8404	7578	5200	6955	7200	6886	414
9	Singapore	Singapore	5790	4344	5560	5535	9695	10000	6813	341
10	Boston	United States	7870	5224	6020	8935	6573	6220	6852	380


CREATE TABLE smart_city_index_headers (
  "id" BIGINT,
  "city" VARCHAR,
  "country" VARCHAR,
  "smart_mobility" BIGINT,
  "smart_environment" BIGINT,
  "smart_government" BIGINT,
  "smart_economy" BIGINT,
  "smart_people" BIGINT,
  "smart_living" BIGINT,
  "smartcity_index" BIGINT,
  "smartcity_index_relative_edmonton" BIGINT
);