MIT-LCP / MIT-LCP/mimic-code

SQLite support for mimic-iv

Open
#1,052 1 comment 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

mimic-iv
Dominant language
Jupyter Notebook
Stars
3.4k
Forks
1.7k
PR merge metrics
No merged PRs in 30d

Description

Prerequisites
Description

Is there a way to import mimic-iv data to SQLite? Just like for mimic-iii? It is much quicker than Postgres SQL.

I have tried to reuse the SQLite code for mimic-iii, but it gives me an error. The reason I think is not all tables have ROW_ID now. Is it possible to have a script for SQLite?

Another question I have is the download version of mimic-iv (https://physionet.org/content/mimiciv/1.0/) seems to have no ED/CXR/NOTE tables available. Just wondering when this can be put online for download?

Thanks

Labels
  • mimic-iv

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start by comparing the existing MIMIC-III SQLite code with the MIMIC-IV schema, focusing on the reported ROW_ID difference. Check the linked PhysioNet MIMIC-IV download for the ED, CXR, and NOTE tables. Done would require a defined SQLite import path for MIMIC-IV and a clear answer about the requested tables.

Written by the indexing model from the issue text.

Assessment

Tech stack
sqlite
Domain
databases
Issue type
Feature
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.