TCAD Data EDA

Feng Liang

April 2020

Summary of the Data

##        missing_# missing_% unique_#              top1_val top1_%                                                       VarName Type
## ACT         7683      43.8        3                     1   45.7                                              Type of Accident  Cat
## BFG         5484      31.3        9                     0   61.2                                 Bottom Fitting Damage General  Cat
## BFGIND                            2                     1   76.7                  Validity Indicator for Bottom Fitting Damage  Cat
## BFI        16291      92.8       11                                                           Bottom Fitting Damage Identifier  Cat
## BFS        16310        93       13                                                             Bottom Fitting Damage Specific  Cat
## BOE        15881      90.5       20                                                                       Bureau of Explosives  Cat
## BOF        13039      74.3       18                                                                     Bottom Outlet/Fittings  Cat
## BOP        13142      74.9        9                                                          Level of Bottom Outlet Protection  Cat
## BRC                               3                     2   98.2                                            Billing Repair Car  Cat
## BVA        17474      99.6        6                                                              Botton Outlet Valve Actuation  Cat
## BVT        17389      99.1        8                                                                          Bottom Valve Type  Cat
## CAR         2019      11.5      293                    UP   13.7                                                  Carrier Code  Ind
## CAT        15180      86.5        7                                                                      Category of Car Types  Cat
## CDA         8879      50.6       11                                                               Shelf Coupler Damage "A" End  Cat
## CDB         8892      50.7       11                                                               Shelf Coupler Damage "B" End  Cat
## CDR         8280      47.2       66                   -99   47.2                                                 Cars Derailed  Int
## CDRIND                            2                     1   52.8                Validity Indicator for Number of Cars Derailed  Cat
## CIC         8471      48.3      186                   -99   48.3                                     Number of Cars in Consist  Int
## CICIND                            2                     1   51.7                           Validity Indicator for Train Length  Cat
## CIR        17473      99.6        5                                                                  Chlorine Institute Report  Cat
## CLL        15180      86.5       11                                                                    Cause(s) of Lading Loss  Cat
## CLLIND                            1                     1    100                   Validity Indicator for Cause of Lading Loss  Cat
## CMA                               3                     2   83.6                 Chemists Mfg. Assn./ Chemistry Council (UIUC)  Cat
## COC                               3                     1   97.6                   Injured (Lading Loss only) Hazmat Cars only  Cat
## COR                               3                     1   52.8                                              Car Owner Report  Cat
## CSP                              50             111A100W1   48.7                                   Stenciled Car Specification  Cat
## CST                               1                     2    100                                     Tank Car Center Sill Type  Cat
## CTC                            4165                 24000    3.1                                             Car Tank Capacity  Num
## CTR        14351      81.8       13                                                                     Chemtrec Report (UIUC)  Cat
## DAT        16080      91.6      259                                                       Attachment and Fittings Damage Types  Cat
## DFC                               3                     2   96.6                    Killed (Lading Loss only) Hazmat Cars only  Cat
## DOA                            6704                                                                           Date of Accident Time
## DOA.1                          6703                                                                                       Date Time
## DOC        11541      65.8      812                                                                             Date of Change Time
## DOC.1      11526      65.7      815                                                                             Date of Change Time
## DOE         4743        27     1612                                                                              Date of Entry Time
## DOE.1       4772      27.2     1530                                                                              Date of Entry Time
## DOEIND                            2                     1     73                          Validity Indicator for Date of Entry  Cat
## DOETFP                            3 DOE Before April 2011   83.2                 Manipulator for Date of Entry and Top Fitting  Cat
## DOT        14915        85       26                                                               Department of Transportation  Cat
## DPT        16535      94.2      221                                                                             Puncture Types  Cat
## DRT        17319      98.7       82                                                                              Rupture Types  Cat
## EAL        13291      75.7      113                              Evacuated (Attributable to Lading Loss only) Hazmat Cars only  Cat
## ETC         6938      39.5       13                     0   56.3                                                         Other  Cat
## EXP        15537      88.6        4                                                                       Car Exposure to Fire  Cat
## FCI         8934      50.9      142                                                             Location of First Car Involved  Int
## FIR        15541      88.6        4                                                                Fire Anywhere in Derailment  Cat
## FRA        10191      58.1       24                                                             Federal Railway Administration  Cat
## HDL        15048      85.8        6                                                              Car Tank Head Damage Location  Cat
## HDT         4123      23.5       10                     0   58.3                                     Car Tank Head Damage Tank  Cat
## HDTIND                            2                     1   76.5                            Validity Indicator for Head Damage  Cat
## HID                             167                110.25   33.4                              Car Tank Inside Diameter at Head  Num
## HMG                               5                     7     75                                  Car Tank Head Material Grade  Cat
## HMS            2         0        8                   515   42.8                          Car Tank Head Material Specification  Cat
## HMT                             105                 0.437   41.2                              Car Tank Head Material Thickness  Num
## HSA        15503      88.4        8                                                                 Head Shield Damage "A" End  Cat
## HSB        15543      88.6        8                                                                 Head Shield Damage "B" End  Cat
## HST           10       0.1        8                     0   82.9                                     Car Tank Head Shield Type  Cat
## HSTIND                            2                     1   99.9                        Validity Indicator for Headshield Type  Cat
## IAL        13301      75.8       25                                Injured (Attributable to Lading Loss only) Hazmat Cars only  Cat
## INC                           12113                                                                            Incident Number  Ind
## INS                              17                     2   58.7                Car Tank Insulation or Thermal Protection Type  Cat
## ITK         4328      24.7       25                     4   58.7                                 Car Tank Insulation Thickness  Num
## JIC                               3                     2   85.4                                  Joint inspection Certificate  Cat
## KAL        13242      75.5        9                                 Killed (Attributable to Lading Loss only) Hazmat Cars only  Cat
## LAD                             470               Unknown     50                                                   Lading Name  Ind
## LCL                              19                    UN   53.9                                         Lading Classification  Cat
## LDL                               2                     0   86.5                                                   Lading Lost  Cat
## LLG        15176      86.5      780                                                                      Amount of Lading Loss  Num
## MOA                              12                    12   21.4                                             Month of Accident Time
## MOR                               3                     2   51.4                                                         Other  Cat
## NAR                            2773                         83.3                                                     Narrative  Ind
## NTS        16995      96.9       21                                                       National Transportation Safety Board  Cat
## NWS        14582      83.1       17                                                                              News Clipping  Cat
## OCC        11554      65.8     3230                                                Original Certificate of Construction Number  Ind
## OMK        11595      66.1      141                                                                            Owner\x92s Mark  Ind
## PLC                              17                    UN   76.1                                Previous Lading Classification  Cat
## PLD                             367        Not Applicable   46.1                                          Previous Lading Name  Ind
## POD                               3                     2   91.6                 Evacuated (Lading Loss only) Hazmat Cars only  Cat
## PSC        13356      76.1      375                                                                     Previous Lading in Car  Ind
## RMI                             270                  UTLX   35.9                                       Reporting Mark Initials  Ind
## RMN                           16185                                                                     Reporting Mark Numbers  Ind
## RRM         2076      11.8      310                    UP   13.6                    Railroad Responsible For Track Maintenance  Ind
## RRR        14657      83.5       15                                                                            Railroad Report  Cat
## RRS         2730      15.6     2965                   -99   15.6                                     Location Railroad Station  Ind
## SDL        13223      75.4       13                                                             Car Tank Shell Damage Location  Cat
## SDT          559       3.2       11                     0   47.2                                    Car Tank Shell Damage Type  Cat
## SDTIND                            2                     1   96.8                           Validity Indicator for Shell Damage  Cat
## SHR        17485      99.7        6                                                                             Shipper Report  Cat
## SID                             207                110.25   36.8                      Car Tank Shell Inside Diameter at Center  Num
## SKD         7311      41.7        9                   -98   35.5                   Bottom Discontinuity Protective Skid Damage  Cat
## SMG                               5                     7   68.4                                 Car Tank Shell Material Grade  Cat
## SMS                               5                   515   40.9                         Car Tank Shell Material Specification  Cat
## SOP         2737      15.6       59                   -99   15.6                                             State or Province  Ind
## SRA        17249      98.3       13                                                                                      Srais  Cat
## STC         8778        50      474                   -99     50                                      Lading in Car, Stcc Code  Ind
## STCIND                            2                     0     50                                   Validity Indicator for STCC  Cat
## STL            1         0      101                 0.437   73.3                                       Maximum Shell Thickness  Num
## STS                              87                 0.437   73.9                                       Minimum Shell Thickness  Num
## TCC                               6                     2   75.5                                         Tank Car Coupler Type  Cat
## TCCIND                            1                     1    100                           Validity Indicator for Coupler Type  Cat
## TCD          372       2.1        3                     R   69.1                                          Tank Car Disposition  Cat
## TCL        13241      75.5      130                                                           Location of Car in Train Consist  Int
## TCLIND                            2                     0   75.5                        Validity Indicator for Location of Car  Cat
## TCS                               7                   111   82.8                                      Tank Class Specification  Cat
## TCT                               2                   100   84.2                                       Tank Car Truck Capacity  Num
## TDE        13266      75.6       20                                                          Tank Cars Damaged Empty (No Loss)  Int
## TDF        13253      75.5       25                                                           Tank Cars Damaged Full (No Loss)  Int
## TDG                              36                     1     54                                             Tank Cars Damaged  Int
## TDR         8787      50.1       40                                                                         Tank Cars Derailed  Int
## TDU        13278      75.7       14                                                        Tank Cars Damaged Unknown (No Loss)  Int
## TFG         4491      25.6        8                     0   66.1                                    Top Fitting Damage General  Cat
## TFGIND                            2                     1   74.4                     Validity Indicator for Top Fitting Damage  Cat
## TFI        16219      92.4       12                                                              Top Fitting Damage Identifier  Cat
## TFN        15536      88.5        3                                                                       Top Fittings Nozzles  Cat
## TFNIND                            1                     1    100                     Validity Indicator for Top Fitting Nozzle  Cat
## TFP        14966      85.3       14                                                                    Top Fittings Protection  Cat
## TFPIND                            2                     1     95                 Validity Indicator for Top Fitting Protection  Cat
## TFS        16160      92.1       12                                                                Top Fitting Damage Specific  Cat
## THT           60       0.3        6                     1   53.5                                          Car Tank Heater Type  Cat
## THTIND                            2                     1   99.7                            Validity Indicator for Heater Type  Cat
## TJD         4210        24        8                     1   26.7         Car Tank Jacket or Spray-On Thermal Insulation Damage  Cat
## TJE         4786      27.3        4                     2   60.4                                Car Tank Weld Joint Efficiency  Cat
## TKT         7683      43.8        5                   -99   43.8                                              Type of Track     Cat
## TMP         8715      49.7      130                   -99   49.7                                                   Temperature  Num
## TOA         7955      45.3      753                   -99   45.3                                              Time of Accident Time
## TSI                              15                     1   56.5                       Tank Stenciled Specification Identifier  Cat
## TSP         8540      48.7       70                   -99   48.7                                            Train Speed in Mph  Num
## TSPIND                            2                     1   51.3                            Validity Indicator for Train Speed  Cat
## TTA         7683      43.8        9                   -99   43.8                                    Type of Track and Accident  Cat
## TTAIND                            2                     1   56.2                Validity Indicator for Track and Accident Type  Cat
## TTP                               9                   100   78.3                                            Tank Test Pressure  Num
## TWL                              26                     0   75.2                                Total Number of Cars with Loss  Int
## TWT        10660      60.8     2437                                                                       Train Weight in Tons  Num
## UNT        16564      94.4        5                                                                                 Unit Train  Cat
## WOR        11547      65.8       13                                                             Total Allowable Weight on Rail  Num
## XR1                               3                     2   85.5                                                   Exhibit R-1  Cat
## YCB                              49                  1980    7.8                                                Year Car Built Time
## YOA                              39                  1988    4.3                                              Year of Accident Time

View Missing Patterns

Unknown DOA

The year-by-month table seems to indicate that a surprisingly large amount of incidents happened in Dec, which turns out to be caused by a coding practice: 12/31/yyyy is used for incidents with unknown DOA.

Once we exclude incidents with unknown DOA, which can be recognized by an INC entry that begins “DTE” (for Date To be Established), the year-by-month table (see blow) does not show any associate between Dec and high incident rates.

##       
##         1  2  3  4  5  6  7  8  9 10 11 12
##   1980 24 29 29 25 28 23 25 20 34 15 11 24
##   1981 18 17 38 16  9 25 32 45 27 27 21 24
##   1982 22 33 33 15 13 23 29 17 38 12 17 18
##   1983 19 15 21 14 12 31 23 16 16 17 30 20
##   1984 39 24 60 23 42 32 24 19 23 24 15 13
##   1985 46 57 36 46 42 45 42 28 66 41 27 32
##   1986 30 47 23 43 39 58 39 28 47 32 19 30
##   1987 34 36 30 19 37 33 69 37 33 37 44 72
##   1988 47 42 49 46 55 54 51 65 33 49 50 27
##   1989 43 36 49 43 51 40 36 49 32 33 26 53
##   1990 55 53 34 39 51 40 54 39 39 44 62 39
##   1991 53 40 46 50 68 52 44 38 31 25 25 26
##   1992 37 26 39 22 42 29 45 22 26 34 26 47
##   1993 30 28 59 55 36 40 34 23 36 27 27 25
##   1994 34 36 31 34 30 22 41 49 31 27 13 15
##   1995 57 35 26 27 81 40 28 22 19 32 45 33
##   1996 38 69 41 38 25 21 38 31 28 17 22 25
##   1997 37 24 25 22 43 43 33 29 35 28 43 26
##   1998 23 10 24 21 25 33 22 22 13 23 27 21
##   1999 31 22 19 54 15  8 43 22 29 24 36 57
##   2000 24 26 29 37 39 38 35 42 31 20 44 45
##   2001 39 34 30 32 18 28 39 46 26 35 27 28
##   2002 44 31 22 17 26 26 18 40 17 32 21 66
##   2003 55 51 28 26 51 21 35 40 35 37 38 50
##   2004 26 38 21 41 25 48 33 64 41 50 19 42
##   2005 47 27 40 43 42 41 31 50 18 30 33 22
##   2006 19 17 30 24 20 40 30 12 23 44 21 37
##   2007 42 26 70 33 48 36 44 31 34 60 37 37
##   2008 51 33 50 32 42 55 27 46 41 34 27 12
##   2009 50 17 20 19 34 48 26 35 28 28 19 44
##   2010 15 39 40 38 32 39 39 59 29 38 24 19
##   2011 41 70 56 36 44 29 38 20 39 27 45 16
##   2012 42 13 25  4 16 14 26 29 20 26 15 10
##   2013 38 24 47 23 27 19 91 39 18 20 50 49
##   2014 42 32 13 25 23 15 31 12  7 19 12 22
##   2015 21 81 87 31 17 16 49 10 13 23 35 20
##   2016 17 11 14 16 15 23 13 30  7  7 11 14
##   2017 24  4 44 12 17 39 15 32 22 28 14 25
##   2018 14 13 21  9 14 46 44  3  9 10 19 15

LAD vs STC

How are missing coded in LAD and STC?

##                      
##                        -99  -98   15 4906610 4930040
##   Chlorine               1    0    0       0       0
##   Corn Syrup             2    0    0       0       0
##   Not Applicable         0    3    0       0       0
##   Potassium Hydroxide    1    0    0       0       0
##   Unknown             8770    1    0       1       1
##   Unknown but Loaded     0    0  659       0       0
## 
## Ethylene Oxide        Unknown 
##             51              1
## 
## Sulfuric Acid       Unknown 
##           405             1

The same LAD tag may correspond to multiple STC tags.

##                                                                                  
##  4904304 1,1,1,2-Tetrafluoroethane <> Tetrafluoroethane                          
##  4905702 Butane Mixtures <> Butane (Waste, Etc.)                                 
##  4905704 Butadiene Inhibited <> Butadiene                                        
##  4905752 Liquefied Petroleum Gas <> Liquified Petroleum Gas                      
##  4905792 Vinyl Chloride <> Vinyl Methyl Ether, Inhibited                         
##  4918765 Sodium Chlorate, Aqueous Solution <> Sodium Chloride, Aqueous Solution  
##  4930024 Hydrogen Fluoride <> Hydrogen Fluoride, Anhydrous                       
##  4930248 Phosphoric Acid <> Phosphoric Acid, Solution                            
##  4932021 Corrosive Liquid N.O.S. <> Corrosive Liquid, Inorganic, N.O.S.          
##  4935645 Hexamethylene Diamine Solution <> Hexamethylenediamine Solution         
##  4941167 ELEVATED TEMP.MATL.(BINDER PITCH) <> ELEVATED TEMP.MATL., LIQUID, N.O.S.
##  4963330 Environ. Haz. Sub.,Liq.,N.O.S. <> Environ. Haz. Sub.,Liq.,N.O.S.-Creo

Vice verse, the same STC tag may correspond to multiple LAD tags.

##                                                                
##   Asphalt                         4915261 <> 4910160           
##   Cleaning Liquid Compound        4910147 <> 4936515           
##   Ethylene Glycol                 2818546 <> 4912062           
##   Ethylene Glycol Monoethyl Ether 4915276 <> 4913116           
##   Jet Fuel                        4909215 <> 4915167           
##   Methyl Chloroform               4941176 <> 2818151           
##   Methylene Diphenyl Diisocyanate 4966109 <> 2815127           
##   Naphtha                         4915239 <> 4910239           
##   Petroleum Distillate Fuel Oil   2911315 <> 4910242           
##   Petroleum Naphtha               4910259 <> 4915259 <> 4910256
##   Petroleum Oil                   4910245 <> 1311110           
##   Petroleum Oil, N.O.S.           4915245 <> 4910360           
##   Propylene Glycol                2818556 <> 4910481           
##   Resin Solution                  4910280 <> 4915282           
##   Sodium Chlorate                 4918723 <> 2819924           
##   Tar, Coal or Petroleum          4910263 <> 4915263

LAD vs STC

LAD has 470 unique values.

##        LAD                                 #obs STC                             
##   [1,] 1,1-Difluoroethane                  1    4905716                         
##   [2,] 1,1,1,2-Tetrafluoroethane           3    4904304                         
##   [3,] 2 Ethyl Hexanol                     2    4915101                         
##   [4,] Acetaldehyde                        16   4907210                         
##   [5,] Acetic Anhydride                    4    4931304                         
##   [6,] Acetone                             19   4908105                         
##   [7,] Acid Sludge                         1    4930253                         
##   [8,] Acrylic Acid                        4    4931405                         
##   [9,] Acrylonitrile                       15   4906420                         
##  [10,] Additives, Fuel, Oil, Gasoline      4    4914109                         
##  [11,] Additives, Gasoline, Lube, Fuel Oil 10   4915535                         
##  [12,] Alcohol Distillates, Synthetic      1    4910401                         
##  [13,] Alcohol, Fatty/Cyclic, Ethoxylated  4    4915108                         
##  [14,] Alcohol, N.O.S. (Combustible)       6    4913103                         
##  [15,] Alcohol, N.O.S. (Flammable)         363  4909105                         
##  [16,] Alcoholic Beverage In Bond          5    4910102                         
##  [17,] Alcoholic Beverage, Grain Alcohol   1    4910309                         
##  [18,] Alkali Battery Fluid                1    4935210                         
##  [19,] Alkaline Liquid                     1    4935202                         
##  [20,] Alkaline Liquid, N.O.S., Waste      1    4935221                         
##  [21,] Alkaline, Corrosive Liquid, N.O.S.  1    4935220                         
##  [22,] ALKYL PHENOLS LIQUID N.O.S.         4    4925152                         
##  [23,] ALKYL PHENOLS, SOLID, N.O.S.        1    4925153                         
##  [24,] Alkyl Sulfonic Acid, Liquid         1    4931465                         
##  [25,] Allyl Chloride                      1    4907412                         
##  [26,] Aluminum Chloride                   1    4930213                         
##  [27,] Aluminum Sulfate (Alum) Solution    1    4944165                         
##  [28,] Aminoethylethanolamine              1    4935674                         
##  [29,] Ammonia Solution (Max 60% Free)     3    4904276                         
##  [30,] Ammoniom Nitrate Mixed Fertilizer   1    4918705                         
##  [31,] Ammonium Bisulfate                  1    4936333                         
##  [32,] Ammonium Bisulfite,Solution         1    4932348                         
##  [33,] Ammonium Nitrate Solution           12   4918774                         
##  [34,] Ammonium Polyphosphate              2    2871451                         
##  [35,] Ammonium Sulfide Solution           3    4909303                         
##  [36,] Ammonium Thiosulfate                7    4966756                         
##  [37,] Amyl Acetate                        1    4909111                         
##  [38,] Amyl Alcohol                        1    4913106                         
##  [39,] Anhydrous Ammonia                   190  4904210                         
##  [40,] Aniline Oil, Liquid                 3    4921410                         
##  [41,] Antifreeze, Proprietary             4    2899915                         
##  [42,] Aromatic Concentrate                4    4910490                         
##  [43,] Asphalt                             86   4915261 <> 4910160              
##  [44,] Asphalt Additive, Anti-Stripping    1    4936543                         
##  [45,] Asphalt Sealer                      3    4910302                         
##  [46,] Asphalt, By-Prod.or Petrol.Liq.     26   2911610                         
##  [47,] Asphalt, Cut Back                   26   4910260                         
##  [48,] Asphalt, Cut Back (Inc. Tall Oil)   14   4910220                         
##  [49,] Asphalt, Cut-Back w/Tall Oil Pitch  3    4915320                         
##  [50,] Benzene                             38   4908110                         
##  [51,] Bisulphites,AqueousSolution,N.O.S.  1    4935609                         
##  [52,] Brake Fluid, Hydraulic Fluid        1    2991210                         
##  [53,] Butadiene                           5    4905704                         
##  [54,] Butadiene Inhibited                 91   4905704                         
##  [55,] Butadiene Waste (Impure)            4    4905703                         
##  [56,] Butane                              53   4905706                         
##  [57,] Butane (Waste, Etc.)                1    4905702                         
##  [58,] Butane Mixtures                     1    4905702                         
##  [59,] Butanol                             5    4909129                         
##  [60,] Butene (Liquefied)                  7    4905707                         
##  [61,] Butyl Acetate                       6    4909128                         
##  [62,] Butyl Acrylate                      37   4912215                         
##  [63,] Butyl Alcohol                       2    4909117                         
##  [64,] Butyl Methacrylate                  1    4912235                         
##  [65,] Butylene Glycols                    3    2818540                         
##  [66,] Butylene Oxide                      1    4908144                         
##  [67,] Butylenes, Impure                   1    4905711                         
##  [68,] Butyraldehyde                       6    4908119                         
##  [69,] Calcium Bromide                     1    2812627                         
##  [70,] Calcium Carbonate Slurry            1    2812668                         
##  [71,] Calcium Chloride                    16   2812632                         
##  [72,] Calcium Chlorite                    1    4918714                         
##  [73,] Calcium Silicate                    1    2812643                         
##  [74,] Caprolactam                         1    2818217                         
##  [75,] Caramel                             1    2099340                         
##  [76,] Carbolic Acid, Liq, Over 50% Phenol 5    4921210                         
##  [77,] Carbon Bisulfide                    6    4908125                         
##  [78,] Carbon Black Oil                    2    4910323                         
##  [79,] Carbon Dioxide, Refrigerated Liquid 1    4904509                         
##  [80,] Carbon Tetrachloride                4    4940320                         
##  [81,] Castor Oil, Nec                     1    2093332                         
##  [82,] Caustic Soda, Spent                 2    4025186                         
##  [83,] Chemical Plant Waste, Nec           2    4025190                         
##  [84,] Chemicals used in Herbicides        1    4910168                         
##  [85,] Chemicals, Nec                      1    2899991                         
##  [86,] Chlorinated Hydrocarbon Residue     1    4960114                         
##  [87,] Chlorine                            237  4904120 <> -99                  
##  [88,] Chlorobenzene                       1    4909153                         
##  [89,] Chlorodifluoromethane               7    4904552                         
##  [90,] Chloroform, Not Tech Grade          4    4940310                         
##  [91,] Chloropicrin Mixture                1    4921416                         
##  [92,] Choline Chloride                    1    2042114                         
##  [93,] Chromic Acid Solution               1    4930206                         
##  [94,] Clay and Water Mixed, Not Kaolin    12   3295229                         
##  [95,] Clay, Slip or Slurry                76   1451960                         
##  [96,] Cleaning Liquid Compound            3    4910147 <> 4936515              
##  [97,] Cleaning Liquid Compound-Iron/St    1    4936516                         
##  [98,] Cleaning Liquid, Dry Cleaner        1    4915146                         
##  [99,] Coal Tar Distillate                 3    4910133                         
## [100,] Coal Tar Distillate, Nec            5    4910139                         
## [101,] Coal Tar Oil Dist., Crude Oil       3    4910135                         
## [102,] Combustible Liquid, N.O.S.          57   4915185                         
## [103,] Compounds,WaterTreating Indus.Liq.  1    2899550                         
## [104,] Copper Plating Solution             1    4930275                         
## [105,] Corn Oil                            8    2046510                         
## [106,] Corn Steep Water                    3    2046925                         
## [107,] Corn Syrup                          356  2046115 <> -99                  
## [108,] Corrosive Liq,Acidic,Inorganic,NOS  1    4932022                         
## [109,] Corrosive Liquid N.O.S.             14   4932021                         
## [110,] Corrosive Liquid, Inorganic, N.O.S. 1    4932021                         
## [111,] Corrosive Liquid, Organic, N.O.S.   1    4931257                         
## [112,] Corrosive Liquid, Toxic, N.O.S.     1    4936015                         
## [113,] Corrosive Liquid,Acidic,Org,N.O.S.  2    4931466                         
## [114,] Corrosive Liquid,Basic Inorg,N.O.S. 3    4935258                         
## [115,] Corrosive Material, N.O.S.          1    4936361                         
## [116,] Cottonseed Oil                      5    2091110                         
## [117,] Coumarone-Idene Resins              1    2821131                         
## [118,] Crankcase Drainings                 4    4025129                         
## [119,] CRANKCASE DRAININGS                 1    4025129                         
## [120,] Creosote Oil                        16   4915363                         
## [121,] Creosote, Pitch or Tar Coke         1    2991437                         
## [122,] Cresol                              1    4931417                         
## [123,] Cresylic Acid                       3    4930003                         
## [124,] Cyclohexane                         17   4908132                         
## [125,] Cyclohexanone                       3    4913179                         
## [126,] Denatured Alcohol                   66   4909141                         
## [127,] Denatured Alcohol (50% Chem)        22   4909151                         
## [128,] Denatured Alcohol, Nec              8    4909143                         
## [129,] Detergent Intermediates             3    2818926                         
## [130,] Detergent Intermediates.            1    4915371                         
## [131,] Dichlorobenzene, Ortho, Liquid      1    4941127                         
## [132,] Dichlorodifluoromethane             2    4904516                         
## [133,] Dichloromethane                     3    4941132                         
## [134,] Dichloropropene                     2    4909255                         
## [135,] Dicyclopentadiene                   6    4907219                         
## [136,] Diesel Fuel                         97   4915168                         
## [137,] Diethanolamine                      3    2818127                         
## [138,] Diethyl Ketone                      2    4909150                         
## [139,] Diethylamine                        1    4907815                         
## [140,] Diethylaminoethanol                 1    4913186                         
## [141,] Diethylene Glycol                   6    2818542                         
## [142,] Dimethyl Chlorothiophosphate        2    4933319                         
## [143,] Dimethyl Ether                      1    4905725                         
## [144,] Dimethyl Terephthalate              1    2815134                         
## [145,] Dimethylamine, Anhydrous            6    4905510                         
## [146,] Dimethylamine, Aqueous Solution     1    4907820                         
## [147,] Dimethylformamide                   1    4913157                         
## [148,] DIPHENYLMETHANE DIISOCYANATE        2    4925113                         
## [149,] Dipropylene Glycol                  2    2818544                         
## [150,] Disodium Iminodiacetate             1    2812368                         
## [151,] Dispersant Gas (Flammable)          1    4905727                         
## [152,] Distillers Slop, Liquid Feed        1    2085935                         
## [153,] Electrode Binder (Pitch)            2    2899868                         
## [154,] Elev.Temp.Liq.,Flammable, N.O.S.    8    4912813                         
## [155,] Elevated Temp.Liquid, N.O.S         91   4961617                         
## [156,] ELEVATED TEMP.MATL., LIQUID, N.O.S. 14   4941167                         
## [157,] ELEVATED TEMP.MATL.(BINDER PITCH)   12   4941167                         
## [158,] Environ. Haz. Sub.,Liq.,N.O.S       60   4960131                         
## [159,] Environ. Haz. Sub.,Liq.,N.O.S.      2    4963330                         
## [160,] Environ. Haz. Sub.,Liq.,N.O.S.-Creo 1    4963330                         
## [161,] Esters, N.O.S.                      2    4907614                         
## [162,] Ethanol                             63   4909146                         
## [163,] Ethyl Acetate                       3    4909160                         
## [164,] Ethyl Acrylate, Inhibited           12   4907215                         
## [165,] Ethyl Benzene                       6    4909163                         
## [166,] Ethyl Chloride                      2    4908162                         
## [167,] Ethylene Dibromide                  2    4940335                         
## [168,] Ethylene Dichloride                 14   4909166                         
## [169,] Ethylene Glycol                     70   2818546 <> 4912062              
## [170,] Ethylene Glycol Monobutyl Ether     2    4925128                         
## [171,] Ethylene Glycol Monoethyl Ether     4    4915276 <> 4913116              
## [172,] Ethylene Glycol Monomethyl Ether    8    4913162                         
## [173,] Ethylene Oxide                      51   4906610                         
## [174,] Ethylhexyl Acrylate                 1    4912220                         
## [175,] Fatty Acid Esters Of Vegetable, Nec 1    2899415                         
## [176,] Fatty Acids, Animal, Nec, Inedible  1    2899425                         
## [177,] Fatty Acids, Coconut,Corn,Ctnsd,Etc 3    2899440                         
## [178,] Fatty Acids, Petroleum              6    2899463                         
## [179,] Fatty Acids, Tall Oil               2    2899427                         
## [180,] Fatty Alcohol, N.O.S.               4    4910111                         
## [181,] Fatty Alcohols, Animal, Fish, Petro 4    2818491                         
## [182,] Fatty Alcohols, Ethoxylated         5    2843128                         
## [183,] Feed Supplement                     3    2042135                         
## [184,] Ferric Chloride Solution, Crude     10   4932342                         
## [185,] Ferric Chloride Solution, Not Crude 3    4932343                         
## [186,] Ferric Sulfate Solution             3    4932315                         
## [187,] Ferrous Chloride Solution           8    4932329                         
## [188,] Fertilizer Solution                 5    4935272                         
## [189,] Flammable Liquid, Chemical Waste    6    4910560                         
## [190,] Flammable Liquid, N.O.S.            85   4910185                         
## [191,] Flammable Liquid, Poisonous, nec    1    4907422                         
## [192,] Flavoring Compound, Lard            1    2899834                         
## [193,] Fluid,lubricating system sight feed 1    4915228                         
## [194,] Formaldehyde Solution               26   4913144                         
## [195,] Fuel Oil                            3    4914168                         
## [196,] Fuel Oil Additives (less than 50%   2    2899885                         
## [197,] Fuel Oil, Bunker ''c''              42   2911717                         
## [198,] Fuel Oil, Bunker "C"                4    4915120                         
## [199,] Fuel Oil, No. 1,2,4,5,6             71   4915112                         
## [200,] Furfural                            5    4913146                         
## [201,] Furfuryl alcohol                    1    4925208                         
## [202,] Gasohol                             1    4907826                         
## [203,] Gasoline Additive                   3    4910535                         
## [204,] Gasoline, Natural                   25   4908176                         
## [205,] Gasoline, Nec                       25   4908178                         
## [206,] Glycerine, Crude                    1    4936541                         
## [207,] Glycol Ether, Combust. Liq., N.O.S. 5    4913194                         
## [208,] Glycol Ethers, Nec                  6    4909219                         
## [209,] Hazardous Substance, N.O.S.         10   4960132                         
## [210,] Heating Oil                         30   4915113                         
## [211,] Heptane                             2    4909190                         
## [212,] Herbicides or plant hormones        1    2879963                         
## [213,] Hexamethylene Diamine               6    4936540                         
## [214,] Hexamethylene Diamine Solution      24   4935645                         
## [215,] Hexamethylene Diammmonium Adipate   3    2818133                         
## [216,] Hexamethylenediamine Solution       4    4935645                         
## [217,] Hexamethylenediamine, Solid         4    4935640                         
## [218,] Hexane                              6    4908183                         
## [219,] Hexene                              10   4908182                         
## [220,] Hexyl Alcohol                       1    4913126                         
## [221,] Hydrocarbons, Liquid N.O.S.         32   4912280                         
## [222,] Hydrochloric Acid                   104  4930228                         
## [223,] Hydrochloric Acid Solution Inhib.   4    4930230                         
## [224,] Hydrofluoric/Sulfuric Acid Mixture  1    4930020                         
## [225,] Hydrofluosilicic Acid               5    4930026                         
## [226,] Hydrogen Fluoride                   8    4930024                         
## [227,] Hydrogen Fluoride, Anhydrous        3    4930024                         
## [228,] Hypochlorite Solution               2    4932378                         
## [229,] Ink Base                            1    2899949                         
## [230,] Ink, Printing, nec                  2    2893125                         
## [231,] Insecticide, Liquid, N.O.S.         1    4910197                         
## [232,] Isobutane                           9    4905747                         
## [233,] Isobutane (for Furthur Refining)    1    4905750                         
## [234,] Isobutyl Acetate                    2    4909207                         
## [235,] Isobutyl Alcohol                    4    4909131                         
## [236,] Isobutylene                         9    4905748                         
## [237,] Isooctyl Alcohol                    3    4913128                         
## [238,] Isoprene                            11   4907230                         
## [239,] Isopropanol                         12   4909205                         
## [240,] Isopropenylbenzene                  2    4912631                         
## [241,] Isopropyl Acetate                   1    4909210                         
## [242,] Isopropylamine                      1    4908194                         
## [243,] Jet Fuel                            20   4909215 <> 4915167              
## [244,] Juice, Citrus fruit                 2    2033433                         
## [245,] Kaolin and Water Mixed              18   3295230                         
## [246,] Lacquer, Solvent, Paint Rel. Mat'l  1    4910265                         
## [247,] Lard, Nec                           4    2013190                         
## [248,] Latex, Natural                      5    842320                          
## [249,] Latex, Synthetic                    17   2821245                         
## [250,] Lauryl Methacrylate                 1    2818294                         
## [251,] Lead Arsenate, Solid                1    4923293                         
## [252,] Lignin Liquor                       11   2611215                         
## [253,] Limestone Slurry                    12   3295956                         
## [254,] Linseed Oil                         1    2093110                         
## [255,] Liquefied Petroleum Gas             143  4905752                         
## [256,] Liquified Petroleum Gas             238  4905752                         
## [257,] Lube Oil                            65   4915229                         
## [258,] Lubricating Oil, Nec                4    2911490                         
## [259,] Magnesium Chloride                  13   2812649                         
## [260,] Magnesium Hydroxide, In Water       2    2812652                         
## [261,] Magnesium Sulfate                   1    1471925                         
## [262,] Maleic Anhydride                    6    4941161                         
## [263,] Maple Syrup, refined                2    2099952                         
## [264,] Margarine, Not Frozen Solid         1    2096210                         
## [265,] METHACRYLIC ACID                    1    4930251                         
## [266,] Methanol                            158  4909230                         
## [267,] Methanol, Contaminated              1    4909237                         
## [268,] Methoxydihydropyran                 2    4909328                         
## [269,] Methyl Bromide                      2    4921440                         
## [270,] Methyl Chloride                     13   4905761                         
## [271,] Methyl Chloroform                   6    4941176 <> 2818151              
## [272,] Methyl Esters (Methyl Soyate)       1    2899416                         
## [273,] Methyl Ethyl Ketone                 15   4909243                         
## [274,] Methyl Isobutyl Ketone              1    4909245                         
## [275,] Methyl Isocyanate                   1    4907448                         
## [276,] Methyl Mercaptan                    4    4905520                         
## [277,] Methyl Methacrylate Monomer, Inhib. 29   4907250                         
## [278,] Methyl Methacrylate Monomer, Uninh. 5    4907255                         
## [279,] Methyl Styrene                      1    4913109                         
## [280,] Methyl Tert-Butyl Ether             5    4908224                         
## [281,] Methylamine, Anhydrous              2    4905530                         
## [282,] Methylamine, Aqueous Solution       1    4907840                         
## [283,] Methylene Diphenyl Diisocyanate     8    4966109 <> 2815127              
## [284,] MEYHYL ISOBUTYL CARBINOL            1    4913261                         
## [285,] Mineral Oil                         1    2911425                         
## [286,] Molasses, Beet Sugar                7    2061625                         
## [287,] Molasses, Black Strap               7    2061710                         
## [288,] Molasses, Nec                       28   2061690                         
## [289,] Molasses, Refuse                    7    2062525                         
## [290,] Monoethanolamine                    1    4935665                         
## [291,] Morpholine, Aqueous Mixture         1    4907847                         
## [292,] Naphtha                             14   4915239 <> 4910239              
## [293,] Naphtha, Lighter Fluid              1    4910125                         
## [294,] Naphthalene                         7    4940360                         
## [295,] Naphthenic Sodium Solution, Spent   1    4936656                         
## [296,] Napthenic Acid                      1    4962356                         
## [297,] Nitrobenzene, Liquid, Nitrobenzol   2    4921455                         
## [298,] Nitrogen Fertilizer                 2    2871314                         
## [299,] Nitrogen Fertilizer Solution        44   2871315                         
## [300,] Nitrogen Fertilizer Solution (50%)  22   4904275                         
## [301,] Nitrophenol                         1    4963394                         
## [302,] Nonylphenol                         1    4931763                         
## [303,] Not Applicable                      3    -98                             
## [304,] Nut, Seed or Vegetable Oil          42   2093343                         
## [305,] Octadiene                           1    4909270                         
## [306,] Octanes                             9    4908188                         
## [307,] Octyl Alcohol                       8    4913158                         
## [308,] Octyl Aldehyde                      1    4912064                         
## [309,] Oil Foots, Sediments, Tank Btm, nec 1    2093990                         
## [310,] Oil, Petroleum, Nec                 28   2911791                         
## [311,] Oils Essent'l (Nat'l/Artif'l), Nec  1    2899909                         
## [312,] Old Coding - Apparel Industry       2    2300000                         
## [313,] Old Coding - Food Industry          6    2000000 <> 2093343              
## [314,] Old Coding - Lumber Industry        2    2400000                         
## [315,] Old Coding - Textile Mill Industry  5    2200000                         
## [316,] Old Coding - Tobacco Industry       5    2100000                         
## [317,] Oleum                               10   4930030                         
## [318,] Other Regulated Substances,Liq,NOS  4    4941204                         
## [319,] Paint Related Material              3    4915265                         
## [320,] Paints, Stains, Varnishes           1    4910251                         
## [321,] Paraffin                            3    2991290                         
## [322,] Paraxylene                          7    4909351                         
## [323,] Paste, Nec                          1    2891160                         
## [324,] Paving Tar                          3    4910261                         
## [325,] Pentane                             4    4908255                         
## [326,] Pesticides,Liq.,Toxic,Flam.,N.O.S.  1    4921056                         
## [327,] Peteroleum Crude Oil                34   4915165                         
## [328,] Petrolatum                          1    2911946                         
## [329,] Petroleum Alkylate Detergent        2    4936554                         
## [330,] Petroleum Conensate                 1    4910258                         
## [331,] Petroleum Crude Oil                 559  4910165                         
## [332,] Petroleum Distillate Fuel Oil       17   2911315 <> 4910242              
## [333,] Petroleum Distillates               16   4915287                         
## [334,] Petroleum Fuel, Residual            15   4915111                         
## [335,] Petroleum Hydrocarbon Resin         1    2821168                         
## [336,] Petroleum Lube Oil                  28   4915242                         
## [337,] Petroleum Lubricating Oil           36   2911415                         
## [338,] Petroleum Naphtha                   19   4910259 <> 4915259 <> 4910256   
## [339,] Petroleum Oil                       32   4910245 <> 1311110              
## [340,] Petroleum Oil, N.O.S.               14   4915245 <> 4910360              
## [341,] Petroleum Products, Mixed Loads     2    2911987                         
## [342,] Petroleum Residual Fuel Oil         3    2911715                         
## [343,] Petroleum, Partially Ref. for Proc. 1    4910243                         
## [344,] Phenol                              45   4921220                         
## [345,] Phenol Formaldehyde Resin           5    2821124                         
## [346,] Phenol, molten                      26   4921598                         
## [347,] Phosphoric Acid                     99   4930248                         
## [348,] Phosphoric Acid (77%)               110  4930247                         
## [349,] Phosphoric Acid, Solution           2    4930248                         
## [350,] Phosphoric Anhydride                1    4932324                         
## [351,] Phosphorous, White or Yellow        12   4916141                         
## [352,] Phosphorus Trichloride              1    4932359                         
## [353,] Phthalic Anhydride                  11   4934223                         
## [354,] Pine Oil                            1    4915170                         
## [355,] Plasticizer Alcohol, N.O.S.         1    4910406                         
## [356,] Plasticizer Resin                   1    4910410                         
## [357,] Plasticizer, Asphalt Tile           1    4910408                         
## [358,] Plasticizers                        6    4915410                         
## [359,] Plasticizers, Paint, Lacquer, Etc.  3    2818967                         
## [360,] Plastics, Resins or Gums, Nec       10   2821143                         
## [361,] Poisonous Liquid, N.O.S.            1    4921475                         
## [362,] Polyethylbenzene                    1    4913155                         
## [363,] Polyethylene Glycol                 3    2818554                         
## [364,] Polyoxyethylene Ether               4    2818260                         
## [365,] Polypropylene                       4    2821139                         
## [366,] Polypropylene Glycol                16   2818555                         
## [367,] Polytetramethylene Glycol           1    2818557                         
## [368,] Potassium Acetate, Liquid           1    2818613                         
## [369,] Potassium Hydroxide                 30   4935230 <> -99                  
## [370,] Propane                             73   4905781                         
## [371,] PROPANE, PROPYLENE                  1    4905766                         
## [372,] Propionitrile                       1    4909281                         
## [373,] Propyl Acetate                      1    4909268                         
## [374,] Propyl Alcohol                      2    4909267                         
## [375,] Propylene                           40   4905782                         
## [376,] Propylene Dichloride                2    4909269                         
## [377,] Propylene Glycol                    16   2818556 <> 4910481              
## [378,] Propylene Oxide                     27   4906620                         
## [379,] Propylene Tetramer                  3    4912675 <> 4915575              
## [380,] PROPYLENE TETRAMER                  1    4912675                         
## [381,] Pulp Mill Liquid                    3    4910320                         
## [382,] Rapeseed Oil                        24   2093342                         
## [383,] Refinery Cracking Stock             13   2814158                         
## [384,] Refrigerant Gas, N.O.S.             1    4904570                         
## [385,] Refrigerant Gas, Non-Flammable      1    4904536                         
## [386,] Resin Solution                      6    4910280 <> 4915282              
## [387,] Resin Solution, Plastic, or Gums    1    4910282                         
## [388,] Rosin                               3    2861239                         
## [389,] Rosin solution                      2    4915344                         
## [390,] Rubber Extender Oil, Petroleum Base 5    2911957                         
## [391,] Rubber, Synthetic                   1    2821220                         
## [392,] Silica, Colloidal, In Solution      1    2819986                         
## [393,] Soap, Nec, Liquid                   2    2841990                         
## [394,] Sod&CalSltsofPolyNaphthSulphAcidLiq 1    2819060                         
## [395,] Sodium Aluminate Solution           5    4935260                         
## [396,] Sodium Bichromate Solution          1    2819995                         
## [397,] Sodium Bisulfite Solution           1    4936339                         
## [398,] Sodium Carbonate                    6    2812322                         
## [399,] Sodium Chlorate                     4    4918723 <> 2819924              
## [400,] Sodium Chlorate, Aqueous Solution   4    4918765                         
## [401,] Sodium Chlorate/Sodium Choride Sol  1    2899951                         
## [402,] Sodium Chloride, Aqueous Solution   1    4918765                         
## [403,] Sodium Dichromate                   2    4941170                         
## [404,] Sodium Hydrosulfide, Solution       8    4935268                         
## [405,] Sodium Hydroxide                    357  4935240                         
## [406,] Sodium Hydroxide, Spent             24   4935206                         
## [407,] Sodium Hydroxide, with Potassium    6    4935245                         
## [408,] Sodium Hydroxide, with Water        22   4935243                         
## [409,] Sodium Hydroxide/So Borohydride Sol 2    4935273                         
## [410,] Sodium Methylate, Alcohol Mixture   2    4909290                         
## [411,] Sodium Nitrite                      1    4918747                         
## [412,] Sodium Silicate                     13   2819992                         
## [413,] Sodium, Metal                       1    4916456                         
## [414,] Solvent                             2    4910187                         
## [415,] Sorbitol Sol. w/not less 30% water  1    2818244                         
## [416,] Sorbitol Solution, Crude            2    2818245                         
## [417,] SoyBean Oil                         109  2092110                         
## [418,] Styrene                             1    2818342                         
## [419,] Styrene Monomer, Inhibited          123  4907265                         
## [420,] Sugar, Liquid                       4    2062215                         
## [421,] Sulfide Waste (Petroleum Refinery)  1    4936539                         
## [422,] Sulfur Chloride (Mono)              1    4932380                         
## [423,] Sulfur Dioxide                      9    4904290                         
## [424,] Sulfur Trioxide                     2    4930050                         
## [425,] Sulfur, Molten                      530  4945770                         
## [426,] Sulfuric Acid                       405  4930040                         
## [427,] Sulfuric Acid,Spent                 22   4930042                         
## [428,] Sulphate Black Liquor Skimmings     6    2611230                         
## [429,] Tall Oil                            6    2861230                         
## [430,] Tall Oil, Crude                     6    2861235                         
## [431,] Tallow Animal, Inedible             34   2014350                         
## [432,] Tallow Oil , Nec, Inedible          3    2014335                         
## [433,] Tallow, Animal, Nec                 10   2013955                         
## [434,] Tallow, Edible                      7    2013953                         
## [435,] Tar, Coal or Petroleum              6    4910263 <> 4915263              
## [436,] Tetrachloroethylene                 6    4925202                         
## [437,] Tetrafluoroethane                   2    4904304                         
## [438,] Tetrahydrofuran                     1    4908290                         
## [439,] Thiapentanal                        7    4925206                         
## [440,] Titanium Dioxide and Water Mixed    4    2816130                         
## [441,] Titanium Dioxide, NEC               1    2816125                         
## [442,] Titanium Tetrachloride              1    4932385                         
## [443,] Toluene                             20   4909305                         
## [444,] Toluene Diisocyanate                34   4921575                         
## [445,] Tomato Paste                        2    2033615                         
## [446,] Toxic Liquid, Inorganic, N.O.S.     2    4921025                         
## [447,] Trichloroethylene                   1    4941171                         
## [448,] Tridecyl Benzene                    1    2815136                         
## [449,] Triethylene Glycol                  2    2818558                         
## [450,] Trimethylamine, Anhydrous           2    4905540                         
## [451,] Trimethylchlorosilane               2    4907680                         
## [452,] Tripropylene                        4    4909249                         
## [453,] Turpentine                          1    4910313                         
## [454,] Unknown                             8773 -99 <> 4906610 <> -98 <> 4930040
## [455,] Unknown but Loaded                  659  15                              
## [456,] Urea Liquor                         7    2818146                         
## [457,] Vegetable Oil, Hydrogenated         8    2096125                         
## [458,] Vegetable Oils, Vulcanized          1    2899985                         
## [459,] Vinyl Acetate                       44   4907270                         
## [460,] Vinyl Chloride                      210  4905792                         
## [461,] Vinyl Methyl Ether, Inhibited       1    4905792                         
## [462,] Vinyl Toluene                       1    4912275                         
## [463,] Vinylidene Chloride, Inhibited      7    4907280                         
## [464,] Water (Raw)                         1    1492110                         
## [465,] Water, Waste                        7    4029120                         
## [466,] Wax                                 4    4915387                         
## [467,] Wax (Paraffin or Petroleum), Nec    16   2911990                         
## [468,] Weed Killing Compound               2    4910157                         
## [469,] Wines, Nec                          1    2084120                         
## [470,] Xylene                              29   4909350