2016 Statistical Area Data Collection for Municipalities in Finland

The dataset collection is a compilation of related data tables sourced from the 'Tilastokeskus' website, based in Finland. These tables provide a wide array of statistical data, offering a comprehensive overview of relevant statistical areas. The data is organized into columns and rows, facilitating easy understanding and efficient analysis. This dataset collection is designed to provide a detailed snapshot of statistical areas, making it a valuable resource for researchers, statisticians, and data analysts. The data is presented in a user-friendly table format, making it easily accessible and simple to interpret, regardless of the complexity of the data being presented. 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 the 'Municipalities 2016' Dataset in Geo Boundaries FormatTSV
The history table contains a record of changes of its base table. It holds the version history of each row in the base table, documenting the chronological sequence of changes. Each row is uniquely identified by the combination of the date of extraction and the row number from the raw data source. The table includes two additional fields to track the start and end dates of each version of the row. If the end date is null, it indicates the most recent version. Geographic information is stored in various formats, enabling geospatial data analysis. These geographic coordinates are presented using the WGS 84 coordinate reference system, with the longitude appearing before the latitude. The base table's content, 'Municipalities 2016 (1:1 000 000)', provides information about the...
Municipalities of 2016 (Scale 1:1,000,000) - Data TableTSV
This table, part of a dataset from Finland's Statistical Bureau (Tilastokeskus), is a rich source of geospatial data. It presents information about Finnish municipalities in 2016. Each row corresponds to a unique data extraction, identified by a combination of extraction date and row number. This allows for tracking of data evolution over time. The table contains multiple geographical information columns, beginning with 'geom_', which can be utilized for geospatial data analytics. These include geometric types, centroids, and center coordinates, all expressed using the WGS 84 coordinate reference system, with longitude first, followed by latitude. The 'kunta' column contains unique identifiers for each municipality. The names of these municipalities are provided in multiple languages,...

Column Descriptions

Municipalities of 2016 (Scale 1:1,000,000) - Data Table

Column	Type	Comment
_extract_date	date	This column represents the date when the data on the row was extracted from the source. It is a special column that helps identify when the data was pulled.
_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 is a special column that when combined with '_extract_date', helps to uniquely identify each row.
geom_geojson	string	This column contains GeoJSON formatted geographical data which represents various geographical features with their non-spatial attributes.
geom_geotext	string	This column contains geographic data in text format. It represents the same data as in the 'geom_geojson' column but in a different format.
geom_type	string	This column specifies the type of the geographical data stored in the 'geom_geojson' and 'geom_geotext' columns. The sample value 'ST_MULTIPOLYGON' suggests that the data represents multiple polygonal areas.
geom_centroid	string	This column contains points representing the geometric central point of the geographical feature(s).
geom_center_x	double	This column represents the x-coordinate of the central point of the geographical feature(s).
geom_center_y	double	This column represents the y-coordinate of the central point of the geographical feature(s).
gml_id	string	This column contains a unique identifier for each row, following a specific naming convention that includes the dataset collection name and the row number.
kunta	string	This column contains string type data. The exact meaning of the data is not provided by the source.
name	string	This column contains string type data. Based on the sample values, it appears to represent names of geographical areas or entities.
namn	string	This column contains string type data, likely representing names of geographical areas or entities in a different language.
nimi	string	This column contains string type data. Similar to 'name' and 'namn', it seems to represent names of geographical areas or entities in yet another language.
vuosi	double	This column contains real type data. The exact nature of the data is not specified by the source. However, based on the column name 'vuosi' (year in Finnish) and the sample values, it appears to represent years.

Historical Version Records of the 'Municipalities 2016' Dataset in Geo Boundaries Format

Column	Type	Comment
_start_date	date	This column contains the date when the row was extracted from the data source. This is one of the additional columns in this version history table compared to its base 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 means that the row is the most recent version.
_row_number	long	This column contains the number of the row in the raw data from the data source. Together with '_start_date', it uniquely identifies each row in this version history table.
geom_geojson	string	This column contains the geographical data of the row in GeoJSON format.
geom_geotext	string	This column contains the geographical data of the row in Geotext format.
geom_type	string	This column describes the type of the geographical data.
geom_centroid	string	This column contains the centroid of the geographical data.
geom_center_x	double	This column contains the x-coordinate of the center of the geographical data.
geom_center_y	double	This column contains the y-coordinate of the center of the geographical data.
gml_id	string	This column contains the ID of the row in GML format.
kunta	string	This column contains a string value.
name	string	This column contains a string value.
namn	string	This column contains a string value.
nimi	string	This column contains a string value.
vuosi	double	This column contains a real number value.

Additional Info

Last Updated	November 11, 2024
Created	November 11, 2024