l_case_party

14 rows

✎ View and edit SQL

Suggested facets: party_type

party ▼ description party_type
CB Counsel for the Board NLRB Board for C Cases CBD
CGP Charging Party C Case Party C
CHP Charged Party C Case Party C
EMP Employer R Case Party R
EMPL Employer Involved C Case Party C
GC Counsel for the General Counsel NLRB General Counsel GC
INT Intervenor R Case Party R
NLRB Board NLRB Board for R Cases BD
OTHER Other Other OTHER
PC Party To Contract C Case Party C
PET Petitioner R Case Party R
PI Party-In-Interest C Case Party C
REGN Region Region REGN
UNIN Union Involved R Case Party R

Download this data

CSV · JSON

Table schema 
CREATE TABLE l_case_party(party VARCHAR, description VARCHAR, party_type VARCHAR, PRIMARY KEY(party), FOREIGN KEY (party_type) REFERENCES l_party_type(party_type));