Texas Inpatient Public Use Data File (PUDF)
Texas Health Care Information Collection - Center for Health Statistics
In accordance with Health and Safety Code, Section 108.012(b),"the council (department) may charge a person requesting public use or provider quality data a fee for the data. The fees may reflect the quantity of information provided and the expense incurred by the council in collecting and providing the data and shall be set at a level that will raise revenue sufficient for the operation of the council (department's program). The council (department) may not charge a fee for providing public use data to another Texas state agency.
View Chapter 108.
The Texas Public Use Data File (PUDF) contains data on discharges from Texas hospitals. Data are available by quarter beginning with data for 1999. The PUDF has been released through first quarter 2024. The second quarter 2024 is tentatively scheduled to be released in March 2025.
Purchasing the PUDF requires a completed Order Form, which includes a Data Use Agreement. Information on the data fields is included in the user manuals available below. The data files for data released after 2004 include 255 data fields in a base data file and 13 data fields in a detailed charges file. Data files for years before 2004 include only 205 data fields. The user manual for fourth quarter 2015 is only for this quarter, User Manual, 4Q2015. The user manual for the first through third quarter 2015 data is in User Manual, 2015. If you have trouble viewing any of the documents below, please contact the HHS Accessibility Office, at Accessibility@hhsc.state.tx.us.
Purchasing the Inpatient PUDF requires a completed Order Form, which includes a Data Use Agreement.
- Data Summary for Inpatient (IP), Outpatient (OP) and Emergency Department
- Inpatient PUDF Order Form (PDF format, 385 KB)
2024 PUDF Hospital Discharges | ||
---|---|---|
First quarter, 708 hospitals | Base data: 820,346 records | Charges data: 15,982,731 records |
2023 PUDF Hospital Discharges | ||
---|---|---|
First quarter, 696 hospitals | Base data: 790,235 records | Charges data: 15,178,746 records |
Second quarter, 700 hospitals | Base data: 792,582 records | Charges data: 15,084,398 records |
Third quarter, 698 hospitals | Base data: 816,350 records | Charges data: 15,425,058 records |
Fourth quarter, 707 hospitals | Base data: 821,314 records | Charges data: 15,684,199 records |
2022 Outpatient Surgical and radiological procedures | ||
---|---|---|
First quarter, 696 hospitals | Base data: 742,698 records | Charges data: 14,180,835 records |
Second quarter, 699 hospitals | Base data: 755,432 records | Charges data: 14,098,476 records |
Third quarter, 697 hospitals | Base data: 792,667 records | Charges data: 14,670,366 records |
Fourth quarter, 699 hospitals | Base data: 799,712 records | Charges data: 15,098,417 records |
User Manuals (PDF format)
- User Manual, 2024 (1.6 MB)
- User Manual, 2023 (1.2 MB)
- User Manual, 2022 (1.70 MB)
- User Manual, 2021 (1.64 MB)
- User Manual, 2020 (1.60 MB)
- User Manual, 2019 (2.07 MB)
- User Manual, 2018 (1.98 MB)
- User Manual, 2017 (1.99 MB)
Reporting Status (PDF format)
- 2024 (1.3 MB)
- 2023 (880 KB)
- 2022 (1.30 MB)
- 2021 (1.04 MB)
- 2020 (1.26 MB)
- 2019 (1.35 MB)
- 2018 (1.78 MB)
- 2017 (1.81 MB)
- 2016 (879 KB)
- 2015 (351 KB)
Statistics on Hospital Discharges (Excel format)
- 2023 (59 KB)
- 2022 (53 KB)
- 2021 (64 KB)
- 2020 (52 KB)
- 2019 (56 KB)
- 2018 (56 KB)
- 2017 (56 KB)
- 2016 (59 KB)
- 2015 (155 KB)
- 2014 (140 KB)
- 2013 (54 KB)
- 2012 (118 KB)
- 2011 (116 KB)
- 2010 (105 KB)
- 2009 (132 KB)
- 2008 (134 KB)
- 2007 (104 KB)
- 2006 (101 KB)
- 2005 (97 KB)
Comments Submitted by Hospitals about Their Data (PDF format)
- 2024 First Quarter (180 KB)
- 2023 First Quarter (207 KB), Second Quarter (208 KB), Third Quarter (205 KB) and Fourth Quarter (171 KB)
- 2022 First Quarter (619 KB), Second Quarter (640 KB), Third Quarter (615 KB) and Fourth Quarter (613 KB)
- 2021 First Quarter (450 KB), Second Quarter (332 KB), Third Quarter (493 KB) and Fourth Quarter (577 KB)
- 2020 First Quarter (1.01 MB), Second Quarter (429 KB), Third Quarter (450 KB) and Fourth Quarter (324 KB)
- 2019 First Quarter (398 KB), Second Quarter (395 KB), Third Quarter (363 KB) and Fourth Quarter (449 KB)
- 2018 First Quarter (379 KB), Second Quarter (598 KB), Third Quarter (534 KB) and Fourth Quarter (340 KB)
- 2017 First Quarter (426 KB), Second Quarter (502 KB), Third Quarter (497 KB) and Fourth Quarter (340 KB)
Texas Health Data
Texas Health Data is an interactive public data system that allows you to query THCIC PUDF and statistical reports for Texas healthcare utilization and quality measures.
Free Data Download
The Public Use Data File (PUDF) for 2005, 2006, 2007, 2008, 2009, 2010, 2011, 2012, 2013, 2014, 2015, 2016, 2017, and 2018, in fixed-length and tab-delimited format, are available for free download. The data is available for free download by going to the inpatient free data page. Read the licensee agreement. By clicking agree you agree to the conditions and the data will be available for download
Technical Update
Outpatient data records (Type of Bill is 131) from four different facilities were submitted, certified and included in the inpatient dataset for the second quarter 2020.
The list of those Record IDs of outpatient dataset that were included in the inpatient dataset can be found at the link below.
An update has been released for the third quarter 2019 following files: “PUDF_base1_3Q2019.txt” and PUDF_base1_3Q2019_tab.txt”; “PUDF_base2_3Q2019.txt” and “PUDF_base2_3Q2019_tab.txt” and the "PUDF_charges_3Q2019.txt" and PUDF_charges_3Q2019_tab.txt files. Eleven facilities submitted incorrect charge data, where the numbers reported were 100 times higher. The update contains the correct reporting of those facilities charge data. The following Excel Spreadsheet contains three tabs representing the three PUDF files: Charges, Base 1 and Base 2.
The header of each tab contains the Record ID and the applicable Data Element Title that needs to be replaced in the associated file. Released August 14, 2020
Charges Tab: RECORD_ID; UNIT_RATE; and CHRGS_LINE_ITEM
Base1 Tab: RECORD_ID; TOTAL_CHARGES; and TOTAL_CHARGES_ACCOMM
Base2 Tab: RECORD_ID; and SEMI_PRIVATE_AMOUNT
An update has been released for the first quarter 2019 “Facility_type1q2019.txt” and “Facility_type1q2019_tab.txt” files. A number of facilities that submitted data were not included in those files. The update contains the correct reporting of the facilities and facility type information for the 1Q2019 Inpatient Facility Type files. All other data files were correctly reported and in the appropriate data files. Released February 10, 2020
- First quarter, 2019 - Fixed Length Text Files and Tab-Delimited Text Files
An update has been released for the first quarter 2017 Inpatient /Outpatient data dictionary. The previous released version in the 1Q2017 CD/DVD discs (Last Updated: December, 2017) has been found that the coding scheme for the data element PAT_STATUS was misaligned. The updated data dictionary contains the correct code scheme for PAT_STATUS.
- User Manual, 1Q2017 (1.97 MB)
An update has been released for the third quarter 2016 Inpatient Status Reports. The facilities listed in the update were assigned an erroneous status. The update contains the correct reporting status for each facility.
- Third quarter, 2016 - Update in Excel form
An update has been released for the third quarter 2012 file. The records identified in the update are duplications of Outpatient claims and should be deleted from your copy of the Quarter 3 2012 Inpatient Public Use Data File (PUDF).
- Third quarter, 2012 - Update in Excel form
Fourth quarter 2011 Inpatient computer disks (4Q2011 Inpatient CD) did not include the Facility Type files. December 17, 2012.
- Fourth quarter, 2011 - Fixed Length Text Files and Tab-Delimited Text Files
Records for additional discharges in Quarter 2, 2010 have been found to be duplicated in the data for Quarter 3, 2010. The following update includes the Record ID for those duplicate records that should be deleted from your copy of the Quarter 3 Public Use Data File (PUDF). September 7, 2011.
- Third quarter, 2010 - Update in Excel format
An update has been released for the third quarter 2010 charges file. The records identified in the update do not include charges and should be deleted from your copy of the Quarter 3 2010 Public Use Data File (PUDF).
-
Third quarter, 2010 - Update in Excel format
Records for additional discharges in Quarter 1, 2010 have been found to be duplicated in the data for Quarter 2, 2010. The following update includes the Record ID for those duplicate records that should be deleted from your copy of the Quarter 2 Public Use Data File (PUDF). September 7, 2011.
- Second quarter, 2010 - Update in Excel format
An update has been released for the second quarter 2010 charges file. The records identified in the update do not include charges and should be deleted from your copy of the Quarter 2 2010 Public Use Data File (PUDF).
- Second quarter, 2010 - Update in Excel format
Charges records for some discharges were inadvertently omitted from the Second quarter 2010 PUDF. These records should be added to your copy of the Quarter 2 2010 Public Use Data File (PUDF).
- Second quarter, 2010 - Charges file update in fixed-length format and tab-delimited format
Records for additional discharges in Quarter 4, 2009 have been found to be duplicated in the data for Quarter 1, 2010. The following update includes the Record ID for those duplicate records that should be deleted from your copy of the Quarter 1 Public Use Data File (PUDF). August 19, 2011.
-
First quarter, 2010 - Update in Excel format
Records for some discharges in Quarter 4, 2009 were inadvertently duplicated in the data for Quarter 1, 2010. The following update includes the Record ID for those duplicate records that should be deleted from your copy of the Quarter 1 Public Use Data File (PUDF). May 18, 2011.
- First quarter, 2010 - Update in Excel format
Records for some discharges in Quarter 1, 2009 were inadvertently duplicated in the data for Quarter 2, 2009. The following update includes the Record ID for those duplicate records that should be deleted from your copy of the Quarter 2 Public Use Data File (PUDF). September 9, 2010.
- Second quarter, 2009 - Update in Excel format
Updates to correct missing uniform physician identifiers have been released for the second, third and fourth quarter 2007 Public Use Data Files (PUDF) and the first, second and third quarter 2008 PUDF. The updates include uniform identifiers for the Attending Physician and Operating Physician fields, ATTENDING_PHYSICIAN_UNIF_ID and OPERATING_PHYSICIAN_UNIF_ID, that were set to missing in the original files. Use the update to correct your copy of the PUDF files. For more information please contact THCIC Staff.
- Second quarter, 2007 Fixed-length format, Tab-delimited format
- Third quarter, 2007 Fixed-length format, Tab-delimited format
- Fourth quarter, 2007 Fixed-length format, Tab-delimited format
- First quarter, 2008 Fixed-length format, Tab-delimited format
- Second quarter, 2008 Fixed-length format, Tab-delimited format
- Third quarter, 2008 Fixed-length format, Tab-delimited format
An update has been released for the second quarter 2006 Public Use Data File (PUDF). It updates county codes, ZIP codes and Public Health Regions that were set to missing in the original file. Use the update to correct your copy of the PUDF. For more information please contact THCIC Staff.
- Second quarter, 2006 Fixed-length format, Tab-delimited format
An update has been released for the third quarter 2004 Public Use Data File (PUDF). The update includes those records for which the 3M APR-DRG grouping was corrected. This correction was necessitated because some records were not grouped with Version 20 of the APR-DRG Grouper. The files include the Record ID and four additional data elements: APR-DRG code, APR-MDC, Severity of Illness, and Risk of Mortality. Use the update to correct your copy of the PUDF.
- Third quarter, 2004 Fixed-length format, Tab-delimited format
Updates have been released for the 2003 PUDF. The updates include Patient Status codes for those records where the patient status was incorrectly indicated as invalid. The files contain the 12-digit Encounter ID and the 2-digit Patient Status Code. Use the files to update your copy of the PUDF. September 23, 2005
- First quarter, 2003 Fixed-length format, Tab-delimited format
- Second quarter, 2003 Fixed-length format, Tab-delimited format
- Third quarter, 2003 Fixed-length format, Tab-delimited format
- Fourth quarter, 2003 Fixed-length format, Tab-delimited format
The User Manuals for 1999, 2000 and 2001 have been updated to correctly document the data field ADMIT WEEKDAY. The values for this data field should be interpreted as:
- Monday
- Tuesday
- Wednesday
- Thursday
- Friday
- Saturday
- Sunday
Data Purchasers
The list of organizations includes a variety of organizations that use the data for analysis. The listing includes recipients from calendar year 2022 through calendar year 2023. This list is updated annually. (February 7, 2024)
Download Adobe Reader to view PDF files.
If you have suggestions or comments, please submit them to THCIC.
External links to other sites are intended to be informational and do not have the endorsement of the Texas Department of State Health Services. These sites may also not be accessible to people with disabilities.