Historical Version Records of Finnish Regions (2016)
The 'table__history' is a version history table, maintaining the historical records of its base table. It is part of a larger dataset collection focused on statistical regions in Finland, as sourced from the 'Tilastokeskus' (Statistics Finland) website.
The table contains data about regions in Finland, as indicated by the base table description 'Regions 2016 (1:1 000 000)'. It includes information about each region's name in different languages, the year of the data, and unique identifiers.
One of the unique aspects of this table are the geographic details presented through several columns. These details, represented in WGS 84 coordinate reference system with the order of longitude first, followed by latitude, provide a rich resource for geospatial data analytics. For instance, the data could be used to visualize the geographical distribution of regions or to perform spatial analysis.
The table also utilizes a unique system to track its version history through special columns. The '_start_date' and '_row_number' columns form a combination that uniquely identifies each row, with '_start_date' indicating when the row was extracted from the source data, and '_row_number' noting the row's position in the raw data. The '_end_date' column provides information on when a new version of the row was extracted, with a null value indicating that the row is the most recent version. This system allows for a robust tracking of data changes over time.
The data in this table could be utilized in multiple ways in data analytics. For instance, changes in geographical boundaries of regions over time could be analyzed to understand regional development. The multilingual region names could be used to support multilingual data analysis or applications. Furthermore, the version history system enables detailed analysis of data changes over time, which could be crucial in long-term studies or trend analysis.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column contains the date when the row was extracted from the data source. This is a part of a unique identifier for each row in the version history table, together with '_row_number'. |
| _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 extracted from the data source. Together with '_start_date', it forms a unique identifier for each row in this version history table. |
| geom_geojson | string | This column contains the geometry of the statistical area in GeoJSON format. |
| geom_geotext | string | This column contains the geometry of the statistical area as a text string. |
| geom_type | string | This column specifies the type of the geometry of the statistical area. |
| geom_centroid | string | This column contains the point that represents the centroid of the statistical area. |
| geom_center_x | double | The x-coordinate of the centroid of the statistical area. |
| geom_center_y | double | The y-coordinate of the centroid of the statistical area. |
| gml_id | string | The unique identifier of the region in the statistical area dataset. |
| maakunta | string | The code of the region in the statistical area dataset. |
| name | string | The English name of the region in the statistical area dataset. |
| namn | string | The Swedish name of the region in the statistical area dataset. |
| nimi | string | The Finnish name of the region in the statistical area dataset. |
| vuosi | double | The year when the data of the statistical area was collected or updated. |
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 | |
| Country | fi |
| Database | fi_tilastokeskus |
| Extract date | 2024-11-11 |
| Id | 50292185-dd9f-4c82-9968-2f11cf70499d |
| Package id | 909078bf-dc64-4bcd-ab87-8e250f88d478 |
| Position | 1 |
| Revision id | 869de569-a189-4975-a773-a93625cb3abf |
| State | active |
| Table | tilastointialueet_maakunta1000k_2016__table__history |