Statistical Regions and Provincial Data Collection 2018

This dataset collection consists of related data tables sourced from the Finnish website, Tilastokeskus (Statistics Finland). The data includes statistical information about various regions in Finland, as provided via the Tilastokeskus web service interface. These tables collectively offer a thorough depiction of statistical areas within the scope of the dataset, contributing to a comprehensive understanding of the corresponding subject matter. The data is organized in a tabular format to allow for easy analysis and interpretation. 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 2018 (Scale 1:4 500 000) - Geographic and Demographic DetailsTSV
The table in question is a rich source of geographic and demographic data. It contains information about regions in the country, specifically from the year 2018. Each row in the table represents a unique region, identified by its own unique combination of extraction date and row number. The geographic characteristics of each region are well-documented in the table, with geographic information such as a GeoJSON representation of the region's shape, a geotext version of the same, the centroid of the region, and the coordinates of the center. This geographic information is presented using the WGS 84 coordinate reference system, where the longitude comes before the latitude. Each region is also identified by a unique GML ID, a code, and names in various languages. The extraction date and...
Version History of Regions 2018 (1:4 500 000) DataTSV
The 'table__history' is a historical record of the 'Regions 2018' dataset (originally 'Maakunnat 2018') sourced from 'Tilastokeskus' (Statistics Finland), a website from Finland. This historical table contains the version history of base table rows which provides a timeline of changes to the data over time. Each row in the table corresponds to a unique version of a row from the base table, with two additional columns '_start_date' and '_end_date' to denote the lifespan of each version. The '_start_date' signifies when the version was first extracted from the data source, and '_end_date' indicates when a newer version was extracted. If '_end_date' is null, it implies that the version is the most recent. The '_row_number' column provides the position of the row in the extracted raw data,...

Column Descriptions

Provinces 2018 (Scale 1:4 500 000) - Geographic and Demographic Details

Column	Type	Comment
_extract_date	date	This column contains the date when the data on the row was extracted from the source.
_row_number	long	This column contains the row number in the data extracted from the source. It, in combination with '_extract_date', uniquely identifies each row.
geom_geojson	string	This column contains geometric data in geojson format, which describes the spatial characteristics of the entities.
geom_geotext	string	This column contains geometric data in text format. It complements the 'geom_geojson' column by providing geometric information in a different format.
geom_type	string	This column indicates the type of the geometric data.
geom_centroid	string	This column indicates the geometric center or centroid of the spatial entity.
geom_center_x	double	This column contains the x-coordinate of the geometric center of the spatial entity.
geom_center_y	double	This column contains the y-coordinate of the geometric center of the spatial entity.
gml_id	string	This column contains a unique identifier for each spatial entity.
maakunta	string	This column contains a string representing the region or province.
name	string	This column contains the English name of the region or province.
namn	string	This column contains the name of the region or province in another language.
nimi	string	This column contains the name of the region or province in another language.
vuosi	long	This column contains an integer indicating the year to which the data pertains.

Version History of Regions 2018 (1:4 500 000) Data

Column	Type	Comment
_start_date	date	This column contains the date when the row was extracted from the data source.
_end_date	date	This column contains the date when a new version of the row was extracted from the data source. If the value of this column is null, it means 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. Together with '_start_date', it uniquely identifies each row in this version history table.
geom_geojson	string	This column contains geometrical data in GeoJSON format, describing the geographical area related to the row.
geom_geotext	string	This column contains geometrical data in text format, describing the geographical area related to the row.
geom_type	string	This column specifies the type of the geometrical data stored in the 'geom_geojson' and 'geom_geotext' columns.
geom_centroid	string	This column contains the geographical coordinates of the centroid point of the geographical area related to the row.
geom_center_x	double	This column contains the x-coordinate of the center point of the geographical area related to the row.
geom_center_y	double	This column contains the y-coordinate of the center point of the geographical area related to the row.
gml_id	string	This column contains a unique identifier for each row, provided by the data source.
maakunta	string	This column contains a numerical identifier for the Finnish region (maakunta) associated with the row.
name	string	This column contains the English name of the Finnish region (maakunta) associated with the row.
namn	string	This column contains the Swedish name of the Finnish region (maakunta) associated with the row.
nimi	string	This column contains the Finnish name of the region (maakunta) associated with the row.
vuosi	long	This column contains the year when the data for the row was collected.

Additional Info

Last Updated	November 11, 2024
Created	November 11, 2024