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/CBMirwFBVV95cUxNT055TEtwRnNkaWpQY2hySUkzUU5TYzdDakVMRHdQMzViRW1xUGxKdHFBemQ5WWZ5MWcteEw3SmVxcnVxYzJjOGI3amZnaEc3NEF1T085dXVMSXpXek00UloyMUtZcTBXa2owTWR0d0pjOTlaSWhia0NweW01MHRaTW1xME1MU2kzeXlMV2Y5SWRiY19pNVJaVFh5S0VjSzQ1REIydjZldnZ4ci1aaGZR?oc=5","as_of":"2026-04-08T02:13:53.785746+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/CBMirwFBVV95cUxNT055TEtwRnNkaWpQY2hySUkzUU5TYzdDakVMRHdQMzViRW1xUGxKdHFBemQ5WWZ5MWcteEw3SmVxcnVxYzJjOGI3amZnaEc3NEF1T085dXVMSXpXek00UloyMUtZcTBXa2owTWR0d0pjOTlaSWhia0NweW01MHRaTW1xME1MU2kzeXlMV2Y5SWRiY19pNVJaVFh5S0VjSzQ1REIydjZldnZ4ci1aaGZR?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_ff4c752e8bc6f361","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-08T02:14:57.231028+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMirwFBVV95cUxNT055TEtwRnNkaWpQY2hySUkzUU5TYzdDakVMRHdQMzViRW1xUGxKdHFBemQ5WWZ5MWcteEw3SmVxcnVxYzJjOGI3amZnaEc3NEF1T085dXVMSXpXek00UloyMUtZcTBXa2owTWR0d0pjOTlaSWhia0NweW01MHRaTW1xME1MU2kzeXlMV2Y5SWRiY19pNVJaVFh5S0VjSzQ1REIydjZldnZ4ci1aaGZR?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"apnews.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMirwFBVV95cUxNT055TEtwRnNkaWpQY2hySUkzUU5TYzdDakVMRHdQMzViRW1xUGxKdHFBemQ5WWZ5MWcteEw3SmVxcnVxYzJjOGI3amZnaEc3NEF1T085dXVMSXpXek00UloyMUtZcTBXa2owTWR0d0pjOTlaSWhia0NweW01MHRaTW1xME1MU2kzeXlMV2Y5SWRiY19pNVJaVFh5S0VjSzQ1REIydjZldnZ4ci1aaGZR?oc=5","source_event_id":"evt_e760b6551a30","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"c235819122858b91","published_at":"2026-04-07T22:41:00+00:00","publisher_domain":"apnews.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.72,"dates_mentioned":[],"entities":[{"asset_class":"equity/none","name":"Offset","relevance":"high","symbol":"","type":"person"},{"asset_class":"none","name":"Migos","relevance":"medium","symbol":"","type":"group"},{"asset_class":"none","name":"Florida casino (Hard Rock Casino referenced in related coverage)","relevance":"high","symbol":"","type":"location"},{"asset_class":"equity/none","name":"Lil Tjay","relevance":"medium","symbol":"","type":"person"}],"event_type":"conflict","information_gaps":["The AP excerpt provided does not include the date/time of the shooting, the specific casino name, or the spokesperson\u2019s identity.","No details are provided here on the severity of injuries, treatment, or whether the shooting is under active investigation.","The relationship between the Offset shooting and Lil Tjay is only mentioned via the provided source summary; the AP article excerpt itself is not included to verify that connection."],"key_facts":["Offset was shot outside a casino in Florida.","A spokesperson says Offset is stable.","Related coverage mentions Lil Tjay leaving jail after an arrest tied to a Hard Rock incident and denying any link to the Offset shooting (details not confirmed in the AP excerpt)."],"numeric_claims":[],"primary_claim":"Offset is stable after being shot outside a Florida casino, per a spokesperson.","relevance_score":0.78,"sentiment":"mixed","source_quality":"high","summary":"AP reports that former Migos rapper Offset is stable after being shot outside a Florida casino, according to a spokesperson. The near-term catalyst is the immediate medical/incident update and any follow-on reporting from law enforcement.","topics":["shooting","celebrity news","medical status update","Florida","casino incident","law enforcement investigation"]},"source":"AP News","source_domain":"apnews.com","source_url":"https://apnews.com","summary":"Former Migos rapper Offset is stable after being shot outside a Florida casino, spokesperson says AP News Rapper Lil Tjay leaves jail after Hard Rock arrest, denies link to Offset shooting: \u2018Hell naw\u2019 WPLG Local 10 Who is Offset? What we know about rapper's Florida shooting USA Today Rapper Lil Tjay arrested following shooting of Offset in Hollywood, records show NBC 6 South Florida Offset Shot Near Florida Casino TMZ","title":"Former Migos rapper Offset is stable after being shot outside a Florida casino, spokesperson says - AP News","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_2a0d299c3359 in signals