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-04T16:48:30.779740+00:00","dedupe_key":"signal_enriched:opportunity_research_delta:8ad475f3485deb32","evidence_event_ids":["evt_e3d3e224d0e9"],"signal_type":"opportunity_research_delta","source":"opportunity_research_ingestor","value":{"aggregator_url":"https://www.facebook.com/hartfordcourant/posts/court-records-show-that-he-sexually-assaulted-the-girl-on-multiple-occasions-whi/1353480706809767/","as_of":"2026-04-04T16:48:30.779740+00:00","canonical_url":"https://www.facebook.com/hartfordcourant/posts/court-records-show-that-he-sexually-assaulted-the-girl-on-multiple-occasions-whi/1353480706809767/","enrichment":{"aggregator_url":"https://www.facebook.com/hartfordcourant/posts/court-records-show-that-he-sexually-assaulted-the-girl-on-multiple-occasions-whi/1353480706809767/","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_460e520fff9d5490","canonical_host":"facebook.com","canonical_is_aggregator":false,"canonical_url":"https://www.facebook.com/hartfordcourant/posts/court-records-show-that-he-sexually-assaulted-the-girl-on-multiple-occasions-whi/1353480706809767/","content_type":"text/html; charset=\"utf-8\"","enriched_at":"2026-04-04T17:09:13.678128+00:00","extraction_method":"heuristic","fetched_description":"Court records show that he sexually assaulted the girl on multiple occasions while she was under the age of 13.","fetched_title":"Court records show that he sexually... - Hartford Courant","final_url":"https://www.facebook.com/hartfordcourant/posts/court-records-show-that-he-sexually-assaulted-the-girl-on-multiple-occasions-whi/1353480706809767/","html_truncated":true,"paywall_likely":false,"publisher_domain":"facebook.com","publisher_resolution":"canonical_url","requested_url":"https://www.facebook.com/hartfordcourant/posts/court-records-show-that-he-sexually-assaulted-the-girl-on-multiple-occasions-whi/1353480706809767/","source_event_id":"evt_e3d3e224d0e9","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"7218b917d227934b","published_at":"","publisher_domain":"facebook.com","query":"Lori Ann Flees latest developments Lori Ann Flees acquired deferred stock units corroboration","signal_understanding":{"analysis_basis":"article","claim_confidence":0.95,"dates_mentioned":[],"entities":[{"asset_class":"","name":"Hartford Courant","relevance":"source of information","symbol":"","type":"publisher"}],"event_type":"conflict","information_gaps":["Specific details about the location of the incident are not provided.","No information on the legal proceedings or charges filed against the boys."],"key_facts":["Four boys involved in the incident are under 15 years old.","The assault allegedly involved dragging the girl into a home and using a weapon to threaten her."],"numeric_claims":[],"primary_claim":"Four boys, all under 15, allegedly dragged a girl into a home and forcibly raped her, with two threatening her with a weapon.","relevance_score":0.9,"sentiment":"negative","source_quality":"high","summary":"Court records indicate that four boys under 15 allegedly assaulted a girl, with two of them reportedly threatening her with a weapon.","topics":["sexual assault","juvenile crime","law enforcement"]},"snippet":"Four young boys, all under 15, allegedly drag little girl into home & forcibly rape her, two of them threaten her with weapon: Police.","source":"web_search","source_domain":"facebook.com","summary":"Four young boys, all under 15, allegedly drag little girl into home & forcibly rape her, two of them threaten her with weapon: Police.","title":"Court records show that he sexually assaulted the girl on multiple ...","url":"https://www.facebook.com/hartfordcourant/posts/court-records-show-that-he-sexually-assaulted-the-girl-on-multiple-occasions-whi/1353480706809767/"}}

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 15454 in events