FQL is a query language that allows you to retrieve, filter and project data from any data source containing FHIR Resources. It brings the power of three existing languages together: SQL, JSON and FhirPath. It allows you to create tables and is useful for gaining insight and perform quality control.
<Bundle xmlns="http://hl7.org/fhir"> <type value="collection" /> <entry> <fullUrl value="urn:uuid:b91088cc-ffb5-4675-8d51-863d24df5aaa" /> <resource> <Organization> <id value="b91088cc-ffb5-4675-8d51-863d24df5aaa" /> <meta> <profile value="http://standardhealthrecord.org/fhir/StructureDefinition/shr-actor-Organization" /> </meta> <type> <coding> <system value="http://hl7.org/fhir/ValueSet/organization-type" /> <code value="prov" /> <display value="Healthcare Provider" /> </coding> <text value="Healthcare Provider" /> </type> <name value="WINCHESTER IMAGING CTR" /> </Organization> </resource> </entry> <entry> <fullUrl value="urn:uuid:8d7c54a8-bb4a-4cb5-8c94-56206069d0dc" /> <resource> <Patient> <id value="8d7c54a8-bb4a-4cb5-8c94-56206069d0dc" /> <meta> <profile value="http://standardhealthrecord.org/fhir/StructureDefinition/shr-demographics-PersonOfRecord" /> </meta> <text> <status value="generated" /> <div xmlns="http://www.w3.org/1999/xhtml">Generated by <a href="https://github.com/synthetichealth/synthea">Synthea</a>. Version identifier: 164fab4d501414d13774483b93584d802c0010ee</div> </text> <extension url="http://hl7.org/fhir/us/core/StructureDefinition/us-core-race"> <valueCodeableConcept> <coding> <system value="http://hl7.org/fhir/v3/Race" /> <code value="2028-9" /> <display value="Asian" /> </coding> <text value="race" /> </valueCodeableConcept> </extension> <extension url="http://hl7.org/fhir/us/core/StructureDefinition/us-core-ethnicity"> <valueCodeableConcept> <coding> <system value="http://hl7.org/fhir/v3/Ethnicity" /> <code value="2186-5" /> <display value="Nonhispanic" /> </coding> <text value="ethnicity" /> </valueCodeableConcept> </extension> <extension url="http://hl7.org/fhir/StructureDefinition/birthPlace"> <valueAddress> <city value="Springfield" /> <state value="MA" /> <country value="US" /> </valueAddress> </extension> <extension url="http://hl7.org/fhir/StructureDefinition/patient-mothersMaidenName"> <valueString value="Susann982 Kohler952" /> </extension> <extension url="http://hl7.org/fhir/us/core/StructureDefinition/us-core-birthsex"> <valueCode value="M" /> </extension> <extension url="http://hl7.org/fhir/StructureDefinition/patient-interpreterRequired"> <valueBoolean value="false" /> </extension> <extension url="http://standardhealthrecord.org/fhir/StructureDefinition/shr-actor-FictionalPerson-extension"> <valueBoolean value="true" /> </extension> <extension url="http://standardhealthrecord.org/fhir/StructureDefinition/shr-demographics-FathersName-extension"> <valueHumanName> <text value="Rodrick407 Runolfsson316" /> </valueHumanName> </extension> <extension url="http://standardhealthrecord.org/fhir/StructureDefinition/shr-demographics-SocialSecurityNumber-extension"> <valueString value="999-10-1854" /> </extension> <identifier> <system value="https://github.com/synthetichealth/synthea" /> <value value="32591784-8346-4c5d-9e94-33f1c1232281" /> </identifier> <identifier> <type> <coding> <system value="http://hl7.org/fhir/identifier-type" /> <code value="SB" /> </coding> </type> <system value="http://hl7.org/fhir/sid/us-ssn" /> <value value="999101854" /> </identifier> <identifier> <type> <coding> <system value="http://hl7.org/fhir/v2/0203" /> <code value="DL" /> </coding> </type> <system value="urn:oid:2.16.840.1.113883.4.3.25" /> <value value="S99954844" /> </identifier> <identifier> <type> <coding> <system value="http://hl7.org/fhir/v2/0203" /> <code value="PPN" /> </coding> </type> <system value="http://standardhealthrecord.org/fhir/StructureDefinition/passportNumber" /> <value value="X99402900X" /> </identifier> <identifier> <type> <coding> <system value="http://hl7.org/fhir/v2/0203" /> <code value="MR" /> </coding> </type> <system value="http://hospital.smarthealthit.org" /> <value value="32591784-8346-4c5d-9e94-33f1c1232281" /> </identifier> <name> <use value="official" /> <family value="Runolfsson316" /> <given value="Barry310" /> <prefix value="Mr." /> </name> <telecom> <system value="phone" /> <value value="357.751.4434 x212" /> <use value="home" /> </telecom> <gender value="male" /> <birthDate value="1924-01-02" /> <deceasedDateTime value="2002-05-08T17:18:49+07:00" /> <address> <extension url="http://hl7.org/fhir/StructureDefinition/geolocation"> <extension url="latitude"> <valueDecimal value="42.496516386672646" /> </extension> <extension url="longitude"> <valueDecimal value="-71.16648855345" /> </extension> </extension> <line value="961 Tyrique Locks" /> <city value="Woburn" /> <state value="MA" /> <postalCode value="01888" /> <country value="US" /> </address> <maritalStatus> <coding> <system value="http://hl7.org/fhir/v3/MaritalStatus" /> <code value="M" /> </coding> <text value="M" /> </maritalStatus> <multipleBirthBoolean value="false" /> <communication> <language> <coding> <system value="http://hl7.org/fhir/ValueSet/languages" /> <code value="en-US" /> <display value="English (United States)" /> </coding> </language> </communication> <generalPractitioner> <reference value="urn:uuid:b91088cc-ffb5-4675-8d51-863d24df5aaa" /> </generalPractitioner> </Patient> </resource> </entry> <entry> <fullUrl value="urn:uuid:4b6c85ea-6e2f-456b-bc83-4056fcbecf11" /> <resource> <Encounter> <id value="4b6c85ea-6e2f-456b-bc83-4056fcbecf11" /> <meta> <profile value="http://standardhealthrecord.org/fhir/StructureDefinition/shr-encounter-Encounter" /> </meta> <status value="finished" /> <class> <code value="ambulatory" /> </class> <type> <coding> <system value="http://snomed.info/sct" /> <code value="308646001" /> </coding> <text value="Death Certification" /> </type> <subject> <reference value="urn:uuid:8d7c54a8-bb4a-4cb5-8c94-56206069d0dc" /> </subject> <period> <start value="2002-05-08T17:18:49+07:00" /> <end value="2002-05-08T17:33:49+07:00" /> </period> <serviceProvider> <reference value="urn:uuid:b91088cc-ffb5-4675-8d51-863d24df5aaa" /> </serviceProvider> </Encounter> </resource> </entry> <entry> <fullUrl value="urn:uuid:d7284e6f-5635-4fb1-a20a-a2cb5aaa7807" /> <resource> <Condition> <id value="d7284e6f-5635-4fb1-a20a-a2cb5aaa7807" /> <meta> <profile value="http://standardhealthrecord.org/fhir/StructureDefinition/shr-problem-Problem" /> </meta> <clinicalStatus value="active" /> <verificationStatus value="confirmed" /> <code> <coding> <system value="http://snomed.info/sct" /> <code value="38341003" /> <display value="Hypertension" /> </coding> <text value="Hypertension" /> </code> <subject> <reference value="urn:uuid:8d7c54a8-bb4a-4cb5-8c94-56206069d0dc" /> </subject> <context> <reference value="urn:uuid:4b6c85ea-6e2f-456b-bc83-4056fcbecf11" /> </context> <onsetDateTime value="1942-07-31T09:33:23+07:00" /> <assertedDate value="1942-07-31" /> </Condition> </resource> </entry> <entry> <fullUrl value="urn:uuid:d1e99d7c-4a4c-438a-af56-33d0c9a60181" /> <resource> <Condition> <id value="d1e99d7c-4a4c-438a-af56-33d0c9a60181" /> <meta> <profile value="http://standardhealthrecord.org/fhir/StructureDefinition/shr-problem-Problem" /> </meta> <clinicalStatus value="active" /> <verificationStatus value="confirmed" /> <code> <coding> <system value="http://snomed.info/sct" /> <code value="15777000" /> <display value="Prediabetes" /> </coding> <text value="Prediabetes" /> </code> <subject> <reference value="urn:uuid:8d7c54a8-bb4a-4cb5-8c94-56206069d0dc" /> </subject> <context> <reference value="urn:uuid:4b6c85ea-6e2f-456b-bc83-4056fcbecf11" /> </context> <onsetDateTime value="1978-02-06T11:24:56+07:00" /> <assertedDate value="1978-02-06" /> </Condition> </resource> </entry> <entry> <fullUrl value="urn:uuid:bf73f493-de33-4624-9e9f-b7deca918428" /> <resource> <Condition> <id value="bf73f493-de33-4624-9e9f-b7deca918428" /> <meta> <profile value="http://standardhealthrecord.org/fhir/StructureDefinition/shr-problem-Problem" /> </meta> <clinicalStatus value="active" /> <verificationStatus value="confirmed" /> <code> <coding> <system value="http://snomed.info/sct" /> <code value="64859006" /> <display value="Osteoporosis (disorder)" /> </coding> <text value="Osteoporosis (disorder)" /> </code> <subject> <reference value="urn:uuid:8d7c54a8-bb4a-4cb5-8c94-56206069d0dc" /> </subject> <context> <reference value="urn:uuid:4b6c85ea-6e2f-456b-bc83-4056fcbecf11" /> </context> <onsetDateTime value="1994-09-02T19:40:06+07:00" /> <assertedDate value="1994-09-02" /> </Condition> </resource> </entry> <entry> <fullUrl value="urn:uuid:cb490f9c-a21c-4973-9eb9-f66019ed143b" /> <resource> <Observation> <id value="cb490f9c-a21c-4973-9eb9-f66019ed143b" /> <meta> <profile value="http://standardhealthrecord.org/fhir/StructureDefinition/shr-observation-Observation" /> </meta> <status value="final" /> <category> <coding> <system value="http://hl7.org/fhir/observation-category" /> </coding> </category> <code> <coding> <system value="http://loinc.org" /> <code value="69453-9" /> <display value="Cause of Death [US Standard Certificate of Death]" /> </coding> <text value="Cause of Death [US Standard Certificate of Death]" /> </code> <subject> <reference value="urn:uuid:8d7c54a8-bb4a-4cb5-8c94-56206069d0dc" /> </subject> <context> <reference value="urn:uuid:4b6c85ea-6e2f-456b-bc83-4056fcbecf11" /> </context> <effectiveDateTime value="2002-05-08T17:18:49+07:00" /> <issued value="2002-05-08T17:18:49+07:00" /> <valueCodeableConcept> <coding> <system value="http://snomed.info/sct" /> <code value="9855000" /> <display value="Natural death with unknown cause" /> </coding> <text value="Natural death with unknown cause" /> </valueCodeableConcept> </Observation> </resource> </entry> <entry> <fullUrl value="urn:uuid:746e8d39-7d25-4a62-afa3-8726500ce033" /> <resource> <DiagnosticReport> <id value="746e8d39-7d25-4a62-afa3-8726500ce033" /> <meta> <profile value="http://standardhealthrecord.org/fhir/StructureDefinition/shr-observation-Panel" /> </meta> <status value="final" /> <code> <coding> <system value="http://loinc.org" /> <code value="69409-1" /> <display value="U.S. standard certificate of death - 2003 revision" /> </coding> </code> <subject> <reference value="urn:uuid:8d7c54a8-bb4a-4cb5-8c94-56206069d0dc" /> </subject> <context> <reference value="urn:uuid:4b6c85ea-6e2f-456b-bc83-4056fcbecf11" /> </context> <effectiveDateTime value="2002-05-08T17:18:49+07:00" /> <issued value="2002-05-08T17:18:49+07:00" /> <result> <reference value="urn:uuid:cb490f9c-a21c-4973-9eb9-f66019ed143b" /> <display value="Cause of Death [US Standard Certificate of Death]" /> </result> </DiagnosticReport> </resource> </entry> <entry> <fullUrl value="urn:uuid:e3de86e4-5e05-49a9-82fb-bb761ee14063" /> <resource> <Goal> <id value="e3de86e4-5e05-49a9-82fb-bb761ee14063" /> <status value="in-progress" /> <description> <text value="Hemoglobin A1c total in Blood < 7.0" /> </description> <addresses> <reference value="urn:uuid:d1e99d7c-4a4c-438a-af56-33d0c9a60181" /> </addresses> </Goal> </resource> </entry> <entry> <fullUrl value="urn:uuid:cac0160e-8e12-4a68-ab65-7d494fc6e556" /> <resource> <Goal> <id value="cac0160e-8e12-4a68-ab65-7d494fc6e556" /> <status value="in-progress" /> <description> <text value="Glucose [Mass/volume] in Blood < 108" /> </description> <addresses> <reference value="urn:uuid:d1e99d7c-4a4c-438a-af56-33d0c9a60181" /> </addresses> </Goal> </resource> </entry> <entry> <fullUrl value="urn:uuid:633b5422-cd30-4350-9201-67f1725468d1" /> <resource> <Goal> <id value="633b5422-cd30-4350-9201-67f1725468d1" /> <status value="in-progress" /> <description> <text value="Maintain blood pressure below 140/90 mmHg" /> </description> <addresses> <reference value="urn:uuid:d1e99d7c-4a4c-438a-af56-33d0c9a60181" /> </addresses> </Goal> </resource> </entry> <entry> <fullUrl value="urn:uuid:7b51f978-60b3-4bec-a9d9-e930afc91410" /> <resource> <Goal> <id value="7b51f978-60b3-4bec-a9d9-e930afc91410" /> <status value="in-progress" /> <description> <text value="Improve and maintenance of optimal foot health: aim at early detection of peripheral vascular problems and neuropathy presumed due to diabetes; and prevention of diabetic foot ulcer, gangrene" /> </description> <addresses> <reference value="urn:uuid:d1e99d7c-4a4c-438a-af56-33d0c9a60181" /> </addresses> </Goal> </resource> </entry> <entry> <fullUrl value="urn:uuid:d718ac4c-d155-4578-a36e-c095413cf489" /> <resource> <Goal> <id value="d718ac4c-d155-4578-a36e-c095413cf489" /> <status value="in-progress" /> <description> <text value="Address patient knowledge deficit on diabetic self-care" /> </description> <addresses> <reference value="urn:uuid:d1e99d7c-4a4c-438a-af56-33d0c9a60181" /> </addresses> </Goal> </resource> </entry> <entry> <resource> <CarePlan> <status value="active" /> <category> <coding> <system value="http://snomed.info/sct" /> <code value="698360004" /> <display value="Diabetes self management plan" /> </coding> </category> <subject> <reference value="urn:uuid:8d7c54a8-bb4a-4cb5-8c94-56206069d0dc" /> </subject> <context> <reference value="urn:uuid:4b6c85ea-6e2f-456b-bc83-4056fcbecf11" /> </context> <period> <start value="1978-02-06" /> </period> <addresses> <reference value="urn:uuid:d1e99d7c-4a4c-438a-af56-33d0c9a60181" /> </addresses> <goal> <reference value="urn:uuid:e3de86e4-5e05-49a9-82fb-bb761ee14063" /> </goal> <goal> <reference value="urn:uuid:cac0160e-8e12-4a68-ab65-7d494fc6e556" /> </goal> <goal> <reference value="urn:uuid:633b5422-cd30-4350-9201-67f1725468d1" /> </goal> <goal> <reference value="urn:uuid:7b51f978-60b3-4bec-a9d9-e930afc91410" /> </goal> <goal> <reference value="urn:uuid:d718ac4c-d155-4578-a36e-c095413cf489" /> </goal> <activity> <detail> <code> <coding> <system value="http://snomed.info/sct" /> <code value="160670007" /> <display value="Diabetic diet" /> </coding> </code> <status value="in-progress" /> </detail> </activity> <activity> <detail> <code> <coding> <system value="http://snomed.info/sct" /> <code value="229065009" /> <display value="Exercise therapy" /> </coding> </code> <status value="in-progress" /> </detail> </activity> </CarePlan> </resource> </entry> <entry> <fullUrl value="urn:uuid:bba5692a-1ff4-43b2-8051-443030f29367" /> <resource> <Observation> <id value="bba5692a-1ff4-43b2-8051-443030f29367" /> <meta> <profile value="http://standardhealthrecord.org/fhir/StructureDefinition/shr-observation-Observation" /> </meta> <status value="final" /> <category> <coding> <system value="http://hl7.org/fhir/observation-category" /> <code value="survey" /> </coding> </category> <code> <coding> <system value="http://snomed.info/sct" /> <code value="273724008" /> <display value="Quality adjusted life years" /> </coding> <text value="Quality adjusted life years" /> </code> <subject> <reference value="urn:uuid:8d7c54a8-bb4a-4cb5-8c94-56206069d0dc" /> </subject> <effectiveDateTime value="2017-09-18T15:07:09+07:00" /> <issued value="2017-09-18T15:07:09+07:00" /> <valueQuantity> <value value="77.01230325278127" /> <unit value="years" /> <system value="http://unitsofmeasure.org/" /> <code value="years" /> </valueQuantity> </Observation> </resource> </entry> <entry> <fullUrl value="urn:uuid:a3469934-467c-4324-b526-bba9a4b9d209" /> <resource> <Observation> <id value="a3469934-467c-4324-b526-bba9a4b9d209" /> <meta> <profile value="http://standardhealthrecord.org/fhir/StructureDefinition/shr-observation-Observation" /> </meta> <status value="final" /> <category> <coding> <system value="http://hl7.org/fhir/observation-category" /> <code value="survey" /> </coding> </category> <code> <coding> <system value="http://snomed.info/sct" /> <code value="273421001" /> <display value="Disability rating scale" /> </coding> <text value="Disability rating scale" /> </code> <subject> <reference value="urn:uuid:8d7c54a8-bb4a-4cb5-8c94-56206069d0dc" /> </subject> <effectiveDateTime value="2017-09-18T15:07:09+07:00" /> <issued value="2017-09-18T15:07:09+07:00" /> <valueQuantity> <value value="16.451616747218743" /> <unit value="years" /> <system value="http://unitsofmeasure.org/" /> <code value="years" /> </valueQuantity> </Observation> </resource> </entry> </Bundle>