Schema for nlrb_rc_elections_1961_1998

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