SQLite Web: event

seq

Primary key. INTEGER

id

TEXT NOT NULL

kind

TEXT NOT NULL

ts

TEXT NOT NULL

actor

TEXT

subject_entity_ids

TEXT

payload

{"created_at":"2026-04-12T20:02:49.154396+00:00","dedupe_key":"signal_enriched:news_delta:3f33d87be09314c6","evidence_event_ids":["evt_941466475e84"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMiigFBVV95cUxOc3JZUDFlTl9mS3FNMnowVUlvQy12VU1XVzJWZlowSzY3LUo3S3FOd0JKaVFGWFdoeVF6UVpYOEVBMHkxQkVxWVhma3ZFZURhVUh2M2g1SFhZMDN0N3dKNW1ORWloODhuWlVSa3hGOVhyTzRvYmEyTnZ1NkRlblVFU3EtQ1RabU1ZelE?oc=5","as_of":"2026-04-12T20:02:49.154396+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/CBMiigFBVV95cUxOc3JZUDFlTl9mS3FNMnowVUlvQy12VU1XVzJWZlowSzY3LUo3S3FOd0JKaVFGWFdoeVF6UVpYOEVBMHkxQkVxWVhma3ZFZURhVUh2M2g1SFhZMDN0N3dKNW1ORWloODhuWlVSa3hGOVhyTzRvYmEyTnZ1NkRlblVFU3EtQ1RabU1ZelE?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_3d0e75ddd01b4753","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-12T21:56:55.628679+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiigFBVV95cUxOc3JZUDFlTl9mS3FNMnowVUlvQy12VU1XVzJWZlowSzY3LUo3S3FOd0JKaVFGWFdoeVF6UVpYOEVBMHkxQkVxWVhma3ZFZURhVUh2M2g1SFhZMDN0N3dKNW1ORWloODhuWlVSa3hGOVhyTzRvYmEyTnZ1NkRlblVFU3EtQ1RabU1ZelE?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/CBMiigFBVV95cUxOc3JZUDFlTl9mS3FNMnowVUlvQy12VU1XVzJWZlowSzY3LUo3S3FOd0JKaVFGWFdoeVF6UVpYOEVBMHkxQkVxWVhma3ZFZURhVUh2M2g1SFhZMDN0N3dKNW1ORWloODhuWlVSa3hGOVhyTzRvYmEyTnZ1NkRlblVFU3EtQ1RabU1ZelE?oc=5","source_event_id":"evt_941466475e84","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"677339fd240150cb","published_at":"2026-04-12T19:10:21+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"","name":"The Motley Fool","relevance":"source of the headline","symbol":"","type":"publisher"}],"event_type":"other","information_gaps":["Which specific stocks are referenced (\u201cthese stocks\u201d) is not provided.","No standardized ticker symbols are available in the provided text.","\u201cSouth of the border\u201d is not defined (country/region unclear).","No near-term catalyst timing or concrete event is described beyond the general investment suggestion.","No article details are available to confirm whether the recommendation is based on earnings, policy, contracts, or other developments."],"key_facts":["Provided text is only a headline and matching source summary.","The headline references a \u201creshoring theme.\u201d","The headline implies buying \u201cthese stocks south of the border.\u201d","No stock names, tickers, countries, or companies are listed in the provided text."],"numeric_claims":[],"primary_claim":"The Motley Fool headline recommends that investors play the reshoring theme by buying certain stocks \u201csouth of the border.\u201d","relevance_score":0.25,"sentiment":"neutral","source_quality":"unknown","summary":"The Motley Fool headline suggests investors interested in the \u201creshoring theme\u201d may consider buying stocks of companies located \u201csouth of the border.\u201d No specific companies, tickers, or timing details are provided in the available text.","topics":["reshoring theme","stock picking","geographic reference (south of the border)"]},"source":"The Motley Fool","source_domain":"fool.com","source_url":"https://www.fool.com","summary":"Want to Play the Reshoring Theme? You Might Want to Buy These Stocks South of the Border. The Motley Fool","title":"Want to Play the Reshoring Theme? You Might Want to Buy These Stocks South of the Border. - 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

source_ref

TEXT

confidence

REAL (default 0.0

dedupe_key

TEXT

episode_id

TEXT

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

event_store.db — events

Update row 31050 in events