osha_enforcement

Custom SQL query returning 1 row (hide)

select 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 from violation where "activity_nr" = :p0 order by rowid limit 101

Query parameters

p0