r_block
10,346 rows
Suggested facets: unit_id, action_sequence, recurrence, blocked (date), unblocked (date)
| r_case_number | unit_id | action_sequence | recurrence | blocked | unblocked | reqproc_board_filed_date | reqproc_board_party | reqproc_board_deter_date | reqproc_board_deter |
|---|---|---|---|---|---|---|---|---|---|
| 01-RC-19536 | A | 0 | 0 | 1991-06-17 | |||||
| 01-RC-19910 | A | 0 | 0 | 1992-12-03 | |||||
| 01-RC-20309 | A | 0 | 0 | 2000-02-11 | |||||
| 01-RC-20310 | A | 0 | 0 | 2000-02-11 | 2000-02-23 | ||||
| 01-RC-20360 | A | 0 | 0 | 1995-09-20 | |||||
| 01-RC-20460 | A | 0 | 0 | 1996-05-16 | 2003-11-05 | ||||
| 01-RC-20463 | A | 0 | 0 | 1996-07-08 | |||||
| 01-RC-20463 | A | 1 | 0 | 1996-08-21 | |||||
| 01-RC-20463 | A | 2 | 0 | 1996-09-09 | |||||
| 01-RC-20538 | A | 0 | 0 | 1996-11-29 | 2003-11-10 | ||||
| 01-RC-20600 | A | 0 | 0 | 1997-05-20 | |||||
| 01-RC-20622 | A | 0 | 0 | 1997-05-20 | |||||
| 01-RC-20626 | A | 0 | 0 | 1997-06-27 | |||||
| 01-RC-20634 | A | 0 | 0 | 1997-07-11 | |||||
| 01-RC-20649 | A | 0 | 0 | ||||||
| 01-RC-20815 | A | 0 | 0 | 1998-04-09 | 2000-09-14 | ||||
| 01-RC-20826 | A | 0 | 0 | 1998-04-30 | 2002-05-17 | ||||
| 01-RC-20869 | A | 0 | 0 | 1998-07-28 | |||||
| 01-RC-20880 | A | 0 | 0 | 1998-08-20 | |||||
| 01-RC-20897 | A | 0 | 0 | ||||||
| 01-RC-20916 | A | 0 | 0 | 1998-11-16 | 2003-11-06 | ||||
| 01-RC-20922 | A | 0 | 0 | 1998-11-17 | |||||
| 01-RC-20924 | A | 0 | 0 | 1998-11-27 | |||||
| 01-RC-20935 | A | 0 | 0 | 1998-11-18 | 1999-02-26 | ||||
| 01-RC-20935 | A | 0 | 1 | ||||||
| 01-RC-20935 | A | 1 | 0 | 1999-05-11 | |||||
| 01-RC-20935 | A | 2 | 0 | 1999-05-26 | |||||
| 01-RC-20941 | A | 0 | 0 | 1998-12-29 | |||||
| 01-RC-20973 | A | 0 | 0 | ||||||
| 01-RC-20984 | A | 0 | 0 | 1999-05-11 | |||||
| 01-RC-20996 | A | 0 | 0 | 1999-05-13 | |||||
| 01-RC-21006 | A | 0 | 0 | 1999-04-26 | 2003-11-07 | ||||
| 01-RC-21015 | A | 0 | 0 | 1999-06-18 | 1999-09-21 | ||||
| 01-RC-21025 | A | 0 | 0 | 1999-05-28 | 2002-05-22 | ||||
| 01-RC-21063 | A | 0 | 0 | 1999-09-01 | |||||
| 01-RC-21102 | A | 0 | 0 | 1999-12-03 | 2000-01-19 | ||||
| 01-RC-21152 | A | 0 | 0 | 2003-07-15 | |||||
| 01-RC-21158 | A | 0 | 0 | 2000-04-25 | 2001-02-21 | ||||
| 01-RC-21158 | A | 1 | 0 | 2001-02-13 | 2001-02-21 | ||||
| 01-RC-21174 | A | 0 | 0 | 2000-05-03 | 2001-02-16 | ||||
| 01-RC-21193 | A | 0 | 0 | 2000-05-23 | 2000-08-22 | ||||
| 01-RC-21200 | A | 0 | 0 | 2000-06-08 | 2000-09-14 | ||||
| 01-RC-21207 | A | 0 | 0 | 2000-07-05 | 2002-01-09 | ||||
| 01-RC-21217 | A | 0 | 0 | 2000-08-07 | 2000-08-07 | ||||
| 01-RC-21236 | A | 0 | 0 | 2000-08-01 | 2000-09-06 | ||||
| 01-RC-21240 | A | 0 | 0 | 2000-09-15 | 2000-09-25 | ||||
| 01-RC-21240 | A | 0 | 1 | ||||||
| 01-RC-21240 | A | 0 | 2 | ||||||
| 01-RC-21240 | A | 0 | 3 | ||||||
| 01-RC-21240 | A | 1 | 0 | 2000-11-08 | |||||
| 01-RC-21240 | A | 2 | 0 | 2001-07-17 | |||||
| 01-RC-21240 | A | 3 | 0 | 2001-08-10 | |||||
| 01-RC-21241 | A | 0 | 0 | 2000-09-15 | 2000-09-25 | ||||
| 01-RC-21241 | A | 0 | 1 | ||||||
| 01-RC-21241 | A | 0 | 2 | ||||||
| 01-RC-21241 | A | 0 | 3 | ||||||
| 01-RC-21241 | A | 1 | 0 | 2000-11-08 | |||||
| 01-RC-21241 | A | 2 | 0 | 2001-07-17 | |||||
| 01-RC-21241 | A | 3 | 0 | 2001-08-10 | |||||
| 01-RC-21242 | A | 0 | 0 | 2000-09-15 | 2000-09-25 | ||||
| 01-RC-21242 | A | 0 | 1 | ||||||
| 01-RC-21242 | A | 0 | 2 | ||||||
| 01-RC-21242 | A | 0 | 3 | ||||||
| 01-RC-21242 | A | 0 | 4 | ||||||
| 01-RC-21242 | A | 0 | 5 | ||||||
| 01-RC-21243 | A | 0 | 0 | 2000-10-25 | 2000-11-14 | ||||
| 01-RC-21260 | A | 0 | 0 | ||||||
| 01-RC-21272 | A | 0 | 0 | 2000-11-29 | 2001-10-17 | ||||
| 01-RC-21272 | A | 1 | 0 | 2001-04-19 | 2001-10-17 | ||||
| 01-RC-21274 | A | 0 | 0 | 2000-11-13 | 2000-11-16 | ||||
| 01-RC-21280 | A | 0 | 0 | 2000-12-11 | 2001-03-27 | ||||
| 01-RC-21283 | A | 0 | 0 | 2000-12-06 | 2001-01-26 | ||||
| 01-RC-21286 | A | 0 | 0 | 2000-12-08 | 2000-12-08 | ||||
| 01-RC-21286 | A | 1 | 0 | 2001-02-02 | 2002-04-26 | ||||
| 01-RC-21286 | A | 2 | 0 | 2001-05-11 | 2002-04-26 | ||||
| 01-RC-21287 | A | 0 | 0 | 2000-12-15 | |||||
| 01-RC-21287 | A | 1 | 0 | 2001-02-15 | |||||
| 01-RC-21290 | A | 0 | 0 | 2000-12-13 | 2000-12-14 | ||||
| 01-RC-21290 | A | 1 | 0 | 2000-12-27 | 2001-01-10 | ||||
| 01-RC-21291 | A | 0 | 0 | 2001-01-11 | 2001-01-18 | ||||
| 01-RC-21299 | A | 0 | 0 | 2001-01-31 | |||||
| 01-RC-21309 | A | 0 | 0 | 2001-02-01 | 2001-05-21 | ||||
| 01-RC-21309 | A | 1 | 0 | 2001-03-21 | 2001-05-21 | ||||
| 01-RC-21309 | A | 2 | 0 | 2001-03-28 | 2001-05-21 | ||||
| 01-RC-21317 | A | 0 | 0 | 2001-02-14 | 2001-02-21 | ||||
| 01-RC-21326 | A | 0 | 0 | 2001-03-23 | 2001-03-23 | ||||
| 01-RC-21331 | A | 0 | 0 | 2001-03-28 | 2001-06-27 | ||||
| 01-RC-21343 | A | 0 | 0 | 2001-05-11 | 2001-08-21 | ||||
| 01-RC-21344 | A | 0 | 0 | 2001-05-11 | 2001-08-21 | ||||
| 01-RC-21345 | A | 0 | 0 | 2001-05-11 | 2001-10-23 | ||||
| 01-RC-21347 | A | 0 | 0 | 2001-05-11 | 2001-08-20 | ||||
| 01-RC-21348 | A | 0 | 0 | 2001-05-11 | 2001-08-20 | ||||
| 01-RC-21349 | A | 0 | 0 | 2001-05-22 | 2001-05-24 | ||||
| 01-RC-21349 | A | 0 | 1 | ||||||
| 01-RC-21351 | A | 0 | 0 | 2001-05-11 | 2001-07-18 | ||||
| 01-RC-21351 | A | 1 | 0 | 2001-07-23 | 2001-08-21 | ||||
| 01-RC-21352 | A | 0 | 0 | 2001-05-11 | 2001-08-20 | ||||
| 01-RC-21356 | A | 0 | 0 | 2001-05-11 | 2001-08-20 | ||||
| 01-RC-21357 | A | 0 | 0 | 2001-05-11 | 2001-09-19 | ||||
| 01-RC-21359 | A | 0 | 0 | 2001-05-11 |
Table schema
CREATE TABLE r_block(r_case_number VARCHAR, unit_id VARCHAR, action_sequence BIGINT, recurrence BIGINT, blocked DATE, unblocked DATE, reqproc_board_filed_date VARCHAR, reqproc_board_party VARCHAR, reqproc_board_deter_date VARCHAR, reqproc_board_deter VARCHAR);