l_type_elections

5 rows

✎ View and edit SQL

This data as json, CSV (advanced)

code ▼ type_election description
B Board Ordered Board ordered election
C Consent Consent - election held pursuant to Agreement for Consent Election (objections and/or challenges, if any, resolved by Regional Director)
E Expedited Expedited election processed under 8(b)(7)(C)
R Regional Director Ordered Regional Director ordered election
S Stipulation Stipulation - election held pursuant to Stipulation for Certification upon Consent Election (Objections and/or Challenges, if any, ruled upon by Board following exceptions to Regional Director's report of objections and/or challenges)

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "l_type_elections" (
   [code] TEXT PRIMARY KEY,
   [type_election] TEXT,
   [description] TEXT
);