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

From Wikidata
Jump to navigation Jump to search
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)  View with Reasonator View with SQID
    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]