SQLite Web: event

seq

Primary key. INTEGER

id

TEXT NOT NULL

kind

TEXT NOT NULL

ts

TEXT NOT NULL

actor

TEXT

subject_entity_ids

TEXT

payload

{"created_at":"2026-04-03T11:17:56.444213+00:00","signal_type":"opportunity_research_snapshot","source":"opportunity_research_ingestor","value":{"as_of":"2026-04-03T11:17:56.444213+00:00","bucket":"2026-04-03T11:00Z","items":[{"fp":"87dc7fcf40131536","provider":"serper","published_at":"2026-04-03T11:17:56.444213+00:00","quality_hint":1.0,"query":"IDF official says conflicting reports resolution primary sources","snippet":"The IDF stated on April 1 that it struck \u201capproximately 15 weapons production sites,\u201d including a Ministry of Defense and Armed Forces Logistics (MODAFL) ...","source":"web_search","source_url":"https://understandingwar.org/research/middle-east/iran-update-special-report-april-1-2026/","summary":"The IDF stated on April 1 that it struck \u201capproximately 15 weapons production sites,\u201d including a Ministry of Defense and Armed Forces Logistics (MODAFL) ...","title":"Iran Update Special Report, April 1, 2026 | ISW","url":"https://understandingwar.org/research/middle-east/iran-update-special-report-april-1-2026/"},{"fp":"0ebd40729b90a8fe","provider":"serper","published_at":"2026-04-03T11:17:56.444213+00:00","quality_hint":1.0,"query":"IDF official says conflicting reports resolution primary sources","snippet":"The IDF stated on April 1 that it struck \u201capproximately 15 weapons production sites,\u201d including a Ministry of Defense and Armed Forces Logistics (MODAFL) ...","source":"web_search","source_url":"https://www.criticalthreats.org/analysis/iran-update-evening-special-report-april-1-2026","summary":"The IDF stated on April 1 that it struck \u201capproximately 15 weapons production sites,\u201d including a Ministry of Defense and Armed Forces Logistics (MODAFL) ...","title":"Iran Update Evening Special Report, April 1, 2026 | Critical Threats","url":"https://www.criticalthreats.org/analysis/iran-update-evening-special-report-april-1-2026"},{"fp":"a21a945be1431fa7","provider":"serper","published_at":"2026-04-03T11:17:56.444213+00:00","quality_hint":1.0,"query":"IDF official says conflicting reports resolution primary sources","snippet":"Iran attacked and set on fire a massive Kuwaiti oil tanker off Dubai overnight, as Gulf states increasingly suffer the fallout from the war.","source":"web_search","source_url":"https://www.npr.org/2026/03/31/nx-s1-5766991/iran-war-lebanon-israel-dubai","summary":"Iran attacked and set on fire a massive Kuwaiti oil tanker off Dubai overnight, as Gulf states increasingly suffer the fallout from the war.","title":"Iran hits oil tanker off Dubai as fighting continues on all fronts - NPR","url":"https://www.npr.org/2026/03/31/nx-s1-5766991/iran-war-lebanon-israel-dubai"},{"fp":"5236e34aeddcddad","provider":"serper","published_at":"2026-04-03T11:17:56.444213+00:00","quality_hint":1.0,"query":"IDF official says conflicting reports resolution primary sources","snippet":"Information War - US Israel discredited There is another dimension of this current conflict in terms on how the three main waring states controlled information, ...","source":"web_search","source_url":"https://www.facebook.com/gohmengseng.freedom/posts/information-war-us-israel-discredited-there-is-another-dimension-of-this-current/10238258085844244/","summary":"Information War - US Israel discredited There is another dimension of this current conflict in terms on how the three main waring states controlled information, ...","title":"Information War - US Israel discredited There is another dimension ...","url":"https://www.facebook.com/gohmengseng.freedom/posts/information-war-us-israel-discredited-there-is-another-dimension-of-this-current/10238258085844244/"},{"fp":"3c9a98a1779d7bcb","provider":"serper","published_at":"2026-04-03T11:17:56.444213+00:00","quality_hint":1.0,"query":"IDF official says conflicting reports resolution primary sources","snippet":"See this important statement from PM Mark Carney on the utter illegality of the current invasions of Iran and Lebanon by Israel and the IDF. We appreciate the ...","source":"web_search","source_url":"https://www.facebook.com/NCCMuslims/posts/see-this-important-statement-from-pm-mark-carney-on-the-utter-illegality-of-the-/1396372829190061/","summary":"See this important statement from PM Mark Carney on the utter illegality of the current invasions of Iran and Lebanon by Israel and the IDF. We appreciate the ...","title":"See this important statement from PM Mark Carney on the utter ...","url":"https://www.facebook.com/NCCMuslims/posts/see-this-important-statement-from-pm-mark-carney-on-the-utter-illegality-of-the-/1396372829190061/"},{"fp":"39bd9cffcaa95054","provider":"serper","published_at":"2026-04-03T11:17:56.444213+00:00","quality_hint":1.0,"query":"IDF official says conflicting reports resolution primary sources","snippet":"A US fighter jet has been shot down, Iranian media claims, and pictures show the extent of a deadly bridge strike in Iran. Meanwhile, Donald Trump has also ...","source":"web_search","source_url":"https://news.sky.com/story/iran-war-latest-trump-tehran-us-israel-kharg-island-netanyahu-lebanon-strikes-drone-live-sky-news-13509565","summary":"A US fighter jet has been shot down, Iranian media claims, and pictures show the extent of a deadly bridge strike in Iran. Meanwhile, Donald Trump has also ...","title":"Iran war latest: US jet shot down, Iranian media claims - Sky News","url":"https://news.sky.com/story/iran-war-latest-trump-tehran-us-israel-kharg-island-netanyahu-lebanon-strikes-drone-live-sky-news-13509565"}],"meta":{},"provider":"serper","quality_hint":1.0,"query":"IDF official says conflicting reports resolution primary sources","source":"opportunity_research_ingestor","source_ref":"targeted_research:case_53b9481ecbc4283f","status":"ok"}}

TEXT NOT NULL

source_ref

TEXT

confidence

REAL (default 0.0

dedupe_key

TEXT

episode_id

TEXT

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

event_store.db — events

Update row 1187 in events