Federal FOIA Data Solutions
Transforming government transparency through advanced data analysis
FOIA Analytics Dashboard
FY 2025 Data Available Spring 2026
Yearly FOIA statistics at a glance
FOIA Agency Rankings
How agencies are measured and ranked
FOIA Agency Scoring Methodology
FOIA agency rankings use 7 categories to grade each agency's performance for the fiscal year. Data used for these rankings are directly reported from each agency and are aggregated on FOIA.gov. Agencies are classified into seven tiers based on annual requests processed, enabling appropriate peer comparisons.
Only parent agencies are scored to prevent double-counting. (For example, FDA is included in HHS, Army is included in DOD, ICE is included in DHS, etc.)
Scoring Framework (100 Points)
Click any category to view detailed scoring methodology
| Category | Points | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Processing Time | 30 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
What it measures: Percentage of requests processed within 20 days for both simple track and complex track requests. Scoring approach: Split evenly between simple track (15 points max) and complex track (15 points max). Each track uses a base point system with performance-based bonus points. Agencies are ranked within their size category, and those meeting threshold percentages earn additional bonus points based on their percentile ranking among peers. Simple Track Scoring (15 points max)Base Points: Awarded based on percentage of simple track requests processed under 20 days.
Bonus Points: Agencies achieving ≥80% earn bonus points (1-2 points) based on their percentile ranking within their size category, for a maximum of 15 total points. Complex Track Scoring (15 points max)Base Points: Awarded based on percentage of complex track requests processed under 20 days.
Bonus Points: Agencies achieving ≥60% earn bonus points (1-2 points) based on their percentile ranking within their size category, for a maximum of 15 total points. Note: Total score is the sum of simple track points + complex track points, with a maximum of 30 points possible. If an agency has only one track type, that track's score is doubled. Why it matters: Processing the majority of requests within 20 days demonstrates strong operational efficiency and commitment to timely transparency. The 20-day threshold represents best-practice responsiveness in FOIA operations. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Backlog Management | 30 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
What it measures: Three dimensions of backlog health—backlog trajectory (15 pts), absolute size (10 pts), and oldest case age (5 pts). Component 1: Backlog Performance Index - BPI (15 points)Formula: (Current Year Backlog - Previous Year Backlog) ÷ Requests Processed Understanding BPI values:
Example: An agency with 500 requests in backlog last year, 600 this year, and 1,000 processed has BPI = (600-500)/1,000 = 0.10, meaning their backlog grew by 10% of their processing capacity.
Component 2: Backlog Volume (10 points)Method: Government-wide comparison of absolute backlog size using LOG10 transformation to ensure fair scoring across all agency sizes. Why LOG10? This mathematical transformation ensures that a 10× increase in backlog results in the same proportional point penalty, whether an agency grows from 100 to 1,000 cases or from 10,000 to 100,000 cases. This prevents agencies with extremely large backlogs from distorting the scoring scale. How it works: Each agency's backlog is compared to the government-wide minimum and maximum backlog for that fiscal year. Agencies with smaller backlogs (closer to the minimum) receive higher scores, while agencies with larger backlogs (closer to the maximum) receive lower scores. Maximum: 10 points (smallest backlog in comparison group) Component 3: Persistence Score (5 points)Method: Evaluates the age of an agency's 10 oldest pending requests. Each case receives 0-10 points based on age bands, then all 10 scores are averaged and scaled to a maximum of 5 points. Age Band Scoring (per case):
Calculation example: If the 10 oldest cases have ages that score 10, 9, 8, 7, 6, 5, 4, 3, 2, 1 (averaging to 5.5), the persistence score is 5.5 / 10 × 5 = 2.75 points. Why it matters: Effective backlog management prevents multi-year delays and demonstrates sustainable operations. The BPI shows trajectory, volume shows current burden, and persistence reveals whether the oldest cases are being forgotten or actively resolved. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Cost Efficiency | 15 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
What it measures: Total costs per request (10 pts) and litigation expenses per request (5 pts), evaluated using government-wide thresholds. Component 1: Cost Per Request (10 points)Formula: Total Cost ÷ Requests Processed Includes all FOIA program costs (personnel, technology, operations) divided by the number of requests processed during the fiscal year.
Component 2: Litigation Cost Per Request (5 points)Formula: Litigation Costs ÷ Requests Received Litigation-related expenses divided by the total number of requests received during the fiscal year.
Why it matters: Efficient resource use maximizes transparency while respecting taxpayer dollars. Low litigation costs indicate well-justified decisions that withstand legal challenge. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Appeals Performance | 10 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
What it measures: Appeal rate (8 pts) and total backlogged appeals (2 pts). Component 1: Appeal Rate (8 points)Definition: Appeal rate is the percentage of incoming FOIA requests that result in an administrative appeal. Formula: (Appeals Received ÷ Requests Received) × 100
Component 2: Appeals Backlog (2 points)Method: Government-wide comparison using LOG10 transformation to ensure fair scoring across all agency sizes. This transformation treats a 10× increase in backlog (e.g., 10→100 or 1,000→10,000) as equivalent, preventing extreme outliers from distorting the scale. Agencies with smaller appeals backlogs receive higher scores (up to 2 points), while those with larger backlogs receive lower scores (down to 0 points). Why it matters: Low appeal rates signal accurate initial decisions that requesters accept without challenge, reducing downstream litigation and administrative burden. Small appeals backlogs demonstrate efficient processing and prevent delays from compounding. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Fee Collection | 5 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
What it measures: Effectiveness in recovering program costs through fee collection, evaluated within size categories. Scoring approach: Agencies are ranked by fee recovery percentage (fees collected ÷ total costs). Only the top 5 agencies in each size category earn points:
Eligibility: Agencies must collect fees >$0 to qualify for ranking. Why it matters: Appropriate fee collection balances public access with cost recovery, ensuring FOIA programs operate sustainably. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Staff Efficiency | 5 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
What it measures: Staff efficiency based on requests processed per total full-time staff member, evaluated within size categories. Scoring approach: Agencies are ranked by efficiency rate (requests processed ÷ total full-time staff). Only the top 5 agencies in each size category earn points:
Staff calculation: Total full-time staff includes both full-time employees and employees that handle FOIA part-time. Why it matters: High staff efficiency can indicate effective workforce deployment and process optimization. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Data Quality | 5 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
What it measures: Accuracy and completeness of reported FOIA data through track type validation. Validation method: Compares the number of requests processed by track type (simple + complex + expedited) to the reported total number of requests processed. The formula for this score would be (simple + complex + expedited) requests processed ÷ Total Requests Processed.
Why it matters: A perfect 100% score indicates no missing or miscategorized cases. Lower percentages could indicate inaccurate reporting. Accurate data enables informed policy decisions and maintains public trust in transparency metrics. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Total | 100 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
FOIA Resources
Essential links for FOIA professionals and researchers
NextGen FOIA Showcase
Explore innovative FOIA programs and best practices from the Chief FOIA Officers Council.
Visit Showcase →The FOIA Project
Comprehensive research and analysis on Freedom of Information Act implementation and trends.
Explore Project →Sunshine Week
Annual celebration of open government and freedom of information, promoting dialogue about government transparency.
Visit Website →Annual FOIA Reports
Official source data: Agency annual reports on FOIA processing, requests, and compliance metrics.
View Reports →How I Can Help
FOIA Program Analytics
Understand your program's performance and position in the federal landscape.
- Extract meaningful insights from FOIA data and identify operational strengths and weaknesses
- Benchmark against peer agencies to understand where you stand and find improvement opportunities
Custom Reporting
Transform complex FOIA data into clear, actionable visualizations tailored to your needs.
- Automate recurring reports to save time, reduce errors, and ensure consistency
- Create custom dashboards and visualizations that make data accessible to all stakeholders
Strategic Intelligence
Anticipate trends and build data-driven cases for what your program needs.
- Use predictive analytics to forecast request volumes, processing times, and resource requirements
- Quantify accomplishments and create evidence-based justifications for budget and staffing requests
Technical Solutions
Streamline operations through automation and seamless data integration.
- Build custom APIs for integration with existing platforms and enterprise systems
- Automate workflows to eliminate manual processes and improve operational efficiency
Professional Experience & Education
A foundation built on federal service, education, and data expertise
Data Glass LLC
Federal FOIA Solutions | 2025-Present
Making federal FOIA data work for us through AI-enhanced analytics, advanced technical solutions, and data powered intelligence that drives progress and transparency in our government.
Department of Veterans Affairs
Functional Analyst: Compliance Risk & Remediation | 2024-2026
Primary database administrator for VA's enterprise FOIA program, equipping VA stakeholders with data-driven decision-making tools and strengthening FOIA operational efficiency and organizational planning.
United States Army
Avionic Equipment Repairer | 2013-2017
Engaged in multinational exercises and supported missions with foreign allies, supporting operations across the globe.
American University
Kogod School of Business | Washington, D.C.
Bachelor of Science in Business Administration
Key Coursework:
• School of Public Affairs: Public Affairs Advocacy Institute
• Database Management & Statistical Applications
• Data Modelling & Analysis
• Business Intelligence & Analytics
About Me
Thank you for visiting my website. I've had the privilege of working with the Veterans Affairs FOIA Office as a database administrator, Power BI developer, and data analyst. That experience gave me real insight into the challenges federal agencies face every day.
By leveraging the latest technology, I'm able to promote transparency of federal FOIA data and help agencies improve their operations to better serve the public. If you're facing a data challenge, I'd love to hear about it.
—Joel
Get In Touch
Have a question or want to connect? Send me a message and let's start the conversation.