Unpaid Tax Roll

Format of the Unpaid Tax Roll File

The file All_current contains the assessor numbers that were billed in the most recent tax year. The file prior.dat contains assessor numbers that are still outstanding in prior years.

Each record is a single fixed-width line. The line below shows the field order. Hovering or focusing on a field highlights its matching explanation below, and each explanation names its field so the meaning is clear without using the highlight.

Data Format: aaaaaaaaaaaaaaaabbbbcccccccccccdddddddddddeeeeeeeeeeefffffffffffgh

The following are examples from the All_current file:

Example 1:   0000004         202200000068497000000684920000006849700000000000  
Example 2:   0000005         202200000001345000000013420000000134500000001342  

Characters 1–16 — Assessor number

The first 16 characters hold the assessor number. In the records above, that is 0000004 and 0000005.

Characters 17–20 — Tax year

The next 4 characters indicate the year for the data displayed. Above, the data is for tax year 2022.

Characters 21–31 — Amount billed, 1st installment

The next 11 characters show the amount billed* for the 1st installment.

Characters 32–42 — Amount billed, 2nd installment

The next 11 characters show the amount billed* for the 2nd installment.

Characters 43–53 — Amount paid, 1st installment

The next 11 characters show the amount of the 1st installment that has been paid.*

Characters 54–64 — Amount paid, 2nd installment

The next 11 characters show the amount of the 2nd installment that has been paid.*

Character 65 — Assignment flag

Indicates assignment status. Possible values:

• Blank — no assignment exists
• 1 — only the 1st half was paid on assignment (not the 2nd half)
• 2 — only the 2nd half was paid on assignment (not the 1st half)
• 3 — both halves were paid on assignment

Character 66 — Bankruptcy flag

Indicates bankruptcy status for that year. Possible values:

• Y — the parcel is marked as bankrupt for that year
• Blank — not bankrupt for that year

View the file layout explanation (FileLayout.pdf)Opens in a new tab.

*Note: In the amounts billed and paid, there are 2 implied decimal places. For example, 00000068497 is $684.97. Please take this into account when working with this file.