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/CBMifkFVX3lxTE53VnZqaDFuVmc5dVJTVVdsRGZfZWZmREZTeHpTU3FhQTNadmxnMzJiTk5uZVgyRVRmX0M2UnVGNHZZSVVDV2RlMUY5YkFXYW9SQ3lLSXBlSy1aa0h1Sm9POWFBNG56dFZQQWswUmQ2TVVTYTdRYTlzeWpoaE9pUQ?oc=5","as_of":"2026-04-09T16:31:19.759594+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/CBMifkFVX3lxTE53VnZqaDFuVmc5dVJTVVdsRGZfZWZmREZTeHpTU3FhQTNadmxnMzJiTk5uZVgyRVRmX0M2UnVGNHZZSVVDV2RlMUY5YkFXYW9SQ3lLSXBlSy1aa0h1Sm9POWFBNG56dFZQQWswUmQ2TVVTYTdRYTlzeWpoaE9pUQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_3d79d9b3a8fb210e","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-10T00:00:46.886498+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMifkFVX3lxTE53VnZqaDFuVmc5dVJTVVdsRGZfZWZmREZTeHpTU3FhQTNadmxnMzJiTk5uZVgyRVRmX0M2UnVGNHZZSVVDV2RlMUY5YkFXYW9SQ3lLSXBlSy1aa0h1Sm9POWFBNG56dFZQQWswUmQ2TVVTYTdRYTlzeWpoaE9pUQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"9to5google.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMifkFVX3lxTE53VnZqaDFuVmc5dVJTVVdsRGZfZWZmREZTeHpTU3FhQTNadmxnMzJiTk5uZVgyRVRmX0M2UnVGNHZZSVVDV2RlMUY5YkFXYW9SQ3lLSXBlSy1aa0h1Sm9POWFBNG56dFZQQWswUmQ2TVVTYTdRYTlzeWpoaE9pUQ?oc=5","source_event_id":"evt_79c00f2cb6c5","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"82f008234c2528c5","published_at":"2026-04-09T13:20:00+00:00","publisher_domain":"9to5google.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"equity/consumer device","name":"Google Pixel 11","relevance":"high","symbol":"","type":"product"},{"asset_class":"equity","name":"Samsung","relevance":"high","symbol":"","type":"company"},{"asset_class":"hardware component","name":"Samsung\u2019s new flagship display (M16 OLED)","relevance":"high","symbol":"","type":"component"},{"asset_class":"equity/consumer device","name":"iPhone 18 Pro","relevance":"medium","symbol":"","type":"product"},{"asset_class":"media","name":"9to5Google","relevance":"medium","symbol":"","type":"publisher"}],"event_type":"supply_disruption","information_gaps":["The provided article text is not actually present (only page CSS), so the extraction relies on the headline/signal summary rather than the article body.","No specific release dates, display specs (brightness/resolution/refresh rate), or sourcing/contract details are included in the provided content.","\u201cAhead of iPhone\u201d is not quantified (no exact weeks/months lead time).","Whether Pixel 11 Pro vs Pixel 11 (base) is specified is unclear from the provided signal."],"key_facts":["9to5Google headline states Pixel 11 reportedly gets Samsung\u2019s new flagship display ahead of iPhone.","The display is described as Samsung\u2019s new flagship display, with one referenced variant name in the provided signal text: \u201cM16 OLED.\u201d","The competitive comparison is explicitly against iPhone 18 Pro (as stated in the signal text)."],"numeric_claims":[],"primary_claim":"Google Pixel 11 is reportedly getting Samsung\u2019s new flagship display ahead of iPhone 18 Pro.","relevance_score":0.62,"sentiment":"neutral","source_quality":"high","summary":"9to5Google reports that Google\u2019s upcoming Pixel 11 is reportedly set to use Samsung\u2019s new flagship display earlier than Apple\u2019s iPhone 18 Pro. The near-term catalyst implied is the Pixel 11 launch window, with potential competitive display-supply timing implications.","topics":["smartphones","display supply chain","Samsung OLED","Google Pixel","Apple iPhone timing","product launch competition"]},"source":"9to5Google","source_domain":"9to5google.com","source_url":"https://9to5google.com","summary":"Google Pixel 11 reportedly gets Samsung\u2019s new flagship display ahead of iPhone 9to5Google I\u2019m ignoring the Google Pixel 11 AI hype because its modem switch is the real deal PhoneArena First Look at the Pixel 11: Here\u2019s What Google\u2019s New Smartphone Looks Like Yahoo News UK Something Just Changed: Google Pixel 11 Pro XL Renders Reveal a New Design Direction Geeky Gadgets Google Pixel 11 May Debut Samsung\u2019s M16 OLED Display Ahead of iPhone 18 Pro & Samsung Itself Android Headlines","title":"Google Pixel 11 reportedly gets Samsung\u2019s new flagship display ahead of iPhone - 9to5Google","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_4367eb2aca20 in signals