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 |
Notice
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 heron-admin@kumc.edu 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:
- date shifting, part of our DeIdentificationStrategy
- age searching (#158)
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.
- #2825
- long concept names obscure Timeline data
Outstanding Problems/Defects/Issues
Ticket | Summary | Keywords |
---|---|---|
#2301 | constraining birth-date by date doesn't work - HERON uses sysdate for start_date in demographics | public-web wrong-results training |
#2617 | Saved searches not updated in REDCap projects after Arkansas release | public-web redcap-to-heron |
Comments
No comments.