The Law and Order Database

The Law and Order Database

Together, we WILL know Jack.

It seems strange to say that I’m going to miss Law and Order, since it’s on TV roughly 87 times a day. TNT airs it pretty much non-stop. It’s only a matter of time before they start showing two episodes at once, split-screen, like in Back to the Future 2. Nevertheless, 456 episodes doesn’t seem like nearly enough. Nowadays even the sitcoms have aggressively serialized storylines stretching from episode to episode. Law and Order always delivered a self-contained package in 43 minutes, perfect for those of us who love quality TV but don’t want to make a commitment. I seldom bothered to watch Law and Order‘s new episodes on the night they aired, but that was the whole point. I knew I’d catch them years later while channel surfing, and they’d still be awesome.

But there is one bright side to the end of the show. We now have a massive, complete data set to dive into.

OTI readers know that Excel is our friend on this site. Mark Lee found the secret correlation between oil production and rock and roll. I charted the snowballing snootiness of the Academy Awards. But this is going to be our biggest project yet–finding the hidden patterns in 20 seasons of murder trials.

To do this, we’re going to need your help. Surprisingly, there’s no place online that actually recounts complete Law and Order plots going back to the beginning. The Law and Order wiki is pretty vague on plot details. All Things Law and Order does encyclopedic recaps, but only for the newer episodes. It’s easy to find one or two sentence synopses, but we want to know how each and every case ended. For that, I think someone is going to have to actually watch a lot of Law and Order. Luckily, that’s what we were all planning to do anyway, right?

Alright detectives, bookmark this page. Everytime you see an episode of L&O (by the way, we’re only talking about the mothership here, not the spinoffs), stop by. It’ll only take 30 seconds to answer this two question survey:

[UPDATE, 7/23: Whoever is watching every single episode of the show in order and sending me the results, please email me at [email protected]. I just want to digitally shake your hand.]

Contribute to the Law and Order Database

    Episode Title

    What was the name of the episode you just saw? (Push "Info" on your fancy remote.)

    If you have no way of knowing, please give an identifying detail. For instance, the name of a guest star and his character name or a short summary of the plot.


    Note that if you pick the “no clear outcome” option, please indicate in the “other” box if a certain outcome seems likely. A good example is the “Blackmail” episode from January. Towards the end, the prosecutors have the murderer identified, but the key witness refuses to testify. In the climactic scene, they convince him to cooperate, allowing the trial to go forward. We never see the results of that trial, but McCoy and Co. are swaggering like it’s an easy guilty verdict or plea bargain. Because we don’t know for sure, you would indicate it as “no clear outcome,” but mention the circumstances so we can take that into account.

    So what do we hope to learn from this? Besides reminding ourselves of how awesome Sam Waterston is?

    First of all, did the conviction rate change from season to season? If so, can we correlate this to anything in the real world? For instance, the actual crime rate in New York spiked in the early 90s, when the show began, and then declined markedly through the Giuliani years. Was this trend towards law and order reflected in Law and Order?

    But maybe the real-world crime rate is less important than the real-world economy. In the first 10 episodes of this current season, only 6 prosecutions resulted in convictions. Maybe the bad economy makes people uneasy about the ability of government to protect us?

    We can also correlate the results with the show’s fictional characters. If Adam Schiff is your favorite D.A.,  you’ll finally be able to prove that he had a higher percentage of guilty verdicts than Arthur Branch. And how does Jerry Orbach compare to Anthony Anderson? I mean, weightwise, it’s no contest, but detectionwise? We owe it to our children to find out.

    Is is, of course, totally possible (if not probable) that the results will be a whole lot of nothing. As much as I’d love to see a sexy-looking curve on that graph, it’s likely that the show has always had about three-quarters guilty verdicts: any less and it would get frustrating for the audience, any more and it would start to seem like too much of a sure thing. With only 20-something episodes per season, there’s going to have to be a significant change to seem like a real trend and not just random statistical noise. And even if there is a pattern waiting to be discovered, it might be a long long time before we’ve collected enough information to find it.

    But hey, this is Law and Order we’re talking about. Years from now, long after you’ve forgotten all the crazy revelations in the final episode of Lost, you’ll still be catching reruns of L&O after work, marveling at Dennis Farina’s mustache. And when you do, come back here and tell me if the good guys won that day.

    Update, May 25, 2010:

    The finale just aired. I didn’t care for it, because it violated two of my Rules for Solid Law & Order Episodes:

    1. There must be a murder.
    2. There must be a trial.

    I know they didn’t know this was their swan song, so I can forgive them for being uncharactistic. Still, all those ticking clocks theatrics seemed to ape the more Bruckheimeresque procedurals that followed in L&O’s wingtips.

    However, the episode is more than redeemed by one final demonstration of Sam Waterston’s awesomeness. It’s about three-quarters of the way through, and the police are having no luck getting a teacher to reveal information about a potentially homicidal colleague. Jack McCoy hasn’t had a single line all episode, but he pokes his head into a conference room to watch a Teacher’s Union lawyer sneer down the detectives’ desperate warnings of a possible massacre. McCoy then heads the guy off at the elevator to ask:

    Just how far up your ass is your head?

    And when the Teacher’s Union guy continues to talk tough, McCoy sets him straight:

    If your obstruction allows a massacre to happen, I will crucify you, Mr. Graylick. I will charge you with negligent homicide, and after I convict you I will resign my job and represent the families of the victims in a wrongful death suit against you and the union. By the time I’m done, you’ll be finished. So my advice to you is get out of my way.

    I’ve watched that scene about five times so far, and I’m still giggling every time.

    Anyway, in honor of the finale, here’s some preliminary results from the Law & Order Database.

    Law & Order: Season 20

    # Ep Name Result
    1 Memo From The Dark Side No verdict (trial halted)
    2 Just A Girl In The World Guilty
    3 Great Satan Guilty
    4 Reality Bites Hung Jury
    5 Dignity Guilty
    6 Human Flesh Search Engine Plea bargain
    7 Boy Gone Astray Charges dismissed
    8 Doped Plea bargain
    9 For The Defense Guilty
    10 Shotgun No indictment
    11 Fed Plea bargain
    12 Blackmail Guilty
    13 Steel-Eyed Death Plea bargain
    14 Boy On Fire Plea bargain (implied?)
    15 Brilliant Disguise Guilty
    16 Innocence Plea bargain
    17 Four Cops Shot Guilty
    18 Brazil Plea bargain
    19 Crashers Plea bargain
    20 The Taxman Cometh Plea bargain
    21 Immortal Plea bargain
    22 Love Eternal Guilty
    23 Rubber Room Guilty (implied)

    Update, June 4, 2010:

    Thanks largely to the heroic efforts of Kyu (see the comment thread), I now have the complete results for Season 1.

    Law & Order: Season 1

    # Ep Name Result
    1 Prescription for Death Guilty
    2 Subterranean Homeboy Blues Plea bargain
    3 The Reaper’s Helper Not guilty of murder, Guilty of endangerment
    4 Kiss the Girls and Make Them Die Guilty
    5 Happily Ever After Guilty
    6 Everybody’s Favorite Bagman Guilty
    7 By Hooker, By Crook Plea bargain
    8 Poison Ivy Defendant committed suicide
    9 Indifference Guilty
    10 Prisoner of Love No clear verdict, guilty implied
    11 Out of the Half-Light No charges filed
    12 Life Choice Guilty
    13 A Death in the Family Declined to prosecute
    14 The Violence of Summer Guilty
    15 The Torrents of Greed (1) n/a – two parter
    16 The Torrents of Greed (2) Defendant killed
    17 Mushrooms Guilty
    18 The Secret Sharers Not guilty
    19 The Serpent’s Tooth Guilty
    20 The Troubles Guilty
    21 Sonata For a Solo Organ Guilty
    22 The Blue Wall Guilty

    The easiest way to analyze this data is, how often did they convict the criminal? In Season 1, there were two Not Guilty verdicts: The Reaper’s Helper and The Secret Sharers. However, the notes I received say that in the case of The Reaper’s Helper, the DA actually sought this result (the defendant was dying of AIDS and they didn’t want him to go to jail). This is a tricky call – is the outcome Success, since the DA got what he wanted? Or is it Failure, because the guy was charged with Murder and found Not Guilty? I think for now, I’m counting it as Success – they convicted the guy of what they thought was fair.

    There are five episodes where there isn’t clear Success or Failure. Poison Ivy and The Torrents of Greed (a two-parter) ended with the defendant’s death. Out of the Half-Light is about a girl who claims she was raped, but it turns out the story was a complete fabrication. A Death in the Family is about a cop who shoots his partner, but it turns out to be self-defense, and the DA tells the Grand Jury it was Justifiable Homicide.

    So of the 22 Season 1 episodes, 17 had clear Success or Failure, and of those, 16 were successes. That’s a 94% success rate.

    Let’s compare with Season 20. First interesting thing is that all 23 episodes ended with clear Success or Failure (if you disagree with my analysis, by the way, let me know). Of those 23 episodes, 4 were Failures. That’s an 82% success rate.

    Yeah, that’s a big difference in the success rates. But if only two or three episodes had ended differently, both seasons would have been exactly the same. I am still guessing that the results aren’t going to graph well – the success rate is always going to be between 80% and 95%, but won’t trend smoothly from season to season. We’ll see. Keep sending the data along everybody!

    23 Comments on “The Law and Order Database”

    1. Pinky Sidewinder #

      When the $2000 boxed set of every season is released we should all donate so you can buy it. Then you can assign teams to review each DVD over the course of a month and we can tabulate the results.

      I’m _very_ interested in that graph.


    2. Tom #

      I love the idea, but might I suggest a different name?

      “Logged & Ordered”


    3. Gab #

      Beliinkie wins for the idea, but Tom wins for the name suggestion.


    4. lauren #

      I absolutely can not wait for the data to reveal what kind of social and cultural changes resulted from Elisabeth Rohm’s sudden and bizarre departure from the show.


    5. Sourire11 #

      Um. This is incredible. And awesome. And the next time I spend the day after a holiday in a Law and Order Marathon haze I will be sure to contribute my results.

      Tom wins for the name.


    6. Megan from Lombard #

      TNT is actually running a marathon of “critical” episodes leading up to the series finale so I figured that it would be adventagous to watch and see if there was any change in verdicts through out the series ;)


    7. fruity #

      This page is now in my bookmarks; I’m in! Brilliant name suggested by Tom.

      On a sort-of related note, as a recent law school graduate of a Midwestern law school who’s studying for the New York bar, I’ve always wished there was a website that dissected how accurate the legal rules and procedures were portrayed on the show. L&O definitely has helped me study evidence rules. A database like that would be pretty sweet for law students.


    8. catsimmie #

      You also need to be able to submit the twist as well as the witty remark! What L&O datebase would be complete without lines like “Is this because I’m a lesbian?”


    9. Petra #

      Yeah, I’m with catsimmie. That particular line was way outta left-field when it was asked on Rohm’s last episode. Meanwhile, Orbach always had at least one good one (and sometimes more!) per show.


    10. Ashley #

      I have to agree that Jack McCoy’s speech was my favorite part of the whole episode. I will be on Law & Order watch from now on!


    11. Sharon Soike #

      Some years ago there was a website that listed all the shows and cast. The point was to show how often actors would appear in different episodes. Usually only one episode per year, but sometimes different L&O’s.

      Anyone know the name of that site?


    12. steve #

      I’d love to see a subset of the reasons for non-conviction: 1. The cops screwed up, 2. The DA’s office screwed up, 3. The perp. was just too smart to be convicted, or 4. Justice was served, either by a not guilty verdict when the suspect actually was not guilty, or the DA just went through the motions knowing a conviction would not serve society while ruining a life.


    13. Helen #

      Phew. Now I don’t feel so bad about it finishing. I can’t bear to watch the least episode.

      Would it be possible to record the series and epsiode number, as well as episode title?

      Thank you for understanding.


    14. Marcus Tee #

      So when do we see any results for our hard work?
      In order to keep MY attention we will need to see some results as we go. Otherwise I (personally) will lose interest in accumulating data.

      Marcus Tee


    15. Matthew Belinkie OTI Staff #

      @Marcus –

      I’ll put up the results season by season, as soon as I have enough data. I’ve already got the most recent season up. Expect another one soon.

      – Matt


    16. Mary #

      What a great idea! I will definitely be contributing. Plus, it gives me a reason to pull out the first 4 seasons I have on DVD. No, I’m not obsessed!


    17. Kate #

      My Evidence professor always told us that L&O was actually pretty right on with the legal stuff.
      Fruity, if you’re studying for the NY Bar. Take Pieper’s class if he’s still doing it.


    18. Marcus Tee #

      Thanks Matt!


    19. Bernard H. Merems #

      While this does not directly bear on this posting, I wonder if anyone is old enough to uncover/discover a very early
      Law & Order episode that I have failed to locate after several years of searching. I would like to know the episode name, number, season number of one of the most skillful and suprising dramas in the series. It is outstanding for its plot twist, cameral work, visual story telling and direction.
      It’s a simple enough plot: a very pregrant woman is jailed without bail pending her trial for the self-defense killing of her brutal husband.

      She urges the DA for an espeditious trial, so her baby would not be born in prison. This is done and while the trial is drawing to a conclusion, with the jury not back with a verdict, she goes into labor and is rushed to the hospital.

      An assistant DA rushes to the hospital to tell her the verdict: not guilty. The shocker comes after this, which I’ll not include here to avoid spoiling it for others who mayu wish to view this gem.

      Thanks for any and all aid,
      Bernard H. Merems


    20. Kyu #

      I’ve been going through Season 1 in the last couple of days. What’s really interesting to me relating to this project is how nuanced the endings are. There are few unequivocal victories. Even when a guilty verdict is reached, the closing lines indicate the limitations of the justice system and the costs of achieving anything within it. It’s no surprise that a show this dialectical can’t help but complicate our basic impulses toward narrative (and emotional) closure.

      Anyway, the show is very good so far, and contributing to this database is addicting. I plan to continue all the way through the 20th season–we’ll see if I get there in time.


    21. mlawski OTI Staff #

      To all of the people who have contributed so far, you are Overthinking It heroes. And, kyu, if you actually watch all 20 seasons, you deserve some sort of medal. (Don’t kill yourself, though!)


    22. Jake #

      Suggestion: Find someone with a law school education to do a legal analysis of each episode.


    Add a Comment