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.

Sign up for GitHub

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

Jump to bottom

Access to SAM_ELT schema in Neptune for EMR data #64

Open
shyamvis opened this issue Sep 10, 2018 · 6 comments
Open

Access to SAM_ELT schema in Neptune for EMR data #64

shyamvis opened this issue Sep 10, 2018 · 6 comments

Comments

@shyamvis
Copy link

No description provided.

@shyamvis shyamvis self-assigned this Sep 10, 2018
@gatechke
Copy link
Collaborator

@shyamvis
I just got the connection to Neptune. I am able to access to SAM_ELT now.

@shyamvis
Copy link
Author

shyamvis commented Sep 19, 2018 via email

@gatechke
Copy link
Collaborator

 Top 10 ICD9 codes by #patients (DX_PERSON_CNT is the #patients, DX_PERSON_PROP is the proportion of total patients)

image

Top 10 ICD10 codes by #patients (same column format)
image

Observation - the rank of top 10 codes are different between ICD9 and ICD10

@gatechke
Copy link
Collaborator

gatechke commented Sep 20, 2018 •
edited
Loading

Histogram - use log scale because the distributions have very long tail

ICD9
image

ICD10
image

@gatechke
Copy link
Collaborator

There are also some records with unknown ICD type

image

@shyamvis
Copy link
Author

Great. I will ask Patrick to investigate the unknown coding system data. We are supposed to get it down to a smaller number.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@gatechke @shyamvis