Historical Version Records for 'Regions 2021' Dataset Table

To download the data set, please sign up or log in

Click here for a data sample

The 'table__history' is a rich source of geographic and historical data. It's part of a larger dataset collection designed to provide detailed information about regions in Finland. This specific table serves a key role in providing the version history of its base table rows, preserving a chronological record of the data.

The dataset was originally sourced from the Finnish website, 'Tilastokeskus' (Statistics Finland), a reliable authority for data on the country's regions.

The contents of the table are diverse and comprehensive. It includes a unique identification for each row, achieved through a combination of the row number and the date the row was extracted. This ensures that each version of the row is distinct and traceable in the table's history.

A key aspect of the table is its geospatial data. Several columns provide geographic details about the regions, presented in the WGS 84 coordinate reference system. This includes the type of geospatial shape (such as polygons or multipolygons) that describe the region's physical boundaries. Further, the table includes the coordinates of the geographic center of each region.

The table also contains columns detailing the region's name in different languages, including Finnish, Swedish, and English. Each record also includes the year it pertains to, providing a temporal context.

The 'table__history' is a valuable tool for data analytics. For instance, it could be used to track regional changes over time, providing insights into how regional boundaries or names may have evolved. Additionally, the geospatial data could be leveraged to analyze regional characteristics, such as size or proximity to other regions. The multilingual data could also be used to support international research or applications, ensuring accurate region identification across different languages.

Field Descriptions

Name Data type Description
_start_datedateThe date when the row was extracted from the data source, which helps in tracking the version history.
_end_datedateThe date when a newer version of the row was extracted. If this is null, it indicates that the row is the most recent version.
_row_numberlongThe number of the row as it appears in the raw data from the data source. This, along with '_start_date', uniquely identifies each row in the version history.
geom_geojsonstringA JSON representation of the geographical shape of the region.
geom_geotextstringA textual representation of the geographical shape of the region.
geom_typestringThe type of geographical shape (e.g., multipolygon or polygon).
geom_centroidstringThe coordinates of the center point of the geographical shape.
geom_center_xdoubleThe X-coordinate of the center point of the geographical shape.
geom_center_ydoubleThe Y-coordinate of the center point of the geographical shape.
gml_idstringA unique identifier for the row.
maakuntastringA code representing the region.
namestringThe English name of the region.
namnstringThe name of the region in Swedish.
nimistringThe name of the region in Finnish.
vuosilongThe year when the data was recorded.

No sample for this dataset

Additional Information

Last updated November 11, 2024
Created November 11, 2024
License No License Provided
Geographic coverage
Geographic granularity
Temporal coverage from
Temporal coverage to
Temporal coverage to
Countryfi
Databasefi_tilastokeskus
Extract date2024-11-11
Id5d91e6d9-5e94-43ad-b7e5-f237f1fa57da
Package idbeb44749-4b6c-4d13-96d1-77631d2e31ac
Position1
Revision id4f8a42a7-3a06-4cd8-b7b4-63e8c9b5ea13
Stateactive
Tabletilastointialueet_maakunta1000k_2021__table__history