SQLite Web: event

seq

Primary key. INTEGER

id

TEXT NOT NULL

kind

TEXT NOT NULL

ts

TEXT NOT NULL

actor

TEXT

subject_entity_ids

TEXT

payload

{"created_at":"2026-04-08T21:48:34.563655+00:00","dedupe_key":"signal_enriched:news_delta:2fd7fa38ba8c3c2a","evidence_event_ids":["evt_79016b468b3d"],"signal_type":"news_headline_delta","source":"news_rss","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

source_ref

TEXT

confidence

REAL (default 0.0

dedupe_key

TEXT

episode_id

TEXT

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

event_store.db — events

Update row 8471 in events