Welfare Areas 2024 (Scale 1:4,500,000) - Data Table

To download the data set, please sign up or log in

Click here for a data sample

The table, part of the dataset collection titled 'tilastointialueet_hyvinvointialue4500k_2024', is a rich source of geographic and wellbeing information projected for the year 2024. It presents a comprehensive view of wellbeing areas in Finland, sourced from the 'Tilastokeskus' (Statistics Finland) website. The table contains a variety of columns, each offering unique insights into the areas studied.

For instance, the columns starting with 'geom_' provide geographic data, useful for geospatial analytics. These columns offer information such as the type of geographic shape, the geojson and geotext data, and the center coordinates of the areas. It's important to note that the geographic coordinates are presented using the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude.

The table also includes columns like 'name', 'namn', and 'nimi' which provide the names of the wellbeing areas in different languages, while the 'hyvinvointialue' column provides a specific code for each area. The 'gml_id' column offers a unique ID for each entry.

Two special columns, '_extract_date' and '_row_number', serve to uniquely identify each row, with the former indicating the date when the data was extracted and the latter specifying the row number in the extracted data.

Given the depth and breadth of data in this table, it can be used in a variety of data analytics applications. For example, the geographic data could be used to create detailed maps showing the distribution of wellbeing areas across Finland. The data could also serve as a basis for trend analysis over time, given the extract dates included. Moreover, multilingual area names could be utilized for research involving cross-language comparisons and international collaboration.

Field Descriptions

Name Data type Description
_extract_datedateThis column contains the date when the data on the row was extracted from the data source. It plays a key role in uniquely identifying each row in conjunction with the '_row_number' column.
_row_numberlongThis column contains the row number in the data extracted from the source on the extract date specified by the column '_extract_date'. It is a crucial component in uniquely identifying each row.
geom_geojsonstringThis column holds geometric data in GeoJSON format, a widely-used format for encoding a variety of geographic data structures.
geom_geotextstringThis column contains geometrical data in text format.
geom_typestringThis column specifies the type of the geometric data stored in the table, such as 'ST_POLYGON' indicating that the geometric data forms a polygon.
geom_centroidstringThis column holds the centroid of the geometric figure. The centroid is a point representing the center of the geometric figure.
geom_center_xdoubleThis column contains the X-coordinate of the center point of the geometric figure.
geom_center_ydoubleThis column contains the Y-coordinate of the center point of the geometric figure.
gml_idstringThis is a string type column which presumably holds a unique identifier for each row.
hyvinvointialuestringThis column is of type string, however, the specific content is not clarified in the provided information.
namestringThis column contains names of entities or areas in English.
namnstringThis column contains names of entities or areas in another language, presumably Finnish or Swedish.
nimistringThis column contains names of entities or areas in another language, presumably Finnish.
vuosilongThis column is of type integer and it seemingly holds year-related information.

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
Countryfi
Databasefi_tilastokeskus
Extract date2024-11-11
Ide3dddb74-16a7-419e-b997-f7966b0ae519
Package id014b5b0a-1dea-4b66-9f1f-fd88b925e10b
Revision ide8100910-0876-411f-90c3-37a3b1493ede
Stateactive
Tabletilastointialueet_hyvinvointialue4500k_2024__table