Statistical Dataset and Postal Code Areas 2017
The table forms part of a dataset collection that is compiled of related data tables. This specific table contains a wealth of data pulled from the Finnish Statistics Bureau's (Tilastokeskus) website. The contents of the table are a result of the Paavo-statistical database and postal code areas for the year 2017. It provides a comprehensive dataset that covers a broad range of demographic, geographical, and statistical data.
The table includes numerous columns, each representing different metrics or aspects of the data. For example, one can find data related to population segmentation, geographical coordinates, income brackets, and even specific details such as the number of women and men within each postal area.
Notably, this table includes several special columns. The 'extract_date' column contains the date when the specific row of data was extracted from the source, while the '_row_number' denotes the unique row number in the data extracted from the source on the specified extract date. Combined, these two columns can be used to uniquely identify each row within the table. The geographic data within the table is contained within columns beginning with 'geom', and these can be utilized for geospatial data analytics, with the coordinates provided in the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude.
This table can be leveraged in multiple ways in the realm of data analytics. For example, it could be used to study population demographics across different regions in Finland, including age distribution, gender ratio, and income levels. The geographical data could be used to create detailed maps visualizing these statistics across the country. Furthermore, the longitudinal aspect of this data, with the extract date for each row, can be used to study trends over time and make predictions for the future.
This table offers a rich resource for analysts, researchers, policymakers, and businesses wanting to glean insights into various aspects of Finnish society.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _extract_date | date | The date when the data on the row was extracted from the data source. |
| _row_number | long | The row number in the data extracted from the source on the extract date specified by the column '_extract_date'. |
| euref_x | double | The x-coordinate in the EUREF-FIN coordinate system. |
| euref_y | double | The y-coordinate in the EUREF-FIN coordinate system. |
| geom_geojson | string | The geographic data in GeoJSON format. |
| geom_geotext | string | The geographic data in text format. |
| geom_type | string | The type of the geographic data. |
| geom_centroid | string | The centroid of the geographic data. |
| geom_center_x | double | The x-coordinate of the center of the geographic data. |
| geom_center_y | double | The y-coordinate of the center of the geographic data. |
| gml_id | string | The ID in the Geography Markup Language (GML) format. |
| he_0_2 | double | Number of people aged between 0 and 2 years. |
| he_13_15 | double | Number of people aged between 13 and 15 years. |
| he_16_17 | double | Number of people aged between 16 and 17 years. |
| he_18_19 | double | Number of people aged between 18 and 19 years. |
| he_20_24 | double | Number of people aged between 20 and 24 years. |
| he_25_29 | double | Number of people aged between 25 and 29 years. |
| he_30_34 | double | Number of people aged between 30 and 34 years. |
| he_35_39 | double | Number of people aged between 35 and 39 years. |
| he_3_6 | double | Number of people aged between 3 and 6 years. |
| he_40_44 | double | Number of people aged between 40 and 44 years. |
| he_45_49 | double | Number of people aged between 45 and 49 years. |
| he_50_54 | double | Number of people aged between 50 and 54 years. |
| he_55_59 | double | Number of people aged between 55 and 59 years. |
| he_60_64 | double | Number of people aged between 60 and 64 years. |
| he_65_69 | double | Number of people aged between 65 and 69 years. |
| he_70_74 | double | Number of people aged between 70 and 74 years. |
| he_75_79 | double | Number of people aged between 75 and 79 years. |
| he_7_12 | double | Number of people aged between 7 and 12 years. |
| he_80_84 | double | Number of people aged between 80 and 84 years. |
| he_85_ | double | Number of people aged 85 years and over. |
| he_kika | double | Average number of children in a family. |
| he_miehet | double | Number of men. |
| he_naiset | double | Number of women. |
| he_vakiy | double | Total number of inhabitants. |
| hr_hy_tul | double | Number of high income households. |
| hr_ke_tul | double | Number of middle income households. |
| hr_ktu | double | Average total income of households. |
| hr_mtu | double | Median total income of households. |
| hr_ovy | double | Total income of households. |
| hr_pi_tul | double | Number of low income households. |
| hr_tuy | double | Total number of households. |
| ko_al_kork | double | Number of people with lower tertiary education. |
| ko_ammat | double | Number of people with vocational education. |
| ko_ika18y | double | Number of people aged 18 years and over. |
| ko_koul | double | Number of people with secondary education. |
| ko_perus | double | Number of people with primary education. |
| ko_yl_kork | double | Number of people with upper tertiary education. |
| ko_yliop | double | Number of people with university education. |
| kunta | string | Municipality code. |
| namn | string | Name of the area in Swedish. |
| nimi | string | Name of the area in Finnish. |
| pinta_ala | double | Area of the region in square meters. |
| posti_alue | string | Postal code area. |
| pt_0_14 | double | Number of people aged between 0 and 14 years. |
| pt_elakel | double | Number of pensioners. |
| pt_muut | double | Number of other non-employed people. |
| pt_opisk | double | Number of students. |
| pt_tyoll | double | Number of employed people. |
| pt_tyott | double | Number of unemployed people. |
| pt_tyovu | double | Number of people in the working-age population. |
| pt_tyovy | double | Number of people in the labour force. |
| pt_vakiy | double | Total number of inhabitants aged 15 or over. |
| ra_as_kpa | double | Number of private houses per km2. |
| ra_asrak | double | Number of residential buildings. |
| ra_asunn | double | Number of dwellings. |
| ra_ke | double | Number of vacant dwellings. |
| ra_kt_as | double | Number of dwellings in blocks of flats. |
| ra_muut | double | Number of other buildings. |
| ra_pt_as | double | Number of dwellings in detached houses. |
| ra_raky | double | Number of buildings. |
| te_aik | double | Number of adults. |
| te_aklap | double | Number of families with children and adults. |
| te_as_valj | double | Percentage of dwellings that are vacant. |
| te_eil_np | double | Number of single-parent families. |
| te_elak | double | Number of pensioners. |
| te_klap | double | Number of families with children. |
| te_laps | double | Number of children. |
| te_muu_as | double | Number of other dwellings. |
| te_nuor | double | Number of people aged between 0 and 14 years. |
| te_omis_as | double | Number of owner-occupied dwellings. |
| te_plap | double | Number of single-child families. |
| te_takk | double | Average size of the dwelling. |
| te_taly | double | Total number of households. |
| te_teini | double | Number of teenagers. |
| te_vuok_as | double | Number of rented dwellings. |
| tp_a_maat | double | Number of people working in the agriculture, forestry and fishing sector. |
| tp_alku_a | double | Number of people working in the primary sector. |
| tp_b_kaiv | double | Number of people working in the mining and quarrying sector. |
| tp_c_teol | double | Number of people working in the manufacturing sector. |
| tp_d_ener | double | Number of people working in the energy supply sector. |
| tp_e_vesi | double | Number of people working in the water supply, sewerage and waste management sector. |
| tp_f_rake | double | Number of people working in the construction sector. |
| tp_g_kaup | double | Number of people working in the wholesale and retail trade sector. |
| tp_h_kulj | double | Number of people working in the transportation and storage sector. |
| tp_i_majo | double | Number of people working in the accommodation and food service sector. |
| tp_j_info | double | Number of people working in the information and communication sector. |
| tp_jalo_bf | double | Number of people working in the other service sector. |
| tp_k_raho | double | Number of people working in the financial and insurance activities sector. |
| tp_l_kiin | double | Number of people working in the real estate activities sector. |
| tp_m_erik | double | Number of people working in the professional, scientific and technical activities sector. |
| tp_n_hall | double | Number of people working in the administrative and support service activities sector. |
| tp_o_julk | double | Number of people working in the public administration and defence sector. |
| tp_p_koul | double | Number of people working in the education sector. |
| tp_palv_gu | double | Number of people working in the other service activities sector. |
| tp_q_terv | double | Number of people working in the human health and social work activities sector. |
| tp_r_taid | double | Number of people working in the arts, entertainment and recreation sector. |
| tp_s_muup | double | Number of people working in other service activities. |
| tp_t_koti | double | Number of people working in activities of households as employers. |
| tp_tyopy | double | Total number of jobs. |
| tp_u_kans | double | Number of people working in activities of extraterritorial organizations and bodies. |
| tp_x_tunt | double | Number of people working in not known or unspecified activities. |
| tr_hy_tul | double | Number of high income taxpayers. |
| tr_ke_tul | double | Number of middle income taxpayers. |
| tr_ktu | double | Average total income of taxpayers. |
| tr_kuty | double | Number of taxpayers. |
| tr_mtu | double | Median total income of taxpayers. |
| tr_ovy | double | Total income of taxpayers. |
| tr_pi_tul | double | Number of low income taxpayers. |
| vuosi | double | 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 | fbccb67f-2e2e-4822-bf7a-f2d52e84d9d1 |
| Package id | 4fb31ec2-9689-41d0-bb05-eea108f1f262 |
| Revision id | 622bd3d6-f8b8-460e-ba42-42434ba65d2e |
| State | active |
| Table | postialue_pno_tilasto_2017__table |