Authors: Miriam Longhitano, Laura Cigno, Anna Avona
Source: SPARQL endpoint
Export
{'sparql_endpoint': 'https://query.wikidata.org/sparql', 'template_mode': 'statistics', 'title': 'Cesare Cremonini', 'color_code': ['#c098fb', '#243dff'], 'user_name': 'mirialonghitano', 'id': '1687730593.346508', 'subtitle': "An overview on Cesare Cremonini's life and music", 'curator': 'Miriam Longhitano, Laura Cigno, Anna Avona', 'description': 'This project will be about one of the best Italian singer songwirter from Bologna: Cesare Cremonini. He was of the best Italian singer-songwriters. As a substantial part of Italian culture, we will analyze his life and works.', 'dynamic_elements': [{'position': 0, 'operations': [], 'type': 'text', 'text': '<p>Cesare Cremonini is an Italian singer-songwriter and musician who has gained widespread acclaim for his soulful voice, introspective lyrics, and captivating melodies. Born on March 27, 1980, in Bologna, Italy, Cremonini developed a passion for music at a young age and embarked on a remarkable journey that would establish him as one of the most prominent figures in the Italian music industry.</p><p>Growing up in a family that appreciated the arts, Cesare Cremonini was exposed to various musical genres from an early age. He began playing the piano at the age of six and quickly discovered his innate talent for music. As he honed his skills, Cremonini started writing his own songs, showcasing his creativity and knack for storytelling.</p><p>In 1996, Cremonini formed the band Senza Filtro with some of his friends; its name was changed in Lùnapop in 1997. The group gained much popularity, thanks to their infectious pop-rock sound and catchy songs. Their debut album, "...Squérez?" released in 1999, became a commercial success in Italy and spawned several hit singles. Cesare\'s distinctive voice and charismatic stage presence quickly made him a fan favorite.</p><p>However, despite the band\'s success, Cesare Cremonini felt the need to pursue a solo career to explore his artistic vision further. In 2002, he released his first solo album, "Bagus," which showcased a more introspective and mature sound compared to his earlier work with Lùnapop. The album received critical acclaim, and Cremonini\'s solo career was off to a promising start.</p><p>Over the following years, Cesare Cremonini continued to release a string of successful albums, each displaying his growth as an artist and his ability to connect with audiences on a profound level. His music became known for its emotional depth, tackling love, loss, and personal introspection themes. Cremonini\'s distinctive voice, characterized by its soulful timbre and emotive delivery, further solidified his position as one of Italy\'s most beloved musicians.</p><p>Some of his most notable albums include "Maggese" (2005), "1999-2010 The Greatest Hits" (2010), "La teoria dei colori" (2012), and "Possibili Scenari" (2017). These albums spawned numerous chart-topping singles, earning Cremonini numerous awards and accolades throughout his career.</p><p>Beyond his musical accomplishments, Cesare Cremonini is known for his philanthropic endeavors and dedication to social causes. He has been involved in various charitable initiatives, using his platform and resources to positively impact society.</p><p>If you want to learn more on Cremonini\'s life and works please <a href="https://en.wikipedia.org/wiki/Cesare_Cremonini_(musician)" target="_blank">click here</a></p>', 'extra_queries': [], 'map_filters': []}, {'position': 1, 'operations': [], 'type': 'table', 'table_title': 'CESARE CREMONINI', 'table_query': 'SELECT DISTINCT ?image WHERE { wd:Q1056805 wdt:P18 ?image . }', 'extra_queries': [], 'map_filters': []}, {'position': 2, 'operations': [], 'type': 'table', 'table_title': 'BEGINNING OF HIS CAREER', 'table_query': 'SELECT DISTINCT ?Start ?StartLabel WHERE { wd:Q1056805 wdt:P2031 ?Start . }', 'extra_queries': [], 'map_filters': []}, {'position': 3, 'operations': [], 'type': 'count', 'count_query': 'SELECT (COUNT(?singer) AS ?count)\r\nWHERE {\r\n ?singer ?a wd:Q482994 .\r\n ?singer wdt:P175 wd:Q1056805 .\r\n}\r\n', 'count_label': 'MUSICAL ALBUM BY CREMONINI', 'extra_queries': [], 'map_filters': []}, {'position': 4, 'operations': [], 'type': 'table', 'table_title': 'CHRONOLOGICAL LIST OF HIS ALBUMS', 'table_query': 'SELECT DISTINCT (?label AS ?album) (YEAR(xsd:dateTime(?date)) AS ?date) WHERE {\r\n ?album wdt:P31 wd:Q482994;\r\n wdt:P175 wd:Q1056805;\r\n wdt:P577 ?date.\r\n SERVICE wikibase:label {\r\n bd:serviceParam wikibase:language "en".\r\n ?album rdfs:label ?label.\r\n }\r\n}\r\nGROUP BY ?label ?date\r\nORDER BY (?date)', 'extra_queries': [], 'map_filters': []}, {'position': 5, 'operations': [], 'type': 'table', 'table_title': 'HIS ALBUM AS "LUNAPOP" MEMBER', 'table_query': 'SELECT DISTINCT (?label AS ?album) (YEAR(xsd:dateTime(?date)) AS ?date) WHERE {\r\n ?album wdt:P31 wd:Q482994;\r\n wdt:P175 wd:Q3841122;\r\n wdt:P577 ?date.\r\n SERVICE wikibase:label {\r\n bd:serviceParam wikibase:language "en".\r\n ?album rdfs:label ?label.\r\n }\r\n}\r\nGROUP BY ?label ?date\r\nORDER BY (?date)', 'extra_queries': [], 'map_filters': []}, {'position': 6, 'operations': [], 'type': 'chart', 'chart_type': 'doughnutchart', 'chart_title': 'TREND OF WORKS BY GENRE', 'chart_query': 'SELECT DISTINCT (?genre AS ?label) (COUNT(?label) AS ?count) WHERE {\r\n ?item wdt:P175 wd:Q1056805;\r\n wdt:P136 ?genre.\r\n SERVICE wikibase:label {\r\n bd:serviceParam wikibase:language "en".\r\n ?item rdfs:label ?label.\r\n }\r\n}\r\nGROUP BY ?count ?genre\r\nORDER BY (?label)\r\nLIMIT 50\r\n', 'chart_series': 'WORKS BY GENRE', 'chart_legend': {'x': 'GENRE', 'y': 'WORKS'}, 'extra_queries': [], 'map_filters': []}, {'position': 7, 'operations': [], 'type': 'textsearch', 'textsearch_userinput': '', 'textsearch_title': 'OTHER POP MUSICIANS', 'textsearch_query': 'SELECT DISTINCT ?singers ?singersLabel ?category ?categoryLabel WHERE {\r\n SERVICE wikibase:mwapi {\r\n bd:serviceParam wikibase:endpoint "www.wikidata.org";\r\n wikibase:api "EntitySearch";\r\n mwapi:search "Cremonini";\r\n mwapi:language "it".\r\n ?singer wikibase:apiOutputItem mwapi:item.\r\n }\r\n {\r\n {?singers wdt:P31 ?category ; wdt:P495 wd:Q38 .\r\n ?category wdt:P31 wd:Q60723829 . }\r\n UNION\r\n {?singers wdt:P31 ?category ; wdt:P495 wd:Q38.\r\n ?category wdt:P279 wd:Q215380 }\r\n }\r\nSERVICE wikibase:label { \r\n bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en"\r\n }\r\n} LIMIT 20', 'textsearch': {'genre': ['show same genre musicians'], 'singers': ['show genre']}, 'extra_queries': [], 'map_filters': []}, {'position': 8, 'operations': [], 'type': 'action', 'action_title': 'show genre', '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\r\n', 'extra_queries': [], 'map_filters': []}, {'position': 9, 'operations': [], 'type': 'action', 'action_title': 'show same genre musicians', 'action_query': 'SELECT DISTINCT ?band ?bandLabel ?category ?categoryLabel ?country ?countryLabel WHERE {\r\n ?band wdt:P31 ?category ; wdt:P495 wd:Q38 ; wdt:P136 <<item>> .\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 10\r\n', 'extra_queries': [], 'map_filters': []}, {'position': 10, 'operations': [], 'type': 'table', 'table_title': 'NOMINATION RECEIVED', 'table_query': 'SELECT DISTINCT ?label (COUNT(DISTINCT ?nomination) AS ?count) WHERE {\r\n ?cremonini ?a wd:Q1056805;\r\n wdt:P1411 ?nomination.\r\n SERVICE wikibase:label {\r\n bd:serviceParam wikibase:language "en".\r\n ?nomination rdfs:label ?label.\r\n }\r\n}\r\nGROUP BY ?label ?count\r\nORDER BY DESC (?count)\r\nLIMIT 20\r\n', 'extra_queries': [], 'map_filters': []}, {'position': 11, 'operations': [], 'type': 'table', 'table_title': 'FOLLOWERS ON YOUTUBE', 'table_query': 'SELECT DISTINCT ?followers WHERE { wd:Q1056805 wdt:P8687 ?followers . }', 'extra_queries': [], 'map_filters': []}]}
This project will be about one of the best Italian singer songwirter from Bologna: Cesare Cremonini. He was of the best Italian singer-songwriters. As a substantial part of Italian culture, we will analyze his life and works.