Report Pipeline
Batch Selector:
★
OVERALL BATCH #69 SUMMARY
Start Date
August 4, 2026
Start Time
7:04 PM
End Date
August 4, 2026
End Time
11:35 PM
Duration
4h 30m 44s
Total Reports Added
43
Bookings to Process
43
Database Sync Status
✓ COMPLETE
1
PDF RAW INGEST
Status
📈 Step Execution History
| Metric | Value |
|---|---|
| Total Successes | 0 |
| Total Failures | 0 [0 permanent, 0 transient] |
| Success Rate | 0% |
2
AFFIDAVIT PARAPHRASER
Status
📈 Step Execution History
| Metric | Value |
|---|---|
| Cases Processed | 0 |
| Records Saved | 0 |
3
AFFIDAVIT GROUPER
Status
📈 Step Execution History
| Metric | Value |
|---|---|
| Affidavits Processed | 0 |
| Affidavits Grouped | 0 |
4
REPORT SUMMARIZER
Status
📈 Step Execution History
| Metric | Value |
|---|---|
| Reports Summarized | 0 |
5
PSEUDONYMIZER
Status
📈 Step Execution History
| Metric | Value |
|---|---|
| Bookings Processed | 0 |
6
POLICE REPORT RANKER
Status
📈 Step Execution History
| Metric | Value |
|---|---|
| Reports Evaluated | 0 |
| Successfully Ranked | 0 |
| Failures | 0 |
| Auto-Favorites Assigned | 0 |
| Auto-Voice MP3s Generated | 0 |
7
AUTO-FAVORITES ASSIGNMENT
Status
💡 Step Description
Automatically flags all narrative reports scoring 65 or higher as favorites in the Curation Terminal database.
| Metric | Value |
|---|---|
| Favorites Marked | 0 |
8
AUTO-VOICE MP3 GENERATION
Status
💡 Step Description
Synthesizes neural voice MP3 narrations using AWS Polly and generates custom QR codes linking to those audio files.
| Metric | Value |
|---|---|
| Voice & QRs Generated | 0 |
| Failures | 0 |
Collapsible Raw execution Console Log
[+] EXPAND
FILE: report_pipeline_log.txt
SIZE: 3662 bytes
1=============================================
2=== GOTOJAIL POLICE REPORT PIPELINE START: Mon Aug 31 10:42:05 UTC 2026 ===
3=============================================
4[SOURCE] CRON
5Terminating any running backfill queue workers...
6Cleaning up lingering Chrome background processes for report profile...
7[STEP 1/6] Running PDF Raw Ingest...
8Running in headless mode.
9Processing cases with AFFIDAVIT flags: [0].
10Limiting to 100 cases.
11Executing query:
12
13 SELECT DISTINCT C.PARENT_CASENO AS CASENUMBER, B.BOOKINGDATE
14 FROM CURRENT_BOOKING B
15 JOIN CURRENT_BOOKING_CHARGE BC ON B.ID = BC.BOOKING_ID
16 JOIN CURRENT_CHARGE C ON C.ID = BC.CHARGE_ID
17 WHERE (C.AFFIDAVIT IN ('0', ?)
18
19 )
20
21 AND B.BOOKING_FOUND = 1
22 AND (
23 (
24 B.BATCH_ID IN (
25 SELECT BATCH_ID FROM BATCH_PIPELINE_BOOKING_LOG WHERE DATE = ?
26 )
27 AND B.STATUS NOT LIKE '%RELEASED%'
28 )
29 OR
30 (
31 B.STATUS NOT LIKE '%RELEASED%'
32 AND B.PROJ_RELEASEDATE IS NOT NULL
33 AND B.PROJ_RELEASEDATE != 'N/A'
34 AND B.PROJ_RELEASEDATE != ''
35 AND SUBSTR(B.PROJ_RELEASEDATE, 1, 10) >= ?
36 AND SUBSTR(B.PROJ_RELEASEDATE, 1, 10) <= ?
37 )
38 )
39
40 AND B.ID NOT IN (
41 SELECT BOOKING_ID FROM CURATION_IGNORE
42 )
43 AND B.ID NOT IN (
44 SELECT DISTINCT b2.ID
45 FROM CURRENT_BOOKING b2
46 JOIN CURRENT_BOOKING_CHARGE bc2 ON b2.ID = bc2.BOOKING_ID
47 JOIN CURRENT_CHARGE c2 ON bc2.CHARGE_ID = c2.ID
48 JOIN LOOKUP_IGNORE_PATTERN p2 ON c2.CHARGE LIKE p2.PATTERN
49 LEFT JOIN CURATION_ALLOW a2 ON b2.ID = a2.BOOKING_ID
50 WHERE a2.BOOKING_ID IS NULL
51 )
52
53 ORDER BY B.BOOKINGDATE DESC
54
55NO ROWS TO PROCESS
56
57Run next: police_report_paraphrase.py
58[STEP 2/6] Running Affidavit Paraphraser...
59Starting to fetch affidavit data...
60Connecting to the database to fetch affidavit data...
61Fetched 0 records.
62No affidavit data found. Exiting script.
63[STEP 3/6] Running Affidavit Grouper...
64No affidavits to group.
65Run next: police_report_shrink.py
66
67[STEP 4/6] Running Police Report Summarizer...
68Executing query to fetch records...
69Total records fetched: 0
70All records have been processed and inserted into POLICE_REPORT_SHRUNK.
71Run next: police_report_appearance.py
72
73[STEP 5/6] Running Police Report Pseudonymizer...
74Running incrementally (only processing reports that have not been scrubbed yet)...
75Loaded 0 bookings for advanced name scrubbing...
76Starting parallel name & PII scrubbing with 30 threads...
77Inserting fully scrubbed records into POLICE_REPORT_SCRUBBED...
78POLICE_REPORT_SCRUBBED table has been populated successfully!
79[STEP 6/6] Running Police Report Ranker...
80No batch ID found in BATCH_PIPELINE_REPORT_LOG and no batch ID specified.
81Falling back to ranking all unranked reports.
82Total records to rank: 0
83
84Successfully ranked: 0
85Failed to rank: 0
86Sending Report Pipeline report...
87Report email sent successfully to entbrady@gmail.com, royjbrady@icloud.com for Police Report Ingestion Pipeline Run.
88=============================================
89=== GOTOJAIL POLICE REPORT PIPELINE END: Mon Aug 31 10:42:19 UTC 2026 ===
90=============================================
91