Authors: Sofia Mangione, Simona Serramondi
Source: SPARQL endpoint
Export
{'sparql_endpoint': 'https://query.wikidata.org/sparql', 'template_mode': 'statistics', 'title': 'The History of the Guitar ', 'color_code': ['#8039c6', '#173ccf'], 'user_name': 'SofiaMangione', 'id': '1685710021.158254', 'subtitle': 'The history of the instrument who changed the world of music', 'curator': 'Sofia Mangione, Simona Serramondi', 'description': 'This project stems from an overview of string instruments, particularly guitars, which have marked an important turning point in the history of music. You will discover how the guitar has influenced not only culture and music, but also the sales market. ', 'dynamic_elements': [{'position': 0, 'operations': [], 'type': 'text', 'text': '<p>A <a href="https://www.britannica.com/summary/stringed-instrument#:~:text=The%20orchestral%20stringed%20instruments%20include,%3B%20ukulele%3B%20viol%3B%20zither." target="_blank">stringed instrument</a> refers to any musical instrument that produces sound by the vibration of stretched strings. This vibration creates many different types of stringed instruments: <strong>449 </strong>is the number of types of stringed instruments existing in the world.</p>', 'extra_queries': [], 'map_filters': []}, {'position': 1, 'operations': [], 'type': 'count', 'count_query': 'SELECT (COUNT(?stringinstrument) AS ?count)\r\nWHERE {\r\n ?stringinstrument ?a wd:Q1798603 . \r\n}\r\n', 'count_label': 'Stringed instruments ', 'extra_queries': [], 'map_filters': []}, {'position': 2, 'operations': [], 'type': 'text', 'text': '<p>This number includes, however, many other realities, in particular the world of guitars. Here only the guitar types go up to 42832 different models.</p>', 'extra_queries': [], 'map_filters': []}, {'position': 3, 'operations': [], 'type': 'count', 'count_query': 'SELECT (COUNT(?guitar) AS ?count)\r\nWHERE {\r\n ?guitar ?a wd:Q6607 . \r\n}\r\n', 'count_label': 'Models of guitars ', 'extra_queries': [], 'map_filters': []}, {'position': 4, 'operations': [], 'type': 'text', 'text': '<p>Let’s now take a look at how the sounds of guitar are produced, based on the components of this instrument. Below, you are provided with a table with the different components that make up a guitar. </p>', 'extra_queries': [], 'map_filters': []}, {'position': 5, 'operations': [], 'type': 'table', 'table_title': 'The components of the guitar ', 'table_query': 'SELECT DISTINCT ?components ?componentsLabel ?image\r\nWHERE { wd:Q6607 wdt:P527 ?components . \r\n OPTIONAL { ?components wdt:P18 ?image . }\r\n SERVICE wikibase:label { bd:serviceParam wikibase:language "en".} } \r\nLIMIT 12\r\n', 'extra_queries': [], 'map_filters': []}, {'position': 6, 'operations': [], 'type': 'text', 'text': '<p>It can be seen from this table that the material that gives life to this instrument is <strong>wood</strong>. Almost all components are made of wood; in fact, wood is one of the factors that most influences the sound of a guitar. Its quality allows the strings to vibrate differently and determines the tone of the instrument. Yet, is it always just one type of wood? The answer is no. In fact, a specific wood is used for each guitar model. Depending on the model of the guitar (e.g., Ibanez, Fender, etc. ) we will have different types of wood (e.g., poplar wood, maple wood, mahogany wood and rosewood).</p><p>To give an idea of how the wood type look like, an <strong>image </strong>of it is provided by clicking "Show the image".</p>', 'extra_queries': [], 'map_filters': []}, {'position': 7, 'operations': [], 'type': 'textsearch', 'textsearch_userinput': 'Gibson ES-333', 'textsearch_title': 'Enter the model of a guitar to see what type of wood was employed. ', 'textsearch_query': 'SELECT DISTINCT ?guitar ?guitarLabel ?wood ?woodLabel\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 ?guitar wikibase:apiOutputItem mwapi:item.\r\n }\r\n ?guitar wdt:P186 ?wood .\r\n ?wood wdt:P31 wd:Q1493054 .\r\n ?guitar wdt:P31 wd:Q6607 .\r\n SERVICE wikibase:label { bd:serviceParam wikibase:language "en".}\r\n}\r\nORDER BY ?guitar\r\n\r\n\r\n', 'textsearch': {'wood': ['Show the image']}, 'extra_queries': [], 'map_filters': []}, {'position': 8, 'operations': [], 'type': 'action', 'action_title': 'Show the image', 'action_query': 'SELECT DISTINCT ?image ?imageLabel\r\nWHERE { \r\n <<item>> wdt:P18 ?image.\r\n\r\nSERVICE wikibase:label { \r\n bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en"\r\n }\r\n}', 'extra_queries': [], 'map_filters': []}, {'position': 9, 'operations': [], 'type': 'text', 'text': '<p>The presence of various types of guitars gives rise to different <strong>market demands</strong>, which vary according to the uses and types most valued by the guitar users. Here, then, two different tables are shown to present the number of acoustic and electric guitars sold over a period of time that goes from 1990 to 2016.</p>', 'extra_queries': [], 'map_filters': []}, {'position': 10, 'operations': [], 'type': 'chart', 'chart_type': 'linechart', 'chart_title': 'Sales of Acoustic Guitars ', 'chart_query': 'SELECT DISTINCT ?label (COUNT(?date) AS ?count) \r\nWHERE { ?guitar ?a wd:Q31561 . \r\n ?guitar wdt:P571 ?date .\r\n SERVICE wikibase:label { bd:serviceParam wikibase:language "en". ?date rdfs:label ?label. }\r\n FILTER(YEAR(?date) >= 1990 && YEAR(?date) <= 2020)\r\n } \r\nGROUP BY ?label \r\nORDER BY ASC(?label) \r\n\r\nLIMIT 30', 'chart_series': '', 'chart_legend': {'x': 'Years', 'y': 'Sales'}, 'extra_queries': [], 'map_filters': []}, {'position': 11, 'operations': [], 'type': 'chart', 'chart_type': 'linechart', 'chart_title': 'Sales of Electric Guitars ', 'chart_query': 'SELECT DISTINCT ?label (COUNT(?date) AS ?count) \r\nWHERE { ?guitar ?a wd:Q78987 . \r\n ?guitar wdt:P571 ?date .\r\n SERVICE wikibase:label { bd:serviceParam wikibase:language "en". ?date rdfs:label ?label. }\r\n FILTER(YEAR(?date) >= 1990 && YEAR(?date) <= 2020)\r\n } \r\nGROUP BY ?label \r\nORDER BY ASC(?label) \r\n\r\nLIMIT 30\r\n', 'chart_series': '', 'chart_legend': {'x': 'Years', 'y': 'Sales'}, 'extra_queries': [], 'map_filters': []}, {'position': 12, 'operations': [], 'type': 'text', 'text': '<p>As we can seen, not only do we have a greater number of sales of electric guitars, but more importantly these are concentrated around 1995, a year when rock-n roll had great success, but also around 2016, a year when the rock-n roll revival played an important role in the history of music. From here, the question arises as to what factors influenced these sales: hence, in the chart below the <strong>most influential guitarists </strong>are shown<strong> </strong>who boosted guitars sales.</p>', 'extra_queries': [], 'map_filters': []}, {'position': 13, 'operations': [], 'type': 'chart', 'chart_type': 'doughnutchart', 'chart_title': 'Most influential Guitarists in the world', 'chart_query': 'SELECT DISTINCT ?label (COUNT(distinct ?band) as ?count) \r\nWHERE {\r\n ?band wdt:P1303* wd:Q6607.\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 20 ', 'chart_series': '', 'chart_legend': {'x': '', 'y': ''}, 'extra_queries': [], 'map_filters': []}, {'position': 14, 'operations': [], 'type': 'text', 'text': '<p>The influence of the American guitarists has since spread throughout the world and thus, as the map shows, different countries have a higher or lower number of guitarists who have influenced their respective cultures (eg., Fabrizio De Andrè in Italy). </p>', 'extra_queries': [], 'map_filters': []}, {'position': 15, 'operations': [], 'type': 'map', 'map_title': 'Guitarists in every country', 'map_points_query': 'SELECT DISTINCT ?point ?pointLabel ?countryLabel ?lat ?long\r\nWHERE {\r\n?point wdt:P1303 wd:Q6607 .\r\n ?point wdt:P27 ?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', 'extra_queries': [], 'map_filters': []}]}
This project stems from an overview of string instruments, particularly guitars, which have marked an important turning point in the history of music. You will discover how the guitar has influenced not only culture and music, but also the sales market.