Sample Data.xlsx

XLSX spreadsheet 23 KB Posted

Attached to
Historical Medical Claims Data Analysis
Solicitation number
15BCMS26Q70000005
Issued by

About this file

This file is a sample dataset in spreadsheet format containing historical medical claims data. The dataset includes two claim records from WVU Hospitals for a patient treated on January 10, 2020, under payor plan VB230081 with FCI McDowell in Welch, West Virginia. The records contain comprehensive claim information including patient demographics (with redacted personally identifiable information), clinical details with multiple diagnostic codes (D57.1, H36, H43.11, H53.002, Z87.891), procedure codes (G0463 for hospital outpatient clinic visit assessment and 92250 for fundus photography), and billing information with facility NPI 1841271459 and TIN 550643304. The claim line items reference revenue codes 510 and 920, place of service code 73 and 532 respectively, with service units and charge amounts documented.

The dataset structure includes standard healthcare claims data fields such as claim type, claim ID, patient identifiers, insurance authorization information, admit and discharge details, provider NPIs and TINs, and procedural descriptions with HCPCS modifiers. This sample data appears designed to demonstrate the format and content requirements for the Department of Justice Bureau of Prisons solicitation 15BCMS26Q70000005 for Historical Medical Claims Data Analysis, serving as a template or example of the claims data that contractors would be expected to process or analyze under that federal contract opportunity.

View the file

Other files

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

Sheet1

partner_nameclaim_typeclaim_idclaim_line_numberpatient_idpatient_first_namepatient_last_namepatient_date_of_birthpatient_genderInsured_idauthorization_numberpayor_plan_namepayor_address_citypayor_address_statepayor_address_zipdiagnostic_code_1diagnostic_code_2diagnostic_code_3diagnostic_code_4diagnostic_code_5diagnostic_code_6diagnostic_code_7diagnostic_code_8diagnostic_code_9diagnostic_code_10diagnostic_code_11diagnostic_code_12diagnostic_code_13diagnostic_code_14diagnostic_code_15diagnostic_code_16diagnostic_code_17diagnostic_code_18diagnostic_code_19diagnostic_code_20admit_diagnostic_code_1type_of_bill_codeadmit_type_codeadmit_source_codeadmit_datestatement_cover_period_fromstatement_cover_period_throughservice_start_dateservice_end_datedischarge_status_coderevenue_codeprocedure_codeprocedure_descriptionhcpcs_modifier_1hcpcs_modifier_2
REDACTEDI145078611REDACTEDREDACTEDREDACTEDREDACTEDREDACTEDREDACTEDVB230081FCI McDowellWelchWest Virginia24801D57.1H36H43.11H53.002Z87.891131321/10/201/10/201/10/201/10/201510G0463Hospital outpatient clinic visit for assessment and management of a patient
REDACTEDI145078612REDACTEDREDACTEDREDACTEDREDACTEDREDACTEDREDACTEDVB230081FCI McDowellWelchWest Virginia24801D57.1H36H43.11H53.002Z87.891131321/10/201/10/201/10/201/10/20192092250Fundus photography with interpretation and report

This is the start of the file's text. The full file is on GovTribe.

File details come from the government source that posted it. Updated .