Create lookup table for charge eligibility

[wdcrumpler-kcdd]

Goal: Create a list of crimes by statute number that can be used by the app to look up the statute indicated by the user, compare with other information (like time since they completed their sentence) and return an assessment of whether the person is eligible for expungement.

Key Resources:

• Google Sheet that contains an initial coding of the eligibility requirements for different crime types (currently simplified and incorrect due to use as test form in jotform prototype)
• Full list (Download) of KS criminal statutes

Tasks:

• Determine how to allow the client to select their charge with specificity (can include multiple approaches that can be A/B tested, like entering statute number from case info or nested dropdowns where a second appears to ask you to select the specific type based on the first)
• Determine how to account for the fact that in previous years, the eligibility of certain crimes may have changed. Simple option: if not eligible under current statutes, tell them to consult with an attorney. Complicated option: get old charge codes and eligibility details and build in a lookup system that triggers depending on the date of the crime. [Note that @wdcrumpler-kcdd received the 2011 Kansas Sentencing Commission Desk Reference Manual, which should include charge descriptions from before the last revision to KS' expungement statute]
• In spreadsheet, build a function that evaluates each crime's information to evaluate how many years must have elapsed before eligibility
• Determine, based on the output of the algorithm, whether it is necessary to ask the user whether they were convicted of attempt/solicitation/conspiracy

[wdcrumpler-kcdd]

Current Status

• Based on the KS Expungement Statute (K.S.A. 21-6614) and guidance from KLS, we have an initial coding of the types of crimes that are expungeable and what the conditions on expungeability are.
• We have found a full list (Download) of KS criminal statutes

To-Do

• Use the two spreadsheets linked above to create a combined spreadsheet where each KS statute is listed along with its eligibility conditions

[HowSimple]

I added a lookup table in the "Lookup Charge Eligibility" page of this existing spreadsheet: https://docs.google.com/spreadsheets/d/1GUCQHuSA4-aFXSOOXaxK436yqXH3zsCT4wOb5_MPHLw/edit#gid=2023437888
It uses the "Abbreviated Jotform Charge List" to look up each charge, and then shows when that charge is eligible to be expunged based on the date it was completed, and the type of charge (attempt, conspiracy, etc). Even though the years seem similar for each type of charge, it does still
Let me know if there is more info necessary to be entered here.
I'll also work on a basic API for the prototype application to be able to look up charge eligibility like this.