c_amendment
54,826 rows
Suggested facets: sequence, amendment_type, amendment_reason, amendment_date (date)
| c_case_number | sequence | amendment_date | amendment_type | amendment_reason |
|---|---|---|---|---|
| 01-CA-19958-001 | 1 | 1982-08-31 | 01st | Body |
| 01-CA-22687-001 | 1 | 1985-03-07 | 01st | Body |
| 01-CA-22687-001 | 2 | 1985-11-27 | 02nd | Body |
| 01-CA-22769-001 | 1 | 1985-04-10 | 01st | AddAl |
| 01-CA-22769-001 | 2 | 1985-11-27 | 02nd | AddAl |
| 01-CA-22869-001 | 1 | 1985-05-24 | 01st | RemAl |
| 01-CA-23307-001 | 1 | 1985-12-12 | 01st | RemAl |
| 01-CA-23748-001 | 1 | 1986-06-19 | 01st | AdRem |
| 01-CA-24528-001 | 1 | 1987-04-02 | 01st | AddAl |
| 01-CA-24863-001 | 1 | 1987-09-11 | 01st | RemAl |
| 01-CA-24921-001 | 1 | 1987-09-30 | 01st | RemAl |
| 01-CA-24967-001 | 1 | 1987-11-27 | 01st | AdRem |
| 01-CA-25237-002 | 1 | 1988-03-10 | 01st | AddAl |
| 01-CA-25521-001 | 1 | 1989-07-03 | 03rd | Body |
| 01-CA-25521-001 | 2 | 1988-05-26 | 01st | Body |
| 01-CA-25521-001 | 3 | 1988-07-07 | 02nd | Body |
| 01-CA-25599-001 | 1 | 1988-08-01 | 01st | AddAl |
| 01-CA-25656-001 | 1 | 1988-08-30 | 01st | AddAl |
| 01-CA-25656-001 | 2 | 1989-01-26 | 02nd | AdRem |
| 01-CA-25656-001 | 3 | 1989-02-07 | 03rd | Body |
| 01-CA-25656-001 | 4 | 1989-03-30 | 04th | AddAl |
| 01-CA-25656-001 | 5 | 1989-11-15 | 05th | Body |
| 01-CA-25656-001 | 6 | 1988-11-21 | 06th | Body |
| 01-CA-25656-001 | 7 | 1990-02-14 | 07th | Body |
| 01-CA-25656-001 | 8 | 1989-11-21 | 06th | Body |
| 01-CA-25805-001 | 1 | 1988-10-31 | 01st | Body |
| 01-CA-25805-001 | 2 | 1989-02-01 | 02nd | AddAl |
| 01-CA-25805-001 | 3 | 1989-10-25 | 03rd | AddAl |
| 01-CA-25864-001 | 1 | 1988-12-18 | 01st | Body |
| 01-CA-25864-001 | 2 | 1989-07-03 | 02nd | Body |
| 01-CA-25896-001 | 1 | 1989-01-23 | 01st | Body |
| 01-CA-26144-001 | 1 | 1989-04-04 | 01st | AddAl |
| 01-CA-26144-001 | 2 | 1989-11-27 | 02nd | Body |
| 01-CA-26144-001 | 3 | 1990-02-20 | 03rd | Body |
| 01-CA-26463-001 | 1 | 1989-09-11 | 01st | AddAl |
| 01-CA-26463-002 | 1 | 1989-09-11 | 01st | RemAl |
| 01-CA-26463-003 | 1 | 1989-09-11 | 01st | RemAl |
| 01-CA-26463-004 | 1 | 1989-09-11 | 01st | RemAl |
| 01-CA-26463-005 | 1 | 1989-09-11 | 01st | Body |
| 01-CA-26463-006 | 1 | 1989-09-11 | 01st | Body |
| 01-CA-26573-001 | 1 | 1989-09-28 | 01st | AddAl |
| 01-CA-26936-001 | 1 | 1990-01-09 | 01st | Party |
| 01-CA-26936-001 | 2 | 1990-01-18 | 02nd | Body |
| 01-CA-27070-001 | 1 | 1990-04-23 | 01st | AddAl |
| 01-CA-27142-001 | 1 | 1990-04-16 | 01st | Body |
| 01-CA-27197-001 | 1 | 1990-06-26 | 01st | RemAl |
| 01-CA-27335-001 | 1 | 1990-07-02 | 01st | RemAl |
| 01-CA-27335-001 | 2 | 1992-09-10 | 02nd | Body |
| 01-CA-27335-001 | 3 | 1992-10-05 | 03rd | Body |
| 01-CA-27385-001 | 1 | 1990-07-19 | 01st | Body |
| 01-CA-27386-001 | 1 | 1990-07-19 | 01st | AddAl |
| 01-CA-27417-001 | 1 | 1990-07-25 | 01st | Other |
| 01-CA-27421-001 | 1 | 1990-08-20 | 01st | RemAl |
| 01-CA-27491-001 | 1 | 1990-09-26 | 01st | RemAl |
| 01-CA-27491-001 | 2 | 1990-10-26 | 02nd | Body |
| 01-CA-27659-001 | 1 | 1990-11-16 | 01st | Body |
| 01-CA-27732-001 | 1 | 1991-02-14 | 01st | Body |
| 01-CA-27732-002 | 1 | 1991-02-14 | 01st | Body |
| 01-CA-27766-001 | 1 | 1991-01-24 | 01st | Body |
| 01-CA-27766-001 | 2 | 1991-01-24 | 01st | AddAl |
| 01-CA-27800-001 | 1 | 1990-12-14 | 01st | Party |
| 01-CA-27800-001 | 2 | 1991-12-19 | 02nd | Body |
| 01-CA-27852-001 | 1 | 1991-01-09 | 01st | RemAl |
| 01-CA-27937-001 | 1 | 1991-02-22 | 01st | Body |
| 01-CA-27953-001 | 1 | 1991-02-22 | 01st | Body |
| 01-CA-28064-001 | 1 | 1991-03-08 | 01st | RemAl |
| 01-CA-28064-001 | 2 | 1991-04-03 | 02nd | Party |
| 01-CA-28064-001 | 3 | 1991-03-08 | 01st | AddAl |
| 01-CA-28064-001 | 4 | 1991-04-03 | 02nd | Body |
| 01-CA-28184-001 | 1 | 1991-05-22 | 01st | AdRem |
| 01-CA-28250-001 | 1 | 1991-05-13 | 01st | Body |
| 01-CA-28250-001 | 2 | 1991-06-12 | 02nd | Body |
| 01-CA-28297-001 | 1 | 1991-07-05 | 01st | Body |
| 01-CA-28298-001 | 1 | 1991-07-05 | 01st | Body |
| 01-CA-28315-001 | 1 | 1991-06-18 | 01st | AddAl |
| 01-CA-28315-001 | 2 | 1991-07-15 | 02nd | Body |
| 01-CA-28348-001 | 1 | 1991-09-07 | 01st | Body |
| 01-CA-28376-001 | 1 | 1991-07-23 | 01st | Body |
| 01-CA-28376-001 | 2 | 1991-07-23 | 01st | AddAl |
| 01-CA-28409-001 | 1 | 1991-08-14 | 01st | AddAl |
| 01-CA-28409-001 | 2 | 1991-08-14 | 01st | RemAl |
| 01-CA-28418-001 | 1 | 1991-08-12 | 01st | AddAl |
| 01-CA-28474-001 | 1 | 1991-09-20 | 01st | AddAl |
| 01-CA-28481-001 | 1 | 1991-10-21 | 01st | Body |
| 01-CA-28481-001 | 2 | 1991-10-28 | 02nd | Body |
| 01-CA-28481-001 | 3 | 1991-10-21 | 01st | Party |
| 01-CA-28481-001 | 4 | 1991-10-28 | 02nd | Body |
| 01-CA-28481-001 | 5 | 1991-10-21 | 01st | Body |
| 01-CA-28493-001 | 1 | 1991-08-28 | 01st | Body |
| 01-CA-28493-001 | 2 | 1991-08-30 | 02nd | Body |
| 01-CA-28493-001 | 3 | 1991-08-28 | 01st | AddAl |
| 01-CA-28493-001 | 4 | 1991-08-30 | 02nd | Body |
| 01-CA-28518-001 | 1 | 1991-09-06 | 01st | AddAl |
| 01-CA-28590-001 | 1 | 1991-08-29 | 01st | Body |
| 01-CA-28590-001 | 2 | 1991-10-15 | 02nd | Body |
| 01-CA-28590-001 | 3 | 1991-10-15 | 02nd | AddAl |
| 01-CA-28590-001 | 4 | 1992-03-16 | 03rd | AddAl |
| 01-CA-28617-001 | 1 | 1991-10-21 | 01st | Body |
| 01-CA-28617-001 | 2 | 1991-10-21 | 01st | Body |
| 01-CA-28751-001 | 1 | 1991-11-15 | 01st | Body |
Table schema
CREATE TABLE c_amendment(c_case_number VARCHAR, "sequence" BIGINT, amendment_date DATE, amendment_type VARCHAR, amendment_reason VARCHAR);