2018 Version History of Paavo Statistical Data and Postal Code Areas
The 'table__history' forms an integral part of the 'postialue_pno_tilasto_2018' dataset collection. This particular table is a history table that retains the version history of its base table rows, providing a detailed chronological record of changes. This makes it invaluable for tracking data evolution over time.
The table compiles a rich array of data fields, covering aspects such as demographic statistics, geographic information, socio-economic indicators, and more. For example, it tracks the population distribution by age groups, gender, and marital status. This demographic information could be used in market research to understand the primary consumer base in a given area.
Moreover, the table includes geographic data fields that are crucial for spatial analytics. These fields contain geographic coordinates presented using the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude. By analyzing these geographic data fields, one could, for instance, visualize the dispersion of population or socio-economic indicators across different regions, aiding in urban planning or resource allocation tasks.
The table also integrates socio-economic indicators which could be instrumental in social research and policy-making. By analyzing these indicators, one could gain insights into the average income levels, employment rates, or housing conditions in different regions, helping to identify areas of social inequality or economic hardship.
In terms of data management, the table includes special columns like '_start_date', '_end_date', and '_row_number' that manage version history. The '_start_date' column indicates when the row was extracted from the data source, while '_end_date' shows when a new version of the row was extracted. If the '_end_date' is null, it signifies that the row is the most recent version. The '_row_number' column contains the row's unique identifier within the raw data.
The data in this table is sourced from 'Tilastokeskus' (Statistics Finland) in Finland. It offers valuable demographic, socio-economic, and geographic data, making it a powerful tool for data analytics in various fields, from market research to urban planning and social policy-making.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | The date when the row was extracted from the data source, marking the beginning of the version for the respective row in the history table. |
| _end_date | date | The date when a new version of the row was extracted from the data source, marking the end of the version for the respective row in the history table. A null value indicates the most recent version of the row. |
| _row_number | long | The number of the row in the raw data extracted from the data source. Together with '_start_date', it forms a unique identifier for each row in this version history table. |
| euref_x | double | The x-coordinate of the geographic location in the EUREF-FIN coordinate system. |
| euref_y | double | The y-coordinate of the geographic location in the EUREF-FIN coordinate system. |
| geom_geojson | string | The geographic boundaries of the area represented as GeoJSON, a format for encoding geographic data structures. |
| geom_geotext | string | The geographic boundaries of the area represented as text. |
| geom_type | string | The type of the geographic object, in this case, a multi-polygon. |
| geom_centroid | string | The geographic point at the center of the area, represented as a point. |
| geom_center_x | double | The x-coordinate of the center point of the area. |
| geom_center_y | double | The y-coordinate of the center point of the area. |
| gml_id | string | The unique identifier of the row in the GML data format. |
| he_0_2 | long | The number of children aged between 0 to 2 years in the area. |
| he_13_15 | long | The number of teenagers aged between 13 to 15 years in the area. |
| he_16_17 | long | The number of teenagers aged between 16 to 17 years in the area. |
| he_18_19 | long | The number of young adults aged between 18 to 19 years in the area. |
| he_20_24 | long | The number of adults aged between 20 to 24 years in the area. |
| he_25_29 | long | The number of adults aged between 25 to 29 years in the area. |
| he_30_34 | long | The number of adults aged between 30 to 34 years in the area. |
| he_35_39 | long | The number of adults aged between 35 to 39 years in the area. |
| he_3_6 | long | The number of children aged between 3 to 6 years in the area. |
| he_40_44 | long | The number of adults aged between 40 to 44 years in the area. |
| he_45_49 | long | The number of adults aged between 45 to 49 years in the area. |
| he_50_54 | long | The number of adults aged between 50 to 54 years in the area. |
| he_55_59 | long | The number of adults aged between 55 to 59 years in the area. |
| he_60_64 | long | The number of adults aged between 60 to 64 years in the area. |
| he_65_69 | long | The number of adults aged between 65 to 69 years in the area. |
| he_70_74 | long | The number of adults aged between 70 to 74 years in the area. |
| he_75_79 | long | The number of adults aged between 75 to 79 years in the area. |
| he_7_12 | long | The number of children aged between 7 to 12 years in the area. |
| he_80_84 | long | The number of adults aged between 80 to 84 years in the area. |
| he_85_ | long | The number of adults aged 85 years and above in the area. |
| he_kika | long | The number of people with immigrant background in the area. |
| he_miehet | long | The number of males in the area. |
| he_naiset | long | The number of females in the area. |
| he_vakiy | long | The total population in the area. |
| hr_hy_tul | long | The number of households with high income in the area. |
| hr_ke_tul | long | The number of households with average income in the area. |
| hr_ktu | double | The average gross income of households in the area. |
| hr_mtu | double | The median gross income of households in the area. |
| hr_ovy | double | The total income of households in the area. |
| hr_pi_tul | long | The number of households with low income in the area. |
| hr_tuy | long | The total number of households in the area. |
| ko_al_kork | long | The number of people with lower secondary education in the area. |
| ko_ammat | long | The number of people with vocational qualification in the area. |
| ko_ika18y | long | The number of people aged 18 years and above in the area. |
| ko_koul | long | The number of people with upper secondary education in the area. |
| ko_perus | long | The number of people with basic education in the area. |
| ko_yl_kork | double | The number of people with higher education (lower level) in the area. |
| ko_yliop | long | The number of people with university or other higher education in the area. |
| kunta | string | The code of the municipality where the area is located. |
| namn | string | The name of the area in Swedish. |
| nimi | string | The name of the area in Finnish. |
| objectid | long | The unique identifier of the row in the object database. |
| pinta_ala | double | The surface area of the area in square meters. |
| posti_alue | string | The postal code of the area. |
| pt_0_14 | long | The number of people aged between 0 to 14 years in the area. |
| pt_elakel | long | The number of pensioners in the area. |
| pt_muut | long | The number of people in other life situations (not working, studying, or on pension) in the area. |
| pt_opisk | long | The number of students in the area. |
| pt_tyoll | long | The number of employed people in the area. |
| pt_tyott | long | The number of unemployed people in the area. |
| pt_tyovu | long | The total workforce in the area. |
| pt_tyovy | long | The total number of people of working age in the area. |
| pt_vakiy | double | The total population of the area. |
| ra_as_kpa | double | The average size of apartments in the area in square meters. |
| ra_asrak | long | The number of residential buildings in the area. |
| ra_asunn | long | The total number of apartments in the area. |
| ra_ke | long | The number of apartments in residential buildings in the area. |
| ra_kt_as | long | The number of apartments in blocks of flats in the area. |
| ra_muut | long | The number of other buildings in the area. |
| ra_pt_as | long | The number of apartments in detached houses in the area. |
| ra_raky | long | The total number of buildings in the area. |
| te_aik | long | The number of adults in the area. |
| te_aklap | long | The number of households with one adult and children in the area. |
| te_as_valj | double | The percentage of people living alone in the area. |
| te_eil_np | long | The number of households with one adult, no children in the area. |
| te_elak | double | The number of pensioners in the area. |
| te_klap | long | The number of households with two adults and children in the area. |
| te_laps | long | The number of children in the area. |
| te_muu_as | long | The number of people living in other types of households in the area. |
| te_nuor | long | The number of young people in the area. |
| te_omis_as | long | The number of owner-occupied apartments in the area. |
| te_plap | long | The number of households with single parents in the area. |
| te_takk | double | The average size of households in the area. |
| te_taly | long | The total number of households in the area. |
| te_teini | long | The number of teenagers in the area. |
| te_vuok_as | long | The number of rented apartments in the area. |
| tp_a_maat | long | The number of people working in agriculture, forestry and fishing in the area. |
| tp_alku_a | long | The number of people working in primary industries in the area. |
| tp_b_kaiv | long | The number of people working in mining and quarrying in the area. |
| tp_c_teol | long | The number of people working in manufacturing in the area. |
| tp_d_ener | long | The number of people working in electricity, gas, steam and air conditioning supply in the area. |
| tp_e_vesi | long | The number of people working in water supply, sewerage, waste management and remediation activities in the area. |
| tp_f_rake | long | The number of people working in construction in the area. |
| tp_g_kaup | long | The number of people working in wholesale and retail trade, repair of motor vehicles and motorcycles in the area. |
| tp_h_kulj | long | The number of people working in transportation and storage in the area. |
| tp_i_majo | long | The number of people working in accommodation and food service activities in the area. |
| tp_j_info | long | The number of people working in information and communication in the area. |
| tp_jalo_bf | long | The number of people working in finance and insurance activities in the area. |
| tp_k_raho | long | The number of people working in real estate activities in the area. |
| tp_l_kiin | long | The number of people working in professional, scientific and technical activities in the area. |
| tp_m_erik | long | The number of people working in administrative and support service activities in the area. |
| tp_n_hall | long | The number of people working in public administration and defence, compulsory social security in the area. |
| tp_o_julk | long | The number of people working in education in the area. |
| tp_p_koul | long | The number of people working in human health and social work activities in the area. |
| tp_palv_gu | long | The number of people working in other service activities in the area. |
| tp_q_terv | long | The number of people working in arts, entertainment and recreation in the area. |
| tp_r_taid | long | The number of people working in other service activities in the area. |
| tp_s_muup | long | The number of people working in activities of households as employers; undifferentiated goods- and services-producing activities of households for own use in the area. |
| tp_t_koti | long | The number of people working in activities of extraterritorial organizations and bodies in the area. |
| tp_tyopy | long | The total number of employed persons in the area. |
| tp_u_kans | long | The number of people working in extraterritorial organizations and bodies in the area. |
| tp_x_tunt | long | The number of people working in activities not adequately defined in the area. |
| tr_hy_tul | long | The number of taxpayers with high income in the area. |
| tr_ke_tul | long | The number of taxpayers with average income in the area. |
| tr_ktu | double | The average gross income of taxpayers in the area. |
| tr_kuty | long | The total number of taxpayers in the area. |
| tr_mtu | double | The median gross income of taxpayers in the area. |
| tr_ovy | double | The total income of taxpayers in the area. |
| tr_pi_tul | long | The number of taxpayers with low income in the area. |
| vuosi | long | The year 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 | 99d60e1c-578a-4a8c-ad4f-69c2ed9aba66 |
| Package id | 92d0fe7e-b1a0-458a-ad8d-c5642db50681 |
| Position | 1 |
| Revision id | 993019db-bb6b-4c0d-a695-1823e646f291 |
| State | active |
| Table | postialue_pno_tilasto_2018__table__history |