c_alj_decision
20,118 rows
Suggested facets: action_sequence, recurrence, eot_brief_party, eot_determination, alj_brief_party, alj_brief_type, determination, brief_due_date (date), eot_request_rcvd_alj (date), eot_deter_date (date), alj_date_filed (date), alj_brief_rcvd_region (date), determination_date (date)
| c_case_number | action_sequence | recurrence | brief_due_date | eot_request_rcvd_alj | eot_brief_party | eot_deter_date | eot_determination | alj_date_filed | alj_brief_rcvd_region | alj_brief_party | alj_brief_type | determination_date | determination |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01-CA-19224-001 | 0 | 0 | 1989-04-05 | PartM | |||||||||
| 01-CA-19567-001 | 0 | 0 | 1988-05-31 | 1988-08-19 | GC | Initl | 1989-04-05 | PartM | |||||
| 01-CA-19690-001 | 0 | 0 | 1988-05-31 | 1988-08-19 | GC | Initl | 1989-04-05 | PartM | |||||
| 01-CA-19731-001 | 0 | 0 | 1983-04-11 | 1983-06-30 | FullM | ||||||||
| 01-CA-19797-001 | 0 | 0 | 1983-04-11 | 1983-06-30 | FullM | ||||||||
| 01-CA-19903-001 | 0 | 0 | 1983-04-11 | 1983-06-30 | FullM | ||||||||
| 01-CA-19958-001 | 0 | 0 | 1988-05-31 | 1988-08-19 | GC | Initl | 1989-04-05 | PartM | |||||
| 01-CA-20007-001 | 0 | 0 | 1983-04-11 | 1983-06-30 | FullM | ||||||||
| 01-CA-20157-001 | 0 | 0 | 1983-04-11 | 1983-06-30 | FullM | ||||||||
| 01-CA-20218-001 | 0 | 0 | 1983-04-11 | 1983-06-30 | FullM | ||||||||
| 01-CA-20283-001 | 0 | 0 | 1988-05-31 | 1988-08-19 | GC | Initl | 1989-04-05 | PartM | |||||
| 01-CA-20291-001 | 0 | 0 | 1988-05-31 | 1988-08-19 | GC | Initl | 1989-04-05 | PartM | |||||
| 01-CA-20304-001 | 0 | 0 | 1988-05-31 | 1988-08-19 | GC | Initl | 1989-04-05 | PartM | |||||
| 01-CA-20442-001 | 0 | 0 | 1983-04-11 | 1983-06-30 | FullM | ||||||||
| 01-CA-20508-001 | 0 | 0 | 1988-05-31 | 1988-08-19 | GC | Initl | 1989-04-05 | PartM | |||||
| 01-CA-20521-001 | 0 | 0 | 1983-04-11 | 1983-06-30 | FullM | ||||||||
| 01-CA-21438-001 | 0 | 0 | 1983-04-11 | 1983-06-30 | FullM | ||||||||
| 01-CA-21560-001 | 0 | 0 | 1988-05-31 | 1988-08-19 | GC | Initl | 1989-04-05 | PartM | |||||
| 01-CA-22687-001 | 0 | 0 | 1996-06-06 | FullM | |||||||||
| 01-CA-22769-001 | 0 | 0 | 1996-06-06 | FullM | |||||||||
| 01-CA-22869-001 | 0 | 0 | 1996-06-06 | FullM | |||||||||
| 01-CA-23427-001 | 0 | 0 | 1989-02-13 | 1989-03-22 | FullM | ||||||||
| 01-CA-23576-001 | 0 | 0 | 1996-06-06 | FullM | |||||||||
| 01-CA-24372-001 | 0 | 0 | 1987-07-10 | FullM | |||||||||
| 01-CA-24863-001 | 0 | 0 | 1988-07-15 | ||||||||||
| 01-CA-24883-001 | 0 | 0 | 1988-07-15 | ||||||||||
| 01-CA-25521-001 | 0 | 0 | 1991-07-30 | 1991-07-29 | GC | Initl | 1991-10-11 | Dismi | |||||
| 01-CA-25599-001 | 0 | 0 | 1996-06-06 | FullM | |||||||||
| 01-CA-25656-001 | 0 | 0 | 1990-04-25 | FullM | |||||||||
| 01-CA-25736-001 | 0 | 0 | 1989-03-01 | FullM | |||||||||
| 01-CA-25805-001 | 0 | 0 | 1996-06-06 | FullM | |||||||||
| 01-CA-25864-001 | 0 | 0 | 1991-07-30 | 1991-07-29 | GC | Initl | 1991-10-11 | Dismi | |||||
| 01-CA-25896-001 | 0 | 0 | 1996-06-06 | FullM | |||||||||
| 01-CA-25940-001 | 0 | 0 | 1990-04-26 | 1990-04-25 | GC | Initl | 1991-06-18 | FullM | |||||
| 01-CA-25969-001 | 0 | 0 | 1989-10-30 | 1989-11-24 | FullM | ||||||||
| 01-CA-26144-001 | 0 | 0 | 1990-04-25 | FullM | |||||||||
| 01-CA-26463-001 | 0 | 0 | 1990-07-06 | 1990-07-05 | GC | Initl | 1991-04-08 | FullM | |||||
| 01-CA-26463-001 | 1 | 0 | 1994-05-19 | FullM | |||||||||
| 01-CA-26463-002 | 0 | 0 | 1990-07-06 | 1990-07-05 | GC | Initl | 1991-04-08 | FullM | |||||
| 01-CA-26463-002 | 1 | 0 | 1994-05-19 | Dismi | |||||||||
| 01-CA-26463-003 | 0 | 0 | 1990-07-06 | 1991-04-08 | Dismi | ||||||||
| 01-CA-26463-003 | 1 | 0 | 1994-05-19 | Dismi | |||||||||
| 01-CA-26463-004 | 0 | 0 | 1990-05-21 | 1991-04-08 | Dismi | ||||||||
| 01-CA-26463-005 | 0 | 0 | 1990-07-06 | 1994-05-19 | Dismi | ||||||||
| 01-CA-26463-005 | 1 | 0 | 1994-05-19 | Dismi | |||||||||
| 01-CA-26463-006 | 0 | 0 | 1990-07-06 | 1991-05-28 | Dismi | ||||||||
| 01-CA-26573-001 | 0 | 0 | 1990-07-19 | 1990-11-02 | 1990-11-02 | GC | Initl | 1991-03-29 | FullM | ||||
| 01-CA-26744-001 | 0 | 0 | 1990-08-06 | 1990-08-02 | GC | Initl | 1993-02-16 | PartM | |||||
| 01-CA-26820-001 | 0 | 0 | 1991-12-13 | 1991-12-12 | 1991-12-12 | GC | Initl | 1992-06-03 | Dismi | ||||
| 01-CA-27014-001 | 0 | 0 | 1990-08-03 | FullM | |||||||||
| 01-CA-27070-001 | 0 | 0 | 1990-07-19 | 1990-11-02 | 1990-11-02 | GC | Initl | 1991-03-29 | FullM | ||||
| 01-CA-27322-001 | 0 | 0 | 1991-10-09 | FullM | |||||||||
| 01-CA-27322-001 | 1 | 0 | 1991-11-18 | FullM | |||||||||
| 01-CA-27385-001 | 0 | 0 | 1991-10-09 | FullM | |||||||||
| 01-CA-27385-001 | 1 | 0 | 1991-11-18 | FullM | |||||||||
| 01-CA-27386-001 | 0 | 0 | 1991-10-09 | FullM | |||||||||
| 01-CA-27386-001 | 1 | 0 | 1991-11-18 | FullM | |||||||||
| 01-CA-27800-001 | 0 | 0 | 1994-01-17 | 1994-05-05 | FullM | ||||||||
| 01-CA-27953-001 | 0 | 0 | 1991-10-09 | FullM | |||||||||
| 01-CA-27953-001 | 1 | 0 | 1991-11-18 | FullM | |||||||||
| 01-CA-28315-001 | 0 | 0 | 1993-02-22 | FullM | |||||||||
| 01-CA-28375-001 | 0 | 0 | 1992-12-18 | 1992-12-17 | 1992-12-17 | GC | Initl | 1993-03-24 | FullM | ||||
| 01-CA-28375-001 | 0 | 1 | 1992-12-17 | CHP | Initl | ||||||||
| 01-CA-28409-001 | 0 | 0 | 1993-02-22 | FullM | |||||||||
| 01-CA-28418-001 | 0 | 0 | 1992-07-20 | 1992-09-24 | 1992-09-24 | GC | Initl | 1992-12-01 | FullM | ||||
| 01-CA-28590-001 | 0 | 0 | 1992-07-20 | 1992-09-24 | 1992-09-24 | GC | Initl | 1992-12-01 | FullM | ||||
| 01-CA-29051-001 | 0 | 0 | 1992-12-18 | 1992-12-17 | 1992-12-17 | GC | Initl | 1993-03-24 | FullM | ||||
| 01-CA-29051-001 | 0 | 1 | 1992-12-17 | 1992-12-17 | CHP | Initl | |||||||
| 01-CA-29179-001 | 0 | 0 | 1993-05-27 | 1993-05-25 | GC | Initl | 1994-01-11 | FullM | |||||
| 01-CA-29224-001 | 0 | 0 | 1993-05-27 | 1993-05-25 | GC | Initl | 1994-01-11 | FullM | |||||
| 01-CA-29414-001 | 0 | 0 | 1994-01-11 | FullM | |||||||||
| 01-CA-29433-001 | 0 | 0 | 1993-05-20 | 1993-05-19 | 1993-05-19 | GC | Initl | 1993-11-22 | PartM | ||||
| 01-CA-29434-001 | 0 | 0 | 1993-05-20 | 1993-05-19 | 1993-05-19 | GC | Initl | 1993-11-22 | PartM | ||||
| 01-CA-29621-001 | 0 | 0 | 1993-12-09 | 1993-12-09 | 1993-12-09 | GC | Initl | 1994-06-30 | Dismi | ||||
| 01-CA-29621-001 | 0 | 1 | 1993-12-09 | 1993-12-13 | CHP | Initl | |||||||
| 01-CA-29740-001 | 0 | 0 | 1993-12-09 | 1993-12-09 | 1993-12-09 | GC | Initl | 1994-06-30 | Dismi | ||||
| 01-CA-29740-001 | 0 | 1 | 1993-12-09 | 1993-12-13 | CHP | Initl | |||||||
| 01-CA-29743-001 | 0 | 0 | 1993-10-01 | 1993-12-02 | 1993-12-02 | GC | Initl | 1994-02-04 | PartM | ||||
| 01-CA-29743-001 | 0 | 1 | 1993-12-06 | 1993-12-08 | CHP | Initl | |||||||
| 01-CA-29751-001 | 0 | 0 | 1993-09-03 | 1993-11-22 | 1993-11-22 | GC | Initl | 1994-12-08 | Other | ||||
| 01-CA-29796-001 | 0 | 0 | 1993-11-19 | 1993-11-22 | 1993-11-22 | GC | Initl | 1994-12-08 | Other | ||||
| 01-CA-29844-001 | 0 | 0 | 1993-08-02 | 1993-07-29 | GC | Initl | 1993-09-08 | FullM | |||||
| 01-CA-29966-001 | 0 | 0 | 1995-07-28 | 1996-06-14 | FullM | ||||||||
| 01-CA-29985-001 | 0 | 0 | 1993-11-22 | 1993-12-09 | 1993-12-09 | GC | Initl | 1993-12-30 | FullM | ||||
| 01-CA-30044-001 | 0 | 0 | 1993-08-02 | 1993-07-29 | GC | Initl | 1993-09-08 | FullM | |||||
| 01-CA-30236-001 | 0 | 0 | 1993-11-22 | 1993-12-09 | 1993-12-09 | GC | Initl | 1993-12-30 | FullM | ||||
| 01-CA-30297-001 | 0 | 0 | 1993-12-09 | 1993-12-09 | 1993-12-09 | GC | Initl | 1994-06-30 | Dismi | ||||
| 01-CA-30297-001 | 0 | 1 | 1993-12-09 | 1993-12-13 | CHP | Initl | |||||||
| 01-CA-30428-001 | 0 | 0 | 1993-12-09 | 1993-12-09 | 1993-12-09 | GC | Initl | 1994-06-30 | Dismi | ||||
| 01-CA-30428-001 | 0 | 1 | 1993-12-09 | 1993-12-13 | CHP | Initl | |||||||
| 01-CA-30434-001 | 0 | 0 | 1996-11-07 | 1996-12-09 | 1996-12-09 | GC | Initl | 1997-03-07 | Dismi | ||||
| 01-CA-30434-001 | 0 | 1 | 1996-12-10 | 1996-12-11 | CHP | Initl | |||||||
| 01-CA-30470-001 | 0 | 0 | 1994-06-20 | 1994-06-17 | 1994-06-17 | GC | Initl | 1995-07-31 | FullM | ||||
| 01-CA-30470-001 | 0 | 1 | 1994-06-20 | 1994-06-20 | CHP | Initl | |||||||
| 01-CA-30745-001 | 0 | 0 | 1997-12-05 | 1997-12-03 | GC | Initl | 1998-01-26 | Dismi | |||||
| 01-CA-30745-001 | 0 | 1 | 1997-12-04 | 1997-12-05 | CHP | Initl | |||||||
| 01-CA-30745-001 | 0 | 2 | 1997-12-04 | 1997-12-05 | CGP | Initl | |||||||
| 01-CA-31010-001 | 0 | 0 | 1996-11-07 | 1996-12-09 | 1996-12-09 | GC | Initl | 1997-03-07 | PartM | ||||
| 01-CA-31010-001 | 0 | 1 | 1996-12-10 | 1996-12-11 | CHP | Initl | |||||||
| 01-CA-31148-001 | 0 | 0 | 1994-08-22 | 1994-09-30 | GC | Initl | 1994-11-03 | FullM |
Table schema
CREATE TABLE c_alj_decision(c_case_number VARCHAR, action_sequence BIGINT, recurrence BIGINT, brief_due_date DATE, eot_request_rcvd_alj DATE, eot_brief_party VARCHAR, eot_deter_date DATE, eot_determination VARCHAR, alj_date_filed DATE, alj_brief_rcvd_region DATE, alj_brief_party VARCHAR, alj_brief_type VARCHAR, determination_date DATE, determination VARCHAR);