SQLite Web: event

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

value

{"aggregator_url":"https://www.facebook.com/wkdzradio/posts/trigg-county-lepc-makes-plans-in-first-quarter-2026/1833980121251174/","as_of":"2026-04-03T18:48:05.078136+00:00","canonical_url":"https://www.facebook.com/wkdzradio/posts/trigg-county-lepc-makes-plans-in-first-quarter-2026/1833980121251174/","enrichment":{"aggregator_url":"https://www.facebook.com/wkdzradio/posts/trigg-county-lepc-makes-plans-in-first-quarter-2026/1833980121251174/","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_90b3ebd9448d75e7","canonical_host":"facebook.com","canonical_is_aggregator":false,"canonical_url":"https://www.facebook.com/wkdzradio/posts/trigg-county-lepc-makes-plans-in-first-quarter-2026/1833980121251174/","content_type":"text/html; charset=\"utf-8\"","enriched_at":"2026-04-04T01:14:45.118613+00:00","extraction_method":"heuristic","fetched_description":"Trigg County LEPC Makes Plans In First Quarter 2026","fetched_title":"WKDZ - Trigg County LEPC Makes Plans In First Quarter 2026","final_url":"https://www.facebook.com/wkdzradio/posts/trigg-county-lepc-makes-plans-in-first-quarter-2026/1833980121251174/","html_truncated":true,"paywall_likely":false,"publisher_domain":"facebook.com","publisher_resolution":"canonical_url","requested_url":"https://www.facebook.com/wkdzradio/posts/trigg-county-lepc-makes-plans-in-first-quarter-2026/1833980121251174/","source_event_id":"evt_0568d5ea9c56","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"41df12d824913622","published_at":"","publisher_domain":"facebook.com","query":"MLEC earnings are conflicting reports resolution primary sources","signal_understanding":{"analysis_basis":"article","claim_confidence":0.9,"dates_mentioned":["May 19, 2026"],"entities":[{"asset_class":"government","name":"Trigg County LEPC","relevance":"primary","symbol":"","type":"organization"}],"event_type":"other","information_gaps":["No specific details on the plans made by Trigg County LEPC were provided."],"key_facts":["Primary Election Day is scheduled for May 19, 2026, with polls open from 6 a.m. to 6 p.m. prevailing time."],"numeric_claims":[],"primary_claim":"Trigg County LEPC has made plans for the first quarter of 2026.","relevance_score":0.7,"sentiment":"neutral","source_quality":"high","summary":"Trigg County LEPC is planning activities for the first quarter of 2026, coinciding with the Primary Election Day on May 19, 2026.","topics":["local government","elections","planning"]},"snippet":"Primary Election Day: May 19, 2026 (polls open 6 a.m. to 6 p.m. prevailing time). If you have any questions about these positions, you can contact Carmen Finley ...","source":"web_search","source_domain":"facebook.com","summary":"Primary Election Day: May 19, 2026 (polls open 6 a.m. to 6 p.m. prevailing time). If you have any questions about these positions, you can contact Carmen Finley ...","title":"Trigg County LEPC Makes Plans In First Quarter 2026 - Facebook","url":"https://www.facebook.com/wkdzradio/posts/trigg-county-lepc-makes-plans-in-first-quarter-2026/1833980121251174/"}

TEXT NOT NULL

threshold

TEXT

direction

TEXT

severity

TEXT

window

TEXT

source

TEXT NOT NULL

reason_trace

TEXT

dedupe_key

TEXT NOT NULL

throttle_s

INTEGER (default 0

created_at

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

event_store.db — signals

Update row sig_039df71df15f in signals