Statistical Areas Municipality Summary 2021

The dataset collection under discussion comprises of related data tables sourced from the website of 'Tilastokeskus' (Statistics Finland), located in Finland. The content of these tables is derived from the Statistical Service Interface (WFS), as provided by the data source. The collection encapsulates a wealth of information, organized meticulously into columns and rows within each table, facilitating an easy understanding and interpretation of the data. Although it is a technical collection, it offers a comprehensive overview of the related subject and serves as an invaluable resource for statistical analysis. 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 2021 (1:1 000 000) - Table from the Dataset CollectionTSV
The table is a component of a dataset collection that focuses on Municipalities in 2021 (1:1 000 000). It is sourced from the 'Tilastokeskus' (Statistics Finland) website in Finland. The table is rich in data and provides various types of information. Specifically, it contains a unique row identifier and extraction date, enabling efficient tracking and versioning of the data. It also comprises geographic details represented in the WGS 84 coordinate reference system, which is a standard for geospatial data analytics. With this, users can analyze geographic patterns and trends, like identifying clusters of municipalities based on their geographic coordinates. The table also includes names of municipalities in different languages, allowing for multilingual data analysis. Furthermore, it...
Version History of Municipalities 2021 (1:1 000 000)TSV
The 'table__history' is a part of a larger dataset and serves as a history table containing the version history of its base table rows. The base table contents, denoted as 'Kunnat 2021 (1:1 000 000)', translates to 'Municipalities 2021 (1:1 000 000)' in English. This suggests that the table contains data about municipalities in Finland, as sourced from the website of 'Tilastokeskus' (Statistics Finland). The table contains several columns, each providing unique and insightful information. For instance, there are columns that hold the row number and the dates when the row was extracted from the data source and when a new version of the row was extracted. These form a combination that uniquely identifies each row in the version history table. Geospatial data is also represented in...

Column Descriptions

Municipalities 2021 (1:1 000 000) - Table from the Dataset Collection

Column	Type	Comment
_extract_date	date	This column contains the date when the row's data was extracted from the data source. It helps in identifying the freshness of the data.
_row_number	long	This column indicates the row number in the data extracted from the source on the extract date specified by the column '_extract_date'. It uniquely identifies each row together with '_extract_date'.
geom_geojson	string	This column holds the geometric shape of the area related to the row in GeoJSON format. It helps in visualizing the spatial data.
geom_geotext	string	This column contains the geometric shape of the area in text format, which can be useful for non-graphical data processing.
geom_type	string	This column describes the type of the geometric shape. It can be either a Polygon or a MultiPolygon.
geom_centroid	string	This column holds the coordinates of the centroid of the geometric shape. It can be used to calculate the center point of the area.
geom_center_x	double	This column contains the x coordinate of the center of the geometric shape. It's part of the spatial information about the area.
geom_center_y	double	This column contains the y coordinate of the center of the geometric shape. It's another part of the spatial information about the area.
gml_id	string	This column holds a unique identifier for each row. It follows the format 'kunta1000k_2021.XX' where XX is a unique number.
kunta	string	This column contains a unique code for each municipality. It helps in identifying the area related to the row.
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 indicates the year when the data was collected. It helps in understanding the temporal context of the data.

Version History of Municipalities 2021 (1:1 000 000)

Column	Type	Comment
_start_date	date	This column contains the date when the row was extracted from the data source. It serves as a part of a unique identifier for each row in this version history table.
_end_date	date	This is 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	This column represents the number of the row in the raw data extracted from the source. It forms a unique identifier in combination with the '_start_date' column.
geom_geojson	string	This column contains geographical data in GeoJSON format, typically representing polygons.
geom_geotext	string	This column gives a textual representation of the geographical data, usually in the form of polygons.
geom_type	string	This column indicates the type of geographical data represented. In this table, it is typically 'ST_POLYGON'.
geom_centroid	string	This column provides the centroid of the geographical data in the format of a point.
geom_center_x	double	This column contains the x-coordinate of the centroid of the geographical data.
geom_center_y	double	This column contains the y-coordinate of the centroid of the geographical data.
gml_id	string	This column features a unique identifier for each row.
kunta	string	This column contains a string data type field.
name	string	This column contains the name of the place in English.
namn	string	This column has another version of the name in its original language.
nimi	string	This column contains another name field in a different language.
vuosi	long	This column contains an integer representing the year.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024