Babel user information
en-N This user has a native understanding of English.
fr-1 Cet utilisateur dispose de connaissances de base en français.
Users by language

About

edit

Data Migration Specialist at LYRASIS

Data model

edit
  • [Generic Tree] - generate trees from Wikidata structures, such as subclasses, administrative divisions, and taxons

Properties

edit

Find and explore properties. "Properties useful for..." in the Notes section below collects specific properties salient to topics I'm working on.

Ranking and deprecating statements

edit

Projects

edit

Working out models, best practices, enrichment of entries in certain areas...

Find stuff to do

edit


Tools and resources for editing, etc.

edit
  • Keyboard shortcuts (enable via preferences)
  • Recoin -- Recoin ("Relative Completeness Indicator") is a script that extends Wikidata entity pages with information about the relative completeness of the information. Relative completeness refers to the extent of information found on an item in comparison with other similar items.
  • Property trees -- Generate lists and trees from Wikidata structures, such as subclasses, administrative divisions, and taxons.
  • QuickStatements -- Enter statements in a tab delimited format
  • TABernacle tool | help
  • PetScan -- PetScan can generate lists of Wikipedia (and related projects) pages or Wikidata items that match certain criteria...
  • Request item deletion
  • Do Not Merge list whitelist pairs to keep them from being merged (or considered for merge)
  • Daty -- In development Daty is a free cross-platform advanced Wikidata editor adhering to GNOME Human Interface Guidelines, intended to enable better editing workflow. Use Daty to search, select, read, batch edit items, script actions, share, visualize proposed changes and bots.

Living people

edit

Querying / SPARQL

edit

Examples of GLAM applications using Wikidata

edit
  • Scholia -- Scholarly profile pages constructed from queries to Wikidata Query Service.

Notes

edit

Properties useful for...

edit

Authority control for people

edit

Instances of: Wikidata property for authority control for people (Q19595382)

SELECT ?item ?itemLabel 
WHERE 
{
  ?item wdt:P31 wd:Q19595382.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Mythology, deities, etc.

edit
  • appears in the form of P4675
  • incarnation of P3701
  • possessed by spirit P4292
  • superhuman feature or ability P2563
  • totem P2831
  • worshipped by P1049

Follow up

edit

My cryptic notes about stuff to wrap up.

Deletion request

edit

https://www.wikidata.org/wiki/Q19283707


Dissertation: https://search.proquest.com/pqdtglobal/docview/303891952/DBE731F29028423BPQ/1?accountid=14244

The longitudinal effects of medical treatment on the intellectual functioning and academic achievement of pediatric oncology patients
Netherton, Sandra Dee. Texas Tech University, ProQuest Dissertations Publishing, 1990. 9115353. 

Query examples

edit

Monolingual text value in results, filtered to a given language

edit
SELECT ?item ?itemLabel ?val WHERE {
  ?item wdt:P1451 ?val.
  BIND(LANG(?val) AS ?language)
  FILTER((LANG(?val)) = "en")
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
LIMIT 50

Motto text, excluding organizations and military units, showing 'instance of' value

edit
SELECT DISTINCT ?item ?itemLabel ?val ?type ?typeLabel WHERE {
  ?item wdt:P1451 ?val.
  MINUS {?item wdt:P31/wdt:P279* wd:Q23905069.}
  MINUS {?item wdt:P31/wdt:P279* wd:Q43229.}
  OPTIONAL {?item wdt:P31 ?type.}
  BIND(LANG(?val) AS ?language)
  FILTER((LANG(?val)) = "en")
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
LIMIT 50

People whose archives are held by Computer History Museum and their employers

edit

source: https://twitter.com/WikiDigi/status/1076121699957977088

SELECT ?person ?personLabel ?employer ?employerLabel ("00FFFF" AS ?rgb) WHERE {
  ?person wdt:P485 wd:Q964035.
  ?person wdt:P108 ?employer.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}

items with Collective Biographies of Women ID (P4539) AND without English Wikipedia articles

edit
# items with Collective Biographies of Women ID (P4539) AND without English Wikipedia articles  
SELECT ?item ?itemLabel ?val
WHERE 
{
  ?item wdt:P4539 ?val.
  FILTER NOT EXISTS { 
    ?articleEn schema:about ?item.
    ?articleEn schema:isPartOf <https://en.wikipedia.org/>.
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Count most used properties for instances of a class (Books)

edit
SELECT ?prop ?propLabel ?count WHERE {
    {
        SELECT ?prop (COUNT(DISTINCT ?item) AS ?count) WHERE {
           
           hint:Query hint:optimizer "None" .
           ?item wdt:P31 wd:Q571 .
           ?item ?p ?id .
           ?prop wikibase:directClaim ?p .
        }  GROUP BY ?prop
    }
  
    SERVICE wikibase:label {
        bd:serviceParam wikibase:language "en" .
    }
} ORDER BY DESC (?count)
  NODES
admin 2
Note 4
Project 5
twitter 1
USERS 2