Public records archive. No legal or medical advice.
Commonwealth v. Clancy
Back to documents
markdownmarkdown
Source: Plymouth Superior Court filing • Public record

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

Download & cite

# 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

CategoryFilesTotal SizeStatus
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 Articles9~70 KB✅ Complete
Reuters News Articles1~8 KB✅ Neutral coverage
AP News Articles2~10 KB✅ Neutral coverage
Legal References7~32 KB✅ Statutes, case law, analysis
Mental Health Resources5~33 KB✅ Clinical + advocacy
Forensic Psychology (PDFs)2~1.6 MB✅ NIST + SWGDE standards
Forensic Psychology (MD)2~37 KB✅ Full summaries
Academic Studies5~25 KB✅ Peer-reviewed research
Entity Files26~60 KB✅ People, orgs, places, events
Video Links1~4 KB✅ Court TV, PBS, YouTube
Glossary1~11 KB✅ 50+ terms
TOTAL81 files~12.4 MB

## Key Documents

### Indictment (September 15, 2023)

  • Charges: 3 counts murder + 3 counts strangulation
  • Grand Jury: Plymouth County, September 15, 2023
  • Key Evidence: 54-minute calculated window; exercise band ligatures; Apple Maps search; fitness tracker data; "ways to kill" search
  • ### Search Warrant Affidavits

  • Warrant Number: 12-29-2022B
  • Pages: 299 pages across 11 separate warrants
  • Evidence Seized: iPhone, 2 laptops, baby monitor, exercise bands, surveillance cameras, medications, blood/urine samples, journals
  • Key Finding: "Researching ways to kill" search on cell phone
  • ### Civil Lawsuit (January 22, 2026)

  • Case: Civil Action No. 2682CV000081, Norfolk County Superior Court
  • Plaintiff: Lindsay M. Clancy
  • Defendants: 8+ (psychiatrists, nurse practitioner, hospitals)
  • Counts: Negligence/Medical Malpractice, Loss of Parental Consortium, Loss of Spousal Consortium, Vicarious Liability
  • Expert Opinion: Dr. Spinelli diagnosed Bipolar Disorder I, severe, with psychosis; antidepressant caused manic symptoms

  • ## 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

  • Frontend: Next.js (App Router) on Vercel with ISR
  • Backend API: Cloudflare Worker with Hono
  • Database: Cloudflare D1 (SQLite)
  • Object Storage: Cloudflare R2
  • Vector Search: Cloudflare Vectorize
  • AI Inference: Cloudflare Workers AI
  • Cache: Workers KV (short-TTL only)
  • Async Processing: Cloudflare Queues
  • Rate Limiting: Durable Objects

  • Last updated: August 31, 2026 (expanded with academic studies and neutral news coverage)