2022 History of Paavo Statistical Data and Postal Code Regions
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 coordinate reference system, where axis order is longitude first, followed by latitude.
In addition to the geographic data, the table includes a wealth of demographic and statistical information. There are columns that specify the number of males and females in a given area, the number of people in various age groups, and much more. This rich demographic data could be invaluable in a number of data analytics applications, such as population studies, urban planning, or market research.
The table also includes a set of unique columns '_start_date', '_end_date' and '_row_number' which are instrumental in tracking changes in the data over time. These columns indicate when the row was extracted from the data source, and in the case of the '_end_date' column, when a new version of the row was extracted. If the '_end_date' is null, that means the row is the most recent version.
This table could be utilized in various ways in data analytics. For instance, the geographic coordinates could be used to create detailed maps of population distribution in Finland. The demographic data could be analyzed to identify trends in age distribution, or to inform marketing strategies. The version history could be used to track changes in these trends over time. Overall, this table is a robust resource for anyone seeking to analyze demographic or geographic data related to Finland.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _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. |
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 | c9547449-727a-423a-bb3c-8109ed9b94c9 |
| Package id | a75cd732-24e7-4708-afe3-0235dcc50685 |
| Position | 1 |
| Revision id | 24d452e5-f6e5-473f-999c-6b49a4b7beb3 |
| State | active |
| Table | postialue_pno_tilasto_2022__table__history |