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/CBMitAFBVV95cUxONGRoQVA2NFdlRjd2T2N5SDhsbjFLT09LUlpYOXpvb0ZzUVRRU3pJVkJQZmlhdEVrelp3QWhYcnFWeGZnV0lnS3otVUlNbC1JWTdTY3J6ZHozNlJoVTc0YXViY2l1RkFuZ2lyd2JNS3dSX0lzZHRfSk1ZTlJWUVI2T2w2TmRNeWl0ZXIwYUJmLUVWbEc3dmhKS1FzQWVjMlFKXzRDYk9ycWNHbUtkR3JnQWVnTW0?oc=5","as_of":"2026-04-08T08:52:34.450623+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/CBMitAFBVV95cUxONGRoQVA2NFdlRjd2T2N5SDhsbjFLT09LUlpYOXpvb0ZzUVRRU3pJVkJQZmlhdEVrelp3QWhYcnFWeGZnV0lnS3otVUlNbC1JWTdTY3J6ZHozNlJoVTc0YXViY2l1RkFuZ2lyd2JNS3dSX0lzZHRfSk1ZTlJWUVI2T2w2TmRNeWl0ZXIwYUJmLUVWbEc3dmhKS1FzQWVjMlFKXzRDYk9ycWNHbUtkR3JnQWVnTW0?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_da49efe076d0aea2","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-08T08:53:08.395556+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMitAFBVV95cUxONGRoQVA2NFdlRjd2T2N5SDhsbjFLT09LUlpYOXpvb0ZzUVRRU3pJVkJQZmlhdEVrelp3QWhYcnFWeGZnV0lnS3otVUlNbC1JWTdTY3J6ZHozNlJoVTc0YXViY2l1RkFuZ2lyd2JNS3dSX0lzZHRfSk1ZTlJWUVI2T2w2TmRNeWl0ZXIwYUJmLUVWbEc3dmhKS1FzQWVjMlFKXzRDYk9ycWNHbUtkR3JnQWVnTW0?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"nypost.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMitAFBVV95cUxONGRoQVA2NFdlRjd2T2N5SDhsbjFLT09LUlpYOXpvb0ZzUVRRU3pJVkJQZmlhdEVrelp3QWhYcnFWeGZnV0lnS3otVUlNbC1JWTdTY3J6ZHozNlJoVTc0YXViY2l1RkFuZ2lyd2JNS3dSX0lzZHRfSk1ZTlJWUVI2T2w2TmRNeWl0ZXIwYUJmLUVWbEc3dmhKS1FzQWVjMlFKXzRDYk9ycWNHbUtkR3JnQWVnTW0?oc=5","source_event_id":"evt_347c0e622791","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"6e657e35c1b1311a","published_at":"2026-04-08T01:38:00+00:00","publisher_domain":"nypost.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"nfl_team_person","name":"John Harbaugh","relevance":"high","symbol":"","type":"person"},{"asset_class":"nfl_player","name":"Dexter Lawrence","relevance":"high","symbol":"","type":"person"},{"asset_class":"nfl_team","name":"New York Giants","relevance":"high","symbol":"NYG","type":"organization"},{"asset_class":"nfl_player","name":"Giants defensive tackle Dexter Lawrence","relevance":"high","symbol":"","type":"person"}],"event_type":"conflict","information_gaps":["The cleaned article text provided is mostly HTML/CSS and does not contain the actual narrative content; extraction relies on the supplied headline and source summary.","No specific trade terms, timeline, or whether the Giants have agreed to trade Lawrence are provided.","\u201cUnpredictable business factor\u201d is not defined (e.g., contract, negotiations, league rules), so the mechanism is unclear.","The \u201ceight potential destinations\u201d list is not included, so only the existence of multiple options is known, not which teams are involved."],"key_facts":["Dexter Lawrence is reported to have requested a trade from the New York Giants (per the provided source summary).","Dexter Lawrence was absent from Giants workouts (per the provided source summary).","John Harbaugh is described as wanting Dexter Lawrence with the Giants (per the provided headline and source summary).","Harbaugh is described as conceding that the business/trade factor is unpredictable (per the provided headline).","The source summary references additional NFL trade/destination context (e.g., \u201ceight potential destinations\u201d), but specific destinations are not included in the provided text."],"numeric_claims":[],"primary_claim":"John Harbaugh wants Dexter Lawrence with the Giants but concedes the business/trade factor is unpredictable.","relevance_score":0.78,"sentiment":"mixed","source_quality":"high","summary":"John Harbaugh is reportedly interested in acquiring Giants defensive tackle Dexter Lawrence, but acknowledges that Lawrence\u2019s trade/business situation is unpredictable. The signal also notes Lawrence\u2019s absence from Giants voluntary workouts and that he has requested a trade, making a near-term roster-catalyst plausible but timing uncertain.","topics":["NFL trade rumors","Dexter Lawrence trade request","Giants roster/defensive line","Head coach comments","Voluntary workouts absence"]},"source":"New York Post","source_domain":"nypost.com","source_url":"https://nypost.com","summary":"John Harbaugh wants Dexter Lawrence with Giants but concedes unpredictable business factor New York Post Dexter Lawrence landing spots: Eight potential destinations for Giants star DT NFL.com Lawrence absent from Giants workouts, but Harbaugh optimistic ESPN NFL news, live updates: De'Von Achane doesn't report to Dolphins voluntary workouts; Pro Bowl DT Dexter Lawrence requests trade from Giants Yahoo Sports John Harbaugh on Kayvon Thibodeaux: Everybody's tradable, but I'm thinking about him in our defense NBC Sports","title":"John Harbaugh wants Dexter Lawrence with Giants but concedes unpredictable business factor - New York Post","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_7d53893e4b5e in signals