Historical Version Details of Large Areas 2022 (1:1 000 000)

The 'table__history' is a historical accumulation of records, each representing a version of a row from its base table. It belongs to the dataset collection 'tilastointialueet_suuralue1000k_2022'. This history table is unique in the sense that it contains two additional columns to keep track of the version history of each row in the base table, namely the '_start_date' and '_end_date'. The '_start_date' indicates when the row was initially extracted from the data source, while the '_end_date' shows 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.

The table presents a detailed geographical dataset, specifically the 'Major Areas 2022 (1:1 000 000)' originating from the Finnish Statistics Bureau (Tilastokeskus). The table includes geographic information columns, namely 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y'. These columns contain geospatial data that can be used for geographical data analytics, such as spatial pattern detection, geospatial visualization, and regional planning. This geographic information is presented using the WGS 84 coordinate reference system, with longitude first, followed by latitude.

The table also contains columns that provide the names of the major areas in three different languages, 'name' in English, 'namn' in Swedish, and 'nimi' in Finnish, as well as the year ('vuosi') and a unique identifier for each row ('_row_number'). The '_row_number' column, in combination with the '_start_date' column, uniquely identifies each row in this history table. This table could be utilized in data analytics to understand the changes in these major areas over time, for example, in population studies, urban planning, or environmental studies.