c_enforcement
9,649 rows
Suggested facets: action_sequence, recurrence, petition_party, petition_court, brief_rcvd_date, brief_rcvd_party, brief_pleading, oral_arg_sch_date, oral_arg_date, court_action_type, court_action_action, som_date, request_date, request_party, request_determination, date_settlement_approved, settlement_type, petition_date (date), brief_rcvd_date (date), oral_arg_sch_date (date), oral_arg_date (date), court_deter_date (date), som_date (date), request_date (date), request_deter_date (date), date_received_region (date), som_date_deter (date), date_settlement_approved (date)
| c_case_number | action_sequence | recurrence | petition_date | petition_party | petition_court | brief_rcvd_date | brief_rcvd_party | brief_pleading | oral_arg_sch_date | oral_arg_date | court_deter_date | court_action_type | court_action_action | case_citation | som_date | som_determination | request_date | request_party | request_deter_date | request_determination | date_received_region | som_date_deter | eot_date_filed | eot_party | eot_determination_date | eot_determination | date_settlement_approved | settlement_type |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01-CA-19224-001 | 0 | 0 | 1995-06-08 | Judge | 8 | |||||||||||||||||||||||
| 01-CA-19224-001 | 1 | 0 | 1997-02-27 | CGP | 10 | 1997-10-24 | 1997-12-12 | Judge | 4 | 97-1026 | ||||||||||||||||||
| 01-CA-19567-001 | 0 | 0 | 1995-06-08 | Mandt | 8 | |||||||||||||||||||||||
| 01-CA-19567-001 | 1 | 0 | 1997-02-27 | CGP | 10 | 1997-10-24 | 1997-12-12 | Judge | 4 | |||||||||||||||||||
| 01-CA-19690-001 | 0 | 0 | 1997-02-27 | CGP | 10 | 1995-06-08 | Mandt | 8 | ||||||||||||||||||||
| 01-CA-19690-001 | 1 | 0 | 1997-02-27 | CGP | 10 | 1997-10-24 | 1997-12-12 | Judge | 4 | |||||||||||||||||||
| 01-CA-19731-001 | 0 | 0 | ||||||||||||||||||||||||||
| 01-CA-19797-001 | 0 | 0 | ||||||||||||||||||||||||||
| 01-CA-19903-001 | 0 | 0 | ||||||||||||||||||||||||||
| 01-CA-19958-001 | 0 | 0 | 1997-02-27 | CGP | 10 | 1997-10-24 | 1995-06-08 | Mandt | 8 | |||||||||||||||||||
| 01-CA-19958-001 | 1 | 0 | 1997-02-27 | CGP | 10 | 1997-12-12 | Judge | 4 | ||||||||||||||||||||
| 01-CA-20007-001 | 0 | 0 | ||||||||||||||||||||||||||
| 01-CA-20157-001 | 0 | 0 | ||||||||||||||||||||||||||
| 01-CA-20218-001 | 0 | 0 | ||||||||||||||||||||||||||
| 01-CA-20283-001 | 0 | 0 | 1995-06-08 | Mandt | 8 | |||||||||||||||||||||||
| 01-CA-20283-001 | 1 | 0 | 1997-02-27 | CGP | 10 | 1997-10-24 | 1997-12-12 | Judge | 4 | |||||||||||||||||||
| 01-CA-20291-001 | 0 | 0 | 1997-02-27 | CGP | 10 | 1997-10-24 | 1995-06-08 | Mandt | 8 | |||||||||||||||||||
| 01-CA-20291-001 | 1 | 0 | 1997-02-27 | CGP | 10 | 1997-12-12 | Judge | 4 | ||||||||||||||||||||
| 01-CA-20304-001 | 0 | 0 | 1997-02-27 | CGP | 10 | 1997-10-24 | 1995-06-08 | Mandt | 8 | |||||||||||||||||||
| 01-CA-20304-001 | 1 | 0 | 1997-02-27 | CGP | 10 | 1997-12-12 | Judge | 4 | ||||||||||||||||||||
| 01-CA-20442-001 | 0 | 0 | ||||||||||||||||||||||||||
| 01-CA-20508-001 | 0 | 0 | 1997-02-27 | CGP | 10 | 1995-06-08 | Mandt | 8 | ||||||||||||||||||||
| 01-CA-20508-001 | 1 | 0 | 1997-02-27 | CGP | 10 | 1997-12-12 | Judge | 4 | ||||||||||||||||||||
| 01-CA-20521-001 | 0 | 0 | ||||||||||||||||||||||||||
| 01-CA-21438-001 | 0 | 0 | ||||||||||||||||||||||||||
| 01-CA-21560-001 | 0 | 0 | 1997-02-27 | CGP | 10 | 1995-06-08 | Mandt | 8 | ||||||||||||||||||||
| 01-CA-21560-001 | 1 | 0 | 1997-02-27 | CGP | 10 | 1997-12-12 | Judge | 4 | ||||||||||||||||||||
| 01-CA-23427-001 | 0 | 0 | 1986-08-19 | CHP | 60 | 1986-12-08 | CB | Initl | 1987-11-12 | 8 | 86-1199 | |||||||||||||||||
| 01-CA-24372-001 | 0 | 0 | ||||||||||||||||||||||||||
| 01-CA-25656-001 | 0 | 0 | 1990-10-16 | CB | 60 | 1991-02-06 | Mandt | 1 | 90-2736 | |||||||||||||||||||
| 01-CA-25736-001 | 0 | 0 | ||||||||||||||||||||||||||
| 01-CA-25969-001 | 0 | 0 | 1991-09-05 | CB | 30 | 1995-07-21 | Judge | 1 | 91-1905 | 1995-07-31 | ||||||||||||||||||
| 01-CA-25969-001 | 1 | 0 | 1998-06-08 | CB | 30 | 1998-09-18 | CnDcr | 1 | 98-1661 | 1998-09-25 | ||||||||||||||||||
| 01-CA-26144-001 | 0 | 0 | 1990-10-16 | CB | 60 | 1991-02-12 | Mandt | 1 | 90-2736 | |||||||||||||||||||
| 01-CA-26463-001 | 0 | 0 | 1993-02-04 | Mandt | 8 | 92-1525 | ||||||||||||||||||||||
| 01-CA-26463-001 | 1 | 0 | 1996-06-25 | Mandt | 1 | |||||||||||||||||||||||
| 01-CA-26463-001 | 2 | 0 | ||||||||||||||||||||||||||
| 01-CA-26463-002 | 0 | 0 | 1993-02-04 | 8 | 92-1525 | |||||||||||||||||||||||
| 01-CA-26463-002 | 1 | 0 | 1996-06-25 | Mandt | 1 | |||||||||||||||||||||||
| 01-CA-26463-002 | 2 | 0 | ||||||||||||||||||||||||||
| 01-CA-26463-003 | 0 | 0 | 1993-02-04 | 8 | 92-1525 | |||||||||||||||||||||||
| 01-CA-26463-003 | 1 | 0 | 1996-06-25 | Mandt | 1 | |||||||||||||||||||||||
| 01-CA-26463-004 | 0 | 0 | ||||||||||||||||||||||||||
| 01-CA-26463-005 | 0 | 0 | 1993-02-04 | 8 | 92-1525 | |||||||||||||||||||||||
| 01-CA-26463-005 | 1 | 0 | 1996-06-25 | Mandt | 1 | |||||||||||||||||||||||
| 01-CA-26463-006 | 0 | 0 | ||||||||||||||||||||||||||
| 01-CA-26573-001 | 0 | 0 | 1994-03-18 | Judge | 2 | 93-1604 | 1994-04-04 | Grant | 1994-03-21 | 1994-04-11T00:00:00 | ||||||||||||||||||
| 01-CA-26575-001 | 0 | 0 | ||||||||||||||||||||||||||
| 01-CA-26575-001 | 1 | 0 | ||||||||||||||||||||||||||
| 01-CA-26936-001 | 0 | 0 | 1992-03-13 | CB | 30 | 1992-04-02 | Judge | 1 | 92-1294 | 1992-10-05 | ||||||||||||||||||
| 01-CA-27070-001 | 0 | 0 | 1994-03-18 | Judge | 2 | 93-1604 | 1994-04-04 | Grant | 1994-03-21 | 1994-04-11T00:00:00 | ||||||||||||||||||
| 01-CA-27142-001 | 0 | 0 | ||||||||||||||||||||||||||
| 01-CA-27321-001 | 0 | 0 | 1991-08-29 | CB | 30 | 1991-10-21 | Judge | 1 | 91-1875 | |||||||||||||||||||
| 01-CA-27321-001 | 1 | 0 | 1992-10-22 | Judge | 1 | 92-2126 | 1992-11-02 | |||||||||||||||||||||
| 01-CA-27322-001 | 0 | 0 | 1992-07-16 | CB | 1992-08-12 | Judge | 1 | 1992-08-20 | ||||||||||||||||||||
| 01-CA-27385-001 | 0 | 0 | 1992-07-16 | CB | 1992-08-12 | Judge | 1 | 1992-08-20 | ||||||||||||||||||||
| 01-CA-27386-001 | 0 | 0 | 1992-07-16 | CB | 1992-08-12 | Judge | 1 | 1992-08-20 | ||||||||||||||||||||
| 01-CA-27506-001 | 0 | 0 | 1995-08-01 | Mandt | 1 | 1995-08-01 | ||||||||||||||||||||||
| 01-CA-27506-001 | 1 | 0 | 1995-08-01 | Mandt | 1 | 1995-08-17 | 1995-08-01 | |||||||||||||||||||||
| 01-CA-27731-001 | 0 | 0 | 1992-04-03 | CB | 30 | 1992-05-05 | Judge | 1 | ||||||||||||||||||||
| 01-CA-27908-001 | 0 | 0 | 1992-10-02 | CB | 30 | 1992-10-27 | Judge | 1 | 1992-10-28 | |||||||||||||||||||
| 01-CA-27908-001 | 1 | 0 | 1996-04-18 | CB | 30 | 1996-08-26 | Judge | 1 | 96-1344 | 1996-08-27 | ||||||||||||||||||
| 01-CA-27953-001 | 0 | 0 | 1992-07-16 | CB | 1992-08-12 | Judge | 1 | 1992-08-20 | ||||||||||||||||||||
| 01-CA-28264-001 | 0 | 0 | 1992-09-17 | Judge | 1 | 92-1996 | 1992-09-28 | |||||||||||||||||||||
| 01-CA-28474-001 | 0 | 0 | 1992-10-01 | Judge | 1 | |||||||||||||||||||||||
| 01-CA-28985-001 | 0 | 0 | 1993-03-25 | CB | 30 | 1993-04-13 | Mandt | 1 | 93-1323 | 1993-05-05 | ||||||||||||||||||
| 01-CA-28985-001 | 0 | 1 | 1994-12-14 | Judge | 1 | 94-2189 | ||||||||||||||||||||||
| 01-CA-28985-001 | 0 | 2 | 1995-02-03 | Judge | 1 | 94-2189 | 1995-02-05 | |||||||||||||||||||||
| 01-CA-29153-001 | 0 | 0 | ||||||||||||||||||||||||||
| 01-CA-29220-001 | 0 | 0 | 1992-12-16 | Judge | 1 | 92-2355 | 1993-01-11 | |||||||||||||||||||||
| 01-CA-29367-001 | 0 | 0 | 1992-12-16 | Judge | 1 | |||||||||||||||||||||||
| 01-CA-29367-001 | 0 | 1 | 1993-01-07 | Mandt | 1 | 92/2360 | ||||||||||||||||||||||
| 01-CA-29406-001 | 0 | 0 | 1993-08-20 | Judge | 1 | 1993-08-30 | ||||||||||||||||||||||
| 01-CA-29433-001 | 0 | 0 | 1995-05-30 | EMPL | 30 | 1996-04-12 | Judge | 2 | 95-1291 | 1996-04-22 | ||||||||||||||||||
| 01-CA-29433-001 | 1 | 0 | 2001-12-11 | CB | 10 | 2002-08-14 | SumEn | 1 | 02-1544 | 2002-08-15 | ||||||||||||||||||
| 01-CA-29434-001 | 0 | 0 | 1995-05-30 | EMPL | 30 | 1996-04-12 | Judge | 2 | 95-1291 | 1996-04-22 | ||||||||||||||||||
| 01-CA-29434-001 | 1 | 0 | 2001-12-11 | CB | 10 | 2002-08-14 | SumEn | 1 | 02-1544 | 2002-08-15 | ||||||||||||||||||
| 01-CA-29445-001 | 0 | 0 | ||||||||||||||||||||||||||
| 01-CA-29557-001 | 0 | 0 | 1994-02-25 | Judge | 1 | 1994-03-01 | ||||||||||||||||||||||
| 01-CA-29621-001 | 0 | 0 | 1996-08-21 | CB | 30 | 1997-02-03 | 1997-02-03 | 1997-05-30 | Judge | 3 | 96-1826 | 1997-06-12 | ||||||||||||||||
| 01-CA-29621-001 | 0 | 1 | 1996-07-31 | CHP | 30 | |||||||||||||||||||||||
| 01-CA-29649-001 | 0 | 0 | 1994-02-25 | Judge | 1 | 1994-03-01 | ||||||||||||||||||||||
| 01-CA-29676-001 | 0 | 0 | 1993-08-26 | Judge | 1 | 1993-08-27 | ||||||||||||||||||||||
| 01-CA-29740-001 | 0 | 0 | 1996-08-21 | CB | 30 | 1997-02-03 | 1997-02-03 | 1997-05-30 | Judge | 3 | 96-1826 | 1997-06-12 | ||||||||||||||||
| 01-CA-29740-001 | 0 | 1 | 1996-07-31 | CHP | 30 | |||||||||||||||||||||||
| 01-CA-29743-001 | 0 | 0 | 1997-05-06 | CB | 30 | 1997-07-16 | Mandt | 1 | 97/1529 | 1997-07-24 | ||||||||||||||||||
| 01-CA-29751-001 | 0 | 0 | 2000-09-12 | CB | 30 | 2001-08-15 | Judge | 1 | 00-2079/00-2080 | 2001-08-16 | ||||||||||||||||||
| 01-CA-29796-001 | 0 | 0 | 2000-09-12 | CB | 30 | 2001-08-15 | Judge | 1 | 00-2079/00-2080 | 2001-08-16 | ||||||||||||||||||
| 01-CA-29985-001 | 0 | 0 | 1996-09-09 | CB | 30 | 1996-10-23 | Judge | 5 | 96-1962 | 1996-10-24 | ||||||||||||||||||
| 01-CA-30236-001 | 0 | 0 | 1996-09-09 | CB | 30 | 1996-10-23 | Judge | 5 | 96-1962 | 1996-10-24 | ||||||||||||||||||
| 01-CA-30297-001 | 0 | 0 | 1996-08-21 | CB | 30 | 1997-02-03 | 1997-02-03 | 1997-05-30 | Judge | 3 | 96-1826 | 1997-06-12 | ||||||||||||||||
| 01-CA-30297-001 | 0 | 1 | 1996-07-31 | CHP | 30 | |||||||||||||||||||||||
| 01-CA-30347-001 | 0 | 0 | 1994-04-02 | CB | 30 | 1994-05-04 | Judge | 1 | 94-1348 | 1994-05-13 | ||||||||||||||||||
| 01-CA-30428-001 | 0 | 0 | 1996-08-21 | CB | 30 | 1997-02-03 | 1997-02-03 | 1997-05-30 | Judge | 3 | 96-1826 | 1997-06-12 | ||||||||||||||||
| 01-CA-30428-001 | 0 | 1 | 1996-07-31 | CHP | 30 | |||||||||||||||||||||||
| 01-CA-30434-001 | 0 | 0 | 2001-03-09 | CB | 30 | |||||||||||||||||||||||
| 01-CA-30472-001 | 0 | 0 | 1994-02-24 | CB | 30 | 1994-03-23 | 1 | |||||||||||||||||||||
| 01-CA-30708-001 | 0 | 0 | 1994-02-24 | CB | 30 | 1994-03-23 | 1 | |||||||||||||||||||||
| 01-CA-30745-001 | 0 | 0 | 2001-08-31 | CHP | 30 | 2002-08-07 | Judge | 4 | 01-2245 | |||||||||||||||||||
| 01-CA-30745-001 | 0 | 1 | 2001-10-10 | CB | 30 |
Table schema
CREATE TABLE c_enforcement(c_case_number VARCHAR, action_sequence BIGINT, recurrence BIGINT, petition_date DATE, petition_party VARCHAR, petition_court BIGINT, brief_rcvd_date DATE, brief_rcvd_party VARCHAR, brief_pleading VARCHAR, oral_arg_sch_date DATE, oral_arg_date DATE, court_deter_date DATE, court_action_type VARCHAR, court_action_action BIGINT, case_citation VARCHAR, som_date DATE, som_determination VARCHAR, request_date DATE, request_party VARCHAR, request_deter_date DATE, request_determination BIGINT, date_received_region DATE, som_date_deter VARCHAR, eot_date_filed BIGINT, eot_party BIGINT, eot_determination_date BIGINT, eot_determination BIGINT, date_settlement_approved DATE, settlement_type VARCHAR);