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-04T07:18:17.308799+00:00","dedupe_key":"signal_enriched:opportunity_research_delta:7a0f897d64fcbe1e","evidence_event_ids":["evt_f44154713e68"],"signal_type":"opportunity_research_delta","source":"opportunity_research_ingestor","value":{"aggregator_url":"https://www.facebook.com/KSAT12/posts/a-trio-of-council-members-had-pushed-to-get-a-non-binding-resolution-to-support-/1396633442503093/","as_of":"2026-04-04T07:18:17.308799+00:00","canonical_url":"https://www.facebook.com/KSAT12/posts/a-trio-of-council-members-had-pushed-to-get-a-non-binding-resolution-to-support-/1396633442503093/","enrichment":{"aggregator_url":"https://www.facebook.com/KSAT12/posts/a-trio-of-council-members-had-pushed-to-get-a-non-binding-resolution-to-support-/1396633442503093/","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_28160d82ddb28dcf","canonical_host":"facebook.com","canonical_is_aggregator":false,"canonical_url":"https://www.facebook.com/KSAT12/posts/a-trio-of-council-members-had-pushed-to-get-a-non-binding-resolution-to-support-/1396633442503093/","content_type":"text/html; charset=\"utf-8\"","enriched_at":"2026-04-04T07:18:45.835945+00:00","extraction_method":"heuristic","fetched_description":"A trio of council members had pushed to get a non-binding resolution to support adding 65 officers in the Fiscal Year 2027 budget onto Thursday\u2019s agenda. But they joined their colleagues in pushing...","fetched_title":"A trio of council members had pushed... - KSAT 12 & KSAT.com","final_url":"https://www.facebook.com/KSAT12/posts/a-trio-of-council-members-had-pushed-to-get-a-non-binding-resolution-to-support-/1396633442503093/","html_truncated":true,"paywall_likely":false,"publisher_domain":"facebook.com","publisher_resolution":"canonical_url","requested_url":"https://www.facebook.com/KSAT12/posts/a-trio-of-council-members-had-pushed-to-get-a-non-binding-resolution-to-support-/1396633442503093/","source_event_id":"evt_f44154713e68","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"6d26847d057df20a","published_at":"","publisher_domain":"facebook.com","query":"BURU earnings are conflicting reports resolution primary sources","signal_understanding":{"analysis_basis":"article","claim_confidence":0.9,"dates_mentioned":[],"entities":[{"asset_class":"public sector","name":"council members","relevance":"advocates for budget changes","symbol":"","type":"government"}],"event_type":"other","information_gaps":["No details on the council members' identities or political affiliations","No information on public or other council members' reactions to the proposal"],"key_facts":["65 officers proposed for addition in Fiscal Year 2027 budget","Resolution is non-binding"],"numeric_claims":[{"label":"number of officers proposed","value":"65"}],"primary_claim":"The council members are pushing for a resolution to add 65 officers to the Fiscal Year 2027 budget.","relevance_score":0.8,"sentiment":"positive","source_quality":"high","summary":"A trio of council members is advocating for a non-binding resolution to include the addition of 65 officers in the Fiscal Year 2027 budget agenda.","topics":["budget","law enforcement","government resolution"]},"snippet":"A trio of council members had pushed to get a non-binding resolution to support adding 65 officers in the Fiscal Year 2027 budget onto Thursday's agenda....","source":"web_search","source_domain":"facebook.com","summary":"A trio of council members had pushed to get a non-binding resolution to support adding 65 officers in the Fiscal Year 2027 budget onto Thursday's agenda....","title":"A trio of council members had pushed to get a non - Facebook","url":"https://www.facebook.com/KSAT12/posts/a-trio-of-council-members-had-pushed-to-get-a-non-binding-resolution-to-support-/1396633442503093/"}}

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