Historical Version Records of Large Areas 2023 (1:1 000 000)

The 'table__history' is a vital component of the larger data group 'tilastointialueet_suuralue1000k_2023'. This table is a history table and serves as a detailed archive for the version history of its base table rows. The base table represents the 'Suuralueet 2023' or 'Major Areas 2023' at a scale of 1:1 000 000.

This table is characterized by several columns, each holding specific information. The '_row_number' column indicates the sequence of the row in the raw data extracted from the data source. Along with '_start_date', it uniquely identifies every row in this table. '_start_date' and '_end_date' are particular columns which specify when the row was extracted and when a new version of the row was obtained, respectively. If the '_end_date' is null, it indicates that the row is the latest version.

Geospatial data analysts might find the columns beginning with 'geom_' particularly useful as they contain geographic information. These data points, written in the WGS 84 coordinate reference system (longitude first, then latitude), can be utilized for geospatial data analytics. For instance, 'geom_geojson' and 'geom_geotext' contain geographical shapes, 'geom_type' specifies the type of the shape, 'geom_centroid' provides the geographical center of the shape, and 'geom_center_x' and 'geom_center_y' provide the coordinates of the geographical center.

Other columns include 'gml_id' which is a unique identifier, 'name', 'namn', and 'nimi' which offer the name of the area in English, Swedish, and Finnish respectively. 'Suuralue' indicates the major area code and 'vuosi' specifies the year.

This data, sourced from the Finnish website 'Tilastokeskus' (Statistics Finland), can be used in various analytical contexts. For example, it could be used to track changes in geographical boundaries over time, or to analyze trends in the naming of areas across different languages. Additionally, the data could be crucial in planning for regional development or environmental conservation efforts, offering valuable historical context.