This dataset contains a monthly record of how many cases pending over a year each judge had at the end of the month, as well as the average number of pending cases over one year among judges. The average pending is calculated by group, so the average for non-complex is different than the average among the judges handling complex criminal cases. There is one data point for the last day of each previous month, starting 2019-01-01, and a datapoint for the current number of pending cases over one year.

This dataset contains a monthly record of how many defendants were in jail for over one year, for all Superior Court judges who handle criminal cases. For the current month, there is one data point representative of the number of defendants in jail for over one year as of today. For previous months, the data point is the last day of the month, and shows how many defendants were in jail for over one year on that day.

Aggregated, Filtered, etc in R

Aggregated, filtered, etc in R

This pre-aggregated and reshaped dataset is used to create a stacked bar chart on the Project ORCA summary dashboard

Aggregated, Filtered, etc in R

This is the actual number of defendants in jail under SC number cases. It does not double count duplicates. This is aggregated and filtered in R.

This dataset contains a monthly record of how many defendants are in jail on Superior Court Criminal cases. It counts each defendant in jail once, using the dataset https://sharefulton.fultoncountyga.gov/Government/Superior-Court-Defendants-in-Jail/raqb-js7j. This data contains the current days count, as well as one datapoint from the last day of each previous month, starting 2019-01-01.

This pre-aggregated and reshaped dataset is used to create a stacked bar chart on the Project ORCA summary dashboard

This contains the number of defendants in jail, per judge, per month.