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/112_Gas-Station.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

184 lines
7.5 KiB
Plaintext
Raw Permalink Blame History

================================================================================================
CASE 112 | Gas Station | January 16, 2022 | USA
================================================================================================
DATABASE RECORD
id 112
date January 16, 2022
original_date January 16, 2022
year 2022
month 1
quarter 2022-Q1
victim Gas Station
location Memphis, Tennessee
country USA
scenario Armed Robbery in Public Space
description Suspects smash gas station with truck, steal Bitcoin ATM
kidnappings 0
violence_torture 0
drugs_alcohol 0
weapons 0
theft 1
life_taken 0
money_wanted (null)
coin_type (null)
reports Fox
notes drove truck into gas station, steal a bitcoin ATM
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:** Gas Station
**Attackers:** Unknown number of perpetrators
**Attack Method:** Armed Robbery in Public Space
**Violence Used:** Threats/intimidation
**Crypto Stolen:** Amount not disclosed
**Status:** Investigation ongoing
LINKED SOURCES
[url] https://www.fox13memphis.com/news/thieves-use-truck-to-smash-into-business-steal-atm-police-say/article_b386fe79-227f-51e2-b347-fa32345d7f76.html
NOTES ON THIS FILE
* matched to sheet row 113: exact match on victim + year, unique on both sides
------------------------------------------------------------------------------------------------
ARTICLE 1
Source Fox
URL https://www.fox13memphis.com/news/thieves-use-truck-to-smash-into-business-steal-atm-police-say/article_b386fe79-227f-51e2-b347-fa32345d7f76.html
Origin reported_K&R sheet, row 113, column "Articles"
Length 838 chars
------------------------------------------------------------------------------------------------
Thieves use truck to smash into business & steal ATM, police say
FOX13 Memphis News Staff Jan 17, 2022
Memphis police released video of thieves who used a truck to smash the front doors of a gas station convenience store and haul away an ATM.
The theft happened Sunday at the Mobil Gas Station on Macon Road near Sycamore View.
MPD said officers were dispatched to an alarm call at the business. When they got to the location, officers saw that the front doors were smashed and the bitcoin ATM had been taken.
Surveillance video shows two people watching as a grey 2004-2008 Ford F-150 backs into the store's front doors. One suspect goes into the business while another lowers the truck's tailgate. A third suspect gets out of the truck, and all three can be seen carrying the ATM out of the store and putting it in the truck bed.
------------------------------------------------------------------------------------------------
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 fox13memphis.com
URL https://www.fox13memphis.com/news/thieves-use-truck-to-smash-into-business-steal-atm-police-say/article_b386fe79-227f-51e2-b347-fa32345d7f76.html
Field url
Retrieved 2026-09-05T12:52:48+00:00 via raw HTTP retrieval, deterministic extraction (HTTP 200)
Language unknown
Kept paragraphs headline [0] + 5-28 excl [25, 26] of 55
Length 2,812 chars
Integrity sha256 1e46725e68e80214c6bba9cb8635ed5f2ee82db0ee1c1a7a5ba5658cabe5b2da
Trimmed AUTO-TRIMMED, unreviewed: kept paragraphs 5-28 plus headline [0]; dropped 4 leading and 26 trailing paragraphs and 2 interior furniture line(s). Case-term hits on page: 13.
Caveat retrieved from a live page on the date above. Unlike text copied
from the spreadsheet, there is no second copy to hash it against.
------------------------------------------------------------------------------------------------
ORIGINAL (unknown, verbatim as retrieved)
Thieves use truck to smash into business & steal ATM, police say | News | fox13memphis.com
You have permission to edit this article.
Thieves use truck to smash into business & steal ATM, police say
Memphis police released video of thieves who used a truck to smash the front doors of a gas station convenience store and haul away an ATM.
The theft happened Sunday at the Mobil Gas Station on Macon Road near Sycamore View.
MPD said officers were dispatched to an alarm call at the business. When they got to the location, officers saw that the front doors were smashed and the bitcoin ATM had been taken.
Surveillance video shows two people watching as a grey 2004-2008 Ford F-150 backs into the store's front doors. One suspect goes into the business while another lowers the truck's tailgate. A third suspect gets out of the truck, and all three can be seen carrying the ATM out of the store and putting it in the truck bed.
Investigators need your help in identifying the individuals responsible.
Anyone with information about this incident should call Crime Stoppers at 528-CASH.
Get email notifications on {{subject}} daily!
Your notification has been saved.
There was a problem saving your notification.
Email notifications are only sent once a day, and only if there are new matching items.
Metal Museum cuts ribbon on new home in Overton Park
The Metal Museum will officially open its new home at the former Memphis College of Art campus Saturday. Read MoreMetal Museum cuts ribbon on new home in Overton Park
Riverside Drive to close overnight on weekends in effort to improve downtown safety, city says
MEMPHIS, Tenn. - Riverside Drive will close overnight on weekends as part of an effort to improve downtown safety, city officials said. Read MoreRiverside Drive to close overnight on weekends in effort to improve downtown safety, city says
4 men sentenced for selling guns at Memphis hotel, officials say
Four men were sentenced to federal prison for selling guns in the parking lot of a Memphis hotel, the U.S. Attorney's Office for the Western District of Tennessee said. Read More4 men sentenced for selling guns at Memphis hotel, officials say
Orpheum to honor Dolly Parton with free '9 to 5' screenings
The Orpheum Theatre Group will honor the late Dolly Parton with four free screenings of "9 to 5" on Dolly Day. Read MoreOrpheum to honor Dolly Parton with free '9 to 5' screenings
Extreme heat can affect major organs, even for people accustomed to Mid-South summers
After months of high temperatures, people living in the Mid-South may feel like their bodies have gotten used to the heat. Read MoreExtreme heat can affect major organs, even for people accustomed to Mid-South summers
================================================================================================
generated from attacks-export-Gart-website.json + reported_K&R | case 112
================================================================================================
Reference in New Issue View Git Blame Copy Permalink