evidence
1 row where event_id = "e6578b64-fe7f-432b-a4a1-5d5d1f7a746a"
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 |
|---|---|---|---|---|---|---|---|---|
| 5d61ce2d-1923-40b8-86e4-51ae3ff10ae2 | e6578b64-fe7f-432b-a4a1-5d5d1f7a746a | radar | radar evidence from CIA document | unverified | 2026-03-24T20:06:05.665194-04:00 |
Advanced export
JSON shape: default, array, newline-delimited, object
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]);