SPARQL Queries

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
infection	10154
disease	6185
influenza	4576
infections	3772
SARS	3402
MERS	3102
diseases	2919
infectious	2825
strains	2001
syndrome	1757
HIV	1663
strain	1437
pneumonia	1344
Influenza	995
cancer	911
Ebola	874
Infection	841
Disease	647
dengue	639
viral infection	636
exposure	633
hepatitis	627
virus infection	622
Infectious	613
H5N1	583
tumor	563
Syndrome	536
viral infections	530
adenovirus	503
severe acute respiratory syndrome	493
Middle East respiratory syndrome	483
Diseases	450
injury	446
respiratory infections	446
pneumoniae	432
H7N9	398
asthma	386
HBV	368
HSV	360
epidemic diarrhea	359
bronchitis	340
Infections	310
rabies	310
encephalitis	305
respiratory disease	303
avian influenza	295
malaria	295
Middle East Respiratory Syndrome	285
ARDS	283
respiratory tract infections	280