Authors: Giorgia Tonelli and Camilla Guarneri
Source: SPARQL endpoint
Export
{'sparql_endpoint': 'https://query.wikidata.org/sparql', 'template_mode': 'statistics', 'title': 'pop in bologna', 'color_code': ['#ff00d0', '#fdcef8'], 'user_name': 'giorgiatonelli', 'id': '1686354802.881508', 'subtitle': '', 'curator': 'Giorgia Tonelli and Camilla Guarneri', 'description': 'the present work is aimed at analysing pop bands phenomenon in Italy, with a particular focus on the scena bolognese', 'dynamic_elements': [{'position': 0, 'operations': [], 'type': 'text', 'text': '<p><span style="background-color: transparent; color: rgb(255, 0, 255);">Divertitevi ragazzi. Suonate. Cantate. State bene e in pace. </span></p><p><span style="background-color: transparent; color: rgb(255, 0, 255);">Bologna è la città della musica, del saper vivere, della libertà.</span></p><p><a href="https://www.instagram.com/p/Ct3ZRxsInoA/?hl=it" target="_blank" style="background-color: transparent; color: rgb(255, 0, 255);">Cesare Cremonini</a></p>', 'extra_queries': [], 'map_filters': []}, {'position': 1, 'operations': [], 'type': 'count', 'count_query': 'SELECT (COUNT(?band) AS ?count)\r\nWHERE {\r\n \t?band ?a wd:Q215380 . # music band\r\n \t?band wdt:P495 wd:Q38 . # from italy\r\n}\r\n', 'count_label': 'Italian Bands', 'extra_queries': [], 'map_filters': []}, {'position': 2, 'operations': [], 'type': 'count', 'count_query': 'SELECT (COUNT(?band) AS ?count)\r\nWHERE {\r\n ?band ?a wd:Q215380 . # music band \r\n ?band wdt:P276 wd:Q1891 . # from bologna\r\n}\r\n', 'count_label': 'Bands from Bologna', 'extra_queries': [], 'map_filters': []}, {'position': 3, 'operations': [], 'type': 'chart', 'chart_type': 'barchart', 'chart_title': 'Italian bands sorted out by their year of foundation', 'chart_query': 'SELECT DISTINCT (year(xsd:dateTime(?date)) as ?label) (COUNT(?label) AS ?count)\r\nWHERE {\r\n ?band ?a wd:Q215380 . # rock band \r\n ?band wdt:P495 wd:Q38 . # from uk\r\n ?band wdt:P2031 ?date . # formation year \r\n SERVICE wikibase:label { bd:serviceParam wikibase:language "en".\r\n ?band rdfs:label ?label.\r\n }\r\n\r\n}\r\n\r\nGROUP BY ?count ?date\r\nORDER BY ?label', 'chart_series': '', 'chart_legend': {'x': 'bands', 'y': 'year of foundation'}, 'extra_queries': [], 'map_filters': []}, {'position': 4, 'operations': [], 'type': 'chart', 'chart_type': 'doughnutchart', 'chart_title': 'Most influential bands on Italian artists', 'chart_query': 'SELECT DISTINCT ?label (COUNT(distinct ?band) as ?count) \r\nWHERE {\r\n ?band ?a wd:Q215380 . # rock band \r\n ?band wdt:P495 wd:Q38 . # italy\r\n ?band wdt:P737 ?influencer .\r\n SERVICE wikibase:label { bd:serviceParam wikibase:language "en".\r\n ?influencer rdfs:label ?label.\r\n }\r\n}\r\n\r\nGROUP BY ?label ?count \r\nORDER BY DESC(?count)\r\nLIMIT 15', 'chart_series': '', 'chart_legend': {'x': '', 'y': ''}, 'extra_queries': [], 'map_filters': []}, {'position': 5, 'operations': [], 'type': 'textsearch', 'textsearch_userinput': '', 'textsearch_title': 'search band e.g. Lunaapop', 'textsearch_query': 'SELECT DISTINCT ?band ?bandLabel ?category ?categoryLabel ?country ?countryLabel WHERE {\r\n SERVICE wikibase:mwapi {\r\n bd:serviceParam wikibase:endpoint "www.wikidata.org";\r\n wikibase:api"EntitySearch";\r\n mwapi:search "lunapop";\r\n mwapi:language "en".\r\n ?band wikibase:apiOutputItem mwapi:item.\r\n }\r\n {\r\n {?band wdt:P31 ?category ; wdt:P495 ?country .\r\n ?category wdt:P31 wd:Q105756498 . }\r\n UNION\r\n {?band wdt:P31 ?category ; wdt:P495 ?country .\r\n ?category wdt:P279 wd:Q2088357 }\r\n }\r\nSERVICE wikibase:label { \r\n bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en"\r\n }\r\n} LIMIT 10\r\n', 'extra_queries': [], 'map_filters': []}, {'position': 6, 'operations': [], 'type': 'text', 'text': '<p><strong style="background-color: transparent; color: rgb(255, 0, 255);">Pooh </strong><span style="background-color: transparent; color: rgb(255, 0, 255);">is a successful Italian pop band</span><strong style="background-color: transparent; color: rgb(255, 0, 255);"> </strong><span style="background-color: transparent; color: rgb(255, 0, 255);">which was formed in Bologna, in 1966. Songs </span><em style="background-color: transparent; color: rgb(255, 0, 255);">Dammi solo un minuto</em><span style="background-color: transparent; color: rgb(255, 0, 255);"> and </span><em style="background-color: transparent; color: rgb(255, 0, 255);">Uomini soli</em><span style="background-color: transparent; color: rgb(255, 0, 255);"> are instances of their successful career.</span></p>', 'extra_queries': [], 'map_filters': []}, {'position': 7, 'operations': [], 'type': 'table', 'table_title': 'Pooh members', 'table_query': 'SELECT DISTINCT ?Member ?MemberLabel (year(xsd:dateTime(?BirthDate)) as ?Birth) ?BirthPlace ?BirthPlaceLabel ?image\r\nWHERE { wd:Q1242174 wdt:P527 ?Member . ?Member wdt:P569 ?BirthDate .\r\n \tOPTIONAL {?Member wdt:P19 ?BirthPlace.}\r\n \tOPTIONAL {?Member wdt:P18 ?image . }\r\n \tSERVICE wikibase:label { bd:serviceParam wikibase:language "en".} }\r\n', 'extra_queries': [], 'map_filters': []}, {'position': 8, 'operations': [], 'type': 'text', 'text': '<p><strong style="background-color: transparent; color: rgb(255, 0, 255);">Stadio </strong><span style="background-color: transparent; color: rgb(255, 0, 255);">is an Italian band which was formed in Bologna a decade later, in 1977. They started out as Lucio Dalla’s supporting band, who featured them in his Anidride Solforosa album. Their breakthrough arrived when they produced Verdone’s </span><em style="background-color: transparent; color: rgb(255, 0, 255);">Acqua e Sapone </em><span style="background-color: transparent; color: rgb(255, 0, 255);">(1983) soundtrack.</span></p><p><span style="background-color: transparent; color: rgb(255, 0, 255);">They worked with artists covering an essential role in the </span><em style="background-color: transparent; color: rgb(255, 0, 255);">scena bolognese</em><span style="background-color: transparent; color: rgb(255, 0, 255);"> such as </span><strong style="background-color: transparent; color: rgb(255, 0, 255);">Lucio Dalla, Gianni Morandi, Francesco Guccini, Vasco Rossi </strong><span style="background-color: transparent; color: rgb(255, 0, 255);">and</span><strong style="background-color: transparent; color: rgb(255, 0, 255);"> Luca Carboni</strong><span style="background-color: transparent; color: rgb(255, 0, 255);">. They won Sanremo Music Festival in 2016, with song </span><em style="background-color: transparent; color: rgb(255, 0, 255);">Un giorno mi dirai</em><span style="background-color: transparent; color: rgb(255, 0, 255);">.</span></p>', 'extra_queries': [], 'map_filters': []}, {'position': 9, 'operations': [], 'type': 'table', 'table_title': 'Stadio members', 'table_query': 'SELECT DISTINCT ?Member ?MemberLabel (year(xsd:dateTime(?BirthDate)) as ?Birth) ?BirthPlace ?BirthPlaceLabel ?image\r\nWHERE { wd:Q2326007 wdt:P527 ?Member . ?Member wdt:P569 ?BirthDate .\r\n \tOPTIONAL {?Member wdt:P19 ?BirthPlace.}\r\n \tOPTIONAL {?Member wdt:P18 ?image . }\r\n \tSERVICE wikibase:label { bd:serviceParam wikibase:language "en".} }\r\n', 'extra_queries': [], 'map_filters': []}, {'position': 10, 'operations': [], 'type': 'text', 'text': '<p><strong style="background-color: transparent; color: rgb(255, 0, 255);">Lunapop</strong><span style="background-color: transparent; color: rgb(255, 0, 255);"> formed in 1999 and split up in 2002. </span></p><p><span style="background-color: transparent; color: rgb(255, 0, 255);">Among them, frontman </span><strong style="background-color: transparent; color: rgb(255, 0, 255);">Cesare Cremonini</strong><span style="background-color: transparent; color: rgb(255, 0, 255);"> pursued a career in music along with bassist </span><strong style="background-color: transparent; color: rgb(255, 0, 255);">Nicola "Ballo" Balestri</strong><span style="background-color: transparent; color: rgb(255, 0, 255);">.</span></p><p><span style="background-color: transparent; color: rgb(255, 0, 255);">Lunapop won the Festival di San Marino with song </span><em style="background-color: transparent; color: rgb(255, 0, 255);">Qualcosa di Grande, </em><span style="background-color: transparent; color: rgb(255, 0, 255);">which allowed them to be scouted by an indie label, which produced their album </span><strong style="background-color: transparent; color: rgb(255, 0, 255);"><em>Squerez</em></strong><em style="background-color: transparent; color: rgb(255, 0, 255);">. </em><span style="background-color: transparent; color: rgb(255, 0, 255);">Their debut single, </span><em style="background-color: transparent; color: rgb(255, 0, 255);">50 Special, </em><span style="background-color: transparent; color: rgb(255, 0, 255);">has become an Italian cult. Other singles include </span><em style="background-color: transparent; color: rgb(255, 0, 255);">Un Giorno Migliore, Se Ci Sarai, Resta con Me </em><span style="background-color: transparent; color: rgb(255, 0, 255);">and</span><em style="background-color: transparent; color: rgb(255, 0, 255);"> Vorrei.</em></p>', 'extra_queries': [], 'map_filters': []}, {'position': 11, 'operations': [], 'type': 'table', 'table_title': 'Lunapop members (only Cesare Cremonini is shown on the table, since other members do not have a wikipedia page)', 'table_query': 'SELECT DISTINCT ?Member ?MemberLabel (year(xsd:dateTime(?BirthDate)) as ?Birth) ?BirthPlace ?BirthPlaceLabel ?image\r\nWHERE { wd:Q3841122 wdt:P527 ?Member . ?Member wdt:P569 ?BirthDate .\r\n \tOPTIONAL {?Member wdt:P19 ?BirthPlace.}\r\n \tOPTIONAL {?Member wdt:P18 ?image . }\r\n \tSERVICE wikibase:label { bd:serviceParam wikibase:language "en".} }', 'extra_queries': [], 'map_filters': []}, {'position': 12, 'operations': [], 'type': 'text', 'text': '<p><strong style="background-color: transparent; color: rgb(255, 0, 255);">Lo Stato Sociale</strong><span style="background-color: transparent; color: rgb(255, 0, 255);"> is an Italian band formed in 2009, in Bologna.</span></p><p><span style="background-color: transparent; color: rgb(255, 0, 255);">Stato Sociale was the runner-up in </span><em style="background-color: transparent; color: rgb(255, 0, 255);">Festival di Sanremo</em><span style="background-color: transparent; color: rgb(255, 0, 255);"> 2018, with their song </span><em style="background-color: transparent; color: rgb(255, 0, 255);">Una Vita in Vacanza.</em></p>', 'extra_queries': [], 'map_filters': []}, {'position': 13, 'operations': [], 'type': 'table', 'table_title': 'Lo Stato Sociale members', 'table_query': 'SELECT DISTINCT ?Member ?MemberLabel (year(xsd:dateTime(?BirthDate)) as ?Birth) ?BirthPlace ?BirthPlaceLabel ?image\r\nWHERE { wd:Q16573195 wdt:P527 ?Member . ?Member wdt:P569 ?BirthDate .\r\n \tOPTIONAL {?Member wdt:P19 ?BirthPlace.}\r\n \tOPTIONAL {?Member wdt:P18 ?image . }\r\n \tSERVICE wikibase:label { bd:serviceParam wikibase:language "en".} }\r\n', 'extra_queries': [], 'map_filters': []}, {'position': 14, 'operations': [], 'type': 'text', 'text': '<p><span style="background-color: transparent; color: rgb(255, 0, 255);">It’s not uncommon for artists to travel the world in order to find recording studios whose atmosphere inspires them the most. For instance, on February 2023, Cesare Cremonini flew to Seattle to record his new album at </span><strong style="background-color: transparent; color: rgb(255, 0, 255);">Robert Lang Studios</strong><span style="background-color: transparent; color: rgb(255, 0, 255);"> in Shoreline, where Nirvana would record their songs. Whereas </span><em style="background-color: transparent; color: rgb(255, 0, 255);">Maggese</em><span style="background-color: transparent; color: rgb(255, 0, 255);"> (2005) was entirely recorded between the </span><strong style="background-color: transparent; color: rgb(255, 0, 255);">Abbey Road Studios</strong><span style="background-color: transparent; color: rgb(255, 0, 255);"> and the </span><strong style="background-color: transparent; color: rgb(255, 0, 255);">Olympic Studios</strong><span style="background-color: transparent; color: rgb(255, 0, 255);"> in London. Similarly, </span><em style="background-color: transparent; color: rgb(255, 0, 255);">La Ragazza del Futuro</em><span style="background-color: transparent; color: rgb(255, 0, 255);"> (2022) was recorded at the </span><strong style="background-color: transparent; color: rgb(255, 0, 255);">Abbey Road Studios.</strong></p>', 'extra_queries': [], 'map_filters': []}, {'position': 15, 'operations': [], 'type': 'map', 'map_title': 'Recording Studios in the World', 'map_points_query': 'SELECT DISTINCT ?point ?pointLabel ?villeIdLabel ?lat ?long\r\nWHERE\r\n{\r\n ?point wdt:P31 wd:Q746369. \r\n ?point wdt:P131 ?villeId.\r\n ?point p:P625 ?statement.\r\n ?statement psv:P625 ?node.\r\n ?node wikibase:geoLatitude ?lat.\r\n ?node wikibase:geoLongitude ?long.\r\n SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }\r\n}', 'extra_queries': [], 'map_filters': []}, {'position': 16, 'operations': [], 'type': 'text', 'text': '<p><span style="color: rgb(255, 0, 255); background-color: transparent;">Bologna is commonly known as </span><em style="color: rgb(255, 0, 255); background-color: transparent;">la Grassa, la Rossa, la Dotta</em><span style="color: rgb(255, 0, 255); background-color: transparent;">. Theatres have always contributed to the cultural turmoil of the city. Bolognese artists have therefore shown deep fondness for theatres. For instance, </span><strong style="color: rgb(255, 0, 255); background-color: transparent;">Lo Stato Sociale</strong><span style="color: rgb(255, 0, 255); background-color: transparent;"> used their exhibition at the Festival di Sanremo 2021 to appeal for a re-opening of theatres. </span><strong style="color: rgb(255, 0, 255); background-color: transparent;">Cesare Cremonini</strong><span style="color: rgb(255, 0, 255); background-color: transparent;">, on the other hand, self-financed his </span><em style="color: rgb(255, 0, 255); background-color: transparent;">Maggese Theatre Tour.</em></p>', 'extra_queries': [], 'map_filters': []}, {'position': 17, 'operations': [], 'type': 'text', 'text': '<p><em style="color: rgb(255, 255, 255); background-color: transparent;">«Gli applausi in un teatro hanno un suono particolare, ti piovono addosso come un temporale improvviso. Ma la cosa più emozionante è stata riuscire a far scoppiare a ridere il pubblico con una battuta. È un sogno che mi portavo dietro fin da bambino, quando all\'asilo mettevo tutti i miei compagni di giochi sulle scale e cercavo di farli ridere rendendomi ridicolo.»</em></p><p><a href="https://it.wikipedia.org/wiki/Cesare_Cremonini_(cantante)" target="_blank"><em>Cesare Cremonini about his Theatre Tour</em></a></p>', 'extra_queries': [], 'map_filters': []}, {'position': 18, 'operations': [], 'type': 'map', 'map_title': 'Theatres', 'map_points_query': '\r\nSELECT DISTINCT ?point ?pointLabel ?villeIdLabel ?lat ?long\r\nWHERE\r\n{\r\n ?point wdt:P31 wd:Q11635. \r\n ?point wdt:P131 ?villeId.\r\n ?point p:P625 ?statement.\r\n ?statement psv:P625 ?node.\r\n ?node wikibase:geoLatitude ?lat.\r\n ?node wikibase:geoLongitude ?long.\r\n SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }\r\n}', 'map_filters': [{'map_filter_query': "SELECT DISTINCT ?point ?filter ?filterLabel\r\nWHERE {\r\n?point wdt:P31 wd:Q11635; wdt:P17 wd:Q38 .\r\n?point wdt:P131 ?filter. ?filter rdfs:label ?filterLabel .\r\nFILTER(LANG(?filterLabel) = '' || LANGMATCHES(LANG(?filterLabel), 'en')). }", 'extra_id': '1688126851188_0', 'position': 0, 'map_filter_title': 'Theaters in Italy'}], 'extra_queries': []}, {'position': 19, 'operations': [], 'type': 'table', 'table_title': 'Theaters in Bologna', 'table_query': 'SELECT DISTINCT ?place ?placeLabel \r\nWHERE\r\n{\r\n ?place wdt:P31 wd:Q24354. #theatre\r\n ?place wdt:P131 wd:Q1891 \r\n SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }\r\n}\r\n', 'extra_queries': [], 'map_filters': []}]}
the present work is aimed at analysing pop bands phenomenon in Italy, with a particular focus on the scena bolognese