Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

mimiciii_derived.pivoted_uo was not found when Calculating Sofa concept #1698

Open
1 task done
bettyJin opened this issue Jan 26, 2024 · 0 comments
Open
1 task done

Comments

@bettyJin
Copy link

Prerequisites

  • 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/
    • Similar ISSUE when calculating Sofa Score (mimic-iii/concepts/pivot/pivoted_sofa.sql) and can't find several data. But it does not apply to my situation

Description

I am trying to write an SQL for a modified version of the SOFA score based on mimic-iii/concepts/pivot/pivoted_sofa.sql. However, when I try to run pivoted_sofa.sql (I haven't made any change yet), it reports "Not found: Table physionet-data:mimiciii_derived.pivoted_uo was not found in location US " Error

Since in README for concepts folder, it mentions

You do not need to generate the concepts if you are using BigQuery! They have already been generated for you. If you have access to MIMIC-III on BigQuery, look under physionet-data.mimic_derived.

So I checked the file under the direction of physionet-data.mimic_derived in my BigQuery, to see if I could find the result of mimic-iii/concepts/pivot/pivoted_uo.sql. As folder columns show at the left of the image, pivoted_uo is missing. I can see other files (i.e. pivoted_gcs) and am able to access them through SQL.

Any idea why only mimiciii_derived.pivoted_uo is missing?

Screen Shot 2024-01-26 at 3 05 32 PM
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant