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/CBMixwFBVV95cUxNQ3dqMWNRWG5Bc0FFXzlmSUpQZU5kcUt5a01CS0tEdHZsdmNMQURXeHFNVUkxNExnSkZ2Y2pFTjhWYWVTS3N3a1pHYlZHeVVSNDBMWU1aNm1lb1NQSURaQzFZTUxyVVBqbFFlTUUzTE03WWpxQ3pwakJoYnE5cDFMaTVQeExXQzBYcUpFY1lJbkwzeDNCbkw3RmFXT040LThEbzhrVC0tNUFuQmRyNnZSYWxBUDJNcUttWWdRc1hIaElQUHFUc3NZ?oc=5","as_of":"2026-04-08T06:36:01.627358+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/CBMixwFBVV95cUxNQ3dqMWNRWG5Bc0FFXzlmSUpQZU5kcUt5a01CS0tEdHZsdmNMQURXeHFNVUkxNExnSkZ2Y2pFTjhWYWVTS3N3a1pHYlZHeVVSNDBMWU1aNm1lb1NQSURaQzFZTUxyVVBqbFFlTUUzTE03WWpxQ3pwakJoYnE5cDFMaTVQeExXQzBYcUpFY1lJbkwzeDNCbkw3RmFXT040LThEbzhrVC0tNUFuQmRyNnZSYWxBUDJNcUttWWdRc1hIaElQUHFUc3NZ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_e644f2be9997489f","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-08T06:36:46.094078+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMixwFBVV95cUxNQ3dqMWNRWG5Bc0FFXzlmSUpQZU5kcUt5a01CS0tEdHZsdmNMQURXeHFNVUkxNExnSkZ2Y2pFTjhWYWVTS3N3a1pHYlZHeVVSNDBMWU1aNm1lb1NQSURaQzFZTUxyVVBqbFFlTUUzTE03WWpxQ3pwakJoYnE5cDFMaTVQeExXQzBYcUpFY1lJbkwzeDNCbkw3RmFXT040LThEbzhrVC0tNUFuQmRyNnZSYWxBUDJNcUttWWdRc1hIaElQUHFUc3NZ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"pbs.org","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMixwFBVV95cUxNQ3dqMWNRWG5Bc0FFXzlmSUpQZU5kcUt5a01CS0tEdHZsdmNMQURXeHFNVUkxNExnSkZ2Y2pFTjhWYWVTS3N3a1pHYlZHeVVSNDBMWU1aNm1lb1NQSURaQzFZTUxyVVBqbFFlTUUzTE03WWpxQ3pwakJoYnE5cDFMaTVQeExXQzBYcUpFY1lJbkwzeDNCbkw3RmFXT040LThEbzhrVC0tNUFuQmRyNnZSYWxBUDJNcUttWWdRc1hIaElQUHFUc3NZ?oc=5","source_event_id":"evt_fc873213b032","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"6cce81cf28a04185","published_at":"2026-04-07T20:14:07+00:00","publisher_domain":"pbs.org","signal_understanding":{"analysis_basis":"article","claim_confidence":0.74,"dates_mentioned":[],"entities":[{"asset_class":"equity/crypto/none","name":"Offset","relevance":"high","symbol":"","type":"person"},{"asset_class":"none","name":"Migos","relevance":"medium","symbol":"","type":"group"},{"asset_class":"none","name":"Lil Tjay","relevance":"high","symbol":"","type":"person"},{"asset_class":"none","name":"Hard Rock Casino","relevance":"medium","symbol":"","type":"location"},{"asset_class":"none","name":"Florida","relevance":"high","symbol":"","type":"location"}],"event_type":"conflict","information_gaps":["The cleaned article text provided contains no readable body content beyond page styling; extraction is therefore based on the provided headline and source summary rather than full article details.","No specific injury severity, treatment status, or timeline (date/time of shooting; when spokesperson statement was made) is included in the provided text.","The exact legal basis for Lil Tjay\u2019s arrest (charges, court filings) is not included in the provided text.","No details on suspects, motive, or weapon are provided in the supplied material."],"key_facts":["PBS: Offset is reported to be in stable condition after being shot in Florida, per a spokesperson.","The shooting occurred outside a Florida casino (Hard Rock Casino is referenced in the source summary).","Other referenced outlets (AP News, Yahoo, NBC 6 South Florida) indicate Offset spoke out for the first time since the shooting.","Other referenced outlets (NBC 6 South Florida) report that Lil Tjay was arrested in connection with the Offset shooting in Hollywood, Florida (records show)."],"numeric_claims":[],"primary_claim":"Offset is in stable condition after being shot outside a Florida casino, according to a spokesperson (PBS).","relevance_score":0.72,"sentiment":"mixed","source_quality":"high","summary":"PBS reports that former Migos rapper Offset is in stable condition after being shot in Florida, according to a spokesperson. The incident is linked to an arrest of rapper Lil Tjay in connection with the shooting, per other referenced outlets.","topics":["shooting","celebrity","medical condition","arrest","Florida","Hard Rock Casino"]},"source":"PBS","source_domain":"pbs.org","source_url":"https://www.pbs.org","summary":"Former Migos rapper Offset in stable condition after being shot in Florida, spokesperson says PBS Former Migos rapper Offset is stable after being shot outside a Florida casino, spokesperson says AP News Rapper Offset speaks out for the first time since he was shot outside Hard Rock Casino Yahoo Rapper Lil Tjay arrested in connection with Offset shooting in Florida NBC News Rapper Lil Tjay arrested following shooting of Offset in Hollywood, records show NBC 6 South Florida","title":"Former Migos rapper Offset in stable condition after being shot in Florida, spokesperson says - PBS","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_403c6b7420c5 in signals