Version History of Paavo Statistical Data and Postal Code Areas 2017
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 geospatial data. This data is presented using the WGS 84 coordinate reference system, allowing for in-depth geographic analysis and visualizations.
In terms of demographic data, the table includes columns such as age groups, gender, and population count. There are also columns that record economic data like average income, housing statistics, and employment status.
The table's wide array of columns makes it a valuable resource for a variety of data analytics applications. For instance, one could analyze demographic trends over time, track changes in economic indicators, or perform geospatial analysis to understand regional variations. Additionally, the table can support the study of correlations between different factors such as income levels and housing statistics or age demographics and employment status.
In conclusion, the 'table__history' is a comprehensive and versatile table that provides a historical perspective on a wide range of demographic, economic, and geospatial data. Its depth and breadth of data points make it a valuable asset for a variety of data analytics applications.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _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. |
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 | add0c25d-51a4-41dc-890b-da25c13386d5 |
| Package id | 4fb31ec2-9689-41d0-bb05-eea108f1f262 |
| Position | 1 |
| Revision id | 57f7b46e-4418-409e-b09c-9d53db4f3a51 |
| State | active |
| Table | postialue_pno_tilasto_2017__table__history |