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-04T23:48:54.613426+00:00","dedupe_key":"signal_enriched:opportunity_research_delta:4323035165b39b46","evidence_event_ids":["evt_c50c5003fa8c"],"signal_type":"opportunity_research_delta","source":"opportunity_research_ingestor","value":{"aggregator_url":"https://www.sciencedirect.com/science/article/pii/S221242092600066X","as_of":"2026-04-04T23:48:54.613426+00:00","canonical_url":"https://www.sciencedirect.com/science/article/pii/S221242092600066X","enrichment":{"aggregator_url":"https://www.sciencedirect.com/science/article/pii/S221242092600066X","article_chars":0,"article_truncated":false,"blocked_reason":"http_403","candidate_id":"sc_8dc2f6e7e9b00543","canonical_host":"sciencedirect.com","canonical_is_aggregator":false,"canonical_url":"https://www.sciencedirect.com/science/article/pii/S221242092600066X","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-05T09:35:22.052528+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://www.sciencedirect.com/science/article/pii/S221242092600066X","html_truncated":false,"paywall_likely":true,"publisher_domain":"sciencedirect.com","publisher_resolution":"canonical_url","requested_url":"https://www.sciencedirect.com/science/article/pii/S221242092600066X","source_event_id":"evt_c50c5003fa8c","source_quality":"blocked","status_code":403,"version":"signal_enrichment_v2"},"fp":"eb27a0cc712d37d2","published_at":"","publisher_domain":"sciencedirect.com","query":"Aster moved last latest developments Aster moved last hours corroboration","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.30000000000000004,"dates_mentioned":[],"entities":[{"asset_class":"","name":"Part-time firefighters (PTFs)","relevance":"primary subject","symbol":"","type":"occupation_group"},{"asset_class":"","name":"Rural Norway","relevance":"context","symbol":"","type":"location"}],"event_type":"other","information_gaps":["No article text is available; only the provided headline and source summary were used.","No quantitative details (e.g., training hours, staffing levels, budget/resource measures) are provided.","No specific employer/agency, policy, or program details are included.","The signal does not identify any measurable outcomes or evidence cited in the (unavailable) article."],"key_facts":["Part-time firefighters (PTFs) in rural Norway are employed in minor positions.","PTFs have little formal training.","PTFs often have few resources."],"numeric_claims":[],"primary_claim":"Part-time firefighters in rural Norway are employed in minor positions, have little formal training, and often few resources.","relevance_score":0.25,"sentiment":"neutral","source_quality":"blocked","summary":"The signal describes part-time firefighters in rural Norway as holding minor roles with limited formal training and few resources.","topics":["public safety","firefighting workforce","rural emergency services","training and resources"]},"snippet":"Part-time firefighters (PTFs) in rural Norway are employed in minor positions, have little formal training and often few resources.","source":"web_search","source_domain":"sciencedirect.com","summary":"Part-time firefighters (PTFs) in rural Norway are employed in minor positions, have little formal training and often few resources.","title":"Don't quit your day job. Part-time firefighters in rural Norway","url":"https://www.sciencedirect.com/science/article/pii/S221242092600066X"}}

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