原文
A comprehensive, searchable database of all executive clemency grants issued by President Donald Trump during both his presidencies. This project provides detailed datasets and an interactive web interface for analyzing presidential pardons and commutations across both terms.
This database tracks all presidential pardons and commutations issued during both Trump presidencies:
- 1,500+ January 6th defendants (mass clemency on Day 1)
- High-profile political figures (Rod Blagojevich, Scott Jenkins, Brian Kelsey)
- Celebrity cases (Todd & Julie Chrisley, NBA YoungBoy)
- Business executives (Paul Walczak, Devon Archer, Jason Galanis)
- Organized crime figures (Larry Hoover - Gangster Disciples)
- Anti-abortion activists (24 clinic blockade participants)
- White-collar criminals and corruption cases
- Political pardons (Michael Flynn, Paul Manafort, Roger Stone)
- Military cases (Eddie Gallagher, Clint Lorance, Blackwater guards)
- Celebrity pardons (Lil Wayne, Kodak Black)
- Business fraud (Michael Milken, Conrad Black)
- Historical pardons (Jack Johnson, Susan B. Anthony)
- Drug offense commutations (Alice Johnson advocacy cases)
- Total Recipients: 500+ individual records across both terms
- Categories: January 6, Political, Business, Corruption, Drug-related, Anti-Abortion, Military, Celebrity
- Restitution Waived: $200+ million in financial penalties forgiven
- Geographic Scope: Cases from all federal districts
- 📱 Mobile-responsive design - Works perfectly on all devices
- 🔍 Advanced search & filtering - By name, offense, category, date, amount
- 📈 Real-time statistics - Live counts and totals for each presidency
- 📊 Interactive demographics - January 6th defendant analysis
- 🎨 Dark theme optimized for readability
- ⚡ Fast loading with client-side filtering
- 🗂️ Three-tab navigation - Second Term | First Term | Demographics
- Comprehensive demographics of January 6th defendants
- Employment patterns (24.7% business owners, 17.2% blue collar)
- Geographic distribution across 47 states
- Financial hardship correlation with violent behavior
- Political affiliation tracking
- Conviction success rates (99.4% for Jan 6 cases)
- Cross-presidency comparison capabilities
Three-tab interface with comprehensive data tables
Advanced filtering and search interface
Filtered results with active search parameters
Fully responsive mobile design with touch-friendly interface
Touch-optimized mobile filter controls
Both CSV files follow the same schema for consistency:
Name,Date,Type,Category,Offense,Original_Sentence,Restitution_Amount,Political_Party,Court,Notes
- Name: Individual or group name
- Date: Date clemency was granted (YYYY-MM-DD)
- Type: "Pardon" (full forgiveness) or "Commutation" (sentence reduction)
- Category: January 6, Political, Business, Corruption, Drug, Anti-Abortion, Military, Celebrity, etc.
- Offense: Criminal charges and convictions
- Original_Sentence: Prison term before clemency
- Restitution_Amount: Financial penalties waived (in dollars)
- Political_Party: Republican, Democrat, Unknown
- Court: Federal district court of conviction
- Notes: Additional context and significance
- Offense: Narcotics distribution, money laundering (Silk Road marketplace)
- Original Sentence: Life without parole
- Significance: Campaign promise to Libertarian supporters
- Offense: Bank fraud, tax evasion ($36M scheme)
- Original Sentences: 12 years (Todd), 7 years (Julie)
- Significance: Reality TV stars, daughter lobbied at RNC
- Date: Inauguration Day
- Scope: ~1,500 defendants pardoned or had sentences commuted
- Impact: Ended largest domestic terrorism prosecution in US history
- Offense: False statements to FBI
- Significance: Former National Security Adviser, Mueller investigation
- Offense: Tax fraud, bank fraud, conspiracy
- Original Sentence: 7.5 years
- Significance: Former Trump campaign chairman
- Offense: Nonviolent drug conspiracy
- Original Sentence: Life without parole
- Significance: Kim Kardashian advocacy, became Trump's clemency adviser
Based on Seton Hall University research of 716 first-wave prosecutions
- 24.7% Business owners (106)
- 17.2% Blue collar workers (74)
- 8.8% White collar workers (38)
- 8.1% Unemployed (35)
- Florida: 11.5% (82 defendants)
- Pennsylvania: 8.9% (64 defendants)
- Texas: 8.8% (63 defendants)
- New York: 7.4% (53 defendants)
- California: 7.3% (52 defendants)
- Total: 47 states represented
- 19.6% experienced financial distress
- 16.3% had judgments/liens
- 15.5% faced foreclosures/evictions
- 9.8% filed for bankruptcy
- Key Finding: 42% of financially distressed engaged in violence
- Gender: 81.3% male, 12.7% female
- Race: 92% white, 8% other ethnicities
- Criminal History: 22.2% had prior convictions
- Armed: 25% came armed to Capitol
- Law Enforcement/Military: 18.5% background
- HTML5 with semantic structure and accessibility features
- CSS3 with modern flexbox/grid layouts and responsive design
- Vanilla JavaScript for optimal performance
- Progressive enhancement approach
- Mobile-first responsive design philosophy
- Dual CSV system for separate term data
- Client-side filtering for instant search results
- Real-time statistics calculation
- Error handling and validation
- Performance optimization for large datasets
- Efficient DOM manipulation with minimal reflows
- Debounced search to prevent input lag
- Lazy data loading for improved initial load time
- Optimized rendering for mobile browsers
- Accessible navigation with keyboard support
The database is automatically deployed via GitHub Pages at: https://codeddarkness.github.io/taco_pardons/
# Clone the repository
git clone https://github.com/codeddarkness/taco_pardons.git
cd taco_pardons
# Serve locally (any HTTP server)
python -m http.server 8000
# OR
npx http-server
# OR
php -S localhost:8000
# Access via browser
# http://localhost:8000- Web Server: Any HTTP server (Apache, Nginx, Python, Node.js, etc.)
- Browser: Modern browser with JavaScript enabled
- Files: HTML file and CSV files must be served via HTTP (not file://)
No special configuration required. The application is entirely client-side and works with any web server capable of serving static files.
-
Official Government Records
-
Legal Documentation
- Federal court records and sentencing documents
- FBI statements of facts
- DOJ press releases and indictments
-
News Sources & Verification
- Reuters, Associated Press, CNN, NBC News
- Washington Post, New York Times
- Specialized legal publications (Lawfare, Marshall Project)
- Academic Research
- Cross-referencing multiple sources for accuracy
- Court document validation where available
- Timeline verification against official announcements
- Regular updates as new clemency actions occur
- Daily checks of official clemency announcements
- RSS feeds from DOJ and White House
- Court document tracking systems
# Add new entries to appropriate CSV file
# trump_pardons_csv.txt (Second Term)
# trump_pardons_first_term_csv.txt (First Term)
# Follow schema:
# Name,Date,Type,Category,Offense,Original_Sentence,Restitution_Amount,Political_Party,Court,Notes- CSV format validation
- Duplicate detection
- Field completeness checking
- Source verification requirements
We welcome contributions to improve the database and analysis.
- Verify sources - Provide official documentation
- Follow schema - Match existing CSV format exactly
- Include citations - Link to source documents
- Test locally - Ensure website functions properly
- Fork the repository
- Create feature branch (
git checkout -b feature/improvement) - Test thoroughly - Verify mobile compatibility
- Submit pull request with detailed description
- Use GitHub Issues for bug reports
- Include browser version and device type
- Provide steps to reproduce problems
- Suggest improvements or corrections
This project is released under the MIT License - see the LICENSE file for details.
- Database content is factual public information
- Academic and journalistic use encouraged
- Attribution appreciated but not required
- Commercial use permitted under MIT terms
This database contains factual information about presidential clemency actions compiled from public sources. It is maintained for:
- Educational purposes and public transparency
- Academic research and policy analysis
- Journalistic reference and fact-checking
- Historical documentation of executive actions
Not intended for: Legal advice, official government use, or definitive legal determinations.
If you find errors or have additional verified information:
- Open a GitHub issue with source documentation
- Submit a pull request with corrections
- Email with official court documents or press releases
- Check existing GitHub Issues
- Review installation instructions
- Verify browser compatibility (Chrome, Firefox, Safari, Edge)
- Seton Hall University Center for Policy & Research
- Professor Mark Denbeaux and research team
- Department of Justice Office of the Pardon Attorney
- Federal Bureau of Investigation for case documentation
- Modern CSS Grid and Flexbox specifications
- Vanilla JavaScript ES6+ features
- Responsive design best practices
- Multiple news organizations for cross-referencing
- Legal journalists and court reporters
- Open source intelligence communities
- Government transparency advocates
Last Updated: June 9, 2025
Database Version: 2.2
Total Records: 500+
Next Update: Weekly (or as clemency actions occur)
This project demonstrates the power of public data transparency and the importance of tracking executive clemency actions across multiple presidencies. By making this information accessible and searchable, we contribute to government accountability and informed civic engagement.