violation

where activity_nr = 101162

✎ 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
97 97 101162 101162 02007   19180091 A O 1984-02-29 1984-03-03 N         1                               2011-10-14 16:45:21 EDT
98 98 101162 101162 02002   19170043 B02 O 1984-02-29 1984-03-03 N         1                               2011-10-14 16:45:21 EDT
99 99 101162 101162 01001   19170152 D01 XVI S 1984-02-29 1984-03-03 N 180.0 180.0     12                               2011-10-14 16:45:21 EDT
100 100 101162 101162 01002   19180105 A S 1984-02-29 1984-03-03 N 180.0 180.0     17                               2011-10-14 16:45:21 EDT
101 101 101162 101162 02001   19170011 A O 1984-02-29 1984-03-03 N         1                               2011-10-14 16:45:21 EDT
102 102 101162 101162 02008   19180091 B O 1984-02-29 1984-03-03 N         3                               2011-10-14 16:45:21 EDT
103 103 101162 101162 02003   19170044 H O 1984-02-29 1984-03-09 N         1                               2011-10-14 16:45:21 EDT
104 104 101162 101162 02004   19170045 G03 III O 1984-02-29 1984-03-05 N         2                               2011-10-14 16:45:21 EDT
105 105 101162 101162 02005   19170071 D01 O 1984-02-29 1984-03-09 N         1                               2011-10-14 16:45:21 EDT
106 106 101162 101162 02006   19170122 C O 1984-02-29 1984-03-02 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])
);