_extract_date | date | The date when the data was extracted. |
_row_number | long | The number of the row in the table. |
museon_nimi | string | The name of the museum. |
museon_numero | int | The number of the museum. |
kunnan_nimi | string | The name of the municipality. |
laani | string | The district. |
maakunta | string | The province. |
paaryhma | string | The main group. |
omistusmuoto | string | The ownership form. |
maksaneet_kavijat | int | The number of paying visitors. |
ilmaiskavijat | int | The number of free visitors. |
kavijat_yhteensa | int | The total number of visitors. |
koululaisryhmien_kavijat_kavijoiden_kokonaismaarasta | int | The number of visitors from school groups as a percentage of the total number of visitors. |
ulkomaalaiset_kavijat | int | The number of foreign visitors. |
palkkausmenot_yhteensa | string | The total salary expenses. |
palkkausmenot_yhteensa__int | int | The total salary expenses as an integer. |
kiinteistomenot_seka_korot_ja_poistot_yhteensa | string | The total expenses for properties, interest, and depreciation. |
kiinteistomenot_seka_korot_ja_poistot_yhteensa__int | int | The total expenses for properties, interest, and depreciation as an integer. |
kokoelmahankintamenot | string | The expenses for collection acquisitions. |
kokoelmahankintamenot__int | int | The expenses for collection acquisitions as an integer. |
muut_menot | string | Other expenses. |
muut_menot__int | int | Other expenses as an integer. |
menot_yhteensa | string | The total expenses. |
menot_yhteensa__int | int | The total expenses as an integer. |
valtionosuus_museolaki_7291992 | string | The state subsidy according to the Museum Act 729/1992. |
valtionosuus_museolaki_7291992__int | int | The state subsidy according to the Museum Act 729/1992 as an integer. |
valtionavustukset | string | State grants. |
valtionavustukset__int | int | State grants as an integer. |
eu_tuet_ja__avustukset | string | EU support and grants. |
eu_tuet_ja__avustukset__int | int | EU support and grants as an integer. |
kunnan_avustukset__ei_koske_kunnallisia_museoita | string | Municipal support (excluding municipal museums). |
kunnan_avustukset__ei_koske_kunnallisia_museoita__int | int | Municipal support (excluding municipal museums) as an integer. |
muut_avustukset | string | Other grants. |
muut_avustukset__int | int | Other grants as an integer. |
sponsorituki | string | Sponsorship support. |
sponsorituki__int | int | Sponsorship support as an integer. |
paasymaksutulot | string | The revenue from admission fees. |
paasymaksutulot__int | int | The revenue from admission fees as an integer. |
myyntitulot | string | The revenue from sales. |
myyntitulot__int | int | The revenue from sales as an integer. |
palvelu__ja_muut_tulot | string | The revenue from services and other sources. |
palvelu__ja_muut_tulot__int | int | The revenue from services and other sources as an integer. |
omatoiminen_tuotto_yhteensa | string | The total self-generated revenue. |
omatoiminen_tuotto_yhteensa__int | int | The total self-generated revenue as an integer. |
tulot_yhteensa | string | The total revenue. |
tulot_yhteensa__int | int | The total revenue as an integer. |
1__vakinainen__paatoiminen_henkilokunta_henkilotyovuosina | string | The number of permanent full-time employees in person-years. |
1__vakinainen__paatoiminen_henkilokunta_henkilotyovuosina__float | float | The number of permanent full-time employees in person-years as a float. |
1__vakinainen__paatoiminen_henkilokunta_henkilotyovuosina__int | int | The number of permanent full-time employees in person-years as an integer. |
1a__vakinaisesta__paatoimisesta_henkilokunnasta_museoammatillisia_henkilotyovuosina | string | The number of museum professional person-years from the permanent full-time staff. |
1a__vakinaisesta__paatoimisesta_henkilokunnasta_museoammatillisia_henkilotyovuosina__int | int | The number of museum professional person-years from the permanent full-time staff as an integer. |
1a__vakinaisesta__paatoimisesta_henkilokunnasta_museoammatillisia_henkilotyovuosina__float | float | The number of museum professional person-years from the permanent full-time staff as a float. |
todelliset_henkilotyovuodet_yhteensa | string | The total actual person-years. |
todelliset_henkilotyovuodet_yhteensa__float | float | The total actual person-years as a float. |
todelliset_henkilotyovuodet_yhteensa__int | int | The total actual person-years as an integer. |
toimiiko_museossa_vapaaehtoistyontekijoita | string | Whether the museum has volunteers. |
toimiiko_museossa_vapaaehtoistyontekijoita__float | float | Whether the museum has volunteers as a float. |
vapaaehtoistyontekijoiden_tyopanos_tuntia_vuodessa | int | The number of volunteer work hours per year. |
museon_paayksikon_avoinnaolo | string | The opening hours of the main unit of the museum. |
museon_paayksikon_avoinnaolo__float | float | The opening hours of the main unit of the museum as a float. |
opastusten_lukumaara_yhteensa | int | The total number of guided tours. |
opastusten_osanottajat_yhteensa | int | The total number of participants in guided tours. |
onko_museon_perusnayttelyyn_ilmainen_sisaanpaasy | string | Whether there is free admission to the museum's permanent exhibition. |
onko_museon_perusnayttelyyn_ilmainen_sisaanpaasy__float | float | Whether there is free admission to the museum's permanent exhibition as a float. |
paasymaksu_perusnayttelyyn__aikuinen | float | The admission fee for adults to the permanent exhibition. |
paasymaksu_erikoisnayttelyihin__aikuinen | float | The admission fee for adults to special exhibitions. |
paasymaksu_perusnayttelyyn__lapset | float | The admission fee for children to the permanent exhibition. |
kulttuurihistorialliset_kokoelmat_laajuus | int | The extent of cultural historical collections. |
kulttuurihistorialliset__kokoelmat_vuoden_kartunta | int | The increase in cultural historical collections during the year. |
kulttuurihistorialliset_kokoelmat_sahkoiseen_kokoelmahallintajarjestelmaan_luetteloitujen_objektien_lukumaara | int | The number of objects in cultural historical collections listed in the electronic collection management system. |
kulttuurihistorialliset_kokoelmat_digitoitujen_objektien_lukumaara | int | The number of digitized objects in cultural historical collections. |
taidekokoelmat_laajuus | int | The extent of art collections. |
taidekokoelmat_vuoden_kartunta | int | The increase in art collections during the year. |
taidekokoelmat_sahkoiseen_kokoelmahallintajarjestelmaan_luetteloitujen_objektien_lukumaara | int | The number of objects in art collections listed in the electronic collection management system. |
taidekokoelmat_digitoitujen_objektien_lukumaara | int | The number of digitized objects in art collections. |
luonnontieteelliset_kokoelmat_laajuus | int | The extent of natural science collections. |
luonnontieteelliset_kokoelmat_vuoden_kartunta | int | The increase in natural science collections during the year. |
luonnontieteelliset_kokoelmat_sahkoiseen_kokoelmahallintajarjestelmaan_luetteloitujen_objektien_lukumaara | int | The number of objects in natural science collections listed in the electronic collection management system. |
luonnontieteelliset_kokoelmat_digitoitujen_objektien_lukumaara | int | The number of digitized objects in natural science collections. |
valokuvien_maara_kokoelmissa | int | The number of photographs in the collections. |
valokuvat_vuoden_kartunta | int | The increase in photographs in the collections during the year. |
valokuvat_sahkoiseen_kokoelmahallintajarjestelmaan_luetteloitujen_objektien_lukumaara | int | The number of photographs listed in the electronic collection management system. |
valokuvat_digitoitujen_objektien_lukumaara | int | The number of digitized photographs. |
vaihtuvat_nayttelyt_oma_tuotanto | int | The number of temporary exhibitions produced by the museum. |
vaihtuvat_nayttelyt_yhteistyonayttelyt | int | The number of temporary exhibitions produced in collaboration with other institutions. |
vaihtuvat_nayttelyt_muiden_tuottamat_nayttelyt | int | The number of temporary exhibitions produced by other institutions. |
vaihtuvat_nayttelyt_yhteensa | int | The total number of temporary exhibitions. |
valmistuneet_kiertonayttelyt | int | The number of completed travelling exhibitions. |
ulkomaille_tuotetut_nayttelyt | int | The number of exhibitions produced for foreign countries. |
kaikki_nayttelyt_yhteensa | int | The total number of exhibitions. |
taidenayttelyiden_lukumaara_museon_vaihtuvista_nayttelyista | int | The number of art exhibitions among the museum's temporary exhibitions. |
taideteollisuus___valokuvataide__ja_rakennustaidenayttelyiden_lukumaara_museon_vaihtuvista_nayttelyista | int | The number of applied arts, photography, and architecture exhibitions among the museum's temporary exhibitions. |
kulttuurihistoriallisten_ja_historiallisten_nayttelyiden_lukumaara_museon_vaihtuvista_nayttelyista | int | The number of cultural historical and historical exhibitions among the museum's temporary exhibitions. |
etnografisten_nayttelyiden_lukumaara_museon_vaihtuvista_nayttelyista | int | The number of ethnographic exhibitions among the museum's temporary exhibitions. |
tekniikan_ja_teollisuusnayttelyiden_lukumaara_museon_vaihtuvista_nayttelyista | int | The number of technology and industry exhibitions among the museum's temporary exhibitions. |
luonnonhistoriallisten_ja_luonnontieteellisten_nayttelyiden_lukumaara_museon_vaihtuvista_nayttelyista | int | The number of natural history and natural science exhibitions among the museum's temporary exhibitions. |
muiden_nayttelyiden_lukumaara_museon_vaihtuvista_nayttelyista | int | The number of other exhibitions among the museum's temporary exhibitions. |
vaihtuvat_nayttelyt_yhteensa_aihetyypin_mukaan | int | The total number of temporary exhibitions by topic type. |
painetut_nayttelyjulkaisut | int | The number of printed exhibition publications. |
painetut_tutkimukset | int | The number of printed research publications. |
muut_painetut_julkaisut | int | The number of other printed publications. |
painetut_julkaisut_yhteensa | int | The total number of printed publications. |
elektroniset_julkaisut_cd_romit__dvdt | int | The number of electronic publications on CD-ROM or DVD. |
verkkojulkaisut | int | The number of online publications. |
kaikki_julkaisut_yhteensa | int | The total number of publications. |
taidehistoriallisten_julkaisujen_lukumaara_museon_julkaisuista | int | The number of art historical publications among the museum's publications. |
taideteollisuus___valokuvataide__ja_rakennustaidejulkaisujen_lukumaara_museon_julkaisuista | int | The number of applied arts, photography, and architecture publications among the museum's publications. |
kulttuurihistoriallisten_ja_historiallisten_julkaisujen_lukumaara_museon_julkaisuista | int | The number of cultural historical and historical publications among the museum's publications. |
etnografisten_julkaisujen_lukumaara_museon_julkaisuista | int | The number of ethnographic publications among the museum's publications. |
tekniikan_ja_teollisuusjulkaisujen_lukumaara_museon_julkaisuista | int | The number of technology and industry publications among the museum's publications. |
luonnonhistoriallisten_ja_luonnontieteellisten_julkaisujen_lukumaara_museon_julkaisuista | int | The number of natural history and natural science publications among the museum's publications. |
muiden_julkaisujen_lukumaara_museon_julkaisuista | int | The number of other publications among the museum's publications. |
julkaisut_yhteensa_aihetyypin_mukaan | int | The total number of publications by topic type. |
onko_museon_tiloissa_yleisopaate | string | Whether there is general access to the museum's premises. |
onko_museon_tiloissa_yleisopaate__float | float | Whether there is general access to the museum's premises as a float. |
onko_museolla_kokoelmahallintajarjestelma | string | Whether the museum has a collection management system. |
onko_museolla_kokoelmahallintajarjestelma__float | float | Whether the museum has a collection management system as a float. |