Skip to main content

Why does Kaggle use Log-loss?

Mining the First 3.5 Million California Unclaimed Property Records


As I mentioned in my previous article the state of California has over $6 billion in assets listed in its unclaimed property databaseThe search interface that California provides is really too simplistic for this type of search, as misspelled names and addresses are both common and no doubt responsible for some of these assets going unclaimed. There is an alternative, however - scrape the entire database and mine it at your leisure using any tools you want.

Here's a basic little scraper written in Ruby.

It's a slow process, but I've managed to pull about 10% of the full database in the past 24 hours (3.5 million out of about 36 million).

What does the distribution of these unclaimed assets look like? 

Among those with non-zero cash reported amounts:
  • Total value - $511 million
  • Median value - $15
  • Mean value - $157
  • 90th percentile - $182
  • 95th percentile - $398
  • 98th percentile - $1,000
  • 99th percentile - $1,937
  • 99.9th percentile - $14,203
  • 99.99th percentile - $96,478
Visually, it looks like this:

  • 548309 have value >= $100
  • 67452 have value >= $1,000
  • 4954 have value >= $10,000
  • 304 have have value >= $100,000
  • 4 have value >= $1,000,000
  • The largest value was $8,050,000
The top 10 by value:
  1. $8,050,000 to Jasmine Holdco. Entered as Hold Co. Sent CEO Alexander Slusky a note on LinkedIn.
  2. $2,183,062 to someone associated with Procket Networks. Procket was bought by Cisco. Sent former Procket CFO Curtis Mason a note on LinkedIn.
  3. $1,669,561 to Wyle Systems. Address and city misspelled. Sent email to Wyle, was told this money belongs to Wyle Electronics, which in turn was purchased by Arrow Electronics.
  4. $1,419,929 to Anne Baronia. Appears to have moved. Sent her notes on Facebook and LinkedIn.
  5. $777,856 to Citi Residential Lending. Premium refund.
  6. $639,000 to Martin Peter Wright. Funds for liquidation.
  7. $611,460 to Jeanne and Melvin Hing. Mature CD or savings certificate.
  8. $520,761 to Loretta Nisewander. Checking account.
  9. $507,077 to Payroll (no address). Now you know what to name your next kid. "This here's my son Payroll, and this one's my daughter Unknown".
  10. $450,000 Joseph Mallon. Funds for liquidation.
People who should be easy to contact:
  1. $58,946 to Ehren Maedge. COO of Scale Computing, Foundation Capital.
  2. $408,105 and $94,001 to Dane Prenovitz. Director of the Dani Investment Collection, appears to go by DJ Dane Mitchell now.
  3. $322,826 to the Hearts Afire Foundation.
  4. $160,825 to the Vernon Otto Wahrenbrock Trust. Wahrenbrock's was the biggest used bookstore here in San Diego - it was very sad when Vernon passed away and Wahrenbrock's closed. His grandson, Craig Maxwell, owns a bookstore in La Mesa.
  5. $10 to OJ Simpson from NetZero.

Comments

  1. Brilliant.

    Congratulations on a job well done.

    It's great to see this kind of work in action.

    ReplyDelete
  2. This is great. Thanks - I'm owed money!

    Are you going to put the database up there with a nicer front end when you're done?

    ReplyDelete
  3. You sent them notes like that, i imagine:

    Good Day Beneficiary,

    We hope this message finds you in good health and condition. We are glad to inform you that your name emerged the sum of 8,050,000.00 United State Dollars from the State of California...

    ReplyDelete
    Replies
    1. An exiled Austrian Prince, Arnold Schwarzenegger, has bequeathed you with many, many monies. Please remit $10 so we may send you these monies.

      Delete
  4. It's insane that so much money is just sitting around unclaimed. This is an extremely interesting undertaking you've gotten yourself into.

    ReplyDelete
  5. This comment has been removed by a blog administrator.

    ReplyDelete
  6. Hey do you still have the Ruby scraper? Can I get it?

    ReplyDelete
    Replies
    1. My code is on GitHub at https://github.com/octonion/ilikemoney.

      Delete
  7. Hello I wish to to share a comment here concerning you to definitely be able to inform you just how much i personally Loved this particular study. I have to elope in order to aTurkey Day time Supper but desired to leave ya an easy comment. We preserved you Same goes with be returning subsequent function to read more of yer quality articles. Keep up the quality work.



    California Property Records

    ReplyDelete
    Replies
    1. Thanks for any other great article. Where else may anyone get that kind of info in such a perfect method of writing? I have a presentation subsequent week, and I’m at the search for such info.


      California Property Records

      Delete

Post a Comment

Popular posts from this blog

A Bayes' Solution to Monty Hall

For any problem involving conditional probabilities one of your greatest allies is Bayes' Theorem. Bayes' Theorem says that for two events A and B, the probability of A given B is related to the probability of B given A in a specific way.

Standard notation:

probability of A given B is written \( \Pr(A \mid B) \)
probability of B is written \( \Pr(B) \)

Bayes' Theorem:

Using the notation above, Bayes' Theorem can be written: \[ \Pr(A \mid B) = \frac{\Pr(B \mid A)\times \Pr(A)}{\Pr(B)} \]Let's apply Bayes' Theorem to the Monty Hall problem. If you recall, we're told that behind three doors there are two goats and one car, all randomly placed. We initially choose a door, and then Monty, who knows what's behind the doors, always shows us a goat behind one of the remaining doors. He can always do this as there are two goats; if we chose the car initially, Monty picks one of the two doors with a goat behind it at random.

Assume we pick Door 1 and then Monty sho…

What's the Value of a Win?

In a previous entry I demonstrated one simple way to estimate an exponent for the Pythagorean win expectation. Another nice consequence of a Pythagorean win expectation formula is that it also makes it simple to estimate the run value of a win in baseball, the point value of a win in basketball, the goal value of a win in hockey etc.

Let our Pythagorean win expectation formula be \[ w=\frac{P^e}{P^e+1},\] where \(w\) is the win fraction expectation, \(P\) is runs/allowed (or similar) and \(e\) is the Pythagorean exponent. How do we get an estimate for the run value of a win? The expected number of games won in a season with \(g\) games is \[W = g\cdot w = g\cdot \frac{P^e}{P^e+1},\] so for one estimate we only need to compute the value of the partial derivative \(\frac{\partial W}{\partial P}\) at \(P=1\). Note that \[ W = g\left( 1-\frac{1}{P^e+1}\right), \] and so \[ \frac{\partial W}{\partial P} = g\frac{eP^{e-1}}{(P^e+1)^2}\] and it follows \[ \frac{\partial W}{\partial P}(P=1) = …

Behind the Speadsheet

In the book "The Only Rule Is It Has to Work: Our Wild Experiment Building a New Kind of Baseball Team", Ben Lindbergh and Sam Miller recount a grand adventure to take command of an independent league baseball team, with the vision of trying every idea, sane or crazy, in an attempt to achieve a winning edge. Five infielders, four outfielders, defensive shifts, optimizing lineups - everything.

It was really an impossible task. Professional sports at every level are filled with highly accomplished and competitive athletes, with real lives and real egos. Now imagine walking in one day and suddenly trying to convince them that they should be doing things differently. Who do you think you are?

I was one of the analysts who helped Ben and Sam in this quest, and I wanted to write some thoughts down from my own perspective, not as one of the main characters, but as someone more behind the scenes. These are some very short initial thoughts only, but I'd like to followup with some…