Hacker News

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

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.


siliconc0w5 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.

LocalH10 minutes 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.

giancarlostoro13 minutes ago

I agree. I dont care if “my guy” or “your guy” does it, it should not be allowed.

lateforworkan hour 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.

elAhmo16 minutes 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.

b00ty4breakfast3 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.

bloppean hour 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.

didgetmaster30 minutes ago

Like most political arguments, if you listen carefully; those who advocate for or against pardons, only want them to go one way.

A pardon is only a protection against a 'vengeful administration' if that administration is not your party.

Pardons are only a miscarriage of justice if those pardoned don't share your ideology.

aexer0e44 minutes ago

Pardons only stop the federal government from prosecuting someone, the states would still go after those individuals

dawnerd6 minutes ago

And in theory a future administration could do something like threaten to withhold funding to states that don’t prosecute.

2OEH8eoCRo04 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?

mdni0073 hours ago

[flagged]

conception4 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!

fwipsy3 hours ago

From the article you linked, child sacrifice allegations came from an anonymous FBI interview in 2019 and are not confirmed by any credible evidence. There are no cannibalism allegations; the word "cannibal" only appears in innocuous contexts.

So child sacrifice and cannibalism are only technically "in the Epstein files;" there's very little evidence that anyone did those things. For other readers, if you hadn't heard about this, that's probably why.

royaltjames2 hours ago

Little evidence that I was abused as a child too, must not have happened.

OtomotOan hour ago

I am deeply sorry for your experience and I totally understand that it triggers something, but let's be ice cold logical for a moment.

If there is no evidence of a crime, you cannot prosecute someone in a constitutional democracy.

If you could you could just make up any claims and get rid of people you simply despise.

Which happens in various regimes...

So although it's certainly a possibility that such cases happened, as long as there is no evidence that they happened, they didn't for all legal matters.

[deleted]4 hours agocollapsed

jmyeetan hour 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.

mullingitoveran hour 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."

lateforwork2 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...

vidlutherop10 minutes 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...

koolba7 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.

ceejayoz6 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.)

gcanyon5 hours ago

Ford did real damage that day.

Pikamander24 hours ago

The real embarrassment is how little effort there's been to limit/reform the pardon system since then.

Pardons have valid uses, but it's wild that a single person can unilaterally pardon donators, family members, former presidents, etc, without needing so much as a simple majority confirmation vote in the House or Senate.

The questionable pardons that we've seen over the last few years (and the Nixon pardon) are just the tip of iceberg in terms of how badly they could be abused.

I'd imagine it won't be long until we see a president issue a preemptive pardon to themself at the end of their term, because there's nothing in the constitution that says they can't.

Ray202 hours ago

Isn't that the whole point of all these pardon things? To reduce incentives to usurp power to avoid responsibility by providing less destructive for the political system ways to avoid responsibility.

cjbgkaghan hour ago

Or concretely, would the Israeli wars end sooner if Netanyahu was pardoned of all crimes? Would Kim Jong Un consider giving up his position if he could be pardoned, or at least credibly believe that he could live a life in luxurious exile? I don’t know the answer to either of those questions, but I do think letting some people get away with crimes with witness immunity can make it much more difficult for criminals to organize as the optimum move is to defect before anyone else does. Which is why I think elite blackmail focuses on unforgivable deeds.

ceejayozan hour ago

They're a release valve for "the system fucked up and permitted an injustice".

Avoiding responsibility isn't the goal, and shouldn't be possible.

vidlutherop7 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.

lelandfe7 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.

vidlutherop7 hours ago

I did not know that. Thanks for the lesson.

[deleted]6 hours agocollapsed

whoiskevin6 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.

Jerrrrrrrry5 hours ago

[dead]

GorbachevyChase5 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.

ceejayoz4 hours ago

> So two wrongs have made a right in this case?

No, it was right to consider the possibility that Trump would violate the norms here. Letting the President right unaddressed wrongs is the entire reason the pardon power exists.

His own current Chief of Staff has similar concerns, and grand juries seem to be taking the same position; that these are just revenge.

https://www.nytimes.com/2025/12/16/us/politics/trump-susie-w...

"Susie Wiles, the White House chief of staff, told an interviewer that she forged a “loose agreement” with Mr. Trump to stop focusing after three months on punishing antagonists, an effort that evidently did not succeed. While she insisted that Mr. Trump is not constantly thinking about retribution, she said that “when there’s an opportunity, he will go for it.”"

[deleted]4 hours agocollapsed

nozzlegear4 hours ago

> crime family

[deleted]6 hours agocollapsed

spuz27 minutes 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.

cs7024 hours ago

Thank you. Apologies in advance for nitpicking, but I think the correct spelling is "pardoned" (a quick search on Google confirms it).

SpyCoder774 hours ago

Most likely that domain was already taken.

SpaceL10n4 hours ago

Pardon me, but this is a list of pardons given to pardoned people.

ceejayoz3 hours ago

I'd presumed this was a wordplay on Donald Trump.

vidlutherop16 minutes ago

correct.

wavint41 minutes 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.

millbj923 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.

salawatan hour 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.

jimkleiberan hour 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.

ks20488 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...

amanaplanacanal4 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.

technothrasher4 hours ago

Unfortunately, probably not. As they could simply invoke the fifth under the claim that they might incriminate themselves under some state law.

CobraMode7 hours ago

As long as they can still pardon the turkey.

Lio6 hours ago

Pardon him for what? What is the charge here? Being a meal? Being a succulent Chinese meal?

winstonewert6 hours ago

For anyone who might be confused about the pardoning a turkey reference: https://en.wikipedia.org/wiki/National_Thanksgiving_Turkey_P...

DonHopkins3 hours ago

[deleted]6 hours agocollapsed

draw_down6 hours ago

[dead]

kupadapuku8 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

justin665 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.

vidlutherop5 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

darknavi5 hours ago

That's probably intentional on the DOJ's part at this point.

vidlutherop4 hours ago

not sure why you think it's intentional. But, created a github issue, and will work on that today/tonight.. yay GLM 5.1 :)

https://github.com/vidluther/pardonned/issues/23

darknavi2 hours ago

I meant it's probably intentional that the data being represented differently on the DOJ's website, not your tracker website.

regular_trash3 hours ago

Stuff like this is very common. For example, at the start of Trump's second term, the whitehouse history page was changed to make democrat presidents look bad -

https://www.whitehouse.gov/about-the-white-house/the-white-h...

duskdozer3 hours ago

>not sure why you think it's intentional

It's entirely on brand.

hk13373 hours ago

Even so, it’s still higher than the other presidents listed

[deleted]5 hours agocollapsed

vidlutherop7 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.

GorbachevyChase5 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.

vunderba3 hours ago

Agreed. I often compare the way the current administration is wielding the pardon system to the old Catholic practice of papal indulgences.

vidlutherop5 hours ago

that is in the works. Working on making sure the data of the pardons is correct first.

nonameiguess6 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.

GorbachevyChase5 hours ago

Friend, I hope you do not actually believe that man was selling dope because of his nuanced political theories.

fabianholzer2 hours ago

Be that as it may, the jurisdiction I am living in has an explicit right to refuse to testify against a spouse. It is wild to me that one can construct a crime out of that, let alone one that warrants a decade of incarceration.

none25854 hours ago

Why is that so hard to believe?

vidlutherop6 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.

justin665 hours ago

The next step would be to dig into how much money is spent lobbying for pardons.

https://campaignlegal.org/update/inside-pardon-playbook-anal...

I'm pretty new to this particular issue so I don't have a ton to offer. It's really interesting, though. Nice site, by the way.

xrd2 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.

[deleted]4 hours agocollapsed

jsiepkes8 hours ago

> Pardons granted by Donald J. Trump (Second Term) Not Including the January 6th Pardons

Why not include the January 6th pardons?

vidlutherop7 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.

soumyaskartha6 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.

dopidopHN22 hours ago

Land of the free ( white collard criminals )

hk13373 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

fgkuescvrickyan hour ago

Have you created a linked data SPARQL endpoint?

digdugdirk7 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.

vidlutherop7 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.

mpassman5 hours ago

Nice. But why show Restitution Abandoned etc. if you have no way to calculate it?

vidlutherop5 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.

elicash3 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.

vunderba2 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

shimman3 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.

andrewstuart6 hours ago

Pardon power can serve no reasonable goal in a functioning democracy except to subvert justice.

glerk5 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.

layer84 hours ago

The parent’s wording does actually imply that subverting justice is a reasonable goal.

ceejayoz4 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.

salawatan hour 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, through 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.

[deleted]16 minutes agocollapsed

fernmyth5 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.”

Luki12343 hours ago

cool

insane_dreamer3 hours ago

Presidential pardons should be banned, period. All presidential pardons are political in nature, and therefore not based on justice.

takahitoyoneda6 hours ago

[dead]

devcraft_ai4 hours ago

[dead]

dailoxxxx10 hours ago

[dead]

emiliazar12 hours ago

[dead]

hn-front (c) 2024 voximity
source