National Academies Press: OpenBook
« Previous: 11 Appendix A Serious Injury Definitions
Page 66
Suggested Citation:"12 Appendix B Identifiers for Linkage." National Academies of Sciences, Engineering, and Medicine. 2021. Development of a Comprehensive Approach for Serious Traffic Crash Injury Measurement and Reporting Systems. Washington, DC: The National Academies Press. doi: 10.17226/26305.
×
Page 66
Page 67
Suggested Citation:"12 Appendix B Identifiers for Linkage." National Academies of Sciences, Engineering, and Medicine. 2021. Development of a Comprehensive Approach for Serious Traffic Crash Injury Measurement and Reporting Systems. Washington, DC: The National Academies Press. doi: 10.17226/26305.
×
Page 67
Page 68
Suggested Citation:"12 Appendix B Identifiers for Linkage." National Academies of Sciences, Engineering, and Medicine. 2021. Development of a Comprehensive Approach for Serious Traffic Crash Injury Measurement and Reporting Systems. Washington, DC: The National Academies Press. doi: 10.17226/26305.
×
Page 68
Page 69
Suggested Citation:"12 Appendix B Identifiers for Linkage." National Academies of Sciences, Engineering, and Medicine. 2021. Development of a Comprehensive Approach for Serious Traffic Crash Injury Measurement and Reporting Systems. Washington, DC: The National Academies Press. doi: 10.17226/26305.
×
Page 69
Page 70
Suggested Citation:"12 Appendix B Identifiers for Linkage." National Academies of Sciences, Engineering, and Medicine. 2021. Development of a Comprehensive Approach for Serious Traffic Crash Injury Measurement and Reporting Systems. Washington, DC: The National Academies Press. doi: 10.17226/26305.
×
Page 70
Page 71
Suggested Citation:"12 Appendix B Identifiers for Linkage." National Academies of Sciences, Engineering, and Medicine. 2021. Development of a Comprehensive Approach for Serious Traffic Crash Injury Measurement and Reporting Systems. Washington, DC: The National Academies Press. doi: 10.17226/26305.
×
Page 71
Page 72
Suggested Citation:"12 Appendix B Identifiers for Linkage." National Academies of Sciences, Engineering, and Medicine. 2021. Development of a Comprehensive Approach for Serious Traffic Crash Injury Measurement and Reporting Systems. Washington, DC: The National Academies Press. doi: 10.17226/26305.
×
Page 72
Page 73
Suggested Citation:"12 Appendix B Identifiers for Linkage." National Academies of Sciences, Engineering, and Medicine. 2021. Development of a Comprehensive Approach for Serious Traffic Crash Injury Measurement and Reporting Systems. Washington, DC: The National Academies Press. doi: 10.17226/26305.
×
Page 73
Page 74
Suggested Citation:"12 Appendix B Identifiers for Linkage." National Academies of Sciences, Engineering, and Medicine. 2021. Development of a Comprehensive Approach for Serious Traffic Crash Injury Measurement and Reporting Systems. Washington, DC: The National Academies Press. doi: 10.17226/26305.
×
Page 74

Below is the uncorrected machine-read text of this chapter, intended to provide our own search engines and external engines with highly rich, chapter-representative searchable text of each book. Because it is UNCORRECTED material, please consider the following text as a useful but insufficient proxy for the authoritative book pages.

66 12 Appendix B Identifiers for Linkage Survey State Identifiers- EMS Patient Care Data Identifiers-ED Data Identifiers- Hospital Discharge Data Identifiers- Trauma Registry Data Identifiers-Vital Records Data Identifiers-Roadway Inventory Data Alabama Time of crash, crash location. Patient Identifier Code. Patient Identifier Code Milepoint Alaska This has yet to be built but we are planning to use the APSIN ID as a unique identifier across databases. This is currently being done using names and dates on both the crash data and the hospital discharge data. This has yet to be built but we are planning to use the APSIN ID as a unique identifier across databases The crash and roadway inventory data are in the same database and are directly linked Arizona Arkansas Name and other fields. County, Route, Section, Log Mile California probabilistically linked-no common identifying field. Use demographic fields common to both, date and location of collision to increase match success. probabilistically linked-no common identifying field. Use demographic fields common to both, date and location of collision to increase match success. probabilistically linked-no common identifying field. Use demographic fields common to both, date and location of collision to increase match success.

67 Survey State Identifiers- EMS Patient Care Data Identifiers-ED Data Identifiers- Hospital Discharge Data Identifiers- Trauma Registry Data Identifiers-Vital Records Data Identifiers-Roadway Inventory Data Colorado For Fatal Records (Crashes) only! Direct interface with all Roadway data for exact location (coding) of both, On- and Off-System Crashes statewide! Delaware Patient's last name, first name, gender, age, crash date and time, ALS/BLS agency location (latitude and longitude). Patient's last name, first name gender, age, position (driver, passenger, etc) crash date, hospital location (lat and long). road name, road number, milepoint, latitude and longitude Florida Sex, Date of Birth, Home zip code, Incident Date. GPS location, intersection information Hawaii milepost, intersections, GPS Idaho Name, Date Of Birth, Gender, Date of Incident, Hospital Transported to.

68 Survey State Identifiers- EMS Patient Care Data Identifiers-ED Data Identifiers- Hospital Discharge Data Identifiers- Trauma Registry Data Identifiers-Vital Records Data Identifiers-Roadway Inventory Data Illinois age, gender, date of birth, date of birth, county, city, date of crash, date of admission. age, gender, date of birth, date of birth, county, city, date of crash, date of admission. age, gender, date of birth, date of birth, county, city, date of crash, date of admission Location Codes Iowa A variety per CODES. A variety per CODES. Direct key field match. Kansas Indirect link with FARS database. On Road/At Road information Kentucky Admit date; occupant date of birth, gender, and resident zip code; distance from crash location to hospital location; vehicle type; person type; crash type. Admit date; occupant date of birth, gender, and resident zip code; distance from crash location to hospital location; vehicle type; person type; crash type. I don't know Louisiana Not currently being performed, but we plan to do so and are looking into. Not currently being performed, but we plan to do so and are looking into. Not currently being performed, but we plan to do so and are looking into. Not currently being performed, but we plan to do so and are looking into. Not currently being performed, but we plan to do so and are looking into. Lat/Long, street names, primary roadway, secondary roadway, distance, direction, milepoint Maine indirect. Unknown

69 Survey State Identifiers- EMS Patient Care Data Identifiers-ED Data Identifiers- Hospital Discharge Data Identifiers- Trauma Registry Data Identifiers-Vital Records Data Identifiers-Roadway Inventory Data Maryland Time of day, day of week, county of crash, age, gender, mechanism of injury, person type (driver, passenger, pedestrian). Time of day, day of week, county of crash, age/dob, gender, mechanism of injury, person type (driver, passenger, pedestrian). Time of day, day of week, county of crash, age/dob, gender, mechanism of injury, person type (driver, passenger, pedestrian). Time of day, day of week, county of crash, age/dob, gender, mechanism of injury, person type (driver, passenger, pedestrian) Integrated through use of ArcGIS, mapping of crashes and roadways in the state Massachusetts Vehicular Injury Indicators, Area of the Vehicle impacted by the collision, Seat Row Location of Patient in Vehicle, Position of Patient in the Seat of the Vehicle, Use of Occupant Safety Equipment, Airbag Deployment, Barriers to Encrypted SSN, Gender, DOB, Ecode, Org ID, Date, Time, Diagnosis, Status, Patient City, Patient Zip. Encrypted SSN, Gender, DOB, Ecode, Org ID, Date, Time, Diagnosis, Status, Patient City, Patient Zip. Protective Devices/Child Specific Restraint, Airbag Deployment, Alcohol Use/Drug Use Indicators, Diagnosis Code, Transport Mode, Injury Incident Date/Injury Incident Time, SiteOrgID, ED/Hospital Admission Time, Patient Street Address, Patient City, Patien Encrypted SSN, Address, City, State, Date of Death, DOB, Cause of injury, Location of injury, Diagnosis Street Name, City, Mile point, Route, Bridges, Speed Limit, Highway District, RPA (Regional Planning agency)

70 Survey State Identifiers- EMS Patient Care Data Identifiers-ED Data Identifiers- Hospital Discharge Data Identifiers- Trauma Registry Data Identifiers-Vital Records Data Identifiers-Roadway Inventory Data Patient Care, Alcohol/Dru. Michigan Not yet linked. Not yet linked. Not yet linked. Not yet linked Not yet linked Minnesota Last name, first name, gender, DOB, crash date, location. Hospital zip, home zip, injured (y/n), fatal (y/n), gender, DOB, admit hour, crash date, position, age, vehicle type. Hospital zip, home zip, injured (y/n), fatal (y/n), gender, DOB, admit hour, crash date, position, age, vehicle type. Last name, first name, hospital zip, home zip, injured (y/n), fatal (y/n), gender, DOB, admit hour, crash date, position, age, vehicle type Last name, first name, hospital zip, home zip, injured (y/n), fatal (y/n), gender, DOB, admit hour, crash date, position, age, vehicle type Route and reference point, roadway system type, county/city identifier Mississippi EMS agency and hospital in crash data base, as well as person name. Person name Person name Person name Linked with Crash by GPS Location Missouri Crash number, crash date, county, name, DOB. Crash number, crash date, county, name, DOB. Crash number, crash date, county, name, DOB Crash number, location information, county, crash date Montana Nebraska Patient first name, last name, gender, Patient date of birth, age, gender, occurrence date, Patient date of birth, age, gender, occurrence date, Patient first name, last name, gender, date of

71 Survey State Identifiers- EMS Patient Care Data Identifiers-ED Data Identifiers- Hospital Discharge Data Identifiers- Trauma Registry Data Identifiers-Vital Records Data Identifiers-Roadway Inventory Data Date of birth, and occurrence date. And occurrence county. And occurrence county. Birth, date of death, and occurrence county Nevada Patient name, birthdate, incident date Route ID and/or Route Full Name New Mexico New York Age, agency county, birth day, birth month, birth year, first two characters of first name, first two characters of last name, last two characters of last name, last four of social security, hour of call, injury flag, run date, sex, call location, call ty. Facility county, first two characters of first name, first two characters of last name, last two characters of last name, last four of social security, state, zip code, role, age, date, date of birth day, birth month, sex, externalExternal- cause code. Facility county, first two characters of first name, first two characters of last name, last two characters of last name, last four of social security, state, zip code, role, age, date, date of birth day, birth month, sex, externalExternal- cause code. Unknown. We are in the process of obtaining trauma registry data. It is anticipated that variables such as: admission date, admission time, month, day and year of birth, age, sex, zip code, county, state, injury date, county of injury, place of occurrence We do not currently have approval for using vital records in the CODES project. We do not currently have access to Roadway Inventory data for the CODES project.

72 Survey State Identifiers- EMS Patient Care Data Identifiers-ED Data Identifiers- Hospital Discharge Data Identifiers- Trauma Registry Data Identifiers-Vital Records Data Identifiers-Roadway Inventory Data North Carolina date, county, time of day, sex, ethnicity, date of birth, person type, and name (if driver). date, county, time of day, sex, ethnicity, date of birth, person type, and name (if driver). date, county, time of day, sex, ethnicity, date of birth, person type, and name (if driver). date, county, time of day, sex, ethnicity, date of birth, person type, and name (if driver) name, date of birth, sex, county of residence date, county, road on, road from, and road to North Dakota Roadway Location Ohio This data is provided by the Division of EMS, Ohio Department of Public Safety. This data is provided by the Division of EMS, Ohio Department of Public Safety. This data is provided by the Ohio Hospital Association. This data is provided by the Division of EMS, Ohio Department of Public Safety These records are provided by the Ohio Department of Health This information is supplied by the Ohio Department of Transportation Oklahoma First and last name; DOB; age; sex; last four digits of SSN; incident date; soundex. First and last name; DOB; age; sex; last four digits of SSN; incident date; soundex. First and last name; DOB; age; sex; last four digits of SSN; incident date; soundex. Year; County; Control Section; Subsection; Mile point. Oregon The following are fields that were tested during probabilistic linking of the EMS and Crash systems: Call #, road number and milepoint

73 Survey State Identifiers- EMS Patient Care Data Identifiers-ED Data Identifiers- Hospital Discharge Data Identifiers- Trauma Registry Data Identifiers-Vital Records Data Identifiers-Roadway Inventory Data Incident #, Responding unit #, Unit dispatched (date/time), En route, Arrive at scene, Arrive at patient, Leave scene, Arrive destination, Dispatch. Pennsylvania Currently we can only link state roads. This is done through County, Route, Segment, and Offset. The crash record and roadway record both contain this information. Puerto Rico Rhode Island We are in the planning stages of implementing a statewide LRS that will link crash data to roadway features/characteristics/etc via a geographic component. Texas Unknown Unknown Unknown Unknown Name Latitude/Longitude Coordinates of the crash.

Development of a Comprehensive Approach for Serious Traffic Crash Injury Measurement and Reporting Systems Get This Book
×
MyNAP members save 10% online.
Login or Register to save!
Download Free PDF

The Moving Ahead for Progress in the 21st Century Act (MAP-21) requires a set of performance metrics to include assessment of serious injuries in crashes.

The TRB National Cooperative Highway Research Program's NCHRP Web-Only Document 302: Development of a Comprehensive Approach for Serious Traffic Crash Injury Measurement and Reporting Systems presents a roadmap for states to develop comprehensive crash-related data linkage systems, with special attention to measuring serious injuries in crashes.

  1. ×

    Welcome to OpenBook!

    You're looking at OpenBook, NAP.edu's online reading room since 1999. Based on feedback from you, our users, we've made some improvements that make it easier than ever to read thousands of publications on our website.

    Do you want to take a quick tour of the OpenBook's features?

    No Thanks Take a Tour »
  2. ×

    Show this book's table of contents, where you can jump to any chapter by name.

    « Back Next »
  3. ×

    ...or use these buttons to go back to the previous chapter or skip to the next one.

    « Back Next »
  4. ×

    Jump up to the previous page or down to the next one. Also, you can type in a page number and press Enter to go directly to that page in the book.

    « Back Next »
  5. ×

    To search the entire text of this book, type in your search term here and press Enter.

    « Back Next »
  6. ×

    Share a link to this book page on your preferred social network or via email.

    « Back Next »
  7. ×

    View our suggested citation for this chapter.

    « Back Next »
  8. ×

    Ready to take your reading offline? Click here to buy this book in print or download it as a free PDF, if available.

    « Back Next »
Stay Connected!