Texas Health Care Information Collection
Center for Health Statistics
Attention
THCIC Stakeholders, Health Data Researchers and Healthcare Facilities,
In response to Coronavirus (COVID-19) emergency requirements THCIC
staff will have limited access to providing responses and data requests.
|
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. Chapter 108 may be viewed by clicking here.
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 third quarter 2020. The fourth quarter 2020 is tentatively scheduled to be released in September 2021.
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.
The 2020 PUDF contains data on hospital inpatient discharges and includes:
Inpatient PUDF 2020 Data
| First quarter, 702 hospitals |
Base data: 774,322 records |
Charges data: 13,507,546 records |
| Second quarter, 687 hospitals | Base data: 672,387 records
| Charges data: 11,633,725 records |
| Third quarter, 688 hospitals | Base data: 740,900 records | Charges data: 15,601,963 records |
User Manuals (PDF format):
Reporting Status (PDF format)
Statistics on hospital discharges. (Excel format)
Comments submitted by hospitals about their data. (PDF format)
- 2020 First Quarter (1.01 MB), Second Quarter (429 KB), Third Quarter (450 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)
- 2016 First Quarter (160 KB), Second Quarter (464 KB), Third Quarter (483 KB) and Fourth Quarter (340 KB)
Texas Health Data
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 2006, 2007, 2008, 2009, 2010, 2011, 2012, 2013, 2014 and 2015, in fixed-length and tab-delimited format, are available for free 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
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.
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.
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).
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).
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.
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.
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.
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
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 2003 through December 31, 2020. This list is updated annually. (February 12, 2021)
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.