Historical Version Records of Regions 2021 (1:4 500 000)
The 'table__history' is a history table that tracks the version history of its base table rows, focusing on regions in Finland. The contents of the table are sourced from 'Tilastokeskus' (Statistics Finland), and includes data such as 'Regions 2021 (1:4 500 000)'. The table is part of a larger dataset collection titled 'tilastointialueet_maakunta4500k_2021'.
The table is comprised of various columns that contain precise information about each data entry. For instance, each row in the table is uniquely identified by a combination of its start date, represented by '_start_date' column, and the row number, represented by '_row_number' column. The '_start_date' column indicates when the row was first extracted from the data source, while '_end_date' signifies when a new version of the row was extracted. If '_end_date' is null, that indicates that the row is the most recent version.
Columns beginning with 'geom_' contain geographic information, which is useful for geospatial data analytics. This includes data such as 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', 'geom_center_y'. These details provide comprehensive geographic information, including the type of geographic shape (polygon, multipolygon), geographic coordinates (in WGS 84 coordinate reference system, with axis order longitude first, followed by latitude), and the geographic center of the region.
Additional columns provide more specific data about the regions, like 'name', 'namn', 'nimi', which include the names of the regions in different languages. The 'vuosi' column indicates the year the data is related to.
This table could be used in a variety of data analytics applications. For example, it could be utilized to analyze the historical changes in the geographic boundaries of regions within Finland. The geospatial data could be used to create detailed maps of the regions over time. It could also be used for multilingual studies, comparing the names of regions in different languages.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | The date when the row was extracted from the data source, for instance '2024-11-11'. |
| _end_date | date | The date when a new version of the row was extracted from the data source. If the value is null, it means that the row is the most recent version of the row. |
| _row_number | long | The number of the row in the raw data extracted from the data source. This number, together with the '_start_date', uniquely identifies each row in the history table. |
| geom_geojson | string | Contains geographical information in GeoJSON format, which can represent simple geographical features, along with their nonspatial attributes. |
| geom_geotext | string | Contains geographical coordinates in a text format, which can represent different geographical features. |
| geom_type | string | The type of geographic data stored in the 'geom_geojson' and 'geom_geotext' columns, such as 'ST_POLYGON' or 'ST_MULTIPOLYGON'. |
| geom_centroid | string | The calculated center point (centroid) of the geographical polygon or multipolygon. |
| geom_center_x | double | The X coordinate of the calculated center point of the geographical polygon or multipolygon. |
| geom_center_y | double | The Y coordinate of the calculated center point of the geographical polygon or multipolygon. |
| gml_id | string | A unique identifier for each row in the table, such as 'maakunta4500k_2021.15'. |
| maakunta | string | A code representing a region in Finland, for example '16', '01', '18', or '07'. |
| name | string | The English name of the region represented by the 'maakunta' code, such as 'Central Ostrobothnia', 'Uusimaa', 'Kainuu', or 'Päijät-Häme'. |
| namn | string | The Swedish name of the region represented by the 'maakunta' code, such as 'Mellersta Österbotten', 'Nyland', 'Kajanaland', or 'Päijänne-Tavastland'. |
| nimi | string | The Finnish name of the region represented by the 'maakunta' code, such as 'Keski-Pohjanmaa', 'Uusimaa', 'Kainuu', or 'Päijät-Häme'. |
| vuosi | long | The year when the data was collected, for example '2021'. |
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 | aa00885e-d202-402a-bd4d-5c7797408fb7 |
| Package id | a3009d2e-0bd6-4e46-b3e2-1c87085fb48a |
| Position | 1 |
| Revision id | a4f3a7d5-377f-4e40-b9fe-7d04059b8dee |
| State | active |
| Table | tilastointialueet_maakunta4500k_2021__table__history |