Statistics Interface Service Dataset Collection 2023

The dataset collection is a compilation of statistical tables sourced from the website of Tilastokeskus (Statistics Finland) in Finland. These tables collectively provide a wide range of statistical information. Although the specifics of the data are not expressly mentioned, given the source, it's reasonable to assume that the data may include demographic, economic, or geographic statistics relevant to the Finnish postal area. As part of a comprehensive dataset collection, each table contributes to a holistic understanding of the subject matter. The data is organized in a format easy to understand, interpret, and analyze, with the information presented in rows and columns for clarity. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

Paavo Statistical Dataset and Postal Code Areas 2023TSV
The table is a component of a larger dataset collection that holds a wealth of data related to postal code area statistics for the year 2023. Originating from the Statistical Center (Tilastokeskus) in Finland, the table includes various demographic, geographical, and economic indicators. For example, it has data on the population split by gender and age group, income levels, educational attainment, and employment status. Geographical data includes the area size of each postal code region and geographic coordinates for geospatial analysis, adhering to the WGS 84 coordinate reference system. It also contains data about housing such as the number of dwellings and the types of buildings. The economic indicators cover employment across different sectors and income levels. With such diverse...
Version History of Paavo Statistical Data and Postal Code Areas 2023TSV
The 'table__history' is an expansive dataset that encapsulates the version history of its base table rows, derived from the dataset collection 'postialue_pno_tilasto_2023'. Originating from the Statistics Finland ('Tilastokeskus') website, this table holds historical data concerning various demographic, geographic, and economic aspects of Finland. The table's content is primarily based on the Paavo statistical dataset and postal code areas for 2023. It provides a comprehensive picture of various demographics by age group, gender, and other categories. Additionally, it offers geographical data, including geographical coordinates, which are presented using the WGS 84 reference system (longitude first, followed by latitude). This geospatial data can be crucial for geographical analysis...

Column Descriptions

Paavo Statistical Dataset and Postal Code Areas 2023

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'.
euref_x	long	A numerical value representing the x-coordinate of a location in the EUREF-FIN coordinate system.
euref_y	long	A numerical value representing the y-coordinate of a location in the EUREF-FIN coordinate system.
geom_geojson	string	GeoJSON representation of the geometry of the area.
geom_geotext	string	Textual representation of the geometry of the area.
geom_type	string	Type of the geometry, e.g., point, polygon, etc.
geom_centroid	string	Geographic coordinates of the centroid of the area.
geom_center_x	double	X-coordinate of the center of the area.
geom_center_y	double	Y-coordinate of the center of the area.
gml_id	string	A unique identifier of the area in the GML format.
he_0_2	long	Number of inhabitants aged between 0 and 2.
he_13_15	long	Number of inhabitants aged between 13 and 15.
he_16_17	long	Number of inhabitants aged between 16 and 17.
he_18_19	long	Number of inhabitants aged between 18 and 19.
he_20_24	long	Number of inhabitants aged between 20 and 24.
he_25_29	long	Number of inhabitants aged between 25 and 29.
he_30_34	long	Number of inhabitants aged between 30 and 34.
he_35_39	long	Number of inhabitants aged between 35 and 39.
he_3_6	long	Number of inhabitants aged between 3 and 6.
he_40_44	long	Number of inhabitants aged between 40 and 44.
he_45_49	long	Number of inhabitants aged between 45 and 49.
he_50_54	long	Number of inhabitants aged between 50 and 54.
he_55_59	long	Number of inhabitants aged between 55 and 59.
he_60_64	long	Number of inhabitants aged between 60 and 64.
he_65_69	long	Number of inhabitants aged between 65 and 69.
he_70_74	long	Number of inhabitants aged between 70 and 74.
he_75_79	long	Number of inhabitants aged between 75 and 79.
he_7_12	long	Number of inhabitants aged between 7 and 12.
he_80_84	long	Number of inhabitants aged between 80 and 84.
he_85_	long	Number of inhabitants aged 85 and over.
he_kika	long	Total number of households.
he_miehet	long	Number of male inhabitants.
he_naiset	long	Number of female inhabitants.
he_vakiy	long	Total population of the area.
hr_hy_tul	long	Number of households with high income.
hr_ke_tul	long	Number of households with medium income.
hr_ktu	long	Average gross income of households.
hr_mtu	long	Median gross income of households.
hr_ovy	long	Total gross income of households.
hr_pi_tul	long	Number of households with low income.
hr_tuy	long	Total number of households.
ko_al_kork	long	Number of inhabitants with lower secondary education.
ko_ammat	long	Number of inhabitants with vocational education.
ko_ika18y	long	Number of inhabitants aged 18 and over.
ko_koul	long	Number of inhabitants with upper secondary education.
ko_perus	long	Number of inhabitants with basic education.
ko_yl_kork	long	Number of inhabitants with lower tertiary education.
ko_yliop	long	Number of inhabitants with higher tertiary education.
kunta	string	Municipality code.
namn	string	Name of the area in Swedish.
nimi	string	Name of the area in Finnish.
pinta_ala	long	Area size in square meters.
postinumeroalue	string	Postal code area.
pt_0_14	long	Number of inhabitants aged between 0 and 14.
pt_elakel	long	Number of inhabitants who are retirees.
pt_muut	long	Number of inhabitants who are other inactive population.
pt_opisk	long	Number of inhabitants who are students.
pt_tyoll	long	Number of inhabitants who are employed.
pt_tyott	long	Number of inhabitants who are unemployed.
pt_vakiy	long	Total population of the area.
ra_as_kpa	double	Average size of dwellings.
ra_asrak	long	Number of residential buildings.
ra_asunn	long	Number of dwellings.
ra_ke	long	Average number of rooms in dwellings.
ra_kt_as	long	Number of dwellings in terraced houses.
ra_muu_as	long	Number of dwellings in other type of buildings.
ra_muut	long	Number of other buildings.
ra_pt_as	long	Number of dwellings in detached houses.
ra_raky	long	Total number of buildings.
te_aik	long	Number of adults without children.
te_aklap	long	Number of families with underage children.
te_as_valj	double	Percentage of vacant dwellings.
te_eil_np	long	Number of families with underage children and retirees.
te_elak	long	Number of retirees.
te_klap	long	Number of families with underage children.
te_laps	long	Number of children.
te_muu_as	long	Number of dwellings with other type of tenure.
te_nuor	long	Number of young adults.
te_omis_as	long	Number of owner-occupied dwellings.
te_plap	long	Number of families with underage children and other adults.
te_takk	double	Average household size.
te_taly	long	Total number of households.
te_teini	long	Number of teenagers.
te_vuok_as	long	Number of rented dwellings.
te_yhlap	long	Number of one-parent families.
te_yks	long	Number of single-person households.
tp_a_maat	long	Number of jobs in agriculture, forestry and fishing.
tp_alku_a	long	Number of jobs in primary production.
tp_b_kaiv	long	Number of jobs in mining and quarrying.
tp_c_teol	long	Number of jobs in manufacturing.
tp_d_ener	long	Number of jobs in electricity, gas, steam and air conditioning supply.
tp_e_vesi	long	Number of jobs in water supply, sewerage, waste management and remediation activities.
tp_f_rake	long	Number of jobs in construction.
tp_g_kaup	long	Number of jobs in wholesale and retail trade, repair of motor vehicles and motorcycles.
tp_h_kulj	long	Number of jobs in transportation and storage.
tp_i_majo	long	Number of jobs in accommodation and food service activities.
tp_j_info	long	Number of jobs in information and communication.
tp_jalo_bf	long	Number of jobs in secondary production.
tp_k_raho	long	Number of jobs in financial and insurance activities.
tp_l_kiin	long	Number of jobs in real estate activities.
tp_m_erik	long	Number of jobs in professional, scientific and technical activities.
tp_n_hall	long	Number of jobs in administrative and support service activities.
tp_o_julk	long	Number of jobs in public administration and defence, compulsory social security.
tp_p_koul	long	Number of jobs in education.
tp_palv_gu	long	Number of jobs in tertiary production.
tp_q_terv	long	Number of jobs in human health and social work activities.
tp_r_taid	long	Number of jobs in arts, entertainment and recreation.
tp_s_muup	long	Number of jobs in other service activities.
tp_t_koti	long	Number of jobs in activities of households as employers, undifferentiated goods- and services-producing activities of households for own use.
tp_tyopy	long	Total number of jobs.
tp_u_kans	long	Number of jobs in activities of extraterritorial organizations and bodies.
tp_x_tunt	long	Number of jobs in activities not elsewhere classified.
tr_hy_tul	long	Number of taxpayers with high income.
tr_ke_tul	long	Number of taxpayers with medium income.
tr_ktu	long	Average gross income of taxpayers.
tr_kuty	long	Total number of taxpayers.
tr_mtu	long	Median gross income of taxpayers.
tr_ovy	long	Total gross income of taxpayers.
tr_pi_tul	long	Number of taxpayers with low income.
vuosi	long	Year of the data.

Version History of Paavo Statistical Data and Postal Code Areas 2023

Column	Type	Comment
_start_date	date	The start date column represents the date when the row data was extracted from the data source. It is used in conjunction with the '_row_number' column to uniquely identify each row in this version history table.
_end_date	date	The end date column represents 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 current row is the most recent version.
_row_number	long	This column contains the number of the row in the raw data that was extracted from the data source. This column forms a unique identifier for each row in conjunction with the '_start_date' column.
euref_x	long	The 'euref_x' column contains the X-coordinate of the postal code area in the EUREF-FIN (TM35FIN) coordinate system.
euref_y	long	The 'euref_y' column contains the Y-coordinate of the postal code area in the EUREF-FIN (TM35FIN) coordinate system.
geom_geojson	string	This column contains the geometrical representation of the postal code area in GeoJSON format.
geom_geotext	string	The 'geom_geotext' column contains the geometrical representation of the postal code area in Well-Known Text (WKT) format.
geom_type	string	The 'geom_type' column specifies the type of the geometry stored in the 'geom_geojson' and 'geom_geotext' columns.
geom_centroid	string	The 'geom_centroid' column contains the geometrical centroid of the postal code area in WKT format.
geom_center_x	double	This column contains the X-coordinate of the geographical center of the postal code area in the EUREF-FIN (TM35FIN) coordinate system.
geom_center_y	double	This column contains the Y-coordinate of the geographical center of the postal code area in the EUREF-FIN (TM35FIN) coordinate system.
gml_id	string	The 'gml_id' column contains a unique identifier for each row, consisting of the prefix 'pno_tilasto_2023' followed by a unique number.
he_0_2	long	The 'he_0_2' column contains the number of inhabitants aged between 0 and 2 years in the postal code area.
he_13_15	long	The 'he_13_15' column contains the number of inhabitants aged between 13 and 15 years in the postal code area.
he_16_17	long	The 'he_16_17' column contains the number of inhabitants aged between 16 and 17 years in the postal code area.
he_18_19	long	The 'he_18_19' column contains the number of inhabitants aged between 18 and 19 years in the postal code area.
he_20_24	long	The 'he_20_24' column contains the number of inhabitants aged between 20 and 24 years in the postal code area.
he_25_29	long	The 'he_25_29' column contains the number of inhabitants aged between 25 and 29 years in the postal code area.
he_30_34	long	The 'he_30_34' column contains the number of inhabitants aged between 30 and 34 years in the postal code area.
he_35_39	long	The 'he_35_39' column contains the number of inhabitants aged between 35 and 39 years in the postal code area.
he_3_6	long	The 'he_3_6' column contains the number of inhabitants aged between 3 and 6 years in the postal code area.
he_40_44	long	The 'he_40_44' column contains the number of inhabitants aged between 40 and 44 years in the postal code area.
he_45_49	long	The 'he_45_49' column contains the number of inhabitants aged between 45 and 49 years in the postal code area.
he_50_54	long	The 'he_50_54' column contains the number of inhabitants aged between 50 and 54 years in the postal code area.
he_55_59	long	The 'he_55_59' column contains the number of inhabitants aged between 55 and 59 years in the postal code area.
he_60_64	long	The 'he_60_64' column contains the number of inhabitants aged between 60 and 64 years in the postal code area.
he_65_69	long	The 'he_65_69' column contains the number of inhabitants aged between 65 and 69 years in the postal code area.
he_70_74	long	The 'he_70_74' column contains the number of inhabitants aged between 70 and 74 years in the postal code area.
he_75_79	long	The 'he_75_79' column contains the number of inhabitants aged between 75 and 79 years in the postal code area.
he_7_12	long	The 'he_7_12' column contains the number of inhabitants aged between 7 and 12 years in the postal code area.
he_80_84	long	The 'he_80_84' column contains the number of inhabitants aged between 80 and 84 years in the postal code area.
he_85_	long	The 'he_85_' column contains the number of inhabitants aged 85 years or older in the postal code area.
he_kika	long	The 'he_kika' column contains the number of inhabitants with a foreign background in the postal code area.
he_miehet	long	The 'he_miehet' column contains the total number of male inhabitants in the postal code area.
he_naiset	long	The 'he_naiset' column contains the total number of female inhabitants in the postal code area.
he_vakiy	long	The 'he_vakiy' column contains the total number of inhabitants in the postal code area.
hr_hy_tul	long	The 'hr_hy_tul' column represents the number of households in the postal code area with a high income.
hr_ke_tul	long	The 'hr_ke_tul' column represents the number of households in the postal code area with a medium income.
hr_ktu	long	The 'hr_ktu' column represents the average income of households in the postal code area.
hr_mtu	long	The 'hr_mtu' column represents the median income of households in the postal code area.
hr_ovy	long	The 'hr_ovy' column represents the total income of households in the postal code area.
hr_pi_tul	long	The 'hr_pi_tul' column represents the number of households in the postal code area with a low income.
hr_tuy	long	The 'hr_tuy' column represents the total number of households in the postal code area.
ko_al_kork	long	The 'ko_al_kork' column contains the number of inhabitants with lower secondary education in the postal code area.
ko_ammat	long	The 'ko_ammat' column contains the number of inhabitants with vocational education in the postal code area.
ko_ika18y	long	The 'ko_ika18y' column contains the number of inhabitants 18 years or older in the postal code area.
ko_koul	long	The 'ko_koul' column contains the number of inhabitants with upper secondary education in the postal code area.
ko_perus	long	The 'ko_perus' column contains the number of inhabitants with basic education in the postal code area.
ko_yl_kork	long	The 'ko_yl_kork' column contains the number of inhabitants with higher tertiary education (e.g., Master's or Doctorate degree) in the postal code area.
ko_yliop	long	The 'ko_yliop' column contains the number of inhabitants with lower tertiary education (e.g., Bachelor's degree) in the postal code area.
kunta	string	The 'kunta' column contains the municipality code in which the postal code area is located.
namn	string	The 'namn' column contains the name of the postal code area in Swedish.
nimi	string	The 'nimi' column contains the name of the postal code area in Finnish.
pinta_ala	long	The 'pinta_ala' column represents the surface area of the postal code area in square meters.
postinumeroalue	string	The 'postinumeroalue' column contains the postal code of the area.
pt_0_14	long	The 'pt_0_14' column contains the number of people aged 0-14 in the postal code area.
pt_elakel	long	The 'pt_elakel' column contains the number of pensioners in the postal code area.
pt_muut	long	The 'pt_muut' column contains the number of other inactive people in the postal code area.
pt_opisk	long	The 'pt_opisk' column contains the number of students in the postal code area.
pt_tyoll	long	The 'pt_tyoll' column contains the number of employed people in the postal code area.
pt_tyott	long	The 'pt_tyott' column contains the number of unemployed people in the postal code area.
pt_vakiy	long	The 'pt_vakiy' column contains the total number of inhabitants in the postal code area.
ra_as_kpa	double	The 'ra_as_kpa' column contains the average size of an apartment in the postal code area, in square meters.
ra_asrak	long	The 'ra_asrak' column contains the number of residential buildings in the postal code area.
ra_asunn	long	The 'ra_asunn' column contains the number of apartments in the postal code area.
ra_ke	long	The 'ra_ke' column contains the number of commercial buildings in the postal code area.
ra_kt_as	long	The 'ra_kt_as' column contains the number of row houses in the postal code area.
ra_muu_as	long	The 'ra_muu_as' column contains the number of other types of housing in the postal code area.
ra_muut	long	The 'ra_muut' column contains the number of other types of buildings in the postal code area.
ra_pt_as	long	The 'ra_pt_as' column contains the number of detached houses in the postal code area.
ra_raky	long	The 'ra_raky' column contains the total number of buildings in the postal code area.
te_aik	long	The 'te_aik' column contains the number of childless couples in the postal code area.
te_aklap	long	The 'te_aklap' column contains the number of couples with children in the postal code area.
te_as_valj	double	The 'te_as_valj' column contains the percentage of vacant apartments in the postal code area.
te_eil_np	long	The 'te_eil_np' column contains the number of single parents in the postal code area.
te_elak	long	The 'te_elak' column contains the number of retired people in the postal code area.
te_klap	long	The 'te_klap' column contains the number of couples with children in the postal code area.
te_laps	long	The 'te_laps' column contains the number of families with children in the postal code area.
te_muu_as	long	The 'te_muu_as' column contains the number of other types of households in the postal code area.
te_nuor	long	The 'te_nuor' column contains the number of young adults (aged 18-24) in the postal code area.
te_omis_as	long	The 'te_omis_as' column contains the number of owner-occupied apartments in the postal code area.
te_plap	long	The 'te_plap' column contains the number of single parents with children in the postal code area.
te_takk	double	The 'te_takk' column contains the average household size in the postal code area.
te_taly	long	The 'te_taly' column contains the total number of households in the postal code area.
te_teini	long	The 'te_teini' column contains the number of teenagers (aged 13-17) in the postal code area.
te_vuok_as	long	The 'te_vuok_as' column contains the number of rented apartments in the postal code area.
te_yhlap	long	The 'te_yhlap' column contains the number of single parents with children in the postal code area.
te_yks	long	The 'te_yks' column contains the number of single-person households in the postal code area.
tp_a_maat	long	The 'tp_a_maat' column contains the number of people working in agriculture, forestry and fishing in the postal code area.
tp_alku_a	long	The 'tp_alku_a' column contains the number of people working in industries in the postal code area.
tp_b_kaiv	long	The 'tp_b_kaiv' column contains the number of people working in mining and quarrying in the postal code area.
tp_c_teol	long	The 'tp_c_teol' column contains the number of people working in manufacturing in the postal code area.
tp_d_ener	long	The 'tp_d_ener' column contains the number of people working in energy supply in the postal code area.
tp_e_vesi	long	The 'tp_e_vesi' column contains the number of people working in water supply, sewerage and waste management in the postal code area.
tp_f_rake	long	The 'tp_f_rake' column contains the number of people working in construction in the postal code area.
tp_g_kaup	long	The 'tp_g_kaup' column contains the number of people working in wholesale and retail trade; repair of motor vehicles and motorcycles in the postal code area.
tp_h_kulj	long	The 'tp_h_kulj' column contains the number of people working in transport and storage in the postal code area.
tp_i_majo	long	The 'tp_i_majo' column contains the number of people working in accommodation and food service activities in the postal code area.
tp_j_info	long	The 'tp_j_info' column contains the number of people working in information and communication in the postal code area.
tp_jalo_bf	long	The 'tp_jalo_bf' column contains the number of people working in administrative and support service activities in the postal code area.
tp_k_raho	long	The 'tp_k_raho' column contains the number of people working in financial and insurance activities in the postal code area.
tp_l_kiin	long	The 'tp_l_kiin' column contains the number of people working in real estate activities in the postal code area.
tp_m_erik	long	The 'tp_m_erik' column contains the number of people working in professional, scientific and technical activities in the postal code area.
tp_n_hall	long	The 'tp_n_hall' column contains the number of people working in administrative and support service activities in the postal code area.
tp_o_julk	long	The 'tp_o_julk' column contains the number of people working in public administration and defence; compulsory social security in the postal code area.
tp_p_koul	long	The 'tp_p_koul' column contains the number of people working in education in the postal code area.
tp_palv_gu	long	The 'tp_palv_gu' column contains the number of people working in human health and social work activities in the postal code area.
tp_q_terv	long	The 'tp_q_terv' column contains the number of people working in arts, entertainment and recreation in the postal code area.
tp_r_taid	long	The 'tp_r_taid' column contains the number of people working in other service activities in the postal code area.
tp_s_muup	long	The 'tp_s_muup' column contains the number of people working in activities of households as employers; undifferentiated goods- and services-producing activities of households for own use in the postal code area.
tp_t_koti	long	The 'tp_t_koti' column contains the number of people working in activities of extraterritorial organisations and bodies in the postal code area.
tp_tyopy	long	The 'tp_tyopy' column contains the total number of jobs in the postal code area.
tp_u_kans	long	The 'tp_u_kans' column contains the number of people working in activities of extraterritorial organisations and bodies in the postal code area.
tp_x_tunt	long	The 'tp_x_tunt' column contains the number of people working in industries not further specified in the postal code area.
tr_hy_tul	long	The 'tr_hy_tul' column represents the number of taxpayers in the postal code area with a high income.
tr_ke_tul	long	The 'tr_ke_tul' column represents the number of taxpayers in the postal code area with a medium income.
tr_ktu	long	The 'tr_ktu' column represents the average income of taxpayers in the postal code area.
tr_kuty	long	The 'tr_kuty' column represents the total number of taxpayers in the postal code area.
tr_mtu	long	The 'tr_mtu' column represents the median income of taxpayers in the postal code area.
tr_ovy	long	The 'tr_ovy' column represents the total income of taxpayers in the postal code area.
tr_pi_tul	long	The 'tr_pi_tul' column represents the number of taxpayers in the postal code area with a low income.
vuosi	long	The 'vuosi' column contains the year of the data.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024