Download improvements
Agency CSV downloads have also been substantially overhauled. Previously, downloads ran the same query used to power the search UI — including a per-row computation of hourly search counts and an activity index score, neither of which appear in the CSV. Stripping those out means downloads now run significantly faster, particularly for agencies with large record sets.
For most downloads, the record cap has been raised from 10,000 to 100,000 records per download.
Downloads now use the browser’s native download manager rather than loading the entire file in the browser before saving. The file begins downloading immediately — you can see it in your download bar and navigate away from the page while it completes.
Two fields were removed, because they were computationally expensive and I don’t think widely-used:
- hourly_count — the count of searches from the same officer in the same hour as each record (used to compute the SAI score)
- sai_score — the Search Activity Index score, a per-record anomaly indicator derived from hourly_count
Redaction fixes
CSV downloads from agency audit views previously included Flock’s redaction sentinel values as
literal strings — REDACTED, ***, and their corresponding license plate hashes (b68919af,
596f4162). These values indicate that Flock redacted a field
directly in the audit log; they carry no analytical meaning. Fields containing these sentinels are
now left blank in downloaded CSVs.
This applies across all columns: name, license_plate_hash, case_number, text_prompt, and any
other field where Flock has indicated the original value was withheld.
Downloads also include a redactions column containing a JSON object with per-field redaction
flags. The agency_license_plate flag is now set when the license plate hash is a redaction
sentinel, in addition to when it is absent entirely.
This is separate from haveibeenflocked.com’s PII redaction of the reason field, which is unchanged
— see the privacy and data redaction page for details on that process.
As always, reach out to humans@haveibeenflocked.com with any questions or concerns.