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.24Complete only 1990-2018
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.24All 1990-2018
Call TypeCode for the type of call received (INC=Incident, DRL=drill).char(3)0.00All 1990-2018
Source of ReportTranslation of code for the type of source of the call or other report.varchar(15)38.25All 1990-2018
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)37.18All 1987-2018
Resp. Organization TypeThe type of organization responsible for the incident.varchar(40)34.17All 1987-2018
Resp. CityThe city in the address of the entity responsible for the incident.varchar(30)37.56All 1987-2018
Resp. StateThe state in the address of the entity responsible for the incident.char(2)36.06All 1987-2018
Resp. Zip CodeThe Zip code in the address of the entity responsible for the incident.varchar(9)51.99All 1987-2018
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)40.34Extended and Complete 1999-2018
Incident DescriptionFree-text description of the incident.text95.63All  
Incident TypeTranslation of a code indicating the type of incident.varchar(40)0.00All 1990-2018
Incident CauseTranslation of a code indicating the cause of the incident.varchar(40)35.43All 1990-2018
Incident Date / TimeDate and time on which the incident occurred.varchar(25)0.16All  
Incident DateDate on which the incident occured.date0.29All  
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-2018
Additional InfoAdditional information on the incident.text98.98All  
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.43All  
Location AddressAddress at which the incident occurred.varchar(50)20.48All 1990-2018
Location Street 1First line of the street address at which the incident occurred.varchar(40)78.39All 1990-2018
Location Street 2Second line of the street address at which the incident occurred.varchar(40)95.27All 1990-2018
City Near LocationName of a city close to the location at which the incident occurred.varchar(30)13.25All 1987-2018
Location StateState within which the incident occurred.char(2)0.02All  
Location CountyCounty within which the incident occurred.varchar(30)0.05All 1987-2018
Location Zip CodeZip code for the address at which the incident occurred.varchar(9)67.70All 1990-2018
Distance From CityDistance from the city close to where the incident occurred.decimal(5,1)96.92All 1990-2018
Distance From City UnitsUnits of measurement for the distance from the city near where the incident occurred.varchar(40)96.94All 1990-2018
Direction From CityThe compass direction from the city near where the incident occurred to the location of the incident.char(3)96.97All 1990-2018
Latitude (Degrees)Latitude degrees of the location of the incident.char(2)88.13All 1990-2018
Latitude (Minutes)Latitude minutes of the location of the incident.char(2)88.13All 1990-2018
Latitude (Seconds)Latitude seconds of the location of the incident.char(2)88.58All 1990-2018
Latitude (Quadrant)Latitude quadrant of the location of the incident.char(1)88.43All 1990-2018
Longitude (Degrees)Longitude degrees of the location of the incident.varchar(4)88.13All 1990-2018
Longitude (Minutes)Longitude minutes of the location of the incident.char(2)88.14All 1990-2018
Longitude (Seconds)Longitude seconds of the location of the incident.char(2)88.59All 1990-2018
Longitude (Quadrant)Longitude quadrant of the location of the incident.char(1)88.50All 1990-2018
Location SectionSection in which the incident is located.varchar(30)97.77Extended and Complete 1990-2018
Location TownshipTownship in which the incident is located.varchar(30)97.76Extended and Complete 1990-2018
Location RangeMeaning of field is unclear.varchar(30)97.84Extended and Complete 1990-2018

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.12High through Complete  
CAS NumberIdentifying number for a particular chemical.varchar(12)93.56High through Complete 1988-2018
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.41High through Complete 1987-2018
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.54High through Complete  
Name of MaterialThe name of the material released during the incident.varchar(80)10.09High through Complete  
Material Reached WaterIndicates whether released material reached water during the incident.varchar(7)0.00High through Complete 1990-2018
Amount In WaterThe amount of the released material that was released to water.decimal(14,5)80.30High through Complete 1987-2018
Amount In Water UnitsUnits of measurement for the amount of the material released to the water.varchar(40)64.69High 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.32All 1990-2018
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.36Extended and Complete 1990-2018
Evacuations (Yes/No)Indicates whether an evacuation took place in response to the incident.char(1)0.30All 1987-2018
Number EvacuatedNumber of people evacuated in response to incident.int(11)98.92All 1990-2018
Who EvacuatedDescription of who was evacuated in response to incident.varchar(40)98.49All 1999-2018
Radius of EvacuationRadius around incident within which people were evacuated.decimal(8,2)99.80All 2000-2018
Injuries (Yes/No)Indicates whether injuries occurred as a result of the incident.char(1)33.67All 1990-2018
Number InjuredNumber of people injured as a result of the incident.smallint(6)96.90All  
Number HospitalizedNumber of people hospitalized as a result of the incident.smallint(6)97.47All 1999-2018
Fatalities (Yes/No)Indicates whether people were killed as a result of the incident.char(1)33.62All 1990-2018
Number FatalitiesNumber of people killed as a result of the incident.smallint(6)97.24All  
Property Damage (Yes/No)Indicates whether property damage was caused by incident.char(1)0.30All 1987-2018
Property Damage (in Dollars)Amount of property damage caused by incident, in dollars.decimal(9,0)99.26All  
Air Corridor Closed (Yes/No)Indicates whether an air corridor was closed by the incident.char(1)6.41All 1990-2018
Air Corridor ClosedName of the air corridor closed by the incident.varchar(80)99.99All 2000-2017
Air Corridor Closure TimeLength of time air corridor was closed due to incident.decimal(5,1)100.00All 2000-2017
Waterway Closed (Yes/No)Indicates whether a waterway was closed by the incident.char(1)9.56All 1990-2018
Waterway ClosedName of the waterway closed by the incident.varchar(80)93.82All 1987-2018
Waterway Closure TimeLength of time a waterway was closed by the incident.decimal(5,1)99.98All 2000-2017
Road Closed (Yes/No)Indicates whether a road was closed by the incident.char(1)6.41All 1990-2018
Road ClosedName of the road closed by the incident.varchar(80)97.69All 1999-2018
Road Closure TimeLength of time a road was closed by the incident.decimal(5,1)98.67All 1999-2018
Road Closure DirectionDirection of the road closed by the incident.varchar(40)98.41All 1999-2018
Major Artery (Yes/No)Indicates whether the road closed by the incident was a major artery.char(1)9.56All 1990-2018
Track Closed (Yes/No)Indicates whether a railroad track was closed by the incident.char(1)9.56All 1990-2018
Track ClosedName of the section of railroad track closed by the incident.varchar(80)97.92All 1990-2018
Track Closure TimeLength of time a section of railroad track was closed by the incident.decimal(5,1)98.90All 1990-2018
Media InterestIndicates the level of news media interest in the incident (high, medium, low, or none).varchar(14)34.87All 1990-2018
Medium DescriptionDescription of which release media -- i.e. air, water, or land -- were affected by the incident.varchar(40)6.84All  
Additional Medium InfoAdditional information on the release media affected.varchar(80)14.78All 1990-2018
Track Closed DirectionDirection in which railroad track was closed by the incident.varchar(40)97.42All 1999-2018
Employee FatalitiesThe number of employee deaths due to the incident.smallint(6)99.80All 1999-2018
Passenger FatalitiesThe number of passenger deaths due to the incident.smallint(6)99.92All 2000-2018
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-2018
Passenger InjuriesThe number of passengers injured due to the incident.smallint(6)99.92All 1999-2018
Occupant FatalitiesThe number of occupants killed by the incident.smallint(6)99.27All 1999-2018
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)95.11All 1999-2018
Passengers TransferredIndicates whether passengers were transferred (for railway incidents).char(3)0.00All 1990-2018

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.20Extended and Complete 1990-2018
Initial Continuous Release NumberID number for the initial record for this continuous release.varchar(7)99.32Extended and Complete 1990-2018
Continuous Release PermitPermit number for continuous release.varchar(10)99.94Extended and Complete 2000-2018
Continuous Release Begin Date (Orig)Date on which continuous release began, in original format..varchar(25)99.81Complete only 2001-2018
Continuous Release Begin DateDate on which continuous release began.date99.81Extended and Complete 2001-2018
Continuous Release End Date (Orig)Date on which continuous release ended, in original format.varchar(25)99.97Complete only 2001-2017
Continuous Release End DateDate on which continuous release ended.date99.97Extended and Complete 2001-2017
Continuous Release Change Date (Orig)Date on which continuous release changed, in original format.varchar(25)99.92Complete only 2001-2018
Continuous Release Change DateDate on which continuous release changed.date99.92Extended and Complete 2001-2018

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-2018
CAS NumberIdentifying number for a particular chemical.varchar(12)55.94High through Complete 1996-2018
Name of MaterialName of a material released as part of continuous release incident.varchar(80)0.00High through Complete 1990-2018
Upper Bounds Release RateUpper bounds of release rate of continuous release.varchar(20)6.78High through Complete 1990-2018
Upper Bounds Rate Unit (Amount)The amount component of the units of measurement for upper bounds release rate in continuous release incident.varchar(40)63.86High through Complete 1990-2018
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.18High through Complete 1990-2018

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.37High through Complete 1990-2018
Estimated Release DurationThe estimated amount of time during which the release of hazardous material took place.varchar(12)95.09High through Complete 1999-2018
Release RateRate of release of hazardous material during the incident.varchar(20)99.00High through Complete 1999-2018
Remedial ActionFree-text description of actions taken to halt the incident.varchar(255)6.40High through Complete  
State/Local Agency On SceneThe state or local agency responding on-scene to the incident.varchar(40)65.97High through Complete 1999-2018
State Agency Report NumberThe report number for the incident from the responding state agency.varchar(30)67.15High through Complete 1999-2018
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)45.02High through Complete 1999-2018
Federal Agency NotifiedThe Federal agency notified of the incident.varchar(40)60.57High through Complete 1999-2018
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)99.00High through Complete 1999-2018
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)99.03High through Complete 1999-2018

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.25Extended and Complete 1999-2018
Platform LetterIdentifying letter for platform involved in incident.text99.96Extended and Complete 2000-2018
Location Area IDArea ID number used to help define location of platform incident.varchar(40)94.14Extended and Complete 1998-2018
Location Block IDBlock ID number used to help define location of platform incident.varchar(10)94.66Extended and Complete 1998-2018
OCSG NumberOCSG identifying number for platform involved in incident.varchar(10)96.74Extended and Complete 1999-2018
OCSP NumberOCSP identifying number for platform involved in incident.varchar(10)99.64Extended and Complete 2000-2018
State Lease NumberState lease number for platform involved in incident.varchar(10)99.50Extended and Complete 1999-2018
Pier Dock NumberPier dock number for platform involved in incident.varchar(10)98.79Extended and Complete 1996-2018
Berth Slip NumberBerth slip number for platform involved in incident..varchar(10)99.17Extended and Complete 1998-2018

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.94Extended and Complete 1999-2018
Type of Fixed ObjectType of fixed object involved in the incident.varchar(40)79.27Extended and Complete 1990-2018
Power Gen. Facility (Yes/No)Indicates whether the incident involved a power generation facility.char(1)83.91Extended and Complete 1990-2018
Generating CapacityGenerating capacity of power generation facility involved in the incident.varchar(20)99.80Extended and Complete 2000-2018
Type Of FuelType of fuel for power plant involved in fixed incident.varchar(40)99.36Extended and Complete 1999-2018
NPDES IDID number for NPDES water pollution permit for facility at which incident took place.varchar(10)99.92Extended and Complete 2000-2017
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.16Extended and Complete 1990-2018
Type of StructureType of fixed structure involved in incident.varchar(40)99.87Extended and Complete 2000-2018
Structure NameName of fixed structure involved in incident.varchar(20)99.91Extended and Complete 2000-2018
Structure Operating (Yes/No)Indicates whether structure involved in incident was operating.char(1)2.94Extended and Complete 1990-2018

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.82Extended and Complete 1999-2018
Airbag Deployed (Yes/No)Indicates whether airbag deployed.char(1)56.23Extended and Complete 1994-2018
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-2018

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)22.06Extended and Complete  
Trailer NumberNumber of trailer involved in mobile incident.varchar(20)93.25Extended and Complete 1999-2018
Fuel CapacityFuel capacity of vehicle in mobile incident.varchar(20)90.39Extended and Complete 1999-2018
Cargo CapacityCargo capacity of vehicle in mobile incident.varchar(20)90.00Extended and Complete 1999-2018
Amount Of CargoActual amount of cargo on board vehicle in mobile incident.varchar(20)90.04Extended and Complete 1999-2018
Hazmat Carrier (Yes/No)Indicates whether vehicle involved in mobile incident was a hazardous materials carrier.char(1)76.47Extended and Complete 1990-2018
Carrier Licensed (Yes/No)Indicates whether vehicle in incident was licensed to carry hazardous materials.char(1)82.66Extended and Complete 1990-2018
Noncompliance With Hazmat (Yes/No)Indicates whether vehicle was not in compliance with hazardous material transport regulations.char(1)91.42Extended and Complete 1990-2018
Vehicle TypeTranslation of code for the type of vehicle involved in a mobile incident.varchar(40)31.54Extended and Complete 1990-2018
Cargo Capacity UnitsUnits of measurement for cargo capacity.varchar(40)94.62Extended and Complete 1999-2018
Cargo On Board UnitsUnits of measurement for amount of cargo on board vehicle.varchar(40)95.15Extended and Complete 1999-2018
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.36Extended and Complete 1990-2018
DOT Regulated (Yes/No)Indicates whether pipeline involved in the incident was Dept. of Transportation regulated.char(1)98.06Extended and Complete 1990-2018
Pipeline Above GroundIndicates whether pipeline is above or below ground.varchar(5)3.01Extended and Complete 1990-2018
Pipeline Exposed Underwater (Yes/No)Indicates whether pipeline involved in the incident is exposed underwater.char(1)39.05Extended and Complete 1990-2018
Pipeline Covered (Yes/No)Indicates whether pipeline involved in the incident is covered.char(1)98.26Extended and Complete 1990-2018

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.01Extended and Complete 1990-2018
Location SubdivisionLocation subdivision name used to help define location of railroad incident.varchar(20)94.64Extended and Complete 1990-2018
Railroad MilepostRailroad milepost near which incident occurred.varchar(10)92.25Extended and Complete 1990-2018
Vehicle TypeType of vehicle involved in railroad grade crossing incident.varchar(20)98.90Extended and Complete 1990-2018
Crossing Device TypeType of crossing device used at railroad grade crossing incident.varchar(40)98.14Extended and Complete 1999-2018
Crossing Device Operational (Yes/No)Indicates whether crossing device used at railroad grade crossing incident was operational.char(1)3.01Extended and Complete 1990-2018
DOT Crossing NumberDOT number for crossing device used at railroad grade crossing incident.varchar(20)98.47Extended and Complete 1999-2018
Brake Failure (Yes/No)Indicates whether brake failure was involved in the railroad incident.char(1)2.94Extended and Complete 1990-2018
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.01Extended and Complete 1990-2018
Conductors TestedNumber of conductors tested.char(3)99.68Extended and Complete 2005-2018
Engineers TestedNumber of engineers tested.char(3)99.72Extended and Complete 2005-2018
Trainmen TestedNumber of trainmen tested.char(3)99.98Extended and Complete 2005-2018
Yard Foremen TestedNumber of yard foremen tested.char(3)99.99Extended and Complete 2005-2018
RCL Operators TestedNumber of RCL operators tested.char(3)99.94Extended and Complete 2005-2018
Brakemen TestedNumber of brakemen tested.char(3)99.98Extended and Complete 2005-2018
Train Dispatchers TestedNumber of train dispatchers tested.char(3)99.99Extended and Complete 2006-2018
Signalmen TestedNumber of signalmen tested.char(3)99.99Extended and Complete 2006-2018
Other Employees TestedNumber of other employees tested.char(3)99.93Extended and Complete 2005-2018
Unknown Employees TestedNumber of employees of unknown classification tested.char(3)99.84Extended and Complete 2005-2018
Passenger HandlingHow passengers were handled (when a passenger train route was involved).varchar(240)97.55Extended and Complete 2006-2018
Passenger RouteIndicates whether the railroad incident was on a designated passenger route.char(3)0.05Extended and Complete 1990-2018
Passenger DelayIndicates whether a delay in passenger rail traffic occured.char(3)0.05Extended and Complete 1990-2018

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.43Extended and Complete 1990-2018
Railroad NameName of railroad owning train.varchar(40)0.53Extended and Complete 1990-2018
Train TypeTranslation of a code for the type of train,varchar(10)28.34Extended and Complete 1990-2018
Track SpeedTrack speed of the track at the location of a railroad incident.varchar(12)79.04Extended and Complete 1999-2018
Train SpeedSpeed of a train just before a railroad incident.varchar(12)90.72Extended and Complete 1999-2018
Track DirectionDirection that a train was travelling in just before railroad incident.char(2)59.97Extended and Complete 1999-2018
Number Of LocomotivesNumber of locomotives attached to train.smallint(6)53.49Extended and Complete 1999-2018
Number Of CarsNumber of cars attached to train.smallint(6)52.47Extended and Complete 1999-2018
Number DerailedNumber of cars derailed during incident.smallint(6)81.60Extended and Complete 1991-2018
Hazmat Noncompliance (Yes/No)Indicates suspected noncompliance with DOT hazmat regulations.char(1)0.09Extended and Complete 1990-2018

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.78Extended and Complete 1991-2018
Car NumberIdentification number of derailed train car.varchar(15)1.98Extended and Complete 1991-2018
Cargo/ContentsCargo or contents of derailed train car.varchar(50)0.00Extended and Complete 1991-2018
Position In TrainPosition of derailed car within train.char(3)51.13Extended and Complete 1999-2018
Car TypeType of derailed train car (either car or locomotive).varchar(15)0.23Extended and Complete 1991-2018

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.84Extended and Complete 1999-2018
Tank Above GroundIndicates whether a storage tank involved in the incident is above or below ground.varchar(5)4.48Extended and Complete 1990-2018
Transportable Container (Yes/No)Indicates whether storage tank involved in the incident was a transportable container.char(1)96.80Extended and Complete 1990-2018
Tank Regulated (Yes/No)Indicates whether a storage tank involved in the incident is regulated.char(1)98.77Extended and Complete 1990-2018
Tank Regulated ByIndicates which agency regulates a storage tank involved in the incident.varchar(20)99.30Extended and Complete 1999-2018
Tank IDID number for a storage tank involved in the incident.varchar(20)98.48Extended and Complete 1999-2018
Tank CapacityCapacity of a storage tank involved in the incident.decimal(9,0)95.63Extended and Complete 1999-2018
Tank Capacity UnitsUnits of measurement of storage tank capacity.varchar(40)95.64Extended and Complete 1999-2018
Actual Amount In TankActual amount within storage tank at time of incident.decimal(9,0)98.50Extended and Complete 1999-2018
Tank Actual Amount UnitsUnits of measurement for actual amount within storage tank.varchar(40)98.46Extended and Complete 1999-2018

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.64Extended and Complete 1990-2018
Aircraft ModelAircraft model involved in the incident.varchar(20)99.60Extended and Complete 1999-2018
Aircraft IDID number of an aircraft involved in the incident.varchar(30)99.71Extended and Complete 1999-2018
Air Fuel CapacityAir fuel capacity of an aircraft involved in the incident.varchar(12)99.92Extended and Complete 1999-2018
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-2018
Air Fuel On BoardAmount of air fuel on board an aircraft involved in the incident.varchar(12)99.93Extended and Complete 2000-2018
Air Fuel On Board UnitsUnits of measurement for air fuel capacity.varchar(40)99.94Extended and Complete 2000-2018
Air Spot NumberNumber used to help define location of aircraft incident.varchar(12)99.90Extended and Complete 1999-2018
Air HangerHanger number used to help define location of the incident.varchar(12)99.96Extended and Complete 2000-2018
Air Runway NumberAir runway number used to help define the location of the incident.varchar(12)99.96Extended and Complete 2000-2018

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)2.94Extended and Complete 1990-2018

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 12. 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)29.43Extended and Complete 1990-2018
Vessel TypeType of ship involved in incident.varchar(40)31.66Extended and Complete 1990-2018
Vessel LengthLength of ship.smallint(6)67.29Extended and Complete 1999-2018
Hull ConstructionType of hull construction of ship.varchar(40)79.10Extended and Complete 1999-2018
Fuel CapacityFuel capacity of ship.varchar(12)82.96Extended and Complete 1999-2018
Fuel On BoardActual amount of fuel on board ship at time of incident.varchar(12)78.84Extended and Complete 1999-2018
Cargo CapacityCargo capacity of ship.varchar(12)91.39Extended and Complete 1999-2018
Cargo On BoardActual amount of cargo on board ship at time of incident.varchar(12)91.37Extended and Complete 1999-2018
Vessel Aground (Yes/No)Indicates whether vessel was aground at time of incident.char(1)0.00Extended and Complete 1990-2018
FlagNationality of registration (flag) of ship.varchar(40)68.76Extended and Complete 1999-2018
BreadthBreadth of ship.smallint(6)92.59Extended and Complete 1999-2018
DraughtDraught of ship.smallint(6)94.89Extended and Complete 1999-2018
Fuel Capacity UnitsUnits of measurement of fuel capacity of ship.varchar(40)93.31Extended and Complete 2000-2018
Fuel On Board UnitsUnits of measurement of fuel on board ship.varchar(40)91.50Extended and Complete 1999-2018
Cargo Capacity UnitsUnits of measurement of cargo capacity of ship.varchar(40)98.60Extended and Complete 2000-2018
Cargo On Board UnitsUnits of measurement for cargo on board ship.varchar(40)98.76Extended and Complete 2000-2018

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)49.63Extended and Complete  
Air TemperatureThe air temperature during the incident.char(3)58.59Extended and Complete 1999-2018
Wind SpeedThe wind speed during the incident.char(3)82.53Extended and Complete 1999-2018
Wind DirectionPrevailing wind direction during the incident.varchar(40)90.22Extended and Complete  
Wind Speed UnitsUnits of measurement of the wind speed during the incident.varchar(40)82.81Extended and Complete 1999-2018

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.06Extended and Complete 1990-2018
Tributary OfIndicates which major river the body of water affected by the release is a tributary of.varchar(40)82.85Extended and Complete 1999-2018
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.94Extended and Complete 1990-2018
Wave ConditionCondition of the waves at the time of the incident.varchar(40)90.83Extended and Complete 1999-2018
Current SpeedSpeed of the water currents during the incident.char(3)97.40Extended and Complete 1999-2018
Current DirectionCompass direction in which the water currents were moving during the incident.varchar(40)97.57Extended and Complete  
Water TemperatureWater temperature at the time of the incident.char(3)99.29Extended and Complete 1999-2018
Current Speed UnitsUnits of measurement of the water current speed.varchar(40)93.93Extended and Complete 1999-2018
River Mile MarkerRiver mile marker near where the incident took place.varchar(10)98.49Extended and Complete 1990-2018
Offshore (Yes/No)Indicates whether incident occurred offshore.char(1)9.56Extended and Complete 1990-2018

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)82.91Extended and Complete  
Direction of Sheen TravelCompass direction in which the sheen was drifting.varchar(40)96.06Extended and Complete 1999-2018
Sheen OdorDescription of the odor of the sheen.varchar(40)94.26Extended and Complete 1999-2018
Sheen Size UnitsUnits of measurement of sheen size.varchar(40)100.00Extended and Complete -
Length of SheenThe length of the sheen.varchar(5)79.27Extended and Complete 1999-2018
Sheen Length UnitsUnits of measurement of the length of the sheen.varchar(40)79.34Extended and Complete 1999-2018
Width of SheenThe width of the sheen.varchar(5)80.92Extended and Complete 1999-2018
Sheen Width UnitsUnits of measurement of the width of the sheen.varchar(40)81.00Extended and Complete 1999-2018

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.60High through Complete  
Number of CR Materials RecordsNumber of Continuous Release Materials records for incident.smallint(6)99.23High through Complete 1990-2018
Number of Mobile Vehicle RecordsNumber of Mobile Details records for incident.smallint(6)90.06High through Complete  
Number of Train RecordsNumber of Trains records for incident.smallint(6)91.14High through Complete 1990-2018
Number of Derailed Train RecordsNumber of Derailed Trains records for incident.smallint(6)98.96High through Complete 1991-2018
Number of Vessel RecordsNumber of Vessels records for incident.smallint(6)86.39High through Complete 1990-2018

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.24Complete only 1990-2018
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.24All 1990-2018
Call TypeCode for the type of call received (INC=Incident, DRL=drill).char(3)0.00All 1990-2018
Source of ReportTranslation of code for the type of source of the call or other report.varchar(15)38.25All 1990-2018
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)37.18All 1987-2018
Resp. Organization TypeThe type of organization responsible for the incident.varchar(40)34.17All 1987-2018
Resp. CityThe city in the address of the entity responsible for the incident.varchar(30)37.56All 1987-2018
Resp. StateThe state in the address of the entity responsible for the incident.char(2)36.06All 1987-2018
Resp. Zip CodeThe Zip code in the address of the entity responsible for the incident.varchar(9)51.99All 1987-2018
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)40.34Extended and Complete 1999-2018
Incident DescriptionFree-text description of the incident.text95.63All  
Incident TypeTranslation of a code indicating the type of incident.varchar(40)0.00All 1990-2018
Incident CauseTranslation of a code indicating the cause of the incident.varchar(40)35.43All 1990-2018
Incident Date / TimeDate and time on which the incident occurred.varchar(25)0.16All  
Incident DateDate on which the incident occured.date0.29All  
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-2018
Additional InfoAdditional information on the incident.text98.98All  
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.43All  
Location AddressAddress at which the incident occurred.varchar(50)20.48All 1990-2018
Location Street 1First line of the street address at which the incident occurred.varchar(40)78.39All 1990-2018
Location Street 2Second line of the street address at which the incident occurred.varchar(40)95.27All 1990-2018
City Near LocationName of a city close to the location at which the incident occurred.varchar(30)13.25All 1987-2018
Location StateState within which the incident occurred.char(2)0.02All  
Location CountyCounty within which the incident occurred.varchar(30)0.05All 1987-2018
Location Zip CodeZip code for the address at which the incident occurred.varchar(9)67.70All 1990-2018
Distance From CityDistance from the city close to where the incident occurred.decimal(5,1)96.92All 1990-2018
Distance From City UnitsUnits of measurement for the distance from the city near where the incident occurred.varchar(40)96.94All 1990-2018
Direction From CityThe compass direction from the city near where the incident occurred to the location of the incident.char(3)96.97All 1990-2018
Latitude (Degrees)Latitude degrees of the location of the incident.char(2)88.13All 1990-2018
Latitude (Minutes)Latitude minutes of the location of the incident.char(2)88.13All 1990-2018
Latitude (Seconds)Latitude seconds of the location of the incident.char(2)88.58All 1990-2018
Latitude (Quadrant)Latitude quadrant of the location of the incident.char(1)88.43All 1990-2018
Longitude (Degrees)Longitude degrees of the location of the incident.varchar(4)88.13All 1990-2018
Longitude (Minutes)Longitude minutes of the location of the incident.char(2)88.14All 1990-2018
Longitude (Seconds)Longitude seconds of the location of the incident.char(2)88.59All 1990-2018
Longitude (Quadrant)Longitude quadrant of the location of the incident.char(1)88.50All 1990-2018
Location SectionSection in which the incident is located.varchar(30)97.77Extended and Complete 1990-2018
Location TownshipTownship in which the incident is located.varchar(30)97.76Extended and Complete 1990-2018
Location RangeMeaning of field is unclear.varchar(30)97.84Extended and Complete 1990-2018
Chris Code (#1)Identifying code for a type of material.char(3)10.12High through Complete  
CAS Number (#1)Identifying number for a particular chemical.varchar(12)93.56High through Complete 1988-2018
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.41High through Complete 1987-2018
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.54High through Complete  
Name of Material (#1)The name of the material released during the incident.varchar(80)10.09High through Complete  
Material Reached Water (#1)Indicates whether released material reached water during the incident.varchar(7)0.00High through Complete 1990-2018
Amount In Water (#1)The amount of the released material that was released to water.decimal(14,5)80.30High through Complete 1987-2018
Amount In Water Units (#1)Units of measurement for the amount of the material released to the water.varchar(40)64.69High through Complete  
Chris Code (#2)Identifying code for a type of material.char(3)10.12High through Complete  
CAS Number (#2)Identifying number for a particular chemical.varchar(12)93.56High through Complete 1988-2018
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.41High through Complete 1987-2018
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.54High through Complete  
Name of Material (#2)The name of the material released during the incident.varchar(80)10.09High through Complete  
Material Reached Water (#2)Indicates whether released material reached water during the incident.varchar(7)0.00High through Complete 1990-2018
Amount In Water (#2)The amount of the released material that was released to water.decimal(14,5)80.30High through Complete 1987-2018
Amount In Water Units (#2)Units of measurement for the amount of the material released to the water.varchar(40)64.69High through Complete  
Chris Code (#3)Identifying code for a type of material.char(3)10.12High through Complete  
CAS Number (#3)Identifying number for a particular chemical.varchar(12)93.56High through Complete 1988-2018
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.41High through Complete 1987-2018
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.54High through Complete  
Name of Material (#3)The name of the material released during the incident.varchar(80)10.09High through Complete  
Material Reached Water (#3)Indicates whether released material reached water during the incident.varchar(7)0.00High through Complete 1990-2018
Amount In Water (#3)The amount of the released material that was released to water.decimal(14,5)80.30High through Complete 1987-2018
Amount In Water Units (#3)Units of measurement for the amount of the material released to the water.varchar(40)64.69High through Complete  
Fire Involved (Yes/No)Indicates whether the incident involved a fire.char(1)0.32All 1990-2018
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.36Extended and Complete 1990-2018
Evacuations (Yes/No)Indicates whether an evacuation took place in response to the incident.char(1)0.30All 1987-2018
Number EvacuatedNumber of people evacuated in response to incident.int(11)98.92All 1990-2018
Who EvacuatedDescription of who was evacuated in response to incident.varchar(40)98.49All 1999-2018
Radius of EvacuationRadius around incident within which people were evacuated.decimal(8,2)99.80All 2000-2018
Injuries (Yes/No)Indicates whether injuries occurred as a result of the incident.char(1)33.67All 1990-2018
Number InjuredNumber of people injured as a result of the incident.smallint(6)96.90All  
Number HospitalizedNumber of people hospitalized as a result of the incident.smallint(6)97.47All 1999-2018
Fatalities (Yes/No)Indicates whether people were killed as a result of the incident.char(1)33.62All 1990-2018
Number FatalitiesNumber of people killed as a result of the incident.smallint(6)97.24All  
Property Damage (Yes/No)Indicates whether property damage was caused by incident.char(1)0.30All 1987-2018
Property Damage (in Dollars)Amount of property damage caused by incident, in dollars.decimal(9,0)99.26All  
Air Corridor Closed (Yes/No)Indicates whether an air corridor was closed by the incident.char(1)6.41All 1990-2018
Air Corridor ClosedName of the air corridor closed by the incident.varchar(80)99.99All 2000-2017
Air Corridor Closure TimeLength of time air corridor was closed due to incident.decimal(5,1)100.00All 2000-2017
Waterway Closed (Yes/No)Indicates whether a waterway was closed by the incident.char(1)9.56All 1990-2018
Waterway ClosedName of the waterway closed by the incident.varchar(80)93.82All 1987-2018
Waterway Closure TimeLength of time a waterway was closed by the incident.decimal(5,1)99.98All 2000-2017
Road Closed (Yes/No)Indicates whether a road was closed by the incident.char(1)6.41All 1990-2018
Road ClosedName of the road closed by the incident.varchar(80)97.69All 1999-2018
Road Closure TimeLength of time a road was closed by the incident.decimal(5,1)98.67All 1999-2018
Road Closure DirectionDirection of the road closed by the incident.varchar(40)98.41All 1999-2018
Major Artery (Yes/No)Indicates whether the road closed by the incident was a major artery.char(1)9.56All 1990-2018
Track Closed (Yes/No)Indicates whether a railroad track was closed by the incident.char(1)9.56All 1990-2018
Track ClosedName of the section of railroad track closed by the incident.varchar(80)97.92All 1990-2018
Track Closure TimeLength of time a section of railroad track was closed by the incident.decimal(5,1)98.90All 1990-2018
Media InterestIndicates the level of news media interest in the incident (high, medium, low, or none).varchar(14)34.87All 1990-2018
Medium DescriptionDescription of which release media -- i.e. air, water, or land -- were affected by the incident.varchar(40)6.84All  
Additional Medium InfoAdditional information on the release media affected.varchar(80)14.78All 1990-2018
Track Closed DirectionDirection in which railroad track was closed by the incident.varchar(40)97.42All 1999-2018
Employee FatalitiesThe number of employee deaths due to the incident.smallint(6)99.80All 1999-2018
Passenger FatalitiesThe number of passenger deaths due to the incident.smallint(6)99.92All 2000-2018
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-2018
Passenger InjuriesThe number of passengers injured due to the incident.smallint(6)99.92All 1999-2018
Occupant FatalitiesThe number of occupants killed by the incident.smallint(6)99.27All 1999-2018
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)95.11All 1999-2018
Passengers TransferredIndicates whether passengers were transferred (for railway incidents).char(3)0.00All 1990-2018
Continuous Release TypeTranslation of code for the type of continuous release.varchar(40)99.20Extended and Complete 1990-2018
Initial Continuous Release NumberID number for the initial record for this continuous release.varchar(7)99.32Extended and Complete 1990-2018
Continuous Release PermitPermit number for continuous release.varchar(10)99.94Extended and Complete 2000-2018
Continuous Release Begin Date (Orig)Date on which continuous release began, in original format..varchar(25)99.81Complete only 2001-2018
Continuous Release Begin DateDate on which continuous release began.date99.81Extended and Complete 2001-2018
Continuous Release End Date (Orig)Date on which continuous release ended, in original format.varchar(25)99.97Complete only 2001-2017
Continuous Release End DateDate on which continuous release ended.date99.97Extended and Complete 2001-2017
Continuous Release Change Date (Orig)Date on which continuous release changed, in original format.varchar(25)99.92Complete only 2001-2018
Continuous Release Change DateDate on which continuous release changed.date99.92Extended and Complete 2001-2018
Chris Code (#1)Identifying code for type of material.char(3)0.00High through Complete 1990-2018
CAS Number (#1)Identifying number for a particular chemical.varchar(12)55.94High through Complete 1996-2018
Name of Material (#1)Name of a material released as part of continuous release incident.varchar(80)0.00High through Complete 1990-2018
Upper Bounds Release Rate (#1)Upper bounds of release rate of continuous release.varchar(20)6.78High through Complete 1990-2018
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)63.86High through Complete 1990-2018
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.18High through Complete 1990-2018
Release Secured (Yes/No)Indicates whether the release had been secured at the time the report was made.char(1)63.37High through Complete 1990-2018
Estimated Release DurationThe estimated amount of time during which the release of hazardous material took place.varchar(12)95.09High through Complete 1999-2018
Release RateRate of release of hazardous material during the incident.varchar(20)99.00High through Complete 1999-2018
Remedial ActionFree-text description of actions taken to halt the incident.varchar(255)6.40High through Complete  
State/Local Agency On SceneThe state or local agency responding on-scene to the incident.varchar(40)65.97High through Complete 1999-2018
State Agency Report NumberThe report number for the incident from the responding state agency.varchar(30)67.15High through Complete 1999-2018
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)45.02High through Complete 1999-2018
Federal Agency NotifiedThe Federal agency notified of the incident.varchar(40)60.57High through Complete 1999-2018
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)99.00High through Complete 1999-2018
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)99.03High through Complete 1999-2018
Platform Rig NameName of platform rig involved in incident.varchar(30)99.25Extended and Complete 1999-2018
Platform LetterIdentifying letter for platform involved in incident.text99.96Extended and Complete 2000-2018
Location Area IDArea ID number used to help define location of platform incident.varchar(40)94.14Extended and Complete 1998-2018
Location Block IDBlock ID number used to help define location of platform incident.varchar(10)94.66Extended and Complete 1998-2018
OCSG NumberOCSG identifying number for platform involved in incident.varchar(10)96.74Extended and Complete 1999-2018
OCSP NumberOCSP identifying number for platform involved in incident.varchar(10)99.64Extended and Complete 2000-2018
State Lease NumberState lease number for platform involved in incident.varchar(10)99.50Extended and Complete 1999-2018
Pier Dock NumberPier dock number for platform involved in incident.varchar(10)98.79Extended and Complete 1996-2018
Berth Slip NumberBerth slip number for platform involved in incident..varchar(10)99.17Extended and Complete 1998-2018
Building IDBuilding ID of a building at which the incident occurred.varchar(10)98.94Extended and Complete 1999-2018
Type of Fixed ObjectType of fixed object involved in the incident.varchar(40)79.27Extended and Complete 1990-2018
Power Gen. Facility (Yes/No)Indicates whether the incident involved a power generation facility.char(1)83.91Extended and Complete 1990-2018
Generating CapacityGenerating capacity of power generation facility involved in the incident.varchar(20)99.80Extended and Complete 2000-2018
Type Of FuelType of fuel for power plant involved in fixed incident.varchar(40)99.36Extended and Complete 1999-2018
NPDES IDID number for NPDES water pollution permit for facility at which incident took place.varchar(10)99.92Extended and Complete 2000-2017
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.16Extended and Complete 1990-2018
Type of StructureType of fixed structure involved in incident.varchar(40)99.87Extended and Complete 2000-2018
Structure NameName of fixed structure involved in incident.varchar(20)99.91Extended and Complete 2000-2018
Structure Operating (Yes/No)Indicates whether structure involved in incident was operating.char(1)2.94Extended and Complete 1990-2018
Road Mile MarkerMile marker number along a road on which the incident occurred.decimal(5,1)98.82Extended and Complete 1999-2018
Airbag Deployed (Yes/No)Indicates whether airbag deployed.char(1)56.23Extended and Complete 1994-2018
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-2018
Vehicle Number (#1)Vehicle ID number, such as a license plate number.varchar(20)22.06Extended and Complete  
Trailer Number (#1)Number of trailer involved in mobile incident.varchar(20)93.25Extended and Complete 1999-2018
Fuel Capacity (#1)Fuel capacity of vehicle in mobile incident.varchar(20)90.39Extended and Complete 1999-2018
Cargo Capacity (#1)Cargo capacity of vehicle in mobile incident.varchar(20)90.00Extended and Complete 1999-2018
Amount Of Cargo (#1)Actual amount of cargo on board vehicle in mobile incident.varchar(20)90.04Extended and Complete 1999-2018
Hazmat Carrier (Yes/No) (#1)Indicates whether vehicle involved in mobile incident was a hazardous materials carrier.char(1)76.47Extended and Complete 1990-2018
Carrier Licensed (Yes/No) (#1)Indicates whether vehicle in incident was licensed to carry hazardous materials.char(1)82.66Extended and Complete 1990-2018
Noncompliance With Hazmat (Yes/No) (#1)Indicates whether vehicle was not in compliance with hazardous material transport regulations.char(1)91.42Extended and Complete 1990-2018
Vehicle Type (#1)Translation of code for the type of vehicle involved in a mobile incident.varchar(40)31.54Extended and Complete 1990-2018
Cargo Capacity Units (#1)Units of measurement for cargo capacity.varchar(40)94.62Extended and Complete 1999-2018
Cargo On Board Units (#1)Units of measurement for amount of cargo on board vehicle.varchar(40)95.15Extended and Complete 1999-2018
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.36Extended and Complete 1990-2018
DOT Regulated (Yes/No)Indicates whether pipeline involved in the incident was Dept. of Transportation regulated.char(1)98.06Extended and Complete 1990-2018
Pipeline Above GroundIndicates whether pipeline is above or below ground.varchar(5)3.01Extended and Complete 1990-2018
Pipeline Exposed Underwater (Yes/No)Indicates whether pipeline involved in the incident is exposed underwater.char(1)39.05Extended and Complete 1990-2018
Pipeline Covered (Yes/No)Indicates whether pipeline involved in the incident is covered.char(1)98.26Extended and Complete 1990-2018
Grade Crossing (Yes/No)Indicates whether incident occurred at railroad grade crossing.char(1)3.01Extended and Complete 1990-2018
Location SubdivisionLocation subdivision name used to help define location of railroad incident.varchar(20)94.64Extended and Complete 1990-2018
Railroad MilepostRailroad milepost near which incident occurred.varchar(10)92.25Extended and Complete 1990-2018
Vehicle TypeType of vehicle involved in railroad grade crossing incident.varchar(20)98.90Extended and Complete 1990-2018
Crossing Device TypeType of crossing device used at railroad grade crossing incident.varchar(40)98.14Extended and Complete 1999-2018
Crossing Device Operational (Yes/No)Indicates whether crossing device used at railroad grade crossing incident was operational.char(1)3.01Extended and Complete 1990-2018
DOT Crossing NumberDOT number for crossing device used at railroad grade crossing incident.varchar(20)98.47Extended and Complete 1999-2018
Brake Failure (Yes/No)Indicates whether brake failure was involved in the railroad incident.char(1)2.94Extended and Complete 1990-2018
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.01Extended and Complete 1990-2018
Conductors TestedNumber of conductors tested.char(3)99.68Extended and Complete 2005-2018
Engineers TestedNumber of engineers tested.char(3)99.72Extended and Complete 2005-2018
Trainmen TestedNumber of trainmen tested.char(3)99.98Extended and Complete 2005-2018
Yard Foremen TestedNumber of yard foremen tested.char(3)99.99Extended and Complete 2005-2018
RCL Operators TestedNumber of RCL operators tested.char(3)99.94Extended and Complete 2005-2018
Brakemen TestedNumber of brakemen tested.char(3)99.98Extended and Complete 2005-2018
Train Dispatchers TestedNumber of train dispatchers tested.char(3)99.99Extended and Complete 2006-2018
Signalmen TestedNumber of signalmen tested.char(3)99.99Extended and Complete 2006-2018
Other Employees TestedNumber of other employees tested.char(3)99.93Extended and Complete 2005-2018
Unknown Employees TestedNumber of employees of unknown classification tested.char(3)99.84Extended and Complete 2005-2018
Passenger HandlingHow passengers were handled (when a passenger train route was involved).varchar(240)97.55Extended and Complete 2006-2018
Passenger RouteIndicates whether the railroad incident was on a designated passenger route.char(3)0.05Extended and Complete 1990-2018
Passenger DelayIndicates whether a delay in passenger rail traffic occured.char(3)0.05Extended and Complete 1990-2018
Train Number (#1)Name or number of train.varchar(40)5.43Extended and Complete 1990-2018
Railroad Name (#1)Name of railroad owning train.varchar(40)0.53Extended and Complete 1990-2018
Train Type (#1)Translation of a code for the type of train,varchar(10)28.34Extended and Complete 1990-2018
Track Speed (#1)Track speed of the track at the location of a railroad incident.varchar(12)79.04Extended and Complete 1999-2018
Train Speed (#1)Speed of a train just before a railroad incident.varchar(12)90.72Extended and Complete 1999-2018
Track Direction (#1)Direction that a train was travelling in just before railroad incident.char(2)59.97Extended and Complete 1999-2018
Number Of Locomotives (#1)Number of locomotives attached to train.smallint(6)53.49Extended and Complete 1999-2018
Number Of Cars (#1)Number of cars attached to train.smallint(6)52.47Extended and Complete 1999-2018
Number Derailed (#1)Number of cars derailed during incident.smallint(6)81.60Extended and Complete 1991-2018
Hazmat Noncompliance (Yes/No) (#1)Indicates suspected noncompliance with DOT hazmat regulations.char(1)0.09Extended and Complete 1990-2018
Train Number (#1)Name or number of derailed train.varchar(40)2.78Extended and Complete 1991-2018
Car Number (#1)Identification number of derailed train car.varchar(15)1.98Extended and Complete 1991-2018
Cargo/Contents (#1)Cargo or contents of derailed train car.varchar(50)0.00Extended and Complete 1991-2018
Position In Train (#1)Position of derailed car within train.char(3)51.13Extended and Complete 1999-2018
Car Type (#1)Type of derailed train car (either car or locomotive).varchar(15)0.23Extended and Complete 1991-2018
Tank DescriptionDescription of a storage tank involved in the incident.varchar(40)93.84Extended and Complete 1999-2018
Tank Above GroundIndicates whether a storage tank involved in the incident is above or below ground.varchar(5)4.48Extended and Complete 1990-2018
Transportable Container (Yes/No)Indicates whether storage tank involved in the incident was a transportable container.char(1)96.80Extended and Complete 1990-2018
Tank Regulated (Yes/No)Indicates whether a storage tank involved in the incident is regulated.char(1)98.77Extended and Complete 1990-2018
Tank Regulated ByIndicates which agency regulates a storage tank involved in the incident.varchar(20)99.30Extended and Complete 1999-2018
Tank IDID number for a storage tank involved in the incident.varchar(20)98.48Extended and Complete 1999-2018
Tank CapacityCapacity of a storage tank involved in the incident.decimal(9,0)95.63Extended and Complete 1999-2018
Tank Capacity UnitsUnits of measurement of storage tank capacity.varchar(40)95.64Extended and Complete 1999-2018
Actual Amount In TankActual amount within storage tank at time of incident.decimal(9,0)98.50Extended and Complete 1999-2018
Tank Actual Amount UnitsUnits of measurement for actual amount within storage tank.varchar(40)98.46Extended and Complete 1999-2018
Aircraft TypeType of aircraft involved in the incident.varchar(10)99.64Extended and Complete 1990-2018
Aircraft ModelAircraft model involved in the incident.varchar(20)99.60Extended and Complete 1999-2018
Aircraft IDID number of an aircraft involved in the incident.varchar(30)99.71Extended and Complete 1999-2018
Air Fuel CapacityAir fuel capacity of an aircraft involved in the incident.varchar(12)99.92Extended and Complete 1999-2018
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-2018
Air Fuel On BoardAmount of air fuel on board an aircraft involved in the incident.varchar(12)99.93Extended and Complete 2000-2018
Air Fuel On Board UnitsUnits of measurement for air fuel capacity.varchar(40)99.94Extended and Complete 2000-2018
Air Spot NumberNumber used to help define location of aircraft incident.varchar(12)99.90Extended and Complete 1999-2018
Air HangerHanger number used to help define location of the incident.varchar(12)99.96Extended and Complete 2000-2018
Air Runway NumberAir runway number used to help define the location of the incident.varchar(12)99.96Extended and Complete 2000-2018
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)2.94Extended and Complete 1990-2018
Vessel Name (#1)Name of ship involved in incident.varchar(30)29.43Extended and Complete 1990-2018
Vessel Type (#1)Type of ship involved in incident.varchar(40)31.66Extended and Complete 1990-2018
Vessel Length (#1)Length of ship.smallint(6)67.29Extended and Complete 1999-2018
Hull Construction (#1)Type of hull construction of ship.varchar(40)79.10Extended and Complete 1999-2018
Fuel Capacity (#1)Fuel capacity of ship.varchar(12)82.96Extended and Complete 1999-2018
Fuel On Board (#1)Actual amount of fuel on board ship at time of incident.varchar(12)78.84Extended and Complete 1999-2018
Cargo Capacity (#1)Cargo capacity of ship.varchar(12)91.39Extended and Complete 1999-2018
Cargo On Board (#1)Actual amount of cargo on board ship at time of incident.varchar(12)91.37Extended and Complete 1999-2018
Vessel Aground (Yes/No) (#1)Indicates whether vessel was aground at time of incident.char(1)0.00Extended and Complete 1990-2018
Flag (#1)Nationality of registration (flag) of ship.varchar(40)68.76Extended and Complete 1999-2018
Breadth (#1)Breadth of ship.smallint(6)92.59Extended and Complete 1999-2018
Draught (#1)Draught of ship.smallint(6)94.89Extended and Complete 1999-2018
Fuel Capacity Units (#1)Units of measurement of fuel capacity of ship.varchar(40)93.31Extended and Complete 2000-2018
Fuel On Board Units (#1)Units of measurement of fuel on board ship.varchar(40)91.50Extended and Complete 1999-2018
Cargo Capacity Units (#1)Units of measurement of cargo capacity of ship.varchar(40)98.60Extended and Complete 2000-2018
Cargo On Board Units (#1)Units of measurement for cargo on board ship.varchar(40)98.76Extended and Complete 2000-2018
Weather ConditionsTranslation of a code for the type of weather conditions during the incident.varchar(40)49.63Extended and Complete  
Air TemperatureThe air temperature during the incident.char(3)58.59Extended and Complete 1999-2018
Wind SpeedThe wind speed during the incident.char(3)82.53Extended and Complete 1999-2018
Wind DirectionPrevailing wind direction during the incident.varchar(40)90.22Extended and Complete  
Wind Speed UnitsUnits of measurement of the wind speed during the incident.varchar(40)82.81Extended and Complete 1999-2018
Body of WaterBody of water that hazardous materials were released to.varchar(40)68.06Extended and Complete 1990-2018
Tributary OfIndicates which major river the body of water affected by the release is a tributary of.varchar(40)82.85Extended and Complete 1999-2018
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.94Extended and Complete 1990-2018
Wave ConditionCondition of the waves at the time of the incident.varchar(40)90.83Extended and Complete 1999-2018
Current SpeedSpeed of the water currents during the incident.char(3)97.40Extended and Complete 1999-2018
Current DirectionCompass direction in which the water currents were moving during the incident.varchar(40)97.57Extended and Complete  
Water TemperatureWater temperature at the time of the incident.char(3)99.29Extended and Complete 1999-2018
Current Speed UnitsUnits of measurement of the water current speed.varchar(40)93.93Extended and Complete 1999-2018
River Mile MarkerRiver mile marker near where the incident took place.varchar(10)98.49Extended and Complete 1990-2018
Offshore (Yes/No)Indicates whether incident occurred offshore.char(1)9.56Extended and Complete 1990-2018
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)82.91Extended and Complete  
Direction of Sheen TravelCompass direction in which the sheen was drifting.varchar(40)96.06Extended and Complete 1999-2018
Sheen OdorDescription of the odor of the sheen.varchar(40)94.26Extended and Complete 1999-2018
Sheen Size UnitsUnits of measurement of sheen size.varchar(40)100.00Extended and Complete -
Length of SheenThe length of the sheen.varchar(5)79.27Extended and Complete 1999-2018
Sheen Length UnitsUnits of measurement of the length of the sheen.varchar(40)79.34Extended and Complete 1999-2018
Width of SheenThe width of the sheen.varchar(5)80.92Extended and Complete 1999-2018
Sheen Width UnitsUnits of measurement of the width of the sheen.varchar(40)81.00Extended and Complete 1999-2018
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.60High through Complete  
Number of CR Materials RecordsNumber of Continuous Release Materials records for incident.smallint(6)99.23High through Complete 1990-2018
Number of Mobile Vehicle RecordsNumber of Mobile Details records for incident.smallint(6)90.06High through Complete  
Number of Train RecordsNumber of Trains records for incident.smallint(6)91.14High through Complete 1990-2018
Number of Derailed Train RecordsNumber of Derailed Trains records for incident.smallint(6)98.96High through Complete 1991-2018
Number of Vessel RecordsNumber of Vessels records for incident.smallint(6)86.39High through Complete 1990-2018