2018 Regional Statistical Areas Dataset Collection

This dataset collection is a compilation of related tables, gathered meticulously from the Statistics Finland (Tilastokeskus) website in Finland. The contents of these tables are derived from the Statistical Service Interface (WFS) provided by Statistics Finland. This collection provides an extensive and detailed insight into statistical areas, offering a thorough understanding of the specific region under study. With data organized in a user-friendly table format, the rows and columns are systematically arranged for easier comprehension and analysis. This makes the dataset a valuable resource for researchers, analysts, and anyone interested in gaining an in-depth understanding of the statistical areas in 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

History of Regional Units 2018 (1:1 000 000): Versioned DataTSV
The 'table__history' is a historical data store that contains version history of its base table rows, originating from the 'Tilastokeskus' website in Finland. The table's contents are based on the dataset titled 'Seutukunnat 2018 (1:1 000 000)', which translates to 'Regions 2018 (1:1 000 000)'. This indicates that the table contains detailed regional data from the year 2018. It consists of several columns, each storing specific types of information. For instance, some columns hold geographic data, useful for geospatial data analytics. These include coordinates presented using the WGS 84 coordinate reference system, with the longitude mentioned first, followed by latitude. Other columns store row identifiers and their version history, indicated by their starting and ending dates. If the...
Subregions 2018 (1:1 000 000) - Data Table of the Statistical Area CollectionTSV
The table is an integral part of a dataset collection, providing an in-depth view of the regional divisions of Finland in 2018. The data is sourced from the 'Tilastokeskus' (Statistics Finland) website. The table contains various columns that provide a detailed representation of each region, inclusive of geographical and statistical information. The table hosts a wealth of information for each region, including its name in various languages, a unique indicator, and an associated year. The geographical information is presented using the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude. This information can be instrumental in performing geospatial data analytics. The table also contains special columns like '_extract_date' and...

Column Descriptions

Subregions 2018 (1:1 000 000) - Data Table of the Statistical Area Collection

Column	Type	Comment
_extract_date	date	This column contains the date when the data on the row was extracted from the source. It plays a crucial role in identifying each row in combination with the '_row_number' column.
_row_number	long	This column contains the row number in the data extracted from the source on the extract date specified by the '_extract_date' column. The combination of this column with '_extract_date' provides a unique identifier for each row.
geom_geojson	string	This column contains geographical data in GeoJSON format, a format for encoding a variety of geographic data structures.
geom_geotext	string	This column contains the textual representation of the geographical data.
geom_type	string	This column indicates the type of the geographical data structure. For instance, it can be a 'MultiPolygon' which represents a shape consisting of multiple polygons.
geom_centroid	string	This column contains the centroid of the geographical data structure. The centroid is the arithmetic mean position of all the points in the shape.
geom_center_x	double	This column contains the x-coordinate of the center of the geographical data structure.
geom_center_y	double	This column contains the y-coordinate of the center of the geographical data structure.
gml_id	string	This is a string type column which does not have a clear description provided by the source.
name	string	This is a string type column with the 'name' of the corresponding entry.
namn	string	This is a string type column which is not clearly described by the source.
nimi	string	This is a string type column which is not clearly described by the source.
seutukunta	string	This is a string type column. The exact meaning and usage is not clear from the data source.
vuosi	long	This integer type column does not have a clear description provided by the source.

History of Regional Units 2018 (1:1 000 000): Versioned Data

Column	Type	Comment
_start_date	date	Indicates the date when the row was extracted from the data source.
_end_date	date	Indicates the date when a new version of the row was extracted from the data source. If the value is null, it signifies that the row is the most recent version.
_row_number	long	Represents the number of the row in the raw data extracted from the data source. This column, combined with '_start_date', forms a unique identifier for each row in this version history table.
geom_geojson	string	Contains the GeoJSON format of the geographical data.
geom_geotext	string	Holds the textual representation of the geographical data.
geom_type	string	Specifies the type of the geographical data.
geom_centroid	string	Provides the centroid point of the geographical data.
geom_center_x	double	Indicates the X coordinate of the geographical data center.
geom_center_y	double	Indicates the Y coordinate of the geographical data center.
gml_id	string	Serves as a unique identifier for the geographical data.
name	string	Contains the name of the region in English.
namn	string	Contains the name of the region in Swedish.
nimi	string	Contains the name of the region in Finnish.
seutukunta	string	Holds the region code.
vuosi	long	Indicates the year of the data.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024