Statistical Areas Municipality 1000k 2024

The dataset collection in focus contains a group of related data tables, sourced from the 'Tilastokeskus' website, located in Finland. The data tables within this collection present an array of interlinked data, structured in a table format with rows and columns for ease of understanding and analysis. As per the information provided by the data source, the dataset is a service interface (WFS) provided by the Statistics Center. Please note that this description is a broad overview and the exact contents of the dataset may vary. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

Historical Version Records of Municipalities 2024 (1:1 000 000)TSV
The 'table__history' is a history table that contains the version history of its base table rows. The table is a part of a dataset collection that focuses on the municipalities of Finland in 2024 at a scale of 1:1 000 000. The table is sourced from the website of 'Tilastokeskus' (Statistics Finland). The data in the table is organized in rows and columns, with each row representing a unique version of a municipality and each column representing a specific attribute or characteristic of that municipality. The table includes columns for geographic information, which can be utilized for geospatial data analytics. These columns contain data in GeoJSON format, text format, type of the geographic feature, centroid of the feature, and x and y coordinates of the feature's center. The...
Municipalities 2024 Statistics (1:1 000 000) - Dataset TableTSV
The table in question is a rich data collection pertaining to the municipalities in Finland for the year 2024. It is sourced from the Finnish statistical agency, 'Tilastokeskus' (Statistics Finland). It consists of a variety of columns, each containing vital data that can be used for various forms of data analytics. The columns include a unique identifier for each municipality, their name in different languages, and the year of the data. The table also contains intricate geometric data representing the geographic location and shape of each municipality. This includes the type of geometric representation used, as well as the centroid and center coordinates of the geographic shape. These geographic coordinates are presented using the WGS 84 coordinate reference system, with axis order...

Column Descriptions

Municipalities 2024 Statistics (1:1 000 000) - Dataset Table

Column	Type	Comment
_extract_date	date	This column indicates the date when the data in the row was extracted from the source.
_row_number	long	This column contains the row number within the dataset that was extracted on the specific '_extract_date'. The combination of '_extract_date' and '_row_number' provides a unique identifier for each row.
geom_geojson	string	This geojson formatted column contains the geometric representation of the respective municipality in the form of polygons or multipolygons.
geom_geotext	string	This column contains textual representation of the geometric shape of the respective municipality.
geom_type	string	This column specifies the type of the geometric shape used to represent the respective municipality. It can be a polygon or multipolygon.
geom_centroid	string	This column contains the data of the geometric center point of the respective municipality.
geom_center_x	double	This column represents the x-coordinate of the center point of the respective municipality's geometric shape.
geom_center_y	double	This column represents the y-coordinate of the center point of the respective municipality's geometric shape.
gml_id	string	This column provides a unique ID for each row in the table, following the format 'kunta1000k_[year].[row_number]'.
kunta	string	This column contains the municipality code in string format.
name	string	This column contains the name of the municipality in Finnish.
namn	string	This column contains the name of the municipality in Swedish.
nimi	string	This column contains the name of the municipality in another language, possibly a regional language.
vuosi	long	This column indicates the year that the data is representative of.

Historical Version Records of Municipalities 2024 (1:1 000 000)

Column	Type	Comment
_start_date	date	This column holds the date when the row was extracted from the data source, it acts as a timestamp for when the version of the row was created. Together with '_row_number', it uniquely identifies each row in this history table.
_end_date	date	This column represents the date when a new version of the row was extracted from the data source, effectively indicating the end of the validity period for the current row version. If the value of the 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. This, in combination with '_start_date', uniquely identifies each row in the history table.
geom_geojson	string	This column holds geospatial data in GeoJSON format, which is a format for encoding a variety of geographic data structures. The values in this column represent different geometric shapes.
geom_geotext	string	This column contains geospatial data in Geotext format. The data represents different geometric shapes such as polygons and multipolygons.
geom_type	string	This column specifies the type of geometric shape represented in the 'geom_geojson' and 'geom_geotext' columns. It can be a multipolygon or a polygon.
geom_centroid	string	This column contains the centroid point of the geometric shape. It is a point in 2D space, represented in the Point format.
geom_center_x	double	This column represents the X coordinate of the geometric shape's center point.
geom_center_y	double	This column represents the Y coordinate of the geometric shape's center point.
gml_id	string	This column contains the unique identifier of the row in String format. The identifier is based on the year and the row number in the original data source.
kunta	string	This column contains a unique code associated with each municipality.
name	string	This column contains the name of the municipality in Finnish.
namn	string	This column holds the Swedish name of the municipality.
nimi	string	This column holds the Finnish name of the municipality.
vuosi	long	This column contains the year associated with the data. It is of Integer data type.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024