Oh man, is this relevant to my interests. An organization I founded is currently in a state-level Freedom of Information law fight -- using the Missouri Sunshine Law -- against the Missouri Department of Health and Senior Services, asking for two database dumps as CSV files. The databases have millions of records covering decades of data, but only about four columns, so this should take a couple of hours to export, tops. Of course, we're willing to pay for the USB flash drive to put the files on, and cover any unusual labor costs to do the export.
The good news is that the Department has agreed that we should have the legal right to this data.
The bad news is that the Missouri Dept of Health is claiming with a straight face that they can only retrieve one day's worth of data at a time from their mainframe, and must re-run the work job for each and every subsequent day's data. They claim that it is impossible for their software to select for a date range.
And therefore, they have quoted my organization a price of about one million dollars and 2.6 years to select and deliver our data.
Shot:
https://mobile.twitter.com/ReclaimTheRecs/status/74644736092...
Chaser:
https://mobile.twitter.com/ReclaimTheRecs/status/75116107051...
(Don't worry, we have a good Sunshine Law lawyer and he is as outraged/amused at this bullshit as we are.)
The good news is that the Department has agreed that we should have the legal right to this data.
The bad news is that the Missouri Dept of Health is claiming with a straight face that they can only retrieve one day's worth of data at a time from their mainframe, and must re-run the work job for each and every subsequent day's data. They claim that it is impossible for their software to select for a date range.
And therefore, they have quoted my organization a price of about one million dollars and 2.6 years to select and deliver our data.
Shot: https://mobile.twitter.com/ReclaimTheRecs/status/74644736092...
Chaser: https://mobile.twitter.com/ReclaimTheRecs/status/75116107051...
(Don't worry, we have a good Sunshine Law lawyer and he is as outraged/amused at this bullshit as we are.)