c_impact_category
457,996 rows
Suggested facets: history_sequence, investigation, litigation, compliance, determination_due_date (date), disposition_due_date (date), investigation_date (date), litigation_date (date), compliance_date (date)
| c_case_number | history_sequence | determination_due_date | disposition_due_date | investigation | investigation_date | litigation | litigation_date | compliance | compliance_date |
|---|---|---|---|---|---|---|---|---|---|
| 01-CA-19224-001 | 0 | 1981-12-10 | 1981-12-24 | 3 | 2001-08-14 | ||||
| 01-CA-19224-001 | 1 | 1981-12-10 | 1981-12-24 | 3 | 2001-08-14 | 3 | 2001-08-14 | ||
| 01-CA-19567-001 | 0 | 1982-03-24 | 1982-04-07 | 3 | 2001-08-14 | ||||
| 01-CA-19567-001 | 1 | 1982-03-24 | 1982-04-07 | 3 | 2001-08-14 | 3 | 2001-08-14 | ||
| 01-CA-19690-001 | 0 | 1982-04-22 | 1982-05-06 | 3 | 2001-08-14 | ||||
| 01-CA-19690-001 | 1 | 1982-04-22 | 1982-05-06 | 3 | 2001-08-14 | 3 | 2001-08-14 | ||
| 01-CA-19731-001 | 1 | 1982-06-03 | 1982-06-17 | 2 | 2000-03-16 | ||||
| 01-CA-19797-001 | 1 | 1982-06-30 | 1982-07-14 | 2 | 2000-03-27 | ||||
| 01-CA-19903-001 | 1 | 1982-07-29 | 1982-08-12 | 2 | 2000-03-27 | ||||
| 01-CA-19958-001 | 0 | 1982-07-19 | 1982-08-02 | 3 | 2002-05-03 | ||||
| 01-CA-20007-001 | 1 | 1982-08-30 | 1982-09-13 | 2 | 2000-03-27 | ||||
| 01-CA-20157-001 | 1 | 1982-10-21 | 1982-11-04 | 2 | 2000-03-27 | ||||
| 01-CA-20218-001 | 1 | 1982-11-10 | 1982-11-24 | 2 | 2000-03-27 | ||||
| 01-CA-20442-001 | 1 | 1983-01-19 | 1983-02-02 | 2 | 2000-03-27 | ||||
| 01-CA-20521-001 | 1 | 1983-02-14 | 1983-02-28 | 2 | 2000-03-27 | ||||
| 01-CA-20521-001 | 2 | 1983-02-14 | 1983-02-28 | 2 | 2000-03-27 | 2 | 2001-02-27 | ||
| 01-CA-20521-001 | 3 | 1983-02-14 | 1983-02-28 | 2 | 2000-03-27 | 2 | 2001-02-27 | 2 | 2001-02-27 |
| 01-CA-21438-001 | 1 | 1983-12-05 | 1983-12-19 | 2 | 2000-03-27 | ||||
| 01-CA-21560-001 | 0 | 1983-12-15 | 1983-12-29 | 3 | 2001-08-16 | ||||
| 01-CA-21943-001 | 0 | 1984-05-29 | 1984-06-12 | 2 | 2001-04-05 | ||||
| 01-CA-21943-001 | 1 | 1984-05-29 | 1984-06-12 | 2 | 2001-04-05 | 2 | 2001-04-05 | ||
| 01-CA-21943-001 | 2 | 1984-05-29 | 1984-06-12 | 3 | 2001-05-09 | 2 | 2001-04-05 | ||
| 01-CA-21943-001 | 3 | 1984-05-29 | 1984-06-12 | 3 | 2001-05-09 | 3 | 2001-05-09 | ||
| 01-CA-21943-001 | 4 | 1984-05-29 | 1984-06-12 | 3 | 2001-05-09 | 3 | 2001-05-09 | 3 | 2001-05-09 |
| 01-CA-22040-002 | 0 | 1984-07-06 | 1984-07-20 | 2 | 2001-04-05 | ||||
| 01-CA-22040-002 | 1 | 1984-07-06 | 1984-07-20 | 2 | 2001-04-05 | 2 | 2001-04-05 | ||
| 01-CA-22040-002 | 2 | 1984-07-06 | 1984-07-20 | 3 | 2001-05-09 | 2 | 2001-04-05 | ||
| 01-CA-22040-002 | 3 | 1984-07-06 | 1984-07-20 | 3 | 2001-05-09 | 3 | 2001-05-09 | ||
| 01-CA-22040-002 | 4 | 1984-07-06 | 1984-07-20 | 3 | 2001-05-09 | 3 | 2001-05-09 | 3 | 2001-05-09 |
| 01-CA-22687-001 | 1 | 1985-03-12 | 1985-03-26 | 3 | 1999-05-17 | ||||
| 01-CA-22769-001 | 1 | 1985-04-18 | 1985-05-02 | 3 | 1999-05-17 | ||||
| 01-CA-22869-001 | 1 | 1985-05-28 | 1985-06-11 | 3 | 1999-05-17 | ||||
| 01-CA-22869-001 | 2 | 1985-05-28 | 1985-06-11 | 3 | 1999-05-17 | 3 | 2001-05-09 | ||
| 01-CA-22869-001 | 3 | 1985-05-28 | 1985-06-11 | 3 | 1999-05-17 | 3 | 2001-05-09 | 3 | 2001-05-09 |
| 01-CA-23307-001 | 0 | 1986-01-03 | 1986-01-17 | 2 | 2001-04-05 | ||||
| 01-CA-23307-001 | 1 | 1986-01-03 | 1986-01-17 | 2 | 2001-04-05 | 2 | 2001-04-05 | ||
| 01-CA-23307-001 | 2 | 1986-01-03 | 1986-01-17 | 3 | 2001-05-09 | 2 | 2001-04-05 | ||
| 01-CA-23307-001 | 3 | 1986-01-03 | 1986-01-17 | 3 | 2001-05-09 | 3 | 2001-05-09 | ||
| 01-CA-23307-001 | 4 | 1986-01-03 | 1986-01-17 | 3 | 2001-05-09 | 3 | 2001-05-09 | 3 | 2001-05-09 |
| 01-CA-23427-001 | 0 | 1986-01-20 | 1986-02-03 | 3 | 2000-11-01 | ||||
| 01-CA-23427-001 | 1 | 1986-01-20 | 1986-02-03 | 3 | 2000-11-01 | 3 | 2000-11-01 | ||
| 01-CA-23427-001 | 2 | 1986-01-20 | 1986-02-03 | 3 | 2000-11-01 | 3 | 2000-11-01 | 3 | 2000-11-01 |
| 01-CA-23576-001 | 1 | 1986-03-21 | 1986-04-04 | 3 | 1999-05-17 | ||||
| 01-CA-23748-001 | 0 | 2 | 2001-04-05 | ||||||
| 01-CA-23748-001 | 1 | 1986-06-16 | 1986-06-30 | 2 | 2001-04-05 | 2 | 2001-04-05 | ||
| 01-CA-23748-001 | 2 | 1986-06-16 | 1986-06-30 | 3 | 2001-05-09 | 2 | 2001-04-05 | ||
| 01-CA-23748-001 | 3 | 1986-06-16 | 1986-06-30 | 3 | 2001-05-09 | 3 | 2001-05-09 | ||
| 01-CA-23748-001 | 4 | 1986-06-16 | 1986-06-30 | 3 | 2001-05-09 | 3 | 2001-05-09 | 3 | 2001-05-09 |
| 01-CA-24161-001 | 0 | 1986-10-27 | 1986-11-10 | 2 | 2001-04-05 | ||||
| 01-CA-24161-001 | 1 | 1986-10-27 | 1986-11-10 | 2 | 2001-04-05 | 2 | 2001-04-05 | ||
| 01-CA-24161-001 | 2 | 1986-10-27 | 1986-11-10 | 3 | 2001-05-09 | 2 | 2001-04-05 | ||
| 01-CA-24161-001 | 3 | 1986-10-27 | 1986-11-10 | 3 | 2001-05-09 | 3 | 2001-05-09 | ||
| 01-CA-24161-001 | 4 | 1986-10-27 | 1986-11-10 | 3 | 2001-05-09 | 3 | 2001-05-09 | 3 | 2001-05-09 |
| 01-CA-24372-001 | 1 | 1987-01-22 | 1987-02-05 | 2 | 2000-02-17 | ||||
| 01-CA-24390-002 | 0 | 1987-02-02 | 1987-02-16 | 2 | 2001-04-05 | ||||
| 01-CA-24390-002 | 1 | 1987-02-02 | 1987-02-16 | 2 | 2001-04-05 | 2 | 2001-04-05 | ||
| 01-CA-24390-002 | 2 | 1987-02-02 | 1987-02-16 | 3 | 2001-05-09 | 2 | 2001-04-05 | ||
| 01-CA-24390-002 | 3 | 1987-02-02 | 1987-02-16 | 3 | 2001-05-09 | 3 | 2001-05-09 | ||
| 01-CA-24390-002 | 4 | 1987-02-02 | 1987-02-16 | 3 | 2001-05-09 | 3 | 2001-05-09 | 3 | 2001-05-09 |
| 01-CA-24528-001 | 1 | 1987-03-24 | 1987-04-07 | 3 | 2001-05-08 | ||||
| 01-CA-24528-001 | 2 | 1987-03-24 | 1987-04-07 | 3 | 2001-05-08 | 3 | 2001-05-09 | ||
| 01-CA-24528-001 | 3 | 1987-03-24 | 1987-04-07 | 3 | 2001-05-08 | 3 | 2001-05-09 | 3 | 2001-05-09 |
| 01-CA-24863-001 | 0 | 1987-10-02 | 1987-10-16 | 2 | 2002-02-21 | ||||
| 01-CA-24863-001 | 1 | 1987-10-02 | 1987-10-16 | 2 | 2002-02-21 | 2 | 2002-02-21 | ||
| 01-CA-24863-001 | 2 | 1987-10-02 | 1987-10-16 | 2 | 2002-02-21 | 2 | 2002-02-21 | 2 | 2002-02-21 |
| 01-CA-24883-001 | 0 | 1987-10-12 | 1987-10-26 | 2 | 2002-02-21 | ||||
| 01-CA-24883-001 | 1 | 1987-10-12 | 1987-10-26 | 2 | 2002-02-21 | 2 | 2002-02-21 | ||
| 01-CA-24883-001 | 2 | 1987-10-12 | 1987-10-26 | 2 | 2002-02-21 | 2 | 2002-02-21 | 2 | 2002-02-21 |
| 01-CA-24921-001 | 0 | 1987-10-30 | 1987-11-13 | 2 | 2001-04-05 | ||||
| 01-CA-24921-001 | 1 | 1987-10-30 | 1987-11-13 | 2 | 2001-04-05 | 2 | 2001-04-05 | ||
| 01-CA-24921-001 | 2 | 1987-10-30 | 1987-11-13 | 3 | 2001-05-09 | 2 | 2001-04-05 | ||
| 01-CA-24921-001 | 3 | 1987-10-30 | 1987-11-13 | 3 | 2001-05-09 | 3 | 2001-05-09 | ||
| 01-CA-24921-001 | 4 | 1987-10-30 | 1987-11-13 | 3 | 2001-05-09 | 3 | 2001-05-09 | 3 | 2001-05-09 |
| 01-CA-24967-001 | 0 | 1987-11-23 | 1987-12-07 | 2 | 2001-04-05 | ||||
| 01-CA-24967-001 | 1 | 1987-11-23 | 1987-12-07 | 2 | 2001-04-05 | 2 | 2001-04-05 | ||
| 01-CA-24967-001 | 2 | 1987-11-23 | 1987-12-07 | 3 | 2001-05-09 | 2 | 2001-04-05 | ||
| 01-CA-24967-001 | 3 | 1987-11-23 | 1987-12-07 | 3 | 2001-05-09 | 3 | 2001-05-09 | ||
| 01-CA-24967-001 | 4 | 1987-11-23 | 1987-12-07 | 3 | 2001-05-09 | 3 | 2001-05-09 | 3 | 2001-05-09 |
| 01-CA-25033-001 | 0 | 1987-12-24 | 1988-01-07 | 2 | 2001-04-05 | ||||
| 01-CA-25033-001 | 1 | 1987-12-24 | 1988-01-07 | 2 | 2001-04-05 | 2 | 2001-04-05 | ||
| 01-CA-25033-001 | 2 | 1987-12-24 | 1988-01-07 | 3 | 2001-05-09 | 2 | 2001-04-05 | ||
| 01-CA-25033-001 | 3 | 1987-12-24 | 1988-01-07 | 3 | 2001-05-09 | 3 | 2001-05-09 | ||
| 01-CA-25033-001 | 4 | 1987-12-24 | 1988-01-07 | 3 | 2001-05-09 | 3 | 2001-05-09 | 3 | 2001-05-09 |
| 01-CA-25237-001 | 0 | 1988-04-04 | 1988-04-18 | 2 | 2001-04-05 | ||||
| 01-CA-25237-001 | 1 | 1988-04-04 | 1988-04-18 | 2 | 2001-04-05 | 2 | 2001-04-05 | ||
| 01-CA-25237-001 | 2 | 1988-04-04 | 1988-04-18 | 3 | 2001-05-09 | 2 | 2001-04-05 | ||
| 01-CA-25237-001 | 3 | 1988-04-04 | 1988-04-18 | 3 | 2001-05-09 | 3 | 2001-05-09 | ||
| 01-CA-25237-001 | 4 | 1988-04-04 | 1988-04-18 | 3 | 2001-05-09 | 3 | 2001-05-09 | 3 | 2001-05-09 |
| 01-CA-25237-002 | 0 | 1988-04-04 | 1988-04-18 | 2 | 2001-04-05 | ||||
| 01-CA-25237-002 | 1 | 1988-04-04 | 1988-04-18 | 2 | 2001-04-05 | 2 | 2001-04-05 | ||
| 01-CA-25237-002 | 2 | 1988-04-04 | 1988-04-18 | 3 | 2001-05-09 | 2 | 2001-04-05 | ||
| 01-CA-25237-002 | 3 | 1988-04-04 | 1988-04-18 | 3 | 2001-05-09 | 3 | 2001-05-09 | ||
| 01-CA-25237-002 | 4 | 1988-04-04 | 1988-04-18 | 3 | 2001-05-09 | 3 | 2001-05-09 | 3 | 2001-05-09 |
| 01-CA-25341-001 | 0 | 1988-05-12 | 1988-05-26 | 2 | 2001-04-05 | ||||
| 01-CA-25341-001 | 1 | 1988-05-12 | 1988-05-26 | 2 | 2001-04-05 | 2 | 2001-04-05 | ||
| 01-CA-25341-001 | 2 | 1988-05-12 | 1988-05-26 | 3 | 2001-05-09 | 2 | 2001-04-05 | ||
| 01-CA-25341-001 | 3 | 1988-05-12 | 1988-05-26 | 3 | 2001-05-09 | 3 | 2001-05-09 | ||
| 01-CA-25341-001 | 4 | 1988-05-12 | 1988-05-26 | 3 | 2001-05-09 | 3 | 2001-05-09 | 3 | 2001-05-09 |
| 01-CA-25599-001 | 1 | 1988-07-25 | 1988-08-08 | 3 | 1999-05-17 | ||||
| 01-CA-25805-001 | 1 | 1988-10-27 | 1988-11-10 | 3 | 1999-05-17 |
Table schema
CREATE TABLE c_impact_category(c_case_number VARCHAR, history_sequence BIGINT, determination_due_date DATE, disposition_due_date DATE, investigation BIGINT, investigation_date DATE, litigation BIGINT, litigation_date DATE, compliance BIGINT, compliance_date DATE);