Skip to main content

Posts

Showing posts from February, 2013

Probability and Cumulative Dice Sums

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 database .  The 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 percen

Sergey Brin, Please Pick up your Paychecks

The state of California is currently holding over $6 billion  in unclaimed property belonging to millions of people. What type of property and who are the rightful owners? According to California's official unclaimed property website, these assets fall into the following categories: Bank accounts and safe deposit box contents Stocks, mutual funds, bonds, and dividends Uncashed cashier's checks or money orders Certificates of deposit Matured or terminated insurance policies Estates Mineral interests and royalty payments, trust funds, and escrow accounts People forget, people die, people move around. But $6 billion is a staggering amount of money; some of these amounts have to be really large. Let's try to find some interesting examples. This is official California UCP search form . Programmer and database types will notice one problem immediately - no fuzzy string matching . If your name or address was misspelled on the assets, or munged in the recording proce