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/CBMiwAFBVV95cUxPUmFpZmRZYy1UZUNzUkxtR254MUpLNUtmd0RaYkZYQ1M1TTZ1eEVvdDYtZW9EX2ZjTDB1cTY2dzd2VkwwTzhhR0UwXy1ZSWZxcjdkRG9sYUNLOFliOFUwd0FJQkVsQmczMXNMZ3IxekJPVXVYaUlvam13NWxOY3hQcWhualI4RjREaWRudUNkcWxwa0ItQlhVSmpnU2lERkwzVUM0cnBYU2NmTnp2YUtEX1gwQW93emxmYlNVcXc2cjY?oc=5","as_of":"2026-04-10T12:07:32.402015+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/CBMiwAFBVV95cUxPUmFpZmRZYy1UZUNzUkxtR254MUpLNUtmd0RaYkZYQ1M1TTZ1eEVvdDYtZW9EX2ZjTDB1cTY2dzd2VkwwTzhhR0UwXy1ZSWZxcjdkRG9sYUNLOFliOFUwd0FJQkVsQmczMXNMZ3IxekJPVXVYaUlvam13NWxOY3hQcWhualI4RjREaWRudUNkcWxwa0ItQlhVSmpnU2lERkwzVUM0cnBYU2NmTnp2YUtEX1gwQW93emxmYlNVcXc2cjY?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_8751253d39271e94","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-10T12:08:25.074620+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiwAFBVV95cUxPUmFpZmRZYy1UZUNzUkxtR254MUpLNUtmd0RaYkZYQ1M1TTZ1eEVvdDYtZW9EX2ZjTDB1cTY2dzd2VkwwTzhhR0UwXy1ZSWZxcjdkRG9sYUNLOFliOFUwd0FJQkVsQmczMXNMZ3IxekJPVXVYaUlvam13NWxOY3hQcWhualI4RjREaWRudUNkcWxwa0ItQlhVSmpnU2lERkwzVUM0cnBYU2NmTnp2YUtEX1gwQW93emxmYlNVcXc2cjY?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"mpamag.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiwAFBVV95cUxPUmFpZmRZYy1UZUNzUkxtR254MUpLNUtmd0RaYkZYQ1M1TTZ1eEVvdDYtZW9EX2ZjTDB1cTY2dzd2VkwwTzhhR0UwXy1ZSWZxcjdkRG9sYUNLOFliOFUwd0FJQkVsQmczMXNMZ3IxekJPVXVYaUlvam13NWxOY3hQcWhualI4RjREaWRudUNkcWxwa0ItQlhVSmpnU2lERkwzVUM0cnBYU2NmTnp2YUtEX1gwQW93emxmYlNVcXc2cjY?oc=5","source_event_id":"evt_57fe2f4fcae2","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"34fd45b25f44239c","published_at":"2026-04-10T11:59:44+00:00","publisher_domain":"mpamag.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.7,"dates_mentioned":[],"entities":[{"asset_class":"","name":"mpamag.com","relevance":"source of the claim","symbol":"","type":"publisher"}],"event_type":"price_action","information_gaps":["The article text provided is not included (only page code/boilerplate), so the specific markets, the exact percentage share, and the time period for the data are not available.","No information is provided on whether this is based on active listings, sold listings, or another metric.","No direct implications for prices, demand, or liquidity are stated in the provided text beyond the headline claim."],"key_facts":["mpamag.com headline states that million-dollar listings make up the majority in 13 US markets."],"numeric_claims":[{"label":"Number of US markets","value":"13"}],"primary_claim":"Million-dollar listings make up the majority in 13 US markets, according to mpamag.com.","relevance_score":0.35,"sentiment":"neutral","source_quality":"high","summary":"The article reports that million-dollar home listings represent a majority share in 13 US markets.","topics":["US housing market","real estate listings","million-dollar listings","market concentration"]},"source":"mpamag.com","source_domain":"mpamag.com","source_url":"https://www.mpamag.com","summary":"Million dollar listings make up majority in 13 US markets mpamag.com","title":"Million dollar listings make up majority in 13 US markets - mpamag.com","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_756dfea82d1d in signals