query-e74a5b25c59f3a065101302cf8cecf40

rq turtle/ttl

List words

Use at

• https://query.wikidata.org/sparql

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
#defaultView:BubbleChart
#Bubblechart and list of words in titles of articles about Zika. Limited to English titles, first 42 words, some words filtered.
#by Jura1, 7 March 2020

SELECT ?word (COUNT(DISTINCT ?title) as ?count)


WHERE
{

{    SELECT * { 
{  SELECT ?title (REPLACE(CONCAT(REPLACE(REPLACE(REPLACE(str(?title),'[\\.:,\\? %";\\]\\[]',""),"[\\(\\)–“—”]"," "),"’","'"), 
  " Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z")
  ,"[ ]{2,100}"," ") as ?input)
   {  [] wdt:P921 wd:Q202864 ; wdt:P1476 ?title . FILTER(lang(?title)="en") } #  LIMIT 100
} 
{    SELECT ?re ?nv { ?n wdt:P5176 []; wdt:P1181 ?nv . FILTER( ?nv < 43) 
     BIND( CONCAT( "^([^ ]+ ){", str( ?nv - 1 ),"}([^ ]+) .*") as ?re) }
} BIND( REPLACE(?input, ?re, "$2") as ?word) }
}    FILTER ( ?word != "Z" && ?word != "Zika" && ?word != "Corona" 
            && strlen(?word) > 3 
            && ?word != "pandemic" && ?word != "virus" && lcase(?word) != "infection" && ?word != "mortality"
           )               
}
GROUP BY ?word

Query found at

• https://www.wikidata.org/wiki/Wikidata:Request_a_query/Archive/2020/03