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/CBMiogFBVV95cUxNRlZMQ3hUQnlTMnJWNkRpVm9oYVRoQmtKTFJoemp1Sjd5dnhVVlBKOHhVb2tsY3E1bnlaelA5UGNaZkdIaGNmdHVEZ211d2FzMjVmY2VDSHp1TnpPblpNY1pUeGlHZmFuQV9odnFDWDBYMHcyWUJDeXJJT2lyeGlQcG9FTWhaMGp1U3lpUzhqSV96MWpDb1JsME1YNV94ZXI2dVE?oc=5","as_of":"2026-04-07T23:23:38.992775+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMiogFBVV95cUxNRlZMQ3hUQnlTMnJWNkRpVm9oYVRoQmtKTFJoemp1Sjd5dnhVVlBKOHhVb2tsY3E1bnlaelA5UGNaZkdIaGNmdHVEZ211d2FzMjVmY2VDSHp1TnpPblpNY1pUeGlHZmFuQV9odnFDWDBYMHcyWUJDeXJJT2lyeGlQcG9FTWhaMGp1U3lpUzhqSV96MWpDb1JsME1YNV94ZXI2dVE?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_46c9e65c179aec6c","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=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-08T00:35:43.620648+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiogFBVV95cUxNRlZMQ3hUQnlTMnJWNkRpVm9oYVRoQmtKTFJoemp1Sjd5dnhVVlBKOHhVb2tsY3E1bnlaelA5UGNaZkdIaGNmdHVEZ211d2FzMjVmY2VDSHp1TnpPblpNY1pUeGlHZmFuQV9odnFDWDBYMHcyWUJDeXJJT2lyeGlQcG9FTWhaMGp1U3lpUzhqSV96MWpDb1JsME1YNV94ZXI2dVE?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"variety.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiogFBVV95cUxNRlZMQ3hUQnlTMnJWNkRpVm9oYVRoQmtKTFJoemp1Sjd5dnhVVlBKOHhVb2tsY3E1bnlaelA5UGNaZkdIaGNmdHVEZ211d2FzMjVmY2VDSHp1TnpPblpNY1pUeGlHZmFuQV9odnFDWDBYMHcyWUJDeXJJT2lyeGlQcG9FTWhaMGp1U3lpUzhqSV96MWpDb1JsME1YNV94ZXI2dVE?oc=5","source_event_id":"evt_b60f293a4fb4","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"34c373352e01f632","published_at":"2026-04-07T17:36:00+00:00","publisher_domain":"variety.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.74,"dates_mentioned":[],"entities":[{"asset_class":"other","name":"Lil Tjay","relevance":"primary subject (arrested)","symbol":"","type":"person"},{"asset_class":"other","name":"Offset","relevance":"victim/target of shooting","symbol":"","type":"person"},{"asset_class":"other","name":"Variety","relevance":"source of headline","symbol":"","type":"publisher"},{"asset_class":"other","name":"Miami Herald","relevance":"supports allegation about directing friends","symbol":"","type":"publisher"},{"asset_class":"other","name":"CNN","relevance":"supports hospitalization and alleged direction","symbol":"","type":"publisher"},{"asset_class":"other","name":"NBC 6 South Florida","relevance":"supports arrest/records framing","symbol":"","type":"publisher"},{"asset_class":"other","name":"WSB-TV","relevance":"supports shooting location and charging","symbol":"","type":"publisher"}],"event_type":"conflict","information_gaps":["Exact date/time of the shooting and arrest are not provided in the supplied text.","Specific charges against Lil Tjay are not enumerated in the supplied text (only that he was charged).","Injury severity/condition details for Offset are not provided beyond being hospitalized.","Whether Lil Tjay\u2019s alleged actions are confirmed by court findings is not stated (only arrest report/records allegations).","No details are provided on the weapon, number of shots, or investigative status beyond the arrest."],"key_facts":["Lil Tjay was arrested in connection with a shooting in Florida involving Offset (Variety).","Offset was shot in Florida and was hospitalized (per provided source summary referencing CNN and others).","Arrest report/records allege Lil Tjay directed friends to attack Offset before the shooting (per provided source summary referencing Miami Herald/CNN).","The shooting is described as occurring in Hollywood, Florida (per provided source summary referencing NBC 6 South Florida/WSB-TV).","Offset is identified as an Atlanta rapper and a member of Migos (per provided source summary referencing NBC 6 South Florida/WSB-TV)."],"numeric_claims":[],"primary_claim":"Lil Tjay was arrested in connection with the shooting of Offset in Florida, with arrest records alleging Lil Tjay directed friends to attack Offset before the shooting.","relevance_score":0.72,"sentiment":"negative","source_quality":"high","summary":"Variety reports that rapper Lil Tjay was arrested in connection with a shooting in Florida involving Atlanta rapper Offset. The reporting indicates Offset was hospitalized and that arrest records allege Lil Tjay directed others to attack Offset before the shooting.","topics":["arrest","shooting","criminal allegations","Offset (Migos)","Lil Tjay"]},"source":"Variety","source_domain":"variety.com","source_url":"https://variety.com","summary":"Rapper Lil Tjay Arrested in Connection With Offset Shooting in Florida Variety Rapper Offset hospitalized after being shot in Florida CNN Lil Tjay directed friends to attack Offset before shooting, arrest report says Miami Herald Rapper Lil Tjay arrested following shooting of Offset in Hollywood, records show NBC 6 South Florida Atlanta rapper Offset, of Migos, shot in Florida; Lil Tjay charged, reports say WSB-TV","title":"Rapper Lil Tjay Arrested in Connection With Offset Shooting in Florida - Variety","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/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_5305a65f1b8b in signals