2024 Postal Area Statistics Collection

The dataset collection under review comprises a group of related data tables sourced from the website of 'Tilastokeskus' (Statistics Finland), a reputable data source in Finland. The data within these tables are organized into rows and columns, providing a structured and consistent format for data analysis. The description provided by the data source, 'Tilastokeskuksen palvelurajapinta (WFS)', translates to 'Statistics Finland's service interface (WFS)' in English. This suggests that the dataset collection provides a comprehensive set of statistics relevant to postal areas and is projected to inform research and planning up to the year 2024. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

Historical Versioning of Paavo Statistical Data and Postal Code Areas 2024TSV
The 'History' table is a rich, multi-faceted dataset sourced from the Finnish Statistics Bureau ('Tilastokeskus'), providing a detailed snapshot of demographic and geographic data projected for the year 2024. It offers a comprehensive array of demographic data, including population demographics, income levels, educational attainment, and employment status, among other factors. The data is organized by postal code areas, offering granular insight into various regions. The table also provides geographic data which can be useful for geospatial data analytics. This geographic information is presented using the WGS 84 coordinate reference system, with longitude preceding latitude. This can enable detailed spatial analysis and mapping, allowing for regional comparisons and trend...
Postal Area Statistics and Postal Code Regions 2024TSV
The table is a component of a larger dataset collection, and it holds a wealth of related data structured in rows and columns format. The data in this table specifically pertains to the Paavo statistical dataset and postal code areas for the year 2024, a valuable resource for demographic and geographic data analysis. The table contains a broad array of columns that reflect various aspects of the dataset such as demographic distribution, geographical coordinates, and socio-economic indicators. Two special columns '_extract_date' and '_row_number' are present in the table. The '_extract_date' column records the date when the data for each row was extracted, while the '_row_number' column logs the row number in the extracted data. The combination of these two columns provides a unique...

Column Descriptions

Postal Area Statistics and Postal Code Regions 2024

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	long	The X-coordinate value according to the EUREF-FIN (ETRS-TM35FIN) coordinate system.
euref_y	long	The Y-coordinate value according to the EUREF-FIN (ETRS-TM35FIN) coordinate system.
geom_geojson	string	Geographical data in GeoJSON format.
geom_geotext	string	Geographical data in geotext format.
geom_type	string	Type of the geographical data.
geom_centroid	string	Geographical center of the area in point format.
geom_center_x	double	X-coordinate of the geographical center of the area.
geom_center_y	double	Y-coordinate of the geographical center of the area.
gml_id	string	Unique GML identifier of the postal code area.
he_0_2	long	Number of people aged 0-2 years.
he_13_15	long	Number of people aged 13-15 years.
he_16_17	long	Number of people aged 16-17 years.
he_18_19	long	Number of people aged 18-19 years.
he_20_24	long	Number of people aged 20-24 years.
he_25_29	long	Number of people aged 25-29 years.
he_30_34	long	Number of people aged 30-34 years.
he_35_39	long	Number of people aged 35-39 years.
he_3_6	long	Number of people aged 3-6 years.
he_40_44	long	Number of people aged 40-44 years.
he_45_49	long	Number of people aged 45-49 years.
he_50_54	long	Number of people aged 50-54 years.
he_55_59	long	Number of people aged 55-59 years.
he_60_64	long	Number of people aged 60-64 years.
he_65_69	long	Number of people aged 65-69 years.
he_70_74	long	Number of people aged 70-74 years.
he_75_79	long	Number of people aged 75-79 years.
he_7_12	long	Number of people aged 7-12 years.
he_80_84	long	Number of people aged 80-84 years.
he_85_	long	Number of people aged 85 years and over.
he_kika	long	Number of people with a foreign background.
he_miehet	long	Number of males.
he_naiset	long	Number of females.
he_vakiy	long	Number of permanent residents.
hr_hy_tul	long	Number of households with good income level.
hr_ke_tul	long	Number of households with average income level.
hr_ktu	long	Total income of the households (in euros).
hr_mtu	long	Median income of the households (in euros).
hr_ovy	long	Total income of the households from own dwellings (in euros).
hr_pi_tul	long	Number of households with low income level.
hr_tuy	long	Total number of households.
ko_al_kork	long	Number of people with lower secondary education.
ko_ammat	long	Number of people with vocational qualifications.
ko_ika18y	long	Number of people aged 18 years and over.
ko_koul	long	Number of people who are studying.
ko_perus	long	Number of people with basic education.
ko_yl_kork	long	Number of people with higher education.
ko_yliop	long	Number of people with university level education.
kunta	string	Municipality code.
namn	string	The name of the postal code area in Swedish.
nimi	string	The name of the postal code area in Finnish.
pinta_ala	long	The surface area of the postal code area (in square meters).
postinumeroalue	string	Postal code.
pt_0_14	long	Number of people aged 0-14 years.
pt_elakel	long	Number of pensioners.
pt_muut	long	Number of other people.
pt_opisk	long	Number of students.
pt_tyoll	long	Number of working people.
pt_tyott	long	Number of unemployed people.
pt_vakiy	long	Number of permanent residents.
ra_as_kpa	double	Average size of the dwellings (in square meters).
ra_asrak	long	Number of residential buildings.
ra_asunn	long	Number of dwellings.
ra_ke	long	Number of summer cottages.
ra_kt_as	long	Number of dwellings in terraced houses.
ra_muu_as	long	Dwellings in other types of buildings.
ra_muut	long	Number of other buildings.
ra_pt_as	long	Number of dwellings in detached houses.
ra_raky	long	Number of buildings.
te_aik	long	Number of adults.
te_aklap	long	Number of households with adults and children.
te_as_valj	double	Percentage of dwellings vacant.
te_eil_np	long	Number of households with pensioners and no children.
te_elak	long	Number of pensioners.
te_klap	long	Number of households with children.
te_laps	long	Number of children.
te_muu_as	long	Dwellings in other types of buildings.
te_nuor	long	Number of young people.
te_omis_as	long	Number of dwellings owned by occupants.
te_plap	long	Number of households with only children.
te_takk	double	Average number of people per household.
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 single-parent households.
te_yks	long	Number of single-person households.
tp_a_maat	long	Number of people employed in agriculture, forestry and fishing.
tp_alku_a	long	Number of people employed in primary production.
tp_b_kaiv	long	Number of people employed in mining and quarrying.
tp_c_teol	long	Number of people employed in manufacturing.
tp_d_ener	long	Number of people employed in electricity, gas, steam and air conditioning supply.
tp_e_vesi	long	Number of people employed in water supply, sewerage, waste management and remediation activities.
tp_f_rake	long	Number of people employed in construction.
tp_g_kaup	long	Number of people employed in wholesale and retail trade.
tp_h_kulj	long	Number of people employed in transportation and storage.
tp_i_majo	long	Number of people employed in accommodation and food service activities.
tp_j_info	long	Number of people employed in information and communication.
tp_jalo_bf	long	Number of people employed in secondary production.
tp_k_raho	long	Number of people employed in financial and insurance activities.
tp_l_kiin	long	Number of people employed in real estate activities.
tp_m_erik	long	Number of people employed in professional, scientific and technical activities.
tp_n_hall	long	Number of people employed in administrative and support service activities.
tp_o_julk	long	Number of people employed in public administration and defence.
tp_p_koul	long	Number of people employed in education.
tp_palv_gu	long	Number of people employed in services.
tp_q_terv	long	Number of people employed in human health and social work activities.
tp_r_taid	long	Number of people employed in arts, entertainment and recreation.
tp_s_muup	long	Number of people employed in other service activities.
tp_t_koti	long	Number of people employed in activities of households as employers.
tp_tyopy	long	Number of jobs.
tp_u_kans	long	Number of people employed in activities of extraterritorial organizations and bodies.
tp_x_tunt	long	Number of people employed in activities not adequately defined.
tr_hy_tul	long	Number of taxpayers with good income level.
tr_ke_tul	long	Number of taxpayers with average income level.
tr_ktu	long	Total income of the taxpayers (in euros).
tr_kuty	long	Total number of taxpayers.
tr_mtu	long	Median income of the taxpayers (in euros).
tr_ovy	long	Total income of the taxpayers from own dwellings (in euros).
tr_pi_tul	long	Number of taxpayers with low income level.
vuosi	long	Year of the data.

Historical Versioning of Paavo Statistical Data and Postal Code Areas 2024

Column	Type	Comment
_start_date	date	This is the date when the row was extracted from the data source. It is part of the combination that uniquely identifies each row in this version history table.
_end_date	date	This is the date when a new version of the row was extracted from the data source. If the value of this column is null, it means that the row is the most recent version of the row.
_row_number	long	This column contains the number of the row in the raw data extracted from the data source. Together with '_start_date', it forms a combination that uniquely identifies each row in this version history table.
euref_x	long	This is a column of type Integer64 that has not been described by the source.
euref_y	long	This is a column of type Integer64 that has not been described by the source.
geom_geojson	string	This column contains the geometric data of the area in GeoJSON format.
geom_geotext	string	This column contains the geometric data of the area in text format.
geom_type	string	This column contains the type of geometric data stored in the 'geom_geojson' and 'geom_geotext' columns.
geom_centroid	string	This column contains the geometric centroid of the area.
geom_center_x	double	This column contains the x-coordinate of the center of the area.
geom_center_y	double	This column contains the y-coordinate of the center of the area.
gml_id	string	This is a String type column that has not been described by the source.
he_0_2	long	This is an Integer type column that has not been described by the source.
he_13_15	long	This is an Integer type column that has not been described by the source.
he_16_17	long	This is an Integer type column that has not been described by the source.
he_18_19	long	This is an Integer type column that has not been described by the source.
he_20_24	long	This is an Integer type column that has not been described by the source.
he_25_29	long	This is an Integer type column that has not been described by the source.
he_30_34	long	This is an Integer type column that has not been described by the source.
he_35_39	long	This is an Integer type column that has not been described by the source.
he_3_6	long	This is an Integer type column that has not been described by the source.
he_40_44	long	This is an Integer type column that has not been described by the source.
he_45_49	long	This is an Integer type column that has not been described by the source.
he_50_54	long	This is an Integer type column that has not been described by the source.
he_55_59	long	This is an Integer type column that has not been described by the source.
he_60_64	long	This is an Integer type column that has not been described by the source.
he_65_69	long	This is an Integer type column that has not been described by the source.
he_70_74	long	This is an Integer type column that has not been described by the source.
he_75_79	long	This is an Integer type column that has not been described by the source.
he_7_12	long	This is an Integer type column that has not been described by the source.
he_80_84	long	This is an Integer type column that has not been described by the source.
he_85_	long	This is an Integer type column that has not been described by the source.
he_kika	long	This is an Integer type column that has not been described by the source.
he_miehet	long	This is an Integer type column that has not been described by the source.
he_naiset	long	This is an Integer type column that has not been described by the source.
he_vakiy	long	This is an Integer type column that has not been described by the source.
hr_hy_tul	long	This is an Integer type column that has not been described by the source.
hr_ke_tul	long	This is an Integer type column that has not been described by the source.
hr_ktu	long	This is an Integer type column that has not been described by the source.
hr_mtu	long	This is an Integer type column that has not been described by the source.
hr_ovy	long	This is a column of type Integer64 that has not been described by the source.
hr_pi_tul	long	This is an Integer type column that has not been described by the source.
hr_tuy	long	This is an Integer type column that has not been described by the source.
ko_al_kork	long	This is an Integer type column that has not been described by the source.
ko_ammat	long	This is an Integer type column that has not been described by the source.
ko_ika18y	long	This is an Integer type column that has not been described by the source.
ko_koul	long	This is an Integer type column that has not been described by the source.
ko_perus	long	This is an Integer type column that has not been described by the source.
ko_yl_kork	long	This is an Integer type column that has not been described by the source.
ko_yliop	long	This is an Integer type column that has not been described by the source.
kunta	string	This is a String type column that has not been described by the source.
namn	string	This is a String type column that has not been described by the source.
nimi	string	This is a String type column that has not been described by the source.
pinta_ala	long	This is a column of type Integer64 that has not been described by the source.
postinumeroalue	string	This is a String type column that has not been described by the source.
pt_0_14	long	This is an Integer type column that has not been described by the source.
pt_elakel	long	This is an Integer type column that has not been described by the source.
pt_muut	long	This is an Integer type column that has not been described by the source.
pt_opisk	long	This is an Integer type column that has not been described by the source.
pt_tyoll	long	This is an Integer type column that has not been described by the source.
pt_tyott	long	This is an Integer type column that has not been described by the source.
pt_vakiy	long	This is an Integer type column that has not been described by the source.
ra_as_kpa	double	This is a Real type column that has not been described by the source.
ra_asrak	long	This is an Integer type column that has not been described by the source.
ra_asunn	long	This is an Integer type column that has not been described by the source.
ra_ke	long	This is an Integer type column that has not been described by the source.
ra_kt_as	long	This is an Integer type column that has not been described by the source.
ra_muu_as	long	This is an Integer type column that has not been described by the source.
ra_muut	long	This is an Integer type column that has not been described by the source.
ra_pt_as	long	This is an Integer type column that has not been described by the source.
ra_raky	long	This is an Integer type column that has not been described by the source.
te_aik	long	This is an Integer type column that has not been described by the source.
te_aklap	long	This is an Integer type column that has not been described by the source.
te_as_valj	double	This is a Real type column that has not been described by the source.
te_eil_np	long	This is an Integer type column that has not been described by the source.
te_elak	long	This is an Integer type column that has not been described by the source.
te_klap	long	This is an Integer type column that has not been described by the source.
te_laps	long	This is an Integer type column that has not been described by the source.
te_muu_as	long	This is an Integer type column that has not been described by the source.
te_nuor	long	This is an Integer type column that has not been described by the source.
te_omis_as	long	This is an Integer type column that has not been described by the source.
te_plap	long	This is an Integer type column that has not been described by the source.
te_takk	double	This is a Real type column that has not been described by the source.
te_taly	long	This is an Integer type column that has not been described by the source.
te_teini	long	This is an Integer type column that has not been described by the source.
te_vuok_as	long	This is an Integer type column that has not been described by the source.
te_yhlap	long	This is an Integer type column that has not been described by the source.
te_yks	long	This is an Integer type column that has not been described by the source.
tp_a_maat	long	This is an Integer type column that has not been described by the source.
tp_alku_a	long	This is an Integer type column that has not been described by the source.
tp_b_kaiv	long	This is an Integer type column that has not been described by the source.
tp_c_teol	long	This is an Integer type column that has not been described by the source.
tp_d_ener	long	This is an Integer type column that has not been described by the source.
tp_e_vesi	long	This is an Integer type column that has not been described by the source.
tp_f_rake	long	This is an Integer type column that has not been described by the source.
tp_g_kaup	long	This is an Integer type column that has not been described by the source.
tp_h_kulj	long	This is an Integer type column that has not been described by the source.
tp_i_majo	long	This is an Integer type column that has not been described by the source.
tp_j_info	long	This is an Integer type column that has not been described by the source.
tp_jalo_bf	long	This is an Integer type column that has not been described by the source.
tp_k_raho	long	This is an Integer type column that has not been described by the source.
tp_l_kiin	long	This is an Integer type column that has not been described by the source.
tp_m_erik	long	This is an Integer type column that has not been described by the source.
tp_n_hall	long	This is an Integer type column that has not been described by the source.
tp_o_julk	long	This is an Integer type column that has not been described by the source.
tp_p_koul	long	This is an Integer type column that has not been described by the source.
tp_palv_gu	long	This is an Integer type column that has not been described by the source.
tp_q_terv	long	This is an Integer type column that has not been described by the source.
tp_r_taid	long	This is an Integer type column that has not been described by the source.
tp_s_muup	long	This is an Integer type column that has not been described by the source.
tp_t_koti	long	This is an Integer type column that has not been described by the source.
tp_tyopy	long	This is an Integer type column that has not been described by the source.
tp_u_kans	long	This is an Integer type column that has not been described by the source.
tp_x_tunt	long	This is an Integer type column that has not been described by the source.
tr_hy_tul	long	This is an Integer type column that has not been described by the source.
tr_ke_tul	long	This is an Integer type column that has not been described by the source.
tr_ktu	long	This is an Integer type column that has not been described by the source.
tr_kuty	long	This is an Integer type column that has not been described by the source.
tr_mtu	long	This is an Integer type column that has not been described by the source.
tr_ovy	long	This is a column of type Integer64 that has not been described by the source.
tr_pi_tul	long	This is an Integer type column that has not been described by the source.
vuosi	long	This is an Integer type column that has not been described by the source.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024