2019 Road Traffic Accidents History Version - Finland
Click here for a data sample
The 'table__history' is a comprehensive record containing the version history of its base table rows. It holds significant data pertaining to road traffic accidents in 2019 (Tieliikenneonnettomuudet 2019), sourced from the Central Bureau of Statistics (Tilastokeskus) in Finland. This historical table uniquely identifies each row with a combination of the row number and the date when the row was first extracted from the source data. It also reflects when a new version of the row was extracted, providing an ongoing timeline of updates. If the end date for a row is null, it denotes the most recent version. The table is rich with geographic information, encoded in columns beginning with 'geom_', which is useful for geospatial data analytics. These columns present geographic coordinates using the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude. The data in this table could be utilized in a variety of ways in data analytics. For example, one could analyze the frequency of accidents based on time of day, month, or geographical location to identify high-risk areas or periods. The data could also be used to study the relationship between accident severity and other factors such as the number of involved parties.
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 part of the combination with _row_number that uniquely identifies 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 row number from the raw data extracted from the source. It forms a unique identifier for each row in combination with _start_date. |
|---|
| geom_geojson | string | This column contains geometric data in the GeoJSON format. |
|---|
| geom_geotext | string | This column contains geometric data in text format. |
|---|
| geom_type | string | This column indicates the geometric data type. |
|---|
| geom_centroid | string | This column contains the geometric center (centroid) of the data point. |
|---|
| 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 a unique identifier for the data point. |
|---|
| kello | string | This column contains the time associated with the data point. |
|---|
| kkonn | long | This column contains an integer value. |
|---|
| lkmhapa | long | This column contains an integer value. |
|---|
| lkmjk | long | This column contains an integer value. |
|---|
| lkmlaka | long | This column contains an integer value. |
|---|
| lkmmo | long | This column contains an integer value. |
|---|
| lkmmp | long | This column contains an integer value. |
|---|
| lkmmuukulk | long | This column contains an integer value. |
|---|
| lkmpp | long | This column contains an integer value. |
|---|
| onntyyppi | string | This column contains a string value. |
|---|
| vakav | string | This column contains a string value. |
|---|
| vvonn | string | This column contains a string value. |
|---|
| x | double | This column contains a real number representing the x-coordinate of the data point. |
|---|
| y | double | This column contains a real number representing the y-coordinate of the data point. |
|---|
