Statistics Service Interface Data Tables (2013)

This dataset collection comprises a set of related data tables sourced from the 'Tilastokeskus' (Statistics Finland) website, based in Finland. These tables are organized in a column-and-row format, each containing relevant and interconnected data. The content of this collection is derived from the Statistics Finland's service interface, providing a wealth of information that is integral to statistical analysis. The collection can encompass one or several tables, depending on the breadth and depth of the data being covered. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

ELY Areas 2013 (Scale 1:1 000 000) Dataset TableTSV
The table, sourced from the 'Tilastokeskus' (Statistics Finland) website in Finland, primarily contains data related to ELY areas in 2013 at a scale of 1:1,000,000. Each row in the table represents a unique ELY area, identified by its unique code ('ely'), name ('name'), Finnish name ('nimi'), and Swedish name ('namn'), along with a unique identifier in the form of 'gml_id'. The data in each row is extracted on a specific date, captured by the '_extract_date' column, and assigned a unique '_row_number' for identification purposes. The table also holds geospatial data related to these ELY areas. This includes 'geom_geojson' and 'geom_geotext' which contain the geographical coordinates of the ELY areas in JSON and text format respectively. The 'geom_type' indicates the type of...
Version History of ELY Areas 2013 (1:1 000 000) - TableTSV
The 'table__history' is a meticulously organized collection of data, which forms a part of the 'tilastointialueet_ely1000k_2013' dataset. This table specifically serves as a history table, recording the version history of its base table rows. It is sourced from the 'Tilastokeskus' (Statistics Finland) website from Finland. The data content of this table is comprehensive and diverse. It captures the ELY-areas in 2013 at a ratio of 1:1,000,000. The table features multiple columns, each holding unique information. For instance, one column records the row number in the raw data extracted from the source, while others capture the start and end dates of when the row was extracted and when a new version of it was extracted, respectively. If the end date column holds a null value, it indicates...

Column Descriptions

ELY Areas 2013 (Scale 1:1 000 000) Dataset Table

Column	Type	Comment
_extract_date	date	The date when the data on the row of the table was extracted from the data source.
_row_number	long	The row number in the data extracted from the source on the extract date specified by the column '_extract_date'.
ely	string	A string identifier for the ELY Centre.
geom_geojson	string	The geographical data represented in GeoJSON format.
geom_geotext	string	The geographical data represented in geotext format.
geom_type	string	The type of the geographical data, for example 'ST_MULTIPOLYGON'.
geom_centroid	string	The geographical center point of the data.
geom_center_x	double	The x-coordinate of the geographical center.
geom_center_y	double	The y-coordinate of the geographical center.
gid	long	An integer identifier for the data.
gml_id	string	A string identifier for the data.
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 of the data, represented as an integer.

Version History of ELY Areas 2013 (1:1 000 000) - Table

Column	Type	Comment
_start_date	date	This column contains the date when the row was extracted from the data source. This, along with '_row_number', uniquely identifies each row in this version history table.
_end_date	date	This column contains the date when a new version of the row was extracted from the data source. If the value in this column 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. This, along with '_start_date', uniquely identifies each row in this version history table.
ely	string	This column contains string type data representing a unique code for each ELY Centre in Finland.
geom_geojson	string	This column contains the geographical representation of the ELY Centre in GeoJSON format.
geom_geotext	string	This column contains the geographical representation of the ELY Centre in text format.
geom_type	string	This column contains the type of the geographical representation of the ELY Centre.
geom_centroid	string	This column contains the geographical center point of the ELY Centre.
geom_center_x	double	This column contains the x-coordinate of the geographical center point of the ELY Centre.
geom_center_y	double	This column contains the y-coordinate of the geographical center point of the ELY Centre.
gid	long	This column contains an integer that represents a unique identifier for each row in the table.
gml_id	string	This column contains a string type unique identifier for each row in the table.
name	string	This column contains the English name of the ELY Centre.
namn	string	This column contains the Swedish name of the ELY Centre.
nimi	string	This column contains the Finnish name of the ELY Centre.
vuosi	long	This column contains an integer representing the year of the data.

Additional Info

Last Updated	November 11, 2024
Created	November 11, 2024