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/CBMi3AFBVV95cUxQR0YyN3JxMTRqb2VDZDdXdVA5R3cyZ1ZZXzlKeS1MWHVWejN0OVFoZURhQWRUdHZrRHBBRm1mM09mZHdJbnkyQ21YaUYxLS1jbzJVQTN1aDhpbjI2Ymh1V3NBbmYyRGJYRXd1X2JYaWxaSEdWSFR1SzFVZEFmQjRzbmVIdmpIWmp4Wk9xUG96eFJKbE9QZ3NKakt6cldWZWVjajJFWUNnb21UY0R0dUhuR00taDNPT3FQSmRXRjFJUEdFbjVielppWHItVmpoSjR5d25VWmdKWlcyTDZS?oc=5","as_of":"2026-04-10T20:14:38.989304+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/CBMi3AFBVV95cUxQR0YyN3JxMTRqb2VDZDdXdVA5R3cyZ1ZZXzlKeS1MWHVWejN0OVFoZURhQWRUdHZrRHBBRm1mM09mZHdJbnkyQ21YaUYxLS1jbzJVQTN1aDhpbjI2Ymh1V3NBbmYyRGJYRXd1X2JYaWxaSEdWSFR1SzFVZEFmQjRzbmVIdmpIWmp4Wk9xUG96eFJKbE9QZ3NKakt6cldWZWVjajJFWUNnb21UY0R0dUhuR00taDNPT3FQSmRXRjFJUEdFbjVielppWHItVmpoSjR5d25VWmdKWlcyTDZS?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_536f4df14dc92f03","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-10T20:16:10.906933+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMi3AFBVV95cUxQR0YyN3JxMTRqb2VDZDdXdVA5R3cyZ1ZZXzlKeS1MWHVWejN0OVFoZURhQWRUdHZrRHBBRm1mM09mZHdJbnkyQ21YaUYxLS1jbzJVQTN1aDhpbjI2Ymh1V3NBbmYyRGJYRXd1X2JYaWxaSEdWSFR1SzFVZEFmQjRzbmVIdmpIWmp4Wk9xUG96eFJKbE9QZ3NKakt6cldWZWVjajJFWUNnb21UY0R0dUhuR00taDNPT3FQSmRXRjFJUEdFbjVielppWHItVmpoSjR5d25VWmdKWlcyTDZS?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"247wallst.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMi3AFBVV95cUxQR0YyN3JxMTRqb2VDZDdXdVA5R3cyZ1ZZXzlKeS1MWHVWejN0OVFoZURhQWRUdHZrRHBBRm1mM09mZHdJbnkyQ21YaUYxLS1jbzJVQTN1aDhpbjI2Ymh1V3NBbmYyRGJYRXd1X2JYaWxaSEdWSFR1SzFVZEFmQjRzbmVIdmpIWmp4Wk9xUG96eFJKbE9QZ3NKakt6cldWZWVjajJFWUNnb21UY0R0dUhuR00taDNPT3FQSmRXRjFJUEdFbjVielppWHItVmpoSjR5d25VWmdKWlcyTDZS?oc=5","source_event_id":"evt_bba8d355361f","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"db2cfd1121f3004d","published_at":"2026-04-10T20:04:27+00:00","publisher_domain":"247wallst.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.78,"dates_mentioned":[],"entities":[{"asset_class":"","name":"24/7 Wall St.","relevance":"high","symbol":"","type":"publisher"},{"asset_class":"equities","name":"Stock market","relevance":"medium","symbol":"","type":"market"},{"asset_class":"cash","name":"$50,000","relevance":"high","symbol":"","type":"money_amount"}],"event_type":"other","information_gaps":["No article body content was provided (cleaned text appears to be mostly CSS/boilerplate), so the actual investment recommendations, risk guidance, or any specific tickers are not available.","No specific stocks, ETFs, or tickers are mentioned in the provided headline.","No timing (date of publication or market context) is provided beyond the headline text."],"key_facts":["Headline states the subject is 45 years old.","Headline states the subject has barely invested in the stock market.","Headline states the subject recently inherited $50,000.","Headline asks what the subject should do.","Publisher indicated as 24/7 Wall St."],"numeric_claims":[{"label":"age","value":"45"},{"label":"inheritance_amount_usd","value":"50000"}],"primary_claim":"A 45-year-old who recently inherited $50,000 and has barely invested in the stock market asks what they should do (24/7 Wall St.).","relevance_score":0.15,"sentiment":"neutral","source_quality":"high","summary":"The headline describes a 45-year-old investor who has barely invested and recently inherited $50,000, asking what to do with it. It is presented as a 24/7 Wall St. advice-style article rather than a market-moving claim about specific securities.","topics":["personal finance","inherited funds","beginner investing","stock market advice"]},"source":"24/7 Wall St.","source_domain":"247wallst.com","source_url":"https://247wallst.com","summary":"","tickers":[],"title":"I'm 45 and I've Barely Invested in the Stock Market. I Recently Inherited $50,000. What Should I Do? - 24/7 Wall St.","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_f4ae06145756 in signals