Sofia/DB-cleanup
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Activity
Files
fetch-sheet-only-sources
DB-cleanup/merge-output/sources/110_2-unidentified-males.txt
T
StellarCrowandClaude Fable 5.1 439e83a4cb feat(sources): Wayback pass, automatic trimming, detention rule, ten cases re-sourced 
Second and third rounds on the dossier pipeline, reviewed locally before commit.

Retrieval
- wayback_pass.py: retries every BLOCKED/DEAD/THIN/ERROR linked source through
  the Wayback Machine; blocks carry the snapshot date, archive URL and the live
  verdict. 143 slots retried: 93 fetched, 37 no snapshot, 12 script shells, 1 PDF.
- fetch_sources.py: fetch_wayback() helper.
- add_extra_sources.py: files staged extra_* finds (web search, not on the DB
  record) into the store with a provenance note.
- Cases re-sourced by web search: 248 (Oslo: Document.no, Avisa Oslo, NRK; the
  linked Le Parisien piece is case 242 and is marked OFF-CASE), 258 Kharkiv,
  260 Singapore, 358 Bangkok, 365 Las Vegas, 388 Verneuil-sur-Seine, 390 Zoersel,
  430 Homestead. 341 of 364 cases now hold a fetched article; 11, 66 and 399
  have no public text source (podcast, police video, direct victim report).

Trimming
- auto_trim.py: case-anchored furniture cut for UNTRIMMED blocks. Finds the body
  run that mentions the case, merges across subheadings and short furniture
  gaps, drops teasers, share bars, date/URL/caption lines and subscription
  pitches; refuses pages with no record term or almost no body. 302 blocks
  trimmed; 16 left on auto-trim-review.md (7 OFF-CASE suspects). Every cut is
  labelled AUTO-TRIMMED, UNREVIEWED in the dossier; the full extract stays in
  staging/. Decisions with anchors in trim-decisions-auto.json.
- build_cases.py / verify_all.py: banners for auto-trimmed and archived blocks,
  staged-file check extended to Wayback blocks, flag legend under the record.

Detention rule
- README "Definitions": the DB field `kidnappings` is the DETENTION violence
  type (victim, guard, staff or relative held to force submission or execute
  the theft), distinct from the Kidnapping scenario (taken away and held).
- detention-flag-review.md / detention-flag-corrections.json: 40 records
  reviewed with evidence; 30 set-to-1 proposals accepted by the owner on
  2026-09-06 (listed in corrections-approved.md), 10 still open.
- apply_detention_wording.py: "Violence Used" in the 70 reviewed summaries now
  names detention explicitly (62 of 70 labelled), supported by the summary's
  own text; idempotent; supersedes the batch scripts' wording.

Worklist and docs
- sofia-worklist.md: 248 decisions, detention rule item replacing the old
  "no abduction" item, fresh-search section for the textless cases.
- README-START-HERE.md: progress notes, run commands, next steps.
- Bug fixed in passing: Wayback blocks stored in-memory text with carriage
  returns; now stored as read back from disk.

verify_all.py PASSES (2321 checks).

Co-Authored-By: Claude Fable 5.1 <noreply@anthropic.com>
Claude-Session: https://claude.ai/code/session_01GZZENdTLzNGsbNy4DyF1yt
2026-09-06 19:36:45 +02:00

120 lines
8.1 KiB
Plaintext
Raw Permalink Blame History

================================================================================================
CASE 110 | 2 unidentified males | December 27, 2021 | Canada
================================================================================================
DATABASE RECORD
id 110
date December 27, 2021
original_date December 27, 2021
year 2021
month 12
quarter 2021-Q4
victim 2 unidentified males
location Thunder Bay, Ontario, Canada
country Canada
scenario Kidnapping
description 11 Inmates take 2 inmates hostage, force them to transfer cryptocurrency
kidnappings 1
violence_torture 1
drugs_alcohol 0
weapons 0
theft 1
life_taken 0
money_wanted unknown
coin_type (null)
reports ThunderBayPolice
notes 11 inmates hold 2 other for 30 hours in a cell until they make phonecalls to transfer crypto to them
has_processed_date 1
created_at 2025-11-13 05:44:45
(flag legend: 'kidnappings' is the DETENTION flag — 1 when the victim was held against
their will at any point, tied, locked in, held at gunpoint or taken away; it is NOT the
same as the 'Kidnapping' scenario, which means taken away and held. See README, Definitions.)
AI SUMMARY [generated at bulk import, NOT verified against sources]
**Victim:** 2 unidentified males
**Attackers:** Unknown number of perpetrators
**Attack Method:** Kidnapping for ransom
**Violence Used:** Physical violence
**Crypto Stolen:** unknown
**Status:** Investigation ongoing
LINKED SOURCES
[url] https://www.thunderbaypolice.ca/news/eleven-inmates-charges-following-serious-30-hour-assault-and-extortion-incident
NOTES ON THIS FILE
* matched to sheet row 111: exact match on victim + year, unique on both sides
------------------------------------------------------------------------------------------------
ARTICLE 1
Source ThunderBayPolice
URL https://www.thunderbaypolice.ca/news/eleven-inmates-charges-following-serious-30-hour-assault-and-extortion-incident
Origin reported_K&R sheet, row 111, column "Articles"
Length 2,022 chars
------------------------------------------------------------------------------------------------
Eleven inmates charges following serious 30-hour assault and extortion incident
Police have filed a total of 137 charges against 11 inmates at the Thunder Bay District jail following a recent investigation into a violence incident that occurred at the facility.
Thunder Bay Police Service officers with the Uniform Patrol Branch were initially dispatched to the District Jail just before 8:30 a.m. on Wednesday, Dec. 29 following reports of a serious inmate-on-inmate assault.
Police learned that on Monday, Dec. 27, two male victims were forced into cells and not allowed to leave by 11 male suspects. The victims were repeatedly assaulted by the accused individuals while in the cells.
Between the assaults, and while still being held captive, the victims were allegedly forced to make phone calls to transfer crypto currency from accounts they had access to the accounts of the accused.
In the morning hours of Tuesday, Dec. 28, further assaults occurred while the victims were still being held captive. Correctional Officers were able to separate the involved parties during one of these incidents.
Victims were transported to the Thunder Bay Regional Health Sciences Centre for further evaluation of their injuries.
The investigation found the victims had been held captive for about 30 hours. Further investigation led police to identify 11 accused inmates.
Accused persons facing charges include one Thunder Bay male, one Timmins male, and nine other males from the Greater Toronto Area. Ages of the accused range from 18-to-32 years old. The Thunder Bay Police Service only identifies an accused after charges have been sworn before the courts.
Charges being filed include multiple counts of Assault Causing Bodily Harm, Forcible Confinement, Kidnapping, Extortion, Intimidation Using Violence, Obstruct Peace Officer, and Failure to Comply with Sentence.
The suspects will remain in custody and will be provided with future court appearance dates for the new charges they face.
The investigation remains ongoing.
------------------------------------------------------------------------------------------------
FETCHED ARTICLE 1 [AUTO-TRIMMED — UNREVIEWED]
!! Furniture was cut by a script keyed on this case's record, not by a person.
!! It may still carry passages about OTHER cases from a round-up article.
!! The full page extract is kept in staging/ if a cut needs revisiting.
Source thunderbaypolice.ca
URL https://www.thunderbaypolice.ca/news/eleven-inmates-charges-following-serious-30-hour-assault-and-extortion-incident
Field url
Retrieved 2026-09-05T13:30:39+00:00 via Wayback Machine snapshot 20250121171231, deterministic extraction (HTTP None)
Language unknown
Kept paragraphs headline [0] + 2-11 of 13
Length 2,009 chars
Integrity sha256 94257a14938d5100b793fdb3980d4bf802cc7c0a16e215a3751072ebc2bc52b5
Trimmed AUTO-TRIMMED, unreviewed: kept paragraphs 2-11 plus headline [0]; dropped 1 leading and 1 trailing paragraphs. Case-term hits on page: 11.
Note live URL was DEAD on the first pass; text comes from an archived copy dated 2025-01-21
Archive http://web.archive.org/web/20250121171231/https://www.thunderbaypolice.ca/news/eleven-inmates-charges-following-serious-30-hour-assault-and-extortion-incident
Caveat retrieved from a Wayback Machine snapshot, not the live page. The
snapshot date is in the method line; the live URL was unreadable.
------------------------------------------------------------------------------------------------
ORIGINAL (unknown, verbatim as retrieved)
Eleven inmates charges following serious 30-hour assault and extortion incident | Thunderbay
Police have filed a total of 137 charges against 11 inmates at the Thunder Bay District jail following a recent investigation into a violence incident that occurred at the facility.
Thunder Bay Police Service officers with the Uniform Patrol Branch were initially dispatched to the District Jail just before 8:30 a.m. on Wednesday, Dec. 29 following reports of a serious inmate-on-inmate assault.
Police learned that on Monday, Dec. 27, two male victims were forced into cells and not allowed to leave by 11 male suspects. The victims were repeatedly assaulted by the accused individuals while in the cells.
Between the assaults, and while still being held captive, the victims were allegedly forced to make phone calls to transfer crypto currency from accounts they had access to the accounts of the accused.
In the morning hours of Tuesday, Dec. 28, further assaults occurred while the victims were still being held captive. Correctional Officers were able to separate the involved parties during one of these incidents.
Victims were transported to the Thunder Bay Regional Health Sciences Centre for further evaluation of their injuries.
The investigation found the victims had been held captive for about 30 hours. Further investigation led police to identify 11 accused inmates.
Accused persons facing charges include one Thunder Bay male, one Timmins male, and nine other males from the Greater Toronto Area. Ages of the accused range from 18-to-32 years old. The Thunder Bay Police Service only identifies an accused after charges have been sworn before the courts.
Charges being filed include multiple counts of Assault Causing Bodily Harm, Forcible Confinement, Kidnapping, Extortion, Intimidation Using Violence, Obstruct Peace Officer, and Failure to Comply with Sentence.
The suspects will remain in custody and will be provided with future court appearance dates for the new charges they face.
================================================================================================
generated from attacks-export-Gart-website.json + reported_K&R | case 110
================================================================================================
Reference in New Issue View Git Blame Copy Permalink