c_advice
6,770 rows
Suggested facets: action_sequence, recurrence, advice_scope, advice_submission (date), advice_rcvd_submission (date), advice_memo_date (date), advice_deter_rcvd_reg (date), file_received_advice (date)
| c_case_number | action_sequence | recurrence | advice_submission | advice_rcvd_submission | advice_scope | advice_memo_date | advice_deter_rcvd_reg | file_received_advice |
|---|---|---|---|---|---|---|---|---|
| 01-CA-19731-001 | 0 | 0 | 1982-04-13 | 1983-02-04 | 1983-02-07 | |||
| 01-CA-19903-001 | 0 | 0 | 1983-02-04 | 1983-02-07 | ||||
| 01-CA-20007-001 | 0 | 0 | 1983-02-04 | 1983-02-07 | ||||
| 01-CA-20157-001 | 0 | 0 | 1983-02-04 | 1983-02-07 | ||||
| 01-CA-20218-001 | 0 | 0 | 1983-02-04 | 1983-02-07 | ||||
| 01-CA-20442-001 | 0 | 0 | 1983-02-04 | 1983-02-07 | ||||
| 01-CA-20521-001 | 0 | 0 | 1983-02-04 | 1983-02-07 | ||||
| 01-CA-21438-001 | 0 | 0 | 1983-02-04 | 1983-02-07 | ||||
| 01-CA-22769-001 | 0 | 0 | 1986-04-16 | Full | 1986-05-02 | |||
| 01-CA-25940-001 | 0 | 0 | 1989-01-25 | Full | 1989-08-18 | 1989-08-23 | ||
| 01-CA-26820-001 | 0 | 0 | 1989-12-29 | 1989-12-30 | Full | 1991-03-20 | 1991-03-21 | 1989-12-30 |
| 01-CA-28590-001 | 0 | 0 | 1991-12-23 | Full | 1992-02-20 | 1992-02-25 | ||
| 01-CA-29631-001 | 0 | 0 | 1992-12-23 | |||||
| 01-CA-29757-001 | 0 | 0 | 1992-12-23 | |||||
| 01-CA-29966-001 | 0 | 0 | 1993-01-28 | Full | 1993-04-26 | 1993-04-28 | ||
| 01-CA-30063-001 | 0 | 0 | 1993-04-26 | 1993-04-28 | ||||
| 01-CA-30374-001 | 0 | 0 | 1993-07-28 | Full | 1993-09-08 | |||
| 01-CA-30630-001 | 0 | 0 | 1993-07-28 | Full | 1993-09-08 | |||
| 01-CA-30745-001 | 0 | 0 | 1996-12-24 | Full | 1997-04-29 | |||
| 01-CA-32158-001 | 0 | 0 | 1995-02-22 | Full | 1995-08-21 | |||
| 01-CA-32169-001 | 0 | 0 | 1994-12-28 | Full | 1995-01-05 | 1995-01-10 | ||
| 01-CA-32170-001 | 0 | 0 | 1994-12-28 | Full | 1995-01-05 | 1995-01-10 | ||
| 01-CA-32248-001 | 0 | 0 | 1995-02-22 | Full | 1995-08-21 | |||
| 01-CA-32393-001 | 0 | 0 | 1996-02-29 | Full | 1996-07-19 | |||
| 01-CA-32742-001 | 0 | 0 | 1995-12-12 | Full | 1996-04-30 | |||
| 01-CA-32767-001 | 0 | 0 | 1995-12-12 | Full | 1996-04-30 | |||
| 01-CA-32952-001 | 0 | 0 | 1996-02-29 | Full | 1996-07-19 | |||
| 01-CA-32953-001 | 0 | 0 | 1996-02-29 | Full | 1996-07-19 | |||
| 01-CA-32954-001 | 0 | 0 | 1996-02-29 | Full | 1996-07-19 | |||
| 01-CA-32965-001 | 0 | 0 | 1996-02-29 | Full | 1996-07-19 | |||
| 01-CA-32966-001 | 0 | 0 | 1996-02-29 | Full | 1996-07-19 | |||
| 01-CA-32991-001 | 0 | 0 | 1996-02-29 | Full | 1996-07-19 | |||
| 01-CA-33016-001 | 0 | 0 | 1996-02-29 | Full | 1996-07-19 | |||
| 01-CA-33023-001 | 0 | 0 | 1996-02-29 | Full | 1996-07-19 | |||
| 01-CA-33024-001 | 0 | 0 | 1996-02-29 | Full | 1996-07-19 | |||
| 01-CA-33025-001 | 0 | 0 | 1996-02-29 | Full | 1996-07-19 | |||
| 01-CA-33026-001 | 0 | 0 | 1996-02-29 | Full | 1996-07-19 | |||
| 01-CA-33044-001 | 0 | 0 | 1996-02-29 | Full | 1996-07-19 | |||
| 01-CA-33045-001 | 0 | 0 | 1996-02-29 | Full | 1996-07-19 | |||
| 01-CA-33046-001 | 0 | 0 | 1996-02-29 | Full | 1996-07-19 | |||
| 01-CA-33047-001 | 0 | 0 | 1996-02-29 | Full | 1996-07-19 | |||
| 01-CA-33050-001 | 0 | 0 | 1996-02-29 | Full | 1996-07-19 | |||
| 01-CA-33050-002 | 0 | 0 | 1996-02-29 | Full | 1996-07-19 | |||
| 01-CA-33214-001 | 0 | 0 | 1996-02-29 | Full | 1996-07-19 | |||
| 01-CA-33216-001 | 0 | 0 | 1996-02-29 | Full | 1996-07-19 | |||
| 01-CA-33217-001 | 0 | 0 | 1996-02-29 | Full | 1996-07-19 | |||
| 01-CA-33218-001 | 0 | 0 | 1996-02-29 | Full | 1996-07-19 | |||
| 01-CA-33536-001 | 0 | 0 | 1996-02-29 | Full | 1996-07-19 | |||
| 01-CA-34278-001 | 0 | 0 | 1996-10-28 | Full | 1997-03-07 | 1997-03-12 | ||
| 01-CA-34338-001 | 0 | 0 | 1997-02-28 | Full | 1997-04-07 | |||
| 01-CA-35110-001 | 0 | 0 | 1997-06-06 | 1997-06-07 | Part | 1997-06-11 | 1997-06-23 | |
| 01-CA-35198-001 | 0 | 0 | 1997-06-06 | 1997-06-07 | Part | 1997-06-19 | 1997-06-23 | |
| 01-CA-36226-001 | 0 | 0 | 1999-01-05 | Full | 1999-02-01 | 1999-02-04 | ||
| 01-CA-36251-001 | 0 | 0 | 1999-01-29 | Full | 1999-02-26 | 1999-03-03 | ||
| 01-CA-36484-001 | 0 | 0 | 1998-09-22 | Full | 1998-10-19 | 1998-10-19 | ||
| 01-CA-36606-001 | 0 | 0 | 1998-11-16 | Full | 1999-01-15 | 1999-01-21 | ||
| 01-CA-36607-001 | 0 | 0 | 1998-12-16 | Full | 1999-01-15 | 1999-01-21 | ||
| 01-CA-36635-001 | 0 | 0 | 1999-01-29 | Part | 1999-02-26 | 1999-03-03 | ||
| 01-CA-36774-001 | 0 | 0 | 1999-04-29 | Full | 1999-06-03 | 1999-06-09 | ||
| 01-CA-36774-001 | 1 | 0 | 1999-08-25 | Full | 1999-10-14 | 1999-10-14 | ||
| 01-CA-36875-001 | 0 | 0 | ||||||
| 01-CA-36933-001 | 0 | 0 | ||||||
| 01-CA-36945-001 | 0 | 0 | 1999-08-25 | Full | 1999-10-14 | 1999-10-14 | ||
| 01-CA-37018-001 | 0 | 0 | 1999-05-11 | Full | 1999-07-02 | 1999-07-02 | ||
| 01-CA-37022-001 | 0 | 0 | 1999-05-11 | Full | 1999-07-02 | 1999-07-02 | ||
| 01-CA-37057-001 | 0 | 0 | 1999-09-03 | Full | 1999-09-28 | 1999-10-04 | ||
| 01-CA-37058-001 | 0 | 0 | 1999-04-30 | Full | 1999-06-25 | 1999-06-25 | ||
| 01-CA-37095-001 | 0 | 0 | 1999-05-28 | Full | 1999-06-25 | 1999-06-28 | ||
| 01-CA-37149-001 | 0 | 0 | 1999-05-11 | Full | 1999-07-02 | 1999-07-02 | ||
| 01-CA-37256-001 | 0 | 0 | 1999-09-30 | Full | 1999-10-28 | |||
| 01-CA-37282-001 | 0 | 0 | 1999-08-25 | Full | 1999-10-14 | 1999-10-14 | ||
| 01-CA-37283-001 | 0 | 0 | 1999-08-25 | Full | 1999-10-14 | 1999-10-14 | ||
| 01-CA-37300-001 | 0 | 0 | 1999-10-15 | Full | 1999-11-01 | 1999-11-08 | ||
| 01-CA-37354-001 | 0 | 0 | 2000-01-24 | Full | 2000-03-31 | 2000-04-03 | ||
| 01-CA-37411-001 | 0 | 0 | 2000-05-12 | Full | 2000-07-27 | 2000-08-01 | ||
| 01-CA-37453-001 | 0 | 0 | 1999-11-05 | Full | 1999-12-13 | 1999-12-20 | ||
| 01-CA-37465-001 | 0 | 0 | 2000-02-17 | Full | 2000-05-16 | 2000-05-19 | ||
| 01-CA-37490-001 | 0 | 0 | 1999-12-23 | Full | 2000-02-24 | 2000-02-29 | ||
| 01-CA-37501-001 | 0 | 0 | 1999-10-15 | Full | 1999-11-01 | 1999-11-08 | ||
| 01-CA-37535-001 | 0 | 0 | 2000-02-02 | Full | ||||
| 01-CA-37682-001 | 0 | 0 | 2000-02-04 | 2000-02-04 | Full | 2000-03-24 | 2000-03-24 | |
| 01-CA-37743-001 | 0 | 0 | 2001-04-26 | Full | 2001-08-31 | 2001-09-04 | ||
| 01-CA-37743-001 | 0 | 1 | 2001-09-25 | 2001-09-27 | ||||
| 01-CA-37763-001 | 0 | 0 | 2000-05-18 | Full | 2000-08-21 | 2000-08-23 | ||
| 01-CA-37769-001 | 0 | 0 | 2000-02-04 | 2000-02-04 | Full | 2000-03-24 | 2000-03-24 | |
| 01-CA-37811-001 | 0 | 0 | 2000-02-25 | Full | 2000-03-02 | 2000-03-07 | ||
| 01-CA-37828-001 | 0 | 0 | 2000-02-25 | Full | 2000-03-02 | 2000-03-07 | ||
| 01-CA-37857-001 | 0 | 0 | 2000-04-25 | Full | 2000-05-15 | 2000-05-17 | ||
| 01-CA-37875-001 | 0 | 0 | 2000-02-25 | Full | 2000-03-02 | 2000-03-07 | ||
| 01-CA-37925-001 | 0 | 0 | 2000-06-29 | Full | 2000-07-18 | 2000-07-21 | ||
| 01-CA-37931-001 | 0 | 0 | 2000-02-25 | Full | 2000-03-02 | 2000-03-07 | ||
| 01-CA-37961-001 | 0 | 0 | 2000-06-29 | Full | 2000-07-18 | 2000-07-21 | ||
| 01-CA-37988-001 | 0 | 0 | 2000-05-10 | Full | 2000-06-16 | 2000-06-19 | ||
| 01-CA-38118-001 | 0 | 0 | 2000-07-18 | Full | 2000-10-30 | 2000-11-02 | ||
| 01-CA-38239-001 | 0 | 0 | 2000-07-05 | Full | ||||
| 01-CA-38276-001 | 0 | 0 | 2001-02-28 | Full | 2001-08-17 | 2001-08-22 | ||
| 01-CA-38400-001 | 0 | 0 | 2001-02-28 | Full | 2001-08-17 | 2001-08-22 | ||
| 01-CA-38508-001 | 0 | 0 | 2000-11-14 | Full | 2000-12-26 | 2001-01-02 | ||
| 01-CA-38571-001 | 0 | 0 | 2001-02-16 | 2001-02-20 | Full | 2001-03-21 | 2001-03-26 | |
| 01-CA-38647-001 | 0 | 0 | 2001-11-30 | Full | 2001-12-10 | 2001-12-10 |
Table schema
CREATE TABLE c_advice(c_case_number VARCHAR, action_sequence BIGINT, recurrence BIGINT, advice_submission DATE, advice_rcvd_submission DATE, advice_scope VARCHAR, advice_memo_date DATE, advice_deter_rcvd_reg DATE, file_received_advice DATE);