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-20T17:59:52.099852+00:00","dedupe_key":"signal_enriched:news_delta:a96b08d038520124","evidence_event_ids":["evt_7cb24f2e4feb"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMilAFBVV95cUxOUTNjOWp2UnVBT09SM2h6MkhkRzd4WmhiUklzZ014ekwyMlBWbnBKbjhvV3BscExfX0JjR3R1eTJzcEtWd2dxVnlkYXBVX0t4MWFZMXdPODVuZ3pGTUE4YTltR0QxMG5mSUN4QVJVZFY5Zk1keWxkWm9zNy1KcVBoWEJxd1ktSXNnek1XNEQ5a01JT05z0gGaAUFVX3lxTE5oMEpUa3RoMGFnUDVwT1JiVHB1LWtlU0t5WElaUkRDWUtfV0xRemdfNDFlX212UFhSdXc5aEpsbl9kS25nazluZjFhSUltVUdLTEhpUnRVb25VOTdkWVN6UlA4YjV0NjQ3b2hpV0ZlM1FSYjl1QnRNNDFDYUUwY3dOOW54N0NfdFVpb1Z4YzNSTEJDd3ZJbmFyTEE?oc=5","as_of":"2026-04-20T17:59:52.099852+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.66Y3bu-8kXQ.L.X.O/am=GAIFAACAA2YBAwpA/d=1/ed=1/rs=ALs0n2ORIMICXrbudO7aLun3cEYLx6oJDg/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMilAFBVV95cUxOUTNjOWp2UnVBT09SM2h6MkhkRzd4WmhiUklzZ014ekwyMlBWbnBKbjhvV3BscExfX0JjR3R1eTJzcEtWd2dxVnlkYXBVX0t4MWFZMXdPODVuZ3pGTUE4YTltR0QxMG5mSUN4QVJVZFY5Zk1keWxkWm9zNy1KcVBoWEJxd1ktSXNnek1XNEQ5a01JT05z0gGaAUFVX3lxTE5oMEpUa3RoMGFnUDVwT1JiVHB1LWtlU0t5WElaUkRDWUtfV0xRemdfNDFlX212UFhSdXc5aEpsbl9kS25nazluZjFhSUltVUdLTEhpUnRVb25VOTdkWVN6UlA4YjV0NjQ3b2hpV0ZlM1FSYjl1QnRNNDFDYUUwY3dOOW54N0NfdFVpb1Z4YzNSTEJDd3ZJbmFyTEE?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_01c651a501d65661","canonical_host":"gstatic.com","canonical_is_aggregator":true,"canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.66Y3bu-8kXQ.L.X.O/am=GAIFAACAA2YBAwpA/d=1/ed=1/rs=ALs0n2ORIMICXrbudO7aLun3cEYLx6oJDg/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-20T18:28:42.792015+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMilAFBVV95cUxOUTNjOWp2UnVBT09SM2h6MkhkRzd4WmhiUklzZ014ekwyMlBWbnBKbjhvV3BscExfX0JjR3R1eTJzcEtWd2dxVnlkYXBVX0t4MWFZMXdPODVuZ3pGTUE4YTltR0QxMG5mSUN4QVJVZFY5Zk1keWxkWm9zNy1KcVBoWEJxd1ktSXNnek1XNEQ5a01JT05z0gGaAUFVX3lxTE5oMEpUa3RoMGFnUDVwT1JiVHB1LWtlU0t5WElaUkRDWUtfV0xRemdfNDFlX212UFhSdXc5aEpsbl9kS25nazluZjFhSUltVUdLTEhpUnRVb25VOTdkWVN6UlA4YjV0NjQ3b2hpV0ZlM1FSYjl1QnRNNDFDYUUwY3dOOW54N0NfdFVpb1Z4YzNSTEJDd3ZJbmFyTEE?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"cbsnews.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMilAFBVV95cUxOUTNjOWp2UnVBT09SM2h6MkhkRzd4WmhiUklzZ014ekwyMlBWbnBKbjhvV3BscExfX0JjR3R1eTJzcEtWd2dxVnlkYXBVX0t4MWFZMXdPODVuZ3pGTUE4YTltR0QxMG5mSUN4QVJVZFY5Zk1keWxkWm9zNy1KcVBoWEJxd1ktSXNnek1XNEQ5a01JT05z0gGaAUFVX3lxTE5oMEpUa3RoMGFnUDVwT1JiVHB1LWtlU0t5WElaUkRDWUtfV0xRemdfNDFlX212UFhSdXc5aEpsbl9kS25nazluZjFhSUltVUdLTEhpUnRVb25VOTdkWVN6UlA4YjV0NjQ3b2hpV0ZlM1FSYjl1QnRNNDFDYUUwY3dOOW54N0NfdFVpb1Z4YzNSTEJDd3ZJbmFyTEE?oc=5","source_event_id":"evt_7cb24f2e4feb","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"7c00fc23fe1bc4f7","published_at":"2026-04-20T14:42:00+00:00","publisher_domain":"cbsnews.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.42,"dates_mentioned":[],"entities":[],"event_type":"other","information_gaps":["article_text_unavailable"],"key_facts":["Headline: Neighbors recall \"full-blown shootout\" after father targets children in mass shooting in Shreveport, Louisiana - CBS News","Source summary: Neighbors recall \"full-blown shootout\" after father targets children in mass shooting in Shreveport, Louisiana CBS News Man kills 8 children and shoots his wife and another woman in Shreveport, Louisiana Yahoo Louisiana gunman had sought mental health treatment, relatives say The Washington Post What We Know About the Killing of 8 Children in Louisiana The New York Times Louisiana gunman killed 8 children, including "],"numeric_claims":[],"primary_claim":"Neighbors recall \"full-blown shootout\" after father targets children in mass shooting in Shreveport, Louisiana - CBS News","relevance_score":0.46,"sentiment":"neutral","source_quality":"unknown","summary":"Neighbors recall \"full-blown shootout\" after father targets children in mass shooting in Shreveport, Louisiana CBS News Man kills 8 children and shoots his wife and another woman in Shreveport, Louisiana Yahoo Louisiana gunman had sought mental health treatment, relatives say The Washington Post What We Know About the Killing of 8 Children in Louisiana The New York Times Louisiana gunman killed 8 ","topics":["news headline"]},"source":"CBS News","source_domain":"cbsnews.com","source_url":"https://www.cbsnews.com","summary":"Neighbors recall \"full-blown shootout\" after father targets children in mass shooting in Shreveport, Louisiana CBS News Man kills 8 children and shoots his wife and another woman in Shreveport, Louisiana Yahoo Louisiana gunman had sought mental health treatment, relatives say The Washington Post What We Know About the Killing of 8 Children in Louisiana The New York Times Louisiana gunman killed 8 children, including 7 of his own, police say, in deadliest mass shooting since 2024 CNN","title":"Neighbors recall \"full-blown shootout\" after father targets children in mass shooting in Shreveport, Louisiana - CBS News","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.66Y3bu-8kXQ.L.X.O/am=GAIFAACAA2YBAwpA/d=1/ed=1/rs=ALs0n2ORIMICXrbudO7aLun3cEYLx6oJDg/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 462087 in events