_extract_date | date | A column that represents the date of data extraction. |
_row_number | long | A column that represents the row number of the data. |
kysymys | string | A column that represents a question. |
kysymys__float | float | A column that represents a question as a floating point number. |
museon_nimi | string | A column that represents the name of the museum. |
museon_nimi__float | float | A column that represents the name of the museum as a floating point number. |
museon_numero | float | A column that represents the number of the museum. |
kunnan_nimi | string | A column that represents the name of the municipality. |
kunnan_nimi__float | float | A column that represents the name of the municipality as a floating point number. |
laani | string | A column that represents the province. |
laani__float | float | A column that represents the province as a floating point number. |
maakunta | string | A column that represents the region. |
maakunta__float | float | A column that represents the region as a floating point number. |
paaryhma | string | A column that represents the main group. |
paaryhma__float | float | A column that represents the main group as a floating point number. |
omistusmuoto | string | A column that represents the ownership type. |
omistusmuoto__float | float | A column that represents the ownership type as a floating point number. |
maksaneet_kavijat | int | A column that represents the number of paying visitors. |
ilmaiskavijat | int | A column that represents the number of free visitors. |
kavijat_yhteensa | int | A column that represents the total number of visitors. |
kavijat_museokohteittain | string | A column that represents the number of visitors per museum site. |
kavijat_museokohteittain__float | float | A column that represents the number of visitors per museum site as a floating point number. |
kavijoista_ilmaiskavijat_museokohteittain | string | A column that represents the number of free visitors per museum site. |
kavijoista_ilmaiskavijat_museokohteittain__float | float | A column that represents the number of free visitors per museum site as a floating point number. |
koululaisryhmien_kavijat_kavijoiden_kokonaismaarasta | int | A column that represents the number of school group visitors from the total number of visitors. |
ulkomaalaiset_kavijat | int | A column that represents the number of foreign visitors. |
palkkausmenot_yhteensa | int | A column that represents the total salary expenses. |
kiinteistomenot_seka_korot_ja_poistot_yhteensa | int | A column that represents the total expenses for real estate, interests, and depreciation. |
kokoelmahankintamenot | int | A column that represents the expenses for collection acquisitions. |
muut_menot | int | A column that represents other expenses. |
menot_yhteensa | int | A column that represents the total expenses. |
valtionosuus_museolaki_7291992 | int | A column that represents the state subsidy according to the Museums Act (729/1992). |
valtionavustukset | int | A column that represents the state subsidies. |
eu_tuet_ja__avustukset | int | A column that represents the EU grants and subsidies. |
kunnan_avustukset__ei_koske_kunnallisia_museoita | int | A column that represents the municipal grants (excluding municipal museums). |
muut_avustukset | int | A column that represents other grants. |
sponsorituki | int | A column that represents the support from sponsors. |
paasymaksutulot | int | A column that represents the income from admission fees. |
myyntitulot | int | A column that represents the income from sales. |
palvelu__ja_muut_tulot | int | A column that represents the income from services and other sources. |
omatoiminen_tuotto_yhteensa | int | A column that represents the total self-generated income. |
tulot_yhteensa | int | A column that represents the total income. |
1__vakinainen__paatoiminen_henkilokunta_henkilotyovuosina | string | A column that represents the full-time equivalent personnel. |
1__vakinainen__paatoiminen_henkilokunta_henkilotyovuosina__int | int | A column that represents the full-time equivalent personnel as an integer. |
1__vakinainen__paatoiminen_henkilokunta_henkilotyovuosina__float | float | A column that represents the full-time equivalent personnel as a floating point number. |
1a__vakinaisesta__paatoimisesta_henkilokunnasta_museoammatillisia_henkilotyovuosina | string | A column that represents the full-time equivalent professional personnel. |
1a__vakinaisesta__paatoimisesta_henkilokunnasta_museoammatillisia_henkilotyovuosina__int | int | A column that represents the full-time equivalent professional personnel as an integer. |
1a__vakinaisesta__paatoimisesta_henkilokunnasta_museoammatillisia_henkilotyovuosina__float | float | A column that represents the full-time equivalent professional personnel as a floating point number. |
todelliset_henkilotyovuodet_yhteensa | string | A column that represents the total actual personnel years. |
todelliset_henkilotyovuodet_yhteensa__float | float | A column that represents the total actual personnel years as a floating point number. |
todelliset_henkilotyovuodet_yhteensa__int | int | A column that represents the total actual personnel years as an integer. |
toimiiko_museossa_vapaaehtoistyontekijoita | string | A column that represents whether the museum has volunteers. |
toimiiko_museossa_vapaaehtoistyontekijoita__float | float | A column that represents whether the museum has volunteers as a floating point number. |
vapaaehtoistyontekijoiden_tyopanos_tuntia_vuodessa | int | A column that represents the volunteer work hours per year. |
museon_paayksikon_avoinnaolo | string | A column that represents the opening hours of the main unit of the museum. |
museon_paayksikon_avoinnaolo__float | float | A column that represents the opening hours of the main unit of the museum as a floating point number. |
museoyksikoiden_aukioloajat_paivina_vuodessa | string | A column that represents the number of days the museum units are open per year. |
museoyksikoiden_aukioloajat_paivina_vuodessa__float | float | A column that represents the number of days the museum units are open per year as a floating point number. |
opastusten_lukumaara_yhteensa | int | A column that represents the total number of guided tours. |
opastusten_osanottajat_yhteensa | int | A column that represents the total number of participants in guided tours. |
onko_museon_perusnayttelyyn_ilmainen_sisaanpaasy | string | A column that represents whether the museum's permanent exhibition has free admission. |
onko_museon_perusnayttelyyn_ilmainen_sisaanpaasy__float | float | A column that represents whether the museum's permanent exhibition has free admission as a floating point number. |
paasymaksu_perusnayttelyyn__aikuinen | float | A column that represents the admission fee to the permanent exhibition for adults. |
paasymaksu_erikoisnayttelyihin__aikuinen | float | A column that represents the admission fee to special exhibitions for adults. |
paasymaksu_perusnayttelyyn__lapset | float | A column that represents the admission fee to the permanent exhibition for children. |
kulttuurihistorialliset_kokoelmat_laajuus | int | A column that represents the extent of cultural historical collections. |
kulttuurihistorialliset__kokoelmat_vuoden_kartunta | int | A column that represents the increase in cultural historical collections in a year. |
kulttuurihistorialliset_kokoelmat_sahkoiseen_kokoelmahallintajarjestelmaan_luetteloitujen_objektien_lukumaara | int | A column that represents the number of objects in cultural historical collections cataloged in the electronic collection management system. |
kulttuurihistorialliset_kokoelmat_digitoitujen_objektien_lukumaara | int | A column that represents the number of digitized objects in cultural historical collections. |
taidekokoelmat_laajuus | int | A column that represents the extent of art collections. |
taidekokoelmat_vuoden_kartunta | int | A column that represents the increase in art collections in a year. |
taidekokoelmat_sahkoiseen_kokoelmahallintajarjestelmaan_luetteloitujen_objektien_lukumaara | int | A column that represents the number of objects in art collections cataloged in the electronic collection management system. |
taidekokoelmat_digitoitujen_objektien_lukumaara | int | A column that represents the number of digitized objects in art collections. |
luonnontieteelliset_kokoelmat_laajuus | int | A column that represents the extent of natural science collections. |
luonnontieteelliset_kokoelmat_vuoden_kartunta | int | A column that represents the increase in natural science collections in a year. |
luonnontieteelliset_kokoelmat_sahkoiseen_kokoelmahallintajarjestelmaan_luetteloitujen_objektien_lukumaara | int | A column that represents the number of objects in natural science collections cataloged in the electronic collection management system. |
luonnontieteelliset_kokoelmat_digitoitujen_objektien_lukumaara | int | A column that represents the number of digitized objects in natural science collections. |
valokuvien_maara_kokoelmissa | int | A column that represents the number of photographs in the collections. |
valokuvat_vuoden_kartunta | int | A column that represents the increase in the number of photographs in a year. |
valokuvat_sahkoiseen_kokoelmahallintajarjestelmaan_luetteloitujen_objektien_lukumaara | int | A column that represents the number of photographs cataloged in the electronic collection management system. |
valokuvat_digitoitujen_objektien_lukumaara | int | A column that represents the number of digitized photographs. |
vaihtuvat_nayttelyt_oma_tuotanto | int | A column that represents the number of temporary exhibitions produced by the museum itself. |
vaihtuvat_nayttelyt_yhteistyonayttelyt | int | A column that represents the number of joint exhibitions. |
vaihtuvat_nayttelyt_muiden_tuottamat_nayttelyt | int | A column that represents the number of exhibitions produced by others. |
vaihtuvat_nayttelyt_yhteensa | int | A column that represents the total number of temporary exhibitions. |
valmistuneet_kiertonayttelyt | int | A column that represents the number of completed touring exhibitions. |
ulkomaille_tuotetut_nayttelyt | int | A column that represents the number of exhibitions produced for international venues. |
kaikki_nayttelyt_yhteensa | int | A column that represents the total number of exhibitions. |
taidenayttelyiden_lukumaara_museon_vaihtuvista_nayttelyista | int | A column that represents the number of art exhibitions from the museum's temporary exhibitions. |
taideteollisuus___valokuvataide__ja_rakennustaidenayttelyiden_lukumaara_museon_vaihtuvista_nayttelyista | int | A column that represents the number of exhibitions of applied arts, photography, and architectural arts from the museum's temporary exhibitions. |
kulttuurihistoriallisten_ja_historiallisten_nayttelyiden_lukumaara_museon_vaihtuvista_nayttelyista | int | A column that represents the number of cultural historical and historical exhibitions from the museum's temporary exhibitions. |
etnografisten_nayttelyiden_lukumaara_museon_vaihtuvista_nayttelyista | int | A column that represents the number of ethnographic exhibitions from the museum's temporary exhibitions. |
tekniikan_ja_teollisuusnayttelyiden_lukumaara_museon_vaihtuvista_nayttelyista | int | A column that represents the number of technology and industry exhibitions from the museum's temporary exhibitions. |
luonnonhistoriallisten_ja_luonnontieteellisten_nayttelyiden_lukumaara_museon_vaihtuvista_nayttelyista | int | A column that represents the number of natural history and natural science exhibitions from the museum's temporary exhibitions. |
muiden_nayttelyiden_lukumaara_museon_vaihtuvista_nayttelyista | int | A column that represents the number of other exhibitions from the museum's temporary exhibitions. |
vaihtuvat_nayttelyt_yhteensa_aihetyypin_mukaan | int | A column that represents the total number of temporary exhibitions categorized by topic type. |
painetut_nayttelyjulkaisut | int | A column that represents the number of printed exhibition publications. |
painetut_tutkimukset | int | A column that represents the number of printed research publications. |
muut_painetut_julkaisut | int | A column that represents the number of other printed publications. |
painetut_julkaisut_yhteensa | int | A column that represents the total number of printed publications. |
elektroniset_julkaisut_cd_romit__dvdt | int | A column that represents the number of electronic publications on CD-ROMs or DVDs. |
verkkojulkaisut | int | A column that represents the number of online publications. |
kaikki_julkaisut_yhteensa | int | A column that represents the total number of publications. |
taidehistoriallisten_julkaisujen_lukumaara_museon_julkaisuista | int | A column that represents the number of art historical publications from the museum's publications. |
taideteollisuus___valokuvataide__ja_rakennustaidejulkaisujen_lukumaara_museon_julkaisuista | int | A column that represents the number of publications on applied arts, photography, and architectural arts from the museum's publications. |
kulttuurihistoriallisten_ja_historiallisten_julkaisujen_lukumaara_museon_julkaisuista | int | A column that represents the number of cultural historical and historical publications from the museum's publications. |
etnografisten_julkaisujen_lukumaara_museon_julkaisuista | int | A column that represents the number of ethnographic publications from the museum's publications. |
tekniikan_ja_teollisuusjulkaisujen_lukumaara_museon_julkaisuista | int | A column that represents the number of technology and industry publications from the museum's publications. |
luonnonhistoriallisten_ja_luonnontieteellisten_julkaisujen_lukumaara_museon_julkaisuista | int | A column that represents the number of natural history and natural science publications from the museum's publications. |
muiden_julkaisujen_lukumaara_museon_julkaisuista | int | A column that represents the number of other publications from the museum's publications. |
julkaisut_yhteensa_aihetyypin_mukaan | int | A column that represents the total number of publications categorized by topic type. |
onko_museon_tiloissa_yleisopaate | string | A column that represents whether the museum's premises have public access. |
onko_museon_tiloissa_yleisopaate__float | float | A column that represents whether the museum's premises have public access as a floating point number. |
onko_museolla_kokoelmahallintajarjestelma | string | A column that represents whether the museum has a collection management system. |
onko_museolla_kokoelmahallintajarjestelma__float | float | A column that represents whether the museum has a collection management system as a floating point number. |