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/CBMilgFBVV95cUxQTy1YWEY3V3VtVGxtMTJPVzB2TXFfcW92ZDhuQ1pwWG5KZ3NUUWRLNkZILTlOZDFjalFlTWpXMnZPNjBlZjVldGpJZ2ZSSmlzeTRYLW1BMHZvQXBhZWpPRDNiYUFPMzkzWGNfVVN0alRCTnEwWmkwSzlPcmRGTzFBVE9qckRDSENSMWFzWi1jYTFoTmx5aWc?oc=5","as_of":"2026-04-09T17:20:48.202022+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/CBMilgFBVV95cUxQTy1YWEY3V3VtVGxtMTJPVzB2TXFfcW92ZDhuQ1pwWG5KZ3NUUWRLNkZILTlOZDFjalFlTWpXMnZPNjBlZjVldGpJZ2ZSSmlzeTRYLW1BMHZvQXBhZWpPRDNiYUFPMzkzWGNfVVN0alRCTnEwWmkwSzlPcmRGTzFBVE9qckRDSENSMWFzWi1jYTFoTmx5aWc?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_dae6d80c9f8c2925","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:08:51.111460+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMilgFBVV95cUxQTy1YWEY3V3VtVGxtMTJPVzB2TXFfcW92ZDhuQ1pwWG5KZ3NUUWRLNkZILTlOZDFjalFlTWpXMnZPNjBlZjVldGpJZ2ZSSmlzeTRYLW1BMHZvQXBhZWpPRDNiYUFPMzkzWGNfVVN0alRCTnEwWmkwSzlPcmRGTzFBVE9qckRDSENSMWFzWi1jYTFoTmx5aWc?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"theverge.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMilgFBVV95cUxQTy1YWEY3V3VtVGxtMTJPVzB2TXFfcW92ZDhuQ1pwWG5KZ3NUUWRLNkZILTlOZDFjalFlTWpXMnZPNjBlZjVldGpJZ2ZSSmlzeTRYLW1BMHZvQXBhZWpPRDNiYUFPMzkzWGNfVVN0alRCTnEwWmkwSzlPcmRGTzFBVE9qckRDSENSMWFzWi1jYTFoTmx5aWc?oc=5","source_event_id":"evt_44007610b3cc","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"173106cc43a1b9cb","published_at":"2026-04-09T14:01:43+00:00","publisher_domain":"theverge.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"equity","name":"Ticketmaster","relevance":"high","symbol":"","type":"company"},{"asset_class":"equity","name":"Live Nation","relevance":"high","symbol":"","type":"company"},{"asset_class":"equity","name":"AEG","relevance":"medium","symbol":"","type":"company"},{"asset_class":"unknown","name":"BigLaw attorney","relevance":"low","symbol":"","type":"person_or_role"}],"event_type":"conflict","information_gaps":["The article text provided is not the actual article content (it appears to be page styling/HTML), so details such as specific claims, legal theories, and the exact timing/date of the jury decision are not available in the provided material.","The signal does not specify what \u201cfate\u201d entails (e.g., damages, injunction, liability finding) or which specific counts remain for the jury.","No explicit market/financial impact is stated in the provided headline/summary beyond the implication of legal outcome."],"key_facts":["The Verge headline states that a jury is about to decide the fate of Ticketmaster.","The provided source summary indicates the Live Nation trial is nearing its end and closing arguments are set to begin.","The source summary references AEG and a BigLaw attorney being in the \u201chot seat\u201d as the trial nears end."],"numeric_claims":[],"primary_claim":"A jury is about to decide the fate of Ticketmaster as the Live Nation antitrust trial nears its end.","relevance_score":0.78,"sentiment":"neutral","source_quality":"high","summary":"The Verge reports that a jury is about to decide the outcome of the Ticketmaster-related Live Nation antitrust trial. The near-term catalyst is the jury decision following the trial\u2019s closing arguments.","topics":["antitrust","trial","Ticketmaster","Live Nation","jury decision","closing arguments"]},"source":"The Verge","source_domain":"theverge.com","source_url":"https://www.theverge.com","summary":"A jury is about to decide the fate of Ticketmaster The Verge AEG, BigLaw Atty In Hot Seat As Live Nation Trial Nears End Law360 Did Live Nation Kill Live Music? The Free Press Live Nation Trial Nears End With Closing Arguments Set to Begin Rolling Stone Live Nation Antitrust Case Narrows as Plaintiffs Drop Standalone Exclusive-Dealing Claim TicketNews","title":"A jury is about to decide the fate of Ticketmaster - The Verge","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_e30f58f4653d in signals