# Jonesboro PD JPD-2026-851 Section 2 — Production Overview One file, `Real Time Intelligence Report.xlsx` (625,365 bytes), emailed 2026-07-24 at 15:52 CDT by **Sally Smith** through the City's JustFOIA relay. The transmittal in full: > "The attached spreadsheet is in response to item two of your request. This log is kept by the Real Time Crime Center and dates back to December 2023, when it was first created. Please advise if you have questions about the provided material. **Section number two is considered complete.**" Integrity record: `_phase0_workdir/jonesboro-851-s2-manifest-2026-07-24.md`. ## What arrived A single workbook of 31 monthly worksheets covering **December 2023 through June 2026**, **5,201 data rows**. See [[Jonesboro RTCC Camera Pull Log 2023-2026]]. ## Key takeaways 1. **The corpus's first case-level camera-use record.** Every other production has supplied inventories, contracts, policies, or statutory aggregates. This one records the individual pull: which cameras were checked for which case, and what came of it. 2. **Evidence was found in roughly 83%** of pulls with a recorded outcome (3,956 of 4,767), while **an arrest is associated with about 8%** where that field is populated (136 of 1,663). 3. **About 85% of pulls are internal investigative work**, not records-request fulfilment — only 694 of 4,777 carry the FOIA flag. 4. **Traffic matters outnumber criminal ones roughly 4.7 to one** (1,339 against 284). 5. **Flock appears 152 times as a pull source**, logged alongside City intersection cameras without distinction. The plate-reader network functions as one more camera an analyst checks. 6. **The log was rebuilt three times** — two different Microsoft Forms instruments and then a manual table — so fields appear and disappear across the period and every figure carries its own denominator. 7. **An express completeness statement.** "Section number two is considered complete" is a per-category disposition volunteered without being asked, which is uncommon in this corpus ([[The Disposition Is the Record]]). ## Safety and handling Defender clean. The workbook contains **no macros, no external-link parts, no OLE objects, and zero formula elements** — it is entirely static values. Its 91 external hyperlinks all resolve to the bare root `http://evidence.com/`. A raw byte scan flagged a `DDE` token that proved to be part of a GUID rather than a formula. Published in **aggregate only** on Joshua's direction. The log carries 4,387 free-text note entries (216 referencing victim or suspect, 85 referencing a plate or tag, 5 containing a street address), row-level case numbers, and 307 distinct officer-name values. None of that is republished; the full extraction stays in the immutable corpus. ## People and orgs [[Jonesboro Police Department]] · [[Real-Time Crime Center (RTCC)]] · [[Flock Safety, Inc.]] · [[Axon Enterprise, Inc.]] ## Open questions / follow-ups - Sections 3 and beyond of `JPD-2026-851`, which remain outstanding. - Whether the Department retains the two earlier Microsoft Forms datasets separately. - The Flock platform's own audit export, distinct from these analyst-recorded entries.