Subqueries

13.6. Subqueries#

13.6.1. Using value from a subquery#

SELECT p.*, m.max_stay
FROM  PatientCorePopulatedTable  p
INNER JOIN 
(SELECT PatientID, ROUND(MAX(julianday(AdmissionEndDate)-julianday(AdmissionStartDate))) MAX_STAY
FROM AdmissionsCorePopulatedTable 
GROUP BY PatientID
HAVING MAX_STAY >= 15
) m
ON p.PatientID = m.PatientID
Hide code cell source 
import sqlite3
import pandas as pd

conn = sqlite3.connect('100_patients.db')

sql_statement = """
SELECT p.*, m.max_stay
FROM  PatientCorePopulatedTable  p
INNER JOIN 
(SELECT PatientID, ROUND(MAX(julianday(AdmissionEndDate)-julianday(AdmissionStartDate))) MAX_STAY
FROM AdmissionsCorePopulatedTable 
GROUP BY PatientID
HAVING MAX_STAY >= 15
) m
ON p.PatientID = m.PatientID
"""
df = pd.read_sql_query(sql_statement, conn)
df.style.set_table_attributes('style="font-size: 12px"')
  PatientID PatientGender PatientDateOfBirth PatientRace PatientMaritalStatus PatientLanguage PatientPopulationPercentageBelowPoverty MAX_STAY
0 FB2ABB23-C9D0-4D09-8464-49BF0B982F0F Male 1947-12-28 02:45:40.547 Unknown Married Icelandic 18.080000 17.000000
1 64182B95-EB72-4E2B-BE77-8050B71498CE Male 1952-01-18 19:51:12.917 African American Separated English 13.030000 15.000000
2 DB22A4D9-7E4D-485C-916A-9CD1386507FB Female 1970-07-25 13:04:20.717 Asian Married English 6.670000 17.000000
3 6E70D84D-C75F-477C-BC37-9177C3698C66 Male 1979-01-04 05:45:29.580 White Married English 16.090000 19.000000
4 7FD13988-E58A-4A5C-8680-89AC200950FA Male 1965-07-12 15:41:20.523 White Married Spanish 12.410000 19.000000
5 C60FE675-CA52-4C55-A233-F4B27E94987F Male 1957-10-30 23:26:15.303 Asian Married Spanish 12.800000 16.000000
6 B39DC5AC-E003-4E6A-91B6-FC07625A1285 Female 1935-11-03 21:07:09.040 White Married English 15.310000 18.000000
7 FA157FA5-F488-4884-BF87-E144630D595C Female 1932-11-01 06:19:56.577 White Single English 16.320000 19.000000
8 1A40AF35-C6D4-4D46-B475-A15D84E8A9D5 Male 1949-01-10 15:37:35.543 White Married English 11.250000 20.000000
9 DA6CECFF-DE13-4C4C-919F-64E1A2B76C9D Male 1924-06-27 19:37:58.823 Asian Divorced English 83.750000 17.000000
10 0A9BA3E4-CF3C-49C4-9774-5EEA2EE7D123 Male 1980-04-04 07:59:15.820 White Single Spanish 14.280000 17.000000
11 7C788499-7798-484B-A027-9FCDC4C0DADB Male 1926-08-13 10:22:16.247 White Married English 11.890000 19.000000
12 D8B53AA2-7953-4477-9EA4-68400EBAAC5C Male 1951-06-11 20:11:10.003 African American Unknown English 16.890000 19.000000
13 25B786AF-0F99-478C-9CFA-0EA607E45834 Male 1926-08-20 00:21:38.870 White Married English 93.600000 19.000000
14 F00C64F8-2033-4640-80FE-F1F62CBE26A5 Female 1957-06-04 18:31:01.177 African American Single English 15.720000 18.000000
15 B70E5A76-F2BC-41E4-B037-CD4D9ABA0967 Male 1962-12-15 01:59:01.737 White Single Icelandic 13.100000 19.000000
16 F0B53A2C-98CA-415D-B928-E3FD0E52B22A Male 1950-06-20 10:31:18.337 African American Married English 14.870000 17.000000
17 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE Female 1930-05-28 02:59:42.857 White Married Icelandic 19.220000 19.000000
18 0BC491C5-5A45-4067-BD11-A78BEA00D3BE Female 1921-04-18 01:56:01.807 Unknown Married English 18.050000 19.000000
19 FFCDECD6-4048-4DCB-B910-1218160005B3 Male 1941-05-06 14:56:42.687 White Single English 14.490000 18.000000
20 CD2ADB1B-97F7-4EF6-BC5C-3E0EC562A06F Female 1963-04-16 08:54:08.647 White Single Icelandic 11.160000 19.000000
21 69CC25ED-A54A-4BAF-97E3-774BB3C9DED1 Female 1974-10-13 14:51:28.997 Unknown Married English 17.720000 17.000000
22 69B5D2A0-12FD-46EF-A5FF-B29C4BAFBE49 Male 1954-05-02 16:38:15.957 White Married English 18.650000 16.000000
23 8D389A8C-A6D8-4447-9DDE-1A28AB4EC667 Female 1964-07-10 08:50:13.707 Asian Married English 4.340000 19.000000
24 967987B9-FFEF-4776-85CF-AE05CA81F583 Male 1947-02-13 10:26:55.520 White Widowed English 88.660000 20.000000
25 9BBF3A51-443D-438B-9289-B98B8E0577C0 Male 1944-11-25 06:12:56.860 White Married English 16.760000 16.000000
26 6D8008ED-D623-4BE4-B93B-335F9797C170 Female 1978-03-14 13:41:28.337 White Married Icelandic 14.810000 18.000000
27 B3892204-880B-40EF-B3BB-B824B50E99E5 Male 1978-08-06 08:38:27.330 White Single Spanish 16.860000 20.000000
28 49DADA25-F2C2-42BB-8210-D78E6C7B0D48 Male 1962-04-08 10:18:26.263 African American Married English 19.500000 19.000000
29 7548B6CF-79D9-461D-A0C5-20B861406FAC Male 1956-11-13 14:08:00.253 White Married Icelandic 14.030000 15.000000
30 80D356B4-F974-441F-A5F2-F95986D119A2 Female 1938-03-06 18:24:18.297 White Single English 18.880000 20.000000
31 A0A976C8-9B30-4492-B8C4-5B25095B9192 Male 1931-05-26 14:54:15.847 Asian Single English 19.520000 17.000000
32 3B11D6B3-A36A-4B69-A437-C29BF425A941 Female 1954-05-18 10:19:19.110 Asian Separated English 10.800000 18.000000
33 E483DE6E-D4E6-47FD-905B-22EE86EC7ACE Male 1945-11-18 04:14:31.573 African American Single English 16.880000 20.000000
34 53B9FFDD-F80B-43BE-93CF-C34A023EE7E9 Male 1921-08-22 19:17:09.227 White Divorced Icelandic 18.170000 18.000000
35 C5D09468-574F-4802-B56F-DB38F4EB1687 Male 1939-07-07 19:39:49.753 African American Married Icelandic 10.870000 16.000000
36 EA7C2F0F-DA1C-4CE8-9700-4BB1FC7AF3FB Male 1969-01-05 00:15:09.627 Unknown Married English 3.300000 20.000000
37 35FE7491-1A1D-48CB-810C-8DC2599AB3DD Male 1969-11-02 06:34:34.527 White Married English 4.510000 19.000000
38 56A35E74-90BE-44A0-B7BA-7743BB152133 Female 1968-11-09 15:29:19.557 White Married English 8.810000 17.000000
39 CC12B481-B516-455B-884F-4CA900B29F2E Female 1985-10-21 07:59:04.777 Unknown Divorced English 14.580000 18.000000
40 3231F930-2978-4F50-8234-755449851E7B Male 1979-05-26 04:58:10.627 White Single English 18.360000 20.000000
41 1311FEE4-2FDC-46E4-83D3-1550A3E51D2C Female 1988-03-28 03:09:22.807 White Single English 14.990000 15.000000
42 EEAFC0B3-B835-4D99-AB33-2F9428E54E5F Female 1961-01-08 15:19:15.490 Asian Unknown English 18.950000 17.000000
43 36775002-9EC3-4889-AD4F-80DC6855C8D8 Female 1963-07-16 22:16:48.477 Asian Single Spanish 15.560000 18.000000
44 4C201C71-CCED-40D1-9642-F9C8C485B854 Male 1926-09-22 09:17:14.713 African American Married English 10.300000 19.000000
45 2A8772FE-61DB-483E-B6BF-6C0A74BA9C2A Female 1966-10-14 15:31:48.427 Asian Single English 11.150000 18.000000
46 C65A4ADE-112E-49E4-B72A-0DED22C242ED Male 1955-04-07 18:55:17.077 White Married English 19.660000 15.000000
47 80AC01B2-BD55-4BE0-A59A-4024104CF4E9 Female 1965-05-14 15:25:09.740 African American Married English 19.740000 20.000000
48 6A57AC0C-57F3-4C19-98A1-51135EFBC4FF Female 1958-07-07 16:00:19.383 Unknown Married English 94.060000 17.000000
49 7A025E77-7832-4F53-B9A7-09A3F98AC17E Female 1951-07-12 08:23:45.520 Asian Single English 16.690000 20.000000
50 886B5885-1EE2-49F3-98D5-A2F02EB8A9D4 Female 1970-04-27 09:15:11.080 Unknown Married English 10.350000 17.000000
51 0681FA35-A794-4684-97BD-00B88370DB41 Female 1978-10-02 21:46:05.300 Asian Unknown Spanish 19.160000 18.000000
52 E250799D-F6DE-4914-ADB4-B08A6E5029B9 Female 1945-08-04 19:03:00.757 White Single Unknown 12.860000 19.000000
53 A19A0B00-4C9A-4206-B1FE-17E6DA3CEB0B Female 1967-07-01 01:44:24.907 Unknown Married English 17.840000 15.000000
54 E5478913-6819-4977-BB11-4C8B61175B56 Female 1980-03-21 13:08:56.867 White Single English 12.920000 20.000000
55 66154E24-D3EE-4311-89DB-6195278F9B3C Female 1944-08-26 13:03:24.297 White Divorced English 19.490000 18.000000
56 BC44CE19-9FC5-4AC9-A296-9EBC5E3D03AE Female 1953-06-04 03:16:17.843 African American Married English 15.040000 16.000000
57 CC9CDA72-B37A-4F8F-AFE4-B08F56A183BE Female 1942-04-14 14:01:01.130 Asian Married Spanish 14.150000 16.000000
58 EA9B67E2-15F0-450B-A8A6-14F6E4AE3D12 Female 1930-04-08 20:59:31.057 Asian Separated Icelandic 98.400000 16.000000
59 3E462A8F-7B90-43A1-A8B6-AD82CB5002C9 Female 1986-12-20 16:41:34.793 White Married Spanish 18.330000 15.000000
60 9E18822E-7D13-45C7-B50E-F95CFF92BC3E Male 1954-10-16 06:45:56.257 Unknown Single English 15.240000 18.000000
61 A7142B71-A144-4D56-BD14-3E966B01DB37 Male 1960-03-28 13:40:52.270 White Divorced Spanish 19.520000 17.000000
62 98F593D2-8894-49BB-93B9-5A0E2CF85E2E Female 1944-07-15 19:04:11.487 African American Married English 9.100000 16.000000
63 1A220558-5996-43E1-AE5D-7B96180FED35 Male 1937-09-07 22:23:53.143 Asian Married English 15.110000 20.000000
64 7A7332AD-88B1-4848-9356-E5260E477C59 Female 1944-12-01 06:30:01.543 Unknown Married English 19.460000 19.000000
65 36E2F89E-777A-4D77-9D95-0D70A8AB416F Male 1980-05-30 13:23:50.703 African American Separated English 19.360000 19.000000
66 03A481F5-B32A-4A91-BD42-43EB78FEBA77 Female 1968-02-07 23:02:38.017 Asian Single Unknown 93.230000 15.000000
67 2A5251B1-0945-47FA-A65C-7A6381562591 Female 1942-01-07 16:45:33.060 Unknown Married Spanish 18.050000 16.000000
68 8AF47463-8534-4203-B210-C2290F6CE689 Female 1952-06-27 17:29:04.187 White Divorced English 11.880000 16.000000
69 6623F5D6-D581-4268-9F9B-21612FBBF7B5 Female 1943-02-17 15:36:13.787 Asian Single Spanish 14.490000 18.000000
70 65A7FBE0-EA9F-49E9-9824-D8F3AD98DAC0 Female 1962-11-30 06:28:33.110 White Separated Spanish 17.980000 19.000000
71 FB909FAE-72DD-4F6F-9828-D92183DF185F Male 1940-07-15 12:18:41.080 White Single Spanish 14.900000 15.000000

13.6.2. IN and NOT IN examples#

SELECT *
FROM  LabsCorePopulatedTable 
WHERE PatientID IN (
    SELECT PatientID 
    FROM PatientCorePopulatedTable 
    WHERE PatientLanguage IN ('Icelandic', 'Spanish')
)
LIMIT 100;
Hide code cell source 
import sqlite3
import pandas as pd

conn = sqlite3.connect('100_patients.db')

sql_statement = """
SELECT *
FROM  LabsCorePopulatedTable 
WHERE PatientID IN (
    SELECT PatientID 
    FROM PatientCorePopulatedTable 
    WHERE PatientLanguage IN ('Icelandic', 'Spanish')
)
LIMIT 100;
"""
df = pd.read_sql_query(sql_statement, conn)
df.style.set_table_attributes('style="font-size: 12px"')
  PatientID AdmissionID LabName LabValue LabUnits LabDateTime
0 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 1 CBC: HEMOGLOBIN 10.900000 gm/dl 1953-11-28 14:09:29.363
1 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 1 METABOLIC: AST/SGOT 29.300000 U/L 1953-11-28 21:02:51.897
2 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 1 METABOLIC: GLUCOSE 132.900000 mg/dL 1953-11-28 00:21:31.683
3 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 1 URINALYSIS: RED BLOOD CELLS 2.300000 rbc/hpf 1953-11-28 11:19:18.283
4 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 1 METABOLIC: ALK PHOS 74.600000 U/L 1953-11-28 00:20:01.843
5 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 1 CBC: MCHC 33.500000 g/dl 1953-11-28 01:27:39.687
6 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 1 METABOLIC: CARBON DIOXIDE 21.700000 mmol/L 1953-11-28 08:17:31.660
7 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 1 CBC: EOSINOPHILS 0.500000 k/cumm 1953-11-28 10:35:41.860
8 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 1 METABOLIC: CALCIUM 9.700000 mg/dL 1953-11-28 08:30:06.620
9 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 1 CBC: NEUTROPHILS 9.000000 k/cumm 1953-11-28 09:45:44.733
10 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 1 URINALYSIS: PH 6.700000 no unit 1953-11-28 17:40:09.690
11 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 1 CBC: ABSOLUTE NEUTROPHILS 62.800000 % 1953-11-28 03:35:04.810
12 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 1 METABOLIC: BILI TOTAL 0.400000 mg/dL 1953-11-28 15:22:31.230
13 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 1 METABOLIC: CREATININE 0.600000 mg/dL 1953-12-01 22:15:51.590
14 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 1 URINALYSIS: PH 6.300000 no unit 1953-12-01 06:33:26.870
15 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 1 METABOLIC: GLUCOSE 137.400000 mg/dL 1953-12-01 13:30:53.080
16 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 1 CBC: RED BLOOD CELL COUNT 6.900000 m/cumm 1953-12-01 13:50:57.487
17 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 1 CBC: WHITE BLOOD CELL COUNT 10.500000 k/cumm 1953-12-01 06:16:18.957
18 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 1 CBC: MCH 30.000000 pg 1953-12-02 08:57:13.550
19 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 1 CBC: BASOPHILS 0.000000 k/cumm 1953-12-02 12:52:42.280
20 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 1 METABOLIC: CHLORIDE 93.900000 mmol/L 1953-12-02 04:51:06.733
21 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 1 CBC: ABSOLUTE LYMPHOCYTES 21.300000 % 1953-12-02 00:23:14.160
22 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 1 CBC: RED BLOOD CELL COUNT 5.500000 m/cumm 1953-12-02 11:58:56.217
23 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 1 CBC: WHITE BLOOD CELL COUNT 10.800000 k/cumm 1953-12-02 05:00:20.303
24 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 1 METABOLIC: AST/SGOT 18.900000 U/L 1953-12-02 02:09:54.483
25 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 1 METABOLIC: BILI TOTAL 1.100000 mg/dL 1953-12-02 04:09:22.613
26 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 1 METABOLIC: BUN 11.900000 mg/dL 1953-12-02 02:13:19.553
27 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 1 CBC: MCHC 34.300000 g/dl 1953-12-02 08:01:19.600
28 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 1 URINALYSIS: WHITE BLOOD CELLS 3.100000 wbc/hpf 1953-12-02 13:30:22.977
29 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 1 METABOLIC: TOTAL PROTEIN 5.100000 gm/dL 1953-12-02 01:47:15.153
30 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 1 METABOLIC: SODIUM 154.500000 mmol/L 1953-12-01 23:27:54.847
31 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 1 CBC: MEAN CORPUSCULAR VOLUME 70.400000 fl 1953-12-02 07:18:53.313
32 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 1 METABOLIC: ALBUMIN 3.600000 gm/dL 1953-12-02 13:36:37.693
33 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 1 CBC: EOSINOPHILS 0.400000 k/cumm 1953-12-02 14:01:04.720
34 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 1 METABOLIC: CREATININE 0.700000 mg/dL 1953-12-02 06:51:26.493
35 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 1 CBC: HEMOGLOBIN 18.600000 gm/dl 1953-12-02 05:12:51.010
36 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 1 METABOLIC: ALT/SGPT 28.400000 U/L 1953-12-02 09:02:25.493
37 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 1 CBC: HEMATOCRIT 53.400000 % 1953-12-02 00:56:25.770
38 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 1 CBC: ABSOLUTE NEUTROPHILS 69.400000 % 1953-12-02 07:25:49.810
39 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 1 METABOLIC: ALK PHOS 103.900000 U/L 1953-12-02 07:28:37.630
40 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 1 METABOLIC: CARBON DIOXIDE 24.900000 mmol/L 1953-12-02 13:15:03.360
41 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 1 URINALYSIS: SPECIFIC GRAVITY 1.000000 no unit 1953-12-02 14:11:51.947
42 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 1 METABOLIC: POTASSIUM 3.800000 mmol/L 1953-12-02 00:13:49.983
43 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 1 URINALYSIS: RED BLOOD CELLS 0.800000 rbc/hpf 1953-12-02 03:47:57.670
44 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 1 METABOLIC: GLUCOSE 79.000000 mg/dL 1953-12-01 23:24:50.990
45 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 1 CBC: RDW 14.600000 % 1953-12-02 06:39:25.980
46 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 2 CBC: NEUTROPHILS 4.400000 k/cumm 1979-09-15 13:22:34.587
47 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 2 CBC: EOSINOPHILS 0.200000 k/cumm 1979-09-16 02:04:55.270
48 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 2 METABOLIC: CHLORIDE 98.100000 mmol/L 1979-09-15 20:01:51.337
49 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 2 CBC: MEAN CORPUSCULAR VOLUME 97.000000 fl 1979-09-15 23:18:05.967
50 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 2 CBC: LYMPHOCYTES 0.600000 k/cumm 1979-09-15 14:08:31.630
51 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 2 METABOLIC: POTASSIUM 4.800000 mmol/L 1979-09-15 11:02:57.917
52 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 2 METABOLIC: ALT/SGPT 70.900000 U/L 1979-09-15 16:44:20.533
53 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 2 METABOLIC: CALCIUM 10.400000 mg/dL 1979-09-15 11:50:22.660
54 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 2 METABOLIC: SODIUM 145.100000 mmol/L 1979-09-16 03:35:13.270
55 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 2 CBC: ABSOLUTE NEUTROPHILS 69.200000 % 1979-09-16 05:43:33.740
56 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 2 CBC: MCH 32.600000 pg 1979-09-15 23:21:28.610
57 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 2 URINALYSIS: SPECIFIC GRAVITY 1.000000 no unit 1979-09-16 09:45:20.950
58 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 2 CBC: MONOCYTES 0.700000 k/cumm 1979-09-16 05:27:57.903
59 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 2 URINALYSIS: RED BLOOD CELLS 0.900000 rbc/hpf 1979-09-15 18:16:03.557
60 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 2 URINALYSIS: WHITE BLOOD CELLS 0.900000 wbc/hpf 1979-09-16 09:32:38.197
61 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 2 METABOLIC: ALBUMIN 2.700000 gm/dL 1979-09-15 18:23:59.207
62 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 2 METABOLIC: ALK PHOS 70.500000 U/L 1979-09-15 20:15:19.773
63 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 2 URINALYSIS: PH 6.100000 no unit 1979-09-15 21:34:58.310
64 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 2 CBC: HEMOGLOBIN 11.600000 gm/dl 1979-09-15 22:05:34.613
65 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 2 CBC: WHITE BLOOD CELL COUNT 9.300000 k/cumm 1979-09-16 09:19:19.133
66 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 2 CBC: RDW 15.200000 % 1979-09-16 09:58:40.650
67 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 2 METABOLIC: CREATININE 1.000000 mg/dL 1979-09-15 20:01:09.230
68 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 2 CBC: MCHC 28.100000 g/dl 1979-09-16 01:21:46.287
69 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 2 CBC: PLATELET COUNT 167.400000 k/cumm 1979-09-16 08:04:34.420
70 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 2 METABOLIC: TOTAL PROTEIN 6.700000 gm/dL 1979-09-15 11:19:20.393
71 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 2 CBC: BASOPHILS 0.100000 k/cumm 1979-09-15 12:47:07.220
72 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 2 METABOLIC: ANION GAP 8.200000 mmol/L 1979-09-16 05:42:07.383
73 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 2 METABOLIC: BUN 24.500000 mg/dL 1979-09-16 04:58:33.460
74 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 2 CBC: EOSINOPHILS 0.200000 k/cumm 1979-09-17 05:30:39.517
75 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 2 METABOLIC: SODIUM 131.400000 mmol/L 1979-09-17 00:13:16.120
76 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 2 CBC: MCH 32.900000 pg 1979-09-16 17:24:55.867
77 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 2 URINALYSIS: PH 6.800000 no unit 1979-09-17 07:05:11.520
78 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 2 METABOLIC: ALBUMIN 4.700000 gm/dL 1979-09-16 14:12:57.197
79 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 2 CBC: MCHC 29.800000 g/dl 1979-09-16 13:43:53.140
80 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 2 CBC: WHITE BLOOD CELL COUNT 4.100000 k/cumm 1979-09-16 12:01:20.027
81 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 2 CBC: HEMOGLOBIN 17.700000 gm/dl 1979-09-17 04:37:36.363
82 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 2 CBC: MONOCYTES 0.300000 k/cumm 1979-09-17 07:20:34.527
83 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 2 CBC: NEUTROPHILS 1.600000 k/cumm 1979-09-16 16:55:47.507
84 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 2 CBC: RDW 10.600000 % 1979-09-17 06:39:16.747
85 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 2 METABOLIC: CARBON DIOXIDE 32.800000 mmol/L 1979-09-16 23:43:59.297
86 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 2 METABOLIC: CREATININE 0.700000 mg/dL 1979-09-16 18:50:49.857
87 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 2 URINALYSIS: WHITE BLOOD CELLS 1.000000 wbc/hpf 1979-09-16 15:54:13.407
88 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 2 CBC: MEAN CORPUSCULAR VOLUME 79.000000 fl 1979-09-17 06:51:33.423
89 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 2 METABOLIC: ALT/SGPT 74.900000 U/L 1979-09-16 12:49:35.207
90 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 2 CBC: BASOPHILS 0.200000 k/cumm 1979-09-17 04:54:46.347
91 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 2 CBC: ABSOLUTE NEUTROPHILS 77.100000 % 1979-09-17 02:34:22.067
92 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 2 CBC: RED BLOOD CELL COUNT 6.300000 m/cumm 1979-09-16 10:15:38.247
93 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 2 CBC: HEMATOCRIT 37.400000 % 1979-09-16 10:44:27.440
94 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 2 METABOLIC: POTASSIUM 3.600000 mmol/L 1979-09-16 11:09:37.170
95 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 2 URINALYSIS: SPECIFIC GRAVITY 1.000000 no unit 1979-09-19 16:15:16.273
96 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 2 METABOLIC: GLUCOSE 126.200000 mg/dL 1979-09-20 09:38:32.793
97 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 2 METABOLIC: AST/SGOT 27.800000 U/L 1979-09-20 11:35:34.000
98 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 2 CBC: RED BLOOD CELL COUNT 5.700000 m/cumm 1979-09-20 12:24:18.503
99 81C5B13B-F6B2-4E57-9593-6E7E4C13B2CE 2 METABOLIC: CREATININE 1.200000 mg/dL 1979-09-21 02:31:31.370 
SELECT *
FROM  LabsCorePopulatedTable 
WHERE PatientID IN (
    SELECT PatientID 
    FROM PatientCorePopulatedTable 
    WHERE PatientLanguage NOT IN ('Icelandic', 'Spanish')
)
LIMIT 100;
Hide code cell source 
import sqlite3
import pandas as pd

conn = sqlite3.connect('100_patients.db')

sql_statement = """
SELECT *
FROM  LabsCorePopulatedTable 
WHERE PatientID IN (
    SELECT PatientID 
    FROM PatientCorePopulatedTable 
    WHERE PatientLanguage NOT IN ('Icelandic', 'Spanish')
)
LIMIT 100;
"""
df = pd.read_sql_query(sql_statement, conn)
df.style.set_table_attributes('style="font-size: 12px"')
  PatientID AdmissionID LabName LabValue LabUnits LabDateTime
0 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 1 URINALYSIS: RED BLOOD CELLS 1.800000 rbc/hpf 1992-07-01 01:36:17.910
1 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 1 METABOLIC: GLUCOSE 103.300000 mg/dL 1992-06-30 09:35:52.383
2 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 1 CBC: MCH 35.800000 pg 1992-06-30 03:50:11.777
3 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 1 METABOLIC: CALCIUM 8.900000 mg/dL 1992-06-30 12:09:46.107
4 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 1 CBC: RED BLOOD CELL COUNT 4.800000 m/cumm 1992-07-01 01:31:08.677
5 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 1 URINALYSIS: PH 4.900000 no unit 1992-07-01 01:25:54.887
6 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 1 METABOLIC: TOTAL PROTEIN 7.500000 gm/dL 1992-06-30 17:58:08.513
7 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 1 METABOLIC: CHLORIDE 111.500000 mmol/L 1992-06-30 14:03:11.313
8 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 1 CBC: LYMPHOCYTES 2.200000 k/cumm 1992-07-01 02:42:24.957
9 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 1 CBC: ABSOLUTE LYMPHOCYTES 33.300000 % 1992-06-30 09:39:02.830
10 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 1 METABOLIC: SODIUM 130.400000 mmol/L 1992-06-30 14:25:18.260
11 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 1 URINALYSIS: SPECIFIC GRAVITY 1.000000 no unit 1992-07-01 02:40:06.887
12 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 1 METABOLIC: BILI TOTAL 0.600000 mg/dL 1992-07-01 01:21:44.597
13 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 1 URINALYSIS: WHITE BLOOD CELLS 2.000000 wbc/hpf 1992-06-30 14:34:52.290
14 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 1 CBC: EOSINOPHILS 0.600000 k/cumm 1992-06-30 20:14:36.117
15 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 1 METABOLIC: ALK PHOS 63.500000 U/L 1992-06-30 09:08:51.047
16 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 1 CBC: RDW 15.800000 % 1992-06-30 11:04:44.837
17 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 1 METABOLIC: AST/SGOT 35.600000 U/L 1992-06-30 23:38:15.140
18 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 1 METABOLIC: CREATININE 1.000000 mg/dL 1992-06-30 14:50:30.213
19 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 1 CBC: NEUTROPHILS 1.000000 k/cumm 1992-07-01 17:43:57.380
20 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 1 CBC: BASOPHILS 0.100000 k/cumm 1992-07-01 22:50:15.633
21 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 1 CBC: RDW 10.100000 % 1992-07-01 21:54:46.720
22 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 1 METABOLIC: CALCIUM 8.400000 mg/dL 1992-07-01 21:49:40.153
23 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 1 METABOLIC: BILI TOTAL 0.100000 mg/dL 1992-07-01 21:47:17.043
24 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 1 CBC: RED BLOOD CELL COUNT 3.700000 m/cumm 1992-07-01 19:45:23.057
25 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 1 CBC: MONOCYTES 0.800000 k/cumm 1992-07-01 03:28:46.073
26 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 1 CBC: EOSINOPHILS 0.500000 k/cumm 1992-07-01 03:20:24.070
27 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 1 CBC: MCH 24.200000 pg 1992-07-01 18:02:55.160
28 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 1 CBC: LYMPHOCYTES 1.600000 k/cumm 1992-07-01 09:43:24.983
29 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 1 METABOLIC: BUN 20.200000 mg/dL 1992-07-01 17:56:23.110
30 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 1 CBC: WHITE BLOOD CELL COUNT 3.200000 k/cumm 1992-07-01 23:01:03.837
31 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 1 CBC: PLATELET COUNT 163.700000 k/cumm 1992-07-01 09:16:43.977
32 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 1 METABOLIC: POTASSIUM 5.500000 mmol/L 1992-07-01 07:20:54.017
33 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 1 METABOLIC: ANION GAP 11.200000 mmol/L 1992-07-01 04:25:57.077
34 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 1 CBC: HEMATOCRIT 52.400000 % 1992-07-01 05:35:45.510
35 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 1 METABOLIC: CREATININE 0.900000 mg/dL 1992-07-01 12:04:14.040
36 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 1 METABOLIC: TOTAL PROTEIN 6.600000 gm/dL 1992-07-01 09:10:37.717
37 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 1 CBC: HEMOGLOBIN 14.200000 gm/dl 1992-07-01 14:23:02.633
38 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 1 METABOLIC: CHLORIDE 105.300000 mmol/L 1992-07-01 20:58:22.167
39 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 1 URINALYSIS: WHITE BLOOD CELLS 2.500000 wbc/hpf 1992-07-01 22:13:00.610
40 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 1 METABOLIC: ALK PHOS 77.700000 U/L 1992-07-01 18:49:40.103
41 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 1 CBC: ABSOLUTE LYMPHOCYTES 26.000000 % 1992-07-01 03:38:07.080
42 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 1 METABOLIC: CARBON DIOXIDE 26.300000 mmol/L 1992-07-01 05:53:08.337
43 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 1 METABOLIC: AST/SGOT 14.800000 U/L 1992-07-01 22:43:55.487
44 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 1 METABOLIC: SODIUM 144.700000 mmol/L 1992-07-01 05:47:30.580
45 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 1 CBC: ABSOLUTE NEUTROPHILS 73.400000 % 1992-07-01 13:57:21.853
46 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 1 METABOLIC: ALBUMIN 3.100000 gm/dL 1992-07-01 08:10:42.320
47 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 1 URINALYSIS: RED BLOOD CELLS 2.500000 rbc/hpf 1992-07-01 10:38:47.503
48 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 1 URINALYSIS: SPECIFIC GRAVITY 1.000000 no unit 1992-07-01 19:28:25.110
49 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 1 METABOLIC: GLUCOSE 69.500000 mg/dL 1992-07-01 04:13:39.683
50 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 1 URINALYSIS: PH 5.700000 no unit 1992-07-01 03:26:14.710
51 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 1 CBC: MCHC 28.500000 g/dl 1992-07-01 03:54:13.587
52 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 2 CBC: HEMATOCRIT 50.900000 % 2005-07-26 09:51:14.723
53 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 2 METABOLIC: POTASSIUM 4.400000 mmol/L 2005-07-26 14:03:53.497
54 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 2 CBC: NEUTROPHILS 3.100000 k/cumm 2005-07-26 12:27:06.393
55 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 2 CBC: PLATELET COUNT 200.600000 k/cumm 2005-07-27 02:34:55.977
56 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 2 CBC: BASOPHILS 0.000000 k/cumm 2005-07-26 14:58:28.687
57 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 2 METABOLIC: BILI TOTAL 0.200000 mg/dL 2005-07-26 20:39:49.140
58 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 2 METABOLIC: ALBUMIN 5.800000 gm/dL 2005-07-26 09:51:51.223
59 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 2 URINALYSIS: PH 5.900000 no unit 2005-07-26 23:37:48.423
60 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 2 METABOLIC: GLUCOSE 73.800000 mg/dL 2005-07-26 20:05:54.243
61 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 2 METABOLIC: TOTAL PROTEIN 9.200000 gm/dL 2005-07-27 06:44:49.873
62 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 2 CBC: HEMOGLOBIN 16.100000 gm/dl 2005-07-27 02:35:16.290
63 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 2 CBC: RED BLOOD CELL COUNT 5.000000 m/cumm 2005-07-27 04:47:14.633
64 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 2 METABOLIC: CREATININE 1.200000 mg/dL 2005-07-26 19:23:18.550
65 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 2 CBC: MEAN CORPUSCULAR VOLUME 86.600000 fl 2005-07-27 01:16:21.500
66 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 2 METABOLIC: ALT/SGPT 29.100000 U/L 2005-07-27 00:59:44.193
67 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 2 METABOLIC: CHLORIDE 103.000000 mmol/L 2005-07-27 01:21:10.610
68 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 2 URINALYSIS: RED BLOOD CELLS 2.000000 rbc/hpf 2005-07-26 18:14:43.880
69 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 2 METABOLIC: CARBON DIOXIDE 26.800000 mmol/L 2005-07-27 12:47:59.227
70 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 2 METABOLIC: SODIUM 132.000000 mmol/L 2005-07-27 12:14:30.773
71 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 2 METABOLIC: CHLORIDE 107.600000 mmol/L 2005-07-27 13:43:55.487
72 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 2 CBC: HEMOGLOBIN 17.400000 gm/dl 2005-07-27 15:51:38.070
73 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 2 METABOLIC: BUN 9.400000 mg/dL 2005-07-27 11:23:02.263
74 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 2 CBC: ABSOLUTE LYMPHOCYTES 18.200000 % 2005-07-27 12:03:25.640
75 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 2 CBC: NEUTROPHILS 3.500000 k/cumm 2005-07-28 01:46:12.800
76 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 2 METABOLIC: ALT/SGPT 18.400000 U/L 2005-07-28 00:04:32.980
77 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 2 URINALYSIS: PH 4.700000 no unit 2005-07-27 16:13:23.007
78 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 2 CBC: BASOPHILS 0.100000 k/cumm 2005-07-27 13:30:05.717
79 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 2 METABOLIC: BILI TOTAL 0.200000 mg/dL 2005-07-27 16:14:15.507
80 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 2 URINALYSIS: SPECIFIC GRAVITY 1.000000 no unit 2005-07-28 06:54:36.203
81 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 2 CBC: LYMPHOCYTES 3.100000 k/cumm 2005-07-31 03:23:38.850
82 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 2 CBC: EOSINOPHILS 0.600000 k/cumm 2005-07-30 19:34:59.980
83 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 2 CBC: ABSOLUTE LYMPHOCYTES 20.400000 % 2005-07-30 23:13:19.497
84 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 2 METABOLIC: SODIUM 146.100000 mmol/L 2005-07-30 07:58:59.830
85 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 2 METABOLIC: ALK PHOS 137.000000 U/L 2005-07-31 05:09:35.897
86 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 2 CBC: RED BLOOD CELL COUNT 3.400000 m/cumm 2005-08-01 00:41:01.693
87 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 2 METABOLIC: CALCIUM 9.700000 mg/dL 2005-08-01 07:15:57.150
88 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 2 METABOLIC: ALT/SGPT 49.800000 U/L 2005-08-01 06:40:05.217
89 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 2 CBC: MONOCYTES 0.800000 k/cumm 2005-07-31 19:48:08.663
90 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 2 CBC: EOSINOPHILS 0.100000 k/cumm 2005-07-31 11:45:34.767
91 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 2 URINALYSIS: SPECIFIC GRAVITY 1.000000 no unit 2005-07-31 23:11:25.867
92 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 2 CBC: WHITE BLOOD CELL COUNT 4.800000 k/cumm 2005-07-31 20:34:27.947
93 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 2 CBC: PLATELET COUNT 273.500000 k/cumm 2005-08-01 01:08:12.140
94 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 2 METABOLIC: CREATININE 0.900000 mg/dL 2005-07-31 14:44:19.543
95 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 2 URINALYSIS: RED BLOOD CELLS 2.700000 rbc/hpf 2005-07-31 20:50:27.503
96 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 2 CBC: HEMOGLOBIN 12.300000 gm/dl 2005-07-31 09:49:42.283
97 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 2 METABOLIC: ALK PHOS 41.500000 U/L 2005-07-31 23:13:13.987
98 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 2 CBC: BASOPHILS 0.200000 k/cumm 2005-07-31 16:00:29.537
99 1A8791E3-A61C-455A-8DEE-763EB90C9B2C 2 METABOLIC: POTASSIUM 5.600000 mmol/L 2005-07-31 11:16:11.607
Contents