2015 Road Traffic Accidents History in Finland
The 'table__history' is a rich repository of data pertaining to road traffic accidents in 2015, originating from the 'Tilastokeskus' (Statistics Finland) website. It serves as a history table, maintaining the version history of its base table rows. The table is part of a larger dataset collection that encapsulates related data tables focusing on road traffic for the year 2015.
The table is structured in a way that each row is uniquely identifiable via a combination of the row number and the start date, the date when the row was extracted from the data source. This unique identifier enables tracking of all versions of a row. The end date signals when a new version of the row was created, with a null value indicating the most recent version.
One of the table's unique features is its incorporation of geographical information, which can be harnessed for geospatial data analytics. This data is presented using the WGS 84 coordinate reference system, with the order of the axes being longitude followed by latitude.
The table records various details about each accident, including indicators like the type of accident, the severity of the accident, the number of people involved, and the time of the accident. These details, when coupled with the geographical information, can provide insights into accident hotspots and the factors contributing to these accidents.
In terms of data analytics, this table can be leveraged in numerous ways. For instance, the geographical data can be used to identify areas with a high frequency of accidents, which could inform road safety measures, infrastructure improvements, or traffic regulation changes. The time data could be used to identify patterns in accident occurrence, potentially informing targeted public awareness campaigns. Furthermore, the data could be used in predictive modeling to forecast areas and times of high accident risk.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | Indicates the date when the row was extracted from the data source. This, in combination with '_row_number', uniquely identifies each row in the 'table__history' table. |
| _end_date | date | Specifies the date when a new version of the row was extracted from the data source. A null value in this column indicates that the row is the most recent version. |
| _row_number | long | Contains the number of the row as it was extracted in raw form from the data source. This, in combination with '_start_date', uniquely identifies each row in the 'table__history' table. |
| geom_geojson | string | Stores the geometric data of the location in GeoJSON format. |
| geom_geotext | string | Contains the geometric point data in plain text format. |
| geom_type | string | Specifies the type of the geometric data. For example, 'ST_POINT' indicates a single point in space. |
| geom_centroid | string | Holds the central point of the geometric data. |
| geom_center_x | double | Specifies the X-coordinate of the center point of the geometric data. |
| geom_center_y | double | Specifies the Y-coordinate of the center point of the geometric data. |
| gml_id | string | A unique identifier for each row in the table. |
| kello | string | Indicates the time of the event. |
| kkonn | long | A numerical code representing a specific category. |
| lkmhapa | long | Represents a specific count or quantity related to the event. |
| lkmjk | long | Represents a specific count or quantity related to the event. |
| lkmlaka | long | Represents a specific count or quantity related to the event. |
| lkmmo | long | Represents a specific count or quantity related to the event. |
| lkmmp | long | Represents a specific count or quantity related to the event. |
| lkmmuukulk | long | Represents a specific count or quantity related to the event. |
| lkmpp | long | Represents a specific count or quantity related to the event. |
| onntyyppi | string | A numeric code representing the type of event. |
| vakav | string | A character code providing information on the severity of the event. |
| vvonn | string | Indicates the year of the event. |
| x | double | The X-coordinate of the location where the event occurred. |
| y | double | The Y-coordinate of the location where the event occurred. |
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 | 06d8da9e-0600-44f2-bb5d-e447737ec04d |
| Package id | e21da7ee-20ea-49a6-83f2-a4cd5fdfb6b3 |
| Position | 1 |
| Revision id | a8b0d0c4-9f85-4d1c-be4c-b17a34de0a8b |
| State | active |
| Table | tieliikenne_tieliikenne_2015__table__history |