About the Data

The information is provided “as-is” without any warranties or guarantees of accuracy. Please do not rely on this data set to solve personal legal problems.

Current version: 1.0

Caseload Per Annum

SELECT start_year, judge_name, count(case_number)
from (SELECT DISTINCT 
    cd.case_number, cd.judge_name, cd.status,
    EXTRACT(YEAR FROM MIN(TO_TIMESTAMP(d.filing_date::text, 'MM/DD/YYYY')::date) OVER (PARTITION BY cd.case_number)) AS start_year
FROM case_defendant cd
JOIN docket d ON cd.case_number = d.case_number)
WHERE start_year > 2014 and status like '%CASE CLOSED%'
GROUP BY judge_name, start_year
ORDER BY judge_name, start_year DESC