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-14T15:01:44.732180+00:00","dedupe_key":"signal_enriched:news_delta:714abb5802722651","evidence_event_ids":["evt_e65c98bfb368"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMi5AFBVV95cUxQMm5Bd2twbGk4RUdmYTM1R0hOTlNUcDNnWXl1bEtxS3g0WktHOW5mODRqQ0wxTnJlV1ZiaEpPcUJIS0JYUEVZdTVWV0lISlRiOE9XdWlNVnY5RXpWUGE2dnVMVVZ6SjNsYWZwOVdSSVBtbHdxdjVhblJBMUF5M1c3WDlDS3BCdTZIWWdGYU5qUzQzMzVjclA3ZFZSckJJQXVOWXRhRWdOSnZOT2lSeURpM3Fwck9rU0VBd3BLYXhjUklaU2YwS1Z1MnhNUlZmLUc5aEtCOUdiR3RlcUZGQ21pY3Jhb1nSAeoBQVVfeXFMTmFSVEE0TE11T0NaMnk3dzFYRDRpY2xIQkY1M1dLa1lpWUVBaG9CWmtoWk9SRTdFQmRDYVdlMGllTDdleG4tOUxNemNndzcyUDR6TVVyME9UdXQ0MDMtVlJSTnREbV9lcUlOOGt1ekpweGMzMGNXcTVhelp5RTdnZjZfT0hHSXB3NWdGUXZjUlNYQVhMM0RVMFpzYUtrbURrbnNlWHdLQnpIR0Z1RTZObDM3QldNTkl6WUVTd3M4b0hYaE9yWUFKRG93c2dXY1l0SmRzUU1uSndLeDNoNi13Nk02dnU5NHFnNjNn?oc=5","as_of":"2026-04-14T15:01:44.732180+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.z46LtA-qfIg.L.X.O/am=GAIFAACAA2YBAwpA/d=1/ed=1/rs=ALs0n2PeUbKSDKfQ9Op-3wUE_8hlNgDpuA/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMi5AFBVV95cUxQMm5Bd2twbGk4RUdmYTM1R0hOTlNUcDNnWXl1bEtxS3g0WktHOW5mODRqQ0wxTnJlV1ZiaEpPcUJIS0JYUEVZdTVWV0lISlRiOE9XdWlNVnY5RXpWUGE2dnVMVVZ6SjNsYWZwOVdSSVBtbHdxdjVhblJBMUF5M1c3WDlDS3BCdTZIWWdGYU5qUzQzMzVjclA3ZFZSckJJQXVOWXRhRWdOSnZOT2lSeURpM3Fwck9rU0VBd3BLYXhjUklaU2YwS1Z1MnhNUlZmLUc5aEtCOUdiR3RlcUZGQ21pY3Jhb1nSAeoBQVVfeXFMTmFSVEE0TE11T0NaMnk3dzFYRDRpY2xIQkY1M1dLa1lpWUVBaG9CWmtoWk9SRTdFQmRDYVdlMGllTDdleG4tOUxNemNndzcyUDR6TVVyME9UdXQ0MDMtVlJSTnREbV9lcUlOOGt1ekpweGMzMGNXcTVhelp5RTdnZjZfT0hHSXB3NWdGUXZjUlNYQVhMM0RVMFpzYUtrbURrbnNlWHdLQnpIR0Z1RTZObDM3QldNTkl6WUVTd3M4b0hYaE9yWUFKRG93c2dXY1l0SmRzUU1uSndLeDNoNi13Nk02dnU5NHFnNjNn?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_5550bec14d1d004e","canonical_host":"gstatic.com","canonical_is_aggregator":true,"canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.z46LtA-qfIg.L.X.O/am=GAIFAACAA2YBAwpA/d=1/ed=1/rs=ALs0n2PeUbKSDKfQ9Op-3wUE_8hlNgDpuA/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-14T15:03:02.459719+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMi5AFBVV95cUxQMm5Bd2twbGk4RUdmYTM1R0hOTlNUcDNnWXl1bEtxS3g0WktHOW5mODRqQ0wxTnJlV1ZiaEpPcUJIS0JYUEVZdTVWV0lISlRiOE9XdWlNVnY5RXpWUGE2dnVMVVZ6SjNsYWZwOVdSSVBtbHdxdjVhblJBMUF5M1c3WDlDS3BCdTZIWWdGYU5qUzQzMzVjclA3ZFZSckJJQXVOWXRhRWdOSnZOT2lSeURpM3Fwck9rU0VBd3BLYXhjUklaU2YwS1Z1MnhNUlZmLUc5aEtCOUdiR3RlcUZGQ21pY3Jhb1nSAeoBQVVfeXFMTmFSVEE0TE11T0NaMnk3dzFYRDRpY2xIQkY1M1dLa1lpWUVBaG9CWmtoWk9SRTdFQmRDYVdlMGllTDdleG4tOUxNemNndzcyUDR6TVVyME9UdXQ0MDMtVlJSTnREbV9lcUlOOGt1ekpweGMzMGNXcTVhelp5RTdnZjZfT0hHSXB3NWdGUXZjUlNYQVhMM0RVMFpzYUtrbURrbnNlWHdLQnpIR0Z1RTZObDM3QldNTkl6WUVTd3M4b0hYaE9yWUFKRG93c2dXY1l0SmRzUU1uSndLeDNoNi13Nk02dnU5NHFnNjNn?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"thebadgerproject.org","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMi5AFBVV95cUxQMm5Bd2twbGk4RUdmYTM1R0hOTlNUcDNnWXl1bEtxS3g0WktHOW5mODRqQ0wxTnJlV1ZiaEpPcUJIS0JYUEVZdTVWV0lISlRiOE9XdWlNVnY5RXpWUGE2dnVMVVZ6SjNsYWZwOVdSSVBtbHdxdjVhblJBMUF5M1c3WDlDS3BCdTZIWWdGYU5qUzQzMzVjclA3ZFZSckJJQXVOWXRhRWdOSnZOT2lSeURpM3Fwck9rU0VBd3BLYXhjUklaU2YwS1Z1MnhNUlZmLUc5aEtCOUdiR3RlcUZGQ21pY3Jhb1nSAeoBQVVfeXFMTmFSVEE0TE11T0NaMnk3dzFYRDRpY2xIQkY1M1dLa1lpWUVBaG9CWmtoWk9SRTdFQmRDYVdlMGllTDdleG4tOUxNemNndzcyUDR6TVVyME9UdXQ0MDMtVlJSTnREbV9lcUlOOGt1ekpweGMzMGNXcTVhelp5RTdnZjZfT0hHSXB3NWdGUXZjUlNYQVhMM0RVMFpzYUtrbURrbnNlWHdLQnpIR0Z1RTZObDM3QldNTkl6WUVTd3M4b0hYaE9yWUFKRG93c2dXY1l0SmRzUU1uSndLeDNoNi13Nk02dnU5NHFnNjNn?oc=5","source_event_id":"evt_e65c98bfb368","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"e4af95e6b99b9f8b","published_at":"2026-04-14T14:25:58+00:00","publisher_domain":"thebadgerproject.org","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"","name":"Wisconsin congressman (unnamed)","relevance":"primary subject","symbol":"","type":"person"},{"asset_class":"","name":"The Badger Project","relevance":"source","symbol":"","type":"publisher"}],"event_type":"regulation","information_gaps":["The congressman\u2019s name is not provided in the provided text.","The bill\u2019s name/number, sponsors, and proposed effective date are not provided.","No details are provided on what specific trading activity occurred (frequency, timeframe, or holdings).","No information is provided on whether the bill has been introduced, passed a chamber, or its current legislative status."],"key_facts":["The headline states a wealthy Wisconsin congressman keeps aggressively trading stocks.","The headline states a bipartisan bill would ban the practice."],"numeric_claims":[],"primary_claim":"A bipartisan bill would ban stock trading by a wealthy Wisconsin congressman who is described as aggressively trading stocks.","relevance_score":0.45,"sentiment":"neutral","source_quality":"unknown","summary":"The Badger Project reports that a wealthy Wisconsin congressman has been aggressively trading stocks, and that a bipartisan bill would ban the practice.","topics":["stock trading","congressional trading","bipartisan bill","ban on practice","Wisconsin"]},"source":"The Badger Project","source_domain":"thebadgerproject.org","source_url":"https://thebadgerproject.org","summary":"This wealthy Wisconsin congressman keeps aggressively trading stocks. A bipartisan bill would ban the practice The Badger Project","title":"This wealthy Wisconsin congressman keeps aggressively trading stocks. A bipartisan bill would ban the practice - The Badger Project","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.z46LtA-qfIg.L.X.O/am=GAIFAACAA2YBAwpA/d=1/ed=1/rs=ALs0n2PeUbKSDKfQ9Op-3wUE_8hlNgDpuA/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 43161 in events