Road Traffic Accidents 2014: History Version
The 'table__history' is a significant component of the data collection named 'tieliikenne_tieliikenne_2014'. This table serves as a historical archive of road traffic accidents in 2014, sourced from 'Tilastokeskus' (Statistics Finland). It contains meticulously organized data, presented in rows and columns that offer a plethora of information for analysis.
Each row in this table represents a unique incident, identified by a combination of the row number and the date the data was extracted. The rows are periodically updated, and these updates are tracked through start and end dates for each version of the row. If the end date of a row is null, it indicates that the version of the row is the most recent.
The table offers a wealth of geographical details, such as geographic coordinates and geometrical data, which are crucial for geospatial analytics. These geographic coordinates are presented using the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude.
Beyond geographical information, the table contains details about the time of the accident, the number of involved parties, and the severity of the accident. This information can be instrumental in various data analytics applications. For instance, by analyzing the times of accidents, we can identify the most dangerous hours for driving. Similarly, the severity of accidents can be cross-referenced with other factors to understand the conditions that often lead to serious accidents.
In essence, 'table__history' is a comprehensive historical record of road traffic accidents in Finland in 2014, providing valuable insights for improving road safety and shaping traffic regulations.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column contains the date when the row was extracted from the data source. It forms a unique combination with '_row_number' to identify each row in this version history table. |
| _end_date | date | This column contains the date when a new version of the row was extracted from the data source. If the value is null, it indicates that the row is the most recent version. |
| _row_number | long | This column contains the number of the row in the raw data extracted from the data source, contributing to the unique identification of each row in conjunction with '_start_date'. |
| geom_geojson | string | This column contains the geometric data of the points in the GeoJSON format. |
| geom_geotext | string | This column contains the geometric data of the points in the text format. |
| geom_type | string | This column specifies the type of the geometric data. |
| geom_centroid | string | This column contains the centroid of the geometric data. |
| geom_center_x | double | This column contains the x-coordinate of the geometric center. |
| geom_center_y | double | This column contains the y-coordinate of the geometric center. |
| gml_id | string | This column contains the ID of the GML, a markup language for geographic information. |
| kello | string | This column contains data related to the time. |
| kkonn | long | This column contains integer data, details not provided by the data source. |
| lkmhapa | long | This column contains integer data, details not provided by the data source. |
| lkmjk | long | This column contains integer data, details not provided by the data source. |
| lkmlaka | long | This column contains integer data, details not provided by the data source. |
| lkmmo | long | This column contains integer data, details not provided by the data source. |
| lkmmp | long | This column contains integer data, details not provided by the data source. |
| lkmmuukulk | long | This column contains integer data, details not provided by the data source. |
| lkmpp | long | This column contains integer data, details not provided by the data source. |
| onntyyppi | string | This column contains data of type string, details not provided by the data source. |
| vakav | string | This column contains data of type string, details not provided by the data source. |
| vvonn | string | This column contains string data, details not provided by the data source. |
| x | double | This column contains real data, possibly related to geographic information. |
| y | double | This column contains real data, possibly related to geographic information. |
No sample for this dataset
Additional Information
| Last updated | November 11, 2024 |
|---|---|
| Created | November 11, 2024 |
| License | No License Provided |
| Geographic coverage | |
| Geographic granularity | |
| Temporal coverage from | |
| Temporal coverage to | |
| Temporal coverage to | |
| Country | fi |
| Database | fi_tilastokeskus |
| Extract date | 2024-11-11 |
| Id | 93aa38f5-0f7c-4bdd-9445-a3d3effb485b |
| Package id | e65283ee-be7a-42a8-95b1-754da7b0303e |
| Position | 1 |
| Revision id | 983ba349-c643-4193-a928-c0060911e1dd |
| State | active |
| Table | tieliikenne_tieliikenne_2014__table__history |