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/215_30-y-o-Chinese-Man.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

148 lines
8.0 KiB
Plaintext
Raw Permalink Blame History

================================================================================================
CASE 215 | 30 y/o Chinese Man | February 24, 2025 | South Korea
================================================================================================
DATABASE RECORD
id 215
date February 24, 2025
original_date February 24, 2025
year 2025
month 2
quarter 2025-Q1
victim 30 y/o Chinese Man
location Jeju City, South Korea
country South Korea
scenario P2P Trade Gone Wrong
description 4 Chinese suspects stab man lured to perform a trade in hotel room, steal 85 million won.
kidnappings 1
violence_torture 1
drugs_alcohol 0
weapons 1
theft 1
life_taken 1
money_wanted 85M won
coin_type cash
reports YNA
notes Chinese murdered during p2p trade in a hotel
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:** 30 y/o Chinese Man
**Attackers:** Unknown number of perpetrators
**Attack Method:** P2P Trade Gone Wrong - victim kidnapped
**Violence Used:** Murder/homicide
**Crypto Stolen:** 85M won in cash
**Status:** Victim deceased; investigation ongoing
LINKED SOURCES
[url] https://www.yna.co.kr/view/AKR20250225097600056
NOTES ON THIS FILE
* matched to sheet row 216: exact match on victim + year, unique on both sides
------------------------------------------------------------------------------------------------
ARTICLE 1
Source YNA
URL https://www.yna.co.kr/view/AKR20250225097600056
Origin reported_K&R sheet, row 216, column "Articles"
Length 2,210 chars
------------------------------------------------------------------------------------------------
Murder of Chinese Man at Jeju Hotel... Suspected to Have Occurred During Cryptocurrency Transaction
Reported by Song Go, February 25, 2025, 1:29 PM
Summary
By Bong Ji Cheol, Bong Ji Cheol Reporter
The Jeju West Police Station is investigating four Chinese suspects in connection with the murder of a Chinese man at a hotel in Jeju.
[Photo credit: Yonhap News]
(Jeju = Yonhap News) Bong Ji Cheol Reporter - The murder of a Chinese man at a hotel in Jeju City is suspected to have occurred during a cryptocurrency exchange transaction, and the police are investigating.
The Jeju West Police Station announced on the 25th that they are investigating four Chinese individuals, including two women in their 30s, one man in his 30s, and one man in his 60s, on suspicion of murder.
These individuals are accused of killing a 30-year-old Chinese man, Mr. A, in a suite at a luxury hotel in Jeju City on the afternoon of the 24th. Mr. A was discovered by the police at around 5:10 PM after a friend's report.
The friend reported to 112 that "a friend who went to buy cryptocurrency is not responding, which is unusual, and something might be wrong."
When the police arrived, Mr. A was found dead, having been stabbed multiple times with a weapon and bleeding profusely.
Five minutes after the report, at 5:15 PM, one of the suspects, a 30-year-old woman, surrendered herself at the Seongsan Police Station in Seogwipo, Jeju.
Subsequently, two Chinese accomplices, a man and a woman in their 30s, were arrested at Jeju International Airport while attempting to leave the country, and a 60-year-old Chinese man was urgently detained at the hotel casino.
The police have confirmed that these four suspects fled with 85 million won (approximately $70,000 USD) belonging to the victim, Mr. A, and are investigating the exact motive and circumstances of the crime.
The police believe that the 30-year-old Chinese woman who surrendered may be the mastermind and are considering all possibilities, including whether the crime occurred during a cryptocurrency exchange transaction, based on the suspects' statements.
All of the suspects entered Jeju on tourist visas and are not illegally residing in the country.
------------------------------------------------------------------------------------------------
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 yna.co.kr
URL https://www.yna.co.kr/view/AKR20250225097600056
Field url
Retrieved 2026-09-05T12:48:29+00:00 via raw HTTP retrieval, deterministic extraction (HTTP 200)
Language unknown
Kept paragraphs 0-15 of 18
Length 989 chars
Integrity sha256 0c961ef268ebfe338c7d6850b7e76e67c445d9e31ea4f7e4c379f831e8644097
Trimmed AUTO-TRIMMED, unreviewed: kept paragraphs 0-15; dropped 0 leading and 2 trailing paragraphs. Case-term hits on page: 2 (WEAK anchor, confirm the page is about this case).
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)
(제주=연합뉴스) 변지철 기자 = 제주시내 호텔에서 발생한 중국인 피살사건은 가상화폐 환전 거래과정에서 발생했을 가능성이 있는 것으로 보고 경찰이 수사중이다.
제주서부경찰서는 살인 혐의로 30대 여성 2명과 30대 남성 1명, 60대 남성 1명 등 중국인 4명을 조사하고 있다고 25일 밝혔다.
이들은 지난 24일 오후 제주시의 한 특급호텔 객실에서 30대 중국인 남성 A씨를 살해한 혐의를 받는다. A씨는 24일 오후 5시 10분께 지인의 신고를 받고 출동한 경찰에 의해 발견됐다.
지인은 '가상화폐를 사러 갔던 지인이 연락되지 않아 이상하다. 잘못된 것 같다'고 112에 신고했다.
경찰 발견 당시 A씨는 흉기에 여러 차례 찔려 피를 흘린 채 사망한 상태였다.
신고 시각 5분 뒤인 오후 5시 15분께 피의자 중 한 명인 30대 여성 1명이 제주 서귀포시 성산파출소에서 자수했다.
이어 공범인 30대 중국인 남녀 2명이 출국하려다 제주국제공항에서 경찰에 붙잡혔고, 호텔 카지노에서 60대 중국인 남성 1명이 긴급체포됐다.
경찰은 이들 4명이 피해자 A씨의 돈 8천500만원을 가지고 달아난 사실을 확인하고 정확한 범행 동기와 경위를 조사하고 있다.
경찰은 자수한 30대 중국인 여성이 주범일 가능성이 있다고 보고 있으며, 피의자 진술을 토대로 가상화폐 환전 거래 과정에서 범행을 저질렀는지 등 모든 가능성을 열어두고 수사하고 있다.
이들은 모두 관광비자로 제주를 찾았으며 불법 체류 신분은 아닌 것으로 알려졌다.
한편 지난달에도 제주시내 호텔에서 8억4천만원 상당의 가상화폐를 빼앗아 달아난 중국인 일당이 구속되는 등 가상화폐 거래 관련 범죄가 이어지고 있다.
제보는 카카오톡 okjebo
<저작권자(c) 연합뉴스,
무단 전재-재배포, AI 학습 및 활용 금지>
2025/02/25 13:29 송고
2025년02월25일 13시29분 송고
URL이 복사되었습니다.
[영상] "터널 안에서 목소리 들려"…네팔 대홍수 9일만에 '기적의 생존'
================================================================================================
generated from attacks-export-Gart-website.json + reported_K&R | case 215
================================================================================================
Reference in New Issue View Git Blame Copy Permalink