Version History of Paavo Statistical Data and Postal Code Areas 2023
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 and mapping purposes.
Particularly notable is the table's ability to track changes over time. Each entry in the table is uniquely identified by a combination of the date when the row was extracted and the row number. This allows for precise tracking of changes and provides the ability to analyze trends over time, an invaluable resource for historical comparisons and trend analysis.
The table also captures economic data, including income levels and employment status, providing a snapshot of the economic landscape in different areas. Other specialized columns hold data related to housing, education, and various industries, painting a comprehensive picture of the socio-economic conditions.
The usefulness of this table is vast. For instance, demographic data could be employed to understand population trends or to plan public services in different areas. The geospatial data could be utilized for geographical mapping or spatial analysis. Economic data could be used to study income disparities or employment trends. Moreover, by analyzing the version history, analysts can spot temporal trends, changes, and anomalies, which can inform a wide array of decisions and policies.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _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. |
No sample for this dataset
Additional Information
| Last updated | November 11, 2024 |
|---|---|
| Created | November 11, 2024 |
| License | No License Provided |
| Geographic coverage | |
| Geographic granularity | |
| Temporal coverage from | |
| Temporal coverage to | |
| Temporal coverage to | |
| Country | fi |
| Database | fi_tilastokeskus |
| Extract date | 2024-11-11 |
| Id | 99cc7b32-6f26-4744-8ccd-ba52573a47f5 |
| Package id | efa44985-6cb9-46a3-a01a-da5dc43335ca |
| Position | 1 |
| Revision id | 66ab6544-9fff-48d2-9849-79431fb44bce |
| State | active |
| Table | postialue_pno_tilasto_2023__table__history |