rc_elect

where case_number = "01-RC-018072"

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ case_number suffix election_date unit description_election expedited date_election_held type_election no_elig join_union_won union_won_votes union_won_intl_type union_won_intl joint_union_lost_1 union_lost_votes_1 union_lost_intl_1_type union_lost_intl_1 joint_union_lost_2 union_lost_votes_2 union_lost_intl_2_type union_lost_intl_2 joint_union_lost_3 union_lost_votes_3 union_lost_intl_3_type union_lost_intl_3 joint_union_lost_4 union_lost_votes_4 union_lost_intl_4_type union_lost_intl_4 votes_against_union challenges void_votes elect_vote_control control conclusive challenges_determinative patric_union incumb_union mail_ballot union_control cross_petition runoff_necessary cross_pet_case_number rerun_runoff_number impounded date_elect_certified stage method
114 114 01-RC-018072 A 1984-02-02 T 1 0 1984-02-02 S 49 0 0 8   0 8 3 233 233                         41 0 0 1 0 1 1   B   0     0       1984-02-13 1 4 
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,
   [union_won_intl] INTEGER,
   [joint_union_lost_1] INTEGER,
   [union_lost_votes_1] INTEGER,
   [union_lost_intl_1_type] TEXT,
   [union_lost_intl_1] INTEGER,
   [joint_union_lost_2] INTEGER,
   [union_lost_votes_2] INTEGER,
   [union_lost_intl_2_type] TEXT,
   [union_lost_intl_2] INTEGER,
   [joint_union_lost_3] INTEGER,
   [union_lost_votes_3] INTEGER,
   [union_lost_intl_3_type] TEXT,
   [union_lost_intl_3] INTEGER,
   [joint_union_lost_4] INTEGER,
   [union_lost_votes_4] INTEGER,
   [union_lost_intl_4_type] TEXT,
   [union_lost_intl_4] INTEGER,
   [votes_against_union] INTEGER,
   [challenges] INTEGER,
   [void_votes] INTEGER,
   [elect_vote_control] INTEGER,
   [control] INTEGER,
   [conclusive] INTEGER,
   [challenges_determinative] INTEGER,
   [patric_union] TEXT,
   [incumb_union] TEXT,
   [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,
   [method] TEXT,
   FOREIGN KEY([union_won_intl_type]) REFERENCES [l_elect_union_type]([code]),
   FOREIGN KEY([union_won_intl]) REFERENCES [l_union_codes_and_names]([code]),
   FOREIGN KEY([union_lost_intl_1_type]) REFERENCES [l_elect_union_type]([code]),
   FOREIGN KEY([union_lost_intl_1]) REFERENCES [l_union_codes_and_names]([code]),
   FOREIGN KEY([union_lost_intl_2_type]) REFERENCES [l_elect_union_type]([code]),
   FOREIGN KEY([union_lost_intl_2]) REFERENCES [l_union_codes_and_names]([code]),
   FOREIGN KEY([union_lost_intl_3_type]) REFERENCES [l_elect_union_type]([code]),
   FOREIGN KEY([union_lost_intl_3]) REFERENCES [l_union_codes_and_names]([code]),
   FOREIGN KEY([union_lost_intl_4_type]) REFERENCES [l_elect_union_type]([code]),
   FOREIGN KEY([union_lost_intl_4]) REFERENCES [l_union_codes_and_names]([code]),
   FOREIGN KEY([conclusive]) REFERENCES [l_elect_conclusive]([code]),
   FOREIGN KEY([incumb_union]) REFERENCES [l_elect_incumbent_union]([code]),
   FOREIGN KEY([method]) REFERENCES [l_elect_method_of_disposition]([code]),
   FOREIGN KEY([stage]) REFERENCES [l_elect_stage_of_closing]([code]),
   FOREIGN KEY([patric_union]) REFERENCES [l_elect_participating_union]([code])
);