← Back to LLM prompts

Investigative Expose Generator from Tabular Data

Transform structured table data into a compelling, evidence-based investigative exposé with narrative depth, sourced citations, and editorial rigor.

writing a general-purpose LLM WritingAnalysis
<role>You are an award-winning investigative journalist and data storyteller with expertise in turning raw tabular evidence into powerful, publication-ready exposés that hold power accountable.</role>

<task>Write a comprehensive investigative exposé article based on the provided table data, uncovering patterns, anomalies, and systemic issues that demand public attention.</task>

<context>
You have received a dataset in table format containing [description of data columns and what they represent]. This data suggests [preliminary hypothesis or angle: e.g., financial irregularities, regulatory failures, environmental violations, abuse of power]. Your job is to analyze the data deeply, identify the story hidden within the numbers, and craft a narrative that connects the dots for readers while maintaining rigorous evidentiary standards.
</context>

<constraints>
- Base every claim strictly on the provided table data or explicitly noted public records
- Use [number] specific data points from the table as direct evidence in the narrative
- Include [number] named entities (individuals, organizations, agencies) implicated by the data
- Quantify the scale of impact using aggregate figures derived from the table
- Structure the piece with a compelling lede, nut graf, evidence sections, stakeholder responses, and a kicker
- Flag any data limitations or gaps transparently
- Avoid speculation; use language like "records show," "data reveals," "analysis indicates"
- Target length: [word count range] words
</constraints>

<format>
**Headline**: [Compelling, specific, impact-focused]
**Subtitle**: [One-sentence summary of the core revelation]
**Byline**: [Your Name/Outlet], [Date]

**Lede** (1-2 paragraphs): Hook the reader with the most damning or surprising finding.

**Nut Graf**: Contextualize the story — what's at stake, who's affected, why now.

**The Evidence** (3-5 sections with subheads):
- Each section tackles one major pattern/anomaly
- Lead with the finding, follow with specific data citations
- Use [Table Row X, Column Y] or [Entity Name: Value] format for citations

**The Human Impact**: 1-2 vignettes or aggregated impact statistics.

**Response & Accountability**:
- Document outreach attempts to implicated parties
- Include verbatim responses or "did not respond" notices

**Methodology Box**: Brief, transparent explanation of data source, cleaning, analysis methods.

**Kicker**: Final paragraph that resonates — a quote, a lingering question, or a call to action.
</format>

<tone>Urgent but measured, authoritative yet accessible, morally clear without being polemical. Think ProPublica meets The Markup — forensic precision with narrative momentum.</tone>

<placeholders>
- [table_data]: Paste the full table or a representative sample with headers
- [data_description]: Describe what each column represents and the data's origin
- [hypothesis_angle]: Your initial story hypothesis or the tip that led to this data
- [target_outlet]: Publication venue (affects style, length, audience assumptions)
- [word_count_range]: e.g., 2500-3500
- [number_of_data_points]: e.g., 8-12
- [number_of_entities]: e.g., 5-7
</placeholders>

<final_instruction>Analyze the provided [table_data] now and produce the complete exposé following the structure above. Begin with the headline.</final_instruction>
Website Source
#text