Version History of Regional Units 2019 (1:4 500 000) Table
Click here for a data sample
The 'table__history' is a rich source of historical data, offering insights into the evolution of various regions in Finland. It is part of the 'tilastointialueet_seutukunta4500k_2019' dataset collection, which collates relevant data tables. The history table maintains a version history for each row in its base table, allowing users to track data changes over time. This is particularly useful in trend analysis and predictive modeling. The table comprises several columns, each contributing unique information. For instance, some columns carry geographic information, which can be leveraged in geospatial data analytics. These columns present geographic coordinates using the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude. Two additional columns capture the start and end dates of each data row's extraction from the source, facilitating the identification of each row's most recent version. If the end date is null, it signifies that the row is the most recent version. This information is especially beneficial in data verification and change analysis. Other columns contain details like the name of the region in different languages, the year of data, and unique identifiers. The data from this table can be utilized in various ways. For instance, it can be used to study regional changes over time, perform geospatial analysis to identify patterns and trends, and substantiate research with historical data. The table is sourced from 'Tilastokeskus' ('Statistics Finland'), a reliable source in Finland.
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | This column contains the date when the row was extracted from the data source. It forms a unique identifier in combination with the '_row_number' column. |
|---|
| _end_date | date | This column contains the date when a new version of the row was extracted from the data source. If the value is null, it indicates that the row is the most recent version. |
|---|
| _row_number | long | This column contains the number of the row in the raw data extracted 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 geometric data in GeoJSON format. This data represents the geographical structures related to the data. |
|---|
| geom_geotext | string | This column contains the geometric data in text format, representing the geographical structures related to the data. |
|---|
| geom_type | string | This column specifies the type of the geographical structure represented by the geometric data. |
|---|
| geom_centroid | string | This column contains the centroid of the geographical structure represented by the geometric data. |
|---|
| geom_center_x | double | This column contains the X-coordinate of the center point of the geographical structure. |
|---|
| geom_center_y | double | This column contains the Y-coordinate of the center point of the geographical structure. |
|---|
| gml_id | string | This column contains the unique identifier of the row in the base table. |
|---|
| name | string | This column contains the name in English of the geographical entity represented by the row. |
|---|
| namn | string | This column contains the name in Swedish of the geographical entity represented by the row. |
|---|
| nimi | string | This column contains the name in Finnish of the geographical entity represented by the row. |
|---|
| seutukunta | string | This column contains a unique code representing the geographical entity. |
|---|
| vuosi | long | This column contains the year when the data was collected. |
|---|
