r_elect_agreement
32,708 rows
This data as json, CSV (advanced)
| Link | rowid ▼ | r_case_number | unit_id | action_sequence | date_approved | election_agreement_type |
|---|---|---|---|---|---|---|
| 1 | 1 | 01-RC-19926 | A | 0 | 1993-05-06T00:00:00 | Stipulated Election Agreement Stip |
| 2 | 2 | 01-RC-20292 | A | 0 | 1995-05-02T00:00:00 | Stipulated Election Agreement Stip |
| 3 | 3 | 01-RC-20467 | A | 0 | 1996-06-14T00:00:00 | Stipulated Election Agreement Stip |
| 4 | 4 | 01-RC-20626 | A | 0 | 1997-06-24T00:00:00 | Stipulated Election Agreement Stip |
| 5 | 5 | 01-RC-20634 | A | 0 | 1997-06-30T00:00:00 | Stipulated Election Agreement Stip |
| 6 | 6 | 01-RC-20649 | A | 0 | 1997-07-30T00:00:00 | Stipulated Election Agreement Stip |
| 7 | 7 | 01-RC-20761 | A | 0 | 1998-03-19T00:00:00 | Stipulated Election Agreement Stip |
| 8 | 8 | 01-RC-20815 | A | 0 | 2001-01-10T00:00:00 | Stipulated Election Agreement Stip |
| 9 | 9 | 01-RC-20890 | A | 0 | 1998-09-18T00:00:00 | Stipulated Election Agreement Stip |
| 10 | 10 | 01-RC-20897 | A | 0 | 1998-10-06T00:00:00 | Stipulated Election Agreement Stip |
| 11 | 11 | 01-RC-20906 | A | 0 | 1998-10-23T00:00:00 | Stipulated Election Agreement Stip |
| 12 | 12 | 01-RC-20910 | A | 0 | 1998-10-30T00:00:00 | Stipulated Election Agreement Stip |
| 13 | 13 | 01-RC-20912 | A | 0 | 1998-10-28T00:00:00 | Stipulated Election Agreement Stip |
| 14 | 14 | 01-RC-20922 | A | 0 | 1998-11-10T00:00:00 | Stipulated Election Agreement Stip |
| 15 | 15 | 01-RC-20923 | A | 0 | 1998-11-10T00:00:00 | Stipulated Election Agreement Stip |
| 16 | 16 | 01-RC-20936 | A | 0 | 1998-12-07T00:00:00 | Stipulated Election Agreement Stip |
| 17 | 17 | 01-RC-20937 | A | 0 | 1998-12-10T00:00:00 | Stipulated Election Agreement Stip |
| 18 | 18 | 01-RC-20938 | A | 0 | 1998-12-10T00:00:00 | Stipulated Election Agreement Stip |
| 19 | 19 | 01-RC-20941 | A | 0 | 1998-12-17T00:00:00 | Stipulated Election Agreement Stip |
| 20 | 20 | 01-RC-20942 | A | 0 | 1998-12-11T00:00:00 | Stipulated Election Agreement Stip |
| 21 | 21 | 01-RC-20944 | A | 0 | 1998-12-22T00:00:00 | Stipulated Election Agreement Stip |
| 22 | 22 | 01-RC-20946 | A | 0 | 1998-12-23T00:00:00 | Stipulated Election Agreement Stip |
| 23 | 23 | 01-RC-20949 | A | 0 | 1999-01-28T00:00:00 | Stipulated Election Agreement Stip |
| 24 | 24 | 01-RC-20950 | A | 0 | 1999-01-13T00:00:00 | Stipulated Election Agreement Stip |
| 25 | 25 | 01-RC-20952 | A | 0 | 1998-12-24T00:00:00 | Stipulated Election Agreement Stip |
| 26 | 26 | 01-RC-20953 | A | 0 | 1999-01-05T00:00:00 | Stipulated Election Agreement Stip |
| 27 | 27 | 01-RC-20955 | A | 0 | 1999-01-04T00:00:00 | Stipulated Election Agreement Stip |
| 28 | 28 | 01-RC-20956 | A | 0 | 1998-12-30T00:00:00 | Stipulated Election Agreement Stip |
| 29 | 29 | 01-RC-20959 | A | 0 | 1999-01-08T00:00:00 | Stipulated Election Agreement Stip |
| 30 | 30 | 01-RC-20964 | A | 0 | 1999-02-04T00:00:00 | Stipulated Election Agreement Stip |
| 31 | 31 | 01-RC-20966 | A | 0 | 1999-02-18T00:00:00 | Stipulated Election Agreement Stip |
| 32 | 32 | 01-RC-20972 | A | 0 | 1999-02-26T00:00:00 | Stipulated Election Agreement Stip |
| 33 | 33 | 01-RC-20973 | A | 0 | 1999-02-18T00:00:00 | Stipulated Election Agreement Stip |
| 34 | 34 | 01-RC-20974 | A | 0 | 1999-03-01T00:00:00 | Stipulated Election Agreement Stip |
| 35 | 35 | 01-RC-20976 | A | 0 | 1999-03-05T00:00:00 | Stipulated Election Agreement Stip |
| 36 | 36 | 01-RC-20977 | A | 0 | 1999-03-08T00:00:00 | Stipulated Election Agreement Stip |
| 37 | 37 | 01-RC-20978 | A | 0 | 1999-03-11T00:00:00 | Stipulated Election Agreement Stip |
| 38 | 38 | 01-RC-20979 | A | 0 | 1999-03-09T00:00:00 | Stipulated Election Agreement Stip |
| 39 | 39 | 01-RC-20980 | A | 0 | 1999-03-10T00:00:00 | Stipulated Election Agreement Stip |
| 40 | 40 | 01-RC-20981 | A | 0 | 1999-03-23T00:00:00 | Stipulated Election Agreement Stip |
| 41 | 41 | 01-RC-20982 | A | 0 | 1999-03-12T00:00:00 | Stipulated Election Agreement Stip |
| 42 | 42 | 01-RC-20986 | A | 0 | 1999-03-25T00:00:00 | Stipulated Election Agreement Stip |
| 43 | 43 | 01-RC-20987 | A | 0 | 1999-03-25T00:00:00 | Stipulated Election Agreement Stip |
| 44 | 44 | 01-RC-20988 | A | 0 | 1999-03-31T00:00:00 | Stipulated Election Agreement Stip |
| 45 | 45 | 01-RC-20989 | A | 0 | 1999-04-08T00:00:00 | Stipulated Election Agreement Stip |
| 46 | 46 | 01-RC-20991 | A | 0 | 1999-04-05T00:00:00 | Stipulated Election Agreement Stip |
| 47 | 47 | 01-RC-20992 | A | 0 | 1999-04-07T00:00:00 | Stipulated Election Agreement Stip |
| 48 | 48 | 01-RC-20993 | A | 0 | 1999-04-12T00:00:00 | Stipulated Election Agreement Stip |
| 49 | 49 | 01-RC-20994 | A | 0 | 1999-04-15T00:00:00 | Stipulated Election Agreement Stip |
| 50 | 50 | 01-RC-20997 | A | 0 | 1999-04-14T00:00:00 | Stipulated Election Agreement Stip |
| 51 | 51 | 01-RC-20998 | A | 0 | 1999-04-09T00:00:00 | Stipulated Election Agreement Stip |
| 52 | 52 | 01-RC-21001 | A | 0 | 1999-05-03T00:00:00 | Stipulated Election Agreement Stip |
| 53 | 53 | 01-RC-21002 | A | 0 | 1999-04-28T00:00:00 | Stipulated Election Agreement Stip |
| 54 | 54 | 01-RC-21003 | A | 0 | 1999-04-30T00:00:00 | Stipulated Election Agreement Stip |
| 55 | 55 | 01-RC-21004 | A | 0 | 1999-04-28T00:00:00 | Stipulated Election Agreement Stip |
| 56 | 56 | 01-RC-21007 | A | 0 | 1999-04-30T00:00:00 | Stipulated Election Agreement Stip |
| 57 | 57 | 01-RC-21008 | A | 0 | 1999-05-03T00:00:00 | Stipulated Election Agreement Stip |
| 58 | 58 | 01-RC-21010 | A | 0 | 1999-05-12T00:00:00 | Stipulated Election Agreement Stip |
| 59 | 59 | 01-RC-21013 | A | 0 | 1999-05-21T00:00:00 | Stipulated Election Agreement Stip |
| 60 | 60 | 01-RC-21015 | A | 0 | 1999-05-19T00:00:00 | Stipulated Election Agreement Stip |
| 61 | 61 | 01-RC-21016 | A | 0 | 1999-05-24T00:00:00 | Stipulated Election Agreement Stip |
| 62 | 62 | 01-RC-21017 | A | 0 | 1999-05-26T00:00:00 | Stipulated Election Agreement Stip |
| 63 | 63 | 01-RC-21018 | A | 0 | 1998-06-03T00:00:00 | Stipulated Election Agreement Stip |
| 64 | 64 | 01-RC-21019 | A | 0 | 1999-05-27T00:00:00 | Stipulated Election Agreement Stip |
| 65 | 65 | 01-RC-21020 | A | 0 | 1999-06-29T00:00:00 | Stipulated Election Agreement Stip |
| 66 | 66 | 01-RC-21021 | A | 0 | 1999-06-03T00:00:00 | Stipulated Election Agreement Stip |
| 67 | 67 | 01-RC-21022 | A | 0 | 1999-06-04T00:00:00 | Stipulated Election Agreement Stip |
| 68 | 68 | 01-RC-21023 | A | 0 | 1999-06-08T00:00:00 | Stipulated Election Agreement Stip |
| 69 | 69 | 01-RC-21024 | A | 0 | 1999-06-17T00:00:00 | Stipulated Election Agreement Stip |
| 70 | 70 | 01-RC-21027 | A | 0 | 1999-06-16T00:00:00 | Stipulated Election Agreement Stip |
| 71 | 71 | 01-RC-21028 | A | 0 | 1999-06-17T00:00:00 | Stipulated Election Agreement Stip |
| 72 | 72 | 01-RC-21029 | A | 0 | 1999-08-03T00:00:00 | Stipulated Election Agreement Stip |
| 73 | 73 | 01-RC-21030 | A | 0 | 1999-06-23T00:00:00 | Stipulated Election Agreement Stip |
| 74 | 74 | 01-RC-21031 | A | 0 | 1999-06-22T00:00:00 | Stipulated Election Agreement Stip |
| 75 | 75 | 01-RC-21032 | A | 0 | 1999-06-28T00:00:00 | Stipulated Election Agreement Stip |
| 76 | 76 | 01-RC-21033 | A | 0 | 1999-06-28T00:00:00 | Stipulated Election Agreement Stip |
| 77 | 77 | 01-RC-21034 | A | 0 | 1999-07-01T00:00:00 | Stipulated Election Agreement Stip |
| 78 | 78 | 01-RC-21035 | A | 0 | 1999-06-30T00:00:00 | Stipulated Election Agreement Stip |
| 79 | 79 | 01-RC-21036 | A | 0 | 1999-07-07T00:00:00 | Stipulated Election Agreement Stip |
| 80 | 80 | 01-RC-21038 | A | 0 | 1999-07-20T00:00:00 | Stipulated Election Agreement Stip |
| 81 | 81 | 01-RC-21039 | A | 0 | 1999-07-21T00:00:00 | Stipulated Election Agreement Stip |
| 82 | 82 | 01-RC-21040 | A | 0 | 1999-08-02T00:00:00 | Stipulated Election Agreement Stip |
| 83 | 83 | 01-RC-21043 | A | 0 | 1999-08-09T00:00:00 | Stipulated Election Agreement Stip |
| 84 | 84 | 01-RC-21044 | A | 0 | 1999-09-09T00:00:00 | Stipulated Election Agreement Stip |
| 85 | 85 | 01-RC-21045 | A | 0 | 1999-08-10T00:00:00 | Stipulated Election Agreement Stip |
| 86 | 86 | 01-RC-21046 | A | 0 | 1999-08-12T00:00:00 | Stipulated Election Agreement Stip |
| 87 | 87 | 01-RC-21047 | A | 0 | 1999-08-24T00:00:00 | Stipulated Election Agreement Stip |
| 88 | 88 | 01-RC-21048 | A | 0 | 1999-08-13T00:00:00 | Stipulated Election Agreement Stip |
| 89 | 89 | 01-RC-21050 | A | 0 | 1999-08-18T00:00:00 | Stipulated Election Agreement Stip |
| 90 | 90 | 01-RC-21051 | A | 0 | 1999-08-24T00:00:00 | Stipulated Election Agreement Stip |
| 91 | 91 | 01-RC-21052 | A | 0 | 1999-08-24T00:00:00 | Stipulated Election Agreement Stip |
| 92 | 92 | 01-RC-21053 | A | 0 | 1999-08-24T00:00:00 | Stipulated Election Agreement Stip |
| 93 | 93 | 01-RC-21055 | A | 0 | 1999-08-24T00:00:00 | Stipulated Election Agreement Stip |
| 94 | 94 | 01-RC-21056 | A | 0 | 1999-08-25T00:00:00 | Stipulated Election Agreement Stip |
| 95 | 95 | 01-RC-21057 | A | 0 | 1999-08-31T00:00:00 | Stipulated Election Agreement Stip |
| 96 | 96 | 01-RC-21058 | A | 0 | 1999-09-03T00:00:00 | Stipulated Election Agreement Stip |
| 97 | 97 | 01-RC-21059 | A | 0 | 1999-08-31T00:00:00 | Stipulated Election Agreement Stip |
| 98 | 98 | 01-RC-21060 | A | 0 | 1999-09-02T00:00:00 | Stipulated Election Agreement Stip |
| 99 | 99 | 01-RC-21061 | A | 0 | 1999-08-26T00:00:00 | Stipulated Election Agreement Stip |
| 100 | 100 | 01-RC-21064 | A | 0 | 1999-10-14T00:00:00 | Stipulated Election Agreement Stip |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "r_elect_agreement" (
"r_case_number" text,
"unit_id" text,
"action_sequence" integer,
"date_approved" text,
"election_agreement_type" text,
FOREIGN KEY (r_case_number, unit_id) REFERENCES r_bargaining_unit (r_case_number, unit_id),
FOREIGN KEY ([election_agreement_type]) REFERENCES[l_r_elect_agree_type] ([election_agreement_type])
);