Statistics Area Collection for Municipalities 2023

The dataset collection in question is a compilation of related data tables, sourced from the 'Tilastokeskus' website of Finland. These tables are integrated and provide a comprehensive data set offering valuable insights. The data source describes this collection as a statistical service interface (WFS) provided by the Statistics Centre. This suggests that the data collection is likely to be statistical in nature and possibly related to the public services sector in Finland. The tables within this collection are interconnected, making it a valuable resource for those interested in comprehensive, detailed, and interconnected statistical data from 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

Municipalities 2023 (1:4 500 000) - Table from Finnish Statistical Data CollectionTSV
The table under discussion contains data on 'Kunnat 2023 (1:4 500 000)', which translates to 'Municipalities 2023', sourced from the 'Statistics Finland' website in Finland. This table is part of a larger dataset collection, focusing on presenting comprehensive geographical and municipal data for the year 2023. The table holds data for a wide range of geographical attributes, each being represented by a separate column. Some of the columns contain the date of data extraction and row number, providing a unique identification for each data row. This facilitates effective data tracking and extraction. Other columns present various geographical attributes such as Polygon and MultiPolygon data, centroid points, and center coordinates. These specifications, presented in the WGS 84 coordinate...
Version History of Municipalities 2023 (1:4 500 000) TableTSV
The 'table__history' is a vital constituent of the dataset collection 'tilastointialueet_kunta4500k_2023'. This table serves as a historical record, holding the version history of the base table rows. The base table, sourced from 'Tilastokeskus' (Statistics Finland), is titled 'Kunnat 2023 (1:4 500 000)', translated to English as 'Municipalities 2023 (1:4 500 000)'. The table compiles essential information about the municipalities of Finland, including geographical data and identifiers. The table's unique identifier is a combination of the '_start_date' and '_row_number' columns, with the former indicating the date the row was extracted from the data source and the latter representing the row's number in the raw data. The '_end_date' column signifies when a new version of the row was...

Column Descriptions

Municipalities 2023 (1:4 500 000) - Table from Finnish Statistical Data Collection

Column	Type	Comment
_extract_date	date	This column contains the date when the data on the row of the table was extracted from the source. The format is yyyy-mm-dd.
_row_number	long	This column contains the row number in the data extracted from the source on the extract date specified by the column '_extract_date'. This column along with '_extract_date' uniquely identifies each row.
geom_geojson	string	This column contains the geometric data in GeoJSON format. This data represents different types of geometric features.
geom_geotext	string	This column contains the geometric data in text format. The data represents different types of geometric features.
geom_type	string	This column specifies the type of the geometric data.
geom_centroid	string	This column contains the centroid of the geometric data.
geom_center_x	double	This column contains the X-coordinate of the center of the geometric data.
geom_center_y	double	This column contains the Y-coordinate of the center of the geometric data.
gml_id	string	This column contains a unique identifier for each row. The format is 'kunta4500k_2023.row_number'
kunta	string	This column contains a unique identifier for the municipality.
name	string	This column contains the English name of the municipality.
namn	string	This column contains the local name of the municipality.
nimi	string	This column contains the Finnish name of the municipality.
vuosi	long	This column contains the year of the data.

Version History of Municipalities 2023 (1:4 500 000) Table

Column	Type	Comment
_start_date	date	This column indicates the date when the row was extracted from the data source, helping to track the version history of the base table rows.
_end_date	date	This column records the date when a new version of the row was extracted from the data source. If this column's value is null, it signifies that the row is the most recent version.
_row_number	long	This column represents the number of the row in the raw data extracted from the data source. It forms a unique identifier in combination with the '_start_date' column.
geom_geojson	string	The column contains the geometric data in GeoJSON format, representing the geographical boundaries of the region.
geom_geotext	string	The column contains the geometric data in text format, which is a textual representation of the geographical boundaries of the region.
geom_type	string	This column indicates the type of the geographical data, for example, it could be a point, line or polygon.
geom_centroid	string	This column stores the geometric center (centroid) of the region in a point format.
geom_center_x	double	This column holds the X-coordinate of the geometric center of the region.
geom_center_y	double	Contains the Y-coordinate of the geometric center of the region.
gml_id	string	This column contains a unique identifier for each row in the table.
kunta	string	This column holds the municipality code in string format.
name	string	This column holds the English names of the municipalities.
namn	string	Column contains the Swedish names of the municipalities.
nimi	string	This column contains the Finnish names of the municipalities.
vuosi	long	This column indicates the year of the data entry.

Additional Info

Last Updated	November 11, 2024
Created	November 11, 2024