2018 Road Traffic Accidents History - Versioned Record Table
The 'history' table is a part of a dataset collection that stores data related to road traffic accidents in 2018. The data in this table is sourced from 'Tilastokeskus' (Statistics Finland), a Finnish statistical organization. The table serves as a historical record of its base table rows, storing the version history of each row. This is achieved through special columns: '_start_date' and '_end_date', which respectively mark when the row was extracted from the source, and when a new version of the row was extracted. If '_end_date' is null, it implies that the row is the most recent version. The '_row_number' column helps in uniquely identifying each row, combined with '_start_date'.
The table contains a wealth of information, with columns storing geographic data that can be used for geospatial data analytics. These 'geom_' prefixed columns present geographic coordinates using the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude. The data also includes details about the time of accident ('kello'), type of accident ('onntyyppi'), and various details about the number of different types of vehicles and pedestrians involved.
Given the rich dataset, the table can be utilized in a multitude of ways for data analytics purposes. For instance, geospatial analytics could be used to identify accident hotspots or to analyze the geographical spread of accidents. Temporal analytics could reveal patterns in accident times, while the accident type and vehicle data could be used for safety analysis or to inform policy decisions.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column contains the date when the row was extracted from the data source. It is used together with '_row_number' to uniquely identify each row in this 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 of this column is null, it means 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. It is used together with '_start_date' to uniquely identify each row in this history table. |
| geom_geojson | string | This column contains geographical data in GeoJSON format. |
| geom_geotext | string | This column contains geographical data in text format. |
| geom_type | string | This column specifies the type of geographical data contained in the 'geom_geojson' and 'geom_geotext' columns. |
| geom_centroid | string | This column contains the centroid point of the geographical data. |
| geom_center_x | double | This column contains the x-coordinate of the center point of the geographical data. |
| geom_center_y | double | This column contains the y-coordinate of the center point of the geographical data. |
| gml_id | string | This column contains a unique identifier for the row. |
| kello | string | This column contains information about the hour of the day. |
| kkonn | long | This column contains numerical data. |
| lkmhapa | long | This column contains numerical data. |
| lkmjk | long | This column contains numerical data. |
| lkmlaka | long | This column contains numerical data. |
| lkmmo | long | This column contains numerical data. |
| lkmmp | long | This column contains numerical data. |
| lkmmuukulk | long | This column contains numerical data. |
| lkmpp | long | This column contains numerical data. |
| onntyyppi | string | This column contains numerical data. |
| vakav | string | This column contains numerical data. |
| vvonn | string | This column contains information about the year. |
| x | double | This column contains the x-coordinate of a point. |
| y | double | This column contains the y-coordinate of a point. |
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 | be0820a8-3244-4935-816e-ba744df48760 |
| Package id | fcaeafc9-e25b-46e3-8449-c0db2f6b9cdd |
| Position | 1 |
| Revision id | 98c489d9-dfe3-4bf4-8331-082c85ca4990 |
| State | active |
| Table | tieliikenne_tieliikenne_2018__table__history |