The following files are in tab delimited text file format... From kc09prmt.exe: FILE DEFINITION FOR FILE: #1 ----------------------------------------------------------------------------- FILE ROOT NAME : kc09pmt.txt USER DISPLAY NAME : 2009 Permit/Operator Site ID/ID NUMBER OF RECORDS : 14,422 ----------------------------------------------------------------------------- FLD FIELD FLD FLD DEC RELATES--TO NUM NAME TYPE LEN PTS FILE FIELD --- ----------- ---- --- --- ---- ----- 1 PERMIT ASC 7 1 1 2 LOCATION ASC 8 3 COMMODITY ASC 15 4 MERIDIAN ASC 1 5 TOWNSHIP ASC 3 6 RANGE ASC 3 7 SECTION NUM 2 0 8 QUANTITY NUM 11 2 9 UNITS ASC 1 10 EFFECT_DATE DAT 8 11 EXP_DATE DAT 8 12 PERMITTEE ASC 30 13 LASTNAME ASC 30 14 FIRSTNAME ASC 15 15 MAIL_ADDR ASC 30 16 MAIL_CITY ASC 30 17 MAIL_ST ASC 2 18 MAIL_ZIP ASC 10 FILE DEFINITION FOR FILE #2 ----------------------------------------------------------------------------- FILE ROOT NAME : kc09pst.txt USER DISPLAY NAME : 2009 Permit/Operator Site ID/ID Pesticides NUMBER OF RECORDS : 57,821 ----------------------------------------------------------------------------- FLD FIELD FLD FLD DEC RELATES--TO NUM NAME TYPE LEN PTS FILE FIELD --- ----------- ---- --- --- ---- ----- 1 PEST_CODE NUM 5 0 2 PERMIT ASC 7 2 1 3 LOCATION ASC 8 2 2 4 COMMODITY ASC 15 5 FORMS ASC 1 6 METHOD ASC 2 7 APPLICATOR ASC 2 From kc09purs.exe: This file is in a comma delimited text file format. It contains more than 65,536 records and thus, should NOT be opened in Excel due to a record numberlimit in Excel. FILE DEFINITION LISTING FOR FILE #3 *************************************************** FILE ROOT NAME = KC09PURS.TXT USER DISPLAY NAME = Agricultural Production PUR - 2009 *************************************************** NUMBER OF RECORDS = 122,949 *************************************************** FIELD FIELD FIELD DEC RELATES--TO NMBR LEN TYPE PTS FILE FIELD ----- ----- ----- --- ---- ----- 1 8 NUMERIC 0 0 0 REPORT# (Document Number) 2 1 ASCII 0 0 ACTIVITY (P=PCO, O or M=Grower) 3 1 ASCII 0 0 APPLMETH (A=air,G=ground,O=other) 4 7 ASCII 1 1 PERMIT 5 8 ASCII 2 2 LOCATION 6 15 ASCII 0 0 COMMODITY 7 11 NUMERIC 2 0 0 QUANTITY (Acres Planted) 8 1 ASCII 0 0 MERIDIAN 9 3 ASCII 0 0 TOWNSHIP 10 3 ASCII 0 0 RANGE 11 2 NUMERIC 0 0 0 SECTION 12 8 DATE 0 0 DATE_APPL 13 2 NUMERIC 0 0 MIL_HOUR_APPL 14 2 NUMERIC 0 0 MIL_MINUTES_APPL 15 10 NUMERIC 2 0 0 QUAN_TREAT (Acres Treated) 16 7 NUMERIC 0 0 0 MFG_FIRMNO --| 17 5 NUMERIC 0 0 0 LABEL_SEQ_NO | The four components 18 2 ASCII 0 0 REVISION_NO | of EPA Reg Number 19 7 NUMERIC 0 0 0 REG_FIRMNO --| 20 40 ASCII 0 0 PESTICIDE NAME (Brand Name) 21 8 NUMERIC 2 0 0 AMT_USED 22 2 ASCII 0 0 AMT_UNITS