HERON Table Rock Includes ~50 Million Searchable De-Identified Physician Notes
HERON Table Rock Includes ~50 Million Searchable De-Identified Physician Notes:
- The biggest addition this release is de-identified free text physician notes! We have scrubbed the PHI from all of the physician notes (progress notes, ED notes, etc.) These are searchable in the HERON interface under
Visit Notes
- Data is now current through April 2018.
- Thanks to user feedback, additional HCPCs and point of care lab tests are now available in HERON
- Significant work is being done with two new projects:
- GROUSE is a data warehouse with Medicare / Medicaid Claims data for Kansas and 8 surrounding statse.
- SHRINE allows users to run feasibility counts across the Greater Plains Collaborative network. A network of 12 sites.
- If you are interested in learning about one of the data opportunities listed above, please contact
heron-admin@kumc.edu
Tips & Tricks: Searching Free-Text Physician Notes
- Notes are found under Visit Notes
- When you pull a note type into your query, it will prompt you to enter a value. You can choose either "no value" or search "by value."
- Typically you will use contains, but in the drop down you can choose exact, starts with, or ends with.
- If you would like to search by text, enter the text name in the search box. Example, search patients who have diabetes written in the note.
Warning #1:
When searching by names, it cannot distinguish between, "patient has diabetes" and "patient does not have diabetes." It will choose both notes because they contain the word diabetes. However, when you request the data, this will help filter out notes that don't have anything to do with diabetes.
Warning #2:
If you are looking for diabetes, you should pull over the note multiple times and in the search text enter variations of how physicians would write diabetes (i.e. T1D, T2D, diabetes).
Research Scientist Spotlight: Noor Abu-el-rub joined our team in October, 2017 and has done remarkable work improving our de-identification software. Her work with this de-identification software has allowed us to de-identify ~50 million physician notes. These are all loaded into HERON and users may now create queries based off of information in the note text.
Need help with HERON? Join the Frontiers Lunch and Learn which meets the 2nd and 4th Tuesdays of each month from 12:00 - 1:00 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 # UL1TR002366).
HERON Table Rock Contents Summary
Our tour of rivers and lakes expands to include bodies of water within the Greater Plains Collaborative states. This month honors Table Rock Lake in Nebraska.
The HERON repository contains over 2 billion real observations from the hospital, clinics, and research systems:
Observation | Patients | Source | Go-Live | Snapshot | Issues | |
Alerts | 79.8M | 649K | ||||
KUH/O2/Epic | Nov-07 | Apr-18 | ||||
Allergy | 857K | 358K | ||||
KUH/O2/Epic | Nov-07 | Apr-18 | various* | |||
Cancer Cases | 21.7M | 97K | ||||
KUH Cancer Registry | ca 1950s | Apr-18 | labels*?#3927 | |||
Cardiology Labs | 38.4M | 400K | ||||
KUH/O2/Epic | Nov-07 | Jan-18 | ||||
Cystic Fibrosis Registry | 664K | 241 | ||||
CF Registry | Apr-17 | Apr-18 | ||||
Demographics | 36.3M | 2.33M | ||||
KUH Billing (O2 via SMS) | ca 1980s | Apr-18 | various* | |||
UKP Billing | ca. 2000 | Aug-17 | ||||
64.4K | 64.4K | Frontiers participant registry | J-17 | Apr-18 | ||
212.7K | 212.7K | Social Security Death Index | ca. 1962 | Dec-17 | ||
Diagnoses (IDC9, ICD10) | 120M | 1.04M | ||||
KUH/O2/Epic | Nov-07 | Apr-18 | various* | |||
UKP Billing | ca. 2000 | Nov-17 | ||||
University HealthSystem Consortium (UHC) | Q4 2008 | Apr-18 | ||||
History | 85.2M | 667K | ||||
KUH/O2/Epic | Nov-07 | Apr-18 | ||||
Lab Results | 242M | 667K | ||||
KUH/O2/Epic | ca 2003 | Apr-18 | various* | |||
Medications | 570M | 696K | ||||
KUH/O2/Epic (Organized by VA Class) | Nov-07 | Apr-18 | various* | |||
Microbiology | 6.10M | 46.7K | ||||
KUH/O2/Epic | ca 2003 | Apr-18 | various* | |||
Negative | 1.17M | 179K | KUH/O2/Epic | ca 2003 | Apr-18 | |
Positive | 20.9K | 14.7K | KUH/O2/Epic | ca 2003 | Apr-18 | |
National Cardiovascular Data Registry | 2.19M | 18.0K | ||||
NCDR | Jul-09 | Dec-17 | ||||
National Trauma Data Registry | 0.93M | 15.6K | ||||
NTDS | Jan-06 | July-16 | ||||
Nursing Observations | 1.65B | ? | ||||
KUH/O2/Epic | Nov-07 | Apr-18 | various* | |||
Procedure Orders | 154M | 793K | ||||
KUH/O2/Epic | ca 2003 | Apr-18 | various* | |||
Procedures (CPT) | 60.8M | |||||
UKP Billing | ca. 2000 | Jan-18 | #4093, #4100 | |||
REDCap | 2.89M | 65.4K | ||||
REDCap | Jul-17 | Jan-18 | ||||
Reports/Notes? | 175M | 634K | ||||
KUH/O2/Epic | ? | Apr-18 | ||||
Specimens | 137K | 9.7K | ||||
KUMC Biospecimen Repository | ? | Jul-15 | ||||
Visit Details | 237M | 1.23M | ||||
KUH/O2/Epic | Nov-07 | Apr-18 | ||||
?Hospital Quality Metrics | 12.5M | 155K | ||||
University?HealthSystem??Consortium (UHC) | Q4 2008 | Jan-18 | various* | |||
All | 2.8B |
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.
No results
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.