l_case_party

14 rows

✎ View and edit SQL

This data as json, CSV (advanced)

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

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "l_case_party" (
[party] text PRIMARY KEY,
[description] text,
[party_type] text,
    FOREIGN KEY ([party_type]) REFERENCES[l_party_type] ([party_type])
);