Authors: Mari Wigham
Part of: Sound and Vision
Source: SPARQL endpoint
Export
{'sparql_endpoint': 'https://cat.apis.beeldengeluid.nl/sparql', 'template_mode': 'statistics', 'title': 'Dutch Broadcast Concert Collection', 'color_code': ['#05c8f0', '#ff00bc'], 'section_name': 'Sound and Vision', 'subtitle': 'Exploring live concerts on Dutch television and radio', 'curator': 'Mari Wigham', 'description': 'The Dutch Broadcast Concert Collection (Dutch name MOZ - Muziekopnamen Zendgemachtigden) contains recordings of concerts broadcast live by Dutch public service broadcasters, and metadata describing the recordings, including related persons.', 'action': 'save', 'dynamic_elements': [{'position': 0, 'operations': [], 'type': 'count', 'count_query': 'PREFIX schema: <http://schema.org/>\r\nPREFIX sdo: <https://schema.org/>\r\nPREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>\r\nPREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>\r\n\r\n\r\nSELECT DISTINCT (COUNT(?program) AS ?count) \r\nWHERE { \r\n\r\n \t?series <https://schema.org/name> "Muziekopnamen Zendgemachtigden (MOZ)"^^xsd:string . \r\n\t?season sdo:partOfSeries ?series . \r\n ?program sdo:partOfSeason ?season . \r\n}', 'count_label': 'concerts', 'extra_queries': []}, {'position': 1, 'operations': [], 'type': 'count', 'count_query': 'PREFIX schema: <http://schema.org/>\r\nPREFIX skos: <http://www.w3.org/2004/02/skos/core#>\r\nPREFIX sdo: <https://schema.org/>\r\nPREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>\r\nPREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>\r\n\r\nSELECT (COUNT(distinct ?entityName) as ?count)\r\nWHERE {\r\n?series <https://schema.org/name> "Muziekopnamen Zendgemachtigden (MOZ)"^^xsd:string . \r\n\t?season sdo:partOfSeries ?series . \r\n ?program_uri sdo:partOfSeason ?season . \r\n {\r\n ?program_uri a sdo:CreativeWork ;\r\n (sdo:about|sdo:mentions|sdo:creator|sdo:contributor|sdo:actor|sdo:crew|sdo:performer)/\r\n (sdo:about|sdo:mentions|sdo:creator|sdo:contributor|sdo:actor|sdo:crew|sdo:performer) ?entity .\r\n ?entity skos:prefLabel ?entityName\r\n }\r\n UNION\r\n {\r\n ?program_uri sdo:isPartOfSeason ?season .\r\n\r\n ?season (sdo:about|sdo:mentions|sdo:creator|sdo:contributor|sdo:actor|sdo:crew|sdo:performer)/\r\n (sdo:about|sdo:mentions|sdo:creator|sdo:contributor|sdo:actor|sdo:crew|sdo:performer) ?entity .\r\n\r\n ?entity skos:prefLabel ?entityName\r\n }\r\n UNION\r\n {\r\n ?program_uri sdo:isPartOfSeason/sdo:isPartOfSeries ?series .\r\n\r\n ?series (sdo:about|sdo:mentions|sdo:creator|sdo:contributor|sdo:actor|sdo:crew|sdo:performer)/\r\n (sdo:about|sdo:mentions|sdo:creator|sdo:contributor|sdo:actor|sdo:crew|sdo:performer) ?entity .\r\n\r\n ?entity skos:prefLabel ?entityName\r\n }\r\n UNION\r\n {\r\n ?scene sdo:hasPart ?program_uri.\r\n\r\n ?scene (sdo:about|sdo:mentions|sdo:creator|sdo:contributor|sdo:actor|sdo:crew|sdo:performer)/\r\n (sdo:about|sdo:mentions|sdo:creator|sdo:contributor|sdo:actor|sdo:crew|sdo:performer) ?entity .\r\n\r\n ?entity skos:prefLabel ?entityName \r\n }\r\n} ', 'count_label': 'related persons', 'extra_queries': []}, {'position': 2, 'operations': [], 'type': 'chart', 'chart_type': 'linechart', 'chart_title': 'Distribution of concerts over time', 'chart_query': 'PREFIX schema: <http://schema.org/>\r\nPREFIX sdo: <https://schema.org/>\r\nPREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>\r\nPREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>\r\nPREFIX xsd: <http://www.w3.org/2001/XMLSchema#>\r\n\r\n\r\nSELECT ?label\r\nWHERE {\r\n \t?series <https://schema.org/name> "Muziekopnamen Zendgemachtigden (MOZ)"^^xsd:string . \r\n\t?season sdo:partOfSeries ?series . \r\n ?program sdo:partOfSeason ?season . \r\n ?program <https://schema.org/datePublished> ?date .\r\n BIND(substr(?date, 1, 4) as ?label)} ', 'chart_series': 'concerts', 'chart_legend': {'x': 'year', 'y': 'concerts'}, 'extra_queries': []}, {'position': 3, 'operations': [], 'type': 'text', 'text': '<p>The concerts span a time range from 1934 through to the present day. Note that the data point in 1900 comes from a concert that cannot be more precisely dated than to the twentieth century.</p>', 'extra_queries': []}, {'position': 4, 'operations': [], 'type': 'chart', 'chart_type': 'doughnutchart', 'chart_title': 'Roles of persons in the concert collection', 'chart_query': 'PREFIX schema: <http://schema.org/>\r\nPREFIX skos: <http://www.w3.org/2004/02/skos/core#>\r\nPREFIX sdo: <https://schema.org/>\r\nPREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>\r\nPREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>\r\n\r\n# Toon alleen items die ook op GPP te bekijken/beluisteren zijn.\r\nSELECT ?count ?label\r\nWHERE{\r\n {\r\nSELECT (COUNT(distinct ?entityName) as ?count) ?role\r\nWHERE {\r\n?series <https://schema.org/name> "Muziekopnamen Zendgemachtigden (MOZ)"^^xsd:string . \r\n\t?season sdo:partOfSeries ?series . \r\n ?program_uri sdo:partOfSeason ?season . \r\n ?program_uri a sdo:CreativeWork .\r\n ?program_uri ?role ?roleEntity . ?roleEntity ?role ?entity .\r\n ?entity skos:prefLabel ?entityName\r\n } group by ?role LIMIT 3}\r\n?role rdfs:label ?label}order by desc(?count)', 'chart_series': '', 'chart_legend': {'x': '', 'y': ''}, 'extra_queries': []}, {'position': 5, 'operations': [], 'type': 'text', 'text': '<p>Persons in the collection either performed music, or created it, or were simply mentioned in the concert metadata. The donut chart above shows that most of the persons included in the collection have the role of performer (linked to concerts with the property byArtist).</p>', 'extra_queries': []}, {'position': 6, 'operations': [], 'type': 'chart', 'chart_type': 'barchart', 'chart_title': 'Top 5 most frequently occurring creators', 'chart_query': 'PREFIX schema: <http://schema.org/>\r\nPREFIX skos: <http://www.w3.org/2004/02/skos/core#>\r\nPREFIX sdo: <https://schema.org/>\r\nPREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>\r\nPREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>\r\n\r\n# Toon alleen items die ook op GPP te bekijken/beluisteren zijn.\r\nSELECT ?count ?label\r\nWHERE{\r\n {\r\nSELECT (COUNT(distinct ?program_uri) as ?count) ?label\r\nWHERE {\r\n?series <https://schema.org/name> "Muziekopnamen Zendgemachtigden (MOZ)"^^xsd:string . \r\n\t?season sdo:partOfSeries ?series . \r\n ?program_uri sdo:partOfSeason ?season . \r\n {\r\n ?program_uri a sdo:CreativeWork ;\r\n sdo:creator/sdo:creator ?entity .\r\n ?entity skos:prefLabel ?label\r\n }\r\n UNION\r\n {\r\n ?program_uri sdo:isPartOfSeason ?season .\r\n\r\n ?season sdo:creator/sdo:creator ?entity .\r\n\r\n ?entity skos:prefLabel ?label\r\n }\r\n UNION\r\n {\r\n ?program_uri sdo:isPartOfSeason/sdo:isPartOfSeries ?series .\r\n\r\n ?series sdo:creator/sdo:creator ?entity .\r\n\r\n ?entity skos:prefLabel ?label\r\n }\r\n UNION\r\n {\r\n ?scene sdo:hasPart ?program_uri.\r\n\r\n ?scene sdo:creator/sdo:creator?entity .\r\n\r\n ?entity skos:prefLabel ?label \r\n }\r\n } group by ?label }}order by desc(?count) LIMIT 5', 'chart_series': 'N. of creators', 'chart_legend': {'x': 'creator', 'y': 'frequency '}, 'extra_queries': []}, {'position': 7, 'operations': [], 'type': 'text', 'text': "<p>This graph shows the top five most frequently occurring creators in the concert collection. International classical composers such as Beethoven and Mozart are mixed with modern musicians such as Jean-Pierre Gabriël, who conducts multiple orchestras in the Netherlands, Ron Ford, a Dutch-American composer, and Myrthe van Dijk, who composed songs for the iconic 'Kinderen voor Kinderen' youth choir.</p>", 'extra_queries': []}, {'position': 8, 'operations': [], 'type': 'chart', 'chart_type': 'barchart', 'chart_title': 'Top 10 most frequently occurring performers', 'chart_query': 'PREFIX schema: <http://schema.org/>\r\nPREFIX skos: <http://www.w3.org/2004/02/skos/core#>\r\nPREFIX sdo: <https://schema.org/>\r\nPREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>\r\nPREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>\r\n\r\n# Toon alleen items die ook op GPP te bekijken/beluisteren zijn.\r\nSELECT ?count ?label\r\nWHERE{\r\n {\r\nSELECT (COUNT(distinct ?program_uri) as ?count) ?label\r\nWHERE {\r\n?series <https://schema.org/name> "Muziekopnamen Zendgemachtigden (MOZ)"^^xsd:string . \r\n\t?season sdo:partOfSeries ?series . \r\n ?program_uri sdo:partOfSeason ?season . \r\n {\r\n ?program_uri a sdo:CreativeWork ;\r\n sdo:byArtist/sdo:byArtist ?entity .\r\n ?entity skos:prefLabel ?label\r\n }\r\n UNION\r\n {\r\n ?program_uri sdo:isPartOfSeason ?season .\r\n\r\n ?season sdo:byArtist/sdo:byArtist ?entity .\r\n\r\n ?entity skos:prefLabel ?label\r\n }\r\n UNION\r\n {\r\n ?program_uri sdo:isPartOfSeason/sdo:isPartOfSeries ?series .\r\n\r\n ?series sdo:byArtist/sdo:byArtist ?entity .\r\n\r\n ?entity skos:prefLabel ?label\r\n }\r\n UNION\r\n {\r\n ?scene sdo:hasPart ?program_uri.\r\n\r\n ?scene sdo:byArtist/sdo:byArtist ?entity .\r\n\r\n ?entity skos:prefLabel ?label \r\n }\r\n } group by ?label }}order by desc(?count) LIMIT 10', 'chart_series': 'N. of performers', 'chart_legend': {'x': 'performer', 'y': 'frequency'}, 'extra_queries': []}, {'position': 9, 'operations': [], 'type': 'text', 'text': '<p>Plotting the top ten performers reveals that the collection has an emphasis on music performed by orchestras, choirs and ensembles. Dolf van der Linden, a Dutch conductor, and Marinus Voorberg, a Dutch conductor and pianist, also feature in the top ten.</p>', 'extra_queries': []}, {'position': 10, 'operations': [], 'type': 'text', 'text': '<p>All concerts are under copyright. They were produced by a variety of production companies</p>', 'extra_queries': []}, {'position': 11, 'operations': [], 'type': 'chart', 'chart_type': 'barchart', 'chart_title': 'Top 10 production companies', 'chart_query': 'PREFIX skos: <http://www.w3.org/2004/02/skos/core#>\r\nSELECT ?label ?count\r\nWHERE\r\n{\r\n {\r\nSELECT distinct ?label (COUNT(?program_uri) AS ?count) WHERE {\r\n?series <https://schema.org/name> "Muziekopnamen Zendgemachtigden (MOZ)"^^xsd:string . \r\n\t?season <https://schema.org/partOfSeries> ?series . \r\n ?program_uri <https://schema.org/partOfSeason> ?season . \r\n ?program_uri <https://schema.org/productionCompany> ?prod_company . \r\n ?prod_company <https://schema.org/productionCompany> ?prod_entity . ?prod_entity skos:prefLabel ?label\r\n} GROUP BY ?label \r\n }} ORDER BY desc(?count) LIMIT 10', 'chart_series': 'N. of companies', 'chart_legend': {'x': 'company', 'y': 'frequency'}, 'extra_queries': []}, {'position': 12, 'operations': [], 'type': 'text', 'text': '<p>The production companies reflect the diversity of the collection. From Omroep MAX, a public service broadcaster that serves older viewers, to Mojo Concerts, an important concert promotor in the Netherlands.</p>', 'extra_queries': []}]}
The Dutch Broadcast Concert Collection (Dutch name MOZ - Muziekopnamen Zendgemachtigden) contains recordings of concerts broadcast live by Dutch public service broadcasters, and metadata describing the recordings, including related persons.