NLRB cases, 1999-2011
Data source: NLRB files posted to data.gov, archived on archive.org
Tables
c_10k
c_case_number, action_sequence, recurrence, disposition_method, disposition_date, disposition_timing, board_work_awarded, board_deter_date
172 rows
c_advice
c_case_number, action_sequence, recurrence, advice_submission, advice_rcvd_submission, advice_scope, advice_memo_date, advice_deter_rcvd_reg, file_received_advice
6,770 rows
c_alj_decision
c_case_number, action_sequence, recurrence, brief_due_date, eot_request_rcvd_alj, eot_brief_party, eot_deter_date, eot_determination, alj_date_filed, alj_brief_rcvd_region, alj_brief_party, alj_brief_type, determination_date, determination
20,118 rows
c_alj_motion
c_case_number, action_sequence, recurrence, date_filed, motion_type, party_filing, determination_date, motion_determination
3,135 rows
c_alleg_action
c_case_number, allegation_sequence, sequence, action_result, action_date, action_type
1,551,184 rows
c_appeal
c_case_number, action_sequence, recurrence, appeal_expiration_date, eot_date_filed, eot_party, eot_date_determination, eot_determination, appeal_date_filed, appeal_action, appeal_rcvd_in_region, appeal_file_oa, appeal_rcvd_oa, appeal_file_rtrn_reg, appeal_file_rcvd_reg, appeal_date_determination, appeal_determination, appeal_party
143,760 rows
c_bankruptcy
c_case_number, action_sequence, recurrence, bank_pet_filed, bank_pet_party, bank_pet_court, bank_pet_case_num, bank_pet_type, poc_bar_date, poc_category, poc_date, dis_bank_date, dis_bank_act, chapter_11_approved, amount_claimed, amount_received
1,227 rows
c_board_decision
c_case_number, action_sequence, recurrence, transfer_order_date, exception_due_date, exceptions_eot_date_filed, exceptions_eot_party_filing, exceptions_eot_deter_date, exceptions_eot_determination, oral_arg_req, oral_argument_req_party, oral_arg_order_date, oral_arg_sch_date, oral_arg_date, exceptions_date_filed, decision_date, date_received_region, determination, citation, request_date, request_party, request_deter_date, request_determination, motion_eot_date_filed, motion_eot_party_filing, motion_eot_deter_date, motion_eot_determination
17,317 rows
c_board_other_motions
c_case_number, action_sequence, recurrence, other_motion_date, other_motion_party, other_motion_type, other_motion_deter_date, other_motion_deter
2,104 rows
c_case
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
329,513 rows
c_case_case_group
c_case_group_id, c_case_number, sequence, lead, date_case_added, date_case_removed
177,565 rows
c_closing
c_case_number, action_sequence, date_closed, close_method, close_timing, date_file_sent_archives, date_file_to_records, date_file_destroyed, preclosing_letter, notice_of_closing_date
326,944 rows
c_collection_activities
c_case_number, action_sequence, recurrence, liens_filed_date, liens_filed_court, liens_filed_amount, liens_filed_citation, escrow_established, escrow_location, escrow_terms, garnishment_date, garnishment_party, garnishment_court, garnishment_citation
184 rows
c_complaint
c_case_number, action_sequence, recurrence, issued, contain_noh, answer_to_complaint, date_of_withdrawal_order
43,079 rows
c_compliance_goals
c_case_number, action_sequence, recurrence, letter_date, letter_type, posting_goal, not_post_party, posting_type, notices_post_dates, post_expires, reinstatement_goal, reinstatement_offered, closing_goal, backpay_received
39,814 rows
c_compliance_spec
c_case_number, action_sequence, recurrence, comp_spec_issued, backpay_estimate_number, backpay_estimate_amount, date_spec_answer_received, date_spec_withdrawn, date_sw_approved, sw_action, scope, sw_participation
2,098 rows
c_contempt
c_case_number, action_sequence, recurrence, petition_date, brief_rcvd_date, brief_rcvd_party, brief_pleading, oral_arg_sch_date, oral_arg_date, court_deter_date, court_action_type, court_action_action, som_date_deter, som_determination, som_filed, request_date, request_party, request_deter_date, request_determination, date_received_region, citation, court, eot_date_filed, eot_party, eot_determination_date, eot_determination, date_settlement_approved, settlement_type
1,305 rows
c_deferral
c_case_number, action_sequence, recurrence, request_party, request_received, scope, date_deferral_issued, deferral_type, date_deferral_checked, date_deferral_extended, willingness_date, willingness_type, date_processing_resumed
75,639 rows
c_discovery
c_case_number, action_sequence, recurrence, district_court_date, district_court_court, district_court_citation, date_subpoena_issued, date_subpoena_answered, discovery_initiated, party, accordance_with, interrogatories, court_action, court_determination
28 rows
c_dismissal
c_case_number, action_sequence, recurrence, revoked_reason, date_issued, scope, revoked_date, adjusted
109,632 rows
c_enforcement
c_case_number, action_sequence, recurrence, petition_date, petition_party, petition_court, brief_rcvd_date, brief_rcvd_party, brief_pleading, oral_arg_sch_date, oral_arg_date, court_deter_date, court_action_type, court_action_action, case_citation, som_date, som_determination, request_date, request_party, request_deter_date, request_determination, date_received_region, som_date_deter, eot_date_filed, eot_party, eot_determination_date, eot_determination, date_settlement_approved, settlement_type
9,649 rows
c_hearing
c_case_number, hearing_type, action_sequence, recurrence, scheduled_hearing_date, hearing_opened, hearing_closed, record_form, date_notice_issued, date_rescheduled_issued, p_p_rcvd_region, p_p_deter_source, p_p_determination, p_p_party, p_p_deter_date, hearing_days_on_record, length_of_transcript, hearing_time, hearing_city, hearing_state, hearing_address
69,580 rows
c_impact_category
c_case_number, history_sequence, determination_due_date, disposition_due_date, investigation, investigation_date, litigation, litigation_date, compliance, compliance_date
457,996 rows
c_inj_10j_appeal
c_case_number, action_sequence, recurrence, appeal_date, appeal_party, appeal_court, appellate_date, appellate_decision, appellage_citation
16,237 rows
c_injunction_10j
c_case_number, action_sequence, recurrence, advice_submit_board, board_determination, board_deter_date, board_rcvd_region, reason_cease, cease_action_date, pet_10j_court, pet_10j_filed_date, pet_10j_court_case_name, pet_10j_withdrawn_date, date_answer_resp_rcvd, brief_10j_party, brief_10j_type, brief_10j_date, brief_10j_rcvd_region, motion_filed, motion_filing_party, motion_type, motion_determination, motion_deter_date, discovery_request_date, discovery_request_party, discovery_type, discovery_co_date, hearing_ordered, hearing_scheduled, hearing_opened, hearing_closed, hearing_days, hearing_evidence_type, co_judgement_type, co_order_type, co_judgement_date, co_court, final_disposition_10j, final_dispostion_filed, tro_granted, date_charged_party_notified
16,237 rows
c_injunction_10l
c_case_number, action_sequence, recurrence, brief_10l_type, brief_10l_party, brief_10l_date, brief_10l_rcvd_region, motion_type, motion_filed, motion_filing_party, motion_determination, motion_deter_date, discovery_request_date, discovery_request_party, discovery_type, discovery_co_date, pet_10l_filed_date, pet_10l_court, pet_court_case_name, pet_10l_withdrawn, answer_10l_rcvd_region, hearing_10l_ordered, hearing_10l_scheduled, hearing_10l_opened, hearing_10l_closed, hearing_days, hearing_evidence_type, co_determination_type, co_order_type, co_deter_date, co_court_issuing, appeal_date, appeal_party, appeal_court, appellate_date, appellate_decision, appellate_citation, final_disposition_10l, final_disposition_filed, cease_action_date, reason_cease, tro_granted
308 rows
c_motion_summ_judge
c_case_number, action_sequence, recurrence, rcvd_board_date, motion_party, motion_basis, notice_show_cause_date, notice_reply_due_date, notice_eot_request_rcvd, notice_eot_party, notice_eot_date_deter, notice_eot_determination, notice_reply_recv_board, notice_reply_party
2,193 rows
c_motions_affect_cmp
c_case_number, action_sequence, motion_date, motion_forum, motion_type, title, motion_party, determination_date, motion_determination
778 rows
c_participant
c_case_number, participant_id, participant_group, participant_role, name_for_correspondence, name_prefix, first_name, mid_name, last_name, name_suffix, street_address_1, street_address_2, city, state, zip, phone_num, phone_ext, cell_phone, fax_num, e_mail_address, formal_name, parent_name, exclusive_service, afl_cio, incumbent_union, labor_org_code, local_dist_id, party_scope, parti_type
1,297,111 rows
c_regional_deter
action_sequence, recurrence, organizational_campaign, strike_in_same_unit
326,198 rows
c_settlement
c_case_number, action_sequence, recurrence, proposal_letter_sent_date, proposed_approval__date, inf_settle_approved, inf_settle_participation, inf_settle_scope, inf_settle_revoked, fs_settlement_sent_ops, fs_submitted_to, formal_scope, fs_board_determination, fs_determination_date, determination_rcvd_reg, formal_participation
29,253 rows
c_sup_aljd_cmp
c_case_number, action_sequence, recurrence, brief_due_date, eot_request_rcvd_alj, eot_brief_party, eot_brief_deter_date, eot_brief_determination, alj_brief_rcvd_region, alj_brief_party, eot_brief_type, alj_brief_rcvd_alj, alj_date_filed, aljd_comp_date, aljd_comp_determination
726 rows
c_sup_board_dec_cmp
c_case_number, action_sequence, recurrence, transfer_order_date, exception_due, exceptions_eot_date_filed, exceptions_eot_party_filing, exceptions_eot_deter_date, exceptions_eot_determination, oral_arg_req, oral_argument_req_party, oral_arg_order_date, oral_arg_sch_date, oral_arg_date, exception_filed, exception_party, bd_issued, determination, date_received_region, bd_citation, bd_reinstated_num, bd_pref_hire_num, bd_made_whole_num, bd_total_backpay, bd_fees_awarded, bd_fines_awarded, bd_contributions_awarded, bd_other_awarded, request_date, request_party, request_deter_date, request_determination, motion_eot_date_filed, motion_eot_party_filing, motion_eot_deter_date, motion_eot_determination
1,127 rows
c_supreme_court
c_case_number, action_sequence, supct_reinstated_num, supct_prf_hire_num, supct_made_whole_num, supct_total_backpay, supct_fees_awarded, supct_fines_awarded, supct_cont_awarded, supct_other_awarded, gc_cert_rec_date, petition_cert_date, petition_cert_party, oral_argument_scheduled, oral_argument_held, decision_date, decision, citation, certiorari_board_date_deter, date_received_region, date_pet_determination, pet_determination
497 rows
c_transfer_history
c_case_number, history_date, sequence, date_data_received, request_date, reason_transfer, transfer_type, transfer_order_date, new_case_number, former_case_number, sent_date, received_date
19,325 rows
cl_c_closed_case_report
c_case_number, action_sequence, washington_approval, compliance_type, closing_type, complaint, enforcement_recommend, contempt_recommended_type, emprein_num_discrim, emprein_num_accept, emprein_num_waiving, emprein_num_decline, emprein_num_pref_list, unionres_num_hall_rights, unionres_obj_with, unionres_hired, back_number_made_whole, back_total_num_rcv, back_total_amount_due, back_total_employer, back_total_union, fees_num_individuals, fees_total_due, fees_total_employers, fees_total_union, other_post_notice, other_company_post, other_union_post, other_withdraw_assistance, other_withdraw_notice, other_disestablish, other_disestablish_notice, other_end_picketing, other_end_picketing_date, other_end_picketing_return, other_end_stoppage, other_end_stoppage_date, other_end_stoppage_return, other_bargain, other_bargain_status, backpay_control_code, back_installment_flag, court_costs, court_costs_amount, court_costs_collected, check_forwarded_finance, other_remedies, cmp_cp_position, agent, regional_attorney, regional_director
126,619 rows
cl_c_withdrawal
c_case_number, action_sequence, recurrence, disposition_date, disposition, scope, conditional, solicited, adjusted, revoked_date, revoked_reason
198,686 rows
l_blue_book_codes
blue_book_code, bb_section, bb_heading, bb_chapter, bb_division, description
24,546 rows
l_c_action_fields
action_table_code, action_field_code, tbl_name, field_name, description, chronology_flag
264 rows
l_c_case_group_type
case_group_type, prohibit_manual_maint, description, case_group_sort_order
6 rows
l_naics_code
naics_code, naics_us_industry_code, naics_industry_code, naics_industry_group, naics_subsector, naics_sector, description
1,175 rows
l_naics_industry
naics_industry_code, naics_industry_group, naics_subsector, naics_sector, description
721 rows
l_naics_us_industry
naics_us_industry_code, naics_industry_code, naics_industry_group, naics_subsector, naics_sector, description
1,175 rows
l_nlrb_office
nlrb_office_id, region, branch, division, district, office_name, description, supervising_office, office_mgr_name, office_type, street_address_1, street_address_2, city, state, zip, main_phone_num, main_phone_ext, main_fax_num, e_mail_address, system_time_out, io_daily_hours, trigger_flag, standard_correspond_path, standard_reports_path, office_correspond_path, office_reports_path, office_forms_path, path_legal_research, path_forms, path_summation, path_crystal, message_of_the_day, date_in_service, cats_version
45 rows
l_notifications
notification_id, participant_group, nlrb_office_id, contact_id, keyword, subject, coverage
2,553 rows
l_r_action_fields
action_table_code, action_field_code, tbl_name, field_name, description, chronology_flag
88 rows
l_r_case_group_type
case_group_type, prohibit_manual_maint, description, case_group_sort_order
1 row
r_action
r_case_number, unit_id, action_sequence, recurrence, action_table_code, action_field_code, action_date, date_entered, action_control
432,001 rows
r_bargaining_unit
r_case_number, unit_id, bargaining_unit_code, bargaining_unit_scope, num_employees_determined, unit_city, unit_state, unit_county, description_determined
46,397 rows
r_block
r_case_number, unit_id, action_sequence, recurrence, blocked, unblocked, reqproc_board_filed_date, reqproc_board_party, reqproc_board_deter_date, reqproc_board_deter
10,346 rows
r_block_cases
r_case_number, unit_id, action_sequence, sequence, recurrence, c_case_number, req_proceed_filed, req_proceed_party, req_proceed_withdrawn
21,130 rows
r_case
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
54,118 rows
r_case_case_group
r_case_group_id, r_case_number, sequence, date_case_added, lead, date_case_removed
2,283 rows
r_challenge_issue
election_id, sequence, challenge_party, challenge_issue, number, challenge_action, challenge_result
6,948 rows
r_challenge_tabulation
election_id, challenge_action, sequence, number_eligible, number_ineligible, number_withdrawn, number_unresolved
3,636 rows
r_closed_case
r_case_number, action_sequence, closing_date, closing_stage, closing_method, date_file_archives, date_file_to_records, date_file_destroyed
53,740 rows
r_elect_agreement
r_case_number, unit_id, action_sequence, date_approved, election_agreement_type
32,708 rows
r_elect_certification
election_id, cert_of_representative, cert_of_results, certified_bargaining_agent
29,844 rows
r_elect_scheduled
r_case_number, unit_id, action_sequence, election_mode, election_type, election_state, election_time, election_city, schedule_date, self_deter_election, expedited_under_8b7, scheduled_tally_date, election_cancelled, date_excelsior_list_due, date_excelsior_list_received, date_excelsior_list_sent, date_eligible, election_place, additional_languages
37,721 rows
r_elect_votes_for
r_case_number, unit_id, election_id, tally_id, sort_order, labor_organization, votes_for
35,589 rows
r_election
election_id, date_election, election_type, election_mode, election_time, election_city, election_state, expedited_under_8b7, globe_sonotone_election, ballots_impounded
31,678 rows
r_election_tally
r_case_number, unit_id, election_id, tally_id, tally_date, tally_type, self_determination_tally, num_employees_eligible, num_void_ballots, num_votes_against, num_valid_votes, num_challenges, challenges_determinative, runoff_required, majority_for, num_for_inclusion, num_against_inclusion, num_sustained_challenges
33,966 rows
r_objection_issue
election_id, sequence, objection_issue_date, objection_party, objection_issue, objection_action, objection_result
37,264 rows
r_participant
r_case_number, participant_id, participant_role, participant_group, name_for_correspondence, name_prefix, first_name, mid_name, last_name, name_suffix, street_address_1, street_address_2, city, state, zip, phone_num, phone_ext, cell_phone, fax_num, e_mail_address, formal_name, parent_name, exclusive_service, incumbent_union, labor_org_code, local_dist_id, afl_cio, party_scope, parti_type
236,073 rows
r_post_elect_board_act
r_case_number, received_date, received_reason, ruling_action_code, exception_withdrawn_date, board_decision_date, board_action_code
2,536 rows
r_post_elect_hearing
r_case_number, unit_id, election_id, action_sequence, recurrence, noh_issued, hearing_scheduled, p_p_request_date, p_p_party, p_p_determination, p_p_order_issued, hearing_opened, hearing_closed, hearing_days, date_reschedule_issued, staff_id, length_of_transcript, hearing_time, hearing_city, hearing_state, hearing_address
3,688 rows
r_post_elect_rd_act
r_case_number, unit_id, election_id, action_sequence, recurrence, brief_due, brief_filed, brief_party, eot_request_date, eot_party, eot_determination_date, eot_determination, action_date, rd_action_type, rd_action_determination, review_due_date, date_ho_report, ho_report_directed, exceptions_due_date
4,745 rows
r_pre_elect_board_act
r_case_number, action_sequence, recurrence, received_date, received_reason, ruling_decision_date, ruling_action_code, exception_withdrawn_date, board_decision_date, board_action_code
2,720 rows
r_pre_elect_hearing
r_case_number, unit_id, action_sequence, recurrence, date_notice_issued, date_hearing_scheduled, date_rescheduled_issued, length_of_transcript, p_p_party, p_p_determination, p_p_rcvd_region, p_p_response_date, hearing_opened, hearing_closed, hearing_days_on_record, hearing_off_rep_date, hearing_time, hearing_city, hearing_state, hearing_address
56,031 rows
r_pre_elect_rd_decision
r_case_number, unit_id, action_sequence, recurrence, determination_eot, eot_party, eot_filed_date, eot_deter_brief_date, brief_rcvd_party, pre_election_brief_rcvd, rd_decision_issued_date, rd_decision_type, recon_request_filed, recon_request_party, rd_recon_deter, rd_recon_deter_date, brief_due_date, review_due_date
10,280 rows
r_transfer_history
r_case_number, history_date, sequence, date_data_received, request_date, reason_transfer, transfer_type, transfer_order_date, new_case_number, former_case_number, sent_date, received_date
1,350 rows
r_withdrawal
r_case_number, unit_id, action_sequence, withdrawal_approved_date, with_prejudice_flag
19,884 rows
... and 2 hidden tables
Download SQLite DB: cats.db 853.9 MB