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-08T00:57:08.168750+00:00","dedupe_key":"signal_enriched:news_delta:0b9374d9f1506b9f","evidence_event_ids":["evt_54ea86a65df9"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMisAFBVV95cUxNckUwbW5zRHJtZnI0VUlhdmtfZWVIblRoaE1vRFE5UDVOeEdZM1NEbG5kSUpfV3dyTE1ad3VfbnFLSGtwLWNVQWl2YnVjcGFGbXdvaXA4X0NKLWdVRVE1UDFFRkdYYll4VFQwSF9CUTJaZTFINmRlMzZtc3NFUG5VeE9EdnQ0Q3Y2TXRadGU1MFlucHJ1SC1nUWw4azlRc1RNUGNhN3JEOTVWMGRMYzZkZA?oc=5","as_of":"2026-04-08T00:57:08.168750+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/CBMisAFBVV95cUxNckUwbW5zRHJtZnI0VUlhdmtfZWVIblRoaE1vRFE5UDVOeEdZM1NEbG5kSUpfV3dyTE1ad3VfbnFLSGtwLWNVQWl2YnVjcGFGbXdvaXA4X0NKLWdVRVE1UDFFRkdYYll4VFQwSF9CUTJaZTFINmRlMzZtc3NFUG5VeE9EdnQ0Q3Y2TXRadGU1MFlucHJ1SC1nUWw4azlRc1RNUGNhN3JEOTVWMGRMYzZkZA?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_18c71e9267478061","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:57:53.157087+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMisAFBVV95cUxNckUwbW5zRHJtZnI0VUlhdmtfZWVIblRoaE1vRFE5UDVOeEdZM1NEbG5kSUpfV3dyTE1ad3VfbnFLSGtwLWNVQWl2YnVjcGFGbXdvaXA4X0NKLWdVRVE1UDFFRkdYYll4VFQwSF9CUTJaZTFINmRlMzZtc3NFUG5VeE9EdnQ0Q3Y2TXRadGU1MFlucHJ1SC1nUWw4azlRc1RNUGNhN3JEOTVWMGRMYzZkZA?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"nytimes.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMisAFBVV95cUxNckUwbW5zRHJtZnI0VUlhdmtfZWVIblRoaE1vRFE5UDVOeEdZM1NEbG5kSUpfV3dyTE1ad3VfbnFLSGtwLWNVQWl2YnVjcGFGbXdvaXA4X0NKLWdVRVE1UDFFRkdYYll4VFQwSF9CUTJaZTFINmRlMzZtc3NFUG5VeE9EdnQ0Q3Y2TXRadGU1MFlucHJ1SC1nUWw4azlRc1RNUGNhN3JEOTVWMGRMYzZkZA?oc=5","source_event_id":"evt_54ea86a65df9","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"2c4a8ef4b66c8dcf","published_at":"2026-04-07T19:49:49+00:00","publisher_domain":"nytimes.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"other","name":"John Harbaugh","relevance":"high","symbol":"","type":"person"},{"asset_class":"other","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","name":"ESPN","relevance":"medium","symbol":"","type":"organization"},{"asset_class":"media","name":"NFL.com","relevance":"medium","symbol":"","type":"organization"},{"asset_class":"media","name":"Yahoo Sports","relevance":"medium","symbol":"","type":"organization"},{"asset_class":"media","name":"Big Blue View","relevance":"low","symbol":"","type":"organization"}],"event_type":"conflict","information_gaps":["The cleaned article text provided does not include the actual NYT body content; only the headline and the external source summary are available here.","No specific timing (dates) for workouts, trade discussions, or a resolution is included in the provided material.","The exact wording/context of Harbaugh\u2019s quote beyond the headline is not available in the provided text.","Whether Lawrence\u2019s trade request has been formally accepted/negotiated (or any reported offer details) is not included."],"key_facts":["Dexter Lawrence has 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 said he believes Dexter Lawrence wants to be here (quoted in the headline).","The source summary indicates other outlets discussed potential landing spots for Lawrence and reported on workout participation by other players (De'Von Achane, Paulson Adebo), but these details are not confirmed within the NYT headline itself."],"numeric_claims":[],"primary_claim":"John Harbaugh stated, \u201cI believe Dexter wants to be here,\u201d in response to Dexter Lawrence\u2019s trade demand.","relevance_score":0.72,"sentiment":"mixed","source_quality":"high","summary":"John Harbaugh said he believes Dexter Lawrence wants to remain with the Giants despite Lawrence\u2019s trade request and his absence from Giants workouts. The near-term catalyst is continued offseason workout participation/absence and any follow-on reporting on Lawrence\u2019s trade status.","topics":["NFL offseason","trade request","Giants defensive tackle","team statements","workouts/availability"]},"source":"The New York Times","source_domain":"nytimes.com","source_url":"https://www.nytimes.com","summary":"John Harbaugh on Dexter Lawrence\u2019s trade demand: \u2018I believe Dexter wants to be here\u2019 The New York Times Lawrence absent from Giants workouts, but Harbaugh optimistic ESPN Dexter Lawrence landing spots: Eight potential destinations for Giants star DT NFL.com 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 NY Giants news: Paulson Adebo one of three players who missed first workout Big Blue View","title":"John Harbaugh on Dexter Lawrence\u2019s trade demand: \u2018I believe Dexter wants to be here\u2019 - The New York Times","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 2770 in events