Wellbeing Areas 2022 (1:1 000 000) - Data Table
The table under consideration is derived from the 'Tilastokeskus' website, based in Finland. It is a part of a larger dataset collection that revolves around the theme of 'Wellbeing Areas 2022' at a scale of 1:1,000,000. The table comprises various columns, each containing specific information related to the theme.
Two special columns are '_extract_date' and '_row_number', which store the date when the data was extracted and the row number in the extracted data respectively. These two columns in combination provide a unique identity to each row.
The table also provides a wealth of geospatial data, with several columns starting with 'geom_' that contain geographic information. These columns can be utilized for geospatial data analytics, with geographic coordinates being presented using the WGS 84 coordinate reference system.
Other columns include 'name', 'namn', 'nimi', and 'vuosi', which contain information about the wellbeing areas in different languages and the year of data, respectively. 'Gml_id' and 'hyvinvointialue' contain unique identifiers for each wellbeing area.
The data from this table can be utilized in various ways for data analytics. For instance, the geospatial data can be used to map the wellbeing areas, allowing for a visual representation of the data. The '_extract_date' and '_row_number' columns can be used to track changes in the data over time. The information in the 'name', 'namn', and 'nimi' columns could be employed to perform multilingual analyses or to compare wellbeing status across different regions. The 'vuosi' column would allow analysts to focus on data from a specific year, providing a temporal dimension to their analyses.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _extract_date | date | This column contains the date when the data on the row of the table was extracted from the data source. It allows tracking of the extraction history of each row. |
| _row_number | long | This column contains the sequential row number in the data extracted from the source on the extract date specified by the column '_extract_date'. Together with '_extract_date', it uniquely identifies each row. |
| geom_geojson | string | This column contains geometric data in GeoJSON format, which is a format for encoding geographical data structures. It can include data such as polygons or multipolygons representing specific areas. |
| geom_geotext | string | This column contains geometric data in text format, which provides a human-readable representation of the geographical data structures. It can include data such as polygons or multipolygons representing specific areas. |
| geom_type | string | This column indicates the type of geometric data represented in the 'geom_geojson' and 'geom_geotext' columns. It typically includes values such as 'ST_POLYGON' or 'ST_MULTIPOLYGON'. |
| geom_centroid | string | This column contains the centroid point of the geometric shape in 'POINT' format. The centroid is the geometric center of a shape. |
| geom_center_x | double | This column contains the x-coordinate of the centroid of the geometric shape. It represents the longitude of the center point. |
| geom_center_y | double | This column contains the y-coordinate of the centroid of the geometric shape. It represents the latitude of the center point. |
| gml_id | string | This is a unique identifier for each row. It is typically composed of the name of the well-being area and the year. |
| hyvinvointialue | string | This column contains the identifier for the well-being area. The identifier is a unique number assigned to each well-being area. |
| name | string | This column contains the English name of the well-being area. |
| namn | string | This column contains the Swedish name of the well-being area. |
| nimi | string | This column contains the Finnish name of the well-being area. |
| vuosi | long | This column contains the year to which the data pertains. |
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 | 7e10a75d-c1b7-4cd2-a628-d5856648baae |
| Package id | c0305471-316c-45d5-b49d-d612977daa96 |
| Revision id | bd420f01-c6ab-4398-848c-3fcbaddf8fb7 |
| State | active |
| Table | tilastointialueet_hyvinvointialue1000k_2022__table |