Calculate the number of open cases by lawyer

[newswim]

This is not data that is being tracked anywhere at the state level.

[tpadmanabhan]

Validate if needed with Nick. Then determine priority, assign

[tpadmanabhan]

Per @nicolassaw determine if assigned attorney is doing a good job. Recommends collecting data after parsing and doing a visualization @newswim @lianilychee

[nicolassaw]

Blocked by open-austin/indigent-defense-stats#83 . We have to better parse the data in that step before we can connect defense attorneys across multiple cases.

[nicolassaw]

Data may have to be placed into a separate table before pushed to the visualization. Or it could be left as is in the original table and the visualization is able to fold the data along defense attorney (and run sum functions on the number of cases) rather than cases.

[nicolassaw]

No longer blocked by open-austin/indigent-defense-stats#83 .

[nicolassaw]

I think that ultimately this ticket is for the creation of a visualization that displays the number of cases per attorney.

But first we must consider implications for displaying attorney data and we have a few final options: 1. Don't display caseload data at all, 2. Show anonymized caseload data, 3. Show attorney caseload data with defense attorney name.

If we anonymize, we must build the infrastructure (probably a database or table is CosmosDB with attorney names and assigned ids that is pinged for each attorney when anonymization takes place in cleaning step).

If we display, we should put together disclaimer related to accuracy of data.