Medical Coding and Audit Results

This dataset provides a comprehensive view of professional medical coding assignments, audit results, coding accuracy, DRG and HCC validation, and compliance with official guidelines. It is designed for healthcare quality assurance, reimbursement optimization, and regulatory compliance analytics, supporting both operational and strategic decision-making.

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

Medical coding quality assurance and audit tracking

Sample rows

preview · 8 of 100 rows · all 19 columns
assignment_idstringdrg_validation_statusstringcoding_accuracy_scorefloatguideline_compliancebooleansecondary_diagnosis_codesstringpatient_idstringencounter_datedatecoder_idstringcoding_statusstringprimary_diagnosis_codestringprocedure_codesstringdrg_codestringhcc_codesstringaudit_idstringaudit_datedateauditor_idstringreimbursement_amountfloataudit_findingsstringcoding_notesstring
CA10001valid0.98trueI10P200012023-07-11CODER05completedE11.999213291HCC19,HCC85blankblankblank150.67blankStandard outpatient visit for diabetes follow-up.
CA10002blankblankfalseblankP200022023-07-12CODER07pendingJ45.909blankblankblankblankblankblank0blankAwaiting physician documentation for asthma severity.
CA10003corrected0.85trueE78.5,I10P200032023-07-13CODER02auditedI21.392928,93010246HCC85AUD300012023-07-18AUDITOR028700.5DRG corrected due to additional comorbidity code.Acute MI with stent placement.
CA10004blank0.92trueblankP200042023-07-14CODER03completedN39.087086blankblankblankblankblank70blankUTI confirmed by urine culture.
CA10005valid0.95trueE11.9P200052023-07-15CODER01auditedK21.943239377HCC19AUD300022023-07-19AUDITOR031200Procedure code validated, no discrepancies.Endoscopy for GERD, diabetic patient.
CA10006blank0.11falseblankP200062023-07-16CODER05rejectedR07.9blankblankblankblankblankblank0blankInsufficient documentation for chest pain coding.
CA10007blank0.96trueblankP200072023-07-17CODER06completedM54.597110,97112blankblankblankblankblank230.89blankPhysical therapy for low back pain.
CA10008blankblankfalseblankP200082023-07-18CODER08pendingF41.9blankblankblankblankblankblank0blankAwaiting psychologist documentation for anxiety disorder.

What the 100 rows show

from the 100-row sample

Valid (drg validation status) stands out: mean coding_accuracy_score is 0.95, against 0.79 for the rest.

  • 68%guideline_compliance = true
  • 0.94median coding_accuracy_score
  • 4coding statuses
  • 13hcc codeses
  • 22coders
  • 182.6median reimbursement_amount
Mean coding_accuracy_score by drg_validation_status41 rows
00.510.95valid28 rows0.64invalid3 rows0.83corrected10 rows
coding_accuracy_score84 rows, in bands of 0.1
0306034100123125800.51coding_accuracy_score →

Median 0.94, from 0.0 to 0.99.

secondary_diagnosis_codes37 rows with a value · 63 left blank
  1. I1013
  2. E11.9,I104
  3. E78.5,I102
  4. E11.92
  5. R50.92
  6. I12.9,E11.222
  7. Z87.811
  8. J44.91
  9. F41.91
  10. F32.91
19 columns by typefrom the column list below
  • string 14
  • float 2
  • date 2
  • boolean 1

Columns

19 columns in four groups
blueprint · 19 columns
columntypedescriptionexample
Text 14 columns
assignment_idstringUnique identifier for each coding assignment or case.uniqueCA10001
patient_idstringUnique identifier for the patient associated with the coding assignment.P20001
coder_idstringUnique identifier for the professional medical coder.CODER05
coding_statusstringStatus of the coding assignment (e.g., completed, pending, audited).completed · pending · audited · rejectedcompleted
primary_diagnosis_codestringPrimary ICD or other diagnosis code assigned for the encounter.E11.9
secondary_diagnosis_codesstringComma-separated list of secondary diagnosis codes assigned.optionalI10
procedure_codesstringComma-separated list of procedure codes assigned for the encounter.optional99213
drg_codestringDiagnosis Related Group (DRG) code assigned for reimbursement and validation.optional291
drg_validation_statusstringStatus of DRG validation (e.g., valid, invalid, corrected).valid · invalid · corrected · not_applicable · optionalvalid
hcc_codesstringComma-separated list of Hierarchical Condition Category (HCC) codes assigned.optionalHCC19,HCC85
audit_idstringUnique identifier for the audit performed on the coding assignment.optionalAUD30001
auditor_idstringUnique identifier for the auditor who performed the audit.optionalAUDITOR02
audit_findingsstringDetailed findings from the audit, including discrepancies and recommendations.optionalDRG corrected due to addi…
coding_notesstringAdditional notes or comments from the coder regarding the assignment.optionalInsomnia, no procedures.
Numbers 2 columns
coding_accuracy_scorefloatAccuracy score for the coding assignment, typically between 0 and 1.0 to 1 · optional0.98
reimbursement_amountfloatAmount reimbursed for the coded encounter.0 or more · optional150.67
Dates and times 2 columns
encounter_datedateDate of the medical encounter being coded.2023-07-11
audit_datedateDate when the coding audit was performed.optional2023-07-18
True or false 1 column
guideline_compliancebooleanIndicates if the coding assignment complies with official coding guidelines.true

Use it for

  • guideline comp…68%68 of 100 rowsmean coding accuracy …0.95valid0.64invalid0.83correc…

    A healthcare dashboard

    The guideline_compliance rate, coding_accuracy_score by drg_validation_status and a breakdown of secondary_diagnosis_codes. Excel, Power BI or Tableau.

  • Why do the 28 valid rows have a mean coding_accuracy_score of 0.95?

    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 assignments with patient_id, encounter_date and coder_id to fill a screen in front of a buyer.

Not quite right?

Make it yours.

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

Preview 20 rows free

10,000 rows of yours: $12.99One-time. No subscription. All prices

This dataset100 rows19 columns
Yours10,000 rows19 columns

blueprint · medical-coding-and-audit-results

Behind this dataset

Same schema. As many rows as you need.

These 100 rows came out of a blueprint — 19 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
  • Coded by certified coder (CPC, CCS, RHIA, RHIT)
  • ICD-10-CM diagnosis codes to highest specificity
  • ICD-10-PCS procedure codes for inpatient (7-character)
  • CPT and HCPCS codes with correct modifiers
  • Principal diagnosis selection for inpatient
  • DRG assignment and validation
  • HCC (Hierarchical Condition Category) for RAF score
  • Coding accuracy rate from audits
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
medical-coding-and-audit-results

What should your data show?

Preview 20 rows free
No signup. No card.