{"id":1476,"date":"2017-03-21T19:42:12","date_gmt":"2017-03-21T19:42:12","guid":{"rendered":"http:\/\/www.mollieecheverria.com\/?page_id=1476"},"modified":"2017-04-01T22:23:38","modified_gmt":"2017-04-01T22:23:38","slug":"linked-jazz-dbpedia-wikidata","status":"publish","type":"page","link":"https:\/\/www.mollieecheverria.com\/?page_id=1476","title":{"rendered":"DBpedia to Wikidata: Exploring the Linked Jazz Name Directory"},"content":{"rendered":"<h4>Project Title:<\/h4>\n<p>DBpedia to Wikidata: Exploring the Linked Jazz Name Directory<\/p>\n<h4>Course:<\/h4>\n<p>LIS-664 &#8211; Program for Cultural Heritage, Fall 2016, Pratt Institute<\/p>\n<h4>Project Description:<\/h4>\n<p>This project was informed by my involvement in Pratt&#8217;s long-running <a href=\"https:\/\/linkedjazz.org\/\">Linked Jazz<\/a> project, which seeks to explore the relationships and collaborations between jazz musicians by extracting relationship data from oral history transcripts and publishing it as semantically-structured <a href=\"https:\/\/en.wikipedia.org\/wiki\/Linked_data\">linked data<\/a>. Linked Jazz recently received a <a href=\"https:\/\/linkedjazz.org\/new-orleans-jazz-and-heritage-foundation-grant\/\">grant from the New Orleans Jazz and Heritage Foundation<\/a> to create a dataset focused specifically on New Orleans-based jazz musicians. As a\u00a0test project for this grant, I wanted to explore what familial relationship data about New Orleans-based jazz musicians was available on <a href=\"https:\/\/www.wikidata.org\/\">Wikidata<\/a>, a popular linked data repository. I also wanted to compare Wikidata to another popular linked data dataset, <a href=\"http:\/\/wiki.dbpedia.org\/\">DBpedia<\/a>, which was used during the creation of the Linked Jazz dataset in 2011, but which has been increasingly supplanted by Wikidata in the succeeding six years.<\/p>\n<h4>Project Documentation<\/h4>\n<p><a href=\"http:\/\/pfch.nyc\/wikidata_exploration\/index.html\">View Project Website<\/a> &#8211; <a href=\"https:\/\/www.mollieecheverria.com\/wp-content\/uploads\/2017\/03\/Exploring-the-Linked-Jazz-Directory-in-Wikidata.pdf\">Download Project Presentation<\/a><\/p>\n<h4>Methods:<\/h4>\n<p>I started by downloading the original <a href=\"https:\/\/linkedjazz.org\/content\/linked-jazz-name-directory\/\">Linked Jazz Name Directory<\/a>, available online as an <a href=\"https:\/\/en.wikipedia.org\/wiki\/N-Triples\">N-Triple file<\/a>. This directory includes the names of about 9,000 jazz musicians along with their <a href=\"https:\/\/www.w3.org\/TR\/ld-bp\/#HTTP-URIS\">persistent resource identifiers<\/a> on DBpedia. To find the equivalent identifiers for these musicians on Wikidata, I first had to separate these names out into <a href=\"https:\/\/en.wikipedia.org\/wiki\/JSON\">JSON<\/a> using a <a href=\"https:\/\/en.wikipedia.org\/wiki\/Python_(programming_language)\">Python<\/a> script. Because resources on DBpedia (<a href=\"http:\/\/dbpedia.org\/page\/Miles_Davis\">see example<\/a>) contain links to the identifier for the same person, place, or thing on other linked data repositories, I could then use another Python script to extract the corresponding Wikidata ID for each name in the Linked Jazz Directory. With these names, I used another script to query Wikidata for the <a href=\"https:\/\/www.wikidata.org\/wiki\/Property:P19\">place of birth<\/a> and <a href=\"https:\/\/www.wikidata.org\/wiki\/Property:P20\">place of death<\/a> of each musician. Using even more scripts, I narrowed down the directory to only musicians who had been born in or died in New Orleans. I then attempted to query Wikidata for information about the <a href=\"https:\/\/www.wikidata.org\/wiki\/Wikidata:List_of_properties\/Person#Relationship\">relatives of these individuals<\/a>, but was not able to find much data. Because I already had data on where musicians in the Linked Jazz Directory were born and\/or had died, I decided to experiment with the\u00a0<a href=\"https:\/\/www.tableau.com\/\">Tableau<\/a> software platform to create a <a href=\"https:\/\/public.tableau.com\/profile\/mollie.echeverria#!\/vizhome\/WikidataPlaceofBirth\/PlaceofDeath\">geomapped visualization<\/a> of these locations.<\/p>\n<h4>My Role:<\/h4>\n<p>I worked on this project alone, but used scripts created by Molly Reese-Lerner and fellow Linked Jazz team member Hannah Sistrunk for <a href=\"https:\/\/github.com\/mreesele\/CH-LJ\">an LIS-664-01 project the previous year<\/a>, along with scripts created by Linked Jazz project member and METRO Fellow <a href=\"https:\/\/twitter.com\/izahoina\">Karen Li-Lun Hwang, <\/a> as the basis of many of the scripts I used.<\/p>\n<h4>Learning Objective Achieved:<\/h4>\n<p>Technology<\/p>\n<h4>Rationale:<\/h4>\n<p>This project was primarily based on Python programming. I also worked with data serialization formats including N-Triples and JSON, semantic web datasets, and data visualization software.<\/p>\n<h4>Additional Learning Objective Achieved:<\/h4>\n<p>Communication<\/p>\n<h4>Rationale:<\/h4>\n<p>Using Tableau, I created an interactive visualization of the jazz musician birth and death data I pulled from Wikidata.<\/p>\n<h4>Additional Learning Objective Achieved:<\/h4>\n<p>Reflective Practice<\/p>\n<h4>Rationale:<\/h4>\n<p>This project was in part meant to examine Wikidata as a replacement source for DBpedia, and to explore trends in the use of linked data datasets as a whole.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Project Title: DBpedia to Wikidata: Exploring the Linked Jazz Name Directory Course: LIS-664 &#8211; Program for Cultural Heritage, Fall 2016, Pratt Institute Project Description: This project was informed by my involvement in Pratt&#8217;s long-running Linked Jazz project, which seeks to explore the relationships and collaborations between jazz musicians by extracting relationship data from oral history [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":1722,"parent":1603,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"ngg_post_thumbnail":0,"footnotes":""},"class_list":["post-1476","page","type-page","status-publish","has-post-thumbnail","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>DBpedia to Wikidata: Exploring the Linked Jazz Name Directory &#8211; Mollie Echeverr\u00eda<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.mollieecheverria.com\/?page_id=1476\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/?page_id=1476\",\"url\":\"https:\\\/\\\/www.mollieecheverria.com\\\/?page_id=1476\",\"name\":\"DBpedia to Wikidata: Exploring the Linked Jazz Name Directory &#8211; Mollie Echeverr\u00eda\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/?page_id=1476#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/?page_id=1476#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.mollieecheverria.com\\\/wp-content\\\/uploads\\\/2017\\\/03\\\/Dashboard-1.png\",\"datePublished\":\"2017-03-21T19:42:12+00:00\",\"dateModified\":\"2017-04-01T22:23:38+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/?page_id=1476#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.mollieecheverria.com\\\/?page_id=1476\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/?page_id=1476#primaryimage\",\"url\":\"https:\\\/\\\/www.mollieecheverria.com\\\/wp-content\\\/uploads\\\/2017\\\/03\\\/Dashboard-1.png\",\"contentUrl\":\"https:\\\/\\\/www.mollieecheverria.com\\\/wp-content\\\/uploads\\\/2017\\\/03\\\/Dashboard-1.png\",\"width\":1968,\"height\":1568},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/?page_id=1476#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Projects\",\"item\":\"https:\\\/\\\/www.mollieecheverria.com\\\/?page_id=1603\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"DBpedia to Wikidata: Exploring the Linked Jazz Name Directory\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/#website\",\"url\":\"https:\\\/\\\/www.mollieecheverria.com\\\/\",\"name\":\"Mollie Echeverr\u00eda\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.mollieecheverria.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"DBpedia to Wikidata: Exploring the Linked Jazz Name Directory &#8211; Mollie Echeverr\u00eda","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.mollieecheverria.com\/?page_id=1476","twitter_misc":{"Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.mollieecheverria.com\/?page_id=1476","url":"https:\/\/www.mollieecheverria.com\/?page_id=1476","name":"DBpedia to Wikidata: Exploring the Linked Jazz Name Directory &#8211; Mollie Echeverr\u00eda","isPartOf":{"@id":"https:\/\/www.mollieecheverria.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.mollieecheverria.com\/?page_id=1476#primaryimage"},"image":{"@id":"https:\/\/www.mollieecheverria.com\/?page_id=1476#primaryimage"},"thumbnailUrl":"https:\/\/www.mollieecheverria.com\/wp-content\/uploads\/2017\/03\/Dashboard-1.png","datePublished":"2017-03-21T19:42:12+00:00","dateModified":"2017-04-01T22:23:38+00:00","breadcrumb":{"@id":"https:\/\/www.mollieecheverria.com\/?page_id=1476#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.mollieecheverria.com\/?page_id=1476"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.mollieecheverria.com\/?page_id=1476#primaryimage","url":"https:\/\/www.mollieecheverria.com\/wp-content\/uploads\/2017\/03\/Dashboard-1.png","contentUrl":"https:\/\/www.mollieecheverria.com\/wp-content\/uploads\/2017\/03\/Dashboard-1.png","width":1968,"height":1568},{"@type":"BreadcrumbList","@id":"https:\/\/www.mollieecheverria.com\/?page_id=1476#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Projects","item":"https:\/\/www.mollieecheverria.com\/?page_id=1603"},{"@type":"ListItem","position":2,"name":"DBpedia to Wikidata: Exploring the Linked Jazz Name Directory"}]},{"@type":"WebSite","@id":"https:\/\/www.mollieecheverria.com\/#website","url":"https:\/\/www.mollieecheverria.com\/","name":"Mollie Echeverr\u00eda","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.mollieecheverria.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/www.mollieecheverria.com\/index.php?rest_route=\/wp\/v2\/pages\/1476","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mollieecheverria.com\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.mollieecheverria.com\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.mollieecheverria.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mollieecheverria.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1476"}],"version-history":[{"count":17,"href":"https:\/\/www.mollieecheverria.com\/index.php?rest_route=\/wp\/v2\/pages\/1476\/revisions"}],"predecessor-version":[{"id":2002,"href":"https:\/\/www.mollieecheverria.com\/index.php?rest_route=\/wp\/v2\/pages\/1476\/revisions\/2002"}],"up":[{"embeddable":true,"href":"https:\/\/www.mollieecheverria.com\/index.php?rest_route=\/wp\/v2\/pages\/1603"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.mollieecheverria.com\/index.php?rest_route=\/wp\/v2\/media\/1722"}],"wp:attachment":[{"href":"https:\/\/www.mollieecheverria.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1476"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}