Version History of Survey Answers for Museum Activities (2009-1) from Museovirasto Website (Finland)

To download the data set, please sign up or log in

This table contains the version history of the rows extracted from the 'Museovirasto' website in the country Finland (ISO country code: 'fi'). It is named 'museoiden_toiminta_20091_xlsxkyselyn_vastauksethistory' and it serves as the historical record of the base table 'museoiden_toiminta_20091_xlsx__kyselyn_vastaukset'. The table includes columns such as '_start_date', '_end_date', '_row_number', and various other columns representing different aspects of museum activities, including financial data, visitor numbers, staff information, exhibition details, collection sizes, publications, and other relevant information. The '_start_date' column indicates the date when a specific version of a row was extracted, while the '_end_date' column indicates the date when a new version of the row was extracted. If the '_end_date' value is null, it means that the row is the most recent version. This table provides a valuable resource for data analytics and can be used to analyze trends and patterns in museum activities, visitor behavior, financial performance, staff composition, exhibition types, collection sizes, and the publication output of museums over time. It allows researchers and analysts to gain insights into the museum sector in Finland and examine the impact of various factors on museum operations and performance.

Field Descriptions

Name	Data type	Description
_start_date	date	The start date indicating the validity period of the row version.
_end_date	date	The end date indicating the validity period of the row version.
_row_number	long	The row number of the version history.
kysymys	string	The question field.
kysymys__float	float	The floating-point value of the question field.
museon_nimi	string	The name of the museum.
museon_nimi__float	float	The floating-point value of the museum name.
museon_numero	float	The number of the museum.
kunnan_nimi	string	The name of the municipality.
kunnan_nimi__float	float	The floating-point value of the municipality name.
laani	string	The province of the museum.
laani__float	float	The floating-point value of the province of the museum.
maakunta	string	The region of the museum.
maakunta__float	float	The floating-point value of the region of the museum.
paaryhma	string	The main group of the museum.
paaryhma__float	float	The floating-point value of the main group of the museum.
omistusmuoto	string	The ownership form of the museum.
omistusmuoto__float	float	The floating-point value of the ownership form of the museum.
maksaneet_kavijat	int	The number of paying visitors.
ilmaiskavijat	int	The number of free visitors.
kavijat_yhteensa	int	The total number of visitors.
kavijat_museokohteittain	string	The number of visitors per museum site.
kavijat_museokohteittain__float	float	The floating-point value of the number of visitors per museum site.
kavijoista_ilmaiskavijat_museokohteittain	string	The number of free visitors per museum site.
kavijoista_ilmaiskavijat_museokohteittain__float	float	The floating-point value of the number of free visitors per museum site.
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	int	The total payroll costs.
kiinteistomenot_seka_korot_ja_poistot_yhteensa	int	The total costs of property, interest, and depreciation.
kokoelmahankintamenot	int	The costs of collecting artifacts.
muut_menot	int	Other expenses.
menot_yhteensa	int	The total expenses.
valtionosuus_museolaki_7291992	int	The state subsidy based on the Museum Act 729/1992.
valtionavustukset	int	The state grants.
eu_tuet_ja__avustukset	int	EU support and grants.
kunnan_avustukset__ei_koske_kunnallisia_museoita	int	The municipality grants (excluding municipal museums).
muut_avustukset	int	Other grants.
sponsorituki	int	Sponsorship support.
paasymaksutulot	int	Revenue from admission fees.
myyntitulot	int	Revenue from sales.
palvelu__ja_muut_tulot	int	Revenue from services and other sources.
omatoiminen_tuotto_yhteensa	int	Total self-generated revenue.
tulot_yhteensa	int	Total revenue.
1__vakinainen__paatoiminen_henkilokunta_henkilotyovuosina	string	The number of permanent full-time employees in person-years.
1__vakinainen__paatoiminen_henkilokunta_henkilotyovuosina__int	int	The integer value of the number of permanent full-time employees in person-years.
1__vakinainen__paatoiminen_henkilokunta_henkilotyovuosina__float	float	The floating-point value of the number of permanent full-time employees in person-years.
1a__vakinaisesta__paatoimisesta_henkilokunnasta_museoammatillisia_henkilotyovuosina	string	The number of museum professionals in person-years from the pool of permanent full-time employees.
1a__vakinaisesta__paatoimisesta_henkilokunnasta_museoammatillisia_henkilotyovuosina__int	int	The integer value of the number of museum professionals in person-years from the pool of permanent full-time employees.
1a__vakinaisesta__paatoimisesta_henkilokunnasta_museoammatillisia_henkilotyovuosina__float	float	The floating-point value of the number of museum professionals in person-years from the pool of permanent full-time employees.
todelliset_henkilotyovuodet_yhteensa	string	The total actual person-years.
todelliset_henkilotyovuodet_yhteensa__float	float	The floating-point value of the total actual person-years.
todelliset_henkilotyovuodet_yhteensa__int	int	The integer value of the total actual person-years.
toimiiko_museossa_vapaaehtoistyontekijoita	string	Indicator of whether the museum has volunteers or not.
toimiiko_museossa_vapaaehtoistyontekijoita__float	float	The floating-point value of the indicator of whether the museum has volunteers or not.
vapaaehtoistyontekijoiden_tyopanos_tuntia_vuodessa	int	The number of hours contributed by volunteers per year.
museon_paayksikon_avoinnaolo	string	The opening hours of the main unit of the museum.
museon_paayksikon_avoinnaolo__float	float	The floating-point value of the opening hours of the main unit of the museum.
museoyksikoiden_aukioloajat_paivina_vuodessa	string	The number of days the museum units are open per year.
museoyksikoiden_aukioloajat_paivina_vuodessa__float	float	The floating-point value of the number of days the museum units are open per year.
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	Indicator of whether admission to the museum's permanent exhibition is free or not.
onko_museon_perusnayttelyyn_ilmainen_sisaanpaasy__float	float	The floating-point value of the indicator of whether admission to the museum's permanent exhibition is free or not.
paasymaksu_perusnayttelyyn__aikuinen	float	The admission fee for adults to the museum's 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 museum's permanent exhibition.
kulttuurihistorialliset_kokoelmat_laajuus	int	The extent of cultural history collections.
kulttuurihistorialliset__kokoelmat_vuoden_kartunta	int	The increase in cultural history collections during the year.
kulttuurihistorialliset_kokoelmat_sahkoiseen_kokoelmahallintajarjestelmaan_luetteloitujen_objektien_lukumaara	int	The number of objects in cultural history collections cataloged in the electronic collection management system.
kulttuurihistorialliset_kokoelmat_digitoitujen_objektien_lukumaara	int	The number of digitized objects in cultural history 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 cataloged 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 cataloged 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 the number of photographs during the year.
valokuvat_sahkoiseen_kokoelmahallintajarjestelmaan_luetteloitujen_objektien_lukumaara	int	The number of photographs cataloged in the electronic collection management system.
valokuvat_digitoitujen_objektien_lukumaara	int	The number of digitized photographs.
vaihtuvat_nayttelyt_oma_tuotanto	int	The number of exhibitions produced by the museum itself.
vaihtuvat_nayttelyt_yhteistyonayttelyt	int	The number of exhibitions produced in collaboration with others.
vaihtuvat_nayttelyt_muiden_tuottamat_nayttelyt	int	The number of exhibitions produced by others.
vaihtuvat_nayttelyt_yhteensa	int	The total number of temporary exhibitions.
valmistuneet_kiertonayttelyt	int	The number of completed traveling exhibitions.
ulkomaille_tuotetut_nayttelyt	int	The number of exhibitions produced for international venues.
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 exhibitions in applied arts, photography, and architecture among the museum's temporary exhibitions.
kulttuurihistoriallisten_ja_historiallisten_nayttelyiden_lukumaara_museon_vaihtuvista_nayttelyista	int	The number of exhibitions in cultural and historical topics 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 exhibitions in technology and industry 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 categorized 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 CDs or DVDs.
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 publications in applied arts, photography, and architecture among the museum's publications.
kulttuurihistoriallisten_ja_historiallisten_julkaisujen_lukumaara_museon_julkaisuista	int	The number of publications in cultural and historical topics 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 publications in technology and industry 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 categorized by topic type.
onko_museon_tiloissa_yleisopaate	string	Indicator of whether the museum's premises have general access or not.
onko_museon_tiloissa_yleisopaate__float	float	The floating-point value of the indicator of whether the museum's premises have general access or not.
onko_museolla_kokoelmahallintajarjestelma	string	Indicator of whether the museum has a collection management system or not.
onko_museolla_kokoelmahallintajarjestelma__float	float	The floating-point value of the indicator of whether the museum has a collection management system or not.

Data Explorer

No sample for this dataset

Additional Information


Last updated	April 21, 2024
Created	April 21, 2024
License	No License Provided
Geographic coverage
Geographic granularity
Temporal coverage from
Temporal coverage to
Temporal coverage to
Adapter	excel
Country	fi
Database	fi_museovirasto
Id	3c2cfadb-ecf7-43cf-a65d-4dc656f3b61d
Package id	5a79f50d-3ab6-4682-ac0e-035c9a4889cd
Position	1
Revision id	6a0a82e8-6d4e-4a69-a9fa-a7590e2fa78c
State	active
Table	museoiden_toiminta_20091_xlsx__kyselyn_vastaukset__history