To download the data set, please sign up or log in

Tieliikenneonnettomuudet 2011 - Road traffic accidents

Tieliikenneonnettomuudet 2011 - Road traffic accidents

Tables

  • Tieliikenne 2011, Tieliikennetieliikenne 2011TSV

    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 2011, Tieliikennetieliikenne 2011

Column Type Comment
vvonn int Data source did not contain a description for vvonn. Column vvonn has 6399 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 2011.
kkonn int Data source did not contain a description for kkonn. Column kkonn has 6399 rows, out of which 0 are empty, making the null percent 0.00. 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 6399 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 08.00-08.59 and maximum string is 23.00-23.59.
vakav int Data source did not contain a description for vakav. Column vakav has 6399 rows, out of which 0 are empty, making the null percent 0.00. 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 6399 rows, out of which 0 are empty, making the null percent 0.00. 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 6399 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 57.
lkmlaka int Data source did not contain a description for lkmlaka. Column lkmlaka has 6399 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 4.
lkmjk int Data source did not contain a description for lkmjk. Column lkmjk has 6399 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 6.
lkmpp int Data source did not contain a description for lkmpp. Column lkmpp has 6399 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 2.
lkmmo int Data source did not contain a description for lkmmo. Column lkmmo has 6399 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 4.
lkmmp int Data source did not contain a description for lkmmp. Column lkmmp has 6399 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 4.
lkmmuukulk int Data source did not contain a description for lkmmuukulk. Column lkmmuukulk has 6399 rows, out of which 0 are empty, making the null percent 0.00. 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 6399 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 89222.00 and maximum value is 722386.50.
y float Data source did not contain a description for y. Column y has 6399 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 6639171.50 and maximum value is 7754529.00.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 6399 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: POINT (20.13927900915894 ... and first 25 characters of maximum string: POINT (31.346999281156826...
geom_center_x float Longitude of center. Column geom_center_x has 6399 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 19.57 and maximum value is 31.35.
geom_center_y float Latitude of center. Column geom_center_y has 6399 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 59.83 and maximum value is 69.90.
geom_type string Geometry type. Column geom_type has 6399 rows, out of which 0 are empty, making the null percent 0.00. 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 12, 2019
Created May 6, 2018