Does Delaware FOIA make my agency convert raw data from HTML to CSV when I ask for it as a database file?

Official title

19-IB53 9/17/2019 FOIA Opinion Letter to Mr. Craig O'Donnell re: FOIA Complaint Concerning The Department of Safety and Homeland Security

Plain-English summary

Craig O'Donnell of the Dover Post asked the Delaware State Police on January 15, 2019 for individual incident-level data for Part I offenses 2014-2016, in CSV/database/spreadsheet format. He explicitly said he did not want to require DSP to create new records and offered flexibility. DSP acknowledged on January 24 that the request was in legal review with an estimated 15-business-day update. Seven months passed with no further communication. On August 27, 2019, DSP produced HTML files. O'Donnell petitioned, raising nine separate complaints: missed deadlines and updates, no clarification request, format mismatch, "constructive denial," and inconsistency with prior DSP positions on data exports.

The AG sided with DSP on every substantive point but flagged the timing as concerning. The opinion found the claims about DSP's initial process moot once DSP produced the records it deemed responsive, while recommending more timely communications. On format, the opinion held that "FOIA does not require a public body to convert its existing files into other formats." DSP's counsel represented that the files were produced in the only format available to DSP and containing existing fields, and the AG accepted that representation about the existence of records "in accordance with past practice." The opinion added that FOIA does not require a public body to explain why provided records are responsive, send a separate cover letter, or respond to routine emails within particular timeframes. The AG closed by recommending DSP "provide more timely communications in the future."

Currency note

This opinion was issued in 2019. Subsequent statutory amendments, court decisions, or later AG opinions may have changed the analysis. Treat this page as historical context, not current legal advice. Verify current law before relying on any specific rule, deadline, or remedy mentioned here.

Common questions

Why doesn't FOIA require format conversion?

The opinion holds that "FOIA does not require a public body to convert its existing files into other formats," while it "does require that a public body allow access to a document in its available format." If the agency holds data only as HTML reports, FOIA reaches them in that form rather than compelling an Excel or CSV export.

Is producing HTML the same as producing nothing?

The opinion does not treat it that way. It accepted DSP's representation that the HTML files were the only format available and containing existing fields, and held there was no FOIA violation in producing them. The opinion does not address how a requester might obtain a different format.

Was the seven-month delay a violation?

The opinion did not find a violation. It treated the claims about DSP's initial process as moot once DSP produced its responsive records, but recommended that DSP "provide more timely communications in the future."

What does "constructive denial" mean and did it apply?

The petitioner argued that DSP's prolonged silence followed by a format-mismatched production amounted to a refusal to respond. The opinion did not adopt that framing. It grouped the process claims as moot once records arrived and found no violation in the response itself.

Doesn't this conflict with DSP's other position that database exports are "new records"?

The petitioner pressed that contradiction. The opinion noted that DSP's counsel represented the files were produced in the only available format and that "this Office has previously held that FOIA does not preclude a public body from voluntarily releasing a record," so producing the existing HTML files did not resolve whether exporting raw database content is required.

Background and statutory framework

The Uniform Crime Reporting (UCR) program is the FBI's voluntary national crime statistics system; participating agencies submit data in defined fields. State agencies typically generate UCR submissions from internal databases. The journalist's request sought the underlying incident-level data, not the aggregated statistics that DSP publishes annually.

FOIA's right of access covers inspection and copying of public records in their available format. The opinion applies that limit directly: "FOIA does not require a public body to convert its existing files into other formats," though it "does require that a public body allow access to a document in its available format."

The opinion also relied on mootness for the timing claims: once DSP produced the records it deemed responsive, the claims about its initial process were moot, leaving only the AG's recommendation that DSP communicate more promptly.

Citations

• 29 Del. C. §§ 10001-10007 (Delaware Freedom of Information Act)
• 29 Del. C. § 10005 (petition determinations)

Source

• Landing page: https://attorneygeneral.delaware.gov/2019/09/17/19-ib53-9-17-2019-foia-opinion-letter-to-mr-craig-odonnell-re-foia-complaint-concerning-the-department-of-safety-and-homeland-security/
• Original PDF: https://attorneygeneral.delaware.gov/wp-content/uploads/sites/50/2019/10/Attorney-General-Opinion-No.-19-IB53.pdf

Original opinion text

PRINT VERSION: Attorney General Opinion No. 19-IB53

OFFICE OF THE ATTORNEY GENERAL OF THE STATE OF DELAWARE

Attorney General Opinion No. 19-IB53

September 17, 2019

VIA EMAIL

Mr. Craig O'Donnell

Dover Post

[email protected]

RE: FOIA Petition Regarding the Delaware Department of Safety and Homeland Security / Delaware State Police

Dear Mr. O'Donnell:

We write in response to your correspondence alleging that the Delaware State Police ("DSP") violated Delaware's Freedom of Information Act, 29 Del. C. §§ 10001-10007 ("FOIA") in connection with your request for records. We treat your correspondence as a Petition for a determination pursuant to 29 Del. C. § 10005 regarding whether a violation of FOIA has occurred or is about to occur. As discussed below, while we do not determine that DSP has violated FOIA as alleged, we recommend DSP provide more timely communications in the future.

BACKGROUND

You sent DSP a request on January 15, 2019 seeking the following:

[A]n electronic copy of data for individual Part I offenses reported or known to police from 2014-2016, as compiled for purposes of participating in the FBI's national Uniform Crime Reporting (UCR) system and other incident tracking purposes. For each individual UCR Part I offense known to police, please provide the following data fields:

The incident number of the offense, Incident/offense date, Type of offense, Unfounded (yes/no), Unfounded Date, Clearance Date, Arrest Date, Type of clearance, Exceptional clearance type.

It is our understanding your agency participates in the FBI's Uniform Crime Reporting program, and has for years regularly compiled and reported crime statistics in a manner that complies with the requirements of that program.

We specifically request to receive the bulk of this information in a useable electronic format. Data records should be provided in a format such as a delimited text/CSV, or database file such as Microsoft Access database or Microsoft Excel spreadsheet. Data records should NOT be provided as a PDF file or other non-useable electronic format, nor on paper, without first checking with us.

In the event you no longer have incident level data in electronic form going back to 2014, please provide as much electronic data as you do currently have in your possession. It is our intention to work with your agency on this request. We do not wish you to create any new sets of information, or to go to great lengths to re-create older information.

On January 24, 2019, DSP's FOIA Coordinator acknowledged receipt of your request, advised that it had been sent for legal review, and stated that an update would be provided within fifteen business days. However, you did not receive any further response from DSP until August 27, 2019. You then filed a Petition, alleging the following:

DSP failed to provide any notice about the request between January 24 and August 27, 2019 regarding the "untimely delay" in providing records. DSP did not contact you to clarify what you were seeking and consequently provided records which are not responsive to your request. DSP did not provide a good faith estimate of how long it would take to complete a response to your request. The documents provided are not responsive to the request and appear to be database printouts of annual summaries. DSP did not withhold the documents and state that it would require creating new records, as DSP previously stated with regard to other requests. DSP provided the records as HTML files when DSP should have claimed responsive records "could not be provided because they are not documents exported to Excel." DSP did not provide a separate letter with the response to explain why you did not receive what you requested. DSP did not respond within 24 hours to your request for clarification of the issues raised in item 6 above. DSP's response is a "constructive denial."

On September 4, 2019, DSP's counsel replied to your Petition ("Response"). DSP denies violating FOIA and requests that the petition be dismissed as moot because DSP provided all responsive documents in its possession. In response to item 1, DSP asserts that its January 24, 2019 email complied with FOIA's response requirements because it was sent six business days after your request was received and notified you of a permissible reason that the response would take another estimated fifteen business days. For item 2, DSP disputes that it needed clarity to respond to your request. For item 3, DSP acknowledges that it did not provide any updates between January 24 and August 27, 2019 but claims there is no evidence it acted in bad faith. DSP also notes that you contacted them regarding other FOIA requests during this time and did not request any update on this, though acknowledging you are not obligated to do so.

In response to issues 4 through 7 and 9, DSP asserts that "FOIA does not require a public body to create a new document in response to a record request; however, FOIA does require that a public body allow access to a document in its available format," and because the documents were made available to you in the only format DSP had, there was no need to contact you regarding format. DSP also notes that this Office has previously held that FOIA does not preclude a public body from voluntarily releasing a record. DSP asserts in response to item 7 that FOIA does not require a cover letter or other explanatory document.

In response to item 8, DSP disputes your allegation that it did not reply to your email with questions within 24 hours and argues FOIA does not have this requirement. DSP provided exhibits showing that you asked on August 28, 2019 if there was a cover letter or if you needed to file a FOIA request for such and that the DSP FOIA Coordinator responded a few hours later.

DISCUSSION

Your claims can be grouped into two categories: allegations regarding DSP's initial process in responding to the request and allegations regarding the response itself. First, we determine that the claims regarding DSP's initial process in responding to your request are now moot, as DSP has provided a response enclosing the records it deems responsive. However, we recommend DSP provide more timely communications.

Second, we reviewed the claims regarding DSP's response and find no violation of FOIA. FOIA does not prohibit the disclosure of records but merely gives the public body the grounds to withhold records exempt from the definition of "public records." Moreover, DSP's counsel represents that DSP produced the files responsive to the request in the only format available to DSP and "containing existing fields," and in accordance with past practice, our Office accepts this representation regarding the existence of records. FOIA does not require a public body to convert its existing files into other formats. FOIA does not require a public body to explain why the provided records are responsive, send a separate cover letter, or respond to emails received in its normal course of business within certain timeframes. Finally, although DSP acknowledges the FOIA Coordinator did not contact you to state the records would not be produced in the desired format as you requested, DSP alleges this communication was not necessary, as there were no formatting options to discuss. We do not believe that these circumstances rise to the level of a FOIA violation.

CONCLUSION

For the reasons set forth above, while we do not determine that DSP has violated FOIA as alleged, we recommend DSP provide more timely communications in the future.

Very truly yours,

/s/ Alexander S. Mackler

Alexander S. Mackler

Chief Deputy Attorney General

cc: Lisa M. Morris, Deputy Attorney General

Dorey L. Cole, Deputy Attorney General