Version History of Museoiden Toiminta 2007 Table (2007) from Museovirasto Website in Finland

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

This table contains the version history of the rows from the 'museoiden_toiminta_2007_xlsx__taulukko_2007' table. The rows in this table represent different versions of the base table rows extracted from the web site of Museovirasto, the national museum authority of Finland. The table has additional columns '_start_date' and '_end_date' to indicate the extraction dates of the row versions. The data in this table can be utilized in various data analytics tasks related to museum operations and financial analysis. For example, the columns 'palkkausmenot_yhteensa' (total personnel expenses), 'kiinteistomenot_seka_korot_ja_poistot_yhteensa' (total property expenses including depreciation), 'kokoelmahankintamenot' (collection acquisition expenses), and 'muut_menot' (other expenses) can be used to analyze the financial performance of museums. The columns related to visitor statistics such as 'maksaneet_kavijat' (paying visitors), 'ilmaiskavijat' (free visitors), and 'kavijat_yhteensa' (total visitors) can be used to analyze museum visitation patterns. The different categories of temporary exhibitions can be analyzed using columns such as 'vaihtuvat_nayttelyt_yhteensa' (total number of temporary exhibitions) and 'vaihtuvat_nayttelyt_yhteensa_aihetyypin_mukaan' (total number of temporary exhibitions categorized by topic). The columns related to publications such as 'painetut_julkaisut_yhteensa' (total number of printed publications) and 'verkkojulkaisut' (online publications) can be used to analyze the dissemination of museum knowledge and research. Due to the version history nature of this table, it enables tracking changes in museum data over time and conducting trend analysis.

Field Descriptions

Name	Data type	Description
_start_date	date	The start date indicating the validity period of the row version in the history of the base table.
_end_date	date	The end date indicating the validity period of the row version in the history of the base table.
_row_number	long	The row number of the table.
kysymys	string	The question field of the table.
kysymys__float	float	The question field as a float data type of the table.
museon_nimi	string	The name of the museum.
museon_nimi__float	float	The name of the museum as a float data type.
museon_numero	float	The number of the museum.
kunnan_nimi	string	The name of the municipality.
kunnan_nimi__float	float	The name of the municipality as a float data type.
laani	string	The province of the museum.
laani__float	float	The province of the museum as a float data type.
maakunta	string	The region of the museum.
maakunta__float	float	The region of the museum as a float data type.
paaryhma	string	The main group of the museum.
paaryhma__float	float	The main group of the museum as a float data type.
omistusmuoto	string	The ownership type of the museum.
omistusmuoto__float	float	The ownership type of the museum as a float data type.
palkkausmenot_yhteensa	int	The total salary expenses.
kiinteistomenot_seka_korot_ja_poistot_yhteensa	int	The total expenses for real estate, interest, and depreciation.
kokoelmahankintamenot	int	The acquisition expenses of the collections.
muut_menot	int	The other expenses.
menot_yhteensa	int	The total expenses.
valtionosuus_museolaki_7291992	int	The state subsidy according to Museum Act 729/1992.
valtionavustukset	int	The state grants.
eu_tuet_ja_avustukset	int	The EU funding and grants.
kunnan_avustukset__ei_koske_kunnallisia_museoita	int	The municipality grants (excluding municipal museums).
muut_avustukset	int	The other grants.
sponsorituki	int	The sponsorship support.
paasymaksutulot	int	The admission fee revenues.
myyntitulot	int	The sales revenues.
palvelu__ja_muut_tulot	int	The service and other revenues.
omatoiminen_tuotto_yhteensa	int	The total self-generated revenue.
tulot_yhteensa	int	The total revenues.
1__vakinainen__paatoiminen_henkilokunta	string	The number of permanent full-time personnel.
1__vakinainen__paatoiminen_henkilokunta__int	int	The number of permanent full-time personnel as an integer data type.
1__vakinainen__paatoiminen_henkilokunta__float	float	The number of permanent full-time personnel as a float data type.
1a__vakinaisesta__paatoimisesta_henkilokunnasta_museoammatillisia_henkilotyovuosina	string	The number of professional personnel years from the permanent full-time personnel.
1a__vakinaisesta__paatoimisesta_henkilokunnasta_museoammatillisia_henkilotyovuosina__int	int	The number of professional personnel years from the permanent full-time personnel as an integer data type.
1a__vakinaisesta__paatoimisesta_henkilokunnasta_museoammatillisia_henkilotyovuosina__float	float	The number of professional personnel years from the permanent full-time personnel as a float data type.
todelliset_henkilotyovuodet_yhteensa	string	The total actual personnel years.
todelliset_henkilotyovuodet_yhteensa__float	float	The total actual personnel years as a float data type.
todelliset_henkilotyovuodet_yhteensa__int	int	The total actual personnel years as an integer data type.
toimiiko_museossa_vapaaehtoistyontekijoita	string	Indication of whether the museum operates with volunteers.
toimiiko_museossa_vapaaehtoistyontekijoita__float	float	Indication of whether the museum operates with volunteers as a float data type.
vapaaehtoistyontekijoiden_tyopanos_tuntia_vuodessa	int	The annual working hours of volunteer workforce.
museon_paayksikon_avoinnaolo	string	The opening hours of the main unit of the museum.
museon_paayksikon_avoinnaolo__float	float	The opening hours of the main unit of the museum as a float data type.
maksaneet_kavijat	int	The number of paying visitors.
ilmaiskavijat	int	The number of free visitors.
kavijat_yhteensa	int	The total number of visitors.
kavijoista_koululaisryhmien_kavijat	int	The number of visitors from school groups.
ulkomaalaisten_kavijoiden_lukumaara	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	Indication of whether the basic exhibition of the museum has free admission.
onko_museon_perusnayttelyyn_ilmainen_sisaanpaasy__float	float	Indication of whether the basic exhibition of the museum has free admission as a float data type.
paasymaksu_perusnayttelyyn__aikuinen	float	The admission fee for the basic exhibition for adults.
paasymaksu_erikoisnayttelyihin__aikuinen	float	The admission fee for special exhibitions for adults.
paasymaksu_perusnayttelyyn__lapset	float	The admission fee for the basic exhibition for children.
kulttuurihistorialliset_kokoelmat	int	The cultural history collections.
kulttuurihistoriallisista__kokoelmista_vuoden_kartunta	int	The increase in cultural history collections within a year.
montako_objektia__kulttuurihistoriallisista_kokoelmista_on_luetteloitu_sahkoiseen_kokoelmahallintajarjestelmaan	int	The number of objects cataloged in the electronic collection management system for cultural history collections.
montako_objektia_kulttuurihistoriallisista_kokoelmista_on_digitoitu	int	The number of objects digitized in the cultural history collections.
taidekokoelmat	int	The art collections.
taidekokoelmista_vuoden_kartunta	int	The increase in art collections within a year.
montako_objektia__taidekokoelmista_on_luetteloitu_sahkoiseen_kokoelmahallintajarjestelmaan	int	The number of objects cataloged in the electronic collection management system for art collections.
montako_objektia_taidekokoelmista_on_digitoitu	int	The number of objects digitized in the art collections.
luonnontieteelliset_kokoelmat	int	The natural science collections.
luonnontieteellisista_kokoelmista_vuoden_kartunta	int	The increase in natural science collections within a year.
montako_objektia_luonnontieteellisista_kokoelmista_on_luetteloitu_sahkoiseen_kokoelmahallintajarjestelmaan	int	The number of objects cataloged in the electronic collection management system for natural science collections.
montako_objektia_luonnontieteellisista_kokoelmista_on_digitoitu	int	The number of objects digitized in the natural science collections.
valokuvien_maara_kokoelmissa	int	The number of photographs in the collections.
valokuvista_vuoden_kartunta	int	The increase in photographs within a year.
montako_objektia_valokuvista_on_luetteloitu_sahkoiseen_kokoelmahallintajarjestelmaan	int	The number of photographs cataloged in the electronic collection management system.
montako_objektia_valokuvista_on_digitoitu	int	The number of photographs digitized.
oma_tuotanto_museon_vaihtuvista_nayttelyista	int	The number of exhibitions produced by the museum itself.
yhteistyonayttelyt_museon_vaihtuvista_nayttelyista	int	The number of joint exhibitions in the museum.
muiden_tuottamat_nayttelyt_museon_vaihtuvista_nayttelyista	int	The number of exhibitions produced by others in the museum.
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 countries.
kaikki_nayttelyt_yhteensa	int	The total number of exhibitions.
taidenayttelyiden_lukumaara_museon_vaihtuvista_nayttelyista	int	The number of art exhibitions in the temporary exhibitions of the museum.
taideteollisuus___valokuvataide__ja_rakennustaidenayttelyiden_lukumaara_museon_vaihtuvista_nayttelyista	int	The number of art and design exhibitions including photography and architecture in the temporary exhibitions of the museum.
kulttuurihistoriallisten_ja_historiallisten_nayttelyiden_lukumaara_museon_vaihtuvista_nayttelyista	int	The number of cultural history and historical exhibitions in the temporary exhibitions of the museum.
etnografisten_nayttelyiden_lukumaara_museon_vaihtuvista_nayttelyista	int	The number of ethnographic exhibitions in the temporary exhibitions of the museum.
tekniikan_ja_teollisuusnayttelyiden_lukumaara_museon_vaihtuvista_nayttelyista	int	The number of technology and industry exhibitions in the temporary exhibitions of the museum.
luonnonhistoriallisten_ja_luonnontieteellisten_nayttelyiden_lukumaara_museon_vaihtuvista_nayttelyista	int	The number of natural history and science exhibitions in the temporary exhibitions of the museum.
muiden_nayttelyiden_lukumaara_museon_vaihtuvista_nayttelyista	int	The number of other exhibitions in the temporary exhibitions of the museum.
vaihtuvat_nayttelyt_yhteensa_aihetyypin_mukaan	int	The total number of temporary exhibitions 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_cdt__dvdt	int	The number of electronic publications in CD or DVD format.
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 from the museum publications.
taideteollisuus___valokuvataide__ja_rakennustaidejulkaisujen_lukumaara_museon_julkaisuista	int	The number of art and design publications including photography and architecture from the museum publications.
kulttuurihistoriallisten_ja_historiallisten_julkaisujen_lukumaara_museon_julkaisuista	int	The number of cultural history and historical publications from the museum publications.
etnografisten_julkaisujen_lukumaara_museon_julkaisuista	int	The number of ethnographic publications from the museum publications.
tekniikan_ja_teollisuusjulkaisujen_lukumaara_museon_julkaisuista	int	The number of technology and industry publications from the museum publications.
luonnonhistoriallisten_ja_luonnontieteellisten_julkaisujen_lukumaara_museon_julkaisuista	int	The number of natural history and science publications from the museum publications.
muiden_julkaisujen_lukumaara_museon_julkaisuista	int	The number of other publications from the museum publications.
julkaisut_yhteensa_aihetyypin_mukaan	int	The total number of publications by topic type.
onko_museolla_paate_museokavijoiden_kaytettavissa	string	Indication of whether the museum has a public accessible computer for visitors.
onko_museolla_paate_museokavijoiden_kaytettavissa__float	float	Indication of whether the museum has a public accessible computer for visitors as a float data type.
onko_museolla_kokoelmahallintajarjestelma	string	Indication of whether the museum has a collection management system.
onko_museolla_kokoelmahallintajarjestelma__float	float	Indication of whether the museum has a collection management system as a float data type.

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	5d862e7d-c54a-4f69-ac41-48f3b18d18f6
Package id	711fbe8d-8667-4ae1-9275-c0da8801aec1
Position	1
Revision id	5e4da976-4119-4976-a33e-4620c224eb25
State	active
Table	museoiden_toiminta_2007_xlsx__taulukko_2007__history