SQLite support for mimic-iv

[GilbertFan]

Prerequisites

• [X ] Put an X between the brackets on this line if you have done all of the following:
  • Checked the online documentation: https://mimic.mit.edu/
  • Checked that your issue isn't already addressed: https://github.com/MIT-LCP/mimic-code/issues?utf8=%E2%9C%93&q=

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

[tompollard]

@GilbertFan An SQLite import script would be useful. We're pretty stretched in the lab at the moment, but we would be happy to review a pull request.