search

WPRDC / wprdc-etl

MIT License
8 stars 3 forks source link

Fatal OD Mock Data Death Date, Death Time #13

Closed bsmithgall closed 8 years ago

bsmithgall commented 8 years ago 
Death Date,Death Time,Manner of Death,Age,Sex,Race,Case Dispo,Combined OD1,Combined OD2,Combined OD3,Combined OD4,Combined OD5,Combined OD6,Combined OD7,Incident Zip,Decedent Zip,Case Year
2014-02-09T00:00:00,2015-12-04T12:33:00,ACCIDENT,54,Male,White,MO,Heroin,,,,,,,15212,15212,2014
2014-03-29T00:00:00,2015-12-04T01:03:00,ACCIDENT,47,Male,White,MO,Benzodiazepines,Heroin,,,,,,15129,15129,2014
2014-06-07T00:00:00,2015-12-04T13:15:00,ACCIDENT,26,Male,White,MO,Clonazepam,Cocaine,Heroin,Methadone,,,,15215,15215,2014
2014-08-16T00:00:00,2015-12-04T16:19:00,Accidents,54,Male,White,MO,Alcohol,Cocaine,,,,,,15204,15204,2014
2014-09-07T00:00:00,2015-12-04T06:19:00,ACCIDENT,85,Female,White,MO,Dextromethorphan,,,,,,,15237,15237,2014
2014-10-25T00:00:00,2015-12-04T00:36:00,ACCIDENT,51,Male,White,MO,Fentanyl,Heroin,Nordiazepam,Oxycodone,,,,15216,15216,2014
2014-11-14T00:00:00,2015-12-04T10:58:00,Accidents,31,Male,White,MO,Fentanyl,Heroin,,,,,,15102,,2014

is the current mock file, but in the old pipeline code it looks like the death date/death time are in a different format. Are we sure this is accurate?

saylorsd commented 8 years ago

No. That's my bad. I took what I had thinking it was an original, but it must have been one I downloaded from the data center. The county removed everything from their FTP that isn't automatically updated so I'll have to ask for it. It should be good to go tomorrow morning sometime.

bsmithgall commented 8 years ago

:+1: once you patch it please close the ticket. I'm going to also work on a slight refactor of the CSVExtractor to take an additional separator argument to handle it. If you get a chance, could you also look at #4 tomorrow?

saylorsd commented 8 years ago

Sounds good. I took a quick look and started tracing the code to get a better idea but got caught up with some other stuff. I should have more time starting tomorrow to focus on this project.