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-08T07:51:57.549128+00:00","dedupe_key":"signal_enriched:news_delta:022deec9bbd1fc46","evidence_event_ids":["evt_de75b868ba68"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMivgFBVV95cUxNNnp6SFdwX3ZVbmF0NVUtMEZyV05SX19sdEVmM3M5a1pPc3RRVnBpZERCcnp4dXV5anVMeHNNZW5LTVY5RDdteTdTTnUwQjdZQlZoczgxc2xyS05fSnVkWWNyc01wLW1xNmxVOWFkVDBJZ192bW1vZHozaXdEcmhfNmJrRFQ0RGpaYXkzdC1kUmlHX3BvNVFlanlWRTdaNVFQRlgzWXRsVWYyOTFRbGJSM20wVUp0VFRhLUptcjlB?oc=5","as_of":"2026-04-08T07:51:57.549128+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAIFAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2OYSmDAUDetpsORI83j3dpsv55GJQ/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMivgFBVV95cUxNNnp6SFdwX3ZVbmF0NVUtMEZyV05SX19sdEVmM3M5a1pPc3RRVnBpZERCcnp4dXV5anVMeHNNZW5LTVY5RDdteTdTTnUwQjdZQlZoczgxc2xyS05fSnVkWWNyc01wLW1xNmxVOWFkVDBJZ192bW1vZHozaXdEcmhfNmJrRFQ0RGpaYXkzdC1kUmlHX3BvNVFlanlWRTdaNVFQRlgzWXRsVWYyOTFRbGJSM20wVUp0VFRhLUptcjlB?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_3036a90e8c28c6e1","canonical_host":"gstatic.com","canonical_is_aggregator":true,"canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAIFAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2OYSmDAUDetpsORI83j3dpsv55GJQ/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-08T07:52:12.258537+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMivgFBVV95cUxNNnp6SFdwX3ZVbmF0NVUtMEZyV05SX19sdEVmM3M5a1pPc3RRVnBpZERCcnp4dXV5anVMeHNNZW5LTVY5RDdteTdTTnUwQjdZQlZoczgxc2xyS05fSnVkWWNyc01wLW1xNmxVOWFkVDBJZ192bW1vZHozaXdEcmhfNmJrRFQ0RGpaYXkzdC1kUmlHX3BvNVFlanlWRTdaNVFQRlgzWXRsVWYyOTFRbGJSM20wVUp0VFRhLUptcjlB?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"reuters.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMivgFBVV95cUxNNnp6SFdwX3ZVbmF0NVUtMEZyV05SX19sdEVmM3M5a1pPc3RRVnBpZERCcnp4dXV5anVMeHNNZW5LTVY5RDdteTdTTnUwQjdZQlZoczgxc2xyS05fSnVkWWNyc01wLW1xNmxVOWFkVDBJZ192bW1vZHozaXdEcmhfNmJrRFQ0RGpaYXkzdC1kUmlHX3BvNVFlanlWRTdaNVFQRlgzWXRsVWYyOTFRbGJSM20wVUp0VFRhLUptcjlB?oc=5","source_event_id":"evt_de75b868ba68","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"3804784959c78564","published_at":"2026-04-08T02:07:32+00:00","publisher_domain":"reuters.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.78,"dates_mentioned":[],"entities":[{"asset_class":"sovereign","name":"Iran","relevance":"high","symbol":"","type":"country"},{"asset_class":"commodity","name":"Physical oil markets","relevance":"high","symbol":"","type":"market"}],"event_type":"geopolitical_risk","information_gaps":["No details are provided on the ceasefire terms, start date, duration, or parties involved beyond the headline.","No specific indicators of \u201cstressed\u201d physical oil markets are included (e.g., spreads, inventories, shipping constraints).","No asset tickers or specific tradable instruments are mentioned in the provided text."],"key_facts":["Reuters headline states that an Iran ceasefire provides hope.","Reuters headline states that physical oil markets will remain stressed."],"numeric_claims":[],"primary_claim":"Even with an Iran ceasefire, physical oil markets are likely to stay stressed.","relevance_score":0.72,"sentiment":"mixed","source_quality":"high","summary":"Reuters reports that an Iran ceasefire offers some hope, but physical oil markets are expected to remain stressed.","topics":["Iran ceasefire","oil markets","physical crude supply/demand conditions","market stress"]},"source":"Reuters","source_domain":"reuters.com","source_url":"https://www.reuters.com","summary":"Iran ceasefire provides hope, but physical oil markets to remain stressed Reuters","title":"Iran ceasefire provides hope, but physical oil markets to remain stressed - Reuters","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAIFAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2OYSmDAUDetpsORI83j3dpsv55GJQ/m=syndicationarticleview,_b,_tp"}}

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 5304 in events