-
Notifications
You must be signed in to change notification settings - Fork 8
/
load_data.sql
69 lines (31 loc) · 2.18 KB
/
load_data.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
SET search_path TO mimiciv;
\cd /share/fsmresfiles/mimic4/physionet.org/files/mimiciv/1.0/core
\copy ADMISSIONS FROM 'admissions.csv' DELIMITER ',' CSV HEADER NULL ''
\copy PATIENTS FROM 'patients.csv' DELIMITER ',' CSV HEADER NULL ''
\copy TRANSFERS FROM 'transfers.csv' DELIMITER ',' CSV HEADER NULL ''
\cd /share/fsmresfiles/mimic4/physionet.org/files/mimiciv/1.0/icu
\copy D_ITEMS FROM 'd_items.csv' DELIMITER ',' CSV HEADER NULL ''
\copy CHARTEVENTS FROM 'chartevents.csv' DELIMITER ',' CSV HEADER NULL ''
\copy DATETIMEEVENTS FROM 'datetimeevents.csv' DELIMITER ',' CSV HEADER NULL ''
\copy ICUSTAYS FROM 'icustays.csv' DELIMITER ',' CSV HEADER NULL ''
\copy INPUTEVENTS FROM 'inputevents.csv' DELIMITER ',' CSV HEADER NULL ''
\copy OUTPUTEVENTS FROM 'outputevents.csv' DELIMITER ',' CSV HEADER NULL ''
\copy PROCEDUREEVENTS FROM 'procedureevents.csv' DELIMITER ',' CSV HEADER NULL ''
\cd /share/fsmresfiles/mimic4/physionet.org/files/mimiciv/1.0/hosp
\copy D_HCPCS FROM 'd_hcpcs.csv' DELIMITER ',' CSV HEADER NULL ''
\copy D_ICD_DIAGNOSES FROM 'd_icd_diagnoses.csv' DELIMITER ',' CSV HEADER NULL ''
\copy D_ICD_PROCEDURES FROM 'd_icd_procedures.csv' DELIMITER ',' CSV HEADER NULL ''
\copy D_LABITEMS FROM 'd_labitems.csv' DELIMITER ',' CSV HEADER NULL ''
\copy DIAGNOSES_ICD FROM 'diagnoses_icd.csv' DELIMITER ',' CSV HEADER NULL ''
\copy DRGCODES FROM 'drgcodes.csv' DELIMITER ',' CSV HEADER NULL ''
\copy EMAR FROM 'emar.csv' DELIMITER ',' CSV HEADER NULL ''
\copy EMAR_DETAIL FROM 'emar_detail.csv' DELIMITER ',' CSV HEADER NULL ''
\copy HCPCSEVENTS FROM 'hcpcsevents.csv' DELIMITER ',' CSV HEADER NULL ''
\copy LABEVENTS FROM 'labevents.csv' DELIMITER ',' CSV HEADER NULL ''
\copy MICROBIOLOGYEVENTS FROM 'microbiologyevents.csv' DELIMITER ',' CSV HEADER NULL ''
\copy PHARMACY FROM 'pharmacy.csv' DELIMITER ',' CSV HEADER NULL ''
\copy POE FROM 'poe.csv' DELIMITER ',' CSV HEADER NULL ''
\copy POE_DETAIL FROM 'poe_detail.csv' DELIMITER ',' CSV HEADER NULL ''
\copy PRESCRIPTIONS FROM 'prescriptions.csv' DELIMITER ',' CSV HEADER NULL ''
\copy PROCEDURES_ICD FROM 'procedures_icd.csv' DELIMITER ',' CSV HEADER NULL ''
\copy SERVICES FROM 'services.csv' DELIMITER ',' CSV HEADER NULL ''