Posts for the month of September 2014

Temporal searching available in HERON Delaware release

Please note: Clear your browser cache if you receive an error when starting the HERON query tool.

Instructions to clear cache for Firefox and Chrome.

HERON Delaware upgrade to i2b2 v1.7.03 introduces the Temporal Query Tool which allows you to narrow your search by a series of events. For example:

  • Define a population
    • create a search for males with hypertension and acute myocardial infarction
  • Define events
    • Event 1 is hypertension
    • Event 2 is acute myocardial infarction
  • Define temporal relationships of the events
    • Event 1 happens before event 2 by greater than 1 day
  • Submit the query.
    • Results include the number of male patients who have had at least 1 acute myocardial infarction diagnosis after a hypertension diagnosis.

HERON issues to note due to recent data clean-up by the O2 team:

  • Deceased per Social Security Master Death File decreased due to the removal of certain Social Security Numbers in the EMR. See #2911 for more details.
  • Nursing data decreased. See #2955 for more details.

To learn more about temporal querying in HERON, join the Frontiers Lunch and Learn which meets the 1st and 3rd Tuesdays of each month from 12:00 - 1:30 PM in room 3001D Student Center. Register in advance if possible but drop-ins are welcome.

Any publication that results from a project utilizing HERON should cite grant support (CTSA Award # UL1TR000001).

HERON Delaware Contents Summary

This month, our tour of rivers and lakes in Kansas honors the Delaware River.

The HERON repository contains approximately 1.6 billion real observations from the hospital, clinics, and research systems:

Observation Patients Source Go-Live Snapshot Issues
Allergy 528K 242K
KUH/O2/Epic Nov 2007 Aug 2014 various*
Cancer Cases 11.1M 74.7K
KUH Cancer Registry 1950s Aug 2014 labels*
Cardiology Labs 21.7M 329K
KUH/O2/Epic Nov 2007 Aug 2014
Demographics 19.7M 2.06M
KUH Billing (O2 via SMS) 1980s Aug 2014 various*
UKP Billing 2000 Aug 2014
297K 29.7K Frontiers participant registry Jun 2009 Aug 2014 #2451
194.1K 194.1K Social Security Death Index 1962 Aug 2014 #2911
Diagnoses (IDC9) 66.2M 774K
KUH/O2/Epic Nov 2007 Aug 2014 various*
UKP Billing 2000 Aug 2014
University HealthSystem Consortium (UHC) Q4 2008 June 2014
History 29.5M 409K
KUH/O2/Epic Nov 2007 Aug 2014
Lab Results 147M 360K
KUH/O2/Epic 2003 Aug 2014 various*
Medications 124M 418K
KUH/O2/Epic (Organized by VA Class) Nov 2007 Aug 2014 various*
Microbiology 3.25M 28.7K
KUH/O2/Epic 2003 (?) Aug 2014 various*
772K 120K Negative 2003 Aug 2014
10K 7.51K Positive 2003 Aug 2014
Nursing Observations 813M ?
KUH/O2/Epic Nov 2007 Aug 2014 various* #2955
Procedure Orders 165M 549K
KUH/O2/Epic 2003 (?) Aug 2014 various*
Procedures (CPT) 13.5M 674K
UKP Billing 2000 Aug 2014 #26
REDCap 1.02M 48.7K
REDCap July 2011 Aug 2014
Reports/Notes 65.5M 396K
KUH/O2/Epic ? Aug 2014
Specimens 120K 8.75K
KUMC Biospecimen Repository ? Aug 2014
Visit Details 65.2M .93M
KUH/O2/Epic Nov 2007 Aug 2014
Hospital Quality Metrics 6.9M 93K
University HealthSystem Consortium (UHC) Q4 2008 June 2014
All 1.6B


Some material in the UMLS Metathesaurus is from copyrighted sources of the respective copyright holders. Users of the UMLS Metathesaurus are solely responsible for compliance with any copyright, patent or trademark restrictions and are referred to the copyright, patent or trademark notices appearing in the original sources, all of which are hereby incorporated by reference.

Misuse of the Limited Access Death Master File, NTIS, U.S. Department of Commerce data is subject to penalties under provisions of 15 CFR § 1110.200.

Beta Disclaimer

We are providing this early access to obtain feedback from you, the research community. While we are actively working on validating the data loaded into the system with hospital and clinic technical staff, there may be problems with our translation of data from our source systems (HospitalEpicSource and ClinicIdxSource) into HERON.

Please email us at if you discover information you believe may be erroneous.

We are actively working on enhancing the types of data included. Stay tuned to our roadmap to track progress toward upcoming releases.

Various Issues Still Apply

Keep in mind the issues noted in the original HERON beta notice, including:

Enhancements and Problems/Defects/Issues Addressed in this Release

Due to in-progress trac access policy issues, this section may be blank for a time.

long concept names obscure Timeline data

Outstanding Problems/Defects/Issues