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

171 lines
10 KiB
Markdown
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.
# 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.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.