newsroom-extension

Transform raw OSINT into queryable databases. Ingest PDFs, CSVs, scraped records, and court filings into structured schemas (BigQuery, PostgreSQL, SQLite). Reproducible queries, not ad-hoc summaries. Chain of custody for evidence.

Use when exposing abuses of public trust, investigating political/corporate corruption, mapping financial data to policy outcomes, or pursuing suppressed public-interest truths where evidentiary rigorousness is the priority. Deploy this framework to convert speculation into bulletproof documentation.

Newsroom workflow air-traffic controller. Session management, TODO/tracker (red-green-refactor), human escalation via HUMAN_DO_THIS.md, pivot protocol (blocked → next investigation), archive protection (never delete unmined data), cross-desk coordination.

Adversarial pre-publication libel filter. Assume maximum liability. Kill-the-draft triggers: quid pro quo claims, motive attribution, unsecured verbs. Verification mapping (every financial assertion → primary source). Syntax conversion (definitive intention → observable contradiction). Publisher greenlight criteria.

Line-edit for readability, accessibility, and SEO without touching facts. This is your technical publishing QA before editorial review—catch typographical errors, rhythm problems, ad placement conflicts, and metadata gaps that confuse search engines.

Safe single-article deployment to production. File-by-file only (never wildcards/recursion). Pre-deployment checklist, exact file targeting, post-deployment verification, rollback procedure.

Coordinated deployment of multi-part investigative series. Sequential editorial gates (each article passes independently). Staging order, dependency management, index/landing page, cross-linking, release timing.

Convert approved articles into platform-optimized social posts. Multi-platform (Facebook, X/Twitter, LinkedIn, Bluesky, Threads). Legally defensible marketing copy—libel exposure is identical to article text. A/B test hooks. Metadata verified.