Clinical Trial Laboratory and Biomarker Data
This dataset provides comprehensive laboratory and biomarker results from clinical trials, including hematology, chemistry, urinalysis, tumor markers, pharmacokinetics, pharmacodynamics, and exploratory biomarkers. It enables robust safety and efficacy analysis, longitudinal tracking of patient responses, and supports regulatory submissions and translational research.
Sample rows
preview · 8 of 100 rows · all 18 columns| lab_result_idstring | result_flagstring | result_valuefloat | result_unitstring | clinical_trial_idstring | subject_idstring | visit_numberinteger | visit_datedate | sample_typestring | test_categorystring | test_namestring | test_codestring | reference_range_lowfloat | reference_range_highfloat | lab_namestring | collection_timedatetime | analysis_timedatetime | commentsstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| LAB001 | normal | 6.2 | 10^3/uL | CT2024-01 | SUBJ001 | 1 | 2024-03-01 | blood | hematology | WBC | LOINC-6690-2 | 4 | 10 | Central Lab Alpha | 2024-03-01T08:15:00 | 2024-03-01T10:10:00 | blank |
| LAB002 | high | 62 | U/L | CT2024-01 | SUBJ001 | 1 | 2024-03-01 | blood | chemistry | ALT | LOINC-1742-6 | 10 | 60 | Central Lab Alpha | 2024-03-01T08:15:00 | 2024-03-01T10:19:00 | blank |
| LAB003 | normal | 34 | U/L | CT2024-01 | SUBJ001 | 1 | 2024-03-01 | blood | chemistry | AST | LOINC-1920-8 | 10 | 40 | Central Lab Alpha | 2024-03-01T08:15:00 | 2024-03-01T10:21:00 | blank |
| LAB004 | normal | 12.1 | g/dL | CT2024-01 | SUBJ001 | 2 | 2024-03-15 | blood | hematology | HGB | LOINC-718-7 | 12 | 16 | Central Lab Alpha | 2024-03-15T09:00:00 | 2024-03-15T10:40:00 | blank |
| LAB005 | normal | 0.12 | g/L | CT2024-01 | SUBJ001 | 2 | 2024-03-15 | urine | urinalysis | Protein | LOINC-5804-0 | 0 | 0.15 | Central Lab Alpha | 2024-03-15T09:05:00 | 2024-03-15T10:45:00 | blank |
| LAB006 | normal | 210 | 10^3/uL | CT2024-01 | SUBJ002 | 1 | 2024-03-02 | blood | hematology | PLT | LOINC-777-3 | 150 | 400 | Central Lab Alpha | 2024-03-02T08:25:00 | 2024-03-02T10:00:00 | blank |
| LAB007 | normal | 0 | mmol/L | CT2024-01 | SUBJ002 | 1 | 2024-03-02 | urine | urinalysis | Glucose | LOINC-2345-7 | 0 | 0.8 | Central Lab Alpha | 2024-03-02T08:35:00 | 2024-03-02T10:22:00 | blank |
| LAB008 | normal | 1.28 | mg/dL | CT2024-01 | SUBJ002 | 2 | 2024-03-16 | blood | chemistry | Creatinine | LOINC-2160-0 | 0.7 | 1.3 | Central Lab Alpha | 2024-03-16T08:10:00 | 2024-03-16T09:59:00 | blank |
| LAB009 | high | 41 | U/mL | CT2024-01 | SUBJ002 | 2 | 2024-03-16 | blood | tumor marker | CA-125 | LOINC-10334-1 | 0 | 35 | Central Lab Alpha | 2024-03-16T08:20:00 | 2024-03-16T10:05:00 | Elevated CA-125, consider retesting or further evaluation. |
| LAB010 | normal | 2.4 | ng/mL | CT2024-01 | SUBJ003 | 1 | 2024-03-03 | blood | pharmacokinetics | Drug A Level | PK-DRUGA | 0 | 5 | Central Lab Beta | 2024-03-03T08:05:00 | 2024-03-03T09:30:00 | blank |
| LAB011 | normal | 125 | U/L | CT2024-01 | SUBJ003 | 1 | 2024-03-03 | blood | pharmacodynamics | Enzyme Activity | PD-ENZ1 | 90 | 130 | Central Lab Beta | 2024-03-03T08:06:00 | 2024-03-03T09:34:00 | blank |
| LAB012 | normal | 0.86 | ng/mL | CT2024-01 | SUBJ003 | 2 | 2024-03-17 | plasma | exploratory biomarker | Biomarker X | XP-BMX1 | 0 | 1 | Central Lab Beta | 2024-03-17T08:10:00 | 2024-03-17T09:45:00 | blank |
| LAB013 | normal | 172 | mg/dL | CT2024-01 | SUBJ003 | 2 | 2024-03-17 | serum | chemistry | Cholesterol | LOINC-2093-3 | 120 | 200 | Central Lab Beta | 2024-03-17T08:20:00 | 2024-03-17T09:51:00 | blank |
| LAB014 | normal | 4.7 | 10^6/uL | CT2024-02 | SUBJ004 | 1 | 2024-04-01 | blood | hematology | RBC | LOINC-789-8 | 4 | 5.5 | Central Lab Gamma | 2024-04-01T08:10:00 | 2024-04-01T09:30:00 | blank |
| LAB015 | normal | 6.1 | blank | CT2024-02 | SUBJ004 | 1 | 2024-04-01 | urine | urinalysis | pH | LOINC-2756-9 | 4.5 | 8 | Central Lab Gamma | 2024-04-01T08:19:00 | 2024-04-01T09:38:00 | blank |
| LAB016 | normal | 106 | mg/dL | CT2024-02 | SUBJ004 | 2 | 2024-04-15 | blood | chemistry | Glucose | LOINC-2345-7 | 70 | 110 | Central Lab Gamma | 2024-04-15T08:12:00 | 2024-04-15T09:32:00 | blank |
| LAB017 | normal | 3.4 | ng/mL | CT2024-02 | SUBJ004 | 2 | 2024-04-15 | serum | tumor marker | PSA | LOINC-2857-1 | 0 | 4 | Central Lab Gamma | 2024-04-15T08:18:00 | 2024-04-15T09:40:00 | blank |
| LAB018 | normal | 0.12 | ng/mg | CT2024-02 | SUBJ005 | 1 | 2024-04-02 | tissue | exploratory biomarker | Biomarker Y | XP-BMY1 | 0 | 0.2 | Central Lab Delta | 2024-04-02T09:03:00 | 2024-04-02T11:03:00 | blank |
| LAB019 | normal | 4.8 | ng/mL | CT2024-02 | SUBJ005 | 1 | 2024-04-02 | blood | pharmacokinetics | Drug B Level | PK-DRUGB | 0 | 6 | Central Lab Delta | 2024-04-02T09:00:00 | 2024-04-02T10:20:00 | blank |
| LAB020 | normal | 3.7 | g/dL | CT2024-02 | SUBJ005 | 2 | 2024-04-16 | serum | chemistry | Albumin | LOINC-1751-7 | 3.5 | 5 | Central Lab Delta | 2024-04-16T09:15:00 | 2024-04-16T10:49:00 | blank |
What the 100 rows show
from the 100-row sample- 5.5median result_
value - 5sample types
- 7test categories
- 10clinical trials
- 15lab names
- 2.5median reference_
range_ low
Median 5.5, from 0.0 to 340.0.
- string 11
- integer 1
- float 3
- date 1
- datetime 2
Columns
18 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 11 columns | |||
lab_result_id | string | Unique identifier for each laboratory result recordunique | LAB001 |
clinical_trial_id | string | Identifier for the clinical trial associated with the lab result10 trials | CT2024-01 |
subject_id | string | Unique identifier for the subject/patient in the clinical trial | SUBJ001 |
sample_type | string | Type of biological sample collected (e.g., blood, urine, tissue)6 values | blood |
test_category | string | Category of laboratory test (e.g., hematology, chemistry, urinalysis, tumor marker, pharmacokinetics, pharmacodynamics, exploratory biomarker)7 values | hematology |
test_name | string | Name of the laboratory test performed (e.g., ALT, AST, WBC, CA-125) | WBC |
test_code | string | Standardized code for the laboratory test (e.g., LOINC, internal code)optional | LOINC-6690-2 |
result_unit | string | Unit of measurement for the laboratory result (e.g., mg/dL, U/L, cells/uL) | 10^3/uL |
result_flag | string | Indicator if the result is normal, high, low, or abnormalnormal · high · low · abnormal · not assessed · optional | normal |
lab_name | string | Name of the central laboratory that performed the testoptional | Central Lab Alpha |
comments | string | Free-text comments or notes about the result, sample, or analysisoptional | Elevated CA-125, consider… |
| Numbers 4 columns | |||
visit_number | integer | Visit number within the clinical trial protocol1 or more | 1 |
result_value | float | Numeric value of the laboratory test result | 6.2 |
reference_range_low | float | Lower bound of the normal reference range for the testoptional | 4 |
reference_range_high | float | Upper bound of the normal reference range for the testoptional | 10 |
| Dates and times 3 columns | |||
visit_date | date | Date when the sample was collected or the visit occurred | 2024-03-01 |
collection_time | datetime | Exact timestamp when the sample was collectedoptional | 2024-03-01T08:15:00 |
analysis_time | datetime | Timestamp when the sample was analyzedoptional | 2024-03-01T10:10: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 100 rows?
A class exercise
Hand out the rows and one question. Everyone works from the same 100 rows.
- Lab results100LAB0016.2normalLAB00262highLAB00334normal
A software demo
Believable lab results with clinical_
trial_ id, subject_ id and visit_ number to fill a screen in front of a buyer.
This dataset100 rows18 columns
Yours1,000 rows18 columns
blueprint · clinical-trial-laboratory-and-biomarker-data
Behind this dataset
Same schema. As many rows as you need.
These 100 rows came out of a blueprint — 18 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
- Lab ID unique per sample
- Subject ID and visit/timepoint
- Sample collection date/time
- Test performed with LOINC code
- Result value, units, and reference range
- Abnormality flag: normal, low, high, critically abnormal
- Pharmacokinetics: Cmax, Tmax, AUC, half-life
- Pharmacodynamics: target engagement, pathway modulation
Open the blueprint in Data Factory
1 credit per row. Preview 20 rows free. Buy rows for the full run.
- Exports
- CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
- Licence
- yours to use, including commercially
- API slug
- clinical-trial-laboratory-and-biomarker-data