Road Traffic Statistics 2020
Tables
-
2020 Road Traffic Accidents History TableTSV
The 'table__history' is a historical record of the 'Road Traffic Accidents 2020' dataset, sourced from the 'Statistics Finland' (Tilastokeskus) website. It captures the version history of each row in its base table, presenting a temporal snapshot of the data at the time of extraction. The table uniquely identifies each row through a combination of '_start_date', marking the extraction date, and '_row_number', signifying the row's position in the raw data. The '_end_date' indicates when a new version of the row was extracted; a null value signifies the most current version. This table contains a wealth of geographic and categorical data. It features a series of 'geom_' columns, which store geospatial information, such as coordinates and point types, a critical resource for geospatial...
-
Road Traffic Accidents 2020TSV
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...
Column Descriptions
Road Traffic Accidents 2020
| Column | Type | Comment |
|---|---|---|
| _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. |
2020 Road Traffic Accidents History Table
| Column | Type | Comment |
|---|---|---|
| _start_date | date | The date when the row was extracted from the data source, marking the start of the version history for that specific row. |
| _end_date | date | 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 | The number of the row in the raw data extracted from the data source. Together with '_start_date', it uniquely identifies each row in this version history table. |
| geom_geojson | string | GeoJSON representation of the geographical point associated with the row. |
| geom_geotext | string | Textual representation of the geographical point associated with the row. |
| geom_type | string | Type of the geographical object represented in 'geom_geojson' and 'geom_geotext'. |
| geom_centroid | string | Centroid of the geographical object associated with the row. |
| geom_center_x | double | X-coordinate of the center of the geographical object associated with the row. |
| geom_center_y | double | Y-coordinate of the center of the geographical object associated with the row. |
| gml_id | string | Unique identifier of the row. |
| kello | string | Time associated with the row. |
| kkonn | long | Integer value associated with the row. |
| lkmhapa | long | Integer value associated with the row. |
| lkmjk | long | Integer value associated with the row. |
| lkmlaka | long | Integer value associated with the row. |
| lkmmo | long | Integer value associated with the row. |
| lkmmp | long | Integer value associated with the row. |
| lkmmuukulk | long | Integer value associated with the row. |
| lkmpp | long | Integer value associated with the row. |
| onntyyppi | string | Integer value associated with the row. |
| vakav | string | Integer value associated with the row. |
| vvonn | string | String value associated with the row. |
| x | double | Real value representing the X-coordinate of the geographical point associated with the row. |
| y | double | Real value representing the Y-coordinate of the geographical point associated with the row. |
Additional Info
| Last Updated | November 12, 2024 |
|---|---|
| Created | November 11, 2024 |