c_complaint
43,079 rows
Suggested facets: action_sequence, contain_noh, issued (date), answer_to_complaint (date), date_of_withdrawal_order (date)
| c_case_number | action_sequence | recurrence | issued | contain_noh | answer_to_complaint | date_of_withdrawal_order |
|---|---|---|---|---|---|---|
| 01-CA-19224-001 | 0 | 0 | 1983-12-07 | Y | 1984-01-23 | |
| 01-CA-19567-001 | 0 | 0 | 1983-12-07 | Y | 1984-01-23 | |
| 01-CA-19690-001 | 0 | 0 | 1983-12-07 | Y | 1984-01-23 | |
| 01-CA-19731-001 | 0 | 0 | 1982-05-12 | |||
| 01-CA-19797-001 | 0 | 0 | 1982-05-07 | |||
| 01-CA-19903-001 | 0 | 0 | 1982-07-07 | |||
| 01-CA-19958-001 | 0 | 0 | 1983-12-07 | Y | 1984-01-23 | |
| 01-CA-20007-001 | 0 | 0 | 1982-08-09 | |||
| 01-CA-20157-001 | 0 | 0 | 1982-10-22 | |||
| 01-CA-20218-001 | 0 | 0 | 1982-10-22 | |||
| 01-CA-20283-001 | 0 | 0 | 1983-12-07 | Y | 1983-12-19 | |
| 01-CA-20291-001 | 0 | 0 | 1983-12-07 | 1984-01-23 | ||
| 01-CA-20304-001 | 0 | 0 | 1983-12-07 | |||
| 01-CA-20442-001 | 0 | 0 | 1983-01-28 | |||
| 01-CA-20508-001 | 0 | 0 | 1983-12-07 | 1984-01-23 | ||
| 01-CA-20521-001 | 0 | 0 | 1983-01-28 | |||
| 01-CA-21438-001 | 0 | 0 | 1983-11-17 | |||
| 01-CA-21560-001 | 0 | 0 | 1983-12-07 | 1984-01-23 | ||
| 01-CA-21943-001 | 0 | 0 | 1988-01-29 | 1988-11-07 | ||
| 01-CA-22040-002 | 0 | 0 | 1984-06-15 | Y | 1992-03-02 | |
| 01-CA-22687-001 | 0 | 0 | 1985-03-18 | |||
| 01-CA-22769-001 | 0 | 0 | 1985-04-19 | 1986-02-14 | ||
| 01-CA-22869-001 | 0 | 0 | 1985-12-09 | |||
| 01-CA-23307-001 | 0 | 0 | 1988-01-29 | Y | 1988-11-07 | |
| 01-CA-23427-001 | 0 | 0 | 1986-01-03 | Y | 2000-10-31 | |
| 01-CA-23576-001 | 0 | 0 | 1986-04-30 | 1988-09-01 | ||
| 01-CA-23748-001 | 0 | 0 | 1988-01-29 | 1998-11-07 | ||
| 01-CA-24161-001 | 0 | 0 | 1988-01-29 | 1988-11-07 | ||
| 01-CA-24372-001 | 0 | 0 | 1987-01-09 | 1987-04-03 | ||
| 01-CA-24390-002 | 0 | 0 | 1988-01-29 | 1988-11-07 | ||
| 01-CA-24528-001 | 0 | 0 | 1988-01-29 | Y | 1988-11-07 | |
| 01-CA-24863-001 | 0 | 0 | 1987-10-06 | |||
| 01-CA-24883-001 | 0 | 0 | 1987-10-06 | 1987-10-19 | ||
| 01-CA-24921-001 | 0 | 0 | 1988-01-29 | 1988-11-07 | ||
| 01-CA-24967-001 | 0 | 0 | 1990-09-27 | |||
| 01-CA-25033-001 | 0 | 0 | 1988-01-29 | 1988-11-07 | ||
| 01-CA-25237-001 | 0 | 0 | 1988-04-27 | 1998-06-24 | ||
| 01-CA-25237-002 | 0 | 0 | 1988-06-16 | 1988-06-24 | ||
| 01-CA-25341-001 | 0 | 0 | 1988-06-16 | 1988-11-07 | ||
| 01-CA-25521-001 | 0 | 0 | 1988-07-18 | Y | 1988-08-16 | |
| 01-CA-25599-001 | 0 | 0 | 1988-08-17 | 1988-09-01 | ||
| 01-CA-25656-001 | 0 | 0 | 1988-09-02 | 1988-09-19 | ||
| 01-CA-25656-001 | 1 | 0 | 1989-04-28 | Y | 1989-06-15 | |
| 01-CA-25736-001 | 0 | 0 | 1988-09-29 | |||
| 01-CA-25805-001 | 0 | 0 | 1988-11-18 | |||
| 01-CA-25864-001 | 0 | 0 | 1989-01-31 | Y | 1989-02-10 | |
| 01-CA-25867-001 | 0 | 0 | 1988-12-16 | 1988-12-22 | ||
| 01-CA-25896-001 | 0 | 0 | 1989-01-23 | N | ||
| 01-CA-25940-001 | 0 | 0 | 1989-09-11 | Y | ||
| 01-CA-25969-001 | 0 | 0 | 1989-01-20 | |||
| 01-CA-26144-001 | 0 | 0 | 1989-04-28 | 1989-06-15 | ||
| 01-CA-26183-001 | 0 | 0 | 1989-04-20 | |||
| 01-CA-26232-001 | 0 | 0 | 1989-05-23 | 1989-06-05 | ||
| 01-CA-26237-001 | 0 | 0 | 1989-05-23 | 1989-06-05 | ||
| 01-CA-26270-001 | 0 | 0 | 1989-05-12 | |||
| 01-CA-26353-001 | 0 | 0 | 1989-06-14 | |||
| 01-CA-26463-001 | 0 | 0 | 1989-10-06 | Y | 1989-10-26 | |
| 01-CA-26463-002 | 0 | 0 | 1989-10-06 | Y | 1989-10-26 | |
| 01-CA-26463-003 | 0 | 0 | 1989-10-06 | Y | 1989-10-26 | |
| 01-CA-26463-004 | 0 | 0 | 1989-10-06 | Y | 1989-10-26 | |
| 01-CA-26463-005 | 0 | 0 | 1989-10-06 | Y | 1989-10-26 | |
| 01-CA-26463-006 | 0 | 0 | 1989-10-06 | Y | 1989-10-26 | |
| 01-CA-26573-001 | 0 | 0 | 1989-10-27 | 1989-11-17 | ||
| 01-CA-26575-001 | 0 | 0 | 1989-10-06 | Y | 1989-11-09 | |
| 01-CA-26744-001 | 0 | 0 | 1989-12-26 | Y | 1990-02-28 | |
| 01-CA-26820-001 | 0 | 0 | 1991-04-11 | 1991-04-29 | ||
| 01-CA-26936-001 | 0 | 0 | 1990-01-29 | 1990-03-01 | ||
| 01-CA-27014-001 | 0 | 0 | 1990-03-05 | Y | 1990-03-29 | |
| 01-CA-27070-001 | 0 | 0 | 1990-04-30 | Y | 1990-05-10 | |
| 01-CA-27142-001 | 0 | 0 | 1991-03-22 | 1991-09-12 | ||
| 01-CA-27321-001 | 0 | 0 | 1990-06-28 | |||
| 01-CA-27322-001 | 0 | 0 | 1990-06-28 | Y | 1990-10-05 | |
| 01-CA-27335-001 | 0 | 0 | 1990-07-06 | Y | 1990-10-29 | |
| 01-CA-27356-001 | 0 | 0 | 1990-07-18 | |||
| 01-CA-27385-001 | 0 | 0 | 1990-07-25 | 1990-10-05 | ||
| 01-CA-27386-001 | 0 | 0 | 1990-07-26 | |||
| 01-CA-27417-001 | 0 | 0 | 1990-08-02 | |||
| 01-CA-27421-001 | 0 | 0 | 1990-08-29 | Y | ||
| 01-CA-27491-001 | 0 | 0 | 1990-10-30 | Y | 1990-11-04 | |
| 01-CA-27506-001 | 0 | 0 | 1990-10-04 | |||
| 01-CA-27659-001 | 0 | 0 | 1990-12-12 | Y | 1990-12-21 | |
| 01-CA-27731-001 | 0 | 0 | 1990-11-30 | |||
| 01-CA-27732-001 | 0 | 0 | 1991-02-21 | Y | 1991-03-04 | |
| 01-CA-27732-002 | 0 | 0 | 1991-02-21 | Y | 1991-03-04 | |
| 01-CA-27766-001 | 0 | 0 | 1991-01-29 | 1991-02-12 | ||
| 01-CA-27800-001 | 0 | 0 | 1990-12-20 | 1991-01-04 | ||
| 01-CA-27879-001 | 0 | 0 | 1991-01-25 | 1991-02-08 | ||
| 01-CA-27908-001 | 0 | 0 | 1991-02-05 | |||
| 01-CA-27937-001 | 0 | 0 | 1991-02-22 | Y | 1991-03-04 | |
| 01-CA-27953-001 | 0 | 0 | 1991-02-27 | |||
| 01-CA-28064-001 | 0 | 0 | 1991-04-11 | Y | 1991-10-01 | |
| 01-CA-28250-001 | 0 | 0 | 1991-06-24 | |||
| 01-CA-28264-001 | 0 | 0 | 1991-06-11 | N | ||
| 01-CA-28297-001 | 0 | 0 | 1991-08-07 | 1991-08-22 | ||
| 01-CA-28298-001 | 0 | 0 | 1991-08-07 | |||
| 01-CA-28315-001 | 0 | 0 | 1991-08-13 | Y | 1991-08-27 | |
| 01-CA-28348-001 | 0 | 0 | 1991-09-19 | 1991-10-09 | ||
| 01-CA-28375-001 | 0 | 0 | 1991-07-24 | 1991-08-06 | ||
| 01-CA-28375-001 | 1 | 0 | 1992-03-25 | Y | 1992-04-08 | |
| 01-CA-28376-001 | 0 | 0 | 1991-07-31 | Y | 1991-08-12 |
Table schema
CREATE TABLE c_complaint(c_case_number VARCHAR, action_sequence BIGINT, recurrence BIGINT, issued DATE, contain_noh VARCHAR, answer_to_complaint DATE, date_of_withdrawal_order DATE);