Show HN: Pardonned.com – A searchable database of US Pardons (undefined)
280 points by vidluther 13 hours ago
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.
siliconc0w 6 hours ago
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.
LocalH an hour ago
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.
torben-friis 33 minutes ago
>There's no reason to say that unless you know they're actively committing federal crimes in the present day.
There are reasons. For example, you feel the justice system is going to be misused against them. Protection against future witch hunts basically.
I don't think this is what's happening here, and trump is on record talking very explicitly about weaponising the state against his enemies himself, but it's probably an excuse that will be used.
sanex 14 minutes ago
flowerlad an hour ago
Not true. Liz Cheney hasn’t committed any crimes (as far as we know).
lateforwork 2 hours ago
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.
elAhmo an hour ago
The notion itself that someone needs to be protected by a 'vengeful administration', while judicial system should be not politically affiliated is telling how broken the whole separation of powers is. Everyone who is a ruling party puts candidates they know aligned with their views, resulting in 'just wait until my turn comes and I will do as much as damage as possible' cycle.
b00ty4breakfast 4 hours ago
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.
bloppe 2 hours ago
I've often wondered what would happen if a president explicitly offers to pardon anybody who murders members of Congress. Would they settle on reigning in the pardon power with an amendment?
We're sort of already there. A lot of the Jan 6 rioters were openly trying to murder congressmen. The fact they weren't successful isn't super reassuring.
didgetmaster an hour ago
aexer0e 2 hours ago
giancarlostoro an hour ago
I agree. I dont care if “my guy” or “your guy” does it, it should not be allowed.
2OEH8eoCRo0 5 hours ago
The preemptive pardon is ridiculous. Pardon for what? What if it comes out someone is a child cannibal? Are they pardoned for that?
conception 4 hours ago
There’s no /s so I’m assuming you didn’t know that child cannibalism was in the Epstein files https://www.yahoo.com/news/articles/fact-check-breaking-down...
So to answer your question, seems like Yes, pardons for all!
fwipsy 4 hours ago
jmyeet 2 hours ago
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.
mullingitover 2 hours ago
> Federal prosecutors have a ton of power. Conviction rates are 98-99%.
This always gets thrown around, but the fact is they should be that high. Prosecutors shouldn't bring cases unless they have evidence of guilt beyond a reasonable doubt, and DOJ prosectors don't (normally) screw around.
When you see lower rates of conviction, as in the current ethically bankrupt administration, it's often malicious prosecution, aka "You'll beat the rap, but you won't beat the ride."
jmyeet an hour ago
koolba 8 hours ago
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.
ceejayoz 7 hours ago
https://en.wikipedia.org/wiki/Pardon_of_Richard_Nixon
https://www.presidency.ucsb.edu/documents/proclamation-4311-...
> Now, Therefore, I, Gerald R. Ford, President of the United States, pursuant to the pardon power conferred upon me by Article II, Section 2, of the Constitution, have granted and by these presents do grant a full, free, and absolute pardon unto Richard Nixon for all offenses against the United States which he, Richard Nixon, has committed or may have committed or taken part in during the period from January 20, 1969 through August 9, 1974.
Not quite as long, but much more significant. (No violence exception, the criminal was the President, and they were crimes against the entire country, not some random drug/tax charges.)
gcanyon 6 hours ago
Ford did real damage that day.
Pikamander2 5 hours ago
jfengel 11 minutes ago
vidluther 8 hours ago
So this was the first time (i think) anyone got a preemptive pardon, the actual warrant on the DOJ website says what it says.. https://www.justice.gov/pardon/media/1385756/dl?inline
Will have to crunch through the offenses in the db and see if anything else like this shows up.
lelandfe 8 hours ago
Preemptive meaning they hadn't yet been convicted. Nixon was pardoned by Ford in this manner (for "all offenses against the United States" between Jan. 20, 1969—Aug. 9, 1974). Carter preemptively mass-pardoned draft dodgers, etc.
vidluther 7 hours ago
whoiskevin 6 hours ago
Look at what the Trump administration has done with the DOJ pursuing unwarranted indictments against anyone Trump doesn't like. All getting thrown out so far. And you lead with questioning why one of his constant targets would pardon his family? The bigger question is why this isn't more outrage at the GOP attempts to find something on Biden or Clinton. They have been wasting tax dollars while Coomer "investigates" for something that he has never been able to prove. I'd have pardoned everyone around me given that constant sustained and terrible attack. All the while the Trump grift machine continues without so much as a blink.
GorbachevyChase 6 hours ago
So two wrongs have made a right in this case? I think that you should not be emotionally invested in internet people impugning the honor of one crime family over another.
ceejayoz 5 hours ago
nozzlegear 5 hours ago
DM70 10 minutes ago
May I ask you if your project does what nobody else does in USA?
lateforwork 3 hours ago
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...
vidluther an hour ago
Interesting story, but I do not see her name in the list of pardons and commutations on the source website twice.
https://www.justice.gov/pardon/commutations-granted-presiden...
She only shows up here
https://www.justice.gov/pardon/clemency-grants-president-don...
yorwba 41 minutes ago
The first time was under the name Adriana Shayota: https://www.justice.gov/usao-sdca/pr/federal-jury-convicts-s...
cs702 5 hours ago
Thank you. Apologies in advance for nitpicking, but I think the correct spelling is "pardoned" (a quick search on Google confirms it).
SpyCoder77 5 hours ago
Most likely that domain was already taken.
vidluther an hour ago
It's a play on Donald Trump, after watching a Liz Oyer video linking a very plausible pardon for sale scheme, I wanted to initially build a site that showcased pardons just by Trump, but I realized that would be partisan and not as useful.
SpaceL10n 5 hours ago
Pardon me, but this is a list of pardons given to pardoned people.
ceejayoz 4 hours ago
I'd presumed this was a wordplay on Donald Trump.
vidluther an hour ago
correct.
jimkleiber 2 hours ago
I like the concept. I'd love to see more types of data available, especially maybe race, age, connection to the president or their families, donations that the pardoned/commuted people have given and to whom, and more.
I'd find that fascinating for seeing deeper patterns.
spuz an hour ago
This is the kind of data I would like to see on ourworldindata.org. They have good tools for visualising data and comparing between countries.
kupadapuku 9 hours ago
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
justin66 6 hours ago
The Obama number is also high because the designer combined Obama's first and second terms into one figure, unlike what he did with the other presidents who served two terms.
vidluther 6 hours ago
Hmm, I see the issue.. The DOJ website lists all of Obama's as once, so I need to modify the parser.. https://www.justice.gov/pardon/pardons-granted-president-bar...
Compare that to the other list. https://www.justice.gov/pardon/clemency-recipients
darknavi 6 hours ago
hk1337 4 hours ago
Even so, it’s still higher than the other presidents listed
vidluther 8 hours ago
A bunch of mass commutations have occurred under Obama, Biden, and most recently under Trump, I'm working on a comparison tool, so we can visualize the change in number of pardons by president, further breakdown of composition is an interesting idea as well.
GorbachevyChase 6 hours ago
A more interesting analysis to me would not be the number pardoned, but rather the monetary value of correlated donations or direct financial interests. Pardons are one of the many services for sale, it seems.
vunderba 4 hours ago
vidluther 6 hours ago
nonameiguess 7 hours ago
I'm pretty sure the numbers are going up simply because 1) 90s sentencing laws got insanely strict and prisons are full of old guys serving inflated sentences, 2) drug laws eventually became more lax and people are in prison for things that aren't even criminal any more, and 3) prisons have simply run out of space and it's easier to release people than build more.
This kind of topic is bound to bring up a lot of outrage, but I'd invite people to remember it's the Marc Richs of the old buying pardons that you should be directing that toward. There are plenty of people locked up for a very long time who really don't deserve it. I recall a Chumash woman I worked with at the LA County Museum of Natural History 24 years ago. I gave her a ride home a few times and eventually realized I was taking her to a halfway house, and it came out that the FBI has busted her in the early 90s for criminal conspiracy and her only actual offense was refusing to testify against her husband, who'd been selling marijuana on their reservation under the logic that he didn't believe US law should apply because of the historical treaties about tribal land. She did 10 years in federal prison for that.
GorbachevyChase 6 hours ago
Friend, I hope you do not actually believe that man was selling dope because of his nuanced political theories.
fabianholzer 3 hours ago
none2585 5 hours ago
vidluther 7 hours ago
@nonameiguess I agree on the pardon buying, the reason why I started looking into building this was because of a video by Liz Oyer, who pointed out all the restitution and fines that were being forgiven under Trump.
That's kind of how I came upon the name for the site, I wanted to see if there is any truth to the rumors that people are selling and buying pardons. In order to investigate that, we needed a set of data to start from, in a manner that was easily queryable as opposed to what's on the DOJ website.
justin66 6 hours ago
millbj92 4 hours ago
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.
salawat 2 hours ago
The Pardon is a structural check on the legislative and judiciary. It cannot be done away with safely without causing massive problems down the road. If anything, this should be a learning experience for the country not to put criminally inclined presidents in office.
wavint 2 hours ago
This is exactly the kind of thing the DOJ website should have provided natively. Good reminder that "public record" and "actually accessible" are very different things. Bookmarked.
ks2048 9 hours ago
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...
amanaplanacanal 5 hours ago
On the bright side, if they get pardoned they can't plead the fifth and can be forced to testify against anyone not pardoned.
technothrasher 5 hours ago
Unfortunately, probably not. As they could simply invoke the fifth under the claim that they might incriminate themselves under some state law.
CobraMode 8 hours ago
As long as they can still pardon the turkey.
Lio 7 hours ago
Pardon him for what? What is the charge here? Being a meal? Being a succulent Chinese meal?
winstonewert 7 hours ago
xrd 3 hours ago
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.
jsiepkes 9 hours ago
> Pardons granted by Donald J. Trump (Second Term) Not Including the January 6th Pardons
Why not include the January 6th pardons?
vidluther 8 hours ago
That disclaimer is there for now to make it clear that we're not showing that data yet. I need to figure out how to show the mass commutations done by Biden as well.
Working on a comparison tool, so we can see # of pardons over admins, it seems the number of pardons has been going up each administration.
soumyaskartha 7 hours ago
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.
dopidopHN2 3 hours ago
Land of the free ( white collard criminals )
digdugdirk 8 hours ago
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.
vidluther 8 hours ago
Thanks for the heads up on that.. there's a lot of massaging/cross checking that still needs to be done. Right now the numbers are based purely on what the sentence is described on the DOJ website.
https://www.justice.gov/pardon/clemency-grants-president-don...
cmd-f trevor milton .. if the text for the sentence column doesn't say anything about a fine or restitution the system is not going to be able to figure that out.
The numbers for the prison time reduced is also technically incorrect, Ross Ulbricht, Rod Blagojevich and many others had already served many years in prison, so technically we should not count that as time reduced.
hk1337 4 hours ago
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
mpassman 6 hours ago
Nice. But why show Restitution Abandoned etc. if you have no way to calculate it?
vidluther 6 hours ago
i am calculating it if it's available in the sentence details. If the sentence details don't have a fine or restitution then we can't calculate it.
elicash 4 hours ago
Would love if you can track this more deeply and sort/filter/search through restitutions and fines. The ones you know about, that is.
shimman 4 hours ago
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.
fgkuescvricky 2 hours ago
Have you created a linked data SPARQL endpoint?
vunderba 3 hours ago
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
andrewstuart 7 hours ago
Pardon power can serve no reasonable goal in a functioning democracy except to subvert justice.
glerk 5 hours ago
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.
layer8 5 hours ago
The parent’s wording does actually imply that subverting justice is a reasonable goal.
ceejayoz 5 hours ago
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.
fernmyth 6 hours ago
It’s an alternative to coups and civil wars. The deal made in private conversations is something like “Give up power peacefully. Everybody gets pardoned and goes home to their families. Nobody needs to do anything crazy or violent out of desperation to avoid prison.”
salawat 2 hours ago
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.
Luki1234 4 hours ago
cool
insane_dreamer 4 hours ago
Presidential pardons should be banned, period. All presidential pardons are political in nature, and therefore not based on justice.