2017 Postal Code Area Statistics Data Collection

The dataset collection in focus presents a comprehensive compilation of tables related to postal area statistics from 2017. The data within these tables is sourced from 'Tilastokeskus' (Statistics Finland), a Finnish statistical service. Each table within the collection carries a variety of related data, organized neatly into rows and columns for easy understanding and analysis. The information provided by this dataset is essential for understanding the postal area statistics in Finland during the year 2017. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

Statistical Dataset and Postal Code Areas 2017TSV
The table forms part of a dataset collection that is compiled of related data tables. This specific table contains a wealth of data pulled from the Finnish Statistics Bureau's (Tilastokeskus) website. The contents of the table are a result of the Paavo-statistical database and postal code areas for the year 2017. It provides a comprehensive dataset that covers a broad range of demographic, geographical, and statistical data. The table includes numerous columns, each representing different metrics or aspects of the data. For example, one can find data related to population segmentation, geographical coordinates, income brackets, and even specific details such as the number of women and men within each postal area. Notably, this table includes several special columns. The 'extract_date'...
Version History of Paavo Statistical Data and Postal Code Areas 2017TSV
The 'table__history' is a history table that belongs to the 'postialue_pno_tilasto_2017' dataset collection. This table, sourced from the website of the Statistics Finland ('Tilastokeskus'), presents a rich set of data including demographic, geographic, and economic indicators at a granular level. The table's primary focus is to maintain the version history of its base table rows, providing a historical perspective on the data. The table contains a multitude of columns that capture a wide range of data points. For instance, there are columns that record the start and end dates of when the raw data was extracted from the data source, uniquely identifying each row's version history. The table also includes geographic information, with several columns starting with 'geom_' that provide...

Column Descriptions

Statistical Dataset and Postal Code Areas 2017

Column	Type	Comment
_extract_date	date	The date when the data on the row 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	double	The x-coordinate in the EUREF-FIN coordinate system.
euref_y	double	The y-coordinate in the EUREF-FIN coordinate system.
geom_geojson	string	The geographic data in GeoJSON format.
geom_geotext	string	The geographic data in text format.
geom_type	string	The type of the geographic data.
geom_centroid	string	The centroid of the geographic data.
geom_center_x	double	The x-coordinate of the center of the geographic data.
geom_center_y	double	The y-coordinate of the center of the geographic data.
gml_id	string	The ID in the Geography Markup Language (GML) format.
he_0_2	double	Number of people aged between 0 and 2 years.
he_13_15	double	Number of people aged between 13 and 15 years.
he_16_17	double	Number of people aged between 16 and 17 years.
he_18_19	double	Number of people aged between 18 and 19 years.
he_20_24	double	Number of people aged between 20 and 24 years.
he_25_29	double	Number of people aged between 25 and 29 years.
he_30_34	double	Number of people aged between 30 and 34 years.
he_35_39	double	Number of people aged between 35 and 39 years.
he_3_6	double	Number of people aged between 3 and 6 years.
he_40_44	double	Number of people aged between 40 and 44 years.
he_45_49	double	Number of people aged between 45 and 49 years.
he_50_54	double	Number of people aged between 50 and 54 years.
he_55_59	double	Number of people aged between 55 and 59 years.
he_60_64	double	Number of people aged between 60 and 64 years.
he_65_69	double	Number of people aged between 65 and 69 years.
he_70_74	double	Number of people aged between 70 and 74 years.
he_75_79	double	Number of people aged between 75 and 79 years.
he_7_12	double	Number of people aged between 7 and 12 years.
he_80_84	double	Number of people aged between 80 and 84 years.
he_85_	double	Number of people aged 85 years and over.
he_kika	double	Average number of children in a family.
he_miehet	double	Number of men.
he_naiset	double	Number of women.
he_vakiy	double	Total number of inhabitants.
hr_hy_tul	double	Number of high income households.
hr_ke_tul	double	Number of middle income households.
hr_ktu	double	Average total income of households.
hr_mtu	double	Median total income of households.
hr_ovy	double	Total income of households.
hr_pi_tul	double	Number of low income households.
hr_tuy	double	Total number of households.
ko_al_kork	double	Number of people with lower tertiary education.
ko_ammat	double	Number of people with vocational education.
ko_ika18y	double	Number of people aged 18 years and over.
ko_koul	double	Number of people with secondary education.
ko_perus	double	Number of people with primary education.
ko_yl_kork	double	Number of people with upper tertiary education.
ko_yliop	double	Number of people with university education.
kunta	string	Municipality code.
namn	string	Name of the area in Swedish.
nimi	string	Name of the area in Finnish.
pinta_ala	double	Area of the region in square meters.
posti_alue	string	Postal code area.
pt_0_14	double	Number of people aged between 0 and 14 years.
pt_elakel	double	Number of pensioners.
pt_muut	double	Number of other non-employed people.
pt_opisk	double	Number of students.
pt_tyoll	double	Number of employed people.
pt_tyott	double	Number of unemployed people.
pt_tyovu	double	Number of people in the working-age population.
pt_tyovy	double	Number of people in the labour force.
pt_vakiy	double	Total number of inhabitants aged 15 or over.
ra_as_kpa	double	Number of private houses per km2.
ra_asrak	double	Number of residential buildings.
ra_asunn	double	Number of dwellings.
ra_ke	double	Number of vacant dwellings.
ra_kt_as	double	Number of dwellings in blocks of flats.
ra_muut	double	Number of other buildings.
ra_pt_as	double	Number of dwellings in detached houses.
ra_raky	double	Number of buildings.
te_aik	double	Number of adults.
te_aklap	double	Number of families with children and adults.
te_as_valj	double	Percentage of dwellings that are vacant.
te_eil_np	double	Number of single-parent families.
te_elak	double	Number of pensioners.
te_klap	double	Number of families with children.
te_laps	double	Number of children.
te_muu_as	double	Number of other dwellings.
te_nuor	double	Number of people aged between 0 and 14 years.
te_omis_as	double	Number of owner-occupied dwellings.
te_plap	double	Number of single-child families.
te_takk	double	Average size of the dwelling.
te_taly	double	Total number of households.
te_teini	double	Number of teenagers.
te_vuok_as	double	Number of rented dwellings.
tp_a_maat	double	Number of people working in the agriculture, forestry and fishing sector.
tp_alku_a	double	Number of people working in the primary sector.
tp_b_kaiv	double	Number of people working in the mining and quarrying sector.
tp_c_teol	double	Number of people working in the manufacturing sector.
tp_d_ener	double	Number of people working in the energy supply sector.
tp_e_vesi	double	Number of people working in the water supply, sewerage and waste management sector.
tp_f_rake	double	Number of people working in the construction sector.
tp_g_kaup	double	Number of people working in the wholesale and retail trade sector.
tp_h_kulj	double	Number of people working in the transportation and storage sector.
tp_i_majo	double	Number of people working in the accommodation and food service sector.
tp_j_info	double	Number of people working in the information and communication sector.
tp_jalo_bf	double	Number of people working in the other service sector.
tp_k_raho	double	Number of people working in the financial and insurance activities sector.
tp_l_kiin	double	Number of people working in the real estate activities sector.
tp_m_erik	double	Number of people working in the professional, scientific and technical activities sector.
tp_n_hall	double	Number of people working in the administrative and support service activities sector.
tp_o_julk	double	Number of people working in the public administration and defence sector.
tp_p_koul	double	Number of people working in the education sector.
tp_palv_gu	double	Number of people working in the other service activities sector.
tp_q_terv	double	Number of people working in the human health and social work activities sector.
tp_r_taid	double	Number of people working in the arts, entertainment and recreation sector.
tp_s_muup	double	Number of people working in other service activities.
tp_t_koti	double	Number of people working in activities of households as employers.
tp_tyopy	double	Total number of jobs.
tp_u_kans	double	Number of people working in activities of extraterritorial organizations and bodies.
tp_x_tunt	double	Number of people working in not known or unspecified activities.
tr_hy_tul	double	Number of high income taxpayers.
tr_ke_tul	double	Number of middle income taxpayers.
tr_ktu	double	Average total income of taxpayers.
tr_kuty	double	Number of taxpayers.
tr_mtu	double	Median total income of taxpayers.
tr_ovy	double	Total income of taxpayers.
tr_pi_tul	double	Number of low income taxpayers.
vuosi	double	Year of the data.

Version History of Paavo Statistical Data and Postal Code Areas 2017

Column	Type	Comment
_start_date	date	This column signifies the date when the row was extracted from the data source. It helps in creating a version history of each row in the table.
_end_date	date	This column contains 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	This column contains the number of the row in the raw data extracted from the data source. It is used in combination with '_start_date' to uniquely identify each row in this version history table.
euref_x	double	This column stores the X coordinate of the data point according to the EUREF-FIN coordinate system.
euref_y	double	This column holds the Y coordinate of the data point according to the EUREF-FIN coordinate system.
geom_geojson	string	This column contains the geographic data in GeoJSON format.
geom_geotext	string	This column holds the geographic data in text format.
geom_type	string	This column specifies the type of geographic data stored in the 'geom_geojson' and 'geom_geotext' columns.
geom_centroid	string	This column contains the centroid point of the geographic data.
geom_center_x	double	This column contains the X coordinate of the center point of the geographic data.
geom_center_y	double	This column contains the Y coordinate of the center point of the geographic data.
gml_id	string	This column holds identifiers in Geography Markup Language (GML) format.
he_0_2	double	This column contains the number of people aged between 0 and 2 years.
he_13_15	double	This column contains the number of people aged between 13 and 15 years.
he_16_17	double	This column contains the number of people aged between 16 and 17 years.
he_18_19	double	This column contains the number of people aged between 18 and 19 years.
he_20_24	double	This column contains the number of people aged between 20 and 24 years.
he_25_29	double	This column contains the number of people aged between 25 and 29 years.
he_30_34	double	This column contains the number of people aged between 30 and 34 years.
he_35_39	double	This column contains the number of people aged between 35 and 39 years.
he_3_6	double	This column contains the number of people aged between 3 and 6 years.
he_40_44	double	This column contains the number of people aged between 40 and 44 years.
he_45_49	double	This column contains the number of people aged between 45 and 49 years.
he_50_54	double	This column contains the number of people aged between 50 and 54 years.
he_55_59	double	This column contains the number of people aged between 55 and 59 years.
he_60_64	double	This column contains the number of people aged between 60 and 64 years.
he_65_69	double	This column contains the number of people aged between 65 and 69 years.
he_70_74	double	This column contains the number of people aged between 70 and 74 years.
he_75_79	double	This column contains the number of people aged between 75 and 79 years.
he_7_12	double	This column contains the number of people aged between 7 and 12 years.
he_80_84	double	This column contains the number of people aged between 80 and 84 years.
he_85_	double	This column contains the number of people aged 85 years and above.
he_kika	double	This column holds the overall gender ratio in the population.
he_miehet	double	This column contains the number of males in the population.
he_naiset	double	This column contains the number of females in the population.
he_vakiy	double	This column holds the number of permanent residents in the population.
hr_hy_tul	double	This column contains the number of households with high income.
hr_ke_tul	double	This column contains the number of households with average income.
hr_ktu	double	This column holds the average gross income of households.
hr_mtu	double	This column contains the median gross income of households.
hr_ovy	double	This column holds the total gross income of households.
hr_pi_tul	double	This column contains the number of households with low income.
hr_tuy	double	This column contains the total number of households.
ko_al_kork	double	This column contains the number of people with lower secondary level education.
ko_ammat	double	This column contains the number of people with vocational qualifications.
ko_ika18y	double	This column contains the number of people over the age of 18 years.
ko_koul	double	This column holds the number of people with post-secondary non-tertiary education.
ko_perus	double	This column contains the number of people with basic education.
ko_yl_kork	double	This column contains the number of people with higher education.
ko_yliop	double	This column contains the number of people with university degrees.
kunta	string	This column holds the municipality codes.
namn	string	This column contains the names of the geographical areas in Swedish language.
nimi	string	This column contains the names of the geographical areas in Finnish language.
pinta_ala	double	This column holds the surface area of the geographical area in square meters.
posti_alue	string	This column contains the postal code areas.
pt_0_14	double	This column contains the number of people aged between 0 and 14 years.
pt_elakel	double	This column contains the number of pensioners.
pt_muut	double	This column contains the number of other people not included in other categories.
pt_opisk	double	This column contains the number of students.
pt_tyoll	double	This column contains the number of employed people.
pt_tyott	double	This column contains the number of unemployed people.
pt_tyovu	double	This column contains the number of labor force i.e. sum of employed and unemployed people.
pt_tyovy	double	This column contains the number of people of working age (15-64 years).
pt_vakiy	double	This column contains the number of permanent residents.
ra_as_kpa	double	This column contains the average size of dwellings in square meters.
ra_asrak	double	This column contains the number of dwellings.
ra_asunn	double	This column contains the number of residential buildings.
ra_ke	double	This column holds the average number of people per dwelling.
ra_kt_as	double	This column contains the number of vacant dwellings.
ra_muut	double	This column contains the number of other buildings.
ra_pt_as	double	This column contains the number of occupied dwellings.
ra_raky	double	This column contains the number of buildings.
te_aik	double	This column contains the number of adults.
te_aklap	double	This column contains the number of families with underage children.
te_as_valj	double	This column contains the ratio of vacant dwellings.
te_eil_np	double	This column contains the number of non-permanent residents.
te_elak	double	This column contains the number of pensioner households.
te_klap	double	This column contains the number of families with children.
te_laps	double	This column contains the number of children.
te_muu_as	double	This column contains the number of other households not included in other categories.
te_nuor	double	This column contains the number of young adults.
te_omis_as	double	This column contains the number of owner-occupied dwellings.
te_plap	double	This column contains the number of families with one parent.
te_takk	double	This column contains the average number of people in a family.
te_taly	double	This column contains the total number of families.
te_teini	double	This column contains the number of teenagers.
te_vuok_as	double	This column contains the number of rented dwellings.
tp_a_maat	double	This column contains the number of people employed in agriculture, forestry and fishing.
tp_alku_a	double	This column contains the number of people employed in primitive occupations.
tp_b_kaiv	double	This column contains the number of people employed in mining and quarrying.
tp_c_teol	double	This column contains the number of people employed in manufacturing.
tp_d_ener	double	This column contains the number of people employed in electricity, gas, steam and air conditioning supply.
tp_e_vesi	double	This column contains the number of people employed in water supply, sewerage, waste management and remediation activities.
tp_f_rake	double	This column contains the number of people employed in construction.
tp_g_kaup	double	This column contains the number of people employed in wholesale and retail trade; repair of motor vehicles and motorcycles.
tp_h_kulj	double	This column contains the number of people employed in transportation and storage.
tp_i_majo	double	This column contains the number of people employed in accommodation and food service activities.
tp_j_info	double	This column contains the number of people employed in information and communication.
tp_jalo_bf	double	This column contains the number of people employed in secondary occupations.
tp_k_raho	double	This column contains the number of people employed in financial and insurance activities.
tp_l_kiin	double	This column contains the number of people employed in real estate activities.
tp_m_erik	double	This column contains the number of people employed in professional, scientific and technical activities.
tp_n_hall	double	This column contains the number of people employed in administrative and support service activities.
tp_o_julk	double	This column contains the number of people employed in public administration and defense; compulsory social security.
tp_p_koul	double	This column contains the number of people employed in education.
tp_palv_gu	double	This column contains the number of people employed in service occupations.
tp_q_terv	double	This column contains the number of people employed in human health and social work activities.
tp_r_taid	double	This column contains the number of people employed in arts, entertainment and recreation.
tp_s_muup	double	This column contains the number of people employed in other service activities.
tp_t_koti	double	This column contains the number of people employed in activities of households as employers; undifferentiated goods- and services-producing activities of households for own use.
tp_tyopy	double	This column contains the number of jobs.
tp_u_kans	double	This column contains the number of people employed in activities of extraterritorial organizations and bodies.
tp_x_tunt	double	This column contains the number of people employed in unknown occupations.
tr_hy_tul	double	This column contains the number of households with high income.
tr_ke_tul	double	This column contains the number of households with average income.
tr_ktu	double	This column contains the average gross income of households.
tr_kuty	double	This column contains the total number of households.
tr_mtu	double	This column contains the median gross income of households.
tr_ovy	double	This column contains the total gross income of households.
tr_pi_tul	double	This column contains the number of households with low income.
vuosi	double	This column holds the year when the data was collected.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024