core.news_headlines
UW's headline feed, paged back to the last run. Keyed on time plus a hash of source and headline, because the vendor sends no id.
Simplify Analyticsuw_news63,139 rowsexportable| created_at ↑timestamp with time zone | headline_shatext | headlinetext | news_sourcetext | is_majorboolean | sentimenttext | tickersjsonb | tagsjsonb |
|---|
| sourcetext |
|---|
| endpointtext |
|---|
| request_paramsjsonb |
|---|
| as_ofdate |
|---|
| vintage_tstimestamp with time zone |
|---|
| retrieved_attimestamp with time zone |
|---|
| 2026-07-27 08:03 | f44412163fa357ddf6fbfb69376d4043ff090ceccb4a01429e7a1a229… | Booz Allen Expands Mission-Grade Cyber Defense Product Suite | Business Wire | true | neutral | ["BAH"] | [] | {} | uw_news | /api/news/headlines | {"limit":99} | 2026-09-14 | 2026-09-14 13:15 | 2026-09-14 13:15 |