Postal Area Statistics and Postal Code Regions 2015 Dataset Table
The table, which is part of the 'postialue_pno_tilasto_2015' dataset collection, is a rich source of demography and geo-spatial data. It comes from the Finnish website 'Tilastokeskus' (Statistics Finland). The table incorporates various aspects including geographical coordinates, demographic distributions, and economic indicators among others. The contents of the table are based on the Paavo statistical datasets and postal code areas for the year 2015.
Two special columns, '_extract_date' and '_row_number', are included in the table. The '_extract_date' marks the date of data extraction from the source, while the '_row_number' represents the row number in the data extracted from the source on that particular extract date. These two columns combine to uniquely identify each row.
The columns that start with 'geom_' contain geographic information which can be useful for geospatial data analytics. These geographic coordinates follow the WGS 84 coordinate reference system, with axis order of longitude first, followed by latitude.
The data in the table could be utilized in various ways. For example, the geographical coordinates could be used to visualize the distribution of population or economic activity across different regions. The demographic data could be analyzed to understand population age structure or gender distribution. The economic indicators could be used to study regional economic performance or disparities. All this information could be crucial for policymakers, urban planners, researchers, and businesses for decision making, planning, and strategy formulation.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _extract_date | date | This is a special column that contains the date when the data on the row of the table was extracted from the source. |
| _row_number | long | This special column contains the row number in the data extracted from the source on the extract date specified by the column '_extract_date'. |
| euref_x | double | This column contains the X coordinate in the EUREF-FIN coordinate system. |
| euref_y | double | This column contains the Y coordinate in the EUREF-FIN coordinate system. |
| geom_geojson | string | This column contains the geometric data of the postal area in GeoJSON format. |
| geom_geotext | string | This column contains the geometric data of the postal area in geotext format. |
| geom_type | string | This column indicates the type of the geometric data. |
| geom_centroid | string | This column contains the centroid of the geometric shape of the postal area. |
| geom_center_x | double | This column contains the X coordinate of the geometric center of the postal area. |
| geom_center_y | double | This column contains the Y coordinate of the geometric center of the postal area. |
| gml_id | string | This column contains the GML ID of the postal area. |
| he_0_2 | double | This column contains the number of permanent residents aged between 0 and 2 in the postal area. |
| he_13_15 | double | This column contains the number of permanent residents aged between 13 and 15 in the postal area. |
| he_16_17 | double | This column contains the number of permanent residents aged between 16 and 17 in the postal area. |
| he_18_19 | double | This column contains the number of permanent residents aged between 18 and 19 in the postal area. |
| he_20_24 | double | This column contains the number of permanent residents aged between 20 and 24 in the postal area. |
| he_25_29 | double | This column contains the number of permanent residents aged between 25 and 29 in the postal area. |
| he_30_34 | double | This column contains the number of permanent residents aged between 30 and 34 in the postal area. |
| he_35_39 | double | This column contains the number of permanent residents aged between 35 and 39 in the postal area. |
| he_3_6 | double | This column contains the number of permanent residents aged between 3 and 6 in the postal area. |
| he_40_44 | double | This column contains the number of permanent residents aged between 40 and 44 in the postal area. |
| he_45_49 | double | This column contains the number of permanent residents aged between 45 and 49 in the postal area. |
| he_50_54 | double | This column contains the number of permanent residents aged between 50 and 54 in the postal area. |
| he_55_59 | double | This column contains the number of permanent residents aged between 55 and 59 in the postal area. |
| he_60_64 | double | This column contains the number of permanent residents aged between 60 and 64 in the postal area. |
| he_65_69 | double | This column contains the number of permanent residents aged between 65 and 69 in the postal area. |
| he_70_74 | double | This column contains the number of permanent residents aged between 70 and 74 in the postal area. |
| he_75_79 | double | This column contains the number of permanent residents aged between 75 and 79 in the postal area. |
| he_7_12 | double | This column contains the number of permanent residents aged between 7 and 12 in the postal area. |
| he_80_84 | double | This column contains the number of permanent residents aged between 80 and 84 in the postal area. |
| he_85_ | double | This column contains the number of permanent residents aged 85 and above in the postal area. |
| he_kika | double | This column contains the average age of the permanent residents in the postal area. |
| he_miehet | double | This column contains the number of male permanent residents in the postal area. |
| he_naiset | double | This column contains the number of female permanent residents in the postal area. |
| he_vakiy | double | This column contains the number of permanent residents in the postal area. |
| hr_hy_tul | double | This column contains the number of inhabitants with high income in the postal area. |
| hr_ke_tul | double | This column contains the number of inhabitants with average income in the postal area. |
| hr_ktu | double | This column contains the average income of the inhabitants in the postal area. |
| hr_mtu | double | This column contains the median income of the inhabitants in the postal area. |
| hr_ovy | double | This column contains the total earned income of the inhabitants in the postal area. |
| hr_pi_tul | double | This column contains the number of inhabitants with low income in the postal area. |
| hr_tuy | double | This column contains the total income of the inhabitants in the postal area. |
| ko_al_kork | double | This column contains the number of people with lower secondary education in the postal area. |
| ko_ammat | double | This column contains the number of people with vocational education in the postal area. |
| ko_ika18y | double | This column contains the number of people aged 18 and above in the postal area. |
| ko_koul | double | This column contains the number of people with higher education in the postal area. |
| ko_perus | double | This column contains the number of people with basic education in the postal area. |
| ko_yl_kork | double | This column contains the number of people with higher secondary education in the postal area. |
| ko_yliop | double | This column contains the number of people with university education in the postal area. |
| kunta | string | This column contains the municipality code of the postal area. |
| namn | string | This column contains the Swedish name of the postal area. |
| nimi | string | This column contains the name of the postal area. |
| pinta_ala | double | This column contains the area size in square meters. |
| posti_alue | string | This column contains the postal code of the area. |
| pt_0_14 | double | This column contains the number of permanent residents aged between 0 and 14 in the postal area. |
| pt_elakel | double | This column contains the number of permanent residents who are pensioners in the postal area. |
| pt_muut | double | This column contains the number of permanent residents who are neither students nor pensioners in the postal area. |
| pt_opisk | double | This column contains the number of permanent residents who are students in the postal area. |
| pt_tyoll | double | This column contains the number of employed permanent residents in the postal area. |
| pt_tyott | double | This column contains the number of unemployed permanent residents in the postal area. |
| pt_tyovu | double | This column contains the number of permanent residents outside the labor force in the postal area. |
| pt_tyovy | double | This column contains the number of working-age permanent residents in the postal area. |
| pt_vakiy | double | This column contains the number of permanent residents in the postal area. |
| ra_as_kpa | double | This column contains the total floor area of the dwellings in the postal area. |
| ra_asrak | double | This column contains the number of residential buildings in the postal area. |
| ra_asunn | double | This column contains the number of dwellings in the postal area. |
| ra_ke | double | This column contains the number of buildings in the postal area. |
| ra_kt_as | double | This column contains the number of empty dwellings in the postal area. |
| ra_muut | double | This column contains the total floor area of other types of buildings in the postal area. |
| ra_pt_as | double | This column contains the number of occupied dwellings in the postal area. |
| ra_raky | double | This column contains the total floor area of the buildings in the postal area. |
| te_aik | double | This column contains the number of households with adults in the postal area. |
| te_aklap | double | This column contains the number of households with single adults in the postal area. |
| te_as_valj | double | This column contains the housing density, i.e., number of inhabitants per one dwelling, in the postal area. |
| te_eil_np | double | This column contains the number of households with elderly people living alone in the postal area. |
| te_elak | double | This column contains the number of households with retirees in the postal area. |
| te_klap | double | This column contains the number of households with children and two adults in the postal area. |
| te_laps | double | This column contains the number of households with children in the postal area. |
| te_muu_as | double | This column contains the number of households living in other types of housing in the postal area. |
| te_nuor | double | This column contains the number of households with children in the postal area. |
| te_omis_as | double | This column contains the number of households living in their own house in the postal area. |
| te_plap | double | This column contains the number of households with only one parent in the postal area. |
| te_takk | double | This column contains the average size of the households in the postal area. |
| te_taly | double | This column contains the number of households in the postal area. |
| te_teini | double | This column contains the number of households with teenagers in the postal area. |
| te_vuok_as | double | This column contains the number of households living in rented houses in the postal area. |
| tp_a_maat | double | This column contains the number of jobs in agriculture in the postal area. |
| tp_alku_a | double | This column contains the number of jobs in agriculture, forestry and fishing in the postal area. |
| tp_b_kaiv | double | This column contains the number of jobs in mining and quarrying in the postal area. |
| tp_c_teol | double | This column contains the number of jobs in manufacturing in the postal area. |
| tp_d_ener | double | This column contains the number of jobs in electricity, gas, steam and air conditioning supply in the postal area. |
| tp_e_vesi | double | This column contains the number of jobs in water supply, sewerage, waste management and remediation activities in the postal area. |
| tp_f_rake | double | This column contains the number of jobs in construction in the postal area. |
| tp_g_kaup | double | This column contains the number of jobs in wholesale and retail trade in the postal area. |
| tp_h_kulj | double | This column contains the number of jobs in transportation and storage in the postal area. |
| tp_i_majo | double | This column contains the number of jobs in accommodation and food service activities in the postal area. |
| tp_j_info | double | This column contains the number of jobs in information and communication in the postal area. |
| tp_jalo_bf | double | This column contains the number of jobs in wholesale and retail trade, repair of motor vehicles and motorcycles in the postal area. |
| tp_k_raho | double | This column contains the number of jobs in financial and insurance activities in the postal area. |
| tp_l_kiin | double | This column contains the number of jobs in real estate activities in the postal area. |
| tp_m_erik | double | This column contains the number of jobs in professional, scientific and technical activities in the postal area. |
| tp_n_hall | double | This column contains the number of jobs in administrative and support service activities in the postal area. |
| tp_o_julk | double | This column contains the number of jobs in public administration and defense, compulsory social security in the postal area. |
| tp_p_koul | double | This column contains the number of jobs in education in the postal area. |
| tp_palv_gu | double | This column contains the number of jobs in other service activities in the postal area. |
| tp_q_terv | double | This column contains the number of jobs in human health and social work activities in the postal area. |
| tp_r_taid | double | This column contains the number of jobs in arts, entertainment and recreation in the postal area. |
| tp_s_muup | double | This column contains the number of jobs in other service activities in the postal area. |
| tp_t_koti | double | This column contains the number of jobs in activities of households as employers in the postal area. |
| tp_tyopy | double | This column contains the number of jobs in the postal area. |
| tp_u_kans | double | This column contains the number of jobs in activities of extraterritorial organizations and bodies in the postal area. |
| tp_x_tunt | double | This column contains the number of jobs in activities of unknown nature in the postal area. |
| tr_hy_tul | double | This column contains the number of people in the workforce with high income in the postal area. |
| tr_ke_tul | double | This column contains the number of people in the workforce with average income in the postal area. |
| tr_ktu | double | This column contains the average income of the people in the workforce in the postal area. |
| tr_kuty | double | This column contains the total number of people in the workforce in the postal area. |
| tr_mtu | double | This column contains the median income of the people in the workforce in the postal area. |
| tr_ovy | double | This column contains the total earned income of the people in the workforce in the postal area. |
| tr_pi_tul | double | This column contains the number of people in the workforce with low income in the postal area. |
| vuosi | double | This column contains the year of the statistics. |
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 | 37aa8749-1727-4131-b3d2-b9d12f5fddd9 |
| Package id | 8c431d27-f54b-42cf-bd23-9426fd4b2990 |
| Revision id | 1c033c8c-1733-4f99-8cf2-2709f83d0adc |
| State | active |
| Table | postialue_pno_tilasto_2015__table |