{"id":64,"date":"2018-02-21T01:41:06","date_gmt":"2018-02-21T01:41:06","guid":{"rendered":"http:\/\/thinking.is.ed.ac.uk\/wikidata-basics\/?p=64"},"modified":"2018-02-21T14:12:59","modified_gmt":"2018-02-21T14:12:59","slug":"practical-personalising-a-sparql-query-and-mass-edits","status":"publish","type":"post","link":"https:\/\/thinking.is.ed.ac.uk\/wikidata-basics\/practical-personalising-a-sparql-query-and-mass-edits\/","title":{"rendered":"Practical – Personalising a SPARQL query and mass edits"},"content":{"rendered":"

We’ve created some SPARQL queries recently which demonstrate the information Wikidata possesses about alumni from the University of Edinburgh.<\/p>\n

Map of University of Edinburgh alumni by place of birth.<\/a><\/p>\n

Timeline of University of Edinburgh alumni by date of birth.<\/a><\/p>\n

Timeline of works by Robert Louis Stevenson.<\/a><\/p>\n

It is very easy to amend these queries to display different results by virtue of changing one aspect; the institution.<\/p>\n

    \n
  1. You will each be allocated a university from the list below. Look up the unique Q number for the institution you have been allocated on Wikidata<\/a>. Copy the Q number.<\/li>\n
  2. Then click on the map link above to swap out the University of Edinburgh’s unique Q number (Q160302) with the new Q number. Hit run.<\/li>\n
  3. Copy the link to export the result onto the Etherpad sheet<\/a>. Give it a name e.g University of York – map of alumni<\/em>.<\/li>\n<\/ol>\n

     <\/p>\n

      \n
    1. University of York (Q967165) \u2013 Petscan. https:\/\/petscan.wmflabs.org\/?psid=3301937<\/a><\/li>\n
    2. University of Bristol \u2013 Petscan https:\/\/petscan.wmflabs.org\/?psid=3301940<\/a><\/li>\n
    3. University of Oxford \u2013 Petscan https:\/\/petscan.wmflabs.org\/?psid=3301942<\/a><\/li>\n
    4. University of Cambridge \u2013 Petscan https:\/\/petscan.wmflabs.org\/?psid=3301946<\/a><\/li>\n
    5. University of Glasgow \u2013 Petscan https:\/\/petscan.wmflabs.org\/?psid=3301953<\/a><\/li>\n
    6. University of St. Andrews \u2013 Petscan https:\/\/petscan.wmflabs.org\/?psid=3301954<\/a><\/li>\n
    7. University of Teesside \u2013 Petscan https:\/\/petscan.wmflabs.org\/?psid=3301958<\/a><\/li>\n
    8. University of Trinity College, Dublin \u2013 Petscan https:\/\/petscan.wmflabs.org\/?psid=3301961<\/a><\/li>\n
    9. University of Dundee \u2013 Petscan https:\/\/petscan.wmflabs.org\/?psid=3301994<\/a><\/li>\n
    10. University of Heriot-Watt \u2013 Petscan https:\/\/petscan.wmflabs.org\/?psid=3301996<\/a><\/li>\n
    11. University of Edinburgh Napier \u2013 Petscan https:\/\/petscan.wmflabs.org\/?psid=3301999<\/a><\/li>\n
    12. Queen\u2019s University Belfast \u2013 Petscan https:\/\/petscan.wmflabs.org\/?psid=3302001<\/a><\/li>\n
    13. University of Strathclyde \u2013 Petscan https:\/\/petscan.wmflabs.org\/?psid=3302003<\/a><\/li>\n
    14. Glasgow Caledonian University \u2013 Petscan https:\/\/petscan.wmflabs.org\/?psid=3302004<\/a><\/li>\n
    15. University of Stirling \u2013 Petscan https:\/\/petscan.wmflabs.org\/?psid=3302006<\/a><\/li>\n
    16. University of Manchester \u2013 Petscan https:\/\/petscan.wmflabs.org\/?psid=3302007<\/a><\/li>\n
    17. University of Plymouth \u2013 Petscan https:\/\/petscan.wmflabs.org\/?psid=3302008<\/a><\/li>\n
    18. University of Northampton \u2013 Petscan https:\/\/petscan.wmflabs.org\/?psid=3302009<\/a><\/li>\n
    19. London Metropolitan University \u2013 Petscan https:\/\/petscan.wmflabs.org\/?psid=3302010<\/a><\/li>\n
    20. University of Liverpool \u2013 Petscan https:\/\/petscan.wmflabs.org\/?psid=3302012<\/a><\/li>\n
    21. University of Leeds \u2013 Petscan https:\/\/petscan.wmflabs.org\/?psid=3302014<\/a><\/li>\n
    22. University of East Anglia \u2013 Petscan https:\/\/petscan.wmflabs.org\/?psid=3302017<\/a><\/li>\n
    23. University of Exeter \u2013 Petscan https:\/\/petscan.wmflabs.org\/?psid=3302018<\/a><\/li>\n
    24. University of Sheffield \u2013 Petscan https:\/\/petscan.wmflabs.org\/?psid=3302020<\/a><\/li>\n
    25. Cardiff University \u2013 Petscan https:\/\/petscan.wmflabs.org\/?psid=3302021<\/a><\/li>\n
    26. Aberystwyth University \u2013 Petscan https:\/\/petscan.wmflabs.org\/?psid=3302022<\/a><\/li>\n
    27. Bath Spa University \u2013 Petscan https:\/\/petscan.wmflabs.org\/?psid=3302024<\/a><\/li>\n
    28. Swansea University \u2013 Petscan https:\/\/petscan.wmflabs.org\/?psid=3302040<\/a><\/li>\n<\/ol>\n

       <\/p>\n

      Mass editing Wikidata.<\/strong><\/p>\n

      Petscan is a very useful tool. In the above links, I have asked Petscan to show me Wikipedia articles on that exist in a Wikipedia category of ‘Alumni of xxxxxxx’. <\/strong>I have then filtered the result to show me only those Wikipedia pages from that category where there is a Wikidata item for that person BUT no Place of Education (P69)<\/strong> statement.<\/p>\n

       <\/p>\n

      Using this information, I can copy the resulting information into a Google spreadsheet<\/a> and arrange it in a format that Wikidata can import via the QuickStatements<\/a> tool. So that’s exactly what we’re going to do.<\/p>\n

      It’s graduation day all over again for the alumni above!<\/strong><\/p>\n

      (Video tutorial 1<\/a>) (Video tutorial 2<\/a>). (Exemplar sheet<\/a>).<\/p>\n

      The syntax you need is explained in QuickStatements <\/a><\/u>v.1<\/a><\/u> and you can use the Wikidata plug-in<\/a><\/u> for Google Sheets to make wrangling the data in Google Sheets easier.<\/p>\n","protected":false},"excerpt":{"rendered":"

      We’ve created some SPARQL queries recently which demonstrate the information Wikidata possesses about alumni from the University of Edinburgh. Map of University of Edinburgh alumni by place of birth. Timeline of University of Edinburgh alumni by date of birth. Timeline of works by Robert Louis Stevenson. It is very easy to amend these queries to […]<\/p>\n","protected":false},"author":41,"featured_media":65,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-64","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/thinking.is.ed.ac.uk\/wikidata-basics\/wp-json\/wp\/v2\/posts\/64","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/thinking.is.ed.ac.uk\/wikidata-basics\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/thinking.is.ed.ac.uk\/wikidata-basics\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/thinking.is.ed.ac.uk\/wikidata-basics\/wp-json\/wp\/v2\/users\/41"}],"replies":[{"embeddable":true,"href":"https:\/\/thinking.is.ed.ac.uk\/wikidata-basics\/wp-json\/wp\/v2\/comments?post=64"}],"version-history":[{"count":3,"href":"https:\/\/thinking.is.ed.ac.uk\/wikidata-basics\/wp-json\/wp\/v2\/posts\/64\/revisions"}],"predecessor-version":[{"id":68,"href":"https:\/\/thinking.is.ed.ac.uk\/wikidata-basics\/wp-json\/wp\/v2\/posts\/64\/revisions\/68"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/thinking.is.ed.ac.uk\/wikidata-basics\/wp-json\/wp\/v2\/media\/65"}],"wp:attachment":[{"href":"https:\/\/thinking.is.ed.ac.uk\/wikidata-basics\/wp-json\/wp\/v2\/media?parent=64"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/thinking.is.ed.ac.uk\/wikidata-basics\/wp-json\/wp\/v2\/categories?post=64"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/thinking.is.ed.ac.uk\/wikidata-basics\/wp-json\/wp\/v2\/tags?post=64"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}