Version History of Road Traffic Accidents 2013
The 'table__history' is a comprehensive chronicle of traffic accidents that occurred in Finland in 2013, sourced from the Finnish statistical agency, 'Tilastokeskus'. This table forms a part of the larger 'tieliikenne_tieliikenne_2013' dataset collection.
The table keeps track of the version history of each row in the base table, providing a timeline of when each piece of data was extracted and when it was updated, if applicable. Unique identifiers for each row are created through a combination of the extraction date ('_start_date') and the row number ('_row_number') in the raw data. If a row has been updated, the '_end_date' column lists the date of the new extraction; if this is null, it indicates that the row is the most recent version.
In addition to the temporal metadata, the table contains detailed information on each traffic accident, including the type and severity of the accident and the number of different types of vehicles involved. This information is supplemented with geographical data, which is presented using the WGS 84 coordinate reference system. The 'geom_' prefixed columns provide geospatial data that can be utilized for geospatial data analytics, including the exact coordinates ('geom_center_x', 'geom_center_y') of the accident, and the shape and location ('geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid') of the geographic feature associated with the accident.
This table offers a wealth of opportunities for data analytics. For example, analysts could use the geographical data to identify high-risk areas for traffic accidents and assess whether certain types of accidents are more common in specific regions. Similarly, by analyzing the temporal metadata, analysts could identify trends in accident occurrence and severity over time, potentially revealing patterns related to weather, traffic conditions, or other time-dependent factors. The comprehensive nature of 'table__history' makes it an invaluable resource for any data-driven approach to improving road safety.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column represents the date when the row was extracted from the data source. It is a part of a unique identifier for each row in combination with the '_row_number' column in this version history table. |
| _end_date | date | This column represents the date when a new version of a row was extracted from the data source. If the value is null, it indicates that the row version is the most recent one. |
| _row_number | long | This column contains the number of the row in the raw data extracted from the data source. It forms a unique identifier for each row in combination with the '_start_date' column. |
| geom_geojson | string | This column contains the geographical information of the data in GeoJSON format. |
| geom_geotext | string | This column contains the geographical information as a plain text. |
| geom_type | string | This column specifies the type of the geographical data. The data is of type 'ST_POINT', which represents a point in space. |
| geom_centroid | string | This column contains the centroid 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 each row. |
| kello | string | This column represents a time range. |
| kkonn | long | This integer column represents a specific attribute of the data, with values like 12, 7, 3, 10, 5. |
| lkmhapa | long | This integer column represents a specific attribute of the data, with values like 1, 0, 2. |
| lkmjk | long | This integer column represents a specific attribute of the data, with values like 0, 1. |
| lkmlaka | long | This integer column represents a specific attribute of the data, with values like 0, 1. |
| lkmmo | long | This integer column represents a specific attribute of the data, with values like 0. |
| lkmmp | long | This integer column represents a specific attribute of the data, with values like 0, 1. |
| lkmmuukulk | long | This integer column represents a specific attribute of the data, with values like 0. |
| lkmpp | long | This integer column represents a specific attribute of the data, with values like 0. |
| onntyyppi | string | This column represents a specific attribute of the data, with values like 8, 7, 2, 0, 1. |
| vakav | string | This column represents a specific attribute of the data, with values like 2, 1. |
| vvonn | string | This column represents the year of the event, with values like 2013. |
| x | double | This column contains the X coordinate of the geographical location. |
| y | double | This column contains the Y coordinate of the geographical location. |
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 | 37619143-455c-40cf-957c-31933953fd85 |
| Package id | f4157bcd-57a1-48cc-9db4-0d6b789b209a |
| Position | 1 |
| Revision id | 98be2c38-8031-4760-99ef-ed4b759cd4ed |
| State | active |
| Table | tieliikenne_tieliikenne_2013__table__history |