Authors: Veronica Copparoni, Tatiana Giacobbo
Source: SPARQL endpoint
Export
{'sparql_endpoint': 'https://dbpedia.org/sparql', 'template_mode': 'statistics', 'title': 'Best female music artists', 'color_code': ['#e392fe', '#371a94'], 'user_name': 'VeronicaCopparoni', 'id': '1686643551.648723', 'subtitle': 'Explore the most successful women in music history', 'curator': 'Veronica Copparoni, Tatiana Giacobbo', 'description': 'Throughout history, numerous women have become cultural icons and symbols of female empowerment, thanks to their unique talents, distinctive voices, and memorable hits. With this story we want to explore some of the most influential and successful female musicians of all time, who have sold millions of records and inspired countless people around the world.', 'dynamic_elements': [{'position': 0, 'operations': [], 'type': 'count', 'count_query': 'PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>\r\nPREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> \r\nPREFIX dbo: <http://dbpedia.org/ontology/>\r\nPREFIX dbr: <http://dbpedia.org/resource/>\r\nPREFIX owl: <http://www.w3.org/2002/07/owl#> \r\nPREFIX dbp: <http://dbpedia.org/property/>\r\n\r\n \r\n\r\nSELECT (COUNT(?list) AS ?count)\r\nWHERE\r\n{\r\n?list a owl:Thing .\r\n?list ?relation dbr:List_of_best-selling_albums_by_women . \r\n}', 'count_label': 'Number of albums by women that sold more than 10mln', 'extra_queries': [], 'map_filters': []}, {'position': 1, 'operations': [], 'type': 'text', 'text': '<p>This is the number of famous albums that sold at least 10 millions copies worldwide. In the music scene, this surely represents a measure of success and recognition for every event.</p>', 'extra_queries': [], 'map_filters': []}, {'position': 2, 'operations': [], 'type': 'table', 'table_title': 'Best-selling women in music', 'table_query': 'PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>\r\nPREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>\r\nPREFIX dbo: <http://dbpedia.org/ontology/> \r\nPREFIX dbr: <http://dbpedia.org/resource/>\r\nPREFIX owl: <http://www.w3.org/2002/07/owl#>\r\nPREFIX dbp: <http://dbpedia.org/property/>\r\nPREFIX commons: <http://commons.wikimedia.org/wiki/Special:FilePath/>\r\n\r\n \r\n\r\n\r\nSELECT DISTINCT ?name ?picture ?birth_date ?place_of_birth ?years_active ?death_date \r\nWHERE { \r\n?list a owl:Thing . \r\n?list ?relation dbr:List_of_best-selling_albums_by_women . \r\n?person a dbo:Animal ; a dbo:Person .\r\ndbr:List_of_best-selling_albums_by_women ?boh ?person .\r\n?person dbp:name ?name .\r\n?person dbo:birthDate ?birth_date .\r\nOPTIONAL { \r\n?person dbo:deathDate ?death_date . }\r\n?person dbo:activeYearsStartYear ?years_active .\r\n?person dbp:birthPlace ?place_of_birth . \r\n?person dbp:name ?name \r\nMINUS { ?person dbp:name "Whitney Houston"@en } \r\n?person dbo:thumbnail ?pic .\r\nOPTIONAL { ?person foaf:homepage ?sito . }\r\n?wikipage foaf:primaryTopic ?person\r\n\r\n\r\nBIND (REPLACE(str(?pic), "(\\\\?width=300)", "","i") AS ?picture)} \r\nORDER BY ?years_active ', 'extra_queries': [], 'map_filters': []}, {'position': 3, 'operations': [], 'type': 'text', 'text': '<h3><br></h3><h3><br></h3><h3>With this doughnut chart we want to represent the number of awards honoring female performers and songwriters for their career and artistic achievements in the music business.</h3>', 'extra_queries': [], 'map_filters': []}, {'position': 4, 'operations': [], 'type': 'chart', 'chart_type': 'doughnutchart', 'chart_title': 'Awards wins', 'chart_query': 'PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>\r\nPREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>\r\nPREFIX dbo: <http://dbpedia.org/ontology/> \r\nPREFIX dbr: <http://dbpedia.org/resource/>\r\nPREFIX owl: <http://www.w3.org/2002/07/owl#>\r\nPREFIX dbp: <http://dbpedia.org/property/>\r\nPREFIX commons: <http://commons.wikimedia.org/wiki/Special:FilePath/>\r\n\r\nSELECT DISTINCT ?label ?count\r\nWHERE { \r\n?list a owl:Thing . \r\n?list ?relation dbr:List_of_best-selling_albums_by_women . \r\n?person a dbo:Animal ; a dbo:Person .\r\ndbr:List_of_best-selling_albums_by_women ?boh ?person .\r\n?person dbp:name ?label .\r\n?person dbp:awards ?what . \r\nFILTER (REGEX (?what, "awards", "I"))\r\n?what dbp:nominations ?nominations .\r\n?what dbp:wins ?count .\r\n}\r\nGROUP BY ?label\r\nORDER BY DESC ( ?count)', 'chart_series': '', 'chart_legend': {'x': '', 'y': ''}, 'extra_queries': [], 'map_filters': []}, {'position': 5, 'operations': [], 'type': 'text', 'text': '<h3><br></h3><h3><br></h3><h3>Another significant recognition that female artists get for their artistic production is the nomination for awards and prizes. Similarly, the bar chart explores the number of nominations that the most popular female musicians received during their career.</h3>', 'extra_queries': [], 'map_filters': []}, {'position': 6, 'operations': [], 'type': 'chart', 'chart_type': 'barchart', 'chart_title': 'Number of nominations received ', 'chart_query': 'PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>\r\nPREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>\r\nPREFIX dbo: <http://dbpedia.org/ontology/> \r\nPREFIX dbr: <http://dbpedia.org/resource/>\r\nPREFIX owl: <http://www.w3.org/2002/07/owl#>\r\nPREFIX dbp: <http://dbpedia.org/property/>\r\nPREFIX commons: <http://commons.wikimedia.org/wiki/Special:FilePath/>\r\n\r\nSELECT DISTINCT ?label ?count\r\nWHERE { \r\n?list a owl:Thing . \r\n?list ?relation dbr:List_of_best-selling_albums_by_women . \r\n?person a dbo:Animal ; a dbo:Person .\r\ndbr:List_of_best-selling_albums_by_women ?boh ?person .\r\n?person dbp:name ?label .\r\n?person dbp:awards ?what . \r\nFILTER (REGEX (?what, "awards", "I"))\r\n?what dbp:nominations ?count .\r\n?what dbp:wins ?eins .\r\n}\r\nGROUP BY ?label\r\nORDER BY DESC (?count)', 'chart_series': '', 'chart_legend': {'x': 'Artists', 'y': 'Nominations'}, 'extra_queries': [], 'map_filters': []}, {'position': 7, 'operations': [], 'type': 'map', 'map_title': 'Place of birth of the most influential female artists', 'map_points_query': 'PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>\r\nPREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>\r\nPREFIX dbo: <http://dbpedia.org/ontology/> \r\nPREFIX dbr: <http://dbpedia.org/resource/>\r\nPREFIX owl: <http://www.w3.org/2002/07/owl#>\r\nPREFIX dbp: <http://dbpedia.org/property/>\r\nPREFIX commons: <http://commons.wikimedia.org/wiki/Special:FilePath/>\r\n\r\n \r\n\r\nSELECT DISTINCT ?name ?point ?lat ?long\r\nWHERE { \r\n?list a owl:Thing . \r\n?list ?relation dbr:List_of_best-selling_albums_by_women . \r\n?person a dbo:Animal ; a dbo:Person .\r\ndbr:List_of_best-selling_albums_by_women ?boh ?person .\r\n?person dbp:name ?name .\r\n?person dbo:birthPlace ?luogo .\r\n?luogo georss:point ?point ; geo:lat ?lat ; geo:long ?long . \r\n}\r\nGROUP BY ?luogo', 'extra_queries': [], 'map_filters': []}, {'position': 8, 'operations': [], 'type': 'textsearch', 'textsearch_userinput': '', 'textsearch_title': 'Women in music', 'textsearch_query': 'PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>\r\nPREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>\r\nPREFIX dbo: <http://dbpedia.org/ontology/> \r\nPREFIX dbr: <http://dbpedia.org/resource/>\r\nPREFIX owl: <http://www.w3.org/2002/07/owl#>\r\nPREFIX dbp: <http://dbpedia.org/property/>\r\nPREFIX commons: <http://commons.wikimedia.org/wiki/Special:FilePath/>\r\n\r\nSELECT DISTINCT ?Name ?person \r\nWHERE { \r\n?list a owl:Thing . \r\n?list ?relation dbr:List_of_best-selling_albums_by_women . \r\n?person a dbo:Animal ; a dbo:Person .\r\ndbr:List_of_best-selling_albums_by_women ?boh ?person .\r\n?person dbp:name ?Name .\r\n?person dbo:birthDate ?BirthDate .\r\nOPTIONAL { \r\n?person dbo:deathDate ?datam . }\r\n?person dbo:activeYearsStartYear ?years_active .\r\nFILTER regex(str(?Name), <<searchterm>>, \'i\') \r\nOPTIONAL { \r\n?person foaf:homepage ?sito . }\r\n?wikipage foaf:primaryTopic ?person .\r\nFILTER (LANG(?Name)="en")\r\n }', 'textsearch': {'person': ['birth_date', 'years_active', 'wikipage', 'Bio']}, 'extra_queries': [], 'map_filters': []}, {'position': 9, 'operations': [], 'type': 'action', 'action_title': 'years_active', 'action_query': 'PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>\r\nPREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>\r\nPREFIX dbo: <http://dbpedia.org/ontology/> \r\nPREFIX dbr: <http://dbpedia.org/resource/>\r\nPREFIX owl: <http://www.w3.org/2002/07/owl#>\r\nPREFIX dbp: <http://dbpedia.org/property/>\r\nPREFIX commons: <http://commons.wikimedia.org/wiki/Special:FilePath/>\r\n\r\nSELECT DISTINCT ?years_active\r\nWHERE { \r\n?list a owl:Thing . \r\n?list ?relation dbr:List_of_best-selling_albums_by_women . \r\n?person a dbo:Animal ; a dbo:Person .\r\ndbr:List_of_best-selling_albums_by_women ?boh ?person .\r\n?person dbp:name ?Name .\r\n?person dbo:birthDate ?BirthDate .\r\nOPTIONAL { \r\n?person dbo:deathDate ?datam . }\r\n <<item>> dbo:activeYearsStartYear ?years_active .\r\nOPTIONAL { \r\n?person foaf:homepage ?sito . }\r\n?wikipage foaf:primaryTopic ?person\r\n }', 'extra_queries': [], 'map_filters': []}, {'position': 10, 'operations': [], 'type': 'action', 'action_title': 'wikipage', 'action_query': 'PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>\r\nPREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>\r\nPREFIX dbo: <http://dbpedia.org/ontology/> \r\nPREFIX dbr: <http://dbpedia.org/resource/>\r\nPREFIX owl: <http://www.w3.org/2002/07/owl#>\r\nPREFIX dbp: <http://dbpedia.org/property/>\r\nPREFIX commons: <http://commons.wikimedia.org/wiki/Special:FilePath/>\r\n\r\nSELECT DISTINCT ?wikipage\r\nWHERE { \r\n?list a owl:Thing . \r\n?list ?relation dbr:List_of_best-selling_albums_by_women . \r\n?person a dbo:Animal ; a dbo:Person .\r\ndbr:List_of_best-selling_albums_by_women ?boh ?person .\r\n?person rdfs:label ?Name . \r\n?person dbo:birthDate ?BirthDate .\r\nOPTIONAL { \r\n?person dbo:deathDate ?datam . }\r\n?person dbo:activeYearsStartYear ?years_active .\r\nOPTIONAL { \r\n?person foaf:homepage ?sito . }\r\n?wikipage foaf:primaryTopic <<item>> .\r\nFILTER (LANG(?Name)="en")\r\n }', 'extra_queries': [], 'map_filters': []}, {'position': 11, 'operations': [], 'type': 'action', 'action_title': 'birth_date', 'action_query': 'PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>\r\nPREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>\r\nPREFIX dbo: <http://dbpedia.org/ontology/> \r\nPREFIX dbr: <http://dbpedia.org/resource/>\r\nPREFIX owl: <http://www.w3.org/2002/07/owl#>\r\nPREFIX dbp: <http://dbpedia.org/property/>\r\nPREFIX commons: <http://commons.wikimedia.org/wiki/Special:FilePath/>\r\n\r\nSELECT DISTINCT ?BirthDate\r\nWHERE { \r\n?list a owl:Thing . \r\n?list ?relation dbr:List_of_best-selling_albums_by_women . \r\n?person a dbo:Animal ; a dbo:Person .\r\ndbr:List_of_best-selling_albums_by_women ?boh ?person .\r\n?person rdfs:label ?Name . \r\n<<item>> dbo:birthDate ?BirthDate .\r\nOPTIONAL { \r\n?person dbo:deathDate ?datam . }\r\n?person dbo:activeYearsStartYear ?years_active .\r\nOPTIONAL { \r\n?person foaf:homepage ?sito . }\r\n?wikipage foaf:primaryTopic ?person .\r\nFILTER (LANG(?Name)="en")\r\n }', 'extra_queries': [], 'map_filters': []}, {'position': 12, 'operations': [], 'type': 'action', 'action_title': 'Bio', 'action_query': 'PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>\r\nPREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>\r\nPREFIX dbo: <http://dbpedia.org/ontology/> \r\nPREFIX dbr: <http://dbpedia.org/resource/>\r\nPREFIX owl: <http://www.w3.org/2002/07/owl#>\r\nPREFIX dbp: <http://dbpedia.org/property/>\r\nPREFIX commons: <http://commons.wikimedia.org/wiki/Special:FilePath/>\r\nPREFIX foaf: <http://xmlns.com/foaf/0.1/>\r\n\r\nSELECT DISTINCT ?comment\r\nWHERE { \r\n?list a owl:Thing . \r\n?list ?relation dbr:List_of_best-selling_albums_by_women . \r\n?person a dbo:Animal ; a dbo:Person .\r\ndbr:List_of_best-selling_albums_by_women ?boh ?person .\r\n?person dbp:name ?Name .\r\n?person dbo:birthDate ?BirthDate .\r\nOPTIONAL { \r\n?person dbo:deathDate ?datam . }\r\n ?person dbo:activeYearsStartYear ?years_active .\r\nOPTIONAL { \r\n?person foaf:homepage ?sito . }\r\n?wikipage foaf:primaryTopic ?person .\r\n<<item>> rdfs:comment ?comment .\r\n FILTER (LANG(?comment)="en")\r\n }', 'extra_queries': [], 'map_filters': []}]}
Throughout history, numerous women have become cultural icons and symbols of female empowerment, thanks to their unique talents, distinctive voices, and memorable hits. With this story we want to explore some of the most influential and successful female musicians of all time, who have sold millions of records and inspired countless people around the world.