Institutions 2022: Historical Versioning of Dataset Records
The 'table__history' is a history table that contains the version history of its base table rows. It has been sourced from the 'Tilastokeskus' (Statistics Finland) website. The data contained within the table is related to 'Oppilaitokset 2022', translated to English as 'Educational Institutions 2022'.
This table is enriched with columns that provide valuable data for analysis. For instance, the table contains unique row identifiers formed by a combination of the '_start_date' and '_row_number' columns. The column '_start_date' signifies when a particular row was extracted from the data source, whereas '_end_date' indicates when a new version of the row was extracted. If the '_end_date' is null, it implies that the row is the most recent version.
Significant data related to geographical coordinates, prefixed with 'geom_', is present in the table. This data can be utilized for geospatial data analytics, with coordinates presented using the WGS 84 coordinate reference system, where longitude is followed by latitude.
In the realm of data analytics, the information in the table could be utilized in several ways. For example, the unique row identifiers could be used to track changes in educational institutions over time, providing insights into trends or significant shifts. The geographical data could be utilized to perform spatial analysis, such as identifying patterns or anomalies in the distribution of educational institutions across Finland.
Furthermore, the table could provide valuable input for predictive models, aiding in forecasting future trends relating to educational institutions based on historical data. For instance, predictive models could utilize the data to forecast the future establishments of educational institutions in specific geographical coordinates.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column contains the date when the row was extracted from the data source, serving as a starting point for the version history of a particular row. |
| _end_date | date | This column contains the date when a new version of the row was extracted from the data source, marking the end of the period for the current version. If the value is null, it indicates that the row is the most recent version. |
| _row_number | long | This column contains the number of the row in the raw data extracted from the data source. Together with '_start_date', it uniquely identifies each row in this version history table. |
| euref_x | double | This column stores the X coordinate value in the EUREF coordinate system. |
| euref_y | double | This column stores the Y coordinate value in the EUREF coordinate system. |
| geom_geojson | string | This column contains the geometric data of the location in the GeoJSON format. |
| geom_geotext | string | This column stores the geometric data in a text-based format. |
| geom_type | string | This column indicates the type of the geometric data. |
| geom_centroid | string | This column contains the centroid of the geometric data. |
| geom_center_x | double | This column stores the X coordinate of the geometric center. |
| geom_center_y | double | This column stores the Y coordinate of the geometric center. |
| gml_id | string | This column contains the unique identifier of the row. |
| olo | string | This column contains specific data related to the entity, the meaning and use of which may vary depending on the context of the dataset. |
| oltyp | string | This column contains the identifier for the type of educational institution. |
| oltyp_nimi | string | This column provides the name corresponding to the type of educational institution. |
| onimi | string | This column contains the name of the educational institution. |
| til_vuosi | long | This column represents the year of the data. |
| tunn | string | This column contains a unique identifier or a code for the educational institution. |
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 | 918da940-f26f-486d-a6da-f97f9589010d |
| Package id | b6ab36f5-17a0-41c7-9b8e-cda596f11a23 |
| Position | 1 |
| Revision id | 8d47313e-63ca-4b49-b1a7-bb6e62a740a3 |
| State | active |
| Table | oppilaitokset_oppilaitokset__table__history |