Statistical Data and Postal Area Information - Finland
The table under discussion is a part of a larger dataset collection that holds related data tables. This particular table contains an extensive range of data columns, each with a unique name and holding specific information. The data within the table is organized in a systematic manner, with rows and columns forming an interconnected network of information.
The table encompasses a variety of data, including demographic information, geographic coordinates, and numerous other statistics. This makes it a comprehensive resource for various data analytics tasks. For instance, it includes columns holding data about the age distribution of a population, gender distribution, and other demographic data. This can be utilized in demographic studies and population analytics.
The table also contains geographic data, including information encoded using the WGS 84 coordinate reference system (longitude first, followed by latitude). This geospatial data is stored in columns that begin with 'geom_', making it a valuable resource for geospatial data analytics. For example, the data can be used to analyze population distribution across various geographical regions.
In addition to this, the table includes two special columns, '_extract_date' and '_row_number'. The '_extract_date' column contains the date when the data was extracted from the source, while the '_row_number' indicates the row number of the extracted data. The combination of these two columns uniquely identifies each row, providing a reliable reference system for the data.
According to the data source, the table contents are described as 'Paavo-tilastoaineisto ja -postinumeroalueet', which translates to 'Paavo statistical data and postal code areas'. This indicates that the table includes postal area-specific statistical data, making it a useful tool for location-specific analytics. For instance, the data can be used to analyze trends and patterns within specific postal areas.
The table is sourced from the website 'Tilastokeskus' (Statistics Finland) in Finland. It is important to note that the data content of the table is subject to the accuracy of the data provided by the source.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _extract_date | date | This column indicates the date at which the data row was extracted from the data source. |
| _row_number | long | This column corresponds to the row number of the data extracted from the source on the extraction date specified by the '_extract_date' column. Together, these two columns uniquely identify each row. |
| euref_x | long | This column represents the X coordinate in the EUREF-FIN coordinate system. |
| euref_y | long | This column represents the Y coordinate in the EUREF-FIN coordinate system. |
| geom_geojson | string | This column contains the geometrical data of the postal area represented in GeoJSON format. |
| geom_geotext | string | This column contains the geometrical data of the postal area represented in text format. |
| geom_type | string | This column represents the type of geometrical data stored in the 'geom_geojson' and 'geom_geotext' columns. |
| geom_centroid | string | This column contains the coordinates of the centroid of the postal area. |
| geom_center_x | double | This column represents the X coordinate of the center of the postal area. |
| geom_center_y | double | This column represents the Y coordinate of the center of the postal area. |
| gml_id | string | This column contains the unique identifier of the postal area in GML format. |
| he_0_2 | long | This column represents the number of children aged between 0 and 2 years in the postal area. |
| he_13_15 | long | This column represents the number of teenagers aged between 13 and 15 years in the postal area. |
| he_16_17 | long | This column represents the number of teenagers aged between 16 and 17 years in the postal area. |
| he_18_19 | long | This column represents the number of young adults aged between 18 and 19 years in the postal area. |
| he_20_24 | long | This column represents the number of young adults aged between 20 and 24 years in the postal area. |
| he_25_29 | long | This column represents the number of adults aged between 25 and 29 years in the postal area. |
| he_30_34 | long | This column represents the number of adults aged between 30 and 34 years in the postal area. |
| he_35_39 | long | This column represents the number of adults aged between 35 and 39 years in the postal area. |
| he_3_6 | long | This column represents the number of children aged between 3 and 6 years in the postal area. |
| he_40_44 | long | This column represents the number of adults aged between 40 and 44 years in the postal area. |
| he_45_49 | long | This column represents the number of adults aged between 45 and 49 years in the postal area. |
| he_50_54 | long | This column represents the number of adults aged between 50 and 54 years in the postal area. |
| he_55_59 | long | This column represents the number of adults aged between 55 and 59 years in the postal area. |
| he_60_64 | long | This column represents the number of adults aged between 60 and 64 years in the postal area. |
| he_65_69 | long | This column represents the number of elderly people aged between 65 and 69 years in the postal area. |
| he_70_74 | long | This column represents the number of elderly people aged between 70 and 74 years in the postal area. |
| he_75_79 | long | This column represents the number of elderly people aged between 75 and 79 years in the postal area. |
| he_7_12 | long | This column represents the number of children aged between 7 and 12 years in the postal area. |
| he_80_84 | long | This column represents the number of elderly people aged between 80 and 84 years in the postal area. |
| he_85_ | long | This column represents the number of elderly people aged 85 years and more in the postal area. |
| he_kika | long | This column represents the average size of households in the postal area. |
| he_miehet | long | This column represents the number of men in the postal area. |
| he_naiset | long | This column represents the number of women in the postal area. |
| he_vakiy | long | This column represents the total population in the postal area. |
| hr_hy_tul | long | This column represents the number of households in the high income bracket in the postal area. |
| hr_ke_tul | long | This column represents the number of households in the medium income bracket in the postal area. |
| hr_ktu | long | This column represents the average gross income of households in the postal area. |
| hr_mtu | long | This column represents the median gross income of households in the postal area. |
| hr_ovy | long | This column represents the total income of all households in the postal area. |
| hr_pi_tul | long | This column represents the number of households in the low income bracket in the postal area. |
| hr_tuy | long | This column represents the total number of households in the postal area. |
| ko_al_kork | long | This column represents the number of people in the postal area with a lower secondary education. |
| ko_ammat | long | This column represents the number of people in the postal area with a vocational qualification. |
| ko_ika18y | long | This column represents the number of people aged 18 years or more in the postal area. |
| ko_koul | long | This column represents the number of people in the postal area with at least a secondary education. |
| ko_perus | long | This column represents the number of people in the postal area with a comprehensive school education. |
| ko_yl_kork | long | This column represents the number of people in the postal area with a higher tertiary education (Licentiate or Doctorate degree). |
| ko_yliop | long | This column represents the number of people in the postal area with a lower tertiary education (Bachelor's or Master's degree). |
| kunta | string | This column represents the code of the municipality where the postal area is located. |
| namn | string | This column represents the Swedish name of the postal area. |
| nimi | string | This column represents the Finnish name of the postal area. |
| pinta_ala | long | This column represents the total area (in square meters) of the postal area. |
| postinumeroalue | string | This column represents the postal code of the area. |
| pt_0_14 | long | This column represents the number of people aged between 0 and 14 years in the postal area. |
| pt_elakel | long | This column represents the number of pensioners in the postal area. |
| pt_muut | long | This column represents the number of people in the postal area who are not in the labor force nor students nor pensioners. |
| pt_opisk | long | This column represents the number of students in the postal area. |
| pt_tyoll | long | This column represents the number of employed people in the postal area. |
| pt_tyott | long | This column represents the number of unemployed people in the postal area. |
| pt_vakiy | long | This column represents the total population aged 15 years or more in the postal area. |
| ra_as_kpa | double | This column represents the average price per square meter of dwellings in the postal area. |
| ra_asrak | long | This column represents the number of dwellings in the postal area. |
| ra_asunn | long | This column represents the number of occupied dwellings in the postal area. |
| ra_ke | long | This column represents the number of buildings in the postal area. |
| ra_kt_as | long | This column represents the number of terraced houses in the postal area. |
| ra_muu_as | long | This column represents the number of other types of dwellings in the postal area. |
| ra_muut | long | This column represents the number of other types of buildings in the postal area. |
| ra_pt_as | long | This column represents the number of apartment buildings in the postal area. |
| ra_raky | long | This column represents the total floor area of buildings in the postal area. |
| te_aik | long | This column represents the number of households in the postal area consisting of a single adult. |
| te_aklap | long | This column represents the number of households in the postal area consisting of a single adult with children. |
| te_as_valj | double | This column represents the average number of rooms in dwellings in the postal area. |
| te_eil_np | long | This column represents the number of households in the postal area consisting of a couple without children. |
| te_elak | long | This column represents the number of households in the postal area consisting of pensioners. |
| te_klap | long | This column represents the number of households in the postal area consisting of a couple with children. |
| te_laps | long | This column represents the number of households in the postal area consisting of a single parent with children. |
| te_muu_as | long | This column represents the number of households in the postal area consisting of other types of dwellings. |
| te_nuor | long | This column represents the number of households in the postal area consisting of young adults. |
| te_omis_as | long | This column represents the number of owner-occupied dwellings in the postal area. |
| te_plap | long | This column represents the number of households in the postal area consisting of a single parent with adolescent children. |
| te_takk | double | This column represents the average size of dwellings in the postal area. |
| te_taly | long | This column represents the total number of households in the postal area. |
| te_teini | long | This column represents the number of households in the postal area consisting of teenagers. |
| te_vuok_as | long | This column represents the number of rented dwellings in the postal area. |
| te_yhlap | long | This column represents the number of households in the postal area consisting of a single adult with adolescent children. |
| te_yks | long | This column represents the number of households in the postal area consisting of a single person. |
| tp_a_maat | long | This column represents the number of jobs in the postal area in the 'Agriculture, forestry and fishing' sector. |
| tp_alku_a | long | This column represents the number of jobs in the postal area in the 'Primary sector'. |
| tp_b_kaiv | long | This column represents the number of jobs in the postal area in the 'Mining and quarrying' sector. |
| tp_c_teol | long | This column represents the number of jobs in the postal area in the 'Manufacturing' sector. |
| tp_d_ener | long | This column represents the number of jobs in the postal area in the 'Electricity, gas, steam and air conditioning supply' sector. |
| tp_e_vesi | long | This column represents the number of jobs in the postal area in the 'Water supply; sewerage, waste management and remediation activities' sector. |
| tp_f_rake | long | This column represents the number of jobs in the postal area in the 'Construction' sector. |
| tp_g_kaup | long | This column represents the number of jobs in the postal area in the 'Wholesale and retail trade; repair of motor vehicles and motorcycles' sector. |
| tp_h_kulj | long | This column represents the number of jobs in the postal area in the 'Transportation and storage' sector. |
| tp_i_majo | long | This column represents the number of jobs in the postal area in the 'Accommodation and food service activities' sector. |
| tp_j_info | long | This column represents the number of jobs in the postal area in the 'Information and communication' sector. |
| tp_jalo_bf | long | This column represents the number of jobs in the postal area in the 'Secondary sector'. |
| tp_k_raho | long | This column represents the number of jobs in the postal area in the 'Financial and insurance activities' sector. |
| tp_l_kiin | long | This column represents the number of jobs in the postal area in the 'Real estate activities' sector. |
| tp_m_erik | long | This column represents the number of jobs in the postal area in the 'Professional, scientific and technical activities' sector. |
| tp_n_hall | long | This column represents the number of jobs in the postal area in the 'Administrative and support service activities' sector. |
| tp_o_julk | long | This column represents the number of jobs in the postal area in the 'Public administration and defense; compulsory social security' sector. |
| tp_p_koul | long | This column represents the number of jobs in the postal area in the 'Education' sector. |
| tp_palv_gu | long | This column represents the number of jobs in the postal area in the 'Tertiary sector'. |
| tp_q_terv | long | This column represents the number of jobs in the postal area in the 'Human health and social work activities' sector. |
| tp_r_taid | long | This column represents the number of jobs in the postal area in the 'Arts, entertainment and recreation' sector. |
| tp_s_muup | long | This column represents the number of jobs in the postal area in the 'Other service activities' sector. |
| tp_t_koti | long | This column represents the number of jobs in the postal area in the 'Activities of households as employers; undifferentiated goods- and services-producing activities of households for own use' sector. |
| tp_tyopy | long | This column represents the total number of jobs in the postal area. |
| tp_u_kans | long | This column represents the number of jobs in the postal area in the 'Activities of extraterritorial organizations and bodies' sector. |
| tp_x_tunt | long | Column description not available |
| tr_hy_tul | long | This column represents the number of taxpayers in the postal area in the high income bracket. |
| tr_ke_tul | long | This column represents the number of taxpayers in the postal area in the medium income bracket. |
| tr_ktu | long | This column represents the average gross income of taxpayers in the postal area. |
| tr_kuty | long | Column description not available |
| tr_mtu | long | This column represents the median gross income of taxpayers in the postal area. |
| tr_ovy | long | This column represents the total income of all taxpayers in the postal area. |
| tr_pi_tul | long | This column represents the number of taxpayers in the postal area in the low income bracket. |
| vuosi | long | This column represents 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 | 14ee0b42-29e9-4b14-a113-a1ba6ca8ae93 |
| Package id | d603ae20-cd88-4450-a128-d9d2b599e423 |
| Revision id | e2baaf02-bc37-4161-bf23-3b700ce3aac7 |
| State | active |
| Table | postialue_pno_tilasto__table |