Lab Test Results
This dataset provides detailed laboratory test results, including test types, quantitative and qualitative outcomes, reference ranges, ordering physician information, specimen details, and timestamps. It enables clinical analysis, patient monitoring, and quality assurance in healthcare settings, supporting interoperability and regulatory compliance.
Sample rows
preview · 8 of 200 rows · all 17 columns| lab_test_result_idstring | result_flagstring | result_valuefloat | result_unitstring | patient_idstring | test_typestring | test_codestring | reference_range_lowfloat | reference_range_highfloat | reference_range_unitstring | result_textstring | ordering_physician_idstring | ordering_physician_namestring | result_timestampdatetime | specimen_typestring | specimen_collection_timestampdatetime | lab_locationstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| LTR00001 | normal | 5.1 | 10^12/L | PAT10001 | Complete Blood Count | 718-7 | 4.5 | 6 | 10^12/L | blank | PHY2001 | Dr. Emily Carter | 2024-03-01T09:35:00 | blood | 2024-03-01T08:55:00 | LabCenter01 |
| LTR00002 | abnormal | 112.3 | mg/dL | PAT10002 | Glucose, Fasting | 1558-6 | 70 | 99 | mg/dL | blank | PHY2002 | Dr. Raj Patel | 2024-03-02T10:22:00 | blood | 2024-03-02T09:40:00 | LabCenter02 |
| LTR00003 | normal | blank | blank | PAT10003 | Urinalysis | 5804-0 | blank | blank | blank | No protein, no glucose detected. | PHY2003 | Dr. Alice Nguyen | 2024-03-03T13:15:00 | urine | 2024-03-03T12:45:00 | LabCenter03 |
| LTR00004 | normal | 187 | mg/dL | PAT10004 | Cholesterol, Total | 2093-3 | 125 | 200 | mg/dL | blank | PHY2004 | Dr. Michael Lee | 2024-03-04T08:28:00 | blood | 2024-03-04T07:55:00 | LabCenter04 |
| LTR00005 | normal | blank | blank | PAT10005 | COVID-19 PCR | 94500-6 | blank | blank | blank | Negative for SARS-CoV-2 RNA. | PHY2001 | Dr. Emily Carter | 2024-03-05T09:47:00 | nasopharyngeal swab | 2024-03-05T09:15:00 | LabCenter01 |
| LTR00006 | abnormal | 6.7 | % | PAT10006 | Hemoglobin A1c | 4548-4 | 4 | 6.4 | % | blank | PHY2002 | Dr. Raj Patel | 2024-03-06T11:11:00 | blood | 2024-03-06T10:40:00 | LabCenter02 |
| LTR00007 | normal | 3.2 | mIU/L | PAT10007 | Thyroid Stimulating Hormone | TSH-1 | 0.4 | 4 | mIU/L | blank | PHY2003 | Dr. Alice Nguyen | 2024-03-07T15:22:00 | blood | 2024-03-07T14:50:00 | LabCenter03 |
| LTR00008 | abnormal | blank | blank | PAT10008 | Urine Pregnancy Test | 2106-3 | blank | blank | blank | Positive for beta-hCG. | PHY2004 | Dr. Michael Lee | 2024-03-08T08:31:00 | urine | 2024-03-08T08:10:00 | LabCenter04 |
| LTR00009 | normal | 141 | mmol/L | PAT10009 | Basic Metabolic Panel | BMP-1 | 135 | 145 | mmol/L | blank | PHY2005 | Dr. Susan Black | 2024-03-09T09:55:00 | blood | 2024-03-09T09:25:00 | LabCenter05 |
| LTR00010 | normal | blank | blank | PAT10010 | Hepatitis B Surface Antigen | 5195-3 | blank | blank | blank | Negative for HBsAg. | PHY2006 | Dr. James O'Neill | 2024-03-10T11:19:00 | blood | 2024-03-10T10:55:00 | LabCenter06 |
| LTR00011 | normal | 8 | 10^9/L | PAT10011 | White Blood Cell Count | 6690-2 | 4.5 | 11 | 10^9/L | blank | PHY2001 | Dr. Emily Carter | 2024-03-11T08:17:00 | blood | 2024-03-11T07:45:00 | LabCenter01 |
| LTR00012 | normal | blank | blank | PAT10012 | Urine Protein | 5804-0 | blank | blank | blank | Negative for protein. | PHY2002 | Dr. Raj Patel | 2024-03-12T13:03:00 | urine | 2024-03-12T12:35:00 | LabCenter02 |
| LTR00013 | abnormal | 38.5 | mg/dL | PAT10013 | HDL Cholesterol | 2085-9 | 40 | 60 | mg/dL | blank | PHY2003 | Dr. Alice Nguyen | 2024-03-13T15:46:00 | blood | 2024-03-13T15:21:00 | LabCenter03 |
| LTR00014 | abnormal | 68 | U/L | PAT10014 | ALT (SGPT) | 1742-6 | 10 | 55 | U/L | blank | PHY2004 | Dr. Michael Lee | 2024-03-14T10:22:00 | blood | 2024-03-14T10:01:00 | LabCenter04 |
| LTR00015 | normal | blank | blank | PAT10015 | HIV 1/2 Antibody | 5671-3 | blank | blank | blank | Non-reactive for HIV. | PHY2005 | Dr. Susan Black | 2024-03-15T09:43:00 | blood | 2024-03-15T09:17:00 | LabCenter05 |
| LTR00016 | normal | 214 | 10^9/L | PAT10016 | Platelet Count | 777-3 | 150 | 400 | 10^9/L | blank | PHY2006 | Dr. James O'Neill | 2024-03-16T11:36:00 | blood | 2024-03-16T11:02:00 | LabCenter06 |
| LTR00017 | pending | blank | blank | PAT10017 | Stool Occult Blood | 27353-2 | blank | blank | blank | Awaiting lab processing. | PHY2001 | Dr. Emily Carter | 2024-03-17T09:15:00 | stool | 2024-03-17T08:41:00 | LabCenter01 |
| LTR00018 | normal | 13.9 | sec | PAT10018 | Prothrombin Time | 5964-2 | 11 | 15 | sec | blank | PHY2002 | Dr. Raj Patel | 2024-03-18T10:39:00 | blood | 2024-03-18T10:18:00 | LabCenter02 |
| LTR00019 | normal | 1.05 | mg/dL | PAT10019 | Creatinine | 2160-0 | 0.7 | 1.3 | mg/dL | blank | PHY2003 | Dr. Alice Nguyen | 2024-03-19T14:18:00 | blood | 2024-03-19T13:58:00 | LabCenter03 |
| LTR00020 | abnormal | 33 | mm/hr | PAT10020 | Erythrocyte Sedimentation Rate | 4537-7 | 0 | 20 | mm/hr | blank | PHY2004 | Dr. Michael Lee | 2024-03-20T08:44:00 | blood | 2024-03-20T08:13:00 | LabCenter04 |
What the 200 rows show
from the 200-row sample- 9.3median result_
value - 9specimen types
- 16ordering physicians
- 21ordering physician names
- 21lab locations
- 23reference range units
Median 9.3, from 0.0 to 10,150.
- string 12
- float 3
- datetime 2
Columns
17 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 12 columns | |||
lab_test_result_id | string | Unique identifier for each lab test result recordunique | LTR00001 |
patient_id | string | Unique identifier for the patient associated with the test result | PAT10001 |
test_type | string | Name of the laboratory test performed (e.g., CBC, glucose, cholesterol) | Complete Blood Count |
test_code | string | Standardized code for the test type (e.g., LOINC code)optional | 718-7 |
result_unit | string | Unit of measurement for the test result (e.g., mg/dL, mmol/L)optional | 10^12/L |
result_flag | string | Indicator of result status (e.g., normal, abnormal, critical)normal · abnormal · critical · pending · optional | normal |
reference_range_unit | string | Unit of measurement for the reference rangeoptional | 10^12/L |
result_text | string | Free-text interpretation or comments about the test resultoptional | Positive for beta-hCG. |
ordering_physician_id | string | Unique identifier for the physician who ordered the test | PHY2001 |
ordering_physician_name | string | Full name of the ordering physicianoptional | Dr. Emily Carter |
specimen_type | string | Type of specimen collected for the test (e.g., blood, urine)9 types · optional | blood |
lab_location | string | Name or code of the laboratory where the test was performedoptional | LabCenter01 |
| Numbers 3 columns | |||
result_value | float | Numeric value of the test result (if applicable)optional | 5.1 |
reference_range_low | float | Lower bound of the reference range for the testoptional | 4.5 |
reference_range_high | float | Upper bound of the reference range for the testoptional | 6 |
| Dates and times 2 columns | |||
result_timestamp | datetime | Date and time when the test result was finalized | 2024-03-01T09:35:00 |
specimen_collection_timestamp | datetime | Date and time when the specimen was collectedoptional | 2024-03-01T08:55:00 |
Use it for
A healthcare dashboard
Result_
value by result_ flag and a breakdown of result_ unit. Excel, Power BI or Tableau. What pattern can you find in 200 rows?
A class exercise
Hand out the rows and one question. Everyone works from the same 200 rows.
- Lab test results200LTR000015.1normalLTR00002112.3abnormalLTR00003normal
A software demo
Believable lab test results with patient_
id, test_ type and test_ code to fill a screen in front of a buyer.
This dataset200 rows17 columns
Yours10,000 rows17 columnslab_location: UK only
blueprint · lab-test-results
Behind this dataset
Same schema. As many rows as you need.
These 200 rows came out of a blueprint — 17 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.
Rules it was built with
- Test code references lab test catalog
- Result value with units of measure
- Reference range for normal results
- Critical flag for abnormal results
- Result date/time after order date/time
Open the blueprint in Data Factory
1 credit per row. New accounts start with 25 free credits.
- Exports
- CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
- Licence
- yours to use, including commercially
- API slug
- lab-test-results