Version History of Survey Responses for Museum Activities in Finland

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

This table contains the version history of the rows from the 'Museovirasto' data source. It provides a historical record of the data extracted from the source. The table has additional columns '_start_date' and '_end_date', which indicate the dates when a particular version of each row was extracted from the data source. 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 various data analytics scenarios. For example, it can be used to analyze the changes in museum-related information over time. Researchers can examine trends in visitor numbers, explore the impact of free admission policies on attendance, analyze the distribution of museums across different regions, and much more. The 'Museovirasto' data source originates from Finland (ISO country code 'fi').

Field Descriptions

Name	Data type	Description
_start_date	date	The start date of the validity period for the row version.
_end_date	date	The end date of the validity period for the row version.
_row_number	long	The unique identifier for each row.
museon_nimi	string	The name of the museum.
museon_numero	float	The unique number assigned to the museum.
kunnan_nimi	string	The name of the municipality.
kunnan_nimi__float	float	The name of the municipality as a floating-point number.
laani	string	The name of the region.
laani__float	float	The name of the region as a floating-point number.
maakunta	string	The name of the province.
maakunta__float	float	The name of the province as a floating-point number.
paaryhma	string	The main group of the museum.
paaryhma__float	float	The main group of the museum as a floating-point number.
omistusmuoto	string	The ownership form of the museum.
omistusmuoto__float	float	The ownership form of the museum as a floating-point number.
maksetut_kaynnit_yhteensa	int	The total number of paid visits.
ilmaiskaynnit_yhteensa	int	The total number of free visits.
kaikki_kaynnit_yhteensa	int	The total number of all visits.
paivakoti___koululais__ja_opiskelijaryhmien_kavijat_kayntien_kokonaismaarasta	int	The number of visits by daycare, school, and student groups as a percentage of total visits.
ulkomaisten_kaynnit_kayntien_kokonaismaarasta	int	The number of visits by foreigners as a percentage of total visits.
asiantuntijapalvelukaynnit	int	The number of visits for expert services.
muut_kaynnit	int	The number of other visits.
muut_kaynnit_yhteensa	int	The total number of other visits.
nayttelyopastusten_lukumaara	int	The number of exhibition tours.
nayttelyopastuksiin_osallistuneiden_henkilomaara	int	The number of people who participated in exhibition tours.
jarjestettyjen_tyopajojen_lukumaara	int	The number of organized workshops.
tyopajoihin_osallistuneiden_henkilomaara	int	The number of people who participated in workshops.
muiden_yleisotapahtumien_lukumaara	int	The number of other public events.
yleisotapahtumien_kokonaismaara	int	The total number of public events.
onko_museoon_ilmainen_sisaanpaasy_kaikille_kavijoille	string	Indicates whether the museum offers free admission for all visitors.
onko_museoon_ilmainen_sisaanpaasy_kaikille_kavijoille__float	float	Indicates whether the museum offers free admission for all visitors as a floating-point number.
onko_museoon_ilmainen_sisaanpaasy_kaikille_kavijoille__int	int	Indicates whether the museum offers free admission for all visitors as an integer.
onko_museoon_ilmainen_sisaanpaasy_alle_18_vuotiaille_kavijoille	string	Indicates whether the museum offers free admission for visitors under 18 years old.
onko_museoon_ilmainen_sisaanpaasy_alle_18_vuotiaille_kavijoille__float	float	Indicates whether the museum offers free admission for visitors under 18 years old as a floating-point number.
onko_museoon_ilmainen_sisaanpaasy_alle_18_vuotiaille_kavijoille__int	int	Indicates whether the museum offers free admission for visitors under 18 years old as an integer.
paasymaksu_perusnayttelyyn__aikuiset	float	The admission fee for adults to the basic exhibition.
paasymaksu_vaihtuvaan_nayttelyyn__aikuiset	float	The admission fee for adults to the changing exhibition.
paasymaksu_perusnayttelyyn__lapset	float	The admission fee for children to the basic exhibition.
paasymaksu_vaihtuvaan_nayttelyyn__lapset	float	The admission fee for children to the changing exhibition.
jos_museoon_on_sisaanpaasymaksu__tarjoaako_museo_tiettyina_paivina_vuodessa_ilmaisen_sisaanpaasyn	string	Indicates whether the museum offers free admission on certain days of the year if there is an admission fee.
jos_museoon_on_sisaanpaasymaksu__tarjoaako_museo_tiettyina_paivina_vuodessa_ilmaisen_sisaanpaasyn__float	float	Indicates whether the museum offers free admission on certain days of the year if there is an admission fee as a floating-point number.
jos_museoon_on_sisaanpaasymaksu__tarjoaako_museo_tiettyina_paivina_vuodessa_ilmaisen_sisaanpaasyn__int	int	Indicates whether the museum offers free admission on certain days of the year if there is an admission fee as an integer.
jos_kylla__kuinka_monena_paivana_vuodessa	int	The number of days in a year when the museum offers free admission if there is an admission fee.
jos_kylla__montako_tuntia_vuodessa	int	The number of hours in a year when the museum offers free admission if there is an admission fee.
museon_paayksikon_avoinna_olo	string	The opening hours of the main unit of the museum.
museon_paayksikon_avoinna_olo__float	float	The opening hours of the main unit of the museum as a floating-point number.
museon_paayksikon_avoinna_olo__int	int	The opening hours of the main unit of the museum as an integer.
vaihtuvat_nayttelyt_oma_tuotanto	int	The number of changing exhibitions produced by the museum.
vaihtuvat_nayttelyt_yhteistyonayttelyt	int	The number of changing exhibitions produced in collaboration with other institutions.
vaihtuvat_nayttelyt_muiden_tuottamat_nayttelyt	int	The number of changing exhibitions produced by other institutions.
vaihtuvat_nayttelyt_yhteensa	int	The total number of changing exhibitions.
valmistuneet_uudet_kiertonayttelyt	int	The number of new traveling exhibitions produced.
ulkomaille_tuotetut_nayttelyt	int	The number of exhibitions produced abroad.
kaikki_nayttelyt_yhteensa	int	The total number of exhibitions.
museon_tuottamat_nayttelyt_museon_ulkopuolella	int	The number of exhibitions produced by the museum outside of its premises.
valmistuneet_uudet_verkkonayttelyt	int	The number of new online exhibitions produced.
museon_julkaisemat_kokoelmajulkaisut	int	The number of collection publications published by the museum.
museon_julkaisemat_nayttelyjulkaisut	int	The number of exhibition publications published by the museum.
museon_julkaisemat_tutkimusjulkaisut	int	The number of research publications published by the museum.
muut_julkaisut	int	The number of other publications.
kaikki_julkaisut_yhteensa	int	The total number of publications.
kuinka_monta_naista_julkaisuista_on_julkaistu_painettuna	int	The number of publications published in print form.
kuinka_monta_naista_julkaisuista_on_julkaistu_verkkojulkaisuna	int	The number of publications published as online publications.
kuinka_monta_naista_julkaisuista_on_julkaistu_elektronisena_julkaisuna_esim__cd_romit_tai_dvdt	int	The number of publications published as electronic publications, such as CD-ROMs or DVDs.
onko_museolla_kaytossa_sahkoinen_kokoelmahallintajarjestelma	string	Indicates whether the museum uses an electronic collection management system.
onko_museolla_kaytossa_sahkoinen_kokoelmahallintajarjestelma__float	float	Indicates whether the museum uses an electronic collection management system as a floating-point number.
onko_museolla_kaytossa_sahkoinen_kokoelmahallintajarjestelma__int	int	Indicates whether the museum uses an electronic collection management system as an integer.
onko_museolla_kirjattu_kokoelmapoliittinen_ohjelma	string	Indicates whether the museum has recorded a collection policy program.
onko_museolla_kirjattu_kokoelmapoliittinen_ohjelma__float	float	Indicates whether the museum has recorded a collection policy program as a floating-point number.
onko_museolla_kirjattu_kokoelmapoliittinen_ohjelma__int	int	Indicates whether the museum has recorded a collection policy program as an integer.
onko_museolla_kirjattu_digitointisuunnitelma	string	Indicates whether the museum has recorded a digitization plan.
onko_museolla_kirjattu_digitointisuunnitelma__float	float	Indicates whether the museum has recorded a digitization plan as a floating-point number.
onko_museolla_kirjattu_digitointisuunnitelma__int	int	Indicates whether the museum has recorded a digitization plan as an integer.
kulttuurihistorialliset_esinekokoelmat_koko_laajuus	int	The total scope of cultural historical object collections.
kulttuurihistorialliset_esinekokoelmat_vuoden_kartunta	int	The increase in cultural historical object collections during a year.
kulttuurihistorialliset_esinekokoelmat_kokoelmahallintajarjestelmaan_luetteloitujen_objektien_lukumaara	int	The number of objects in cultural historical object collections that have been cataloged in the collection management system.
kulttuurihistorialliset_kokoelmat_digitoitujen_objektien_lukumaara	int	The number of objects in cultural historical collections that have been digitized.
taidekokoelmat_koko_laajuus	int	The total scope of art collections.
taidekokoelmat_vuoden_kartunta	int	The increase in art collections during a year.
taidekokoelmat__kokoelmahallintajarjestelmaan_luetteloitujen_objektien_lukumaara	int	The number of objects in art collections that have been cataloged in the collection management system.
taidekokoelmat_digitoitujen_objektien_lukumaara	int	The number of objects in art collections that have been digitized.
luonnontieteelliset_kokoelmat_koko_laajuus	int	The total scope of natural science collections.
luonnontieteelliset_kokoelmat_vuoden_kartunta	int	The increase in natural science collections during a year.
luonnontieteelliset_kokoelmat__kokoelmahallintajarjestelmaan_luetteloitujen_objektien_lukumaara	int	The number of objects in natural science collections that have been cataloged in the collection management system.
luonnontieteelliset_kokoelmat_digitoitujen_objektien_lukumaara	int	The number of objects in natural science collections that have been digitized.
valokuvakokoelmat_laajuus	int	The total scope of photograph collections.
valokuvakokoelmat_vuoden_kartunta	int	The increase in photograph collections during a year.
valokuvakokoelmat_kokoelmanhallintajarjestelmaan_luetteloitujen_objektien_maara	int	The number of objects in photograph collections that have been cataloged in the collection management system.
valokuvakokoelmat_digitoitujen_objektien_lukumaara	int	The number of objects in photograph collections that have been digitized.
vakinainen__paatoiminen_henkilokunta_henkilotyovuosina	string	The total number of permanent full-time staff in person-years.
vakinainen__paatoiminen_henkilokunta_henkilotyovuosina__float	float	The total number of permanent full-time staff in person-years as a floating-point number.
vakinainen__paatoiminen_henkilokunta_henkilotyovuosina__int	int	The total number of permanent full-time staff in person-years as an integer.
vakinaisesta__paatoimisesta_henkilokunnasta_museoammatillisia_henkilotyovuosina	string	The number of person-years worked by professionals in the permanent full-time staff.
vakinaisesta__paatoimisesta_henkilokunnasta_museoammatillisia_henkilotyovuosina__int	int	The number of person-years worked by professionals in the permanent full-time staff as an integer.
vakinaisesta__paatoimisesta_henkilokunnasta_museoammatillisia_henkilotyovuosina__float	float	The number of person-years worked by professionals in the permanent full-time staff as a floating-point number.
todelliset_henkilotyovuodet_yhteensa	string	The total number of actual person-years worked.
todelliset_henkilotyovuodet_yhteensa__float	float	The total number of actual person-years worked as a floating-point number.
todelliset_henkilotyovuodet_yhteensa__int	int	The total number of actual person-years worked as an integer.
toimiiko_museossa_vapaaehtoistyontekijoita	string	Indicates whether the museum has volunteers.
toimiiko_museossa_vapaaehtoistyontekijoita__float	float	Indicates whether the museum has volunteers as a floating-point number.
toimiiko_museossa_vapaaehtoistyontekijoita__int	int	Indicates whether the museum has volunteers as an integer.
vapaaehtoistyontekijoiden_tyopanos_tuntia_vuodessa	int	The total number of hours worked by volunteers in a year.
palkkausmenot_yhteensa	float	The total salary expenses.
kiinteistomenot_seka_korot_ja_poistot_yhteensa	float	The total expenses for real estate, interest, and depreciation.
kokoelmahankintamenot	float	The expenses for acquiring collections.
nayttelytoiminnan_menot	float	The expenses for exhibition activities.
markkinointi__ja_viestintamenot	float	The expenses for marketing and communication.
muut_menot	float	The expenses for other purposes.
muut_menot_yhteensa	float	The total expenses for other purposes.
menot_yhteensa	float	The total expenses.
valtionosuus_museolaki_7291992	float	The state subsidy according to the Museum Act (729/1992).
valtionavustukset	float	The state grants.
kunnan_avustukset__ei_koske_kunnallisia_museoita	float	The municipal grants (not applicable to municipal museums).
muut_toiminta_avustukset	float	The other operating grants.
muut_hankeavustukset	float	The other project grants.
eu_tuet_ja__avustukset	float	The EU grants and subsidies.
sponsorituki	float	The sponsorship support.
paasymaksutulot	float	The income from admission fees.
palvelu__ja_myyntitulot	float	The income from services and sales.
muut_tulot	float	The other income.
omat_tulot_yhteensa	float	The total own income.
tulot_yhteensa	float	The total income.

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	a2366232-594f-4de2-90b3-32327884cfea
Package id	80618999-3b71-4da6-93a6-0f67d796db2e
Position	1
Revision id	db065a93-c70c-4976-98c6-9838ce8ee668
State	active
Table	museoiden_toiminta_2013_paivitetty27112023_xlsx__kyselyn_vastaukset__history