Sorting Tax Delinquent List for most motivated sellers

[Anthony DiRico]

I just my hands on LA county delinquent tax roll and I'm sorting through the data and am a bit overwhelmed. My excel spreadsheet has about 700,000 rows worth of data and I'm trying to narrow it down to the top 5,000 most motivated leads. Whoever has experience with the tax list, are you finding that best leads come from the most number of defaults, highest current balance due, years in delinquency or anything else? What's the best criteria to focus on? Thanks in advance.

[Larry Higgins]

@Anthony DiRico does the spreadsheet give you delinquent amount and CAD value? 

 If so, I would take the top five thousand with the highest delinquency as a percentage of the overall value.  For instance, a $20k tax delinquency on a $200k property would carry a lot more weight with me than a $20k tax delinquency on a $700k property.

Either that or you could just take the top 5,000 most delinquent properties you can find that fall within your parameters.

A lot of the the top 5000 most delinquent properties will have the same properties with multiple years of delinquency.

I'm a little tired, so hope I didn't write that in a confusing way lol.