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.sec.gov/Archives/edgar/data/108985/0000108985-26-000032.txt","as_of":"2026-04-18T03:05:05.644967+00:00","canonical_url":"https://www.sec.gov/Archives/edgar/data/108985/0000108985-26-000032.txt","company":"YORK WATER CO","enrichment":{"aggregator_url":"https://www.sec.gov/Archives/edgar/data/108985/0000108985-26-000032.txt","article_chars":1418,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_0b6d63522a4cf503","canonical_host":"sec.gov","canonical_is_aggregator":false,"canonical_url":"https://www.sec.gov/Archives/edgar/data/108985/0000108985-26-000032.txt","content_type":"text/plain","enriched_at":"2026-04-18T03:07:46.741196+00:00","extraction_method":"trafilatura","fetched_description":"","fetched_title":"","final_url":"https://www.sec.gov/Archives/edgar/data/108985/0000108985-26-000032.txt","html_truncated":false,"paywall_likely":false,"publisher_domain":"sec.gov","publisher_resolution":"canonical_url","requested_url":"https://www.sec.gov/Archives/edgar/data/108985/0000108985-26-000032.txt","source_event_id":"evt_30dd0a5d66d4","source_quality":"medium","status_code":200,"version":"signal_enrichment_v2"},"form_type":"4","fp":"8d993a500b5893b4","kind":"sec_filing","published_at":"20260417","publisher_domain":"sec.gov","signal_understanding":{"analysis_basis":"article","claim_confidence":0.72,"dates_mentioned":["2026-04-16","2026-04-17"],"entities":[{"asset_class":"equity","name":"YORK WATER CO","relevance":"high","symbol":"YORW","type":"issuer"},{"asset_class":"person","name":"Snyder Mark S","relevance":"high","symbol":"","type":"reporting_owner"},{"asset_class":"person","name":"Molly Elizabeth Houck","relevance":"medium","symbol":"","type":"signatory"}],"event_type":"listing","information_gaps":["The cleaned text does not explicitly state whether the Form 4 reflects a purchase, sale, or other transaction type (only that it is Form 4 and includes dividend reinvestment plan shares).","The text includes numeric values (e.g., 10.3, 29.127, 4574.337) but does not label what each number represents (e.g., price per share vs. number of shares vs. total value).","No explicit change vs prior known state is provided in the signal beyond the fact that this filing was discovered; prior state/previous holdings or prior Form 4s are not included."],"key_facts":["SEC accession number: 0000108985-26-000032.","Conformed submission type: Form 4.","Conformed period of report: 2026-04-16.","Filed as of date: 2026-04-17.","Issuer: YORK WATER CO (CIK: 0000108985).","Reporting owner: Mark S. Snyder (CIK: 0001463117).","Security type shown: Common Stock.","Transaction date shown: 2026-04-16.","The filing states: \"Includes shares acquired under The York Water Company dividend reinvestment plan.\"","Signatory: Molly Elizabeth Houck, Assistant Secretary by Power of Attorney (as shown in the text)."],"numeric_claims":[{"label":"Transaction date (period of report)","value":"2026-04-16"},{"label":"Filed as of date","value":"2026-04-17"},{"label":"Reported security price/amount fields","value":"10.3; 29.127; 4574.337 (present in text, but exact meaning not explicitly labeled)"}],"primary_claim":"A Form 4 for YORK WATER CO (YORW) was filed on 2026-04-17 (conformed period of report: 2026-04-16) by reporting owner Mark S. Snyder.","relevance_score":0.55,"sentiment":"neutral","source_quality":"medium","summary":"YORK WATER CO (YORW) filed a Form 4 on 2026-04-17 covering a transaction with reporting owner Mark S. Snyder for the period ending 2026-04-16.","topics":["SEC filing","Form 4","insider transaction disclosure","York Water Company","dividend reinvestment plan"]},"source":"sec_edgar","source_domain":"sec.gov","summary":"Form 4 \u00b7 YORK WATER CO \u00b7 Filed 20260417","ticker":"YORW","tickers":["YORW"],"title":"YORW filed 4","url":"https://www.sec.gov/Archives/edgar/data/108985/0000108985-26-000032.txt"}

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