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/CBMihwFBVV95cUxOX1ZZUW9IenZkUzF6QXh5YWp1Z0VpelpLbmt2cGFhZjJNbTN5cXNDdHpzdnU2T0RScDRSYWQ5amViVU5qOVRoVy0tN0FUQ1ctaFlkaGhDWUVRdzc4ZkZ3TVhyQ1d4MXUwUmNKVDlvS21oOW5rMkphVVBBeE45ZzRjckRQNVh6aVk?oc=5","as_of":"2026-04-09T04:35:26.110977+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/CBMihwFBVV95cUxOX1ZZUW9IenZkUzF6QXh5YWp1Z0VpelpLbmt2cGFhZjJNbTN5cXNDdHpzdnU2T0RScDRSYWQ5amViVU5qOVRoVy0tN0FUQ1ctaFlkaGhDWUVRdzc4ZkZ3TVhyQ1d4MXUwUmNKVDlvS21oOW5rMkphVVBBeE45ZzRjckRQNVh6aVk?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_6f750e3de0cbd51e","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:37:39.415432+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMihwFBVV95cUxOX1ZZUW9IenZkUzF6QXh5YWp1Z0VpelpLbmt2cGFhZjJNbTN5cXNDdHpzdnU2T0RScDRSYWQ5amViVU5qOVRoVy0tN0FUQ1ctaFlkaGhDWUVRdzc4ZkZ3TVhyQ1d4MXUwUmNKVDlvS21oOW5rMkphVVBBeE45ZzRjckRQNVh6aVk?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"theguardian.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMihwFBVV95cUxOX1ZZUW9IenZkUzF6QXh5YWp1Z0VpelpLbmt2cGFhZjJNbTN5cXNDdHpzdnU2T0RScDRSYWQ5amViVU5qOVRoVy0tN0FUQ1ctaFlkaGhDWUVRdzc4ZkZ3TVhyQ1d4MXUwUmNKVDlvS21oOW5rMkphVVBBeE45ZzRjckRQNVh6aVk?oc=5","source_event_id":"evt_a37ca139cb86","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"f7342a98d7115846","published_at":"2026-04-09T02:03:00+00:00","publisher_domain":"theguardian.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.72,"dates_mentioned":[],"entities":[{"asset_class":"government","name":"FBI","relevance":"primary law-enforcement actor","symbol":"","type":"government_agency"},{"asset_class":"person","name":"Former Fort Bragg employee","relevance":"suspect/defendant","symbol":"","type":"individual"},{"asset_class":"military_installation","name":"Fort Bragg","relevance":"employment/location tied to the alleged leak","symbol":"","type":"military_base"},{"asset_class":"media","name":"The Guardian","relevance":"journalist/publication allegedly receiving leaked information","symbol":"","type":"news_outlet"},{"asset_class":"media","name":"Fox News","relevance":"referenced in source summary as another outlet tied to the alleged leak (uncertain from provided text)","symbol":"","type":"news_outlet"},{"asset_class":"media","name":"Reuters","relevance":"referenced in source summary as another outlet tied to the alleged leak (uncertain from provided text)","symbol":"","type":"news_outlet"},{"asset_class":"media","name":"The Hill","relevance":"referenced in source summary as another outlet tied to the alleged leak (uncertain from provided text)","symbol":"","type":"news_outlet"},{"asset_class":"military_unit","name":"Delta Force","relevance":"referenced in source summary as the alleged subject of disclosed tactics (uncertain from provided text)","symbol":"","type":"military_unit"}],"event_type":"conflict","information_gaps":["The cleaned article text provided contains no readable body content beyond page styling; only the headline and the external source summary are usable here.","The suspect\u2019s name, the specific charges, the date of arrest, and the exact classified material allegedly disclosed are not present in the provided text.","It is unclear whether the journalist/publication in the Guardian story is the same as the Fox News/Reuters/The Hill references mentioned in the source summary.","The extent to which \u201cDelta Force tactics\u201d are part of the Guardian case specifically is uncertain from the provided material."],"key_facts":["FBI arrested a former Fort Bragg employee/veteran in connection with an alleged classified leak to a journalist (per The Guardian headline).","The alleged leak involves classified military information (per headline).","The provided source summary indicates the individual was charged and references other outlets and alleged disclosure of Delta Force tactics, but these details are not fully verifiable from the provided cleaned article text (uncertain)."],"numeric_claims":[],"primary_claim":"The FBI arrested a former Fort Bragg employee over an alleged classified leak to a journalist.","relevance_score":0.78,"sentiment":"negative","source_quality":"high","summary":"The FBI has arrested a former Fort Bragg employee/veteran in connection with an alleged leak of classified military information to a journalist, as reported by The Guardian. The case centers on unauthorized disclosure of classified material, with near-term implications for ongoing investigations and potential legal proceedings.","topics":["FBI arrest","classified information leak","military secrecy","journalism","national security","criminal charges"]},"source":"The Guardian","source_domain":"theguardian.com","source_url":"https://www.theguardian.com","summary":"FBI arrests ex-Fort Bragg employee over alleged classified leak to journalist The Guardian Former Fort Bragg employee charged with leaking classified military information to journalist Fox News US Army veteran charged with leaking classified information to journalist Reuters Ex-Army employee with top-secret clearance charged with leaking information to journalist The Hill Army veteran charged with disclosing classified Delta Force tactics Politico","title":"FBI arrests ex-Fort Bragg employee over alleged classified leak to journalist - The Guardian","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_e09a00e42732 in signals