2020 Road Traffic Accidents History Table

The 'table__history' is a historical record of the 'Road Traffic Accidents 2020' dataset, sourced from the 'Statistics Finland' (Tilastokeskus) website. It captures the version history of each row in its base table, presenting a temporal snapshot of the data at the time of extraction. The table uniquely identifies each row through a combination of '_start_date', marking the extraction date, and '_row_number', signifying the row's position in the raw data. The '_end_date' indicates when a new version of the row was extracted; a null value signifies the most current version.

This table contains a wealth of geographic and categorical data. It features a series of 'geom_' columns, which store geospatial information, such as coordinates and point types, a critical resource for geospatial data analytics. The geographic coordinates are represented using the WGS 84 coordinate reference system, with the order of longitude followed by latitude.

Beside the geospatial data, the table also records details like the timing of accidents ('kello'), the number of various types of vehicles involved (e.g., 'lkmhapa', 'lkmjk', 'lkmlaka', 'lkmmo', 'lkmmp', 'lkmmuukulk', 'lkmpp'), and the type and severity of the accident ('onntyyppi', 'vakav').

This table offers valuable insights for traffic accident analysis in Finland, allowing researchers to track accident trends over time and identify high-risk locations or times. It can also aid in designing preventive measures by analyzing the types and severity of accidents in relation to various factors such as location, time, and type of vehicles involved. It's a vital resource for policy-makers, traffic authorities, and researchers studying road safety.