Loading...
Loading...
Available on 1 platform
Sign in to view source links and access this dataset
Five years of institutional medical billing data for injured employees in Texas, maintained by the Texas Department of Insurance, Division of Workers' Compensation. It contains header information for bills submitted by hospitals and medical facilities on CMS-1450 forms, grouping individual line items for services. The dataset includes charges, payments, and treatment details for claims from the last five years.
Requires joining with a separate detail dataset using `Bill ID` for complete bill analysis. A specific data dictionary file is needed to interpret coded fields. License terms are not specified in the provided information.
| # | Column Name |
|---|---|
| 1 | Rendering Bill Provider Primary Specialty Code |
| 2 | Referring Provider Gate Keeper Indicator |
| 3 | Billing Provider FEIN |
| 4 | Employee Marital Status Code |
| 5 | Employer Physical Country Code |
| 6 | Provider Agreement Code |
| 7 | Billing Provider State License Number |
| 8 | Billing Provider National Provider ID |
| 9 | Fifth ICD-9CM or ICD-10CM Diagnosis Code |
| 10 | Bill Type |
| 11 | Referring Provider FEIN |
| 12 | Place of Service Bill Code |
| 13 | Bill ID |
| 14 | Bill Frequency Type Code |
| 15 | Provider Signature On File Indicator |
| 16 | Facility Medicare Number |
| 17 | Release of Information Code |
| 18 | Employee Mailing Postal Code |
| 19 | Total Charge Per Bill |
| 20 | Billing Provider First Name |
| 21 | Second ICD-9CM or ICD-10CM Diagnosis Code |
| 22 | Referring Provider State License Number |
| 23 | ICD-9CM or ICD-10CM Principal Procedure Code |
| 24 | Fourth ICD-9CM or ICD-10CM Procedure Code |
| 25 | Managed Care Organization Identification |
| 26 | Billing Provider Secondary Address |
| 27 | Contract Type Code |
| 28 | Facility Secondary Address |
| 29 | Billing Provider Unique Bill Identification Number |
| 30 | Admission Hour |
| 31 | Principal Procedure Date |
| 32 | Referring Provider Middle Name Initial |
| 33 | Facility FEIN |
| 34 | Employee Mailing Country Code |
| 35 | Transaction Tracking Number |
| 36 | Billing Type Code |
| 37 | Admission Date |
| 38 | Referring Provider National Provider ID |
| 39 | Referring Provider Last Name or Group |
| 40 | Rendering Bill Provider National Provider ID |
| 41 | Rendering Bill Provider State License Number |
| 42 | Rendering Bill Provider Postal Code |
| 43 | Rendering Bill Provider State Code |
| 44 | Rendering Bill Provider City |
| 45 | Rendering Bill Provider Secondary Address |
| 46 | Rendering Bill Provider Primary Address |
| 47 | Rendering Bill Provider First Name |
| 48 | Rendering Bill Provider Last Name or Group |
| 49 | Billing Provider Postal Code |
| 50 | Billing Provider State Code |
| 51 | Billing Provider City |
| 52 | Billing Provider Primary Address |
| 53 | Billing Provider Primary Specialty Code |
| 54 | Billing Provider Suffix |
| 55 | Billing Provider Last Name or Group |
| 56 | Facility National Provider ID |
| 57 | Facility Postal Code |
| 58 | Facility State Code |
| 59 | Facility Primary Address |
| 60 | Fourth Procedure Date |
| 61 | Third Procedure Date |
| 62 | Second Procedure Date |
| 63 | First Procedure Date |
| 64 | Third ICD-9CM or ICD-10CM Procedure Code |
| 65 | Second ICD-9CM or ICD-10CM Procedure Code |
| 66 | First ICD-9CM or ICD-10CM Procedure Code |
| 67 | Admitting Diagnosis Code |
| 68 | Principal Diagnosis Code |
| 69 | Referring Provider First Name |
| 70 | Fourth ICD-9CM or ICD-10CM Diagnosis Code |
| 71 | Third ICD-9CM or ICD-10CM Diagnosis Code |
| 72 | First ICD-9CM or ICD-10CM Diagnosis Code |
| 73 | Date Insurer Paid Bill |
| 74 | Date of Bill |
| 75 | Service Bill To Date |
| 76 | Billing Provider Medicare Number |
| 77 | Service Bill From Date |
| 78 | Date Insurer Received Bill |
| 79 | Diagnosis Related Group Code |
| 80 | Rendering Bill Provider FEIN |
| 81 | Discharge Hour |
| 82 | Discharge Date |
| 83 | Facility Code |
| 84 | Employee Date of Injury |
| 85 | Claim Administrator Claim Number |
| 86 | Employee Date of Birth |
| 87 | Employee Mailing State Code |
| 88 | Employer Physical Postal Code |
| 89 | Employer Physical State Code |
| 90 | Employer FEIN |
| 91 | Claim Administrator Name |
| 92 | Claim Administrator FEIN |
| 93 | Insurer Postal Code |
| 94 | Insurer FEIN |
| 95 | Reporting Period End Date |
| 96 | Reporting Period Start Date |
| 97 | Treatment Authorization Number |
| 98 | Facility Country Code |
| 99 | Unique Bill ID Number |
| 100 | Bill Selection Date |
| 101 | Billing Provider Country Code |
| 102 | Billing Format Code |
| 103 | Transaction Set Purpose Code |
| 104 | Billing Provider Middle Name Initial |
| 105 | Employee Mailing City |
| 106 | Rendering Bill Provider Middle Name Initial |
| 107 | Facility Name |
| 108 | Referring Provider Medicare Number |
| 109 | Employee Gender Code |
| 110 | Referring Provider Specialty License Number |
| 111 | Referring Provider Suffix |
| 112 | Bill Submission Reason Code |
| 113 | Rendering Bill Provider Country Code |
| 114 | Rendering Bill Provider Gate Keeper Indicator |
| 115 | Employer Physical City |
| 116 | Rendering Bill Provider Suffix |
| 117 | Claim Administrator Postal Code |
| 118 | Patient Account Number |
| 119 | Facility State License Number |
| 120 | Billing Provider Gate Keeper Indicator |
| 121 | Total Amount Paid Per Bill |
| 122 | Facility City |
| 123 | Admission Type Code |