2022 Postal Area Statistics Tables Collection

The dataset collection comprises a group of related data tables, sourced from the 'Tilastokeskus' (Statistics Finland) website in Finland. These tables are organized in a structured format consisting of rows and columns, which aids in the efficient consolidation and analysis of the data. The dataset is derived from Statistics Finland's service interface, signifying its reliability and accuracy. The comprehensive nature of this dataset collection makes it a valuable resource for various analytical and statistical purposes. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

2022 History of Paavo Statistical Data and Postal Code RegionsTSV
The 'table__history' is a richly detailed dataset table that is part of the larger 'postialue_pno_tilasto_2022' dataset collection. This table serves as a history table, providing a comprehensive version history of its base table rows, essentially tracking changes over time. The table encompasses a broad range of columns that contain diverse types of data, from geographic information to demographic statistics. The data content of this table is sourced from 'Tilastokeskus' (Statistics Finland), a reputable data source in Finland. The table's geographic information is particularly noteworthy. Columns beginning with 'geom_' store geographic data that could be leveraged for geospatial data analytics. These columns hold information such as the geographic coordinates using the WGS 84...
Paavo Statistical Data and Postal Code Areas 2022 Dataset TableTSV
The table is part of a dataset collection that organizes a wealth of data related to demographic and geographic statistics. The information in this table is sourced from 'Tilastokeskus' (Statistics Finland) and is a part of the Paavo statistical dataset and postal code areas for the year 2022. The table contains a multitude of columns, each representing different demographic and geographic metrics. These various metrics include age group demographics, household income levels, educational statuses, geographical coordinates, and more. Notably, two special columns, '_extract_date' and '_row_number', provide insight into when the data was extracted and the unique identification of each row. The geographic coordinates are represented using the WGS 84 coordinate reference system, providing...

Column Descriptions

Paavo Statistical Data and Postal Code Areas 2022 Dataset Table

Column	Type	Comment
_extract_date	date	This special column contains the date when the data on the row of the table was extracted from the data 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'. The combination of the columns '_extract_date' and '_row_number' uniquely identifies each row.
euref_x	long	This Integer64 type column represents the x-coordinate of the postal code area in the EUREF-FIN (TM35FIN) coordinate system.
euref_y	long	This Integer64 type column represents the y-coordinate of the postal code area in the EUREF-FIN (TM35FIN) coordinate system.
geom_geojson	string	Column description not available
geom_geotext	string	Column description not available
geom_type	string	Column description not available
geom_centroid	string	Column description not available
geom_center_x	double	Column description not available
geom_center_y	double	Column description not available
gml_id	string	This is a string type column that provides a unique identifier for each row in the table.
he_0_2	long	Column description not available
he_13_15	long	Column description not available
he_16_17	long	Column description not available
he_18_19	long	Column description not available
he_20_24	long	Column description not available
he_25_29	long	Column description not available
he_30_34	long	Column description not available
he_35_39	long	Column description not available
he_3_6	long	Column description not available
he_40_44	long	Column description not available
he_45_49	long	Column description not available
he_50_54	long	Column description not available
he_55_59	long	Column description not available
he_60_64	long	Column description not available
he_65_69	long	Column description not available
he_70_74	long	Column description not available
he_75_79	long	Column description not available
he_7_12	long	Column description not available
he_80_84	long	Column description not available
he_85_	long	Column description not available
he_kika	long	This Integer64 type column represents the number of people in age groups.
he_miehet	long	This Integer64 type column represents the male population.
he_naiset	long	This Integer64 type column represents the female population.
he_vakiy	long	This Integer64 type column represents the resident population.
hr_hy_tul	long	Column description not available
hr_ke_tul	long	Column description not available
hr_ktu	long	Column description not available
hr_mtu	long	Column description not available
hr_ovy	long	Column description not available
hr_pi_tul	long	Column description not available
hr_tuy	long	Column description not available
ko_al_kork	long	Column description not available
ko_ammat	long	Column description not available
ko_ika18y	long	Column description not available
ko_koul	long	Column description not available
ko_perus	long	Column description not available
ko_yl_kork	long	Column description not available
ko_yliop	long	Column description not available
kunta	string	This string type column represents the municipality.
namn	string	This string type column also represents names.
nimi	string	This string type column represents names.
pinta_ala	double	This Real type column represents the surface area.
postinumeroalue	string	This string type column represents the postal code area.
pt_0_14	long	Column description not available
pt_elakel	long	Column description not available
pt_muut	long	Column description not available
pt_opisk	long	Column description not available
pt_tyoll	long	Column description not available
pt_tyott	long	Column description not available
pt_vakiy	long	Column description not available
ra_as_kpa	double	Column description not available
ra_asrak	long	Column description not available
ra_asunn	long	Column description not available
ra_ke	long	Column description not available
ra_kt_as	long	Column description not available
ra_muu_as	long	Column description not available
ra_muut	long	Column description not available
ra_pt_as	long	Column description not available
ra_raky	long	Column description not available
te_aik	long	Column description not available
te_aklap	long	Column description not available
te_as_valj	double	Column description not available
te_eil_np	long	Column description not available
te_elak	long	Column description not available
te_klap	long	Column description not available
te_laps	long	Column description not available
te_muu_as	long	Column description not available
te_nuor	long	Column description not available
te_omis_as	long	Column description not available
te_plap	long	Column description not available
te_takk	double	Column description not available
te_taly	long	Column description not available
te_teini	long	Column description not available
te_vuok_as	long	Column description not available
te_yhlap	long	Column description not available
te_yks	long	Column description not available
tp_a_maat	long	Column description not available
tp_alku_a	long	Column description not available
tp_b_kaiv	long	Column description not available
tp_c_teol	long	Column description not available
tp_d_ener	long	Column description not available
tp_e_vesi	long	Column description not available
tp_f_rake	long	Column description not available
tp_g_kaup	long	Column description not available
tp_h_kulj	long	Column description not available
tp_i_majo	long	Column description not available
tp_j_info	long	Column description not available
tp_jalo_bf	long	Column description not available
tp_k_raho	long	Column description not available
tp_l_kiin	long	Column description not available
tp_m_erik	long	Column description not available
tp_n_hall	long	Column description not available
tp_o_julk	long	Column description not available
tp_p_koul	long	Column description not available
tp_palv_gu	long	Column description not available
tp_q_terv	long	Column description not available
tp_r_taid	long	Column description not available
tp_s_muup	long	Column description not available
tp_t_koti	long	Column description not available
tp_tyopy	long	Column description not available
tp_u_kans	long	Column description not available
tp_x_tunt	long	Column description not available
tr_hy_tul	long	Column description not available
tr_ke_tul	long	Column description not available
tr_ktu	long	Column description not available
tr_kuty	long	Column description not available
tr_mtu	long	Column description not available
tr_ovy	long	Column description not available
tr_pi_tul	long	Column description not available
vuosi	long	This Integer64 type column represents the year.

2022 History of Paavo Statistical Data and Postal Code Regions

Column	Type	Comment
_start_date	date	The date when the row was extracted from the data source. This column, together with '_row_number', uniquely identifies each row in this version history table.
_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 of the row.
_row_number	long	The number of the row in the raw data extracted from the data source. This number, in combination with '_start_date', uniquely identifies each row in this version history table.
euref_x	long	The integer value representing the X-coordinate in the EUREF-FIN coordinate system (EPSG:3067).
euref_y	long	The integer value representing the Y-coordinate in the EUREF-FIN coordinate system (EPSG:3067).
geom_geojson	string	The column contains geographical data in GeoJSON format representing the spatial boundaries of the postal code area.
geom_geotext	string	The column contains geographical data in text format representing the spatial boundaries of the postal code area.
geom_type	string	The column contains the type of the geographical data structure. The value 'ST_MULTIPOLYGON' indicates that the geographical data represents a multipolygon.
geom_centroid	string	The column contains the coordinates of the centroid of the multipolygon representing the postal code area.
geom_center_x	double	The column contains the X-coordinate of the centroid of the multipolygon representing the postal code area.
geom_center_y	double	The column contains the Y-coordinate of the centroid of the multipolygon representing the postal code area.
gml_id	string	The unique identifier of the postal code area in the source dataset.
he_0_2	long	The number of inhabitants aged between 0 and 2 years in the postal code area.
he_13_15	long	The number of inhabitants aged between 13 and 15 years in the postal code area.
he_16_17	long	The number of inhabitants aged between 16 and 17 years in the postal code area.
he_18_19	long	The number of inhabitants aged between 18 and 19 years in the postal code area.
he_20_24	long	The number of inhabitants aged between 20 and 24 years in the postal code area.
he_25_29	long	The number of inhabitants aged between 25 and 29 years in the postal code area.
he_30_34	long	The number of inhabitants aged between 30 and 34 years in the postal code area.
he_35_39	long	The number of inhabitants aged between 35 and 39 years in the postal code area.
he_3_6	long	The number of inhabitants aged between 3 and 6 years in the postal code area.
he_40_44	long	The number of inhabitants aged between 40 and 44 years in the postal code area.
he_45_49	long	The number of inhabitants aged between 45 and 49 years in the postal code area.
he_50_54	long	The number of inhabitants aged between 50 and 54 years in the postal code area.
he_55_59	long	The number of inhabitants aged between 55 and 59 years in the postal code area.
he_60_64	long	The number of inhabitants aged between 60 and 64 years in the postal code area.
he_65_69	long	The number of inhabitants aged between 65 and 69 years in the postal code area.
he_70_74	long	The number of inhabitants aged between 70 and 74 years in the postal code area.
he_75_79	long	The number of inhabitants aged between 75 and 79 years in the postal code area.
he_7_12	long	The number of inhabitants aged between 7 and 12 years in the postal code area.
he_80_84	long	The number of inhabitants aged between 80 and 84 years in the postal code area.
he_85_	long	The number of inhabitants aged 85 years or older in the postal code area.
he_kika	long	The difference between the number of men and women in the postal code area.
he_miehet	long	The number of male inhabitants in the postal code area.
he_naiset	long	The number of female inhabitants in the postal code area.
he_vakiy	long	The total number of inhabitants in the postal code area.
hr_hy_tul	long	The number of households with high income in the postal code area.
hr_ke_tul	long	The number of households with average income in the postal code area.
hr_ktu	long	The average total income of households in the postal code area.
hr_mtu	long	The median total income of households in the postal code area.
hr_ovy	long	The total income of households in the postal code area.
hr_pi_tul	long	The number of households with low income in the postal code area.
hr_tuy	long	The total number of households in the postal code area.
ko_al_kork	long	The number of inhabitants with lower secondary education in the postal code area.
ko_ammat	long	The number of inhabitants with vocational education in the postal code area.
ko_ika18y	long	The number of inhabitants aged 18 years or older in the postal code area.
ko_koul	long	The number of inhabitants with upper secondary education in the postal code area.
ko_perus	long	The number of inhabitants with basic education in the postal code area.
ko_yl_kork	long	The number of inhabitants with lower tertiary education in the postal code area.
ko_yliop	long	The number of inhabitants with university level education in the postal code area.
kunta	string	The municipal code of the municipality that the postal code area is located in.
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 area of the postal code area in square meters.
postinumeroalue	string	The postal code of the postal code area.
pt_0_14	long	The number of inhabitants aged between 0 and 14 years in the postal code area.
pt_elakel	long	The number of retired inhabitants in the postal code area.
pt_muut	long	The number of inhabitants not in labour force, excluding students and pensioners, in the postal code area.
pt_opisk	long	The number of student inhabitants in the postal code area.
pt_tyoll	long	The number of working inhabitants in the postal code area.
pt_tyott	long	The number of unemployed inhabitants in the postal code area.
pt_vakiy	long	The total number of inhabitants aged 15 years or older in the postal code area.
ra_as_kpa	double	The average residential building area in square meters in the postal code area.
ra_asrak	long	The number of residential buildings in the postal code area.
ra_asunn	long	The number of dwellings in the postal code area.
ra_ke	long	The number of buildings under construction in the postal code area.
ra_kt_as	long	The number of non-residential buildings in the postal code area.
ra_muu_as	long	The number of other buildings in the postal code area.
ra_muut	long	The number of other buildings in the postal code area.
ra_pt_as	long	The number of apartment buildings in the postal code area.
ra_raky	long	The total number of buildings in the postal code area.
te_aik	long	The number of adults, excluding pensioners, in the postal code area.
te_aklap	long	The number of adults living alone in the postal code area.
te_as_valj	double	The average size of the dwelling in the postal code area in square meters.
te_eil_np	long	The number of non-working inhabitants in the postal code area.
te_elak	long	The number of pensioners in the postal code area.
te_klap	long	The number of families with children in the postal code area.
te_laps	long	The number of children in the postal code area.
te_muu_as	long	The number of other dwellings in the postal code area.
te_nuor	long	The number of young adults in the postal code area.
te_omis_as	long	The number of owner-occupied dwellings in the postal code area.
te_plap	long	The number of families with underage children in the postal code area.
te_takk	double	The average number of rooms in the dwellings in the postal code area.
te_taly	long	The total number of dwellings in the postal code area.
te_teini	long	The number of teenagers in the postal code area.
te_vuok_as	long	The number of rented dwellings in the postal code area.
te_yhlap	long	The number of single-parent families in the postal code area.
te_yks	long	The number of single-person households in the postal code area.
tp_a_maat	long	The number of employed inhabitants working in agriculture, forestry and fishing in the postal code area.
tp_alku_a	long	The number of employed inhabitants working in primary industries in the postal code area.
tp_b_kaiv	long	The number of employed inhabitants working in mining and quarrying in the postal code area.
tp_c_teol	long	The number of employed inhabitants working in manufacturing in the postal code area.
tp_d_ener	long	The number of employed inhabitants working in energy supply in the postal code area.
tp_e_vesi	long	The number of employed inhabitants working in water supply, sewerage and waste management in the postal code area.
tp_f_rake	long	The number of employed inhabitants working in construction in the postal code area.
tp_g_kaup	long	The number of employed inhabitants working in trade in the postal code area.
tp_h_kulj	long	The number of employed inhabitants working in transport and storage in the postal code area.
tp_i_majo	long	The number of employed inhabitants working in accommodation and food service activities in the postal code area.
tp_j_info	long	The number of employed inhabitants working in information and communication in the postal code area.
tp_jalo_bf	long	The number of employed inhabitants working in other service activities in the postal code area.
tp_k_raho	long	The number of employed inhabitants working in financial and insurance activities in the postal code area.
tp_l_kiin	long	The number of employed inhabitants working in real estate activities in the postal code area.
tp_m_erik	long	The number of employed inhabitants working in professional, scientific and technical activities in the postal code area.
tp_n_hall	long	The number of employed inhabitants working in administration and support service activities in the postal code area.
tp_o_julk	long	The number of employed inhabitants working in public administration and defense; compulsory social security in the postal code area.
tp_p_koul	long	The number of employed inhabitants working in education in the postal code area.
tp_palv_gu	long	The number of employed inhabitants working in other service activities in the postal code area.
tp_q_terv	long	The number of employed inhabitants working in human health and social work activities in the postal code area.
tp_r_taid	long	The number of employed inhabitants working in arts, entertainment and recreation in the postal code area.
tp_s_muup	long	The number of employed inhabitants working in other service activities in the postal code area.
tp_t_koti	long	The number of employed inhabitants working in activities of households as employers; undifferentiated goods- and services-producing activities of households for own use in the postal code area.
tp_tyopy	long	The total number of employed inhabitants in the postal code area.
tp_u_kans	long	The number of employed inhabitants working in activities of extraterritorial organizations and bodies in the postal code area.
tp_x_tunt	long	The number of employed inhabitants with unknown industry in the postal code area.
tr_hy_tul	long	The number of households with high income in the postal code area, calculated from tax data.
tr_ke_tul	long	The number of households with average income in the postal code area, calculated from tax data.
tr_ktu	long	The average taxable income of households in the postal code area.
tr_kuty	long	The total number of households in the postal code area, calculated from tax data.
tr_mtu	long	The median taxable income of households in the postal code area.
tr_ovy	long	The total taxable income of households in the postal code area.
tr_pi_tul	long	The number of households with low income in the postal code area, calculated from tax data.
vuosi	long	The year when the data was collected.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024