c_deferral
75,639 rows
Suggested facets: action_sequence, deferral_type, request_received (date), date_deferral_issued (date), date_deferral_checked (date), date_deferral_extended (date), willingness_date (date), date_processing_resumed (date)
| c_case_number | action_sequence | recurrence | request_party | request_received | scope | date_deferral_issued | deferral_type | date_deferral_checked | date_deferral_extended | willingness_date | willingness_type | date_processing_resumed |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01-CA-26604-001 | 0 | 0 | FULL | 1989-10-10 | Coll | 2001-08-06 | ||||||
| 01-CA-27684-001 | 0 | 0 | FULL | 1990-11-15 | Dubo | 2001-09-19 | ||||||
| 01-CA-27852-001 | 0 | 0 | FULL | 1991-01-16 | Coll | 2001-09-19 | ||||||
| 01-CA-28025-001 | 0 | 0 | FULL | 1991-04-02 | Coll | 2000-04-18 | 2000-05-02 | 2000-06-21 | ||||
| 01-CA-28025-002 | 0 | 0 | FULL | 1991-04-02 | Coll | 2000-04-18 | 2000-05-02 | |||||
| 01-CA-28025-003 | 0 | 0 | FULL | 1991-04-02 | Coll | 2000-04-18 | 2000-05-02 | |||||
| 01-CA-28184-001 | 0 | 0 | FULL | 1991-05-24 | Coll | 2001-09-19 | ||||||
| 01-CA-28751-001 | 0 | 0 | 1991-11-22 | Coll | 1992-08-04 | |||||||
| 01-CA-28751-001 | 0 | 1 | 1993-10-13 | |||||||||
| 01-CA-28751-001 | 0 | 2 | 1996-05-31 | |||||||||
| 01-CA-28751-001 | 0 | 3 | 1997-02-25 | 1997-03-11 | ||||||||
| 01-CA-29186-001 | 0 | 0 | FULL | 1992-04-24 | Dubo | 1997-02-24 | 1997-03-10 | |||||
| 01-CA-29186-001 | 0 | 1 | 2000-04-20 | 2000-05-04 | ||||||||
| 01-CA-29189-001 | 0 | 0 | FULL | 1992-04-29 | Coll | 2001-09-19 | ||||||
| 01-CA-29627-001 | 0 | 0 | FULL | 1992-09-29 | Coll | 2002-03-21 | ||||||
| 01-CA-29743-001 | 0 | 0 | PART | 1992-11-02 | Coll | |||||||
| 01-CA-29756-001 | 0 | 0 | FULL | 1992-11-05 | Coll | 2001-08-30 | ||||||
| 01-CA-30013-001 | 0 | 0 | 1993-11-19 | Coll | ||||||||
| 01-CA-30099-001 | 0 | 0 | FULL | 1993-02-19 | Coll | |||||||
| 01-CA-30181-002 | 0 | 0 | 1993-03-12 | Dubo | ||||||||
| 01-CA-30292-001 | 0 | 0 | FULL | 1993-04-13 | Coll | 1993-11-22 | ||||||
| 01-CA-30347-001 | 0 | 0 | PART | 1993-06-30 | Coll | |||||||
| 01-CA-30354-001 | 0 | 0 | FULL | 1993-05-11 | Coll | 2001-09-19 | ||||||
| 01-CA-30556-001 | 0 | 0 | 1993-07-07 | Coll | ||||||||
| 01-CA-30568-001 | 0 | 0 | FULL | 1993-08-02 | Coll | 1999-12-28 | ||||||
| 01-CA-30629-001 | 0 | 0 | FULL | 1993-08-04 | Coll | 2002-02-06 | ||||||
| 01-CA-30996-001 | 0 | 0 | FULL | 1993-11-29 | Other | |||||||
| 01-CA-31084-002 | 0 | 0 | 1993-12-16 | Coll | 1999-03-16 | 1999-03-30 | ||||||
| 01-CA-31123-001 | 0 | 0 | FULL | 1993-12-28 | Coll | 2002-02-25 | ||||||
| 01-CA-31160-002 | 0 | 0 | FULL | 1994-01-26 | Coll | |||||||
| 01-CA-31277-001 | 0 | 0 | 1994-02-17 | Coll | ||||||||
| 01-CA-31277-001 | 1 | 0 | FULL | 1994-02-17 | Coll | |||||||
| 01-CA-31374-001 | 0 | 0 | FULL | 1994-03-22 | Coll | 2001-08-28 | ||||||
| 01-CA-31566-001 | 0 | 0 | 1994-05-25 | Coll | ||||||||
| 01-CA-31708-001 | 0 | 0 | FULL | 1994-07-08 | Coll | 1999-03-18 | ||||||
| 01-CA-31708-001 | 1 | 0 | FULL | 1994-07-08 | Coll | |||||||
| 01-CA-31722-001 | 0 | 0 | 1994-07-12 | Coll | 1999-03-18 | 1999-04-01 | ||||||
| 01-CA-31722-001 | 1 | 0 | FULL | 1994-07-12 | Coll | |||||||
| 01-CA-31804-001 | 0 | 0 | FULL | 1994-07-26 | Coll | 2002-04-26 | ||||||
| 01-CA-31821-001 | 0 | 0 | FULL | 1994-08-08 | Coll | 1999-03-18 | 1999-04-01 | |||||
| 01-CA-31874-001 | 0 | 0 | 1994-08-11 | Coll | ||||||||
| 01-CA-32082-001 | 0 | 0 | 1994-10-26 | Coll | ||||||||
| 01-CA-32128-001 | 0 | 0 | 1994-11-04 | Coll | 1999-03-26 | 1999-04-09 | ||||||
| 01-CA-32140-001 | 0 | 0 | 1994-11-30 | Coll | ||||||||
| 01-CA-32229-001 | 0 | 0 | FULL | 1994-12-13 | Coll | 2001-08-28 | ||||||
| 01-CA-32233-002 | 0 | 0 | 1994-12-16 | Coll | ||||||||
| 01-CA-32261-001 | 0 | 0 | FULL | 1994-12-14 | Coll | 2002-03-21 | ||||||
| 01-CA-32327-001 | 0 | 0 | FULL | 1995-01-13 | Coll | 2004-06-21 | 2005-03-16 | |||||
| 01-CA-32327-001 | 0 | 1 | 2005-03-16 | |||||||||
| 01-CA-32329-001 | 0 | 0 | 1995-01-30 | Coll | ||||||||
| 01-CA-32456-001 | 0 | 0 | 1995-02-13 | Coll | ||||||||
| 01-CA-32493-001 | 0 | 0 | FULL | 1995-10-12 | ERISA | 2004-01-15 | ||||||
| 01-CA-32557-001 | 0 | 0 | FULL | 1995-03-24 | Coll | |||||||
| 01-CA-32558-001 | 0 | 0 | FULL | 1995-03-13 | Dubo | 1999-12-20 | ||||||
| 01-CA-32570-001 | 0 | 0 | FULL | 1995-03-07 | Coll | |||||||
| 01-CA-32601-001 | 0 | 0 | 1995-03-30 | Coll | ||||||||
| 01-CA-32609-001 | 0 | 0 | 1995-05-04 | Coll | 1999-03-18 | 1999-04-01 | ||||||
| 01-CA-32609-002 | 0 | 0 | 1995-05-04 | Coll | 1999-03-18 | 1999-04-01 | ||||||
| 01-CA-32627-001 | 0 | 0 | FULL | 1995-04-03 | Coll | 2003-01-02 | ||||||
| 01-CA-32660-002 | 0 | 0 | FULL | 1995-04-12 | Coll | |||||||
| 01-CA-32741-001 | 0 | 0 | 1995-04-28 | Coll | ||||||||
| 01-CA-32824-001 | 0 | 0 | 1995-05-23 | Coll | ||||||||
| 01-CA-32861-001 | 0 | 0 | FULL | 1995-05-17 | Coll | |||||||
| 01-CA-32875-001 | 0 | 0 | 1995-05-31 | Coll | ||||||||
| 01-CA-32884-001 | 0 | 0 | 1995-06-07 | Coll | ||||||||
| 01-CA-32948-001 | 0 | 0 | 1995-06-14 | Coll | ||||||||
| 01-CA-32986-001 | 0 | 0 | 1995-07-11 | Dubo | 1999-04-08 | 1999-04-22 | ||||||
| 01-CA-33040-001 | 0 | 0 | FULL | 1995-07-28 | Coll | 1997-09-16 | 1997-09-30 | |||||
| 01-CA-33040-001 | 0 | 1 | 1999-04-12 | 1999-04-26 | ||||||||
| 01-CA-33064-001 | 0 | 0 | FULL | 1995-07-24 | Coll | 1996-05-31 | 1996-06-14 | |||||
| 01-CA-33104-001 | 0 | 0 | 1995-08-09 | Coll | ||||||||
| 01-CA-33203-001 | 0 | 0 | 1995-09-01 | Coll | 1997-05-30 | 1997-06-13 | ||||||
| 01-CA-33203-001 | 0 | 1 | 1999-04-12 | 1999-04-26 | ||||||||
| 01-CA-33275-001 | 0 | 0 | FULL | 1995-10-26 | OSHA | 2003-11-14 | ||||||
| 01-CA-33300-001 | 0 | 0 | FULL | 1995-09-29 | Coll | |||||||
| 01-CA-33334-001 | 0 | 0 | FULL | 1995-10-20 | Coll | 1999-04-07 | 1999-04-21 | |||||
| 01-CA-33400-001 | 0 | 0 | 1995-11-07 | Other | ||||||||
| 01-CA-33409-001 | 0 | 0 | 1995-11-07 | Coll | ||||||||
| 01-CA-33417-001 | 0 | 0 | 1995-11-06 | Coll | 1996-10-21 | 1996-11-04 | ||||||
| 01-CA-33417-001 | 0 | 1 | 1999-02-05 | |||||||||
| 01-CA-33427-001 | 0 | 0 | FULL | 1996-02-28 | Coll | 1997-05-30 | 1997-06-13 | 2002-04-09 | ||||
| 01-CA-33427-001 | 0 | 1 | 1999-04-07 | 1999-04-21 | ||||||||
| 01-CA-33427-001 | 0 | 2 | 2002-03-14 | 2002-03-28 | ||||||||
| 01-CA-33440-001 | 0 | 0 | FULL | 1995-11-21 | Coll | 2002-04-11 | ||||||
| 01-CA-33457-001 | 0 | 0 | FULL | 1995-11-30 | Coll | 1999-04-07 | 1999-04-21 | |||||
| 01-CA-33475-001 | 0 | 0 | FULL | 1995-11-28 | Other | 2000-03-16 | ||||||
| 01-CA-33522-001 | 0 | 0 | 1995-12-15 | Coll | 1997-05-13 | 1999-05-27 | ||||||
| 01-CA-33549-001 | 0 | 0 | 1996-01-24 | Coll | ||||||||
| 01-CA-33582-001 | 0 | 0 | 1996-02-20 | Coll | ||||||||
| 01-CA-33645-001 | 0 | 0 | FULL | 1996-03-05 | Coll | 1997-07-28 | 1997-08-11 | 2002-04-12 | ||||
| 01-CA-33645-001 | 0 | 1 | 1999-04-07 | 1999-04-21 | ||||||||
| 01-CA-33645-001 | 0 | 2 | 2002-03-20 | 2002-04-03 | ||||||||
| 01-CA-33646-001 | 0 | 0 | 1996-03-25 | Coll | 1996-02-05 | |||||||
| 01-CA-33650-001 | 0 | 0 | FULL | 1996-02-27 | Coll | 2000-05-23 | ||||||
| 01-CA-33687-001 | 0 | 0 | FULL | 1996-02-21 | Coll | 2002-03-20 | 2002-04-03 | 2002-04-12 | ||||
| 01-CA-33689-001 | 0 | 0 | 1996-03-27 | Dubo | 1997-02-24 | 1997-03-10 | ||||||
| 01-CA-33689-001 | 0 | 1 | 1999-04-12 | 1999-04-26 | ||||||||
| 01-CA-33716-001 | 0 | 0 | 1996-02-22 | Coll | 1996-02-01 | |||||||
| 01-CA-33751-001 | 0 | 0 | FULL | 1996-03-20 | Coll | 2002-03-13 | 2002-03-26 | 2002-04-09 | ||||
| 01-CA-33758-001 | 0 | 0 | FULL | 1996-05-08 | Coll | 2002-03-21 |
Table schema
CREATE TABLE c_deferral(c_case_number VARCHAR, action_sequence BIGINT, recurrence BIGINT, request_party VARCHAR, request_received DATE, "scope" VARCHAR, date_deferral_issued DATE, deferral_type VARCHAR, date_deferral_checked DATE, date_deferral_extended DATE, willingness_date DATE, willingness_type VARCHAR, date_processing_resumed DATE);