violation
where activity_nr = 101279
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
128 | 128 | 101279 101279 | 01002 | 19260451 A04 | S | 1984-03-09 | 1984-03-15 | N | 100.0 | 100.0 | 1 | 2011-10-14 16:45:21 EDT | ||||||||||||||||||
129 | 129 | 101279 101279 | 01003 | 19260451 E04 | S | 1984-03-09 | 1984-03-15 | N | 100.0 | 100.0 | 1 | 2011-10-14 16:45:21 EDT | ||||||||||||||||||
130 | 130 | 101279 101279 | 01001 | 19260300 B01 | S | 1984-03-09 | 1984-03-12 | N | 100.0 | 100.0 | 1 | 2011-10-14 16:45:21 EDT | ||||||||||||||||||
131 | 131 | 101279 101279 | 02001 | 19260451 E08 | O | 1984-03-09 | 1984-03-15 | 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]) );