violation_event

History of changes to a violation's penalty, abatement date, or status. Each row records a settlement, contest, modification, or other event that altered an earlier-issued violation. Useful for tracking how proposed penalties shrink through the appeals and settlement process.
activity_nr
Foreign key to violation.activity_nr.
citation_id
Foreign key to violation.citation_id.
hist_abate_date
New abatement date set by this event, if applicable.
hist_date
Date of the event.
hist_event
Type of event (settlement, contest, modification, etc.).
hist_insp_nr
Related inspection number.
hist_penalty
Penalty amount after this event, in dollars.
hist_vtype
New violation type after this event.
load_dt
Timestamp when this row was loaded.
pen_fta
Flag distinguishing penalty events from failure-to-abate events.

11,608,898 rows

✎ View and edit SQL

Suggested facets: pen_fta, hist_event, hist_vtype, hist_insp_nr, load_dt, hist_date (date), hist_abate_date (date), load_dt (date)

activity_nr citation_id pen_fta hist_event hist_date hist_penalty hist_abate_date hist_vtype hist_insp_nr load_dt
178319 178319 01001 P I 1984-03-09 150.0 1984-03-09 S   2011-10-14 16:48:14
178319 178319 01001 P Z 1984-03-30 300.0 1984-03-09 S   2011-10-14 16:48:14
178335 178335 01001 P I 1984-02-10 120.0 1984-02-10 S   2011-10-14 16:48:14
178335 178335 01001 P Z 1984-03-12 240.0 1984-02-10 S   2011-10-14 16:48:14
178335 178335 01002A P I 1984-02-10 210.0 1984-03-11 S   2011-10-14 16:48:14
178335 178335 01002A P Z 1984-03-12 420.0 1984-03-11 S   2011-10-14 16:48:14
178335 178335 01003 P I 1984-02-10 60.0 1984-02-10 S   2011-10-14 16:48:14
178335 178335 01003 P Z 1984-03-12 120.0 1984-02-10 S   2011-10-14 16:48:14
178335 178335 01004 P I 1984-02-10 120.0 1984-01-30 S   2011-10-14 16:48:14
178335 178335 01004 P Z 1984-03-12 240.0 1984-01-30 S   2011-10-14 16:48:14
178335 178335 01005 P I 1984-02-10 90.0 1984-05-15 S   2011-10-14 16:48:14
178335 178335 01005 P Z 1984-03-12 180.0 1984-05-15 S   2011-10-14 16:48:14
178376 178376 01002 P I 1984-02-10 150.0 1984-02-10 S   2011-10-14 16:48:14
178376 178376 01002 P Z 1984-03-12 300.0 1984-02-10 S   2011-10-14 16:48:14
178376 178376 01003 P I 1984-02-10 120.0 1984-02-10 S   2011-10-14 16:48:14
178376 178376 01003 P Z 1984-03-12 240.0 1984-02-10 S   2011-10-14 16:48:14
178400 178400 01001 P Z 1984-03-30 490.0 1984-04-12 O   2011-10-14 16:48:14
178400 178400 01001 P I 1984-04-13   1984-06-15 O   2011-10-14 16:48:14
178400 178400 02001 P Z 1984-03-09   1984-04-12 O   2011-10-14 16:48:14
178400 178400 02001 P I 1984-04-13   1984-06-15 O   2011-10-14 16:48:14
178400 178400 02002 P Z 1984-03-09   1984-04-12 O   2011-10-14 16:48:14
178400 178400 02002 P I 1984-04-13   1984-06-15 O   2011-10-14 16:48:14
178418 178418 01001 P I 1984-02-10 45.0 1984-02-10 S   2011-10-14 16:48:14
178418 178418 01001 P Z 1984-03-02 90.0 1984-02-10 S   2011-10-14 16:48:14
178442 178442 01001A P Z 1984-08-21 160.0 1984-08-29 S   2011-10-14 16:48:14
178442 178442 01001A P I 1984-09-05 80.0 1984-08-29 S   2011-10-14 16:48:14
178442 178442 01002A P Z 1984-08-21 280.0 1984-08-29 S   2011-10-14 16:48:14
178442 178442 01002A P I 1984-09-05 140.0 1984-08-29 S   2011-10-14 16:48:14
178442 178442 01003A P Z 1984-08-21 40.0 1984-09-09 S   2011-10-14 16:48:14
178442 178442 01003A P I 1984-09-05 30.0 1984-09-09 S   2011-10-14 16:48:14
178442 178442 01004 P Z 1984-08-21 80.0 1984-08-24 S   2011-10-14 16:48:14
178442 178442 01004 P I 1984-09-05 50.0 1984-08-24 S   2011-10-14 16:48:14
178517 178517 01001 P I 1984-03-09 60.0 1984-03-27 S   2011-10-14 16:48:14
178517 178517 01001 P Z 1984-03-30 120.0 1984-03-27 S   2011-10-14 16:48:14
178517 178517 01002 P I 1984-03-09 60.0 1984-03-17 S   2011-10-14 16:48:14
178517 178517 01002 P Z 1984-03-30 120.0 1984-03-17 S   2011-10-14 16:48:14
178517 178517 01003A P I 1984-03-09 150.0 1984-06-12 S   2011-10-14 16:48:14
178517 178517 01003A P Z 1984-03-30 300.0 1984-06-12 S   2011-10-14 16:48:14
178608 178608 01001 P I 1984-03-23 90.0 1984-03-22 S   2011-10-14 16:48:14
178608 178608 01001 P Z 1984-03-30 180.0 1984-03-22 S   2011-10-14 16:48:14
178657 178657 01001 P I 1984-02-17 60.0 1984-03-21 S   2011-10-14 16:48:14
178657 178657 01001 P Z 1984-03-22 120.0 1984-03-21 S   2011-10-14 16:48:14
178657 178657 01002A P I 1984-02-17 120.0 1984-04-15 S   2011-10-14 16:48:14
178657 178657 01002A P Z 1984-03-22 240.0 1984-04-15 S   2011-10-14 16:48:14
178657 178657 01002B P I 1984-02-17   1984-04-15 S   2011-10-14 16:48:14
178657 178657 01002B P Z 1984-03-22   1984-04-15 S   2011-10-14 16:48:14
178657 178657 01002C P I 1984-02-17   1984-04-15 S   2011-10-14 16:48:14
178657 178657 01002C P Z 1984-03-22   1984-04-15 S   2011-10-14 16:48:14
178657 178657 01002D P I 1984-02-17   1984-04-15 S   2011-10-14 16:48:14
178657 178657 01002D P Z 1984-03-22   1984-04-15 S   2011-10-14 16:48:14
178657 178657 01003A P I 1984-02-17 120.0 1984-04-15 S   2011-10-14 16:48:14
178657 178657 01003A P Z 1984-03-22 240.0 1984-04-15 S   2011-10-14 16:48:14
178657 178657 01003B P I 1984-02-17   1984-04-15 S   2011-10-14 16:48:14
178657 178657 01003B P Z 1984-03-22   1984-04-15 S   2011-10-14 16:48:14
178657 178657 02003 P I 1984-02-17   1984-04-15 O   2011-10-14 16:48:14
178657 178657 02003 P Z 1984-03-22   1984-04-15 O   2011-10-14 16:48:14
178814 178814 01001A P I 1984-02-17 30.0 1984-02-20 S   2011-10-14 16:48:14
178814 178814 01001A P Z 1984-03-08 60.0 1984-02-20 S   2011-10-14 16:48:14
178848 178848 01001 P Z 1984-03-21 280.0 1984-04-04 S   2011-10-14 16:48:14
178848 178848 01001 P I 1984-04-02   1984-04-04 O   2011-10-14 16:48:14
178848 178848 01002 P Z 1984-03-21 80.0 1984-03-29 S   2011-10-14 16:48:14
178848 178848 01002 P I 1984-04-02 40.0 1984-04-15 S   2011-10-14 16:48:14
178848 178848 01003 P Z 1984-03-21 120.0 1984-03-29 S   2011-10-14 16:48:14
178848 178848 01003 P I 1984-04-02 60.0 1984-03-29 S   2011-10-14 16:48:14
178848 178848 01004 P Z 1984-03-21 240.0 1984-03-24 S   2011-10-14 16:48:14
178848 178848 01004 P I 1984-04-02 120.0 1984-03-24 S   2011-10-14 16:48:14
178848 178848 02001 P Z 1984-03-21   1984-03-24 O   2011-10-14 16:48:14
178848 178848 02001 P I 1984-04-02   1984-03-24 O   2011-10-14 16:48:14
178848 178848 02002 P Z 1984-03-21   1984-03-24 O   2011-10-14 16:48:14
178848 178848 02002 P I 1984-04-02   1984-04-24 O   2011-10-14 16:48:14
178848 178848 02003 P Z 1984-03-21   1984-04-24 O   2011-10-14 16:48:14
178848 178848 02003 P I 1984-04-02   1984-04-24 O   2011-10-14 16:48:14
178889 178889 01001A P Z 1984-04-10 640.0 1984-04-13 S   2011-10-14 16:48:14
178889 178889 01001A P I 1984-04-27 200.0 1984-04-13 S   2011-10-14 16:48:14
178889 178889 01001B P Z 1984-04-10   1984-04-13 S   2011-10-14 16:48:14
178889 178889 01001B P I 1984-04-27   1984-04-13 S   2011-10-14 16:48:14
178889 178889 01002A P Z 1984-04-10 810.0 1984-04-13 S   2011-10-14 16:48:14
178889 178889 01002A P I 1984-04-27 200.0 1984-04-13 S   2011-10-14 16:48:14
178889 178889 01002B P Z 1984-04-10   1984-04-13 S   2011-10-14 16:48:14
178889 178889 01002B P I 1984-04-27   1984-04-13 S   2011-10-14 16:48:14
178921 178921 01001 P Z 1984-03-26 120.0 1984-04-08 S   2011-10-14 16:48:14
178921 178921 01001 P I 1984-04-11 60.0 1984-04-08 S   2011-10-14 16:48:14
178921 178921 01002 P Z 1984-03-26 150.0 1984-03-19 S   2011-10-14 16:48:14
178921 178921 01002 P I 1984-04-11 75.0 1984-03-19 S   2011-10-14 16:48:14
178921 178921 02001 P Z 1984-03-26   1984-04-08 O   2011-10-14 16:48:14
178921 178921 02001 P I 1984-04-11   1984-04-08 O   2011-10-14 16:48:14
178921 178921 02002 P Z 1984-03-26   1984-04-08 O   2011-10-14 16:48:14
178921 178921 02002 P I 1984-04-11   1984-04-16 O   2011-10-14 16:48:14
178921 178921 02003 P Z 1984-03-26   1984-04-08 O   2011-10-14 16:48:14
178921 178921 02003 P I 1984-04-11   1984-04-08 O   2011-10-14 16:48:14
178921 178921 02004 P Z 1984-03-26   1984-04-08 O   2011-10-14 16:48:14
178921 178921 02004 P I 1984-04-11   1984-04-08 O   2011-10-14 16:48:14
178921 178921 02005 P Z 1984-03-26   1984-04-08 O   2011-10-14 16:48:14
178921 178921 02005 P I 1984-04-11   1984-04-16 O   2011-10-14 16:48:14
178921 178921 02006 P Z 1984-03-26   1984-04-08 O   2011-10-14 16:48:14
178921 178921 02006 P I 1984-04-11   1984-04-16 O   2011-10-14 16:48:14
178947 178947 01001 P I 1984-03-16 60.0 1984-04-15 S   2011-10-14 16:48:14
178947 178947 01001 P Z 1984-03-30 120.0 1984-04-15 S   2011-10-14 16:48:14
178947 178947 01002 P I 1984-03-16 60.0 1984-04-15 S   2011-10-14 16:48:14
178947 178947 01002 P Z 1984-03-30 120.0 1984-04-15 S   2011-10-14 16:48:14

Next page

Download this data

CSV · JSON

Table schema 
CREATE TABLE violation_event(activity_nr BIGINT, citation_id VARCHAR, pen_fta VARCHAR, hist_event VARCHAR, hist_date DATE, hist_penalty DOUBLE, hist_abate_date DATE, hist_vtype VARCHAR, hist_insp_nr BIGINT, load_dt TIMESTAMP);