c_sup_aljd_cmp

726 rows

✎ View and edit SQL

Suggested facets: action_sequence, recurrence, eot_brief_party, eot_brief_determination, alj_brief_party, aljd_comp_determination, brief_due_date (date), eot_request_rcvd_alj (date), eot_brief_deter_date (date), alj_brief_rcvd_region (date), alj_brief_rcvd_alj (date), alj_date_filed (date), aljd_comp_date (date)

c_case_number action_sequence recurrence brief_due_date eot_request_rcvd_alj eot_brief_party eot_brief_deter_date eot_brief_determination alj_brief_rcvd_region alj_brief_party eot_brief_type alj_brief_rcvd_alj alj_date_filed aljd_comp_date aljd_comp_determination
01-CA-22687-001 0 0                     1996-06-06  
01-CA-22769-001 0 0                     1996-06-06  
01-CA-22869-001 0 0                     1996-06-06  
01-CA-23576-001 0 0                     1996-06-06  
01-CA-25599-001 0 0                     1996-06-06  
01-CA-25736-001 0 0                     1989-03-01 1
01-CA-25805-001 0 0                     1996-06-06  
01-CA-25896-001 0 0                     1996-06-06  
01-CA-25969-001 0 0                     1998-02-17 1
01-CA-27908-001 0 0 1994-08-24         1994-08-24 GC   1994-08-24 1994-08-23 1994-09-16 1
01-CA-29179-001 0 0                     1994-01-11  
01-CA-29433-001 0 0                     2001-08-08 1
01-CA-29434-001 0 0                     2001-08-08 1
01-CA-31148-001 0 0 2005-06-03 2005-05-20 GC 2005-06-17 Grant   GC     2005-06-16 2005-06-29 1
01-CA-31148-001 0 1             CHP     2005-06-15    
01-CA-31158-001 0 0 2005-06-03 2005-05-20 GC 2005-06-17 Grant   GC     2005-06-16 2005-06-29 1
01-CA-31158-001 0 1             CHP     2005-06-15    
01-CA-33353-001 0 0 2003-08-19           GC     2003-09-11 2003-10-29 5
01-CA-33353-001 0 1             CHP     2003-09-11    
01-CA-33353-001 1 0                     2004-03-30 1
01-CA-33762-001 0 0 2003-08-19           GC     2003-09-11 2003-10-29 5
01-CA-33762-001 0 1             CHP     2003-09-11    
01-CA-33762-001 1 0                     2004-03-30 1
01-CA-33956-001 0 0 2003-08-19           GC     2003-09-11 2003-10-29 5
01-CA-33956-001 0 1             CHP     2003-09-11    
01-CA-33956-001 1 0                     2004-03-30 1
01-CA-34066-001 0 0 2003-08-19           GC     2003-09-11 2003-10-29 5
01-CA-34066-001 0 1             CHP     2003-09-11    
01-CA-34066-001 1 0                     2004-03-30 1
01-CA-36229-001 0 0                     1998-12-29  
01-CA-43892-001 0 0 2010-02-17 2010-01-26 GC 2010-03-31 Grant   GC     2010-03-30 2010-06-04 1
01-CA-43892-001 0 1             CHP     2010-03-31    
02-CA-17769-001 0 0 1994-06-14         1994-06-14 GC   1994-06-14 1994-06-14 1997-06-10 2
02-CA-21761-001 0 0                     1990-07-27 1
02-CA-21917-001 0 0                     1990-07-27 1
02-CA-21931-001 0 0                     1990-07-27 1
02-CA-25886-001 0 0 1999-07-30         1999-08-03 CGP   1999-08-03 1999-07-30 1999-11-15 1
02-CA-26131-001 0 0 1999-07-30         1999-08-03 CGP   1999-08-03 1999-08-03 1999-11-15 1
02-CA-26152-001 0 0 1999-07-30         1999-08-03 CGP   1999-08-03 1999-07-30 1999-11-05 1
02-CA-26386-001 1 0 1999-08-03         1999-08-03 CGP   1999-08-03 1999-08-03 1999-11-15 1
02-CA-26390-001 1 0                     1999-11-15 1
02-CA-26409-001 1 0                     1999-11-15 1
02-CA-26844-001 0 0 1999-04-22                   1999-06-03 1
02-CA-28129-001 0 0                     1999-10-06 1
02-CA-28129-001 1 0                     2000-08-22 2
02-CA-29306-001 0 0 2001-06-22                   2001-06-22 5
02-CA-29311-001 0 0 1999-07-12                   1997-08-29 5
02-CA-29311-001 1 0                     1999-11-10 2
02-CA-30569-001 0 0 2000-08-16         2000-09-19 GC   2000-09-20 2000-09-19 2000-12-29 4
02-CA-30701-001 0 0                     1999-09-29 5
02-CA-30788-001 0 0                     2000-02-16 1
02-CA-30862-001 0 0                     2000-02-16 1
02-CA-30905-001 0 0                     2000-02-16 1
02-CA-30986-001 0 0                     2000-02-16 1
02-CA-31011-001 0 0 2000-08-16         2000-09-19 GC   2000-09-20 2000-09-19 2000-12-29 4
02-CA-31025-001 0 0                     2000-02-16 1
02-CA-31170-001 0 0                     2000-02-16 1
02-CA-31494-001 0 0 2003-12-19 2003-12-12 GC 2003-12-15 Grant 2004-01-30 CHP   2004-01-30 2004-01-29 2004-05-21 1
02-CA-31504-001 0 0 2005-01-06 2005-01-04 CHP 2005-01-05 Grant 2005-02-10 GC   2005-02-11 2005-02-10 2005-03-08 1
02-CA-31771-001 0 0                     1999-07-20 5
02-CA-32559-001 0 0 2010-07-26 2010-07-12 GC 2010-07-14 Grant 2010-08-06 GC   2010-08-06 2010-08-06 2010-09-07 1
02-CA-32559-001 0 1           2010-08-09 CHP   2010-08-09 2010-08-06    
02-CA-32778-001 0 0 2010-07-26 2010-07-12 GC 2010-07-14 Grant 2010-08-06 GC   2010-08-06 2010-08-06 2010-09-07 1
02-CA-32778-001 0 1           2010-08-09 CHP   2010-08-09 2010-08-06    
02-CA-32811-001 0 0 2005-04-01 2005-03-28 GC 2005-03-28 Grant 2005-04-15 GC   2005-04-15 2005-04-15 2005-05-10 1
02-CA-32941-001 0 0 2010-07-26 2010-07-12 GC 2010-07-14 Grant 2010-08-06 GC   2010-08-06 2010-08-06 2010-09-07 1
02-CA-32941-001 0 1           2010-08-09 CHP   2010-08-09 2010-08-06    
02-CA-33144-001 0 0 2010-07-26 2010-07-12 GC 2010-07-14 Grant 2010-08-06 GC   2010-08-06 2010-08-06 2010-09-07 1
02-CA-33144-001 0 1           2010-08-09 CHP   2010-08-09 2010-08-06    
02-CA-33267-001 0 0 2010-07-26 2010-07-12 GC 2010-07-14 Grant 2010-08-06 GC   2010-08-06 2010-08-06 2010-09-07 1
02-CA-33267-001 0 1           2010-08-09 CHP   2010-08-09 2010-08-06    
02-CA-33316-001 0 0 2004-03-01 2004-02-10 GC 2004-02-11 Grant 2004-03-29 GC   2004-03-30 2004-03-29 2004-04-13 1
02-CA-34613-001 0 0 2006-04-06                   2007-03-12 5
02-CA-35054-001 0 0 2004-08-12 2004-08-04 CHP 2004-08-04 Grant 2004-08-26 GC   2004-08-27 2004-08-26 2004-09-10 1
02-CA-35306-001 0 0 2006-04-06                   2007-03-12 5
02-CA-35495-001 0 0 2006-04-06                   2007-03-12 5
02-CA-35621-001 0 0 2006-04-06                   2007-03-12 5
02-CA-37967-001 0 0 2009-05-12 2009-05-08 CHP 2009-05-08 Grant 2009-05-26 CHP   2009-05-26 2009-05-26 2009-11-18 1
02-CA-37967-001 0 1           2009-05-26 GC   2009-05-26 2009-05-26    
02-CB-08676-001 1 0 1994-06-14         1994-06-14 GC   1994-06-14 1994-06-14 1987-06-10 2
02-CB-16789-001 0 0                     1999-09-29 5
03-CA-17899-001 0 0 1997-05-27 1997-05-12 CHP 1997-05-23 Grant   GC     1997-06-19 1997-09-05 1
03-CA-17899-001 0 1             EMPL     1997-06-19    
03-CA-17908-001 0 0 1996-07-23 1996-07-08 CHP 1996-08-02 Grant   GC     1996-08-01 1996-09-27 1
03-CA-17908-001 0 1             CHP     1996-07-31    
03-CA-17908-001 0 2             CGP     1996-08-02    
03-CA-18504-001 0 0                     1998-03-30 4
03-CA-18626-001 0 0 2000-07-25 2000-07-07 CGP 2000-07-07 Grant   GC     2000-08-03 2000-09-18 5
03-CA-18626-001 0 1   2000-11-17 GC 2000-11-17 Grant   CHP     2000-08-04    
03-CA-18626-001 0 2             CHP     2000-08-07    
03-CA-18626-001 0 3             CGP     2000-08-02    
03-CA-18750-001 0 0 2000-07-25 2000-07-07 CGP 2000-07-07 Grant   CHP     2000-08-07 2000-09-18 5
03-CA-18750-001 0 1           2000-08-04 CHP   2000-08-04 2000-08-04    
03-CA-18750-001 0 2           2000-08-03 GC   2000-08-04 2000-08-03    
03-CA-18750-001 0 3             CGP     2000-08-02    
03-CA-18760-001 0 0 2000-07-25           CHP     2000-08-07 2000-09-18 5
03-CA-18760-001 0 1           2000-08-04 CGP   2000-08-04 2000-08-04    
03-CA-18760-001 0 2           2000-08-03 GC   2000-08-04 2000-08-03    
03-CA-18760-001 0 3             CGP     2000-08-02    
03-CA-18760-001 1 0                     2000-09-18 1

Next page

Download this data

CSV · JSON

Table schema 
CREATE TABLE c_sup_aljd_cmp(c_case_number VARCHAR, action_sequence BIGINT, recurrence BIGINT, brief_due_date DATE, eot_request_rcvd_alj DATE, eot_brief_party VARCHAR, eot_brief_deter_date DATE, eot_brief_determination VARCHAR, alj_brief_rcvd_region DATE, alj_brief_party VARCHAR, eot_brief_type BIGINT, alj_brief_rcvd_alj DATE, alj_date_filed DATE, aljd_comp_date DATE, aljd_comp_determination BIGINT);