The Export file is a pipe-delimited csv file that contains all records in the system The file includes the header in the first row. Header Definitions: id Unique row identifier for table propertyId unique identifier for each record headingLn Tax year and type, e.g. "2021 REAL ESTATE" or "2021 TANGIBLE PERSONAL PROPERTY" accountNum The parcel number/account number of the record escrowCode Mortgage code if mortgage assessAmt Assessment amount* exemptions Total exemptions amount* taxableAmt Taxable amount* millageCod Millage code (district code) addlOwners T/F (true false) more owners than listed pastDueMsg "PRIOR TAXES DUE" if prior year taxes due secTwnRng Section/township/range, e.g., SEC: 09 TNSHP: 37S RNG: 22E legalLine1 First 50 characters of legal description legalLine2 Second 50 characters of legal description legalLine3 Third 50 characters of legal description legalLine4 Fourth 50 characters of legal description legalLine5 NOT USED location Street name and address location2 NOT USED physLoc1 NOT USED physLoc2 NOT USED physLoc3 NOT USED address1 Address1 through address5 are owner names and address lines address2 Address1 through address5 are owner names and address lines address3 Address1 through address5 are owner names and address lines address4 Address1 through address5 are owner names and address lines address5 Address1 through address5 are owner names and address lines address6 NOT USED address7 NOT USED address8 NOT USED advDesc1 Ad Valorem Description 1 advDesc2 Ad Valorem Description 2 advDesc3 Ad Valorem Description 3 advDesc4 Ad Valorem Description 4 advDesc5 Ad Valorem Description 5 advDesc6 Ad Valorem Description 6 advDesc7 Ad Valorem Description 7 advDesc8 Ad Valorem Description 8 advDesc9 Ad Valorem Description 9 advDesc10 Ad Valorem Description 10 advDesc11 Ad Valorem Description 11 advDesc12 Ad Valorem Description 12 advDesc13 Ad Valorem Description 13 advDesc14 Ad Valorem Description 14 advDesc15 Ad Valorem Description 15 advDesc16 Ad Valorem Description 16 advDesc17 Ad Valorem Description 17 advDesc18 Ad Valorem Description 18 advDesc19 Ad Valorem Description 19 advDesc20 Ad Valorem Description 20 assesAmt1 Ad Valorem Assessment 1 assesAmt2 Ad Valorem Assessment 2 assesAmt3 Ad Valorem Assessment 3 assesAmt4 Ad Valorem Assessment 4 assesAmt5 Ad Valorem Assessment 5 assesAmt6 Ad Valorem Assessment 6 assesAmt7 Ad Valorem Assessment 7 assesAmt8 Ad Valorem Assessment 8 assesAmt9 Ad Valorem Assessment 9 assesAmt10 Ad Valorem Assessment 10 assesAmt11 Ad Valorem Assessment 11 assesAmt12 Ad Valorem Assessment 12 assesAmt13 Ad Valorem Assessment 13 assesAmt14 Ad Valorem Assessment 14 assesAmt15 Ad Valorem Assessment 15 assesAmt16 Ad Valorem Assessment 16 assesAmt17 Ad Valorem Assessment 17 assesAmt18 Ad Valorem Assessment 18 assesAmt19 Ad Valorem Assessment 19 assesAmt20 Ad Valorem Assessment 20 exemptn1 Exemption Amount 1 exemptn2 Exemption Amount 2 exemptn3 Exemption Amount 3 exemptn4 Exemption Amount 4 exemptn5 Exemption Amount 5 exemptn6 Exemption Amount 6 exemptn7 Exemption Amount 7 exemptn8 Exemption Amount 8 exemptn9 Exemption Amount 9 exemptn10 Exemption Amount 10 exemptn11 Exemption Amount 11 exemptn12 Exemption Amount 12 exemptn13 Exemption Amount 13 exemptn14 Exemption Amount 14 exemptn15 Exemption Amount 15 exemptn16 Exemption Amount 16 exemptn17 Exemption Amount 17 exemptn18 Exemption Amount 18 exemptn19 Exemption Amount 19 exemptn20 Exemption Amount 20 taxable1 Taxable Amount 1 taxable2 Taxable Amount 2 taxable3 Taxable Amount 3 taxable4 Taxable Amount 4 taxable5 Taxable Amount 5 taxable6 Taxable Amount 6 taxable7 Taxable Amount 7 taxable8 Taxable Amount 8 taxable9 Taxable Amount 9 taxable10 Taxable Amount 10 taxable11 Taxable Amount 11 taxable12 Taxable Amount 12 taxable13 Taxable Amount 13 taxable14 Taxable Amount 14 taxable15 Taxable Amount 15 taxable16 Taxable Amount 16 taxable17 Taxable Amount 17 taxable18 Taxable Amount 18 taxable19 Taxable Amount 19 taxable20 Taxable Amount 20 millage1 Millage Rate 1 millage2 Millage Rate 2 millage3 Millage Rate 3 millage4 Millage Rate 4 millage5 Millage Rate 5 millage6 Millage Rate 6 millage7 Millage Rate 7 millage8 Millage Rate 8 millage9 Millage Rate 9 millage10 Millage Rate 10 millage11 Millage Rate 11 millage12 Millage Rate 12 millage13 Millage Rate 13 millage14 Millage Rate 14 millage15 Millage Rate 15 millage16 Millage Rate 16 millage17 Millage Rate 17 millage18 Millage Rate 18 millage19 Millage Rate 19 millage20 Millage Rate 20 advTax1 Ad Valorem Tax 1 advTax2 Ad Valorem Tax 2 advTax3 Ad Valorem Tax 3 advTax4 Ad Valorem Tax 4 advTax5 Ad Valorem Tax 5 advTax6 Ad Valorem Tax 6 advTax7 Ad Valorem Tax 7 advTax8 Ad Valorem Tax 8 advTax9 Ad Valorem Tax 9 advTax10 Ad Valorem Tax 10 advTax11 Ad Valorem Tax 11 advTax12 Ad Valorem Tax 12 advTax13 Ad Valorem Tax 13 advTax14 Ad Valorem Tax 14 advTax15 Ad Valorem Tax 15 advTax16 Ad Valorem Tax 16 advTax17 Ad Valorem Tax 17 advTax18 Ad Valorem Tax 18 advTax19 Ad Valorem Tax 19 advTax20 Ad Valorem Tax 20 exDescr1 Exemption Description 1 exDescr2 Exemption Description 2 exDescr3 Exemption Description 3 exDescr4 Exemption Description 4 exDescr5 Exemption Description 5 exDescr6 Exemption Description 6 exDescr7 Exemption Description 7 exDescr8 Exemption Description 8 exDescr9 Exemption Description 9 exDescr10 Exemption Description 10 exAmount1 Exemption Amount 1 exAmount2 Exemption Amount 2 exAmount3 Exemption Amount 3 exAmount4 Exemption Amount 4 exAmount5 Exemption Amount 5 exAmount6 Exemption Amount 6 exAmount7 Exemption Amount 7 exAmount8 Exemption Amount 8 exAmount9 Exemption Amount 9 exAmount10 Exemption Amount 10 totalMillage Total Millage Rate totalAdvTax Total Ad Valorem Tax, navDescr1 Non Ad Valorem Description 1 navDescr2 Non Ad Valorem Description 2 navDescr3 Non Ad Valorem Description 3 navDescr4 Non Ad Valorem Description 4 navDescr5 Non Ad Valorem Description 5 navDescr6 Non Ad Valorem Description 6 navDescr7 Non Ad Valorem Description 7 navDescr8 Non Ad Valorem Description 8 navDescr9 Non Ad Valorem Description 9 navDescr10 Non Ad Valorem Description 10 navRate1 Non Ad Valorem Rate Type 1 navRate2 Non Ad Valorem Rate Type 2 navRate3 Non Ad Valorem Rate Type 3 navRate4 Non Ad Valorem Rate Type 4 navRate5 Non Ad Valorem Rate Type 5 navRate6 Non Ad Valorem Rate Type 6 navRate7 Non Ad Valorem Rate Type 7 navRate8 Non Ad Valorem Rate Type 8 navRate9 Non Ad Valorem Rate Type 9 navRate10 Non Ad Valorem Rate Type 10 navAmt1 Non Ad Valorem Tax 1 navAmt2 Non Ad Valorem Tax 2 navAmt3 Non Ad Valorem Tax 3 navAmt4 Non Ad Valorem Tax 4 navAmt5 Non Ad Valorem Tax 5 navAmt6 Non Ad Valorem Tax 6 navAmt7 Non Ad Valorem Tax 7 navAmt8 Non Ad Valorem Tax 8 navAmt9 Non Ad Valorem Tax 9 navAmt10 Non Ad Valorem Tax 10 totlNavTax Total Non Ad Valorem Tax combinedTx Total Gross Tax exMsg T/F (true/false) more exemptions than listed seniorExMs T/F (true/false) has senior exemption pstmkDt1 First Discount Period Due Date pstmkDt2 Second Discount Period Due Date pstmkDt3 Third Discount Period Due Date pstmkDt4 Forth Discount Period Due Date pstmkDt5 Fifth Discount Period Due Date pstmkDue1 First Discount Period Due Amount pstmkDue2 Second Discount Period Due Amount pstmkDue3 Third Discount Period Due Amount pstmkDue4 Fourth Discount Period Due Amount pstmkDue5 Fifth Discount Period Due Amount taxYear Tax Year of record scanline Bill Scan Line, pastDueYrs Comma-separated list of past due years ctrl Record Control number if available zipCode Zip Code zip4 Zip Code +4 certificateNumber Certificate Number certificateYear Certificate Year buyerId Certificate Owner Bidder ID buyerName Certificate Owner Bidder Name bidInterestRate Certificate Interest Rate faceAmount Certificate Face Amount certificateSaleDate Certificate Sale Date purchaseDate Certificate Purchase Date taxDeedAppliedDate Tax Deed Applied Date totalDueDate Total Due Calculation Date totalDue Total Due Amount paymentAmount Latest Payment Amount paymentDate Latest Payment Date receiptNo Latest Payment Receipt Number paid Y/N (Yes/No) Paid Status of record installment Y/N (Yes/No) On Installment Plan bankrupt Y/N (Yes/No) In Bankruptcy warrant Y/N (Yes/No) Tangible Personal Property Warrant Issued tdIssued Y/N (Yes/No) Tax Deed Issued stlEligible STL Eligible Date installmentNumber Installment Number paymentQRCode Link to website detail (url for QR Code) dorCode DOR Code dorDescription DOR Description, e.g., "Single Family Home" * assessAmt,exemptions,taxableAmt fields are no longer as relevant since they represent max or total amounts. There can be multiple assessment amounts per record. The assessAmt is simply the maximum assessment. The exemptions is the total of exemptions; however, not all exemptions are applicable to all funds. The taxableAmt is the assessAmt - exemptions; however, the actual total gross due should be determined from the combinedTx field. Each Ad Valorem amount, Non Ad Valorem amount are listed in detail, along with totlNavTax (total Non Advalorem Gross Tax) and totalAdvTax (total Ad Valorem Gross Tax). The totalDue is the totalDue (including discounts, interest, penalties, etc as of the totalDueDate.