To download the data set, please sign up or log in
2019 Postal Area Statistics Collection
Tables
-
2019 Postal Area Statistics and Postal Code Areas: Version HistoryTSV
The history table is a comprehensive data collection that provides a chronological record of various data points. This table, part of a larger dataset collection, houses the version history of its base table rows. It serves as a valuable tool for tracking changes over time, and can aid in a multitude of data analytics applications. For instance, the table includes geographic information, presented using the WGS 84 coordinate reference system (longitude first, then latitude), which is key for geospatial data analytics. This data could be used to track changes in demographics, infrastructure, or the environment in specific geographic areas. The table also uniquely identifies each row using a combination of the start date of data extraction and a row number. This makes it possible to...
-
2019 Statistical Data and Postal Code AreasTSV
The table is part of a dataset collection related to postal area statistics from 2019, originating from the Finnish statistical office, 'Tilastokeskus' (Statistics Finland). The table contains a wide range of information, including demographic details broken down by age and gender, income data, geographical coordinates, and details related to housing, education, employment, and more. The data is organized in rows, each identified by a unique combination of extraction date and row number. The geographical coordinates are presented in the WGS 84 coordinate reference system, with longitude first and then latitude, making it useful for geospatial data analytics. This table could be utilized in numerous ways in data analytics. For example, it could be used to study the demographic...
Column Descriptions
2019 Statistical Data and Postal Code Areas
| Column | Type | Comment |
|---|---|---|
| _extract_date | date | Contains the date when the data on the row of the table was extracted from the data source. |
| _row_number | long | Contains the row number in the data extracted from the source on the extract date specified by the column '_extract_date'. |
| euref_x | long | Denotes the X coordinate in the EUREF-FIN coordinate system (EPSG:3067). |
| euref_y | long | Denotes the Y coordinate in the EUREF-FIN coordinate system (EPSG:3067). |
| geom_geojson | string | Contains the geographic area of the postal code area as a GeoJSON. |
| geom_geotext | string | Contains the geographic area of the postal code area as WKT text. |
| geom_type | string | Describes the type of geometrical object (Multipolygon). |
| geom_centroid | string | The centroid of the geographical area as a WKT point. |
| geom_center_x | double | The X coordinate of the centroid of the geographical area. |
| geom_center_y | double | The Y coordinate of the centroid of the geographical area. |
| gml_id | string | Unique identifier for the row. |
| he_0_2 | long | Number of people in the age group 0-2 years. |
| he_13_15 | long | Number of people in the age group 13-15 years. |
| he_16_17 | long | Number of people in the age group 16-17 years. |
| he_18_19 | long | Number of people in the age group 18-19 years. |
| he_20_24 | long | Number of people in the age group 20-24 years. |
| he_25_29 | long | Number of people in the age group 25-29 years. |
| he_30_34 | long | Number of people in the age group 30-34 years. |
| he_35_39 | long | Number of people in the age group 35-39 years. |
| he_3_6 | long | Number of people in the age group 3-6 years. |
| he_40_44 | long | Number of people in the age group 40-44 years. |
| he_45_49 | long | Number of people in the age group 45-49 years. |
| he_50_54 | long | Number of people in the age group 50-54 years. |
| he_55_59 | long | Number of people in the age group 55-59 years. |
| he_60_64 | long | Number of people in the age group 60-64 years. |
| he_65_69 | long | Number of people in the age group 65-69 years. |
| he_70_74 | long | Number of people in the age group 70-74 years. |
| he_75_79 | long | Number of people in the age group 75-79 years. |
| he_7_12 | long | Number of people in the age group 7-12 years. |
| he_80_84 | long | Number of people in the age group 80-84 years. |
| he_85_ | long | Number of people in the age group 85 and above. |
| he_kika | long | Number of people with a foreign background. |
| he_miehet | long | Number of men. |
| he_naiset | long | Number of women. |
| he_vakiy | long | Number of permanent residents. |
| hr_hy_tul | long | Number of high-income households. |
| hr_ke_tul | long | Number of average-income households. |
| hr_ktu | double | Average income of households. |
| hr_mtu | double | Median income of households. |
| hr_ovy | double | Total income of households. |
| hr_pi_tul | long | Number of low-income households. |
| hr_tuy | long | Number of households. |
| ko_al_kork | long | Number of people with lower tertiary education. |
| ko_ammat | long | Number of people with vocational education. |
| ko_ika18y | long | Number of people aged 18 and over. |
| ko_koul | long | Number of people with secondary education. |
| ko_perus | long | Number of people with basic education. |
| ko_yl_kork | double | Number of people with higher tertiary education. |
| ko_yliop | long | Number of people with university education. |
| kunta | string | Municipality code. |
| namn | string | Name of the postal code area in Swedish. |
| nimi | string | Name of the postal code area in Finnish. |
| objectid | long | Unique identifier of the object. |
| pinta_ala | double | Area of the postal code area in square meters. |
| posti_alue | string | Postal code. |
| pt_0_14 | long | Number of people aged 0-14. |
| pt_elakel | long | Number of pensioners. |
| pt_muut | long | Number of other people. |
| pt_opisk | long | Number of students. |
| pt_tyoll | long | Number of employed people. |
| pt_tyott | long | Number of unemployed people. |
| pt_vakiy | double | Number of permanent residents. |
| ra_as_kpa | double | Average size of dwellings. |
| ra_asrak | long | Number of residential buildings. |
| ra_asunn | long | Number of dwellings. |
| ra_ke | long | Number of buildings under construction. |
| ra_kt_as | long | Number of row houses. |
| ra_muut | long | Number of other buildings. |
| ra_pt_as | long | Number of detached houses. |
| ra_raky | long | Number of buildings. |
| te_aik | long | Number of adults. |
| te_aklap | long | Number of childless families. |
| te_as_valj | double | Households' average size. |
| te_eil_np | long | Number of other families. |
| te_elak | double | Number of pensioner households. |
| te_klap | long | Number of families with children. |
| te_laps | long | Number of children. |
| te_muu_as | long | Number of other dwellings. |
| te_nuor | long | Number of young people. |
| te_omis_as | long | Number of owner-occupied dwellings. |
| te_plap | long | Number of single parent families. |
| te_takk | double | Column description not available |
| te_taly | long | Number of households. |
| te_teini | long | Number of teenagers. |
| te_vuok_as | long | Number of rented dwellings. |
| tp_a_maat | long | Number of people working in primary production. |
| tp_alku_a | long | Number of people working in primary production. |
| tp_b_kaiv | long | Number of people working in mining and quarrying. |
| tp_c_teol | long | Number of people working in manufacturing. |
| tp_d_ener | long | Number of people working in energy supply. |
| tp_e_vesi | long | Number of people working in water supply, sewerage and waste management. |
| tp_f_rake | long | Number of people working in construction. |
| tp_g_kaup | long | Number of people working in trade. |
| tp_h_kulj | long | Number of people working in transport and storage. |
| tp_i_majo | long | Number of people working in accommodation and food service activities. |
| tp_j_info | long | Number of people working in information and communication. |
| tp_jalo_bf | long | Number of people working in other service activities. |
| tp_k_raho | long | Number of people working in financial and insurance activities. |
| tp_l_kiin | long | Number of people working in real estate activities. |
| tp_m_erik | long | Number of people working in professional, scientific and technical activities. |
| tp_n_hall | long | Number of people working in administrative and support service activities. |
| tp_o_julk | long | Number of people working in public administration and defence, compulsory social security. |
| tp_p_koul | long | Number of people working in education. |
| tp_palv_gu | long | Number of people working in other service activities. |
| tp_q_terv | long | Number of people working in human health and social work activities. |
| tp_r_taid | long | Number of people working in arts, entertainment and recreation. |
| tp_s_muup | long | Number of people working in other service activities. |
| tp_t_koti | long | Number of people working in activities of households as employers. |
| tp_tyopy | long | Number of workplaces. |
| tp_u_kans | long | Number of people working in activities of extraterritorial organizations and bodies. |
| tp_x_tunt | long | Number of people working in activities not adequately defined. |
| tr_hy_tul | long | Number of high-income taxpayers. |
| tr_ke_tul | long | Number of average-income taxpayers. |
| tr_ktu | double | Average income of taxpayers. |
| tr_kuty | long | Number of taxpayers. |
| tr_mtu | double | Median income of taxpayers. |
| tr_ovy | double | Total income of taxpayers. |
| tr_pi_tul | long | Number of low-income taxpayers. |
| vuosi | long | Year of the data. |
2019 Postal Area Statistics and Postal Code Areas: Version History
| Column | Type | Comment |
|---|---|---|
| _start_date | date | This column captures the date when the row was extracted from the data source. It helps in identifying the exact version of the data row in this history table. |
| _end_date | date | This column records the date when a new version of the row was extracted from the data source. If the value of this column 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 uniquely identifies each row in this version history table when combined with the '_start_date'. |
| euref_x | long | This column contains the X coordinate of the geographical location in the EUREF-FIN coordinates system. |
| euref_y | long | This column contains the Y coordinate of the geographical location in the EUREF-FIN coordinates system. |
| geom_geojson | string | This column contains the geographical location of the area in GeoJSON format, which is a format for encoding a variety of geographic data structures. |
| geom_geotext | string | This column stores the geographical location of the area in geotext format. |
| geom_type | string | This column specifies the type of the geographical shape used to represent the area. In this case, it is 'ST_MULTIPOLYGON', indicating the area is represented using multiple polygons. |
| geom_centroid | string | This column contains the centroid of the geographical location. The centroid is the geometric center of a plane figure or shape. |
| geom_center_x | double | This column contains the X coordinate of the geometric center of the area. |
| geom_center_y | double | This column contains the Y coordinate of the geometric center of the area. |
| gml_id | string | This column contains a unique identifier for each row in the Geography Markup Language (GML) format. |
| he_0_2 | long | This column records the number of people aged between 0-2 years in the area. |
| he_13_15 | long | This column records the number of people aged between 13-15 years in the area. |
| he_16_17 | long | This column records the number of people aged between 16-17 years in the area. |
| he_18_19 | long | This column records the number of people aged between 18-19 years in the area. |
| he_20_24 | long | This column captures the number of people aged between 20-24 years in the area. |
| he_25_29 | long | This column records the number of people aged between 25-29 years in the area. |
| he_30_34 | long | This column tracks the number of people aged between 30-34 years in the area. |
| he_35_39 | long | This column indicates the number of people aged between 35-39 years in the area. |
| he_3_6 | long | This column records the number of people aged between 3-6 years in the area. |
| he_40_44 | long | This column captures the number of people aged between 40-44 years in the area. |
| he_45_49 | long | This column indicates the number of people aged between 45-49 years in the area. |
| he_50_54 | long | This column records the number of people aged between 50-54 years in the area. |
| he_55_59 | long | This column captures the number of people aged between 55-59 years in the area. |
| he_60_64 | long | This column records the number of people aged between 60-64 years in the area. |
| he_65_69 | long | This column indicates the number of people aged between 65-69 years in the area. |
| he_70_74 | long | This column records the number of people aged between 70-74 years in the area. |
| he_75_79 | long | This column includes the number of people aged between 75-79 years in the area. |
| he_7_12 | long | This column records the number of people aged between 7-12 years in the area. |
| he_80_84 | long | This column captures the number of people aged between 80-84 years in the area. |
| he_85_ | long | This column records the number of people aged 85 years or older in the area. |
| he_kika | long | This column indicates the total number of people in the area. |
| he_miehet | long | This column records the total number of men in the area. |
| he_naiset | long | This column indicates the total number of women in the area. |
| he_vakiy | long | This column records the total population in the area. |
| hr_hy_tul | long | This column provides the number of households with high income in the area. |
| hr_ke_tul | long | This column records the number of households with average income in the area. |
| hr_ktu | double | This column captures the average gross income of households in the area. |
| hr_mtu | double | This column records the median income of households in the area. |
| hr_ovy | double | This column provides the total income of households in the area. |
| hr_pi_tul | long | This column records the number of households with low income in the area. |
| hr_tuy | long | This column captures the total number of households in the area. |
| ko_al_kork | long | This column records the number of people with low level of education in the area. |
| ko_ammat | long | This column indicates the number of people with vocational education in the area. |
| ko_ika18y | long | This column records the number of people aged 18 years or older in the area. |
| ko_koul | long | This column captures the number of people with secondary education in the area. |
| ko_perus | long | This column records the number of people with primary education in the area. |
| ko_yl_kork | double | This column indicates the number of people with high level of education in the area. |
| ko_yliop | long | This column records the number of people with university education in the area. |
| kunta | string | This column contains the municipality code of the area. |
| namn | string | This column contains the name of the area. |
| nimi | string | This column records the Finnish name of the area. |
| objectid | long | This column provides a unique identifier for each row. |
| pinta_ala | double | This column records the surface area of the geographical location. |
| posti_alue | string | This column contains the postal code of the area. |
| pt_0_14 | long | This column records the number of people aged between 0-14 years in the area. |
| pt_elakel | long | This column indicates the number of retirees in the area. |
| pt_muut | long | This column records the number of other people in the area. |
| pt_opisk | long | This column captures the number of students in the area. |
| pt_tyoll | long | This column records the number of employed people in the area. |
| pt_tyott | long | This column indicates the number of unemployed people in the area. |
| pt_vakiy | double | This column records the total population in the area. |
| ra_as_kpa | double | This column captures the average size of dwellings in the area. |
| ra_asrak | long | This column records the number of residential buildings in the area. |
| ra_asunn | long | This column indicates the number of dwellings in the area. |
| ra_ke | long | This column provides the number of summer cottages in the area. |
| ra_kt_as | long | This column records the number of detached houses in the area. |
| ra_muut | long | This column indicates the number of other buildings in the area. |
| ra_pt_as | long | This column records the number of dwellings in the area. |
| ra_raky | long | This column captures the total number of buildings in the area. |
| te_aik | long | This column records the number of adults in the area. |
| te_aklap | long | This column indicates the number of working-age adults in the area. |
| te_as_valj | double | This column provides the percentage of vacancies in the area. |
| te_eil_np | long | This column records the number of non-working-age adults in the area. |
| te_elak | double | This column indicates the number of retirees in the area. |
| te_klap | long | This column records the number of working-age children in the area. |
| te_laps | long | This column captures the number of children in the area. |
| te_muu_as | long | This column records the number of other residential buildings in the area. |
| te_nuor | long | This column indicates the number of young people in the area. |
| te_omis_as | long | This column records the number of owner-occupied dwellings in the area. |
| te_plap | long | This column captures the number of working-age adults with children in the area. |
| te_takk | double | This column provides the average size of households in the area. |
| te_taly | long | This column records the total number of households in the area. |
| te_teini | long | This column indicates the number of teenagers in the area. |
| te_vuok_as | long | This column records the number of rented dwellings in the area. |
| tp_a_maat | long | This column captures the number of people working in the agriculture sector in the area. |
| tp_alku_a | long | This column records the number of people working in the primary sector in the area. |
| tp_b_kaiv | long | This column indicates the number of people working in the mining industry in the area. |
| tp_c_teol | long | This column records the number of people working in the manufacturing industry in the area. |
| tp_d_ener | long | This column captures the number of people working in the energy sector in the area. |
| tp_e_vesi | long | This column indicates the number of people working in the water supply and waste management sector in the area. |
| tp_f_rake | long | This column records the number of people working in the construction sector in the area. |
| tp_g_kaup | long | This column captures the number of people working in the trade sector in the area. |
| tp_h_kulj | long | This column indicates the number of people working in the transport sector in the area. |
| tp_i_majo | long | This column records the number of people working in the accommodation and food service activities sector in the area. |
| tp_j_info | long | This column captures the number of people working in the information and communication sector in the area. |
| tp_jalo_bf | long | This column indicates the number of people working in the other service activities sector in the area. |
| tp_k_raho | long | This column records the number of people working in the financial and insurance activities sector in the area. |
| tp_l_kiin | long | This column captures the number of people working in the real estate activities sector in the area. |
| tp_m_erik | long | This column indicates the number of people working in the professional, scientific and technical activities sector in the area. |
| tp_n_hall | long | This column records the number of people working in the administrative and support service activities sector in the area. |
| tp_o_julk | long | This column captures the number of people working in the public administration and defense sector in the area. |
| tp_p_koul | long | This column indicates the number of people working in the education sector in the area. |
| tp_palv_gu | long | This column records the number of people working in the other activities sector in the area. |
| tp_q_terv | long | This column captures the number of people working in the human health and social work activities sector in the area. |
| tp_r_taid | long | This column indicates the number of people working in the arts, entertainment and recreation sector in the area. |
| tp_s_muup | long | This column records the number of people working in the other services sector in the area. |
| tp_t_koti | long | This column captures the number of people working in the activities of households as employers sector in the area. |
| tp_tyopy | long | This column records the total number of people working in the area. |
| tp_u_kans | long | This column indicates the number of people working in the activities of extraterritorial organizations and bodies sector in the area. |
| tp_x_tunt | long | This column records the number of people working in the unknown activities sector in the area. |
| tr_hy_tul | long | This column captures the number of households with high income in the area. |
| tr_ke_tul | long | This column records the number of households with average income in the area. |
| tr_ktu | double | This column provides the average gross income of households in the area. |
| tr_kuty | long | This column indicates the total number of households in the area. |
| tr_mtu | double | This column records the median income of households in the area. |
| tr_ovy | double | This column captures the total income of households in the area. |
| tr_pi_tul | long | This column records the number of households with low income in the area. |
| vuosi | long | This column records the year of the data. |
Additional Info
| Last Updated | November 12, 2024 |
|---|---|
| Created | November 11, 2024 |