violation
where activity_nr = 113951
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1080 | 1080 | 113951 113951 | 02001 | 19101017 M02 | O | 1984-07-17 | 1984-08-17 | X | 14 | 3 | C | 2011-10-14 16:45:21 EDT | ||||||||||||||||||
1081 | 1081 | 113951 113951 | 01001C | 19101017 F01 | S | 1984-07-17 | 1985-01-15 | N | 14 | 3 | C | 2011-10-14 16:45:21 EDT | ||||||||||||||||||
1082 | 1082 | 113951 113951 | 01001A | 19101017 C01 | S | 1984-07-17 | 1985-01-15 | N | 630.0 | 630.0 | 14 | 3 | C | 2011-10-14 16:45:21 EDT | ||||||||||||||||
1083 | 1083 | 113951 113951 | 01001B | 19101017 C02 | S | 1984-07-17 | 1985-01-15 | N | 14 | 3 | C | 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]) );