2015 Postal Area Statistics Collection

The dataset collection in question is an assembly of related data tables originating from Finland. Specifically, it is sourced from the website of 'Tilastokeskus' (Statistics Finland). This collection is comprised of a group of tables that share a common theme, which may range from one to several tables. Each table within the collection is a structured compilation of related data, neatly arranged in columns and rows for easy comprehension and analysis. The particular dataset collection is based on data from the service interface of the Statistics Finland (Tilastokeskuksen palvelurajapinta). This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

2015 Version History of Statistical Data and Postal Code Areas from Paavo DatasetTSV
The 'table__history' is a rich historical dataset that is part of the 'postialue_pno_tilasto_2015' dataset collection, sourced from 'Tilastokeskus' (Statistics Finland) website. The table contains a variety of data, including demographic, geographic, and socioeconomic information. The demographic data includes breakouts of population by age and gender. The geographic data, which uses the WGS 84 coordinate reference system, includes detailed geospatial data for data analytics. Socioeconomic data includes income levels, education levels, and occupational categories among others. The table also tracks the version history of each row in the base table, indicating the date of extraction ('_start_date') and the date a new version of the row was extracted ('_end_date'). The combination of...
Postal Area Statistics and Postal Code Regions 2015 Dataset TableTSV
The table, which is part of the 'postialue_pno_tilasto_2015' dataset collection, is a rich source of demography and geo-spatial data. It comes from the Finnish website 'Tilastokeskus' (Statistics Finland). The table incorporates various aspects including geographical coordinates, demographic distributions, and economic indicators among others. The contents of the table are based on the Paavo statistical datasets and postal code areas for the year 2015. Two special columns, '_extract_date' and '_row_number', are included in the table. The '_extract_date' marks the date of data extraction from the source, while the '_row_number' represents the row number in the data extracted from the source on that particular extract date. These two columns combine to uniquely identify each row. The...

Column Descriptions

Postal Area Statistics and Postal Code Regions 2015 Dataset Table

Column	Type	Comment
_extract_date	date	This is a special column that contains the date when the data on the row of the table was extracted from the source.
_row_number	long	This special 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 data of the postal area in GeoJSON format.
geom_geotext	string	This column contains the geometric data of the postal area in geotext format.
geom_type	string	This column indicates the type of the geometric data.
geom_centroid	string	This column contains the centroid of the geometric shape of the postal area.
geom_center_x	double	This column contains the X coordinate of the geometric center of the postal area.
geom_center_y	double	This column contains the Y coordinate of the geometric center of the postal area.
gml_id	string	This column contains the GML ID of the postal area.
he_0_2	double	This column contains the number of permanent residents aged between 0 and 2 in the postal area.
he_13_15	double	This column contains the number of permanent residents aged between 13 and 15 in the postal area.
he_16_17	double	This column contains the number of permanent residents aged between 16 and 17 in the postal area.
he_18_19	double	This column contains the number of permanent residents aged between 18 and 19 in the postal area.
he_20_24	double	This column contains the number of permanent residents aged between 20 and 24 in the postal area.
he_25_29	double	This column contains the number of permanent residents aged between 25 and 29 in the postal area.
he_30_34	double	This column contains the number of permanent residents aged between 30 and 34 in the postal area.
he_35_39	double	This column contains the number of permanent residents aged between 35 and 39 in the postal area.
he_3_6	double	This column contains the number of permanent residents aged between 3 and 6 in the postal area.
he_40_44	double	This column contains the number of permanent residents aged between 40 and 44 in the postal area.
he_45_49	double	This column contains the number of permanent residents aged between 45 and 49 in the postal area.
he_50_54	double	This column contains the number of permanent residents aged between 50 and 54 in the postal area.
he_55_59	double	This column contains the number of permanent residents aged between 55 and 59 in the postal area.
he_60_64	double	This column contains the number of permanent residents aged between 60 and 64 in the postal area.
he_65_69	double	This column contains the number of permanent residents aged between 65 and 69 in the postal area.
he_70_74	double	This column contains the number of permanent residents aged between 70 and 74 in the postal area.
he_75_79	double	This column contains the number of permanent residents aged between 75 and 79 in the postal area.
he_7_12	double	This column contains the number of permanent residents aged between 7 and 12 in the postal area.
he_80_84	double	This column contains the number of permanent residents aged between 80 and 84 in the postal area.
he_85_	double	This column contains the number of permanent residents aged 85 and above in the postal area.
he_kika	double	This column contains the average age of the permanent residents in the postal area.
he_miehet	double	This column contains the number of male permanent residents in the postal area.
he_naiset	double	This column contains the number of female permanent residents in the postal area.
he_vakiy	double	This column contains the number of permanent residents in the postal area.
hr_hy_tul	double	This column contains the number of inhabitants with high income in the postal area.
hr_ke_tul	double	This column contains the number of inhabitants with average income in the postal area.
hr_ktu	double	This column contains the average income of the inhabitants in the postal area.
hr_mtu	double	This column contains the median income of the inhabitants in the postal area.
hr_ovy	double	This column contains the total earned income of the inhabitants in the postal area.
hr_pi_tul	double	This column contains the number of inhabitants with low income in the postal area.
hr_tuy	double	This column contains the total income of the inhabitants in the postal area.
ko_al_kork	double	This column contains the number of people with lower secondary education in the postal area.
ko_ammat	double	This column contains the number of people with vocational education in the postal area.
ko_ika18y	double	This column contains the number of people aged 18 and above in the postal area.
ko_koul	double	This column contains the number of people with higher education in the postal area.
ko_perus	double	This column contains the number of people with basic education in the postal area.
ko_yl_kork	double	This column contains the number of people with higher secondary education in the postal area.
ko_yliop	double	This column contains the number of people with university education in the postal area.
kunta	string	This column contains the municipality code of the postal area.
namn	string	This column contains the Swedish name of the postal area.
nimi	string	This column contains the name of the postal area.
pinta_ala	double	This column contains the area size in square meters.
posti_alue	string	This column contains the postal code of the area.
pt_0_14	double	This column contains the number of permanent residents aged between 0 and 14 in the postal area.
pt_elakel	double	This column contains the number of permanent residents who are pensioners in the postal area.
pt_muut	double	This column contains the number of permanent residents who are neither students nor pensioners in the postal area.
pt_opisk	double	This column contains the number of permanent residents who are students in the postal area.
pt_tyoll	double	This column contains the number of employed permanent residents in the postal area.
pt_tyott	double	This column contains the number of unemployed permanent residents in the postal area.
pt_tyovu	double	This column contains the number of permanent residents outside the labor force in the postal area.
pt_tyovy	double	This column contains the number of working-age permanent residents in the postal area.
pt_vakiy	double	This column contains the number of permanent residents in the postal area.
ra_as_kpa	double	This column contains the total floor area of the dwellings 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 buildings in the postal area.
ra_kt_as	double	This column contains the number of empty dwellings in the postal area.
ra_muut	double	This column contains the total floor area of other types of buildings in the postal area.
ra_pt_as	double	This column contains the number of occupied dwellings in the postal area.
ra_raky	double	This column contains the total floor area of the buildings in the postal area.
te_aik	double	This column contains the number of households with adults in the postal area.
te_aklap	double	This column contains the number of households with single adults in the postal area.
te_as_valj	double	This column contains the housing density, i.e., number of inhabitants per one dwelling, in the postal area.
te_eil_np	double	This column contains the number of households with elderly people living alone in the postal area.
te_elak	double	This column contains the number of households with retirees in the postal area.
te_klap	double	This column contains the number of households with children and two adults in the postal area.
te_laps	double	This column contains the number of households with children in the postal area.
te_muu_as	double	This column contains the number of households living in other types of housing in the postal area.
te_nuor	double	This column contains the number of households with children in the postal area.
te_omis_as	double	This column contains the number of households living in their own house in the postal area.
te_plap	double	This column contains the number of households with only one parent in the postal area.
te_takk	double	This column contains the average size of the households in the postal area.
te_taly	double	This column contains the number of households in the postal area.
te_teini	double	This column contains the number of households with teenagers in the postal area.
te_vuok_as	double	This column contains the number of households living in rented houses in the postal area.
tp_a_maat	double	This column contains the number of jobs in agriculture in the postal area.
tp_alku_a	double	This column contains the number of jobs in agriculture, forestry and fishing in the postal area.
tp_b_kaiv	double	This column contains the number of jobs in mining and quarrying in the postal area.
tp_c_teol	double	This column contains the number of jobs in manufacturing in the postal area.
tp_d_ener	double	This column contains the number of jobs in electricity, gas, steam and air conditioning supply in the postal area.
tp_e_vesi	double	This column contains the number of jobs in water supply, sewerage, waste management and remediation activities in the postal area.
tp_f_rake	double	This column contains the number of jobs in construction in the postal area.
tp_g_kaup	double	This column contains the number of jobs in wholesale and retail trade in the postal area.
tp_h_kulj	double	This column contains the number of jobs in transportation and storage in the postal area.
tp_i_majo	double	This column contains the number of jobs in accommodation and food service activities in the postal area.
tp_j_info	double	This column contains the number of jobs in information and communication in the postal area.
tp_jalo_bf	double	This column contains the number of jobs in wholesale and retail trade, repair of motor vehicles and motorcycles in the postal area.
tp_k_raho	double	This column contains the number of jobs in financial and insurance activities in the postal area.
tp_l_kiin	double	This column contains the number of jobs in real estate activities in the postal area.
tp_m_erik	double	This column contains the number of jobs in professional, scientific and technical activities in the postal area.
tp_n_hall	double	This column contains the number of jobs in administrative and support service activities in the postal area.
tp_o_julk	double	This column contains the number of jobs in public administration and defense, compulsory social security in the postal area.
tp_p_koul	double	This column contains the number of jobs in education in the postal area.
tp_palv_gu	double	This column contains the number of jobs in other service activities in the postal area.
tp_q_terv	double	This column contains the number of jobs in human health and social work activities in the postal area.
tp_r_taid	double	This column contains the number of jobs in arts, entertainment and recreation in the postal area.
tp_s_muup	double	This column contains the number of jobs in other service activities in the postal area.
tp_t_koti	double	This column contains the number of jobs in activities of households as employers in the postal area.
tp_tyopy	double	This column contains the number of jobs in the postal area.
tp_u_kans	double	This column contains the number of jobs in activities of extraterritorial organizations and bodies in the postal area.
tp_x_tunt	double	This column contains the number of jobs in activities of unknown nature in the postal area.
tr_hy_tul	double	This column contains the number of people in the workforce with high income in the postal area.
tr_ke_tul	double	This column contains the number of people in the workforce with average income in the postal area.
tr_ktu	double	This column contains the average income of the people in the workforce in the postal area.
tr_kuty	double	This column contains the total number of people in the workforce in the postal area.
tr_mtu	double	This column contains the median income of the people in the workforce in the postal area.
tr_ovy	double	This column contains the total earned income of the people in the workforce in the postal area.
tr_pi_tul	double	This column contains the number of people in the workforce with low income in the postal area.
vuosi	double	This column contains the year of the statistics.

2015 Version History of Statistical Data and Postal Code Areas from Paavo Dataset

Column	Type	Comment
_start_date	date	The date when the row was extracted from the data source.
_end_date	date	The date when a new version of the row was extracted from the data source. If the value is null, it indicates that the row is the most recent version.
_row_number	long	The number of the row in the raw data extracted from the data source. This column, in combination with '_start_date', uniquely identifies each row in this version history table.
euref_x	double	The x-coordinate of the location in the EUREF-FIN coordinate system (EPSG:3067).
euref_y	double	The y-coordinate of the location in the EUREF-FIN coordinate system (EPSG:3067).
geom_geojson	string	The geographical area of the postal code area represented in GeoJSON format.
geom_geotext	string	The geographical area of the postal code area represented in Well-Known Text (WKT) format.
geom_type	string	The type of the geographical area, represented as a PostGIS geometry type.
geom_centroid	string	The central point of the geographical area, represented as a point in WKT format.
geom_center_x	double	The x-coordinate of the central point of the geographical area.
geom_center_y	double	The y-coordinate of the central point of the geographical area.
gml_id	string	The identifier of the row in the base table in the GML format used by the source.
he_0_2	double	The number of people aged between 0 to 2 years in the postal code area.
he_13_15	double	The number of people aged between 13 to 15 years in the postal code area.
he_16_17	double	The number of people aged between 16 to 17 years in the postal code area.
he_18_19	double	The number of people aged between 18 to 19 years in the postal code area.
he_20_24	double	The number of people aged between 20 to 24 years in the postal code area.
he_25_29	double	The number of people aged between 25 to 29 years in the postal code area.
he_30_34	double	The number of people aged between 30 to 34 years in the postal code area.
he_35_39	double	The number of people aged between 35 to 39 years in the postal code area.
he_3_6	double	The number of people aged between 3 to 6 years in the postal code area.
he_40_44	double	The number of people aged between 40 to 44 years in the postal code area.
he_45_49	double	The number of people aged between 45 to 49 years in the postal code area.
he_50_54	double	The number of people aged between 50 to 54 years in the postal code area.
he_55_59	double	The number of people aged between 55 to 59 years in the postal code area.
he_60_64	double	The number of people aged between 60 to 64 years in the postal code area.
he_65_69	double	The number of people aged between 65 to 69 years in the postal code area.
he_70_74	double	The number of people aged between 70 to 74 years in the postal code area.
he_75_79	double	The number of people aged between 75 to 79 years in the postal code area.
he_7_12	double	The number of people aged between 7 to 12 years in the postal code area.
he_80_84	double	The number of people aged between 80 to 84 years in the postal code area.
he_85_	double	The number of people aged 85 years or older in the postal code area.
he_kika	double	The percentage of people with a foreign background in the postal code area.
he_miehet	double	The number of men in the postal code area.
he_naiset	double	The number of women in the postal code area.
he_vakiy	double	The total number of inhabitants in the postal code area.
hr_hy_tul	double	The number of households with high income in the postal code area.
hr_ke_tul	double	The number of households with average income in the postal code area.
hr_ktu	double	The average total income of households in the postal code area.
hr_mtu	double	The median total income of households in the postal code area.
hr_ovy	double	The total income of all households in the postal code area.
hr_pi_tul	double	The number of households with low income in the postal code area.
hr_tuy	double	The total number of households in the postal code area.
ko_al_kork	double	The number of people with lower secondary education in the postal code area.
ko_ammat	double	The number of people with vocational education in the postal code area.
ko_ika18y	double	The number of people over 18 years of age in the postal code area.
ko_koul	double	The number of people with upper secondary education in the postal code area.
ko_perus	double	The number of people with basic education in the postal code area.
ko_yl_kork	double	The number of people with lower university degree in the postal code area.
ko_yliop	double	The number of people with university degree in the postal code area.
kunta	string	The code of the municipality where the postal code area is located.
namn	string	The name of the postal code area in Swedish.
nimi	string	The name of the postal code area in Finnish.
pinta_ala	double	The surface area of the postal code area in square meters.
posti_alue	string	The postal code.
pt_0_14	double	The number of people aged between 0 to 14 years in the postal code area.
pt_elakel	double	The number of retired people in the postal code area.
pt_muut	double	The number of people in the postal code area that are not classified as students, employed, unemployed or retired.
pt_opisk	double	The number of students in the postal code area.
pt_tyoll	double	The number of employed people in the postal code area.
pt_tyott	double	The number of unemployed people in the postal code area.
pt_tyovu	double	The potential workforce in the postal code area (people aged 15 to 74 years).
pt_tyovy	double	The workforce in the postal code area (people aged 15 to 74 years that are either employed or unemployed).
pt_vakiy	double	The total number of inhabitants aged 15 years or older in the postal code area.
ra_as_kpa	double	The average size of dwellings in the postal code area.
ra_asrak	double	The number of inhabited buildings in the postal code area.
ra_asunn	double	The total number of dwellings in the postal code area.
ra_ke	double	The number of buildings in the postal code area.
ra_kt_as	double	The number of detached houses in the postal code area.
ra_muut	double	The number of other buildings in the postal code area.
ra_pt_as	double	The number of dwellings in apartment blocks in the postal code area.
ra_raky	double	The number of inhabited buildings in the postal code area.
te_aik	double	The number of adults (people aged 18 to 64 years) in the postal code area.
te_aklap	double	The number of families with children where the youngest child is under 3 years in the postal code area.
te_as_valj	double	The percentage of dwellings that are vacant in the postal code area.
te_eil_np	double	The number of families with children where the youngest child is under 7 years and the oldest is at least 18 years in the postal code area.
te_elak	double	The number of elderly people (people aged 65 years or older) in the postal code area.
te_klap	double	The number of families with children where the youngest child is under 7 years in the postal code area.
te_laps	double	The number of children (people aged under 18 years) in the postal code area.
te_muu_as	double	The number of dwellings in the postal code area that are not owner-occupied or rented.
te_nuor	double	The number of young people (people aged 15 to 24 years) in the postal code area.
te_omis_as	double	The number of owner-occupied dwellings in the postal code area.
te_plap	double	The number of families with children where the youngest child is under 7 years and the oldest is at least 7 years in the postal code area.
te_takk	double	The average number of people per dwelling in the postal code area.
te_taly	double	The total number of households in the postal code area.
te_teini	double	The number of teenagers (people aged 13 to 17 years) in the postal code area.
te_vuok_as	double	The number of rented dwellings in the postal code area.
tp_a_maat	double	The number of people working in the agriculture, forestry and fishing industry in the postal code area.
tp_alku_a	double	The number of people working in the primary industries in the postal code area.
tp_b_kaiv	double	The number of people working in the mining and quarrying industry in the postal code area.
tp_c_teol	double	The number of people working in the manufacturing industry in the postal code area.
tp_d_ener	double	The number of people working in the electricity, gas, steam and air conditioning supply industry in the postal code area.
tp_e_vesi	double	The number of people working in the water supply, sewerage, waste management and remediation activities industry in the postal code area.
tp_f_rake	double	The number of people working in the construction industry in the postal code area.
tp_g_kaup	double	The number of people working in the wholesale and retail trade, repair of motor vehicles and motorcycles industry in the postal code area.
tp_h_kulj	double	The number of people working in the transportation and storage industry in the postal code area.
tp_i_majo	double	The number of people working in the accommodation and food service activities industry in the postal code area.
tp_j_info	double	The number of people working in the information and communication industry in the postal code area.
tp_jalo_bf	double	The number of people working in the secondary industries in the postal code area.
tp_k_raho	double	The number of people working in the financial and insurance activities industry in the postal code area.
tp_l_kiin	double	The number of people working in the real estate activities industry in the postal code area.
tp_m_erik	double	The number of people working in the professional, scientific and technical activities industry in the postal code area.
tp_n_hall	double	The number of people working in the administrative and support service activities industry in the postal code area.
tp_o_julk	double	The number of people working in the public administration and defence, compulsory social security industry in the postal code area.
tp_p_koul	double	The number of people working in the education industry in the postal code area.
tp_palv_gu	double	The number of people working in the tertiary industries in the postal code area.
tp_q_terv	double	The number of people working in the human health and social work activities industry in the postal code area.
tp_r_taid	double	The number of people working in the arts, entertainment and recreation industry in the postal code area.
tp_s_muup	double	The number of people working in the other service activities industry in the postal code area.
tp_t_koti	double	The number of people working in activities of households as employers, undifferentiated goods- and services-producing activities of households for own use industry in the postal code area.
tp_tyopy	double	The number of jobs in the postal code area.
tp_u_kans	double	The number of people working in activities of extraterritorial organizations and bodies in the postal code area.
tp_x_tunt	double	The number of people working in industries not specified elsewhere in the postal code area.
tr_hy_tul	double	The number of taxpayers with high income in the postal code area.
tr_ke_tul	double	The number of taxpayers with average income in the postal code area.
tr_ktu	double	The average total income of taxpayers in the postal code area.
tr_kuty	double	The total number of taxpayers in the postal code area.
tr_mtu	double	The median total income of taxpayers in the postal code area.
tr_ovy	double	The total income of all taxpayers in the postal code area.
tr_pi_tul	double	The number of taxpayers with low income in the postal code area.
vuosi	double	The year when the data was collected.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024