Historical Version Records of Regional Units 2020 (1:1 000 000)
Click here for a data sample
The history table is a detailed record of data changes over time, belonging to the dataset collection. This table, specifically, provides an historical overview of the 'Seutukunnat 2020 (1:1 000 000)' or 'Regional units 2020 (1:1 000 000)' base table data, sourced from the Finnish Statistics Bureau (Tilastokeskus). The history table consists of rows that represent different versions of the base table. Each row is uniquely identified by a combination of a start date, indicating when the data was extracted, and a row number, which is the row's position in the raw data extracted from the source. An end date is also included, marking when a newer version of the row was extracted. If the end date is null, it indicates that the row is the most recent version. Geographic details are provided in several columns like geojson, geotext, type, centroid, center_x, and center_y, all using the WGS 84 coordinate reference system, with the order being longitude first, followed by latitude. The table includes the names of the regional units in different languages and their unique identifiers. The table's data can be utilized in various ways in data analytics, such as trend analysis of regional changes over time, geospatial analysis of the regions using the provided coordinates, or multilingual studies using the names of the regional units in different languages.
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | This column contains the date when a specific row was extracted from the data source. It forms a unique combination with '_row_number' to identify each row in the version history table. |
|---|
| _end_date | date | This column holds the date when a newer version of a row was extracted. If it is null, it signifies that the row is the most recent version. |
|---|
| _row_number | long | This column contains the number of the row as it appears in the raw data extracted from the data source. It forms a unique combination with '_start_date' to identify each row in the version history table. |
|---|
| geom_geojson | string | This column stores the geometric representation of the area in GeoJSON format. |
|---|
| geom_geotext | string | This column contains the geometric representation of the area in text format. |
|---|
| geom_type | string | This column indicates the type of the geometric representation, which in this case is a polygon. |
|---|
| geom_centroid | string | This column holds the geometric center (centroid) of the area. |
|---|
| geom_center_x | double | This column contains the x-coordinate of the geometric center of the area. |
|---|
| geom_center_y | double | This column contains the y-coordinate of the geometric center of the area. |
|---|
| gml_id | string | This column represents a unique identifier for each row. |
|---|
| name | string | This column holds the English name of the area. |
|---|
| namn | string | This column contains the name of the area in another language. |
|---|
| nimi | string | This column provides the name of the area in another language. |
|---|
| seutukunta | string | This column contains a code representing the area. |
|---|
| vuosi | long | This column holds the year associated with the data row. |
|---|
