2018 Postal Area Statistics Collection

The dataset collection under discussion is a comprehensive grouping of data tables. These tables are interconnected and offer an organized layout of data in the form of rows and columns. The dataset is sourced from 'Tilastokeskus' (The Statistical Bureau), a website based in Finland. The contents of this dataset collection are derived from the Statistics Service Interface (WFS) provided by the data source. This indicates that the data is likely to be statistical in nature, possibly related to postal areas, considering the original naming convention of the collection. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

2018 Statistics and Postal Area Data in FinlandTSV
The table is part of a dataset collection that encapsulates data related to postal area statistics for the year 2018, sourced from the Finnish official statistics provider, 'Tilastokeskus' (Statistics Finland). The data table includes a wealth of information that can be utilized for various analytical purposes. It presents a wide range of demographic, socio-economic, and geographic data by postal area in Finland. Key parameters include population distribution by age, gender, education level, occupational category, income levels, and housing conditions, among others. Additionally, the table contains data on employment sectors, including agriculture, manufacturing, retail, etc. Geographic information is represented in a number of columns, providing a rich resource for geospatial data...
2018 Version History of Paavo Statistical Data and Postal Code AreasTSV
The 'table__history' forms an integral part of the 'postialue_pno_tilasto_2018' dataset collection. This particular table is a history table that retains the version history of its base table rows, providing a detailed chronological record of changes. This makes it invaluable for tracking data evolution over time. The table compiles a rich array of data fields, covering aspects such as demographic statistics, geographic information, socio-economic indicators, and more. For example, it tracks the population distribution by age groups, gender, and marital status. This demographic information could be used in market research to understand the primary consumer base in a given area. Moreover, the table includes geographic data fields that are crucial for spatial analytics. These fields...

Column Descriptions

2018 Statistics and Postal Area Data in 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	This column contains the X-coordinate in the EUREF-FIN coordinate system.
euref_y	double	This column contains the Y-coordinate in the EUREF-FIN coordinate system.
geom_geojson	string	This column contains the geometric information of the area in GeoJSON format.
geom_geotext	string	This column contains the geometric information of the area in text format.
geom_type	string	This column contains the type of the geometric object.
geom_centroid	string	This column contains the geometric center point of the area.
geom_center_x	double	This column contains the X-coordinate of the geometric center point of the area.
geom_center_y	double	This column contains the Y-coordinate of the geometric center point of the area.
gml_id	string	This column contains the unique identifier in the GML format.
he_0_2	long	This column contains the number of people aged 0-2.
he_13_15	long	This column contains the number of people aged 13-15.
he_16_17	long	This column contains the number of people aged 16-17.
he_18_19	long	This column contains the number of people aged 18-19.
he_20_24	long	This column contains the number of people aged 20-24.
he_25_29	long	This column contains the number of people aged 25-29.
he_30_34	long	This column contains the number of people aged 30-34.
he_35_39	long	This column contains the number of people aged 35-39.
he_3_6	long	This column contains the number of people aged 3-6.
he_40_44	long	This column contains the number of people aged 40-44.
he_45_49	long	This column contains the number of people aged 45-49.
he_50_54	long	This column contains the number of people aged 50-54.
he_55_59	long	This column contains the number of people aged 55-59.
he_60_64	long	This column contains the number of people aged 60-64.
he_65_69	long	This column contains the number of people aged 65-69.
he_70_74	long	This column contains the number of people aged 70-74.
he_75_79	long	This column contains the number of people aged 75-79.
he_7_12	long	This column contains the number of people aged 7-12.
he_80_84	long	This column contains the number of people aged 80-84.
he_85_	long	This column contains the number of people aged 85 and over.
he_kika	long	This column contains the number of people in other age groups.
he_miehet	long	This column contains the number of males.
he_naiset	long	This column contains the number of females.
he_vakiy	long	This column contains the total number of permanent residents.
hr_hy_tul	long	This column contains the number of households with high income.
hr_ke_tul	long	This column contains the number of households with average income.
hr_ktu	double	This column contains the average gross income of households.
hr_mtu	double	This column contains the median gross income of households.
hr_ovy	double	This column contains the total income of households.
hr_pi_tul	long	This column contains the number of households with low income.
hr_tuy	long	This column contains the total number of households.
ko_al_kork	long	This column contains the number of people with a low level of education.
ko_ammat	long	This column contains the number of people with vocational education.
ko_ika18y	long	This column contains the number of people aged 18 and over.
ko_koul	long	This column contains the number of people with a secondary education.
ko_perus	long	This column contains the number of people with primary education.
ko_yl_kork	double	This column contains the number of people with a high level of education.
ko_yliop	long	This column contains the number of people with a university degree.
kunta	string	This column contains the municipality code.
namn	string	This column contains the name of the area in Swedish.
nimi	string	This column contains the name of the area in Finnish.
objectid	long	This column contains the unique identifier of the object.
pinta_ala	double	This column contains the surface area of the object.
posti_alue	string	This column contains the postal code of the area.
pt_0_14	long	This column contains the number of people aged 0-14.
pt_elakel	long	This column contains the number of retirees.
pt_muut	long	This column contains the number of other people.
pt_opisk	long	This column contains the number of students.
pt_tyoll	long	This column contains the number of employed people.
pt_tyott	long	This column contains the number of unemployed people.
pt_tyovu	long	This column contains the number of people in the working age.
pt_tyovy	long	This column contains the number of people in the labor force.
pt_vakiy	double	This column contains the total number of permanent residents.
ra_as_kpa	double	This column contains the average size of dwellings.
ra_asrak	long	This column contains the number of residential buildings.
ra_asunn	long	This column contains the number of dwellings.
ra_ke	long	This column contains the number of other buildings.
ra_kt_as	long	This column contains the number of terraced houses.
ra_muut	long	This column contains the number of other buildings.
ra_pt_as	long	This column contains the number of detached houses.
ra_raky	long	This column contains the number of buildings.
te_aik	long	This column contains the number of adults.
te_aklap	long	This column contains the number of adults living alone.
te_as_valj	double	This column contains the percentage of dwellings vacant.
te_eil_np	long	This column contains the number of non-family households.
te_elak	double	This column contains the number of retirees.
te_klap	long	This column contains the number of couples without children.
te_laps	long	This column contains the number of children.
te_muu_as	long	This column contains the number of people living in other types of households.
te_nuor	long	This column contains the number of young people.
te_omis_as	long	This column contains the number of owner-occupied dwellings.
te_plap	long	This column contains the number of single parents.
te_takk	double	This column contains the average size of households.
te_taly	long	This column contains the total number of families.
te_teini	long	This column contains the number of teenagers.
te_vuok_as	long	This column contains the number of rented dwellings.
tp_a_maat	long	This column contains the number of people working in agriculture, forestry and fishing.
tp_alku_a	long	This column contains the number of people working in primary industries.
tp_b_kaiv	long	This column contains the number of people working in mining and quarrying.
tp_c_teol	long	This column contains the number of people working in manufacturing.
tp_d_ener	long	This column contains the number of people working in electricity, gas, steam and air conditioning supply.
tp_e_vesi	long	This column contains the number of people working in water supply, sewerage, waste management and remediation activities.
tp_f_rake	long	This column contains the number of people working in construction.
tp_g_kaup	long	This column contains the number of people working in wholesale and retail trade, repair of motor vehicles and motorcycles.
tp_h_kulj	long	This column contains the number of people working in transportation and storage.
tp_i_majo	long	This column contains the number of people working in accommodation and food service activities.
tp_j_info	long	This column contains the number of people working in information and communication.
tp_jalo_bf	long	This column contains the number of people working in other service activities.
tp_k_raho	long	This column contains the number of people working in financial and insurance activities.
tp_l_kiin	long	This column contains the number of people working in real estate activities.
tp_m_erik	long	This column contains the number of people working in professional, scientific and technical activities.
tp_n_hall	long	This column contains the number of people working in administrative and support service activities.
tp_o_julk	long	This column contains the number of people working in public administration and defense, compulsory social security.
tp_p_koul	long	This column contains the number of people working in education.
tp_palv_gu	long	This column contains the number of people working in other service activities.
tp_q_terv	long	This column contains the number of people working in human health and social work activities.
tp_r_taid	long	This column contains the number of people working in arts, entertainment and recreation.
tp_s_muup	long	This column contains the number of people working in other service activities.
tp_t_koti	long	This column contains the number of people working in activities of households as employers, undifferentiated goods and services producing activities of households for own use.
tp_tyopy	long	This column contains the total number of jobs.
tp_u_kans	long	This column contains the number of people working in activities of extraterritorial organizations and bodies.
tp_x_tunt	long	This column contains the number of people working in industries not elsewhere specified.
tr_hy_tul	long	This column contains the number of taxpayers with high income.
tr_ke_tul	long	This column contains the number of taxpayers with average income.
tr_ktu	double	This column contains the average gross income of taxpayers.
tr_kuty	long	This column contains the total number of taxpayers.
tr_mtu	double	This column contains the median gross income of taxpayers.
tr_ovy	double	This column contains the total income of taxpayers.
tr_pi_tul	long	This column contains the number of taxpayers with low income.
vuosi	long	This column contains the year of the data.

2018 Version History of Paavo Statistical Data and Postal Code Areas

Column	Type	Comment
_start_date	date	The date when the row was extracted from the data source, marking the beginning of the version for the respective row in the history table.
_end_date	date	The date when a new version of the row was extracted from the data source, marking the end of the version for the respective row in the history table. A null value indicates the most recent version of the row.
_row_number	long	The number of the row in the raw data extracted from the data source. Together with '_start_date', it forms a unique identifier for each row in this version history table.
euref_x	double	The x-coordinate of the geographic location in the EUREF-FIN coordinate system.
euref_y	double	The y-coordinate of the geographic location in the EUREF-FIN coordinate system.
geom_geojson	string	The geographic boundaries of the area represented as GeoJSON, a format for encoding geographic data structures.
geom_geotext	string	The geographic boundaries of the area represented as text.
geom_type	string	The type of the geographic object, in this case, a multi-polygon.
geom_centroid	string	The geographic point at the center of the area, represented as a point.
geom_center_x	double	The x-coordinate of the center point of the area.
geom_center_y	double	The y-coordinate of the center point of the area.
gml_id	string	The unique identifier of the row in the GML data format.
he_0_2	long	The number of children aged between 0 to 2 years in the area.
he_13_15	long	The number of teenagers aged between 13 to 15 years in the area.
he_16_17	long	The number of teenagers aged between 16 to 17 years in the area.
he_18_19	long	The number of young adults aged between 18 to 19 years in the area.
he_20_24	long	The number of adults aged between 20 to 24 years in the area.
he_25_29	long	The number of adults aged between 25 to 29 years in the area.
he_30_34	long	The number of adults aged between 30 to 34 years in the area.
he_35_39	long	The number of adults aged between 35 to 39 years in the area.
he_3_6	long	The number of children aged between 3 to 6 years in the area.
he_40_44	long	The number of adults aged between 40 to 44 years in the area.
he_45_49	long	The number of adults aged between 45 to 49 years in the area.
he_50_54	long	The number of adults aged between 50 to 54 years in the area.
he_55_59	long	The number of adults aged between 55 to 59 years in the area.
he_60_64	long	The number of adults aged between 60 to 64 years in the area.
he_65_69	long	The number of adults aged between 65 to 69 years in the area.
he_70_74	long	The number of adults aged between 70 to 74 years in the area.
he_75_79	long	The number of adults aged between 75 to 79 years in the area.
he_7_12	long	The number of children aged between 7 to 12 years in the area.
he_80_84	long	The number of adults aged between 80 to 84 years in the area.
he_85_	long	The number of adults aged 85 years and above in the area.
he_kika	long	The number of people with immigrant background in the area.
he_miehet	long	The number of males in the area.
he_naiset	long	The number of females in the area.
he_vakiy	long	The total population in the area.
hr_hy_tul	long	The number of households with high income in the area.
hr_ke_tul	long	The number of households with average income in the area.
hr_ktu	double	The average gross income of households in the area.
hr_mtu	double	The median gross income of households in the area.
hr_ovy	double	The total income of households in the area.
hr_pi_tul	long	The number of households with low income in the area.
hr_tuy	long	The total number of households in the area.
ko_al_kork	long	The number of people with lower secondary education in the area.
ko_ammat	long	The number of people with vocational qualification in the area.
ko_ika18y	long	The number of people aged 18 years and above in the area.
ko_koul	long	The number of people with upper secondary education in the area.
ko_perus	long	The number of people with basic education in the area.
ko_yl_kork	double	The number of people with higher education (lower level) in the area.
ko_yliop	long	The number of people with university or other higher education in the area.
kunta	string	The code of the municipality where the area is located.
namn	string	The name of the area in Swedish.
nimi	string	The name of the area in Finnish.
objectid	long	The unique identifier of the row in the object database.
pinta_ala	double	The surface area of the area in square meters.
posti_alue	string	The postal code of the area.
pt_0_14	long	The number of people aged between 0 to 14 years in the area.
pt_elakel	long	The number of pensioners in the area.
pt_muut	long	The number of people in other life situations (not working, studying, or on pension) in the area.
pt_opisk	long	The number of students in the area.
pt_tyoll	long	The number of employed people in the area.
pt_tyott	long	The number of unemployed people in the area.
pt_tyovu	long	The total workforce in the area.
pt_tyovy	long	The total number of people of working age in the area.
pt_vakiy	double	The total population of the area.
ra_as_kpa	double	The average size of apartments in the area in square meters.
ra_asrak	long	The number of residential buildings in the area.
ra_asunn	long	The total number of apartments in the area.
ra_ke	long	The number of apartments in residential buildings in the area.
ra_kt_as	long	The number of apartments in blocks of flats in the area.
ra_muut	long	The number of other buildings in the area.
ra_pt_as	long	The number of apartments in detached houses in the area.
ra_raky	long	The total number of buildings in the area.
te_aik	long	The number of adults in the area.
te_aklap	long	The number of households with one adult and children in the area.
te_as_valj	double	The percentage of people living alone in the area.
te_eil_np	long	The number of households with one adult, no children in the area.
te_elak	double	The number of pensioners in the area.
te_klap	long	The number of households with two adults and children in the area.
te_laps	long	The number of children in the area.
te_muu_as	long	The number of people living in other types of households in the area.
te_nuor	long	The number of young people in the area.
te_omis_as	long	The number of owner-occupied apartments in the area.
te_plap	long	The number of households with single parents in the area.
te_takk	double	The average size of households in the area.
te_taly	long	The total number of households in the area.
te_teini	long	The number of teenagers in the area.
te_vuok_as	long	The number of rented apartments in the area.
tp_a_maat	long	The number of people working in agriculture, forestry and fishing in the area.
tp_alku_a	long	The number of people working in primary industries in the area.
tp_b_kaiv	long	The number of people working in mining and quarrying in the area.
tp_c_teol	long	The number of people working in manufacturing in the area.
tp_d_ener	long	The number of people working in electricity, gas, steam and air conditioning supply in the area.
tp_e_vesi	long	The number of people working in water supply, sewerage, waste management and remediation activities in the area.
tp_f_rake	long	The number of people working in construction in the area.
tp_g_kaup	long	The number of people working in wholesale and retail trade, repair of motor vehicles and motorcycles in the area.
tp_h_kulj	long	The number of people working in transportation and storage in the area.
tp_i_majo	long	The number of people working in accommodation and food service activities in the area.
tp_j_info	long	The number of people working in information and communication in the area.
tp_jalo_bf	long	The number of people working in finance and insurance activities in the area.
tp_k_raho	long	The number of people working in real estate activities in the area.
tp_l_kiin	long	The number of people working in professional, scientific and technical activities in the area.
tp_m_erik	long	The number of people working in administrative and support service activities in the area.
tp_n_hall	long	The number of people working in public administration and defence, compulsory social security in the area.
tp_o_julk	long	The number of people working in education in the area.
tp_p_koul	long	The number of people working in human health and social work activities in the area.
tp_palv_gu	long	The number of people working in other service activities in the area.
tp_q_terv	long	The number of people working in arts, entertainment and recreation in the area.
tp_r_taid	long	The number of people working in other service activities in the area.
tp_s_muup	long	The number of people working in activities of households as employers; undifferentiated goods- and services-producing activities of households for own use in the area.
tp_t_koti	long	The number of people working in activities of extraterritorial organizations and bodies in the area.
tp_tyopy	long	The total number of employed persons in the area.
tp_u_kans	long	The number of people working in extraterritorial organizations and bodies in the area.
tp_x_tunt	long	The number of people working in activities not adequately defined in the area.
tr_hy_tul	long	The number of taxpayers with high income in the area.
tr_ke_tul	long	The number of taxpayers with average income in the area.
tr_ktu	double	The average gross income of taxpayers in the area.
tr_kuty	long	The total number of taxpayers in the area.
tr_mtu	double	The median gross income of taxpayers in the area.
tr_ovy	double	The total income of taxpayers in the area.
tr_pi_tul	long	The number of taxpayers with low income in the area.
vuosi	long	The year the data was collected.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024