evidence

1 row where event_id = "1a393002-b62b-5ffa-9ed3-27107851bfaa"

✎ 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
2b051ea3-c6fb-496d-be74-4b07a9044f73 1a393002-b62b-5ffa-9ed3-27107851bfaa 2325f554-f700-4f06-af30-ec1de1b44fbd government_document Document: A-83-001-2-1 | Witnesses: 1 | Witness appears credible, reports specific timeframes and multiple incidents, willing to cooperate with military authorities       2026-06-01T00:28:45.675217

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]);