Operations of Museums in Finland

The dataset collection consists of one or more dataset tables sourced from the web site of Museovirasto in Finland.

Tables

Responses from Museoiden Toiminta 20081 XLSX SurveyTSV
This table contains the responses of a survey conducted by Museovirasto, which is the Finnish Heritage Agency. The survey data provides information on various aspects of museum operations. The table includes columns such as extract date, row number, questions, museum name, municipality name, region, ownership type, expenditure details, revenue details, staffing information, visitor statistics, collection details, exhibition details, publication details, and museum facilities. The data can be utilized for various data analytics purposes such as analyzing museum performance, understanding visitor trends, assessing collection sizes and growth, evaluating exhibition types, and studying publication patterns. The dataset originates from Finland, which has the ISO country code 'fi'.
Version History of Survey Responses for Museums' Activities in FinlandTSV
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...

Column Descriptions

Responses from Museoiden Toiminta 20081 XLSX Survey

Column	Type	Comment
_extract_date	date	Date when the data was extracted
_row_number	long	Sequential number of the row in the table
kysymys	string	Question
kysymys__float	float	Question as a float (floating point number)
museon_nimi	string	Museum name
museon_nimi__float	float	Museum name as a float
museon_numero	float	Museum number
kunnan_nimi	string	Municipality name
kunnan_nimi__float	float	Municipality name as a float
laani	string	Province
laani__float	float	Province as a float
maakunta	string	Region
maakunta__float	float	Region as a float
paaryhma	string	Main group
paaryhma__float	float	Main group as a float
omistusmuoto	string	Ownership form
omistusmuoto__float	float	Ownership form as a float
palkkausmenot_yhteensa	int	Total pay costs
kiinteistomenot_seka_korot_ja_poistot_yhteensa	int	Total property costs, interest, and depreciation
kokoelmahankintamenot	int	Collection acquisition costs
muut_menot	int	Other expenses
menot_yhteensa	int	Total expenses
valtionosuus_museolaki_7291992	int	Government subsidy according to Museum Act
valtionavustukset	int	State grants
eu_tuet_ja__avustukset	int	EU grants and subsidies
kunnan_avustukset__ei_koske_kunnallisia_museoita	int	Municipal grants (does not apply to municipal museums)
muut_avustukset	int	Other grants
sponsorituki	int	Sponsor support
paasymaksutulot	int	Admission fee revenue
myyntitulot	int	Sales revenue
palvelu__ja_muut_tulot	int	Service and other revenue
omatoiminen_tuotto_yhteensa	int	Total self-generated revenue
tulot_yhteensa	int	Total revenue
1__vakinainen__paatoiminen_henkilokunta_henkilotyovuosina	string	1. Full-time equivalent of permanent staff (in person-years)
1__vakinainen__paatoiminen_henkilokunta_henkilotyovuosina__int	int	1. Full-time equivalent of permanent staff as an integer
1__vakinainen__paatoiminen_henkilokunta_henkilotyovuosina__float	float	1. Full-time equivalent of permanent staff as a float
1a__vakinaisesta__paatoimisesta_henkilokunnasta_museoammatillisia_henkilotyovuosina	string	1a. Full-time equivalent of museum professional staff among permanent staff (in person-years)
1a__vakinaisesta__paatoimisesta_henkilokunnasta_museoammatillisia_henkilotyovuosina__int	int	1a. Full-time equivalent of museum professional staff among permanent staff as an integer
1a__vakinaisesta__paatoimisesta_henkilokunnasta_museoammatillisia_henkilotyovuosina__float	float	1a. Full-time equivalent of museum professional staff among permanent staff as a float
todelliset_henkilotyovuodet_yhteensa	string	Total person-years worked
todelliset_henkilotyovuodet_yhteensa__float	float	Total person-years worked as a float
todelliset_henkilotyovuodet_yhteensa__int	int	Total person-years worked as an integer
toimiiko_museossa_vapaaehtoistyontekijoita	string	Do volunteers work in the museum
toimiiko_museossa_vapaaehtoistyontekijoita__float	float	Do volunteers work in the museum as a float
vapaaehtoistyontekijoiden_tyopanos_tuntia_vuodessa	int	Volunteers' working hours per year
museon_paayksikon_avoinnaolo	string	Opening hours of the main unit of the museum
museon_paayksikon_avoinnaolo__float	float	Opening hours of the main unit of the museum as a float
museoyksikoiden_aukioloajat_paivina_vuodessa	string	Opening hours of museum units in days per year
museoyksikoiden_aukioloajat_paivina_vuodessa__int	int	Opening hours of museum units in days per year as an integer
museoyksikoiden_aukioloajat_paivina_vuodessa__float	float	Opening hours of museum units in days per year as a float
maksaneet_kavijat	int	Paying visitors
ilmaiskavijat	int	Free visitors
kavijat_yhteensa	int	Total number of visitors
koululaisryhmien_kavijat_kavijoiden_kokonaismaarasta	int	Number of visitors from school groups as a percentage of the total number of visitors
ulkomaalaiset_kavijat	int	Foreign visitors
opastusten_lukumaara_yhteensa	int	Total number of guided tours
opastusten_osanottajat_yhteensa	int	Total number of participants in guided tours
onko_museon_perusnayttelyyn_ilmainen_sisaanpaasy	string	Is admission to the museum's basic exhibition free
onko_museon_perusnayttelyyn_ilmainen_sisaanpaasy__float	float	Is admission to the museum's basic exhibition free as a float
paasymaksu_perusnayttelyyn__aikuinen	float	Admission fee for the basic exhibition - adult
paasymaksu_erikoisnayttelyihin__aikuinen	float	Admission fee for special exhibitions - adult
paasymaksu_perusnayttelyyn__lapset	float	Admission fee for the basic exhibition - children
kulttuurihistorialliset_kokoelmat_laajuus	int	Extent of cultural-historical collections
kulttuurihistorialliset__kokoelmat_vuoden_kartunta	int	Increase in cultural-historical collections during the year
kulttuurihistorialliset_kokoelmat_sahkoiseen_kokoelmahallintajarjestelmaan_luetteloitujen_objektien_lukumaara	int	Number of objects in cultural-historical collections cataloged in the electronic collection management system
kulttuurihistorialliset_kokoelmat_digitoitujen_objektien_lukumaara	int	Number of digitized objects in cultural-historical collections
taidekokoelmat_laajuus	int	Extent of art collections
taidekokoelmat_vuoden_kartunta	int	Increase in art collections during the year
taidekokoelmat_sahkoiseen_kokoelmahallintajarjestelmaan_luetteloitujen_objektien_lukumaara	int	Number of objects in art collections cataloged in the electronic collection management system
taidekokoelmat_digitoitujen_objektien_lukumaara	int	Number of digitized objects in art collections
luonnontieteelliset_kokoelmat_laajuus	int	Extent of natural science collections
luonnontieteelliset_kokoelmat_vuoden_kartunta	int	Increase in natural science collections during the year
luonnontieteelliset_kokoelmat_sahkoiseen_kokoelmahallintajarjestelmaan_luetteloitujen_objektien_lukumaara	int	Number of objects in natural science collections cataloged in the electronic collection management system
luonnontieteelliset_kokoelmat_digitoitujen_objektien_lukumaara	int	Number of digitized objects in natural science collections
valokuvien_maara_kokoelmissa	int	Number of photographs in the collections
valokuvat_vuoden_kartunta	int	Increase in photographs during the year
valokuvat_sahkoiseen_kokoelmahallintajarjestelmaan_luetteloitujen_objektien_lukumaara	int	Number of photographs cataloged in the electronic collection management system
valokuvat_digitoitujen_objektien_lukumaara	int	Number of digitized photographs
vaihtuvat_nayttelyt_oma_tuotanto	int	Number of temporary exhibitions produced by the museum
vaihtuvat_nayttelyt_yhteistyonayttelyt	int	Number of temporary exhibitions done in collaboration with others
vaihtuvat_nayttelyt_muiden_tuottamat_nayttelyt	int	Number of temporary exhibitions produced by others
vaihtuvat_nayttelyt_yhteensa	int	Total number of temporary exhibitions
valmistuneet_kiertonayttelyt	int	Completed traveling exhibitions
ulkomaille_tuotetut_nayttelyt	int	Exhibitions produced for foreign countries
kaikki_nayttelyt_yhteensa	int	Total number of exhibitions
taidenayttelyiden_lukumaara_museon_vaihtuvista_nayttelyista	int	Number of art exhibitions in the museum's temporary exhibitions
taideteollisuus___valokuvataide__ja_rakennustaidenayttelyiden_lukumaara_museon_vaihtuvista_nayttelyista	int	Number of art and photography exhibitions in the museum's temporary exhibitions
kulttuurihistoriallisten_ja_historiallisten_nayttelyiden_lukumaara_museon_vaihtuvista_nayttelyista	int	Number of cultural-historical and historical exhibitions in the museum's temporary exhibitions
etnografisten_nayttelyiden_lukumaara_museon_vaihtuvista_nayttelyista	int	Number of ethnographic exhibitions in the museum's temporary exhibitions
tekniikan_ja_teollisuusnayttelyiden_lukumaara_museon_vaihtuvista_nayttelyista	int	Number of technology and industry exhibitions in the museum's temporary exhibitions
luonnonhistoriallisten_ja_luonnontieteellisten_nayttelyiden_lukumaara_museon_vaihtuvista_nayttelyista	int	Number of natural history and natural science exhibitions in the museum's temporary exhibitions
muiden_nayttelyiden_lukumaara_museon_vaihtuvista_nayttelyista	int	Number of other exhibitions in the museum's temporary exhibitions
vaihtuvat_nayttelyt_yhteensa_aihetyypin_mukaan	int	Total number of temporary exhibitions by topic type
painetut_nayttelyjulkaisut	int	Number of printed exhibition publications
painetut_tutkimukset	int	Number of printed research publications
muut_painetut_julkaisut	int	Number of other printed publications
painetut_julkaisut_yhteensa	int	Total number of printed publications
elektroniset_julkaisut_cd_romit__dvdt	int	Number of electronic publications - CD-ROMs, DVDs
verkkojulkaisut	int	Number of online publications
kaikki_julkaisut_yhteensa	int	Total number of publications
taidehistoriallisten_julkaisujen_lukumaara_museon_julkaisuista	int	Number of art historical publications among the museum's publications
taideteollisuus___valokuvataide__ja_rakennustaidejulkaisujen_lukumaara_museon_julkaisuista	int	Number of art and photography publications among the museum's publications
kulttuurihistoriallisten_ja_historiallisten_julkaisujen_lukumaara_museon_julkaisuista	int	Number of cultural-historical and historical publications among the museum's publications
etnografisten_julkaisujen_lukumaara_museon_julkaisuista	int	Number of ethnographic publications among the museum's publications
tekniikan_ja_teollisuusjulkaisujen_lukumaara_museon_julkaisuista	int	Number of technology and industry publications among the museum's publications
luonnonhistoriallisten_ja_luonnontieteellisten_julkaisujen_lukumaara_museon_julkaisuista	int	Number of natural history and natural science publications among the museum's publications
muiden_julkaisujen_lukumaara_museon_julkaisuista	int	Number of other publications among the museum's publications
julkaisut_yhteensa_aihetyypin_mukaan	int	Total number of publications by topic type
onko_museon_tiloissa_yleisopaate	string	Are the museum premises accessible to the public
onko_museon_tiloissa_yleisopaate__float	float	Are the museum premises accessible to the public as a float
onko_museolla_kokoelmahallintajarjestelma	string	Does the museum have a collection management system
onko_museolla_kokoelmahallintajarjestelma__float	float	Does the museum have a collection management system as a float

Version History of Survey Responses for Museums' Activities in Finland

Column	Type	Comment
_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.

Additional Info

Last Updated	April 21, 2024
Created	April 21, 2024