Data for 200M traffic stop records

The Stanford Open Policing Project just released a dataset for police traffic stops across the country:

Currently, a comprehensive, national repository detailing interactions between police and the public doesn’t exist. That’s why the Stanford Open Policing Project is collecting and standardizing data on vehicle and pedestrian stops from law enforcement departments across the country — and we’re making that information freely available. We’ve already gathered over 200 million records from dozens of state and local police departments across the country.

You can download the data as CSV or RDS, and there are fields for stop date, stop time, location, driver demographics, and reasons for the stop. As you might imagine, the data from various municipalities comes at varying degrees of detail and timespans. I imagine there’s a lot to learn here both from the data and from working with the data.

Tags: , ,

Teaching kept me from SF Giants playoff games; StubHub glitches are keeping me from my money ..

Well, as if not going to the game wasn't bad enough ...

A few weeks ago, I managed to buy some tickets to some San Francisco Giants playoff games (for the League Championship Series and the World Series). Alas, due to teaching activities for Intro Bio at UC Davis, I was unable to go (when I bought them the dates were not yet determined). I gave some to a neighbor (a belated thank you for them allowing construction workers to use their driveway and yard for months when we had a pool built last summer). And then I sold the others on StubHub. Generally I have always loved Stubhub. Great way to get tickets. Had never sold any there before but it was pretty smooth and painless (except for the relatively large commission but that is another story) and the tickets sold fast (I listed them at ticket price).

And then I waited to payment to go to my Paypal account. And waited. And waited. I finally wrote to StubHub
"Just trying to find out why it is taking so long to get payment from something from a few weeks ago"
The response was surprising:
Dear Jonathan,

Thank you for contacting StubHub.

I understand your concern regarding your payment. I'm sorry it has been delayed. We recently experienced a technical error where MLB payments were diverted to 'Credit My Team Account'. We are in the process of correcting these orders and issuing payments to the default payment method in the sellers account. Due to the widespread nature of this issue, it is taking longer than normal to change the payment method, as each one needs to be done manually. Unfortunately at this point, I am unable to give you a timeframe for receiving your PayPal payment. Rest assured we are working as quickly as possible on this issue.



I apologize for the inconvenience, but appreciate your business with StubHub. Please feel free to contact us if you have any further questions.

Sincerely,

Kim
StubHub Customer Service
Weekdays: 5:00AM -- 9:00PM (PST)
Weekends: 6:00AM -- 7:00PM (PST)
customerservice@stubhub.com
www.StubHub.com

Wow.  Glad they are trying to explain what was going on.  But just how hard can it be to correct such an error?

So I waited again.  And waited.  And then I got an email with the subject line "Payments Returned to StubHub - 11/06/2012."   Sounded good.  Until I looked at the email.


That is right.  I got a payment of $0.  How does that even work?  A few days later I did get a notice of an ACTUAL payment for some of the money I am owed.  But some is still missing.  Clearly some sort of major IT / DB malfunctions going on at StubHub.  Anyone else have this problem?