• CDR Home

• Table of contents

• Application Information

• Main Menu

• Retrieve/Edit Case

• Reports

• Utilities

• Export Database

• Appendix A: Apply for Digital Certificate

• Appendix B: Register for Web Application

• CDR-Data Dictionary (Excel)

• CDR - Web Application Lookup tables (Excel)

Main Menu: Utilities                                                                  

Export Database

When you select the Export Database option from the Utilities Menu, the export begins immediately. Once the export is completed, a link will appear on the screen indicating that you may now download the data file. User-level permissions will determine what is allowed to be exported; teams will be able to export the same cases that your team membership allows you to view and edit.  DOH Administrators will be able to export the entire database. 

The database export will produce a zip file containing several text files. Each text file contains the information related to the file’s name.  Several text files contain multiple forms.

 Sample exported zip file.

 Forms contained in each file:

 DeathCertificate.txt:

·         Death Certificate

·         General Information

 Circumstances.txt:

·         Circumstances of Death

·         Fire

·         Burn

·         Fall

·         Firearms

·         Sudden Infant Death Syndrome

·         Drowning

·         Poisoning/Drug Intoxication

·         Vehicular Injury

·         Other Circumstances

 AdditionalInformation.txt:

·         Additional Information

 InfantDeaths.txt:

·         Infant Deaths

ReviewInfo.txt:

·         Records for Review

·         Committee Conclusions

·         Narrative

·         Review Information

·         Case Status

 The information contained in each text file is pipe delimited and can easily be imported into Access or Excel for detailed analysis.  The first line of the file contains the field names for each column, all rows after the first are data.

Screen shot of a sample exported file.

These are the settings known to properly import this data into Excel.

Below are the settings known to start the import data process for Access:

Some of the explanation fields will be truncated.  To tell which fields will be truncated, the user can import the data,  then look at the error table for that file and it will list the fields that are being truncated.  From that list, the user can re-import the data correctly by clicking on the Advanced button and reset the data type to memo from text for each truncated field. Click on the data type field you want to change and select memo.

For more information on the data returned by the data export utility, please consult the Washington CDR Data Dictionary and the Washington CDR Lookup tables.XLS.

Back to Table of Contents

DOH Home | Access Washington | Privacy Notice | Disclaimer/Copyright Information

Child Death Review 
Department of Health
PO Box 47880
Olympia, Washington 98504-7880
360-236-3536 fax 360-586-7868

Last Update : 05/19/2006 10:33 AM
Send inquires about DOH and its programs to the Health Consumer Assistance Office
Comments or questions regarding this web site? Send mail to Sub-Site Developer.