{"id":1747,"date":"2026-07-08T06:21:00","date_gmt":"2026-07-08T06:21:00","guid":{"rendered":"https:\/\/www.etkad.ee\/?p=1747"},"modified":"2026-07-08T06:37:13","modified_gmt":"2026-07-08T06:37:13","slug":"teraviljadega-seotud-regilaulude-leviku-analuus-eestis","status":"publish","type":"post","link":"https:\/\/www.etkad.ee\/en\/humal\/toovood\/teraviljadega-seotud-regilaulude-leviku-analuus-eestis\/","title":{"rendered":"Analysis of the Distribution of Estonian Runo Songs Related to Grains"},"content":{"rendered":"<div class=\"wp-block-group is-layout-constrained wp-block-group-is-layout-constrained\"><div class=\"kb-row-layout-wrap kb-row-layout-id1747_da09b4-cc alignnone wp-block-kadence-rowlayout\"><div class=\"kt-row-column-wrap kt-has-2-columns kt-row-layout-equal kt-tab-layout-inherit kt-mobile-layout-row kt-row-valign-top\">\n\n<div class=\"wp-block-kadence-column kadence-column1747_6cdeef-39\"><div class=\"kt-inside-inner-col\">\n<p class=\"wp-block-paragraph\">We are working with the Estonian runosongs' database, which contains runosong texts and the metadata associated with them. The aim of the project is to study the geographical distribution of work songs containing references to grain types and to analyse which grains are mentioned most frequently in different regions. Through the analysis, we aim to identify possible regional patterns and examine how and whether runosongs might reflect historical agriculture.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><br><a href=\"https:\/\/www.folklore.ee\/regilaul\/andmebaas\">Runosongs' database<\/a> contains various types of metadata, including song titles, themes, song texts, places of collection, collectors, performers, and dates of collection. It is important to note that not all types of metadata are fully available for every song.<\/p>\n<\/div><\/div>\n\n\n\n<div class=\"wp-block-kadence-column kadence-column1747_23104b-68\"><div class=\"kt-inside-inner-col\">\n<ul class=\"wp-block-list has-theme-palette-8-background-color has-background\">\n<li><strong>Authors:<\/strong>\n<ul class=\"wp-block-list\">\n<li>Mirelle Kiholane (University of Tartu)<\/li>\n\n\n\n<li>Helena Kalm (University of Tartu)<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>Licence:<\/strong> <a href=\"https:\/\/creativecommons.org\/licenses\/by\/4.0\/\">CC-BY-4.0<\/a><\/li>\n\n\n\n<li><strong>Date\/version:<\/strong> 29.05.2026<\/li>\n\n\n\n<li><strong>Subject field:<\/strong> <a href=\"https:\/\/www.etkad.ee\/en\/eriala\/folkloristika\/\" data-type=\"eriala\" data-id=\"82\">folkloristics<\/a><\/li>\n\n\n\n<li><strong>Data media type:<\/strong> <a href=\"https:\/\/www.etkad.ee\/en\/andmete-meediatuup\/tekst\/\" data-type=\"andmete-meediatuup\" data-id=\"91\">text<\/a>, <a href=\"https:\/\/www.etkad.ee\/en\/andmete-meediatuup\/metaandmed\/\" data-type=\"andmete-meediatuup\" data-id=\"86\">metadata<\/a><\/li>\n\n\n\n<li><strong>Keywords (content): <\/strong><a href=\"https:\/\/ems.elnet.ee\/id\/EMS162644\">grains<\/a>, <a href=\"https:\/\/ems.elnet.ee\/id\/EMS020697\">runo songs<\/a><\/li>\n\n\n\n<li><strong>Keywords (<a href=\"https:\/\/tadirah.info\/index.html\" target=\"_blank\" rel=\"noreferrer noopener\">Tadirah<\/a>):<\/strong> <a href=\"https:\/\/www.etkad.ee\/en\/marksonad\/kollatsioonimine\/\" data-type=\"marksonad\" data-id=\"114\">Collating<\/a>, <a href=\"https:\/\/www.etkad.ee\/en\/marksonad\/sisuanaluus\/\" data-type=\"marksonad\" data-id=\"54\">content analysis<\/a>, <a href=\"https:\/\/www.etkad.ee\/en\/marksonad\/geoviitamine\/\" data-type=\"marksonad\" data-id=\"108\">georeferencing<\/a>, <a href=\"https:\/\/www.etkad.ee\/en\/marksonad\/andmete-visualiseerimine\/\" data-type=\"marksonad\" data-id=\"11\">data visualization<\/a>, <a href=\"https:\/\/www.etkad.ee\/en\/marksonad\/andmete-graafiline-kujutamine\/\" data-type=\"marksonad\" data-id=\"115\">plotting<\/a>, <a href=\"https:\/\/www.etkad.ee\/en\/marksonad\/lemmatiseerimine\/\" data-type=\"marksonad\" data-id=\"22\">lemmatizing<\/a>, <a href=\"https:\/\/www.etkad.ee\/en\/marksonad\/andmekaeve\/\" data-type=\"marksonad\" data-id=\"9\">data mining<\/a><\/li>\n\n\n\n<li><strong>Output:<\/strong> <a href=\"https:\/\/www.etkad.ee\/en\/valjund\/andmestik\/\" data-type=\"valjund\" data-id=\"93\">dataset<\/a>, <a href=\"https:\/\/www.etkad.ee\/en\/valjund\/visualiseering\/\" data-type=\"valjund\" data-id=\"98\">data visualization<\/a> <\/li>\n\n\n\n<li><strong>Related materials:<\/strong>\n<ul class=\"wp-block-list\">\n<li>Mirelle Kiholane, Helena Kalm. <a href=\"https:\/\/webrepo.kirmus.ee\/Kultuuriandmete_projekt\/Regilaulud\"><em>Analysis of the distribution area of \u200b\u200bEstonian agricultural runosongs<\/em>.<\/a> Cultural Data Project, University of Tartu\/Estonian Literary Museum, 2026. <\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/div><\/div>\n\n<\/div><\/div>\n\n\n<figure data-wp-context=\"{&quot;imageId&quot;:&quot;6a55e28fd7f80&quot;}\" data-wp-interactive=\"core\/image\" data-wp-key=\"6a55e28fd7f80\" class=\"wp-block-image size-full wp-lightbox-container\"><img loading=\"lazy\" decoding=\"async\" width=\"440\" height=\"945\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on--click=\"actions.showLightbox\" data-wp-on--load=\"callbacks.setButtonStyles\" data-wp-on--pointerdown=\"actions.preloadImage\" data-wp-on--pointerenter=\"actions.preloadImageWithDelay\" data-wp-on--pointerleave=\"actions.cancelPreload\" data-wp-on-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/www.etkad.ee\/wp-content\/uploads\/2026\/06\/regilaulud_eng.drawio.png\" alt=\"\" class=\"wp-image-1749\" srcset=\"https:\/\/www.etkad.ee\/wp-content\/uploads\/2026\/06\/regilaulud_eng.drawio.png 440w, https:\/\/www.etkad.ee\/wp-content\/uploads\/2026\/06\/regilaulud_eng.drawio-140x300.png 140w, https:\/\/www.etkad.ee\/wp-content\/uploads\/2026\/06\/regilaulud_eng.drawio-6x12.png 6w\" sizes=\"auto, (max-width: 440px) 100vw, 440px\" \/><button\n\t\t\tclass=\"lightbox-trigger\"\n\t\t\ttype=\"button\"\n\t\t\taria-haspopup=\"dialog\"\n\t\t\tdata-wp-bind--aria-label=\"state.thisImage.triggerButtonAriaLabel\"\n\t\t\tdata-wp-init=\"callbacks.initTriggerButton\"\n\t\t\tdata-wp-on--click=\"actions.showLightbox\"\n\t\t\tdata-wp-style--right=\"state.thisImage.buttonRight\"\n\t\t\tdata-wp-style--top=\"state.thisImage.buttonTop\"\n\t\t>\n\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"12\" height=\"12\" fill=\"none\" viewbox=\"0 0 12 12\">\n\t\t\t\t<path fill=\"#fff\" d=\"M2 0a2 2 0 0 0-2 2v2h1.5V2a.5.5 0 0 1 .5-.5h2V0H2Zm2 10.5H2a.5.5 0 0 1-.5-.5V8H0v2a2 2 0 0 0 2 2h2v-1.5ZM8 12v-1.5h2a.5.5 0 0 0 .5-.5V8H12v2a2 2 0 0 1-2 2H8Zm2-12a2 2 0 0 1 2 2v2h-1.5V2a.5.5 0 0 0-.5-.5H8V0h2Z\" \/>\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n<\/div>\n\n\n\n<div class=\"wp-block-group alignfull is-layout-constrained wp-block-group-is-layout-constrained\"><div class=\"kb-row-layout-wrap kb-row-layout-id1747_7c465c-46 alignfull has-light-beige-background-color kt-row-has-bg wp-block-kadence-rowlayout\"><div class=\"kt-row-column-wrap kt-has-1-columns kt-row-layout-equal kt-tab-layout-inherit kt-mobile-layout-row kt-row-valign-top kb-theme-content-width\">\n\n<div class=\"wp-block-kadence-column kadence-column1747_a47433-96 kb-section-dir-vertical inner-column-1\"><div class=\"kt-inside-inner-col\"><div class=\"kb-row-layout-wrap kb-row-layout-id1747_0618cb-0e alignnone wp-block-kadence-rowlayout\"><div class=\"kt-row-column-wrap kt-has-1-columns kt-row-layout-equal kt-tab-layout-inherit kt-mobile-layout-row kt-row-valign-top\">\n\n<div class=\"wp-block-kadence-column kadence-column1747_262eba-c0\"><div class=\"kt-inside-inner-col\">\n<h1 class=\"kt-adv-heading1747_08a2c0-7e wp-block-kadence-advancedheading has-theme-palette-3-color has-text-color\" data-kb-block=\"kb-adv-heading1747_08a2c0-7e\">Workflow steps<\/h1>\n\n\n\n<div class=\"wp-block-kadence-accordion alignnone\"><div class=\"kt-accordion-wrap kt-accordion-id1747_d9578a-73 kt-accordion-has-15-panes kt-active-pane-0 kt-accordion-block kt-pane-header-alignment-left kt-accodion-icon-style-basic kt-accodion-icon-side-left\" style=\"max-width:none\"><div class=\"kt-accordion-inner-wrap\" data-allow-multiple-open=\"false\" data-start-open=\"0\">\n<div class=\"wp-block-kadence-pane kt-accordion-pane kt-accordion-pane-1 kt-pane1747_c91f9c-94\"><div class=\"kt-accordion-header-wrap\"><button class=\"kt-blocks-accordion-header kt-acccordion-button-label-show\" type=\"button\"><span class=\"kt-blocks-accordion-title-wrap\"><span class=\"kt-blocks-accordion-title\">1. Selection of grains<\/span><\/span><span class=\"kt-blocks-accordion-icon-trigger\"><\/span><\/button><\/div><div class=\"kt-accordion-panel kt-accordion-panel-hidden\"><div class=\"kt-accordion-panel-inner\">\n<p class=\"wp-block-paragraph\"><strong>Keywords: <\/strong><a href=\"https:\/\/www.etkad.ee\/en\/marksonad\/sirvimine\/\" data-type=\"marksonad\" data-id=\"116\">Browsing<\/a>, <a href=\"https:\/\/www.etkad.ee\/en\/marksonad\/otsing\/\" data-type=\"marksonad\" data-id=\"117\">searching<\/a>, <a href=\"https:\/\/www.etkad.ee\/en\/marksonad\/infootsing\/\" data-type=\"marksonad\" data-id=\"37\">information retrieval<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The aim of the first stage was to determine which grains could be used for the analysis. Identifying these was the basis of our work, since database queries cannot be made without precise inputs. The initial selection of types of grain was developed in cooperation with the mentor, from whom we asked which grains have historically been the most important in Estonia. The resulting list consisted of wheat, oats, buckwheat, rye, and barley. We found that a list of five types of grain would be sufficiently comprehensive for this project. The first SQL queries and visualisations were made using these grains in order to check their presence and word forms. In the third stage, this list was expanded in cooperation with the content mentor to include Estonian dialectal and inflected forms.<\/p>\n<\/div><\/div><\/div>\n\n\n\n<div class=\"wp-block-kadence-pane kt-accordion-pane kt-accordion-pane-2 kt-pane1747_0a3150-d1\"><div class=\"kt-accordion-header-wrap\"><button class=\"kt-blocks-accordion-header kt-acccordion-button-label-show\" type=\"button\"><span class=\"kt-blocks-accordion-title-wrap\"><span class=\"kt-blocks-accordion-title\">2. Analysis of the SQL database<\/span><\/span><span class=\"kt-blocks-accordion-icon-trigger\"><\/span><\/button><\/div><div class=\"kt-accordion-panel kt-accordion-panel-hidden\"><div class=\"kt-accordion-panel-inner\">\n<p class=\"wp-block-paragraph\"><strong>Keywords:<\/strong> <a href=\"https:\/\/www.etkad.ee\/en\/marksonad\/eeltootlus\/\" data-type=\"marksonad\" data-id=\"14\">preprocessing<\/a>, <a href=\"https:\/\/www.etkad.ee\/en\/marksonad\/uurimine\/\" data-type=\"marksonad\" data-id=\"44\">exploration<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">At this stage, we became familiar for the first time with the <a href=\"https:\/\/a3s.fi\/filter-db-doc\/filter-db.html\">FILTER database<\/a>used in the project. Before making queries, we read the accompanying additional materials, such as the database schema and user guide, in order to understand the general structure and the logic of query creation. Becoming familiar with the database enabled us to define clearer goals and establish a system for creating queries in the following stages.<\/p>\n<\/div><\/div><\/div>\n\n\n\n<div class=\"wp-block-kadence-pane kt-accordion-pane kt-accordion-pane-3 kt-pane1747_469d5c-82\"><div class=\"kt-accordion-header-wrap\"><button class=\"kt-blocks-accordion-header kt-acccordion-button-label-show\" type=\"button\"><span class=\"kt-blocks-accordion-title-wrap\"><span class=\"kt-blocks-accordion-title\">3. List of dialectal and inflected forms of grain names<\/span><\/span><span class=\"kt-blocks-accordion-icon-trigger\"><\/span><\/button><\/div><div class=\"kt-accordion-panel kt-accordion-panel-hidden\"><div class=\"kt-accordion-panel-inner\">\n<p class=\"wp-block-paragraph\"><strong>Keywords:<\/strong> <a href=\"https:\/\/www.etkad.ee\/en\/marksonad\/eeltootlus\/\" data-type=\"marksonad\" data-id=\"14\">Preprocessing<\/a>, <a href=\"https:\/\/www.etkad.ee\/en\/marksonad\/lemmatiseerimine\/\" data-type=\"marksonad\" data-id=\"22\">lemmatizing<\/a>, <a href=\"https:\/\/www.etkad.ee\/en\/marksonad\/teisendamine\/\" data-type=\"marksonad\" data-id=\"118\">transformation<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This stage focuses on the inflected and dialectal variants of the selected grains. Since runosongs contain dialectal forms and historical language use, it was necessary to compile an expanded list of word forms. This helped reduce situations in which important textual information would be missed because of an overly simplified keyword search. Word inflections also have to be taken into account, as they make word search more difficult.\n\nFor this purpose, the content mentor shared with us a list that included most of the dialectal and inflected variants of wheat, oats, rye, barley, and buckwheat. This list was cleaned with the help of ChatGPT in order to group the variants under the corresponding grain type, which would later be needed for word search in the SQL code and for compiling tables.<\/p>\n<\/div><\/div><\/div>\n\n\n\n<div class=\"wp-block-kadence-pane kt-accordion-pane kt-accordion-pane-4 kt-pane1747_2ad30e-de\"><div class=\"kt-accordion-header-wrap\"><button class=\"kt-blocks-accordion-header kt-acccordion-button-label-show\" type=\"button\"><span class=\"kt-blocks-accordion-title-wrap\"><span class=\"kt-blocks-accordion-title\">4. Creating the SQL script<\/span><\/span><span class=\"kt-blocks-accordion-icon-trigger\"><\/span><\/button><\/div><div class=\"kt-accordion-panel kt-accordion-panel-hidden\"><div class=\"kt-accordion-panel-inner\">\n<p class=\"wp-block-paragraph\"><strong>Keywords: <\/strong><a href=\"https:\/\/www.etkad.ee\/en\/marksonad\/andmete-visualiseerimine\/\" data-type=\"marksonad\" data-id=\"11\">Data visualization<\/a>, <a href=\"https:\/\/www.etkad.ee\/en\/marksonad\/paringud\/\" data-type=\"marksonad\" data-id=\"66\">querying<\/a>, <a href=\"https:\/\/www.etkad.ee\/en\/marksonad\/andmekaeve\/\" data-type=\"marksonad\" data-id=\"9\">data mining<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The aim of this stage was to create an SQL script that would find Estonian-language runosongs in the FILTER database with the subcategory of work songs, mentioning our selected words, together with the locations of the songs.<br>The choice to focus only on work songs was made because, in the course of our work, we wanted to see where these grains were cultivated in agricultural contexts. We therefore excluded other song types that might contain these grain types, since they were not substantively relevant to our project. The SQL database program DBeaver was used to write the script. For this, we used the tables identified in the second stage, which contained information important to us, such as words, location, and ID values from specific tables. ID values make it possible to create links between different tables, combine data from different tables, and create one new table. For word search, we used the list created in the previous stage, divided by grain names, so that the table would immediately include the base form of the word.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Several different tables were created. The tables focus on presenting different results. One table shows the occurrence of each mentioned grain in all parishes, both as a number and as a relative frequency, taking into account how many songs were collected in each parish overall and calculating a percentage value for the frequency of each grain type per 100 songs. This is important because in some regions significantly more songs have been collected, which can distort the results. There is also a table showing exactly in which song and verse the word was found, together with the original variant of the word. Another table shows the most frequently mentioned cereal in each parish and its frequency, and there is also a table in which the frequencies of cereals are added together and, on that basis, the relative frequency is calculated for each parish. These data were downloaded as CSV files<br>which can later be used to create visualisations such as maps and tables. These tables are also an important part of the final analysis, because they show which cereals were important in which places, together with their<br>frequencies.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n<\/div><\/div><\/div>\n\n\n\n<div class=\"wp-block-kadence-pane kt-accordion-pane kt-accordion-pane-10 kt-pane1747_d9d0c3-38\"><div class=\"kt-accordion-header-wrap\"><button class=\"kt-blocks-accordion-header kt-acccordion-button-label-show\" type=\"button\"><span class=\"kt-blocks-accordion-title-wrap\"><span class=\"kt-blocks-accordion-title\">5. Visualisation as tables in R<\/span><\/span><span class=\"kt-blocks-accordion-icon-trigger\"><\/span><\/button><\/div><div class=\"kt-accordion-panel kt-accordion-panel-hidden\"><div class=\"kt-accordion-panel-inner\">\n<p class=\"wp-block-paragraph\"><strong>Keywords: <\/strong><a href=\"https:\/\/www.etkad.ee\/en\/marksonad\/andmete-graafiline-kujutamine\/\" data-type=\"marksonad\" data-id=\"115\">plotting<\/a>, <a href=\"https:\/\/www.etkad.ee\/en\/marksonad\/programmeerimine\/\" data-type=\"marksonad\" data-id=\"119\">programming<\/a>, <a href=\"https:\/\/www.etkad.ee\/en\/marksonad\/diagrammide-koostamine\/\" data-type=\"marksonad\" data-id=\"12\">diagramming<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The aim of this stage was to create visualisations based on the tables generated with the SQL script, making it possible to see and analyse more clearly the regional distribution of songs related to grain cultivation and the frequency of occurrence of different grain types. The visualisation was carried out in RStudio using the packages ggplot2, dplyr, and tidyverse. R was chosen because of previous experience with it, and also because it allows the data to be processed precisely before visualisation and produces figures that are reproducible through code. To make the data easier to compare, they were normalised. The occurrences of all cereal types in each region were added together and divided by the total number of songs from that region. The result was a percentage showing the share of songs related to grain cultivation among all songs collected from the region. In addition, a minimum threshold was established: only regions where at least 30 songs had been collected were included in the analysis. The choice of threshold was based on the results of the CSV tables. This was necessary for the accuracy of the results, because in regions with a small number of songs, individual occurrences could form a disproportionately large share of the final results, thereby distorting the accuracy of the overall comparison.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Four figures were created: a bar chart showing the general frequency of occurrence of grain types, a bar chart comparing the occurrence of agricultural work songs, a stacked bar chart showing the share of grain types by region, and a heatmap giving an overview of all grain-type and region combinations. For diagrams containing regions, the results were calculated for the 20 regions with the highest shares. This stage was directly based on the SQL script created in the previous stage, which produced the normalised summary tables needed for the analysis. The figures from this stage also support the maps created in the following stage and make it possible to see the numerical results more clearly.<\/p>\n<\/div><\/div><\/div>\n\n\n\n<div class=\"wp-block-kadence-pane kt-accordion-pane kt-accordion-pane-13 kt-pane1747_24a370-cc\"><div class=\"kt-accordion-header-wrap\"><button class=\"kt-blocks-accordion-header kt-acccordion-button-label-show\" type=\"button\"><span class=\"kt-blocks-accordion-title-wrap\"><span class=\"kt-blocks-accordion-title\">6. Creating maps<\/span><\/span><span class=\"kt-blocks-accordion-icon-trigger\"><\/span><\/button><\/div><div class=\"kt-accordion-panel kt-accordion-panel-hidden\"><div class=\"kt-accordion-panel-inner\">\n<p class=\"wp-block-paragraph\"><strong>Keywords: <\/strong><a href=\"https:\/\/www.etkad.ee\/en\/marksonad\/andmete-visualiseerimine\/\" data-type=\"marksonad\" data-id=\"11\">data visualization<\/a>, <a href=\"https:\/\/www.etkad.ee\/en\/marksonad\/geoviitamine\/\" data-type=\"marksonad\" data-id=\"108\">georeferencing<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This stage focuses on visualising the completed data tables in order to create interactive maps showing locations and the occurrence of cereals in the specified places. The website Datawrapper was used to create the interactive maps, as it allows users to upload their own data and process them easily on a selected map with little code. Datawrapper supports Estonian-language data and also offers various maps of Estonia, but for our data we needed a map of Estonia that included historical parishes that no longer exist today. In the map application of the Estonian Land Board geoportal, we found a historical map of Estonian parishes, showing parishes up to 1917, which matched our data almost perfectly. We downloaded this map as a GEOJSON file and uploaded it to Datawrapper. This made it possible to visualise the data according to our locations. It should be noted that Setomaa was missing from the map and had been included under Vastseliina. Since the Setomaa data were significantly larger than the Vastseliina data, we decided to use the Setomaa data in the place of Vastseliina on the map.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">A total of three maps were created. \u201cOccurrence of grain types per 100 songs\u201d shows for the runosongs of each parish the most frequently mentioned grain, its relative frequency in percentages, and the number of occurrences. This visualisation makes it possible to see which parishes may have been more important in Estonian grain cultivation and which cereals they may have been associated with. \u201cFrequency of grain mentions in parishes\u201d shows the frequency of grains mentioned in the runosongs of each parish, considering all the grain types together. Data were included only from parishes where at least 30 songs had been collected, because smaller results can make relative frequency unstable. This map shows which parishes may have been most important in grain cultivation, considering the selected grain types. The third map shows the mention frequency of each grain type in each parish, displaying the most frequently mentioned grain for each parish and using colours to distinguish the grain types. This map helps visualise larger regions that were associated with the grains mentioned in the songs.<\/p>\n<\/div><\/div><\/div>\n\n\n\n<div class=\"wp-block-kadence-pane kt-accordion-pane kt-accordion-pane-14 kt-pane1747_8c7b51-49\"><div class=\"kt-accordion-header-wrap\"><button class=\"kt-blocks-accordion-header kt-acccordion-button-label-show\" type=\"button\"><span class=\"kt-blocks-accordion-title-wrap\"><span class=\"kt-blocks-accordion-title\">7. Interpretation of the results<\/span><\/span><span class=\"kt-blocks-accordion-icon-trigger\"><\/span><\/button><\/div><div class=\"kt-accordion-panel kt-accordion-panel-hidden\"><div class=\"kt-accordion-panel-inner\">\n<p class=\"wp-block-paragraph\"><strong>Keywords:<\/strong> <a href=\"https:\/\/www.etkad.ee\/en\/marksonad\/sisuanaluus\/\" data-type=\"marksonad\" data-id=\"54\">Content analysis<\/a>, <a href=\"https:\/\/www.etkad.ee\/en\/marksonad\/vordlemine\/\" data-type=\"marksonad\" data-id=\"32\">comparing<\/a>, <a href=\"https:\/\/www.etkad.ee\/en\/marksonad\/selgitamine\/\" data-type=\"marksonad\" data-id=\"26\">explanation<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Agricultural songs containing the selected grains were most widespread primarily in Central, Southern, and South-Eastern Estonia. This result may indicate that grain cultivation played a more important role in these regions than elsewhere in Estonia. Runosongs were connected with everyday work and farm life, and their wider distribution may point to a stronger traditional influence of agriculture in these regions. At the same time, it is important to note that the regional distribution of cereal mentions may be influenced by a variety of factors, such as song traditions, collecting practices, or historical patterns. The results should therefore not be interpreted as exhaustive indicators, but rather as patterns that emerged from the study. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The account of agricultural history found in the work Science in the History of the Development of Estonian Agriculture, created by the Academic Agricultural Society, partly overlaps with our results. According to this account, Viljandi County, Tartu County, and partly J\u00e4rva County were among the most important agricultural regions in Estonia.\n\nAlthough historical accounts often emphasise the importance of rye as Estonia\u2019s main bread grain, the present analysis showed that oats were mentioned most frequently in runosongs instead. This may indicate that runosongs do not clearly reflect agricultural importance, but rather everyday work practices and peasant life. The year in which the songs were created must also be taken into account, as this is often unclear. Rye began to gain importance in agricultural research from 1918 onward, but a large share of folk songs may represent older results. The frequent occurrence of oats may be connected with their widespread use in farm economies, for example as animal feed. Since work songs were connected with everyday farm labour, oats may have been more visible in agricultural practice than other types of grain.<\/p>\n<\/div><\/div><\/div>\n<\/div><\/div><\/div>\n<\/div><\/div>\n\n<\/div><\/div><\/div><\/div>\n\n<\/div><\/div><\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>","protected":false},"excerpt":{"rendered":"<p>T\u00f6\u00f6tame Eesti regilaulude andmebaasiga, mis sisaldab regilaulude tekste ja nende juurde kuuluvaid metaandmeid. Projekti eesm\u00e4rk on uurida teravilju sisaldavate t\u00f6\u00f6laulude geograafilist levikut ning anal\u00fc\u00fcsida, milliseid teravilju erinevates piirkondades k\u00f5ige sagedamini mainitakse. Anal\u00fc\u00fcsi kaudu soovime leida v\u00f5imalikke regionaalseid mustreid ning uurida, kuidas ja kas regilaulud v\u00f5iksid peegeldada ajaloolist p\u00f5llunduskultuuri. Regilaulude andmebaas sisaldab mitmesuguseid metaandmeid, sealhulgas laulude [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[111,77],"tags":[],"marksonad":[9,115,11,12,14,108,37,114,22,117,66,119,26,116,54,118,44,32],"eriala":[82],"valjund":[93,98],"andmete-meediatuup":[86,91],"class_list":["post-1747","post","type-post","status-publish","format-standard","hentry","category-humal","category-toovood","marksonad-andmekaeve","marksonad-andmete-graafiline-kujutamine","marksonad-andmete-visualiseerimine","marksonad-diagrammide-koostamine","marksonad-eeltootlus","marksonad-geoviitamine","marksonad-infootsing","marksonad-kollatsioonimine","marksonad-lemmatiseerimine","marksonad-otsing","marksonad-paringud","marksonad-programmeerimine","marksonad-selgitamine","marksonad-sirvimine","marksonad-sisuanaluus","marksonad-teisendamine","marksonad-uurimine","marksonad-vordlemine","eriala-folkloristika","valjund-andmestik","valjund-visualiseering","andmete-meediatuup-metaandmed","andmete-meediatuup-tekst"],"_links":{"self":[{"href":"https:\/\/www.etkad.ee\/en\/wp-json\/wp\/v2\/posts\/1747","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.etkad.ee\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.etkad.ee\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.etkad.ee\/en\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.etkad.ee\/en\/wp-json\/wp\/v2\/comments?post=1747"}],"version-history":[{"count":9,"href":"https:\/\/www.etkad.ee\/en\/wp-json\/wp\/v2\/posts\/1747\/revisions"}],"predecessor-version":[{"id":1836,"href":"https:\/\/www.etkad.ee\/en\/wp-json\/wp\/v2\/posts\/1747\/revisions\/1836"}],"wp:attachment":[{"href":"https:\/\/www.etkad.ee\/en\/wp-json\/wp\/v2\/media?parent=1747"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.etkad.ee\/en\/wp-json\/wp\/v2\/categories?post=1747"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.etkad.ee\/en\/wp-json\/wp\/v2\/tags?post=1747"},{"taxonomy":"marksonad","embeddable":true,"href":"https:\/\/www.etkad.ee\/en\/wp-json\/wp\/v2\/marksonad?post=1747"},{"taxonomy":"eriala","embeddable":true,"href":"https:\/\/www.etkad.ee\/en\/wp-json\/wp\/v2\/eriala?post=1747"},{"taxonomy":"valjund","embeddable":true,"href":"https:\/\/www.etkad.ee\/en\/wp-json\/wp\/v2\/valjund?post=1747"},{"taxonomy":"andmete-meediatuup","embeddable":true,"href":"https:\/\/www.etkad.ee\/en\/wp-json\/wp\/v2\/andmete-meediatuup?post=1747"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}