forked from masijiaqiu/kidney_watch
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathinsertpatient.sql
99 lines (62 loc) · 9.4 KB
/
insertpatient.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
INSERT INTO db_health.Patient (id, pid, first_name, last_name, gender, dob, category, score, egfr, change_rate, cancer, smoking, htn, diabetes, depression, asprin, amitriptyline, metformin, furosemide, cancer_notes, htn_notes)
VALUES (1, "100100100AB", "Heather", "Campbell", "F", "1965-10-08", "AHD", 6, 10, -5, "Yes", "No", "Yes", "No", "Yes", "No", "Yes", "No", "Yes", "Pt reports he is palliative d/t cancer - has been given between 2-12 months", "PMH (Past Medical History): Anemia, cytomegalovirus infeciton, hemorrhoids, +++ lipids, HTN, IgA nephropathy, +ve TB test, skin lesion, hemodialysis, fistula");
INSERT INTO db_health.Patient (id, pid, first_name, last_name, gender, dob, category, score, egfr, change_rate, cancer, smoking, htn, diabetes, depression, asprin, amitriptyline, metformin, furosemide, cancer_notes)
VALUES (2, "100100100AC", "Alexandra", "Lewis", "F", "1961-05-31", "AHD", 4, 10, -1, "Yes", "No", "No", "No", "No", "No", "Yes", "No", "Yes", "Client states 'has back cancer'");
INSERT INTO db_health.Patient (id, pid, first_name, last_name, gender, dob, category, score, egfr, change_rate, cancer, smoking, htn, diabetes, depression, asprin, amitriptyline, metformin, furosemide, htn_notes, diabetes_notes)
VALUES (3, "100100100AD", "Nathan", "Mackenzie", "M", "1964-08-11", "AHD", 7, 12, -1, "No", "No", "Yes", "Yes", "No", "Yes", "No", "Yes", "Yes", "Blood pressure 130.", "PMH (Past Medical History): Anemia, cytomegalovirus infeciton, hemorrhoids, +++ lipids, HTN, IgA nephropathy, +ve TB test, skin lesion, hemodialysis, fistula");
INSERT INTO db_health.Patient (id, pid, first_name, last_name, gender, dob, category, score, egfr, change_rate, cancer, smoking, htn, diabetes, depression, asprin, amitriptyline, metformin, furosemide)
VALUES (4, "100100100AE", "Sebastian", "Jones", "M", "1960-04-20", "AHD", 3, 12, 4, "Yes", "Yes", "No", "No", "Yes", "Yes", "Yes", "No", "No");
INSERT INTO db_health.Patient (id, pid, first_name, last_name, gender, dob, category, score, egfr, change_rate, cancer, smoking, htn, diabetes, depression, asprin, amitriptyline, metformin, furosemide)
VALUES (5, "100100100AF", "Sebastian", "Forsyth", "M", "1962-07-11", "AHD", 1, 19, 2, "No", "No", "Yes", "No", "No", "Yes", "No", "No", "Yes");
INSERT INTO db_health.Patient (id, pid, first_name, last_name, gender, dob, category, score, egfr, change_rate, cancer, smoking, htn, diabetes, depression, asprin, amitriptyline, metformin, furosemide)
VALUES (6, "100100100HA", "Maria", "McDonald", "F", "1965-09-05", "HD", 6, 8, -5, "Yes", "No", "Yes", "Yes", "No", "No", "Yes", "Yes", "Yes");
INSERT INTO db_health.Patient (id, pid, first_name, last_name, gender, dob, category, score, egfr, change_rate, cancer, smoking, htn, diabetes, depression, asprin, amitriptyline, metformin, furosemide)
VALUES (7, "100100100HB", "Kylie", "Tucker", "F", "1961-04-28", "HD", 1, 13, 1, "No", "No", "No", "No", "Yes", "Yes", "Yes", "No", "No");
INSERT INTO db_health.Patient (id, pid, first_name, last_name, gender, dob, category, score, egfr, change_rate, cancer, smoking, htn, diabetes, depression, asprin, amitriptyline, metformin, furosemide)
VALUES (8, "100100100HD", "Ryan", "Knox", "M", "1960-03-18", "HD", 7, 7, -3, "Yes", "Yes", "Yes", "Yes", "No", "No", "Yes", "Yes", "Yes");
INSERT INTO db_health.Patient (id, pid, first_name, last_name, gender, dob, category, score, egfr, change_rate, cancer, smoking, htn, diabetes, depression, asprin, amitriptyline, metformin, furosemide)
VALUES (9, "100100100HE", "Kevin", "Terry", "M", "1962-06-08", "HD", 5, 9, -3, "No", "No", "Yes", "Yes", "No", "Yes", "No", "Yes", "Yes");
INSERT INTO db_health.Patient (id, pid, first_name, last_name, gender, dob, category, score, egfr, change_rate, cancer, smoking, htn, diabetes, depression, asprin, amitriptyline, metformin, furosemide)
VALUES (10, "100100100HC", "Sophie", "James", "F", "1963-07-19", "HD", 1, 12, 0, "No", "No", "Yes", "No", "No", "Yes", "No", "No", "Yes");
INSERT INTO db_health.Patient (id, pid, first_name, last_name, gender, dob, category, score, egfr, change_rate, cancer, smoking, htn, diabetes, depression, asprin, amitriptyline, metformin, furosemide)
VALUES (11, "100100100MA", "Felicity", "Lee", "F", "1961-02-21", "MKCK", 5, 20, -1, "Yes", "No", "No", "No", "Yes", "No", "Yes", "No", "No");
INSERT INTO db_health.Patient (id, pid, first_name, last_name, gender, dob, category, score, egfr, change_rate, cancer, smoking, htn, diabetes, depression, asprin, amitriptyline, metformin, furosemide)
VALUES (12, "100100100MB", "Bernadette", "Piper", "F", "1963-05-14", "MKCK", 4, 18, -2, "No", "No", "Yes", "No", "No", "No", "No", "No", "Yes");
INSERT INTO db_health.Patient (id, pid, first_name, last_name, gender, dob, category, score, egfr, change_rate, cancer, smoking, htn, diabetes, depression, asprin, amitriptyline, metformin, furosemide)
VALUES (13, "100100100MC", "Faith", "Turner", "F", "1965-08-03", "MKCK", 3, 18, 2, "No", "Yes", "Yes", "Yes", "No", "No", "No", "Yes", "Yes");
INSERT INTO db_health.Patient (id, pid, first_name, last_name, gender, dob, category, score, egfr, change_rate, cancer, smoking, htn, diabetes, depression, asprin, amitriptyline, metformin, furosemide, cancer_notes, htn_notes, diabetes_notes)
VALUES (14, "100100100MD", "Boris", "Anderson", "M", "1960-01-12", "MKCK", 6, 16, -1, "Yes", "No", "Yes", "Yes", "No", "No", "Yes", "Yes", "Yes", "Pt reports he is palliative d/t cancer - has been given between 2-12 months", "PMH (Past Medical History): Anemia, cytomegalovirus infeciton, hemorrhoids, +++ lipids, HTN, IgA nephropathy, +ve TB test, skin lesion, hemodialysis, fistula", "Chronic arteriosclerosis for 20 years with diet-controlled type II diabetes.");
INSERT INTO db_health.Patient (id, pid, first_name, last_name, gender, dob, category, score, egfr, change_rate, cancer, smoking, htn, diabetes, depression, asprin, amitriptyline, metformin, furosemide)
VALUES (15, "100100100ME", "Jack", "Coleman", "M", "1962-04-03", "MKCK", 1, 23, 2, "No", "No", "Yes", "No", "No", "Yes", "No", "No", "Yes");
INSERT INTO db_health.Patient (id, pid, first_name, last_name, gender, dob, category, score, egfr, change_rate, cancer, smoking, htn, diabetes, depression, asprin, amitriptyline, metformin, furosemide)
VALUES (16, "100100100PA", "Samantha", "Clark", "F", "1961-03-26", "PD", 6, 22, -1, "Yes", "No", "Yes", "Yes", "No", "No", "Yes", "Yes", "Yes");
INSERT INTO db_health.Patient (id, pid, first_name, last_name, gender, dob, category, score, egfr, change_rate, cancer, smoking, htn, diabetes, depression, asprin, amitriptyline, metformin, furosemide)
VALUES (17, "100100100PB", "Lauren", "Black", "F", "1963-06-16", "PD", 4, 26, -1, "No", "No", "No", "No", "Yes", "Yes", "Yes", "No", "No");
INSERT INTO db_health.Patient (id, pid, first_name, last_name, gender, dob, category, score, egfr, change_rate, cancer, smoking, htn, diabetes, depression, asprin, amitriptyline, metformin, furosemide)
VALUES (18, "100100100PC", "Harry", "Arnold", "M", "1960-02-14", "PD", 4, 27, 10, "Yes", "Yes", "Yes", "Yes", "No", "No", "Yes", "Yes", "Yes");
INSERT INTO db_health.Patient (id, pid, first_name, last_name, gender, dob, category, score, egfr, change_rate, cancer, smoking, htn, diabetes, depression, asprin, amitriptyline, metformin, furosemide)
VALUES (19, "100100100PD", "Evan", "Watson", "M", "1962-05-06", "PD", 5, 21, -2, "No", "No", "Yes", "Yes", "No", "Yes", "No", "Yes", "Yes");
INSERT INTO db_health.Patient (id, pid, first_name, last_name, gender, dob, category, score, egfr, change_rate, cancer, smoking, htn, diabetes, depression, asprin, amitriptyline, metformin, furosemide)
VALUES (20, "100100100PE", "Richard", "Ball", "M", "1964-07-26", "PD", 1, 23, 13, "No", "No", "Yes", "No", "No", "Yes", "No", "No", "Yes");
INSERT INTO db_health.Patient (id, pid, first_name, last_name, gender, dob, category, score, egfr, change_rate, cancer, smoking, htn, diabetes, depression, asprin, amitriptyline, metformin, furosemide)
VALUES (21, "100100100MF", "Jack", "Doe", "M", "1972-04-03", "MKCK", 4, 63, -2, "No", "No", "Yes", "No", "No", "Yes", "No", "No", "Yes");
INSERT INTO db_health.Patient (id, pid, first_name, last_name, gender, dob, category, score, egfr, change_rate, cancer, smoking, htn, diabetes, depression, asprin, amitriptyline, metformin, furosemide)
VALUES (22, "100100100MG", "Jane", "Doe", "F", "1975-04-03", "MKCK", 4, 65, -5, "No", "No", "Yes", "No", "No", "Yes", "No", "No", "Yes");
INSERT INTO db_health.lab_test (id, pid, lab_name, lab_value, test_date)
VALUES (1, "100100100MD", "eGFR", 33, "2017-03-18");
INSERT INTO db_health.lab_test (id, pid, lab_name, lab_value, test_date)
VALUES (2, "100100100MD", "eGFR", 17, "2017-06-18");
INSERT INTO db_health.lab_test (id, pid, lab_name, lab_value, test_date)
VALUES (3, "100100100MD", "eGFR", 16, "2017-11-18");
INSERT INTO db_health.lab_test (id, pid, lab_name, lab_value, test_date)
VALUES (4, "100100100MD", "ACR", 302, "2017-10-08");
INSERT INTO db_health.lab_test (id, pid, lab_name, lab_value, test_date)
VALUES (5, "100100100MD", "ACR", 332, "2017-12-08");
INSERT INTO db_health.lab_test (id, pid, lab_name, lab_value, test_date)
VALUES (6, "100100100MD", "ACR", 341, "2018-02-10");
INSERT INTO db_health.lab_test (id, pid, lab_name, lab_value, test_date)
VALUES (7, "100100100MD", "SrCr", 281, "2017-07-21");
INSERT INTO db_health.lab_test (id, pid, lab_name, lab_value, test_date)
VALUES (8, "100100100MD", "SrCr", 298, "2017-11-26");
INSERT INTO db_health.lab_test (id, pid, lab_name, lab_value, test_date)
VALUES (9, "100100100MD", "SrCr", 328, "2018-03-21");