Authors: Valeria Di raimo and Eleonora Visone
Source: SPARQL endpoint
Export
{'sparql_endpoint': 'https://query.wikidata.org/sparql', 'template_mode': 'statistics', 'title': 'Jazz musicians born in Bologna', 'color_code': ['#db541a', '#cf9e17'], 'user_name': 'Ele-cerasella', 'id': '1685691815.368436', 'subtitle': 'An overview of their subgenres ', 'curator': 'Valeria Di raimo and Eleonora Visone', 'description': 'This project aims at providing information about jazz musicians born in Bologna. In this way, we want to highlight how the city could get advantage of having been the hometown of many jazz musicians to better promote the genre. In order to get a complete overview, we added an action to the textsearch showing the subgenres of the resulting musicians and some tables with further information. ', 'dynamic_elements': [{'position': 0, 'operations': [], 'type': 'textsearch', 'textsearch_userinput': '', 'textsearch_title': 'Jazz musicians born in Bologna ', 'textsearch_query': '\r\nSELECT ?person ?personLabel ?birthDate ?birthPlaceLabel WHERE {\r\n ?person wdt:P106 wd:Q639669 ; # occupation: jazz musician\r\n wdt:P19 ?birthPlace . # place of birth\r\n ?birthPlace wdt:P131* wd:Q1891 . # located in the administrative territorial entity (or its subentities) of: Bologna\r\n OPTIONAL { ?person wdt:P569 ?birthDate } # date of birth\r\n SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }\r\n}\r\nORDER BY ?personLabel\r\n', 'textsearch': {'birthDate': ['Show music subgenres'], 'image': ['Show music subgenres'], 'musicians': ['Show music subgenres'], 'person': ['Show music subgenres']}, 'extra_queries': [], 'map_filters': []}, {'position': 1, 'operations': [], 'type': 'action', 'action_title': 'Show music subgenres', 'action_query': 'SELECT DISTINCT ?subgenre ?subgenreLabel\r\nWHERE { \r\n <<item>> wdt:P136 ?subgenre .\r\n\r\nSERVICE wikibase:label { \r\n bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en"\r\n }\r\n}\r\nLIMIT 20', 'extra_queries': [], 'map_filters': []}, {'position': 2, 'operations': [], 'type': 'table', 'table_title': 'Age of jazz musicians born in Bologna', 'table_query': 'SELECT ?item ?itemLabel ?age WHERE {\r\n ?item wdt:P106 wd:Q639669; # occupation: jazz musician\r\n wdt:P19 wd:Q1891; # place of birth: Bologna\r\n wdt:P569 ?birth. # date of birth\r\n BIND(YEAR(NOW()) - YEAR(?birth) AS ?age) # calculate current age\r\n SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }\r\n}\r\nORDER BY ?age\r\nLIMIT 30 \r\n', 'extra_queries': [], 'map_filters': []}, {'position': 3, 'operations': [], 'type': 'table', 'table_title': 'How many of the jazz musicians born in Bologna died?', 'table_query': 'SELECT ?item ?itemLabel ?death WHERE {\r\n ?item wdt:P106 wd:Q639669; # occupation: jazz musician\r\n wdt:P19 wd:Q1891; # place of birth: Bologna\r\n wdt:P570 ?death. # date of death\r\n SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }\r\n}\r\nORDER BY DESC(?death)\r\n', 'extra_queries': [], 'map_filters': []}]}
This project aims at providing information about jazz musicians born in Bologna. In this way, we want to highlight how the city could get advantage of having been the hometown of many jazz musicians to better promote the genre. In order to get a complete overview, we added an action to the textsearch showing the subgenres of the resulting musicians and some tables with further information.