MCRO Forensic Database · Complete Public Archive · OTS Timestamped

The Complete Forensic Database

The complete forensic dataset from State of Minnesota v. Guertin (27-CR-23-1886): database exports, source files, forensic reports, analysis tools, and cryptographic authentication — packaged for independent download, verification, and analysis. Every file is SHA-256 hashed and Bitcoin-timestamped via OpenTimestamps. Every number in every report is reproducible by anyone with a copy.

4,251Court Filings
2,903Case Dockets
2.9MDatabase Rows
1.6 GBDatabase Size
606,037Hashed Text Rows
88Forensic Reports
231DB Indexes
100%OTS Timestamped
Hugging Face — the complete corpus as datasets
8 repositories, 62,439 files, 71.14 GB. Each repository has a manifest.tsv listing every file’s SHA-256, and the database is included as Parquet tables that load in one line.
Open the Collection Main dataset
▶ 01 PostgreSQL Database 435 MB Archive · 1.6 GB Live
The complete MCRO Forensic PostgreSQL Database — 55 tables, 42 views, 16 materialized views, and 231 indexes across 1.6 GB. Built from 4,251 court filing PDFs downloaded from Minnesota Court Records Online, deconstructed into 606,037 individually SHA-256 hashed text rows with 1,156,980 classification tags, 155,357 docket events, 35,326 extracted PDF objects, and 11,645 hearing records.

The database is read-only. No row has been modified since finalization. Every forensic report produced from this database can be reproduced by anyone with access, yielding identical results.
Database Export
ZIP MCRO_export.zip — Complete Database Archive
Full database backup (.dump), schema SQL, CSV exports of all 114 tables/views, restoration guide, export script, and OpenTimestamps proofs. Everything you need in one file.
435 MB loading hash...
Download Archive OTS Proof
Individual Database Files
File Description Size SHA-256
MCRO_Supabase__20260310.dump Latest full backup (pg_restore format) 82 MB loading...
MCRO_Supabase__20260303.dump Prior backup (comparison/fallback) 82 MB loading...
schema_only.sql DDL for all schemas (human-readable, no data) 252 KB loading... View
mcro_csv_export.zip All 114 tables/views as individual CSVs 277 MB loading...
MCRO__Database_Schema.md Annotated schema reference with row counts 22 KB loading...
README__load_MCRO_Supabase.md Step-by-step restoration guide 9.3 KB loading...
export.sh Exact script that produced this export 3.3 KB loading...
Quick Restore: Download the .dump file and run:
pg_restore -h YOUR_HOST -p 5432 -U postgres.YOUR_PROJECT_REF -d postgres --no-owner --no-privileges -F c MCRO_Supabase__20260310.dump

Verification query (expected: 181,556 rows): SELECT COUNT(*) FROM children_doc_strings;

Full instructions including Supabase CLI method and Claude MCP connector setup are in README__load_MCRO_Supabase.md.
Source File Archives
The raw source files from which the database was constructed — 4,251 court filing PDFs, 2,903 docket records, extracted objects, metadata JSON, and hearing data. Each archive includes an OpenTimestamps proof (.ots) anchored to the Bitcoin blockchain.
Archive Contents Size SHA-256 OTS
children-pdf.zip 4,251 court filing PDFs — children table 2.5 GB loading... OTS
parents-pdf.zip 2,903 case docket PDFs — parents table 854 MB loading... OTS
children-objects.zip 25,972 extracted PDF objects (fonts, images, streams) by SHA-256 940 MB loading... OTS
source-hearings.zip 11,645 hearing records — source_hearings table 109 MB loading... OTS
hashpack-json.zip PDF structure, streams, and SHA-256 hashes — hashpack table 57 MB loading... OTS
parents-html.zip Raw MCRO docket HTML pages as captured 42 MB loading... OTS
children-json.zip Full metadata JSON per document — children table 24 MB loading... OTS
parents-json.zip Parties, events, hearings, charges — parents table 15 MB loading... OTS
children-pdf-to-text.zip Full text extraction from all court filing PDFs 7.9 MB loading... OTS
source-json.zip 14 collection session configs — source table 1.1 MB loading... OTS
▶ 02 3-Step Project Framework 3 Claude.ai Projects · 219 Files
The complete, reproducible AI-powered forensic analysis pipeline used to produce every report on this site. Three pre-built Claude.ai Projects with full instructions, knowledge files, and the Supabase MCP connector setup guide. Download these, load the database into your own Supabase instance, and you have the exact same analytical capability that produced 79 forensic reports from 2.9 million rows of court record data.
STEP 1
Prompt Generator
Describe your analysis goal in plain English. Receives database schema, all prior prompts & reports. Outputs a structured, production-ready prompt.
➔
STEP 2
Report Generator
Executes structured prompts against the live database via Supabase MCP connector. Produces professional .docx reports with SQL appendix.
➔
STEP 3
Intelligence Synthesis
Cross-report analysis, claim evaluation, gap identification. All 79 reports loaded as knowledge. Feeds gaps back to Step 1.
Prerequisites: Claude.ai Pro subscription ($20/month) · Supabase account (Pro at $25/month for 1.6 GB database) · Supabase MCP connector enabled in Claude.ai

Setup time: Database restore takes ~5 minutes. Each project takes ~2 minutes to configure. Full instructions included in the download.
ZIP All Projects — Complete Framework
All 3 projects, READMEs, Supabase connector setup guide, and file inventory.
14 MB loading hash...
Download All Projects
ZIP Step 1: Prompt Generator
Instructions, cheat sheet, database schema, 56 prior prompts, 65 prior reports, 13 bookmark schemas.
6.7 MB loading hash...
Download
ZIP Step 2: Report Generator
Instructions, database schema, style template. Enforces SELECT-only queries and 9-section report format.
108 KB loading hash...
Download
ZIP Step 3: Intelligence Synthesis
Instructions, all 65 forensic reports as knowledge files, 2 supplementary catalogs for cross-report analysis.
6.3 MB loading hash...
Download
▶ 03 Forensic Reports 88 Reports · 14 Categories
Every forensic report produced from the MCRO database, organized by analytical domain. Each report contains methodology, numbered findings, limitations, and a complete SQL appendix so every result can be independently reproduced.
ZIP All Reports — 88 PDFs
29 MB loading hash...
Download All Reports
▶ 01 Hearing Claims Analysis 10 reports ZIP
Narrative Arc Report (1 of 10)310 KBDL
Discovery Fraud Evidence Chain (2 of 10)218 KBDL
Email Evidence: Carpenter & Donnelly (3 of 10)267 KBDL
March 5 Hearing Claims Analysis (4 of 10)359 KBDL
Koch Competency Order Forensics (5 of 10)292 KBDL
Motion to Dismiss Analysis (6 of 10)461 KBDL
April 17 Hearing Claims Analysis (7 of 10)333 KBDL
Pro Se Petition Evidence Filing (8 of 10)446 KBDL
April 29 Hearing Claims Analysis (9 of 10)497 KBDL
Emergency Motions Synthesis (10 of 10)509 KBDL
▶ 02 Competency & Rule 20 Analysis 8 reports ZIP
Guertin Rule 20 Competency Analysis345 KBDL
Rule 20 Fact Check: Rogstad (Part 1)417 KBDL
Rule 20 Fact Check: Milz (Part 2)580 KBDL
Milz Transcript Verification Supplement366 KBDL
Rule 20 Fact Check: Cranbrook (Part 3)380 KBDL
Cloned Judicial Signature on First Rule 20 Order505 KBDL
Forced Neuroleptic Pipeline Report371 KBDL
Rule 20 Reports: Duplicate Metadata Authentication319 KBDL
▶ 03 Email Authentication 5 reports ZIP
Exhibit EML-A (Part 1)538 KBDL
Exhibit EML-B (Part 1)1020 KBDL
Exhibit EML-C (Part 1)1.4 MBDL
Exhibit EML-D (Part 1)494 KBDL
Exhibit EML-E (Part 1)624 KBDL
▶ 04 Digital Forensics & Document Authentication 6 reports ZIP
Initial Digital Forensic Analysis Report101 KBDL
MCRO Digital Signature Authentication102 KBDL
eSolutions Signature Statistical Breakdown962 KBDL
Cloned Discovery Template Forensic Report102 KBDL
Hash Loop Evidence Capture: System (Part 1)670 KBDL
Hash Loop Evidence Capture: Docket (Part 2)682 KBDL
▶ 05 Tracking Font Forensics 3 reports ZIP
Tracking Fonts and Revision Counts94 KBDL
Font Tracking Forensic Report (Groups A1-F1)113 KBDL
Font Tracking Language Report (Groups A1-F1)790 KBDL
▶ 06 Temporal Document Drift Analysis 12 reports ZIP
Docket Drift (Part 1)96 KBDL
Docket Drift (Part 2)103 KBDL
Docket Anomaly (Part 1)353 KBDL
Docket Anomaly (Part 2)285 KBDL
DocSet Group Analysis (Part 1)617 KBDL
DocSet Group Analysis (Part 2)529 KBDL
DocSet Group Analysis (Part 3)598 KBDL
DocSet Group Analysis (Part 4)523 KBDL
DocSet Group Analysis (Part 5)691 KBDL
Language Term Exclusivity (Part 1)484 KBDL
Language Term Exclusivity (Part 2)496 KBDL
Source Hearings Scheduling Anomalies117 KBDL
▶ 07 Mental Health Statistical Pattern Analysis 6 reports ZIP
Mental Health Over-Representation98 KBDL
Finding of Incompetency Clones124 KBDL
Cluster Event Alignment117 KBDL
Cluster Expanded Origin MH Outcome Analysis127 KBDL
Constitutional MH Inversion Severity Index848 KBDL
MH Case Events Comprehensive Report948 KBDL
▶ 08 Patent & IP Context 5 reports ZIP
Patent & Trademark Chronological Report487 KBDL
InfiniSet vs Netflix Patent Duplication281 KBDL
US Patent 11,577,177 Financial Valuation271 KBDL
LinkedIn Search Timeline Report549 KBDL
Military Simulation & LinkedIn Correlation397 KBDL
▶ 09 Supplemental & Reference 4 reports ZIP
Addendum Vol XIV Claims Verification524 KBDL
Addendum Vol XV Claims Verification460 KBDL
Guertin Case Update (March 8, 2026)536 KBDL
USPS Address Recycling Forensic Report3.7 MBDL
▶ 10 Capstone Synthesis Reports 11 reports ZIP
The Forensic Database Overview326 KBDL
The Database That Was Never Supposed to Exist482 KBDL
The Competency Question: A Forensic Narrative280 KBDL
Capstone Convergence Target Report492 KBDL
Capstone Provenance Authentication Report1.9 MBDL
Discovery Fraud & Competency Chronology355 KBDL
Narrative Arc Report (1 of 10)310 KBDL
Emergency Motions Synthesis (10 of 10)509 KBDL
Forced Neuroleptic Pipeline Report371 KBDL
Language Term Exclusivity (Part 3)442 KBDL
Constitutional MH Inversion Severity Index848 KBDL
▶ 11 Agent Swarm Findings 5 reports ZIP
Criminal Case Agent Swarm Analysis1.2 MBDL
Parallel Autonomous Forensic Investigation694 KBDL
The Commitment Pipeline1018 KBDL
The Tuesday Machine1.2 MBDL
The 33-Year Legal Universe867 KBDL
▶ 12 Aspose Backdating — Smoking Gun 2 reports ZIP
Aspose Software Version Impossibility Report3.9 MBDL
Aspose Impossibility x Competency Statute Convergence1.1 MBDL
▶ 13 Guertin Docket Snapshot Analysis 2 reports ZIP
Cole-Prochazka Inversion Report192 KBDL
Cole Authorship Target4 Convergence Addendum174 KBDL
▶ 14 Latest Additional Reports 13 reports ZIP
Chronological Correlation Report — 8th Cir. Timeline789 KBDL
Appellate Language Analysis — Vocabulary Blackout (v2)1.5 MBDL
Competency Statutory Framework Evolution291 KBDL
The Competency Loop & Suspension of Rights1.3 MBDL
Internet Archive / photorobot.com Forensic Report411 KBDL
Forensic Psychology Report — Guertin223 KBDL
MCRO Watermark PKI Reversion Analysis414 KBDL
Judicial Officer Representation Analysis1.6 MBDL
Judicial Officer Representation — Narrative Synthesis581 KBDL
NIP Docket-Level Temporal Analysis233 KBDL
NIP Operational Anatomy655 KBDL
Single Hypothesis Convergence Report145 KBDL
77-Cluster Forensic Report — Agent Swarm Synthesis1.1 MBDL
▶ 04 Knowledge Catalogs 13 Catalogs · 2.4 MB · LLM-Optimized
Structured reference catalogs designed for LLM knowledge ingestion. Thousands of pages of court filings, emails, and investigative materials extracted into machine-readable markdown with standardized fields — filing metadata, detailed summaries, legal issues, entities, forensic flags, and cross-references.

These catalogs allow AI systems like Claude to understand and reference court filing content without consuming tokens on raw PDFs. Load them as project knowledge files and the entire case history is available for analysis within token-efficient structured formats.
How to use: Download the catalogs and add them as knowledge files in a Claude.ai Project. The Trimmed versions are optimized for Claude's context window. Combined with the database and the 3-Step Project Framework, they provide comprehensive case context for independent analysis.

Full vs. Trimmed: Discovery and Patent catalogs come in two versions. Full versions contain complete exhibit inventories and per-filing entity lists. Trimmed versions (3-8x smaller) consolidate cross-cutting information into deduplicated appendices for token efficiency.
ZIP All Knowledge Catalogs
741 KB loading hash...
Download All Catalogs
CatalogSubjectSizeSHA-256
Discovery Fraud (FULL) 28 filings — complete detail with exhibit inventories 380 KB loading... DL
Discovery Fraud (Trimmed) 28 filings — compressed for LLM ingestion 46 KB loading... DL
Patent Fraud (FULL) 25 filings — complete detail with exhibit inventories 924 KB loading... DL
Patent Fraud (Trimmed) 25 filings — compressed for LLM ingestion 298 KB loading... DL
Federal Case 24-cv-02646 Guertin v. Hennepin County — 107 entries, 5,765 pages 50 KB loading... DL
Federal Case 25-cv-02670 Guertin v. Walz et al. — related proceedings 37 KB loading... DL
8th Circuit 24-2662 Appeal of 24-cv-02646 27 KB loading... DL
8th Circuit 25-2476 Appeal of 25-cv-02670 — 114 PDFs, 4,915 pages 109 KB loading... DL
Email Authentication & Entities 99 emails — authentication verdicts and entity validation 304 KB loading... DL
Biographical Data Catalog Verified facts from court filings and public records 56 KB loading... DL
Substack 2023 84 posts — domain-organized verifiable facts 42 KB loading... DL
Substack 2024 Factual intelligence extraction 37 KB loading... DL
Substack 2025–2026 Factual intelligence extraction 41 KB loading... DL
▶ 05 Dataset Authentication 4-Layer Verification · 100% Coverage
The complete cryptographic authentication package for the MCRO forensic corpus. Four independent layers of verification — court-issued digital signatures, Bitcoin-timestamped hash chains, email authentication protocols, and official court filings — independently prove the authenticity and integrity of every file in this dataset.
Verification MetricResult
MCRO-Downloaded PDFs with Valid Court Signatures4,206 of 4,206 (100%)
Post-Signing Modifications Detected0 of 4,206 (0.0%)
Docket Records Bitcoin-Timestamped (OTS)2,903 of 2,903 (100%)
Hash-Chain Links Verified68 of 68 (100%)
OTS + Roughtime Timestamps Verified137 of 137 (100%)
SHA-256 Match Rate (Bundle vs. Docket Report)2,666 of 2,672 (99.8%)
Mismatches Explained by Docket Updates6 of 6 (100%)
Authenticated Emails228 emails + 280 attachments
Days from Collection to First Court Filing≤ 4 days (Apr 28–30 → May 3, 2024)
MCRO Watermark Certificate ValidityApril 2, 2024 – April 2, 2026
Certificate Chain of Trust:
Leaf: Minnesota Court Records Online (MCRO) Watermark · Serial: 3f9a4ed3d4d82120126a4ece4e415ea8
Issuer: MJB – Issuing CA (Minnesota Judicial Branch, Saint Paul, MN) · RSA-3072 · SHA-384
SHA-256 Fingerprint: 84b5a55aee3a8f99d44e8f7266bb31ba71a78e5a64606a7e5d88bab19849ae10
ZIP Complete Authentication Package
All authentication reports (PDF), MCRO public key, MJB Issuing CA certificate and CRL, signature details JSON, per-document validation spreadsheet, and OpenTimestamps proofs.
6.4 MB loading hash...
Download Package
Authentication Reports
ReportDescriptionSize
Capstone Provenance Authentication Report Consolidated chain-of-custody verification across full report series 3.7 MB DL
MCRO Digital Signature Authentication Corpus-wide MCRO Watermark validation across all 4,251 PDFs 235 KB DL
Digital Signature Report (Embedded Files) Certificate chain details, CA status, embedded verification artifacts 944 KB DL
Hash Loop Evidence Capture: System (Part 1) System-level authentication of evidence capture controller and hash chains 887 KB DL
Hash Loop Evidence Capture: Docket (Part 2) Cross-session verification of 2,729 docket downloads against PDF registry 972 KB DL
Cryptographic Verification Files
FilePurposeSize
MCRO_public-key.pem RSA public key for the MCRO Watermark certificate 451 B
MJBIssuingCA.crt MJB Issuing CA certificate (Minnesota Judicial Branch) 1.5 KB
MJBIssuingCA.crl Certificate Revocation List from the issuing CA 7.5 KB
MCRO_sig-details.json Parsed signature metadata for the entire corpus 64 KB
MCRO-SIGNATURE_doc_authentication.xlsx Per-document signature validation results for all 4,251 PDFs 615 KB
MCRO_ots-timestamps.zip OpenTimestamps proofs anchored to Bitcoin blockchain 6.4 KB
MCRO_revoked-list.csv Certificate revocation serial numbers with dates and reasons 19 KB
▶ 06 Source Files 10 ZIP Packages · 4 Pillars · ~4.8 GB
The 10 raw source packages from which every row of the MCRO database was derived — 4,251 court filing PDFs, 2,903 case docket records, 25,972 extracted PDF objects, 4,251 hashpack reports, 5,807 raw HTML docket pages, and the source/hearing configuration data. Each archive is SHA-256 hashed and Bitcoin-anchored via OpenTimestamps. Click any hash to copy the full SHA-256 to your clipboard.
ZIP
children-pdf 2.5 GB
Source PDFs for the children table — 4,251 court-filed documents loading hash…
↓ Download OTS
ZIP
parents-pdf 854 MB
Source PDFs for the parents table — 2,903 case docket records loading hash…
↓ Download OTS
ZIP
children-objects 940 MB
Extracted PDF objects from children — 25,972 fonts, images, and data streams by SHA-256 loading hash…
↓ Download OTS
ZIP
source-hearings 109 MB
Source data for the source_hearings table — 11,645 hearing session search results loading hash…
↓ Download OTS
ZIP
hashpack-json 57 MB
Source JSON for the hashpack table — PDF structure, streams, SHA-256 hashes (derived from children) loading hash…
↓ Download OTS
ZIP
parents-html 42 MB
Raw MCRO docket HTML pages for the parents table — as captured during collection loading hash…
↓ Download OTS
ZIP
children-json 24 MB
Source JSON for the children table — full metadata per document loading hash…
↓ Download OTS
ZIP
parents-json 15 MB
Source JSON for the parents table — parties, events, hearings, charges loading hash…
↓ Download OTS
ZIP
children-pdf-to-text 7.9 MB
Full text extraction from all children PDFs — complete document content as plain text loading hash…
↓ Download OTS
ZIP
source-json 1.1 MB
Source JSON for the source table — 14 collection session configurations and parameters loading hash…
↓ Download OTS
Browse interactively: the /source-files/ explorer is a single-page app over the same archives — filter by case type, year, filing type, cluster, and case set; deep-link into any document; preview PDFs in a split-pane viewer.