violation

where activity_nr = 100586

✎ View and edit SQL

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
17 17 100586 100586 02006   19100110 F04 I O 1984-02-09 1984-02-13 X         1                               2011-10-14 16:45:21 EDT
18 18 100586 100586 02004   19100107 B09 O 1984-02-09 1984-02-15 X         1                               2011-10-14 16:45:21 EDT
19 19 100586 100586 02003   19100036 B04 O 1984-02-09 1984-02-12 X         1                               2011-10-14 16:45:21 EDT
20 20 100586 100586 01001   19100217 B08 III S 1984-02-29 1984-02-17 X 40.0 80.0     1                               2011-10-14 16:45:21 EDT
21 21 100586 100586 02001A   19040002 A O 1984-02-09 1984-02-12 X         1                               2011-10-14 16:45:21 EDT
22 22 100586 100586 02001B   19040005 A O 1984-02-09 1984-02-13 X         1                               2011-10-14 16:45:21 EDT
23 23 100586 100586 02002   19100022 D01 O 1984-02-09 1984-03-02 X         1                               2011-10-14 16:45:21 EDT
24 24 100586 100586 02005   19100107 E05 O 1984-02-09 1984-03-02 X         2                               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])
);