search

ipno-llead / processing

Processing repo for the Innocence Project New Orleans' Louisiana Law Enforcement Accountability Database
7 stars 5 forks source link

Officer with more than 1 left date in a calendar month #103

Open pckhoi opened 3 years ago

pckhoi commented 3 years ago

Moving issue from Asana here for easy tracking. I found these 2 rows from New Orleans SO and @ayyubibrahimi confirmed the same events were found in charges data:

                                 event_uid          kind  year  month   day time    raw_date                               uid                     complaint_uid         agency left_reason
    4856  21cdac6653e9bf8982a1a6054e0a415c  officer_left  2019    9.0  27.0  NaN  09/27/2019  171f4a5efc24b516bbeb22df0b375f77  07bb028ce69daf059d1430a8fa319dc5 New Orleans SO termination
    4917  f3825c85b145f3c6ae54a0135ae94379  officer_left  2019    9.0  30.0  NaN  09/30/2019  171f4a5efc24b516bbeb22df0b375f77  3b69c0f0938ae33433834721e579f59f New Orleans SO termination

I'm turning a blind eye to this for now but we should decide on how to resolve this soon because it means this might results in bugs in the LLEAD website.

pckhoi commented 3 years ago

@rajivsinclair @lsukaristone

rajivsinclair commented 2 years ago

Thanks for flagging this. Can we do anything to validate the raw source data for this? /cc @ayyubibrahimi

pckhoi commented 2 years ago

@rajivsinclair since these appear consistently in multiple data sources, chances are they are not typos. Until Ayyub figure out the underlying reason, I think you should probably let the web team know to handle this possibility.

ayyubibrahimi commented 2 years ago

Still working on confirmation.

My inclination is still the same as before though: because these terminations have different internal tracking numbers, different investigation_start and investigation_end dates, it seems that he really was terminated twice. For what purpose, I have no idea. To make a statement? Good measure?

Even if that isn't the case now, how should we handle that in the future? As I imagine that we may come across this peculiar act