violation
where activity_nr = 102129
Download this data as a CSV Spreadsheet (All Rows)
Link | rowid ▼ | activity_nr | citation_id | delete_flag | standard | viol_type | issuance_date | abate_date | abate_complete | current_penalty | initial_penalty | contest_date | final_order_date | nr_instances | nr_exposed | rec | gravity | emphasis | hazcat | fta_insp_nr | fta_issuance_date | fta_penalty | fta_contest_date | fta_final_order_date | hazsub1 | hazsub2 | hazsub3 | hazsub4 | hazsub5 | load_dt |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
228 | 228 | 102129 102129 | 01001 | 19260100 A | O | 1984-04-24 | 1984-04-27 | N | 1 | 2011-10-14 16:45:21 EDT |
CREATE TABLE "violation" ( [activity_nr] INTEGER REFERENCES [inspection]([activity_nr]), [citation_id] TEXT, [delete_flag] TEXT, [standard] TEXT, [viol_type] TEXT, [issuance_date] TEXT, [abate_date] TEXT, [abate_complete] TEXT, [current_penalty] FLOAT, [initial_penalty] FLOAT, [contest_date] TEXT, [final_order_date] TEXT, [nr_instances] INTEGER, [nr_exposed] INTEGER, [rec] TEXT, [gravity] INTEGER, [emphasis] TEXT, [hazcat] TEXT, [fta_insp_nr] INTEGER, [fta_issuance_date] TEXT, [fta_penalty] FLOAT, [fta_contest_date] TEXT, [fta_final_order_date] TEXT, [hazsub1] TEXT, [hazsub2] TEXT, [hazsub3] TEXT, [hazsub4] TEXT, [hazsub5] TEXT, [load_dt] TEXT );