Skip to Search Skip to Left Navigation U.S. Department of Transportation (US DOT) Research and Innovative Technology Administration (RITA) Bureau of Transportation Statistics (BTS)Bureau of Transportation Statistics (BTS) - Research and Innovative Technology Administration (RITA) - United States Department of Transportation (USDOT, US DOT or DOT)
  ABOUT RITA | CONTACT US | PRESS ROOM | CAREERS | SITE MAP
Bureau of Transportation Statistics
Data and Statistics
Bookstore
Programs
About BTS
Upcoming Press Releases
External Links
Intelligent Transportation Systems
National Transportation Library
Research, Development and Technology
Transportation Safety Institute
University Transportation Centers
Volpe National Transportation Systems Center
Printable Version

MPIR BASIC RECORD

Excel | CSV

FIELD NAME FIELD DESCRIPTION TYPE/LGTH
CASENO MP MSIS CASE NO CHAR(10)
PIRSPCN COAST GUARD DISTRICT CHAR(2)
COAST GUARD UNIT CHAR(5)
PCN (SEQUENCE NUMBER) CHAR(5)
INCIDENT YEAR CHAR(4)
PIND PIRS INDICATOR CHAR(1)
PORTCODE PORT CHAR(5)
OSC ON SCENE COORDINATOR AGENCY CHAR(4)
EPA EPA REGION CHAR(2)
CDATE (GROUP) DATE CLOSED  
CDATEDD CLOSED DAY CHAR(2)
CDATEMM CLOSED MONTH CHAR(3)
CDATEYY CLOSED YEAR CHAR(4)
VALID VALIDATED CHAR(1)
RPTBY REPORTED BY CHAR(2)
RDATE (GROUP) DATE REPORTED  
RDATEDD REPORT DAY CHAR(2)
RDATEMM REPORT MONTH CHAR(3)
RDATEYY REPORT YEAR CHAR(4)
RTIME TIME REPORTED CHAR(4)
DTIME SPILL DATE/TIME INDICATOR CHAR(1)
SDATE (GROUP) DATE OF SPILL  
SDATEDD SPILL DAY CHAR(2)
SDATEMM SPILL MONTH CHAR(3)
SDATEYY SPILL YEAR CHAR(4)
STIME TIME OF SPILL CHAR(4)
CASREF CASUALTY CASE REF CHAR(10)
WTRBD WATER BODY CHAR(5)
RMILE RIVER MILE CHAR(4)
LATIND LATITUDE INDICATOR CHAR(1)
LAT LATITUDE CHAR(5)
LONGIND LONGITUDE INDICATOR CHAR(1)
LONGIT LONGITUDE CHAR(6)
CITY CITY CHAR(25)
STATE STATE CHAR(2)
ACT CLEAN UP ACTION CHAR(2)
REMPTY REMOVAL PARTY CHAR(3)
PNUM PROJECT NUMBER CHAR(10)
PTYPE PROJECT TYPE CHAR(6)
CEILING AUTHORIZED CEILING CHAR(9)
EXPEND FUNDS EXPENDED CHAR(9)
TCOST TOTAL COST CHAR(9)
NOTIFICATION NRC NOTIFICATION CHAR(1)
NRCNUMBER NRC CASE NUMBER CHAR(12)
YEAR INCIDENT YEAR CHAR(4)
QTR INCIDENT QUARTER CHAR(1)

PRIMARY KEY IS CASENO