Subqueries
Contents
Subqueries#
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
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 |
IN and NOT IN examples#
SELECT *
FROM LabsCorePopulatedTable
WHERE PatientID IN (
SELECT PatientID
FROM PatientCorePopulatedTable
WHERE PatientLanguage IN ('Icelandic', 'Spanish')
)
LIMIT 100;
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;
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 |