c_case: 34
This data as json
| rowid | c_case_number | status | nlrb_office_id | case_type | docket_num | case_suffix_num | case_name | date_filed | date_closed | disposition_due | disposition_accomplished | charged_party_on_charge | charging_party_on_charge | inquiry_id | employer_involved_on_charge | io_assist | naics_code | num_8a3_discriminatees | num_8b2_discriminatees | num_employees | postal | investigation_complete | disposition_date | dispute_loc_city | dispute_loc_state | dispute_loc_county | dispute_loc_zip |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 34 | 01-CA-24921-001 | Close | 1 | CA | 24921 | 1 | Brown & Sharpe Manufacturing Company | 1987-08-28T00:00:00 | 2001-08-16T00:00:00 | 1987-11-13T00:00:00 | Y | Brown & Sharpe Manufacturing Company | Machinists Local Lodges 883, 1088 and 1142 District Lodge No. 64 | N | 339999 | 400 | N | 1987-09-24T00:00:00 | 1988-01-29T00:00:00 | North Kingstown | RI | 9 | 02852 |