SQLite Web: event

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-04T03:03:53.521137+00:00","dedupe_key":"signal_enriched:discovery_sec_filing_delta:14086c6edc92148f","evidence_event_ids":["evt_f7b8fead4109"],"signal_type":"discovery_sec_filing_delta","source":"discovery_sec_filings","value":{"aggregator_url":"https://www.sec.gov/Archives/edgar/data/1583107/0001898490-26-000006.txt","as_of":"2026-04-04T03:03:53.521137+00:00","canonical_url":"https://www.sec.gov/Archives/edgar/data/1583107/0001898490-26-000006.txt","company":"Theravance Biopharma, Inc.","enrichment":{"aggregator_url":"https://www.sec.gov/Archives/edgar/data/1583107/0001898490-26-000006.txt","article_chars":1466,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_c5a243165b4bd73b","canonical_host":"sec.gov","canonical_is_aggregator":false,"canonical_url":"https://www.sec.gov/Archives/edgar/data/1583107/0001898490-26-000006.txt","content_type":"text/plain","enriched_at":"2026-04-04T03:18:59.671246+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://www.sec.gov/Archives/edgar/data/1583107/0001898490-26-000006.txt","html_truncated":false,"paywall_likely":false,"publisher_domain":"sec.gov","publisher_resolution":"canonical_url","requested_url":"https://www.sec.gov/Archives/edgar/data/1583107/0001898490-26-000006.txt","source_event_id":"evt_f7b8fead4109","source_quality":"medium","status_code":200,"version":"signal_enrichment_v2"},"form_type":"4","fp":"06d50d09bccbe9f8","kind":"sec_filing","published_at":"20260403","publisher_domain":"sec.gov","signal_understanding":{"analysis_basis":"article","claim_confidence":0.9,"dates_mentioned":["2026-04-01","2026-04-03"],"entities":[{"asset_class":"equity","name":"Theravance Biopharma, Inc.","relevance":"issuer","symbol":"TBPH","type":"company"}],"event_type":"other","information_gaps":["No specific details on the nature of ownership change disclosed in the filing."],"key_facts":["Filing Date: April 3, 2026","Form Type: 4","Reporting Owner: Rhonda Farnum","Company Name: Theravance Biopharma, Inc."],"numeric_claims":[],"primary_claim":"Theravance Biopharma, Inc. filed a Form 4 on April 3, 2026.","relevance_score":0.5,"sentiment":"neutral","source_quality":"medium","summary":"Theravance Biopharma, Inc. filed a Form 4 on April 3, 2026, disclosing ownership changes by Rhonda Farnum.","topics":["SEC Filing","Ownership Change"]},"source":"sec_edgar","source_domain":"sec.gov","summary":"Form 4 \u00b7 Theravance Biopharma, Inc. \u00b7 Filed 20260403","ticker":"TBPH","tickers":["TBPH"],"title":"TBPH filed 4","url":"https://www.sec.gov/Archives/edgar/data/1583107/0001898490-26-000006.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')

event_store.db — events

Update row 10794 in events