Statistical Region Data Collection 4500k

The dataset collection in question includes a series of related data tables which originate from the Statistics Finland (Tilastokeskus) website, based in Finland. The collection contains numerous tables that encompass a variety of years, providing a comprehensive and chronological perspective of the data. The data in this collection is sourced from the Statistics Finland's service interface (WFS). Therefore, the dataset collection provides a rich source of statistical data, collated and organized into tables, offering a detailed exploration of specific areas over a range of years. 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 at 1:4,500,000 ScaleTSV
The table belongs to a dataset collection, and it contains data on Municipalities at a detailed scale of 1:4,500,000. Originating from the website of Statistics Finland ('Tilastokeskus'), the table features several columns that carry valuable information. Two special columns in this table are '_extract_date' and '_row_number', which contain the date when the data was extracted and the corresponding row number in the data extracted on that particular date, providing a unique identifier for each row. The table also contains multiple 'geom_' columns, which hold geographic information useful for geospatial data analytics. For instance, 'geom_geojson' contains Geographical JSON data, 'geom_geotext' and 'geom_centroid' provide geographical text and centroid points, and 'geom_center_x' and...
Version History of Municipalities (Scale 1:4,500,000)TSV
The 'table__history' is a rich and comprehensive history table, capturing the version history of its base table rows. The table is part of a larger dataset collection, providing in-depth insights into the municipalities of Finland, as sourced from 'Tilastokeskus' (Statistics Finland). This table comprises a variety of columns, each serving a unique purpose. For instance, the '_start_date' and '_end_date' columns represent the time span for which a specific version of a row remained valid. The '_row_number' column is used to identify each row uniquely in combination with '_start_date'. If '_end_date' is null, it indicates that the row is the most recent version. Notably, the table includes several 'geom_' prefixed columns which hold geographic information. This can be utilized for...

Column Descriptions

Municipalities at 1:4,500,000 Scale

Column	Type	Comment
_extract_date	date	This column records the date when the data on the specific row was extracted from the source. It allows tracking of the data extraction timeline.
_row_number	long	This column contains the row number in the data extracted from the source. Along with the '_extract_date', it uniquely identifies each row.
geom_geojson	string	This column contains geographical data in GeoJSON format. It might include details such as coordinates and polygons representing geographical regions.
geom_geotext	string	This column contains geographical data in plain text format. It is a textual representation of geographical shapes and coordinates.
geom_type	string	This column describes the type of the geographical data stored in the table.
geom_centroid	string	This column contains the centroid of the geographical data. The centroid is the central point of a region represented by geographical data.
geom_center_x	double	This column represents the x-coordinate of the center point of the geographical region.
geom_center_y	double	This column represents the y-coordinate of the center point of the geographical region.
gml_id	string	This column contains unique identifications assigned to each row.
kunta	string	This column contains string values. As the specific description is not provided, it might represent an identifier or a category of the data.
name	string	This column contains string values, possibly representing names related to each row's data.
namn	string	This column contains string values. It seems to contain similar information as the 'name' column, possibly in a different language or representing a different aspect of the data.
nimi	string	This column contains string values. It seems to contain similar information as the 'name' and 'namn' columns, possibly in a different language or representing a different aspect of the data.
vuosi	long	This column contains integer values, possibly representing a year associated with each row's data.

Version History of Municipalities (Scale 1:4,500,000)

Column	Type	Comment
_start_date	date	This column contains the date when the row was extracted from the data source. It aids in tracking the changes in data over time in the 'table__history' table.
_end_date	date	This column denotes the date when a new version of the row was extracted from the data source. If the value is null, it signifies that the row is the latest version.
_row_number	long	This column contains the number of the row as it appeared in the original data from the data source. Together with '_start_date', it uniquely identifies each row in the history table.
geom_geojson	string	This column contains the geographical data in GeoJSON format. GeoJSON is a format for encoding a variety of geographic data structures.
geom_geotext	string	This column contains geometric data in a textual format. It represents the shapes and locations of geographical entities.
geom_type	string	This column specifies the type of the geographical data structure, such as Polygon or MultiPolygon.
geom_centroid	string	This column contains the centroid of the geographical entity, represented as a point.
geom_center_x	double	This column contains the X-coordinate of the geographical entity's center.
geom_center_y	double	This column contains the Y-coordinate of the geographical entity's center.
gml_id	string	This column contains unique identifiers for each row, as provided by the data source.
kunta	string	This column represents a specific attribute of the dataset, as provided by the data source.
name	string	This column contains the English names of the entities.
namn	string	This column contains names of the entities in a different language.
nimi	string	This column also contains the names of the entities, possibly in another language.
vuosi	long	This column contains integer values, representing a specific attribute of the entities, possibly the year.

Additional Info

Last Updated	January 7, 2025
Created	January 2, 2025