Version History of Welfare Areas 2022 (1:1 000 000)
Click here for a data sample
The 'History' table is part of the 'Wellbeing Areas 2022 (1:1 000 000)' dataset and serves as a version history record of the base table rows. This table is primarily sourced from the 'Tilastokeskus' website based in Finland. The table is organized in such a way that each row is uniquely identified by the combination of 'start_date' and '_row_number'. The '_start_date' indicates the date when the row was extracted from the data source and '_end_date' signifies when a new version of the row was extracted. If the '_end_date' is null, it implies that the row is the most recent version. The table contains geographic information denoted by columns starting with 'geom', which can be used for geospatial data analytics. The geographic coordinates are presented using the WGS 84 coordinate reference system, with the order of longitude first, followed by latitude. The data in this table can be analyzed to understand trends in wellbeing areas over time. For instance, the geographic data can be used to create visualizations of these areas, or the version history can be used to track changes in these areas over time. Additionally, by leveraging the '_start_date' and '_end_date', analysts can identify and study the duration and frequency of changes in these areas.
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | This column represents the date when the row data was extracted from the data source. It forms a unique identifier for each row in conjunction with the _row_number column. |
|---|
| _end_date | date | This column represents the date when a new version of the row was extracted from the data source. If the value is null, it indicates that the row is the most current version. |
|---|
| _row_number | long | This column represents the number of the row as it appears in the raw data sourced from the data source. It forms a unique identifier for each row in conjunction with the _start_date column. |
|---|
| geom_geojson | string | This column contains the geographical data of the wellbeing area in GeoJSON format, which may represent polygons or multipolygons. |
|---|
| geom_geotext | string | This column contains the geographical data of the wellbeing area in textual format, which may represent polygons or multipolygons. |
|---|
| geom_type | string | This column indicates the type of the geographical data, which can be either a polygon or a multipolygon. |
|---|
| geom_centroid | string | This column represents the centroid point of the geographical area. |
|---|
| geom_center_x | double | This column represents the x-coordinate of the center of the geographical area. |
|---|
| geom_center_y | double | This column represents the y-coordinate of the center of the geographical area. |
|---|
| gml_id | string | This column contains a unique identifier for the row in the data source. |
|---|
| hyvinvointialue | string | This column represents a code associated with the wellbeing area. |
|---|
| name | string | This column contains the English name of the wellbeing area. |
|---|
| namn | string | This column contains the Swedish name of the wellbeing area. |
|---|
| nimi | string | This column contains the Finnish name of the wellbeing area. |
|---|
| vuosi | long | This column represents the year associated with the data row. |
|---|
