violation

where activity_nr = 102129

✎ 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
228 228 102129 102129 01001   19260100 A O 1984-04-24 1984-04-27 N         1                               2011-10-14 16:45:21 EDT 
CREATE TABLE "violation" (
   [activity_nr] INTEGER REFERENCES [inspection]([activity_nr]),
   [citation_id] TEXT,
   [delete_flag] TEXT,
   [standard] TEXT,
   [viol_type] TEXT,
   [issuance_date] TEXT,
   [abate_date] TEXT,
   [abate_complete] TEXT,
   [current_penalty] FLOAT,
   [initial_penalty] FLOAT,
   [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] FLOAT,
   [fta_contest_date] TEXT,
   [fta_final_order_date] TEXT,
   [hazsub1] TEXT,
   [hazsub2] TEXT,
   [hazsub3] TEXT,
   [hazsub4] TEXT,
   [hazsub5] TEXT,
   [load_dt] TEXT
);