Statistics Interface (WFS) Regional Data Collection 2020

The dataset collection in question is a comprehensive assembly of related data tables. These tables are populated with data sourced from 'Tilastokeskus' (Statistics Finland), a reputable entity based in Finland. The data within these tables are organized in an accessible format of rows and columns, facilitating easy navigation and interpretation. Notably, the dataset collection is derived from Tilastokeskuksen palvelurajapinta (WFS), which translates to 'Statistics Finland's service interface (WFS)' in English. This dataset collection provides a wealth of statistical data, reflecting the robust and reliable data collection methodologies employed by Statistics Finland. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

Historical Version Records of Regional Units 2020 (1:1 000 000)TSV
The history table is a detailed record of data changes over time, belonging to the dataset collection. This table, specifically, provides an historical overview of the 'Seutukunnat 2020 (1:1 000 000)' or 'Regional units 2020 (1:1 000 000)' base table data, sourced from the Finnish Statistics Bureau (Tilastokeskus). The history table consists of rows that represent different versions of the base table. Each row is uniquely identified by a combination of a start date, indicating when the data was extracted, and a row number, which is the row's position in the raw data extracted from the source. An end date is also included, marking when a newer version of the row was extracted. If the end date is null, it indicates that the row is the most recent version. Geographic details are provided...
Regional Units 2020 (Scale 1:1,000,000) - Data TableTSV
The table comprises a dataset of regional units for the year 2020 at a scale of 1:1,000,000. The data originates from 'Tilastokeskus' (Statistics Finland), a Finnish web source. The table contains a wealth of information that can be used for various data analytics purposes. For instance, the name, namn, and nimi columns contain the names of the regions in different languages, which can be beneficial for multilingual data analysis and reporting. The seutukunta and vuosi columns provide the code of the region and the year, respectively. The table also includes a unique identifier for each row, a combination of the 'extract_date' and '_row_number', which can be valuable for tracking data modifications over time. The table features multiple columns starting with 'geom', which contain...

Column Descriptions

Regional Units 2020 (Scale 1:1,000,000) - Data Table

Column	Type	Comment
_extract_date	date	This column contains the date when the data on the corresponding row was extracted from the source. This information is crucial to understand the timeline of the dataset.
_row_number	long	This column holds the row number as it is in the data extracted from the source on the extract date specified by the column '_extract_date'. This along with '_extract_date' column can be used to uniquely identify each row.
geom_geojson	string	This column stores the geometric data of the regions in GeoJSON format, a popular open standard format designed for representing simple geographical features.
geom_geotext	string	In this column, the geometric data is presented in textual format which is an alternative representation to the GeoJSON format in the 'geom_geojson' column.
geom_type	string	This column specifies the type of geometric data, which can be either polygon or multipolygon, representing the shape of the statistical region.
geom_centroid	string	This column stores the geographical point that represents the centroid, or the geometric center, of the region.
geom_center_x	double	This column contains the X-coordinate of the centroid of the region.
geom_center_y	double	This column contains the Y-coordinate of the centroid of the region.
gml_id	string	This column holds a unique identifier for each row in the table.
name	string	This column contains the name of the statistical region in English language.
namn	string	This column provides the name of the statistical region in Swedish language.
nimi	string	This column holds the name of the statistical region in Finnish language.
seutukunta	string	This column contains a unique code assigned to each statistical region.
vuosi	long	This column holds the year for which the statistical data is relevant.

Historical Version Records of Regional Units 2020 (1:1 000 000)

Column	Type	Comment
_start_date	date	This column contains the date when a specific row was extracted from the data source. It forms a unique combination with '_row_number' to identify each row in the version history table.
_end_date	date	This column holds the date when a newer version of a row was extracted. If it is null, it signifies that the row is the most recent version.
_row_number	long	This column contains the number of the row as it appears in the raw data extracted from the data source. It forms a unique combination with '_start_date' to identify each row in the version history table.
geom_geojson	string	This column stores the geometric representation of the area in GeoJSON format.
geom_geotext	string	This column contains the geometric representation of the area in text format.
geom_type	string	This column indicates the type of the geometric representation, which in this case is a polygon.
geom_centroid	string	This column holds the geometric center (centroid) of the area.
geom_center_x	double	This column contains the x-coordinate of the geometric center of the area.
geom_center_y	double	This column contains the y-coordinate of the geometric center of the area.
gml_id	string	This column represents a unique identifier for each row.
name	string	This column holds the English name of the area.
namn	string	This column contains the name of the area in another language.
nimi	string	This column provides the name of the area in another language.
seutukunta	string	This column contains a code representing the area.
vuosi	long	This column holds the year associated with the data row.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024