History of Regional Units 2018 (1:1 000 000): Versioned Data
Click here for a data sample
The 'table__history' is a historical data store that contains version history of its base table rows, originating from the 'Tilastokeskus' website in Finland. The table's contents are based on the dataset titled 'Seutukunnat 2018 (1:1 000 000)', which translates to 'Regions 2018 (1:1 000 000)'. This indicates that the table contains detailed regional data from the year 2018. It consists of several columns, each storing specific types of information. For instance, some columns hold geographic data, useful for geospatial data analytics. These include coordinates presented using the WGS 84 coordinate reference system, with the longitude mentioned first, followed by latitude. Other columns store row identifiers and their version history, indicated by their starting and ending dates. If the ending date is null, it suggests that the row is the most recent version. Additionally, there are columns containing regional names in different languages, unique identifiers, and the year related to the data. This table could be instrumental in performing various data analytics tasks. For example, one could track changes in regional characteristics over time, analyze spatial patterns and trends, or even study the evolution of specific regions. Moreover, by utilizing the version history, it's possible to revert and compare past versions of the data, which could provide insights into how certain changes have impacted the regions over time.
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | Indicates the date when the row was extracted from the data source. |
|---|
| _end_date | date | Indicates the date when a new version of the row was extracted from the data source. If the value is null, it signifies that the row is the most recent version. |
|---|
| _row_number | long | Represents the number of the row in the raw data extracted from the data source. This column, combined with '_start_date', forms a unique identifier for each row in this version history table. |
|---|
| geom_geojson | string | Contains the GeoJSON format of the geographical data. |
|---|
| geom_geotext | string | Holds the textual representation of the geographical data. |
|---|
| geom_type | string | Specifies the type of the geographical data. |
|---|
| geom_centroid | string | Provides the centroid point of the geographical data. |
|---|
| geom_center_x | double | Indicates the X coordinate of the geographical data center. |
|---|
| geom_center_y | double | Indicates the Y coordinate of the geographical data center. |
|---|
| gml_id | string | Serves as a unique identifier for the geographical data. |
|---|
| name | string | Contains the name of the region in English. |
|---|
| namn | string | Contains the name of the region in Swedish. |
|---|
| nimi | string | Contains the name of the region in Finnish. |
|---|
| seutukunta | string | Holds the region code. |
|---|
| vuosi | long | Indicates the year of the data. |
|---|
