_start_date | date | This column contains the date when the row was extracted from the data source. This is part of the unique identifier for each row in this version history 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 means 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. This is part of the unique identifier for each row in this version history table. |
euref_x | long | This column contains the x-coordinate value in the EUREF-FIN coordinate system. |
euref_y | long | This column contains the y-coordinate value in the EUREF-FIN coordinate system. |
geom_geojson | string | This column contains the geometric data in GeoJSON format. |
geom_geotext | string | This column contains the geometric data in text format. |
geom_type | string | This column contains the type of the geometric data. |
geom_centroid | string | This column contains the centroid of the geometric data. |
geom_center_x | double | This column contains the x-coordinate of the center of the geometric data. |
geom_center_y | double | This column contains the y-coordinate of the center of the geometric data. |
gml_id | string | This column contains an ID that is unique for each row in the data source. |
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 over. |
he_kika | double | This column contains the number of people of an unknown or other gender. |
he_miehet | double | This column contains the number of men. |
he_naiset | double | This column contains the number of women. |
he_vakiy | double | This column contains the number of permanent residents. |
hr_hy_tul | double | This column contains the number of households with a high income. |
hr_ke_tul | double | This column contains the number of households with an average income. |
hr_ktu | double | This column contains the average income of the households. |
hr_mtu | double | This column contains the median income of the households. |
hr_ovy | double | This column contains the total income of the households. |
hr_pi_tul | double | This column contains the number of households with a low income. |
hr_tuy | double | This column contains the number of households in total. |
ko_al_kork | double | This column contains the number of people with low education. |
ko_ammat | double | This column contains the number of people with vocational education. |
ko_ika18y | double | This column contains the number of people who are 18 years old or over. |
ko_koul | double | This column contains the number of people with secondary 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 high education. |
ko_yliop | double | This column contains the number of people with a university degree. |
kunta | string | This column contains the municipality code. |
namn | string | This column contains the name of the area in Swedish. |
nimi | string | This column contains the name of the area in Finnish. |
pinta_ala | long | This column contains the area size in square meters. |
postinumeroalue | string | This column contains the postal code area. |
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 retired people. |
pt_muut | double | This column contains the number of people with other or unknown occupation status. |
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_vakiy | double | This column contains the number of permanent residents. |
ra_as_kpa | double | This column contains the share of single-family houses of all buildings. |
ra_asrak | double | This column contains the number of residential buildings. |
ra_asunn | double | This column contains the number of dwellings. |
ra_ke | double | This column contains the number of other buildings. |
ra_kt_as | double | This column contains the number of other dwellings. |
ra_muut | double | This column contains the number of other buildings. |
ra_pt_as | double | This column contains the number of dwellings in single-family houses. |
ra_raky | double | This column contains the number of buildings in total. |
te_aik | double | This column contains the number of adults. |
te_aklap | double | This column contains the number of adults living alone. |
te_as_valj | double | This column contains the share of dwellings that are vacant. |
te_eil_np | double | This column contains the number of adults who are not in a relationship. |
te_elak | double | This column contains the number of retired adults. |
te_klap | double | This column contains the number of adults living with children. |
te_laps | double | This column contains the number of children. |
te_muu_as | double | This column contains the number of adults living in other dwelling types. |
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 adults living with parents. |
te_takk | double | This column contains the average size of the households. |
te_taly | double | This column contains the number of adults in total. |
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 workplaces in the agriculture, forestry and fishing sector. |
tp_alku_a | double | This column contains the number of workplaces in the primary sector. |
tp_b_kaiv | double | This column contains the number of workplaces in the mining and quarrying sector. |
tp_c_teol | double | This column contains the number of workplaces in the manufacturing sector. |
tp_d_ener | double | This column contains the number of workplaces in the electricity, gas, steam and air conditioning supply sector. |
tp_e_vesi | double | This column contains the number of workplaces in the water supply, sewerage, waste management and remediation activities sector. |
tp_f_rake | double | This column contains the number of workplaces in the construction sector. |
tp_g_kaup | double | This column contains the number of workplaces in the wholesale and retail trade, repair of motor vehicles and motorcycles sector. |
tp_h_kulj | double | This column contains the number of workplaces in the transportation and storage sector. |
tp_i_majo | double | This column contains the number of workplaces in the accommodation and food service activities sector. |
tp_j_info | double | This column contains the number of workplaces in the information and communication sector. |
tp_jalo_bf | double | This column contains the number of workplaces in the secondary sector. |
tp_k_raho | double | This column contains the number of workplaces in the financial and insurance activities sector. |
tp_l_kiin | double | This column contains the number of workplaces in the real estate activities sector. |
tp_m_erik | double | This column contains the number of workplaces in the professional, scientific and technical activities sector. |
tp_n_hall | double | This column contains the number of workplaces in the administrative and support service activities sector. |
tp_o_julk | double | This column contains the number of workplaces in the public administration and defense, compulsory social security sector. |
tp_p_koul | double | This column contains the number of workplaces in the education sector. |
tp_palv_gu | double | This column contains the number of workplaces in the service sector. |
tp_q_terv | double | This column contains the number of workplaces in the human health and social work activities sector. |
tp_r_taid | double | This column contains the number of workplaces in the arts, entertainment and recreation sector. |
tp_s_muup | double | This column contains the number of workplaces in the other service activities sector. |
tp_t_koti | double | This column contains the number of workplaces in the activities of households as employers, undifferentiated goods and services producing activities of households for own use sector. |
tp_tyopy | double | This column contains the number of workplaces. |
tp_u_kans | double | This column contains the number of workplaces in the activities of extraterritorial organizations and bodies sector. |
tp_x_tunt | double | This column contains the number of workplaces in the unknown sector. |
tr_hy_tul | double | This column contains the number of households with a high income. |
tr_ke_tul | double | This column contains the number of households with an average income. |
tr_ktu | double | This column contains the average income of the households. |
tr_kuty | double | This column contains the number of households in total. |
tr_mtu | double | This column contains the median income of the households. |
tr_ovy | double | This column contains the total income of the households. |
tr_pi_tul | double | This column contains the number of households with a low income. |
vuosi | long | This column contains the year when the data was collected. |