home

NLRB cases, 1999-2011

This data is the publicly-releasable records for the Case Activity Tracking System that the National Labor Relations Board used from around 1999-2011

Data source: NLRB files posted to data.gov, archived on archive.org

Custom SQL query

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_decision_bb

c_case_number, action_sequence, recurrence, blue_book_code

1,639 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_allegation

c_case_number, allegation_sequence, nlra_section, allegation_keyname

599,417 rows

c_amendment

c_case_number, sequence, amendment_date, amendment_type, amendment_reason

54,826 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_dec_bb

c_case_number, action_sequence, recurrence, blue_book_code

1,299 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_case_group

c_case_group_id, case_group_type, date_dissolved, date_created

60,628 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_r_block

c_case_number, sequence, r_case_number

5,832 rows

c_regional_compliance

c_case_number, action_sequence, recurrence, date_assigned

39,043 rows

c_regional_deter

action_sequence, recurrence, organizational_campaign, strike_in_same_unit

326,198 rows

c_reopening

c_case_number, action_sequence, reopen_date, reopen_reason

6,772 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_closed_case_report_alleg

c_case_number, action_sequence, nlra_section

204,012 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_allegation_type

nlra_section, allegation_keyname, case_type, description

217 rows

l_blue_book_chapter

bb_chapter, bb_division, description

66 rows

l_blue_book_codes

blue_book_code, bb_section, bb_heading, bb_chapter, bb_division, description

24,546 rows

l_blue_book_division

bb_division, description

8 rows

l_blue_book_heading

bb_heading, bb_chapter, bb_division, description

3,249 rows

l_blue_book_section

bb_section, bb_heading, bb_chapter, bb_division, description

12,607 rows

l_brief_type

brief_type, description

5 rows

l_c_10j_advice_deter

determination, description

2 rows

l_c_10j_board_deter

determination, description

2 rows

l_c_10j_brief_type

i_10j_brief_type, description

4 rows

l_c_10j_discovery_type

discovery_type, description

4 rows

l_c_10j_final

final_disposition_10j, description

5 rows

l_c_10j_judgement

judgement_type, description

4 rows

l_c_10j_motion_determ

determination_motion, description

4 rows

l_c_10j_motion_type

motion_type, description

8 rows

l_c_10j_reason_cease

reason_cease, description

5 rows

l_c_10j_reg_determ_code

regional_determination, description

2 rows

l_c_10l_co_determ

determination_type, description

4 rows

l_c_10l_discovery_type

discovery_type, description

4 rows

l_c_10l_final

final_disposition_10l, description

4 rows

l_c_10l_motion_determ

determination_motion, description

4 rows

l_c_10l_reason_cease

reason_cease, description

5 rows

l_c_10l_reg_determ

regional_determination, description

2 rows

l_c_abeyance_code

abeyance_reason, description

4 rows

l_c_accordance_with

accordance, description

7 rows

l_c_action_fields

action_table_code, action_field_code, tbl_name, field_name, description, chronology_flag

264 rows

l_c_advice_determination

advice_determination, description

7 rows

l_c_advice_type

advice_type, description

8 rows

l_c_alj_cmp_deter

determination, description

5 rows

l_c_alj_determination

determination, description

4 rows

l_c_alj_mot_typ

motion_type, description

14 rows

l_c_alleg_act_type

action_type, action_result, description

49 rows

l_c_amendment_reason

amendment_reason, description

7 rows

l_c_amendment_type

amendment_type, description

10 rows

l_c_app_brief_pleading

brief_pleading, description

4 rows

l_c_app_court_act_type

court_action_type, description

4 rows

l_c_app_court_action

court_action_action, description

4 rows

l_c_appeal_action

appeal_action, description

4 rows

l_c_appeal_deter

appeal_determination, description

9 rows

l_c_appellate_court

determination, description, certiorari_board_date_deter

4 rows

l_c_appellate_enf_deter

enforcement_determination, description

5 rows

l_c_bank_pet_type

bank_pet_type, description

4 rows

l_c_bd_contempt

determination, description

2 rows

l_c_bd_deter_certiorari

certiorari_board_deter, description

2 rows

l_c_board_determination

determination, description

6 rows

l_c_board_motion_deter

board_motion_deter, description

4 rows

l_c_board_motion_type

board_motion_type, description

11 rows

l_c_board_recon_deter

request_determination, description

4 rows

l_c_case_group_type

case_group_type, prohibit_manual_maint, description, case_group_sort_order

6 rows

l_c_case_note_topic

note_topic, description, region

253 rows

l_c_case_scope

scope, description

2 rows

l_c_case_type

case_type, description, next_docket_number

7 rows

l_c_close_determination

determination, description

4 rows

l_c_close_method

close_method, description

15 rows

l_c_close_timing

close_timing, description

14 rows

l_c_cmp_letter_type

letter_type, description

4 rows

l_c_cmp_spec_sw_action

sw_action, description

2 rows

l_c_cmp_spec_sw_participation

sw_participation, description

2 rows

l_c_comp_motion_deter

determination, description

4 rows

l_c_comp_motion_forum

motion_forum, description

6 rows

l_c_comp_motion_type

motion_type, description

21 rows

l_c_complaint_reason

reason_for_withdrawal, description

5 rows

l_c_compliance_reason

compliance_reason, description

14 rows

l_c_contempt_deter

determination, description

4 rows

l_c_contempt_settlement

settlement_type, description

2 rows

l_c_deferral_type

deferral_type, description

7 rows

l_c_discharge_bank_act

dis_bank_action, description

3 rows

l_c_discovery_ct_deter

court_determination, description

4 rows

l_c_dismissal_revoke

revoked_reason, description

4 rows

l_c_enf_court_act_type

court_action_type, description

7 rows

l_c_enf_court_action

court_action_action, description

8 rows

l_c_enforcement_settlement

settlement_type, description

3 rows

l_c_escrow_acc_loc

escrow_location, description

2 rows

l_c_formal_settle_type

formal_settlement_type, description

3 rows

l_c_fs_submitted

fs_submitted_to, description

2 rows

l_c_gc_recommendation

gc_cert_recommendation, description

2 rows

l_c_goal_description

goal, description

11 rows

l_c_goals

goal, first_effective, category, number_of_days, last_effective, active

15 rows

l_c_heac_det_p_p

determination_request_p_p, description

4 rows

l_c_hearing_type

hearing_type, description

3 rows

l_c_inj_appellate_dec

decision, description

3 rows

l_c_inj_court_order_typ

court_order_type, description

4 rows

l_c_inj_evidence_type

evidence_type, description

6 rows

l_c_inj_rel_type

injuctive_relief_type, description

3 rows

l_c_inj_relief_deter

injunctive_relief_dec, description

4 rows

l_c_inj_relief_recipient

injunctive_relief_rec, description

4 rows

l_c_method_of_disp

method_of_disposition, description

4 rows

l_c_motion_summ_judge

motion_basis, description

2 rows

l_c_overage_decision

overage_decision, description

2 rows

l_c_overage_reason

overage_reason, description

14 rows

l_c_p_p_deter_source

p_p_deter_source, description

4 rows

l_c_part_role_type

role_code, description

16 rows

l_c_posting_type

posting_type, description

4 rows

l_c_proof_claim_cat

poc_category, description

5 rows

l_c_reason_transfer

reason_transfer, description

4 rows

l_c_reg_det_agenda_typ

agenda_type, description

3 rows

l_c_reg_det_dec_level

decision_level, description

5 rows

l_c_reg_det_type

regional_determination, description

14 rows

l_c_reopen_reason

reopen_reason, description

5 rows

l_c_settle_part

participation, description

3 rows

l_c_settlement_bd

determination, description

4 rows

l_c_som_determination

som_determination, description

2 rows

l_c_spielberg_determ

spielberg_determination, description

3 rows

l_c_status

status, description

26 rows

l_c_supreme_ct_deter

determination, description

8 rows

l_c_supreme_ct_pet_deter

pet_determination, description

2 rows

l_c_timing_of_disp

timing_of_disposition, description

4 rows

l_c_transfer_type

transfer_type, description

4 rows

l_c_willingness_type

willingness_type, description

4 rows

l_c_with_disposition

disposition, description

3 rows

l_c_with_revocation

revoked_reason, description

3 rows

l_c_with_scope

withdrawal_scope, description

2 rows

l_case_party

party, description, party_type

14 rows

l_ccr_backpay_control

backpay_control_code, description

5 rows

l_ccr_bargain_status

other_bargain_status, description

6 rows

l_ccr_charge_party_pos

cp_position, description

2 rows

l_ccr_closing_stage

closing_stage, description

12 rows

l_ccr_closing_type

closing_type, description

6 rows

l_ccr_complaint

complaint, description

2 rows

l_ccr_contempt_rec_type

contempt_recommended_type, description

2 rows

l_compliance_type

type, description

6 rows

l_county

county_code, state, county_name

3,294 rows

l_court

court, court_type, description

207 rows

l_court_type

court_type, description

113 rows

l_eot_determination

eot_determination, description

4 rows

l_geographic_division

geographic_division, description

10 rows

l_geographic_region

geographic_region, description

10 rows

l_hearing_record_form

record_form, description

2 rows

l_impact_analysis_cat

impact_category, description, number_of_days

3 rows

l_injunction_brief_type

i_10l_brief_type, description

5 rows

l_injunction_motion_type

motion_type, description

5 rows

l_labor_org_code

labor_org_code, labor_org_reference, labor_org_name, afl_cio

734 rows

l_member_type

member_type, description

10 rows

l_method_filed_type

method_filed, description

7 rows

l_motion_deter

motion_determination, description

4 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_industry_group

naics_industry_group, naics_subsector, naics_sector, description

313 rows

l_naics_qualifier

naics_code, naics_qualifier, description

12 rows

l_naics_sector

naics_sector, description

24 rows

l_naics_subsector

naics_subsector, naics_sector, description

99 rows

l_naics_us_industry

naics_us_industry_code, naics_industry_code, naics_industry_group, naics_subsector, naics_sector, description

1,175 rows

l_name_prefix

name_prefix, description

7 rows

l_name_suffix

name_suffix, description

7 rows

l_nlrb_branch

branch, description

5 rows

l_nlrb_district

district, description

7 rows

l_nlrb_division

division, description

12 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_nlrb_office_type

office_type, description

4 rows

l_nlrb_region

region, description, force_xfer_log

45 rows

l_note_type

note_type, description, object_tag

6 rows

l_notifications

notification_id, participant_group, nlrb_office_id, contact_id, keyword, subject, coverage

2,553 rows

l_organization

organization_id, formal_name, parent_name

70,977 rows

l_organization_name

organization_id, cnt, variant_name

95,755 rows

l_parti_type

parti_type, description

4 rows

l_participant_group

participant_group, identifier, description

45 rows

l_party_scope

party_scope, description

5 rows

l_party_type

party_type, description

7 rows

l_r_action_fields

action_table_code, action_field_code, tbl_name, field_name, description, chronology_flag

88 rows

l_r_amendment_reason

amendment_reason, description

5 rows

l_r_amendment_type

amendment_type, description

10 rows

l_r_bargain_unit_code

bargaining_unit_code, description

10 rows

l_r_bargain_unit_scope

bargaining_unit_scope, description

6 rows

l_r_block_determination

block_determination, description

4 rows

l_r_board_action_code

action_code, action_source, description

77 rows

l_r_board_action_src_reason

action_source, received_reason

6 rows

l_r_board_received_reason

received_reason, description

4 rows

l_r_case_elect_type

election_type, description

7 rows

l_r_case_group_type

case_group_type, prohibit_manual_maint, description, case_group_sort_order

1 row

l_r_case_note_topic

note_topic, description, region

210 rows

l_r_case_type

case_type, description, next_docket_number

7 rows

l_r_challenge_act_result

challenge_action, challenge_result, description

54 rows

l_r_challenge_act_type

challenge_action, description, sort_index, pre_investigation

16 rows

l_r_challenge_issue

challenge_issue, description

22 rows

l_r_closing_method

closing_method, description

8 rows

l_r_closing_stage

closing_stage, description

5 rows

l_r_elect_agree_type

election_agreement_type, description

2 rows

l_r_elect_mode

election_mode, description

3 rows

l_r_obj_act_result

objection_action, objection_result, description

49 rows

l_r_obj_act_type

objection_action, description

15 rows

l_r_objection_issue

objection_issue, description

26 rows

l_r_part_role_type

participant_role, role_name

16 rows

l_r_postelec_det_eot

post_elect_determ_eot, description

4 rows

l_r_postelec_det_p_p

post_elect_determ_p_p, description

4 rows

l_r_postelec_ho_directed

ho_report_directed, description

2 rows

l_r_preelec_det_eot

determination_eot, description

4 rows

l_r_preelec_hear_det_p_p

determination_request_p_p, description

4 rows

l_r_preelec_rd_dec_type

rd_decision_type, description

7 rows

l_r_preelec_rd_issue_dec

issue_code, description

59 rows

l_r_preelec_rd_recon

rd_reconsider_deter, description

5 rows

l_r_rd_action_det

rd_action_determination, rd_action_type, description

82 rows

l_r_rd_action_type

rd_action_type, description

18 rows

l_r_reason_transfer

reason_transfer, description

4 rows

l_r_reopen_reason

reopen_reason, description

5 rows

l_r_status

status, description

23 rows

l_r_tally_type

tally_type, description

14 rows

l_r_target_description

target, description

6 rows

l_r_targets

target, first_effective, number_of_days, last_effective, active, category

6 rows

l_r_transfer_type

transfer_type, description

3 rows

l_r_with_det

withdrawal_req_deter, description

4 rows

l_scope

scope, description

2 rows

l_state

state, geographic_division, geographic_region, state_name

60 rows

l_supervisor_type

supervisor_type, description

3 rows

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_case_group

r_case_group_id, case_group_type, date_created, date_dissolved

1,083 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_dismissal

r_case_number, unit_id, action_sequence, date_letter_issued

2,289 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_impact_category

r_case_number, history_sequence, preelection, postelection

61,797 rows

r_objection_issue

election_id, sequence, objection_issue_date, objection_party, objection_issue, objection_action, objection_result

37,264 rows

r_part_variant

r_case_number, participant_id, variant_name

102,208 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_bb

r_case_number, unit_id, action_sequence, blue_book_code, recurrence

9,077 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_pre_elect_rd_issues

r_case_number, unit_id, action_sequence, recurrence, issue_code

4,791 rows

r_reopened_case

r_case_number, action_sequence, date_reopened, reopen_reason

365 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 1 hidden table

Download SQLite DB: cats.db 853.9 MB

Powered by Datasette · Queries took 285.134ms · Data source: NLRB files posted to data.gov, archived on archive.org