c_compliance_goals

39,814 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ 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
1 1 01-CA-21943-001 0 0 2001-05-24T00:00:00 SETTL 2001-06-05T00:00:00 CHP Facil 2001-06-01T00:00:00 2001-07-31T00:00:00 2001-05-22T00:00:00   2001-08-07T00:00:00 2001-07-30T00:00:00
2 2 01-CA-22040-002 0 0 2001-05-24T00:00:00 SETTL 2001-06-05T00:00:00 CHP Facil 2001-06-01T00:00:00 2001-07-31T00:00:00 2001-05-22T00:00:00   2001-08-07T00:00:00 2001-07-30T00:00:00
3 3 01-CA-23307-001 0 0 2001-05-24T00:00:00 SETTL 2001-06-05T00:00:00 CHP Facil 2001-06-01T00:00:00 2001-07-31T00:00:00 2001-05-22T00:00:00   2001-08-07T00:00:00 2001-07-30T00:00:00
4 4 01-CA-23427-001 0 0     1986-09-08T00:00:00         1986-08-25T00:00:00   1986-11-10T00:00:00  
5 5 01-CA-23748-001 0 0 2001-05-24T00:00:00 SETTL 2001-06-05T00:00:00 CHP Facil 2001-06-01T00:00:00 2001-07-31T00:00:00 2001-05-22T00:00:00   2001-08-07T00:00:00 2001-07-30T00:00:00
6 6 01-CA-24161-001 0 0 2001-05-24T00:00:00 SETTL 2001-06-05T00:00:00 CHP Facil 2001-06-01T00:00:00 2001-07-31T00:00:00 2001-05-22T00:00:00   2001-08-07T00:00:00 2001-07-30T00:00:00
7 7 01-CA-24372-001 0 0     1987-12-16T00:00:00         1987-12-02T00:00:00      
8 8 01-CA-24390-002 0 0 2001-05-24T00:00:00 SETTL 2001-06-05T00:00:00 CHP Facil 2001-06-01T00:00:00 2001-07-31T00:00:00 2001-05-22T00:00:00   2001-08-07T00:00:00 2001-07-30T00:00:00
9 9 01-CA-24528-001 0 0 2001-05-24T00:00:00 SETTL 2001-06-05T00:00:00 CHP Facil 2001-06-01T00:00:00 2001-07-31T00:00:00 2001-05-22T00:00:00   2001-08-07T00:00:00 2001-07-30T00:00:00
10 10 01-CA-24863-001 0 0 1988-09-22T00:00:00 SETTL 1988-09-13T00:00:00 CHP Facil 1988-09-23T00:00:00 1988-11-02T00:00:00 1988-08-30T00:00:00   1988-12-13T00:00:00  
11 11 01-CA-24883-001 0 0 1988-09-22T00:00:00 SETTL 1988-09-13T00:00:00         1988-08-30T00:00:00   1988-12-13T00:00:00  
12 12 01-CA-24921-001 0 0 2001-05-24T00:00:00 SETTL 2001-06-05T00:00:00 CHP Facil 2001-06-01T00:00:00 2001-07-31T00:00:00 2001-05-22T00:00:00   2001-08-07T00:00:00 2001-07-30T00:00:00
13 13 01-CA-24967-001 0 0 2001-05-24T00:00:00 SETTL 2001-06-05T00:00:00 CHP Facil 2001-06-01T00:00:00 2001-07-31T00:00:00 2001-05-22T00:00:00   2001-08-07T00:00:00 2001-07-30T00:00:00
14 14 01-CA-25033-001 0 0 2001-05-24T00:00:00 SETTL 2001-06-05T00:00:00 CHP Facil 2001-06-01T00:00:00 2001-07-31T00:00:00 2001-05-22T00:00:00   2001-08-07T00:00:00 2001-07-30T00:00:00
15 15 01-CA-25237-001 0 0 2001-05-24T00:00:00 SETTL 2001-06-05T00:00:00 CHP Facil 2001-06-01T00:00:00 2001-07-31T00:00:00 2001-05-22T00:00:00   2001-08-07T00:00:00 2001-07-30T00:00:00
16 16 01-CA-25237-002 0 0 2001-05-24T00:00:00 SETTL 2001-06-05T00:00:00 CHP Facil 2001-06-01T00:00:00 2001-07-31T00:00:00 2001-05-22T00:00:00   2001-08-07T00:00:00 2001-07-30T00:00:00
17 17 01-CA-25341-001 0 0 2001-05-24T00:00:00 SETTL 2001-06-05T00:00:00 CHP Facil 2001-06-01T00:00:00 2001-07-31T00:00:00 2001-05-22T00:00:00   2001-08-07T00:00:00 2001-07-30T00:00:00
18 18 01-CA-25656-001 0 0     1990-09-27T00:00:00         1990-09-13T00:00:00      
19 19 01-CA-25736-001 0 0 1989-05-02T00:00:00 Board 1989-05-12T00:00:00 CHP Facil 1989-05-30T00:00:00 1989-07-29T00:00:00        
20 20 01-CA-25867-001 0 0 2001-05-24T00:00:00 SETTL 2001-06-05T00:00:00 CHP Facil 2001-06-01T00:00:00 2001-07-31T00:00:00 2001-05-22T00:00:00   2001-08-07T00:00:00 2001-07-30T00:00:00
21 21 01-CA-25940-001 0 0 1992-05-01T00:00:00 SETTL 1992-05-27T00:00:00         1992-05-13T00:00:00      
22 22 01-CA-25969-001 0 0 1991-07-05T00:00:00 Board 1991-07-30T00:00:00 CHP Facil 1996-07-08T00:00:00 1996-09-08T00:00:00 1991-07-16T00:00:00   1991-10-29T00:00:00 2007-04-16T00:00:00
23 23 01-CA-26098-001 0 0 1989-06-12T00:00:00 SETTL 1989-06-16T00:00:00 CHP Facil 1989-06-14T00:00:00 1989-08-13T00:00:00 1989-06-02T00:00:00   1989-09-15T00:00:00  
24 24 01-CA-26144-001 0 0     1990-09-27T00:00:00         1990-09-13T00:00:00      
25 25 01-CA-26183-001 0 0 1992-08-24T00:00:00 Board 1992-09-14T00:00:00         1992-08-31T00:00:00      
26 26 01-CA-26232-001 0 0 1992-01-22T00:00:00 SETTL                  
27 27 01-CA-26237-001 0 0 1992-01-22T00:00:00 SETTL 1992-02-06T00:00:00         1992-01-23T00:00:00      
28 28 01-CA-26270-001 0 0 1992-08-24T00:00:00 Board 1992-09-14T00:00:00         1992-08-31T00:00:00      
29 29 01-CA-26353-001 0 0 1992-08-24T00:00:00 Board 1992-09-14T00:00:00         1992-08-31T00:00:00      
30 30 01-CA-26463-001 0 0 1992-03-06T00:00:00 Board 1992-03-30T00:00:00 CHP Facil     1992-03-16T00:00:00   1992-06-29T00:00:00  
31 31 01-CA-26463-002 0 0 1992-03-06T00:00:00 Board 1992-03-30T00:00:00         1992-03-16T00:00:00      
32 32 01-CA-26463-003 0 0 1992-03-06T00:00:00 Board 1992-03-30T00:00:00         1992-03-16T00:00:00      
33 33 01-CA-26463-005 0 0 1992-03-06T00:00:00 Board 1992-03-30T00:00:00         1992-03-16T00:00:00      
34 34 01-CA-26573-001 0 0 1991-12-27T00:00:00 Board 1994-08-29T00:00:00         1994-08-15T00:00:00   1994-11-28T00:00:00  
35 35 01-CA-26575-001 0 0 1990-04-20T00:00:00 Board 1990-05-13T00:00:00 CHP Facil 1990-05-03T00:00:00 1990-07-03T00:00:00 1990-04-29T00:00:00   1990-09-18T00:00:00  
36 36 01-CA-26936-001 0 0 1991-06-05T00:00:00 Board 1991-07-01T00:00:00 CHP Facil     1991-06-17T00:00:00      
37 37 01-CA-27014-001 0 0 1990-09-17T00:00:00 Board 1990-10-11T00:00:00         1990-09-27T00:00:00      
38 38 01-CA-27070-001 0 0 1991-12-27T00:00:00 Board 1992-01-21T00:00:00         1992-01-07T00:00:00   1992-04-21T00:00:00  
39 39 01-CA-27142-001 0 0 1992-04-01T00:00:00 Board 1992-04-11T00:00:00 CHP Facil 1992-04-11T00:00:00 1992-06-10T00:00:00        
40 40 01-CA-27197-001 0 0 1990-07-09T00:00:00 SETTL 1990-07-26T00:00:00 CHP Facil 1990-08-05T00:00:00 1990-10-04T00:00:00 1990-07-12T00:00:00   1990-10-25T00:00:00  
41 41 01-CA-27321-001 0 0 1990-12-14T00:00:00 Board 1991-01-10T00:00:00 CHP Facil 1991-10-18T00:00:00 1991-12-17T00:00:00 1990-12-27T00:00:00      
42 42 01-CA-27356-001 0 0 1990-12-10T00:00:00 SETTL 1990-12-24T00:00:00 CHP Mail 1990-12-14T00:00:00 1991-01-03T00:00:00 1990-12-10T00:00:00   1991-03-25T00:00:00  
43 43 01-CA-27417-001 0 0 1990-12-10T00:00:00 SETTL 1990-12-24T00:00:00 CHP Mail 1990-12-14T00:00:00 1991-01-03T00:00:00 1990-12-10T00:00:00   1991-03-25T00:00:00  
44 44 01-CA-27421-001 0 0 1991-12-12T00:00:00 SETTL 1991-12-25T00:00:00 CHP Mail 1991-12-18T00:00:00   1991-12-11T00:00:00   1992-03-25T00:00:00 1992-01-28T00:00:00
45 45 01-CA-27491-001 0 0 1991-12-12T00:00:00 SETTL 1991-12-10T00:00:00 CHP Mail 1991-12-18T00:00:00   1991-11-26T00:00:00   1992-03-10T00:00:00 1992-01-28T00:00:00
46 46 01-CA-27659-001 0 0 1991-12-12T00:00:00 SETTL 1991-12-10T00:00:00 CHP Mail 1991-12-18T00:00:00   1991-11-26T00:00:00   1992-03-10T00:00:00 1992-01-28T00:00:00
47 47 01-CA-27732-001 0 0 1991-12-12T00:00:00 SETTL 1991-12-10T00:00:00 CHP Mail 1991-12-18T00:00:00   1991-11-26T00:00:00   1992-03-10T00:00:00 1992-01-28T00:00:00
48 48 01-CA-27732-002 0 0 1991-12-12T00:00:00 SETTL 1991-12-10T00:00:00 CHP Mail 1991-12-18T00:00:00   1991-11-26T00:00:00   1992-03-10T00:00:00 1992-01-28T00:00:00
49 49 01-CA-27766-001 0 0 1992-01-08T00:00:00 SETTL 1992-01-16T00:00:00         1992-01-02T00:00:00   1992-03-19T00:00:00  
50 50 01-CA-27879-001 0 0 1993-12-10T00:00:00 Board 1993-11-29T00:00:00         1993-11-15T00:00:00      
51 51 01-CA-27908-001 0 0 1992-05-14T00:00:00 Board 1992-06-03T00:00:00         1992-05-20T00:00:00   1992-09-02T00:00:00 2001-05-17T00:00:00
52 52 01-CA-27937-001 0 0 1991-12-12T00:00:00 SETTL 1991-12-25T00:00:00 CHP Mail 1991-12-18T00:00:00   1991-12-11T00:00:00   1992-03-25T00:00:00 1992-01-28T00:00:00
53 53 01-CA-28064-001 0 0 1991-11-27T00:00:00 SETTL 1991-12-17T00:00:00 CHP Mail 1991-12-05T00:00:00 1991-12-24T00:00:00 1991-12-03T00:00:00   1992-02-18T00:00:00 1996-03-11T00:00:00
54 54 01-CA-28250-001 0 0     1992-02-29T00:00:00         1992-02-15T00:00:00   1992-05-30T00:00:00  
55 55 01-CA-28264-001 0 0 1992-01-17T00:00:00 Board 1992-02-12T00:00:00         1992-01-29T00:00:00   1992-05-13T00:00:00  
56 56 01-CA-28348-001 0 0     1993-03-22T00:00:00 CHP Facil 1993-03-19T00:00:00 1993-05-18T00:00:00        
57 57 01-CA-28375-001 0 0 1991-12-20T00:00:00 SETTL 1994-03-30T00:00:00 CHP Facil 1994-03-26T00:00:00 1994-05-27T00:00:00 1994-03-16T00:00:00   1994-06-29T00:00:00  
58 58 01-CA-28375-001 0 1 1994-03-05T00:00:00 Board                  
59 59 01-CA-28376-001 0 0 1992-09-22T00:00:00 SETTL 1992-09-25T00:00:00         1992-09-11T00:00:00      
60 60 01-CA-28418-001 0 0 1996-09-23T00:00:00 Board 1996-09-28T00:00:00 CHP Facil 2000-01-24T00:00:00 2000-03-24T00:00:00 1996-09-14T00:00:00   1996-11-30T00:00:00  
61 61 01-CA-28474-001 0 0 1992-04-01T00:00:00 Board 1992-04-28T00:00:00         1992-04-14T00:00:00      
62 62 01-CA-28481-001 0 0 1992-09-22T00:00:00 SETTL 1992-09-25T00:00:00         1992-09-11T00:00:00   1992-12-25T00:00:00  
63 63 01-CA-28493-001 0 0 1991-11-27T00:00:00 SETTL 1991-12-17T00:00:00 CHP Mail 1991-12-05T00:00:00 1991-12-24T00:00:00 1991-12-03T00:00:00   1992-03-17T00:00:00 1996-03-11T00:00:00
64 64 01-CA-28518-001 0 0 1993-07-08T00:00:00 SETTL 1993-07-15T00:00:00 CHP Mail 1993-07-16T00:00:00   1993-07-01T00:00:00   1993-10-14T00:00:00  
65 65 01-CA-28558-001 0 0 1993-08-25T00:00:00 SETTL 1993-09-14T00:00:00 CHP Facil 1993-09-01T00:00:00 1993-10-31T00:00:00 1993-08-31T00:00:00   1993-11-16T00:00:00  
66 66 01-CA-28590-001 0 0 1996-09-23T00:00:00 Board 1996-09-28T00:00:00 CHP Facil 2000-01-24T00:00:00 2000-03-24T00:00:00 1996-09-14T00:00:00   1996-11-30T00:00:00  
67 67 01-CA-28617-001 0 0 1992-09-22T00:00:00 SETTL 1992-09-25T00:00:00         1992-09-11T00:00:00      
68 68 01-CA-28866-001 0 0 1992-07-22T00:00:00 Board 1992-08-12T00:00:00 CHP Facil 1992-10-01T00:00:00 1992-12-01T00:00:00 1992-07-29T00:00:00   1992-12-09T00:00:00 2001-03-23T00:00:00
69 69 01-CA-28892-001 0 0 1992-01-22T00:00:00 SETTL 1992-02-04T00:00:00         1992-01-21T00:00:00   1992-05-05T00:00:00  
70 70 01-CA-28935-001 0 0 1992-08-04T00:00:00 Board 1992-08-24T00:00:00         1992-08-10T00:00:00   1992-12-21T00:00:00  
71 71 01-CA-28985-001 0 0 1993-02-03T00:00:00 Board 1993-01-06T00:00:00         1992-12-23T00:00:00   1993-03-10T00:00:00  
72 72 01-CA-28985-001 0 1 1993-04-23T00:00:00 CO                  
73 73 01-CA-28985-001 0 2 1994-07-21T00:00:00 CO                  
74 74 01-CA-29051-001 0 0 1994-03-05T00:00:00 Board 1994-03-30T00:00:00 CHP Facil 1994-03-26T00:00:00 1994-05-27T00:00:00 1994-03-16T00:00:00   1994-06-29T00:00:00  
75 75 01-CA-29137-001 0 0 1993-08-25T00:00:00 SETTL 1993-09-14T00:00:00 CHP Facil 1993-09-01T00:00:00 1993-10-31T00:00:00 1993-08-31T00:00:00   1993-11-16T00:00:00  
76 76 01-CA-29145-001 0 0 1993-08-25T00:00:00 SETTL 1993-09-14T00:00:00 CHP Facil 1993-09-01T00:00:00 1993-10-31T00:00:00 1993-08-31T00:00:00   1993-11-16T00:00:00  
77 77 01-CA-29153-001 0 0 1992-07-31T00:00:00 Board 1992-08-24T00:00:00 CHP Facil 1992-09-19T00:00:00 1992-11-19T00:00:00 1992-08-10T00:00:00   1992-12-21T00:00:00  
78 78 01-CA-29179-001 0 0 1993-09-30T00:00:00 SETTL 1993-06-25T00:00:00 CHP Facil 1994-12-08T00:00:00 1995-02-06T00:00:00 1993-06-11T00:00:00      
79 79 01-CA-29217-001 0 0 1993-07-01T00:00:00 SETTL 1993-05-13T00:00:00 CHP Facil 1993-07-07T00:00:00 1993-09-05T00:00:00 1993-04-29T00:00:00      
80 80 01-CA-29220-001 0 0 1992-09-15T00:00:00 Board 1992-09-25T00:00:00         1992-09-11T00:00:00      
81 81 01-CA-29220-001 0 1 1993-02-05T00:00:00 CO                  
82 82 01-CA-29252-001 0 0     1992-12-31T00:00:00 CHP Facil 1992-12-18T00:00:00 1992-02-17T00:00:00 1992-12-17T00:00:00   1993-04-29T00:00:00 2000-07-12T00:00:00
83 83 01-CA-29367-001 0 0 1992-09-17T00:00:00 Board 1992-10-02T00:00:00         1992-09-18T00:00:00      
84 84 01-CA-29406-001 0 0 1993-04-09T00:00:00 Board 1993-05-05T00:00:00         1993-04-21T00:00:00      
85 85 01-CA-29414-001 0 0     1994-11-28T00:00:00         1994-11-14T00:00:00      
86 86 01-CA-29433-001 0 0 1995-05-18T00:00:00 Board 1995-05-28T00:00:00 CHP Facil 1996-07-18T00:00:00 1996-09-18T00:00:00 1995-05-14T00:00:00   1995-08-27T00:00:00 2009-03-11T00:00:00
87 87 01-CA-29434-001 0 0 1995-05-18T00:00:00 Board 1995-05-28T00:00:00 CHP Facil 1996-07-18T00:00:00 1996-09-18T00:00:00 1995-05-14T00:00:00   1995-08-27T00:00:00 2009-03-11T00:00:00
88 88 01-CA-29445-001 0 0 1993-10-25T00:00:00 Board 1993-10-20T00:00:00 CHP Facil 1993-11-01T00:00:00 1993-12-31T00:00:00 1993-10-06T00:00:00   1994-01-19T00:00:00  
89 89 01-CA-29500-001 0 0 1993-08-10T00:00:00 SETTL 1993-09-03T00:00:00 CHP Facil 1993-08-30T00:00:00 1993-10-29T00:00:00 1993-08-20T00:00:00      
90 90 01-CA-29550-001 0 0 1992-09-25T00:00:00 SETTL 1992-10-21T00:00:00 CHP Facil 1992-10-26T00:00:00 1992-12-24T00:00:00 1992-10-07T00:00:00      
91 91 01-CA-29557-001 0 0 1993-10-22T00:00:00 Board 1993-10-08T00:00:00         1993-09-24T00:00:00      
92 92 01-CA-29582-001 0 0 1993-08-25T00:00:00 SETTL 1993-09-14T00:00:00 CHP Facil 1993-09-01T00:00:00 1993-10-31T00:00:00 1993-08-31T00:00:00   1993-11-16T00:00:00  
93 93 01-CA-29602-001 0 0 1993-06-08T00:00:00 SETTL 1993-06-10T00:00:00 CHP Facil 1993-06-14T00:00:00 1993-08-13T00:00:00 1993-05-27T00:00:00      
94 94 01-CA-29621-001 0 0     1996-08-17T00:00:00 CHP Facil 1997-06-20T00:00:00 1997-08-19T00:00:00 1996-08-03T00:00:00      
95 95 01-CA-29631-001 0 0 1993-03-31T00:00:00 SETTL 1993-04-15T00:00:00 CHP Facil 1993-04-06T00:00:00 1993-06-05T00:00:00 1993-04-01T00:00:00   1993-07-15T00:00:00  
96 96 01-CA-29649-001 0 0 1993-10-22T00:00:00 Board 1993-10-08T00:00:00         1993-09-24T00:00:00      
97 97 01-CA-29676-001 0 0 1993-06-08T00:00:00 Board 1993-06-22T00:00:00         1993-06-08T00:00:00   1993-08-24T00:00:00  
98 98 01-CA-29690-001 0 0 1992-12-01T00:00:00 SETTL 1992-12-18T00:00:00 CHP Facil 1992-12-07T00:00:00 1993-02-05T00:00:00 1992-12-04T00:00:00   1993-03-19T00:00:00  
99 99 01-CA-29740-001 0 0     1996-08-17T00:00:00 CHP Facil 1997-06-20T00:00:00 1997-08-19T00:00:00 1996-08-03T00:00:00      
100 100 01-CA-29743-001 0 0     1994-05-12T00:00:00         1994-04-28T00:00:00   1994-07-14T00:00:00  

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "c_compliance_goals" (
    "c_case_number" text,
    "action_sequence" integer,
    "recurrence" integer,
    "letter_date" text,
    "letter_type" text,
    "posting_goal" text,
    "not_post_party" text,
    "posting_type" text,
    "notices_post_dates" text,
    "post_expires" text,
    "reinstatement_goal" text,
    "reinstatement_offered" text,
    "closing_goal" text,
    "backpay_received" text
);