Version History of Maakunnat 2013 (1:4 500 000) - Regional Data
The history table, part of a larger dataset, captures the version history of its base table rows, which are primarily focused on the geographic and demographic information of regions in Finland. Derived from the Finnish Statistical Bureau's (Tilastokeskus) dataset, this table provides a time-stamped record of each row's extraction from the source data, forming a progression of data versions over time. A unique identifier is created for each row in this version history table, combining the date of extraction and the row number. The table also indicates when a new version of a row was extracted, with a null value signifying the most recent version.
Geospatial data forms a significant part of the table content, with multiple columns dedicated to storing geographic information. These include details on geographical coordinates and regions, which are presented using the WGS 84 coordinate reference system. The table also includes demographic information such as region names in multiple languages and related identifiers.
The data in this table could be utilized in various ways for data analytics. For instance, the version history could be used to track changes in demographic data over time, allowing for trend analysis and forecasting. Furthermore, the geospatial information could be leveraged in GIS systems for mapping and geographic trend analysis. It could also be used to cross-reference with other datasets for a more comprehensive statistical analysis.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column signifies the date when the row was extracted from the data source. It works in combination with the '_row_number' column to uniquely identify each row in the history table. |
| _end_date | date | This column contains the date when a new version of the row was extracted from the data source. If its value is null, it indicates that the row is the most recent version. |
| _row_number | long | This column represents the number of the row in the raw data extracted from the data source. It is used in combination with the '_start_date' column to uniquely identify each row in the history table. |
| geom_geojson | string | This column contains the geometric data in GeoJSON format. |
| geom_geotext | string | This column stores the geometric data in text format. |
| geom_type | string | This column denotes the type of the geometric data. |
| geom_centroid | string | This column signifies the centroid of the geometric shape. |
| geom_center_x | double | This column indicates the x-coordinate of the center of the geometric shape. |
| geom_center_y | double | This column indicates the y-coordinate of the center of the geometric shape. |
| gml_id | string | This column represents the unique identifier of the row. |
| maakunta | string | This column contains a string data type that signifies the province. |
| name | string | This column stores the name of the province in English. |
| namn | string | This column contains the name of the province in Swedish. |
| nimi | string | This column contains the name of the province in Finnish. |
| vuosi | long | This column, an integer data type, represents the year. |
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 | f99df2c5-0244-4122-a783-84b67b72f8e4 |
| Package id | 85c02e6a-7af1-45ac-bf8c-72a438671e54 |
| Position | 1 |
| Revision id | f347543c-12fd-4a4f-b1f2-5de0cd5fbcd2 |
| State | active |
| Table | tilastointialueet_maakunta4500k_2013__table__history |