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.