Endoscopy and Colonoscopy Findings

This dataset provides detailed, structured information from gastrointestinal endoscopy and colonoscopy reports, including procedure details, sedation, findings, polyp and biopsy descriptions, pathology results, photodocumentation, and quality metrics. It is ideal for clinical research, quality assurance, and screening program evaluation in gastroenterology, supporting both patient care and population health analytics.

  • last updated 2 Nov 2025
  • by GoMask
The brief that made it

Clinical outcomes research in gastroenterology

Sample rows

preview · 8 of 100 rows · all 21 columns
report_idstringbowel_preparation_qualitystringbiopsies_takenintegerphotodocumentationbooleanpolyp_locationstringpatient_idstringprocedure_datedateprocedure_typestringindicationstringsedation_typestringfindingsstringpolyp_countintegerlargest_polyp_size_mmfloatpolyp_morphologystringbiopsy_locationstringpathology_resultstringcecal_intubation_successbooleanwithdrawal_time_minfloatcomplicationsstringscreening_programstringendoscopist_idstring
REP10001excellent2truesigmoid colonPAT23012022-02-21colonoscopyscreeningconscious sedationmultiple small polyps in sigmoid colon37.8sessilesigmoid colontubular adenoma, no dysplasiatrue7.9blankCRC National ProgramENDO17
REP10002blank1falseblankPAT23872022-03-03upper endoscopydyspepsianonemild antral gastritis0blankblankantrumchronic gastritis, H. pylori negativeblankblankblankblankENDO05
REP10003good0trueblankPAT21022022-01-29colonoscopysurveillance post-polypectomydeep sedationno abnormal findings0blankblankblankblanktrue8.3blankCRC National ProgramENDO01
REP10004blank0falseblankPAT22202022-04-07sigmoidoscopyrectal bleedingnoneinternal hemorrhoids0blankblankblankblankblankblankblankblankENDO13
REP10005excellent1trueascending colonPAT23552022-03-12colonoscopychange in bowel habitsconscious sedation1 polyp in ascending colon115.2pedunculatedascending colonvillous adenoma, low grade dysplasiatrue9.5minor bleeding controlled endoscopicallyblankENDO03
REP10006blank0trueblankPAT24882022-02-11upper endoscopyGERDconscious sedationnormal study0blankblankblankblankblankblankblankblankENDO17
REP10007good2truetransverse colonPAT21542022-05-24colonoscopyscreeningdeep sedationflat polyp in transverse colon18.9flattransverse colonhyperplastic polyp, benign mucosatrue10.6blankCRC National ProgramENDO09
REP10008fair4truedescending colonPAT21232022-06-08colonoscopypositive FITgeneral anesthesiamultiple polyps, largest in descending colon518.3sessiledescending colonadenomatous polyps, 2 with high grade dysplasiatrue12.1post-polypectomy bleedingCRC National ProgramENDO11

What the 100 rows show

from the 100-row sample

Fair (bowel preparation quality) stands out: mean biopsies_taken is 2.3, against 0.98 for the rest.

  • 66%photodocumentation = true
  • 1median biopsies_taken
  • 3polyp morphologies
  • 4procedure types
  • 4sedation types
  • 6screening programs
Mean biopsies_taken by bowel_preparation_quality67 rows
0240.42excellent19 rows1.3good33 rows2.3fair15 rows
biopsies_taken100 rows, in bands of 0.5
02040350330200111024biopsies_taken →

Median 1, from 0 to 4.

polyp_location46 rows with a value · 54 left blank
  1. transverse colon14
  2. descending colon10
  3. sigmoid colon9
  4. cecum6
  5. ascending colon5
  6. rectum2
21 columns by typefrom the column list below
  • string 14
  • integer 2
  • float 2
  • date 1
  • boolean 2

Columns

21 columns in four groups
blueprint · 21 columns
columntypedescriptionexample
Text 14 columns
report_idstringUnique identifier for each endoscopy or colonoscopy reportuniqueREP10001
patient_idstringUnique identifier for the patient undergoing the procedurePAT2301
procedure_typestringType of procedure performed (e.g., colonoscopy, upper endoscopy, sigmoidoscopy)colonoscopy · upper endoscopy · sigmoidoscopy · othercolonoscopy
indicationstringClinical reason for performing the procedureoptionalscreening
sedation_typestringType of sedation used during the procedure5 values · optionalconscious sedation
findingsstringSummary of findings observed during the procedureoptionalmild antral gastritis
polyp_locationstringAnatomical location of the largest or most significant polyp6 locations · optionalsigmoid colon
polyp_morphologystringMorphological description of the largest or most significant polyp (e.g., sessile, pedunculated)sessile · pedunculated · flat · other · optionalsessile
biopsy_locationstringAnatomical location(s) where biopsies were taken11 locations · optionalsigmoid colon
pathology_resultstringSummary of pathology results from biopsies or polyp removaloptionalchronic active gastritis
bowel_preparation_qualitystringQuality of bowel preparation (e.g., excellent, good, fair, poor)excellent · good · fair · poor · optionalexcellent
complicationsstringDescription of any complications that occurred during or after the procedure6 complicationses · optionalminor bleeding, resolved
screening_programstringName or type of screening program if applicable6 programs · optionalCRC National Program
endoscopist_idstringUnique identifier for the physician who performed the procedureENDO17
Numbers 4 columns
polyp_countintegerTotal number of polyps identified during the procedure0 or more · optional3
largest_polyp_size_mmfloatSize in millimeters of the largest polyp found0 or more · optional7.8
biopsies_takenintegerNumber of biopsies taken during the procedure0 or more · optional2
withdrawal_time_minfloatWithdrawal time in minutes (colonoscopy quality metric)0 or more · optional7.9
Dates and times 1 column
procedure_datedateDate when the procedure was performed2022-02-21
True or false 2 columns
photodocumentationbooleanIndicates whether photodocumentation was performedoptionaltrue
cecal_intubation_successbooleanIndicates whether cecal intubation was successfully achieved (colonoscopy quality metric)optionaltrue

Use it for

  • photodocumenta…66%66 of 100 rowsmean biopsies taken b…0.42excell…1.3good2.3fair

    A healthcare dashboard

    The photodocumentation rate, biopsies_taken by bowel_preparation_quality and a breakdown of polyp_location. Excel, Power BI or Tableau.

  • Why do the 15 fair rows have a mean biopsies_taken of 2.3?

    A root-cause class exercise

    Hand out the rows and one question. The answer is in the data, not in the brief.

  • A software demo

    Believable reports with patient_id, procedure_date and procedure_type to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 21 columns, your size and your rules. See 20 rows before you pay.

Preview 20 rows free

1,000 rows: $1.99 · 10,000: $12.99One-time. No subscription. All prices

This dataset100 rows21 columns
Yours1,000 rows21 columnspolyp_location: UK only

blueprint · endoscopy-and-colonoscopy-findings

Behind this dataset

Same schema. As many rows as you need.

These 100 rows came out of a blueprint — 21 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
  • Procedure ID and accession number unique
  • Procedure: EGD (upper endoscopy), colonoscopy, flexible sigmoidoscopy
  • Indication: screening, surveillance, symptoms, follow-up
  • Bowel prep quality for colonoscopy (excellent, good, fair, poor)
  • Cecal intubation achieved (yes/no) - quality metric
  • Withdrawal time documented (minimum 6 minutes)
  • Findings: polyps, diverticula, inflammation, masses, ulcers
  • Polyp size, location, morphology (pedunculated, sessile, flat)
Rows
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
endoscopy-and-colonoscopy-findings

What should your data show?

Preview 20 rows free
No signup. No card.