r_block_cases

21,130 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ r_case_number unit_id action_sequence sequence recurrence c_case_number req_proceed_filed req_proceed_party req_proceed_withdrawn
1 1 01-RC-19536 A 0 -1 0        
2 2 01-RC-19910 A 0 0 0 01-CA-29985-001      
3 3 01-RC-20309 A 0 -1 0        
4 4 01-RC-20309 A 0 0 0 01-CA-37885-001      
5 5 01-RC-20310 A 0 -1 0        
6 6 01-RC-20310 A 0 0 0 01-CA-37885-001      
7 7 01-RC-20360 A 0 -1 0        
8 8 01-RC-20460 A 0 -1 0        
9 9 01-RC-20460 A 0 0 0 01-CA-34029-001      
10 10 01-RC-20463 A 0 -1 0        
11 11 01-RC-20463 A 0 0 0 01-CA-34171-001      
12 12 01-RC-20463 A 1 -1 0        
13 13 01-RC-20463 A 2 -1 0        
14 14 01-RC-20538 A 0 -1 0        
15 15 01-RC-20600 A 0 -1 0        
16 16 01-RC-20622 A 0 -1 0        
17 17 01-RC-20622 A 0 0 0 01-CA-35025-001      
18 18 01-RC-20626 A 0 -1 0        
19 19 01-RC-20634 A 0 -1 0        
20 20 01-RC-20649 A 0 -1 0   1997-07-30T00:00:00 Petitioner PET  
21 21 01-RC-20815 A 0 -1 0        
22 22 01-RC-20826 A 0 -1 0 01-CA-36244-001 1998-06-27T00:00:00    
23 23 01-RC-20826 A 0 0 0 01-CA-36244-001      
24 24 01-RC-20869 A 0 -1 0        
25 25 01-RC-20880 A 0 -1 0        
26 26 01-RC-20897 A 0 -1 0   1998-10-27T00:00:00 Petitioner PET  
27 27 01-RC-20916 A 0 -1 0        
28 28 01-RC-20916 A 0 0 0 01-CA-36768-001      
29 29 01-RC-20922 A 0 -1 0        
30 30 01-RC-20922 A 0 0 0 01-CA-36756-001      
31 31 01-RC-20924 A 0 -1 0        
32 32 01-RC-20924 A 0 0 0 01-CA-36774-001      
33 33 01-RC-20935 A 0 -1 0 01-CA-36715-001 1999-02-01T00:00:00 Petitioner PET  
34 34 01-RC-20935 A 0 -1 1 01-CB-09342-001 1999-02-26T00:00:00 Petitioner PET  
35 35 01-RC-20935 A 0 0 0 01-CA-36715-001      
36 36 01-RC-20935 A 0 1 0 01-CB-09342-001      
37 37 01-RC-20935 A 1 -1 0        
38 38 01-RC-20935 A 1 0 0 01-CB-09433-001      
39 39 01-RC-20935 A 2 -1 0        
40 40 01-RC-20935 A 2 0 0 01-CA-37279-001      
41 41 01-RC-20941 A 0 -1 0        
42 42 01-RC-20941 A 0 1 0 01-CA-36845-001      
43 43 01-RC-20941 A 0 2 0 01-CA-36861-001      
44 44 01-RC-20941 A 0 3 0 01-CA-36870-001      
45 45 01-RC-20941 A 0 4 0 01-CA-36880-001      
46 46 01-RC-20973 A 0 -1 0   1999-02-16T00:00:00 Petitioner PET  
47 47 01-RC-20984 A 0 -1 0 01-CA-37265-001 1999-05-18T00:00:00 Employer EMP  
48 48 01-RC-20984 A 0 0 0 01-CA-37265-001      
49 49 01-RC-20996 A 0 -1 0        
50 50 01-RC-20996 A 0 0 0 01-CA-37272-001      
51 51 01-RC-21006 A 0 -1 0        
52 52 01-RC-21006 A 0 0 0 01-CA-37206-001      
53 53 01-RC-21006 A 0 1 0 01-CA-37069-001      
54 54 01-RC-21015 A 0 -1 0        
55 55 01-RC-21015 A 0 0 0 01-CA-37309-001      
56 56 01-RC-21025 A 0 -1 0        
57 57 01-RC-21063 A 0 -1 0        
58 58 01-RC-21063 A 0 0 0 01-CA-37536-001      
59 59 01-RC-21102 A 0 -1 0 01-CA-37694-001 1999-11-09T00:00:00 Petitioner PET 1999-12-03T00:00:00
60 60 01-RC-21102 A 0 0 0 01-CA-37694-001      
61 61 01-RC-21152 A 0 -1 0        
62 62 01-RC-21152 A 0 0 0 01-CA-38280-001      
63 63 01-RC-21158 A 0 -1 0        
64 64 01-RC-21158 A 0 0 0 01-CA-38090-001      
65 65 01-RC-21158 A 0 1 0 01-CA-38091-001      
66 66 01-RC-21158 A 1 -1 0        
67 67 01-RC-21158 A 1 0 0 01-CA-38820-001      
68 68 01-RC-21174 A 0 -1 0        
69 69 01-RC-21174 A 0 0 0 01-CA-38118-001      
70 70 01-RC-21193 A 0 -1 0 01-CA-38149-001 2000-08-22T00:00:00 Petitioner PET  
71 71 01-RC-21193 A 0 0 0 01-CA-38149-001      
72 72 01-RC-21200 A 0 -1 0        
73 73 01-RC-21200 A 0 0 0 01-CA-38003-001      
74 74 01-RC-21207 A 0 -1 0        
75 75 01-RC-21207 A 0 1 0 01-CA-38283-001      
76 76 01-RC-21207 A 0 2 0 01-CA-38284-001      
77 77 01-RC-21207 A 0 3 0 01-CA-38542-001      
78 78 01-RC-21217 A 0 -1 0 01-CA-38358-001 2000-08-07T00:00:00 Petitioner PET  
79 79 01-RC-21217 A 0 0 0 01-CA-38358-001      
80 80 01-RC-21236 A 0 -1 0 01-CA-38349-001 2000-09-06T00:00:00 Petitioner PET  
81 81 01-RC-21236 A 0 0 0 01-CA-38349-001      
82 82 01-RC-21240 A 0 -1 0 01-CA-38433-001 2000-09-25T00:00:00 Petitioner PET  
83 83 01-RC-21240 A 0 -1 1 01-CA-38438-001 2000-09-25T00:00:00 Petitioner PET  
84 84 01-RC-21240 A 0 -1 2 01-CA-38489-001 2000-10-23T00:00:00 Petitioner PET  
85 85 01-RC-21240 A 0 -1 3 01-CA-38541-001 2000-10-23T00:00:00 Petitioner PET  
86 86 01-RC-21240 A 0 0 0 01-CA-38433-001      
87 87 01-RC-21240 A 0 1 0 01-CA-38438-001      
88 88 01-RC-21240 A 0 2 0 01-CA-38489-001      
89 89 01-RC-21240 A 0 3 0 01-CA-38541-001      
90 90 01-RC-21240 A 1 -1 0        
91 91 01-RC-21240 A 1 0 0 01-CA-38433-001      
92 92 01-RC-21240 A 2 -1 0        
93 93 01-RC-21240 A 2 0 0 01-CA-39199-001      
94 94 01-RC-21240 A 3 -1 0        
95 95 01-RC-21240 A 3 0 0 01-CA-39238-001      
96 96 01-RC-21241 A 0 -1 0 01-CA-38438-001 2000-09-25T00:00:00 Petitioner PET  
97 97 01-RC-21241 A 0 -1 1 01-CA-38433-001 2000-09-25T00:00:00 Petitioner PET  
98 98 01-RC-21241 A 0 -1 2 01-CA-38489-001 2000-10-23T00:00:00 Petitioner PET  
99 99 01-RC-21241 A 0 -1 3 01-CA-38541-001 2000-10-23T00:00:00 Petitioner PET  
100 100 01-RC-21241 A 0 0 0 01-CA-38433-001      

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "r_block_cases" (
    "r_case_number" text,
    "unit_id" text,
    "action_sequence" integer,
    "sequence" integer,
    "recurrence" integer,
    "c_case_number" text,
    "req_proceed_filed" text,
    "req_proceed_party" text,
    "req_proceed_withdrawn" text,
    FOREIGN KEY ([req_proceed_party]) REFERENCES[l_case_party] ([party]),
    FOREIGN KEY (r_case_number, unit_id) REFERENCES r_bargaining_unit (r_case_number, unit_id)
);