CODES Custom Reporting System
The Reporting System is a simple way to create your own complex tabular reports from the
linked data. The system provides a variety of health outcome measures, output in tabular form, that can then be downloaded into Excel or other software of your choice for further manipulation and analysis.
To run the system, all you need to do is:
- "Select" the data you want to examine.
- "Choose" the data elements to create rows in the report.
- "Create" the report comprised of the selected row measures and 22 outcome measures in columns.
You can download the data as a CSV file (comma separated values) or as an XML file for inputting into the table software of your choice.
The option labeled "Export Data to Excel or CSV" exports the data as a CSV file.
The option labeled "Export Data to XML" exports the data in XML, a flexible format that may also be used with a wide variety of tools.
If you are using our Excel templates, select the "Export Data to Excel or CSV".
Selection of Data
You can select data for a variety of conditions.
- 2009-2014. Can select any or all. There is also an "All Years" choice that overrides any individual selections.
Clearing this selection box is the same as choosing all years. Default is 2014.
County (A single or any combination of Wisconsin's 72 counties) Default is ALL.
City (A single or any combination of 30 Wisconsin cities) Default is ALL.
Rural (Rural or Urban) Default is ALL.
Highway Type (Interstate, State, County, Local) Default is ALL.
- Person Characteristics:
Sex (Either Male/Female) Default is both sexes.
Age (Any range from 0-96) Default is all.
Role (Driver, Passenger, Motorcyclist, Moped Rider, Bicyclist, Pedestrian) A single or any combination - Default is All
Persons with Alcohol Present (Yes/No) Passengers of motor vehicles not included.
Persons with Drugs Present (Yes/No) Passengers of motor vehicles not included.
Persons with Alcohol or Drugs Present (Yes/No) Passengers of motor vehicles not included.
- Crash Characteristics:
- For all characteristics selecting Yes will include ALL vehicles/occupants involved in any crash possessing the specific attribute. For instance, selecting Citation Issued will include all vehicles/persons involved in a crash for which any person was issued a citation.
Alcohol a factor in crash (Yes/No)
Drugs a factor in crash (Yes/No)
Alcohol or Drugs a factor in crash (Yes/No)
Citation Issued in crash (Yes/No)
Construction Zone Crash (Yes/No)
Commercial Vehicle (> 10,000 lbs) involved in crash (Yes/No)
Passenger Vehicles (Yes/No)
Data selection criteria is exclusive between factors. That is, if you select Sex=Male and Role=Motorcycle, the output will only include crash occupants who are male and were riding a motorcycle. If you select Sex=Female and Construction Zone Crash=Yes, only female occupants of vehicles involved in a
Construction zone crash will be selected.
For more information, see our detailed data dictionary (PDF) with information about each Selection Data Element.
Choice of Row Data Elements
There are 36 different row data elements available for creating reports.
You can choose either one or two data elements for inclusion.
The data elements include such items as age, crash type, vehicle type, role and year.
Except for "Occupant of Passenger Vehicle" and "Persons with Alcohol/Drugs Present", all data selection elements are also available as row data elements.
You can download a simple list of all row data elements (PDF) and
a detailed data dictionary (PDF) with information about each row data element.
There are 22 outcome measures output for each tabular report. These include information related to:
- Transportation to Medical Facility
- ER Visits and Hospitalizations, Length of Stay and Injury Severity
- Death and Years of Person Life Lost due to crashes
- ER and Hospitalization Charges
- Estimated full Medical Costs, Other Costs and "Quality of Life" Costs
A list of all outcome elements is available as part of the data elements list (PDF).
For more complete information on each Outcome Data element, see the detailed data dictionary (PDF).
We provide templates to assist you in using the data in Excel. See the template page for more information.
We Welcome Your Input
Please direct your inquiries and feedback to:
610 Walnut Street
Madison, WI 53726