violation

where activity_nr = 113951

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