SQLite Web: event_store.db

Update row 126987 in events

seq

Primary key. INTEGER

id

TEXT NOT NULL

kind

TEXT NOT NULL

ts

TEXT NOT NULL

actor

TEXT

subject_entity_ids

TEXT

payload

{"created_at":"2026-04-18T03:05:05.644967+00:00","dedupe_key":"signal_enriched:discovery_sec_filing_delta:01b578ad78af9e52","evidence_event_ids":["evt_30dd0a5d66d4"],"signal_type":"discovery_sec_filing_delta","source":"discovery_sec_filings","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

source_ref

TEXT

confidence

REAL (default 0.0

dedupe_key

TEXT

episode_id

TEXT

created_at

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

Cancel