Authors: Peter van Kranenburg
Part of: Tunes
Source: SPARQL endpoint
Export
{'sparql_endpoint': 'https://polifonia.disi.unibo.it/tunes/sparql', 'template_mode': 'statistics', 'title': 'Tunes Statistics', 'color_code': ['#39c6b4', '#17cf31'], 'section_name': 'Tunes', 'subtitle': '', 'curator': 'Peter van Kranenburg', 'description': 'The project is about relations between songs from different geographical origins.', 'action': 'save', 'dynamic_elements': [{'position': 0, 'operations': [], 'type': 'text', 'text': '<p>This data story presents relations between four collections of European Folk Songs: The Meertens Tune Collections (MTC) (Dutch), The Essen Folksong Collection (German), The Session corpus (Irish), and the Ceol Rince na hÉireann corpus (Irish).</p>', 'extra_queries': [], 'map_filters': []}, {'position': 1, 'operations': [], 'type': 'text', 'text': 'The total number of songs in the four collections is:', 'extra_queries': [], 'map_filters': []}, {'position': 2, 'operations': [], 'type': 'count', 'count_query': 'PREFIX tunesr: <http://w3id.org/polifonia/resource/tunes/>\r\nPREFIX mm: <http://w3id.org/polifonia/ontology/music-meta/>\r\nSELECT (COUNT(?s) AS ?count)\r\nWHERE {?s a mm:MusicEntity}', 'count_label': 'songs', 'extra_queries': [], 'map_filters': []}, {'position': 3, 'operations': [], 'type': 'text', 'text': '<p>Distributed over the collections as follow</p>', 'extra_queries': [], 'map_filters': []}, {'position': 4, 'operations': [], 'type': 'chart', 'chart_type': 'barchart', 'chart_title': ' Count of songs in the four collections', 'chart_query': 'PREFIX : <http://example.com/tunes/>\r\nSELECT ?label (COUNT(?content) AS ?count)\r\nWHERE {\r\n ?content a :Song .\r\n ?content :songcollection ?label .\r\n } GROUP BY ?label', 'chart_series': 'N. of songs per collection', 'chart_legend': {'x': 'collection', 'y': 'songs'}, 'extra_queries': [], 'map_filters': []}, {'position': 5, 'operations': [], 'type': 'text', 'text': "<p>The Meertens corpus (Dutch) contains Tune Family annotations. All songs that can be considered the 'same' song are grouped in a Tune Family. The total number of tune families:</p>", 'extra_queries': [], 'map_filters': []}, {'position': 6, 'operations': [], 'type': 'count', 'count_query': 'PREFIX : <http://example.com/tunes/>\r\nSELECT (COUNT(?s) AS ?count)\r\nWHERE {?s a :TuneFamily}', 'count_label': 'Tune families', 'extra_queries': [], 'map_filters': []}, {'position': 7, 'operations': [], 'type': 'text', 'text': '<p>For the Dutch data set, we also have metadata about the sources of the songs, including printed books, manuscripts, audio recordings, leaflets, etc. The number of sources for the Dutch songs is:</p>', 'extra_queries': [], 'map_filters': []}, {'position': 8, 'operations': [], 'type': 'count', 'count_query': 'PREFIX : <http://example.com/tunes/>\r\nSELECT (COUNT(?s) AS ?count)\r\nWHERE {?s a :Source}', 'count_label': 'sources ', 'extra_queries': [], 'map_filters': []}, {'position': 9, 'operations': [], 'type': 'chart', 'chart_type': 'linechart', 'chart_title': 'Distribution of Dutch sources over time', 'chart_query': 'PREFIX : <http://example.com/tunes/>\r\nSELECT ?label (COUNT(?content) AS ?count)\r\nWHERE {\r\nvalues (?label ?min ?max) {\r\n ("1500-1549" 1500 1549)\r\n ("1550-1599" 1550 1599)\r\n ("1600-1649" 1600 1649)\r\n ("1650-1699" 1650 1699)\r\n ("1700-1749" 1700 1749)\r\n ("1750-1799" 1750 1799)\r\n ("1800-1849" 1800 1849)\r\n ("1850-1899" 1850 1899)\r\n ("1900-1949" 1900 1949)\r\n ("1950-1999" 1950 1999)\r\n ("2000-2049" 2000 2049) }\r\n \r\n ?content a :Source .\r\n ?content :sourcesortingyear ?year .\r\n \r\n filter( ?min <= ?year && ?year <= ?max)\r\n \r\n } GROUP BY ?label\r\nORDER BY ASC(?label)', 'chart_series': 'N. of sources per period', 'chart_legend': {'x': 'time period', 'y': 'n. of sources'}, 'extra_queries': [], 'map_filters': []}, {'position': 10, 'operations': [], 'type': 'text', 'text': '<p>We are interested in relations between the songs from different geographic origins. Therefore, we compute the similarity between all pairs of songs. Songs with high similarity across collections are specifically of interest.</p>', 'extra_queries': [], 'map_filters': []}, {'position': 11, 'operations': [], 'type': 'chart', 'chart_type': 'barchart', 'chart_title': 'Count of highly similar song pairs across collections', 'chart_query': 'PREFIX : <http://example.com/tunes/>\r\nSELECT ?label (COUNT(?song) AS ?count)\r\nWHERE {\r\n ?song :highlysimilar ?othersong .\r\n ?song :songcollection ?labela .\r\n ?othersong :songcollection ?labelb .\r\n BIND(concat(str(?labela), "-", str(?labelb) ) as ?label)\r\n } GROUP BY ?label', 'chart_series': 'N. of similar songs per collection', 'chart_legend': {'x': 'collection', 'y': 'N. of similar songs'}, 'extra_queries': [], 'map_filters': []}, {'position': 12, 'operations': [], 'type': 'text', 'text': '<p>This shows that the Dutch and German collections are stronger connected than the Dutch and the Irish, while, not surprisingly, the two Irish collections have a large number of songs in common.</p>', 'extra_queries': [], 'map_filters': []}]}
The project is about relations between songs from different geographical origins.