William Graham
Joined 17 July 2017
Useful Wikidata links
editNovel items
editTo do
edit- Create field office as a kind of branch (Q1410110) of a United States federal government department or agency
- Split up United States legal system (Q4445375)
Conflations to resolve
edit- Maria García-Gil (Q39986852) - Need to fix all the object named as statements first.
- George Davey Smith (Q21003878) potentially conflated, has 1600+ articles and lots of them are missing object named as.
To monitor
edit- Make sure detangling of David C. Geary (Q902578) and David M. Geary (Q98935990) sticks
Done
edit- Create Talk Show the Game Show - Talk Show The Game Show (Q55740242)
- Create Foreign Service Labor Relations Board (Q55740630)
Useful tools
edit- https://johnnythetank.github.io/youtube-channel-name-converter/
- https://tweeterid.com/
- youtube-dl -f 'bestvideo[ext=webm]+bestaudio[ext=webm]'
Queries
edit- https://query.wikidata.org/#SELECT%20%3Fitem%20%3Fdesc%20WHERE%20%7B%0A%20%20%3Fitem%20wdt%3AP31%2B%20wd%3AQ476068.%0A%20%20OPTIONAL%20%7B%0A%20%20%20%20%3Fitem%20rdfs%3Alabel%20%3Fdesc.%0A%20%20%20%20FILTER%28%28LANG%28%3Fdesc%29%29%20%3D%20"en"%29%0A%20%20%7D%0A%7D
- https://query.wikidata.org/#SELECT%20%3Fitem%20%3FitemLabel%20WHERE%20%7B%0A%20%20%3Fitem%20wdt%3AP17%20wd%3AQ30.%0A%20%20%3Fitem%20rdfs%3Alabel%20%3FitemLabel.%0A%20%20FILTER%28%28LANG%28%3FitemLabel%29%29%20%3D%20%22en%22%29%0A%20%20FILTER%28REGEX%28%3FitemLabel%2C%20%22%20Act%24%22%2C%20%22i%22%29%29%0A%20%20%0A%7D
- https://query.wikidata.org/#SELECT%20%3Fitem%20%3FitemLabel%20WHERE%20%7B%0A%20%20%3Fitem%20wdt%3AP17%20wd%3AQ30.%0A%20%20%3Fitem%20rdfs%3Alabel%20%3FitemLabel.%0A%20%20FILTER%28%28LANG%28%3FitemLabel%29%29%20%3D%20%22en%22%29%0A%20%20FILTER%28REGEX%28%3FitemLabel%2C%20%22%20act%24%22%2C%20%22i%22%29%29%0A%20%20%0A%7D
- https://query.wikidata.org/#SELECT%20%3Fitem%20%3FitemLabel%20WHERE%20%7B%0A%20%20%3Fitem%20wdt%3AP17%20wd%3AQ30.%0A%20%20%3Fitem%20rdfs%3Alabel%20%3FitemLabel.%0A%20%20FILTER%28%28LANG%28%3FitemLabel%29%29%20%3D%20"en"%29%0A%20%20FILTER%28REGEX%28%3FitemLabel%2C%20"act%20of%20%5C%5Cd%5C%5Cd%5C%5Cd%5C%5Cd"%2C%20"i"%29%29%0A%20%20%0A%7D
- Overriden vetoes https://query.wikidata.org/#SELECT%20%3Fact%20%3FactLabel%20%3FsignatoryStatement%0AWHERE%0A%7B%0A%09%3Fact%20wdt%3AP31%20wd%3AQ476068%20.%20%20%20%20%23find%20act%20of%20congress%0A%20%20%20%20%3Fact%20p%3AP1891%20%3FsignatoryStatement%20.%0A%09%3FsignatoryStatement%20rdf%3Atype%20wdno%3AP1891%20.%20%20%20%23with%20at%20least%20one%20P1891%20(signatory)%20statement%20defined%20to%20be%20%22no%20value%22%0A%09SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22%20%7D%0A%7D
- Artists in Canada items https://query.wikidata.org/#SELECT%20%3Fhuman%20%3FhumanLabel%20%3FArtists_in_Canada_record_number%20WHERE%20%7B%0D%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0D%0A%20%20%3Fhuman%20wdt%3AP31%20wd%3AQ5.%0D%0A%20%20%3Fhuman%20wdt%3AP5239%20%3FArtists_in_Canada_record_number.%0D%0A%7D%0D%0AORDER%20BY%20xsd%3Ainteger%28%3FArtists_in_Canada_record_number%29
- Artists in Canada items 2