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-07T03:18:43.308311+00:00","dedupe_key":"signal_enriched:discovery_sec_filing_delta:23d1bb0efe3b1a5d","evidence_event_ids":["evt_6cf85a78a498"],"signal_type":"discovery_sec_filing_delta","source":"discovery_sec_filings","value":{"aggregator_url":"https://www.sec.gov/Archives/edgar/data/1175535/0001437749-26-011427.txt","as_of":"2026-04-07T03:18:43.308311+00:00","canonical_url":"https://www.sec.gov/Archives/edgar/data/1175535/0001437749-26-011427.txt","company":"Whitestone REIT","enrichment":{"aggregator_url":"https://www.sec.gov/Archives/edgar/data/1175535/0001437749-26-011427.txt","article_chars":1519,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_b63485a6d41c75bd","canonical_host":"sec.gov","canonical_is_aggregator":false,"canonical_url":"https://www.sec.gov/Archives/edgar/data/1175535/0001437749-26-011427.txt","content_type":"text/plain","enriched_at":"2026-04-07T04:54:00.346178+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://www.sec.gov/Archives/edgar/data/1175535/0001437749-26-011427.txt","html_truncated":false,"paywall_likely":false,"publisher_domain":"sec.gov","publisher_resolution":"canonical_url","requested_url":"https://www.sec.gov/Archives/edgar/data/1175535/0001437749-26-011427.txt","source_event_id":"evt_6cf85a78a498","source_quality":"medium","status_code":200,"version":"signal_enrichment_v2"},"form_type":"4","fp":"6d3d527e13f0e748","kind":"sec_filing","published_at":"20260406","publisher_domain":"sec.gov","signal_understanding":{"analysis_basis":"article","claim_confidence":0.9,"dates_mentioned":["2026-04-06","2026-04-01"],"entities":[{"asset_class":"REIT","name":"Whitestone REIT","relevance":"high","symbol":"WSR","type":"issuer"}],"event_type":"listing","information_gaps":["No prior known state for comparison provided."],"key_facts":["Form 4 filed on April 6, 2026","Reporting owner: Peter Tropoli","Transaction involves restricted common share units under the 2018 Long-Term Equity Incentive Ownership Plan."],"numeric_claims":[],"primary_claim":"Whitestone REIT filed a Form 4 on April 6, 2026, reporting a transaction related to restricted common share units.","relevance_score":0.7,"sentiment":"neutral","source_quality":"medium","summary":"Whitestone REIT filed a Form 4 on April 6, 2026, disclosing a transaction involving restricted common share units granted to Peter Tropoli.","topics":["SEC Filing","Equity Incentive Plan"]},"source":"sec_edgar","source_domain":"sec.gov","summary":"Form 4 \u00b7 Whitestone REIT \u00b7 Filed 20260406","ticker":"WSR","tickers":["WSR"],"title":"WSR filed 4","url":"https://www.sec.gov/Archives/edgar/data/1175535/0001437749-26-011427.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 35483 in events