S T A T E  O F  V E R M O N T
Department of Banking, Insurance, Securities
& Health Care Administration (BISHCA)
89 Main St.  Montpelier, VT 05620-3101    Main Phone:  802-828-3301  
Paulette J. Thabault, Commissioner

    BISHCA Home   I  Banking Division   I   Insurance Division    I   Securities Division   I  Health Care Administration  I  Captive Insurance Division  I        Search

 


Vermont Uniform Hospital Discharge Data Set (VUHDDS):

BISHCA provides the PUBLIC USE FILES derived from the Vermont Uniform Hospital Discharge Set.  Data users can generate their own reports about the use of the Vermont hospitals by residents and non-residents.  There are no data for Vermonters using hospitals outside of Vermont. Information that could potentially identify individuals has been removed or modified to protect the privacy of individuals.

Jump Links for this page:
Contacts for Questions/Problems
Download Vermont Public Use Files for 2008
Download Vermont Public Use Files for 2007
Download Vermont Public Use Files for 2006
Download Vermont Revenue Code File 2006, 2007 and 2008
Download Vermont Public Use Files for 2005 and Earlier
Links to Relevant Websites

 FAQ's: Overview and Notes about Access to Files
 Contacts for Questions/Problems

  • If you have a problem downloading the Vermont Public Use Files:
    Please contact Lucas Herring at the Vermont Department of Banking, Insurance, Securities & Health Care Administration.
     

  • If you have questions about the content and use of the Vermont Uniform Hospital Discharge Data Set, contact Joan Mongeon at the Vermont Department of Health.
     

  • If you have a question about accessing non-public data elements, contact
    Dian Kahn at the Vermont Department of Banking, Insurance, Securities &
    Health Care Administration.
     

 Downloading Vermont Public Use Files 2008

·        Field Properties: This Excel document includes the field properties to use with the 2008 Vermont Inpatient, Outpatient and Emergency Department data as well as all of the underlying code tables. You can use this to set up your tables prior to downloading or to reduce the size of your tables after downloading them. This has been updated to reflect the PPX and PPX grouper fields from the 2007 Vermont Public Use Files.  

·        Code Tables: This Excel document lists all of the data to be listed in the 2008 code tables. Once you have created your tables, this data can be easily inserted into them. The DRG field has a change as of October 1st, 2008 with Federal regulation to change to the use of MS-DRG codes.  Both codes are given in the Code Tables along with the new Admission Quarter and Discharge Quarter fields introduced in 2007. Note that the ID field is highlighted in yellow in the Excel file. This is because the ID variable is not in the data files, but instead represents the unique ID field that you may want to add to the downloaded data. You may want to add the ID field to define your data set if you are combining multiple text files into one master file.

Inpatient, Outpatient and Emergency Department Data
The following text files represent data for each collection year. The Inpatient Data and Outpatient Data files combine to make the complete data set for each year. These files are separated below for easier downloading and because they are used individually in many cases. Data is extracted from both the Inpatient and Outpatient data to create a file based only on records relating to the Emergency Department, which is the third data file listed for each year.  The 2008 data does not include data from the Veterans Affairs Medical Center, which is included in the 2005 and earlier files. 

The fourth file is the Expanded Outpatient File, which was collected for the first time in 2006.  The submission of "expanded" outpatient records by Vermont hospital for calendar year 2006, 2007 and 2008 with principal procedures outside the ICD-9-CM range of 0.00-86.99 was incomplete and inconsistent across the hospitals. For CY 2007, the submission of expanded outpatient data Vermont hospitals filed was not a complete set for the entire year. BISHCA is working with the Vermont hospitals to ensure a complete and consistent filing of the expanded outpatient data set in future reporting years.

Text files are .zip formatted for greater downloading ease.  Zipped sizes shown.
2008 Public Use Files

2008 Vermont Outpatient Data

 (10,973 kb)
2008 Vermont Inpatient Data (2,663 kb)
2008 Emergency Department Data (8,173 kb)
2008 Vermont Expanded Outpatient Data (32,042 kb)

 

 Downloading Vermont Public Use Files 2007

·        Field Properties: This Excel document includes the field properties to use with the 2007 Vermont Inpatient, Outpatient and Emergency Department data as well as all of the underlying code tables. You can use this to set up your tables prior to downloading or to reduce the size of your tables after downloading them. This has been updated to reflect the addition of Admission Quarter, Discharge Quarter, and Unadjusted Total Charges fields since the 2006 Vermont Public Use Files.  

·        Code Tables: This Excel document lists all of the data to be listed in the 2007 code tables. Once you have created your tables, this data can be easily inserted into them. The DRG field has a change as of October 1st, 2007 with Federal regulation to change to the use of MS-DRG codes.  Both codes are given in the Code Tables along with the new Admission Quarter and Discharge Quarter fields. Note that the ID field is highlighted in yellow in the Excel file. This is because the ID variable is not in the data files, but instead represents the unique ID field that you may want to add to the downloaded data. You may want to add the ID field to define your data set if you are combining multiple text files into one master file.

Inpatient, Outpatient and Emergency Department Data
The following text files represent data for each collection year. The Inpatient Data and Outpatient Data files combine to make the complete data set for each year. These files are separated below for easier downloading and because they are used individually in many cases. Data is extracted from both the Inpatient and Outpatient data to create a file based only on records relating to the Emergency Department, which is the third data file listed for each year.  The 2007 data does not include data from the Veterans Affairs Medical Center, which is included in the 2005 and earlier files. 

The fourth file is the Expanded Outpatient File, which was collected for the first time in 2006.  The submission of "expanded" outpatient records by Vermont hospital for calendar year 2006 and 2007 with principal procedures outside the ICD-9-CM range of 0.00-86.99 was incomplete and inconsistent across the hospitals. For CY 2007, the submission of expanded outpatient data Vermont hospitals filed was not a complete set for the entire year. BISHCA is working with the Vermont hospitals to ensure a complete and consistent filing of the expanded outpatient data set in future reporting years.

Text files are .zip formatted for greater downloading ease.  Zipped sizes shown.
2007 Public Use Files

2007 Vermont Outpatient Data

 (2,525 kb)
2007 Vermont Inpatient Data (10,507 kb)
2007 Emergency Department Data (7,759 kb)
2007 Vermont Expanded Outpatient Data (29,340 kb)


 

 Downloading Vermont Public Use Files 2006

  • Field Properties: This Excel document includes the field properties to use with the 2006 Vermont Inpatient, Outpatient and Emergency Department data as well as all of the underlying code tables. You can use this to set up your tables prior to downloading or to reduce the size of your tables after downloading them. This has been updated to reflect the removal of one code (Patient Type) and the addition of six others since the 2005 and earlier Vermont Public Use Files.
     

  • Code Tables: This Excel document lists all of the data to be listed in the code tables. Once you have created your tables, this data can be easily inserted into them. Note that the ID field is highlighted in yellow in the Excel file. This is because the ID variable is not in the data files, but instead represents the unique ID field that you may want to add to the downloaded data. You may want to add the ID field to define your data set if you are combining multiple text files into one master file. This file has been updated for the 2006 data as well.

    Inpatient, Outpatient and Emergency Department Data
    The following text files represent data for each collection year. The Inpatient Data and Outpatient Data files combine to make the complete data set for each year. These files are separated below for easier downloading and because they are used individually in many cases. Data is extracted from both the Inpatient and Outpatient data to create a file based only on records relating to the Emergency Department, which is the third data file listed for each year.  The 2006 data does not include data from the Veterans Affairs Medical Center, which is included in the 2005 and earlier files. 

    The fourth file is the Expanded Outpatient File, which was collected for the first time in 2006.  The submission of "expanded" outpatient records by Vermont hospital for calendar year 2006 with principal procedures outside the ICD-9-CM range of 0.00-86.99 was incomplete and inconsistent across the hospitals. For CY 2006, the submission of expanded outpatient data was voluntary and not every Vermont hospital filed the complete set for the entire year. BISHCA is working with the Vermont hospitals to ensure a complete and consistent filing of the expanded outpatient data set in future reporting years.

    Text files are .zip formatted for greater downloading ease.  Zipped sizes shown.
    2006 Public Use Files

    2006 Vermont Outpatient Data

    		 (7,676 kb)
    2006 Vermont Inpatient Data (2,375 kb)
    2006 Emergency Department Data (6,426 kb)
    2006 Vermont Expanded Outpatient Data (18,748 kb)

     

 Downloading Vermont Revenue Code File 2006, 2007 and 2008

  • Field Properties: This Excel document includes the field properties to use with the 2006 and 2007 Vermont Revenue Code data as well as all of the underlying code tables. You can use this to set up your tables prior to downloading or to reduce the size of your tables after downloading them. The UNIQ ID field is located in the Revenue Code file and will allow you to link it with the Public Use Files. 
     

  • Code Tables: This Excel document lists all of the data to be listed in the code tables mentioned above. Once you have created your tables, this data can be easily inserted into them. There are also two additional tables that are available for your use that contain crosswalks for the revenue Center ID to the Primary, Secondary, and Tertiary Cost Center Sources for CCR.

Revenue Code Data
The following file represents revenue code data. Revenue code data can be linked with records in all the corresponding Public Use Files using a unique number. There may be more than one revenue record linked to each of the different Inpatient, Outpatient and Emergency Department records, which is why this file is much larger than the other files provided.  Text files are .zip formatted for greater downloading ease.  Zipped sizes shown
2008 Vermont Revenue Code Data (31,672 kb)
2007 Vermont Revenue Code Data (26,993 kb)
2006 Vermont Revenue Code Data (33,025 kb)

 

 Downloading Vermont Public Use Files 2005 and Earlier

  • Field Properties: This PDF file includes the field properties to use with the Inpatient, Outpatient and Emergency Department Data table as well as all of the underlying code tables.  You can use this to set up your tables prior to downloading or to reduce the size of your tables after downloading them.

  • Code Tables: This Excel document lists all of the data to be listed in the code tables.  Once you have created your tables, this data can be easily inserted into them.  Note that the ID field is highlighted in yellow in the Excel file. This is because the ID variable is not in the data files, but instead represents the unique ID field that you may want to add to the downloaded data.  You may want to add the ID field to define your data set if you are combining multiple text files into one master file.

Inpatient, Outpatient and Emergency Department Data
The following text files represent data for each collection year. The Inpatient Data and Outpatient Data files combine to make the complete data set for each year. These files are separated below for easier downloading and because they are used individually in many cases. Data is extracted from both the Inpatient and Outpatient data to create a file based only on records relating to the Emergency Department, which is the third data file listed for each year.   

Text files are .zip formatted for greater downloading ease.  Zipped sizes shown.
2005 Vermont Public Use Files
2005 Vermont Outpatient Data (6,957 kb)
2005 Vermont Inpatient Data (2,271 kb)
2005 Emergency Department Data (5,563 kb)
2004 Vermont Public Use Files
2004 Vermont Outpatient Data (7,311 kb)
2004 Vermont Inpatient Data (2,222 kb)
2004 Emergency Department Data (5,818 kb)
2003 Vermont Public Use Files
2003 Vermont Outpatient Data (7,143 kb)
2003 Vermont Inpatient Data (2,234 kb)
2003 Emergency Department Data (5,709 kb)
2002 Vermont Public Use Files
2002 Vermont Outpatient Data (6,257 kb)
2002 Vermont Inpatient Data (2,122 kb)
2002 Emergency Department Data (5,140 kb)

 
 Links to Relevant Websites