Wikidata:WikiProject Medicine/Talks/Wikimedia for Medicine course at Tel Aviv University 2021

COVID-19 on Wikidata (details)
Video about COVID19: R0, the case fatality rate and why we need to flatten the curve (traffic stats)

About edit

This page hosts the materials for a presentation given remotely on 5 January 2021 and 28 December 2021 as part of the Wikimedia for Medicine course at Tel Aviv University (Q319239).

Notes edit

We are using https://etherpad.wikimedia.org/p/Wikidata-at-WikiMed-course-at-TAU-2021-01-05 for shared notes.

Starting points edit

Queries edit

COVID-19-related edit

Handcrafted edit

National flags sorted by number of colours edit

# colorful state flags
#defaultView:ImageGrid
SELECT ?state ?stateLabel (COUNT(?color) AS ?count) ?image WITH {
  SELECT DISTINCT ?state WHERE {
    ?state wdt:P31/wdt:P279* wd:Q3624078;
           p:P463 ?memberOfStatement.
    ?memberOfStatement a wikibase:BestRank;
                         ps:P463 wd:Q1065.
    MINUS { ?memberOfStatement pq:P582 ?endTime. }
    MINUS { ?state wdt:P576|wdt:P582 ?end. }
  }
} AS %states WHERE {
  INCLUDE %states.
  ?state wdt:P163 ?flag.
  ?flag wdt:P462 ?color.
  OPTIONAL { ?flag wdt:P18 ?image. }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
GROUP BY ?state ?stateLabel ?image
ORDER BY DESC(?count)
LIMIT 25
Try it!

Medical conditions with headache and cough edit

The following query uses these:

  • Properties: symptoms and signs (P780)     
    SELECT DISTINCT ?condition ?conditionLabel WHERE {
      ?condition wdt:P780 wd:Q86 . #headache
      ?condition wdt:P780 wd:Q35805 . #cough
      SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    }
    

Canned edit

Listeria edit

Scholia edit

PARAMOUNT trial (Q17148583) edit
PARAMOUNT trial (Q17148583) edit
Israel Prize (Q616568) edit
Israel and diabetes edit

Ordia edit

Potential activities related to the course edit

  • How to handle updates in databases Wikidata links to, e.g. recent changes to Medical Subject Headings (MeSH)?
  • Give a medicine/ Israel/ Hebrew spin to anything in Wikidata:Wikidata curricula/Activities
  • Translate any of the above
  • Set up some lexeme forms in Hebrew to make it easier to enter lexicographic data about Hebrew into Wikidata
  • Translate the Scholia interface
  • Annotate items related to Israel or Hebrew
    • medical conditions frequently encountered in Israel
      • publications about such medical conditions
    • institutions based in Israel
    • researchers based at/ educated at institutions based in Israel
      • publications by such researchers

See also edit