Add missing California courts: 55 Superior Courts + administrative tribunals

[micahstubbs]

Summary

Courts-DB is missing significant California court coverage:

Missing Courts

Court Type	Reality	In Courts-DB	Gap
Superior Courts	58 (one per county)	3	55 missing
State Bar Court	1	0	1
Workers' Comp Appeals Board (WCAB)	1	0	1
Unemployment Insurance Appeals Board (CUIAB)	1	0	1
Public Employment Relations Board (PERB)	1	0	1
Public Utilities Commission (CPUC)	1	0	1
Agricultural Labor Relations Board (ALRB)	1	0	1
Office of Administrative Hearings (OAH)	1	0	1

Details

Superior Courts: California has 58 counties, each with its own Superior Court. Currently courts-db only has:

• calsuperct - generic California Superior Court
• calsuppctla - Los Angeles Superior Court
• calsuppctsf - San Francisco Superior Court

Administrative Tribunals: These quasi-judicial bodies issue published decisions and handle significant caseloads:

• CUIAB alone handles 189K+ appeals/year with 900+ employees
• OAH provides ALJs for 1,500+ state/local agencies
• CPUC has 70+ ALJs

Sources

• California Courts website
• Judiciary of California - Wikipedia
• State Bar Court
• WCAB
• CUIAB
• PERB
• CPUC ALJ Division
• OAH

Suggested Approach

1. Add 58 California Superior Courts (one per county)
2. Add State Bar Court
3. Consider adding major administrative tribunals that publish decisions

Would be happy to contribute these additions via PR.

[mlissner]

@flooie, can you please take on this and it's various PRs?

[micahstubbs]

Thanks for taking a look. I know its a bit of effort to review.

[flooie]

No, no thank you for doing it. This is the first step in getting these integrated into the system.

We will need a corresponding reporters-db addition to parse the citations, as I suspect we don't have all of the formats.