SQLite Web: event

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

value

{"aggregator_url":"https://news.google.com/rss/articles/CBMinwFBVV95cUxPajFlTWpReHZoNjA1R1pOUE9tcjFPM1I3VjNTT3g4Tl9ZQU5mOUdfcFFIclplSHFUeVJwNDZvaXppZmxvMWRfTmNQWFlVWlllQnJXLW93MnFFT2dYVWhlZmFiM2QtSWxHR3NUVW0tRzE4dU9aZEVsQXpfOENkS3Vvclh6UGpkbUdSYjl6M1FTUXZXdGxrby1DbmU0UG1OeWc?oc=5","as_of":"2026-04-10T15:28:44.146917+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/CBMinwFBVV95cUxPajFlTWpReHZoNjA1R1pOUE9tcjFPM1I3VjNTT3g4Tl9ZQU5mOUdfcFFIclplSHFUeVJwNDZvaXppZmxvMWRfTmNQWFlVWlllQnJXLW93MnFFT2dYVWhlZmFiM2QtSWxHR3NUVW0tRzE4dU9aZEVsQXpfOENkS3Vvclh6UGpkbUdSYjl6M1FTUXZXdGxrby1DbmU0UG1OeWc?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_27aae870a53bb944","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-10T16:21:01.635738+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMinwFBVV95cUxPajFlTWpReHZoNjA1R1pOUE9tcjFPM1I3VjNTT3g4Tl9ZQU5mOUdfcFFIclplSHFUeVJwNDZvaXppZmxvMWRfTmNQWFlVWlllQnJXLW93MnFFT2dYVWhlZmFiM2QtSWxHR3NUVW0tRzE4dU9aZEVsQXpfOENkS3Vvclh6UGpkbUdSYjl6M1FTUXZXdGxrby1DbmU0UG1OeWc?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"techcrunch.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMinwFBVV95cUxPajFlTWpReHZoNjA1R1pOUE9tcjFPM1I3VjNTT3g4Tl9ZQU5mOUdfcFFIclplSHFUeVJwNDZvaXppZmxvMWRfTmNQWFlVWlllQnJXLW93MnFFT2dYVWhlZmFiM2QtSWxHR3NUVW0tRzE4dU9aZEVsQXpfOENkS3Vvclh6UGpkbUdSYjl6M1FTUXZXdGxrby1DbmU0UG1OeWc?oc=5","source_event_id":"evt_88bfec6cdb14","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"359d531e5222e431","published_at":"2026-04-10T14:39:32+00:00","publisher_domain":"techcrunch.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"sovereign","name":"France (government)","relevance":"high","symbol":"","type":"country_government"},{"asset_class":"software","name":"Microsoft Windows","relevance":"high","symbol":"Windows","type":"software_product"},{"asset_class":"software","name":"Linux","relevance":"high","symbol":"Linux","type":"operating_system"},{"asset_class":"software","name":"US-based tech vendors (unspecified)","relevance":"medium","symbol":"","type":"other"}],"event_type":"regulation","information_gaps":["No specific timeline (dates, milestones, or rollout schedule) is included in the provided text.","No details on scope (which agencies, number of devices, or percentage migration) are provided.","No specific US vendors beyond \u201cUS tech\u201d are named in the provided text.","No quantified impact (cost, performance, security outcomes) is provided.","The provided article text appears to be largely HTML/CSS and does not include the substantive content needed to verify additional details."],"key_facts":["TechCrunch reports France will ditch Windows for Linux to reduce reliance on US tech.","The reporting indicates France has launched a government Linux desktop plan.","The reporting frames this as accelerating a digital sovereignty push.","The headline implies a Windows exit is beginning (timing: near-term/ongoing, exact date not provided in the provided text)."],"numeric_claims":[],"primary_claim":"France is ditching Windows for Linux to reduce reliance on US tech, accelerating a government digital sovereignty push.","relevance_score":0.72,"sentiment":"mixed","source_quality":"high","summary":"France plans to move away from Windows toward Linux for government desktops as part of a digital sovereignty effort to reduce reliance on US technology. The near-term catalyst is the start of the Windows exit alongside a newly launched government Linux desktop plan.","topics":["digital sovereignty","government IT modernization","Windows-to-Linux migration","tech independence","US tech reliance"]},"source":"TechCrunch","source_domain":"techcrunch.com","source_url":"https://techcrunch.com","summary":"France to ditch Windows for Linux to reduce reliance on US tech TechCrunch France Launches Government Linux Desktop Plan as Windows Exit Begins Linuxiac French government says it's ditching Windows for Linux \u2014 country accelerates plans to ditch US-based software in digital sovereignty push Tom's Hardware France Dumps Windows for Linux in Push for Tech Independence The Tech Buzz French alternatives to Google Search, ChatGPT, and YouTube Music Cybernews","title":"France to ditch Windows for Linux to reduce reliance on US tech - TechCrunch","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

threshold

TEXT

direction

TEXT

severity

TEXT

window

TEXT

source

TEXT NOT NULL

reason_trace

TEXT

dedupe_key

TEXT NOT NULL

throttle_s

INTEGER (default 0

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

event_store.db — signals

Update row sig_f755eaf022f5 in signals