Statistical Areas Municipality Dataset - 2019 Edition

This dataset collection is a group of interrelated tables sourced from the 'Tilastokeskus' (Statistics Finland) website, based in Finland. The tables are organized in a structured format consisting of rows and columns that hold related data. From a comprehensive review, the dataset is found to be a service interface (WFS) provided by Statistics Finland. This dataset collection can be an invaluable resource for various research and analytical purposes, considering the reputation of the source. 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 2019 (1:1 000 000) - Geographical Data CollectionTSV
The table under consideration is a collection of related data that forms part of a larger dataset, specifically 'tilastointialueet_kunta1000k_2019'. This table is of particular interest for its focus on municipalities in 2019, as translated from the original Finnish description, 'Kunnat 2019 (1:1 000 000)'. Sourced from the Finnish web site 'Tilastokeskus' (Statistics Finland), the table provides a wealth of data ripe for analysis. One of the main features of this table is its geographical data, as evidenced by several columns beginning with 'geom_'. These columns contain various types of geographic information, making the table a valuable resource for geospatial data analytics. The geographic coordinates are presented in the WGS 84 coordinate reference system, with longitude listed...
Municipalities 2019 (1:1 000 000) - Version HistoryTSV
The 'table__history' is part of the 'tilastointialueet_kunta1000k_2019' dataset collection, which is sourced from the 'Tilastokeskus' website based in Finland. This table serves as a history table, encapsulating the version history of its base table rows. It comprises of several columns that contain a variety of data, including geographic and temporal information. For instance, the 'start_date' column marks the date when a row was extracted from the data source, while the '_end_date' column indicates when a new version of the row was extracted. A combination of '_start_date' and '_row_number' uniquely identifies each row, with '_row_number' pointing to the number of the row in the raw data extracted from the data source. If the '_end_date' for a row is null, it means that the row is the...

Column Descriptions

Municipalities 2019 (1:1 000 000) - Geographical Data Collection

Column	Type	Comment
_extract_date	date	This column contains the date when the data row was extracted from the data source.
_row_number	long	This column contains the row number in the data extracted from the source on a specific extract date. Together with '_extract_date', it uniquely identifies each row.
geom_geojson	string	This column stores geometric data in GeoJSON format, representing the geographical features of the area.
geom_geotext	string	This column contains geometric data in text format, representing geographical features of the area.
geom_type	string	This column describes the type of geometric data stored in the 'geom_geojson' and 'geom_geotext' columns. For example, it may indicate that the geometric data represents a multipolygon.
geom_centroid	string	This column contains the central point of the geographical feature represented by the geometric data in the 'geom_geojson' and 'geom_geotext' columns.
geom_center_x	double	This column represents the x-coordinate of the center of the geographical feature.
geom_center_y	double	This column represents the y-coordinate of the center of the geographical feature.
gml_id	string	This is a unique identifier for each row of data.
kunta	string	This column represents the municipality code in Finland.
name	string	This column contains the name of the municipality in English.
namn	string	This column contains the name of the municipality in Swedish.
nimi	string	This column contains the name of the municipality in Finnish.
vuosi	long	This column indicates the year for which the data is relevant.

Municipalities 2019 (1:1 000 000) - Version History

Column	Type	Comment
_start_date	date	This column contains the date when the row was extracted from the data source, marking the start of the row's version in the history table. For example, a date could be '2024-11-11'.
_end_date	date	This column contains the date when a new version of the row was extracted from the data source, marking the end of the row's version in the history table. If the value is null, it indicates that the row is the most recent version. For example, a value could be 'None'.
_row_number	long	This column contains the number of the row in the raw data extracted from the data source. In combination with '_start_date', it uniquely identifies each row in this version history table.
geom_geojson	string	This column contains the geographical information of the area in GeoJSON format (a format for encoding geographic data structures).
geom_geotext	string	This column contains the textual representation of the geographical information in multipolygon format.
geom_type	string	This column specifies the type of the geometrical object represented in the 'geom_geojson' and 'geom_geotext' columns. For example, it could be 'ST_MULTIPOLYGON'.
geom_centroid	string	This column contains the centroid (geographical center) of the area represented by the geographical information.
geom_center_x	double	This column contains the x-coordinate (longitude) of the center of the area represented by the geographical information.
geom_center_y	double	This column contains the y-coordinate (latitude) of the center of the area represented by the geographical information.
gml_id	string	This column contains the ID of the area in GML (Geography Markup Language) format.
kunta	string	This column contains a unique identifier for the 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 associated with the data row. For example, it could be '2019'.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024