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-05T10:48:51.251304+00:00","dedupe_key":"signal_enriched:opportunity_research_delta:05af46e34a7f81ca","evidence_event_ids":["evt_57bc4e09d64e"],"signal_type":"opportunity_research_delta","source":"opportunity_research_ingestor","value":{"aggregator_url":"https://www.ssga.com/library-content/assets/pdf/global/asset-stewardship/ssim-conflicts-mitigation-guideline.pdf","as_of":"2026-04-05T10:48:51.251304+00:00","canonical_url":"https://www.ssga.com/library-content/assets/pdf/global/asset-stewardship/ssim-conflicts-mitigation-guideline.pdf","enrichment":{"aggregator_url":"https://www.ssga.com/library-content/assets/pdf/global/asset-stewardship/ssim-conflicts-mitigation-guideline.pdf","article_chars":0,"article_truncated":false,"blocked_reason":"unsupported_content_type","candidate_id":"sc_0a9ce29649b07fbf","canonical_host":"ssga.com","canonical_is_aggregator":false,"canonical_url":"https://www.ssga.com/library-content/assets/pdf/global/asset-stewardship/ssim-conflicts-mitigation-guideline.pdf","content_type":"application/pdf","enriched_at":"2026-04-05T22:19:10.796767+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://www.ssga.com/library-content/assets/pdf/global/asset-stewardship/ssim-conflicts-mitigation-guideline.pdf","html_truncated":false,"paywall_likely":false,"publisher_domain":"ssga.com","publisher_resolution":"canonical_url","requested_url":"https://www.ssga.com/library-content/assets/pdf/global/asset-stewardship/ssim-conflicts-mitigation-guideline.pdf","source_event_id":"evt_57bc4e09d64e","source_quality":"blocked","status_code":200,"version":"signal_enrichment_v2"},"fp":"671c769e92d8565b","published_at":"","publisher_domain":"ssga.com","query":"clash between earnings conflicting reports resolution primary sources","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.52,"dates_mentioned":[],"entities":[{"asset_class":"equity","name":"State Street","relevance":"primary","symbol":"","type":"company"},{"asset_class":"asset_manager","name":"State Street Global Advisors (SSGA)","relevance":"source context","symbol":"","type":"publisher"}],"event_type":"regulation","information_gaps":["No article/PDF text was provided beyond the short source summary.","The document title is truncated in the headline; full title, publication date, and jurisdiction/regulatory framework are not available.","No specific criteria details (e.g., thresholds, triggers, scope of shares) are provided.","No frequency/timing details for the periodic review are provided.","No named stakeholders or governance bodies are identified in the provided text."],"key_facts":["Conflict mitigation protocols include predefined criteria to systematically recall shares.","The recall procedure is subject to periodic review by relevant stakeholders."],"numeric_claims":[],"primary_claim":"The conflict mitigation protocols include (1) predefined criteria to systematically recall shares and (2) periodic review of the recall procedure by relevant stakeholders.","relevance_score":0.35,"sentiment":"neutral","source_quality":"blocked","summary":"The provided source summary states that conflict mitigation protocols for State Street investment activities include predefined criteria for systematically recalling shares and periodic review of the recall procedure by relevant stakeholders.","topics":["conflicts of interest","conflict mitigation protocols","share recall procedures","governance","stakeholder review"]},"snippet":"The conflict mitigation protocols include predefining criteria to systematically recall shares, periodic review of the recall procedure by relevant stakeholders ...","source":"web_search","source_domain":"ssga.com","summary":"The conflict mitigation protocols include predefining criteria to systematically recall shares, periodic review of the recall procedure by relevant stakeholders ...","title":"[PDF] Managing Conflicts of Interest Arising from State Street Investment ...","url":"https://www.ssga.com/library-content/assets/pdf/global/asset-stewardship/ssim-conflicts-mitigation-guideline.pdf"}}

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 24501 in events