SQLite Web: event

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

value

{"aggregator_url":"https://news.google.com/rss/articles/CBMimwFBVV95cUxNQkJiamNrQlJxU0FqcVplQTh4QVItYlVhV3JZcW5UcDlsNTBpeXNvUjBYRklHVmVFdXBIM3JlNmFwTkpNSGtfRWlGX2puejZwMV9Vb0MyLTNWNzY4aXJBZTZrLXBQZ1FTX2ZMMktiOC1ha3h2X2VyLUFyZkpmOWMzQUIyajUzRjNEdm5OM3R3aC15NmZwQVg3Um5jYw?oc=5","as_of":"2026-04-10T01:56:34.499639+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/CBMimwFBVV95cUxNQkJiamNrQlJxU0FqcVplQTh4QVItYlVhV3JZcW5UcDlsNTBpeXNvUjBYRklHVmVFdXBIM3JlNmFwTkpNSGtfRWlGX2puejZwMV9Vb0MyLTNWNzY4aXJBZTZrLXBQZ1FTX2ZMMktiOC1ha3h2X2VyLUFyZkpmOWMzQUIyajUzRjNEdm5OM3R3aC15NmZwQVg3Um5jYw?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_57b97cafeddabb33","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-10T01:58:20.242512+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMimwFBVV95cUxNQkJiamNrQlJxU0FqcVplQTh4QVItYlVhV3JZcW5UcDlsNTBpeXNvUjBYRklHVmVFdXBIM3JlNmFwTkpNSGtfRWlGX2puejZwMV9Vb0MyLTNWNzY4aXJBZTZrLXBQZ1FTX2ZMMktiOC1ha3h2X2VyLUFyZkpmOWMzQUIyajUzRjNEdm5OM3R3aC15NmZwQVg3Um5jYw?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"yahoo.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMimwFBVV95cUxNQkJiamNrQlJxU0FqcVplQTh4QVItYlVhV3JZcW5UcDlsNTBpeXNvUjBYRklHVmVFdXBIM3JlNmFwTkpNSGtfRWlGX2puejZwMV9Vb0MyLTNWNzY4aXJBZTZrLXBQZ1FTX2ZMMktiOC1ha3h2X2VyLUFyZkpmOWMzQUIyajUzRjNEdm5OM3R3aC15NmZwQVg3Um5jYw?oc=5","source_event_id":"evt_ca085219c709","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"1fb2cb9b369a58a6","published_at":"2026-04-09T19:21:32+00:00","publisher_domain":"yahoo.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"","name":"Abbey Romeo","relevance":"high","symbol":"","type":"person"},{"asset_class":"","name":"David Isaacman","relevance":"high","symbol":"","type":"person"},{"asset_class":"","name":"Love On The Spectrum","relevance":"medium","symbol":"","type":"tv_show"},{"asset_class":"","name":"Yahoo","relevance":"medium","symbol":"","type":"publisher"}],"event_type":"other","information_gaps":["Whether the couple confirmed the breakup is not stated in the provided text (reportedly only).","Exact timing/date of the split is not provided.","Details of the disagreement over marriage are not provided.","No direct quotes or primary documentation are included in the provided excerpt."],"key_facts":["Yahoo headline states Abbey and David (Love On The Spectrum) reportedly split after 5 years together.","The provided source summary indicates the split followed a disagreement over marriage."],"numeric_claims":[{"label":"relationship duration","value":"5 years"}],"primary_claim":"Abbey Romeo and David Isaacman reportedly split after 5 years together following disagreement over marriage.","relevance_score":0.22,"sentiment":"negative","source_quality":"high","summary":"Yahoo reports that \u201cLove On The Spectrum\u201d couple Abbey Romeo and David Isaacman have reportedly split after five years together. The reported reason involves disagreement over marriage.","topics":["celebrity news","relationship breakup","reality television","marriage disagreement"]},"source":"Yahoo","source_domain":"yahoo.com","source_url":"https://www.yahoo.com","summary":"\u2018Love On The Spectrum\u2019 Couple Abbey and David Reportedly Split After 5 Years Together Yahoo Love on the Spectrum couple Abbey and David SPLIT after 5 years together following 'disagreement over marriage' the-sun.com 'Love on the Spectrum' Stars Abbey Romeo and David Isaacman Break Up People.com Did Love on the Spectrum\u2019s Abbey and David Breakup? Vulture Love on the Spectrum\u2019s Abbey Romeo and David Isaacman Break Up After 5 Years E! News","title":"\u2018Love On The Spectrum\u2019 Couple Abbey and David Reportedly Split After 5 Years Together - Yahoo","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

threshold

TEXT

direction

TEXT

severity

TEXT

window

TEXT

source

TEXT NOT NULL

reason_trace

TEXT

dedupe_key

TEXT NOT NULL

throttle_s

INTEGER (default 0

created_at

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

event_store.db — signals

Update row sig_bd274c6aec7f in signals