_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 data 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 | long | This column contains the X-coordinate of the data in the EUREF-FIN coordinate system. |
euref_y | long | This column contains the Y-coordinate of the data in the EUREF-FIN coordinate system. |
geom_geojson | string | This column contains the geometry of the area in GeoJSON format. |
geom_geotext | string | This column contains the geometry of the area as text. |
geom_type | string | This column specifies the type of the geometry. |
geom_centroid | string | This column contains the centroid of the geometry of the area. |
geom_center_x | double | This column contains the X-coordinate of the center of the geometry. |
geom_center_y | double | This column contains the Y-coordinate of the center of the geometry. |
gml_id | string | This column contains the unique identifier of the data row in the GML format. |
he_0_2 | long | This column contains the number of people in the age group 0-2. |
he_13_15 | long | This column contains the number of people in the age group 13-15. |
he_16_17 | long | This column contains the number of people in the age group 16-17. |
he_18_19 | long | This column contains the number of people in the age group 18-19. |
he_20_24 | long | This column contains the number of people in the age group 20-24. |
he_25_29 | long | This column contains the number of people in the age group 25-29. |
he_30_34 | long | This column contains the number of people in the age group 30-34. |
he_35_39 | long | This column contains the number of people in the age group 35-39. |
he_3_6 | long | This column contains the number of people in the age group 3-6. |
he_40_44 | long | This column contains the number of people in the age group 40-44. |
he_45_49 | long | This column contains the number of people in the age group 45-49. |
he_50_54 | long | This column contains the number of people in the age group 50-54. |
he_55_59 | long | This column contains the number of people in the age group 55-59. |
he_60_64 | long | This column contains the number of people in the age group 60-64. |
he_65_69 | long | This column contains the number of people in the age group 65-69. |
he_70_74 | long | This column contains the number of people in the age group 70-74. |
he_75_79 | long | This column contains the number of people in the age group 75-79. |
he_7_12 | long | This column contains the number of people in the age group 7-12. |
he_80_84 | long | This column contains the number of people in the age group 80-84. |
he_85_ | long | This column contains the number of people in the age group 85 and above. |
he_kika | long | This column contains the total number of people in the area. |
he_miehet | long | This column contains the number of males in the area. |
he_naiset | long | This column contains the number of females in the area. |
he_vakiy | long | This column contains the total population in the area. |
hr_hy_tul | long | This column contains the number of high-income households in the area. |
hr_ke_tul | long | This column contains the number of middle-income households in the area. |
hr_ktu | long | This column contains the total income of the households in the area. |
hr_mtu | long | This column contains the median income of the households in the area. |
hr_ovy | long | This column contains the total number of households in the area. |
hr_pi_tul | long | This column contains the number of low-income households in the area. |
hr_tuy | long | This column contains the total number of households in the area. |
ko_al_kork | long | This column contains the number of people with primary education. |
ko_ammat | long | This column contains the number of people with vocational education. |
ko_ika18y | long | This column contains the number of people aged 18 years and above. |
ko_koul | long | This column contains the number of people with secondary education. |
ko_perus | long | This column contains the number of people with basic education. |
ko_yl_kork | long | This column contains the number of people with upper secondary education. |
ko_yliop | long | This column contains the number of people with university education. |
kunta | string | This column contains the code of the municipality. |
namn | string | This column contains the Swedish name of the area. |
nimi | string | This column contains the Finnish name of the area. |
pinta_ala | double | This column contains the area of the region in square meters. |
postinumeroalue | string | This column contains the postal code of the area. |
pt_0_14 | long | This column contains the number of people in the age group 0-14. |
pt_elakel | long | This column contains the number of pensioners. |
pt_muut | long | This column contains the number of people in other groups. |
pt_opisk | long | This column contains the number of students. |
pt_tyoll | long | This column contains the number of employed people. |
pt_tyott | long | This column contains the number of unemployed people. |
pt_vakiy | long | This column contains the total population in the area. |
ra_as_kpa | double | This column contains the average size of the apartments in the area. |
ra_asrak | long | This column contains the number of residential buildings in the area. |
ra_asunn | long | This column contains the number of apartments in the area. |
ra_ke | long | This column contains the average size of the apartments in the area. |
ra_kt_as | long | This column contains the number of apartments in multi-storey buildings. |
ra_muut | long | This column contains the number of other buildings. |
ra_pt_as | long | This column contains the number of apartments in detached houses and row houses. |
ra_raky | long | This column contains the number of buildings in the area. |
te_aik | long | This column contains the number of adults. |
te_aklap | long | This column contains the number of children living with one parent. |
te_as_valj | double | This column contains the average value of the apartments in the area. |
te_eil_np | long | This column contains the number of people not in families. |
te_elak | long | This column contains the number of retired people. |
te_klap | long | This column contains the number of children living with both parents. |
te_laps | long | This column contains the number of children. |
te_muu_as | long | This column contains the number of people in other residential status. |
te_nuor | long | This column contains the number of young people. |
te_omis_as | long | This column contains the number of people living in owner-occupied housing. |
te_plap | long | This column contains the number of children living with one parent. |
te_takk | double | This column contains the average size of the households in the area. |
te_taly | long | This column contains the total number of households in the area. |
te_teini | long | This column contains the number of teenagers. |
te_vuok_as | long | This column contains the number of people living in rental housing. |
te_yhlap | long | This column contains the number of single-parent households. |
te_yks | long | This column contains the number of people living alone. |
tp_a_maat | long | This column contains the number of people working in primary industries. |
tp_alku_a | long | Column description not available |
tp_b_kaiv | long | This column contains the number of people working in mining and quarrying. |
tp_c_teol | long | This column contains the number of people working in manufacturing. |
tp_d_ener | long | This column contains the number of people working in energy supply. |
tp_e_vesi | long | This column contains the number of people working in water supply and waste management. |
tp_f_rake | long | This column contains the number of people working in construction. |
tp_g_kaup | long | This column contains the number of people working in trade. |
tp_h_kulj | long | This column contains the number of people working in transportation and storage. |
tp_i_majo | long | This column contains the number of people working in accommodation and food service activities. |
tp_j_info | long | This column contains the number of people working in information and communication. |
tp_jalo_bf | long | Column description not available |
tp_k_raho | long | This column contains the number of people working in financial and insurance activities. |
tp_l_kiin | long | This column contains the number of people working in real estate activities. |
tp_m_erik | long | This column contains the number of people working in professional, scientific and technical activities. |
tp_n_hall | long | This column contains the number of people working in administrative and support service activities. |
tp_o_julk | long | This column contains the number of people working in public administration and defense; compulsory social security. |
tp_p_koul | long | This column contains the number of people working in education. |
tp_palv_gu | long | Column description not available |
tp_q_terv | long | This column contains the number of people working in human health and social work activities. |
tp_r_taid | long | This column contains the number of people working in arts, entertainment and recreation. |
tp_s_muup | long | This column contains the number of people working in other service activities. |
tp_t_koti | long | This column contains the number of people working in activities of households as employers; undifferentiated goods- and services-producing activities of households for own use. |
tp_tyopy | long | This column contains the total number of jobs in the area. |
tp_u_kans | long | This column contains the number of people working in activities of extraterritorial organizations and bodies. |
tp_x_tunt | long | This column contains the number of people working in activities not adequately defined. |
tr_hy_tul | long | This column contains the number of high-income taxpayers. |
tr_ke_tul | long | This column contains the number of middle-income taxpayers. |
tr_ktu | long | This column contains the total income of the taxpayers. |
tr_kuty | long | This column contains the total number of taxpayers. |
tr_mtu | long | This column contains the median income of the taxpayers. |
tr_ovy | long | This column contains the total income of the taxpayers. |
tr_pi_tul | long | This column contains the number of low-income taxpayers. |
vuosi | long | This column contains the year of the data. |