2019 Road Traffic Accidents Data Table
The 'table' is part of a larger dataset collection which focuses on road traffic accidents in 2019. It comprises columns that contain a variety of data related to each incident, including geographic information, specific identifiers, and details about the accidents themselves. This valuable collection can be utilized for a range of data analytics purposes, such as studying traffic patterns, identifying high-risk areas, or analyzing accident trends over time.
The geographic data is particularly useful for geospatial data analytics, as it is presented using WGS 84 coordinate reference system, with axis order being longitude first, followed by latitude. This allows for the precise pinpointing of accident locations and the creation of detailed, meaningful visualizations.
The table also contains two unique columns, '_extract_date' and '_row_number', that help to keep the data organized and easily trackable. '_extract_date' specifies the date when the data was extracted from the source, and '_row_number' provides a unique identifier for each row. When combined, these columns allow for each row to be uniquely identified.
The data for this table is sourced from the website of 'Tilastokeskus' (Statistics Finland), based in Finland. The comprehensive nature of this table makes it a robust resource for anyone looking to conduct thorough analyses of road traffic accidents.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _extract_date | date | This column records the date when the row data was extracted from the data source. |
| _row_number | long | This column records the row number in the data extracted from the source on the extraction date specified by the '_extract_date' column. |
| geom_geojson | string | This column contains geometric data in GeoJSON format. |
| geom_geotext | string | This column holds the geometric data in a text format. |
| geom_type | string | This column specifies the type of the geometric data. |
| geom_centroid | string | This column contains the centroid of the geometric data. |
| 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 holds the unique identifier of the data row. |
| kello | string | This column represents the time of the event. |
| kkonn | long | This column is an integer type column. |
| lkmhapa | long | This column is also an integer type column. |
| lkmjk | long | This column is an integer type column. |
| lkmlaka | long | This column is an integer type column. |
| lkmmo | long | This column is an integer type column. |
| lkmmp | long | This column is an integer type column. |
| lkmmuukulk | long | This column is an integer type column. |
| lkmpp | long | This column is an integer type column. |
| onntyyppi | string | This column is a string type column. |
| vakav | string | This column is a string type column. |
| vvonn | string | This column is a string type column. |
| x | double | This column is a real type column that holds numerical data. |
| y | double | This column is a real type column that holds numerical data. |
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 | 1435f7a0-5792-4677-ac6f-7574fbf16216 |
| Package id | 93ba0433-1f8c-4181-8d98-cb9a4f1a94ab |
| Revision id | c3dc0ca5-fd3f-46c5-b935-138f1f951cb4 |
| State | active |
| Table | tieliikenne_tieliikenne_2019__table |