-
Notifications
You must be signed in to change notification settings - Fork 0
/
Untitled Diagram.drawio
129 lines (129 loc) · 14.1 KB
/
Untitled Diagram.drawio
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
<mxfile host="app.diagrams.net" modified="2024-05-24T18:24:12.823Z" agent="Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36" etag="28s1p6Dn7gxp4wuwskDR" version="24.4.8" type="github">
<diagram id="C5RBs43oDa-KdzZeNtuy" name="Page-1">
<mxGraphModel dx="1707" dy="427" grid="1" gridSize="10" guides="1" tooltips="1" connect="1" arrows="1" fold="1" page="1" pageScale="1" pageWidth="827" pageHeight="1169" math="0" shadow="0">
<root>
<mxCell id="WIyWlLk6GJQsqaUBKTNV-0" />
<mxCell id="WIyWlLk6GJQsqaUBKTNV-1" parent="WIyWlLk6GJQsqaUBKTNV-0" />
<mxCell id="WIyWlLk6GJQsqaUBKTNV-2" value="" style="rounded=0;html=1;jettySize=auto;orthogonalLoop=1;fontSize=11;endArrow=block;endFill=0;endSize=8;strokeWidth=1;shadow=0;labelBackgroundColor=none;edgeStyle=orthogonalEdgeStyle;" parent="WIyWlLk6GJQsqaUBKTNV-1" source="WIyWlLk6GJQsqaUBKTNV-3" target="WIyWlLk6GJQsqaUBKTNV-6" edge="1">
<mxGeometry relative="1" as="geometry" />
</mxCell>
<mxCell id="WIyWlLk6GJQsqaUBKTNV-3" value="(diagnoses_icd.csv)<br>Total Unique Patients in MIMIC-IV: 180640<br>Total Unique Admissions in MIMIC-IV: 430852" style="rounded=1;whiteSpace=wrap;html=1;fontSize=12;glass=0;strokeWidth=1;shadow=0;" parent="WIyWlLk6GJQsqaUBKTNV-1" vertex="1">
<mxGeometry x="-37.5" y="70" width="250" height="40" as="geometry" />
</mxCell>
<mxCell id="WIyWlLk6GJQsqaUBKTNV-6" value="unique patients: 7613<br>unique admissions: 8306<br>10681 record total (multiple seq number)" style="rhombus;whiteSpace=wrap;html=1;shadow=0;fontFamily=Helvetica;fontSize=12;align=center;strokeWidth=1;spacing=6;spacingTop=-4;" parent="WIyWlLk6GJQsqaUBKTNV-1" vertex="1">
<mxGeometry x="-2.5" y="210" width="180" height="180" as="geometry" />
</mxCell>
<mxCell id="WIyWlLk6GJQsqaUBKTNV-7" value="173027 patients excluded<br>422546 admissions excluded" style="rounded=1;whiteSpace=wrap;html=1;fontSize=12;glass=0;strokeWidth=1;shadow=0;" parent="WIyWlLk6GJQsqaUBKTNV-1" vertex="1">
<mxGeometry x="240" y="140" width="160" height="40" as="geometry" />
</mxCell>
<mxCell id="WIyWlLk6GJQsqaUBKTNV-8" value="merge with patients.csv" style="rounded=0;html=1;jettySize=auto;orthogonalLoop=1;fontSize=11;endArrow=block;endFill=0;endSize=8;strokeWidth=1;shadow=0;labelBackgroundColor=none;edgeStyle=orthogonalEdgeStyle;" parent="WIyWlLk6GJQsqaUBKTNV-1" source="WIyWlLk6GJQsqaUBKTNV-10" target="WIyWlLk6GJQsqaUBKTNV-11" edge="1">
<mxGeometry x="-0.2938" y="72" relative="1" as="geometry">
<mxPoint as="offset" />
</mxGeometry>
</mxCell>
<mxCell id="WIyWlLk6GJQsqaUBKTNV-10" value="unique patients: 7613<br>unique admissions: 8306<br>10681 total record" style="rhombus;whiteSpace=wrap;html=1;shadow=0;fontFamily=Helvetica;fontSize=12;align=center;strokeWidth=1;spacing=6;spacingTop=-4;" parent="WIyWlLk6GJQsqaUBKTNV-1" vertex="1">
<mxGeometry x="-6.25" y="470" width="187.5" height="180" as="geometry" />
</mxCell>
<mxCell id="WIyWlLk6GJQsqaUBKTNV-11" value="unique patients: 7613<br style="--tw-border-spacing-x: 0; --tw-border-spacing-y: 0; --tw-translate-x: 0; --tw-translate-y: 0; --tw-rotate: 0; --tw-skew-x: 0; --tw-skew-y: 0; --tw-scale-x: 1; --tw-scale-y: 1; --tw-pan-x: ; --tw-pan-y: ; --tw-pinch-zoom: ; --tw-scroll-snap-strictness: proximity; --tw-gradient-from-position: ; --tw-gradient-via-position: ; --tw-gradient-to-position: ; --tw-ordinal: ; --tw-slashed-zero: ; --tw-numeric-figure: ; --tw-numeric-spacing: ; --tw-numeric-fraction: ; --tw-ring-inset: ; --tw-ring-offset-width: 0px; --tw-ring-offset-color: #fff; --tw-ring-color: rgb(59 130 246 / .5); --tw-ring-offset-shadow: 0 0 #0000; --tw-ring-shadow: 0 0 #0000; --tw-shadow: 0 0 #0000; --tw-shadow-colored: 0 0 #0000; --tw-blur: ; --tw-brightness: ; --tw-contrast: ; --tw-grayscale: ; --tw-hue-rotate: ; --tw-invert: ; --tw-saturate: ; --tw-sepia: ; --tw-drop-shadow: ; --tw-backdrop-blur: ; --tw-backdrop-brightness: ; --tw-backdrop-contrast: ; --tw-backdrop-grayscale: ; --tw-backdrop-hue-rotate: ; --tw-backdrop-invert: ; --tw-backdrop-opacity: ; --tw-backdrop-saturate: ; --tw-backdrop-sepia: ; border-color: var(--border-color);">unique admissions: 8306<br style="--tw-border-spacing-x: 0; --tw-border-spacing-y: 0; --tw-translate-x: 0; --tw-translate-y: 0; --tw-rotate: 0; --tw-skew-x: 0; --tw-skew-y: 0; --tw-scale-x: 1; --tw-scale-y: 1; --tw-pan-x: ; --tw-pan-y: ; --tw-pinch-zoom: ; --tw-scroll-snap-strictness: proximity; --tw-gradient-from-position: ; --tw-gradient-via-position: ; --tw-gradient-to-position: ; --tw-ordinal: ; --tw-slashed-zero: ; --tw-numeric-figure: ; --tw-numeric-spacing: ; --tw-numeric-fraction: ; --tw-ring-inset: ; --tw-ring-offset-width: 0px; --tw-ring-offset-color: #fff; --tw-ring-color: rgb(59 130 246 / .5); --tw-ring-offset-shadow: 0 0 #0000; --tw-ring-shadow: 0 0 #0000; --tw-shadow: 0 0 #0000; --tw-shadow-colored: 0 0 #0000; --tw-blur: ; --tw-brightness: ; --tw-contrast: ; --tw-grayscale: ; --tw-hue-rotate: ; --tw-invert: ; --tw-saturate: ; --tw-sepia: ; --tw-drop-shadow: ; --tw-backdrop-blur: ; --tw-backdrop-brightness: ; --tw-backdrop-contrast: ; --tw-backdrop-grayscale: ; --tw-backdrop-hue-rotate: ; --tw-backdrop-invert: ; --tw-backdrop-opacity: ; --tw-backdrop-saturate: ; --tw-backdrop-sepia: ; border-color: var(--border-color);">10681 total record" style="rounded=1;whiteSpace=wrap;html=1;fontSize=12;glass=0;strokeWidth=1;shadow=0;" parent="WIyWlLk6GJQsqaUBKTNV-1" vertex="1">
<mxGeometry x="26.25" y="770" width="122.5" height="80" as="geometry" />
</mxCell>
<mxCell id="WIyWlLk6GJQsqaUBKTNV-12" value="match the unique (patient, admission) record, no change on unique patients/admission&nbsp;" style="rounded=1;whiteSpace=wrap;html=1;fontSize=12;glass=0;strokeWidth=1;shadow=0;" parent="WIyWlLk6GJQsqaUBKTNV-1" vertex="1">
<mxGeometry x="200" y="400" width="200" height="70" as="geometry" />
</mxCell>
<mxCell id="F-e7LcrMIv3ka9AGYVmj-1" value="(admissions.csv)<br>Total Unique Patients: 180733<br>Total Unique Admissions: 431231" style="rounded=1;whiteSpace=wrap;html=1;" parent="WIyWlLk6GJQsqaUBKTNV-1" vertex="1">
<mxGeometry x="497" y="280" width="210" height="40" as="geometry" />
</mxCell>
<mxCell id="F-e7LcrMIv3ka9AGYVmj-2" value="(icustays.csv)<br>Total Unique Patients: 50920<br>Total Unique Admissions: 66239<br>Total Unique stays: 73181" style="rounded=1;whiteSpace=wrap;html=1;" parent="WIyWlLk6GJQsqaUBKTNV-1" vertex="1">
<mxGeometry x="497" y="170" width="200" height="60" as="geometry" />
</mxCell>
<mxCell id="F-e7LcrMIv3ka9AGYVmj-3" value="(patients.csv)<br>Total Unique Patients: 299712" style="rounded=1;whiteSpace=wrap;html=1;" parent="WIyWlLk6GJQsqaUBKTNV-1" vertex="1">
<mxGeometry x="504" y="390" width="193" height="40" as="geometry" />
</mxCell>
<mxCell id="F-e7LcrMIv3ka9AGYVmj-5" value="" style="endArrow=classic;html=1;rounded=0;" parent="WIyWlLk6GJQsqaUBKTNV-1" edge="1">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<mxPoint x="87" y="390" as="sourcePoint" />
<mxPoint x="87" y="470" as="targetPoint" />
</mxGeometry>
</mxCell>
<mxCell id="F-e7LcrMIv3ka9AGYVmj-6" value="" style="endArrow=classic;html=1;rounded=0;" parent="WIyWlLk6GJQsqaUBKTNV-1" edge="1">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<mxPoint x="90" y="160" as="sourcePoint" />
<mxPoint x="240" y="160" as="targetPoint" />
</mxGeometry>
</mxCell>
<mxCell id="F-e7LcrMIv3ka9AGYVmj-7" value="filter out patients and admission by ICD9/10" style="text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=4;spacingRight=4;overflow=hidden;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;rotatable=0;whiteSpace=wrap;html=1;" parent="WIyWlLk6GJQsqaUBKTNV-1" vertex="1">
<mxGeometry x="110" y="160" width="117.5" height="50" as="geometry" />
</mxCell>
<mxCell id="F-e7LcrMIv3ka9AGYVmj-8" value="" style="endArrow=classic;html=1;rounded=0;" parent="WIyWlLk6GJQsqaUBKTNV-1" edge="1">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<mxPoint x="87.5" y="730" as="sourcePoint" />
<mxPoint x="227.5" y="730" as="targetPoint" />
<Array as="points">
<mxPoint x="117.5" y="730" />
</Array>
</mxGeometry>
</mxCell>
<mxCell id="F-e7LcrMIv3ka9AGYVmj-9" value="" style="endArrow=classic;html=1;rounded=0;entryX=0;entryY=0.5;entryDx=0;entryDy=0;" parent="WIyWlLk6GJQsqaUBKTNV-1" edge="1">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<mxPoint x="87.5" y="440" as="sourcePoint" />
<mxPoint x="201.5" y="440" as="targetPoint" />
</mxGeometry>
</mxCell>
<mxCell id="F-e7LcrMIv3ka9AGYVmj-10" value="merge with admission.csv" style="text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=4;spacingRight=4;overflow=hidden;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;rotatable=0;whiteSpace=wrap;html=1;" parent="WIyWlLk6GJQsqaUBKTNV-1" vertex="1">
<mxGeometry x="87.5" y="400" width="90" height="30" as="geometry" />
</mxCell>
<mxCell id="F-e7LcrMIv3ka9AGYVmj-12" value="match on the unique patient, no change on unique patients, admission" style="rounded=1;whiteSpace=wrap;html=1;" parent="WIyWlLk6GJQsqaUBKTNV-1" vertex="1">
<mxGeometry x="227.5" y="700" width="160" height="60" as="geometry" />
</mxCell>
<mxCell id="F-e7LcrMIv3ka9AGYVmj-13" value="" style="endArrow=classic;html=1;rounded=0;" parent="WIyWlLk6GJQsqaUBKTNV-1" edge="1">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<mxPoint x="87.5" y="850" as="sourcePoint" />
<mxPoint x="88" y="950" as="targetPoint" />
</mxGeometry>
</mxCell>
<mxCell id="F-e7LcrMIv3ka9AGYVmj-15" value="" style="endArrow=classic;html=1;rounded=0;" parent="WIyWlLk6GJQsqaUBKTNV-1" edge="1">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<mxPoint x="87.5" y="910" as="sourcePoint" />
<mxPoint x="250" y="910" as="targetPoint" />
</mxGeometry>
</mxCell>
<mxCell id="F-e7LcrMIv3ka9AGYVmj-16" value="merge with icustays.csv" style="text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=4;spacingRight=4;overflow=hidden;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;rotatable=0;whiteSpace=wrap;html=1;" parent="WIyWlLk6GJQsqaUBKTNV-1" vertex="1">
<mxGeometry x="132.5" y="880" width="80" height="30" as="geometry" />
</mxCell>
<mxCell id="F-e7LcrMIv3ka9AGYVmj-17" value="match on unique (patient, admission) record, no change on unique patient and admission. Add 491 record (by the multiple icustays)" style="rounded=1;whiteSpace=wrap;html=1;" parent="WIyWlLk6GJQsqaUBKTNV-1" vertex="1">
<mxGeometry x="250" y="880" width="170" height="70" as="geometry" />
</mxCell>
<mxCell id="F-e7LcrMIv3ka9AGYVmj-19" value="cohort:<br>7613 patients<br>8306 admissions<br>11172 record" style="ellipse;whiteSpace=wrap;html=1;aspect=fixed;" parent="WIyWlLk6GJQsqaUBKTNV-1" vertex="1">
<mxGeometry x="26.25" y="950" width="120" height="120" as="geometry" />
</mxCell>
<mxCell id="KhMxUd1tZsilPMztDyav-0" value="" style="endArrow=classic;html=1;rounded=0;" edge="1" parent="WIyWlLk6GJQsqaUBKTNV-1" target="KhMxUd1tZsilPMztDyav-1">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<mxPoint x="121.25" y="1060" as="sourcePoint" />
<mxPoint x="181.25" y="1130" as="targetPoint" />
</mxGeometry>
</mxCell>
<mxCell id="KhMxUd1tZsilPMztDyav-1" value="never went to ICU&nbsp;<div>5909 record</div><div>patient: 4706</div><div>admission: 5027</div><div>icu: 0</div>" style="ellipse;whiteSpace=wrap;html=1;aspect=fixed;" vertex="1" parent="WIyWlLk6GJQsqaUBKTNV-1">
<mxGeometry x="170" y="1091.25" width="140" height="140" as="geometry" />
</mxCell>
<mxCell id="KhMxUd1tZsilPMztDyav-2" value="transfer to ICU &lt; 7 days<div>4993 record</div><div>patient: 3124</div><div>admission: 3258</div><div>icu: 3429</div>" style="ellipse;whiteSpace=wrap;html=1;aspect=fixed;" vertex="1" parent="WIyWlLk6GJQsqaUBKTNV-1">
<mxGeometry x="-150" y="1100" width="143.75" height="143.75" as="geometry" />
</mxCell>
<mxCell id="KhMxUd1tZsilPMztDyav-3" value="" style="endArrow=classic;html=1;rounded=0;exitX=0;exitY=1;exitDx=0;exitDy=0;" edge="1" parent="WIyWlLk6GJQsqaUBKTNV-1" source="F-e7LcrMIv3ka9AGYVmj-19" target="KhMxUd1tZsilPMztDyav-2">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<mxPoint x="-50" y="1080" as="sourcePoint" />
<mxPoint y="1030" as="targetPoint" />
</mxGeometry>
</mxCell>
<mxCell id="KhMxUd1tZsilPMztDyav-4" value="" style="endArrow=classic;html=1;rounded=0;exitX=0.5;exitY=1;exitDx=0;exitDy=0;" edge="1" parent="WIyWlLk6GJQsqaUBKTNV-1" source="F-e7LcrMIv3ka9AGYVmj-19" target="KhMxUd1tZsilPMztDyav-5">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<mxPoint x="150" y="1170" as="sourcePoint" />
<mxPoint x="86" y="1140" as="targetPoint" />
</mxGeometry>
</mxCell>
<mxCell id="KhMxUd1tZsilPMztDyav-5" value="Transfer to ICU after 7 days<div>270 record</div><div>patient: 132</div><div>admission: 132</div><div>icu: 163</div>" style="ellipse;whiteSpace=wrap;html=1;aspect=fixed;" vertex="1" parent="WIyWlLk6GJQsqaUBKTNV-1">
<mxGeometry x="20" y="1130" width="140" height="140" as="geometry" />
</mxCell>
</root>
</mxGraphModel>
</diagram>
</mxfile>