Version History of Survey Responses for Museums' Activities in Finland

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

This table contains the version history of the 'Museoiden toiminta 20081.xlsx - Kyselyn vastaukset' table. The table is sourced from the website of the Finnish Heritage Agency (Museovirasto) in Finland. It provides a historical record of the data extracted from the original table. Each row in this table represents a specific version of a row in the base table. The '_start_date' column indicates the date when the row was extracted, while the '_end_date' column represents the date when a new version of the row was extracted. If the '_end_date' is null, it means that the row is the most recent version. The data in this table can be utilized in data analytics to track changes over time, analyze trends in museum operations, compare different versions of the data, and understand the evolution of various parameters related to museums and cultural heritage.

Field Descriptions

Name	Data type	Description
_start_date	date	The start date of the validity period of the row version.
_end_date	date	The end date of the validity period of the row version.
_row_number	long	The row number in the table.
kysymys	string	The question.
kysymys__float	float	The float value of the question.
museon_nimi	string	The name of the museum.
museon_nimi__float	float	The float value of the museum name.
museon_numero	float	The museum number.
kunnan_nimi	string	The name of the municipality.
kunnan_nimi__float	float	The float value of the municipality name.
laani	string	The province.
laani__float	float	The float value of the province.
maakunta	string	The region.
maakunta__float	float	The float value of the region.
paaryhma	string	The main group.
paaryhma__float	float	The float value of the main group.
omistusmuoto	string	The ownership form.
omistusmuoto__float	float	The float value of the ownership form.
palkkausmenot_yhteensa	int	The total payroll expenses.
kiinteistomenot_seka_korot_ja_poistot_yhteensa	int	The total expenses for real estate, interest, and depreciation.
kokoelmahankintamenot	int	The acquisition expenses for collections.
muut_menot	int	The other expenses.
menot_yhteensa	int	The total expenses.
valtionosuus_museolaki_7291992	int	The state subsidy based on the Museums Act (729/1992).
valtionavustukset	int	The state grants.
eu_tuet_ja__avustukset	int	The EU grants and subsidies.
kunnan_avustukset__ei_koske_kunnallisia_museoita	int	The municipality grants (not applicable to municipal museums).
muut_avustukset	int	The other grants.
sponsorituki	int	The sponsorship support.
paasymaksutulot	int	The entrance fee revenue.
myyntitulot	int	The sales revenue.
palvelu__ja_muut_tulot	int	The revenue from services and other sources.
omatoiminen_tuotto_yhteensa	int	The total self-generated revenue.
tulot_yhteensa	int	The total revenue.
1__vakinainen__paatoiminen_henkilokunta_henkilotyovuosina	string	The number of full-time equivalent permanent employees.
1__vakinainen__paatoiminen_henkilokunta_henkilotyovuosina__int	int	The integer value of the number of full-time equivalent permanent employees.
1__vakinainen__paatoiminen_henkilokunta_henkilotyovuosina__float	float	The float value of the number of full-time equivalent permanent employees.
1a__vakinaisesta__paatoimisesta_henkilokunnasta_museoammatillisia_henkilotyovuosina	string	The number of full-time equivalent permanent employees working in museum professions.
1a__vakinaisesta__paatoimisesta_henkilokunnasta_museoammatillisia_henkilotyovuosina__int	int	The integer value of the number of full-time equivalent permanent employees working in museum professions.
1a__vakinaisesta__paatoimisesta_henkilokunnasta_museoammatillisia_henkilotyovuosina__float	float	The float value of the number of full-time equivalent permanent employees working in museum professions.
todelliset_henkilotyovuodet_yhteensa	string	The total actual person-years.
todelliset_henkilotyovuodet_yhteensa__float	float	The float 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	Indicates whether the museum has volunteers.
toimiiko_museossa_vapaaehtoistyontekijoita__float	float	The float value indicating whether the museum has volunteers.
vapaaehtoistyontekijoiden_tyopanos_tuntia_vuodessa	int	The total hours of volunteer work per year.
museon_paayksikon_avoinnaolo	string	The opening hours of the main unit of the museum.
museon_paayksikon_avoinnaolo__float	float	The float value of the opening hours of the main unit of the museum.
museoyksikoiden_aukioloajat_paivina_vuodessa	string	The opening hours of museum units in days per year.
museoyksikoiden_aukioloajat_paivina_vuodessa__int	int	The integer value of the opening hours of museum units in days per year.
museoyksikoiden_aukioloajat_paivina_vuodessa__float	float	The float value of the opening hours of museum units in days per year.
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 visitors.
ulkomaalaiset_kavijat	int	The number of foreign visitors.
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	Indicates whether there is free admission to the basic exhibition of the museum.
onko_museon_perusnayttelyyn_ilmainen_sisaanpaasy__float	float	The float value indicating whether there is free admission to the basic exhibition of the museum.
paasymaksu_perusnayttelyyn__aikuinen	float	The admission fee for adults to the basic exhibition.
paasymaksu_erikoisnayttelyihin__aikuinen	float	The admission fee for adults to special exhibitions.
paasymaksu_perusnayttelyyn__lapset	float	The admission fee for children to the basic 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 cataloged in the electronic collection management system.
kulttuurihistorialliset_kokoelmat_digitoitujen_objektien_lukumaara	int	The number of digitally archived 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 cataloged in the electronic collection management system.
taidekokoelmat_digitoitujen_objektien_lukumaara	int	The number of digitally archived 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 digitally archived 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 digitally archived 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 organizations.
vaihtuvat_nayttelyt_muiden_tuottamat_nayttelyt	int	The number of temporary exhibitions produced by other organizations.
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 foreign audiences.
kaikki_nayttelyt_yhteensa	int	The total number of exhibitions.
taidenayttelyiden_lukumaara_museon_vaihtuvista_nayttelyista	int	The number of art exhibitions in the museum's temporary exhibitions.
taideteollisuus___valokuvataide__ja_rakennustaidenayttelyiden_lukumaara_museon_vaihtuvista_nayttelyista	int	The number of exhibitions on applied arts, photography, and architectural art in the museum's temporary exhibitions.
kulttuurihistoriallisten_ja_historiallisten_nayttelyiden_lukumaara_museon_vaihtuvista_nayttelyista	int	The number of cultural historical and historical exhibitions in the museum's temporary exhibitions.
etnografisten_nayttelyiden_lukumaara_museon_vaihtuvista_nayttelyista	int	The number of ethnographic exhibitions in the museum's temporary exhibitions.
tekniikan_ja_teollisuusnayttelyiden_lukumaara_museon_vaihtuvista_nayttelyista	int	The number of technology and industry exhibitions in the museum's temporary exhibitions.
luonnonhistoriallisten_ja_luonnontieteellisten_nayttelyiden_lukumaara_museon_vaihtuvista_nayttelyista	int	The number of natural history and natural science exhibitions in the museum's temporary exhibitions.
muiden_nayttelyiden_lukumaara_museon_vaihtuvista_nayttelyista	int	The number of other exhibitions in the museum's temporary exhibitions.
vaihtuvat_nayttelyt_yhteensa_aihetyypin_mukaan	int	The total number of temporary exhibitions by theme 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 such as CD-ROMs and 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 in the museum's publications.
taideteollisuus___valokuvataide__ja_rakennustaidejulkaisujen_lukumaara_museon_julkaisuista	int	The number of publications on applied arts, photography, and architectural art in the museum's publications.
kulttuurihistoriallisten_ja_historiallisten_julkaisujen_lukumaara_museon_julkaisuista	int	The number of cultural historical and historical publications in the museum's publications.
etnografisten_julkaisujen_lukumaara_museon_julkaisuista	int	The number of ethnographic publications in the museum's publications.
tekniikan_ja_teollisuusjulkaisujen_lukumaara_museon_julkaisuista	int	The number of technology and industry publications in the museum's publications.
luonnonhistoriallisten_ja_luonnontieteellisten_julkaisujen_lukumaara_museon_julkaisuista	int	The number of natural history and natural science publications in the museum's publications.
muiden_julkaisujen_lukumaara_museon_julkaisuista	int	The number of other publications in the museum's publications.
julkaisut_yhteensa_aihetyypin_mukaan	int	The total number of publications by theme type.
onko_museon_tiloissa_yleisopaate	string	Indicates whether there is public access to the museum premises.
onko_museon_tiloissa_yleisopaate__float	float	The float value indicating whether there is public access to the museum premises.
onko_museolla_kokoelmahallintajarjestelma	string	Indicates whether the museum has a collection management system.
onko_museolla_kokoelmahallintajarjestelma__float	float	The float value indicating whether the museum has a collection management system.

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	8681f0ac-d85a-4a73-b30c-3f196f8515a1
Package id	2a302e69-c46d-4b77-94ed-a7e8f7c2e6bb
Position	1
Revision id	281b3556-07f9-446f-a252-29df58e32c25
State	active
Table	museoiden_toiminta_20081_xlsx__kyselyn_vastaukset__history