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/CBMimwFBVV95cUxNR2piSEtIcGpCTWNHMXQtaUZORW5QN294LU1lMmJsVndoN3I0R3dNMndkNjU3VlZmNnYtdVFtbmtsd0hiQTdZNFlObTBFalVlV19lUWZnMzZ4b0VIbHd3YTVBT0ZjSVh3S2t2bUQ5aUhvdFdsMzBFUEcxY0FrN09NcUswOTF6T2pIb0ZuNzdweU9KWFRlaEZVVGJTaw?oc=5","as_of":"2026-04-13T11:48:55.367022+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/CBMimwFBVV95cUxNR2piSEtIcGpCTWNHMXQtaUZORW5QN294LU1lMmJsVndoN3I0R3dNMndkNjU3VlZmNnYtdVFtbmtsd0hiQTdZNFlObTBFalVlV19lUWZnMzZ4b0VIbHd3YTVBT0ZjSVh3S2t2bUQ5aUhvdFdsMzBFUEcxY0FrN09NcUswOTF6T2pIb0ZuNzdweU9KWFRlaEZVVGJTaw?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_784cfa5243cbfa42","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-13T13:25:34.137875+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMimwFBVV95cUxNR2piSEtIcGpCTWNHMXQtaUZORW5QN294LU1lMmJsVndoN3I0R3dNMndkNjU3VlZmNnYtdVFtbmtsd0hiQTdZNFlObTBFalVlV19lUWZnMzZ4b0VIbHd3YTVBT0ZjSVh3S2t2bUQ5aUhvdFdsMzBFUEcxY0FrN09NcUswOTF6T2pIb0ZuNzdweU9KWFRlaEZVVGJTaw?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"barrons.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMimwFBVV95cUxNR2piSEtIcGpCTWNHMXQtaUZORW5QN294LU1lMmJsVndoN3I0R3dNMndkNjU3VlZmNnYtdVFtbmtsd0hiQTdZNFlObTBFalVlV19lUWZnMzZ4b0VIbHd3YTVBT0ZjSVh3S2t2bUQ5aUhvdFdsMzBFUEcxY0FrN09NcUswOTF6T2pIb0ZuNzdweU9KWFRlaEZVVGJTaw?oc=5","source_event_id":"evt_5a1e1541a316","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"ce6282806299f694","published_at":"2026-04-13T09:55:00+00:00","publisher_domain":"barrons.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"media","name":"Barron's","relevance":"source of the headline","symbol":"","type":"publisher"}],"event_type":"other","information_gaps":["The five pipeline stocks are not named in the provided text.","No ticker symbols are provided for the pipeline stocks.","No details are provided on the mechanism (e.g., contracts, volumes, tariffs) linking demand to stock performance.","No near-term catalyst timing (date/quarter) is provided.","No additional context from the article body is available."],"key_facts":["Barron\u2019s published an article titled \u201cThe World Wants More American Energy. 5 Pipeline Stocks That Benefit.\u201d","The headline asserts that five pipeline stocks benefit from increased demand for American energy."],"numeric_claims":[],"primary_claim":"The world wants more American energy, and Barron\u2019s identifies five pipeline stocks that benefit.","relevance_score":0.35,"sentiment":"positive","source_quality":"unknown","summary":"Barron\u2019s headline indicates that demand for more American energy is expected to benefit five pipeline stocks. No specific company names, tickers, or timing details are provided in the available text.","topics":["American energy demand","pipeline stocks","equities","energy infrastructure"]},"source":"Barron's","source_domain":"barrons.com","source_url":"https://www.barrons.com","summary":"The World Wants More American Energy. 5 Pipeline Stocks That Benefit. Barron's","title":"The World Wants More American Energy. 5 Pipeline Stocks That Benefit. - Barron's","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_bdb9589b5dd1 in signals