This repository has been archived on 2026-10-19. You can view files and clone it. You cannot open issues or pull requests or push a commit.
Files
DB-cleanup/merge-output/pending-database-fixes-Sofi.md
StellarCrow 41766c68a2 chore: final state before the move to gart/gart-databases
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.
2026-10-17 10:47:37 +02:00

10 KiB
Raw Permalink Blame History

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:

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.md is out of date on four points — life_taken is a count of deaths, "Mexico" is missing from the country list, the kidnappings rule doesn't match recent entries, and money_wanted is 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.