Wikidata:WikiProject COVID-19/Queries
Statistics relating to pandemic spread
editNumber of WHO confirmed cases and deaths globally by date
editThe following query uses these:
- Items: COVID-19 pandemic (Q81068910) , infection (Q166231) , World Health Organization (Q7817) , death (Q4)
- Properties: author (P50) , number of cases (P1603) , number of deaths (P1120) , stated in (P248) , point in time (P585)
#defaultView:LineChart SELECT ?date (MAX(?count) AS ?max_count) ?measureLabel WHERE { BIND(wd:Q81068910 AS ?outbreak). { BIND(wd:Q166231 AS ?measure). ?outbreak p:P1603 ?cases. ?cases prov:wasDerivedFrom/pr:P248/wdt:P50 wd:Q7817. ?cases pqv:P585/wikibase:timeValue ?date. ?cases psv:P1603/wikibase:quantityAmount ?count. ?cases psv:P1603/wikibase:quantityAmount ?infection_count. } UNION { BIND(wd:Q4 AS ?measure). ?outbreak p:P1120 ?deaths. ?deaths prov:wasDerivedFrom/pr:P248/wdt:P50 wd:Q7817. ?deaths pqv:P585/wikibase:timeValue ?date. ?deaths psv:P1120/wikibase:quantityAmount ?count. ?deaths psv:P1120/wikibase:quantityAmount ?death_count. } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } } GROUP BY ?date ?measureLabel ORDER BY ASC(?date) DESC(?measure)
Dashboard of cases per country
editThe following query uses these:
- Properties: part of (P361) , country (P17) , number of cases (P1603) , number of deaths (P1120) , point in time (P585)
SELECT ?item ?itemLabel ?dates ?caseNo ?deathNo ?countryLabel WHERE { ?item wdt:P361 wd:Q83741704 . OPTIONAL { ?item wdt:P17 ?country . } ?item p:P1603 ?cases . ?cases ps:P1603 ?caseNo ; pq:P585 ?dates . OPTIONAL{ ?item p:P1120 ?deaths . ?deaths pq:P585 ?dates ; ps:P1120 ?deathNo . } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } } ORDER BY ?country ?dates
(From Wikidata:WikiProject_Humanitarian_Wikidata#COVID-19_outbreak_dashboard)
Effect on individuals
editImage grid of individuals who have died from COVID-19 ordered by Wikidata item completeness
editThe following query uses these:
- Items: COVID-19 (Q84263196) , human (Q5)
- Properties: cause of death (P509) , instance of (P31) , date of death (P570) , date of birth (P569) , image (P18)
Features: ImageGrid (Q24515278)
#defaultView:ImageGrid
SELECT ?person ?date_of_death ?age ?image
WHERE {
?person wdt:P509 wd:Q84263196 ; wdt:P31 wd:Q5
OPTIONAL { ?person wdt:P570 ?date_of_death }
OPTIONAL { ?person wikibase:statements ?statements_count ; wikibase:sitelinks ?sitelinks_count ; wikibase:identifiers ?identifiers_count . BIND(?statements_count + ?sitelinks_count + ?identifiers_count AS ?rank)}
OPTIONAL { ?person wdt:P569 ?dob ; wdt:P570 ?dod . BIND(YEAR(?dod)-YEAR(?dob) as ?age) }
OPTIONAL { ?person wdt:P18 ?image }
}
ORDER BY DESC(?rank)
Notes:
- Only individuals with an image in Wikidata are shown in the image grid. Switch to tabular view to see a more complete list of individuals.
- Wikidata item completeness is based on the number of sitelinks, statements and identifiers for each Wikidata item for an individual.
Image grid of individuals who have been diagnosed with COVID-19 ordered by Wikidata item completeness
editThe following query uses these:
- Items: COVID-19 (Q84263196) , human (Q5)
- Properties: medical condition (P1050) , instance of (P31) , image (P18) , country of citizenship (P27)
Features: ImageGrid (Q24515278)
#defaultView:ImageGrid
SELECT ?person ?person_label (GROUP_CONCAT(?country_of_citizenship_label; separator=";") AS ?countries_of_citizenship) ?image ?rank
WHERE {
?person wdt:P1050 wd:Q84263196; wdt:P31 wd:Q5 .
OPTIONAL { ?person rdfs:label ?person_label . FILTER(LANG(?person_label) = "en")}
OPTIONAL { ?person wikibase:statements ?statements_count ; wikibase:sitelinks ?sitelinks_count ; wikibase:identifiers ?identifiers_count . BIND(?statements_count + ?sitelinks_count + ?identifiers_count AS ?rank)}
OPTIONAL { ?person wdt:P18 ?image }
OPTIONAL { ?person wdt:P27 ?country_of_citizenship . ?country_of_citizenship rdfs:label ?country_of_citizenship_label . FILTER(LANG(?country_of_citizenship_label) = "en")}
}
GROUP BY ?person ?person_label ?image ?rank
ORDER BY DESC(?rank)
Notes:
- Only individuals with an image in Wikidata are shown in the image grid. Switch to tabular view to see a more complete list of individuals.
- Wikidata item completeness is based on the number of sitelinks, statements and identifiers for each Wikidata item for an individual.
- Query could be improved by using Wikidata label service (automatic language choice) and hiding the ?rank output (but still using it for ORDER BY).
List of people who have died
editSee Wikidata:Lists/corona_virus_deaths
Map by place of death
edit- Items used: COVID-19 (Q84263196) , human (Q5)
- Properties used: cause of death (P509) , instance of (P31) , place of death (P20) , coordinate location (P625) , image (P18) , date of birth (P569) , date of death (P570)
- Features used: map (Q24515275)
#defaultView:Map{"hide":["?coor"]}
SELECT ?item ?itemLabel ?itemDescription ?img ?pod ?podLabel ?coor ?age
WHERE
{
?item wdt:P509 wd:Q84263196 ; wdt:P31 wd:Q5 .
?item wdt:P20 ?pod . ?pod wdt:P625 ?coor .
OPTIONAL { ?item wdt:P18 ?img }
OPTIONAL { ?item wdt:P569 ?dob ; wdt:P570 ?dod . BIND(YEAR(?dod)-YEAR(?dob) as ?age) }
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
Duration between first case and first death based on number of cases and number of deaths
edit- Items used: COVID-19 pandemic in China (Q83872271) , disease outbreak (Q3241045) , COVID-19 pandemic (Q81068910)
- Properties used: instance of (P31) , part of (P361) , number of deaths (P1120) , number of cases (P1603) , point in time (P585)
#For this to work, ideally ?cases and ?deaths would have a value of 1
#"significant event" (P793) could store the actual dates
#
SELECT ?item ?itemLabel
?firstdeath ?deaths
?firstcase ?cases
(?firstdeath - ?firstcase as ?diff)
WHERE
{
# VALUES ?item { wd:Q83872271 }
?item wdt:P31 wd:Q3241045 .
?item wdt:P361 wd:Q81068910 .
?item p:P1120 [pq:P585 ?firstdeath ; ps:P1120 ?deaths ] .
FILTER ( ?deaths > 0 )
FILTER NOT EXISTS
{
?item p:P1120 [pq:P585 ?date_deaths2 ; ps:P1120 ?deaths2 ].
FILTER( ?firstdeath > ?date_deaths2 )
}
?item p:P1603 [pq:P585 ?firstcase ; ps:P1603 ?cases ] .
FILTER ( ?cases > 0 )
FILTER NOT EXISTS
{
?item p:P1603 [pq:P585 ?date_cases2 ; ps:P1603 ?cases2 ]
FILTER ( ?firstcase > ?date_cases2 )
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Media items in Wikidata
editScientific journal articles
editwith COVIDWHO ID (P8150)
editThe following query uses these:
- Properties: COVIDWHO ID (P8150) , publication date (P577)
SELECT DISTINCT ?item ?itemLabel ?pdate { ?item wdt:P8150 ?covidwho . OPTIONAL { ?item wdt:P577 ?pdate } SERVICE wikibase:label { bd:serviceParam wikibase:language "en" } . }
- See also these related queries:
with main subject (P921) Sars-Cov-2, COVID-19, or the epidemic
editThe following query uses these:
- Items: SARS-CoV-2 (Q82069695) , COVID-19 (Q84263196) , COVID-19 pandemic (Q81068910) , scholarly article (Q13442814)
- Properties: instance of (P31) , main subject (P921) , publication date (P577)
SELECT DISTINCT ?item ?itemLabel ?pdate { VALUES ?topics { wd:Q82069695 wd:Q84263196 wd:Q81068910 } ?item wdt:P31 wd:Q13442814. ?item wdt:P921 ?topics. OPTIONAL { ?item wdt:P577 ?pdate } SERVICE wikibase:label { bd:serviceParam wikibase:language "en" } . }
with main subject molecular/structural biology of any SARS-related strain
editThe following query uses these:
- Items: structural biology (Q908902) , molecular biology (Q7202) , SARSr-CoV (Q278567) , protein (Q8054)
- Properties: parent taxon (P171) , title (P1476) , publication date (P577) , main subject (P921) , instance of (P31) , found in taxon (P703) , of (P642)
SELECT DISTINCT ?item ?title ?topicLabel ?taxonLabel ?protLabel (MIN(?pdate) AS ?pubdate) { VALUES ?topic { wd:Q908902 wd:Q7202 } ?item p:P921 [ ps:P921 ?topic; pq:P642 ?taxon ]. ?taxon wdt:P171 wd:Q278567. ?item wdt:P1476 ?title. ?item wdt:P577 ?pdate. OPTIONAL { ?item wdt:P921 ?prot. ?prot wdt:P31 wd:Q8054 { ?prot wdt:P703 ?taxon } UNION { ?prot wdt:P703 wd:Q278567 } } SERVICE wikibase:label { bd:serviceParam wikibase:language "en" } . } GROUP BY ?item ?title ?topicLabel ?taxonLabel ?protLabel ORDER BY ?pubdate
Biology of the SARS-CoV-2
editThe following query uses these:
- Items: Betacoronavirus (Q16532287)
- Properties: parent taxon (P171)
SELECT ?item ?itemLabel ?description WHERE { ?item wdt:P171* wd:Q16532287. BIND(SUBSTR( ?descriptionLong, 1, 80) AS ?description). SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". ?item rdfs:label ?itemLabel. ?item schema:description ?descriptionLong. } }
Control methods
editCurfews and restrictions on movement and activity
editThe following query uses these:
- Properties: instance of (P31) , has cause (P828) , part of (P361) , applies to jurisdiction (P1001) , start time (P580) , end time (P582)
SELECT ?lockdown ?lockdownLabel ?jurisdictionLabel ?countryLabel ?started ?ended WHERE { SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } ?lockdown wdt:P31 wd:Q6665312. ?lockdown wdt:P828 ?cause. ?cause wdt:P361+ wd:Q83741704. ?lockdown wdt:P1001 ?jurisdiction. ?lockdown wdt:P580 ?started. OPTIONAL { ?lockdown wdt:P582 ?ended } }
Proximity contact tracing protocols
editThe following query uses these:
- Properties: instance of (P31) , described by source (P1343) , developer (P178)
SELECT ?proximity_contact_tracing_protocol ?proximity_contact_tracing_protocolLabel ?described_by_source ?described_by_sourceLabel ?developer ?developerLabel WHERE { SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } ?proximity_contact_tracing_protocol wdt:P31 wd:Q93251355. OPTIONAL { ?proximity_contact_tracing_protocol wdt:P1343 ?described_by_source. } OPTIONAL { ?proximity_contact_tracing_protocol wdt:P178 ?developer. } }
Vaccines (and candidates)
editList of vaccine candiates with trial phases
editThe following query uses these:
- Items: COVID-19 vaccine (Q87719492) , COVID-19 (Q84263196) , SARS-CoV-2 (Q82069695) , vaccine (Q134808) , vaccine candidate (Q28051899) , inactivated vaccine (Q3560939) , Q96695067, adenovirus-based vaccine (Q96841548) , DNA vaccine (Q578537) , RNA vaccine (Q97153934) , protein subunit vaccine (Q97153933) , virus-like particle vaccine (Q58623657) , replicating viral vector vaccine (Q99518999)
- Properties: instance of (P31) , vaccine for (P1924) , described by source (P1343) , clinical trial phase (P6099)
SELECT DISTINCT ?item (SAMPLE(?itemLabel) AS ?itemLabel) (SAMPLE(?trialLabels) AS ?trialLabels) (SAMPLE(?typeLabel) AS ?typeLabel) WHERE { { ?item wdt:P31 wd:Q87719492 } UNION { VALUES ?v { wd:Q84263196 wd:Q82069695 } VALUES ?vv { wd:Q134808 wd:Q28051899 } ?item wdt:P31 ?vv. ?item wdt:P1924 ?v. } OPTIONAL { VALUES ?type { wd:Q3560939 wd:Q96695067 wd:Q96841548 wd:Q578537 wd:Q97153934 wd:Q97153933 wd:Q58623657 wd:Q99518999 } ?item wdt:P31 ?type } OPTIONAL { ?item wdt:P1343 ?type } { SELECT ?item (GROUP_CONCAT(DISTINCT(?trialLabel); separator=", ") AS ?trialLabels) WHERE { ?item wdt:P1343 ?src. ?src wdt:P6099 ?trial. ?trial rdfs:label ?trialLabel. FILTER( LANG(?trialLabel)="en" ) } GROUP BY ?item } SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . ?item rdfs:label ?itemLabel . ?type rdfs:label ?typeLabel . } } GROUP BY ?item
Map of organisations/companies developing/manufacturing a vaccine in trials
editThe following query uses these:
- Items: COVID-19 vaccine (Q87719492) , COVID-19 (Q84263196) , SARS-CoV-2 (Q82069695) , vaccine (Q134808) , vaccine candidate (Q28051899) , inactivated vaccine (Q3560939) , Q96695067, adenovirus-based vaccine (Q96841548) , DNA vaccine (Q578537) , RNA vaccine (Q97153934) , protein subunit vaccine (Q97153933) , virus-like particle vaccine (Q58623657) , replicating viral vector vaccine (Q99518999)
- Properties: instance of (P31) , vaccine for (P1924) , manufacturer (P176) , developer (P178) , headquarters location (P159) , coordinate location (P625)
Features: map (Q24515275)
#defaultView:Map
SELECT DISTINCT ?item ?itemLabel ?org ?orgLabel ?loc
WHERE
{
{ ?item wdt:P31 wd:Q87719492 } UNION {
VALUES ?v { wd:Q84263196 wd:Q82069695 }
VALUES ?vv { wd:Q134808 wd:Q28051899 }
?item wdt:P31 ?vv.
?item wdt:P1924 ?v.
}
OPTIONAL
{
VALUES ?type { wd:Q3560939 wd:Q96695067 wd:Q96841548 wd:Q578537 wd:Q97153934 wd:Q97153933 wd:Q58623657 wd:Q99518999 }
?item wdt:P31 ?type
}
OPTIONAL {
VALUES ?p { wdt:P176 wdt:P178 }
?item ?p ?org.
OPTIONAL { ?org wdt:P159 [ wdt:P625 ?hloc ]. }
OPTIONAL { ?org wdt:P625 ?cloc. }
BIND (IF (BOUND(?hloc), ?hloc, ?cloc) AS ?loc)
?org rdfs:label ?orgLabel. FILTER( LANG(?orgLabel)="en" )
}
?item rdfs:label ?itemLabel. FILTER( LANG(?itemLabel)="en" )
}
Test kits
editThe following query uses these:
- Items: COVID-19 test (Q86901049)
- Properties: instance of (P31) , manufacturer (P176) , uses (P2283)
SELECT DISTINCT ?item ?itemLabel ?manuLabel ?usesLabel { ?item wdt:P31 wd:Q86901049. ?item wdt:P176 ?manu. OPTIONAL { ?item wdt:P2283 ?uses. } SERVICE wikibase:label { bd:serviceParam wikibase:language "en" } . }
Economic impacts
editBankrupted businesses
editThe following query uses these:
- Items: organization (Q43229) , bankruptcy (Q152074) , economic impact of the COVID-19 pandemic (Q96175652)
- Properties: instance of (P31) , subclass of (P279) , country (P17) , inception (P571) , industry (P452) , parent organization (P749) , has subsidiary (P355) , significant event (P793) , point in time (P585) , has cause (P828)
SELECT ?organization ?organizationLabel ?bankruptcyDate ?countryLabel ?inception (GROUP_CONCAT(DISTINCT ?industryLabel;separator=", ") AS ?industries) (GROUP_CONCAT(DISTINCT ?parentLabel;separator=", ") AS ?parents) (GROUP_CONCAT(DISTINCT ?subsiduaryLabel;separator=", ") AS ?subsiduaries) WHERE { ?organization wdt:P31/wdt:P279* wd:Q43229. OPTIONAL { ?organization wdt:P17 ?country }. OPTIONAL { ?organization wdt:P571 ?inception }. OPTIONAL { ?organization wdt:P452 ?industry }. OPTIONAL { ?organization wdt:P749 ?parent }. OPTIONAL { ?organization wdt:P355 ?subsiduary }. ?organization p:P793 ?event. ?event ps:P793 wd:Q152074. OPTIONAL { ?event pq:P585 ?bankruptcyDate }. ?event pq:P828 wd:Q96175652. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". ?organization rdfs:label ?organizationLabel. ?country rdfs:label ?countryLabel. ?industry rdfs:label ?industryLabel. ?parent rdfs:label ?parentLabel. ?subsiduary rdfs:label ?subsiduaryLabel } } GROUP BY ?organization ?organizationLabel ?bankruptcyDate ?countryLabel ?inception ORDER BY DESC(?bankruptcyDate)
Wikidata modelling metadata
editProperty usage
editProperty usage across items associated with SARS-CoV-2, COVID-19 or the COVID-19 pandemic
editThe following query uses these:
- Items: SARS-CoV-2 (Q82069695) , COVID-19 (Q84263196) , COVID-19 pandemic (Q81068910)
SELECT DISTINCT ?property ?propertyLabel ?count WITH { SELECT DISTINCT ?item WHERE { VALUES ?topic { wd:Q82069695 wd:Q84263196 wd:Q81068910 } ?item ?claim ?topic . ?property wikibase:directClaim ?claim. } LIMIT 200000 } AS %items WITH { SELECT DISTINCT ?property (COUNT(*) AS ?count) WHERE { INCLUDE %items. ?item ?p [ ] . ?property a wikibase:Property; wikibase:claim ?p. } GROUP BY ?property LIMIT 100 } AS %results WHERE { INCLUDE %results. SERVICE wikibase:label { bd:serviceParam wikibase:language "en". } } ORDER BY DESC(?count) LIMIT 100
Properties used on COVID-19 items for outbreaks
editThe following query uses these:
- Properties: Wikidata item of this property (P1629) , instance of (P31) , of (P642)
SELECT (SAMPLE(?subjectitem) as ?item) (concat("\u007B\u007BP\u007C",strafter(str(?property),"y/"),"\u007D\u007D") as ?p) ?propertyLabel (COUNT(DISTINCT ?s) as ?ct) ?total (100*?ct/?total AS ?percent) (strafter(str(?ptype),"#") as ?ptype) (SAMPLE(?s) as ?sample) { ?property wikibase:claim ?wdt . ?property wikibase:propertyType ?ptype . OPTIONAL { ?property wdt:P1629 ?subjectitem } ?s ?wdt ?value . ?s p:P31 ?statement. ?statement ps:P31 wd:Q3241045. ?statement pq:P642 wd:Q84263196. FILTER (?s != wd:Q15397819 ) SERVICE wikibase:label { bd:serviceParam wikibase:language "en" } { SELECT (COUNT(DISTINCT ?i) as ?total) { ?i p:P31 ?statement. ?statement ps:P31 wd:Q3241045. ?statement pq:P642 wd:Q84263196. } } } GROUP BY ?property ?propertyLabel ?total ?ptype ORDER BY DESC(?ct) LIMIT 200
Property usage per outbreak item
editThe following query uses these:
- Properties: start time (P580) , location (P276) , country (P17) , distribution map (P1846) , subreddit (P3984) , hashtag (P2572) , instance of (P31) , number of deaths (P1120) , number of cases (P1603) , of (P642)
SELECT DISTINCT ?item ?itemLabel ?beginning ?countryLabel ?locationLabel ?deaths ?cases ?distribution_map ( GROUP_CONCAT ( DISTINCT ?subreddit; separator="; " ) AS ?subreddits ) ( GROUP_CONCAT ( DISTINCT ?hashtag; separator="; " ) AS ?hashtags ) WHERE { ?item p:P31 ?statement. ?statement ps:P31 wd:Q3241045. ?statement pq:P642 wd:Q84263196. OPTIONAL{?item wdt:P580 ?beginning .} OPTIONAL{?item wdt:P276 ?location .} OPTIONAL{?item wdt:P17 ?country .} # Using p instead of wdt to ignore ranking. OPTIONAL{?item p:P1120 [ps:P1120 ?deaths] .} OPTIONAL{?item p:P1603 [ps:P1603 ?cases] .} OPTIONAL{?item wdt:P1846 ?distribution_map .} OPTIONAL{?item wdt:P3984 ?subreddit .} OPTIONAL{?item wdt:P2572 ?hashtag .} # Get only the highest number for these status. FILTER NOT EXISTS { ?item p:P1120 [ps:P1120 ?deaths_] . FILTER (?deaths_ > ?deaths) } FILTER NOT EXISTS { ?item p:P1603 [ps:P1603 ?cases_] . FILTER (?cases_ > ?cases) } SERVICE wikibase:label { #BabelRainbow bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" } } GROUP BY ?item ?itemLabel ?beginning ?countryLabel ?locationLabel ?deaths ?cases ?distribution_map ORDER BY ?item
Outbreak items for countries and their respective countries
editThe following query uses these:
- Properties: country (P17) , instance of (P31) , of (P642)
SELECT ?item ?itemLabel ?country ?countryLabel WHERE { ?item p:P31 ?statement. ?statement ps:P31 wd:Q3241045. ?statement pq:P642 wd:Q84263196. ?item wdt:P17 ?country. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } }
qid property ReplaceWithYourTargetID heuristic deduced
Maintenance queries
editMissing properties
editMissing properties on outbreak items
edit- Items used: disease outbreak (Q3241045) , COVID-19 (Q84263196)
- Properties used: part of (P361) , instance of (P31) , of (P642)
SELECT ?item ?itemLabel ?itemDescription
{
?item p:P31 [ps:P31 wd:Q3241045 ; pq:P642 wd:Q84263196 ] .
MINUS { ?item wdt:P361 [] }
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
- Items used: disease outbreak (Q3241045) , COVID-19 pandemic (Q81068910)
- Properties used: instance of (P31) , part of (P361) , location (P276)
SELECT ?item ?itemLabel ?itemDescription
{
?item wdt:P31 wd:Q3241045 .
?item wdt:P361+ wd:Q81068910 .
MINUS { ?item p:P276 [] }
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
- Items used: disease outbreak (Q3241045) , COVID-19 pandemic (Q81068910)
- Properties used: instance of (P31) , part of (P361) , country (P17)
SELECT ?item ?itemLabel ?itemDescription
{
?item wdt:P31 wd:Q3241045 .
?item wdt:P361+ wd:Q81068910 .
MINUS { ?item p:P17 [] }
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
- Items used: disease outbreak (Q3241045) , COVID-19 pandemic (Q81068910)
- Properties used: instance of (P31) , part of (P361) , start time (P580)
SELECT ?item ?itemLabel ?itemDescription
{
?item wdt:P31 wd:Q3241045 .
?item wdt:P361+ wd:Q81068910 .
MINUS { ?item p:P580 [] }
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
- Items used: disease outbreak (Q3241045) , COVID-19 pandemic (Q81068910)
- Properties used: instance of (P31) , part of (P361) , number of deaths (P1120)
SELECT ?item ?itemLabel ?itemDescription
{
?item wdt:P31 wd:Q3241045 .
?item wdt:P361+ wd:Q81068910 .
MINUS { ?item p:P1120 [] }
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
Articles with a COVID-19 topic in the title but not as main subject
edit- In this section, queries are collected that search for publications with the strings "COVID-19", "COVID-19 pandemic", "SARS-CoV-2" in their title but without a corresponding main subject (P921) statement about COVID-19 pandemic (Q81068910) , COVID-19 (Q84263196) or SARS-CoV-2 (Q82069695) , respectively.
- These queries provide their results in QuickStatements format, so as to facilitate running QuickStatements batches for topic tagging for these terms.
- Notes of caution
- To see whether anyone else is currently working on this, check recent QuickStatements batches or the relevant RecentChangesLinked pages (COVID-19 pandemic / COVID-19 / SARS-COV-2).
- Before sending the query output to QuickStatements, please check whether everything is OK, then uncomment the
?item ?title
line and rerun the query to get the results in QuickStatements format. - SPARQL query results may be affected by server lag.
- When adapting these queries for any other topics, please pay attention not just to the search string but also to
- the
ReplaceWithYourTargetID
and -haswbstatement:P921=
parts (which should both use the same identifier, e.g. Q82069695 for SARS-CoV-2) and of course to- strings and terms that can have different meanings in different circumstances.
- the
COVID-19 pandemic
edit- Properties used: title (P1476)
SELECT
DISTINCT
?item ?title
(REPLACE(STR(?item), ".*Q", "Q") AS ?qid)
("P921" AS ?property)
("Q81068910" AS ?ReplaceWithYourTargetID)
("S887" AS ?heuristic)
("Q69652283" AS ?deduced)
WHERE {
hint:Query hint:optimizer "None".
{ SERVICE wikibase:mwapi {
bd:serviceParam wikibase:api "Search";
wikibase:endpoint "www.wikidata.org";
mwapi:srsearch "\"covid-19\" pandemic haswbstatement:P31=Q13442814 -haswbstatement:P921=Q81068910".
?page_title wikibase:apiOutput mwapi:title.
}
}
BIND(IRI(CONCAT(STR(wd:), ?page_title)) AS ?item)
?item wdt:P1476 ?title.
FILTER CONTAINS(LCASE(?title), "covid-19").
FILTER CONTAINS(LCASE(?title), "pandemic").
}
COVID-19
edit- Properties used: title (P1476)
SELECT
DISTINCT
?item ?title
(REPLACE(STR(?item), ".*Q", "Q") AS ?qid)
("P921" AS ?property)
("Q84263196" AS ?ReplaceWithYourTargetID)
("S887" AS ?heuristic)
("Q69652283" AS ?deduced)
WHERE {
hint:Query hint:optimizer "None".
{ SERVICE wikibase:mwapi {
bd:serviceParam wikibase:api "Search";
wikibase:endpoint "www.wikidata.org";
mwapi:srsearch "\"covid-19\" haswbstatement:P31=Q13442814 -haswbstatement:P921=Q84263196".
?page_title wikibase:apiOutput mwapi:title.
}
}
BIND(IRI(CONCAT(STR(wd:), ?page_title)) AS ?item)
?item wdt:P1476 ?title.
FILTER CONTAINS(LCASE(?title), "covid-19"). # also check for variants, e.g. without the dash and/ or with "2019"
}
SARS-COV-2
edit- Items used: [SARS-CoV: 2. Modeling SARS epidemic (Q79334742)]
- Properties used: title (P1476)
SELECT
DISTINCT
?item ?title
(REPLACE(STR(?item), ".*Q", "Q") AS ?qid)
("P921" AS ?property)
("Q82069695" AS ?ReplaceWithYourTargetID)
("S887" AS ?heuristic)
("Q69652283" AS ?deduced)
WHERE {
hint:Query hint:optimizer "None".
{ SERVICE wikibase:mwapi {
bd:serviceParam wikibase:api "Search";
wikibase:endpoint "www.wikidata.org";
mwapi:srsearch "\"sars-cov-2\" haswbstatement:P31=Q13442814 -haswbstatement:P921=Q82069695". # also check for spelling variants
?page_title wikibase:apiOutput mwapi:title.
}
}
BIND(IRI(CONCAT(STR(wd:), ?page_title)) AS ?item)
?item wdt:P1476 ?title.
FILTER CONTAINS(LCASE(?title), "sars-cov-2"). # also check for spelling variants, e.g. "sars-cov2"
FILTER (?item != wd:Q79334742 ) # Paper about the 2003 epidemic
}
Properties to remove
editProperties to remove from outbreak items
edit- Items used: disease outbreak (Q3241045) , COVID-19 pandemic (Q81068910)
- Properties used: instance of (P31) , part of (P361) , number of injured (P1339)
# another property should be used
SELECT *
{
?item wdt:P31 wd:Q3241045 .
?item wdt:P361+ wd:Q81068910 .
?item p:P1339 ?_injured_statement .
OPTIONAL { ?_injured_statement ps:P1339 ?number_injured }
}
- Items used: disease outbreak (Q3241045) , COVID-19 pandemic (Q81068910)
- Properties used: instance of (P31) , part of (P361) , number of survivors (P1561)
# another property should be used
SELECT *
{
?item wdt:P31 wd:Q3241045 .
?item wdt:P361+ wd:Q81068910 .
?item p:P1561 ?_survivors .
OPTIONAL { ?_survivors ps:P1561 ?number_survivors }
}