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/CBMiqAFBVV95cUxNWHhMY3ZqcFdkakR1NjdfdEktbEdwUUxyVURDLW82dDZ4Nzh5c0tSSHJHaElzZFNvU0d0eVVqY24tcl9VeFVBbmQxeW9GLWktYjRCSzFIWk16c2g4NEg4NHJ5Q2xKbTRteUlEYzNzeEhsUmI3V1JWSzBOZ0ZQLTRxek9TSFhyNGpQTXltZGJ5SXZpNXNDcERnNnNxTWpfQUlmUkhaa013dEE?oc=5","as_of":"2026-04-09T12:52:06.113280+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/CBMiqAFBVV95cUxNWHhMY3ZqcFdkakR1NjdfdEktbEdwUUxyVURDLW82dDZ4Nzh5c0tSSHJHaElzZFNvU0d0eVVqY24tcl9VeFVBbmQxeW9GLWktYjRCSzFIWk16c2g4NEg4NHJ5Q2xKbTRteUlEYzNzeEhsUmI3V1JWSzBOZ0ZQLTRxek9TSFhyNGpQTXltZGJ5SXZpNXNDcERnNnNxTWpfQUlmUkhaa013dEE?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_97ec42a47ace30b9","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-09T23:24:40.893141+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiqAFBVV95cUxNWHhMY3ZqcFdkakR1NjdfdEktbEdwUUxyVURDLW82dDZ4Nzh5c0tSSHJHaElzZFNvU0d0eVVqY24tcl9VeFVBbmQxeW9GLWktYjRCSzFIWk16c2g4NEg4NHJ5Q2xKbTRteUlEYzNzeEhsUmI3V1JWSzBOZ0ZQLTRxek9TSFhyNGpQTXltZGJ5SXZpNXNDcERnNnNxTWpfQUlmUkhaa013dEE?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"f1oversteer.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiqAFBVV95cUxNWHhMY3ZqcFdkakR1NjdfdEktbEdwUUxyVURDLW82dDZ4Nzh5c0tSSHJHaElzZFNvU0d0eVVqY24tcl9VeFVBbmQxeW9GLWktYjRCSzFIWk16c2g4NEg4NHJ5Q2xKbTRteUlEYzNzeEhsUmI3V1JWSzBOZ0ZQLTRxek9TSFhyNGpQTXltZGJ5SXZpNXNDcERnNnNxTWpfQUlmUkhaa013dEE?oc=5","source_event_id":"evt_2a5d7511294b","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"9ec5dbea2657810c","published_at":"2026-04-09T05:50:18+00:00","publisher_domain":"f1oversteer.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.66,"dates_mentioned":["2028"],"entities":[{"asset_class":"other","name":"Gianpiero Lambiase","relevance":"primary subject","symbol":"","type":"person"},{"asset_class":"other","name":"Max Verstappen","relevance":"impacted driver","symbol":"","type":"person"},{"asset_class":"other","name":"McLaren","relevance":"destination team","symbol":"","type":"organization"},{"asset_class":"other","name":"Red Bull","relevance":"current/employing team","symbol":"","type":"organization"},{"asset_class":"other","name":"ESPN","relevance":"source of reporting (as cited)","symbol":"","type":"media"},{"asset_class":"other","name":"The Guardian","relevance":"source of reporting (as cited)","symbol":"","type":"media"},{"asset_class":"other","name":"BBC","relevance":"source of reporting (as cited)","symbol":"","type":"media"},{"asset_class":"other","name":"Yahoo Sports","relevance":"source of reporting (as cited)","symbol":"","type":"media"},{"asset_class":"other","name":"F1 Oversteer","relevance":"signal publisher","symbol":"","type":"media"}],"event_type":"other","information_gaps":["The provided article text is not actually present (only CSS/HTML content), so details like contract terms, confirmation status, or exact timing of the Red Bull exit are not verifiable from the supplied text.","Whether Lambiase\u2019s move is fully confirmed vs. \u201cset for\u201d/\u201cper reports\u201d is not deterministically established in the provided content.","No information is provided on who would replace Lambiase as Verstappen\u2019s race engineer at Red Bull.","No details are provided on whether Verstappen\u2019s future uncertainty is directly caused by this personnel change or is speculative framing."],"key_facts":["Headline reports that Gianpiero Lambiase will join McLaren in 2028.","Headline reports that Lambiase is currently Max Verstappen\u2019s race engineer at Red Bull.","Multiple outlets are cited in the provided source summary as reporting the move (ESPN, The Guardian, BBC, Yahoo Sports).","The reporting is framed as increasing uncertainty around Max Verstappen\u2019s F1 future (per the provided source summary)."],"numeric_claims":[{"label":"joining year","value":"2028"}],"primary_claim":"Gianpiero Lambiase is reported to be leaving Red Bull to join McLaren in 2028.","relevance_score":0.62,"sentiment":"mixed","source_quality":"high","summary":"Reports say Max Verstappen\u2019s Red Bull race engineer Gianpiero Lambiase is set to leave Red Bull and join McLaren in 2028. The move is framed as adding uncertainty to Verstappen\u2019s longer-term F1 situation.","topics":["Formula 1","team personnel","engineer transfer","driver-team stability","career moves"]},"source":"F1 Oversteer","source_domain":"f1oversteer.com","source_url":"https://www.f1oversteer.com","summary":"Max Verstappen race engineer Gianpiero Lambiase to join McLaren in 2028 F1 Oversteer Max Verstappen's trusted Red Bull engineer to join McLaren - sources ESPN Max Verstappen\u2019s F1 future in further doubt with race engineer to leave Red Bull The Guardian Max Verstappen's Red Bull engineer Gianpiero Lambiase to join McLaren BBC Gianpiero Lambiase set for stunning Red Bull exit, per reports Yahoo Sports","title":"Max Verstappen race engineer Gianpiero Lambiase to join McLaren in 2028 - F1 Oversteer","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_979c3ec2cc95 in signals