violation

where activity_nr = 101279

✎ 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
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])
);