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-10T02:44:17.304729+00:00","dedupe_key":"signal_enriched:news_delta:b8c12c8c2d80793f","evidence_event_ids":["evt_d3b2419cabb1"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMiiAFBVV95cUxQRmJFaE11UWMyMUNzY0NqUlN0TXB2YkxFc1VmTkhLZ3NMb3NCWTI0QTFoTVJqdTRSeE1PM3VibnNsWExlRXhKU3VtRDk2QmJRempGWk9lTmdjclR1Ql85U3dSR0pHRVNDc2V4WER4T3pLd18tM1ozZWtQSjNUaTRuZDBsQ2Q5U3ZD?oc=5","as_of":"2026-04-10T02:44:17.304729+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAIFAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2OYSmDAUDetpsORI83j3dpsv55GJQ/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMiiAFBVV95cUxQRmJFaE11UWMyMUNzY0NqUlN0TXB2YkxFc1VmTkhLZ3NMb3NCWTI0QTFoTVJqdTRSeE1PM3VibnNsWExlRXhKU3VtRDk2QmJRempGWk9lTmdjclR1Ql85U3dSR0pHRVNDc2V4WER4T3pLd18tM1ozZWtQSjNUaTRuZDBsQ2Q5U3ZD?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_4776a31f1c1a94d3","canonical_host":"gstatic.com","canonical_is_aggregator":true,"canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAIFAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2OYSmDAUDetpsORI83j3dpsv55GJQ/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-10T02:45:17.019682+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiiAFBVV95cUxQRmJFaE11UWMyMUNzY0NqUlN0TXB2YkxFc1VmTkhLZ3NMb3NCWTI0QTFoTVJqdTRSeE1PM3VibnNsWExlRXhKU3VtRDk2QmJRempGWk9lTmdjclR1Ql85U3dSR0pHRVNDc2V4WER4T3pLd18tM1ozZWtQSjNUaTRuZDBsQ2Q5U3ZD?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"nytimes.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiiAFBVV95cUxQRmJFaE11UWMyMUNzY0NqUlN0TXB2YkxFc1VmTkhLZ3NMb3NCWTI0QTFoTVJqdTRSeE1PM3VibnNsWExlRXhKU3VtRDk2QmJRempGWk9lTmdjclR1Ql85U3dSR0pHRVNDc2V4WER4T3pLd18tM1ozZWtQSjNUaTRuZDBsQ2Q5U3ZD?oc=5","source_event_id":"evt_d3b2419cabb1","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"d34d603a781b7ea7","published_at":"2026-04-09T22:37:56+00:00","publisher_domain":"nytimes.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"other","name":"\u201cNo Kings\u201d protest","relevance":"high","symbol":"","type":"event"},{"asset_class":"other","name":"Homeland Security agent","relevance":"high","symbol":"","type":"person_or_role"},{"asset_class":"other","name":"Student/teen photographer (USC freshman; 18-year-old mentioned in other coverage)","relevance":"high","symbol":"","type":"person"},{"asset_class":"other","name":"Los Angeles Times","relevance":"medium","symbol":"","type":"publisher"},{"asset_class":"other","name":"CNN","relevance":"medium","symbol":"","type":"publisher"},{"asset_class":"other","name":"The Guardian","relevance":"medium","symbol":"","type":"publisher"},{"asset_class":"other","name":"KTLA","relevance":"medium","symbol":"","type":"publisher"},{"asset_class":"other","name":"The New York Times","relevance":"high","symbol":"","type":"publisher"}],"event_type":"conflict","information_gaps":["The cleaned article text provided contains only page styling/HTML and no readable article content, so details beyond the headline and the provided source summary cannot be verified here.","Exact date/time of the incident is not present in the provided text.","Whether the agent\u2019s action is characterized as a \u201cprojectile\u201d vs \u201cshot\u201d differs across the provided summaries; the precise mechanism is not confirmed in the available content.","Injury severity beyond \u201clost an eye\u201d (e.g., medical timeline, treatment) is not provided.","No information is provided here about official findings, charges, or whether the agent\u2019s identity is publicly confirmed beyond \u201cHomeland Security agent.\u201d","The lawyer\u2019s identity and the legal posture (lawsuit, complaint, etc.) are not included in the provided text."],"key_facts":["The New York Times headline states that a student hit by a projectile during the \u201cNo Kings\u201d protest lost an eye, as said by a lawyer.","The source summary indicates the teen went to photograph an L.A. \u201cNo Kings\u201d rally and was blinded by a Homeland Security agent, per the attorney.","Other outlets in the provided source summary similarly describe an 18-year-old losing an eye after being shot/struck by a U.S. agent during the No Kings march in downtown Los Angeles.","The incident is described as involving a federal agent\u2019s projectile (NYT wording) / being shot (other outlets\u2019 wording), per the cited attorney statements."],"numeric_claims":[],"primary_claim":"A lawyer says a teen/student who went to photograph the L.A. \u201cNo Kings\u201d rally lost an eye after being hit by a Homeland Security agent\u2019s projectile.","relevance_score":0.86,"sentiment":"negative","source_quality":"high","summary":"A student photographer at the \u201cNo Kings\u201d protest in downtown Los Angeles was struck by a federal agent\u2019s projectile and lost an eye, according to a lawyer cited by The New York Times.","topics":["protest","injury","federal law enforcement","Homeland Security","Los Angeles","legal claims","eyewitness/photographer","public safety"]},"source":"The New York Times","source_domain":"nytimes.com","source_url":"https://www.nytimes.com","summary":"Student Hit by Projectile During \u2018No Kings\u2019 Protest Lost an Eye, Lawyer Says The New York Times Teen who went to photograph L.A. 'No Kings' rally shot, blinded by Homeland Security agent, attorney says Los Angeles Times \u2018No Kings\u2019 protest: USC freshman loses eye after being struck by federal agent\u2019s projectile in LA, attorney says CNN LA teen loses eye after being shot by US agent at No Kings march, lawyer says The Guardian 18-year-old loses eye after being shot during No Kings protest in downtown Los Angeles KTLA","title":"Student Hit by Projectile During \u2018No Kings\u2019 Protest Lost an Eye, Lawyer Says - The New York Times","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAIFAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2OYSmDAUDetpsORI83j3dpsv55GJQ/m=syndicationarticleview,_b,_tp"}}

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