forked from MIT-LCP/mimic-code
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathpostgres_load_data_gz.sql
181 lines (124 loc) · 7.24 KB
/
postgres_load_data_gz.sql
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
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
-- -------------------------------------------------------------------------------
--
-- Load data into the MIMIC-III schema
--
-- -------------------------------------------------------------------------------
--------------------------------------------------------
-- File created - Thursday-August-27-2015
--------------------------------------------------------
-- Change to the directory containing the data files
\cd :mimic_data_dir
-- If running scripts individually, you can set the schema where all tables are created as follows:
-- SET search_path TO mimiciii;
-- Restoring the search path to its default value can be accomplished as follows:
-- SET search_path TO "$user",public;
/* Set the mimic_data_dir variable to point to directory containing
all .csv files. If using Docker, this should not be changed here.
Rather, when running the docker container, use the -v option
to have Docker mount a host volume to the container path /mimic_data
as explained in the README file
*/
--------------------------------------------------------
-- Load Data for Table ADMISSIONS
--------------------------------------------------------
\copy ADMISSIONS FROM PROGRAM 'gzip -dc ADMISSIONS.csv.gz' DELIMITER ',' CSV HEADER NULL ''
--------------------------------------------------------
-- Load Data for Table CALLOUT
--------------------------------------------------------
\copy CALLOUT from PROGRAM 'gzip -dc CALLOUT.csv.gz' delimiter ',' csv header NULL ''
--------------------------------------------------------
-- Load Data for Table CAREGIVERS
--------------------------------------------------------
\copy CAREGIVERS from PROGRAM 'gzip -dc CAREGIVERS.csv.gz' delimiter ',' csv header NULL ''
--------------------------------------------------------
-- Load Data for Table CHARTEVENTS
--------------------------------------------------------
\copy CHARTEVENTS from PROGRAM 'gzip -dc CHARTEVENTS.csv.gz' delimiter ',' csv header NULL ''
--------------------------------------------------------
-- Load Data for Table CPTEVENTS
--------------------------------------------------------
\copy CPTEVENTS from PROGRAM 'gzip -dc CPTEVENTS.csv.gz' delimiter ',' csv header NULL ''
--------------------------------------------------------
-- Load Data for Table DATETIMEEVENTS
--------------------------------------------------------
\copy DATETIMEEVENTS from PROGRAM 'gzip -dc DATETIMEEVENTS.csv.gz' delimiter ',' csv header NULL ''
--------------------------------------------------------
-- Load Data for Table DIAGNOSES_ICD
--------------------------------------------------------
\copy DIAGNOSES_ICD from PROGRAM 'gzip -dc DIAGNOSES_ICD.csv.gz' delimiter ',' csv header NULL ''
--------------------------------------------------------
-- Load Data for Table DRGCODES
--------------------------------------------------------
\copy DRGCODES from PROGRAM 'gzip -dc DRGCODES.csv.gz' delimiter ',' csv header NULL ''
--------------------------------------------------------
-- Load Data for Table D_CPT
--------------------------------------------------------
\copy D_CPT from PROGRAM 'gzip -dc D_CPT.csv.gz' delimiter ',' csv header NULL ''
--------------------------------------------------------
-- Load Data for Table D_ICD_DIAGNOSES
--------------------------------------------------------
\copy D_ICD_DIAGNOSES from PROGRAM 'gzip -dc D_ICD_DIAGNOSES.csv.gz' delimiter ',' csv header NULL ''
--------------------------------------------------------
-- Load Data for Table D_ICD_PROCEDURES
--------------------------------------------------------
\copy D_ICD_PROCEDURES from PROGRAM 'gzip -dc D_ICD_PROCEDURES.csv.gz' delimiter ',' csv header NULL ''
--------------------------------------------------------
-- Load Data for Table D_ITEMS
--------------------------------------------------------
\copy D_ITEMS from PROGRAM 'gzip -dc D_ITEMS.csv.gz' delimiter ',' csv header NULL ''
--------------------------------------------------------
-- Load Data for Table D_LABITEMS
--------------------------------------------------------
\copy D_LABITEMS from PROGRAM 'gzip -dc D_LABITEMS.csv.gz' delimiter ',' csv header NULL ''
--------------------------------------------------------
-- Load Data for Table ICUSTAYS
--------------------------------------------------------
\copy ICUSTAYS from PROGRAM 'gzip -dc ICUSTAYS.csv.gz' delimiter ',' csv header NULL ''
--------------------------------------------------------
-- Load Data for Table INPUTEVENTS_CV
--------------------------------------------------------
\copy INPUTEVENTS_CV from PROGRAM 'gzip -dc INPUTEVENTS_CV.csv.gz' delimiter ',' csv header NULL ''
--------------------------------------------------------
-- Load Data for Table INPUTEVENTS_MV
--------------------------------------------------------
\copy INPUTEVENTS_MV from PROGRAM 'gzip -dc INPUTEVENTS_MV.csv.gz' delimiter ',' csv header NULL ''
--------------------------------------------------------
-- Load Data for Table LABEVENTS
--------------------------------------------------------
\copy LABEVENTS from PROGRAM 'gzip -dc LABEVENTS.csv.gz' delimiter ',' csv header NULL ''
--------------------------------------------------------
-- Load Data for Table MICROBIOLOGYEVENTS
--------------------------------------------------------
\copy MICROBIOLOGYEVENTS from PROGRAM 'gzip -dc MICROBIOLOGYEVENTS.csv.gz' delimiter ',' csv header NULL ''
--------------------------------------------------------
-- Load Data for Table NOTEEVENTS
--------------------------------------------------------
\copy NOTEEVENTS from PROGRAM 'gzip -dc NOTEEVENTS.csv.gz' delimiter ',' csv header NULL ''
--------------------------------------------------------
-- Load Data for Table OUTPUTEVENTS
--------------------------------------------------------
\copy OUTPUTEVENTS from PROGRAM 'gzip -dc OUTPUTEVENTS.csv.gz' delimiter ',' csv header NULL ''
--------------------------------------------------------
-- Load Data for Table PATIENTS
--------------------------------------------------------
\copy PATIENTS from PROGRAM 'gzip -dc PATIENTS.csv.gz' delimiter ',' csv header NULL ''
--------------------------------------------------------
-- Load Data for Table PRESCRIPTIONS
--------------------------------------------------------
\copy PRESCRIPTIONS from PROGRAM 'gzip -dc PRESCRIPTIONS.csv.gz' delimiter ',' csv header NULL ''
--------------------------------------------------------
-- Load Data for Table PROCEDUREEVENTS_MV
--------------------------------------------------------
\copy PROCEDUREEVENTS_MV from PROGRAM 'gzip -dc PROCEDUREEVENTS_MV.csv.gz' delimiter ',' csv header NULL ''
--------------------------------------------------------
-- Load Data for Table PROCEDURES_ICD
--------------------------------------------------------
\copy PROCEDURES_ICD from PROGRAM 'gzip -dc PROCEDURES_ICD.csv.gz' delimiter ',' csv header NULL ''
--------------------------------------------------------
-- Load Data for Table SERVICES
--------------------------------------------------------
\copy SERVICES from PROGRAM 'gzip -dc SERVICES.csv.gz' delimiter ',' csv header NULL ''
--------------------------------------------------------
-- Load Data for Table TRANSFERS
--------------------------------------------------------
\copy TRANSFERS from PROGRAM 'gzip -dc TRANSFERS.csv.gz' delimiter ',' csv header NULL ''