FindIT 1.0

Discover the breadth and depth of data across the network

FindIT, our federated information dictionary tool, can be used to explore the data shared across the Data QUEST network. Data generated in primary care practices via diverse electronic health record systems have been aligned to facilitate research and speed the ability to translate significant research discoveries directly into real world practice settings.

Please browse data categories at the bottom of the page to explore what data are available.


Distribution of Patients by Gender within Data QUEST data
Click the image to learn about the development of FindIT 2.0.
Click the image to learn about the research priorities of Data QUEST’s community practice partners.
Data QUEST currently has data from three organizations and 15 active clinics across two states.
Distribution of Patients by Race within Data QUEST data

Data QUEST includes data from 3 organizations and 15 primary care clinics across Washington and Idaho that together provide more than 185,000 outpatient visits annually.

Browse Data Types

Explore counts of patient lives by different categories of data found in Data QUEST partners' electronic health record systems.

  • Patient Demographics
  • Medications
  • Vital Signs
  • Procedures
  • Immunizations

Browse By Diagnosis

Explore counts of patient lives by different diagnosis categories, driven by ICD-9 Codes.

 
  • Common Conditions (in alphabetical order)
    • Asthma
    • Chronic Obstructive Pulmonary Disease
    • Coronary Artery Disease
    • Degenerative Joint Disease (Arthritis)
    • Depression 
    • Diabetes
    • Hyperlipidemia
    • Hypertension
    • Pregnancy 

Data Dictionary

Explore our data dictionary.

  • Patient Demographics
    • Date of birth
    • Gender
    • Race
    • Ethnicity
  • Patient Addr / Phone
    • Phone type (e.g., home, work)
    • Phone number
    • Status code for whether the patient address / phone record is active or inactive
    • Type of patient address (e.g., home, work) - codes may vary by organization
    • 1st line of address
    • 2nd line of address
    • City
    • State - two character code (e.g. ID, TX, OR)
    • Zip Code
  • Patient Insurance
    • Indicates the priority order of the insurance policy: 1 – Primary 2 – Secondary 3 – Tertiary 4 - Other
    • Insurance name (free text)
    • Date/Time the insurance policy became effective
    • Date the insurance policy was terminated (if applicable)
  • Past Medical History
    • Past Medical History category code (e.g., PMH_Dialysis, PMH_Hysterectomy)
    • Past Medical History description (e.g., Breast Cancer, Hysterctomy)
    • Date/Time of onset
  • Smoking Status
    • Code for smoking status
    • Description of code for smoking status
    • Date/Time smoking status was recorded
  • Family History
    • Family history category code for a small subset of family history
    • Family history value description
    • Indicates the documented family member that has the Fhx data element
    • Date and time that the family history was documented in the electronic health record
  • Problem / Diagnoses
    • Record status 1 = active, 0 and -1 = not active
    • Problem or diagnosis code (e.g. ICD-9)
    • Problem or diagnosis description
    • Date/Time problem was diagnosed
  • CPT codes
    • Encounter or visit ID (allows link to date of the visit and other visit information)
    • CPT code
    • CPT code description
  • Lab Tests
    • Lab test code
    • Lab test description
    • Date/Time the results were recorded
    • Result value, if numeric
    • Unit of Measure for results, if available
    • Code indicating abnormal result - not used universally across all lab tests for all sites (e.g., 0 or 1)
  • Medications
    • NDC code (e.g., 54327099, 00093111101); present for most medications by a mapping algorithm to the text description
    • Medication description (e.g., string text "Flonase" "Lisinopril") - present for all medications
    • Dose Quantity (e.g., 90 tabs, 30 DAYS)
    • Units of measure (e.g., MG, MCG/ML, %)
    • Dose frequency / medication instructions (Sig) (e.g., 1 po daily prn seasonal allergies as directed on the pack)
    • Date/Time the medication was prescribed
    • Dose frequency / medication instructions (Sig) (e.g., 1 po daily prn seasonal allergies as directed on the pack)
    • Quantity (e.g., 100, 15, 90)
    • Dose form (e.g., Gram(s), Strip, Tablet)
    • Route of administration
    • Days supply
  • Procedures
    • Procedure Result category code
    • Procedure description (e.g., Diabetic foot exam, mammogram)
    • Date/Time of Procedure
  • Immunizations
    • Immunization category code (e.g., IMM_PCV, IMM_Flu, IMM_Tdap)
    • Date immunization was given
    • Immunization description of the immunization category code (e.g., PNEUMOVAX, FLU VAX, TDAP)
  • Patient Appts
    • Provider ID of provider scheduled to be seen at the appt
    • Location ID of clinic where appointment was scheduled
    • Date/Time and time of appointment
  • Patient Visit Info
    • Location where the patient was seen (typically the clinic)
    • Provider ID of provider who saw the patient
    • Provider ID of provider who billed to see the patient
    • Date and time of the encounter / visit
    • Type of encounter
  • Referrals
    • Referral category code
    • Referral description
    • Referral date
  • Patient Findings
    • Coded value identifying the finding (e.g., FND_BPS, FND_WTLB)
    • Finding description of coded value (e.g., BPS, weight)
    • Value associated with the finding (e.g., acutal blood pressure value or weight)
    • Unit of measure associated with the finding value (e.g., mm Hg, lbs)
    • Date/Time the finding was recorded