NLRB cases, 1984-2000
Data source: NLRB files archived with the National Archive
Tables
c_consolid
case_number, consolidation, consol_id, consolidation_type, consolidation_code, consolidation_stage, date_severed, severance_id, severance_type, severance_code, severance_stage, key_consol_case_number, sub_consol_case_number
19,468 rows
c_formal1
case_number, cf1_date, date_last_action, consol_type, consol_code, update_control, code_date_complt_iss, date_complaint_issued, allegations, number_discrim, complaint_control, code_date_ro_disp, date_ro_disp, ro_disp_control, date_hearing_opened, code_date_hearing_closed, date_hearing_closed, hearing_control, code_date_disp_issed_recd, date_disp_issued_recd, type_disposition, allegations_uphld, allegations_dismd, discrim_upheld, discrim_dismissed, back_pay_control, admin_law_judge_disp, board_decision_control, card_control, number_discrim_reinst_ca, number_rec_back_pay_uni_emp_cb, number_rec_back_pay_only_ca, number_discrim_restor_cb, number_discrim_preferd, remedy, code_date_hearing_opened, chips_amended_code, consol_server, case_state_action, complaint_calendar_year, complaint_fical_year, consol_case_number, sub_consol_case_number
75,509 rows
c_formal2
case_number, cf2_date, date_last_action, consolidation_type, consolidation_code, update_control, code_date_transfer_board, date_transfer_board, control_type, date_decision_issued, type_decision, disp_allegations, allegations_uphld, allegations_dismd, number_discrim_reinstated_ca, number_receive_back_pay_uni_emp_cb, number_receive_back_pay_only_ca, number_discrim_restored_cb, number_discrim_dismissed, number_discrim_preferred, remedy, board_members, board_disposition_allegations, close_control, card_control, code_date_dec_issued, volume_number, issue_number, party_filing_excpt, board_members_5
13,812 rows
c_formal3
case_number, cf3_date, date_last_action, consol_type, consol_code, update_control, date_ref_app_ct, type_ref, date_pet_answ_filed, date_ref_pet_answ, date_ca_opinion, date_brief_filed, type_disposition, ca_no, date_ca_decree, type_decree, control_case, card_control, code_date_brief_filed
6,603 rows
c_formal4
case_number, cf4_date, date_last_action, stage_last_action, consolidation_type, consolidation_code, upate_control, date_referred_scb, date_recom_writ_cert, type_recom, date_pret_writ_cert_filed, party_filing, date_sc_action, sc_ruling, date_supreme_court_argue, date_supreme_court_dec, type_supreme_court_dec, date_back_pay_specs, stage_back_pay_specs, date_hearing_closed, date_administrative_law_judge_dec_issued, date_board_suppl_decision, type_board_suppl_decision, date_ref_acb, date_suppl_ca_decree, card_control, code_date_hearing_closed, code_date_administrative_law_judges_decision_issued, code_date_board_suppl_decision
2,288 rows
c_master
case_number, region, ctype, docket, suffix, file_date, close_date, date_last_action, county, state, industry, complainant, joint_complainant, respondent, joint_respondent, number_employed, allegations, number_discrim, situation, number_of_charges, type_charge, number_allegations, status, formal_action_control, machine_control, proceeding_control, fact_advice, type_refusal, fact_appeal, code_date_ro_disp, date_ro_disp, method_disposition, collyer_deferral, date_collyer_began, date_collyer_end, code_date_closed, stage_close, method_close, reason_remedy_close, status_barg_close, solic_stages_investig, contact_witness, date_re_advice_received, date_action_on_advice, date_appeal_received, date_action_on_appeal, hearing_held_code, decision_made_code, chips_close_flag, chips_close_date, related_case, chips_amended_code, formal_setl, filed_calendar_year, closed_calendar_year, filed_fiscal_year, closed_fiscal_year, key_case_number, sub_key_case_number, transferred_case_number
516,355 rows
c_trailer
case_number, trailer_date, date_last_action, allegations_adjusted, settlement, approval_requested, number_reinstated, number_w_reinstated, number_d_reinstated, number_p_list, number_restored, number_withdrawn_employment, number_rcu_employed, number_allegations, number_made_whole, number_receiving_back_pay, total_amt, amt_pd_co, amt_pd_un, back_pay_control, f_installment, number_rcu_dues, total_comp, total_pd_co, total_pd_un, dues_control, remedy, date_end_picket, date_end_work_stop, number_employs_picket, number_employes_stop, number_to_be_reinst, related_combined_code, related_key_case_number
183,216 rows
l_county
alpha_state_code, numeric_state_code, county_number, county_name, resident_code, region, district, resident_office, Unnamed: 8
3,270 rows
r_consolid
case_number, consolidation_date, consol_id, key_consol_case_reg, key_consol_case_type, key_consol_case_docket, key_consol_case_suffix, sub_consol_case_reg, sub_consol_case_type, sub_consol_case_docket, sub_consol_case_suffix, consolidation_type, consolidation_code, consolidation_stage, date_severed, severance_id, severance_type, severance_code, severance_stage
2,345 rows
r_formal1
case_number, rf1_date, date_last_action, consol_code, code_date_hearing_close, date_hearing_close, control, update_control, date_dec_issued, unit, type_dec, type_specl_elect, date_waiver, date_req_review, party_filing, date_ruling_reg, ruling_control, date_board_dec_req, board_dec, type_board_dec, board_unit, volume_number, issue_number, board_members_5, chips_amended_code
16,572 rows
r_formal2
case_number, suffix, rf2_date, date_last_action, transaction, action_777, consol_code, date_election_held, date_obj_chall_filed, number_obj_filed, number_chall, date_hearing_ordered, basis_election, party_filing_ob, hearing_code, hearing_ordered_by, date_rps_no_hearing_held, update_control, date_hearing_closed, date_hearing_opened, date_rpt_on_obj_chall, first_election_rpt, rpt_control, date_rd_suppl_dec, ruling_on_obj, type_decision, decision_control, another_election, previously_reported, date_certification, stage, method, rd_of_bd_dec, date_review_waivered, date_exception_filed, exception_code, date_ruling_on_exc, ruling_on_exc_code, date_reg_for_review, party_filing_req, date_ruling_on_req, ruling_on_req_code, date_board_dec, type_board_dec, number_obj_sustained, number_obj_overuled, number_obj_withdrawn, number_chall_sustained, number_chall_overuled, number_chall_withdrawn, date_obj_chall_resolved, ruling_on_obj_r, ruling_on_obj_r.1, date_bd_dec_on_rev, bd_dec_on_rev
11,445 rows
r_master
case_number, region, ctype, docket, file_date, close_date, date_last_action, industry, state, county, petitioner_type, petitioner, joint_petitioner, local_number, recogn_union_type, recogn_union, joint_recogn_union, unit, number_emp, proposed_no_emp, picket_8b7c, status, machine_control, proceeding_control, date_appeal, ruling_code, consol_code, date_notice_hearing_issued, date_hearing_opened, date_hearing_closed, hearing_control, code_date_closed, stage_closed, method_closed, reason_close, hearing_held_code, dec_made_code, date_agree_approv, date_appea_recd, date_action_on_appeal, chips_amended_code, date_hearing2_closed_108, date_hearing2_open_108, blocking_case_code, consol_sever, case_stage_action, consol_type, chips_close_flag, chips_close_date, filed_calendar_year, filed_fiscal_year, closed_calendar_year, closed_fiscal_year, blocking_case_number, consol_case_number, sub_consol_case_number, transfer_case_number
111,291 rows
rc_elect
case_number, suffix, election_date, unit, description_election, expedited, date_election_held, type_election, no_elig, join_union_won, union_won_votes, union_won_intl_type, union_won_intl, joint_union_lost_1, union_lost_votes_1, union_lost_intl_1_type, union_lost_intl_1, joint_union_lost_2, union_lost_votes_2, union_lost_intl_2_type, union_lost_intl_2, joint_union_lost_3, union_lost_votes_3, union_lost_intl_3_type, union_lost_intl_3, joint_union_lost_4, union_lost_votes_4, union_lost_intl_4_type, union_lost_intl_4, votes_against_union, challenges, void_votes, elect_vote_control, control, conclusive, challenges_determinative, patric_union, incumb_union, mail_ballot, union_control, cross_petition, runoff_necessary, cross_pet_case_number, rerun_runoff_number, impounded, date_elect_certified, stage, method
75,894 rows
ud_elect
case_number, suffix, election_date, cunion, description_election, expedited, unit, date_election_held, type_election, no_elig, v_votes, for_prop, agn_prop, chall, void, cout, control, date_election_certified, stage, method, mail_ballot, cross_pet_region, cross_pet_type, cross_pet_docket, cross_pet_suffix, rerun_runoff_number, impounded
1,427 rows
... and 2 hidden tables
Download SQLite DB: chips.db 224.3 MB