Commits the work done since 2026-10-01 that was still local: the four-step label and flag passes, the triage and recheck files, the v1 exports of 2026-10-06 and 2026-10-07, the split dossiers, and the Lopp PR 234 batch (scripts, agent prompts, reader and checker files, the flag re-read of 2026-10-17, the review workbook and the import set of the 57 cases added to stats2 as 506 to 562). Raw HTML and node_modules stay out (.gitignore). The stats2 material in use was copied to gart/gart-databases (stats2/) on 2026-10-17; README-START-HERE.md now says so. This repo is closed.
10 KiB
Database fixes — done and to do
Every correction to cases already in the database: the ones already made, and the ones still waiting.
Corrections are made by hand on https://sqlite-stats.gart.io/attacks/, never from this repository — the database is the record. After making one, click Export, save the file into exports/, and run /reconcile. The reconcile shows which fields changed; move that item from To do to Done.
Last reviewed: 30 September 2026, against the export of that day (398 cases).
At a glance
| Case | What | Status |
|---|---|---|
| 23 | Date typo "September I" fixed | Done |
| 57 | Country changed USA → Canada | Done |
| 358 | Date, location, source and amounts corrected | Done |
| 488 | money_wanted "Undisclosed" → "Crypto" at import |
Done |
| 489 | Victim shortened at import | Done |
| 482 | Text in the wrong boxes; duplicate link | To do |
| 478 | Stray space in outlet name | To do |
| 481 | Deaths: 5 or 4? | To do — decision needed |
| 321 | Weapon not recorded | To do |
| 258 | Thin record; now fully sourced | To do |
| 23 | month still January after the date fix |
To do |
| 358 | Duplicate link; stray space | To do |
| 176 | Wrong location; thin record | To do — optional |
Done
Changes made in the database and confirmed in an export.
Case 23 — T.W. (Troy Woody Jr.), USA, 2018
Seen in the export of 30 September 2026.
| Field | Before | After |
|---|---|---|
date |
"September I, 2018" | "September 1, 2018" |
original_date |
"September I, 2018" | "September 1, 2018" |
The legacy typo that config/field-guide.md warned about. month was not changed — see To do.
Case 57 — Simply Delicious Food Market, 19 November 2019
Seen in the export of 30 September 2026.
| Field | Before | After |
|---|---|---|
country |
"USA" | "Canada" |
Case 358 — Bangkok, November 2025
Seen in the export of 30 September 2026. The record's link had pointed to an unrelated Thaiger story about dogs left behind in floods.
| Field | Before | After |
|---|---|---|
date, original_date |
"November 10, 2025" | "November 1, 2025" |
location |
"Bangkok" | "Maha Set Road, Bang Rak, Bangkok" |
url |
Thaiger flood story (wrong article) | https://thethaiger.com/news/national/south-korean-and-thai-nationals-arrested-for-bangkok-crypto-assault |
url_2 |
empty | https://www.khaosodenglish.com/news/2025/11/23/south-korean-3-thais-held-in-bangkok-kidnapping-case/ |
url_3, url_4 |
empty | https://news.nate.com/view/20251124n13809 (the same link twice — see To do) |
summary Crypto Stolen |
"Amount not disclosed in reports." | "9,375 USDT (sent in two transfers) plus 50,000 baht in cash." |
Changed at import
Cases edited in the database as they were imported, so they differ from the file that was staged:
| Case | Field | Staged | In the database |
|---|---|---|---|
| 488 — Taninges, 14 March 2026 | money_wanted |
"Undisclosed" | "Crypto" |
| 489 — Vendin-le-Vieil, 20 September 2026 | victim |
"A couple and their 2 children, ages 8 and 12" | "A couple and their 2 children" |
To do
1. Case 482 — Jouy-en-Josas, 24 August 2026
Three fields look like text was pasted into the wrong boxes.
| Field | Now | Should be |
|---|---|---|
reports |
"Attackers acted on a belief about the victim's holdings that was wrong." | CNews (the outlet in url) |
notes |
"Crypto" | The sentence currently sitting in reports |
url_3 |
The same CNews link as url |
Empty — it's a duplicate |
2. Case 478 — Alès, 29 August 2026
reports is " Journal du Coin" with a space in front. Case 480 has it without the space, so anything counting by outlet treats them as two different outlets. Remove the space.
3. Case 481 — Atizapán de Zaragoza, 1 September 2026 — decision needed
life_taken is 5. Every source names four people killed — Jonathan Meléndez, his wife, their three-year-old daughter, and the household employee — plus the family dog. The record's own summary says "Five homicides, including … the family dog."
Decide which you mean: 4 (people) or 5 (including the dog). Worth settling because it sets the rule for later cases.
4. Case 321 — Recife, 21 March 2025
Found on 23 September while chasing down a vague forum reference to a "Bitcoin miner's family" attack in Brazil, which turned out to be this case, not a new one.
| Field | Now | Should be |
|---|---|---|
weapons |
0 |
Likely 1 — a Yahoo Finance report on the same incident (13 Aug 2025) says the mother was "held at gunpoint for 12 hours" before the ransom was paid |
Source: https://finance.yahoo.com/news/brazilian-mom-held-bitcoin-ransom-161059269.html
5. Case 258 — Kharkiv, 10 October 2025
The record still says the victim is "unknown", cites only an archive link, and calls it "unclear if legitimate military". Police statements from October 2025 and the court file published in September 2026 answer all of that.
| Field | Now | Should be |
|---|---|---|
victim |
"unknown" | "32 y/o man" — a crypto trader who also handled other people's money (Kharkiv police) |
location |
"Kharkiv" | "Kharkiv, Ukraine" (to match the other Ukrainian cases); seized at a currency exchange on Nauky Street |
money_wanted |
"$83,000" | "83,620 USDT" — four transfers, about 3.47 million hryvnias — plus €14,600 cash taken from his pocket |
notes |
empty | The attackers, aged 30, 34 and 39, wore military uniform and balaclavas and posed as military recruitment (TCC) officers; one was a serving soldier. The organiser named in court papers, Oleksiy Steshak, is a staff officer of an army assault battalion. The victim was held in a basement in Izium until 11 October and suffered a broken nose, then left on the roadside in Bezliudivka. KORD special forces detained the group in Kharkiv and Kyiv on 12 October 2025; charged with kidnapping (art. 146 §2) and robbery (art. 187 §4), held in custody. The same gang is charged over a Kyiv kidnapping of 15 May 2025 (case 492) |
summary Status |
"Investigation ongoing. Unclear if attackers were military personnel…" | Group detained 12 October 2025 and held in custody. One attacker was a serving soldier; the organiser is an army staff officer |
url / url_2–url_4 |
archive.is link only | url: Gwara Media (below, most detailed police account). url_2: 368.media. url_3: InfoCity. url_4: life.kyiv.ua. Keep the archive link in url_5 |
Sources, all read on 30 September 2026:
- https://gwaramedia.com/u-harkovi-vikrali-cholovika-ta-vidibrali-ponad-97-tisyach-dolariv-napadnikiv-zatrimano/ — Gwara Media, 17 Oct 2025, citing Kharkiv regional police and its head of investigations, Serhiy Bolvinov
- https://368.media/2026/09/22/ofitser-shturmovogo-bataljonu-stvoryv-bandu-dlya-katuvannya-lyudej-zarady-vykupu-u-kryptovalyuti/ — 368.media, 22 Sept 2026, from the court file
- https://infocity.kharkiv.ua/proisshestvija/vykraly-cholovika-ta-zavolodily-joho-kryptoiu-u-kharkovi-zatrymaly-zlochynnu-hrupu-foto/ — InfoCity, 17 Oct 2025
- https://life.kyiv.ua/news/oberezhno-banda-vikradachiv-u-ki%D1%94vi-ta-harkovi-zhertva-viddala-15-tis-%D1%94vro-i-83- — life.kyiv.ua, 18 Oct 2025
One detail differs between sources: the October 2025 police account says he was driven around for about two hours; the court file says he was held in a basement in Izium from the evening of 10 October until about 2 AM on 11 October, with the four crypto transfers made between 21:00 and 23:50. The court file is later and more detailed.
6. Case 23 — T.W. (Troy Woody Jr.), USA, 2018
Left over from the date fix under Done: the date now says September, but month is still 1, so the case counts in January in any monthly figures. quarter is already 2018-Q3.
| Field | Now | Should be |
|---|---|---|
month |
1 |
9 |
7. Case 358 — Bangkok, 1 November 2025
Left over from the corrections under Done:
| Field | Now | Should be |
|---|---|---|
url_4 |
Same nate.com link as url_3 |
Empty — it's a duplicate |
location |
"Maha Set Road, Bang Rak, Bangkok " (trailing space) | Remove the space after "Bangkok" |
8. Case 176 — Bukit Timah, Singapore, 18 April 2024 — optional
The record is thin and one field is wrong. Six Malaysians were sentenced on 14 September 2026, and that coverage is far more detailed.
| Field | Now | Should be |
|---|---|---|
location |
"Lianhe Zaobao, Singapore" | An actual place — King Albert Park, Bukit Timah, Singapore. "Lianhe Zaobao" is a newspaper |
description |
"4 men rob…" | Seven men entered; six were convicted |
violence_torture |
0 |
Likely 1 — the 11 victims were tied up with their mouths taped; three robbers carried machetes, two carried baseball bats |
Sources: https://www.cryptocompass.com/articles/six-malaysians-jailed-over-s-4-9m-singapore-crypto-heist, https://www.therakyatpost.com/news/2026/09/15/six-malaysians-jailed-for-armed-raid-on-singapore-poker-game-that-netted-s4-9-million-most-of-it-still-missing/
New findings go at the end of this section, numbered on, with before/after values and source links.
Decisions already taken
- Case 106 — "E.Z.", Los Angeles: do NOT change
theft. Investigated on 16 September. The September 2026 reporting about a victim held at gunpoint who transferred about $25,000 concerns R.C., a party planner — a different person. The LA Times article that case 106 itself cites names the victims separately: R.C., E.Z. (Enzo Zelocchi), D.D. and L.A. Separately, case 106's description says "attempted robbery & kidnapping at gunpoint" and is dated 21 November 2021, but no source describes a gunpoint incident against E.Z. or mentions that date; the wording may come from R.C.'s incident. Not certain enough to change on its own. - R.C. (August 2021) and L.A. (October 2022) will not be added. Both were gunpoint robberies by Adam Iza's hired deputies, but neither dispute involved cryptocurrency and both sums moved by bank transfer. The rule: an attacker being a crypto figure is not enough on its own.
Also waiting
config/field-guide.mdis out of date on four points —life_takenis a count of deaths, "Mexico" is missing from the country list, thekidnappingsrule doesn't match recent entries, andmoney_wantedis entered as "Crypto" rather than "Undisclosed". To be done soon; priority to be set first.- The
sources/folder — 364 raw article files from the original bulk import, used by nothing and already out of date. Francesco to decide whether to keep it.