c_alleg_action
1,551,184 rows
Suggested facets: allegation_sequence, sequence, action_result, action_type, action_date (date)
| c_case_number | allegation_sequence | sequence | action_result | action_date | action_type |
|---|---|---|---|---|---|
| 01-CA-19224-001 | 1 | 0 | NOMER | 1981-12-08 00:00:00 | DETRM |
| 01-CA-19224-001 | 1 | 1 | Dismi | 1981-12-28 00:00:00 | DISMI |
| 01-CA-19224-001 | 1 | 2 | AppRe | 1983-09-27 00:00:00 | APEAL |
| 01-CA-19224-001 | 1 | 3 | Compl | 1983-12-07 00:00:00 | Compl |
| 01-CA-19224-001 | 1 | 4 | ALJDM | 1989-04-05 00:00:00 | ALJD |
| 01-CA-19224-001 | 1 | 5 | ALJDN | 1989-04-05 00:00:00 | ALJD |
| 01-CA-19224-001 | 1 | 6 | BDMer | 1990-08-28 00:00:00 | BDDEC |
| 01-CA-19224-001 | 1 | 7 | BDNMe | 1990-08-28 00:00:00 | BDDEC |
| 01-CA-19224-001 | 1 | 8 | BDNMe | 1996-08-16 00:00:00 | BDDEC |
| 01-CA-19567-001 | 1 | 0 | NOMER | 1982-03-19 00:00:00 | DETRM |
| 01-CA-19567-001 | 1 | 1 | Dismi | 1982-04-08 00:00:00 | DISMI |
| 01-CA-19567-001 | 1 | 2 | MERIT | 1983-11-04 00:00:00 | DETRM |
| 01-CA-19567-001 | 1 | 3 | Compl | 1983-12-07 00:00:00 | Compl |
| 01-CA-19567-001 | 1 | 4 | ALJDM | 1989-04-05 00:00:00 | ALJD |
| 01-CA-19567-001 | 1 | 5 | ALJDN | 1989-04-05 00:00:00 | ALJD |
| 01-CA-19567-001 | 1 | 6 | BDMer | 1990-08-28 00:00:00 | BDDEC |
| 01-CA-19567-001 | 1 | 7 | BDNMe | 1990-08-28 00:00:00 | BDDEC |
| 01-CA-19567-001 | 1 | 8 | BDNMe | 1996-08-16 00:00:00 | BDDEC |
| 01-CA-19567-001 | 2 | 0 | NOMER | 1982-03-19 00:00:00 | DETRM |
| 01-CA-19567-001 | 2 | 1 | Dismi | 1982-04-08 00:00:00 | DISMI |
| 01-CA-19567-001 | 2 | 2 | MERIT | 1983-11-04 00:00:00 | DETRM |
| 01-CA-19567-001 | 2 | 3 | Compl | 1983-12-07 00:00:00 | Compl |
| 01-CA-19567-001 | 2 | 4 | ALJDM | 1989-04-05 00:00:00 | ALJD |
| 01-CA-19567-001 | 2 | 5 | ALJDN | 1989-04-05 00:00:00 | ALJD |
| 01-CA-19567-001 | 2 | 6 | BDMer | 1990-08-28 00:00:00 | BDDEC |
| 01-CA-19567-001 | 2 | 7 | BDNMe | 1990-08-28 00:00:00 | BDDEC |
| 01-CA-19567-001 | 2 | 8 | BDNMe | 1996-08-16 00:00:00 | BDDEC |
| 01-CA-19567-001 | 3 | 0 | NOMER | 1982-03-19 00:00:00 | DETRM |
| 01-CA-19567-001 | 3 | 1 | Dismi | 1982-04-08 00:00:00 | DISMI |
| 01-CA-19567-001 | 3 | 2 | MERIT | 1983-11-04 00:00:00 | DETRM |
| 01-CA-19567-001 | 3 | 3 | Compl | 1983-12-07 00:00:00 | Compl |
| 01-CA-19567-001 | 3 | 4 | ALJDM | 1989-04-05 00:00:00 | ALJD |
| 01-CA-19567-001 | 3 | 5 | ALJDN | 1989-04-05 00:00:00 | ALJD |
| 01-CA-19567-001 | 3 | 6 | BDMer | 1990-08-28 00:00:00 | BDDEC |
| 01-CA-19567-001 | 3 | 7 | BDNMe | 1990-08-28 00:00:00 | BDDEC |
| 01-CA-19567-001 | 3 | 8 | BDNMe | 1996-08-16 00:00:00 | BDDEC |
| 01-CA-19690-001 | 1 | 0 | NOMER | 1982-04-16 00:00:00 | DETRM |
| 01-CA-19690-001 | 1 | 1 | Dismi | 1982-04-28 00:00:00 | DISMI |
| 01-CA-19690-001 | 1 | 2 | AppDS | 1982-06-16 00:00:00 | APEAL |
| 01-CA-19690-001 | 1 | 3 | Compl | 1983-12-07 00:00:00 | Compl |
| 01-CA-19690-001 | 2 | 0 | NOMER | 1982-04-16 00:00:00 | DETRM |
| 01-CA-19690-001 | 2 | 1 | Dismi | 1982-04-28 00:00:00 | DISMI |
| 01-CA-19690-001 | 2 | 2 | AppDS | 1982-06-16 00:00:00 | APEAL |
| 01-CA-19690-001 | 2 | 3 | Compl | 1983-12-07 00:00:00 | Compl |
| 01-CA-19690-001 | 3 | 0 | NOMER | 1982-04-16 00:00:00 | DETRM |
| 01-CA-19690-001 | 3 | 1 | Dismi | 1982-04-28 00:00:00 | DISMI |
| 01-CA-19690-001 | 3 | 2 | AppDS | 1982-06-16 00:00:00 | APEAL |
| 01-CA-19690-001 | 3 | 3 | Compl | 1983-12-07 00:00:00 | Compl |
| 01-CA-19731-001 | 1 | 0 | Advic | 1982-04-13 00:00:00 | ADVIC |
| 01-CA-19731-001 | 1 | 1 | MERIT | 1982-05-12 00:00:00 | DETRM |
| 01-CA-19731-001 | 1 | 2 | Compl | 1982-05-12 00:00:00 | Compl |
| 01-CA-19731-001 | 1 | 3 | Dismi | 1982-05-25 00:00:00 | DISMI |
| 01-CA-19731-001 | 1 | 4 | ALJDM | 1983-06-30 00:00:00 | ALJD |
| 01-CA-19731-001 | 1 | 5 | AdRMe | 1983-02-04 00:00:00 | ADVCR |
| 01-CA-19731-001 | 2 | 0 | Advic | 1982-04-13 00:00:00 | ADVIC |
| 01-CA-19731-001 | 2 | 1 | MERIT | 1982-05-12 00:00:00 | DETRM |
| 01-CA-19731-001 | 2 | 2 | Compl | 1982-05-12 00:00:00 | Compl |
| 01-CA-19731-001 | 2 | 3 | Dismi | 1982-05-25 00:00:00 | DISMI |
| 01-CA-19731-001 | 2 | 4 | ALJDM | 1983-06-30 00:00:00 | ALJD |
| 01-CA-19731-001 | 2 | 5 | AdRMe | 1983-02-04 00:00:00 | ADVCR |
| 01-CA-19797-001 | 1 | 0 | Compl | 1982-05-07 00:00:00 | Compl |
| 01-CA-19903-001 | 1 | 0 | MERIT | 1982-07-07 00:00:00 | DETRM |
| 01-CA-19903-001 | 1 | 1 | Compl | 1982-07-07 00:00:00 | Compl |
| 01-CA-19958-001 | 1 | 10 | MERIT | 1982-11-19 00:00:00 | DETRM |
| 01-CA-19958-001 | 1 | 11 | MERIT | 1982-07-16 00:00:00 | DETRM |
| 01-CA-19958-001 | 1 | 12 | NOMER | 1982-07-16 00:00:00 | DETRM |
| 01-CA-19958-001 | 1 | 2 | Dismi | 1982-07-27 00:00:00 | DISMI |
| 01-CA-19958-001 | 1 | 3 | AppRe | 1982-11-19 00:00:00 | APEAL |
| 01-CA-19958-001 | 1 | 4 | MERIT | 1982-11-19 00:00:00 | DETRM |
| 01-CA-19958-001 | 1 | 5 | Compl | 1983-12-07 00:00:00 | Compl |
| 01-CA-19958-001 | 1 | 6 | Dismi | 1983-01-21 00:00:00 | DISMI |
| 01-CA-19958-001 | 1 | 7 | AppDR | 1983-09-27 00:00:00 | APEAL |
| 01-CA-19958-001 | 1 | 8 | UniSA | 1983-03-21 00:00:00 | InfSA |
| 01-CA-19958-001 | 1 | 9 | Dismi | 1983-03-23 00:00:00 | DISMI |
| 01-CA-20007-001 | 1 | 0 | MERIT | 1982-08-09 00:00:00 | DETRM |
| 01-CA-20007-001 | 1 | 1 | Compl | 1982-08-09 00:00:00 | Compl |
| 01-CA-20007-001 | 2 | 0 | MERIT | 1982-08-09 00:00:00 | DETRM |
| 01-CA-20007-001 | 2 | 1 | Compl | 1982-08-09 00:00:00 | Compl |
| 01-CA-20157-001 | 1 | 0 | Compl | 1982-10-22 00:00:00 | Compl |
| 01-CA-20218-001 | 1 | 0 | Compl | 1982-10-22 00:00:00 | Compl |
| 01-CA-20218-001 | 2 | 0 | Compl | 1982-10-22 00:00:00 | Compl |
| 01-CA-20283-001 | 1 | 0 | NOMER | 1982-10-25 00:00:00 | DETRM |
| 01-CA-20283-001 | 1 | 1 | Dismi | 1982-11-03 00:00:00 | DISMI |
| 01-CA-20283-001 | 1 | 2 | AppRe | 1983-09-27 00:00:00 | APEAL |
| 01-CA-20283-001 | 1 | 3 | NOMER | 1983-04-11 00:00:00 | DETRM |
| 01-CA-20283-001 | 1 | 4 | Compl | 1983-12-07 00:00:00 | Compl |
| 01-CA-20291-001 | 1 | 0 | MERIT | 1982-10-25 00:00:00 | DETRM |
| 01-CA-20291-001 | 1 | 1 | NOMER | 1982-10-25 00:00:00 | DETRM |
| 01-CA-20291-001 | 1 | 2 | Dismi | 1982-11-12 00:00:00 | DISMI |
| 01-CA-20291-001 | 1 | 3 | AppRe | 1983-09-27 00:00:00 | APEAL |
| 01-CA-20291-001 | 1 | 4 | Compl | 1983-12-07 00:00:00 | Compl |
| 01-CA-20304-001 | 1 | 0 | NOMER | 1982-10-25 00:00:00 | DETRM |
| 01-CA-20304-001 | 1 | 1 | Dismi | 1982-11-16 00:00:00 | DISMI |
| 01-CA-20304-001 | 1 | 2 | AppRe | 1983-09-27 00:00:00 | APEAL |
| 01-CA-20304-001 | 1 | 3 | Compl | 1983-12-07 00:00:00 | Compl |
| 01-CA-20442-001 | 1 | 0 | Compl | 1983-01-28 00:00:00 | Compl |
| 01-CA-20442-001 | 2 | 0 | Compl | 1983-01-28 00:00:00 | Compl |
| 01-CA-20508-001 | 1 | 0 | NOMER | 1983-01-05 00:00:00 | DETRM |
| 01-CA-20508-001 | 1 | 1 | Dismi | 1983-01-14 00:00:00 | DISMI |
| 01-CA-20508-001 | 1 | 2 | AppRe | 1983-09-27 00:00:00 | APEAL |
Table schema
CREATE TABLE c_alleg_action(c_case_number VARCHAR, allegation_sequence BIGINT, "sequence" BIGINT, action_result VARCHAR, action_date TIMESTAMP, action_type VARCHAR);