kassab_analytics

Data license: Public court records

Tables

appellate_issues

appellate_issue_id, filing_id, point_of_error, standard_of_review

24 rows

case_metadata

key, value

16 rows

chain_steps

chain_id, step_number, filing_id, date, description, party

68 rows

citations

citation_id, filing_id, case_name, citation, court, year, proposition, cited_by

999 rows

defenses_raised

defense_id, filing_id, defense

397 rows

evidence_referenced

evidence_id, filing_id, evidence

769 rows

filing_sections

section_id, filing_id, heading, summary

553 rows

filings

filing_id, date, doc_type, party, description, doc_type_detail, procedural_posture, chain, outcome, phase, filename, relief_requested, full_text

68 rows

issues

issue_id, name, cluster, relevance, summary, kassab_position, pohl_position, result, appellate_status, authorities

10 rows

key_assertions

assertion_id, filing_id, assertion

1,237 rows

key_facts

fact_id, filing_id, fact

899 rows

legal_theories

theory_id, filing_id, theory, party, role, basis

509 rows

milestones

milestone_id, label, date

9 rows

motion_chains

chain_id, name, outcome, outcome_class, filing_count, duration

13 rows

orders

order_id, date, title, court, filename, full_text

16 rows

rulings

ruling_id, filing_id, outcome, reasoning, standard_applied

6 rows

sqlite_sequence

name, seq

12 rows

statutes

statute_id, filing_id, statute, description, cited_by

397 rows

... and 30 hidden tables