r_action

✎ View and edit SQL

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

Next page

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)
);