Alistair Johnson
Alistair Johnson
In the TRANSFERS table (which goes to VISIT_DETAIL) there is a `care_site` which tells you where the patient is moved to. However, there is no field to store the reason...
I was looking through the PRESCRIPTIONS -> DRUG_EXPOSURE ETL, and came across the use of the `extract_value` function here: https://github.com/MIT-LCP/mimic-omop/blob/68e521268137abe2f5f44fd03c104f48aa5b3d2f/etl/StandardizedClinicalDataTables/DRUG_EXPOSURE/etl.sql#L40 The function seems to extract numbers from text - which...
The [visit detail](https://github.com/OHDSI/CommonDataModel/wiki/VISIT_DETAIL) table has some columns: * `admitting_source_concept_id` * `admitting_source_value` * `discharge_to_concept_id` * `discharge_to_source_value` This seems inconsistent for two reasons: 1. "admitting" and "discharge" are different tenses (perhaps it...
The difference between these two tables is subtle: 1. Numeric/categorical (Quantitative) data in MEASUREMENT 2. String (Qualitative) data in OBSERVATION So for example religion/ethnicity are placed in OBSERVATION, while heart...
There is no specimen identifier in MIMIC-III v1.4. However, it would be beneficial to have one so we can populate the SPECIMEN table in OMOP. Currently, the repository has: *...
Seems like the care_site.csv contains a mapping for services and units, though I think it's cleaner to have these two mappings in separate files. Thoughts?
There is some inconsistency in the conversion of some of the output measurements. I copied over code from mimic-code and adapted it the schema: ```sql select meas.visit_detail_id , meas.person_id ,...
As raised in #1529, `DATETIME_DIFF` in PostgreSQL calculates a fractional number, whereas `DATETIME_DIFF` in BigQuery returns a whole number. This results in a subtle divergence of the concepts in the...
### Discussed in https://github.com/MIT-LCP/mimic-code/discussions/1490 Originally posted by **fantamanatee** February 19, 2023 In the [Load MIMIC-IV into a PostgreSQL database tutorial](https://github.com/MIT-LCP/mimic-code/tree/main/mimic-iv/buildmimic/postgres#load-mimic-iv-into-a-postgresql-database), I noticed note events are not included. Since MIMIC IV...
I'm using wfdb 4.1.2, and when I try to run this code it fails with a 404: ```python import wfdb record = wfdb.rdrecord('p1003/p10030753/s40735970/40735970', pn_dir='mimic-iv-ecg') NetFileNotFoundError: 404 Error: Not Found for...