Legal Docket
Matters against their statute dates, filings still in draft, and the heaviest caseloads.
- LGSOLStatute risk · ≤ 60 daysLive
- LGOPNOpen mattersLive
- LGFDHFiling deadline hit rateLive
- LGFEEEstimated fees · openLive
Traced to its query
Open matters still at an early stage whose statute of limitations falls within the next 60 days.
- Formula
COUNT(matter) WHERE stage IN ('Intake','Conflict Check','Engaged','Discovery') AND 0 ≤ statute_of_limitations − today ≤ 60 days — matters = crm_industry_objects(object_id='matters', status ≠ 'Closed').data ∪ open crm_deals.custom_fields.statute_of_limitations- Sources
- crm_industry_objects (matters)crm_deals.custom_fields.statute_of_limitationsGET /api/v1/crm/boards/industry → legal.risk60
- League stat
- Shot clock violations
- Window
- today
- Note
- A matter past the early stages (Litigation, Trial Prep, Settlement) has been filed — its statute is satisfied and it is drawn as filed, not at risk.
Matters (the Cases / Matters object) not closed.
- Formula
COUNT(*) FROM crm_industry_objects WHERE object_id = 'matters' AND data->>'status' ≠ 'Closed'- Sources
- crm_industry_objects (matters)GET /api/v1/crm/boards/industry → legal.openMatters
- League stat
- Games in progress
- Window
- today
Of the filings whose deadline fell in the last 90 days, the share filed on or before the deadline.
- Formula
100 × COUNT(filed_date ≤ filing_deadline) ÷ COUNT(*) FROM crm_industry_objects WHERE object_id = 'documents' AND today − 90 days ≤ filing_deadline < today- Sources
- crm_industry_objects (documents — Filings)GET /api/v1/crm/boards/industry → legal.filings
- League stat
- Free-throw percentage
- Window
- last 90 days
The estimated fees on every open matter, added up.
- Formula
SUM((data->>'estimated_fees')::numeric) FROM crm_industry_objects WHERE object_id = 'matters' AND data->>'status' ≠ 'Closed'- Sources
- crm_industry_objects (matters).data.estimated_feesGET /api/v1/crm/boards/industry → legal.feesOpen
- League stat
- Payroll on the field
- Window
- today