Statistics Finland 2014 Regional Statistics Collection

The dataset collection in question is a comprehensive compilation of related data tables. These tables are sourced from the website of Tilastokeskus (Statistics Finland), located in Finland. The information provided by the data source is served through a statistical interface, denoted as 'Tilastokeskuksen palvelurajapinta (WFS)' in Finnish, which translates to 'Statistics Finland's service interface (WFS)' in English. The tables within this collection share a common theme, and together, they construct a detailed and multifaceted representation of the data. The data compiled within these tables holds a potential wealth of insights and is ideal for in-depth analysis and research. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

History of Regions 2014: Version History of Base Table RowsTSV
The 'table__history' is a rich source of geospatial data, offering a version history of its base table rows. Sourced from the 'Tilastokeskus' (Statistics Finland) website, it covers an array of geographic and demographic data related to the Finnish provinces as of 2014. The table includes geographic coordinates presented using the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude, which can be utilized for geospatial data analytics. Notably, the table features columns for the start and end dates of data extraction from the source, providing insights into the evolution of data over time. It also includes a unique row number for each data entry, which together with the start date, provides a unique identification for each row in this version...
Regions 2014 (1:4 500 000) - A Detailed Geospatial DatasetTSV
This table, located within the dataset 'tilastointialueet_maakunta4500k_2014', provides a comprehensive set of data related to the regions of Finland in 2014. The data has been sourced from the Finnish statistical agency, 'Tilastokeskus' (Statistics Finland). The table contains various columns which provide details such as the date of data extraction, row number, geographic details, and region-specific information. The geographic details are given in the WGS 84 coordinate reference system, with longitude first, followed by latitude. Columns starting with 'geom_' contain this geospatial information, which can be used for data analytics involving geographic positioning and visualization. For instance, the data in the 'geom_center_x' and 'geom_center_y' columns represent the central...

Column Descriptions

Regions 2014 (1:4 500 000) - A Detailed Geospatial Dataset

Column	Type	Comment
_extract_date	date	This column records the date when the data on the row was extracted from the data source. This, combined with the '_row_number' column, forms a unique identifier for each row.
_row_number	long	This column contains the row number of the data extracted from the source on the extract date specified by the column '_extract_date'. It helps in uniquely identifying each row in combination with the '_extract_date' column.
geom_geojson	string	This column contains geometric data in GeoJSON format, which is a format for encoding a variety of geographic data structures.
geom_geotext	string	This column holds the geometric data in text form. It is useful for visualizing the geographic structures associated with the data.
geom_type	string	This column specifies the type of geometric data stored in the row. For example, the type could be 'ST_MULTIPOLYGON' which represents a geographical shape that comprises multiple polygons.
geom_centroid	string	This column contains the central point of the geometric shape represented by the row. It is calculated based on the geometric data.
geom_center_x	double	This column records the x-coordinate of the center of the geometric shape.
geom_center_y	double	This column records the y-coordinate of the center of the geometric shape.
gml_id	string	This column contains the unique identifier for the geometric data in GML (Geography Markup Language) format.
maakunta	string	This column stores a unique identifier for the Finnish province ('maakunta' in Finnish) associated with the row.
name	string	This column contains the English name of the Finnish province associated with the row.
namn	string	This column holds the Swedish name of the Finnish province. In Finland, both Finnish and Swedish are official languages.
nimi	string	This column records the Finnish name of the province associated with the row.
vuosi	long	This column contains the year related to the data in the row. It helps in understanding the temporal context of the data.

History of Regions 2014: Version History of Base Table Rows

Column	Type	Comment
_start_date	date	The date when the row was extracted from the data source. Along with the '_row_number', it forms a unique identifier for each row in this version history table.
_end_date	date	The date when a new version of the row was extracted from the data source. A null value in this column 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. This column forms a unique combination with '_start_date' to identify each row in the version history table.
geom_geojson	string	Contains geometric data in GeoJSON format, representing geographic features.
geom_geotext	string	Contains geometric data as text, representing geographic features.
geom_type	string	Specifies the type of the geometric data stored in the 'geom_geojson' and 'geom_geotext' columns.
geom_centroid	string	Contains the central point of the geometric features represented in the 'geom_geojson' and 'geom_geotext' columns.
geom_center_x	double	The X-coordinate of the central point of the geometric features.
geom_center_y	double	The Y-coordinate of the central point of the geometric features.
gml_id	string	A unique identifier for each row in the base table.
maakunta	string	Contains data related to the region.
name	string	The English name of the region.
namn	string	The Swedish name of the region.
nimi	string	The Finnish name of the region.
vuosi	long	The year for which the data of the row is relevant.

Additional Info

Last Updated	November 11, 2024
Created	November 11, 2024