Version History of Regions 2018 (1:4 500 000) Data

The 'table__history' is a historical record of the 'Regions 2018' dataset (originally 'Maakunnat 2018') sourced from 'Tilastokeskus' (Statistics Finland), a website from Finland. This historical table contains the version history of base table rows which provides a timeline of changes to the data over time. Each row in the table corresponds to a unique version of a row from the base table, with two additional columns '_start_date' and '_end_date' to denote the lifespan of each version. The '_start_date' signifies when the version was first extracted from the data source, and '_end_date' indicates when a newer version was extracted. If '_end_date' is null, it implies that the version is the most recent. The '_row_number' column provides the position of the row in the extracted raw data, and together with '_start_date', it uniquely identifies each row in the history table.

The table provides a variety of information about the regions in Finland in 2018, such as their names in different languages (Finnish, Swedish, and English), and numeric identifiers assigned to each region. There are also several columns containing geographical data, which can be used in geospatial data analytics. This includes information about the geometry of each region, the centroid of the region, and the geographic center in the form of x (longitude) and y (latitude) coordinates. These geographic coordinates are presented using the WGS 84 coordinate reference system.

The data in this table could be utilized in various ways. For example, it could be used to analyze regional changes over time in Finland, observing how the regions' data evolve. The geographic information could be used to map the regions and understand spatial relationships and patterns. Moreover, the version history could be used to track the integrity of the data and understand the data extraction and updating process.