Vertical Stack Query

Get all rules that apply to a specific filing in a specific district — traverses federal → circuit → district → judge layers

Custom SQL query (hide) 

SELECT hierarchy_level, COALESCE(district_id, '—') as district, rule_number, title, substr(text, 1, 500) as text_preview, frcp_reference, topic FROM provisions WHERE (hierarchy_level = 'federal' AND frcp_reference = :frcp_rule) OR (district_id = :district_id AND topic = :topic) ORDER BY CASE hierarchy_level WHEN 'federal' THEN 1 WHEN 'circuit' THEN 2 WHEN 'district' THEN 3 WHEN 'judge' THEN 4 END

Query parameters

0 results