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-04T20:18:34.866063+00:00","dedupe_key":"signal_enriched:opportunity_research_delta:01227eea22a3b012","evidence_event_ids":["evt_b4d0f4ca7eda"],"signal_type":"opportunity_research_delta","source":"opportunity_research_ingestor","value":{"aggregator_url":"https://www.facebook.com/groups/hvacbusinessownerscontractors/posts/1699565124730365/","as_of":"2026-04-04T20:18:34.866063+00:00","canonical_url":"https://www.facebook.com/groups/hvacbusinessownerscontractors/posts/1699565124730365/","enrichment":{"aggregator_url":"https://www.facebook.com/groups/hvacbusinessownerscontractors/posts/1699565124730365/","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_cd8c7355203b8b70","canonical_host":"facebook.com","canonical_is_aggregator":false,"canonical_url":"https://www.facebook.com/groups/hvacbusinessownerscontractors/posts/1699565124730365/","content_type":"text/html; charset=\"utf-8\"","enriched_at":"2026-04-05T03:37:04.180534+00:00","extraction_method":"heuristic","fetched_description":"Before I ask my question I want to mention I purchased a small but long standing company last year. I had one of his existing customers recently complain about my pricing and how I\u2019m not treating...","fetched_title":"HVAC Business Owners & Contractors | Before I ask my question I want to mention I purchased a small but long standing company last year","final_url":"https://www.facebook.com/groups/hvacbusinessownerscontractors/posts/1699565124730365/","html_truncated":true,"paywall_likely":false,"publisher_domain":"facebook.com","publisher_resolution":"canonical_url","requested_url":"https://www.facebook.com/groups/hvacbusinessownerscontractors/posts/1699565124730365/","source_event_id":"evt_b4d0f4ca7eda","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"9b298eccfba30887","published_at":"","publisher_domain":"facebook.com","query":"Trane Technologies had conflicting reports resolution primary sources","signal_understanding":{"analysis_basis":"article","claim_confidence":0.9,"dates_mentioned":[],"entities":[{"asset_class":"","name":"HVAC Business Owners & Contractors","relevance":"context","symbol":"","type":"organization"}],"event_type":"other","information_gaps":["Details on the specific reasons for the charge are not provided.","No information on the company's pricing strategy or market position."],"key_facts":["The charge for replacing two thermostats was $300.","The thermostats were supplied by the customer."],"numeric_claims":[],"primary_claim":"The owner of a commercial account complained about a $300 charge for replacing two thermostats.","relevance_score":0.7,"sentiment":"negative","source_quality":"high","summary":"A commercial account owner expressed dissatisfaction over a $300 charge for replacing two customer-supplied thermostats, indicating potential pricing concerns in the HVAC service market.","topics":["HVAC","customer service","pricing"]},"snippet":"This is a commercial account. He complained that I was going to charge $300 total to replace 2 thermostats side by side (customer supplied). Then goes on to ...","source":"web_search","source_domain":"facebook.com","summary":"This is a commercial account. He complained that I was going to charge $300 total to replace 2 thermostats side by side (customer supplied). Then goes on to ...","title":"Before I ask my question I want to mention I purchased a small but ...","url":"https://www.facebook.com/groups/hvacbusinessownerscontractors/posts/1699565124730365/"}}

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