r_block

10,346 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ r_case_number unit_id action_sequence recurrence blocked unblocked reqproc_board_filed_date reqproc_board_party reqproc_board_deter_date reqproc_board_deter
1 1 01-RC-19536 A 0 0 1991-06-17T00:00:00          
2 2 01-RC-19910 A 0 0 1992-12-03T00:00:00          
3 3 01-RC-20309 A 0 0 2000-02-11T00:00:00          
4 4 01-RC-20310 A 0 0 2000-02-11T00:00:00 2000-02-23T00:00:00        
5 5 01-RC-20360 A 0 0 1995-09-20T00:00:00          
6 6 01-RC-20460 A 0 0 1996-05-16T00:00:00 2003-11-05T00:00:00        
7 7 01-RC-20463 A 0 0 1996-07-08T00:00:00          
8 8 01-RC-20463 A 1 0 1996-08-21T00:00:00          
9 9 01-RC-20463 A 2 0 1996-09-09T00:00:00          
10 10 01-RC-20538 A 0 0 1996-11-29T00:00:00 2003-11-10T00:00:00        
11 11 01-RC-20600 A 0 0 1997-05-20T00:00:00          
12 12 01-RC-20622 A 0 0 1997-05-20T00:00:00          
13 13 01-RC-20626 A 0 0 1997-06-27T00:00:00          
14 14 01-RC-20634 A 0 0 1997-07-11T00:00:00          
15 15 01-RC-20649 A 0 0            
16 16 01-RC-20815 A 0 0 1998-04-09T00:00:00 2000-09-14T00:00:00        
17 17 01-RC-20826 A 0 0 1998-04-30T00:00:00 2002-05-17T00:00:00        
18 18 01-RC-20869 A 0 0 1998-07-28T00:00:00          
19 19 01-RC-20880 A 0 0 1998-08-20T00:00:00          
20 20 01-RC-20897 A 0 0            
21 21 01-RC-20916 A 0 0 1998-11-16T00:00:00 2003-11-06T00:00:00        
22 22 01-RC-20922 A 0 0 1998-11-17T00:00:00          
23 23 01-RC-20924 A 0 0 1998-11-27T00:00:00          
24 24 01-RC-20935 A 0 0 1998-11-18T00:00:00 1999-02-26T00:00:00        
25 25 01-RC-20935 A 0 1            
26 26 01-RC-20935 A 1 0 1999-05-11T00:00:00          
27 27 01-RC-20935 A 2 0 1999-05-26T00:00:00          
28 28 01-RC-20941 A 0 0 1998-12-29T00:00:00          
29 29 01-RC-20973 A 0 0            
30 30 01-RC-20984 A 0 0 1999-05-11T00:00:00          
31 31 01-RC-20996 A 0 0 1999-05-13T00:00:00          
32 32 01-RC-21006 A 0 0 1999-04-26T00:00:00 2003-11-07T00:00:00        
33 33 01-RC-21015 A 0 0 1999-06-18T00:00:00 1999-09-21T00:00:00        
34 34 01-RC-21025 A 0 0 1999-05-28T00:00:00 2002-05-22T00:00:00        
35 35 01-RC-21063 A 0 0 1999-09-01T00:00:00          
36 36 01-RC-21102 A 0 0 1999-12-03T00:00:00 2000-01-19T00:00:00        
37 37 01-RC-21152 A 0 0 2003-07-15T00:00:00          
38 38 01-RC-21158 A 0 0 2000-04-25T00:00:00 2001-02-21T00:00:00        
39 39 01-RC-21158 A 1 0 2001-02-13T00:00:00 2001-02-21T00:00:00        
40 40 01-RC-21174 A 0 0 2000-05-03T00:00:00 2001-02-16T00:00:00        
41 41 01-RC-21193 A 0 0 2000-05-23T00:00:00 2000-08-22T00:00:00        
42 42 01-RC-21200 A 0 0 2000-06-08T00:00:00 2000-09-14T00:00:00        
43 43 01-RC-21207 A 0 0 2000-07-05T00:00:00 2002-01-09T00:00:00        
44 44 01-RC-21217 A 0 0 2000-08-07T00:00:00 2000-08-07T00:00:00        
45 45 01-RC-21236 A 0 0 2000-08-01T00:00:00 2000-09-06T00:00:00        
46 46 01-RC-21240 A 0 0 2000-09-15T00:00:00 2000-09-25T00:00:00        
47 47 01-RC-21240 A 0 1            
48 48 01-RC-21240 A 0 2            
49 49 01-RC-21240 A 0 3            
50 50 01-RC-21240 A 1 0 2000-11-08T00:00:00          
51 51 01-RC-21240 A 2 0 2001-07-17T00:00:00          
52 52 01-RC-21240 A 3 0 2001-08-10T00:00:00          
53 53 01-RC-21241 A 0 0 2000-09-15T00:00:00 2000-09-25T00:00:00        
54 54 01-RC-21241 A 0 1            
55 55 01-RC-21241 A 0 2            
56 56 01-RC-21241 A 0 3            
57 57 01-RC-21241 A 1 0 2000-11-08T00:00:00          
58 58 01-RC-21241 A 2 0 2001-07-17T00:00:00          
59 59 01-RC-21241 A 3 0 2001-08-10T00:00:00          
60 60 01-RC-21242 A 0 0 2000-09-15T00:00:00 2000-09-25T00:00:00        
61 61 01-RC-21242 A 0 1            
62 62 01-RC-21242 A 0 2            
63 63 01-RC-21242 A 0 3            
64 64 01-RC-21242 A 0 4            
65 65 01-RC-21242 A 0 5            
66 66 01-RC-21243 A 0 0 2000-10-25T00:00:00 2000-11-14T00:00:00        
67 67 01-RC-21260 A 0 0            
68 68 01-RC-21272 A 0 0 2000-11-29T00:00:00 2001-10-17T00:00:00        
69 69 01-RC-21272 A 1 0 2001-04-19T00:00:00 2001-10-17T00:00:00        
70 70 01-RC-21274 A 0 0 2000-11-13T00:00:00 2000-11-16T00:00:00        
71 71 01-RC-21280 A 0 0 2000-12-11T00:00:00 2001-03-27T00:00:00        
72 72 01-RC-21283 A 0 0 2000-12-06T00:00:00 2001-01-26T00:00:00        
73 73 01-RC-21286 A 0 0 2000-12-08T00:00:00 2000-12-08T00:00:00        
74 74 01-RC-21286 A 1 0 2001-02-02T00:00:00 2002-04-26T00:00:00        
75 75 01-RC-21286 A 2 0 2001-05-11T00:00:00 2002-04-26T00:00:00        
76 76 01-RC-21287 A 0 0 2000-12-15T00:00:00          
77 77 01-RC-21287 A 1 0 2001-02-15T00:00:00          
78 78 01-RC-21290 A 0 0 2000-12-13T00:00:00 2000-12-14T00:00:00        
79 79 01-RC-21290 A 1 0 2000-12-27T00:00:00 2001-01-10T00:00:00        
80 80 01-RC-21291 A 0 0 2001-01-11T00:00:00 2001-01-18T00:00:00        
81 81 01-RC-21299 A 0 0 2001-01-31T00:00:00          
82 82 01-RC-21309 A 0 0 2001-02-01T00:00:00 2001-05-21T00:00:00        
83 83 01-RC-21309 A 1 0 2001-03-21T00:00:00 2001-05-21T00:00:00        
84 84 01-RC-21309 A 2 0 2001-03-28T00:00:00 2001-05-21T00:00:00        
85 85 01-RC-21317 A 0 0 2001-02-14T00:00:00 2001-02-21T00:00:00        
86 86 01-RC-21326 A 0 0 2001-03-23T00:00:00 2001-03-23T00:00:00        
87 87 01-RC-21331 A 0 0 2001-03-28T00:00:00 2001-06-27T00:00:00        
88 88 01-RC-21343 A 0 0 2001-05-11T00:00:00 2001-08-21T00:00:00        
89 89 01-RC-21344 A 0 0 2001-05-11T00:00:00 2001-08-21T00:00:00        
90 90 01-RC-21345 A 0 0 2001-05-11T00:00:00 2001-10-23T00:00:00        
91 91 01-RC-21347 A 0 0 2001-05-11T00:00:00 2001-08-20T00:00:00        
92 92 01-RC-21348 A 0 0 2001-05-11T00:00:00 2001-08-20T00:00:00        
93 93 01-RC-21349 A 0 0 2001-05-22T00:00:00 2001-05-24T00:00:00        
94 94 01-RC-21349 A 0 1            
95 95 01-RC-21351 A 0 0 2001-05-11T00:00:00 2001-07-18T00:00:00        
96 96 01-RC-21351 A 1 0 2001-07-23T00:00:00 2001-08-21T00:00:00        
97 97 01-RC-21352 A 0 0 2001-05-11T00:00:00 2001-08-20T00:00:00        
98 98 01-RC-21356 A 0 0 2001-05-11T00:00:00 2001-08-20T00:00:00        
99 99 01-RC-21357 A 0 0 2001-05-11T00:00:00 2001-09-19T00:00:00        
100 100 01-RC-21359 A 0 0 2001-05-11T00:00:00          

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "r_block" (
    "r_case_number" text,
    "unit_id" text,
    "action_sequence" integer,
    "recurrence" integer,
    "blocked" text,
    "unblocked" text,
    "reqproc_board_filed_date" text,
    "reqproc_board_party" text,
    "reqproc_board_deter_date" text,
    "reqproc_board_deter" text,
    FOREIGN KEY ([reqproc_board_party]) REFERENCES[l_case_party] ([party]),
    FOREIGN KEY ([reqproc_board_deter]) REFERENCES[l_r_block_determination] ([block_determination]),
    FOREIGN KEY (r_case_number, unit_id) REFERENCES r_bargaining_unit (r_case_number, unit_id)
);