User:William Graham

Useful Wikidata links

• Help:Conflation of two people

Novel items

⍼ (Q87525261)

To do

• 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

• 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

• Make sure detangling of David C. Geary (Q902578) and David M. Geary (Q98935990) sticks

Done

• Create Talk Show the Game Show - Talk Show The Game Show (Q55740242)
• Create Foreign Service Labor Relations Board (Q55740630)

Useful tools

• https://johnnythetank.github.io/youtube-channel-name-converter/
• https://tweeterid.com/
• youtube-dl -f 'bestvideo[ext=webm]+bestaudio[ext=webm]'

Queries

• 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

https://query.wikidata.org/#PREFIX%20xsd%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F2001%2FXMLSchema%23%3E%0D%0A%0D%0ASELECT%20%3Fitem%20%3FitemLabel%20%3FrecNum%20WHERE%20%7B%0D%0A%20%20%3Fitem%20wdt%3AP5239%20%3FrecNum.%0D%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0D%0A%7D%0D%0AORDER%20BY%20DESC%28xsd%3Ainteger%28%3FrecNum%29%29

To come back to

• amendments to the Voting Rights Act of 1965 (Q16824979)