Authors: Gilda Gitto, Vito Antonio Miccoli, Serena Sciortino
Source: SPARQL endpoint
Export
{'sparql_endpoint': 'https://query.wikidata.org/sparql', 'template_mode': 'statistics', 'title': 'Discovering Rock Bands in the USA', 'color_code': ['#071bb0', '#f00000'], 'user_name': 'Serena2796', 'id': '1686588464.951175', 'subtitle': 'Rocking the USA: Discover With Us the Rock Groups and the Sound of Guns N’ Roses and Red Hot Chili Peppers', 'curator': 'Gilda Gitto, Vito Antonio Miccoli, Serena Sciortino', 'description': "Get ready for an amazing adventure into the world of rock music in the USA. We'll explore the huge number of bands, the exciting stadiums they perform in, and the talented members that make up these groups. We'll also discover when these bands formed. Along the way, we'll see cool pictures of rock bands and their unique styles. Plus, we'll dive into the story of Guns N' Roses, learning about their band members, hit albums, and when they were released. In addition, during our journey we have also encountered the majestic band of the Red Hot Chili Peppers. Get ready to rock out to the incredible music and stories that define American rock!", 'dynamic_elements': [{'position': 0, 'operations': [], 'type': 'count', 'count_query': 'SELECT (COUNT(?band) AS ?count)\r\nWHERE {\r\n ?band ?a wd:Q215380 . # music band \r\n ?band wdt:P495 wd:Q30 . # from \r\n}\r\n', 'count_label': 'Music Bands in the USA', 'extra_queries': [], 'map_filters': []}, {'position': 1, 'operations': [], 'type': 'count', 'count_query': '\r\nSELECT (COUNT(?band) AS ?count)\r\nWHERE {\r\n ?band ?a wd:Q5741069 . # rock band \r\n ?band wdt:P495 wd:Q30 . # from uk\r\n}\r\n', 'count_label': 'Rock Bands in the USA', 'extra_queries': [], 'map_filters': []}, {'position': 2, 'operations': [], 'type': 'map', 'map_title': 'Stadiums', 'map_points_query': 'SELECT DISTINCT ?point ?pointLabel ?villeIdLabel ?lat ?long\r\nWHERE {\r\n?point wdt:P31 wd:Q483110; wdt:P17 wd:Q30;\r\nwdt:P131 ?villeId; p:P625 ?statement.\r\n?statement psv:P625 ?node. ?node wikibase:geoLatitude ?lat ; wikibase:geoLongitude ?long.\r\nSERVICE wikibase:label { bd:serviceParam wikibase:language "en". } }\r\n', 'extra_queries': [], 'map_filters': []}, {'position': 3, 'operations': [], 'type': 'chart', 'chart_type': 'linechart', 'chart_title': 'Rock Bands: Formation Year ', 'chart_query': 'SELECT DISTINCT (year(xsd:dateTime(?date)) as ?label) (COUNT(?label) AS ?count)\r\nWHERE {\r\n ?band ?a wd:Q5741069 . # rock band \r\n ?band wdt:P495 wd:Q20 . # from USA\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\r\nLIMIT 20\r\n', 'chart_series': '', 'chart_legend': {'x': 'Formation Year', 'y': 'Groups Number'}, 'extra_queries': [], 'map_filters': []}, {'position': 4, 'operations': [], 'type': 'chart', 'chart_type': 'barchart', 'chart_title': 'Rock Bands: Group Names and Number of Members', 'chart_query': 'SELECT DISTINCT ?label (COUNT(?item) AS ?count) \r\nWHERE { ?band ?a wd:Q5741069 . # rock band \r\n ?band wdt:P495 wd:Q30 . # from USA \r\n ?band wdt:P527 ?item . \r\n SERVICE wikibase:label { bd:serviceParam wikibase:language "en". ?band rdfs:label ?label. } } \r\nGROUP BY ?label \r\nORDER BY DESC(?count) \r\nLIMIT 30\r\n', 'chart_series': '', 'chart_legend': {'x': 'Group Names ', 'y': 'Number of Members '}, 'extra_queries': [], 'map_filters': []}, {'position': 5, 'operations': [], 'type': 'table', 'table_title': "Guns N' Roses: Members, Birth Date and Occupation", 'table_query': 'SELECT DISTINCT ?Member ?MemberLabel (year(xsd:dateTime(?BirthDate)) as ?Birth) ?occupation ?occupationLabel \r\nWHERE { wd:Q11895 wdt:P527 ?Member . ?Member wdt:P569 ?BirthDate . \r\n OPTIONAL {?Member wdt:P1303 ?occupation.} \r\n SERVICE wikibase:label { bd:serviceParam wikibase:language "en".} } LIMIT 10\r\n', 'extra_queries': [], 'map_filters': []}, {'position': 6, 'operations': [], 'type': 'chart', 'chart_type': 'doughnutchart', 'chart_title': 'Instruments Played by Red Hot Chili Peppers', 'chart_query': 'SELECT (?instrumentLabel AS ?label) (COUNT(?member) AS ?count) \r\nWHERE { wd:Q10708 wdt:P527 ?member. ?member \r\n wdt:P1303 ?instrument. ?instrument rdfs:label ?instrumentLabel. \r\n FILTER (lang(?instrumentLabel) = "en"). } \r\nGROUP BY ?instrument ?instrumentLabel \r\nORDER BY DESC(?count) \r\nLIMIT 10\r\n', 'chart_series': '', 'chart_legend': {'x': '', 'y': ''}, 'extra_queries': [], 'map_filters': []}, {'position': 7, 'operations': [], 'type': 'textsearch', 'textsearch_userinput': '', 'textsearch_title': 'Red Hot Chili Peppers: Search Their Members and Discover How They Look Like', 'textsearch_query': 'SELECT DISTINCT ?pic ?member ?memberLabel \r\nWHERE {\r\n SERVICE wikibase:mwapi {\r\n bd:serviceParam wikibase:endpoint "www.wikidata.org";\r\n wikibase:api "EntitySearch";\r\n mwapi:search <<searchterm>>; #member\r\n mwapi:language "en".\r\n ?member wikibase:apiOutputItem mwapi:item.\r\n }\r\n ?member wdt:P463 wd:Q10708 .\r\n ?member wdt:P18 ?pic .\r\n SERVICE wikibase:label { bd:serviceParam wikibase:language "en".}\r\n FILTER regex(str(?pic), "jpg").\r\n}\r\nORDER BY ?member\r\nLIMIT 5\r\n\r\n', 'extra_queries': [], 'map_filters': []}]}
Get ready for an amazing adventure into the world of rock music in the USA. We'll explore the huge number of bands, the exciting stadiums they perform in, and the talented members that make up these groups. We'll also discover when these bands formed. Along the way, we'll see cool pictures of rock bands and their unique styles. Plus, we'll dive into the story of Guns N' Roses, learning about their band members, hit albums, and when they were released. In addition, during our journey we have also encountered the majestic band of the Red Hot Chili Peppers. Get ready to rock out to the incredible music and stories that define American rock!