Investigation Archive - Commonwealth v. Lindsay Clancy
``` DB/ ├── court-transcripts/ # 14 verbatim trial transcripts — YouTube linked (~2.2 MB) │ ├── opening-statements.md # Jul 29, 2026 │ ├── day-02.md # Jul 30, 2026 │ ├── day-03.md # Aug 2, 2026 │ ├── day-04.md # Aug 2, 2026
# Investigation Archive - Commonwealth v. Lindsay Clancy
Case: Commonwealth v. Lindsay Clancy
Court: Plymouth Superior Court, Plymouth, Massachusetts
Trial Dates: July 29 - August 28, 2026
Status: Trial concluded Aug 28, 2026 — jury deliberations ongoing, no verdict as of Aug 31, 2026 (pending)
Created: August 31, 2026
## Database Structure
DB/ ├── court-transcripts/ # 14 verbatim trial transcripts — YouTube linked (~2.2 MB) │ ├── opening-statements.md # Jul 29, 2026 │ ├── day-02.md # Jul 30, 2026 │ ├── day-03.md # Aug 2, 2026 │ ├── day-04.md # Aug 2, 2026 │ ├── day-05.md # Aug 4, 2026 │ ├── day-06.md # Aug 5, 2026 │ ├── day-07.md # Aug 6, 2026 │ ├── day-08.md # Aug 10, 2026 │ ├── day-11.md # Aug 12, 2026 │ ├── day-13.md # Aug 17, 2026 │ ├── day-17.md # Aug 21, 2026 - Chaplain Cavanaugh │ ├── day-20.md # Aug 26, 2026 - Dr. Heilbrun │ ├── day-21.md # Aug 27, 2026 - Dr. Resnick │ └── closing-arguments.md # Aug 28, 2026 │ ├── court-documents/ │ ├── pdfs/ # Original PDFs preserved │ │ ├── clancy-indictment.pdf # 157 KB - Grand jury indictment │ │ ├── clancy-search-warrant.pdf # 6.9 MB - Search warrant affidavits │ │ └── clancy-civil-lawsuit.pdf # 1.0 MB - Civil malpractice suit │ ├── markdown/ # Comprehensive markdown versions │ │ ├── clancy-indictment.md # 12.8 KB - Full indictment details │ │ ├── clancy-search-warrant.md # 17.3 KB - Probable cause, evidence │ │ └── clancy-civil-lawsuit.md # 18.7 KB - 4 counts, 8+ defendants │ └── crime-timeline.md # 208 KB - Complete case timeline │ ├── news-reports/ │ ├── pbs/ # 9 PBS NewsHour articles (~70 KB) │ │ ├── 01-postpartum-psychosis-explainer.md # Jul 28 │ │ ├── 02-ex-husband-testifies.md # Jul 29 │ │ ├── 03-first-responders-testify.md # Jul 30 │ │ ├── 04-women-rally-support.md # Aug 20 │ │ ├── 05-prosecution-expert-testifies.md # Aug 25 │ │ ├── 06-broken-mental-health-system.md # Aug 26 │ │ ├── 07-evidence-concludes.md # Aug 26 │ │ ├── 08-jury-deliberates.md # Aug 27 │ │ └── 09-central-issue-analysis.md # Aug 27 │ ├── reuters/ # Reuters neutral news coverage │ │ └── clancy-closing-arguments-2026-08-27.md # Closing arguments coverage │ └── ap-news/ # AP News neutral coverage │ ├── clancy-diary-coverage.md # Diary evidence coverage │ └── clancy-trial-live-2026-08-28.md # Live trial updates │ ├── legal-references/ # 7 legal reference files │ ├── ma-model-jury-instructions.md # MA Criminal Responsibility standard │ ├── ma-bill-h4484-guilty-except-insane.md # Proposed legislation │ ├── ma-gen-laws-ch123-s16-insanity-defense.md # Full statute text │ ├── ma-sentencing-guidelines-murder.md # Sentencing guidelines │ ├── commonwealth-v-mchoul-1967.md # Full court opinion │ ├── nolo-postpartum-psychosis-defense.md # Nolo legal explainer │ ├── findlaw-postpartum-psychosis-analysis.md # FindLaw analysis │ └── pdfs/ │ └── ma-bill-h194.html # MA Bill H.194 (HTML) │ ├── mental-health/ # 5 mental health reference files │ ├── psi-postpartum-psychosis-help.md # Postpartum Support International │ ├── cleveland-clinic-postpartum-psychosis.md # Cleveland Clinic clinical info │ ├── acog-perinatal-mental-health.md # ACOG guidelines │ ├── apa-postpartum-psychosis.md # American Psychiatric Association │ └── lanier-law-clancy-overview.md # Medical/legal overview │ ├── forensic-psychology/ # 2 PDFs + 2 markdown summaries │ ├── pdfs/ │ │ ├── nist-sp-800-101r1-mobile-forensics.pdf # 1.3 MB - NIST guidelines │ │ └── swgde-best-practices-mobile-evidence.pdf # 310 KB - SWGDE standards │ ├── nist-mobile-device-forensics.md # 17.3 KB - Full summary │ └── swgde-mobile-evidence-best-practices.md # 19.4 KB - Full summary │ ├── academic-studies/ # Scientific/sociological research references │ ├── alford-2024-ppp-infanticide-systematic-review.md # PPP & infanticide systematic review │ ├── gilden-2020-ppp-long-term-outcomes.md # PP long-term outcomes meta-analysis │ ├── oliva-2025-antidepressant-mania-switch.md # Antidepressant switch to mania NMA │ ├── webb-2023-barriers-pmh-care.md # Barriers to perinatal MH care │ └── jaaple-2017-ppp-global-prevalence.md # Global prevalence of PP │ ├── entities/ # 26 entity files │ ├── people/ # 14 person entities │ │ ├── lindsay-clancy.md # Defendant │ │ ├── patrick-clancy.md # Father of victims │ │ ├── cora-clancy.md # Victim (5) │ │ ├── dawson-clancy.md # Victim (3) │ │ ├── callan-clancy.md # Victim (8 months) │ │ ├── kevin-reddington.md # Defense attorney │ │ ├── jennifer-sprague.md # Lead prosecutor │ │ ├── judge-william-sullivan.md # Presiding judge │ │ ├── dr-phillip-resnick.md # Defense expert │ │ ├── dr-kirk-heilbrun.md # Prosecution expert │ │ ├── dr-gregory-saathoff.md # Prosecution rebuttal │ │ ├── sheila-cavanaugh.md # Chaplain witness │ │ ├── paula-musgrove.md # Lindsay's mother │ │ └── allison-ozga.md # Lindsay's sister │ ├── organizations/ # 7 organization entities │ │ ├── plymouth-county-da.md │ │ ├── massachusetts-general-hospital.md │ │ ├── mclean-hospital.md │ │ ├── tewksbury-state-hospital.md │ │ ├── spaulding-rehabilitation-hospital.md │ │ ├── brigham-and-womens-hospital.md │ │ └── postpartum-support-international.md │ ├── places/ # 3 place entities │ │ ├── duxbury-ma.md │ │ ├── plymouth-superior-court.md │ │ └── brockton-ma.md │ └── events/ # 2 event entities │ ├── january-24-2023-killings.md │ └── trial-july-august-2026.md │ ├── media/ │ └── video-links.md # YouTube, PBS, Court TV video links │ ├── glossary/ │ └── glossary.md # 50+ legal, medical, case terms │ └── INDEX.md # This file
## Source Summary
| Category | Files | Total Size | Status |
|---|---|---|---|
| Court Transcripts (YouTube-linked verbatim) | 14 | ~2.2 MB | ✅ Complete |
| Court Documents (PDFs) | 3 | ~8.1 MB | ✅ Originals preserved |
| Court Documents (Markdown) | 3 | ~49 KB | ✅ Comprehensive summaries |
| PBS News Articles | 9 | ~70 KB | ✅ Complete |
| Reuters News Articles | 1 | ~8 KB | ✅ Neutral coverage |
| AP News Articles | 2 | ~10 KB | ✅ Neutral coverage |
| Legal References | 7 | ~32 KB | ✅ Statutes, case law, analysis |
| Mental Health Resources | 5 | ~33 KB | ✅ Clinical + advocacy |
| Forensic Psychology (PDFs) | 2 | ~1.6 MB | ✅ NIST + SWGDE standards |
| Forensic Psychology (MD) | 2 | ~37 KB | ✅ Full summaries |
| Academic Studies | 5 | ~25 KB | ✅ Peer-reviewed research |
| Entity Files | 26 | ~60 KB | ✅ People, orgs, places, events |
| Video Links | 1 | ~4 KB | ✅ Court TV, PBS, YouTube |
| Glossary | 1 | ~11 KB | ✅ 50+ terms |
| TOTAL | 81 files | ~12.4 MB |
## Key Documents
### Indictment (September 15, 2023)
### Search Warrant Affidavits
### Civil Lawsuit (January 22, 2026)
## Hard Constraints (from prompt.md)
1. No legal, moral, or personal opinions — pure recollection of data and information
2. Free tier only — Cloudflare D1, R2, Vectorize, Workers AI, KV, Queues, Vercel Hobby
3. No AI on page reads — AI only at ingestion or explicit user action
4. No file binaries in D1 — R2 only
5. No KV per-request writes — Use Analytics Engine or Durable Objects
6. Indexed columns required — Every D1 query WHERE clause must use indexed columns
7. Presigned direct-to-R2 uploads — Never proxy large files through Worker
8. Cache-Control headers — All public GET endpoints
## Architecture
Last updated: August 31, 2026 (expanded with academic studies and neutral news coverage)