History and Version Records of ELY Areas 2024 (1:1 000 000) Table
Click here for a data sample
The 'table__history' is a part of the 'tilastointialueet_ely1000k_2024' dataset collection. This history table encapsulates the version history of the base table rows offering a snapshot of changes over time. The data focuses on regions defined as ELY-alueet, translated as ELY areas, for the year 2024. The table is sourced from 'Tilastokeskus' (Statistics Finland) and contains a variety of data types, including geographic and temporal data. The table features a unique identifier combination of 'start_date' and '_row_number', representing the date of extraction from the source and the row number in the raw data, respectively. The '_end_date' column indicates when a new version of a row was extracted, with a null value signifying the most recent row version. Data analytics can utilize the geographic information stored in 'geom' prefixed columns for geospatial analysis. This data is presented using the WGS 84 coordinate reference system, with the order being longitude first and then latitude. The table also includes information about the ELY areas' names in different languages and their designated codes. Potential applications of the data in this table could include tracking changes in geographic boundaries over time, studying the evolution of regional classifications, or analyzing trends in the data's temporal aspects.
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | The date when the row data was initially extracted from the source, providing a timestamp for the version of the data in the row. |
|---|
| _end_date | date | The date when a new version of the row data was extracted. If this column is null, it implies that the data in the row represents the most recent version. |
|---|
| _row_number | long | The row number in the raw data from the source. Together with '_start_date', these two columns form a unique identifier for each row in this version history table. |
|---|
| ely | string | The code representing a specific ELY Centre, a regional body responsible for various administrative tasks in Finland. |
|---|
| geom_geojson | string | The geographic shapes representing the ELY Centre's area of responsibility, formatted as GeoJSON, a standard data format for encoding geographic data structures. |
|---|
| geom_geotext | string | The geographic shapes representing the ELY Centre's area of responsibility, formatted as geotext. |
|---|
| geom_type | string | The type of geometric shape used to represent the ELY Centre's area of responsibility. This could be a polygon or a multipolygon. |
|---|
| geom_centroid | string | The centroid or geometric center of the shape representing the ELY Centre's area of responsibility. |
|---|
| geom_center_x | double | The X coordinate of the geometric center of the shape representing the ELY Centre's area of responsibility. |
|---|
| geom_center_y | double | The Y coordinate of the geometric center of the shape representing the ELY Centre's area of responsibility. |
|---|
| gml_id | string | The unique identifier for the row in GML (Geography Markup Language) format. |
|---|
| id | long | The unique identifier for each ELY Centre. |
|---|
| name | string | The English name of the ELY Centre. |
|---|
| namn | string | The Swedish name of the ELY Centre. |
|---|
| nimi | string | The Finnish name of the ELY Centre. |
|---|
| vuosi | long | The year the data was recorded or relevant for, indicating the temporal aspect of the data. |
|---|
