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.rsd.edu/district/policies/5000-series-personnel/policy-5240","as_of":"2026-04-05T02:19:27.134561+00:00","canonical_url":"https://www.rsd.edu/district/policies/5000-series-personnel/policy-5240","enrichment":{"aggregator_url":"https://www.rsd.edu/district/policies/5000-series-personnel/policy-5240","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_04d8bfccbf6cddcd","canonical_host":"rsd.edu","canonical_is_aggregator":false,"canonical_url":"https://www.rsd.edu/district/policies/5000-series-personnel/policy-5240","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-05T15:31:54.000437+00:00","extraction_method":"heuristic","fetched_description":"Policy 5240 - Resolution of Staff Complaints for Non-Contracted Bargaining Unit Employees - Richland School District","fetched_title":"Policy 5240 - Resolution of Staff Complaints for Non-Contracted Bargaining Unit Employees - Richland School District","final_url":"https://www.rsd.edu/district/policies/5000-series-personnel/policy-5240","html_truncated":false,"paywall_likely":false,"publisher_domain":"rsd.edu","publisher_resolution":"canonical_url","requested_url":"https://www.rsd.edu/district/policies/5000-series-personnel/policy-5240","source_event_id":"evt_013ae2fdfed2","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"9e2528666ed500ac","published_at":"","publisher_domain":"rsd.edu","query":"clash between earnings conflicting reports resolution primary sources","signal_understanding":{"analysis_basis":"article","claim_confidence":0.9,"dates_mentioned":[],"entities":[{"asset_class":"education","name":"RSD","relevance":"high","symbol":"","type":"organization"}],"event_type":"research","information_gaps":["Specific details on the grievance process are not provided in the text."],"key_facts":["The document includes policies on various topics such as harassment, discrimination, and special education services.","Grievances can arise from violations of contracts or misapplications of policies."],"numeric_claims":[],"primary_claim":"A grievance may be a claim by a staff member based upon alleged violation, misinterpretation or a misapplication of existing contract, district policies, or procedures.","relevance_score":0.8,"sentiment":"neutral","source_quality":"high","summary":"The document outlines various district policies related to staff complaints, including grievance procedures for alleged violations of contracts or policies.","topics":["staff complaints","grievance procedures","district policies"]},"snippet":"A grievance may be a claim by a staff member based upon alleged violation, misinterpretation or a misapplication of existing contract, district policies, or ...","source":"web_search","source_domain":"rsd.edu","summary":"A grievance may be a claim by a staff member based upon alleged violation, misinterpretation or a misapplication of existing contract, district policies, or ...","title":"Policy 5240 - Resolution of Staff Complaints for Non-Contracted ...","url":"https://www.rsd.edu/district/policies/5000-series-personnel/policy-5240"}

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