Statistics Bureau's Service Interface (WFS) - Educational Institutions Data Collection

This dataset collection is a comprehensive assembly of related data tables concerning educational institutions. The data housed within these tables is sourced from the 'Tilastokeskus' website, otherwise known in English as the 'Statistics Finland'. The contents of this collection are derived from their service interface, which, in English, refers to a Web Feature Service (WFS). This service provides data in a standardized, interoperable format, enhancing the usability and accessibility of the data. As a result, the dataset collection provides a rich resource for understanding and analyzing the landscape of educational institutions within Finland. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

Institutions 2022: A Comprehensive Data Table from FinlandTSV
The table, belonging to the dataset collection 'oppilaitokset_oppilaitokset', contains a rich collection of data pertaining to 'Educational Institutions 2022', as sourced from the Finnish website, 'Tilastokeskus' (Statistics Finland). It is organized into a variety of columns, each holding specific information, and is part of a wider group of interrelated data tables. Two special columns, '_extract_date' and '_row_number', provide context for the data extraction process. The '_extract_date' column indicates when the data was pulled from the source, while the '_row_number' helps to uniquely identify each row based on the extraction date. The table also features a series of 'geom_' columns that contain geographic information, invaluable for geospatial data analytics. These columns provide...
Institutions 2022: Historical Versioning of Dataset RecordsTSV
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...

Column Descriptions

Institutions 2022: A Comprehensive Data Table from Finland

Column	Type	Comment
_extract_date	date	This column contains the date when the data on the row of the table was extracted from the data source.
_row_number	long	This column contains the row number in the data extracted from the source on the extract date specified by the column '_extract_date'.
euref_x	double	A real data type column representing a geographical coordinate.
euref_y	double	A real data type column representing a geographical coordinate.
geom_geojson	string	Contains GeoJSON data, which is a format for encoding geographic data structures.
geom_geotext	string	Contains text representation of geographical data.
geom_type	string	Specifies the type of the geometry - in this case, a point.
geom_centroid	string	Contains the geographical point that represents the center (centroid) of the geometry.
geom_center_x	double	Represents the X coordinate of the center of the geometry.
geom_center_y	double	Represents the Y coordinate of the center of the geometry.
gml_id	string	A string identifier for the row, possibly linked to the source data.
olo	string	A column of string type, detailed description is unavailable.
oltyp	string	A string column, detailed description is unavailable.
oltyp_nimi	string	A string column, detailed description is unavailable.
onimi	string	A string column, detailed description is unavailable.
til_vuosi	long	An integer column representing a year.
tunn	string	A string column, detailed description is unavailable.

Institutions 2022: Historical Versioning of Dataset Records

Column	Type	Comment
_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.

Additional Info

Last Updated	November 11, 2024
Created	November 11, 2024