SQLite Web: event_store.db

Update row 61914 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-17T02:13:18.114675+00:00","dedupe_key":"signal_enriched:discovery_sec_filing_delta:c919d591839b6778","evidence_event_ids":["evt_139a43ad38f4"],"signal_type":"discovery_sec_filing_delta","source":"discovery_sec_filings","value":{"aggregator_url":"https://www.sec.gov/Archives/edgar/data/108985/0000108985-26-000027.txt","as_of":"2026-04-17T02:13:18.114675+00:00","canonical_url":"https://www.sec.gov/Archives/edgar/data/108985/0000108985-26-000027.txt","company":"YORK WATER CO","enrichment":{"aggregator_url":"https://www.sec.gov/Archives/edgar/data/108985/0000108985-26-000027.txt","article_chars":1418,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_1038fd2548f3e507","canonical_host":"sec.gov","canonical_is_aggregator":false,"canonical_url":"https://www.sec.gov/Archives/edgar/data/108985/0000108985-26-000027.txt","content_type":"text/plain","enriched_at":"2026-04-17T03:21:48.801200+00:00","extraction_method":"trafilatura","fetched_description":"","fetched_title":"","final_url":"https://www.sec.gov/Archives/edgar/data/108985/0000108985-26-000027.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-000027.txt","source_event_id":"evt_139a43ad38f4","source_quality":"medium","status_code":200,"version":"signal_enrichment_v2"},"form_type":"4","fp":"cd617c5791c21c14","kind":"sec_filing","published_at":"20260416","publisher_domain":"sec.gov","signal_understanding":{"analysis_basis":"article","claim_confidence":0.62,"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":"Becker Suzanne M","relevance":"high","symbol":"","type":"reporting_owner"},{"asset_class":"person","name":"Molly Elizabeth Houck","relevance":"medium","symbol":"","type":"signatory"}],"event_type":"listing","information_gaps":["The specific transaction type (e.g., buy/sell), number of shares, and exact price/consideration are not explicitly described in the provided cleaned text beyond numeric fields.","No prior known state is included in the prompt, so the \"delta\" (what changed vs prior) cannot be determined from the provided text alone.","No table/footnote context is provided for the numeric values (41.2, 29.127, 119.187), so their financial meaning cannot be confirmed."],"key_facts":["SEC accession number: 0000108985-26-000027.","Form type: 4.","Issuer: YORK WATER CO (YORW).","Reporting owner: Becker Suzanne M (CIK: 0002058774).","Filing/period date shown as 20260416 (filed as of date: 20260416; conform ed period of report: 20260416).","The filing indicates a position/transaction in Common Stock.","The text includes: \"Includes shares acquired under The York Water Company dividend reinvestment plan.\"","Signatory: Molly Elizabeth Houck, Assistant Secretary by Power of Attorney."],"numeric_claims":[{"label":"Common stock price/amount fields shown (as text)","value":"41.2; 29.127; 119.187 (exact meaning not specified in provided text)"}],"primary_claim":"A Form 4 was filed by YORK WATER CO (YORW) on 2026-04-16 for a transaction by reporting owner Becker Suzanne M involving common stock, with shares acquired under the York Water Company dividend reinvestment plan noted.","relevance_score":0.45,"sentiment":"neutral","source_quality":"medium","summary":"YORK WATER CO (YORW) filed a Form 4 on 2026-04-16 reporting a transaction by reporting owner Becker Suzanne M. The filing includes details indicating common stock activity and a dividend reinvestment plan share acquisition note.","topics":["SEC filing","Form 4","insider transaction","common stock","dividend reinvestment plan"]},"source":"sec_edgar","source_domain":"sec.gov","summary":"Form 4 \u00b7 YORK WATER CO \u00b7 Filed 20260416","ticker":"YORW","tickers":["YORW"],"title":"YORW filed 4","url":"https://www.sec.gov/Archives/edgar/data/108985/0000108985-26-000027.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