Activities of Museums in Finland in 2007

This dataset collection consists of one or more dataset tables sourced from the website of Museovirasto in Finland.

Tables

Activity of Museums in Finland in 2007TSV
This table contains data from the 'Museovirasto' website in Finland. It includes various columns with information related to museum operations in 2007. The data can be used for data analytics to gain insights into museum activities, funding sources, staff information, visitor statistics, exhibition details, publication records, and more. The table provides a comprehensive snapshot of the state of museums in Finland in 2007 and can be a valuable resource for researchers, policymakers, and museum professionals.
Version History of Museoiden Toiminta 2007 Table (2007) from Museovirasto Website in FinlandTSV
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...

Column Descriptions

Activity of Museums in Finland in 2007

Column	Type	Comment
_extract_date	date	The date when the data was extracted.
_row_number	long	The row number of the data.
kysymys	string	The question.
kysymys__float	float	The question (floating point).
museon_nimi	string	The name of the museum.
museon_nimi__float	float	The name of the museum (floating point).
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 (floating point).
laani	string	The province.
laani__float	float	The province (floating point).
maakunta	string	The region.
maakunta__float	float	The region (floating point).
paaryhma	string	The main group.
paaryhma__float	float	The main group (floating point).
omistusmuoto	string	The ownership form.
omistusmuoto__float	float	The ownership form (floating point).
palkkausmenot_yhteensa	int	The total salary expenses.
kiinteistomenot_seka_korot_ja_poistot_yhteensa	int	The total costs including property, interest, and depreciation.
kokoelmahankintamenot	int	The acquisition costs of collections.
muut_menot	int	Other expenses.
menot_yhteensa	int	The total expenses.
valtionosuus_museolaki_7291992	int	The state subsidy based on the Museums Act (729/1992).
valtionavustukset	int	State grants.
eu_tuet_ja_avustukset	int	EU support and grants.
kunnan_avustukset__ei_koske_kunnallisia_museoita	int	Municipal grants (excluding municipal museums).
muut_avustukset	int	Other grants.
sponsorituki	int	Sponsorship support.
paasymaksutulot	int	Income from admission fees.
myyntitulot	int	Income from sales.
palvelu__ja_muut_tulot	int	Income from services and other sources.
omatoiminen_tuotto_yhteensa	int	Total self-generated income.
tulot_yhteensa	int	Total income.
1__vakinainen__paatoiminen_henkilokunta	string	Number of permanent full-time employees.
1__vakinainen__paatoiminen_henkilokunta__int	int	Number of permanent full-time employees (integer).
1__vakinainen__paatoiminen_henkilokunta__float	float	Number of permanent full-time employees (floating point).
1a__vakinaisesta__paatoimisesta_henkilokunnasta_museoammatillisia_henkilotyovuosina	string	Number of professional person-years in the permanent full-time staff.
1a__vakinaisesta__paatoimisesta_henkilokunnasta_museoammatillisia_henkilotyovuosina__int	int	Number of professional person-years in the permanent full-time staff (integer).
1a__vakinaisesta__paatoimisesta_henkilokunnasta_museoammatillisia_henkilotyovuosina__float	float	Number of professional person-years in the permanent full-time staff (floating point).
todelliset_henkilotyovuodet_yhteensa	string	Total actual person-years.
todelliset_henkilotyovuodet_yhteensa__float	float	Total actual person-years (floating point).
todelliset_henkilotyovuodet_yhteensa__int	int	Total actual person-years (integer).
toimiiko_museossa_vapaaehtoistyontekijoita	string	Are there voluntary workers at the museum?
toimiiko_museossa_vapaaehtoistyontekijoita__float	float	Are there voluntary workers at the museum? (floating point).
vapaaehtoistyontekijoiden_tyopanos_tuntia_vuodessa	int	The total number of hours worked by volunteers 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 (floating point).
maksaneet_kavijat	int	Number of paying visitors.
ilmaiskavijat	int	Number of free visitors.
kavijat_yhteensa	int	Total number of visitors.
kavijoista_koululaisryhmien_kavijat	int	Number of visitors from school groups.
ulkomaalaisten_kavijoiden_lukumaara	int	Number of 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 the admission to the basic exhibition free?
onko_museon_perusnayttelyyn_ilmainen_sisaanpaasy__float	float	Is the admission to the basic exhibition free? (floating point).
paasymaksu_perusnayttelyyn__aikuinen	float	Admission fee for adults to the basic exhibition.
paasymaksu_erikoisnayttelyihin__aikuinen	float	Admission fee for adults to special exhibitions.
paasymaksu_perusnayttelyyn__lapset	float	Admission fee for children to the basic exhibition.
kulttuurihistorialliset_kokoelmat	int	Cultural historical collections.
kulttuurihistoriallisista__kokoelmista_vuoden_kartunta	int	Increase in cultural historical collections during the year.
montako_objektia__kulttuurihistoriallisista_kokoelmista_on_luetteloitu_sahkoiseen_kokoelmahallintajarjestelmaan	int	Number of objects cataloged in the electronic collection management system from cultural historical collections.
montako_objektia_kulttuurihistoriallisista_kokoelmista_on_digitoitu	int	Number of objects digitized from cultural historical collections.
taidekokoelmat	int	Art collections.
taidekokoelmista_vuoden_kartunta	int	Increase in art collections during the year.
montako_objektia__taidekokoelmista_on_luetteloitu_sahkoiseen_kokoelmahallintajarjestelmaan	int	Number of objects cataloged in the electronic collection management system from art collections.
montako_objektia_taidekokoelmista_on_digitoitu	int	Number of objects digitized from art collections.
luonnontieteelliset_kokoelmat	int	Natural science collections.
luonnontieteellisista_kokoelmista_vuoden_kartunta	int	Increase in natural science collections during the year.
montako_objektia_luonnontieteellisista_kokoelmista_on_luetteloitu_sahkoiseen_kokoelmahallintajarjestelmaan	int	Number of objects cataloged in the electronic collection management system from natural science collections.
montako_objektia_luonnontieteellisista_kokoelmista_on_digitoitu	int	Number of objects digitized from natural science collections.
valokuvien_maara_kokoelmissa	int	Number of photographs in the collections.
valokuvista_vuoden_kartunta	int	Increase in the number of photographs during the year.
montako_objektia_valokuvista_on_luetteloitu_sahkoiseen_kokoelmahallintajarjestelmaan	int	Number of photographs cataloged in the electronic collection management system.
montako_objektia_valokuvista_on_digitoitu	int	Number of photographs digitized.
oma_tuotanto_museon_vaihtuvista_nayttelyista	int	Number of exhibitions produced by the museum itself.
yhteistyonayttelyt_museon_vaihtuvista_nayttelyista	int	Number of collaborative exhibitions with other organizations.
muiden_tuottamat_nayttelyt_museon_vaihtuvista_nayttelyista	int	Number of exhibitions produced by other organizations.
vaihtuvat_nayttelyt_yhteensa	int	Total number of temporary exhibitions.
valmistuneet_kiertonayttelyt	int	Number of completed touring exhibitions.
ulkomaille_tuotetut_nayttelyt	int	Number of 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 temporary exhibitions.
taideteollisuus___valokuvataide__ja_rakennustaidenayttelyiden_lukumaara_museon_vaihtuvista_nayttelyista	int	Number of exhibitions in the field of applied arts, photography and architectural art in the temporary exhibitions.
kulttuurihistoriallisten_ja_historiallisten_nayttelyiden_lukumaara_museon_vaihtuvista_nayttelyista	int	Number of cultural historical and historical exhibitions in the temporary exhibitions.
etnografisten_nayttelyiden_lukumaara_museon_vaihtuvista_nayttelyista	int	Number of ethnographic exhibitions in the temporary exhibitions.
tekniikan_ja_teollisuusnayttelyiden_lukumaara_museon_vaihtuvista_nayttelyista	int	Number of technology and industry exhibitions in the temporary exhibitions.
luonnonhistoriallisten_ja_luonnontieteellisten_nayttelyiden_lukumaara_museon_vaihtuvista_nayttelyista	int	Number of natural history and natural science exhibitions in the temporary exhibitions.
muiden_nayttelyiden_lukumaara_museon_vaihtuvista_nayttelyista	int	Number of other exhibitions in the temporary exhibitions.
vaihtuvat_nayttelyt_yhteensa_aihetyypin_mukaan	int	Total number of temporary exhibitions by subject type.
painetut_nayttelyjulkaisut	int	Printed exhibition publications.
painetut_tutkimukset	int	Printed research publications.
muut_painetut_julkaisut	int	Other printed publications.
painetut_julkaisut_yhteensa	int	Total number of printed publications.
elektroniset_julkaisut_cdt__dvdt	int	Electronic publications (CDs/DVDs).
verkkojulkaisut	int	Online publications.
kaikki_julkaisut_yhteensa	int	Total number of publications.
taidehistoriallisten_julkaisujen_lukumaara_museon_julkaisuista	int	Number of art historical publications.
taideteollisuus___valokuvataide__ja_rakennustaidejulkaisujen_lukumaara_museon_julkaisuista	int	Number of publications in the field of applied arts, photography, and architectural art.
kulttuurihistoriallisten_ja_historiallisten_julkaisujen_lukumaara_museon_julkaisuista	int	Number of cultural historical and historical publications.
etnografisten_julkaisujen_lukumaara_museon_julkaisuista	int	Number of ethnographic publications.
tekniikan_ja_teollisuusjulkaisujen_lukumaara_museon_julkaisuista	int	Number of technology and industry publications.
luonnonhistoriallisten_ja_luonnontieteellisten_julkaisujen_lukumaara_museon_julkaisuista	int	Number of natural history and natural science publications.
muiden_julkaisujen_lukumaara_museon_julkaisuista	int	Number of other publications.
julkaisut_yhteensa_aihetyypin_mukaan	int	Total number of publications by subject type.
onko_museolla_paate_museokavijoiden_kaytettavissa	string	Does the museum have a terminal available for museum visitors?
onko_museolla_paate_museokavijoiden_kaytettavissa__float	float	Does the museum have a terminal available for museum visitors? (floating point).
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? (floating point).

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

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

Additional Info

Last Updated	April 21, 2024
Created	April 21, 2024