2016 Postal Area Statistics Collection

This dataset collection is a comprehensive compilation of statistical data tables, derived from the Finnish Statistics Bureau (Tilastokeskus) in Finland. It encompasses a variety of data pertaining to postal areas, collated in 2016. The information organized in these tables provides a detailed insight into different aspects of the postal areas, allowing for an in-depth analysis and understanding. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

2016 Finnish Postal Area Statistics: Version History TableTSV
The 'table__history' is a detailed history table sourced from the 'Tilastokeskus' (Statistics Finland) website. This table is part of the 'postialue_pno_tilasto_2016' dataset collection and contains the version history of its base table rows. It provides a rich collection of data points captured over time, enabling the tracking of changes and trends. The table is particularly useful in the field of geospatial data analytics, as it includes geographic coordinates following the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude. These enable the mapping and analysis of spatial relationships and patterns. The table contains several unique columns such as '_start_date' and '_end_date', which record when the row was extracted from the data source and...
Statistics and Postal Code Areas 2016 Dataset TableTSV
This table, sourced from the Statistics Finland (Tilastokeskus) website, is part of the 'postialue_pno_tilasto_2016' dataset collection. It contains statistical data along with geographic information related to Finland for the year 2016. The data in this table is organized into numerous columns, each representing specific attributes such as demographic details according to age groups, geographic coordinates, area names in different languages, area size, postal codes, and various socioeconomic indicators among others. The geographic data is presented using the WGS 84 coordinate reference system, making it particularly useful for geospatial data analytics. The table also includes two special columns: '_extract_date', which records the date of data extraction from the source, and...

Column Descriptions

Statistics and Postal Code Areas 2016 Dataset Table

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	This column represents a numerical value indicating the x-coordinate in the EUREF coordinate system.
euref_y	double	This column represents a numerical value indicating the y-coordinate in the EUREF coordinate system.
geom_geojson	string	This column contains GEOJSON formatted data representing the geographical shape of the area.
geom_geotext	string	Geographical data in text format, describing the multi-polygonal shape of the area.
geom_type	string	This column describes the type of geometric shape represented in the 'geom_geojson' column.
geom_centroid	string	This column contains the geographical point information that represents the geometric center of the area.
geom_center_x	double	This column represents the x-coordinate of the geometric center of the area.
geom_center_y	double	This column represents the y-coordinate of the geometric center of the area.
gml_id	string	This column contains a unique identifier for the row in the 'postialue_pno_tilasto_2016' dataset.
he_0_2	double	This column represents the number of people aged 0-2 in the area.
he_13_15	double	This column represents the number of people aged 13-15 in the area.
he_16_17	double	This column represents the number of people aged 16-17 in the area.
he_18_19	double	This column represents the number of people aged 18-19 in the area.
he_20_24	double	This column represents the number of people aged 20-24 in the area.
he_25_29	double	This column represents the number of people aged 25-29 in the area.
he_30_34	double	This column represents the number of people aged 30-34 in the area.
he_35_39	double	This column represents the number of people aged 35-39 in the area.
he_3_6	double	This column represents the number of people aged 3-6 in the area.
he_40_44	double	This column represents the number of people aged 40-44 in the area.
he_45_49	double	This column represents the number of people aged 45-49 in the area.
he_50_54	double	This column represents the number of people aged 50-54 in the area.
he_55_59	double	This column represents the number of people aged 55-59 in the area.
he_60_64	double	This column represents the number of people aged 60-64 in the area.
he_65_69	double	This column represents the number of people aged 65-69 in the area.
he_70_74	double	This column represents the number of people aged 70-74 in the area.
he_75_79	double	This column represents the number of people aged 75-79 in the area.
he_7_12	double	This column represents the number of people aged 7-12 in the area.
he_80_84	double	This column represents the number of people aged 80-84 in the area.
he_85_	double	This column represents the number of people aged 85 and above in the area.
he_kika	double	This column represents the number of households in the area.
he_miehet	double	This column represents the number of males in the area.
he_naiset	double	This column represents the number of females in the area.
he_vakiy	double	This column represents the total number of residents in the area.
hr_hy_tul	double	This column represents the number of high income households in the area.
hr_ke_tul	double	This column represents the number of medium income households in the area.
hr_ktu	double	This column represents the average income of the residents in the area.
hr_mtu	double	This column represents the median income of the residents in the area.
hr_ovy	double	This column represents the total income of the residents in the area.
hr_pi_tul	double	This column represents the number of low income households in the area.
hr_tuy	double	This column represents the number of income recipients in the area.
ko_al_kork	double	This column represents the number of residents with lower secondary education.
ko_ammat	double	This column represents the number of residents with vocational education.
ko_ika18y	double	This column represents the number of residents aged 18 and above.
ko_koul	double	This column represents the number of residents with upper secondary education.
ko_perus	double	This column represents the number of residents with basic education.
ko_yl_kork	double	This column represents the number of residents with lower tertiary (bachelor level) education.
ko_yliop	double	This column represents the number of residents with higher tertiary (master/doctorate level) education.
kunta	string	This column represents the municipal code of the area.
namn	string	This column contains the name of the area in Swedish.
nimi	string	This column contains the name of the area in Finnish.
pinta_ala	double	This column represents the total area of the region in square meters.
posti_alue	string	This column contains the postal code of the area.
pt_0_14	double	This column represents the number of 0-14 year old in the population.
pt_elakel	double	This column represents the number of pensioners in the population.
pt_muut	double	This column represents the number of others (not classified elsewhere) in the population.
pt_opisk	double	This column represents the number of students in the population.
pt_tyoll	double	This column represents the number of employed individuals in the population.
pt_tyott	double	This column represents the number of unemployed individuals in the population.
pt_tyovu	double	This column represents the number of individuals in the working-age population.
pt_tyovy	double	This column represents the number of individuals in the active working-age population.
pt_vakiy	double	This column represents the total population.
ra_as_kpa	double	This column represents the average size of the dwellings in the area.
ra_asrak	double	This column represents the number of dwellings in the area.
ra_asunn	double	This column represents the total number of dwellings in the area.
ra_ke	double	This column represents the number of buildings in the area.
ra_kt_as	double	This column represents the total number of buildings with dwellings in the area.
ra_muut	double	This column represents the number of other buildings in the area.
ra_pt_as	double	This column represents the total number of free-time dwellings in the area.
ra_raky	double	This column represents the total number of buildings built in the area.
te_aik	double	This column represents the number of adults (over 18 years old) in the population.
te_aklap	double	This column represents the number of adults living alone in the population.
te_as_valj	double	This column represents the percentage of dwellings that are vacant.
te_eil_np	double	This column represents the number of single parents in the population.
te_elak	double	This column represents the number of pensioners in the population.
te_klap	double	This column represents the number of families with children in the population.
te_laps	double	This column represents the number of children in the population.
te_muu_as	double	This column represents the number of other dwellings in the population.
te_nuor	double	This column represents the number of young people (under 18 years old) in the population.
te_omis_as	double	This column represents the number of owner-occupied dwellings in the population.
te_plap	double	This column represents the number of families with only one child in the population.
te_takk	double	This column represents the average size of the households in the population.
te_taly	double	This column represents the total number of households in the population.
te_teini	double	This column represents the number of teenagers in the population.
te_vuok_as	double	This column represents the number of rented dwellings in the population.
tp_a_maat	double	This column represents the number of people employed in the 'Agriculture, forestry and fishing' sector.
tp_alku_a	double	This column represents the number of people employed in the 'Primary production' sector.
tp_b_kaiv	double	This column represents the number of people employed in the 'Mining' sector.
tp_c_teol	double	This column represents the number of people employed in the 'Manufacturing' sector.
tp_d_ener	double	This column represents the number of people employed in the 'Energy' sector.
tp_e_vesi	double	This column represents the number of people employed in the 'Water supply' sector.
tp_f_rake	double	This column represents the number of people employed in the 'Construction' sector.
tp_g_kaup	double	This column represents the number of people employed in the 'Trade' sector.
tp_h_kulj	double	This column represents the number of people employed in the 'Transport' sector.
tp_i_majo	double	This column represents the number of people employed in the 'Accommodation and food service activities' sector.
tp_j_info	double	This column represents the number of people employed in the 'Information and communication' sector.
tp_jalo_bf	double	This column represents the number of people employed in the 'Secondary production' sector.
tp_k_raho	double	This column represents the number of people employed in the 'Financial and insurance activities' sector.
tp_l_kiin	double	This column represents the number of people employed in the 'Real estate activities' sector.
tp_m_erik	double	This column represents the number of people employed in the 'Professional, scientific and technical activities' sector.
tp_n_hall	double	This column represents the number of people employed in the 'Administrative and support service activities' sector.
tp_o_julk	double	This column represents the number of people employed in the 'Public administration and defence; compulsory social security' sector.
tp_p_koul	double	This column represents the number of people employed in the 'Education' sector.
tp_palv_gu	double	This column represents the number of people employed in the 'Service industry' sector.
tp_q_terv	double	This column represents the number of people employed in the 'Human health and social work activities' sector.
tp_r_taid	double	This column represents the number of people employed in the 'Arts, entertainment and recreation' sector.
tp_s_muup	double	This column represents the number of people employed in the 'Other service activities' sector.
tp_t_koti	double	This column represents the number of people employed in the 'Activities of households as employers; undifferentiated goods - and services - producing activities of households for own use' sector.
tp_tyopy	double	This column represents the total number of working people in the population.
tp_u_kans	double	This column represents the number of people employed in the 'Activities of extraterritorial organisations and bodies' sector.
tp_x_tunt	double	This column represents the number of people employed in the 'Not known or not stated' sector.
tr_hy_tul	double	This column represents the number of high income tax recipients in the area.
tr_ke_tul	double	This column represents the number of medium income tax recipients in the area.
tr_ktu	double	This column represents the average income of the tax recipients in the area.
tr_kuty	double	This column represents the median income of the tax recipients in the area.
tr_mtu	double	This column represents the median income of the tax recipients in the area.
tr_ovy	double	This column represents the total income from the tax recipients in the area.
tr_pi_tul	double	This column represents the number of low income tax recipients in the area.
vuosi	double	This column represents the year the data was collected.

2016 Finnish Postal Area Statistics: Version History Table

Column	Type	Comment
_start_date	date	This column indicates the date when the row was extracted from the data source. It forms a combination with '_row_number' that uniquely identifies each row in this history table.
_end_date	date	This column represents the date when a new version of the row was extracted from the data source. If the value of the 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 Statistics Finland (Tilastokeskus) source. It forms a unique combination with '_start_date' for each row in this history table.
euref_x	double	This column represents the x-coordinates in the EUREF-FIN coordinate system.
euref_y	double	This column represents the y-coordinates in the EUREF-FIN coordinate system.
geom_geojson	string	This column contains the geographical data of the postal area in GeoJSON format, which represents simple geographical features.
geom_geotext	string	This column contains the geographical data of the postal area in text format.
geom_type	string	This column indicates the type of geometry stored in the geographical data columns. In this case, all the geographical data are of the type 'ST_MULTIPOLYGON', which represents a collection of polygons.
geom_centroid	string	This column contains the geographical coordinates of the centroid of the postal area.
geom_center_x	double	This column represents the x-coordinate of the centroid of the postal area.
geom_center_y	double	This column represents the y-coordinate of the centroid of the postal area.
gml_id	string	This column contains a unique identifier for each postal area in the GML format, which is commonly used for geographical data.
he_0_2	double	This column contains the number of inhabitants aged 0-2 in the postal area.
he_13_15	double	This column contains the number of inhabitants aged 13-15 in the postal area.
he_16_17	double	This column contains the number of inhabitants aged 16-17 in the postal area.
he_18_19	double	This column contains the number of inhabitants aged 18-19 in the postal area.
he_20_24	double	This column contains the number of inhabitants aged 20-24 in the postal area.
he_25_29	double	This column contains the number of inhabitants aged 25-29 in the postal area.
he_30_34	double	This column contains the number of inhabitants aged 30-34 in the postal area.
he_35_39	double	This column contains the number of inhabitants aged 35-39 in the postal area.
he_3_6	double	This column contains the number of inhabitants aged 3-6 in the postal area.
he_40_44	double	This column contains the number of inhabitants aged 40-44 in the postal area.
he_45_49	double	This column contains the number of inhabitants aged 45-49 in the postal area.
he_50_54	double	This column contains the number of inhabitants aged 50-54 in the postal area.
he_55_59	double	This column contains the number of inhabitants aged 55-59 in the postal area.
he_60_64	double	This column contains the number of inhabitants aged 60-64 in the postal area.
he_65_69	double	This column contains the number of inhabitants aged 65-69 in the postal area.
he_70_74	double	This column contains the number of inhabitants aged 70-74 in the postal area.
he_75_79	double	This column contains the number of inhabitants aged 75-79 in the postal area.
he_7_12	double	This column contains the number of inhabitants aged 7-12 in the postal area.
he_80_84	double	This column contains the number of inhabitants aged 80-84 in the postal area.
he_85_	double	This column contains the number of inhabitants aged 85 and above in the postal area.
he_kika	double	This column contains data about the average size of families in the postal area.
he_miehet	double	This column contains the number of male inhabitants in the postal area.
he_naiset	double	This column contains the number of female inhabitants in the postal area.
he_vakiy	double	This column contains the total number of inhabitants in the postal area.
hr_hy_tul	double	This column contains data about the number of inhabitants with high income in the postal area.
hr_ke_tul	double	This column contains data about the number of inhabitants with medium income in the postal area.
hr_ktu	double	This column contains data about the total income of the inhabitants in the postal area.
hr_mtu	double	This column contains data about the median income of the inhabitants in the postal area.
hr_ovy	double	This column contains data about the total income of the inhabitants in the postal area.
hr_pi_tul	double	This column contains data about the number of inhabitants with low income in the postal area.
hr_tuy	double	This column contains data about the total income of the inhabitants in the postal area.
ko_al_kork	double	This column contains data about the number of inhabitants with lower-level tertiary education in the postal area.
ko_ammat	double	This column contains data about the number of inhabitants with vocational education in the postal area.
ko_ika18y	double	This column contains the number of inhabitants aged 18 and above in the postal area.
ko_koul	double	This column contains the number of inhabitants with upper secondary education in the postal area.
ko_perus	double	This column contains the number of inhabitants with basic education in the postal area.
ko_yl_kork	double	This column contains the number of inhabitants with upper-level tertiary education in the postal area.
ko_yliop	double	This column contains the number of inhabitants with university-level education in the postal area.
kunta	string	This column contains a unique identifier for each municipality in Finland.
namn	string	This column contains the names of the postal areas in Swedish.
nimi	string	This column contains the names of the postal areas in Finnish.
pinta_ala	double	This column contains data about the surface area of the postal area in square meters.
posti_alue	string	This column contains the postal code of the postal area.
pt_0_14	double	This column contains the number of inhabitants aged 0-14 in the postal area.
pt_elakel	double	This column contains the number of retired inhabitants in the postal area.
pt_muut	double	This column contains the number of inhabitants with other status in the postal area.
pt_opisk	double	This column contains the number of students in the postal area.
pt_tyoll	double	This column contains the number of employed inhabitants in the postal area.
pt_tyott	double	This column contains the number of unemployed inhabitants in the postal area.
pt_tyovu	double	This column contains the number of inhabitants of working age in the postal area.
pt_tyovy	double	This column contains the number of inhabitants of working age who are in the labor force in the postal area.
pt_vakiy	double	This column contains the number of inhabitants of working age in the postal area.
ra_as_kpa	double	This column contains data about the average size of households in the postal area.
ra_asrak	double	This column contains the number of residential buildings in the postal area.
ra_asunn	double	This column contains the number of dwellings in the postal area.
ra_ke	double	This column contains the number of holiday homes in the postal area.
ra_kt_as	double	This column contains the number of dwellings in terraced houses in the postal area.
ra_muut	double	This column contains the number of other buildings in the postal area.
ra_pt_as	double	This column contains the number of dwellings in apartment blocks in the postal area.
ra_raky	double	This column contains the number of buildings in the postal area.
te_aik	double	This column contains the number of adults in the postal area.
te_aklap	double	This column contains the number of adults living alone in the postal area.
te_as_valj	double	This column contains data about the proportion of inhabitants living alone in the postal area.
te_eil_np	double	This column contains the number of adults living alone without children in the postal area.
te_elak	double	This column contains the number of retired adults in the postal area.
te_klap	double	This column contains the number of adults living with children in the postal area.
te_laps	double	This column contains the number of children in the postal area.
te_muu_as	double	This column contains the number of inhabitants living in other types of households in the postal area.
te_nuor	double	This column contains the number of young adults in the postal area.
te_omis_as	double	This column contains the number of owner-occupied dwellings in the postal area.
te_plap	double	This column contains the number of adults living alone with children in the postal area.
te_takk	double	This column contains data about the average size of households in the postal area.
te_taly	double	This column contains the total number of households in the postal area.
te_teini	double	This column contains the number of teenagers in the postal area.
te_vuok_as	double	This column contains the number of rented dwellings in the postal area.
tp_a_maat	double	This column contains the number of inhabitants employed in the agricultural sector in the postal area.
tp_alku_a	double	This column contains the number of inhabitants employed in the primary sector in the postal area.
tp_b_kaiv	double	This column contains the number of inhabitants employed in the mining industry in the postal area.
tp_c_teol	double	This column contains the number of inhabitants employed in the manufacturing industry in the postal area.
tp_d_ener	double	This column contains the number of inhabitants employed in the energy supply sector in the postal area.
tp_e_vesi	double	This column contains the number of inhabitants employed in the water supply and waste management sector in the postal area.
tp_f_rake	double	This column contains the number of inhabitants employed in the construction sector in the postal area.
tp_g_kaup	double	This column contains the number of inhabitants employed in the retail sector in the postal area.
tp_h_kulj	double	This column contains the number of inhabitants employed in the transportation and storage sector in the postal area.
tp_i_majo	double	This column contains the number of inhabitants employed in the accommodation and food services sector in the postal area.
tp_j_info	double	This column contains the number of inhabitants employed in the information and communication sector in the postal area.
tp_jalo_bf	double	This column contains the number of inhabitants employed in the business and administration sector in the postal area.
tp_k_raho	double	This column contains the number of inhabitants employed in the financial and insurance sector in the postal area.
tp_l_kiin	double	This column contains the number of inhabitants employed in the real estate sector in the postal area.
tp_m_erik	double	This column contains the number of inhabitants employed in professional, scientific and technical activities in the postal area.
tp_n_hall	double	This column contains the number of inhabitants employed in administrative and support service activities in the postal area.
tp_o_julk	double	This column contains the number of inhabitants employed in public administration and defense in the postal area.
tp_p_koul	double	This column contains the number of inhabitants employed in the education sector in the postal area.
tp_palv_gu	double	This column contains the number of inhabitants employed in other service activities in the postal area.
tp_q_terv	double	This column contains the number of inhabitants employed in the health and social work sector in the postal area.
tp_r_taid	double	This column contains the number of inhabitants employed in arts, entertainment and recreation activities in the postal area.
tp_s_muup	double	This column contains the number of inhabitants employed in other sectors in the postal area.
tp_t_koti	double	This column contains the number of inhabitants employed in household activities as employers, undifferentiated goods and services producing activities of households for own use in the postal area.
tp_tyopy	double	This column contains the number of inhabitants of working age who are in the labor force in the postal area.
tp_u_kans	double	This column contains the number of inhabitants employed in activities of extraterritorial organizations and bodies in the postal area.
tp_x_tunt	double	This column contains the number of inhabitants employed in activities not adequately defined in the postal area.
tr_hy_tul	double	This column contains data about the number of households with high income in the postal area.
tr_ke_tul	double	This column contains data about the number of households with medium income in the postal area.
tr_ktu	double	This column contains data about the total income of the households in the postal area.
tr_kuty	double	This column contains the average income of the households in the postal area.
tr_mtu	double	This column contains data about the median income of the households in the postal area.
tr_ovy	double	This column contains data about the total income of the households in the postal area.
tr_pi_tul	double	This column contains data about the number of households with low income in the postal area.
vuosi	double	This column contains the year of the data.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024