JUAREZ POLICE CAD ARCHIVE
Educational Research Edition - September 16, 2026

DISCOVERY AND CREDITS

Discovered, operated, and provided for research by Ringmaster.
Research organization: ODINT
Full name: Observatory for Digital Infrastructure & Network Transparency
Status: U.S. 501(c)(3) nonprofit public charity
Website: https://odint.io
Research findings and contact: ringmast4r@gmail.com

Commercial contracting: Net Works Lab LLC (for-profit)
Website: https://net-works-lab.com

Ringmaster is the operator who found this data source and contributed the
collected material for preservation and educational research.

OVERVIEW AND RESEARCH INVITATION

This archive preserves captured Juarez police computer-aided dispatch (CAD)
incident records, along with saved data exports and collection logs. CAD systems
record information used to manage calls and dispatch responses. This collection
offers material for learning about data analysis, public-safety operations,
historical trends, and the challenges of preserving a changing data source.

Please explore the data for educational research. Possible starting points
include changes in incident categories over time, patterns by hour or day,
geographic patterns where location fields are available, and gaps, duplicates,
or inconsistencies in the records. Check what each field represents before
drawing conclusions; incident records alone do not establish a case's outcome.

Find something interesting? Please credit and tag Ringmaster when sharing your
research, and email ringmast4r@gmail.com with your findings. Include a short
description, the date range you examined, and the query or method you used so
the result can be understood and reproduced.

For contracting opportunities, contact Ringmaster through Net Works Lab LLC
at https://net-works-lab.com, or email ringmast4r@gmail.com and mention your
project. Net Works Lab LLC is the separate for-profit business; ODINT is the
nonprofit research organization.

WHAT IS INCLUDED AND HOW FAR IT GOES BACK

Unique archived incident keys: 7,976,709
Oldest recorded incident date (UTC): January 22, 2019, 10:37:20
Newest recorded incident date (UTC): September 15, 2026, 06:58:07
Latest included capture poll (UTC): September 16, 2026, 04:54:06.546064
Earliest recorded first-seen capture (UTC): July 8, 2026
Historical backfill marked complete by the collector: Yes

The incident dates describe the source records. The capture dates describe
when the collector observed them. Historical backfill brought in older records,
so the collection reaches back to 2019 even though capture began in 2026.

The main incidents table holds 7,976,709 unique incident keys. Separate archive_*
tables preserve 784,286 saved CAD feature rows, 22,301 historical poll records,
and source metadata. These supplemental rows are not extra unique incidents.

WHAT THE ARCHIVE AUDIT FOUND

The archive contains 84,307 more unique incident keys than the inspected July
copy. Discovered readable backups, a recovered damaged July database, and
identifiable saved CAD exports were compared with the accumulated archive.
Those older sources contained no additional incident IDs missing from it.

The inspected collector keeps captured incident keys and has no incident
deletion or age cutoff. It updates the current row when an incident is seen
again; it does not preserve every intermediate version of that row. Local
archive consolidation also retains previously saved incidents if they are
absent from a new server snapshot.

The audit did not establish whether the upstream service deletes older
incidents. The date range and backfill marker do not prove that every incident
ever created by the source is present. See ARCHIVE_AUDIT.json for the detailed
comparisons and recovery results.

HOW TO OPEN THE DATABASE

1. Copy juarez_cad_capture.zip from the DVD to your computer.
2. Extract the ZIP. Allow at least 38 GB free for the extracted database,
   in addition to space for the ZIP and any research working files.
3. Open the extracted .db file with a SQLite-compatible application.

The disc contains a ZIP with the database inside it. The ISO is the disc image
used to create this DVD. You do not need the ISO to open the database.

INTEGRITY AND SUPPORTING FILES

The database integrity check passed, and the full database extraction checksum
matched the verified archive. verification.json contains validation details;
ARCHIVE_README.md and ARCHIVE_AUDIT.json provide supporting archive notes.

Database SHA-256:
02045f609aa99715d04a4ce593975d9abf6fd4010e1b584254077aed51f30e09