SQLite Web: event_store.db

Update row sig_11ccff7b975a in signals

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

value

{"aggregator_url":"https://www.sec.gov/Archives/edgar/data/1345016/0001950047-26-003483.txt","as_of":"2026-04-16T02:08:52.472606+00:00","canonical_url":"https://www.sec.gov/Archives/edgar/data/1345016/0001950047-26-003483.txt","company":"YELP INC","enrichment":{"aggregator_url":"https://www.sec.gov/Archives/edgar/data/1345016/0001950047-26-003483.txt","article_chars":1873,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_3caf6f90a6286cc1","canonical_host":"sec.gov","canonical_is_aggregator":false,"canonical_url":"https://www.sec.gov/Archives/edgar/data/1345016/0001950047-26-003483.txt","content_type":"text/plain","enriched_at":"2026-04-16T02:11:26.072500+00:00","extraction_method":"trafilatura","fetched_description":"","fetched_title":"","final_url":"https://www.sec.gov/Archives/edgar/data/1345016/0001950047-26-003483.txt","html_truncated":false,"paywall_likely":false,"publisher_domain":"sec.gov","publisher_resolution":"canonical_url","requested_url":"https://www.sec.gov/Archives/edgar/data/1345016/0001950047-26-003483.txt","source_event_id":"evt_14e3e70b1039","source_quality":"medium","status_code":200,"version":"signal_enrichment_v2"},"form_type":"144","fp":"56c29b1800f7729d","kind":"sec_filing","published_at":"20260415","publisher_domain":"sec.gov","signal_understanding":{"analysis_basis":"article","claim_confidence":0.72,"dates_mentioned":["2026-04-15","2026-04-16T02:08:52.472606+00:00","2026-04-15","2025-02-20","2026-03-23","2026-03-12","2025-08-14"],"entities":[{"asset_class":"equity","name":"Yelp Inc.","relevance":"high","symbol":"YELP","type":"issuer"},{"asset_class":"equity","name":"David Schwarzbach","relevance":"high","symbol":"","type":"reporting_owner"},{"asset_class":"unknown","name":"Morgan Stanley Smith Barney LLC","relevance":"medium","symbol":"","type":"broker"}],"event_type":"listing","information_gaps":["What changed vs prior known state is not provided in the signal text (no prior filing state/diff content included).","The text is partially formatted; some fields (e.g., exact nature of each transaction line such as sale vs disposition type) are not fully explicit beyond the Form 144 context.","The filing\u2019s full table structure and mapping of each numeric value to specific fields (shares vs price vs aggregate amount) is not fully clear from the cleaned text alone."],"key_facts":["SEC filing type: Form 144.","Issuer/subject company: YELP INC (CIK 0001345016).","Filed as of date: 2026-04-15; accession number: 0001950047-26-003483.","Reporting owner: David A. Schwarzbach (CIK 0001349334).","Filing includes common stock transactions with share counts and dollar amounts shown in the text.","The text shows multiple transaction dates for common shares (e.g., 02/20/2025, 03/23/2026, 03/12/2026, and 04/15/2026) along with share quantities and prices/amounts.","The filing lists a broker/financial services entity: Morgan Stanley Smith Barney LLC."],"numeric_claims":[{"label":"Transaction shares (example line)","value":"7,500"},{"label":"Transaction price/amount (example line)","value":"$199,471.50"},{"label":"Transaction shares (example line)","value":"59,517,013"},{"label":"Transaction price/amount (example line)","value":"$59517013"},{"label":"Transaction shares (example line)","value":"7,500"},{"label":"Transaction price/amount (example line)","value":"$187,500.00"},{"label":"Transaction shares (example line)","value":"10,000"},{"label":"Transaction price/amount (example line)","value":"$250,000.00"}],"primary_claim":"On 2026-04-15, YELP INC filed SEC Form 144 (accession 0001950047-26-003483) disclosing common stock transactions by David Schwarzbach.","relevance_score":0.55,"sentiment":"neutral","source_quality":"medium","summary":"Yelp Inc. (YELP) filed a Form 144 on 2026-04-15. The filing relates to reported sales/dispositions of common stock by reporting owner David Schwarzbach, with multiple transaction dates and share/price amounts disclosed.","topics":["SEC Form 144","insider/affiliate sale disclosure","common stock","transaction dates","share quantities","broker information"]},"source":"sec_edgar","source_domain":"sec.gov","summary":"Form 144 \u00b7 YELP INC \u00b7 Filed 20260415","ticker":"YELP","tickers":["YELP"],"title":"YELP filed 144","url":"https://www.sec.gov/Archives/edgar/data/1345016/0001950047-26-003483.txt"}

TEXT NOT NULL

threshold

TEXT

direction

TEXT

severity

TEXT

window

TEXT

source

TEXT NOT NULL

reason_trace

TEXT

dedupe_key

TEXT NOT NULL

throttle_s

INTEGER (default 0

created_at

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

Cancel