Historical Records of Regional Divisions in Finland (2017)
Click here for a data sample
The 'table__history' is a historical data storage that archives the changes in its base table over time. It is a part of a larger dataset collection, which can be utilized to study the regional statistical areas in Finland, based on the 2017 data at a scale of 1:1,000,000. The historical table records the version history of each row in the base table, allowing users to track changes over time. Each row is uniquely identifiable through a combination of the extraction date and the row number from the raw data. The extraction date indicates when the data was first recorded, while the end date denotes when a new version of the same row was extracted, if any. Rows without an end date represent the most recent versions. The table contains geographic information that can be used for geospatial data analytics. It provides geographic coordinates using the WGS 84 coordinate reference system, with longitude preceding latitude. This information includes the type of geometric representation, the geometric figures themselves, and the centroid of these shapes. It also provides the names of the regional statistical areas in three languages: Finnish, Swedish, and an unnamed language. In addition, there is a unique identification code for each area, along with the year of the data. This combination of historical and geographic data can be valuable for various data analytics purposes. For example, one could analyze changes in the geographic boundaries of these areas over time, or study the evolution of any attribute associated with these areas based on the year of the data. The table is sourced from 'Tilastokeskus' (Statistics Finland), a Finnish website that provides a wide range of statistical data.
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | This is the date when the row was extracted from the data source. It forms a unique identifier for each row in conjunction with '_row_number' |
|---|
| _end_date | date | This represents the date when a new version of the row was extracted from the data source. If it is null, it signifies that the row is the latest version. |
|---|
| _row_number | long | This stands for the number of the row in the raw data extracted from the data source. Together with '_start_date', it uniquely identifies each row. |
|---|
| geom_geojson | string | This contains the geographical representation of the region in GeoJSON format. |
|---|
| geom_geotext | string | This represents the geographical shape of the region in text format, specifically in 'MULTIPOLYGON' format. |
|---|
| geom_type | string | This column specifies the type of geometric data stored, which is 'ST_MULTIPOLYGON' in this case. |
|---|
| geom_centroid | string | This contains the center point of the geographical region, represented as a 'POINT' with coordinates. |
|---|
| geom_center_x | double | This represents the x-coordinate of the center point of the geographical region. |
|---|
| geom_center_y | double | This represents the y-coordinate of the center point of the geographical region. |
|---|
| gml_id | string | This is a unique identifier for each row, provided by the data source. |
|---|
| name | string | This column contains the name of the region in English. |
|---|
| namn | string | This column contains the name of the region in another language. |
|---|
| nimi | string | This column contains the name of the region in another language, possibly Finnish given the data source. |
|---|
| seutukunta | string | This is a string type column, though its exact content is unclear without further context. |
|---|
| vuosi | double | This is a numerical column representing the year, probably related to the data collected or the version of the dataset. |
|---|
