evidence

3 rows where event_id = "ac3208fc-5b29-4cae-8e65-952618d25f8d"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: created_at (date)

id ▼ event_id report_id evidence_type description source_url file_path confidence created_at
2672805b-006c-4949-ba14-253429264cb2 ac3208fc-5b29-4cae-8e65-952618d25f8d   video video evidence from CIA document     unverified 2026-03-24T21:16:30.544198-04:00
63db8d89-ebcc-4e5e-9ff9-aa96657f4f3c ac3208fc-5b29-4cae-8e65-952618d25f8d   physical_trace physical_trace evidence from CIA document     unverified 2026-03-24T21:16:30.544198-04:00
8fdfcd28-bc4f-4f0d-bbd1-001bf3100a6b ac3208fc-5b29-4cae-8e65-952618d25f8d   photograph photograph evidence from CIA document     unverified 2026-03-24T21:16:30.544198-04:00

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "evidence" (
   [id] TEXT PRIMARY KEY,
   [event_id] TEXT REFERENCES [events]([id]),
   [report_id] TEXT REFERENCES [reports]([id]),
   [evidence_type] TEXT,
   [description] TEXT,
   [source_url] TEXT,
   [file_path] TEXT,
   [confidence] TEXT,
   [created_at] TEXT
);
CREATE INDEX [idx_evidence_report_id]
    ON [evidence] ([report_id]);
CREATE INDEX [idx_evidence_event_id]
    ON [evidence] ([event_id]);