SQLite Web: event

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

value

{"aggregator_url":"https://news.google.com/rss/articles/CBMiwwFBVV95cUxPc1dUQXg0dGI5NExfUTQ0eEZ0bHV1cW5oRlRIektVTlloa09uSWlyalE4TmxFYWRqaXF2bHhCQTlJQ0dKU3J4Z0ZuTlJkSVVvdXNZa3k4elpqRHpiWFRDV3Y5T3R0bW9mOE5rRXJMTHVKMUFoV1kxZDd2RzVDUUsxTWdSNGZ3ZFZCcnprbGpqeUlQcjR4N3JYZVFqTjYwVG5sTkl4MzFMU0dGYm5icDRMLTNZSmJXTEJIMVlCZW51UHR1OGs?oc=5","as_of":"2026-04-09T03:57:11.890652+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/CBMiwwFBVV95cUxPc1dUQXg0dGI5NExfUTQ0eEZ0bHV1cW5oRlRIektVTlloa09uSWlyalE4TmxFYWRqaXF2bHhCQTlJQ0dKU3J4Z0ZuTlJkSVVvdXNZa3k4elpqRHpiWFRDV3Y5T3R0bW9mOE5rRXJMTHVKMUFoV1kxZDd2RzVDUUsxTWdSNGZ3ZFZCcnprbGpqeUlQcjR4N3JYZVFqTjYwVG5sTkl4MzFMU0dGYm5icDRMLTNZSmJXTEJIMVlCZW51UHR1OGs?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_0b97cb81a667ed35","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-09T22:34:47.514951+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiwwFBVV95cUxPc1dUQXg0dGI5NExfUTQ0eEZ0bHV1cW5oRlRIektVTlloa09uSWlyalE4TmxFYWRqaXF2bHhCQTlJQ0dKU3J4Z0ZuTlJkSVVvdXNZa3k4elpqRHpiWFRDV3Y5T3R0bW9mOE5rRXJMTHVKMUFoV1kxZDd2RzVDUUsxTWdSNGZ3ZFZCcnprbGpqeUlQcjR4N3JYZVFqTjYwVG5sTkl4MzFMU0dGYm5icDRMLTNZSmJXTEJIMVlCZW51UHR1OGs?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"nbcnews.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiwwFBVV95cUxPc1dUQXg0dGI5NExfUTQ0eEZ0bHV1cW5oRlRIektVTlloa09uSWlyalE4TmxFYWRqaXF2bHhCQTlJQ0dKU3J4Z0ZuTlJkSVVvdXNZa3k4elpqRHpiWFRDV3Y5T3R0bW9mOE5rRXJMTHVKMUFoV1kxZDd2RzVDUUsxTWdSNGZ3ZFZCcnprbGpqeUlQcjR4N3JYZVFqTjYwVG5sTkl4MzFMU0dGYm5icDRMLTNZSmJXTEJIMVlCZW51UHR1OGs?oc=5","source_event_id":"evt_789d7ead582a","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"e1ba2b6403e78ef9","published_at":"2026-04-09T01:28:00+00:00","publisher_domain":"nbcnews.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.74,"dates_mentioned":[],"entities":[{"asset_class":"other","name":"Former Army employee","relevance":"primary subject","symbol":"","type":"person"},{"asset_class":"other","name":"NBC News","relevance":"reporting source","symbol":"","type":"media_outlet"},{"asset_class":"other","name":"Fort Bragg","relevance":"employment/connection mentioned in source summary","symbol":"","type":"location"},{"asset_class":"other","name":"Delta Force","relevance":"classified tactics referenced in source summary","symbol":"","type":"military_unit"},{"asset_class":"other","name":"FBI","relevance":"mentioned in source summary as making arrests","symbol":"","type":"agency"}],"event_type":"regulation","information_gaps":["The article text content was not actually provided (only page styling/HTML), so details such as the defendant\u2019s name, charge specifics, court, date of filing, and the exact nature of the leaked materials are not available.","No information is provided here about the journalist\u2019s identity, the publication, or when the alleged leak occurred.","No details are provided about potential national-security impact beyond the general description of classified military/Delta Force tactics."],"key_facts":["NBC News headline states a former Army employee has been charged with leaking classified information to a journalist.","Source summary indicates the person was a former Fort Bragg employee.","Source summary indicates the alleged disclosure involved classified military information and references to Delta Force tactics.","Source summary indicates the FBI arrested the ex-Fort Bragg employee (timing and jurisdiction not specified in provided text)."],"numeric_claims":[],"primary_claim":"A former Army employee has been charged with leaking classified information to a journalist (NBC News).","relevance_score":0.62,"sentiment":"neutral","source_quality":"high","summary":"NBC News reports that a former Army employee has been charged with leaking classified information to a journalist. The alleged leak involves classified military material, including references to Delta Force tactics.","topics":["classified information","leaks","criminal charges","military intelligence","Delta Force tactics","FBI investigation","journalist source"]},"source":"NBC News","source_domain":"nbcnews.com","source_url":"https://www.nbcnews.com","summary":"Former Army employee charged with leaking classified info to journalist NBC News Former Fort Bragg employee charged with leaking classified military information to journalist Fox News Army veteran charged with disclosing classified Delta Force tactics Politico FBI arrests ex-Fort Bragg employee over alleged classified leak to journalist The Guardian Ex-Army employee charged with leaking classified military information to reporter CBS News","title":"Former Army employee charged with leaking classified info to journalist - NBC News","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

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_8f834e20e46c in signals