Authors: Giulia Montesanto, Agnese Musacchio
Source: SPARQL endpoint
Export
{'sparql_endpoint': 'https://query.wikidata.org/sparql', 'template_mode': 'statistics', 'title': 'Exploring the Rock music genre', 'color_code': ['#80ffac', '#bfa3ff'], 'user_name': 'giuliam2', 'id': '1685638796.117557', 'subtitle': 'The changing face of rock music beyond gender boundaries and throughout different time periods and regions.', 'curator': 'Giulia Montesanto, Agnese Musacchio', 'description': 'As reported by Encyclopedia Britannica, "Rock, also called rock and roll [...] is a form of popular music that emerged in the 1950s. It is certainly arguable that by the end of the 20th century rock was the world’s dominant form of popular music". It is precisely its popularity that makes this genre so worthy of further study. Examining the evolution of rock music across different eras and geographical boundaries, this investigation delves into the genre\'s transformation over time while shedding light on the involvment of women within this musical landscape.', 'dynamic_elements': [{'position': 0, 'operations': [], 'type': 'text', 'text': '<p>The first rock bands were born in the <strong>1950s</strong>, in fact here we can see the number of bands born in the 50s, 60s and 70s: rock bands became more and more popular with each passing decade</p>', 'extra_queries': [], 'map_filters': []}, {'position': 1, 'operations': [], 'type': 'count', 'count_query': 'SELECT (COUNT(?band) AS ?count)\r\nWHERE {\r\n ?band ?a wd:Q5741069 . # rock band \r\n ?band wdt:P571 ?inception.\r\n\r\n FILTER(YEAR(?inception) >= 1950 && YEAR(?inception) <= 1960)\r\n}\r\n', 'count_label': "Bands formed in the '50s", '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:P571 ?inception.\r\n\r\n FILTER(YEAR(?inception) >= 1960 && YEAR(?inception) <= 1970)\r\n}\r\n', 'count_label': "Bands formed in the '60s", 'extra_queries': [], 'map_filters': []}, {'position': 3, 'operations': [], 'type': 'count', 'count_query': 'SELECT (COUNT(?band) AS ?count)\r\nWHERE {\r\n ?band ?a wd:Q5741069 . # rock band \r\n ?band wdt:P571 ?inception.\r\n\r\n FILTER(YEAR(?inception) >= 1970 && YEAR(?inception) <= 1980)\r\n}\r\n', 'count_label': "Bands formed in the 70's", 'extra_queries': [], 'map_filters': []}, {'position': 4, 'operations': [], 'type': 'text', 'text': "<p>Let's now take a look at the most influential rock bands in the USA</p>", 'extra_queries': [], 'map_filters': []}, {'position': 5, 'operations': [], 'type': 'chart', 'chart_type': 'doughnutchart', 'chart_title': 'Top 10 most influential rock bands in the USA', 'chart_query': 'SELECT DISTINCT ?label (COUNT(distinct ?band) as ?count) \r\nWHERE {\r\n ?band ?a wd:Q5741069 . # rock band \r\n ?band wdt:P495 wd:Q30 . # from USA\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 10\r\n', 'chart_series': '', 'chart_legend': {'x': '', 'y': ''}, 'extra_queries': [], 'map_filters': []}, {'position': 6, 'operations': [], 'type': 'text', 'text': "<p>Let's focus on the band Nirvana. What are the roles played by its members?</p>", 'extra_queries': [], 'map_filters': []}, {'position': 7, 'operations': [], 'type': 'table', 'table_title': "Nirvana's members ", 'table_query': 'SELECT DISTINCT ?Member ?MemberLabel (year(xsd:dateTime(?BirthDate)) as ?Birth) (year(xsd:dateTime(?DeathDate)) as ?Death) ?BirthPlace ?BirthPlaceLabel ?occupation ?occupationLabel \r\nWHERE { wd:Q11649 wdt:P527 ?Member . ?Member wdt:P569 ?BirthDate . \r\n OPTIONAL {?Member wdt:P570 ?DeathDate.} ?Member wdt:P19 ?BirthPlace. \r\n OPTIONAL {?Member wdt:P1303 ?occupation.} \r\n SERVICE wikibase:label { bd:serviceParam wikibase:language "en".} } \r\n\r\nLIMIT 10\r\n', 'extra_queries': [], 'map_filters': []}, {'position': 8, 'operations': [], 'type': 'text', 'text': '<p>Each member plays more than one role in the band, four out of five play guitar, including Kurt Cobain, who sings and plays guitar. But who else is connected to the band Nirvana and Cobain and plays guitar, besides singing? His wife Courtney Love, singer and guitarist of American rock band Hole.</p>', 'extra_queries': [], 'map_filters': []}, {'position': 9, 'operations': [], 'type': 'table', 'table_title': "Hole's members", 'table_query': 'SELECT DISTINCT ?Member ?MemberLabel (year(xsd:dateTime(?BirthDate)) as ?Birth) ?BirthPlace ?BirthPlaceLabel ?occupation ?occupationLabel \r\nWHERE { wd:Q624790 wdt:P527 ?Member . ?Member wdt:P569 ?BirthDate . \r\n OPTIONAL {?Member wdt:P19 ?BirthPlace.}\r\n OPTIONAL {?Member wdt:P1303 ?occupation.} \r\n\r\n SERVICE wikibase:label { bd:serviceParam wikibase:language "en".} } \r\n\r\nLIMIT 10\r\n', 'extra_queries': [], 'map_filters': []}, {'position': 10, 'operations': [], 'type': 'text', 'text': '<p>This band is composed solely of women. Something that might come as a surprise, as one does not often hear of all-female rock bands. Let us see if the numbers support this perception.</p>', 'extra_queries': [], 'map_filters': []}, {'position': 11, '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}\r\n', 'count_label': 'Rock bands in the USA', 'extra_queries': [], 'map_filters': []}, {'position': 12, 'operations': [], 'type': 'count', 'count_query': 'SELECT (COUNT(DISTINCT ?band) AS ?count)\r\nWHERE {\r\n ?band wdt:P31 wd:Q5741069 ;\r\n wdt:P527 ?member .\r\n ?member wdt:P31 wd:Q5 ;\r\n wdt:P21 wd:Q6581072 ;\r\n wdt:P27 wd:Q30 .\r\n}\r\n', 'count_label': 'All-female rock bands in the USA', 'extra_queries': [], 'map_filters': []}, {'position': 13, 'operations': [], 'type': 'text', 'text': '<p>Let’s now have a look at how rock evolved throughout the years.</p><p>Over time, rock has become increasingly diversified and so many different sub-genres have emerged that differ from the original genre but retain some of its features. We can see an explosion of new genres between the 1980 and 1995, but the trend declines as we enter the 2000s.</p>', 'extra_queries': [], 'map_filters': []}, {'position': 14, 'operations': [], 'type': 'chart', 'chart_type': 'barchart', 'chart_title': 'When new sub-genres emerged', 'chart_query': 'SELECT DISTINCT ?label (COUNT(?date) AS ?count) \r\nWHERE { ?genre ?a wd:Q188451 .\r\n ?genre wdt:P279* wd:Q11399.\r\n ?genre wdt:P571 ?date . \r\n SERVICE wikibase:label { bd:serviceParam wikibase:language "en". ?date rdfs:label ?label. } \r\n FILTER(YEAR(?date) >= 1978 && YEAR(?date) <= 2001)\r\n } \r\nGROUP BY ?label \r\nORDER BY ASC(?label) \r\nLIMIT 30\r\n', 'chart_series': '', 'chart_legend': {'x': 'Year', 'y': 'Sub-genres that emerged'}, 'extra_queries': [], 'map_filters': []}, {'position': 15, 'operations': [], 'type': 'map', 'map_title': 'Where they emerged', 'map_points_query': 'SELECT DISTINCT ?point ?pointLabel ?countryLabel ?lat ?long\r\nWHERE {\r\n?point wdt:P31 wd:Q188451 .\r\n ?point wdt:P279 wd:Q11399 .\r\n ?point wdt:P495 ?country.\r\n?country 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\nLIMIT 500\r\n', 'extra_queries': [], 'map_filters': []}, {'position': 16, 'operations': [], 'type': 'text', 'text': '<p>Now let\'s go back to Rock music.</p><p>It is arguably one of the most popular music genres ever; but does this apply to all the nations of the world? We can check this by entering the name of a nation; we will then find all the bands of that nationality.</p><p>If interested in the foundation date of the band, one can check it by clicking on "Show foundation year".</p>', 'extra_queries': [], 'map_filters': []}, {'position': 17, 'operations': [], 'type': 'textsearch', 'textsearch_userinput': '', 'textsearch_title': 'Enter the name of a country to get the bands based there.', 'textsearch_query': 'SELECT DISTINCT ?pic ?rockgroup ?rockgroupLabel ?country ?countryLabel\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>>; #country\r\n mwapi:language "en".\r\n ?country wikibase:apiOutputItem mwapi:item.\r\n }\r\n ?rockgroup wdt:P31 wd:Q5741069.\r\n ?rockgroup wdt:P495 ?country .\r\n ?rockgroup wdt:P136 ?band .\r\n OPTIONAL {?rockgroup 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 ?rockgroup\r\nLIMIT 5\r\n', 'textsearch': {'rockgroup': ['Show foundation year']}, 'extra_queries': [], 'map_filters': []}, {'position': 18, 'operations': [], 'type': 'action', 'action_title': 'Show foundation year', 'action_query': 'SELECT DISTINCT ?inception ?InceptionLabel\r\nWHERE { \r\n <<item>> wdt:P571 ?inception . \r\n\r\n\r\nSERVICE wikibase:label { \r\n bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en"\r\n }\r\n}\r\nLIMIT 20\r\n', 'extra_queries': [], 'map_filters': []}]}
As reported by Encyclopedia Britannica, "Rock, also called rock and roll [...] is a form of popular music that emerged in the 1950s. It is certainly arguable that by the end of the 20th century rock was the world’s dominant form of popular music". It is precisely its popularity that makes this genre so worthy of further study. Examining the evolution of rock music across different eras and geographical boundaries, this investigation delves into the genre's transformation over time while shedding light on the involvment of women within this musical landscape.