The following files are in excel file format. From 2022_kern_permit.zip: FILE DEFINITION FOR FILE: #1 ----------------------------------------------------------------------------- FILE ROOT NAME : KC22PMT.XLS USER DISPLAY NAME : 2022 Permit/Operator Site ID/ID - 2022 NUMBER OF RECORDS : 15,861 ----------------------------------------------------------------------------- FLD FIELD NUM NAME --- ----------- 1 PERMIT NUMBER 2 LOCATION 3 COMMODITY 4 MERIDIAN 5 TOWNSHIP 6 RANGE 7 SECTION 8 QUANTITY 9 UNITS 10 EFFECTIVE DATE 11 EXPIRATION DATE 12 PERMITTEE 13 AGENT NAME 14 MAILING ADDRESS 15 CITY 16 STATE 17 ZIP From 2022_kern_use.zip: This file is in an excel format. FILE DEFINITION LISTING FOR FILE #2 ----------------------------------------------------------------------------- FILE ROOT NAME : KC22PURS.XLS USER DISPLAY NAME : Agricultural Production PUR - 2022 NUMBER OF RECORDS : 199,866 ----------------------------------------------------------------------------- FIELD FIELD NMBR NAME ----- ----- 1 PERMIT # 2 PERMITTEE 3 SITE ID 4 MERIDIAN 5 TOWNSHIP 6 RANGE 7 SECTION 8 APPLICATION DATE 9 APPLICATION TIME 10 COMMODITY 11 PLANTED AMOUNT 12 PLANTED UNITS 13 EPA REG NO. 14 PRODUCT NAME 15 QUANTITY USED 16 QUANTITY UNITS 17 TREATED AMOUNT 18 TREATED UNITS 19 APPL. METHOD (A=air,G=ground,O=other) 20 FUME CODE From 2022_kern_mspur.zip: This file is in an excel format. FILE DEFINITION LISTING FOR FILE #3 ----------------------------------------------------------------------------- FILE ROOT NAME : KC22MSPUR.XLSx USER DISPLAY NAME : Monthly Summaries MSPUR - 2022 NUMBER OF RECORDS : 15,832 ----------------------------------------------------------------------------- FIELD FIELD NMBR NAME ----- ----- 1 LICENSE # 2 OPERATOR 3 PERMIT # 4 PERMITTEE 5 MONTH/YEAR 6 PRODUCT NAME 7 EPA REG NO. 8 QUANTITY USED 9 QUANTITY UNITS 10 # OF APPLICATIONS 11 COMMODITY 12 TREATED AMOUNT 13 TREATED UNITS From 2022_kern_contacts.zip: This file is in an excel format. FILE DEFINITION LISTING FOR FILE #4 ----------------------------------------------------------------------------- FILE ROOT NAME : KC22CONTACTS.XLSx USER DISPLAY NAME : CONTACTS - 2022 NUMBER OF RECORDS : 1,195 ----------------------------------------------------------------------------- FIELD FIELD NMBR NAME ----- ----- 1 NAME 2 AGENT NAME 3 CONTACT TYPE 4 LIC./CERT. # 5 LIC./CERT. EXPIRE 6 REGISTRATION DATE 7 REGISTRATION EXPIRE 8 MAILING ADDRESS 9 CITY 10 STATE 11 ZIP