Historical Record of Well-being Regions 2024 at 1:1,000,000 Scale

The 'table__history' is a version history table that tracks the changes over time in the 'Wellbeing Areas 2024 (1:1 000 000)' dataset. This dataset, sourced from the Finnish Central Statistical Office (Tilastokeskus), contains information about designated wellbeing areas in Finland for the year 2024. Each row in the table represents a version of a row from the base table, with the versioning information captured in two additional columns: '_start_date' and '_end_date'. These columns indicate the date when the data row was extracted from the source and when a new version was extracted respectively. If '_end_date' is null, it signifies that the version of the row is the most current one. The row number in the raw data extracted from the source is recorded in the '_row_number' column, and in combination with '_start_date', it uniquely identifies each row in this table.

The table includes several columns that contain geographical information, with coordinates presented in the WGS 84 coordinate reference system. This includes geographical shapes (either polygons or multipolygons), their textual representations, and the type of the geographical shape. Additionally, the table provides the centroid point and x and y coordinates of the center of the geographical shapes.

Other columns in the table provide identifiers and names of the wellbeing areas in multiple languages (Finnish, Swedish, and English), and the year under consideration.

Given its rich information content, the data in this table can be effectively utilized in various data analytics applications. For example, it can help in analyzing the changes in wellbeing areas over time, or in carrying out geospatial analytics to understand the geographical distribution and characteristics of these areas. The multilingual nature of the data can facilitate research in both domestic and international contexts.