Show HN: Pardonned.com – A searchable database of US Pardons
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 - 22661 sekunder sedanWe 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.
- spuz - 7096 sekunder sedanThis is the kind of data I would like to see on ourworldindata.org. They have good tools for visualising data and comparing between countries.
- koolba - 31523 sekunder sedanAre 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.
- lateforwork - 11292 sekunder sedanAre 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...
- jimkleiber - 9377 sekunder sedanI 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.
- cs702 - 18744 sekunder sedanThank you. Apologies in advance for nitpicking, but I think the correct spelling is "pardoned" (a quick search on Google confirms it).
- millbj92 - 14932 sekunder sedanPresidents 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.
- wavint - 7967 sekunder sedanThis 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 - 34180 sekunder sedanJust 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...
- kupadapuku - 33282 sekunder sedanLove 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
- xrd - 12918 sekunder sedanReally terrific. Such fun to see overviews and then dig into the details to see how assumptions about each situation were inaccurate at first glance.
- - 19659 sekunder sedan
- jsiepkes - 34923 sekunder sedan> Pardons granted by Donald J. Trump (Second Term) Not Including the January 6th Pardons
Why not include the January 6th pardons?
- soumyaskartha - 25981 sekunder sedanThis 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 - 13107 sekunder sedanLand of the free ( white collard criminals )
- hk1337 - 15966 sekunder sedanI 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
- digdugdirk - 29917 sekunder sedanYour 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.
- fgkuescvricky - 10836 sekunder sedanHave you created a linked data SPARQL endpoint?
- mpassman - 23982 sekunder sedanNice. But why show Restitution Abandoned etc. if you have no way to calculate it?
- vunderba - 14417 sekunder sedanThanks 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
- shimman - 15595 sekunder sedanReminder 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.
- andrewstuart - 25509 sekunder sedanPardon power can serve no reasonable goal in a functioning democracy except to subvert justice.
- Luki1234 - 16480 sekunder sedancool
- insane_dreamer - 16043 sekunder sedanPresidential pardons should be banned, period. All presidential pardons are political in nature, and therefore not based on justice.
- takahitoyoneda - 25785 sekunder sedan[dead]
- devcraft_ai - 18688 sekunder sedan[dead]
- dailoxxxx - 42942 sekunder sedan[dead]
- emiliazar - 49907 sekunder sedan[dead]
Nördnytt! 🤓