|
|
|
First Phase Report: Appendix B
|
|
|
Print  
|
|
Hazardous Materials Serious Crash Analysis:
First Phase Final Report
|
Table B-1. Comparison of Data as Reported in HMIS and MCMIS with Augmented Database
| Data Prior to Collection of Additional Data |
Augmented Database |
| MCMIS AC_REPORT_NUM |
MCMIS UN Number |
HMIS UNNUM |
HMIS RQUAN |
HMIS RUNIT |
UN Number |
Quantity Shipped |
Quantity Spilled |
Material Units |
| AK0000120641 | UN1230 | UN1230 | 8 | GAL | UN1230 | 9300 | 8 | GAL |
| AL001000604A | UN1075 | | | | UN1075 | 100 | 5 | GAL |
| AL001001641A | UN1824 | UN1824 | 5 | GAL | UN1824 | 6500 | 5 | GAL |
| AL001002239A | UN3257 | | | | UN3257 | | | |
| AL001003101A | UN1203 | NA1993 | 2000 | GAL | UN1203 | 9200 | 2000 | GAL |
| AL001013441A | | | | | UN1993 | | 0 | |
| AL001014603A | UN2187 | | | | UN2187 | | 0 | GAL |
| AL001018762A | UN1863 | | | | UN1863 | 0 | 0 | GAL |
| AL001024192A | UN1075 | UN1075 | 100 | GAL | UN1075 | 2600 | 100 | GAL |
| AL001026702A | | | | | | | | |
| AL001043325A | UN1203 | | | | UN1203 | 0 | 0 | |
| AL001045675A | UN1075 | UN1075 | 400 | GAL | UN1075 | 2400 | 400 | GAL |
| AL001064358A | UN1977 | | | | UN1977 | 0 | 0 | GAL |
| AL001073232A | UN1977 | UN1977 | 3125 | GAL | UN1977 | 4375 | 3125 | GAL | | AL001082485A | UN1203 | | | | UN1203 | 8090 | 5120 | GAL |
| AL001086867A | UN1203 | UN1203 | 7601 | GAL | UN1203 | 7601 | 7601 | GAL |
| AL001089252A | UN1075 | | | | UN1075 | 1200 | 2.5 | GAL |
| AL001103966A | UN1993 | | | | UN1993 | 0 | 0 | GAL |
| AR0001008315 | | | | | UN0083 | 10247 | | LBS | | AZ000000965A | UN1203 | UN1203 | 0 | | UN1203 | 0 | 0 | |
| AZ0000037281 | UN3257 | | | | UN3257 | | | |
| AZ0000037645 | UN1203 | UN1203 | 8307 | GAL | UN1203 | 0 | 8307 | GAL | | AZ0000052269 | UN3066 | | | | UN3066 | | | |
| AZ0000057513 | UN1203 | | | | UN1203 | 8000 | 4500 | GAL |
| AZ000008079A | UN1978 | | | | UN1978 | 9000 | 9000 | GAL |
| AZ000013870A | UN3077 | | | | UN3077 | 60 | 0 | LBS |
| AZ000032452A | UN1866 | | | | UN1866 | | | |
| AZ0009420027 | UN1203 | UN1203 | 4000 | GAL | UN1203 | 8900 | 4000 | GAL |
| AZ0009561219 | UN1203 | | | | UN1203 | | | |
| AZ009240790A | UN1203 | | | | UN1993 | 6000 | | GAL |
| CA0100154124 | UN1203 | | | | UN1203 | 4000 | | GAL |
| CA0100154124 | | | | | UN1993 | 4000 | 25 | GAL | | CA100087141A | UN1993 | | | | | 8000 | 7500 | GAL |
| CA100098421A | UN1075 | | | | UN1075 | 9450 | 9400 | GAL |
| CA100194137A | UN1203 | | | | UN1203 | | 0 | GAL |
| CA100200076A | UN1863 | UN1863 | 8035 | GAL | UN1863 | 8000 | 8000 | GAL |
| CA100200077A | UN1203 | UN1993 | 8705 | GAL | UN1203 | 8600 | | GAL |
| CA100204585A | UN1267 | | | | UN1267 | 3600 | 100 | GAL |
| CA100204585A | UN1267 | | | | UN1267 | 3900 | 3900 | GAL |
| CA100246464A | UN3257 | | | | UN3257 | 4500 | 10 | GAL |
| CA100302512A | UN1993 | | | | UN1993 | 3500 | 3000 | GAL |
| CO2001009334 | UN3257 | | | | UN3257 | | 6000 | GAL |
| CO2001009555 | UN1267 | | | | UN1267 | 8064 | 126 | GAL |
| CO2001009873 | UN1230 | | | | UN1230 | 300 | 155 | GAL |
| CO2001010141 | UN1993 | | | | UN1993 | 7208 | 4000 | GAL |
| CO2001010307 | UN1203 | | | | UN1203 | 8300 | 8300 | GAL |
| CO2001010386 | | UN1203 | 8100 | GAL | UN1203 | 8200 | 8100 | GAL |
| CO2001010432 | UN1203 | UN1203 | 500 | GAL | UN1203 | 8600 | 500 | GAL |
| CO2001010657 | UN1203 | | | | UN1203 | 8300 | 1562 | GAL |
| CO2001011026 | UN1203 | UN1203 | 65 | GAL | UN1993 | 7200 | 65 | GAL | | CO2001011112 | UN1977 | | | | UN1977 | 2000 | 0 | GAL |
| CO2001011140 | UN1203 | | | | UN1203 | | | |
| CO2001011374 | UN2794 | | | | UN2794 | | | |
| CO2001011438 | UN3257 | | | | UN3257 | 6500 | 500 | GAL |
| CTH01-203364 | UN2003 | | | | UN2003 | 39 | | LBS | | DE0101056538 | UN1203 | | | | UN1203 | | | | | FL5194766401 | UN1203 | UN1203 | 0.13 | GAL | UN1203 | 9200 | 0.13 | GAL |
| FL5709662701 | UN1863 | | | | UN1863 | 7800 | 0 | GAL |
| FL5984377401 | UN1203 | | | | UN1203 | 500 | 0 | GAL |
| FL5984387801 | UN1863 | | | | UN1863 | 8000 | 0 | GAL | | FL5984388001 | UN1203 | | | | UN1203 | 8900 | 0 | GAL | | FL6022704901 | UN1942 | | | | UN1942 | 49280 | | LBS | | FL6022752301 | UN1203 | NA1993 | 1000 | GAL | UN1993 | 7500 | 1000 | GAL | | FL6024659501 | UN1203 | UN1203 | 7001 | GAL | UN1203 | 7001 | 7001 | GAL | | FL6029492801 | UN1075 | | | | UN1075 | 0 | 0 | GAL | | FL6035862101 | UN1203 | | | | UN1203 | 9000 | 0 | GAL | | FL6057969301 | UN3291 | | | | UN3291 | | | | | FL6084476901 | UN1090 | | | | UN1090 | 0 | 0 | GAL | | FL6107095601 | UN3257 | | | | UN3257 | 24 | | LBS | | FL6118528101 | UN1090 | | | | UN1090 | 0 | 0 | | | FL6144561801 | UN1863 | UN1863 | 210 | GAL | UN1863 | 9400 | 210 | GAL | | FL6156610401 | UN1111 | | | | UN1203 | 0 | 0 | GAL | | FL6182411101 | | | | | UN1993 | 130 | | GAL | | FL6182580103 | UN1203 | | | | UN1203 | | | | | FL6192172801 | UN1111 | | | | UN1111 | | | | | GA2001000001 | UN1203 | | | | UN1203 | 9000 | 0 | GAL | | GA2001000031 | | | | | UN1863 | 8000 | 0 | GAL | | GA2001000074 | UN1760 | | | | UN1760 | 1500 | 10 | GAL | | GA2001000077 | UN1203 | | | | UN1203 | 8700 | 2200 | GAL | | GA2001000091 | UN1993 | | | | UN1993 | | | | | HI01-0034822 | UN1978 | | | | UN1978 | | | | | ID0100101220 | UN1203 | | | | UN1203 | 10000 | 0 | GAL | | ID0195300310 | UN1863 | UN1863 | 50 | GAL | UN1863 | 5200 | 50 | GAL | | IL0007374281 | UN1987 | | | | UN1987 | 8105 | 300 | GAL | | IL0007763581 | UN2187 | | | | UN2187 | | | | | IN010000108_ | UN2794 | | | | UN2794 | | | | | IN010000118_ | UN1993 | | | | UN1993 | | | | | IN010000291_ | UN1198 | | | | UN1198 | | | | | KS2001003923 | UN1270 | UN1267 | 0.02 | GAL | UN1075 | | | | | KS2001004186 | UN1075 | | | | UN1075 | | 0 | | | KS2001004331 | UN1963 | UN1963 | 11000 | GAL | UN1963 | 9353 | 9353 | GAL | | KS2001004379 | UN1263 | | | | UN1263 | | | | | MA0000004351 | UN1993 | | | | UN1993 | | | | | MA0000004500 | UN1993 | | | | UN1993 | 10000 | 7500 | GAL | | ME2001104150 | UN1993 | | | | UN1993 | | | | | ME2001125930 | UN1203 | NA1993 | 30 | GAL | UN1203 | 8600 | 30 | GAL | | MN0110049500 | UN1203 | | | | UN1203 | 0 | 0 | GAL | | MN0120400300 | | | | | UN1072 | 0 | | | | MN0131261800 | | | | | UN3262 | 60 | | LBS | | MN0140974000 | UN1203 | NA1203 | 8000 | GAL | UN1203 | 8500 | 5000 | GAL | | MN0150700000 | UN1005 | UN1005 | 113.63 | CFT | UN1005 | 133.68 | 113.63 | CFT | | MN0160194100 | UN3268 | | | | UN3268 | | | | | MN0170097300 | UN1987 | | | | UN1987 | 8000 | | GAL | | MN01900512A0 | | UN1170 | 88 | GAL | UN1203 | 88 | 88 | GAL | | MO001074003A | UN1263 | | | | UN1263 | | | | | MO001089005A | | | | | UN | | | | | MO001094007A | UN1203 | | | | UN1203 | 9800 | | GAL | | MO001094026A | UN1361 | | | | UN1361 | 42000 | 1000 | LBS | | MO001156023A | UN1866 | | | | UN1866 | | | | | MO001192011A | UN1203 | NA1993 | 2662 | GAL | UN1203 | 6400 | 2562 | GAL | | MO001192011A | | | | | UN1203 | 2000 | 100 | GAL | | MO001199003A | UN1203 | | | | UN1203 | 7830 | 6739 | GAL | | MO001240029A | | | | | | | | | | MO001283022A | | | | | | | | | | MO001302010A | UN1203 | | | | UN1203 | 2100 | 700 | GAL | | MO001302018A | | | | | UN | | | | | MO001311009A | UN1805 | UN1805 | 5 | GAL | UN1805 | 5677.5 | 5 | GAL | | MO001317017A | UN3077 | | | | UN3077 | 39040 | 39040 | LBS | | MO001337014A | | | | | UN3267 | 848 | | LBS | | MO001337014A | | | | | UN3264 | 119 | | LBS | | MO001337014A | | | | | UN2366 | 1026 | | LBS | | MO001337014A | | | | | UN1993 | 949 | | LBS | | MO001337014A | | | | | UN1760 | 699 | | | | MO001341012A | | | | | | | 41316 | LBS | | MT011550802A | UN1005 | | | | UN1005 | 37560 | | LBS | | MT014070101A | UN1075 | UN1075 | 0 | | UN1075 | 9398 | 0 | GAL | | MT014990405A | UN1789 | | | | UN1789 | | | | | NC100270855A | UN1075 | | | | UN1075 | | | | | NC100337821A | UN1203 | UN1203 | 2498 | GAL | UN1203 | 8000 | 2498 | GAL | | NC100352047A | UN1956 | | | | UN1956 | | | | | NC100398845A | UN1203 | | | | UN1203 | 88 | 5000 | GAL |
| NV5001002719 | | | | | | | | |
| NVRN20010023 | UN1203 | | | | UN1203 | | | | | NY0012132470 | UN1203 | | | | UN1203 | 2800 | | | | NY0012227770 | UN1203 | UN1203 | 3953 | GAL | UN1203 | 12000 | 3953 | GAL | | NY011005010A | UN1203 | | | | UN1203 | | | | | NY011006440A | UN1223 | | | | UN1223 | | 100 | GAL | | NY011006450A | UN1203 | | | | UN1203 | 2200 | 20 | GAL | | NY011253510A | UN3149 | UN3149 | 400 | GAL | UN3149 | 600 | 400 | GAL | | NY011253730A | UN1977 | | | | UN1977 | | | | | NY011289440A | UN1202 | | | | UN1202 | 9103 | | GAL | | NY011520530A | UN1223 | | | | UN1223 | 2000 | 5 | GAL | | NY011521060A | UN1993 | | | | UN1993 | 2600 | | GAL | | NY0131957400 | UN1203 | | | | UN1203 | 8501 | 3000 | GAL | | OK0096232438 | UN0380 | | | | UN0380 | | | | | OK0096235810 | UN1267 | | | | UN1267 | | | | | OK0096235887 | UN1038 | | | | UN1038 | 41000 | | LBS | | OK0096236926 | UN1034 | | | | UN1034 | 4200 | | LBS | | OK0096239321 | UN2977 | | | | UN1977 | 4000 | | GAL | | OK0096239331 | UN1267 | | | | UN1267 | 60 | | | | OK0096242530 | UN0114 | | | | UN0114 | 6592 | 0 | LBS | | OK0096248324 | UN1267 | | | | UN1267 | | | | | OK0096248674 | UN1267 | | | | UN1267 | | | | | OK0096257725 | UN1049 | | | | UN1049 | | | | | OK0096261871 | UN3257 | | | | UN3257 | 6500 | 30 | GAL | | OK0096263390 | UN3257 | | | | UN3257 | 6500 | 100 | GAL | | OK0096263637 | UN1866 | | | | UN1866 | | | | | OK0096273009 | UN1203 | UN1203 | 2661 | GAL | UN1203 | 5768 | 2661 | GAL | | OK0096276058 | UN3257 | | | | UN3257 | 5800 | 50 | GAL | | OK0096278629 | UN1203 | | | | UN1203 | 7200 | 2100 | GAL | | OK0096282262 | UN3291 | | | | UN3291 | 8000 | | LBS | | OK0096284289 | UN1267 | | | | UN1267 | | | | | OK0096294298 | UN1993 | | | | UN1993 | | | | | OK0097201973 | UN3257 | | | | UN3257 | 7000 | 7000 | GAL | | OR001180564A | UN1203 | | | | UN1203 | | 0 | | | OR001260126A | UN1993 | NA1993 | 5538 | GAL | UN1993 | 8300 | 5538 | GAL | | OR001420344A | UN3267 | | | | UN3267 | 2642 | 0 | LBS | | OR001420344A | | | | | UN1263 | 2600 | | | | OR001420344A | | | | | UN1044 | | | | | OR2001211002 | UN1203 | | | | UN1203 | 0 | 0 | GAL | | PA0103210700 | | UN1075 | 400 | GAL | UN1075 | 3000 | 400 | GAL | | PA0103753000 | UN0082 | | | | UN2430 | 45020 | | LBS | | PA0105291600 | UN0081 | | | | UN0042 | 100 | | LBS | | PA100554000A | UN1993 | | | | UN1993 | 800 | | GAL | | PA102221200A | | UN1075 | 3 | GAL | UN1075 | 2000 | 10 | GAL | | PA102319200A | | | | | | | 750 | GAL | | PA102901700A | UN1993 | NA1993 | 2300 | GAL | UN1993 | 3100 | 2300 | GAL | | PA103024800A | | | | | UN | | | | | PA103395100A | | UN1993 | 180 | GAL | UN1993 | 3300 | 180 | GAL | | PA104151900A | UN1993 | | | | UN1993 | 7500 | | GAL | | PA104402600A | | | | | | | 30 | GAL | | PA140004600A | UN1203 | | | | UN1203 | | | | | PA140012600A | UN1203 | | | | UN1203 | 9000 | 0 | | | PA140030100A | UN1273 | | | | UN1273 | | | | | PA140049100A | | | | | UN2187 | | | | | PA140057700A | | | | | UN | 4700 | | GAL | | PA140066200A | | | | | UN1805 | | | | | PA140083700A | | | | | UN2794 | | | | | RI4130070043 | UN1270 | | | | UN1270 | 1980 | 1900 | GAL | | SD12501I1008 | UN1270 | | | | UN1270 | | | | | SD13101J1507 | UN1203 | | | | UN1203 | 0 | 0 | GAL | | SDKINGSD0810 | UN3082 | | | | UN3082 | | | | | VA0000064864 | UN0083 | | | | UN1203 | 10 | | GAL | | VA0000075561 | UN0083 | | | | UN1203 | 9000 | 0 | GAL | | VA0000082661 | UN0083 | | | | UN0083 | | | | | VA0000083044 | | | | | UN1993 | 6000 | | GAL | | WA0001024986 | UN1203 | | | | UN1203 | 0 | 0 | GAL | | WA0001041344 | UN1956 | | | | UN1956 | 6100 | 0 | LBS | | WI0000033154A | | | | | UN1203 | 8000 | 1000 | GAL | | WI000032993A | | | | | UN1075 | | | | | WI000033682A | | UN1987 | 131 | GAL | UN1987 | 8000 | 131 | GAL | | WI000033885A | | UN1203 | 4 | GAL | UN1203 | 8500 | 4 | GAL | | WI000033990A | | | | | UN1203 | | | | | WV0000005035 | UN2977 | | | | UN2977 | | | | | WV000004797A | | | | | UN1978 | | | | | WV000006008A | UN1823 | | | | UN1823 | | | | | WV10042001 | | | | | UN0242 | 39720 | | LBS | | WY01054H151A | | | | | UN | 17000 | 0 | LBS | | WY01100F291A | | | | | UN1993 | 2000 | 2000 | GAL | | WY01101I061A | UN3257 | | | | UN3257 | 3000 | 1500 | GAL | | WY01120I021A | UN2448 | UN2448 | 200 | LBS | UN2448 | 16000 | 25 | GAL | | WY01122E291A | UN1203 | | | | UN1203 | 4000 | | GAL | | WY01124B231A | UN1267 | | | | UN1267 | 10800 | 0 | GAL | | WY01124H141A | UN3257 | | | | UN3257 | 6500 | 4100 | GAL | | WY01143F281A | UN1203 | UN1203 | 876 | GAL | UN1203 | 8000 | 876 | GAL | | WY01146H221A | UN1203 | | | | UN1203 | 9660 | 9660 | GAL | | WY01166F271A | UN1203 | | | | UN1203 | 13366 | 3853 | GAL | | WY01S22G291A | UN1203 | NA1993 | 3181 | GAL | UN1203 | 12000 | 3181 | GAL | | WY01S35A081A | UN1075 | | | | UN1075 | 0 | 0 | GAL | | WY01S35B161A | UN1977 | | | | UN1977 | 1000 | 1 | GAL | | WY02150L051A | UN1203 | | | | UN1203 | | 5 | GAL | | WY02S36L031A | UN0084 | | | | UN0084 | 42000 | 0 | LBS |
|
|
|
|