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:59abfdeb-7fb1-4b5b-a7c4-4ffdb2ae6704" /> <resource> <Organization> <id value="59abfdeb-7fb1-4b5b-a7c4-4ffdb2ae6704" /> <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="BETH ISRAEL DEACONESS HOSPITAL-MILTON INC" /> </Organization> </resource> </entry> <entry> <fullUrl value="urn:uuid:09924d8f-8b0f-4c5c-bcde-4d585bdce664" /> <resource> <Patient> <id value="09924d8f-8b0f-4c5c-bcde-4d585bdce664" /> <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="Montague" /> <state value="MA" /> <country value="US" /> </valueAddress> </extension> <extension url="http://hl7.org/fhir/StructureDefinition/patient-mothersMaidenName"> <valueString value="Faustina541 Schmidt130" /> </extension> <extension url="http://hl7.org/fhir/us/core/StructureDefinition/us-core-birthsex"> <valueCode value="F" /> </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="Quinton414 Durgan60" /> </valueHumanName> </extension> <extension url="http://standardhealthrecord.org/fhir/StructureDefinition/shr-demographics-SocialSecurityNumber-extension"> <valueString value="999-89-2656" /> </extension> <identifier> <system value="https://github.com/synthetichealth/synthea" /> <value value="36013ea3-54ac-409f-8c83-a4d1d9650aba" /> </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="999892656" /> </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="S99911095" /> </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="X53384955X" /> </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="36013ea3-54ac-409f-8c83-a4d1d9650aba" /> </identifier> <name> <use value="official" /> <family value="Bruen856" /> <given value="Martina874" /> <prefix value="Mrs." /> </name> <name> <use value="maiden" /> <family value="Durgan60" /> <given value="Martina874" /> </name> <telecom> <system value="phone" /> <value value="1-209-539-2720" /> <use value="home" /> </telecom> <gender value="female" /> <birthDate value="1936-01-02" /> <deceasedDateTime value="2005-05-05T18:08:37+07:00" /> <address> <extension url="http://hl7.org/fhir/StructureDefinition/geolocation"> <extension url="latitude"> <valueDecimal value="42.25903777653811" /> </extension> <extension url="longitude"> <valueDecimal value="-71.0850009175801" /> </extension> </extension> <line value="24952 Clinton Mountains" /> <city value="Milton" /> <state value="MA" /> <postalCode value="02186" /> <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="zh" /> <display value="Chinese" /> </coding> </language> </communication> <generalPractitioner> <reference value="urn:uuid:59abfdeb-7fb1-4b5b-a7c4-4ffdb2ae6704" /> </generalPractitioner> </Patient> </resource> </entry> <entry> <fullUrl value="urn:uuid:c8b045df-abd2-4853-8d78-99b9d07c6f1f" /> <resource> <Encounter> <id value="c8b045df-abd2-4853-8d78-99b9d07c6f1f" /> <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:09924d8f-8b0f-4c5c-bcde-4d585bdce664" /> </subject> <period> <start value="2005-05-05T18:08:37+07:00" /> <end value="2005-05-05T18:23:37+07:00" /> </period> <serviceProvider> <reference value="urn:uuid:59abfdeb-7fb1-4b5b-a7c4-4ffdb2ae6704" /> </serviceProvider> </Encounter> </resource> </entry> <entry> <fullUrl value="urn:uuid:de37c253-3052-4d41-8403-0208d8fca3df" /> <resource> <Condition> <id value="de37c253-3052-4d41-8403-0208d8fca3df" /> <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="230690007" /> <display value="Stroke" /> </coding> <text value="Stroke" /> </code> <subject> <reference value="urn:uuid:09924d8f-8b0f-4c5c-bcde-4d585bdce664" /> </subject> <context> <reference value="urn:uuid:c8b045df-abd2-4853-8d78-99b9d07c6f1f" /> </context> <onsetDateTime value="1984-03-15T18:08:37+07:00" /> <assertedDate value="1984-03-15" /> </Condition> </resource> </entry> <entry> <fullUrl value="urn:uuid:c2a4de76-30a3-4c8c-acc7-dd4083f25026" /> <resource> <Condition> <id value="c2a4de76-30a3-4c8c-acc7-dd4083f25026" /> <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:09924d8f-8b0f-4c5c-bcde-4d585bdce664" /> </subject> <context> <reference value="urn:uuid:c8b045df-abd2-4853-8d78-99b9d07c6f1f" /> </context> <onsetDateTime value="1987-05-22T01:52:12+07:00" /> <assertedDate value="1987-05-22" /> </Condition> </resource> </entry> <entry> <fullUrl value="urn:uuid:3cdb880a-dfdb-4cf9-b299-ea4b8e7165a0" /> <resource> <Observation> <id value="3cdb880a-dfdb-4cf9-b299-ea4b8e7165a0" /> <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:09924d8f-8b0f-4c5c-bcde-4d585bdce664" /> </subject> <context> <reference value="urn:uuid:c8b045df-abd2-4853-8d78-99b9d07c6f1f" /> </context> <effectiveDateTime value="2005-05-05T18:08:37+07:00" /> <issued value="2005-05-05T18:08:37+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:d6e56ec7-558a-4f57-8f91-f24a878a4591" /> <resource> <DiagnosticReport> <id value="d6e56ec7-558a-4f57-8f91-f24a878a4591" /> <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:09924d8f-8b0f-4c5c-bcde-4d585bdce664" /> </subject> <context> <reference value="urn:uuid:c8b045df-abd2-4853-8d78-99b9d07c6f1f" /> </context> <effectiveDateTime value="2005-05-05T18:08:37+07:00" /> <issued value="2005-05-05T18:08:37+07:00" /> <result> <reference value="urn:uuid:3cdb880a-dfdb-4cf9-b299-ea4b8e7165a0" /> <display value="Cause of Death [US Standard Certificate of Death]" /> </result> </DiagnosticReport> </resource> </entry> <entry> <resource> <CarePlan> <status value="active" /> <category> <coding> <system value="http://snomed.info/sct" /> <code value="698358001" /> <display value="Angina self management plan" /> </coding> </category> <subject> <reference value="urn:uuid:09924d8f-8b0f-4c5c-bcde-4d585bdce664" /> </subject> <context> <reference value="urn:uuid:c8b045df-abd2-4853-8d78-99b9d07c6f1f" /> </context> <period> <start value="1985-08-10" /> </period> <addresses> <reference value="urn:uuid:de37c253-3052-4d41-8403-0208d8fca3df" /> </addresses> <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> <activity> <detail> <code> <coding> <system value="http://snomed.info/sct" /> <code value="226060000" /> <display value="Stress management" /> </coding> </code> <status value="in-progress" /> </detail> </activity> <activity> <detail> <code> <coding> <system value="http://snomed.info/sct" /> <code value="710081004" /> <display value="Smoking cessation therapy" /> </coding> </code> <status value="in-progress" /> </detail> </activity> <activity> <detail> <code> <coding> <system value="http://snomed.info/sct" /> <code value="226234005" /> <display value="Healthy diet" /> </coding> </code> <status value="in-progress" /> </detail> </activity> </CarePlan> </resource> </entry> <entry> <fullUrl value="urn:uuid:670cffcb-f13a-48b3-936f-855cb6e698c3" /> <resource> <Goal> <id value="670cffcb-f13a-48b3-936f-855cb6e698c3" /> <status value="in-progress" /> <description> <text value="Hemoglobin A1c total in Blood < 7.0" /> </description> <addresses> <reference value="urn:uuid:c2a4de76-30a3-4c8c-acc7-dd4083f25026" /> </addresses> </Goal> </resource> </entry> <entry> <fullUrl value="urn:uuid:f89c5295-56b7-417f-a250-a79dc151d72d" /> <resource> <Goal> <id value="f89c5295-56b7-417f-a250-a79dc151d72d" /> <status value="in-progress" /> <description> <text value="Glucose [Mass/volume] in Blood < 108" /> </description> <addresses> <reference value="urn:uuid:c2a4de76-30a3-4c8c-acc7-dd4083f25026" /> </addresses> </Goal> </resource> </entry> <entry> <fullUrl value="urn:uuid:4a41fc4c-5cea-4bbe-b031-1506c6167b18" /> <resource> <Goal> <id value="4a41fc4c-5cea-4bbe-b031-1506c6167b18" /> <status value="in-progress" /> <description> <text value="Maintain blood pressure below 140/90 mmHg" /> </description> <addresses> <reference value="urn:uuid:c2a4de76-30a3-4c8c-acc7-dd4083f25026" /> </addresses> </Goal> </resource> </entry> <entry> <fullUrl value="urn:uuid:34443e8c-a75e-4e11-bfcb-ffaf765c77c1" /> <resource> <Goal> <id value="34443e8c-a75e-4e11-bfcb-ffaf765c77c1" /> <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:c2a4de76-30a3-4c8c-acc7-dd4083f25026" /> </addresses> </Goal> </resource> </entry> <entry> <fullUrl value="urn:uuid:424e57be-5b50-470b-aa21-25a574b4910e" /> <resource> <Goal> <id value="424e57be-5b50-470b-aa21-25a574b4910e" /> <status value="in-progress" /> <description> <text value="Address patient knowledge deficit on diabetic self-care" /> </description> <addresses> <reference value="urn:uuid:c2a4de76-30a3-4c8c-acc7-dd4083f25026" /> </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:09924d8f-8b0f-4c5c-bcde-4d585bdce664" /> </subject> <context> <reference value="urn:uuid:c8b045df-abd2-4853-8d78-99b9d07c6f1f" /> </context> <period> <start value="1987-05-22" /> </period> <addresses> <reference value="urn:uuid:c2a4de76-30a3-4c8c-acc7-dd4083f25026" /> </addresses> <goal> <reference value="urn:uuid:670cffcb-f13a-48b3-936f-855cb6e698c3" /> </goal> <goal> <reference value="urn:uuid:f89c5295-56b7-417f-a250-a79dc151d72d" /> </goal> <goal> <reference value="urn:uuid:4a41fc4c-5cea-4bbe-b031-1506c6167b18" /> </goal> <goal> <reference value="urn:uuid:34443e8c-a75e-4e11-bfcb-ffaf765c77c1" /> </goal> <goal> <reference value="urn:uuid:424e57be-5b50-470b-aa21-25a574b4910e" /> </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:c6cee805-0bd4-4528-9445-748252451453" /> <resource> <Observation> <id value="c6cee805-0bd4-4528-9445-748252451453" /> <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:09924d8f-8b0f-4c5c-bcde-4d585bdce664" /> </subject> <effectiveDateTime value="2017-09-18T15:07:09+07:00" /> <issued value="2017-09-18T15:07:09+07:00" /> <valueQuantity> <value value="66.77541614063853" /> <unit value="years" /> <system value="http://unitsofmeasure.org/" /> <code value="years" /> </valueQuantity> </Observation> </resource> </entry> <entry> <fullUrl value="urn:uuid:4074dada-bcfb-4945-9016-b919c20cb46a" /> <resource> <Observation> <id value="4074dada-bcfb-4945-9016-b919c20cb46a" /> <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:09924d8f-8b0f-4c5c-bcde-4d585bdce664" /> </subject> <effectiveDateTime value="2017-09-18T15:07:09+07:00" /> <issued value="2017-09-18T15:07:09+07:00" /> <valueQuantity> <value value="23.721923859361482" /> <unit value="years" /> <system value="http://unitsofmeasure.org/" /> <code value="years" /> </valueQuantity> </Observation> </resource> </entry> </Bundle>