2021 Statistical Area Dataset Collection for Municipalities

This dataset collection comprises a number of related data tables grouped together. The data tables in this collection have been sourced from the website of Tilastokeskus, also known as the Finnish Statistical Agency, based in Finland. The contents within these tables come from the Statistical Interface Service (WFS). This interface provides a wide range of statistical data, catered for various research and analytical needs. The data, organized in a tabular format with rows and columns, is meticulously arranged for easy understanding 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

Municipalities in 2021 (Scale 1:4 500 000) - Data TableTSV
The table, part of the dataset collection 'tilastointialueet_kunta4500k_2021', contains data related to 'Municipalities 2021 (1:4 500 000)', sourced from the 'Tilastokeskus' (Statistics Finland) website in Finland. The data includes information about different municipalities, identified with specific codes and names, and the year of data reference. Moreover, each row in the table is uniquely identified by a combination of an extraction date and a row number, indicating when the data was pulled from the source and the position of the row in the extracted data. A significant part of the data is dedicated to geographic information, providing detailed geospatial data that can be utilized for geospatial data analytics. This geographic data includes polygons, centroids, and center coordinates...
Version History of Municipalities 2021 at 1:4,500,000 ScaleTSV
The 'table__history' is a historical data table, sourced from the 'Tilastokeskus' website in Finland. It provides a version history of its base table rows, primarily focusing on the year 2021. This table is part of the dataset collection 'tilastointialueet_kunta4500k_2021'. The table records a variety of information, including geographical data, row versions, and municipal data. The geographical data includes geospatial coordinates and information which can be utilized for geospatial data analytics. This geographic information is presented using the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude. Additionally, the table contains a unique row identification system that combines the '_start_date' and '_row_number' columns. The...

Column Descriptions

Municipalities in 2021 (Scale 1:4 500 000) - Data Table

Column	Type	Comment
_extract_date	date	The date the data in the respective row was extracted from the source. This, in combination with '_row_number', uniquely identifies each row.
_row_number	long	The row number in the data extracted from the source on the date specified by '_extract_date'. This, in combination with '_extract_date', uniquely identifies each row.
geom_geojson	string	The geometric data of the area represented in GeoJSON format. This data defines the physical boundaries of the area.
geom_geotext	string	The geometric data of the area represented in text format. This is another way of defining the physical boundaries of the area.
geom_type	string	The type of geometric data stored in the respective row. For example, it could be a polygon representing a particular area.
geom_centroid	string	The centroid of the geometric figure representing the area. This is calculated as the average of all points in the geometric figure.
geom_center_x	double	The x-coordinate of the center of the geometric figure representing the area.
geom_center_y	double	The y-coordinate of the center of the geometric figure representing the area.
gml_id	string	A unique identifier for each row, representing the geometry data for the particular area.
kunta	string	A code representing the specific municipality within Finland.
name	string	The English name of the municipality.
namn	string	The name of the municipality in Swedish, one of the official languages of Finland.
nimi	string	The name of the municipality in Finnish, the national language of Finland.
vuosi	long	The year the data was collected or is relevant for.

Version History of Municipalities 2021 at 1:4,500,000 Scale

Column	Type	Comment
_start_date	date	This column contains the date when the row was extracted from the data source. It's a part of a unique identifier for each row in this history table.
_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 signifies 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. Along with '_start_date', it forms a unique identifier for each row in this history table.
geom_geojson	string	This column contains the geometric shape of the area in GeoJSON format, a common format for encoding a variety of geographic data structures.
geom_geotext	string	This column contains the geometric shape of the area in WKT (Well-known text) format, a text markup language for representing vector geometry objects.
geom_type	string	This column specifies the type of the geometric shape of the area.
geom_centroid	string	This column contains the centroid of the geometric shape of the area in WKT (Well-known text) format.
geom_center_x	double	This column contains the x-coordinate of the centroid of the geometric shape of the area.
geom_center_y	double	This column contains the y-coordinate of the centroid of the geometric shape of the area.
gml_id	string	This column contains a unique identifier for each area.
kunta	string	This column contains the municipality code for each area.
name	string	This column contains the name of the area in English.
namn	string	This column contains the name of the area in Swedish.
nimi	string	This column contains the name of the area in Finnish.
vuosi	long	This column contains the year of the data.

Additional Info

Last Updated	November 11, 2024
Created	November 11, 2024