Authors: Alessandra Greco, Valentina Marcucci
Source: SPARQL endpoint
Export
{'sparql_endpoint': 'https://query.wikidata.org/sparql', 'template_mode': 'statistics', 'title': 'Red Hot Chili Peppers', 'color_code': ['#c63963', '#177fcf'], 'user_name': 'valentinamarcucci1107', 'id': '1687705995.591492', 'subtitle': 'The legendary Red Hot Chili Peppers: a musical revolution and enduring legacy', 'curator': 'Alessandra Greco, Valentina Marcucci', 'description': 'Welcome to a captivating exploration of the musical history of the Red Hot Chili Peppers. From their humble beginnings to becoming global icons, this American rock band has defied genres and expectations, crafting a unique sound that blends rock, funk, punk, and alternative influences. Join us as we trace their evolution and delve into their breakthrough albums. Get ready to dive into the vibrant world of the Red Hot Chili Peppers and discover the magic behind their music.', 'dynamic_elements': [{'position': 0, 'operations': [], 'type': 'text', 'text': "<p>The music scene in the United States has been a breeding ground for diverse musical genres, each contributing to the country's cultural fabric. Among these genres, rock music has emerged as a powerful and enduring force, captivating audiences with its energetic rhythms. For this reason, a lot of music bands and, in particularly, rock bands were born in this country.</p>", 'extra_queries': [], 'map_filters': []}, {'position': 1, '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 usa\r\n}', 'count_label': 'Number of bands in the USA ', 'extra_queries': [], 'map_filters': []}, {'position': 2, 'operations': [], 'type': 'count', 'count_query': 'SELECT (COUNT(?band) AS ?count)\r\nWHERE {\r\n ?band ?a wd:Q5741069 . # rock band \r\n ?band wdt:P495 wd:Q30 . # from usa\r\n}', 'count_label': 'Number of rock bands in the USA', 'extra_queries': [], 'map_filters': []}, {'position': 3, 'operations': [], 'type': 'text', 'text': '<p>As we can see, the relation between American rock bands and the number of their components is not related to their success: in fact, with just six members, Red Hot Chili Peppers is one of the most important rock bands at the moment. In addition, by using a map that shows the collocation of the recording studios in the USA, we found that there are 75 recording studios spread around the country.</p>', 'extra_queries': [], 'map_filters': []}, {'position': 4, 'operations': [], 'type': 'chart', 'chart_type': 'linechart', 'chart_title': 'American rock bands and their members ', 'chart_query': 'SELECT DISTINCT ?label (COUNT(?item) AS ?count) WHERE{\r\n ?band ?a wd:Q5741069 . # rock band\r\n ?band wdt:P495 wd:Q30 . # from usa \r\n ?band wdt:P527 ?item . SERVICE wikibase:label { bd:serviceParam wikibase:language "en". ?band rdfs:label ?label. } } GROUP BY ?label ORDER BY DESC(?count) LIMIT 30', 'chart_series': 'Rock bands and their members in the USA', 'chart_legend': {'x': 'Number of members', 'y': 'Rock band'}, 'extra_queries': [], 'map_filters': []}, {'position': 5, 'operations': [], 'type': 'map', 'map_title': 'Recording studios in the US', 'map_points_query': 'SELECT DISTINCT ?point ?pointLabel ?villeIdLabel ?lat ?long\r\nWHERE {\r\n?point wdt:P31 wd:Q746369; 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". } }', 'extra_queries': [], 'map_filters': []}, {'position': 6, 'operations': [], 'type': 'text', 'text': '<p>The Red Hot Chili Peppers (often abbreviated as RHCP) are an American rock band known for their energetic blend of rock, funk, and punk music. The band was formed in Los Angeles, California, in 1983. The original lineup consisted of lead vocalist Anthony Kiedis, bassist Flea (Michael Balzary), guitarist Hillel Slovak, and drummer Jack Irons.</p><p>Over the years, the Red Hot Chili Peppers have gone through several lineup changes, with members coming and going. The band\'s music is characterized by a unique fusion of different genres, incorporating elements of funk, punk rock, alternative rock, and psychedelic rock. They are known for their energetic and often eccentric live performances.</p><p>Some of their most popular songs include "Under the Bridge," "Californication," "Scar Tissue," "Dani California," and "Give It Away." They have released numerous successful albums throughout their career, including "Blood Sugar Sex Magik," "Californication," and "Stadium Arcadium." Their music has earned them several Grammy Awards and a dedicated fanbase worldwide.</p><p>The Red Hot Chili Peppers have been influential in shaping the alternative rock and funk rock genres and they continue to tour and create music nowadays.</p>', 'extra_queries': [], 'map_filters': []}, {'position': 7, 'operations': [], 'type': 'textsearch', 'textsearch_userinput': '', 'textsearch_title': 'Search band by a name', '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 "red hot chili peppers";\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\r\n', 'textsearch': {'band': ['Music genres', 'Instruments they play', 'Awards they won', 'Nominations they received', 'Number of followers on social medias ', 'Released albums and date', 'Components of The Red Hot Chili Peppers', 'Most famous songs', 'Show other bands from this genre ', 'Year when they started their musical activity'], 'category': ['Show other bands from this genre ']}, 'extra_queries': [], 'map_filters': []}, {'position': 8, 'operations': [], 'type': 'action', 'action_title': 'Music genres', 'action_query': 'SELECT DISTINCT ?genre ?genreLabel\r\nWHERE { \r\n <<item>> wdt:P136 ?genre .\r\n\r\nSERVICE wikibase:label { \r\n bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en"\r\n }\r\n}\r\nLIMIT 10', 'extra_queries': [], 'map_filters': []}, {'position': 9, 'operations': [], 'type': 'action', 'action_title': 'Components of The Red Hot Chili Peppers', 'action_query': 'SELECT DISTINCT ?member ?memberLabel ?image\r\nWHERE { \r\n wd:Q10708 wdt:P527 ?member . \r\n OPTIONAL { ?member wdt:P18 ?image . }\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': 10, 'operations': [], 'type': 'action', 'action_title': 'Show other bands from this genre ', 'action_query': 'SELECT DISTINCT ?band ?bandLabel ?category ?categoryLabel ?country ?countryLabel WHERE {\r\n ?band wdt:P31 ?category ; wdt:P495 ?country ; wdt:P136 wd:Q11399 .\r\n ?category wdt:P279 wd:Q2088357 \r\nSERVICE wikibase:label { \r\n bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en"\r\n }\r\n} LIMIT 20', 'extra_queries': [], 'map_filters': []}, {'position': 11, 'operations': [], 'type': 'action', 'action_title': 'Instruments they play', 'action_query': 'SELECT (?instrumentLabel AS ?label) (COUNT(?member) AS ?count) WHERE {\r\n wd:Q56884561 wdt:P527 ?member. ?member wdt:P1303 ?instrument. ?instrument rdfs:label ?instrumentLabel. FILTER (lang(?instrumentLabel) = "en"). } GROUP BY ?instrument ?instrumentLabel ORDER BY DESC(?count)', 'extra_queries': [], 'map_filters': []}, {'position': 12, 'operations': [], 'type': 'action', 'action_title': 'Year when they started their musical activity', 'action_query': 'SELECT DISTINCT ?Start WHERE { wd:Q10708 wdt:P2031 ?Start . }', 'extra_queries': [], 'map_filters': []}, {'position': 13, 'operations': [], 'type': 'chart', 'chart_type': 'doughnutchart', 'chart_title': 'Sources of inspiration and their influence', 'chart_query': 'SELECT DISTINCT ?label (COUNT(distinct ?band) as ?count) WHERE {\r\n ?band ?a wd:Q5741069 . # rock \r\n ?band wdt:P495 wd:Q30 . # from usa \r\n ?band wdt:P737 ?influencer . SERVICE wikibase:label { bd:serviceParam wikibase:language "en". ?influencer rdfs:label ?label.} } GROUP BY ?label ?count ORDER BY DESC(?count) LIMIT 10\r\n', 'chart_series': '', 'chart_legend': {'x': '', 'y': ''}, 'extra_queries': [], 'map_filters': []}, {'position': 14, 'operations': [], 'type': 'action', 'action_title': 'Released albums and date', 'action_query': 'SELECT DISTINCT (?label AS ?album) (YEAR(xsd:dateTime(?date)) AS ?date) WHERE { ?album wdt:P31 wd:Q482994 . ?album wdt:P175 wd:Q10708 . ?album wdt:P577 ?date . SERVICE wikibase:label { bd:serviceParam wikibase:language "en". ?album rdfs:label ?label. } } GROUP BY ?label ?date ORDER BY ?date LIMIT 20', 'extra_queries': [], 'map_filters': []}, {'position': 15, 'operations': [], 'type': 'action', 'action_title': 'Most famous songs', 'action_query': 'SELECT DISTINCT ?song ?songLabel (year(xsd:dateTime(?publicationDate)) as ?publication) WHERE { ?song wdt:P175 wd:Q10708 ; wdt:P407 wd:Q1860 . ?song wdt:P577 ?publicationDate . SERVICE wikibase:label { bd:serviceParam wikibase:language "en".} } ORDER BY ?publicationDate LIMIT 20', 'extra_queries': [], 'map_filters': []}, {'position': 16, 'operations': [], 'type': 'action', 'action_title': 'Nominations they received', 'action_query': 'SELECT DISTINCT ?nomination ?nominationLabel WHERE { wd:Q10708 wdt:P1411 ?nomination . ?nomination rdfs:label ?nominationLabel. FILTER(LANG(?nominationLabel)="en"). }', 'extra_queries': [], 'map_filters': []}, {'position': 17, 'operations': [], 'type': 'action', 'action_title': 'Awards they won', 'action_query': 'SELECT DISTINCT ?award ?awardLabel WHERE { wd:Q10708 wdt:P166 ?award . ?award rdfs:label ?awardLabel. FILTER(LANG(?awardLabel)="en"). }', 'extra_queries': [], 'map_filters': []}, {'position': 18, 'operations': [], 'type': 'action', 'action_title': 'Number of followers on social medias ', 'action_query': 'SELECT DISTINCT ?followers WHERE { wd:Q10708 wdt:P8687 ?followers . }', 'extra_queries': [], 'map_filters': []}, {'position': 19, 'operations': [], 'type': 'table', 'table_title': 'Music genres', 'table_query': 'SELECT DISTINCT ?genre ?genreLabel\r\nWHERE { \r\n wd:Q10708 wdt:P136 ?genre .\r\n\r\nSERVICE wikibase:label { \r\n bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en"\r\n }\r\n}\r\nLIMIT 10', 'extra_queries': [], 'map_filters': []}, {'position': 20, 'operations': [], 'type': 'table', 'table_title': 'Components of the Red Hot Chili Peppers', 'table_query': 'SELECT DISTINCT ?member ?memberLabel ?image\r\nWHERE { \r\n wd:Q10708 wdt:P527 ?member . \r\n OPTIONAL { ?member wdt:P18 ?image . }\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': 21, 'operations': [], 'type': 'table', 'table_title': 'Other bands from this genre', 'table_query': 'SELECT DISTINCT ?band ?bandLabel ?category ?categoryLabel ?country ?countryLabel WHERE {\r\n ?band wdt:P31 ?category ; wdt:P495 ?country ; wdt:P136 wd:Q11399 .\r\n ?category wdt:P279 wd:Q2088357 \r\nSERVICE wikibase:label { \r\n bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en"\r\n }\r\n} LIMIT 20', 'extra_queries': [], 'map_filters': []}, {'position': 22, 'operations': [], 'type': 'table', 'table_title': 'Instruments they play', 'table_query': 'SELECT (?instrumentLabel AS ?label) (COUNT(?member) AS ?count) WHERE {\r\n wd:Q56884561 wdt:P527 ?member. ?member wdt:P1303 ?instrument. ?instrument rdfs:label ?instrumentLabel. FILTER (lang(?instrumentLabel) = "en"). } GROUP BY ?instrument ?instrumentLabel ORDER BY DESC(?count)', 'extra_queries': [], 'map_filters': []}, {'position': 23, 'operations': [], 'type': 'table', 'table_title': 'Year when they started their activity', 'table_query': 'SELECT DISTINCT ?Start WHERE { wd:Q10708 wdt:P2031 ?Start . }', 'extra_queries': [], 'map_filters': []}, {'position': 24, 'operations': [], 'type': 'table', 'table_title': 'Released albums and date', 'table_query': 'SELECT DISTINCT (?label AS ?album) (YEAR(xsd:dateTime(?date)) AS ?date) WHERE { ?album wdt:P31 wd:Q482994 . ?album wdt:P175 wd:Q10708 . ?album wdt:P577 ?date . SERVICE wikibase:label { bd:serviceParam wikibase:language "en". ?album rdfs:label ?label. } } GROUP BY ?label ?date ORDER BY ?date LIMIT 20', 'extra_queries': [], 'map_filters': []}, {'position': 25, 'operations': [], 'type': 'table', 'table_title': 'Most famous songs', 'table_query': 'SELECT DISTINCT ?song ?songLabel (year(xsd:dateTime(?publicationDate)) as ?publication) WHERE { ?song wdt:P175 wd:Q10708 ; wdt:P407 wd:Q1860 . ?song wdt:P577 ?publicationDate . SERVICE wikibase:label { bd:serviceParam wikibase:language "en".} } ORDER BY ?publicationDate LIMIT 20', 'extra_queries': [], 'map_filters': []}, {'position': 26, 'operations': [], 'type': 'table', 'table_title': 'Nominations they received', 'table_query': 'SELECT DISTINCT ?nomination ?nominationLabel WHERE { wd:Q10708 wdt:P1411 ?nomination . ?nomination rdfs:label ?nominationLabel. FILTER(LANG(?nominationLabel)="en"). }', 'extra_queries': [], 'map_filters': []}, {'position': 27, 'operations': [], 'type': 'table', 'table_title': 'Awards they won', 'table_query': 'SELECT DISTINCT ?award ?awardLabel WHERE { wd:Q10708 wdt:P166 ?award . ?award rdfs:label ?awardLabel. FILTER(LANG(?awardLabel)="en"). }\r\n', 'extra_queries': [], 'map_filters': []}, {'position': 28, 'operations': [], 'type': 'table', 'table_title': 'Number of followers on social medias', 'table_query': 'SELECT DISTINCT ?followers WHERE { wd:Q10708 wdt:P8687 ?followers . }', 'extra_queries': [], 'map_filters': []}]}
Welcome to a captivating exploration of the musical history of the Red Hot Chili Peppers. From their humble beginnings to becoming global icons, this American rock band has defied genres and expectations, crafting a unique sound that blends rock, funk, punk, and alternative influences. Join us as we trace their evolution and delve into their breakthrough albums. Get ready to dive into the vibrant world of the Red Hot Chili Peppers and discover the magic behind their music.