2016 Road Traffic Accidents Data
Click here for a data sample
The table in question belongs to a dataset collection focusing on road traffic accidents in 2016. The data is meticulously structured, providing detailed insights into each accident event. The table houses a vast array of columns, each offering unique pieces of data related to the accident. Key information includes the date of data extraction and the row number, which together form a unique identifier for each row, allowing for precise data referencing. Additionally, the table provides a wealth of geospatial data, such as geographical points and centroids, which use the WGS 84 coordinate reference system for accurate global positioning. This information can be invaluable in geospatial data analytics, enabling the identification of accident hotspots, for instance. The table also contains data on the time of the accidents and various other details that can be analyzed for patterns and trends. All this data has been sourced from 'Tilastokeskus' website, a Finnish statistical institute, making it a reliable source for research and analytics. Potential use cases for this data could include examining the correlation between the time of day and the severity of accidents, or analyzing the geographical data to determine high-risk areas for road traffic accidents.
Field Descriptions
| Name |
Data type |
Description |
| _extract_date | date | The date when the data on the row was extracted from the source. |
|---|
| _row_number | long | The row number in the data extracted from the source on the extract date specified by the _extract_date column. The combination of _extract_date and _row_number uniquely identifies each row. |
|---|
| geom_geojson | string | A GeoJSON representation of the geographical point associated with the data row. |
|---|
| geom_geotext | string | A textual representation of the geographical point associated with the data row. |
|---|
| geom_type | string | The type of the geographical data, which is a point in this case. |
|---|
| geom_centroid | string | The central point of the geographical data. |
|---|
| geom_center_x | double | The x-coordinate of the central point of the geographical data. |
|---|
| geom_center_y | double | The y-coordinate of the central point of the geographical data. |
|---|
| gml_id | string | A unique identifier for the geographical data. |
|---|
| kello | string | A string representing a time range. |
|---|
| kkonn | long | An integer value. |
|---|
| lkmhapa | long | An integer value. |
|---|
| lkmjk | long | An integer value. |
|---|
| lkmlaka | long | An integer value. |
|---|
| lkmmo | long | An integer value. |
|---|
| lkmmp | long | An integer value. |
|---|
| lkmmuukulk | long | An integer value. |
|---|
| lkmpp | long | An integer value. |
|---|
| onntyyppi | string | A string value. |
|---|
| vakav | string | A string value. |
|---|
| vvonn | string | A string representing a year. |
|---|
| x | double | A real number representing a geographical coordinate. |
|---|
| y | double | A real number representing a geographical coordinate. |
|---|
