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/CBMigwFBVV95cUxNZU9UQ25mUE55WDl5QUp0ZHd0UUNfTU5WMGdpVk5BZ21rRy1qNi1VSzZUdGZWUVhuMlNwcEN2RGM4UTlWWTVjMWlNNVJmMm1tNkpsZWxwVG4xd1I5SU5DTFBMMWpIenZEUVYwOWpQeVo2T3pjUjkzdlY2Ykh1blhHU3oyMA?oc=5","as_of":"2026-04-09T02:28:02.084141+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/CBMigwFBVV95cUxNZU9UQ25mUE55WDl5QUp0ZHd0UUNfTU5WMGdpVk5BZ21rRy1qNi1VSzZUdGZWUVhuMlNwcEN2RGM4UTlWWTVjMWlNNVJmMm1tNkpsZWxwVG4xd1I5SU5DTFBMMWpIenZEUVYwOWpQeVo2T3pjUjkzdlY2Ykh1blhHU3oyMA?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_8664f35856bd4ee6","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-09T22:28:03.081676+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMigwFBVV95cUxNZU9UQ25mUE55WDl5QUp0ZHd0UUNfTU5WMGdpVk5BZ21rRy1qNi1VSzZUdGZWUVhuMlNwcEN2RGM4UTlWWTVjMWlNNVJmMm1tNkpsZWxwVG4xd1I5SU5DTFBMMWpIenZEUVYwOWpQeVo2T3pjUjkzdlY2Ykh1blhHU3oyMA?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"nz.news.yahoo.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMigwFBVV95cUxNZU9UQ25mUE55WDl5QUp0ZHd0UUNfTU5WMGdpVk5BZ21rRy1qNi1VSzZUdGZWUVhuMlNwcEN2RGM4UTlWWTVjMWlNNVJmMm1tNkpsZWxwVG4xd1I5SU5DTFBMMWpIenZEUVYwOWpQeVo2T3pjUjkzdlY2Ykh1blhHU3oyMA?oc=5","source_event_id":"evt_e188130c30c7","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"fb4dc46e4d372cf5","published_at":"2026-04-08T19:50:00+00:00","publisher_domain":"nz.news.yahoo.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"person","name":"Offset","relevance":"directly involved/quoted","symbol":"","type":"person"},{"asset_class":"person","name":"Lil Tjay","relevance":"accused/target of \u201crat\u201d claim; also reported arrested/charged","symbol":"","type":"person"},{"asset_class":"event","name":"Offset casino shooting (Florida)","relevance":"incident context for the dispute","symbol":"","type":"event"}],"event_type":"conflict","information_gaps":["The cleaned article text provided contains only HTML/CSS and does not include the actual article content, so details like dates, charges, and specific statements are not verifiable from the provided text.","The exact wording and context of Offset\u2019s \u201crat\u201d comment are not present in the provided content\u2014only the headline/source summary indicates it.","No information is provided here about the outcome of the arrest/charges (e.g., court dates, specific charge types, or whether Offset was a victim/witness/defendant).","Near-term catalyst timing (e.g., upcoming court appearance or further statements) is not specified in the provided material."],"key_facts":["Offset publicly addressed a shooting incident involving a casino in Florida (per the provided headline/source summary).","Offset criticized Lil Tjay\u2019s claims and called Lil Tjay a \u201crat\u201d (per the provided headline).","Lil Tjay is reported as arrested and charged in connection with the Offset casino shooting in Florida (per the provided source summary)."],"numeric_claims":[],"primary_claim":"Offset addressed the shooting and blasted Lil Tjay\u2019s claims by calling him a \u201crat.\u201d","relevance_score":0.72,"sentiment":"mixed","source_quality":"high","summary":"The headline reports that Offset addressed a shooting incident and criticized Lil Tjay\u2019s claims by calling him a \u201crat.\u201d The related coverage also states Lil Tjay was arrested and charged in connection with the Offset casino shooting in Florida.","topics":["shooting incident","public dispute","criminal charges/arrest","rap music celebrity news"]},"source":"Yahoo News New Zealand","source_domain":"nz.news.yahoo.com","source_url":"https://nz.news.yahoo.com","summary":"Offset addresses shooting, blasts Lil Tjay claim he\u2019s a \u2018rat\u2019 Yahoo News New Zealand Lil Tjay Arrested and Charged in Connection With Offset Casino Shooting in Florida Rolling Stone Rapper Lil Tjay arrested in connection with Offset shooting; calls him a \u2018rat\u2019 AJC.com Rapper Breaks Silence After Being Shot Outside Casino The Daily Beast Rapper Lil Tjay arrested in connection with Offset shooting in Florida NBC News","title":"Offset addresses shooting, blasts Lil Tjay claim he\u2019s a \u2018rat\u2019 - Yahoo News New Zealand","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_8d7d26e34772 in signals