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/CBMiigFBVV95cUxQZnFxTW5nTFYtVW96cjVfUExhUDhDMWM4VTRpWmJRQlc3WTZlMmVNUnFzSFlGbENjU2VfVUkyZ3dlSGhXeFRGckhpME5UZEw2TFdSNlVNejBQMVB5YmprUDgyQWJZV1dWVS04WE9wUUg3QUlQUHJKTklzLTNJLTl1YVUtc3RvTll0SUE?oc=5","as_of":"2026-04-08T21:48:34.563655+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/CBMiigFBVV95cUxQZnFxTW5nTFYtVW96cjVfUExhUDhDMWM4VTRpWmJRQlc3WTZlMmVNUnFzSFlGbENjU2VfVUkyZ3dlSGhXeFRGckhpME5UZEw2TFdSNlVNejBQMVB5YmprUDgyQWJZV1dWVS04WE9wUUg3QUlQUHJKTklzLTNJLTl1YVUtc3RvTll0SUE?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_4f30017e3cb1b762","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:15:17.006827+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiigFBVV95cUxQZnFxTW5nTFYtVW96cjVfUExhUDhDMWM4VTRpWmJRQlc3WTZlMmVNUnFzSFlGbENjU2VfVUkyZ3dlSGhXeFRGckhpME5UZEw2TFdSNlVNejBQMVB5YmprUDgyQWJZV1dWVS04WE9wUUg3QUlQUHJKTklzLTNJLTl1YVUtc3RvTll0SUE?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"nfl.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiigFBVV95cUxQZnFxTW5nTFYtVW96cjVfUExhUDhDMWM4VTRpWmJRQlc3WTZlMmVNUnFzSFlGbENjU2VfVUkyZ3dlSGhXeFRGckhpME5UZEw2TFdSNlVNejBQMVB5YmprUDgyQWJZV1dWVS04WE9wUUg3QUlQUHJKTklzLTNJLTl1YVUtc3RvTll0SUE?oc=5","source_event_id":"evt_79016b468b3d","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"2418bd268d2821a6","published_at":"2026-04-08T18:01:00+00:00","publisher_domain":"nfl.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":["2026"],"entities":[{"asset_class":"media","name":"NFL.com","relevance":"high","symbol":"","type":"publisher"},{"asset_class":"sports_league","name":"AFC teams","relevance":"high","symbol":"","type":"sports_league_division"},{"asset_class":"sports_event","name":"2026 NFL Draft","relevance":"high","symbol":"","type":"event"},{"asset_class":"sports_team","name":"Jacksonville Jaguars","relevance":"medium","symbol":"JAX","type":"team"},{"asset_class":"person","name":"Rhett Lewis","relevance":"medium","symbol":"","type":"author"},{"asset_class":"media","name":"ESPN","relevance":"medium","symbol":"","type":"publisher"},{"asset_class":"person","name":"Schrager","relevance":"medium","symbol":"","type":"author"},{"asset_class":"media","name":"New York Times","relevance":"low","symbol":"","type":"publisher"}],"event_type":"other","information_gaps":["The article text itself is not present in the cleaned content (only page styling/HTML fragments), so the specific \u201cone goal\u201d for each AFC team is not extractable from the provided material.","No timing details (e.g., when the draft needs are assessed or when the article was published) are included in the provided text.","The specific teams (beyond Jacksonville Jaguars and an \u201cEagles\u201d reference in the summary) and their corresponding \u201cone goal\u201d are not enumerated in the provided content."],"key_facts":["The headline is: \u201c2026 NFL Draft needs: The one goal each AFC team must nail - NFL.com.\u201d","The provided source summary includes: \u201c2026 NFL mock draft: Schrager projects 32 first-round picks.\u201d","The provided source summary includes a reference to \u201cWhere to Watch the 2026 NFL Draft\u201d and \u201cJacksonville Jaguars Rhett Lewis.\u201d","The provided source summary includes: \u201c2026 NFL mock draft 1.0: Eagles make biggest splash in Round 1 NFL.com.\u201d","The provided source summary includes: \u201cExplore over 2,700 NFL Draft prospects in The Beast 2026 The New York Times.\u201d"],"numeric_claims":[{"label":"first-round picks projected","value":"32"}],"primary_claim":"NFL.com\u2019s article states that each AFC team has \u201cthe one goal\u201d it must nail for the 2026 NFL Draft.","relevance_score":0.35,"sentiment":"neutral","source_quality":"high","summary":"NFL.com published a piece framing the 2026 NFL Draft as a set of team-specific needs for each AFC team, expressed as \u201cthe one goal each AFC team must nail.\u201d The headline also references a 2026 NFL mock draft projecting 32 first-round picks.","topics":["2026 NFL Draft","AFC team needs","NFL mock draft","first-round picks","team-specific draft strategy"]},"source":"NFL.com","source_domain":"nfl.com","source_url":"https://www.nfl.com","summary":"2026 NFL Draft needs: The one goal each AFC team must nail NFL.com 2026 NFL mock draft: Schrager projects 32 first-round picks ESPN Where to Watch the 2026 NFL Draft Jacksonville Jaguars Rhett Lewis 2026 NFL mock draft 1.0: Eagles make biggest splash in Round 1 NFL.com Explore over 2,700 NFL Draft prospects in The Beast 2026 The New York Times","title":"2026 NFL Draft needs: The one goal each AFC team must nail - NFL.com","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_6becd6d44745 in signals