home / chips

r_blocking

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ case_number block_date blocking_case_number
1 1 01-RD-001534 1991-02-04 01-CA-028562-001
2 2 01-RD-001534 1991-05-20 01-CA-028562-001
3 3 01-RD-001534 1991-06-10 01-CA-028562-001
4 4 01-RD-001534 1991-06-17 01-CA-028562-001
5 5 01-RD-001534 1991-08-20 01-CA-028562-001
6 6 01-RD-001539 1988-02-05 01-CA-024850-001
7 7 01-RD-001542 1988-02-11 01-CA-025712-001
8 8 01-RD-001542 1988-08-26 01-CA-025712-001
9 9 01-RD-001544 1988-03-01 01-CA-025066-001
10 10 01-RD-001544 1988-03-09 01-CA-025066-001
11 11 01-RD-001547 1988-03-09 01-CA-025374-001
12 12 01-RD-001549 1988-03-28 01-CA-024166-001
13 13 01-RD-001553 1988-06-08 01-CA-025544-001
14 14 01-RD-001557 1988-11-09 01-CA-025902-001
15 15 01-RD-001561 1988-06-06 01-CA-025561-001
16 16 01-RD-001565 1988-07-18 01-CA-025640-001
17 17 01-RD-001571 1988-09-29 01-CA-025807-001
18 18 01-RD-001572 1988-10-18 01-CA-025844-001
19 19 01-RD-001573 1988-10-17 01-CA-025985-001
20 20 01-RD-001573 1988-10-26 01-CA-025985-001
21 21 01-RD-001573 1988-12-09 01-CA-025985-001
22 22 01-RD-001575 1988-11-02 01-CA-025897-001
23 23 01-RD-001578 1988-11-10 01-CA-025921-001
24 24 01-RD-001583 1988-12-13 01-CA-025995-001
25 25 01-RD-001588 1988-12-22 01-CA-026033-001
26 26 01-RD-001588 1989-01-10 01-CA-026033-001
27 27 01-RD-001589 1988-12-29 01-CA-026040-001
28 28 01-RD-001594 1989-03-16 01-CA-026457-001
29 29 01-RD-001594 1989-04-10 01-CA-026457-001
30 30 01-RD-001594 1989-06-16 01-CA-026457-001
31 31 01-RD-001602 1989-06-30 01-CA-026343-001
32 32 01-RD-001604 1989-10-31 01-CA-026782-001
33 33 01-RD-001608 1989-07-05 01-CA-026483-001
34 34 01-RD-001611 1989-09-01 01-CA-026698-001
35 35 01-RD-001611 1989-09-22 01-CA-026698-001
36 36 01-RD-001613 1989-09-05 01-CA-026643-001
37 37 01-RD-001614 1989-09-14 01-CA-026676-001
38 38 01-RD-001615 1989-09-11 01-CA-026587-001
39 39 01-RD-001629 1989-12-15 01-CA-026912-001
40 40 01-RD-001636 1990-02-27 01-CA-026395-001
41 41 01-RD-001637 1990-05-10 01-CA-027293-101
42 42 01-RD-001642 1990-06-07 01-CB-007286-001
43 43 01-RD-001646 1990-06-04 01-CA-027933-001
44 44 01-RD-001646 1991-01-03 01-CA-027933-001
45 45 01-RD-001646 1991-01-14 01-CA-027933-001
46 46 01-RD-001649 1990-05-11 01-CA-027291-001
47 47 01-RD-001650 1990-06-06 01-CA-027328-001
48 48 01-RD-001656 1990-07-11 01-CB-007322-001
49 49 01-RC-017896 1983-07-15 01-CA-021196-1-2
50 50 01-RC-018015 1983-09-30 01-CA-021429-001
51 51 01-RC-018734 1986-06-17 01-CA-023966-001
52 52 01-RC-018734 1986-06-20 01-CA-023966-001
53 53 01-RC-018734 1988-06-17 01-CA-023966-001
54 54 01-RC-018734 1989-01-23 01-CA-023966-001
55 55 01-RC-018878 1987-06-17 01-CA-024709-001
56 56 01-RC-018950 1987-09-02 01-CA-025569-001
57 57 01-RC-018950 1988-06-13 01-CA-025569-001
58 58 01-RC-019001 1988-03-17 01-CA-025259-001
59 59 01-RC-019001 1988-06-15 01-CA-025259-001
60 60 01-RC-019003 1988-02-29 01-CA-025311-000
61 61 01-RC-019003 1988-07-19 01-CA-025311-000
62 62 01-RC-019004 1988-02-28 01-CA-025311-001
63 63 01-RC-019005 1988-02-28 01-CA-025311-001
64 64 01-RC-019006 1988-02-28 01-CA-025311-001
65 65 01-RC-019009 1988-03-03 01-CB-006733-001
66 66 01-RC-019033 1988-03-04 01-CA-025490-001
67 67 01-RC-019033 1988-05-10 01-CA-025490-001
68 68 01-RC-019037 1988-02-19 01-CA-025457-001
69 69 01-RC-019052 1988-03-30 01-CA-027233-001
70 70 01-RC-019052 1988-05-12 01-CA-027233-001
71 71 01-RC-019052 1988-06-07 01-CA-027233-001
72 72 01-RC-019052 1988-11-18 01-CA-027233-001
73 73 01-RC-019052 1990-04-13 01-CA-027233-001
74 74 01-RC-019052 1990-06-18 01-CA-027233-001
75 75 01-RC-019058 1988-03-31 01-CC-002239-001
76 76 01-RC-019058 1988-07-12 01-CC-002239-001
77 77 01-RC-019058 1988-11-16 01-CC-002239-001
78 78 01-RC-019065 1988-07-01 01-CA-025475-001
79 79 01-RC-019069 1988-06-07 01-CA-026426-001
80 80 01-RC-019069 1989-06-05 01-CA-026426-001
81 81 01-RC-019076 1988-05-24 01-CA-025531-001
82 82 01-RC-019100 1988-09-21 01-CA-023792-001
83 83 01-RC-019100 1988-09-22 01-CA-023792-001
84 84 01-RC-019117 1988-08-01 01-CA-025684-001
85 85 01-RC-019126 1988-08-22 01-CA-025689-001
86 86 01-RC-019145 1989-01-01 01-CA-026009-001
87 87 01-RC-019152 1988-12-28 01-CA-026271-001
88 88 01-RC-019152 1989-04-05 01-CA-026271-001
89 89 01-RC-019164 1988-11-04 01-CA-025913-001
90 90 01-RC-019166 1988-10-17 01-CA-025883-001
91 91 01-RC-019166 1988-10-18 01-CA-025883-001
92 92 01-RC-019166 1988-10-26 01-CA-025883-001
93 93 01-RC-019168 1988-11-29 01-CA-025941-001
94 94 01-RC-019169 1988-10-27 01-CA-025929-001
95 95 01-RC-019169 1988-11-18 01-CA-025929-001
96 96 01-RC-019171 1988-11-18 01-CA-025953-001
97 97 01-RC-019184 1988-12-15 01-CB-006935-001
98 98 01-RC-019204 1989-03-17 01-CA-026225-001
99 99 01-RC-019217 1989-02-21 01-CA-026155-001
100 100 01-RC-019222 1989-03-16 01-CA-026187-001

Next page

CREATE TABLE "r_blocking" (
   [case_number] TEXT REFERENCES [r_master]([case_number]),
   [block_date] TEXT,
   [blocking_case_number] TEXT,
   FOREIGN KEY([blocking_case_number]) REFERENCES [c_master]([case_number])
);
Powered by Datasette · Queries took 9.081ms