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/CBMi1AFBVV95cUxQUUpWRjRqQjlpTnA5a3dlOVozSC1VZTVLRDdXOGNicEhvTVBCRDJQQ21hX081bG9qWHdHbWlGeWFMVkZUSW9WZ1ZtY1VkbVM5NEZmOG5lbUpMZHc0eWVkUzloVDQxM2dsOV81N3F4b0ZXNW0xYzlZdjlERDU1dENkT25sbzQxbXBTLTVjWWw3dXQyclg0bWJDLWhxdUIwMUJ1ZkYteUNfOF9EU2FMMnVPemxnUWFBNjRpaHRDT2IyODhEbThmczFmSkVwLWpjd1liT1U3MA?oc=5","as_of":"2026-04-07T23:23:38.933193+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/CBMi1AFBVV95cUxQUUpWRjRqQjlpTnA5a3dlOVozSC1VZTVLRDdXOGNicEhvTVBCRDJQQ21hX081bG9qWHdHbWlGeWFMVkZUSW9WZ1ZtY1VkbVM5NEZmOG5lbUpMZHc0eWVkUzloVDQxM2dsOV81N3F4b0ZXNW0xYzlZdjlERDU1dENkT25sbzQxbXBTLTVjWWw3dXQyclg0bWJDLWhxdUIwMUJ1ZkYteUNfOF9EU2FMMnVPemxnUWFBNjRpaHRDT2IyODhEbThmczFmSkVwLWpjd1liT1U3MA?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_b1c8325a0355f8c6","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-08T00:35:32.159385+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMi1AFBVV95cUxQUUpWRjRqQjlpTnA5a3dlOVozSC1VZTVLRDdXOGNicEhvTVBCRDJQQ21hX081bG9qWHdHbWlGeWFMVkZUSW9WZ1ZtY1VkbVM5NEZmOG5lbUpMZHc0eWVkUzloVDQxM2dsOV81N3F4b0ZXNW0xYzlZdjlERDU1dENkT25sbzQxbXBTLTVjWWw3dXQyclg0bWJDLWhxdUIwMUJ1ZkYteUNfOF9EU2FMMnVPemxnUWFBNjRpaHRDT2IyODhEbThmczFmSkVwLWpjd1liT1U3MA?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"nbcsports.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMi1AFBVV95cUxQUUpWRjRqQjlpTnA5a3dlOVozSC1VZTVLRDdXOGNicEhvTVBCRDJQQ21hX081bG9qWHdHbWlGeWFMVkZUSW9WZ1ZtY1VkbVM5NEZmOG5lbUpMZHc0eWVkUzloVDQxM2dsOV81N3F4b0ZXNW0xYzlZdjlERDU1dENkT25sbzQxbXBTLTVjWWw3dXQyclg0bWJDLWhxdUIwMUJ1ZkYteUNfOF9EU2FMMnVPemxnUWFBNjRpaHRDT2IyODhEbThmczFmSkVwLWpjd1liT1U3MA?oc=5","source_event_id":"evt_8b40ed3599a8","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"29b49d8b09c0a105","published_at":"2026-04-07T17:51:02+00:00","publisher_domain":"nbcsports.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.74,"dates_mentioned":[],"entities":[{"asset_class":"sports_person","name":"John Harbaugh","relevance":"high","symbol":"","type":"person"},{"asset_class":"sports_person","name":"Dexter Lawrence","relevance":"high","symbol":"","type":"person"},{"asset_class":"sports_team","name":"New York Giants","relevance":"high","symbol":"NYG","type":"organization"},{"asset_class":"media_outlet","name":"NBC Sports","relevance":"medium","symbol":"","type":"organization"}],"event_type":"other","information_gaps":["The cleaned article text provided is largely HTML/CSS and does not contain the actual quote content; only the headline and the provided source summary were usable.","No specific timing (e.g., trade deadline date) is stated in the provided material.","No details are provided on Lawrence\u2019s salary demands beyond a mention in the source summary; exact figures are not included.","It is not confirmed from the provided text that Lawrence will definitively remain; Harbaugh\u2019s statement is predictive/optimistic rather than a confirmation."],"key_facts":["NBC Sports headline states: \u201cJohn Harbaugh: I think prospects are high Dexter Lawrence remains with Giants.\u201d","The provided source summary indicates Lawrence was absent from Giants workouts.","The provided source summary indicates Harbaugh is optimistic about Lawrence remaining with the Giants."],"numeric_claims":[],"primary_claim":"John Harbaugh said he thinks the prospects are high that Dexter Lawrence remains with the Giants.","relevance_score":0.62,"sentiment":"mixed","source_quality":"high","summary":"NBC Sports reports that John Harbaugh said he believes the prospects are high that Dexter Lawrence will remain with the New York Giants. The context suggests Lawrence has been absent from Giants workouts, but Harbaugh is optimistic about his staying.","topics":["NFL","player contract/trade speculation","Dexter Lawrence","Giants roster","workouts/availability","public comments"]},"source":"NBC Sports","source_domain":"nbcsports.com","source_url":"https://www.nbcsports.com","summary":"John Harbaugh: I think prospects are high Dexter Lawrence remains with Giants NBC Sports Lawrence absent from Giants workouts, but Harbaugh optimistic ESPN New York Giants\u2019 star defender Dexter Lawrence salary demands revealed sports.yahoo.com Dexter Lawrence landing spots: Eight potential destinations for Giants star DT NFL.com What's next for Dexter Lawrence and Giants following trade request? Opposing teams weigh in sny.tv","title":"John Harbaugh: I think prospects are high Dexter Lawrence remains with Giants - NBC Sports","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_381775cc610b in signals