Skip to content
ABOUT RITA
|
CONTACT US
|
PRESS ROOM
|
CAREERS
|
SITE MAP
Data and Statistics
Bookstore
Programs
About BTS
Upcoming Press Releases
External Links
BTS Home
>
Programs
>
Maritime Data Working Group
>
USCG Pollution Incident Reporting System (PIRS) Data Dictionary - 1973-1991
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