Version History of Sub-regions 2019 (1:1 000 000) - Historical Data
The 'table__history' is a history table that holds the version history of its base table rows, providing a comprehensive record of changes over time. This table belongs to the dataset collection 'tilastointialueet_seutukunta1000k_2019', sourced from the 'Tilastokeskus' website in Finland. It is primarily focused on the 'Seutukunnat 2019' data, which translates to 'Subregions 2019' in English.
The table comprises of numerous columns, each serving a unique role. The '_row_number' column, for example, identifies the row number in the raw data extracted from the data source. Coupled with the '_start_date' column, these two form a unique identifier for each row in the table. The '_start_date' and '_end_date' columns indicate the timeframe during which a specific row was considered valid. If the '_end_date' field is null, this indicates that the row is the most recent version.
The table also holds columns carrying geospatial information, denoted by the 'geom_' prefix in their names. These columns contain geographic coordinates, geotext, and other geographic details, all represented using the WGS 84 coordinate reference system (longitude first, followed by latitude). This data is crucial for geospatial data analytics.
There are also columns that contain the region's name in different languages and the region's ID ('seutukunta'). The 'vuosi' column indicates the year, which for this dataset is 2019.
In terms of data analytics, this table can be utilized in various ways. For instance, its geospatial data could be used to visualize regional changes over time on a map. Additionally, the version history could help in tracking and analyzing trends, such as changes in regional boundaries or names. Also, by utilizing the '_start_date' and '_end_date' pair, analysts can study the evolution of the data over time.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | The '_start_date' column indicates the date when the row was extracted from the data source, marking the beginning of the row's version history. The format of the date is 'YYYY-MM-DD'. |
| _end_date | date | The '_end_date' column represents the date when a new version of the row was extracted from the data source. If the value is null, it signifies that the row is the most recent version. |
| _row_number | long | The '_row_number' column contains the number of the row in the raw data, helping to uniquely identify each row in this version history table when combined with '_start_date'. |
| geom_geojson | string | The 'geom_geojson' column contains the geometric representation of the data in geojson format, which can include multiple polygons. |
| geom_geotext | string | The 'geom_geotext' column holds the geometric representation of the data in textual format, which can include multiple polygons. |
| geom_type | string | The 'geom_type' column specifies the type of geometric data contained in the row, for example, 'ST_MULTIPOLYGON'. |
| geom_centroid | string | The 'geom_centroid' column contains the centroid point of the geometric data, which represents the center point of the geometric shape. |
| geom_center_x | double | The 'geom_center_x' column indicates the 'x' coordinate of the center of the geometric data. |
| geom_center_y | double | The 'geom_center_y' column indicates the 'y' coordinate of the center of the geometric data. |
| gml_id | string | The 'gml_id' column contains a unique identifier for each row, which is a combination of the dataset name and the row number. |
| name | string | The 'name' column contains the name of the location or region in English. |
| namn | string | The 'namn' column contains the name of the location or region in Swedish. |
| nimi | string | The 'nimi' column contains the name of the location or region in Finnish. |
| seutukunta | string | The 'seutukunta' column contains a numerical code that represents a specific region or area. |
| vuosi | long | The 'vuosi' column indicates the year associated with the row's data. |
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 | 55450745-f922-4b54-9e3c-96088e50a8d5 |
| Package id | f376186a-978e-423d-ae0d-bbd2b68386f6 |
| Position | 1 |
| Revision id | 5283502f-7db6-4630-84e9-dd6208e57003 |
| State | active |
| Table | tilastointialueet_seutukunta1000k_2019__table__history |