r_action
Download this data as a CSV Spreadsheet (All Rows)
Link | rowid ▼ | r_case_number | unit_id | action_sequence | recurrence | action_table_code | action_field_code | action_date | date_entered | action_control |
---|---|---|---|---|---|---|---|---|---|---|
1 | 1 | 01-AC-00093 | A | 0 | 0 | RCASE | Filed | 1999-12-13T00:00:00 | 1999-12-14T19:27:00 | 2229 |
2 | 2 | 01-AC-00093 | A | 0 | 0 | RCLOS | Close | 2000-02-09T00:00:00 | 2000-02-09T09:05:00 | 2480 |
3 | 3 | 01-AC-00093 | A | 0 | 0 | RDISM | Lettr | 2000-01-19T00:00:00 | 2000-01-19T09:51:00 | 2373 |
4 | 4 | 01-AC-00093 | A | 0 | 0 | RPRHR | Notic | 1999-12-28T00:00:00 | 1999-12-28T21:05:00 | 2275 |
5 | 5 | 01-AC-00094 | A | 0 | 0 | RCASE | Filed | 2001-05-31T00:00:00 | 2001-05-31T09:53:00 | 4902 |
6 | 6 | 01-AC-00094 | A | 0 | 0 | RCLOS | Close | 2001-08-23T00:00:00 | 2001-08-23T08:28:00 | 5248 |
7 | 7 | 01-AC-00094 | A | 0 | 0 | RPRHR | Close | 2001-07-20T00:00:00 | 2001-07-24T10:55:00 | 5137 |
8 | 8 | 01-AC-00094 | A | 0 | 0 | RPRHR | HORpt | 2001-07-23T00:00:00 | 2001-07-24T10:55:00 | 5137 |
9 | 9 | 01-AC-00094 | A | 0 | 0 | RPRHR | Notic | 2001-07-11T00:00:00 | 2001-07-11T10:04:00 | 5090 |
10 | 10 | 01-AC-00094 | A | 0 | 0 | RPRHR | Open | 2001-07-20T00:00:00 | 2001-07-24T10:55:00 | 5137 |
11 | 11 | 01-AC-00094 | A | 0 | 0 | RPRRD | Issue | 2001-08-02T00:00:00 | 2001-08-02T15:57:00 | 5174 |
12 | 12 | 01-AC-00095 | A | 0 | 0 | RCASE | Filed | 2001-06-29T00:00:00 | 2001-06-29T09:48:00 | 5056 |
13 | 13 | 01-AC-00095 | A | 0 | 0 | RCLOS | Close | 2001-10-10T00:00:00 | 2001-10-12T10:37:00 | 5472 |
14 | 14 | 01-AC-00095 | A | 0 | 0 | RWITH | Appr | 2001-10-10T00:00:00 | 2001-10-12T10:36:00 | 5471 |
15 | 15 | 01-AC-00096 | A | 0 | 0 | RCASE | Filed | 2002-05-31T00:00:00 | 2002-05-31T08:18:00 | 6411 |
16 | 16 | 01-AC-00096 | A | 0 | 0 | RCLOS | Close | 2002-06-12T00:00:00 | 2002-06-12T11:11:00 | 6452 |
17 | 17 | 01-AC-00096 | A | 0 | 0 | RPRRD | Issue | 2002-06-12T00:00:00 | 2002-06-12T12:20:00 | 6453 |
18 | 18 | 01-AC-00097 | A | 0 | 0 | RCASE | Filed | 2003-10-07T00:00:00 | 2003-10-07T10:42:00 | 41786 |
19 | 19 | 01-AC-00097 | A | 0 | 0 | RCLOS | Close | 2003-11-05T00:00:00 | 2003-11-05T11:16:00 | 45392 |
20 | 20 | 01-AC-00097 | A | 0 | 0 | RPRRD | Issue | 2003-11-05T00:00:00 | 2003-11-05T11:15:00 | 45391 |
21 | 21 | 01-AC-00098 | A | 0 | 0 | RCASE | Filed | 2007-08-17T00:00:00 | 2007-08-17T13:34:00 | 277473 |
22 | 22 | 01-AC-00098 | A | 0 | 0 | RCLOS | Close | 2008-05-09T00:00:00 | 2008-05-09T10:56:00 | 335585 |
23 | 23 | 01-AC-00098 | A | 0 | 0 | RPRRD | Issue | 2007-09-06T00:00:00 | 2007-09-06T10:51:00 | 281692 |
24 | 24 | 01-AC-00099 | A | 0 | 0 | RCASE | Filed | 2009-01-23T00:00:00 | 2009-01-26T09:15:00 | 395874 |
25 | 25 | 01-AC-00099 | A | 0 | 0 | RCLOS | Close | 2009-02-04T00:00:00 | 2011-01-11T08:31:00 | 573348 |
26 | 26 | 01-AC-00100 | A | 0 | 0 | RCASE | Filed | 2009-07-28T00:00:00 | 2009-07-28T10:36:00 | 440395 |
27 | 27 | 01-AC-00100 | A | 0 | 0 | RCLOS | Close | 2009-08-24T00:00:00 | 2010-04-21T11:20:00 | 507241 |
28 | 28 | 01-AC-00101 | A | 0 | 0 | RCASE | Filed | 2010-04-28T00:00:00 | 2010-04-28T11:12:00 | 509002 |
29 | 29 | 01-AC-00101 | A | 0 | 0 | RCLOS | Close | 2010-12-31T00:00:00 | 2011-01-11T08:40:00 | 573349 |
30 | 30 | 01-AC-00101 | A | 0 | 0 | RPRRD | Issue | 2010-08-18T00:00:00 | 2010-08-18T09:24:00 | 537054 |
31 | 31 | 01-AC-00102 | A | 0 | 0 | RCASE | Filed | 2010-04-28T00:00:00 | 2010-04-28T13:05:00 | 509005 |
32 | 32 | 01-AC-00102 | A | 0 | 0 | RCLOS | Close | 2010-12-31T00:00:00 | 2011-01-11T08:41:00 | 573350 |
33 | 33 | 01-AC-00102 | A | 0 | 0 | RPRRD | Issue | 2010-08-18T00:00:00 | 2010-08-18T09:25:00 | 537055 |
34 | 34 | 01-RC-19536 | A | 0 | 0 | RBLCK | Block | 1991-06-17T00:00:00 | 1999-08-19T09:28:00 | 1605 |
35 | 35 | 01-RC-19536 | A | 0 | 0 | RCASE | Filed | 1991-04-10T00:00:00 | 1999-08-19T09:20:00 | 1603 |
36 | 36 | 01-RC-19536 | A | 0 | 0 | RCLOS | Close | 2002-05-10T00:00:00 | 2002-05-15T09:26:00 | 6350 |
37 | 37 | 01-RC-19536 | A | 0 | 0 | RPRHR | Open | 1991-04-24T00:00:00 | ||
38 | 38 | 01-RC-19536 | A | 0 | 0 | RPRRD | Issue | 1991-05-24T00:00:00 | 1999-08-19T09:27:00 | 1604 |
39 | 39 | 01-RC-19536 | A | 0 | 0 | RWITH | Appr | 2002-05-10T00:00:00 | 2002-05-15T09:26:00 | 6349 |
40 | 40 | 01-RC-19910 | A | 0 | 0 | RCASE | Filed | 1992-11-25T00:00:00 | 1999-03-05T20:21:00 | 81 |
41 | 41 | 01-RC-19910 | A | 0 | 0 | RCLOS | Close | 2003-11-14T00:00:00 | 2003-11-18T13:59:00 | 47091 |
42 | 42 | 01-RC-19910 | A | 0 | 0 | RPRHR | Notic | 1992-12-01T00:00:00 | ||
43 | 43 | 01-RC-19910 | A | 0 | 0 | RWITH | Appr | 2003-11-14T00:00:00 | 2003-11-18T13:59:00 | 47090 |
44 | 44 | 01-RC-19910 | A | 1 | 0 | RBLCK | Block | 1992-12-03T00:00:00 | ||
45 | 45 | 01-RC-19926 | A | 0 | 0 | RCASE | Filed | 1993-01-08T00:00:00 | 1999-03-05T13:34:00 | 127 |
46 | 46 | 01-RC-19926 | A | 0 | 0 | RCLOS | Close | 1999-11-12T00:00:00 | 1999-11-15T10:38:00 | 2120 |
47 | 47 | 01-RC-19926 | A | 0 | 0 | RPRHR | Close | 1993-03-03T00:00:00 | 1999-03-05T13:38:00 | 128 |
48 | 48 | 01-RC-19926 | A | 0 | 0 | RPRHR | HORpt | 1993-03-03T00:00:00 | 1999-03-05T13:38:00 | 128 |
49 | 49 | 01-RC-19926 | A | 0 | 0 | RPRHR | Notic | 1993-01-19T00:00:00 | 2000-03-31T13:32:00 | 2754 |
50 | 50 | 01-RC-19926 | A | 0 | 0 | RPRHR | Open | 1993-01-22T00:00:00 | ||
51 | 51 | 01-RC-19926 | A | 0 | 0 | RPRRD | BrfRc | 1993-03-25T00:00:00 | 1999-03-05T13:39:00 | 129 |
52 | 52 | 01-RC-19926 | A | 0 | 0 | RPRRD | Issue | 1993-04-23T00:00:00 | 1999-03-05T13:40:00 | 131 |
53 | 53 | 01-RC-19926 | A | 0 | 0 | RRAGR | Appr | 1993-05-06T00:00:00 | 1999-03-05T13:46:00 | 133 |
54 | 54 | 01-RC-19926 | A | 0 | 0 | RWITH | Appr | 1999-11-12T00:00:00 | 1999-11-15T10:35:00 | 2119 |
55 | 55 | 01-RC-19926 | A | 0 | 1 | RPRRD | BrfRc | 1993-03-25T00:00:00 | 1999-03-05T13:39:00 | 130 |
56 | 56 | 01-RC-19926 | A | 0 | 1 | RPRRD | Issue | 1996-11-21T00:00:00 | 1999-03-05T13:43:00 | 132 |
57 | 57 | 01-RC-19926 | A | 1 | 0 | RPRRD | Issue | 1993-04-23T00:00:00 | ||
58 | 58 | 01-RC-19926 | A | 250 | 0 | RELEC | Elect | 1993-05-20T00:00:00 | 2000-03-24T11:19:00 | 2686 |
59 | 59 | 01-RC-19980 | A | 0 | 0 | RCASE | Filed | 1993-05-07T00:00:00 | 1999-08-18T13:04:00 | 1563 |
60 | 60 | 01-RC-19980 | A | 0 | 0 | RCLOS | Close | 1999-08-16T00:00:00 | 1999-08-18T13:11:00 | 1565 |
61 | 61 | 01-RC-19980 | A | 0 | 0 | RPRHR | Notic | 1993-06-21T00:00:00 | ||
62 | 62 | 01-RC-19980 | A | 0 | 0 | RWITH | Appr | 1999-08-16T00:00:00 | 1999-08-18T13:10:00 | 1564 |
63 | 63 | 01-RC-20080 | A | 0 | 0 | RCASE | Filed | 1994-01-14T00:00:00 | 1999-03-08T09:08:00 | 174 |
64 | 64 | 01-RC-20080 | A | 0 | 0 | RCLOS | Close | 2000-01-11T00:00:00 | 2000-02-28T09:04:00 | 2544 |
65 | 65 | 01-RC-20080 | A | 0 | 0 | RPRHR | Close | 1994-02-04T00:00:00 | 1999-03-08T09:11:00 | 176 |
66 | 66 | 01-RC-20080 | A | 0 | 0 | RPRHR | HORpt | 1994-02-07T00:00:00 | 1999-03-08T09:11:00 | 176 |
67 | 67 | 01-RC-20080 | A | 0 | 0 | RPRHR | Notic | 1994-01-25T00:00:00 | 1999-12-23T19:20:00 | 2260 |
68 | 68 | 01-RC-20080 | A | 0 | 0 | RPRHR | Open | 1994-01-28T00:00:00 | ||
69 | 69 | 01-RC-20080 | A | 0 | 0 | RPRRD | BrfRc | 1994-02-11T00:00:00 | 1999-03-08T09:12:00 | 177 |
70 | 70 | 01-RC-20080 | A | 0 | 0 | RPRRD | Issue | 1994-03-11T00:00:00 | 1999-03-08T09:13:00 | 179 |
71 | 71 | 01-RC-20080 | A | 0 | 0 | RWITH | Appr | 2000-01-11T00:00:00 | 2000-02-28T09:02:00 | 2543 |
72 | 72 | 01-RC-20080 | A | 0 | 1 | RPRRD | BrfRc | 1994-02-14T00:00:00 | 1999-03-08T09:12:00 | 178 |
73 | 73 | 01-RC-20080 | A | 1 | 0 | RPRRD | Issue | 1994-03-11T00:00:00 | ||
74 | 74 | 01-RC-20106 | A | 0 | 0 | RCASE | Filed | 1994-03-10T00:00:00 | 1999-03-05T21:25:00 | 122 |
75 | 75 | 01-RC-20106 | A | 0 | 0 | RCLOS | Close | 2003-11-21T00:00:00 | 2003-12-03T11:30:00 | 49133 |
76 | 76 | 01-RC-20106 | A | 0 | 0 | RPRHR | Close | 1994-03-31T00:00:00 | 1999-03-05T21:27:00 | 123 |
77 | 77 | 01-RC-20106 | A | 0 | 0 | RPRHR | HORpt | 1994-04-01T00:00:00 | 1999-03-05T21:27:00 | 123 |
78 | 78 | 01-RC-20106 | A | 0 | 0 | RPRHR | Open | 1994-03-31T00:00:00 | ||
79 | 79 | 01-RC-20106 | A | 0 | 0 | RPRRD | BrfRc | 1994-04-07T00:00:00 | 1999-03-05T21:28:00 | 124 |
80 | 80 | 01-RC-20106 | A | 0 | 0 | RPRRD | Issue | 1994-06-08T00:00:00 | 1999-03-05T21:29:00 | 126 |
81 | 81 | 01-RC-20106 | A | 0 | 0 | RWITH | Appr | 2003-11-21T00:00:00 | 2003-12-03T11:30:00 | 49132 |
82 | 82 | 01-RC-20106 | A | 0 | 1 | RPRRD | BrfRc | 1994-04-07T00:00:00 | 1999-03-05T21:28:00 | 125 |
83 | 83 | 01-RC-20292 | A | 0 | 0 | RCASE | Filed | 1995-04-17T00:00:00 | 1999-03-04T20:58:00 | 56 |
84 | 84 | 01-RC-20292 | A | 0 | 0 | RCLOS | Close | 1999-10-01T00:00:00 | 1999-10-01T21:54:00 | 1813 |
85 | 85 | 01-RC-20292 | A | 0 | 0 | RRAGR | Appr | 1995-05-02T00:00:00 | 1999-03-04T21:00:00 | 57 |
86 | 86 | 01-RC-20292 | A | 44 | 0 | RCERT | Rep | 1999-10-01T00:00:00 | 1999-10-01T10:39:00 | 1810 |
87 | 87 | 01-RC-20292 | A | 44 | 0 | RELEC | Elect | 1995-06-01T00:00:00 | 1999-03-04T21:01:00 | 58 |
88 | 88 | 01-RC-20292 | A | 44 | 0 | ROBJ | Objec | 1995-06-06T00:00:00 | 1999-03-04T21:04:00 | 59 |
89 | 89 | 01-RC-20292 | A | 44 | 1 | ROBJ | Objec | 1995-06-08T00:00:00 | 1999-03-08T21:02:00 | 231 |
90 | 90 | 01-RC-20292 | A | 44 | 1 | RTALL | Tally | 1995-06-01T00:00:00 | 1999-03-08T20:56:00 | 228 |
91 | 91 | 01-RC-20292 | A | 44 | 2 | ROBJ | Objec | 1995-10-20T00:00:00 | 1999-03-04T21:07:00 | 61 |
92 | 92 | 01-RC-20292 | A | 44 | 2 | RTALL | Tally | 1999-09-23T00:00:00 | 1999-10-01T10:38:00 | 1809 |
93 | 93 | 01-RC-20309 | A | 0 | 0 | RBLCK | Block | 2000-02-11T00:00:00 | 2000-02-17T11:39:00 | 2512 |
94 | 94 | 01-RC-20309 | A | 0 | 0 | RCASE | Filed | 1995-05-31T00:00:00 | 1999-03-08T10:39:00 | 213 |
95 | 95 | 01-RC-20309 | A | 0 | 0 | RCLOS | Close | 2000-02-23T00:00:00 | 2000-02-23T11:16:00 | 2533 |
96 | 96 | 01-RC-20309 | A | 0 | 0 | RPRHR | Close | 1995-07-19T00:00:00 | 1999-03-08T10:43:00 | 215 |
97 | 97 | 01-RC-20309 | A | 0 | 0 | RPRHR | HORpt | 1995-07-20T00:00:00 | 1999-03-08T10:43:00 | 215 |
98 | 98 | 01-RC-20309 | A | 0 | 0 | RPRHR | Notic | 1995-06-09T00:00:00 | 1999-03-08T10:43:00 | 216 |
99 | 99 | 01-RC-20309 | A | 0 | 0 | RPRHR | Open | 1995-06-19T00:00:00 | ||
100 | 100 | 01-RC-20309 | A | 0 | 0 | RPRRD | BrfRc | 1995-08-09T00:00:00 | 1999-03-08T10:44:00 | 217 |
CREATE TABLE "r_action" ( "r_case_number" text, "unit_id" text, "action_sequence" integer, "recurrence" integer, "action_table_code" text, "action_field_code" text, "action_date" text, "date_entered" text, "action_control" integer, FOREIGN KEY (r_case_number, unit_id) REFERENCES r_bargaining_unit (r_case_number, unit_id) );