Statistics Interface Province-Level Data Collection

The dataset collection in question is a compilation of related data tables sourced from the website of Tilastokeskus (Statistics Finland) in Finland. The data present in the collection is organized in a tabular format comprising of rows and columns, each holding related data. The collection includes several tables, each of which represents different years, providing a temporal view of the data. The description provided by the data source, Tilastokeskuksen palvelurajapinta (Statistics Finland's service interface), suggests that the data is likely to be statistical in nature and could be related to regional statistics, given the nature 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

Regions of Finland at 1:1 000 000 ScaleTSV
The table, belonging to a dataset collection, encapsulates a wealth of information regarding regions or provinces (Maakunnat), as detailed by the 'Tilastokeskus' website from Finland. It offers valuable insights into geospatial data, which can be utilized for geographic data analytics. This includes geographic coordinates presented using the WGS 84 coordinate reference system, where the axis order is longitude first, followed by latitude. The table provides detailed geographic data through columns that contain geographic shapes and centroids - central points of the shapes. It also includes the types of the shapes and their textual representations. This information can be particularly useful in mapping and spatial analytics, allowing analysts to visualize, for instance, the spread of a...
Version History of Regions (Scale 1:1 000 000)TSV
The 'table__history' is a comprehensive history table that forms part of the 'tilastointialueet_maakunta1000k' dataset collection. This history table specializes in storing the version history of its base data rows, making it a valuable resource for tracing changes over time. The table contains rich data about regions in Finland, as sourced from the 'Tilastokeskus' website. Each row represents a region at a particular point in time, with unique identifiers established by a combination of the '_start_date' and '_row_number' columns. These columns also help delineate the life cycle of each data row, with '_start_date' indicating when the row was extracted and '_end_date' denoting when a new version was extracted. If '_end_date' is null, it signifies that the current row is the latest...

Column Descriptions

Regions of Finland at 1:1 000 000 Scale

Column	Type	Comment
_extract_date	date	This column contains the date when the data on the row was extracted from the data source. It plays a crucial role in uniquely identifying each row in combination with the '_row_number' column.
_row_number	long	This column contains the row number from the data extracted on the specific extract date indicated by the '_extract_date' column. Together with '_extract_date', it uniquely identifies each row.
geom_geojson	string	This column contains the geographic data of the region in GeoJSON format, which is a format for encoding a variety of geographic data structures.
geom_geotext	string	This column stores the geographic data of the region in text format, which complements the 'geom_geojson' column.
geom_type	string	This column indicates the type of the geographic data, which could be either MultiPolygon or Polygon.
geom_centroid	string	This column provides the centroid of the geographic area, represented as a point in the format (longitude, latitude).
geom_center_x	double	This column contains the longitude of the center point of the geographic area.
geom_center_y	double	This column contains the latitude of the center point of the geographic area.
gml_id	string	This column contains a unique identifier for each row, which is a concatenation of the dataset name and the '_row_number' value.
maakunta	string	This column represents the regional code of the area.
name	string	This column contains the name of the region in English.
namn	string	This column presents the name of the region in Swedish.
nimi	string	This column provides the name of the region in Finnish.
vuosi	long	This column indicates the year for which the data is relevant.

Version History of Regions (Scale 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 forms a unique identifier combination with '_row_number' for each row in this version history 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 indicates that the row is the most recent version.
_row_number	long	This column contains the row number from the raw data extracted from the data source. It forms a unique identifier combination with '_start_date' for each row in this version history table.
geom_geojson	string	This column contains the geographical data of the region in GeoJSON format, which represents simple geographical features with their non-spatial attributes.
geom_geotext	string	This column contains the geographical data of the region as text, which represents simple geographical features with their non-spatial attributes.
geom_type	string	This column represents the type of the geographical feature, like whether it's a polygon or a multipolygon.
geom_centroid	string	This column contains the central point of the geographical feature, represented as a point.
geom_center_x	double	This column contains the x-coordinate of the center of the geographical feature.
geom_center_y	double	This column contains the y-coordinate of the center of the geographical feature.
gml_id	string	This column contains a unique identifier for each row in the base table, which is a string.
maakunta	string	This column contains a string that represents a region.
name	string	This column contains the name of the region in English.
namn	string	This column contains the name of the region in Swedish.
nimi	string	This column contains the name of the region in Finnish.
vuosi	long	This column contains the year the data was collected, represented as an integer.

Additional Info

Last Updated	November 11, 2024
Created	November 11, 2024