RTK NET Home Page

About the Data

Resources

Help

About RTK NET

Data Dictionary

RTK NET provides different kinds of database output. This data dictionary is probably best used with levels of detail such as High, Extended, or Complete -- lower levels of detail, such as Low or Medium, generally will have one line per search result and don't really need a data dictionary, and Summary output provides a summation of the search that has its own help links if you are viewing it in HTML.

The data dictionary is mostly for use with search output viewed in HTML, in which each section of search output will have a help link to part of this document. However, sections of the data dictionary try to present the data fields in the same order as produced by delimited data output (comma or tab delimited data). XML output should have its own specialized documentation, which hasn't been completed yet, but you can use this document to try to look up the meanings of fields in XML that you don't understand.

Incident-based reports

Section: Call Recordkeeping

This section supplies basic information about when and how the incident was reported.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
Incident ID NumberUnique ID number for each incident. Negative ID numbers were assigned by RTK NET to records in reporting years before 1990. Positive ID numbers are NRC Report Numbers.int(11)0.00All  
Date / Time Call ReceivedDate/time when the call reporting the incident was received.varchar(25)0.00Complete only  
Date / Time Call CompleteDate/time when the call reporting the incident was complete.varchar(25)0.25Complete only 1990-2016
Date Call ReceivedDate when the call reporting the incident was received.date0.04All  
Date Call CompleteDate when the call reporting the incident was complete.date0.25All 1990-2016
Call TypeCode for the type of call received (INC=Incident, DRL=drill).char(3)0.00All 1990-2016
Source of ReportTranslation of code for the type of source of the call or other report.varchar(15)39.98All 1990-2016
Call TakerName or initials of person receiving the call that reported the incident.varchar(16)6.58Extended and Complete 1990-2003

Section: Suspected Responsible Party

This section supplies information on which entity is suspected to be responsible for the incident. Often this is the company that owns a site at which an accident took place.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
Resp. CompanyCompany responsible for the incident.varchar(40)36.80All 1987-2016
Resp. Organization TypeThe type of organization responsible for the incident.varchar(40)33.90All 1987-2016
Resp. CityThe city in the address of the entity responsible for the incident.varchar(30)37.14All 1987-2016
Resp. StateThe state in the address of the entity responsible for the incident.char(2)35.70All 1987-2016
Resp. Zip CodeThe Zip code in the address of the entity responsible for the incident.varchar(9)51.24All 1987-2016
Resp. AddressThe address of the entity responsible for the incident.varchar(40)41.98All 1987-2003
Resp. Street 1The first line of the street address of the entity responsible for the incident.varchar(40)91.16All 1990-2003
Resp. Street 2The second line of the street address of the entity responsible for the incident.varchar(40)99.03All 1990-2003
Resp. Last NameLast name of person responsible for incident.varchar(30)42.28All 1987-2003
Resp. First NameFirst name of person responsible for incident.varchar(30)38.06All 1990-2003
Resp. Phone 1First phone number of entity responsible for incident.varchar(10)44.85All 1987-2003
Resp. Phone 2Second phone number of entity responsible for incident.varchar(10)93.03All 1987-2003
Resp. Phone 3Third phone number of entity responsible for incident.varchar(10)99.43All 2000-2003
Resp. Phone Type 1Type of phone number for first phone number of responsible entity.varchar(9)37.77All 1990-2003
Resp. Phone Type 2Type of phone number for second phone number of responsible entity.varchar(9)93.33All 1990-2003
Resp. Phone Type 3Type of phone number for third phone number of responsible entity.varchar(9)99.45All 2000-2003
On Behalf OfThe Reporting party is calling on behalf of the Responsible party.char(1)100.00All -

Section: Incident Description

This section supplies a basic description of the incident, the type of incident, and the cause of the incident.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
Potential FlagIndicates whether the report is a potential release of material.char(1)43.06Extended and Complete 1999-2016
Incident DescriptionFree-text description of the incident.text95.47All  
Incident TypeTranslation of a code indicating the type of incident.varchar(40)0.00All 1990-2016
Incident CauseTranslation of a code indicating the cause of the incident.varchar(40)35.35All 1990-2016
Incident Date / TimeDate and time on which the incident occurred.varchar(25)0.16All  
Incident DateDate on which the incident occured.date0.31All  
Incident Occurred/ Discovered/ PlannedIndicates whether incident occurred by accident, was discovered after it occurred (i.e., dumping), or whether it was planned.varchar(10)0.03All 1987-2016
Additional InfoAdditional information on the incident.text98.95All  
Unknown: WMD_CHEM_FLAGUndocumented field with unknown meaning.char(1)24.90All 1999-2002
Radioactive Materials (Yes/No)Indicates whether radioactive materials were involved in the incident.char(1)2.17All 2000-2002
Biological Materials (Yes/No)Indicates whether biologically hazardous materials were involved in the incident.char(1)2.17All 2000-2002
Oil (Yes/No)Indicates whether oil or other petroleum substances were involved in the incident.char(1)60.67All 1999-2002
Unknown: POTENTIAL_FLAGUndocumented field with unknown meaning.char(1)96.94Extended and Complete 1999-2002
Unknown: AMT_MATERIAL_FLAGUndocumented field with unknown meaning.char(1)99.91Extended and Complete 1999-2002
Unknown: MILITARY_ORG_FLAGUndocumented field with unknown meaning.char(1)55.56Extended and Complete 1999-2002
Liquid Natural Gas (Yes/No)Indicates whether Liquid Natural Gas (LNG) was involved in the incident.char(1)99.99All 2000-2002

Section: Incident Location

This section supplies information on the location of the incident.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
Incident LocationFree-text description of the location at which the incident occurred.varchar(240)55.50All  
Location AddressAddress at which the incident occurred.varchar(50)20.71All 1990-2016
Location Street 1First line of the street address at which the incident occurred.varchar(40)78.35All 1990-2016
Location Street 2Second line of the street address at which the incident occurred.varchar(40)95.22All 1990-2016
City Near LocationName of a city close to the location at which the incident occurred.varchar(30)13.41All 1987-2016
Location StateState within which the incident occurred.char(2)0.02All  
Location CountyCounty within which the incident occurred.varchar(30)0.05All 1987-2016
Location Zip CodeZip code for the address at which the incident occurred.varchar(9)67.23All 1990-2016
Distance From CityDistance from the city close to where the incident occurred.decimal(5,1)96.81All 1990-2016
Distance From City UnitsUnits of measurement for the distance from the city near where the incident occurred.varchar(40)96.83All 1990-2016
Direction From CityThe compass direction from the city near where the incident occurred to the location of the incident.char(3)96.86All 1990-2016
Latitude (Degrees)Latitude degrees of the location of the incident.char(2)88.24All 1990-2016
Latitude (Minutes)Latitude minutes of the location of the incident.char(2)88.25All 1990-2016
Latitude (Seconds)Latitude seconds of the location of the incident.char(2)88.71All 1990-2016
Latitude (Quadrant)Latitude quadrant of the location of the incident.char(1)88.56All 1990-2016
Longitude (Degrees)Longitude degrees of the location of the incident.varchar(4)88.25All 1990-2016
Longitude (Minutes)Longitude minutes of the location of the incident.char(2)88.25All 1990-2016
Longitude (Seconds)Longitude seconds of the location of the incident.char(2)88.72All 1990-2016
Longitude (Quadrant)Longitude quadrant of the location of the incident.char(1)88.62All 1990-2016
Location SectionSection in which the incident is located.varchar(30)97.71Extended and Complete 1990-2016
Location TownshipTownship in which the incident is located.varchar(30)97.70Extended and Complete 1990-2016
Location RangeMeaning of field is unclear.varchar(30)97.78Extended and Complete 1990-2016

Section: Material

This section supplies information on each material released during the incident.

This section can have more than one entry per record. The record with the most entries currently holds 55. Only the first 3 of these are displayed if comma or tab-delimited format is chosen.

This section is displayed in High through Complete detail reports.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
Chris CodeIdentifying code for a type of material.char(3)10.48High through Complete  
CAS NumberIdentifying number for a particular chemical.varchar(12)93.65High through Complete 1988-2016
UN NumberIdentifying number for a material.varchar(8)97.69Extended and Complete 1988-1988
Amount Of MaterialAmount of material released during incident. For early years, this information may be in the Amount Of Material Units field.decimal(14,5)51.27High through Complete 1987-2016
Amount Of Material UnitsUnits of measurement for amount of material released. For early years, this field will include the amount released as well.varchar(40)46.25High through Complete  
Name of MaterialThe name of the material released during the incident.varchar(80)10.44High through Complete  
Material Reached WaterIndicates whether released material reached water during the incident.varchar(7)0.00High through Complete 1990-2016
Amount In WaterThe amount of the released material that was released to water.decimal(14,5)80.20High through Complete 1987-2016
Amount In Water UnitsUnits of measurement for the amount of the material released to the water.varchar(40)64.06High through Complete  

Section: Impact Information

This section supplies information on the impacts of the incident, such as deaths, injuries, evacuations, or property damage.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
Fire Involved (Yes/No)Indicates whether the incident involved a fire.char(1)0.34All 1990-2016
Fire Extinguished (Yes/No)Indicates whether a fire involved with the incident had been extinguished by the time the incident was reported.char(1)98.43Extended and Complete 1990-2016
Evacuations (Yes/No)Indicates whether an evacuation took place in response to the incident.char(1)0.32All 1987-2016
Number EvacuatedNumber of people evacuated in response to incident.int(11)98.91All 1990-2016
Who EvacuatedDescription of who was evacuated in response to incident.varchar(40)98.49All 1999-2016
Radius of EvacuationRadius around incident within which people were evacuated.decimal(8,2)99.80All 2000-2016
Injuries (Yes/No)Indicates whether injuries occurred as a result of the incident.char(1)35.15All 1990-2016
Number InjuredNumber of people injured as a result of the incident.smallint(6)96.92All  
Number HospitalizedNumber of people hospitalized as a result of the incident.smallint(6)97.49All 1999-2016
Fatalities (Yes/No)Indicates whether people were killed as a result of the incident.char(1)35.13All 1990-2016
Number FatalitiesNumber of people killed as a result of the incident.smallint(6)97.32All  
Property Damage (Yes/No)Indicates whether property damage was caused by incident.char(1)0.32All 1987-2016
Property Damage (in Dollars)Amount of property damage caused by incident, in dollars.decimal(9,0)99.28All  
Air Corridor Closed (Yes/No)Indicates whether an air corridor was closed by the incident.char(1)6.70All 1990-2016
Air Corridor ClosedName of the air corridor closed by the incident.varchar(80)99.99All 2000-2016
Air Corridor Closure TimeLength of time air corridor was closed due to incident.decimal(5,1)100.00All 2000-2016
Waterway Closed (Yes/No)Indicates whether a waterway was closed by the incident.char(1)9.99All 1990-2016
Waterway ClosedName of the waterway closed by the incident.varchar(80)93.56All 1987-2016
Waterway Closure TimeLength of time a waterway was closed by the incident.decimal(5,1)99.98All 2000-2016
Road Closed (Yes/No)Indicates whether a road was closed by the incident.char(1)6.70All 1990-2016
Road ClosedName of the road closed by the incident.varchar(80)97.68All 1999-2016
Road Closure TimeLength of time a road was closed by the incident.decimal(5,1)98.64All 1999-2016
Road Closure DirectionDirection of the road closed by the incident.varchar(40)98.40All 1999-2016
Major Artery (Yes/No)Indicates whether the road closed by the incident was a major artery.char(1)9.99All 1990-2016
Track Closed (Yes/No)Indicates whether a railroad track was closed by the incident.char(1)9.99All 1990-2016
Track ClosedName of the section of railroad track closed by the incident.varchar(80)98.03All 1990-2016
Track Closure TimeLength of time a section of railroad track was closed by the incident.decimal(5,1)98.94All 1990-2016
Media InterestIndicates the level of news media interest in the incident (high, medium, low, or none).varchar(14)36.45All 1990-2016
Medium DescriptionDescription of which release media -- i.e. air, water, or land -- were affected by the incident.varchar(40)7.10All  
Additional Medium InfoAdditional information on the release media affected.varchar(80)14.96All 1990-2016
Track Closed DirectionDirection in which railroad track was closed by the incident.varchar(40)97.50All 1999-2016
Employee FatalitiesThe number of employee deaths due to the incident.smallint(6)99.80All 1999-2016
Passenger FatalitiesThe number of passenger deaths due to the incident.smallint(6)99.93All 2000-2016
Community Impact (Yes/No)Indicates whether there was community impact due to the incident.char(1)19.43All 1990-2007
Employee InjuriesThe number of employees injured due to the incident.smallint(6)99.79All 2000-2016
Passenger InjuriesThe number of passengers injured due to the incident.smallint(6)99.92All 1999-2016
Occupant FatalitiesThe number of occupants killed by the incident.smallint(6)99.28All 1999-2016
Road Closure UnitsUnits of measurement of road closure.varchar(40)100.00All -
Track Closure UnitsUnits of measurement of railroad track closure.varchar(40)100.00All -
Duration UnitsMeaning of field is unknown.varchar(40)94.84All 1999-2016
Passengers TransferredIndicates whether passengers were transferred (for railway incidents).char(3)0.00All 1990-2016

Section: Continuous Release

Some incidents are "continuous releases" -- planned events or continuous processes in which more than a CERCLA Reportable Quantity of the chemical is released. If the incident was a continuous release, details are given in this section.

This section is displayed in Extended and Complete detail reports.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
Continuous Release TypeTranslation of code for the type of continuous release.varchar(40)99.17Extended and Complete 1990-2016
Initial Continuous Release NumberID number for the initial record for this continuous release.varchar(7)99.30Extended and Complete 1990-2016
Continuous Release PermitPermit number for continuous release.varchar(10)99.94Extended and Complete 2000-2016
Continuous Release Begin Date (Orig)Date on which continuous release began, in original format..varchar(25)99.80Complete only 2001-2016
Continuous Release Begin DateDate on which continuous release began.date99.80Extended and Complete 2001-2016
Continuous Release End Date (Orig)Date on which continuous release ended, in original format.varchar(25)99.96Complete only 2001-2016
Continuous Release End DateDate on which continuous release ended.date99.96Extended and Complete 2001-2016
Continuous Release Change Date (Orig)Date on which continuous release changed, in original format.varchar(25)99.92Complete only 2001-2016
Continuous Release Change DateDate on which continuous release changed.date99.92Extended and Complete 2001-2016

Section: Continuous Release Material

This section supplies information on each material released during a continuous release incident.

This section can have more than one entry per record. The record with the most entries currently holds 44. Only the first of these is displayed if comma or tab-delimited format is chosen.

This section is displayed in High through Complete detail reports.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
Chris CodeIdentifying code for type of material.char(3)0.00High through Complete 1990-2016
CAS NumberIdentifying number for a particular chemical.varchar(12)56.40High through Complete 1996-2016
Name of MaterialName of a material released as part of continuous release incident.varchar(80)0.00High through Complete 1990-2016
Upper Bounds Release RateUpper bounds of release rate of continuous release.varchar(20)6.80High through Complete 1990-2016
Upper Bounds Rate Unit (Amount)The amount component of the units of measurement for upper bounds release rate in continuous release incident.varchar(40)64.26High through Complete 1990-2016
Upper Bounds Rate Unit (Per Time)The time component of the units of measurement for upper bounds release rate in continuous release incident.varchar(40)70.61High through Complete 1990-2016

Section: Remedial Action

This section supplies information on actions taken to respond to the incident.

This section is displayed in High through Complete detail reports.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
Release Secured (Yes/No)Indicates whether the release had been secured at the time the report was made.char(1)63.97High through Complete 1990-2016
Estimated Release DurationThe estimated amount of time during which the release of hazardous material took place.varchar(12)94.82High through Complete 1999-2016
Release RateRate of release of hazardous material during the incident.varchar(20)98.95High through Complete 1999-2016
Remedial ActionFree-text description of actions taken to halt the incident.varchar(255)6.07High through Complete  
State/Local Agency On SceneThe state or local agency responding on-scene to the incident.varchar(40)64.69High through Complete 1999-2016
State Agency Report NumberThe report number for the incident from the responding state agency.varchar(30)65.70High through Complete 1999-2016
Other Agency NotifiedThe name of another agency notified about the incident.varchar(40)100.00High through Complete -
State/Local Agency NotifiedThe state or local agency notified of the incident.varchar(40)43.45High through Complete 1999-2016
Federal Agency NotifiedThe Federal agency notified of the incident.varchar(40)58.95High through Complete 1999-2016
Release Rate Units (Amount)Part of units of measurement for the release rate, i.e. if the rate was in tons per year, this field would hold the word tons.varchar(40)98.96High through Complete 1999-2016
Release Rate Units (Per Time)Part of units of measurement for the release rate, i.e. if rate was in tons per year, this field would hold the word year.varchar(40)98.99High through Complete 1999-2016

Section: Drilling Platform Details

If the incident involved an offshore oil drilling platform, details are given in this section.

This section is displayed in Extended and Complete detail reports.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
Platform Rig NameName of platform rig involved in incident.varchar(30)99.23Extended and Complete 1999-2016
Platform LetterIdentifying letter for platform involved in incident.text99.96Extended and Complete 2000-2016
Location Area IDArea ID number used to help define location of platform incident.varchar(40)94.08Extended and Complete 1998-2016
Location Block IDBlock ID number used to help define location of platform incident.varchar(10)94.62Extended and Complete 1998-2016
OCSG NumberOCSG identifying number for platform involved in incident.varchar(10)96.64Extended and Complete 1999-2016
OCSP NumberOCSP identifying number for platform involved in incident.varchar(10)99.62Extended and Complete 2000-2016
State Lease NumberState lease number for platform involved in incident.varchar(10)99.49Extended and Complete 1999-2016
Pier Dock NumberPier dock number for platform involved in incident.varchar(10)98.78Extended and Complete 1996-2016
Berth Slip NumberBerth slip number for platform involved in incident..varchar(10)99.17Extended and Complete 1998-2016

Section: Fixed Object Details

If the incident involved a fixed object (such as a building), this section supplies details on it.

This section is displayed in Extended and Complete detail reports.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
Building IDBuilding ID of a building at which the incident occurred.varchar(10)98.96Extended and Complete 1999-2016
Type of Fixed ObjectType of fixed object involved in the incident.varchar(40)79.60Extended and Complete 1990-2016
Power Gen. Facility (Yes/No)Indicates whether the incident involved a power generation facility.char(1)83.91Extended and Complete 1990-2016
Generating CapacityGenerating capacity of power generation facility involved in the incident.varchar(20)99.80Extended and Complete 2000-2016
Type Of FuelType of fuel for power plant involved in fixed incident.varchar(40)99.35Extended and Complete 1999-2016
NPDES IDID number for NPDES water pollution permit for facility at which incident took place.varchar(10)99.92Extended and Complete 2000-2016
NPDES Compliance (Yes/No)Indicates whether fixed facility at which incident took place is in compliance with its NPDES water pollution permits.char(1)99.13Extended and Complete 1990-2016
Type of StructureType of fixed structure involved in incident.varchar(40)99.88Extended and Complete 2000-2016
Structure NameName of fixed structure involved in incident.varchar(20)99.91Extended and Complete 2000-2016
Structure Operating (Yes/No)Indicates whether structure involved in incident was operating.char(1)3.07Extended and Complete 1990-2016

Section: Mobile Incident

If the incident involved a mobile (road) vehicle, this section supplies information on it.

This section is displayed in Extended and Complete detail reports.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
Road Mile MarkerMile marker number along a road on which the incident occurred.decimal(5,1)98.83Extended and Complete 1999-2016
Airbag Deployed (Yes/No)Indicates whether airbag deployed.char(1)59.18Extended and Complete 1994-2016
Bus Service Disruption TimeLength of time for which normal transit bus service was disrupted after mobile incident.decimal(5,1)99.99Extended and Complete 2000-2015
Bus Service Disruption Time UnitsUnits of measurement for time of disruption of normal transit service.varchar(40)99.98Extended and Complete 2000-2015
Transit Bus Involved (Yes/No)Indicates whether a transit bus was involved in a mobile incident.char(1)99.83Extended and Complete 2000-2016

Section: Mobile Incident Details

This section supplies information on each (road) vehicle involved in the incident.

This section can have more than one entry per record. The record with the most entries currently holds 8. Only the first of these is displayed if comma or tab-delimited format is chosen.

This section is displayed in Extended and Complete detail reports.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
Vehicle NumberVehicle ID number, such as a license plate number.varchar(20)23.12Extended and Complete  
Trailer NumberNumber of trailer involved in mobile incident.varchar(20)93.14Extended and Complete 1999-2016
Fuel CapacityFuel capacity of vehicle in mobile incident.varchar(20)89.99Extended and Complete 1999-2016
Cargo CapacityCargo capacity of vehicle in mobile incident.varchar(20)89.51Extended and Complete 1999-2016
Amount Of CargoActual amount of cargo on board vehicle in mobile incident.varchar(20)89.59Extended and Complete 1999-2016
Hazmat Carrier (Yes/No)Indicates whether vehicle involved in mobile incident was a hazardous materials carrier.char(1)75.90Extended and Complete 1990-2016
Carrier Licensed (Yes/No)Indicates whether vehicle in incident was licensed to carry hazardous materials.char(1)82.07Extended and Complete 1990-2016
Noncompliance With Hazmat (Yes/No)Indicates whether vehicle was not in compliance with hazardous material transport regulations.char(1)91.04Extended and Complete 1990-2016
Vehicle TypeTranslation of code for the type of vehicle involved in a mobile incident.varchar(40)33.13Extended and Complete 1990-2016
Cargo Capacity UnitsUnits of measurement for cargo capacity.varchar(40)94.45Extended and Complete 1999-2016
Cargo On Board UnitsUnits of measurement for amount of cargo on board vehicle.varchar(40)95.05Extended and Complete 1999-2016
Vehicle YearYear in which vehicle was built.varchar(4)100.00Extended and Complete -
Vehicle MakeThe make of a vehicle involved in the incident.varchar(30)100.00Extended and Complete -
Vehicle ModelThe model of a vehicle involved in the incident.varchar(30)100.00Extended and Complete -

Section: Pipeline Details

If the incident involved a pipeline, this section supplies information on it.

This section is displayed in Extended and Complete detail reports.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
Pipeline TypeType of pipeline involved in the incident.varchar(40)97.46Extended and Complete 1990-2016
DOT Regulated (Yes/No)Indicates whether pipeline involved in the incident was Dept. of Transportation regulated.char(1)98.15Extended and Complete 1990-2016
Pipeline Above GroundIndicates whether pipeline is above or below ground.varchar(5)3.15Extended and Complete 1990-2016
Pipeline Exposed Underwater (Yes/No)Indicates whether pipeline involved in the incident is exposed underwater.char(1)40.82Extended and Complete 1990-2016
Pipeline Covered (Yes/No)Indicates whether pipeline involved in the incident is covered.char(1)98.20Extended and Complete 1990-2016

Section: Railroad Incident

If the incident involved a railroad or train, this section supplies information on it.

This section is displayed in Extended and Complete detail reports.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
Grade Crossing (Yes/No)Indicates whether incident occurred at railroad grade crossing.char(1)3.15Extended and Complete 1990-2016
Location SubdivisionLocation subdivision name used to help define location of railroad incident.varchar(20)94.87Extended and Complete 1990-2016
Railroad MilepostRailroad milepost near which incident occurred.varchar(10)92.39Extended and Complete 1990-2016
Vehicle TypeType of vehicle involved in railroad grade crossing incident.varchar(20)98.96Extended and Complete 1990-2016
Crossing Device TypeType of crossing device used at railroad grade crossing incident.varchar(40)98.21Extended and Complete 1999-2016
Crossing Device Operational (Yes/No)Indicates whether crossing device used at railroad grade crossing incident was operational.char(1)3.15Extended and Complete 1990-2016
DOT Crossing NumberDOT number for crossing device used at railroad grade crossing incident.varchar(20)98.54Extended and Complete 1999-2016
Brake Failure (Yes/No)Indicates whether brake failure was involved in the railroad incident.char(1)3.07Extended and Complete 1990-2016
Railroad HotlineIndicates if indicent was received via the railroad hotline number.char(1)56.54Extended and Complete 1990-2012
Date Service Restored (Orig)Date on which normal transit service will be restored after railroad incident (in original format).varchar(25)99.80Complete only 2000-2006
Date Service RestoredDate on which normal transit service will be restored after railroad incident.date99.80Extended and Complete 2000-2006
Sub-Part C Testing RequiredWas Federal Post Accident 219.201 Subpart C testing performed (used for railroad incidents).char(3)0.02Extended and Complete 1990-2016
Conductors TestedNumber of conductors tested.char(3)99.70Extended and Complete 2005-2016
Engineers TestedNumber of engineers tested.char(3)99.73Extended and Complete 2005-2016
Trainmen TestedNumber of trainmen tested.char(3)99.98Extended and Complete 2005-2016
Yard Foremen TestedNumber of yard foremen tested.char(3)99.99Extended and Complete 2005-2016
RCL Operators TestedNumber of RCL operators tested.char(3)99.94Extended and Complete 2005-2016
Brakemen TestedNumber of brakemen tested.char(3)99.98Extended and Complete 2005-2016
Train Dispatchers TestedNumber of train dispatchers tested.char(3)99.99Extended and Complete 2006-2015
Signalmen TestedNumber of signalmen tested.char(3)99.99Extended and Complete 2006-2015
Other Employees TestedNumber of other employees tested.char(3)99.93Extended and Complete 2005-2016
Unknown Employees TestedNumber of employees of unknown classification tested.char(3)99.86Extended and Complete 2005-2016
Passenger HandlingHow passengers were handled (when a passenger train route was involved).varchar(240)97.61Extended and Complete 2006-2016
Passenger RouteIndicates whether the railroad incident was on a designated passenger route.char(3)0.05Extended and Complete 1990-2016
Passenger DelayIndicates whether a delay in passenger rail traffic occured.char(3)0.05Extended and Complete 1990-2016

Section: Train Details

This section supplies information on each (railroad) train involved in the incident.

This section can have more than one entry per record. The record with the most entries currently holds 10. Only the first of these is displayed if comma or tab-delimited format is chosen.

This section is displayed in Extended and Complete detail reports.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
Train NumberName or number of train.varchar(40)5.55Extended and Complete 1990-2016
Railroad NameName of railroad owning train.varchar(40)0.55Extended and Complete 1990-2016
Train TypeTranslation of a code for the type of train,varchar(10)29.98Extended and Complete 1990-2016
Track SpeedTrack speed of the track at the location of a railroad incident.varchar(12)77.91Extended and Complete 1999-2016
Train SpeedSpeed of a train just before a railroad incident.varchar(12)90.26Extended and Complete 1999-2016
Track DirectionDirection that a train was travelling in just before railroad incident.char(2)59.12Extended and Complete 1999-2016
Number Of LocomotivesNumber of locomotives attached to train.smallint(6)51.56Extended and Complete 1999-2016
Number Of CarsNumber of cars attached to train.smallint(6)50.66Extended and Complete 1999-2016
Number DerailedNumber of cars derailed during incident.smallint(6)81.28Extended and Complete 1991-2016
Hazmat Noncompliance (Yes/No)Indicates suspected noncompliance with DOT hazmat regulations.char(1)0.09Extended and Complete 1990-2016

Section: Derailed Train Details

This section supplies information on each derailed train car involved in a railroad incident.

This section can have more than one entry per record. The record with the most entries currently holds 48. Only the first of these is displayed if comma or tab-delimited format is chosen.

This section is displayed in Extended and Complete detail reports.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
Train NumberName or number of derailed train.varchar(40)2.80Extended and Complete 1991-2016
Car NumberIdentification number of derailed train car.varchar(15)2.03Extended and Complete 1991-2016
Cargo/ContentsCargo or contents of derailed train car.varchar(50)0.00Extended and Complete 1991-2016
Position In TrainPosition of derailed car within train.char(3)51.13Extended and Complete 1999-2016
Car TypeType of derailed train car (either car or locomotive).varchar(15)0.24Extended and Complete 1991-2016

Section: Storage Tank Details

If the incident involved a storage tank (for oil or chemicals), this section supplies details on it.

This section is displayed in Extended and Complete detail reports.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
Tank DescriptionDescription of a storage tank involved in the incident.varchar(40)93.78Extended and Complete 1999-2016
Tank Above GroundIndicates whether a storage tank involved in the incident is above or below ground.varchar(5)4.68Extended and Complete 1990-2016
Transportable Container (Yes/No)Indicates whether storage tank involved in the incident was a transportable container.char(1)96.83Extended and Complete 1990-2016
Tank Regulated (Yes/No)Indicates whether a storage tank involved in the incident is regulated.char(1)98.76Extended and Complete 1990-2016
Tank Regulated ByIndicates which agency regulates a storage tank involved in the incident.varchar(20)99.29Extended and Complete 1999-2016
Tank IDID number for a storage tank involved in the incident.varchar(20)98.46Extended and Complete 1999-2016
Tank CapacityCapacity of a storage tank involved in the incident.decimal(9,0)95.58Extended and Complete 1999-2016
Tank Capacity UnitsUnits of measurement of storage tank capacity.varchar(40)95.59Extended and Complete 1999-2016
Actual Amount In TankActual amount within storage tank at time of incident.decimal(9,0)98.48Extended and Complete 1999-2016
Tank Actual Amount UnitsUnits of measurement for actual amount within storage tank.varchar(40)98.43Extended and Complete 1999-2016

Section: Aircraft Details

If an aircraft was involved in the incident, this section supplies details about it.

This section is displayed in Extended and Complete detail reports.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
Aircraft TypeType of aircraft involved in the incident.varchar(10)99.65Extended and Complete 1990-2016
Aircraft ModelAircraft model involved in the incident.varchar(20)99.60Extended and Complete 1999-2016
Aircraft IDID number of an aircraft involved in the incident.varchar(30)99.72Extended and Complete 1999-2016
Air Fuel CapacityAir fuel capacity of an aircraft involved in the incident.varchar(12)99.92Extended and Complete 1999-2016
Air Fuel Capacity UnitsUnits of measurement of the air fuel capacity of an aircraft involved in the incident.varchar(40)99.94Extended and Complete 2000-2016
Air Fuel On BoardAmount of air fuel on board an aircraft involved in the incident.varchar(12)99.92Extended and Complete 2000-2016
Air Fuel On Board UnitsUnits of measurement for air fuel capacity.varchar(40)99.94Extended and Complete 2000-2016
Air Spot NumberNumber used to help define location of aircraft incident.varchar(12)99.90Extended and Complete 1999-2016
Air HangerHanger number used to help define location of the incident.varchar(12)99.95Extended and Complete 2000-2016
Air Runway NumberAir runway number used to help define the location of the incident.varchar(12)99.96Extended and Complete 2000-2016

Section: Vessel Incident

If the incident involved a (waterbourne) vessel, such as a ship or boat, then this section supplies information on it.

This section is displayed in Extended and Complete detail reports.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
Allision (Yes/No)An allision is accident in which a moving vessel strikes a fixed object or another vessel that is not under weigh.char(1)3.07Extended and Complete 1990-2016

Section: Vessel Details

This section supplies information on each (waterbourne) vessel, such as a ship or boat, involved in the incident.

This section can have more than one entry per record. The record with the most entries currently holds 10. Only the first of these is displayed if comma or tab-delimited format is chosen.

This section is displayed in Extended and Complete detail reports.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
Vessel NameName of ship involved in incident.varchar(30)31.08Extended and Complete 1990-2016
Vessel TypeType of ship involved in incident.varchar(40)33.22Extended and Complete 1990-2016
Vessel LengthLength of ship.smallint(6)66.74Extended and Complete 1999-2016
Hull ConstructionType of hull construction of ship.varchar(40)78.42Extended and Complete 1999-2016
Fuel CapacityFuel capacity of ship.varchar(12)82.13Extended and Complete 1999-2016
Fuel On BoardActual amount of fuel on board ship at time of incident.varchar(12)78.58Extended and Complete 1999-2016
Cargo CapacityCargo capacity of ship.varchar(12)90.75Extended and Complete 1999-2016
Cargo On BoardActual amount of cargo on board ship at time of incident.varchar(12)90.74Extended and Complete 1999-2016
Vessel Aground (Yes/No)Indicates whether vessel was aground at time of incident.char(1)0.00Extended and Complete 1990-2016
FlagNationality of registration (flag) of ship.varchar(40)67.68Extended and Complete 1999-2016
BreadthBreadth of ship.smallint(6)92.09Extended and Complete 1999-2016
DraughtDraught of ship.smallint(6)94.53Extended and Complete 1999-2016
Fuel Capacity UnitsUnits of measurement of fuel capacity of ship.varchar(40)93.05Extended and Complete 2000-2016
Fuel On Board UnitsUnits of measurement of fuel on board ship.varchar(40)91.63Extended and Complete 1999-2016
Cargo Capacity UnitsUnits of measurement of cargo capacity of ship.varchar(40)98.50Extended and Complete 2000-2016
Cargo On Board UnitsUnits of measurement for cargo on board ship.varchar(40)98.69Extended and Complete 2000-2016

Section: Weather

This section supplies information on the weather during the incident.

This section is displayed in Extended and Complete detail reports.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
Weather ConditionsTranslation of a code for the type of weather conditions during the incident.varchar(40)50.00Extended and Complete  
Air TemperatureThe air temperature during the incident.char(3)57.37Extended and Complete 1999-2016
Wind SpeedThe wind speed during the incident.char(3)81.81Extended and Complete 1999-2016
Wind DirectionPrevailing wind direction during the incident.varchar(40)90.04Extended and Complete  
Wind Speed UnitsUnits of measurement of the wind speed during the incident.varchar(40)82.10Extended and Complete 1999-2016

Section: Material In Water

If the incident involved a release of material to a water body, this section gives information on it.

This section is displayed in Extended and Complete detail reports.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
Body of WaterBody of water that hazardous materials were released to.varchar(40)68.87Extended and Complete 1990-2016
Tributary OfIndicates which major river the body of water affected by the release is a tributary of.varchar(40)82.67Extended and Complete 1999-2016
Nearest River Mile MarkerThe nearest river mile marker to the incident.varchar(100)100.00Extended and Complete -
Water Supply Contaminated (Yes/No)Indicates whether a drinking water supply was contaminated by the incident.char(1)86.41Extended and Complete 1990-2016
Wave ConditionCondition of the waves at the time of the incident.varchar(40)90.42Extended and Complete 1999-2016
Current SpeedSpeed of the water currents during the incident.char(3)97.27Extended and Complete 1999-2016
Current DirectionCompass direction in which the water currents were moving during the incident.varchar(40)97.51Extended and Complete  
Water TemperatureWater temperature at the time of the incident.char(3)99.26Extended and Complete 1999-2016
Current Speed UnitsUnits of measurement of the water current speed.varchar(40)93.57Extended and Complete 1999-2016
River Mile MarkerRiver mile marker near where the incident took place.varchar(10)98.48Extended and Complete 1990-2016
Offshore (Yes/No)Indicates whether incident occurred offshore.char(1)9.99Extended and Complete 1990-2016

Section: Unknown Sheen Details

If the incident involves a sheen of unknown material spotted on a body of water or an ocean, this section supplies details on it.

This section is displayed in Extended and Complete detail reports.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
Sheen SizeSize of the sheen of unknown material seen on water.varchar(20)74.56Extended and Complete 1982-1986
Sheen ColorApparent color of the sheen.varchar(40)83.21Extended and Complete  
Direction of Sheen TravelCompass direction in which the sheen was drifting.varchar(40)95.88Extended and Complete 1999-2016
Sheen OdorDescription of the odor of the sheen.varchar(40)94.16Extended and Complete 1999-2016
Sheen Size UnitsUnits of measurement of sheen size.varchar(40)100.00Extended and Complete -
Length of SheenThe length of the sheen.varchar(5)79.24Extended and Complete 1999-2016
Sheen Length UnitsUnits of measurement of the length of the sheen.varchar(40)79.32Extended and Complete 1999-2016
Width of SheenThe width of the sheen.varchar(5)80.86Extended and Complete 1999-2016
Sheen Width UnitsUnits of measurement of the width of the sheen.varchar(40)80.95Extended and Complete 1999-2016

Section: Disused Fields

This section supplies information from data fields within the database that have no longer been used since 1990 or earlier.

This section is displayed in Extended and Complete detail reports.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
Responding AgencyThe governmental agency responsible for dealing with the incident.varchar(40)23.10Extended and Complete 1982-1986
Incident Cause: Dumping (Yes/No)Indicates whether the incident was caused by illegal dumping of waste.char(1)0.00Extended and Complete 1987-1989
Incident Cause: Equipment Failure (Yes/No)Indicates whether the incident was caused by equipment failure.char(1)0.00Extended and Complete 1987-1989
Incident Cause: Natural (Yes/No)Indicates whether the incident was due to natural causes, such as weather.char(1)0.00Extended and Complete 1987-1989
Incident Cause: Operator Error (Yes/No)Indicates whether the incident was caused by operator error.char(1)0.00Extended and Complete 1987-1989
Incident Cause: Other (Yes/No)Indicates whether the incident was caused by some known factor other than dumping, equipment failure, natural causes, operator error, or transportation.char(1)0.00Extended and Complete 1987-1989
Incident Cause: Transportation (Yes/No)Indicates whether the incident occurred as an accident during transportation of hazardous material.char(1)0.00Extended and Complete 1987-1989
Incident Cause: Unknown (Yes/No)Indicates whether the incident occurred due to an unknown cause.char(1)0.00Extended and Complete 1987-1989
Coast Guard UnitThe identifier for the U.S. Coast Guard unit reporting the incident.varchar(5)62.73Extended and Complete 1987-1989
Unknown: CNOTIFUndocumented field with unknown meaning.varchar(30)50.06Complete only 1987-1989
Unknown: CODEUndocumented field with unknown meaning.char(3)96.29Complete only 1986-1989
Unknown: DCANLUndocumented field with unknown meaning.varchar(10)99.45Complete only 1982-1988
Unknown: DHCUndocumented field with unknown meaning.varchar(10)100.00Complete only 1983-1983
Date of CallThe date on which the call reporting the incident was received.varchar(9)39.89Complete only 1982-1989
Date of EntryThe date on which this incident record was entered into the database.varchar(9)0.00Complete only 1982-1989
Duty OfficerThe name or initials of the duty officer at the call center when the call was received.varchar(20)0.05Extended and Complete 1982-1989
Unknown: ERRCUndocumented field with unknown meaning.char(1)85.41Complete only 1982-1989
Unknown: IDUndocumented field with unknown meaning.int(11)0.00Complete only 1982-1989
Unknown: JURIUndocumented field with unknown meaning.char(1)99.32Complete only 1987-1989
Lbs. Released (1st)The amount of the first chemical released during the incident, in pounds.varchar(11)94.72Extended and Complete 1988-1988
Lbs. Released (2nd)The amount of the second chemical released during the incident, in pounds.varchar(11)100.00Extended and Complete -
Lbs. Released (3rd)The amount of the third chemical released during the incident, in pounds.varchar(11)100.00Extended and Complete -
Release Medium: Air (Yes/No)Indicates whether the incident involved releases to the air.char(1)0.00Extended and Complete 1987-1989
Release Medium: Facility (Yes/No)Indicates whether the incident involved releases to the grounds of a fixed facility.char(1)0.00Extended and Complete 1987-1989
Release Medium: Groundwater (Yes/No)Indicates whether the incident involved releases to groundwater.char(1)0.00Extended and Complete 1987-1989
Release Medium: Land (Yes/No)Indicates whether the incident involved releases to land.char(1)0.00Extended and Complete 1987-1989
Release Medium: Other (Yes/No)Indicates whether the incident involved releases to media other than air, land, water, groundwater, or a facility.char(1)0.00Extended and Complete 1987-1989
Release Medium: Water (Yes/No)Indicates whether the incident involved releases to water.char(1)0.00Extended and Complete 1987-1989
Unknown: MODUSUndocumented field with unknown meaning.char(2)0.95Extended and Complete 1982-1989
Notify CHEMTREC (Yes/No)Indicates whether CHEMTREC was notified of the incident.char(1)0.00Extended and Complete 1987-1989
Notify DIS (Yes/No)Indicates whether DIS was notified of the incident.char(1)0.00Extended and Complete 1987-1989
Notify DOT FAA (Yes/No)Indicates whether Dept. of Transportation -- FAA was notified of the incident.char(1)0.00Extended and Complete 1987-1989
Notify DOT FRA (Yes/No)Indicates whether Dept. of Transportation - FRA was notified of the incident.char(1)0.00Extended and Complete 1987-1989
Notify DOT OMCS (Yes/No)Indicates whether Dept. of Transportation - OMCS was notified of the incident.char(1)0.00Extended and Complete 1987-1989
Notify EPA (Yes/No)Indicates whether Federal EPA was notified of the incident.char(1)0.00Extended and Complete 1987-1989
Notify DOD (Yes/No)Indicates whether Dept. of Defense was notified of the incident.char(1)0.00Extended and Complete 1987-1989
Notify DOE (Yes/No)Indicates whether Dept. of Energy was notified of the incident.char(1)0.00Extended and Complete 1987-1989
Notify FEMA (Yes/No)Indicates whether FEMA was notified of the incident.char(1)0.00Extended and Complete 1987-1989
Notify NRC (Yes/No)Indicates whether Nuclear Regulatory Commission was notified of the incident.char(1)0.00Extended and Complete 1987-1989
Notify Other Agency (Yes/No)Indicates whether another agency, other than those listed in other fields, was notified of the incident.char(1)0.00Extended and Complete 1987-1989
Notify NTSB Pipe (Yes/No)Indicates whether Nat. Trans. Safety Board - Pipe was notified of the incident.char(1)0.00Extended and Complete 1987-1989
Notify NTSB Rail (Yes/No)Indicates whether Nat. Trans. Safety Board - Rail was notified of the incident.char(1)0.00Extended and Complete 1987-1989
Notify Unknown (Yes/No)Indicates whether an unknown agency was notified of the incident.char(1)0.00Extended and Complete 1987-1989
Notify RSPA OHM (Yes/No)Indicates whether RSPA OHM was notified of the incident.char(1)0.00Extended and Complete 1987-1989
Notify RSPA OPS (Yes/No)Indicates whether RSPA OPS was notified of the incident.char(1)0.00Extended and Complete 1987-1989
Notify State or Local Agency (Yes/No)Indicates whether a state or local governmental agency was notified of the incident.char(1)0.00Extended and Complete 1987-1989
Notify USCG (Yes/No)Indicates whether U.S. Coast Guard was notified of the incident.char(1)0.00Extended and Complete 1987-1989
Unknown: RAGE1Undocumented field with unknown meaning.char(1)0.00Complete only 1989-1989
Unknown: RAGE2Undocumented field with unknown meaning.char(1)0.00Complete only 1989-1989
Unknown: RAGE3Undocumented field with unknown meaning.char(1)0.00Complete only 1989-1989
EPA RegionEPA Region in which incident occurred.char(2)0.00Extended and Complete 1987-1989
Responsible Entity CountyThe county within which the entity responsible for the incident is located.varchar(20)95.45Extended and Complete 1988-1989
Unknown: RNAME1Undocumented field with unknown meaning.varchar(30)100.00Extended and Complete -
Unknown: RNAME2Undocumented field with unknown meaning.varchar(30)100.00Extended and Complete -
Unknown: RNAME3Undocumented field with unknown meaning.varchar(30)100.00Extended and Complete -
Unknown: RNOUndocumented field with unknown meaning.varchar(12)0.00Complete only 1987-1989
Unknown: RPTUndocumented field with unknown meaning.char(1)26.21Complete only 1982-1988
Time of ReportTime at which call reporting the incident was received.varchar(4)0.00Extended and Complete 1982-1989
Incident and Resp. Entity at Same LocationIndicates whether the incident occurred at the same location as the responsible entity.char(1)59.94Extended and Complete 1987-1989
Unknown: SEAUndocumented field with unknown meaning.varchar(10)86.05Extended and Complete 1982-1986
Incident ID NumberUnique ID number for each incident. Negative ID numbers were assigned by RTK NET to records in reporting years before 1990. Positive ID numbers are NRC Report Numbers.int(11)0.00Extended and Complete 1982-1989
ShipperThe name of the shipper involved in a transportation accident.varchar(60)95.32Extended and Complete 1982-1986
Source CodeCode for the type of source of the incident.char(2)0.00Extended and Complete 1987-1989
Unknown: SPILLERUndocumented field with unknown meaning.char(1)8.24Extended and Complete 1982-1986
Time: Coast GuardTime at which the incident was reported to the Coast Guard.varchar(4)36.60Extended and Complete 1987-1989
Time: EPATime at which the incident was reported to EPA.varchar(4)21.87Extended and Complete 1987-1989
Time: OtherTime at which the incident was reported to an agency other than the EPA or Coast Guard.varchar(4)51.60Extended and Complete 1987-1989
Time of IncidentTime at which the incident occurred.varchar(4)0.09Extended and Complete 1982-1986

Section: Record Counts

This section provides counts of numbers of subsidiary records (trains, vehicles, vessels, etc.) for the incident. It is used within delimited data so the user can see whether all data for an incident has been included.

This section is displayed in High through Complete detail reports.

Data FieldDescriptionField Type% blankLevel of Detail Year Range
Number of Materials RecordsNumber of Materials records for incident.smallint(6)6.52High through Complete  
Number of CR Materials RecordsNumber of Continuous Release Materials records for incident.smallint(6)99.21High through Complete 1990-2016
Number of Mobile Vehicle RecordsNumber of Mobile Details records for incident.smallint(6)90.15High through Complete  
Number of Train RecordsNumber of Trains records for incident.smallint(6)91.29High through Complete 1990-2016
Number of Derailed Train RecordsNumber of Derailed Trains records for incident.smallint(6)98.95High through Complete 1991-2016
Number of Vessel RecordsNumber of Vessels records for incident.smallint(6)86.52High through Complete 1990-2016

Incident-based delimited data reports

Data FieldDescriptionField Type% blankLevel of Detail Year Range
Incident ID NumberUnique ID number for each incident. Negative ID numbers were assigned by RTK NET to records in reporting years before 1990. Positive ID numbers are NRC Report Numbers.int(11)0.00All  
Date / Time Call ReceivedDate/time when the call reporting the incident was received.varchar(25)0.00Complete only  
Date / Time Call CompleteDate/time when the call reporting the incident was complete.varchar(25)0.25Complete only 1990-2016
Date Call ReceivedDate when the call reporting the incident was received.date0.04All  
Date Call CompleteDate when the call reporting the incident was complete.date0.25All 1990-2016
Call TypeCode for the type of call received (INC=Incident, DRL=drill).char(3)0.00All 1990-2016
Source of ReportTranslation of code for the type of source of the call or other report.varchar(15)39.98All 1990-2016
Call TakerName or initials of person receiving the call that reported the incident.varchar(16)6.58Extended and Complete 1990-2003
Resp. CompanyCompany responsible for the incident.varchar(40)36.80All 1987-2016
Resp. Organization TypeThe type of organization responsible for the incident.varchar(40)33.90All 1987-2016
Resp. CityThe city in the address of the entity responsible for the incident.varchar(30)37.14All 1987-2016
Resp. StateThe state in the address of the entity responsible for the incident.char(2)35.70All 1987-2016
Resp. Zip CodeThe Zip code in the address of the entity responsible for the incident.varchar(9)51.24All 1987-2016
Resp. AddressThe address of the entity responsible for the incident.varchar(40)41.98All 1987-2003
Resp. Street 1The first line of the street address of the entity responsible for the incident.varchar(40)91.16All 1990-2003
Resp. Street 2The second line of the street address of the entity responsible for the incident.varchar(40)99.03All 1990-2003
Resp. Last NameLast name of person responsible for incident.varchar(30)42.28All 1987-2003
Resp. First NameFirst name of person responsible for incident.varchar(30)38.06All 1990-2003
Resp. Phone 1First phone number of entity responsible for incident.varchar(10)44.85All 1987-2003
Resp. Phone 2Second phone number of entity responsible for incident.varchar(10)93.03All 1987-2003
Resp. Phone 3Third phone number of entity responsible for incident.varchar(10)99.43All 2000-2003
Resp. Phone Type 1Type of phone number for first phone number of responsible entity.varchar(9)37.77All 1990-2003
Resp. Phone Type 2Type of phone number for second phone number of responsible entity.varchar(9)93.33All 1990-2003
Resp. Phone Type 3Type of phone number for third phone number of responsible entity.varchar(9)99.45All 2000-2003
On Behalf OfThe Reporting party is calling on behalf of the Responsible party.char(1)100.00All -
Potential FlagIndicates whether the report is a potential release of material.char(1)43.06Extended and Complete 1999-2016
Incident DescriptionFree-text description of the incident.text95.47All  
Incident TypeTranslation of a code indicating the type of incident.varchar(40)0.00All 1990-2016
Incident CauseTranslation of a code indicating the cause of the incident.varchar(40)35.35All 1990-2016
Incident Date / TimeDate and time on which the incident occurred.varchar(25)0.16All  
Incident DateDate on which the incident occured.date0.31All  
Incident Occurred/ Discovered/ PlannedIndicates whether incident occurred by accident, was discovered after it occurred (i.e., dumping), or whether it was planned.varchar(10)0.03All 1987-2016
Additional InfoAdditional information on the incident.text98.95All  
Unknown: WMD_CHEM_FLAGUndocumented field with unknown meaning.char(1)24.90All 1999-2002
Radioactive Materials (Yes/No)Indicates whether radioactive materials were involved in the incident.char(1)2.17All 2000-2002
Biological Materials (Yes/No)Indicates whether biologically hazardous materials were involved in the incident.char(1)2.17All 2000-2002
Oil (Yes/No)Indicates whether oil or other petroleum substances were involved in the incident.char(1)60.67All 1999-2002
Unknown: POTENTIAL_FLAGUndocumented field with unknown meaning.char(1)96.94Extended and Complete 1999-2002
Unknown: AMT_MATERIAL_FLAGUndocumented field with unknown meaning.char(1)99.91Extended and Complete 1999-2002
Unknown: MILITARY_ORG_FLAGUndocumented field with unknown meaning.char(1)55.56Extended and Complete 1999-2002
Liquid Natural Gas (Yes/No)Indicates whether Liquid Natural Gas (LNG) was involved in the incident.char(1)99.99All 2000-2002
Incident LocationFree-text description of the location at which the incident occurred.varchar(240)55.50All  
Location AddressAddress at which the incident occurred.varchar(50)20.71All 1990-2016
Location Street 1First line of the street address at which the incident occurred.varchar(40)78.35All 1990-2016
Location Street 2Second line of the street address at which the incident occurred.varchar(40)95.22All 1990-2016
City Near LocationName of a city close to the location at which the incident occurred.varchar(30)13.41All 1987-2016
Location StateState within which the incident occurred.char(2)0.02All  
Location CountyCounty within which the incident occurred.varchar(30)0.05All 1987-2016
Location Zip CodeZip code for the address at which the incident occurred.varchar(9)67.23All 1990-2016
Distance From CityDistance from the city close to where the incident occurred.decimal(5,1)96.81All 1990-2016
Distance From City UnitsUnits of measurement for the distance from the city near where the incident occurred.varchar(40)96.83All 1990-2016
Direction From CityThe compass direction from the city near where the incident occurred to the location of the incident.char(3)96.86All 1990-2016
Latitude (Degrees)Latitude degrees of the location of the incident.char(2)88.24All 1990-2016
Latitude (Minutes)Latitude minutes of the location of the incident.char(2)88.25All 1990-2016
Latitude (Seconds)Latitude seconds of the location of the incident.char(2)88.71All 1990-2016
Latitude (Quadrant)Latitude quadrant of the location of the incident.char(1)88.56All 1990-2016
Longitude (Degrees)Longitude degrees of the location of the incident.varchar(4)88.25All 1990-2016
Longitude (Minutes)Longitude minutes of the location of the incident.char(2)88.25All 1990-2016
Longitude (Seconds)Longitude seconds of the location of the incident.char(2)88.72All 1990-2016
Longitude (Quadrant)Longitude quadrant of the location of the incident.char(1)88.62All 1990-2016
Location SectionSection in which the incident is located.varchar(30)97.71Extended and Complete 1990-2016
Location TownshipTownship in which the incident is located.varchar(30)97.70Extended and Complete 1990-2016
Location RangeMeaning of field is unclear.varchar(30)97.78Extended and Complete 1990-2016
Chris Code (#1)Identifying code for a type of material.char(3)10.48High through Complete  
CAS Number (#1)Identifying number for a particular chemical.varchar(12)93.65High through Complete 1988-2016
UN Number (#1)Identifying number for a material.varchar(8)97.69Extended and Complete 1988-1988
Amount Of Material (#1)Amount of material released during incident. For early years, this information may be in the Amount Of Material Units field.decimal(14,5)51.27High through Complete 1987-2016
Amount Of Material Units (#1)Units of measurement for amount of material released. For early years, this field will include the amount released as well.varchar(40)46.25High through Complete  
Name of Material (#1)The name of the material released during the incident.varchar(80)10.44High through Complete  
Material Reached Water (#1)Indicates whether released material reached water during the incident.varchar(7)0.00High through Complete 1990-2016
Amount In Water (#1)The amount of the released material that was released to water.decimal(14,5)80.20High through Complete 1987-2016
Amount In Water Units (#1)Units of measurement for the amount of the material released to the water.varchar(40)64.06High through Complete  
Chris Code (#2)Identifying code for a type of material.char(3)10.48High through Complete  
CAS Number (#2)Identifying number for a particular chemical.varchar(12)93.65High through Complete 1988-2016
UN Number (#2)Identifying number for a material.varchar(8)97.69Extended and Complete 1988-1988
Amount Of Material (#2)Amount of material released during incident. For early years, this information may be in the Amount Of Material Units field.decimal(14,5)51.27High through Complete 1987-2016
Amount Of Material Units (#2)Units of measurement for amount of material released. For early years, this field will include the amount released as well.varchar(40)46.25High through Complete  
Name of Material (#2)The name of the material released during the incident.varchar(80)10.44High through Complete  
Material Reached Water (#2)Indicates whether released material reached water during the incident.varchar(7)0.00High through Complete 1990-2016
Amount In Water (#2)The amount of the released material that was released to water.decimal(14,5)80.20High through Complete 1987-2016
Amount In Water Units (#2)Units of measurement for the amount of the material released to the water.varchar(40)64.06High through Complete  
Chris Code (#3)Identifying code for a type of material.char(3)10.48High through Complete  
CAS Number (#3)Identifying number for a particular chemical.varchar(12)93.65High through Complete 1988-2016
UN Number (#3)Identifying number for a material.varchar(8)97.69Extended and Complete 1988-1988
Amount Of Material (#3)Amount of material released during incident. For early years, this information may be in the Amount Of Material Units field.decimal(14,5)51.27High through Complete 1987-2016
Amount Of Material Units (#3)Units of measurement for amount of material released. For early years, this field will include the amount released as well.varchar(40)46.25High through Complete  
Name of Material (#3)The name of the material released during the incident.varchar(80)10.44High through Complete  
Material Reached Water (#3)Indicates whether released material reached water during the incident.varchar(7)0.00High through Complete 1990-2016
Amount In Water (#3)The amount of the released material that was released to water.decimal(14,5)80.20High through Complete 1987-2016
Amount In Water Units (#3)Units of measurement for the amount of the material released to the water.varchar(40)64.06High through Complete  
Fire Involved (Yes/No)Indicates whether the incident involved a fire.char(1)0.34All 1990-2016
Fire Extinguished (Yes/No)Indicates whether a fire involved with the incident had been extinguished by the time the incident was reported.char(1)98.43Extended and Complete 1990-2016
Evacuations (Yes/No)Indicates whether an evacuation took place in response to the incident.char(1)0.32All 1987-2016
Number EvacuatedNumber of people evacuated in response to incident.int(11)98.91All 1990-2016
Who EvacuatedDescription of who was evacuated in response to incident.varchar(40)98.49All 1999-2016
Radius of EvacuationRadius around incident within which people were evacuated.decimal(8,2)99.80All 2000-2016
Injuries (Yes/No)Indicates whether injuries occurred as a result of the incident.char(1)35.15All 1990-2016
Number InjuredNumber of people injured as a result of the incident.smallint(6)96.92All  
Number HospitalizedNumber of people hospitalized as a result of the incident.smallint(6)97.49All 1999-2016
Fatalities (Yes/No)Indicates whether people were killed as a result of the incident.char(1)35.13All 1990-2016
Number FatalitiesNumber of people killed as a result of the incident.smallint(6)97.32All  
Property Damage (Yes/No)Indicates whether property damage was caused by incident.char(1)0.32All 1987-2016
Property Damage (in Dollars)Amount of property damage caused by incident, in dollars.decimal(9,0)99.28All  
Air Corridor Closed (Yes/No)Indicates whether an air corridor was closed by the incident.char(1)6.70All 1990-2016
Air Corridor ClosedName of the air corridor closed by the incident.varchar(80)99.99All 2000-2016
Air Corridor Closure TimeLength of time air corridor was closed due to incident.decimal(5,1)100.00All 2000-2016
Waterway Closed (Yes/No)Indicates whether a waterway was closed by the incident.char(1)9.99All 1990-2016
Waterway ClosedName of the waterway closed by the incident.varchar(80)93.56All 1987-2016
Waterway Closure TimeLength of time a waterway was closed by the incident.decimal(5,1)99.98All 2000-2016
Road Closed (Yes/No)Indicates whether a road was closed by the incident.char(1)6.70All 1990-2016
Road ClosedName of the road closed by the incident.varchar(80)97.68All 1999-2016
Road Closure TimeLength of time a road was closed by the incident.decimal(5,1)98.64All 1999-2016
Road Closure DirectionDirection of the road closed by the incident.varchar(40)98.40All 1999-2016
Major Artery (Yes/No)Indicates whether the road closed by the incident was a major artery.char(1)9.99All 1990-2016
Track Closed (Yes/No)Indicates whether a railroad track was closed by the incident.char(1)9.99All 1990-2016
Track ClosedName of the section of railroad track closed by the incident.varchar(80)98.03All 1990-2016
Track Closure TimeLength of time a section of railroad track was closed by the incident.decimal(5,1)98.94All 1990-2016
Media InterestIndicates the level of news media interest in the incident (high, medium, low, or none).varchar(14)36.45All 1990-2016
Medium DescriptionDescription of which release media -- i.e. air, water, or land -- were affected by the incident.varchar(40)7.10All  
Additional Medium InfoAdditional information on the release media affected.varchar(80)14.96All 1990-2016
Track Closed DirectionDirection in which railroad track was closed by the incident.varchar(40)97.50All 1999-2016
Employee FatalitiesThe number of employee deaths due to the incident.smallint(6)99.80All 1999-2016
Passenger FatalitiesThe number of passenger deaths due to the incident.smallint(6)99.93All 2000-2016
Community Impact (Yes/No)Indicates whether there was community impact due to the incident.char(1)19.43All 1990-2007
Employee InjuriesThe number of employees injured due to the incident.smallint(6)99.79All 2000-2016
Passenger InjuriesThe number of passengers injured due to the incident.smallint(6)99.92All 1999-2016
Occupant FatalitiesThe number of occupants killed by the incident.smallint(6)99.28All 1999-2016
Road Closure UnitsUnits of measurement of road closure.varchar(40)100.00All -
Track Closure UnitsUnits of measurement of railroad track closure.varchar(40)100.00All -
Duration UnitsMeaning of field is unknown.varchar(40)94.84All 1999-2016
Passengers TransferredIndicates whether passengers were transferred (for railway incidents).char(3)0.00All 1990-2016
Continuous Release TypeTranslation of code for the type of continuous release.varchar(40)99.17Extended and Complete 1990-2016
Initial Continuous Release NumberID number for the initial record for this continuous release.varchar(7)99.30Extended and Complete 1990-2016
Continuous Release PermitPermit number for continuous release.varchar(10)99.94Extended and Complete 2000-2016
Continuous Release Begin Date (Orig)Date on which continuous release began, in original format..varchar(25)99.80Complete only 2001-2016
Continuous Release Begin DateDate on which continuous release began.date99.80Extended and Complete 2001-2016
Continuous Release End Date (Orig)Date on which continuous release ended, in original format.varchar(25)99.96Complete only 2001-2016
Continuous Release End DateDate on which continuous release ended.date99.96Extended and Complete 2001-2016
Continuous Release Change Date (Orig)Date on which continuous release changed, in original format.varchar(25)99.92Complete only 2001-2016
Continuous Release Change DateDate on which continuous release changed.date99.92Extended and Complete 2001-2016
Chris Code (#1)Identifying code for type of material.char(3)0.00High through Complete 1990-2016
CAS Number (#1)Identifying number for a particular chemical.varchar(12)56.40High through Complete 1996-2016
Name of Material (#1)Name of a material released as part of continuous release incident.varchar(80)0.00High through Complete 1990-2016
Upper Bounds Release Rate (#1)Upper bounds of release rate of continuous release.varchar(20)6.80High through Complete 1990-2016
Upper Bounds Rate Unit (Amount) (#1)The amount component of the units of measurement for upper bounds release rate in continuous release incident.varchar(40)64.26High through Complete 1990-2016
Upper Bounds Rate Unit (Per Time) (#1)The time component of the units of measurement for upper bounds release rate in continuous release incident.varchar(40)70.61High through Complete 1990-2016
Release Secured (Yes/No)Indicates whether the release had been secured at the time the report was made.char(1)63.97High through Complete 1990-2016
Estimated Release DurationThe estimated amount of time during which the release of hazardous material took place.varchar(12)94.82High through Complete 1999-2016
Release RateRate of release of hazardous material during the incident.varchar(20)98.95High through Complete 1999-2016
Remedial ActionFree-text description of actions taken to halt the incident.varchar(255)6.07High through Complete  
State/Local Agency On SceneThe state or local agency responding on-scene to the incident.varchar(40)64.69High through Complete 1999-2016
State Agency Report NumberThe report number for the incident from the responding state agency.varchar(30)65.70High through Complete 1999-2016
Other Agency NotifiedThe name of another agency notified about the incident.varchar(40)100.00High through Complete -
State/Local Agency NotifiedThe state or local agency notified of the incident.varchar(40)43.45High through Complete 1999-2016
Federal Agency NotifiedThe Federal agency notified of the incident.varchar(40)58.95High through Complete 1999-2016
Release Rate Units (Amount)Part of units of measurement for the release rate, i.e. if the rate was in tons per year, this field would hold the word tons.varchar(40)98.96High through Complete 1999-2016
Release Rate Units (Per Time)Part of units of measurement for the release rate, i.e. if rate was in tons per year, this field would hold the word year.varchar(40)98.99High through Complete 1999-2016
Platform Rig NameName of platform rig involved in incident.varchar(30)99.23Extended and Complete 1999-2016
Platform LetterIdentifying letter for platform involved in incident.text99.96Extended and Complete 2000-2016
Location Area IDArea ID number used to help define location of platform incident.varchar(40)94.08Extended and Complete 1998-2016
Location Block IDBlock ID number used to help define location of platform incident.varchar(10)94.62Extended and Complete 1998-2016
OCSG NumberOCSG identifying number for platform involved in incident.varchar(10)96.64Extended and Complete 1999-2016
OCSP NumberOCSP identifying number for platform involved in incident.varchar(10)99.62Extended and Complete 2000-2016
State Lease NumberState lease number for platform involved in incident.varchar(10)99.49Extended and Complete 1999-2016
Pier Dock NumberPier dock number for platform involved in incident.varchar(10)98.78Extended and Complete 1996-2016
Berth Slip NumberBerth slip number for platform involved in incident..varchar(10)99.17Extended and Complete 1998-2016
Building IDBuilding ID of a building at which the incident occurred.varchar(10)98.96Extended and Complete 1999-2016
Type of Fixed ObjectType of fixed object involved in the incident.varchar(40)79.60Extended and Complete 1990-2016
Power Gen. Facility (Yes/No)Indicates whether the incident involved a power generation facility.char(1)83.91Extended and Complete 1990-2016
Generating CapacityGenerating capacity of power generation facility involved in the incident.varchar(20)99.80Extended and Complete 2000-2016
Type Of FuelType of fuel for power plant involved in fixed incident.varchar(40)99.35Extended and Complete 1999-2016
NPDES IDID number for NPDES water pollution permit for facility at which incident took place.varchar(10)99.92Extended and Complete 2000-2016
NPDES Compliance (Yes/No)Indicates whether fixed facility at which incident took place is in compliance with its NPDES water pollution permits.char(1)99.13Extended and Complete 1990-2016
Type of StructureType of fixed structure involved in incident.varchar(40)99.88Extended and Complete 2000-2016
Structure NameName of fixed structure involved in incident.varchar(20)99.91Extended and Complete 2000-2016
Structure Operating (Yes/No)Indicates whether structure involved in incident was operating.char(1)3.07Extended and Complete 1990-2016
Road Mile MarkerMile marker number along a road on which the incident occurred.decimal(5,1)98.83Extended and Complete 1999-2016
Airbag Deployed (Yes/No)Indicates whether airbag deployed.char(1)59.18Extended and Complete 1994-2016
Bus Service Disruption TimeLength of time for which normal transit bus service was disrupted after mobile incident.decimal(5,1)99.99Extended and Complete 2000-2015
Bus Service Disruption Time UnitsUnits of measurement for time of disruption of normal transit service.varchar(40)99.98Extended and Complete 2000-2015
Transit Bus Involved (Yes/No)Indicates whether a transit bus was involved in a mobile incident.char(1)99.83Extended and Complete 2000-2016
Vehicle Number (#1)Vehicle ID number, such as a license plate number.varchar(20)23.12Extended and Complete  
Trailer Number (#1)Number of trailer involved in mobile incident.varchar(20)93.14Extended and Complete 1999-2016
Fuel Capacity (#1)Fuel capacity of vehicle in mobile incident.varchar(20)89.99Extended and Complete 1999-2016
Cargo Capacity (#1)Cargo capacity of vehicle in mobile incident.varchar(20)89.51Extended and Complete 1999-2016
Amount Of Cargo (#1)Actual amount of cargo on board vehicle in mobile incident.varchar(20)89.59Extended and Complete 1999-2016
Hazmat Carrier (Yes/No) (#1)Indicates whether vehicle involved in mobile incident was a hazardous materials carrier.char(1)75.90Extended and Complete 1990-2016
Carrier Licensed (Yes/No) (#1)Indicates whether vehicle in incident was licensed to carry hazardous materials.char(1)82.07Extended and Complete 1990-2016
Noncompliance With Hazmat (Yes/No) (#1)Indicates whether vehicle was not in compliance with hazardous material transport regulations.char(1)91.04Extended and Complete 1990-2016
Vehicle Type (#1)Translation of code for the type of vehicle involved in a mobile incident.varchar(40)33.13Extended and Complete 1990-2016
Cargo Capacity Units (#1)Units of measurement for cargo capacity.varchar(40)94.45Extended and Complete 1999-2016
Cargo On Board Units (#1)Units of measurement for amount of cargo on board vehicle.varchar(40)95.05Extended and Complete 1999-2016
Vehicle Year (#1)Year in which vehicle was built.varchar(4)100.00Extended and Complete -
Vehicle Make (#1)The make of a vehicle involved in the incident.varchar(30)100.00Extended and Complete -
Vehicle Model (#1)The model of a vehicle involved in the incident.varchar(30)100.00Extended and Complete -
Pipeline TypeType of pipeline involved in the incident.varchar(40)97.46Extended and Complete 1990-2016
DOT Regulated (Yes/No)Indicates whether pipeline involved in the incident was Dept. of Transportation regulated.char(1)98.15Extended and Complete 1990-2016
Pipeline Above GroundIndicates whether pipeline is above or below ground.varchar(5)3.15Extended and Complete 1990-2016
Pipeline Exposed Underwater (Yes/No)Indicates whether pipeline involved in the incident is exposed underwater.char(1)40.82Extended and Complete 1990-2016
Pipeline Covered (Yes/No)Indicates whether pipeline involved in the incident is covered.char(1)98.20Extended and Complete 1990-2016
Grade Crossing (Yes/No)Indicates whether incident occurred at railroad grade crossing.char(1)3.15Extended and Complete 1990-2016
Location SubdivisionLocation subdivision name used to help define location of railroad incident.varchar(20)94.87Extended and Complete 1990-2016
Railroad MilepostRailroad milepost near which incident occurred.varchar(10)92.39Extended and Complete 1990-2016
Vehicle TypeType of vehicle involved in railroad grade crossing incident.varchar(20)98.96Extended and Complete 1990-2016
Crossing Device TypeType of crossing device used at railroad grade crossing incident.varchar(40)98.21Extended and Complete 1999-2016
Crossing Device Operational (Yes/No)Indicates whether crossing device used at railroad grade crossing incident was operational.char(1)3.15Extended and Complete 1990-2016
DOT Crossing NumberDOT number for crossing device used at railroad grade crossing incident.varchar(20)98.54Extended and Complete 1999-2016
Brake Failure (Yes/No)Indicates whether brake failure was involved in the railroad incident.char(1)3.07Extended and Complete 1990-2016
Railroad HotlineIndicates if indicent was received via the railroad hotline number.char(1)56.54Extended and Complete 1990-2012
Date Service Restored (Orig)Date on which normal transit service will be restored after railroad incident (in original format).varchar(25)99.80Complete only 2000-2006
Date Service RestoredDate on which normal transit service will be restored after railroad incident.date99.80Extended and Complete 2000-2006
Sub-Part C Testing RequiredWas Federal Post Accident 219.201 Subpart C testing performed (used for railroad incidents).char(3)0.02Extended and Complete 1990-2016
Conductors TestedNumber of conductors tested.char(3)99.70Extended and Complete 2005-2016
Engineers TestedNumber of engineers tested.char(3)99.73Extended and Complete 2005-2016
Trainmen TestedNumber of trainmen tested.char(3)99.98Extended and Complete 2005-2016
Yard Foremen TestedNumber of yard foremen tested.char(3)99.99Extended and Complete 2005-2016
RCL Operators TestedNumber of RCL operators tested.char(3)99.94Extended and Complete 2005-2016
Brakemen TestedNumber of brakemen tested.char(3)99.98Extended and Complete 2005-2016
Train Dispatchers TestedNumber of train dispatchers tested.char(3)99.99Extended and Complete 2006-2015
Signalmen TestedNumber of signalmen tested.char(3)99.99Extended and Complete 2006-2015
Other Employees TestedNumber of other employees tested.char(3)99.93Extended and Complete 2005-2016
Unknown Employees TestedNumber of employees of unknown classification tested.char(3)99.86Extended and Complete 2005-2016
Passenger HandlingHow passengers were handled (when a passenger train route was involved).varchar(240)97.61Extended and Complete 2006-2016
Passenger RouteIndicates whether the railroad incident was on a designated passenger route.char(3)0.05Extended and Complete 1990-2016
Passenger DelayIndicates whether a delay in passenger rail traffic occured.char(3)0.05Extended and Complete 1990-2016
Train Number (#1)Name or number of train.varchar(40)5.55Extended and Complete 1990-2016
Railroad Name (#1)Name of railroad owning train.varchar(40)0.55Extended and Complete 1990-2016
Train Type (#1)Translation of a code for the type of train,varchar(10)29.98Extended and Complete 1990-2016
Track Speed (#1)Track speed of the track at the location of a railroad incident.varchar(12)77.91Extended and Complete 1999-2016
Train Speed (#1)Speed of a train just before a railroad incident.varchar(12)90.26Extended and Complete 1999-2016
Track Direction (#1)Direction that a train was travelling in just before railroad incident.char(2)59.12Extended and Complete 1999-2016
Number Of Locomotives (#1)Number of locomotives attached to train.smallint(6)51.56Extended and Complete 1999-2016
Number Of Cars (#1)Number of cars attached to train.smallint(6)50.66Extended and Complete 1999-2016
Number Derailed (#1)Number of cars derailed during incident.smallint(6)81.28Extended and Complete 1991-2016
Hazmat Noncompliance (Yes/No) (#1)Indicates suspected noncompliance with DOT hazmat regulations.char(1)0.09Extended and Complete 1990-2016
Train Number (#1)Name or number of derailed train.varchar(40)2.80Extended and Complete 1991-2016
Car Number (#1)Identification number of derailed train car.varchar(15)2.03Extended and Complete 1991-2016
Cargo/Contents (#1)Cargo or contents of derailed train car.varchar(50)0.00Extended and Complete 1991-2016
Position In Train (#1)Position of derailed car within train.char(3)51.13Extended and Complete 1999-2016
Car Type (#1)Type of derailed train car (either car or locomotive).varchar(15)0.24Extended and Complete 1991-2016
Tank DescriptionDescription of a storage tank involved in the incident.varchar(40)93.78Extended and Complete 1999-2016
Tank Above GroundIndicates whether a storage tank involved in the incident is above or below ground.varchar(5)4.68Extended and Complete 1990-2016
Transportable Container (Yes/No)Indicates whether storage tank involved in the incident was a transportable container.char(1)96.83Extended and Complete 1990-2016
Tank Regulated (Yes/No)Indicates whether a storage tank involved in the incident is regulated.char(1)98.76Extended and Complete 1990-2016
Tank Regulated ByIndicates which agency regulates a storage tank involved in the incident.varchar(20)99.29Extended and Complete 1999-2016
Tank IDID number for a storage tank involved in the incident.varchar(20)98.46Extended and Complete 1999-2016
Tank CapacityCapacity of a storage tank involved in the incident.decimal(9,0)95.58Extended and Complete 1999-2016
Tank Capacity UnitsUnits of measurement of storage tank capacity.varchar(40)95.59Extended and Complete 1999-2016
Actual Amount In TankActual amount within storage tank at time of incident.decimal(9,0)98.48Extended and Complete 1999-2016
Tank Actual Amount UnitsUnits of measurement for actual amount within storage tank.varchar(40)98.43Extended and Complete 1999-2016
Aircraft TypeType of aircraft involved in the incident.varchar(10)99.65Extended and Complete 1990-2016
Aircraft ModelAircraft model involved in the incident.varchar(20)99.60Extended and Complete 1999-2016
Aircraft IDID number of an aircraft involved in the incident.varchar(30)99.72Extended and Complete 1999-2016
Air Fuel CapacityAir fuel capacity of an aircraft involved in the incident.varchar(12)99.92Extended and Complete 1999-2016
Air Fuel Capacity UnitsUnits of measurement of the air fuel capacity of an aircraft involved in the incident.varchar(40)99.94Extended and Complete 2000-2016
Air Fuel On BoardAmount of air fuel on board an aircraft involved in the incident.varchar(12)99.92Extended and Complete 2000-2016
Air Fuel On Board UnitsUnits of measurement for air fuel capacity.varchar(40)99.94Extended and Complete 2000-2016
Air Spot NumberNumber used to help define location of aircraft incident.varchar(12)99.90Extended and Complete 1999-2016
Air HangerHanger number used to help define location of the incident.varchar(12)99.95Extended and Complete 2000-2016
Air Runway NumberAir runway number used to help define the location of the incident.varchar(12)99.96Extended and Complete 2000-2016
Allision (Yes/No)An allision is accident in which a moving vessel strikes a fixed object or another vessel that is not under weigh.char(1)3.07Extended and Complete 1990-2016
Vessel Name (#1)Name of ship involved in incident.varchar(30)31.08Extended and Complete 1990-2016
Vessel Type (#1)Type of ship involved in incident.varchar(40)33.22Extended and Complete 1990-2016
Vessel Length (#1)Length of ship.smallint(6)66.74Extended and Complete 1999-2016
Hull Construction (#1)Type of hull construction of ship.varchar(40)78.42Extended and Complete 1999-2016
Fuel Capacity (#1)Fuel capacity of ship.varchar(12)82.13Extended and Complete 1999-2016
Fuel On Board (#1)Actual amount of fuel on board ship at time of incident.varchar(12)78.58Extended and Complete 1999-2016
Cargo Capacity (#1)Cargo capacity of ship.varchar(12)90.75Extended and Complete 1999-2016
Cargo On Board (#1)Actual amount of cargo on board ship at time of incident.varchar(12)90.74Extended and Complete 1999-2016
Vessel Aground (Yes/No) (#1)Indicates whether vessel was aground at time of incident.char(1)0.00Extended and Complete 1990-2016
Flag (#1)Nationality of registration (flag) of ship.varchar(40)67.68Extended and Complete 1999-2016
Breadth (#1)Breadth of ship.smallint(6)92.09Extended and Complete 1999-2016
Draught (#1)Draught of ship.smallint(6)94.53Extended and Complete 1999-2016
Fuel Capacity Units (#1)Units of measurement of fuel capacity of ship.varchar(40)93.05Extended and Complete 2000-2016
Fuel On Board Units (#1)Units of measurement of fuel on board ship.varchar(40)91.63Extended and Complete 1999-2016
Cargo Capacity Units (#1)Units of measurement of cargo capacity of ship.varchar(40)98.50Extended and Complete 2000-2016
Cargo On Board Units (#1)Units of measurement for cargo on board ship.varchar(40)98.69Extended and Complete 2000-2016
Weather ConditionsTranslation of a code for the type of weather conditions during the incident.varchar(40)50.00Extended and Complete  
Air TemperatureThe air temperature during the incident.char(3)57.37Extended and Complete 1999-2016
Wind SpeedThe wind speed during the incident.char(3)81.81Extended and Complete 1999-2016
Wind DirectionPrevailing wind direction during the incident.varchar(40)90.04Extended and Complete  
Wind Speed UnitsUnits of measurement of the wind speed during the incident.varchar(40)82.10Extended and Complete 1999-2016
Body of WaterBody of water that hazardous materials were released to.varchar(40)68.87Extended and Complete 1990-2016
Tributary OfIndicates which major river the body of water affected by the release is a tributary of.varchar(40)82.67Extended and Complete 1999-2016
Nearest River Mile MarkerThe nearest river mile marker to the incident.varchar(100)100.00Extended and Complete -
Water Supply Contaminated (Yes/No)Indicates whether a drinking water supply was contaminated by the incident.char(1)86.41Extended and Complete 1990-2016
Wave ConditionCondition of the waves at the time of the incident.varchar(40)90.42Extended and Complete 1999-2016
Current SpeedSpeed of the water currents during the incident.char(3)97.27Extended and Complete 1999-2016
Current DirectionCompass direction in which the water currents were moving during the incident.varchar(40)97.51Extended and Complete  
Water TemperatureWater temperature at the time of the incident.char(3)99.26Extended and Complete 1999-2016
Current Speed UnitsUnits of measurement of the water current speed.varchar(40)93.57Extended and Complete 1999-2016
River Mile MarkerRiver mile marker near where the incident took place.varchar(10)98.48Extended and Complete 1990-2016
Offshore (Yes/No)Indicates whether incident occurred offshore.char(1)9.99Extended and Complete 1990-2016
Sheen SizeSize of the sheen of unknown material seen on water.varchar(20)74.56Extended and Complete 1982-1986
Sheen ColorApparent color of the sheen.varchar(40)83.21Extended and Complete  
Direction of Sheen TravelCompass direction in which the sheen was drifting.varchar(40)95.88Extended and Complete 1999-2016
Sheen OdorDescription of the odor of the sheen.varchar(40)94.16Extended and Complete 1999-2016
Sheen Size UnitsUnits of measurement of sheen size.varchar(40)100.00Extended and Complete -
Length of SheenThe length of the sheen.varchar(5)79.24Extended and Complete 1999-2016
Sheen Length UnitsUnits of measurement of the length of the sheen.varchar(40)79.32Extended and Complete 1999-2016
Width of SheenThe width of the sheen.varchar(5)80.86Extended and Complete 1999-2016
Sheen Width UnitsUnits of measurement of the width of the sheen.varchar(40)80.95Extended and Complete 1999-2016
Responding AgencyThe governmental agency responsible for dealing with the incident.varchar(40)23.10Extended and Complete 1982-1986
Incident Cause: Dumping (Yes/No)Indicates whether the incident was caused by illegal dumping of waste.char(1)0.00Extended and Complete 1987-1989
Incident Cause: Equipment Failure (Yes/No)Indicates whether the incident was caused by equipment failure.char(1)0.00Extended and Complete 1987-1989
Incident Cause: Natural (Yes/No)Indicates whether the incident was due to natural causes, such as weather.char(1)0.00Extended and Complete 1987-1989
Incident Cause: Operator Error (Yes/No)Indicates whether the incident was caused by operator error.char(1)0.00Extended and Complete 1987-1989
Incident Cause: Other (Yes/No)Indicates whether the incident was caused by some known factor other than dumping, equipment failure, natural causes, operator error, or transportation.char(1)0.00Extended and Complete 1987-1989
Incident Cause: Transportation (Yes/No)Indicates whether the incident occurred as an accident during transportation of hazardous material.char(1)0.00Extended and Complete 1987-1989
Incident Cause: Unknown (Yes/No)Indicates whether the incident occurred due to an unknown cause.char(1)0.00Extended and Complete 1987-1989
Coast Guard UnitThe identifier for the U.S. Coast Guard unit reporting the incident.varchar(5)62.73Extended and Complete 1987-1989
Unknown: CNOTIFUndocumented field with unknown meaning.varchar(30)50.06Complete only 1987-1989
Unknown: CODEUndocumented field with unknown meaning.char(3)96.29Complete only 1986-1989
Unknown: DCANLUndocumented field with unknown meaning.varchar(10)99.45Complete only 1982-1988
Unknown: DHCUndocumented field with unknown meaning.varchar(10)100.00Complete only 1983-1983
Date of CallThe date on which the call reporting the incident was received.varchar(9)39.89Complete only 1982-1989
Date of EntryThe date on which this incident record was entered into the database.varchar(9)0.00Complete only 1982-1989
Duty OfficerThe name or initials of the duty officer at the call center when the call was received.varchar(20)0.05Extended and Complete 1982-1989
Unknown: ERRCUndocumented field with unknown meaning.char(1)85.41Complete only 1982-1989
Unknown: IDUndocumented field with unknown meaning.int(11)0.00Complete only 1982-1989
Unknown: JURIUndocumented field with unknown meaning.char(1)99.32Complete only 1987-1989
Lbs. Released (1st)The amount of the first chemical released during the incident, in pounds.varchar(11)94.72Extended and Complete 1988-1988
Lbs. Released (2nd)The amount of the second chemical released during the incident, in pounds.varchar(11)100.00Extended and Complete -
Lbs. Released (3rd)The amount of the third chemical released during the incident, in pounds.varchar(11)100.00Extended and Complete -
Release Medium: Air (Yes/No)Indicates whether the incident involved releases to the air.char(1)0.00Extended and Complete 1987-1989
Release Medium: Facility (Yes/No)Indicates whether the incident involved releases to the grounds of a fixed facility.char(1)0.00Extended and Complete 1987-1989
Release Medium: Groundwater (Yes/No)Indicates whether the incident involved releases to groundwater.char(1)0.00Extended and Complete 1987-1989
Release Medium: Land (Yes/No)Indicates whether the incident involved releases to land.char(1)0.00Extended and Complete 1987-1989
Release Medium: Other (Yes/No)Indicates whether the incident involved releases to media other than air, land, water, groundwater, or a facility.char(1)0.00Extended and Complete 1987-1989
Release Medium: Water (Yes/No)Indicates whether the incident involved releases to water.char(1)0.00Extended and Complete 1987-1989
Unknown: MODUSUndocumented field with unknown meaning.char(2)0.95Extended and Complete 1982-1989
Notify CHEMTREC (Yes/No)Indicates whether CHEMTREC was notified of the incident.char(1)0.00Extended and Complete 1987-1989
Notify DIS (Yes/No)Indicates whether DIS was notified of the incident.char(1)0.00Extended and Complete 1987-1989
Notify DOT FAA (Yes/No)Indicates whether Dept. of Transportation -- FAA was notified of the incident.char(1)0.00Extended and Complete 1987-1989
Notify DOT FRA (Yes/No)Indicates whether Dept. of Transportation - FRA was notified of the incident.char(1)0.00Extended and Complete 1987-1989
Notify DOT OMCS (Yes/No)Indicates whether Dept. of Transportation - OMCS was notified of the incident.char(1)0.00Extended and Complete 1987-1989
Notify EPA (Yes/No)Indicates whether Federal EPA was notified of the incident.char(1)0.00Extended and Complete 1987-1989
Notify DOD (Yes/No)Indicates whether Dept. of Defense was notified of the incident.char(1)0.00Extended and Complete 1987-1989
Notify DOE (Yes/No)Indicates whether Dept. of Energy was notified of the incident.char(1)0.00Extended and Complete 1987-1989
Notify FEMA (Yes/No)Indicates whether FEMA was notified of the incident.char(1)0.00Extended and Complete 1987-1989
Notify NRC (Yes/No)Indicates whether Nuclear Regulatory Commission was notified of the incident.char(1)0.00Extended and Complete 1987-1989
Notify Other Agency (Yes/No)Indicates whether another agency, other than those listed in other fields, was notified of the incident.char(1)0.00Extended and Complete 1987-1989
Notify NTSB Pipe (Yes/No)Indicates whether Nat. Trans. Safety Board - Pipe was notified of the incident.char(1)0.00Extended and Complete 1987-1989
Notify NTSB Rail (Yes/No)Indicates whether Nat. Trans. Safety Board - Rail was notified of the incident.char(1)0.00Extended and Complete 1987-1989
Notify Unknown (Yes/No)Indicates whether an unknown agency was notified of the incident.char(1)0.00Extended and Complete 1987-1989
Notify RSPA OHM (Yes/No)Indicates whether RSPA OHM was notified of the incident.char(1)0.00Extended and Complete 1987-1989
Notify RSPA OPS (Yes/No)Indicates whether RSPA OPS was notified of the incident.char(1)0.00Extended and Complete 1987-1989
Notify State or Local Agency (Yes/No)Indicates whether a state or local governmental agency was notified of the incident.char(1)0.00Extended and Complete 1987-1989
Notify USCG (Yes/No)Indicates whether U.S. Coast Guard was notified of the incident.char(1)0.00Extended and Complete 1987-1989
Unknown: RAGE1Undocumented field with unknown meaning.char(1)0.00Complete only 1989-1989
Unknown: RAGE2Undocumented field with unknown meaning.char(1)0.00Complete only 1989-1989
Unknown: RAGE3Undocumented field with unknown meaning.char(1)0.00Complete only 1989-1989
EPA RegionEPA Region in which incident occurred.char(2)0.00Extended and Complete 1987-1989
Responsible Entity CountyThe county within which the entity responsible for the incident is located.varchar(20)95.45Extended and Complete 1988-1989
Unknown: RNAME1Undocumented field with unknown meaning.varchar(30)100.00Extended and Complete -
Unknown: RNAME2Undocumented field with unknown meaning.varchar(30)100.00Extended and Complete -
Unknown: RNAME3Undocumented field with unknown meaning.varchar(30)100.00Extended and Complete -
Unknown: RNOUndocumented field with unknown meaning.varchar(12)0.00Complete only 1987-1989
Unknown: RPTUndocumented field with unknown meaning.char(1)26.21Complete only 1982-1988
Time of ReportTime at which call reporting the incident was received.varchar(4)0.00Extended and Complete 1982-1989
Incident and Resp. Entity at Same LocationIndicates whether the incident occurred at the same location as the responsible entity.char(1)59.94Extended and Complete 1987-1989
Unknown: SEAUndocumented field with unknown meaning.varchar(10)86.05Extended and Complete 1982-1986
Incident ID NumberUnique ID number for each incident. Negative ID numbers were assigned by RTK NET to records in reporting years before 1990. Positive ID numbers are NRC Report Numbers.int(11)0.00Extended and Complete 1982-1989
ShipperThe name of the shipper involved in a transportation accident.varchar(60)95.32Extended and Complete 1982-1986
Source CodeCode for the type of source of the incident.char(2)0.00Extended and Complete 1987-1989
Unknown: SPILLERUndocumented field with unknown meaning.char(1)8.24Extended and Complete 1982-1986
Time: Coast GuardTime at which the incident was reported to the Coast Guard.varchar(4)36.60Extended and Complete 1987-1989
Time: EPATime at which the incident was reported to EPA.varchar(4)21.87Extended and Complete 1987-1989
Time: OtherTime at which the incident was reported to an agency other than the EPA or Coast Guard.varchar(4)51.60Extended and Complete 1987-1989
Time of IncidentTime at which the incident occurred.varchar(4)0.09Extended and Complete 1982-1986
Number of Materials RecordsNumber of Materials records for incident.smallint(6)6.52High through Complete  
Number of CR Materials RecordsNumber of Continuous Release Materials records for incident.smallint(6)99.21High through Complete 1990-2016
Number of Mobile Vehicle RecordsNumber of Mobile Details records for incident.smallint(6)90.15High through Complete  
Number of Train RecordsNumber of Trains records for incident.smallint(6)91.29High through Complete 1990-2016
Number of Derailed Train RecordsNumber of Derailed Trains records for incident.smallint(6)98.95High through Complete 1991-2016
Number of Vessel RecordsNumber of Vessels records for incident.smallint(6)86.52High through Complete 1990-2016