To download the data set, please sign up or log in
Tieliikenneonnettomuudet 2013
Tables
-
Tieliikenne 2013, Tieliikennetieliikenne 2013, Full historyTSV
Road traffic accidents involving personal injury known to the police in Finland and reported to Statistics Finland, which have co-ordinate data. The data cover the following information: vvonn = year of the accident kkonn = month of the accident kello = time of the accident vakav = seriousness of the accident: 1 = accident resulting in death, 2 = accident resulting in injury, 3 = accident resulting in serious injury onntyyppi = type of accident: 0 = Same direction of travel (going straight), 1 = Same direction of travel (turning), 2 = Opposite direction of travel (going straight), 3 = Opposite direction of travel (turning), 4 = Intersecting direction of travel (going straight), 5 = Intersecting direction of travel (turning), 6 = Pedestrian accident (on pedestrian crossing), 7 =...
-
Tieliikenne 2013, Tieliikennetieliikenne 2013, LatestTSV
Road traffic accidents involving personal injury known to the police in Finland and reported to Statistics Finland, which have co-ordinate data. The data cover the following information: vvonn = year of the accident kkonn = month of the accident kello = time of the accident vakav = seriousness of the accident: 1 = accident resulting in death, 2 = accident resulting in injury, 3 = accident resulting in serious injury onntyyppi = type of accident: 0 = Same direction of travel (going straight), 1 = Same direction of travel (turning), 2 = Opposite direction of travel (going straight), 3 = Opposite direction of travel (turning), 4 = Intersecting direction of travel (going straight), 5 = Intersecting direction of travel (turning), 6 = Pedestrian accident (on pedestrian crossing), 7 =...
Column Descriptions
Tieliikenne 2013, Tieliikennetieliikenne 2013, Latest
| Column | Type | Comment |
|---|---|---|
| vvonn | int | Data source did not contain a description for vvonn. Column vvonn has 5332 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Constant value is 2013. |
| kkonn | int | Data source did not contain a description for kkonn. Column kkonn has 5332 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 1 and maximum value is 12. |
| kello | string | Data source did not contain a description for kello. Column kello has 5332 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is 00.00-00.59 and maximum string is 23.00-23.59. |
| vakav | int | Data source did not contain a description for vakav. Column vakav has 5332 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 1 and maximum value is 2. |
| onntyyppi | int | Data source did not contain a description for onntyyppi. Column onntyyppi has 5332 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 0 and maximum value is 9. |
| lkmhapa | int | Data source did not contain a description for lkmhapa. Column lkmhapa has 5332 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 0 and maximum value is 13. |
| lkmlaka | int | Data source did not contain a description for lkmlaka. Column lkmlaka has 5332 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 0 and maximum value is 3. |
| lkmjk | int | Data source did not contain a description for lkmjk. Column lkmjk has 5332 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 0 and maximum value is 3. |
| lkmpp | int | Data source did not contain a description for lkmpp. Column lkmpp has 5332 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 0 and maximum value is 3. |
| lkmmo | int | Data source did not contain a description for lkmmo. Column lkmmo has 5332 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 0 and maximum value is 3. |
| lkmmp | int | Data source did not contain a description for lkmmp. Column lkmmp has 5332 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 0 and maximum value is 2. |
| lkmmuukulk | int | Data source did not contain a description for lkmmuukulk. Column lkmmuukulk has 5332 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 0 and maximum value is 2. |
| x | float | Data source did not contain a description for x. Column x has 5332 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 88703.53 and maximum value is 701686.06. |
| y | float | Data source did not contain a description for y. Column y has 5332 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 6638442 and maximum value is 7760306. |
| geom_geojson | string | Geometry in GeoJSON format. |
| geom_geotext | string | Geometry as GeoText. Column geom_geotext has 5332 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. First 25 characters of minimum string: POINT (19.56538747514352 ... and first 25 characters of maximum string: POINT (30.9410587799667 6... |
| geom_center_x | float | Longitude of center. Column geom_center_x has 5332 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 19.57 and maximum value is 30.94. |
| geom_center_y | float | Latitude of center. Column geom_center_y has 5332 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 59.82 and maximum value is 69.95. |
| geom_type | string | Geometry type. Column geom_type has 5332 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. The single string value is: ST_POINT. |
Tieliikenne 2013, Tieliikennetieliikenne 2013, Full history
| Column | Type | Comment |
|---|---|---|
| vvonn | int | Data source did not contain a description for vvonn. Column vvonn has 5332 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Constant value is 2013. |
| kkonn | int | Data source did not contain a description for kkonn. Column kkonn has 5332 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 1 and maximum value is 12. |
| kello | string | Data source did not contain a description for kello. Column kello has 5332 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is 00.00-00.59 and maximum string is 23.00-23.59. |
| vakav | int | Data source did not contain a description for vakav. Column vakav has 5332 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 1 and maximum value is 2. |
| onntyyppi | int | Data source did not contain a description for onntyyppi. Column onntyyppi has 5332 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 0 and maximum value is 9. |
| lkmhapa | int | Data source did not contain a description for lkmhapa. Column lkmhapa has 5332 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 0 and maximum value is 13. |
| lkmlaka | int | Data source did not contain a description for lkmlaka. Column lkmlaka has 5332 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 0 and maximum value is 3. |
| lkmjk | int | Data source did not contain a description for lkmjk. Column lkmjk has 5332 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 0 and maximum value is 3. |
| lkmpp | int | Data source did not contain a description for lkmpp. Column lkmpp has 5332 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 0 and maximum value is 3. |
| lkmmo | int | Data source did not contain a description for lkmmo. Column lkmmo has 5332 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 0 and maximum value is 3. |
| lkmmp | int | Data source did not contain a description for lkmmp. Column lkmmp has 5332 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 0 and maximum value is 2. |
| lkmmuukulk | int | Data source did not contain a description for lkmmuukulk. Column lkmmuukulk has 5332 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 0 and maximum value is 2. |
| x | float | Data source did not contain a description for x. Column x has 5332 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 88703.53 and maximum value is 701686.06. |
| y | float | Data source did not contain a description for y. Column y has 5332 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 6638442 and maximum value is 7760306. |
| geom_geojson | string | Geometry in GeoJSON format. |
| geom_geotext | string | Geometry as GeoText. Column geom_geotext has 5332 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. First 25 characters of minimum string: POINT (19.56538747514352 ... and first 25 characters of maximum string: POINT (30.9410587799667 6... |
| geom_center_x | float | Longitude of center. Column geom_center_x has 5332 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 19.57 and maximum value is 30.94. |
| geom_center_y | float | Latitude of center. Column geom_center_y has 5332 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 59.82 and maximum value is 69.95. |
| geom_type | string | Geometry type. Column geom_type has 5332 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. The single string value is: ST_POINT. |
| orig_extractdate | string | The date when the data was originally fetched from the source. |
Additional Info
| Last Updated | April 25, 2022 |
|---|---|
| Created | September 7, 2018 |