Road Traffic Accidents 2020
The table is a part of a dataset collection that contains information about road traffic accidents for the year 2020, sourced from 'Tilastokeskus' (Statistics Finland), a website based in Finland. The table includes various data points structured as columns, ranging from the date of data extraction to specific geographical coordinates.
It features two noteworthy columns: '_extract_date' and '_row_number'. The former provides the date when the specific data point was extracted, while the latter indicates the unique row number for each data piece extracted on a specific date. This combination allows each row to be uniquely identified.
Several columns in this table store geographic data, which can be instrumental for geospatial data analysis. This data is presented using the WGS 84 coordinate reference system, with longitude appearing before latitude.
The data within the table could serve multiple purposes in the field of data analytics. For instance, temporal analysis could be performed to identify trends in road traffic accidents over time, possibly revealing peak times or months for accidents. Geospatial analysis could help visualize accident hotspots on a map, which could aid in traffic planning and road safety measures. Furthermore, the data could be used to analyze the severity of accidents, potentially highlighting areas with higher incidences of serious accidents and thus contributing to targeted safety interventions.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _extract_date | date | This column contains the date when the data on the row of the table was extracted from the data source. |
| _row_number | long | This column contains the row number in the data extracted from the source on the extract date specified by the column '_extract_date'. |
| geom_geojson | string | This column contains the geographical coordinates of the location in GeoJSON format. |
| geom_geotext | string | This column contains the geographical coordinates of the location in text format. |
| geom_type | string | This column specifies the type of the geographical object, for example, a point. |
| geom_centroid | string | This column contains the geographical coordinates of the centroid of the location. |
| geom_center_x | double | This column contains the X coordinate of the center of the location. |
| geom_center_y | double | This column contains the Y coordinate of the center of the location. |
| gml_id | string | This column contains the unique identifier of the geographical object. |
| kello | string | This column contains the time of the day when the event occurred. |
| 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 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 | e3549e22-9ca5-469f-8b1d-d4c100a22ac7 |
| Package id | 251e032e-54a1-47d2-b539-40aa3f1adcd8 |
| Revision id | 2673ce5f-eb1d-44dc-a04d-7e64dc69b65b |
| State | active |
| Table | tieliikenne_tieliikenne_2020__table |