Law & Order is an American police procedural and legal drama television series, created by Dick Wolf and part of the Law & Order franchise. It originally aired on NBC and, in syndication, on various cable networks. Law & Order premiered on September 13, 1990, and completed its 20th and final season on May 24, 2010. At the time of its cancellation, Law & Order was the longest-running crime drama on American primetime television. After The Simpsons, both Law & Order and Gunsmoke tied for the second longest-running scripted American primetime series with ongoing characters.
All off screen, but occasionally there is discussion of alcohol abuse. Captain Cragen is a recovering alcoholic in his backstory but it is only mentioned occasionally, mostly to gain sympathy for the addict.
The detectives investigate the death of a horse. There is a brief glimpse of the corpse at the beginning but they also spend the rest of the episode discussing it so it's pretty sad.
Special Victims Unit, given how it's all about sexual offenses, will sometimes show a victim being raped onscreen, even if the rape itself is obscured, you still see the victims' reaction