Schema for nlrb_rc_elections_1961_1998
CREATE TABLE nlrb_representation_1961_1998(nlrb_id BIGINT, region BIGINT, r_type VARCHAR, docket BIGINT, sic VARCHAR, unit VARCHAR, elect_size BIGINT, elect_type VARCHAR, elig_voter BIGINT, fst_votes BIGINT, fst_union VARCHAR, sec_votes BIGINT, sec_union VARCHAR, thr_votes BIGINT, thr_union VARCHAR, votes_no BIGINT, challenged BIGINT, elect_contr BIGINT, objection_filed_date DATE, obj_party BIGINT, day_obj_el VARCHAR, ruling_obj BIGINT, day_dec_el VARCHAR, req_review FLOAT, elect_ctrl BIGINT, hrngctrl VARCHAR, day_el_clo VARCHAR, stg_closin VARCHAR, meth_disp BIGINT, participant VARCHAR, incumb_un BIGINT, recordctrl VARCHAR, t_dt_filed VARCHAR, filed_date DATE, company VARCHAR, address VARCHAR, pet_union VARCHAR, valid_for BIGINT, valid_cast BIGINT, t_dt_elect VARCHAR, election_date DATE, won VARCHAR, recodemth BIGINT, state VARCHAR, gsacty BIGINT, "local" BIGINT, local_name VARCHAR, mailballot VARCHAR, t_dt_closed VARCHAR, closed_date DATE, zip BIGINT, problem BIGINT, city_name VARCHAR, county_name VARCHAR);