FOIA Annual Report Data Compilation Worksheet

Worksheet to compile request volumes, backlog, processing times, and exemption use for the agency annual FOIA report to DOJ.

Reporting Period and Submitter

• Reporting year
  Enter the calendar year covered by this annual FOIA report.
• Office or component name
  Name of the office, component, or program submitting the data.
• Submitter name
  Name of the person compiling the worksheet for internal routing and follow-up.
• Submitter email
  Work email address for questions about this submission.
• Submission date
  Date the worksheet is completed and submitted.

Request Volume Summary

• Total FOIA requests received
  Count all FOIA requests received during the reporting year.
• Requests pending at start of year
  Number of requests carried over from the prior reporting year.
• Requests closed during year
  Total requests closed during the reporting year.
• Requests pending at end of year
  Number of requests still open at the end of the reporting year.
• Requests for expedited processing
  Count of requests where expedited processing was requested.

Backlog and Processing Time

• Backlog at start of year
  Number of requests in backlog at the start of the reporting year.
• Backlog at end of year
  Number of requests in backlog at the end of the reporting year.
• Median processing time in days
  Median number of calendar days to process closed requests.
• Average processing time in days
  Average number of calendar days to process closed requests, if tracked.
• Age of oldest pending request in days
  Number of days the oldest open request has been pending at year-end.

Exemptions and Dispositions

• Requests granted in full
  Number of requests granted in full.
• Requests granted in part
  Number of requests granted in part.
• Requests denied in full
  Number of requests denied in full.
• Exemption categories used
  Select the FOIA exemption categories applied during the reporting year.
• Exemption notes
  Optional notes explaining unusual exemption use, redaction trends, or reporting clarifications.

Fee and Administrative Data

• Fee waiver requests received
  Count of fee waiver requests received during the reporting year.
• Fee waivers granted
  Count of fee waiver requests granted.
• Administrative appeals received
  Count of FOIA administrative appeals received during the reporting year.
• Administrative appeals closed
  Count of FOIA administrative appeals closed during the reporting year.
• Fee and administrative notes
  Optional clarifications about fee calculations, appeal handling, or data sources used for the report.

Certification and Data Quality

• Data source confirmed
  Confirm the figures were compiled from official FOIA tracking records and supporting reports.
• Accuracy attestation
  I attest that the information provided is complete and accurate to the best of my knowledge.
• Certification notes
  Optional notes about data limitations, assumptions, or reconciliation issues.