2019 Regional Statistics Tables Collection

This dataset collection is composed of several related data tables sourced from the 'Tilastokeskus' (Statistics Finland) website in Finland. The collection provides statistical data through a service interface (WFS) as stated by the data source. The tables within this collection contain relevant and organized data, arranged in a structured format of rows and columns, providing comprehensive statistical information. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

Provinces 2019 (1:4,500,000) - Table from the Finnish Statistics Dataset CollectionTSV
The table in question encompasses data pertaining to the Finnish regions as of 2019. This includes both geographic and informational data about different parts of Finland. The data is sourced from the Finnish statistical authority, 'Tilastokeskus'. The table contains geographic data that can be used for geospatial data analytics. Specifically, it includes detailed geographic coordinates presented using the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude. This geographic data is held within multiple columns, including those that hold geotext, centroids, and center points. Additionally, the table holds unique identifiers for each region, as well as names in different languages including Finnish, Swedish, and English. This allows for multi-lingual...
Version History of the Regions 2019 (1:4 500 000) TableTSV
The 'table__history' contains detailed historical data extracted from the Statistics Finland (Tilastokeskus) website. The table is part of a broader dataset collection focusing on the administrative regions of Finland in 2019 at a 1:4,500,000 scale. It serves as a historical record, preserving the version history of the base table rows. Every row in the table is uniquely identified by a combination of the '_start_date' and '_row_number' columns. These columns also provide insight into when a particular row was extracted from the source, and when a new version of the same row was extracted. Rows with a null '_end_date' are the most recent versions. The table also contains geographic information such as 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and...

Column Descriptions

Provinces 2019 (1:4,500,000) - Table from the Finnish Statistics Dataset Collection

Column	Type	Comment
_extract_date	date	The date when the data on the row was extracted from the data source. This column, in conjunction with '_row_number', uniquely identifies each row.
_row_number	long	The row number in the data extracted from the source on the extract date specified by the column '_extract_date'. This column, in conjunction with '_extract_date', uniquely identifies each row.
geom_geojson	string	The geographical data of the region in GeoJSON format.
geom_geotext	string	The geographical data of the region in geotext format.
geom_type	string	The type of the geographical data.
geom_centroid	string	The centroid of the geographical data.
geom_center_x	double	The x-coordinate of the center of the geographical data.
geom_center_y	double	The y-coordinate of the center of the geographical data.
gml_id	string	The unique identifier of the row in the dataset.
maakunta	string	The region identifier.
name	string	The English name of the region.
namn	string	The name of the region in Swedish.
nimi	string	The name of the region in Finnish.
vuosi	long	The year of the data.

Version History of the Regions 2019 (1:4 500 000) Table

Column	Type	Comment
_start_date	date	Date when the row was extracted from the data source, helping to track the changes over time. It forms a unique pair with '_row_number' to identify each row in this version history table.
_end_date	date	Date when a new version of the row was extracted from the data source. If this value is null, it indicates that the row is the most recent version.
_row_number	long	Number of the row in the raw data extracted from the data source. Paired with '_start_date', it uniquely identifies each row in this history table.
geom_geojson	string	Contains the geographical data in GeoJSON format. GeoJSON is a format for encoding a variety of geographic data structures.
geom_geotext	string	Holds the geographical data in text format. It represents the same information as 'geom_geojson' but in a different format.
geom_type	string	Type of the geographic data structure. In this table, it refers to a specific type of geographical object - a multipolygon.
geom_centroid	string	Point representing the geometric center of the geographical object. Useful for analyzing the geographical distribution of the data.
geom_center_x	double	X-coordinate of the geometric center of the geographical object. It provides more detailed location data.
geom_center_y	double	Y-coordinate of the geometric center of the geographical object. It gives further precision to the location data.
gml_id	string	Unique identifier for each row in the table.
maakunta	string	Corresponds to a specific region in Finland.
name	string	English name of the region.
namn	string	Swedish name of the region.
nimi	string	Finnish name of the region.
vuosi	long	Year when the data was collected.

Additional Info

Last Updated	November 11, 2024
Created	November 11, 2024