violation
where activity_nr = 101550
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 152 | 152 | 101550 101550 | 01001 | 19260500 D01 | R | 1984-03-09 | 1984-03-12 | X | 560.0 | 560.0 | 1 | 2011-10-14 16:45:21 EDT | ||||||||||||||||||
| 153 | 153 | 101550 101550 | 02001 | 19260553 A01 | O | 1984-03-09 | 1984-03-12 | X | 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]) );