r_case: 05-RD-01336
This data as json
| r_case_number | case_type | status | nlrb_office_id | docket_num | inquiry_id | case_name | date_filed | hearing_target_date | election_target_date | employer_on_petition | union_involved_on_petition | intervenor_on_petition | self_certification | post_elect_self_cert | naics_code | num_employees_requested | description_requested |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 05-RD-01336 | Decertification (removal of rep.) RD | Closed Close | Region 05, Baltimore, Maryland 05 | 1336 | Dassault Falcon Jet Wilmington Corp. | 2004-03-26T00:00:00 | 2004-04-09T00:00:00 | 2004-05-07T00:00:00 | Dassault Falcon Jet Wilmington Corp. | (UAW Local 1542) The International Union, United Automobile, Aerospace and Agricultural | N | N | Other Support Activities for Air Transportation 488190 | 185 | Included Flight support, Maintenance, Aircraft Services Maintenance and Modifications including stock employees, Inspectors, Parts expeditors and Leads person and Crew leaders. Excluded All other employees including Office clerical, Professional, Sales marketing, Guards and supervisors |
Links from other tables
- 1 row from r_case_number in r_bargaining_unit
- 2 rows from r_case_number in r_closed_case
- 2 rows from r_case_number in r_impact_category
- 0 rows from r_case_number in r_part_variant
- 6 rows from r_case_number in r_participant
- 0 rows from r_case_number in r_post_elect_board_act
- 0 rows from r_case_number in r_pre_elect_board_act
- 1 row from r_case_number in r_reopened_case
- 3 rows from r_case_number in r_transfer_history
- 1 row from new_case_number in r_transfer_history
- 3 rows from r_case_number in r_transfer_history