Version History of Museum Activities in Finland

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

This table contains the version history of the 'Museovirasto' data from the country 'Finland'. It is a historical record of the data extracted from the 'museoiden_toiminta_2012_paivitetty08122023_xlsx__kyselyn_vastaukset' table. Each row in this table represents a version of a row in the base table, with additional columns '_start_date' and '_end_date' indicating the extraction dates. This table can be used for data analytics to track changes in the Museovirasto data over time, analyze trends, and compare different versions of the data. For example, it can be used to analyze the number of visitors, expenditure patterns, staffing levels, collection sizes, publication trends, and other metrics related to the activities of museums.

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.
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 administrative region.
maakunta	string	The province.
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 as a percentage of the total number of visitors.
ulkomaalaiset_kavijat	int	The number of foreign visitors.
palkkausmenot_yhteensa	string	The total payroll expenses.
palkkausmenot_yhteensa__int	int	The total payroll expenses as an integer.
kiinteistomenot_seka_korot_ja_poistot_yhteensa	string	The total of property costs, interest, and depreciation.
kiinteistomenot_seka_korot_ja_poistot_yhteensa__int	int	The total of property costs, interest, and depreciation as an integer.
kokoelmahankintamenot	string	The acquisition costs of collections.
kokoelmahankintamenot__int	int	The acquisition costs of collections 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 according to the Museums Act (729/1992).
valtionosuus_museolaki_7291992__int	int	The state subsidy according to the Museums Act (729/1992) as an integer.
valtionavustukset	string	The state grants.
valtionavustukset__int	int	The state grants as an integer.
eu_tuet_ja__avustukset	string	The EU funding and grants.
eu_tuet_ja__avustukset__int	int	The EU funding and grants as an integer.
kunnan_avustukset__ei_koske_kunnallisia_museoita	string	The municipal grants (excluding municipal museums).
kunnan_avustukset__ei_koske_kunnallisia_museoita__int	int	The 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	The admission fee revenue.
paasymaksutulot__int	int	The admission fee revenue as an integer.
myyntitulot	string	The sales revenue.
myyntitulot__int	int	The sales revenue as an integer.
palvelu__ja_muut_tulot	string	The revenue from services and other sources.
palvelu__ja_muut_tulot__int	int	The revenue from services and other sources as an integer.
omatoiminen_tuotto_yhteensa	string	The total self-generated revenue.
omatoiminen_tuotto_yhteensa__int	int	The total self-generated revenue 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 employees in person-years.
1__vakinainen__paatoiminen_henkilokunta_henkilotyovuosina__float	float	The total number of permanent full-time employees in person-years as a float.
1__vakinainen__paatoiminen_henkilokunta_henkilotyovuosina__int	int	The total number of permanent full-time employees in person-years as an integer.
1a__vakinaisesta__paatoimisesta_henkilokunnasta_museoammatillisia_henkilotyovuosina	string	The total number of museum professionals in person-years from permanent employees.
1a__vakinaisesta__paatoimisesta_henkilokunnasta_museoammatillisia_henkilotyovuosina__int	int	The total number of museum professionals in person-years from permanent employees as an integer.
1a__vakinaisesta__paatoimisesta_henkilokunnasta_museoammatillisia_henkilotyovuosina__float	float	The total number of museum professionals in person-years from permanent employees 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	Whether there are volunteers working in the museum.
toimiiko_museossa_vapaaehtoistyontekijoita__float	float	Whether there are volunteers working in the museum as a float.
vapaaehtoistyontekijoiden_tyopanos_tuntia_vuodessa	string	The total number of hours contributed by volunteers per year.
vapaaehtoistyontekijoiden_tyopanos_tuntia_vuodessa__int	int	The total 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 number of days per year that the museum units are open.
museoyksikoiden_aukioloajat_paivina_vuodessa__float	float	The number of days per year that the museum units are open 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	Whether there is free entry to the museum's permanent exhibition.
onko_museon_perusnayttelyyn_ilmainen_sisaanpaasy__float	float	Whether there is free entry to the museum's permanent exhibition as a float.
paasymaksu_perusnayttelyyn__aikuinen	string	The admission fee for adults to the permanent exhibition.
paasymaksu_perusnayttelyyn__aikuinen__int	int	The admission fee for adults to the permanent exhibition as an integer.
paasymaksu_perusnayttelyyn__aikuinen__float	float	The admission fee for adults to the permanent exhibition as a float.
paasymaksu_vaihtuvaan_nayttelyyn__aikuinen	string	The admission fee for adults to temporary exhibitions.
paasymaksu_vaihtuvaan_nayttelyyn__aikuinen__int	int	The admission fee for adults to temporary exhibitions as an integer.
paasymaksu_vaihtuvaan_nayttelyyn__aikuinen__float	float	The admission fee for adults to temporary exhibitions as a float.
paasymaksu_perusnayttelyyn__lapset	string	The admission fee for children to the permanent exhibition.
paasymaksu_perusnayttelyyn__lapset__int	int	The admission fee for children to the permanent exhibition as an integer.
paasymaksu_perusnayttelyyn__lapset__float	float	The admission fee for children to the permanent exhibition as a float.
kulttuurihistorialliset_esinekokoelmat_laajuus	string	The extent of cultural historical object collections.
kulttuurihistorialliset_esinekokoelmat_laajuus__int	int	The extent of cultural historical object collections as an integer.
kulttuurihistorialliset__kokoelmat_vuoden_kartunta	string	The increase in cultural historical collections during the year.
kulttuurihistorialliset__kokoelmat_vuoden_kartunta__int	int	The increase in cultural historical collections during the year as an integer.
kulttuurihistorialliset_kokoelmat_sahkoiseen_kokoelmahallintajarjestelmaan_luetteloitujen_objektien_lukumaara	string	The number of cultural historical objects cataloged in the electronic collection management system.
kulttuurihistorialliset_kokoelmat_sahkoiseen_kokoelmahallintajarjestelmaan_luetteloitujen_objektien_lukumaara__int	int	The number of cultural historical objects cataloged 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 extent of art collections.
taidekokoelmat_laajuus__int	int	The extent of art collections as an integer.
taidekokoelmat_vuoden_kartunta	string	The increase in art collections during the year.
taidekokoelmat_vuoden_kartunta__int	int	The increase in art collections during the year as an integer.
taidekokoelmat_sahkoiseen_kokoelmahallintajarjestelmaan_luetteloitujen_objektien_lukumaara	string	The number of art objects cataloged in the electronic collection management system.
taidekokoelmat_sahkoiseen_kokoelmahallintajarjestelmaan_luetteloitujen_objektien_lukumaara__int	int	The number of art objects cataloged 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 extent of natural science collections.
luonnontieteelliset_kokoelmat_laajuus__int	int	The extent of natural science collections as an integer.
luonnontieteelliset_kokoelmat_vuoden_kartunta	string	The increase in natural science collections during the year.
luonnontieteelliset_kokoelmat_vuoden_kartunta__int	int	The increase in natural science collections during the year as an integer.
luonnontieteelliset_kokoelmat_sahkoiseen_kokoelmahallintajarjestelmaan_luetteloitujen_objektien_lukumaara	string	The number of natural science objects cataloged in the electronic collection management system.
luonnontieteelliset_kokoelmat_sahkoiseen_kokoelmahallintajarjestelmaan_luetteloitujen_objektien_lukumaara__int	int	The number of natural science objects cataloged 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 increase in photographs in the collections during the year.
valokuvat_vuoden_kartunta__int	int	The increase in photographs in the collections during the year as an integer.
valokuvat_sahkoiseen_kokoelmahallintajarjestelmaan_luetteloitujen_objektien_lukumaara	string	The number of photographs cataloged in the electronic collection management system.
valokuvat_sahkoiseen_kokoelmahallintajarjestelmaan_luetteloitujen_objektien_lukumaara__int	int	The number of photographs cataloged 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 temporary exhibitions produced by the museum.
vaihtuvat_nayttelyt_oma_tuotanto__int	int	The number of temporary exhibitions produced by the museum as an integer.
vaihtuvat_nayttelyt_yhteistyonayttelyt	string	The number of temporary exhibitions that are a result of collaboration.
vaihtuvat_nayttelyt_yhteistyonayttelyt__int	int	The number of temporary exhibitions that are a result of collaboration as an integer.
vaihtuvat_nayttelyt_muiden_tuottamat_nayttelyt	string	The number of temporary exhibitions produced by other organizations.
vaihtuvat_nayttelyt_muiden_tuottamat_nayttelyt__int	int	The number of temporary exhibitions produced by other organizations 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 traveling exhibitions.
valmistuneet_kiertonayttelyt__int	int	The number of completed traveling exhibitions as an integer.
ulkomaille_tuotetut_nayttelyt	string	The number of exhibitions produced for foreign venues.
ulkomaille_tuotetut_nayttelyt__int	int	The number of exhibitions produced for foreign venues 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 museum's temporary exhibitions.
taidenayttelyiden_lukumaara_museon_vaihtuvista_nayttelyista__int	int	The number of art exhibitions from the museum's temporary exhibitions as an integer.
taideteollisuus___valokuvataide__ja_rakennustaidenayttelyiden_lukumaara_museon_vaihtuvista_nayttelyista	string	The number of applied arts, photography, and architecture exhibitions from the museum's temporary exhibitions.
taideteollisuus___valokuvataide__ja_rakennustaidenayttelyiden_lukumaara_museon_vaihtuvista_nayttelyista__int	int	The number of applied arts, photography, and architecture exhibitions from the museum's temporary exhibitions as an integer.
kulttuurihistoriallisten_ja_historiallisten_nayttelyiden_lukumaara_museon_vaihtuvista_nayttelyista	string	The number of cultural historical and historical exhibitions from the museum's temporary exhibitions.
kulttuurihistoriallisten_ja_historiallisten_nayttelyiden_lukumaara_museon_vaihtuvista_nayttelyista__int	int	The number of cultural historical and historical exhibitions from the museum's temporary exhibitions as an integer.
etnografisten_nayttelyiden_lukumaara_museon_vaihtuvista_nayttelyista	string	The number of ethnographic exhibitions from the museum's temporary exhibitions.
etnografisten_nayttelyiden_lukumaara_museon_vaihtuvista_nayttelyista__int	int	The number of ethnographic exhibitions from the museum's temporary exhibitions as an integer.
tekniikan_ja_teollisuusnayttelyiden_lukumaara_museon_vaihtuvista_nayttelyista	string	The number of technology and industry exhibitions from the museum's temporary exhibitions.
tekniikan_ja_teollisuusnayttelyiden_lukumaara_museon_vaihtuvista_nayttelyista__int	int	The number of technology and industry exhibitions from the museum's temporary exhibitions as an integer.
luonnonhistoriallisten_ja_luonnontieteellisten_nayttelyiden_lukumaara_museon_vaihtuvista_nayttelyista	string	The number of natural history and natural science exhibitions from the museum's temporary exhibitions.
luonnonhistoriallisten_ja_luonnontieteellisten_nayttelyiden_lukumaara_museon_vaihtuvista_nayttelyista__int	int	The number of natural history and natural science exhibitions from the museum's temporary exhibitions as an integer.
muiden_nayttelyiden_lukumaara_museon_vaihtuvista_nayttelyista	string	The number of other exhibitions from the museum's temporary exhibitions.
muiden_nayttelyiden_lukumaara_museon_vaihtuvista_nayttelyista__int	int	The number of other exhibitions from the museum's temporary exhibitions 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 history publications from the museum's publications.
taidehistoriallisten_julkaisujen_lukumaara_museon_julkaisuista__int	int	The number of art history publications from the museum's publications as an integer.
taideteollisuus___valokuvataide__ja_rakennustaidejulkaisujen_lukumaara_museon_julkaisuista	string	The number of applied arts, photography, and architecture publications from the museum's publications.
taideteollisuus___valokuvataide__ja_rakennustaidejulkaisujen_lukumaara_museon_julkaisuista__int	int	The number of applied arts, photography, and architecture publications from the museum's publications as an integer.
kulttuurihistoriallisten_ja_historiallisten_julkaisujen_lukumaara_museon_julkaisuista	string	The number of cultural historical and historical publications from the museum's publications.
kulttuurihistoriallisten_ja_historiallisten_julkaisujen_lukumaara_museon_julkaisuista__int	int	The number of cultural historical and historical publications from the museum's publications as an integer.
etnografisten_julkaisujen_lukumaara_museon_julkaisuista	string	The number of ethnographic publications from the museum's publications.
etnografisten_julkaisujen_lukumaara_museon_julkaisuista__int	int	The number of ethnographic publications from the museum's publications as an integer.
tekniikan_ja_teollisuusjulkaisujen_lukumaara_museon_julkaisuista	string	The number of technology and industry publications from the museum's publications.
tekniikan_ja_teollisuusjulkaisujen_lukumaara_museon_julkaisuista__int	int	The number of technology and industry publications from the museum's publications as an integer.
luonnonhistoriallisten_ja_luonnontieteellisten_julkaisujen_lukumaara_museon_julkaisuista	string	The number of natural history and natural science publications from the museum's publications.
luonnonhistoriallisten_ja_luonnontieteellisten_julkaisujen_lukumaara_museon_julkaisuista__int	int	The number of natural history and natural science publications from the museum's publications as an integer.
muiden_julkaisujen_lukumaara_museon_julkaisuista	string	The number of other publications from the museum's publications.
muiden_julkaisujen_lukumaara_museon_julkaisuista__int	int	The number of other publications from 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	Whether there is public access to the museum's premises.
onko_museon_tiloissa_yleisopaate__float	float	Whether there is public access to the museum's premises as a float.
onko_museolla_kokoelmahallintajarjestelma	string	Whether the museum has a collection management system.
onko_museolla_kokoelmahallintajarjestelma__float	float	Whether the museum has a collection management system as a float.

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	8dbd8ff9-3837-4e7d-8599-eee94bd9455f
Package id	b91db924-9308-4217-8ebe-94848da2f537
Position	1
Revision id	4c60f806-2c4c-46cc-b7d8-6cfe87aacf69
State	active
Table	museoiden_toiminta_2012_paivitetty08122023_xlsx__kyselyn_vastaukset__history