Show HN: Pardonned.com – A searchable database of US Pardons

501 points by vidluther ↗ HN
https://pardonned.com

Inspired by the videos of Liz Oyer, I wanted to be able to verify her claims and just look up all the pardons more easily.

Tech Stack: Playwright - to sccrape the DOJ website SQLite - local database Astro 6 - Build out a static website from the sqlite db

All code is open source and available on Github.

64 comments

[ 2.4 ms ] story [ 74.5 ms ] thread
> Pardons granted by Donald J. Trump (Second Term) Not Including the January 6th Pardons

Why not include the January 6th pardons?

Just yesterday, Trump said he's going to “pardon everyone who has come within 200 feet of the Oval.” [1] Free reign for crimes for the next 2.5 years.

Maybe removing this pardoning power could be a bipartisan goal... I guess we shouldn't hold our breath.

[1] https://www.yahoo.com/news/articles/trump-promises-pardon-ev...

On the bright side, if they get pardoned they can't plead the fifth and can be forced to testify against anyone not pardoned.
It's not that he just said it yesterday, he's apparently already said it a few times, and yesterday there was just a news article about it.
Love this idea - if I were to extend it, I'd add some kind of analysis breaking down the % composition of pardons (fraud vs drug offences vs financial crime) by President to see if there's some common trend. I was a little surprised to see the Obama number quite so high, until it became apparent that the vast majority were drug offenders being pardoned
If they were listed by Restitution or Fines Abandoned, there is a clear winner, ha ha.
Are there any longer or more generic than this:

> For any nonviolent offenses against the United States which they may have committed or taken part in during the period from January 1 2014 through the date of this pardon (JAN 19, 2025).

https://pardonned.com/pardon/details/biden-family/

That’s 11+ years with no detail or description.

That's when I learned you can be pardoned for future crime since the expiration was end of day. There's nothing stopping a president from signing blanket future pardons with a 100 year expiry. I'm amazed there wasnt any discussion when it happened.
Your numbers seem a bit off on the second Trump term. Trevor Milton was on the hook for over half a billion dollars of restitution alone.
This kind of civic data should have been easily searchable for years. The fact that someone had to build it says a lot about how accessible government records actually are.
Pardon power can serve no reasonable goal in a functioning democracy except to subvert justice.
https://pardonned.com/search/?president=obama-2&categories=d...

I haven’t looked into each case here, but I assume these are a bunch of non-violent drug offenders serving years and decade-long sentences. I see 30 years for “possession with intent to distribute”. That’s just crazy.

When the justice system is clearly broken, it’s ok to subvert it.

There's some value to "the President can correct some wrongs". There are genuine miscarriages of justice sometimes and it's kinda nice to have a release valve for them.

The recent presidential immunity decision just made the downsides way more likely.

Justice is a moving target mate. Should people who had a few pounds of reefer still be serving 30 year sentences? 90's adults would probably say yes. Today? Not so much. Part of being human is being open to the fact you were wrong. The Pardon is the release valve that lets the Chief Executive remove the targets the System has painted on people's backs in response to a clear shift in public conscience. The public in recent history, threw all prudence to the wind and put a con man in office. Surprise, surprise when a con man uses the office to do what con men do.
Nice. But why show Restitution Abandoned etc. if you have no way to calculate it?
We should at least ban the "preemptive" pardon if not all pardons. Pardon means forgiveness for a specific convicted crime, not a means to grant blanket immunity.
(comment deleted)
The preemptive pardon is ridiculous. Pardon for what? What if it comes out someone is a child cannibal? Are they pardoned for that?
There is no universe where any pardon is abolished unless there is a massive political shakeup. The entrenched political class is terrified of endangering their power and privilege even if individual players are ready to do it.
So I have mixed feeling on this.

I'm thinking of Carter fulfilling a campaign pledge to pardon draft dodgers. Whether you support that or not, he did what he said he was going to do and I'm sure only some of them had actually been charged in any way. I think that's a perfectly fine use for the pardon power.

Some will point to the Hunter Biden pardon. So two things can be true at once here: it was absolutely political prosecution AND Joe Biden was completely selfish with his action. At least do something for the people by, say, pardoning a whole bunch of low level drug offenders and decriminalize cannabis at the Federal level. But no, it was completely self-serving but his brain was pretty much gone by this point.

Here's the problem: Federal prosecutors have a ton of power. Conviction rates are 98-99%. But it goes beyond that. Federal prosecutors will intentionally bankrupt you to force you to take a plea. They might charge you with 15 felonies, 12 of which are basically bogus. You still have to defend those bogus felonies and that costs you money. And as soon as you run out of money, they'll offer you a plea where you're looking at 25 years on the 3 remaining felonies or you can just take 10.

The power imbalance is insane and the wealthy are essentially immune. If a US attorney decides to make an example of you, you're going to have a bad time, regardless of the facts.

Millions were spent dredging up some crimes for Hunter Biden and pretty much all they could come up with was doing crack and filling out a form incorrectly. Do you think anyone else would get that level of attention?

A very recent example of this is the Karen Read trial or, as I call it, the most expensive DUI prosecution in history. If you didn't follow the case, don't worry, there'll be any number of true crime documentaries. Millions were spent prosecuting Karen Read for killing JOhn O'Keefe with a completely ridiculous theory of the case and all sorts of evidence that went missing (including police officers disposing of their cell phones on a military base the day before an electronics preservation order was issued).

I don't know what we do about this power imbalance and selective prosecution.

There are two types here: (1) Pardons for crimes not yet committed. (2) Pardons for crimes committed, but not yet convicted. The first type will allow the pardoned to commit a crime in the future for free, which obviously should not be allowed. The second should be allowed if we have this pardon system at all.

The second type became a political necessity, for example to protect Liz Cheney from a vengeful administration.

I agree. I dont care if “my guy” or “your guy” does it, it should not be allowed.
We should go as far as to preemptively ban and sanction any POTUS who says "I'm going to pardon these people before I leave office".

There's no reason to say that unless you know they're actively committing federal crimes in the present day.

As long as that ban doesn't go into effect until after the next non-Republican administration. We need to be able to right the scales after MAGA's abuse of power.
We "should" do many things that aren't feasible, like this or anything else that requires a Constitutional amendment.
Case law agrees with your reading only in part, namely that the pardon power may be exercised at any time after its commission, that is, not preemptive as in being granted before the act being pardoned has taken place.

However, the broader context reads

The power of pardon conferred by the Constitution upon the President is unlimited except in cases of impeachment. It extends to every offence known to the law, and may be exercised at any time after its commission, either before legal proceedings are taken or during their pendency, or after conviction and judgment. The power is not subject to legislative control.

Ex parte Garland, 371 U.S. 333, 380 (1866) https://tile.loc.gov/storage-services/service/ll/usrep/usrep...

Changing it would require not a mere legislative act but a constitutional amendment.

To the executive alone is intrusted the power of pardon; and it is granted without limit.

United States v. Klein, 80 U.S. 128, 147 (1871) https://tile.loc.gov/storage-services/service/ll/usrep/usrep...

(comment deleted)
Thank you. Apologies in advance for nitpicking, but I think the correct spelling is "pardoned" (a quick search on Google confirms it).
Presidential pardons should be banned, period. All presidential pardons are political in nature, and therefore not based on justice.
I would have thought a lot of the drug offense pardons by Obama would have been for marijuana but looking at the first few pages, they’re not.

> 118 of 2,791 GRANTS

Only 118 list marijuana in the pardon text

Reminder that the pardon is a vestigial leftover from monarchism. The idea that one single person can go "nuh uh" in a democratic country is just another massive failure of the US constitution, a legal document written to suppress the will of the people and allow for minority rule but too sacrosanct to change for "reasons" that all seem to only benefit a small minority of people.

Relegate pardon powers to only amount to commutations, at the bare minimum.

Oh fun fact, Alexander Hamilton thought monarchies were the best form of government.

Presidents shouldn't have the right to outright pardon people. It should have to go through some sort of body beforehand and be voted on like everything else.
Thanks for this. As engineers, I think it’s natural for us to look at things like executive orders and pardons, tools that seemingly have no real restrictions or caps, and immediately see them as open to exploitation by bad actors.

The pardon system in particular needs a serious overhaul. For every case where a pardon is used to correct an "unjust ruling", it swings just as easily in the opposite direction. Frankly I have more faith in a decision that goes through the proper judicial process than in one made unilaterally by a single person with zero oversight. There's a reason it's been historically called the "royal pardon".

We need a combination of:

- hard caps on the maximum number of pardons a president can issue per term

- congressional review before those pardons take effect

Land of the free ( white collard criminals )
Really terrific. Such fun to see overviews and then dig into the details to see how assumptions about each situation were inaccurate at first glance.
Are you able to track repeat pardons of the same offender? If not you have a bug.

https://pardonned.com/pardon/details/adriana-isabel-camberos...

Adriana Camberos was in fact pardoned twice.

In 2021, convicted fraudster Adriana Camberos was freed from prison when President Trump commuted her sentence. Rather than taking advantage of that second chance, Ms. Camberos returned to crime. She was convicted again in 2024 in an unrelated fraud. In 2026, Mr. Trump pardoned her again.

Full story here: https://www.nytimes.com/2026/01/16/us/politics/trump-fraudst...

Have you created a linked data SPARQL endpoint?