violation
where activity_nr = 100578
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16 | 16 | 100578 100578 | 01001 | 19100037 K02 | O | 1984-02-09 | 1984-02-12 | N | 1 | 2011-10-14 16:45:21 EDT |
CREATE TABLE "violation" ( "activity_nr" INTEGER, "citation_id" TEXT, "delete_flag" TEXT, "standard" TEXT, "viol_type" TEXT, "issuance_date" TEXT, "abate_date" TEXT, "abate_complete" TEXT, "current_penalty" REAL, "initial_penalty" REAL, "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" REAL, "fta_contest_date" TEXT, "fta_final_order_date" TEXT, "hazsub1" TEXT, "hazsub2" TEXT, "hazsub3" TEXT, "hazsub4" TEXT, "hazsub5" TEXT, "load_dt" TEXT, FOREIGN KEY([activity_nr]) REFERENCES [inspection]([activity_nr]) );