1. Home
  2. Datasets
  3. 2014 Statistical Area Data ...
To download the data set, please sign up or log in

2014 Statistical Area Data Collection

The dataset collection features a series of tables with data from the Statistics Finland Service Interface (WFS), obtained from the Tilastokeskus (Statistics Finland) website. These data tables are compiled from resources in Finland and offer an in-depth view of various statistical areas. The dataset serves to provide rich and detailed data for various analytic purposes. Each table within the collection presents a unique set of data, allowing for a comprehensive overview of the subject matter in question. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

  • Municipalities in 2014 (Scale 1:1 000 000)TSV

    The table in question is part of a larger dataset collection, capturing a comprehensive view of municipalities in Finland as they were in 2014. Sourced from the Finnish statistical authority, 'Tilastokeskus' (Statistics Finland), this table includes various columns that outline different aspects of each municipality. The table stores specific geographic details for each municipality, with a series of 'geom_' prefixed columns. These columns provide information in different formats, like GeoJSON and GeoText, making them versatile for various geospatial data analytics applications. They also include the centroid of the area and its central points in the WGS 84 coordinate reference system, where longitude comes before latitude. Beyond the geographical data, the table also includes columns...

  • Version History of Municipalities 2014 (1:1 000 000) TableTSV

    The 'table__history' is a historical table that retains the version history of its base table rows. It's part of the dataset collection 'tilastointialueet_kunta1000k_2014', which captures data related to the municipalities in 2014 at a scale of 1:1,000,000. The table comes from the Finnish Statistical Bureau ('Tilastokeskus') in Finland. The table records not only the raw data but also the date of data extraction and the unique row number, which together can be used to identify each row uniquely in this version history table. The table has two additional columns '_start_date' and '_end_date', relative to its base table. The '_start_date' column indicates when the row data was extracted from the source, while the '_end_date' refers to the date when a new version of the row was extracted....

Column Descriptions

Municipalities in 2014 (Scale 1:1 000 000)

Column Type Comment
_extract_date date This column specifies the date when the data was extracted from the source. It helps in keeping track of data updates.
_row_number long This column contains the row number of the data extracted from the source. Combined with '_extract_date', it uniquely identifies each row.
geom_geojson string This column contains the geographical data in GeoJSON format. GeoJSON is a format for encoding a variety of geographic data structures.
geom_geotext string This column holds the geographic data in a text format. It provides a readable presentation of the spatial data.
geom_type string This column specifies the type of the geographic data stored in the 'geom_geojson' and 'geom_geotext' columns.
geom_centroid string This column contains the centroid of the geographic data. The centroid is the geometric center of a geometry.
geom_center_x double This column contains the X coordinate of the geometric center of the data.
geom_center_y double This column contains the Y coordinate of the geometric center of the data.
gml_id string This column holds a unique identifier for each row of data.
kunta string This column contains the municipality code of the area.
name string This column holds the name of the area in Finnish.
namn string This column contains the Swedish name of the area.
nimi string This column contains another Finnish name for the area.
vuosi long This column specifies the year of the data.

Version History of Municipalities 2014 (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. It is a part of a combination with '_row_number' that 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 of 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. It is part of a unique identifier for each row when combined with '_start_date'.
geom_geojson string This column stores geometric data in GeoJSON format, which is a common format for encoding a variety of geographic data structures.
geom_geotext string This column contains geometric data in text format. It is a human-readable representation of the geometrical data captured in the 'geom_geojson' column.
geom_type string This column indicates the type of the geometrical data stored. For example, it could be a point, line, or polygon.
geom_centroid string This column contains the geometric centroid of the feature. It is the arithmetic mean position of all the points in all of the geometric object's coordinates.
geom_center_x double This column stores the X coordinate of the feature's center point.
geom_center_y double This column stores the Y coordinate of the feature's center point.
gml_id string This column contains a unique identifier for each feature in the table.
kunta string This column contains a string that represents the municipality in Finland.
name string This column contains the English name of the municipality.
namn string This column contains the Swedish name of the municipality.
nimi string This column contains the Finnish name of the municipality.
vuosi long This column represents the year, indicating the time frame to which the data pertains.

Additional Info

Last Updated November 12, 2024
Created November 11, 2024