I wrote most of this app on a contract nearly 10 years ago. We used it as a mentorship exercise to train state worker programmers in the SCO department on the (then new) ASP.NET Framework and SQL Server 2000. The DBA was familiar with Oracle and mainframes, but not SQL Server. It was written in ASP.NET 1.1 and used SQL Server 2000. From what I can tell it hasn't changed much at all.
"Programmer and database types will notice one problem immediately - no fuzzy string matching."
Yeah, I really wanted to implement that. The problem was we had to use Microsoft SQL Server and no third party database/indexing systems. SQL Server's Full Text Indexing run took too long during the nightly import job on year 2000 commodity hardware. We also had to do all of this within the constraints of training state workers and handing off something they could actually maintain.
I see there are plenty of posts down below that are complaining about the lack of fuzzy search. By all means, crawl the site and create a better search engine. IIRC it is setup in such a way that new records are always appended at the end of the ID space. Just check every night for new things. At the time we wrote this there were a few companies doing just that, charging a small fee, and soliciting people that were owed large sums. I mean, you've got a $6B market, in just California, to play with where you could probably earn 5% or more as a finders fee to those that don't know this is public record, or might just pay you to avoid the hassle of the paperwork.
There was also a web service interface to this system that returned paged results as plain ole XML, but unfortunately I don't remember the URL. We had wanted to expand and create an interstate network by partnering with Texas and some others, but it never panned out for reasons I forget.
It is really nice to have the original author show up and comment on something like this.
After looking at this site I started thinking about ways of crawling the whole database. The 500-record limit would make an alphabet tree crawl a bit more challenging but not too bad. Do you think the state agency would be amenable to requests for bulk download?
[edit] just saw your post which answered most of my questions while I was typing them.
I have lived in several states including CA and found four claims for myself in the CA system due to forgotten accounts from prior addresses, here are a few that might be typical examples of what is being held in this program:
1. Pacific Bell Telephone Company $72.24
2. Verisign (SSL or domain payments) $73.50
3. 20 shares of TravelZoo stock ~$400.00 value?
That TravelZoo stock was from back in the crazy/genius dotcom days when they gave out free stock for email referrals and sign ups. :) They did something right since they are still in business.
I do appreciate this program as these were my oversight/losses, things I had forgotten. However the process to place claims is a bit of a hassle: I need to physically print out forms, include copies of ID, etc. I'll write up a blog post of the process of claiming it when it's all said and done.
I cannot believe the "SEC has not asserted any violation of law by Travelzoo" for "the first offering of 'free shares' over the Internet" [1]. Technically, only a registered broker-dealer agent is allowed to transact shares, and never at a price unrelated to the market.
A very interesting blog post. The key idea is here: "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 process, tracking down any assets belonging to you could become a difficult to impossible process. Given that this database has at most 18 million rows, there's no excuse for such a basic (and important) feature to be missing." A lot of government databases could improve usability enormously by implementing that suggestion.
When I was in college I spent a summer going through Alaska's database (it was downloadable), cross referencing with a people search engine, and then mailing letters to people to tell them that they had missing money and how to claim it (and asking for a 5% cut). Made a decent summer's wage. Pretty sure I could have made a ton more money but it was pretty boring work so I just focused on school and more professional internships after that.
Still, an opportunity for someone feeling entrepreneurial out there.
Except for the fact that the receiver is getting a letter in the mail from someone they've never met informing them that they are owed money. Pretty much screams scam, even though it isn't in this instance.
In Sweden, tax records are public information, so every year around tax time, tabloids will print long lists of names of "the richest people in YOUR neighborhood". Compared to that, this is nothing.
To find and release publicly personal information about someone -- name, address, phone number, and even SSN and credit card numbers -- in such away that they become identifiable to just about anyone online.
It would not be legal (in general) in EU. Data Protection etc.
Yes, child porn is banned on reddit. But things that are protected free speech, but not child porn ("sexually suggestive images of minors") are also banned on reddit.
A term used to describe speech protected under the US Constitution / First Amendement, i.e. it's illegal for the government to ban this sort of speech (they can ban other sorts of speech). Reddit is based in USA, and learn close to the US legal definition of free speech (except in some cases).
Eh, call my annoyed. When people complained about some subreddits that took sneaky sexualised photos of people (usually women) without their consent or knowledge, "free speech" was cited as a reason as to why it couldn't be closed. However when people started tracking down these photographers and publishing their personal info, suddenly that speech should be blocked.
Reddit seems to think it's OK to ban some protected speech to protect straight dude who want to perv at women, but it's not OK to ban some protected speech to protect women from being photographed in public.
(I think the creepshots subreddits probably should have been banned earlier)
There's good evidence that some of the creepshots were just regular photographs taken from existing websites, sometimes cropped or mirrored, and then given a new context. Some of this was done just to troll - linking a local meet subreddit to a creepshot group could generate a lot of anger.
People being angry about photos is one thing; real life information about people can lead to devastating witch-hunts and intense campaigns of harassment.
So I guess I can see why Reddit bans one, but not the other.
Sure, some of the creepshots and other things might be other photos. Doesn't mean all aren't though, one must address that.
People being angry about photos is one thing; real life information about people can lead to devastating witch-hunts and intense campaigns of harassment.
Sexualized photos of people taken without their consent is bad. The very fact of taking sexualized photos without consent/knowledge (e.g. upskirt photos) is harassment.
Witch-hunts can be a problem. People violating privacy and harassing people and then avoiding any consequences is a problem too.
So I guess I can see why Reddit bans one, but not the other.
The cynic in me thinks it's because of the general gender of who's affected.
> Sexualized photos of people taken without their consent is bad. The very fact of taking sexualized photos without consent/knowledge (e.g. upskirt photos) is harassment.
A couple of states seemed to have outsourced this (Ohio, most notably) to another site - missingmoney.com. When searching for first and last names it returned likely matches as well, so perhaps they've implemented some fuzzy string matching along the way that will help citizens find what's owed.
Side note: As a result of this article I found >100 bucks owed to family members which will be a great boon to them. Thanks for posting.
My nephew has $0.26 coming to him. I wonder if he'll track down a notary for the form that will charge less. Next question is: drive in the form or mail it? ;)
I had a small amount of money in a bank account that I found in the Australian version; not long after I claimed it, I received a letter from 2 solicitors saying that I had unclaimed money (although they wouldn't say where from) that they could help me retrieve for a fee.
Maybe they could enact a law that allows them to take ownership of unclaimed property after a certain amount of time? It seems to work that way for abandoned storage units, lost property at airports, etc.
California does have escheat[1] laws which deal with unclaimed property and how the state handles situations where no rightful owner comes forward to claim.[2]
There are plenty of businesses out there that find money for people on commission. I just always thought they were some sort of dodge, sounds like there is some merit to it.
When we wrote this software, we tried hard to get a follow on contract to fix this 180 day problem using more automation. But, there was no budget, and the claims processors did not want to lose their jobs. We toured the location where they process the claims. They literally had piles of filing boxes containing the submitted claim forms in a secured room. I forget how many they do per day, but I remember being surprised at the volume. The site does many millions of searches per month...
Wow, that's insane. Spending $50m/year to notify people and process these claims could easily be justified given the sheer size of the assets being held.
"Programmer and database types will notice one problem immediately - no fuzzy string matching."
Yeah, I really wanted to implement that. The problem was we had to use Microsoft SQL Server and no third party database/indexing systems. SQL Server's Full Text Indexing run took too long during the nightly import job on year 2000 commodity hardware. We also had to do all of this within the constraints of training state workers and handing off something they could actually maintain.
Ah, the joys of state contracting.