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-04T22:19:02.134189+00:00","dedupe_key":"signal_enriched:opportunity_research_delta:3c652835ac9f8e6e","evidence_event_ids":["evt_8e91d9557015"],"signal_type":"opportunity_research_delta","source":"opportunity_research_ingestor","value":{"aggregator_url":"https://www.facebook.com/johnsmithmarketingnashville/posts/in-jan-2025-he-said-elon-musk-was-going-the-balance-the-budget-with-doge-finding/1514476846912106/","as_of":"2026-04-04T22:19:02.134189+00:00","canonical_url":"https://www.facebook.com/johnsmithmarketingnashville/posts/in-jan-2025-he-said-elon-musk-was-going-the-balance-the-budget-with-doge-finding/1514476846912106/","enrichment":{"aggregator_url":"https://www.facebook.com/johnsmithmarketingnashville/posts/in-jan-2025-he-said-elon-musk-was-going-the-balance-the-budget-with-doge-finding/1514476846912106/","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_40fe91741d4dc0e0","canonical_host":"facebook.com","canonical_is_aggregator":false,"canonical_url":"https://www.facebook.com/johnsmithmarketingnashville/posts/in-jan-2025-he-said-elon-musk-was-going-the-balance-the-budget-with-doge-finding/1514476846912106/","content_type":"text/html; charset=\"utf-8\"","enriched_at":"2026-04-05T05:05:49.352720+00:00","extraction_method":"heuristic","fetched_description":"In Jan 2025, he said Elon Musk was going the balance the budget with DOGE finding fraud. On 2/2/25 he said tariffs would balance the budget. On 6/2 he said OBBB would balance the budget. On 6/12...","fetched_title":"In Jan 2025, he said Elon Musk was... - John Smith Marketing","final_url":"https://www.facebook.com/johnsmithmarketingnashville/posts/in-jan-2025-he-said-elon-musk-was-going-the-balance-the-budget-with-doge-finding/1514476846912106/","html_truncated":true,"paywall_likely":false,"publisher_domain":"facebook.com","publisher_resolution":"canonical_url","requested_url":"https://www.facebook.com/johnsmithmarketingnashville/posts/in-jan-2025-he-said-elon-musk-was-going-the-balance-the-budget-with-doge-finding/1514476846912106/","source_event_id":"evt_8e91d9557015","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"1ae617987281bd97","published_at":"","publisher_domain":"facebook.com","query":"Dogecoin DOGE has conflicting reports resolution primary sources","signal_understanding":{"analysis_basis":"article","claim_confidence":0.9,"dates_mentioned":["January 2025","February 2, 2025"],"entities":[{"asset_class":"N/A","name":"Elon Musk","relevance":"high","symbol":"N/A","type":"individual"},{"asset_class":"crypto","name":"DOGE","relevance":"high","symbol":"DOGE","type":"cryptocurrency"}],"event_type":"research","information_gaps":["No specific details on how DOGE would be used to find fraud.","No further context on the implications of tariffs for budget balancing."],"key_facts":["Elon Musk mentioned in January 2025 regarding budget balancing.","DOGE was proposed as a tool for finding fraud.","Tariffs were mentioned as a means to balance the budget on February 2, 2025."],"numeric_claims":[],"primary_claim":"Elon Musk was said to balance the budget with DOGE and tariffs in early 2025.","relevance_score":0.8,"sentiment":"neutral","source_quality":"high","summary":"In January 2025, it was stated that Elon Musk would balance the budget using DOGE to find fraud, and on February 2, 2025, it was mentioned that tariffs would also help balance the budget.","topics":["budget balancing","cryptocurrency","tariffs"]},"snippet":"In Jan 2025, he said Elon Musk was going the balance the budget with DOGE finding fraud. On 2/2/25 he said tariffs would balance the budget. On 6/2 he...","source":"web_search","source_domain":"facebook.com","summary":"In Jan 2025, he said Elon Musk was going the balance the budget with DOGE finding fraud. On 2/2/25 he said tariffs would balance the budget. On 6/2 he...","title":"In Jan 2025, he said Elon Musk was going the balance the budget ...","url":"https://www.facebook.com/johnsmithmarketingnashville/posts/in-jan-2025-he-said-elon-musk-was-going-the-balance-the-budget-with-doge-finding/1514476846912106/"}}

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