Version History of Large Areas (1:1 000 000)

The 'table__history' is a comprehensive historical data table that belongs to the 'tilastointialueet_suuralue1000k' dataset collection. This table serves as a historical archive of the base table rows, preserving the version history of each row. The table presents a rich set of data features including geographic information and other attribute data. The major regions (1:1 000 000) of Finland, as provided by the Finnish national statistical institute 'Tilastokeskus', are the primary focus of the table.

The table contains a unique combination of '_start_date' and '_row_number' for each row, marking the extraction date of the row from the data source and the row's position in the raw data respectively. This combination enables each row in the table to be distinctly identified. Additionally, the table records the date a new version of a row was extracted in the '_end_date' column. A null value in this column signifies that the row is the most recent version.

The geographic information is captured in a series of 'geom_' prefixed columns. These columns contain data that can be used for geospatial analytics. The geographic coordinates are presented in the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude. The table also contains columns for region names in different languages and a unique identifier for each region.

This table can be a valuable resource for a variety of data analytics applications. For instance, it can be used to track regional changes over time, providing insights for urban planning or infrastructure development. The geospatial data can be utilized to create detailed maps or to analyze spatial patterns and trends. Researchers studying regional dynamics may also find this table useful in their work. The multi-language support for region names can facilitate international studies and collaborations, making this table a versatile tool for data-driven decision making.