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-07T23:23:37.678336+00:00","dedupe_key":"signal_enriched:news_delta:da5e5268d7bcc713","evidence_event_ids":["evt_efa7c6b9be90"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMi1gFBVV95cUxNWUp0UTIzckRFNDVNQVBMd1d2azhhT0s4TFR3alJ0ZzJkMFJ3YkpFeVRmd1ZaOFNCZHg4V0UxVmJ6RDlvN0s4NTNTZFBvajRhQWwyem1EV0xYS3JkR0tDZ0o1em9PMnpkdFJxRlVSTGVzR2pnU2RESTNyZ3ZEdTRsVllZV3phcXVmNFl5MWEwZTQtQnVTMUEwcDB4cGNVQ241aVc1amFZUTIxV0pkTUstNVlJTkNHUm81UzloYU5xaUVpMVZzUzUzU3Nrem1VOEJPZ2xVRTFR?oc=5","as_of":"2026-04-07T23:23:37.678336+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/CBMi1gFBVV95cUxNWUp0UTIzckRFNDVNQVBMd1d2azhhT0s4TFR3alJ0ZzJkMFJ3YkpFeVRmd1ZaOFNCZHg4V0UxVmJ6RDlvN0s4NTNTZFBvajRhQWwyem1EV0xYS3JkR0tDZ0o1em9PMnpkdFJxRlVSTGVzR2pnU2RESTNyZ3ZEdTRsVllZV3phcXVmNFl5MWEwZTQtQnVTMUEwcDB4cGNVQ241aVc1amFZUTIxV0pkTUstNVlJTkNHUm81UzloYU5xaUVpMVZzUzUzU3Nrem1VOEJPZ2xVRTFR?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_77de907e21577347","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-08T00:31:44.370964+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMi1gFBVV95cUxNWUp0UTIzckRFNDVNQVBMd1d2azhhT0s4TFR3alJ0ZzJkMFJ3YkpFeVRmd1ZaOFNCZHg4V0UxVmJ6RDlvN0s4NTNTZFBvajRhQWwyem1EV0xYS3JkR0tDZ0o1em9PMnpkdFJxRlVSTGVzR2pnU2RESTNyZ3ZEdTRsVllZV3phcXVmNFl5MWEwZTQtQnVTMUEwcDB4cGNVQ241aVc1amFZUTIxV0pkTUstNVlJTkNHUm81UzloYU5xaUVpMVZzUzUzU3Nrem1VOEJPZ2xVRTFR?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"bettermarkets.org","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMi1gFBVV95cUxNWUp0UTIzckRFNDVNQVBMd1d2azhhT0s4TFR3alJ0ZzJkMFJ3YkpFeVRmd1ZaOFNCZHg4V0UxVmJ6RDlvN0s4NTNTZFBvajRhQWwyem1EV0xYS3JkR0tDZ0o1em9PMnpkdFJxRlVSTGVzR2pnU2RESTNyZ3ZEdTRsVllZV3phcXVmNFl5MWEwZTQtQnVTMUEwcDB4cGNVQ241aVc1amFZUTIxV0pkTUstNVlJTkNHUm81UzloYU5xaUVpMVZzUzUzU3Nrem1VOEJPZ2xVRTFR?oc=5","source_event_id":"evt_efa7c6b9be90","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"2341f43d047acb75","published_at":"2026-04-07T21:59:35+00:00","publisher_domain":"bettermarkets.org","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.7,"dates_mentioned":["2025"],"entities":[{"asset_class":"regulation","name":"U.S. Securities and Exchange Commission (SEC)","relevance":"primary subject of the report","symbol":"","type":"regulator"},{"asset_class":"media","name":"Better Markets","relevance":"publisher making the claim","symbol":"","type":"advocacy/organization"}],"event_type":"regulation","information_gaps":["No specific SEC enforcement failures, metrics, or examples are included in the provided text (only the headline/summary framing).","No details are provided on what \u201cfailures\u201d refer to (e.g., enforcement actions, staffing, outcomes, or policy issues).","No timing/catalyst beyond the report year (2025) is specified in the provided text."],"key_facts":["The signal references an SEC \u201c2025 Enforcement Report.\u201d","The referenced Better Markets piece characterizes the report as detailing \u201cfailures\u201d by the SEC.","The Better Markets framing states these alleged failures endanger \u201cinvestors, markets and financial stability.\u201d"],"numeric_claims":[],"primary_claim":"Better Markets claims the SEC\u2019s 2025 Enforcement Report details SEC failures that endanger investors, markets, and financial stability.","relevance_score":0.62,"sentiment":"negative","source_quality":"high","summary":"Better Markets says the SEC\u2019s 2025 Enforcement Report documents failures that allegedly endanger investors, markets, and financial stability.","topics":["SEC enforcement","2025 Enforcement Report","investor protection","market integrity","financial stability","regulatory accountability"]},"source":"Better Markets","source_domain":"bettermarkets.org","source_url":"https://bettermarkets.org","summary":"SEC\u2019s 2025 Enforcement Report Details Its Failures Endangering Investors, Markets and Financial Stability Better Markets","title":"SEC\u2019s 2025 Enforcement Report Details Its Failures Endangering Investors, Markets and Financial Stability - Better Markets","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 2197 in events