Version History of Large Areas 2022 (1:4 500 000) Dataset

The 'History' table is a rich source of geospatial data, forming part of the 'Large Area Statistics' dataset. It provides a comprehensive record of changes over time, housing the version history of its base table rows. This table proves particularly invaluable for analysts keen on tracking temporal trends and conducting historical comparisons.

The table's data content centers around large areas for the year 2022 at a scale of 1:4,500,000. Each row in the table represents a version of the base table row, with unique identifiers established through a combination of the row number and the start date.

Among the notable features of this table are the start and end dates, indicating when data was extracted and when a new version was extracted, respectively. A null value in the end date field signifies that the row is the most recent version.

The table also houses a wealth of geographic information, encapsulated in columns prefixed with 'geom_'. These columns store geospatial data, including the geojson and geotext formats, the type of geometric shape, as well as the centroid, and the x and y coordinates of the center of the geometric shape. These geographic coordinates are presented using the WGS 84 coordinate reference system, with an axis order of longitude first, followed by latitude.

This geospatial data can be instrumental in various analytical tasks. For instance, analysts could leverage the geographic coordinates to conduct geospatial data analytics, such as plotting regional trends or examining the spatial distribution of data points.

The table also includes columns for the name of the area in multiple languages, providing a broader scope for multinational analysis.

The 'History' table is sourced from the website of 'Tilastokeskus' (Statistics Finland) in Finland, ensuring reliable and authoritative data content.