2022 Road Traffic Accidents History - Version Records
Click here for a data sample
The 'tablehistory' is a version history table that captures the evolution of its base table rows over time. It is a component of a larger dataset group dedicated to road traffic accidents in 2022. The table collects a wealth of data across several columns, providing a detailed overview of each recorded accident. Unique identifiers for each row are established through a combination of the start date, when the row was first extracted from the data source, and a row number. The end date column indicates when a newer version of the row was extracted, with a null value signifying that the row is the most recent version. These date-related columns are exclusive to this version history table, making it more informative than the base table. Among the data collected, there is geographic information that can be effectively used for geospatial data analytics. This geographic information, which includes coordinates using the WGS 84 coordinate reference system (longitude followed by latitude), is particularly useful for visualizing the geographical distribution and concentration of road traffic accidents. The data from the 'tablehistory' is sourced from 'Tilastokeskus' (Statistics Finland), a reliable online source based in Finland. The comprehensive information captured in this table can be instrumental in various analytics applications. For instance, the temporal data can be used to identify trends or patterns in road traffic accidents over time. The geographic data can be utilized to identify accident hot spots, which could inform traffic safety measures. Also, the detailed accident data can be used to investigate correlations between different variables, such as the time of an accident and its severity.
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | This column represents the date when the row was extracted from the data source (e.g., 2024-11-11). |
|---|
| _end_date | date | This column represents 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. Combined with '_start_date', it uniquely identifies each row in this version history table. |
|---|
| geom_geojson | string | This column contains geographical data in GeoJSON format, which represents the geographical features of the data points. |
|---|
| geom_geotext | string | This column contains the geographical coordinates of the data points in text format. |
|---|
| geom_type | string | This column specifies the type of the geographical data. |
|---|
| geom_centroid | string | This column indicates the centroid, or the geometric center, of the geographical data. |
|---|
| geom_center_x | double | This column represents the X-coordinate of the geometric center of the data points. |
|---|
| geom_center_y | double | This column represents the Y-coordinate of the geometric center of the data points. |
|---|
| gml_id | string | This column contains a unique identifier for each data point. |
|---|
| kello | string | This column indicates the time at which the data was collected. |
|---|
| kkonn | long | This integer column represents a specific attribute of the data. |
|---|
| lkmhapa | long | This integer column represents a specific attribute of the data. |
|---|
| lkmjk | long | This integer column represents a specific attribute of the data. |
|---|
| lkmlaka | long | This integer column represents a specific attribute of the data. |
|---|
| lkmmo | long | This integer column represents a specific attribute of the data. |
|---|
| lkmmp | long | This integer column represents a specific attribute of the data. |
|---|
| lkmmuukulk | long | This integer column represents a specific attribute of the data. |
|---|
| lkmpp | long | This integer column represents a specific attribute of the data. |
|---|
| onntyyppi | string | This column represents a specific attribute of the data. |
|---|
| vakav | string | This column represents a specific attribute of the data. |
|---|
| vvonn | string | This column represents a specific attribute of the data. |
|---|
| x | double | This column represents the X-coordinate of the data points. |
|---|
| y | double | This column represents the Y-coordinate of the data points. |
|---|
