MIMIC-IV-3.1 don`t have the derived table?

[VICKY-TU]

I am currently extracting data from the MIMIC-IV 3.1 database on the BigQuery platform. I noticed that my BigQuery project only includes eicu_crd_demo, mimiciii_demo, mimiciv_3_1_hosp, and mimiciv_3_1_icu, however, without mimiciv_3_1_derived. How could I get it?

[AnkushJamthikar]

Hi, did you get the answer to this? I am also looking to get a derived table for MIMIC-IV-3.1. Is there a way or tutorial about how to do this.

[VICKY-TU]

I didn`t find a solution on Bigquery platform, but if the data of mimic-iv 3.1 were download , the derived tables could be generated based on the file of "mimic-code-mian".

[marymlucas]

I am able to recreate the derived tables for MIMIC-IV-3.1 using the SQL scripts in the concepts folder. I did it in BigQuery - just need to make sure that in each script you're changing the path of the source tables from physionet_data.mimiciv to physionet_data.mimiciv_3_1

[VICKY-TU]

Did you change the path of the sourth tables in every command of the derived tables and ran every command one by one? That was a big work.

[marymlucas]

Hi
For the derived tables i need for my project I downloaded all the scripts in concepts and made the change and then ran the scripts in BigQuery. You can use a command line tool like sed (in Linux) to search and replace in all scripts at once so you're not going through them one by one making the change, but I still visually doublecheck each before running.

[VICKY-TU]

Thank you sincerely for your answer!