¶ 1 This appeal arises out of three requests for public records submitted by plaintiff/appellant, the American Civil Liberties Union of Arizona (“ACLU”), to defendant/appellee, the Arizona Department of Child Safety (“DCS”), and its predecessor agency. We hold that when, as here, a state agency maintains public records in an electronic database, Arizona’s public records law requires the
FACTS AND PROCEDURAL BACKGROUND
¶ 2 In May 2013, the ACLU submitted a public records request to DOS’s predecessor, the Arizona Department of Economic Security (“DES”), which at that time was the state agency statutorily responsible for administering child welfare services, and investigating and responding to allegations of child abuse and neglect. The request, which consisted of 30 separate requests with multiple subparts, sought records concerning child welfare services in the possession of DES’s Division of Children, Youth, and Families (“DCYF”) and Child Protective Services. Many of the separate requests required DES to tally or compile numerical or statistical information and percentages. For example, request no. 12 asked DES to provide “[t]he number of children who were substantiated victims of abuse and/or neglect perpetrated by their caregiver(s) while placed” in out-of-home: (a) unlicensed foster care; (b) licensed foster care; (c) congregate care. And, request no. 18 asked DES to provide:
The average number of placements experienced by children in out-of-home care as of the last day of SFY [State Fiscal Year] 2011, 2012 and 2013, or of each of the Semi-Annual Reporting Periods within those SFYs, by total time in care according to the following (or any similar available) distribution: (a) 1 year or less; (b) 1-2 years; (c) 2-5 years; and (d) more than 5 years.
¶ 3 DES responded to certain of the separate requests relying on information from reports it had previously generated. And, as discussed in more detail below, DES’s Report and Statistics Unit retrieved some of the information requested by the ACLU by searching its mainframe based electronic case management system, “CHILDS,” an acronym for Children’s Information Library and Data Source. DES produced records responsive to 14 of the ACLU’s separate requests between May and October 2013. But, by year’s end, DES had not produced records responsive to the remaining separate requests.
¶ 4 On January 28 and 31, 2014, the ACLU submitted a second and a third public records request to DES, and its newly created Department of Child Safety and Family Services (“DCSFS”).
¶ 5 The January 28 request contained 37 separate requests with multiple subparts; the January 31 request contained 24 separate requests, also with multiple subparts. Both requests again required DES to tally or compile numerical or statistical information and percentages. For example, the January 28 request no. 28 asked DES to provide “the number of children in the following age groups who were placed in shelters at any time during the requested periods while in DES foster care custody: (a) ages 0-1; (b) ages 1-5; (c) ages 6-8; (d) ages 9-12; and (e) ages 13-17.” The January 31 request no. 1 asked DES to provide:
[T]he number of Reports concerning children who were not in out-of-home care that were assigned for investigation as Priority 1: High Risk, and that (a) were initiated in a timely manner, and (b) not initiated in a timely manner. For purposes of this question, “initiated in a timely manner” means that the investigation’s Initial Response Time was two hours or less if the investigation was assigned a Standard Response Time, or 24 hours or less if assigned a Mitigated Response Time.
DES did not acknowledge receipt of the January 2014 requests until April 28, 2014.
¶ 6 On May 2, 2014 the ACLU filed a statutory special action asking the superior court to order DES to provide “copies” of all the requested records it had failed to produce, index of any records it had withheld, and its reason for withholding any record. See Ariz. Rev. Stat. (“A.R.S.”) § 39-121.01(D)(2) (Supp. 2015)
¶ 7 After discovery, briefing, and an evi-dentiary hearing, the superior court rejected the ACLU’s request that it order DCS to produce records responsive to the remaining outstanding record requests (“the outstanding requests”).
DISCUSSION
I. CHILDS is a Public Record
¶ 8 The ACLU first argues the superior court should have decided that the electronic records and data maintained by DCS in CHILDS makes CHILDS a public record, and, therefore, DCS was required to query or search CHILDS to respond to its public records requests. Exercising de novo review, we agree with the ACLU that the electronic records and data maintained by DCS in CHILDS makes CHILDS a public record. See Griffis v. Pinal Cty.,
¶ 9 Arizona law defines “public record” broadly and creates a presumption requiring the disclosure of public documents. Id. at 4, ¶ 8,
A public record is one “made by a public officer in pursuance of a duty, the immediate purpose of which is to disseminate information to the public, or to serve as a memorial of official transactions for public reference”; a record that is “required to be kept, or necessary to be kept in the discharge of a duty imposed by law or directed by law to serve as a memorial and evidence of something written, said or done”; or any “written record of transactions of a public officer in his office, which is a convenient and appropriate method of discharging his duties, and is kept by him as such, whether required by ... law or not.”
Griffis,
¶ 10 Arizona’s broad definitions of a public record are not, however, unlimited— they do not encompass documents of a purely private or personal nature. Id. at 4, ¶ 10,
¶ 11 Consistent with this content-driven inquiry, records and data maintained electronically can be as much a public record as records and data maintained on paper. Indeed, the statutory directive contained in AR.S. § 39-121.01(B), requiring officers and public bodies to maintain all records “reasonably necessary or appropriate to maintain an accurate knowledge of their official activities,” incorporates by reference the definition of records contained in A.R.S. § 41-151.18 (2013). The incorporated definition broadly defines “records” as including not only “papers,” but also “other documentary materials, regardless of physical form or characteristics.” See also Lake v. City of Phoenix (“Lake II”),
¶ 12 Under any of the formulations of a public record discussed above, and based on its content, CHILDS is a public record. DES developed CHILDS in 1996 and 1997 to comply with federal criteria for a statewide automated child welfare system. DES used, and now DCS uses, CHILDS to meet its obligations to maintain all reports of child abuse and neglect. A.R.S. §§ 8-804 (Supp. 2015), - 804.01 (2014). And, as the manager of DCS’s Report and Statistics Unit explained at the evidentiary hearing, DCS uses CHILDS to manage its cases, staff, providers, and provider payroll system. Further, as DCS acknowledged in its briefing on appeal, the “records and information in CHILDS are crucial to [DCS’s] ability to achieve its stated purpose of ‘protecting children’ ” both on a “micro” level, that is, on a day-to-day basis concerning a specific case, and on a “macro” level, that is, in providing “aggregate data about child welfare operations, as opposed to case-specific information.” Based on these uncontested facts, and DCS’s own description of how it uses CHILDS, the electronic records and data in CHILDS makes CHILDS a public record under Arizona law.
II. Electronically Maintained Public Records—A Duty to Search, Not Create
¶ 13 The superior court ruled that Arizona’s public records law did not require an agency to create a public record by “writing] a new software program to obtain the [requested] information,” or by “research[ing] and analyzing] data to compile
¶ 14 Under Arizona’s public records law, an agency is required to search for records upon request. Otherwise, the public has no meaningful right to inspect public records. See A.R.S. § 39-121 (public records and other matters “shall be open to inspection”); A.R.S. § 39-121,01(D)(1) (“Any person may request to examine or be furnished copies, printouts or photographs of any public record during regular office hours or may request that the custodian mail a copy of any public record not otherwise available on the public body’s website to the requesting person.”); Phoenix New Times, L.L.C. v. Arpaio,
¶ 15 When a public employee fills out a form to obtain public records from, for example, a storage or file room, the employee has created a record to retrieve records that already exist. Creating a query to search an electronic database is functionally the same. As amici curiae Goldwater Institute and Arizona Center for Law in the Public Interest explained in them amicus brief: “ ‘[Finding’ a [public] record cannot simultaneously require its ‘creation;’ either a [public] record exists to be found, or it does not.” Thus, although creating or “writing” a search query to find electronically stored public records may create a record, that act does not simultaneously create the public record originally requested. To hold otherwise would, as the ACLU argues on appeal, “functionally place most records maintained in public agency databases outside of the public records law.”
¶ 16 In Lake v. City of Phoenix (“Lake I ”), we explained “a public record that would otherwise be subject to Arizona’s public records law does not become immune from production simply by virtue of the method the City employs to catalogue the document.”
¶ 17 But those obligations do not require DCS to tally or compile previously untallied and un-compiled information or data to respond to a public records request. Cf. Judicial Watch, Inc. v. City of Phoenix,
¶ 19 For example, National Security Counselors v. Central Intelligence Agency recognized that searching a database to respond to a FOIA request did not involve the creation of a new record because the agency would have to use some form of programming to retrieve the information.
[A] request seeking “a database listing of the first 100 FOIA requests filed in Fiscal Year 2012,” may require the creation of a new record because the record being requested ... is not necessarily something “that an agency has in fact chosen to create and retain.” The same would be true of paper, rather than electronic, records. For example, if a FOIA request sought “an inventory of all non-electronic records created in 1962 regarding the Cuban Missile Crisis,” an agency need not create an inventory if one did not already exist, though the agency would need to release any such non-electronic records themselves if they were requested and were not exempt from disclosure. Therefore, a FOIA request for a listing or index of a database’s contents that does not seek the contents of the database, but instead essentially seeks information about those contents, is a request that requires the creation of a new record, insofar as the agency has not previously created and retained such a listing or index.
Id. (internal citations omitted) (emphasis added).
¶20 By analogizing to requests for paper records, the court placed less emphasis on the electronic storage and retrieval, and more emphasis on the end result. Thus, under FOIA, an agency has no legal duty to create a new record that compiles or aggregates information about preexisting records. Id. at 271-272; see also West v. Spellings,
¶ 21 Other federal courts have recognized that requests for information about information, that is, requests for information that has not been previously compiled, are not requests for existing records under FOIA. See, e.g., Jean-Pierre v. Fed. Bureau of Prisons,
¶ 22 Many state courts have also concluded that their public records law does not require a governmental entity to summarize, aggregate, or compile information about preexisting records. See, e.g., Chicago Tribune Co. v. Dep’t of Fin. and Prof'l Regulation,
¶ 23 The superior court correctly recognized the ACLU’s outstanding requests were asking DCS to tally and compile aggregate information contained in CHILDS—information that DCS had not previously tallied and compiled. For example, as the superior court found, to respond to the May 2013 request no. 12, DCS would have had to write a computer program to extract the raw data from CHILDS responsive to the request, and then would have had to determine or calculate the number of children who fell within the various categories identified in the request. Similarly, the superior court found that even though raw data responsive to request no. 18 was in an existing “data file,” DCS would still have had to determine how many children were in out-of-home care during the requested time frames, and analyze that information by length of time in care. Then, for each distribution, it would have had to determine how many placements those children had experienced during the specified time periods, and based on the total number of children in each distribution category, determine the average number of placements for children in those categories.
¶ 24 As the foregoing examples illustrate, the ACLU’s outstanding requests sought information about information—information that DCS had not previously compiled. Arizona’s public records law does not, however, require an agency to create a new record that compiles information about information maintained electronically or, indeed, in paper. We acknowledge that distinguishing between searching an electronic database and creating a new record that compiles previously un-compiled information about information may be a difficult task. But on this record, we agree with the superior court that DCS was not “legally required” to respond to the outstanding requests.
¶25 The ACLU nevertheless argues that even if the outstanding requests required DCS to create new records, Arizona’s public records law required DCS to do so because CHILDS contained confidential information that DCS could not redact.
¶ 26 First, as an initial matter, the record fails to support the ACLU’s assertion that it asked to inspect CHILDS. Instead, the record demonstrates the dispute between the parties concerned the ACLU’s separate requests, and not whether the ACLU could inspect CHILDS. Indeed, at the evidentiary hearing, the superior court asked the ACLU’s counsel about “access to the mainframe.” Instead of informing the court that the ACLU had in fact asked to inspect CHILDS, counsel merely responded, “There certainly are instances in which that happens.”
¶ 27 Second, the wording the ACLU relies on in asserting it asked to inspect CHILDS—“all records ... in accordance with how such information is kept”—did not constitute a request to inspect CHILDS. The outstanding requests asked DCS to tally and compile information in CHILDS that had not been previously tallied or compiled. Thus, DCS had nothing to provide “in accordance with how such information is kept.”
¶ 28 Third, and perhaps most importantly, neither DCS nor the ACLU presented any evidence to the superior court that DCS could not produce CHILDS for inspection because DCS was unable to redact confidential information. Although the superior court and the parties may have generally assumed DCS could not redact confidential information from CHILDS, the record contains no evidence showing this.
¶ 29 As we have previously emphasized, there are no “sweeping exemp-tionfs] from the public records laws of this state,” Judicial Watch, Inc.,
¶ 30 In sum, “public records are presumed open to the public for inspection unless the public official can demonstrate a factual basis why a particular record ought not be disclosed to further an important public or private interest.” Star Publ’g Co.,
III. The Post-Litigation Records
¶ 31 As noted, DES produced records responsive to 14 of the ACLU’s May separate requests between May and October 2013. See supra ¶ 3. And, as also noted, DCS did not acknowledge receipt of the ACLU January 2014 requests until April 28, 2014. See supra ¶ 5. Then, in May and June 2014, after the ACLU filed this case, DCS produced records responsive to 13 of the separate requests contained in the ACLU’s May 2013 and January 2014 requests (“post-litigation records”), which, the superior court found, had not required DCS to create new records.
¶ 32 Although neither our public records statutes nor interpretive case law fixes a timeframe for an agency to produce documents, “prompt” for purposes of our public records law is “being ‘quick to act’ or producing the requested records ‘without delay.’ ” Phoenix New Times,
¶ 33 In evaluating the best interests of the state against any delay in producing the posb-litigation records, the court should consider whether the ACLU’s requests for the post-litigation records posed an “unreasonable administrative burden.” Hodai,
¶ 34 In London v. Broderick,
¶35 This court has also recognized that the burden of producing public records may outweigh the public’s interest in inspecting public records. In Hodai, the superior court refused to order a city to produce all records of communications between its police department and the FBI during a one-year period, finding the request overly broad and burdensome.
¶ 36 Consistent with the foregoing authorities, on remand DCS will bear the burden of showing that the ACLU’s request for the post-litigation documents posed an unreasonable administrative burden. As in London, DCS must “articulate! ] sufficiently weighty reasons to tip the balance away from the presumption of disclosure and toward nondisclosure.”
IV. The ACLU’s Request for an Award of Attorneys’ Fees and Costs
¶ 37 The superior court denied the ACLU’s request for an award of attorneys’ fees and costs under A.R.S. § 39-121.02(B). That statute authorizes a court to award “attorney fees and other legal costs that are reasonably incurred in any action under [the public records statutes] if the person seeking public records has substantially prevailed.” The court found the ACLU had not “substantially prevailed” in the ease. We have, however, ruled, in part, in the ACLU’s favor, and we are remanding to the superior court to determine whether DCS promptly provided the ACLU with the post-litigation documents. In this regard, we note that by statute, if a party does not receive a prompt response to a public record request, “[a]ceess to a public record is deemed denied.” A.R.S. § 39-121.01(E). Given these circumstances, we reverse the superior court’s denial of the ACLU’s request for an award of fees and costs, and on remand direct the superior court to reconsider whether the ACLU has “substantially prevailed” in this case.
V. Attorneys’ Fees and Costs on Appeal
¶38 The ACLU has also requested an award of attorneys’ fees and costs on appeal under A.R.S. § 39-121.02(B). Given the issues
CONCLUSION
¶ 39 For the foregoing reasons, we affirm in part, reverse in part, and remand for further proceedings as instructed in this opinion.
Notes
, By executive order issued on January 13, 2014, then Governor Janice K. Brewer established DCSFS and abolished DCYF.
. We cite to the current version of each statute cited in this opinion.
. The court identified the outstanding requests as follows: “May 6, 2013 Request: Items 9-13, 15-18, 23[;] January 28, 2014 Request: Items 1-23, 26-34[; and] January 31, 2014 Request: Items 1-22, 24.”
. CHILDS contains both confidential and non-confidential information pursuant to A.R.S. § 8-807 (2015).
. In full, the following language preceded the 30 separate requests the ACLU submitted to DES in May 2013: "Please provide any and all records reflecting the following public information for each of the State Fiscal Years ("SFY”) 2011, 2012, and 2013; or for each Semi-Annual Reporting Period, as defined by A.R.S. § 8-526, within each of those SFYs; or for any other period (such as by quarter or by month) within each of those SFYs, in accordance with how such information is kept.”
The language preceding the separate requests in the two January 2014 requests was materially the same. In pertinent part, the January 2014 requests read as follows: "Unless indicated otherwise in any of the individual requests below, please provide any and all records reflecting the following public information ... in accordance with how such information is kept.”
. Specifically, the superior court found that after the ACLU filed this case, DCS produced records responsive to "items 19-21, 22(b) and (c) of the May 2013 request, item 25 of the January 28 request, and item 23 of the January 31 request to the extent that it possessed responsive existing records."
. The ACLU has not challenged on appeal the promptness of DES's production of records in 2013.
