c_compliance_goals

39,814 rows

✎ View and edit SQL

Suggested facets: action_sequence, recurrence, reinstatement_offered, letter_date (date), posting_goal (date), notices_post_dates (date), post_expires (date), reinstatement_goal (date), reinstatement_offered (date), closing_goal (date), backpay_received (date)

c_case_number action_sequence recurrence letter_date letter_type posting_goal not_post_party posting_type notices_post_dates post_expires reinstatement_goal reinstatement_offered closing_goal backpay_received
01-CA-21943-001 0 0 2001-05-24 SETTL 2001-06-05 CHP Facil 2001-06-01 2001-07-31 2001-05-22   2001-08-07 2001-07-30
01-CA-22040-002 0 0 2001-05-24 SETTL 2001-06-05 CHP Facil 2001-06-01 2001-07-31 2001-05-22   2001-08-07 2001-07-30
01-CA-23307-001 0 0 2001-05-24 SETTL 2001-06-05 CHP Facil 2001-06-01 2001-07-31 2001-05-22   2001-08-07 2001-07-30
01-CA-23427-001 0 0     1986-09-08         1986-08-25   1986-11-10  
01-CA-23748-001 0 0 2001-05-24 SETTL 2001-06-05 CHP Facil 2001-06-01 2001-07-31 2001-05-22   2001-08-07 2001-07-30
01-CA-24161-001 0 0 2001-05-24 SETTL 2001-06-05 CHP Facil 2001-06-01 2001-07-31 2001-05-22   2001-08-07 2001-07-30
01-CA-24372-001 0 0     1987-12-16         1987-12-02      
01-CA-24390-002 0 0 2001-05-24 SETTL 2001-06-05 CHP Facil 2001-06-01 2001-07-31 2001-05-22   2001-08-07 2001-07-30
01-CA-24528-001 0 0 2001-05-24 SETTL 2001-06-05 CHP Facil 2001-06-01 2001-07-31 2001-05-22   2001-08-07 2001-07-30
01-CA-24863-001 0 0 1988-09-22 SETTL 1988-09-13 CHP Facil 1988-09-23 1988-11-02 1988-08-30   1988-12-13  
01-CA-24883-001 0 0 1988-09-22 SETTL 1988-09-13         1988-08-30   1988-12-13  
01-CA-24921-001 0 0 2001-05-24 SETTL 2001-06-05 CHP Facil 2001-06-01 2001-07-31 2001-05-22   2001-08-07 2001-07-30
01-CA-24967-001 0 0 2001-05-24 SETTL 2001-06-05 CHP Facil 2001-06-01 2001-07-31 2001-05-22   2001-08-07 2001-07-30
01-CA-25033-001 0 0 2001-05-24 SETTL 2001-06-05 CHP Facil 2001-06-01 2001-07-31 2001-05-22   2001-08-07 2001-07-30
01-CA-25237-001 0 0 2001-05-24 SETTL 2001-06-05 CHP Facil 2001-06-01 2001-07-31 2001-05-22   2001-08-07 2001-07-30
01-CA-25237-002 0 0 2001-05-24 SETTL 2001-06-05 CHP Facil 2001-06-01 2001-07-31 2001-05-22   2001-08-07 2001-07-30
01-CA-25341-001 0 0 2001-05-24 SETTL 2001-06-05 CHP Facil 2001-06-01 2001-07-31 2001-05-22   2001-08-07 2001-07-30
01-CA-25656-001 0 0     1990-09-27         1990-09-13      
01-CA-25736-001 0 0 1989-05-02 Board 1989-05-12 CHP Facil 1989-05-30 1989-07-29        
01-CA-25867-001 0 0 2001-05-24 SETTL 2001-06-05 CHP Facil 2001-06-01 2001-07-31 2001-05-22   2001-08-07 2001-07-30
01-CA-25940-001 0 0 1992-05-01 SETTL 1992-05-27         1992-05-13      
01-CA-25969-001 0 0 1991-07-05 Board 1991-07-30 CHP Facil 1996-07-08 1996-09-08 1991-07-16   1991-10-29 2007-04-16
01-CA-26098-001 0 0 1989-06-12 SETTL 1989-06-16 CHP Facil 1989-06-14 1989-08-13 1989-06-02   1989-09-15  
01-CA-26144-001 0 0     1990-09-27         1990-09-13      
01-CA-26183-001 0 0 1992-08-24 Board 1992-09-14         1992-08-31      
01-CA-26232-001 0 0 1992-01-22 SETTL                  
01-CA-26237-001 0 0 1992-01-22 SETTL 1992-02-06         1992-01-23      
01-CA-26270-001 0 0 1992-08-24 Board 1992-09-14         1992-08-31      
01-CA-26353-001 0 0 1992-08-24 Board 1992-09-14         1992-08-31      
01-CA-26463-001 0 0 1992-03-06 Board 1992-03-30 CHP Facil     1992-03-16   1992-06-29  
01-CA-26463-002 0 0 1992-03-06 Board 1992-03-30         1992-03-16      
01-CA-26463-003 0 0 1992-03-06 Board 1992-03-30         1992-03-16      
01-CA-26463-005 0 0 1992-03-06 Board 1992-03-30         1992-03-16      
01-CA-26573-001 0 0 1991-12-27 Board 1994-08-29         1994-08-15   1994-11-28  
01-CA-26575-001 0 0 1990-04-20 Board 1990-05-13 CHP Facil 1990-05-03 1990-07-03 1990-04-29   1990-09-18  
01-CA-26936-001 0 0 1991-06-05 Board 1991-07-01 CHP Facil     1991-06-17      
01-CA-27014-001 0 0 1990-09-17 Board 1990-10-11         1990-09-27      
01-CA-27070-001 0 0 1991-12-27 Board 1992-01-21         1992-01-07   1992-04-21  
01-CA-27142-001 0 0 1992-04-01 Board 1992-04-11 CHP Facil 1992-04-11 1992-06-10        
01-CA-27197-001 0 0 1990-07-09 SETTL 1990-07-26 CHP Facil 1990-08-05 1990-10-04 1990-07-12   1990-10-25  
01-CA-27321-001 0 0 1990-12-14 Board 1991-01-10 CHP Facil 1991-10-18 1991-12-17 1990-12-27      
01-CA-27356-001 0 0 1990-12-10 SETTL 1990-12-24 CHP Mail 1990-12-14 1991-01-03 1990-12-10   1991-03-25  
01-CA-27417-001 0 0 1990-12-10 SETTL 1990-12-24 CHP Mail 1990-12-14 1991-01-03 1990-12-10   1991-03-25  
01-CA-27421-001 0 0 1991-12-12 SETTL 1991-12-25 CHP Mail 1991-12-18   1991-12-11   1992-03-25 1992-01-28
01-CA-27491-001 0 0 1991-12-12 SETTL 1991-12-10 CHP Mail 1991-12-18   1991-11-26   1992-03-10 1992-01-28
01-CA-27659-001 0 0 1991-12-12 SETTL 1991-12-10 CHP Mail 1991-12-18   1991-11-26   1992-03-10 1992-01-28
01-CA-27732-001 0 0 1991-12-12 SETTL 1991-12-10 CHP Mail 1991-12-18   1991-11-26   1992-03-10 1992-01-28
01-CA-27732-002 0 0 1991-12-12 SETTL 1991-12-10 CHP Mail 1991-12-18   1991-11-26   1992-03-10 1992-01-28
01-CA-27766-001 0 0 1992-01-08 SETTL 1992-01-16         1992-01-02   1992-03-19  
01-CA-27879-001 0 0 1993-12-10 Board 1993-11-29         1993-11-15      
01-CA-27908-001 0 0 1992-05-14 Board 1992-06-03         1992-05-20   1992-09-02 2001-05-17
01-CA-27937-001 0 0 1991-12-12 SETTL 1991-12-25 CHP Mail 1991-12-18   1991-12-11   1992-03-25 1992-01-28
01-CA-28064-001 0 0 1991-11-27 SETTL 1991-12-17 CHP Mail 1991-12-05 1991-12-24 1991-12-03   1992-02-18 1996-03-11
01-CA-28250-001 0 0     1992-02-29         1992-02-15   1992-05-30  
01-CA-28264-001 0 0 1992-01-17 Board 1992-02-12         1992-01-29   1992-05-13  
01-CA-28348-001 0 0     1993-03-22 CHP Facil 1993-03-19 1993-05-18        
01-CA-28375-001 0 0 1991-12-20 SETTL 1994-03-30 CHP Facil 1994-03-26 1994-05-27 1994-03-16   1994-06-29  
01-CA-28375-001 0 1 1994-03-05 Board                  
01-CA-28376-001 0 0 1992-09-22 SETTL 1992-09-25         1992-09-11      
01-CA-28418-001 0 0 1996-09-23 Board 1996-09-28 CHP Facil 2000-01-24 2000-03-24 1996-09-14   1996-11-30  
01-CA-28474-001 0 0 1992-04-01 Board 1992-04-28         1992-04-14      
01-CA-28481-001 0 0 1992-09-22 SETTL 1992-09-25         1992-09-11   1992-12-25  
01-CA-28493-001 0 0 1991-11-27 SETTL 1991-12-17 CHP Mail 1991-12-05 1991-12-24 1991-12-03   1992-03-17 1996-03-11
01-CA-28518-001 0 0 1993-07-08 SETTL 1993-07-15 CHP Mail 1993-07-16   1993-07-01   1993-10-14  
01-CA-28558-001 0 0 1993-08-25 SETTL 1993-09-14 CHP Facil 1993-09-01 1993-10-31 1993-08-31   1993-11-16  
01-CA-28590-001 0 0 1996-09-23 Board 1996-09-28 CHP Facil 2000-01-24 2000-03-24 1996-09-14   1996-11-30  
01-CA-28617-001 0 0 1992-09-22 SETTL 1992-09-25         1992-09-11      
01-CA-28866-001 0 0 1992-07-22 Board 1992-08-12 CHP Facil 1992-10-01 1992-12-01 1992-07-29   1992-12-09 2001-03-23
01-CA-28892-001 0 0 1992-01-22 SETTL 1992-02-04         1992-01-21   1992-05-05  
01-CA-28935-001 0 0 1992-08-04 Board 1992-08-24         1992-08-10   1992-12-21  
01-CA-28985-001 0 0 1993-02-03 Board 1993-01-06         1992-12-23   1993-03-10  
01-CA-28985-001 0 1 1993-04-23 CO                  
01-CA-28985-001 0 2 1994-07-21 CO                  
01-CA-29051-001 0 0 1994-03-05 Board 1994-03-30 CHP Facil 1994-03-26 1994-05-27 1994-03-16   1994-06-29  
01-CA-29137-001 0 0 1993-08-25 SETTL 1993-09-14 CHP Facil 1993-09-01 1993-10-31 1993-08-31   1993-11-16  
01-CA-29145-001 0 0 1993-08-25 SETTL 1993-09-14 CHP Facil 1993-09-01 1993-10-31 1993-08-31   1993-11-16  
01-CA-29153-001 0 0 1992-07-31 Board 1992-08-24 CHP Facil 1992-09-19 1992-11-19 1992-08-10   1992-12-21  
01-CA-29179-001 0 0 1993-09-30 SETTL 1993-06-25 CHP Facil 1994-12-08 1995-02-06 1993-06-11      
01-CA-29217-001 0 0 1993-07-01 SETTL 1993-05-13 CHP Facil 1993-07-07 1993-09-05 1993-04-29      
01-CA-29220-001 0 0 1992-09-15 Board 1992-09-25         1992-09-11      
01-CA-29220-001 0 1 1993-02-05 CO                  
01-CA-29252-001 0 0     1992-12-31 CHP Facil 1992-12-18 1992-02-17 1992-12-17   1993-04-29 2000-07-12
01-CA-29367-001 0 0 1992-09-17 Board 1992-10-02         1992-09-18      
01-CA-29406-001 0 0 1993-04-09 Board 1993-05-05         1993-04-21      
01-CA-29414-001 0 0     1994-11-28         1994-11-14      
01-CA-29433-001 0 0 1995-05-18 Board 1995-05-28 CHP Facil 1996-07-18 1996-09-18 1995-05-14   1995-08-27 2009-03-11
01-CA-29434-001 0 0 1995-05-18 Board 1995-05-28 CHP Facil 1996-07-18 1996-09-18 1995-05-14   1995-08-27 2009-03-11
01-CA-29445-001 0 0 1993-10-25 Board 1993-10-20 CHP Facil 1993-11-01 1993-12-31 1993-10-06   1994-01-19  
01-CA-29500-001 0 0 1993-08-10 SETTL 1993-09-03 CHP Facil 1993-08-30 1993-10-29 1993-08-20      
01-CA-29550-001 0 0 1992-09-25 SETTL 1992-10-21 CHP Facil 1992-10-26 1992-12-24 1992-10-07      
01-CA-29557-001 0 0 1993-10-22 Board 1993-10-08         1993-09-24      
01-CA-29582-001 0 0 1993-08-25 SETTL 1993-09-14 CHP Facil 1993-09-01 1993-10-31 1993-08-31   1993-11-16  
01-CA-29602-001 0 0 1993-06-08 SETTL 1993-06-10 CHP Facil 1993-06-14 1993-08-13 1993-05-27      
01-CA-29621-001 0 0     1996-08-17 CHP Facil 1997-06-20 1997-08-19 1996-08-03      
01-CA-29631-001 0 0 1993-03-31 SETTL 1993-04-15 CHP Facil 1993-04-06 1993-06-05 1993-04-01   1993-07-15  
01-CA-29649-001 0 0 1993-10-22 Board 1993-10-08         1993-09-24      
01-CA-29676-001 0 0 1993-06-08 Board 1993-06-22         1993-06-08   1993-08-24  
01-CA-29690-001 0 0 1992-12-01 SETTL 1992-12-18 CHP Facil 1992-12-07 1993-02-05 1992-12-04   1993-03-19  
01-CA-29740-001 0 0     1996-08-17 CHP Facil 1997-06-20 1997-08-19 1996-08-03      
01-CA-29743-001 0 0     1994-05-12         1994-04-28   1994-07-14  

Next page

Download this data

CSV · JSON

Table schema 
CREATE TABLE c_compliance_goals(c_case_number VARCHAR, action_sequence BIGINT, recurrence BIGINT, letter_date DATE, letter_type VARCHAR, posting_goal DATE, not_post_party VARCHAR, posting_type VARCHAR, notices_post_dates DATE, post_expires DATE, reinstatement_goal DATE, reinstatement_offered DATE, closing_goal DATE, backpay_received DATE);