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/CBMilgFBVV95cUxQQ1RNZlNXRzk4ZUhwTE0xWjNKbmlJU0hnSE85enNMLWRicW1fNlJqTzF4eGpYOGExUzl0eloxSkJDa2stczlISnFfazRRVDJLNlFpcGZDZTNyNmQ2N01SdGJjZ0hpZTByTmRRR1Z5bzZnajhsZUtvVGFoUFktSS1TcDVUcU9vSnBvbGJEQ1VuZE1nY202VGc?oc=5","as_of":"2026-04-10T04:47:24.585896+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/CBMilgFBVV95cUxQQ1RNZlNXRzk4ZUhwTE0xWjNKbmlJU0hnSE85enNMLWRicW1fNlJqTzF4eGpYOGExUzl0eloxSkJDa2stczlISnFfazRRVDJLNlFpcGZDZTNyNmQ2N01SdGJjZ0hpZTByTmRRR1Z5bzZnajhsZUtvVGFoUFktSS1TcDVUcU9vSnBvbGJEQ1VuZE1nY202VGc?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_16d4005654d8ab53","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-10T04:47:43.066115+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMilgFBVV95cUxQQ1RNZlNXRzk4ZUhwTE0xWjNKbmlJU0hnSE85enNMLWRicW1fNlJqTzF4eGpYOGExUzl0eloxSkJDa2stczlISnFfazRRVDJLNlFpcGZDZTNyNmQ2N01SdGJjZ0hpZTByTmRRR1Z5bzZnajhsZUtvVGFoUFktSS1TcDVUcU9vSnBvbGJEQ1VuZE1nY202VGc?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMilgFBVV95cUxQQ1RNZlNXRzk4ZUhwTE0xWjNKbmlJU0hnSE85enNMLWRicW1fNlJqTzF4eGpYOGExUzl0eloxSkJDa2stczlISnFfazRRVDJLNlFpcGZDZTNyNmQ2N01SdGJjZ0hpZTByTmRRR1Z5bzZnajhsZUtvVGFoUFktSS1TcDVUcU9vSnBvbGJEQ1VuZE1nY202VGc?oc=5","source_event_id":"evt_dd6f3dde8e1e","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"e1b40d03a557270c","published_at":"2026-04-10T04:21:00+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"headline_only","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"","name":"The Motley Fool","relevance":"source of the recommendation","symbol":"","type":"publisher"}],"event_type":"other","information_gaps":["Which specific industrial stock/company is being recommended is not stated in the provided text.","No rationale (e.g., earnings growth, margins, backlog, valuation) is included in the provided text.","No near-term timing/catalyst information is provided in the provided text.","No tradable asset symbol/ticker can be extracted from the provided text."],"key_facts":["Headline states: \u201cWhat Is 1 of the Best Industrial Stocks to Own for the Next 10 Years?\u201d","No stock ticker or company name is present in the provided text.","No performance, valuation, or catalyst details are present in the provided text."],"numeric_claims":[],"primary_claim":"The Motley Fool article claims there is \u201c1 of the Best Industrial Stocks to Own for the Next 10 Years.\u201d","relevance_score":0.25,"sentiment":"positive","source_quality":"high","summary":"The Motley Fool published an article recommending one industrial stock as a long-term (10-year) holding. The provided text only includes the headline and does not specify which stock or any supporting fundamentals.","topics":["industrial stocks","long-term investing","stock recommendation"]},"source":"The Motley Fool","source_domain":"fool.com","source_url":"https://www.fool.com","summary":"What Is 1 of the Best Industrial Stocks to Own for the Next 10 Years? The Motley Fool","title":"What Is 1 of the Best Industrial Stocks to Own for the Next 10 Years? - The Motley Fool","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_dc219a7db842 in signals