History Table of Wellbeing Regions 2023 (1:1 000 000) Version Records
The 'table__history' is a comprehensive repository that captures the version history of its base table rows. This table is a part of the larger dataset collection, illustrating the interconnected nature of the data. This history table is sourced from the 'Tilastokeskus' website, based in Finland.
The table provides a rich amount of data, ranging from temporal information to geospatial data. The temporal information, such as the start and end dates of a row's extraction, offers insights into the evolution of the data, allowing analysts to track changes over time. For instance, if the '_end_date' field is null, this signifies that the data is the most recent version extracted.
Geospatial data, denoted by the 'geom_' prefix, offers geographic information that can be utilized for geospatial data analytics. This data is presented using the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude. This could enable analysts to understand geographical trends or patterns.
Specifically, the table includes the 'Wellbeing Areas 2023' (Hyvinvointialueet 2023), providing valuable insights into different regions. For instance, data analysts could use this information to study regional disparities in wellbeing or identify areas which may require additional resources or interventions.
The unique row identifier, formed by the combination of '_start_date' and '_row_number', ensures each row in the table is distinct. This feature is crucial when managing data integrity and avoiding duplication.
In summary, this table offers a wealth of data that can be utilized in various ways, from tracking changes over time to studying geographical patterns and trends, and exploring regional disparities in wellbeing.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column contains the date when a particular row was extracted from the data source. It is part of a unique identifier for each row in the version history table, together with the '_row_number' column. |
| _end_date | date | This column contains the date when a new version of a particular row was extracted from the data source. If the value is null, it indicates that the row is the most recent version. |
| _row_number | long | This column contains the number of the row in the raw data extracted from the data source. It forms a unique identifier for each row in the version history table in combination with the '_start_date' column. |
| geom_geojson | string | This column contains the geographical data of a specific area in GeoJSON format. This data is associated with the welfare area represented by the row. |
| geom_geotext | string | This column contains the geographical data of a specific area in textual format. This data is associated with the welfare area represented by the row. |
| geom_type | string | This column specifies the type of the geographical data stored in the 'geom_geojson' and 'geom_geotext' columns. The data can be of type 'ST_MULTIPOLYGON' or 'ST_POLYGON'. |
| geom_centroid | string | This column contains the geographical coordinates of the centroid, or geometric center, of the area represented by the row. |
| geom_center_x | double | This column contains the x-coordinate of the centroid of the area represented by the row. |
| geom_center_y | double | This column contains the y-coordinate of the centroid of the area represented by the row. |
| gml_id | string | This column contains a unique identifier for each row, which is tied to the welfare area and the year represented by the row. |
| hyvinvointialue | string | This column contains a numeric identifier for the welfare area represented by the row. |
| name | string | This column contains the English name of the welfare area represented by the row. |
| namn | string | This column contains the Swedish name of the welfare area represented by the row. |
| nimi | string | This column contains the Finnish name of the welfare area represented by the row. |
| vuosi | long | This column contains the year to which the data in the row corresponds. |
No sample for this dataset
Additional Information
| Last updated | November 11, 2024 |
|---|---|
| Created | November 11, 2024 |
| License | No License Provided |
| Geographic coverage | |
| Geographic granularity | |
| Temporal coverage from | |
| Temporal coverage to | |
| Temporal coverage to | |
| Country | fi |
| Database | fi_tilastokeskus |
| Extract date | 2024-11-11 |
| Id | 45f0c12a-4956-4663-8a40-55088f9e15a7 |
| Package id | f849f8da-7828-4651-8fc0-3405dc0f47ab |
| Position | 1 |
| Revision id | aec3f74e-c4be-4097-b329-50f1c4bed880 |
| State | active |
| Table | tilastointialueet_hyvinvointialue1000k_2023__table__history |