_extract_date | date | The date when the data was extracted |
_row_number | long | The row number of the data |
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 province |
maakunta | string | The region |
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 |
ulkomaalaiset_kavijat | int | The number of international 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 of property, interest, and depreciation |
kiinteistomenot_seka_korot_ja_poistot_yhteensa__int | int | The total expenses of property, interest, and depreciation as an integer |
kokoelmahankintamenot | string | The expenses of collection acquisitions |
kokoelmahankintamenot__int | int | The expenses of 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 based on the museum law 729/1992 |
valtionosuus_museolaki_7291992__int | int | The state subsidy based on the museum law 729/1992 as an integer |
valtionavustukset | string | State grants |
valtionavustukset__int | int | State grants as an integer |
eu_tuet_ja__avustukset | string | EU supports and grants |
eu_tuet_ja__avustukset__int | int | EU supports and grants as an integer |
kunnan_avustukset__ei_koske_kunnallisia_museoita | string | Municipal grants (excluding municipal museums) |
kunnan_avustukset__ei_koske_kunnallisia_museoita__int | int | Municipal grants (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 | Admissions revenue |
paasymaksutulot__int | int | Admissions revenue as an integer |
myyntitulot | string | Sales revenue |
myyntitulot__int | int | Sales revenue as an integer |
palvelu__ja_muut_tulot | string | Service and other revenue |
palvelu__ja_muut_tulot__int | int | Service and other revenue as an integer |
omatoiminen_tuotto_yhteensa | string | The total self-generated income |
omatoiminen_tuotto_yhteensa__int | int | The total self-generated income 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 total number of permanent full-time staff in person-years |
1__vakinainen__paatoiminen_henkilokunta_henkilotyovuosina__float | float | The total number of permanent full-time staff in person-years as a float |
1__vakinainen__paatoiminen_henkilokunta_henkilotyovuosina__int | int | The total number of permanent full-time staff in person-years as an integer |
1a__vakinaisesta__paatoimisesta_henkilokunnasta_museoammatillisia_henkilotyovuosina | string | The number of professional full-time staff in person-years from the permanent full-time staff |
1a__vakinaisesta__paatoimisesta_henkilokunnasta_museoammatillisia_henkilotyovuosina__int | int | The number of professional full-time staff in person-years from the permanent full-time staff as an integer |
1a__vakinaisesta__paatoimisesta_henkilokunnasta_museoammatillisia_henkilotyovuosina__float | float | The number of professional full-time staff in 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 | Indicates if there are volunteers working in the museum |
toimiiko_museossa_vapaaehtoistyontekijoita__float | float | Indicates if there are volunteers working in the museum as a float |
vapaaehtoistyontekijoiden_tyopanos_tuntia_vuodessa | string | The number of hours contributed by volunteers per year |
vapaaehtoistyontekijoiden_tyopanos_tuntia_vuodessa__int | int | The number of hours contributed by volunteers per year as an integer |
museon_paayksikon_avoinnaolo | string | The opening hours of the main unit of the museum |
museoyksikoiden_aukioloajat_paivina_vuodessa | string | The opening hours of the museum units in days per year |
museoyksikoiden_aukioloajat_paivina_vuodessa__float | float | The opening hours of the museum units in days per year as a float |
opastusten_lukumaara_yhteensa | string | The total number of guided tours |
opastusten_lukumaara_yhteensa__int | int | The total number of guided tours as an integer |
opastusten_osanottajat_yhteensa | string | The total number of participants in guided tours |
opastusten_osanottajat_yhteensa__int | int | The total number of participants in guided tours as an integer |
onko_museon_perusnayttelyyn_ilmainen_sisaanpaasy | string | Indicates if the basic exhibition of the museum has free admission |
onko_museon_perusnayttelyyn_ilmainen_sisaanpaasy__float | float | Indicates if the basic exhibition of the museum has free admission as a float |
paasymaksu_perusnayttelyyn__aikuinen | string | The admission fee for adults for the basic exhibition |
paasymaksu_perusnayttelyyn__aikuinen__int | int | The admission fee for adults for the basic exhibition as an integer |
paasymaksu_perusnayttelyyn__aikuinen__float | float | The admission fee for adults for the basic exhibition as a float |
paasymaksu_vaihtuvaan_nayttelyyn__aikuinen | string | The admission fee for adults for the temporary exhibition |
paasymaksu_vaihtuvaan_nayttelyyn__aikuinen__int | int | The admission fee for adults for the temporary exhibition as an integer |
paasymaksu_vaihtuvaan_nayttelyyn__aikuinen__float | float | The admission fee for adults for the temporary exhibition as a float |
paasymaksu_perusnayttelyyn__lapset | string | The admission fee for children for the basic exhibition |
paasymaksu_perusnayttelyyn__lapset__int | int | The admission fee for children for the basic exhibition as an integer |
paasymaksu_perusnayttelyyn__lapset__float | float | The admission fee for children for the basic exhibition as a float |
kulttuurihistorialliset_esinekokoelmat_laajuus | string | The size of the cultural historical object collections |
kulttuurihistorialliset_esinekokoelmat_laajuus__int | int | The size of the cultural historical object collections as an integer |
kulttuurihistorialliset__kokoelmat_vuoden_kartunta | string | The annual change in the size of the cultural historical object collections |
kulttuurihistorialliset__kokoelmat_vuoden_kartunta__int | int | The annual change in the size of the cultural historical object collections as an integer |
kulttuurihistorialliset_kokoelmat_sahkoiseen_kokoelmahallintajarjestelmaan_luetteloitujen_objektien_lukumaara | string | The number of objects in the cultural historical collections listed in the electronic collection management system |
kulttuurihistorialliset_kokoelmat_sahkoiseen_kokoelmahallintajarjestelmaan_luetteloitujen_objektien_lukumaara__int | int | The number of objects in the cultural historical collections listed in the electronic collection management system as an integer |
kulttuurihistorialliset_kokoelmat_digitoitujen_objektien_lukumaara | string | The number of digitized objects in the cultural historical collections |
kulttuurihistorialliset_kokoelmat_digitoitujen_objektien_lukumaara__int | int | The number of digitized objects in the cultural historical collections as an integer |
taidekokoelmat_laajuus | string | The size of the art collections |
taidekokoelmat_laajuus__int | int | The size of the art collections as an integer |
taidekokoelmat_vuoden_kartunta | string | The annual change in the size of the art collections |
taidekokoelmat_vuoden_kartunta__int | int | The annual change in the size of the art collections as an integer |
taidekokoelmat_sahkoiseen_kokoelmahallintajarjestelmaan_luetteloitujen_objektien_lukumaara | string | The number of objects in the art collections listed in the electronic collection management system |
taidekokoelmat_sahkoiseen_kokoelmahallintajarjestelmaan_luetteloitujen_objektien_lukumaara__int | int | The number of objects in the art collections listed in the electronic collection management system as an integer |
taidekokoelmat_digitoitujen_objektien_lukumaara | string | The number of digitized objects in the art collections |
taidekokoelmat_digitoitujen_objektien_lukumaara__int | int | The number of digitized objects in the art collections as an integer |
luonnontieteelliset_kokoelmat_laajuus | string | The size of the natural science collections |
luonnontieteelliset_kokoelmat_laajuus__int | int | The size of the natural science collections as an integer |
luonnontieteelliset_kokoelmat_vuoden_kartunta | string | The annual change in the size of the natural science collections |
luonnontieteelliset_kokoelmat_vuoden_kartunta__int | int | The annual change in the size of the natural science collections as an integer |
luonnontieteelliset_kokoelmat_sahkoiseen_kokoelmahallintajarjestelmaan_luetteloitujen_objektien_lukumaara | string | The number of objects in the natural science collections listed in the electronic collection management system |
luonnontieteelliset_kokoelmat_sahkoiseen_kokoelmahallintajarjestelmaan_luetteloitujen_objektien_lukumaara__int | int | The number of objects in the natural science collections listed in the electronic collection management system as an integer |
luonnontieteelliset_kokoelmat_digitoitujen_objektien_lukumaara | string | The number of digitized objects in the natural science collections |
luonnontieteelliset_kokoelmat_digitoitujen_objektien_lukumaara__int | int | The number of digitized objects in the natural science collections as an integer |
luonnontieteelliset_kokoelmat_digitoitujen_objektien_lukumaara__float | float | The number of digitized objects in the natural science collections as a float |
valokuvien_maara_kokoelmissa | string | The number of photographs in the collections |
valokuvien_maara_kokoelmissa__int | int | The number of photographs in the collections as an integer |
valokuvat_vuoden_kartunta | string | The annual change in the number of photographs in the collections |
valokuvat_vuoden_kartunta__int | int | The annual change in the number of photographs in the collections as an integer |
valokuvat_sahkoiseen_kokoelmahallintajarjestelmaan_luetteloitujen_objektien_lukumaara | string | The number of photographs listed in the electronic collection management system |
valokuvat_sahkoiseen_kokoelmahallintajarjestelmaan_luetteloitujen_objektien_lukumaara__int | int | The number of photographs listed in the electronic collection management system as an integer |
valokuvat_digitoitujen_objektien_lukumaara | string | The number of digitized photographs in the collections |
valokuvat_digitoitujen_objektien_lukumaara__int | int | The number of digitized photographs in the collections as an integer |
vaihtuvat_nayttelyt_oma_tuotanto | string | The number of exhibitions produced by the museum |
vaihtuvat_nayttelyt_oma_tuotanto__int | int | The number of exhibitions produced by the museum as an integer |
vaihtuvat_nayttelyt_yhteistyonayttelyt | string | The number of exhibitions produced in collaboration with others |
vaihtuvat_nayttelyt_yhteistyonayttelyt__int | int | The number of exhibitions produced in collaboration with others as an integer |
vaihtuvat_nayttelyt_muiden_tuottamat_nayttelyt | string | The number of exhibitions produced by others |
vaihtuvat_nayttelyt_muiden_tuottamat_nayttelyt__int | int | The number of exhibitions produced by others as an integer |
vaihtuvat_nayttelyt_yhteensa | string | The total number of temporary exhibitions |
vaihtuvat_nayttelyt_yhteensa__int | int | The total number of temporary exhibitions as an integer |
valmistuneet_kiertonayttelyt | string | The number of completed touring exhibitions |
valmistuneet_kiertonayttelyt__int | int | The number of completed touring exhibitions as an integer |
ulkomaille_tuotetut_nayttelyt | string | The number of exhibitions produced for foreign countries |
ulkomaille_tuotetut_nayttelyt__int | int | The number of exhibitions produced for foreign countries as an integer |
kaikki_nayttelyt_yhteensa | string | The total number of exhibitions |
kaikki_nayttelyt_yhteensa__int | int | The total number of exhibitions as an integer |
taidenayttelyiden_lukumaara_museon_vaihtuvista_nayttelyista | string | The number of art exhibitions from the temporary exhibitions of the museum |
taidenayttelyiden_lukumaara_museon_vaihtuvista_nayttelyista__int | int | The number of art exhibitions from the temporary exhibitions of the museum as an integer |
taideteollisuus___valokuvataide__ja_rakennustaidenayttelyiden_lukumaara_museon_vaihtuvista_nayttelyista | string | The number of art and design, photography, and architecture exhibitions from the temporary exhibitions of the museum |
taideteollisuus___valokuvataide__ja_rakennustaidenayttelyiden_lukumaara_museon_vaihtuvista_nayttelyista__int | int | The number of art and design, photography, and architecture exhibitions from the temporary exhibitions of the museum as an integer |
kulttuurihistoriallisten_ja_historiallisten_nayttelyiden_lukumaara_museon_vaihtuvista_nayttelyista | string | The number of cultural historical and historical exhibitions from the temporary exhibitions of the museum |
kulttuurihistoriallisten_ja_historiallisten_nayttelyiden_lukumaara_museon_vaihtuvista_nayttelyista__int | int | The number of cultural historical and historical exhibitions from the temporary exhibitions of the museum as an integer |
etnografisten_nayttelyiden_lukumaara_museon_vaihtuvista_nayttelyista | string | The number of ethnographic exhibitions from the temporary exhibitions of the museum |
etnografisten_nayttelyiden_lukumaara_museon_vaihtuvista_nayttelyista__int | int | The number of ethnographic exhibitions from the temporary exhibitions of the museum as an integer |
tekniikan_ja_teollisuusnayttelyiden_lukumaara_museon_vaihtuvista_nayttelyista | string | The number of technology and industry exhibitions from the temporary exhibitions of the museum |
tekniikan_ja_teollisuusnayttelyiden_lukumaara_museon_vaihtuvista_nayttelyista__int | int | The number of technology and industry exhibitions from the temporary exhibitions of the museum as an integer |
luonnonhistoriallisten_ja_luonnontieteellisten_nayttelyiden_lukumaara_museon_vaihtuvista_nayttelyista | string | The number of natural history and natural science exhibitions from the temporary exhibitions of the museum |
luonnonhistoriallisten_ja_luonnontieteellisten_nayttelyiden_lukumaara_museon_vaihtuvista_nayttelyista__int | int | The number of natural history and natural science exhibitions from the temporary exhibitions of the museum as an integer |
muiden_nayttelyiden_lukumaara_museon_vaihtuvista_nayttelyista | string | The number of other exhibitions from the temporary exhibitions of the museum |
muiden_nayttelyiden_lukumaara_museon_vaihtuvista_nayttelyista__int | int | The number of other exhibitions from the temporary exhibitions of the museum as an integer |
vaihtuvat_nayttelyt_yhteensa_aihetyypin_mukaan | string | The total number of temporary exhibitions by topic type |
vaihtuvat_nayttelyt_yhteensa_aihetyypin_mukaan__int | int | The total number of temporary exhibitions by topic type as an integer |
painetut_nayttelyjulkaisut | string | The number of printed exhibition publications |
painetut_nayttelyjulkaisut__int | int | The number of printed exhibition publications as an integer |
painetut_tutkimukset | string | The number of printed research publications |
painetut_tutkimukset__int | int | The number of printed research publications as an integer |
muut_painetut_julkaisut | string | The number of other printed publications |
muut_painetut_julkaisut__int | int | The number of other printed publications as an integer |
painetut_julkaisut_yhteensa | string | The total number of printed publications |
painetut_julkaisut_yhteensa__int | int | The total number of printed publications as an integer |
elektroniset_julkaisut_cd_romit__dvdt | string | The number of electronic publications on CD-ROMs or DVDs |
elektroniset_julkaisut_cd_romit__dvdt__int | int | The number of electronic publications on CD-ROMs or DVDs as an integer |
verkkojulkaisut | string | The number of online publications |
verkkojulkaisut__int | int | The number of online publications as an integer |
kaikki_julkaisut_yhteensa | string | The total number of publications |
kaikki_julkaisut_yhteensa__int | int | The total number of publications as an integer |
taidehistoriallisten_julkaisujen_lukumaara_museon_julkaisuista | string | The number of art historical publications among the museum's publications |
taidehistoriallisten_julkaisujen_lukumaara_museon_julkaisuista__int | int | The number of art historical publications among the museum's publications as an integer |
taideteollisuus___valokuvataide__ja_rakennustaidejulkaisujen_lukumaara_museon_julkaisuista | string | The number of art and design, photography, and architecture publications among the museum's publications |
taideteollisuus___valokuvataide__ja_rakennustaidejulkaisujen_lukumaara_museon_julkaisuista__int | int | The number of art and design, photography, and architecture publications among the museum's publications as an integer |
kulttuurihistoriallisten_ja_historiallisten_julkaisujen_lukumaara_museon_julkaisuista | string | The number of cultural historical and historical publications among the museum's publications |
kulttuurihistoriallisten_ja_historiallisten_julkaisujen_lukumaara_museon_julkaisuista__int | int | The number of cultural historical and historical publications among the museum's publications as an integer |
etnografisten_julkaisujen_lukumaara_museon_julkaisuista | string | The number of ethnographic publications among the museum's publications |
etnografisten_julkaisujen_lukumaara_museon_julkaisuista__int | int | The number of ethnographic publications among the museum's publications as an integer |
tekniikan_ja_teollisuusjulkaisujen_lukumaara_museon_julkaisuista | string | The number of technology and industry publications among the museum's publications |
tekniikan_ja_teollisuusjulkaisujen_lukumaara_museon_julkaisuista__int | int | The number of technology and industry publications among the museum's publications as an integer |
luonnonhistoriallisten_ja_luonnontieteellisten_julkaisujen_lukumaara_museon_julkaisuista | string | The number of natural history and natural science publications among the museum's publications |
luonnonhistoriallisten_ja_luonnontieteellisten_julkaisujen_lukumaara_museon_julkaisuista__int | int | The number of natural history and natural science publications among the museum's publications as an integer |
muiden_julkaisujen_lukumaara_museon_julkaisuista | string | The number of other publications among the museum's publications |
muiden_julkaisujen_lukumaara_museon_julkaisuista__int | int | The number of other publications among the museum's publications as an integer |
julkaisut_yhteensa_aihetyypin_mukaan | string | The total number of publications by topic type |
julkaisut_yhteensa_aihetyypin_mukaan__int | int | The total number of publications by topic type as an integer |
onko_museon_tiloissa_yleisopaate | string | Indicates if there is public access to the museum's premises |
onko_museon_tiloissa_yleisopaate__float | float | Indicates if there is public access to the museum's premises as a float |
onko_museolla_kokoelmahallintajarjestelma | string | Indicates if the museum has a collection management system |
onko_museolla_kokoelmahallintajarjestelma__float | float | Indicates if the museum has a collection management system as a float |