Skip to content

SPARQL Queries

Jump to bottom
Guoqian Jiang edited this page Mar 18, 2020 · 13 revisions

Counts on Condition Instances

PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX fhir: <http://hl7.org/fhir/>
select (count(?s) AS ?count) where { 
	?s rdf:type fhir:Condition .
}

Top Condition Instances

PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX fhir: <http://hl7.org/fhir/>
select ?textvalue (count(?textvalue) AS ?count) where { 
	?s rdf:type fhir:Condition .
    ?s fhir:Condition.code ?code .
    ?code fhir:CodeableConcept.coding ?coding .
    ?coding fhir:Coding.code ?codingcode .
    ?codingcode fhir:value ?codingcodevalue  .
    ?coding fhir:Coding.system ?codingsystem .
    ?codingsystem fhir:value ?codingsystemvalue .
    ?code fhir:CodeableConcept.text ?text .
    ?text fhir:value ?textvalue .
    
} group by ?textvalue order by DESC(?count)

	textvalue
	count
1	

infection
	

"10154"^^xsd:integer
2	

disease
	

"6185"^^xsd:integer
3	

influenza
	

"4576"^^xsd:integer
4	

infections
	

"3772"^^xsd:integer
5	

SARS
	

"3402"^^xsd:integer
6	

MERS
	

"3102"^^xsd:integer
7	

diseases
	

"2919"^^xsd:integer
8	

infectious
	

"2825"^^xsd:integer
9	

strains
	

"2001"^^xsd:integer
10	

syndrome
	

"1757"^^xsd:integer
11	

HIV
	

"1663"^^xsd:integer
12	

strain
	

"1437"^^xsd:integer
13	

pneumonia
	

"1344"^^xsd:integer
14	

Influenza
	

"995"^^xsd:integer
15	

cancer
	

"911"^^xsd:integer
16	

Ebola
	

"874"^^xsd:integer
17	

Infection
	

"841"^^xsd:integer
18	

Disease
	

"647"^^xsd:integer
19	

dengue
	

"639"^^xsd:integer
20	

viral infection
	

"636"^^xsd:integer
21	

exposure
	

"633"^^xsd:integer
22	

hepatitis
	

"627"^^xsd:integer
23	

virus infection
	

"622"^^xsd:integer
24	

Infectious
	

"613"^^xsd:integer
25	

H5N1
	

"583"^^xsd:integer
26	

tumor
	

"563"^^xsd:integer
27	

Syndrome
	

"536"^^xsd:integer
28	

viral infections
	

"530"^^xsd:integer
29	

adenovirus
	

"503"^^xsd:integer
30	

severe acute respiratory syndrome
	

"493"^^xsd:integer
31	

Middle East respiratory syndrome
	

"483"^^xsd:integer
32	

Diseases
	

"450"^^xsd:integer
33	

injury
	

"446"^^xsd:integer
34	

respiratory infections
	

"446"^^xsd:integer
35	

pneumoniae
	

"432"^^xsd:integer
36	

H7N9
	

"398"^^xsd:integer
37	

asthma
	

"386"^^xsd:integer
38	

HBV
	

"368"^^xsd:integer
39	

HSV
	

"360"^^xsd:integer
40	

epidemic diarrhea
	

"359"^^xsd:integer
41	

bronchitis
	

"340"^^xsd:integer
42	

Infections
	

"310"^^xsd:integer
43	

rabies
	

"310"^^xsd:integer
44	

encephalitis
	

"305"^^xsd:integer
45	

respiratory disease
	

"303"^^xsd:integer
46	

avian influenza
	

"295"^^xsd:integer
47	

malaria
	

"295"^^xsd:integer
48	

Middle East Respiratory Syndrome
	

"285"^^xsd:integer
49	

ARDS
	

"283"^^xsd:integer
50	

respiratory tract infections
	

"280"^^xsd:integer

Clone this wiki locally
⚡