2022 Road Traffic Data Collection

The dataset collection consists of a group of tables that are related and sourced from the 'Tilastokeskus' (Statistics Finland) website in Finland. The tables contain a variety of data obtained via the service interface of Statistics Finland, presenting a broad spectrum of information. This collective dataset focuses on providing a comprehensive view of the current year's traffic data. Each table within the collection contains a range of related data, which is organized in a table format with columns and rows, thereby allowing for detailed analysis and interpretation of the data. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

2022 Road Traffic Accidents History - Version RecordsTSV
The 'tablehistory' is a version history table that captures the evolution of its base table rows over time. It is a component of a larger dataset group dedicated to road traffic accidents in 2022. The table collects a wealth of data across several columns, providing a detailed overview of each recorded accident. Unique identifiers for each row are established through a combination of the start date, when the row was first extracted from the data source, and a row number. The end date column indicates when a newer version of the row was extracted, with a null value signifying that the row is the most recent version. These date-related columns are exclusive to this version history table, making it more informative than the base table. Among the data collected, there is geographic...
Road Traffic Accidents 2022 - Data OverviewTSV
The table is an integral component of a closely related group of information that is organized in rows and columns. The table belongs to a larger dataset collection, which comprises one or more such tables. This particular table forms part of a dataset that is dedicated to Road Traffic Accidents in 2022. It provides a detailed analysis of traffic mishaps that took place during the year 2022, as sourced from the 'Tilastokeskus' website of Finland. The table is rich in information, detailing not only the date of data extraction but also the specific row number of extracted data, making each row of data unique and identifiable. It provides geographic details that are particularly useful for geospatial data analysis. Geographic coordinates are presented using the WGS 84 coordinate...

Column Descriptions

Road Traffic Accidents 2022 - Data Overview

Column	Type	Comment
_extract_date	date	This column contains the date when the data on the row of the table was extracted from the source.
_row_number	long	This column contains the row number in the data extracted from the source on the extract date specified.
geom_geojson	string	This column records the geographical coordinates of the data point in GeoJSON format.
geom_geotext	string	This column represents the geographical coordinates of the data point in a text format.
geom_type	string	This column indicates the type of geographical data represented, in this case, a point.
geom_centroid	string	This column specifies the centroid of the geographical data point.
geom_center_x	double	This column provides the X coordinate of the center of the geographical data point.
geom_center_y	double	This column provides the Y coordinate of the center of the geographical data point.
gml_id	string	This column contains the id of the data point in the GML (Geography Markup Language) format.
kello	string	This column records the time range during which the data was collected.
kkonn	long	This column records an integer value. The specific meaning of this value is not provided by the data source.
lkmhapa	long	This column records an integer value. The specific meaning of this value is not provided by the data source.
lkmjk	long	This column records an integer value. The specific meaning of this value is not provided by the data source.
lkmlaka	long	This column records an integer value. The specific meaning of this value is not provided by the data source.
lkmmo	long	This column records an integer value. The specific meaning of this value is not provided by the data source.
lkmmp	long	This column records an integer value. The specific meaning of this value is not provided by the data source.
lkmmuukulk	long	This column records an integer value. The specific meaning of this value is not provided by the data source.
lkmpp	long	This column records an integer value. The specific meaning of this value is not provided by the data source.
onntyyppi	string	This column records an integer value. The specific meaning of this value is not provided by the data source.
vakav	string	This column records an integer value. The specific meaning of this value is not provided by the data source.
vvonn	string	This column records an integer value. The specific meaning of this value is not provided by the data source.
x	double	This column records the X coordinate of the data point in a specified projection.
y	double	This column records the Y coordinate of the data point in a specified projection.

2022 Road Traffic Accidents History - Version Records

Column	Type	Comment
_start_date	date	This column represents the date when the row was extracted from the data source (e.g., 2024-11-11).
_end_date	date	This column represents 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 number of the row in the raw data extracted from the data source. Combined with '_start_date', it uniquely identifies each row in this version history table.
geom_geojson	string	This column contains geographical data in GeoJSON format, which represents the geographical features of the data points.
geom_geotext	string	This column contains the geographical coordinates of the data points in text format.
geom_type	string	This column specifies the type of the geographical data.
geom_centroid	string	This column indicates the centroid, or the geometric center, of the geographical data.
geom_center_x	double	This column represents the X-coordinate of the geometric center of the data points.
geom_center_y	double	This column represents the Y-coordinate of the geometric center of the data points.
gml_id	string	This column contains a unique identifier for each data point.
kello	string	This column indicates the time at which the data was collected.
kkonn	long	This integer column represents a specific attribute of the data.
lkmhapa	long	This integer column represents a specific attribute of the data.
lkmjk	long	This integer column represents a specific attribute of the data.
lkmlaka	long	This integer column represents a specific attribute of the data.
lkmmo	long	This integer column represents a specific attribute of the data.
lkmmp	long	This integer column represents a specific attribute of the data.
lkmmuukulk	long	This integer column represents a specific attribute of the data.
lkmpp	long	This integer column represents a specific attribute of the data.
onntyyppi	string	This column represents a specific attribute of the data.
vakav	string	This column represents a specific attribute of the data.
vvonn	string	This column represents a specific attribute of the data.
x	double	This column represents the X-coordinate of the data points.
y	double	This column represents the Y-coordinate of the data points.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024