Schema for chips

CREATE TABLE "allegations" (
"ctype" TEXT,
  "code" INTEGER,
  "allegations" TEXT
);
CREATE TABLE "l_c_case_closing" (
"stage" TEXT,
  "method" TEXT,
  "definition" TEXT
);
CREATE TABLE "l_c_case_pending_status_codes" (
"status" INTEGER,
  "definition" TEXT
);
CREATE TABLE "l_case_types" (
"code" TEXT,
  "type" TEXT
);
CREATE TABLE "l_county" (
"alpha_state_code" TEXT,
  "numeric_state_code" INTEGER,
  "county_number" INTEGER,
  "county_name" TEXT,
  "resident_code" TEXT,
  "region" INTEGER,
  "district" TEXT,
  "resident_office" TEXT,
  "Unnamed: 8" TEXT
);
CREATE TABLE "l_party_filing_objection" (
"code" INTEGER,
  "situation" TEXT
);
CREATE TABLE "l_size_of_unit_codes" (
"code" INTEGER,
  "number_of_employees" TEXT
);
CREATE TABLE "l_stage_of_disposition" (
"code" TEXT,
  "stages_of_disposition_before_hearing_and_after_hearing_closed" TEXT
);
CREATE TABLE "r_names" (
   [case_number] TEXT REFERENCES [r_master]([case_number]),
   [name] TEXT
);
CREATE TABLE "r_address" (
   [case_number] TEXT REFERENCES [r_master]([case_number]),
   [address] TEXT,
   [city] TEXT,
   [state_alpha] TEXT,
   [state_numeric] TEXT
);
CREATE TABLE "r_consolid" (
   [case_number] TEXT REFERENCES [r_master]([case_number]),
   [consolidation_date] TEXT,
   [consol_id] INTEGER,
   [key_consol_case_reg] INTEGER,
   [key_consol_case_type] TEXT,
   [key_consol_case_docket] INTEGER,
   [key_consol_case_suffix] TEXT,
   [sub_consol_case_reg] TEXT,
   [sub_consol_case_type] TEXT,
   [sub_consol_case_docket] TEXT,
   [sub_consol_case_suffix] TEXT,
   [consolidation_type] TEXT,
   [consolidation_code] TEXT,
   [consolidation_stage] TEXT,
   [date_severed] TEXT,
   [severance_id] TEXT,
   [severance_type] TEXT,
   [severance_code] INTEGER,
   [severance_stage] INTEGER
);
CREATE TABLE "regions" (
   [region_num] INTEGER PRIMARY KEY,
   [district_num_fk] INTEGER,
   [region_name] TEXT,
   [subregion_flag] INTEGER,
   [belongs_to_region] INTEGER
);
CREATE TABLE "ud_elect" (
   [case_number] TEXT REFERENCES [r_master]([case_number]),
   [suffix] TEXT,
   [election_date] TEXT,
   [cunion] TEXT,
   [description_election] TEXT,
   [expedited] INTEGER,
   [unit] TEXT,
   [date_election_held] TEXT,
   [type_election] TEXT,
   [no_elig] INTEGER,
   [v_votes] INTEGER,
   [for_prop] INTEGER,
   [agn_prop] INTEGER,
   [chall] INTEGER,
   [void] INTEGER,
   [cout] INTEGER,
   [control] INTEGER,
   [date_election_certified] TEXT,
   [stage] TEXT,
   [method] TEXT,
   [mail_ballot] INTEGER,
   [cross_pet_region] TEXT,
   [cross_pet_type] TEXT,
   [cross_pet_docket] TEXT,
   [cross_pet_suffix] TEXT,
   [rerun_runoff_number] TEXT,
   [impounded] INTEGER
);
CREATE TABLE "c_names" (
   [case_number] TEXT REFERENCES [c_master]([case_number]),
   [name] TEXT
);
CREATE TABLE "c_address" (
   [case_number] TEXT REFERENCES [c_master]([case_number]),
   [address] TEXT,
   [city] TEXT,
   [state_alpha] TEXT,
   [state_numeric] INTEGER
);
CREATE TABLE "c_formal2" (
   [case_number] TEXT REFERENCES [c_master]([case_number]),
   [cf2_date] TEXT,
   [date_last_action] TEXT,
   [consolidation_type] TEXT,
   [consolidation_code] TEXT,
   [update_control] INTEGER,
   [code_date_transfer_board] TEXT,
   [date_transfer_board] TEXT,
   [control_type] TEXT,
   [date_decision_issued] TEXT,
   [type_decision] TEXT,
   [disp_allegations] TEXT,
   [allegations_uphld] TEXT,
   [allegations_dismd] TEXT,
   [number_discrim_reinstated_ca] TEXT,
   [number_receive_back_pay_uni_emp_cb] TEXT,
   [number_receive_back_pay_only_ca] TEXT,
   [number_discrim_restored_cb] TEXT,
   [number_discrim_dismissed] TEXT,
   [number_discrim_preferred] TEXT,
   [remedy] TEXT,
   [board_members] TEXT,
   [board_disposition_allegations] TEXT,
   [close_control] TEXT,
   [card_control] TEXT,
   [code_date_dec_issued] TEXT,
   [volume_number] TEXT,
   [issue_number] TEXT,
   [party_filing_excpt] TEXT,
   [board_members_5] TEXT
);
CREATE TABLE "c_formal3" (
   [case_number] TEXT REFERENCES [c_master]([case_number]),
   [cf3_date] TEXT,
   [date_last_action] TEXT,
   [consol_type] TEXT,
   [consol_code] TEXT,
   [update_control] TEXT,
   [date_ref_app_ct] TEXT,
   [type_ref] TEXT,
   [date_pet_answ_filed] TEXT,
   [date_ref_pet_answ] TEXT,
   [date_ca_opinion] TEXT,
   [date_brief_filed] TEXT,
   [type_disposition] TEXT,
   [ca_no] TEXT,
   [date_ca_decree] TEXT,
   [type_decree] TEXT,
   [control_case] TEXT,
   [card_control] TEXT,
   [code_date_brief_filed] INTEGER
);
CREATE TABLE "c_formal4" (
   [case_number] TEXT REFERENCES [c_master]([case_number]),
   [cf4_date] TEXT,
   [date_last_action] TEXT,
   [stage_last_action] TEXT,
   [consolidation_type] TEXT,
   [consolidation_code] TEXT,
   [upate_control] TEXT,
   [date_referred_scb] TEXT,
   [date_recom_writ_cert] INTEGER,
   [type_recom] TEXT,
   [date_pret_writ_cert_filed] TEXT,
   [party_filing] TEXT,
   [date_sc_action] TEXT,
   [sc_ruling] TEXT,
   [date_supreme_court_argue] INTEGER,
   [date_supreme_court_dec] TEXT,
   [type_supreme_court_dec] TEXT,
   [date_back_pay_specs] TEXT,
   [stage_back_pay_specs] TEXT,
   [date_hearing_closed] TEXT,
   [date_administrative_law_judge_dec_issued] TEXT,
   [date_board_suppl_decision] TEXT,
   [type_board_suppl_decision] TEXT,
   [date_ref_acb] TEXT,
   [date_suppl_ca_decree] TEXT,
   [card_control] INTEGER,
   [code_date_hearing_closed] INTEGER,
   [code_date_administrative_law_judges_decision_issued] INTEGER,
   [code_date_board_suppl_decision] INTEGER
);
CREATE TABLE "r_blocking" (
   [case_number] TEXT REFERENCES [r_master]([case_number]),
   [block_date] TEXT,
   [blocking_case_number] TEXT REFERENCES [c_master]([case_number])
);
CREATE TABLE "c_master" (
   [case_number] TEXT PRIMARY KEY,
   [region] INTEGER,
   [ctype] TEXT,
   [docket] INTEGER,
   [suffix] INTEGER,
   [file_date] TEXT,
   [close_date] TEXT,
   [date_last_action] TEXT,
   [county] TEXT,
   [state] INTEGER,
   [industry] TEXT,
   [complainant] INTEGER,
   [joint_complainant] INTEGER,
   [respondent] TEXT,
   [joint_respondent] INTEGER,
   [number_employed] INTEGER,
   [allegations] INTEGER,
   [number_discrim] INTEGER,
   [situation] INTEGER,
   [number_of_charges] INTEGER,
   [type_charge] TEXT,
   [number_allegations] TEXT,
   [status] TEXT,
   [formal_action_control] TEXT,
   [machine_control] TEXT,
   [proceeding_control] TEXT,
   [fact_advice] TEXT,
   [type_refusal] TEXT,
   [fact_appeal] TEXT,
   [code_date_ro_disp] TEXT,
   [date_ro_disp] TEXT,
   [method_disposition] TEXT,
   [collyer_deferral] TEXT,
   [date_collyer_began] TEXT,
   [date_collyer_end] TEXT,
   [code_date_closed] FLOAT,
   [stage_close] TEXT,
   [method_close] TEXT,
   [reason_remedy_close] TEXT,
   [status_barg_close] FLOAT,
   [solic_stages_investig] TEXT,
   [contact_witness] TEXT,
   [date_re_advice_received] TEXT,
   [date_action_on_advice] TEXT,
   [date_appeal_received] TEXT,
   [date_action_on_appeal] TEXT,
   [hearing_held_code] TEXT,
   [decision_made_code] TEXT,
   [chips_close_flag] TEXT,
   [chips_close_date] TEXT,
   [related_case] TEXT,
   [chips_amended_code] TEXT,
   [formal_setl] TEXT,
   [filed_calendar_year] INTEGER,
   [closed_calendar_year] INTEGER,
   [filed_fiscal_year] INTEGER,
   [closed_fiscal_year] INTEGER,
   [key_case_number] TEXT,
   [sub_key_case_number] TEXT,
   [transferred_case_number] TEXT
);
CREATE TABLE "c_formal1" (
   [case_number] TEXT REFERENCES [c_master]([case_number]),
   [cf1_date] TEXT,
   [date_last_action] TEXT,
   [consol_type] TEXT,
   [consol_code] TEXT,
   [update_control] TEXT,
   [code_date_complt_iss] TEXT,
   [date_complaint_issued] TEXT,
   [allegations] TEXT,
   [number_discrim] INTEGER,
   [complaint_control] TEXT,
   [code_date_ro_disp] TEXT,
   [date_ro_disp] TEXT,
   [ro_disp_control] TEXT,
   [date_hearing_opened] TEXT,
   [code_date_hearing_closed] TEXT,
   [date_hearing_closed] TEXT,
   [hearing_control] TEXT,
   [code_date_disp_issed_recd] TEXT,
   [date_disp_issued_recd] TEXT,
   [type_disposition] TEXT,
   [allegations_uphld] TEXT,
   [allegations_dismd] TEXT,
   [discrim_upheld] TEXT,
   [discrim_dismissed] TEXT,
   [back_pay_control] TEXT,
   [admin_law_judge_disp] TEXT,
   [board_decision_control] TEXT,
   [card_control] TEXT,
   [number_discrim_reinst_ca] INTEGER,
   [number_rec_back_pay_uni_emp_cb] INTEGER,
   [number_rec_back_pay_only_ca] INTEGER,
   [number_discrim_restor_cb] TEXT,
   [number_discrim_preferd] INTEGER,
   [remedy] TEXT,
   [code_date_hearing_opened] TEXT,
   [chips_amended_code] TEXT,
   [consol_server] TEXT,
   [case_state_action] TEXT,
   [complaint_calendar_year] INTEGER,
   [complaint_fical_year] INTEGER,
   [consol_case_number] TEXT,
   [sub_consol_case_number] TEXT
);
CREATE TABLE "c_consolid" (
   [case_number] TEXT REFERENCES [c_master]([case_number]),
   [consolidation] TEXT,
   [consol_id] TEXT,
   [consolidation_type] TEXT,
   [consolidation_code] TEXT,
   [consolidation_stage] TEXT,
   [date_severed] TEXT,
   [severance_id] TEXT,
   [severance_type] TEXT,
   [severance_code] INTEGER,
   [severance_stage] INTEGER,
   [key_consol_case_number] TEXT,
   [sub_consol_case_number] TEXT
);
CREATE TABLE "c_trailer" (
   [case_number] TEXT REFERENCES [c_master]([case_number]),
   [trailer_date] TEXT,
   [date_last_action] TEXT,
   [allegations_adjusted] INTEGER,
   [settlement] TEXT,
   [approval_requested] INTEGER,
   [number_reinstated] INTEGER,
   [number_w_reinstated] INTEGER,
   [number_d_reinstated] INTEGER,
   [number_p_list] INTEGER,
   [number_restored] INTEGER,
   [number_withdrawn_employment] INTEGER,
   [number_rcu_employed] INTEGER,
   [number_allegations] INTEGER,
   [number_made_whole] INTEGER,
   [number_receiving_back_pay] INTEGER,
   [total_amt] INTEGER,
   [amt_pd_co] INTEGER,
   [amt_pd_un] INTEGER,
   [back_pay_control] INTEGER,
   [f_installment] TEXT,
   [number_rcu_dues] INTEGER,
   [total_comp] INTEGER,
   [total_pd_co] INTEGER,
   [total_pd_un] INTEGER,
   [dues_control] INTEGER,
   [remedy] TEXT,
   [date_end_picket] TEXT,
   [date_end_work_stop] TEXT,
   [number_employs_picket] INTEGER,
   [number_employes_stop] INTEGER,
   [number_to_be_reinst] INTEGER,
   [related_combined_code] TEXT,
   [related_key_case_number] TEXT
);
CREATE TABLE "l_unit_codes" (
   [code] TEXT PRIMARY KEY,
   [definition] TEXT
);
CREATE TABLE "l_state_codes" (
   [code] INTEGER PRIMARY KEY,
   [state_name] TEXT
);
CREATE TABLE "l_union_codes_and_names" (
   [code] INTEGER PRIMARY KEY,
   [union_name] TEXT
);
CREATE TABLE "r_master" (
   [case_number] TEXT PRIMARY KEY,
   [region] INTEGER REFERENCES [regions]([region_num]),
   [ctype] TEXT,
   [docket] INTEGER,
   [file_date] TEXT,
   [close_date] TEXT,
   [date_last_action] TEXT,
   [industry] TEXT,
   [state] INTEGER REFERENCES [l_state_codes]([code]),
   [county] INTEGER,
   [petitioner_type] TEXT,
   [petitioner] INTEGER REFERENCES [l_union_codes_and_names]([code]),
   [joint_petitioner] INTEGER,
   [local_number] TEXT,
   [recogn_union_type] TEXT,
   [recogn_union] INTEGER REFERENCES [l_union_codes_and_names]([code]),
   [joint_recogn_union] INTEGER,
   [unit] TEXT REFERENCES [l_unit_codes]([code]),
   [number_emp] INTEGER,
   [proposed_no_emp] INTEGER,
   [picket_8b7c] INTEGER,
   [status] TEXT,
   [machine_control] TEXT,
   [proceeding_control] TEXT,
   [date_appeal] INTEGER,
   [ruling_code] TEXT,
   [consol_code] TEXT,
   [date_notice_hearing_issued] TEXT,
   [date_hearing_opened] TEXT,
   [date_hearing_closed] TEXT,
   [hearing_control] TEXT,
   [code_date_closed] INTEGER,
   [stage_closed] TEXT,
   [method_closed] TEXT,
   [reason_close] TEXT,
   [hearing_held_code] INTEGER,
   [dec_made_code] TEXT,
   [date_agree_approv] TEXT,
   [date_appea_recd] TEXT,
   [date_action_on_appeal] TEXT,
   [chips_amended_code] INTEGER,
   [date_hearing2_closed_108] TEXT,
   [date_hearing2_open_108] TEXT,
   [blocking_case_code] TEXT,
   [consol_sever] TEXT,
   [case_stage_action] TEXT,
   [consol_type] TEXT,
   [chips_close_flag] TEXT,
   [chips_close_date] TEXT,
   [filed_calendar_year] INTEGER,
   [filed_fiscal_year] INTEGER,
   [closed_calendar_year] INTEGER,
   [closed_fiscal_year] INTEGER,
   [blocking_case_number] TEXT,
   [consol_case_number] TEXT,
   [sub_consol_case_number] TEXT,
   [transfer_case_number] TEXT
);
CREATE TABLE "l_type_elections" (
   [code] TEXT PRIMARY KEY,
   [type_election] TEXT,
   [description] TEXT
);
CREATE TABLE "l_elect_union_type" (
   [code] TEXT PRIMARY KEY,
   [definition] TEXT
);
CREATE TABLE "l_elect_conclusive" (
   [code] INTEGER PRIMARY KEY,
   [conclusive_election_control] TEXT
);
CREATE TABLE "l_elect_incumbent_union" (
   [code] INTEGER PRIMARY KEY,
   [incumbent_union] TEXT
);
CREATE TABLE "l_elect_method_of_disposition" (
   [code] TEXT PRIMARY KEY,
   [action] TEXT,
   [method_of_close] TEXT
);
CREATE TABLE "l_elect_stage_of_closing" (
   [code] TEXT PRIMARY KEY,
   [stage_of_closing] TEXT
);
CREATE TABLE "l_elect_participating_union" (
   [code] TEXT PRIMARY KEY,
   [participating_union] TEXT
);
CREATE TABLE "rc_elect" (
   [case_number] TEXT REFERENCES [r_master]([case_number]),
   [suffix] TEXT,
   [election_date] TEXT,
   [unit] TEXT REFERENCES [l_unit_codes]([code]),
   [description_election] TEXT,
   [expedited] INTEGER,
   [date_election_held] TEXT,
   [type_election] TEXT REFERENCES [l_type_elections]([code]),
   [no_elig] INTEGER,
   [join_union_won] INTEGER,
   [union_won_votes] INTEGER,
   [union_won_intl_type] TEXT REFERENCES [l_elect_union_type]([code]),
   [union_won_intl] INTEGER REFERENCES [l_union_codes_and_names]([code]),
   [joint_union_lost_1] INTEGER,
   [union_lost_votes_1] INTEGER,
   [union_lost_intl_1_type] TEXT REFERENCES [l_elect_union_type]([code]),
   [union_lost_intl_1] INTEGER REFERENCES [l_union_codes_and_names]([code]),
   [joint_union_lost_2] INTEGER,
   [union_lost_votes_2] INTEGER,
   [union_lost_intl_2_type] TEXT REFERENCES [l_elect_union_type]([code]),
   [union_lost_intl_2] INTEGER REFERENCES [l_union_codes_and_names]([code]),
   [joint_union_lost_3] INTEGER,
   [union_lost_votes_3] INTEGER,
   [union_lost_intl_3_type] TEXT REFERENCES [l_elect_union_type]([code]),
   [union_lost_intl_3] INTEGER REFERENCES [l_union_codes_and_names]([code]),
   [joint_union_lost_4] INTEGER,
   [union_lost_votes_4] INTEGER,
   [union_lost_intl_4_type] TEXT REFERENCES [l_elect_union_type]([code]),
   [union_lost_intl_4] INTEGER REFERENCES [l_union_codes_and_names]([code]),
   [votes_against_union] INTEGER,
   [challenges] INTEGER,
   [void_votes] INTEGER,
   [elect_vote_control] INTEGER,
   [control] INTEGER,
   [conclusive] INTEGER REFERENCES [l_elect_conclusive]([code]),
   [challenges_determinative] INTEGER,
   [patric_union] TEXT REFERENCES [l_elect_participating_union]([code]),
   [incumb_union] TEXT REFERENCES [l_elect_incumbent_union]([code]),
   [mail_ballot] INTEGER,
   [union_control] TEXT,
   [cross_petition] TEXT,
   [runoff_necessary] INTEGER,
   [cross_pet_case_number] TEXT,
   [rerun_runoff_number] TEXT,
   [impounded] INTEGER,
   [date_elect_certified] TEXT,
   [stage] TEXT REFERENCES [l_elect_stage_of_closing]([code]),
   [method] TEXT REFERENCES [l_elect_method_of_disposition]([code])
);
CREATE TABLE "l_transaction_codes" (
   [trans] TEXT PRIMARY KEY,
   [action] TEXT
);
CREATE TABLE "r_formal1" (
   [case_number] TEXT REFERENCES [r_master]([case_number]),
   [rf1_date] TEXT,
   [date_last_action] TEXT,
   [consol_code] TEXT,
   [code_date_hearing_close] TEXT,
   [date_hearing_close] TEXT,
   [control] INTEGER,
   [update_control] INTEGER,
   [date_dec_issued] TEXT,
   [unit] TEXT REFERENCES [l_unit_codes]([code]),
   [type_dec] TEXT,
   [type_specl_elect] TEXT,
   [date_waiver] TEXT,
   [date_req_review] TEXT,
   [party_filing] TEXT,
   [date_ruling_reg] TEXT,
   [ruling_control] TEXT,
   [date_board_dec_req] TEXT,
   [board_dec] TEXT,
   [type_board_dec] TEXT,
   [board_unit] TEXT,
   [volume_number] TEXT,
   [issue_number] TEXT,
   [board_members_5] TEXT,
   [chips_amended_code] TEXT
);
CREATE TABLE "r_formal2" (
   [case_number] TEXT REFERENCES [r_master]([case_number]),
   [suffix] TEXT,
   [rf2_date] TEXT,
   [date_last_action] TEXT,
   [transaction] TEXT REFERENCES [l_transaction_codes]([trans]),
   [action_777] TEXT,
   [consol_code] TEXT,
   [date_election_held] TEXT,
   [date_obj_chall_filed] TEXT,
   [number_obj_filed] INTEGER,
   [number_chall] INTEGER,
   [date_hearing_ordered] TEXT,
   [basis_election] TEXT REFERENCES [l_type_elections]([code]),
   [party_filing_ob] INTEGER REFERENCES [l_party_filing_objection]([code]),
   [hearing_code] TEXT,
   [hearing_ordered_by] TEXT,
   [date_rps_no_hearing_held] TEXT,
   [update_control] TEXT,
   [date_hearing_closed] TEXT,
   [date_hearing_opened] TEXT,
   [date_rpt_on_obj_chall] TEXT,
   [first_election_rpt] INTEGER,
   [rpt_control] TEXT,
   [date_rd_suppl_dec] TEXT,
   [ruling_on_obj] INTEGER,
   [type_decision] INTEGER,
   [decision_control] TEXT,
   [another_election] TEXT,
   [previously_reported] TEXT,
   [date_certification] TEXT,
   [stage] TEXT,
   [method] TEXT,
   [rd_of_bd_dec] TEXT,
   [date_review_waivered] INTEGER,
   [date_exception_filed] TEXT,
   [exception_code] TEXT,
   [date_ruling_on_exc] TEXT,
   [ruling_on_exc_code] TEXT,
   [date_reg_for_review] TEXT,
   [party_filing_req] TEXT,
   [date_ruling_on_req] TEXT,
   [ruling_on_req_code] TEXT,
   [date_board_dec] INTEGER,
   [type_board_dec] TEXT,
   [number_obj_sustained] INTEGER,
   [number_obj_overuled] INTEGER,
   [number_obj_withdrawn] INTEGER,
   [number_chall_sustained] INTEGER,
   [number_chall_overuled] INTEGER,
   [number_chall_withdrawn] INTEGER,
   [date_obj_chall_resolved] TEXT,
   [ruling_on_obj_r] INTEGER,
   [ruling_on_obj_r.1] INTEGER,
   [date_bd_dec_on_rev] INTEGER,
   [bd_dec_on_rev] INTEGER
);
CREATE TABLE sqlite_stat1(tbl,idx,stat);
CREATE INDEX [idx_r_names_case_number]
    ON [r_names] ([case_number]);
CREATE INDEX [idx_r_address_case_number]
    ON [r_address] ([case_number]);
CREATE INDEX [idx_r_consolid_case_number]
    ON [r_consolid] ([case_number]);
CREATE INDEX [idx_ud_elect_case_number]
    ON [ud_elect] ([case_number]);
CREATE INDEX [idx_c_names_case_number]
    ON [c_names] ([case_number]);
CREATE INDEX [idx_c_address_case_number]
    ON [c_address] ([case_number]);
CREATE INDEX [idx_c_formal2_case_number]
    ON [c_formal2] ([case_number]);
CREATE INDEX [idx_c_formal3_case_number]
    ON [c_formal3] ([case_number]);
CREATE INDEX [idx_c_formal4_case_number]
    ON [c_formal4] ([case_number]);
CREATE INDEX [idx_r_blocking_blocking_case_number]
    ON [r_blocking] ([blocking_case_number]);
CREATE INDEX [idx_r_blocking_case_number]
    ON [r_blocking] ([case_number]);
CREATE INDEX [idx_c_formal1_case_number]
    ON [c_formal1] ([case_number]);
CREATE INDEX [idx_c_consolid_case_number]
    ON [c_consolid] ([case_number]);
CREATE INDEX [idx_c_trailer_case_number]
    ON [c_trailer] ([case_number]);
CREATE INDEX [idx_r_master_unit]
    ON [r_master] ([unit]);
CREATE INDEX [idx_r_master_recogn_union]
    ON [r_master] ([recogn_union]);
CREATE INDEX [idx_r_master_petitioner]
    ON [r_master] ([petitioner]);
CREATE INDEX [idx_r_master_state]
    ON [r_master] ([state]);
CREATE INDEX [idx_r_master_region]
    ON [r_master] ([region]);
CREATE INDEX [idx_rc_elect_method]
    ON [rc_elect] ([method]);
CREATE INDEX [idx_rc_elect_stage]
    ON [rc_elect] ([stage]);
CREATE INDEX [idx_rc_elect_incumb_union]
    ON [rc_elect] ([incumb_union]);
CREATE INDEX [idx_rc_elect_patric_union]
    ON [rc_elect] ([patric_union]);
CREATE INDEX [idx_rc_elect_conclusive]
    ON [rc_elect] ([conclusive]);
CREATE INDEX [idx_rc_elect_union_lost_intl_4]
    ON [rc_elect] ([union_lost_intl_4]);
CREATE INDEX [idx_rc_elect_union_lost_intl_4_type]
    ON [rc_elect] ([union_lost_intl_4_type]);
CREATE INDEX [idx_rc_elect_union_lost_intl_3]
    ON [rc_elect] ([union_lost_intl_3]);
CREATE INDEX [idx_rc_elect_union_lost_intl_3_type]
    ON [rc_elect] ([union_lost_intl_3_type]);
CREATE INDEX [idx_rc_elect_union_lost_intl_2]
    ON [rc_elect] ([union_lost_intl_2]);
CREATE INDEX [idx_rc_elect_union_lost_intl_2_type]
    ON [rc_elect] ([union_lost_intl_2_type]);
CREATE INDEX [idx_rc_elect_union_lost_intl_1]
    ON [rc_elect] ([union_lost_intl_1]);
CREATE INDEX [idx_rc_elect_union_lost_intl_1_type]
    ON [rc_elect] ([union_lost_intl_1_type]);
CREATE INDEX [idx_rc_elect_union_won_intl]
    ON [rc_elect] ([union_won_intl]);
CREATE INDEX [idx_rc_elect_union_won_intl_type]
    ON [rc_elect] ([union_won_intl_type]);
CREATE INDEX [idx_rc_elect_type_election]
    ON [rc_elect] ([type_election]);
CREATE INDEX [idx_rc_elect_unit]
    ON [rc_elect] ([unit]);
CREATE INDEX [idx_rc_elect_case_number]
    ON [rc_elect] ([case_number]);
CREATE INDEX [idx_r_formal1_unit]
    ON [r_formal1] ([unit]);
CREATE INDEX [idx_r_formal1_case_number]
    ON [r_formal1] ([case_number]);
CREATE INDEX [idx_r_formal2_party_filing_ob]
    ON [r_formal2] ([party_filing_ob]);
CREATE INDEX [idx_r_formal2_basis_election]
    ON [r_formal2] ([basis_election]);
CREATE INDEX [idx_r_formal2_transaction]
    ON [r_formal2] ([transaction]);
CREATE INDEX [idx_r_formal2_case_number]
    ON [r_formal2] ([case_number])