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/461_Male-49-and-female-46.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

95 lines
7.0 KiB
Plaintext
Raw Permalink Blame History

This file contains ambiguous Unicode characters
This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.
================================================================================================
CASE 461 | Male (49) and female (46) | June 29, 2026 | USA
================================================================================================
DATABASE RECORD
id 461
date June 29, 2026
original_date June 29, 2026
year 2026
month 6
quarter 2026-Q2
victim Male (49) and female (46)
location Forest Hills, Queens, New York City
country USA
scenario Dodged Attack
description Three armed individuals approached a man (49) and a woman (46) near the corner of 70 Road and 110 Street in Forest Hills and demanded a "cryptocurrency ledger"
kidnappings 0
violence_torture 0
drugs_alcohol 0
weapons 1
theft 0
life_taken 0
money_wanted Crypto
coin_type Crypto
reports NYPD Crime Stoppers
notes The suspects fled on foot without taking any property. NYPD Crime Stoppers issued a wanted bulletin on July 9 with still images of the three persons of interest; no arrests made.
has_processed_date 0
created_at 2026-07-15 17:46:07
(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]
**Victims:** Male (49) and female (46). Names not disclosed. Uninjured.
**Attackers:** Three unidentified individuals. Armed. Fled on foot empty-handed. Identity, age, and nationality not disclosed. Still photos released by NYPD Crime Stoppers July 9, 2026.
**Attack Method:** Confronted both victims on the street at 70 Road and 110 Street at approximately 8:15 PM. Demanded a "cryptocurrency ledger" (hardware wallet device) at gunpoint. Fled when unable to complete the robbery.
**Violence Used:** Firearms presented during confrontation. No physical assault. Victims unharmed.
**Crypto Demanded/Stolen:** Hardware wallet (Ledger device) demanded. €0 obtained. Suspects fled empty-handed.
**Status:** NYPD 112 Precinct investigating. Crime Stoppers wanted bulletin issued July 9, 2026 with photos of three suspects. Up to $3,500 reward offered. Public asked to review security footage from June 29 along 70 Road and 110 Street. No arrests as of July 9.
LINKED SOURCES
[url] https://x.com/NYPDTips/status/2075022065812336954
[url_2] https://hoodline.com/2026/07/forest-hills-crypto-heist-flops-as-armed-trio-botches-ledger-grab-cops-say/
OTHER LINKED SOURCES
[NOT AN ARTICLE] url NYPD Tips (X) — police wanted-bulletin post; recorded as a source, not transcribed
https://x.com/NYPDTips/status/2075022065812336954
------------------------------------------------------------------------------------------------
FETCHED ARTICLE 1
Source Hoodline
URL https://hoodline.com/2026/07/forest-hills-crypto-heist-flops-as-armed-trio-botches-ledger-grab-cops-say/
Field url_2
Retrieved 2026-07-31T14:13:46+00:00 via raw HTTP retrieval, deterministic extraction (HTTP 200)
Language en
Kept paragraphs headline [0] + 6-14 of 31
Length 2,874 chars
Integrity sha256 0e3f14338fcdcc19971c5203cf0c5982863e664ed72fc6236b4be08c0db68fb1
Trimmed dropped city-nav lists at the head and 16 unrelated local teasers
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 (en, verbatim as retrieved)
Forest Hills Crypto Heist Flops As Armed Trio Botches Ledger Grab,
An attempted stickup over a so-called "cryptocurrency ledger" rattled a Forest Hills corner on June 29, when three armed men approached a 49-year-old man and a 46-year-old woman near 70 Road and 110 Street at about 8:15 p.m., according to police. The suspects demanded the device, but fled on foot without taking any property, and investigators are now asking neighbors to comb through any security footage from that evening.
🚨 WANTED FOR AN ATTEMPTED ROBBERY: On Monday, June 29, 2026, at approximately 8:15 P.M., in the vicinity of 70 Road and 110 Street, in the confines of the 112 Precinct in Queens, three unidentified individuals approached a 49-year-old male and a 46-year-old female. The three… pic.twitter.com/8wyIhCegXc
— NYPD Crime Stoppers (@NYPDTips) July 9, 2026
The city’s Crime Stoppers account posted a wanted bulletin on July 9 describing the June 29 confrontation, stating the suspects were armed and demanded a "cryptocurrency ledger." Investigators included still photos of the three people of interest and said the attackers ultimately walked away empty-handed, without getting any of the victims' property. The alert urges anyone with information or video from that time frame to come forward, according to NYPD Crime Stoppers.
Crime Stoppers is offering up to $3,500 for information that leads to an arrest and indictment, and says tipsters can remain anonymous. People can call 1-800-577-TIPS (8477) or, for Spanish speakers, 1-888-57-PISTA (74782), or send an online tip through the NYPD’s Crime Stoppers portal. The program, administered by the New York City Police Foundation, does not require callers to identify themselves, according to NYPD Crime Stoppers.
Part Of A Growing Pattern Of Crypto-Targeted Crimes
Crimes that target physical access to cryptocurrency, often called "wrench attacks," have climbed in recent years, with security firms documenting more violent attempts to force victims into surrendering wallets or private keys. Experts say 2025 marked a notable spike in such coercion cases, prompting calls for multisig setups and tighter operational security. The phenomenon has become an escalating concern, according to CertiK.
Police are asking residents and businesses along 70 Road and 110 Street to review doorbell, building and dash‑camera footage from the night of June 29 and to share anything that might show the trio or their movements. No arrests have been announced and detectives say the investigation remains active, according to NYPD Crime Stoppers.
Anyone with relevant information can also contact their local precinct; tipsters whose information leads to an arrest and indictment may be eligible for a reward, according to NYPD Crime Stoppers. Investigators say they continue to review footage and follow up on leads from the community.
================================================================================================
generated from attacks-export-Gart-website.json + reported_K&R | case 461
================================================================================================
Reference in New Issue View Git Blame Copy Permalink