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_news59,074 rowsexportable| created_at ↑timestamp with time zone | headline_shatext | headlinetext | news_sourcetext | is_majorboolean | sentimenttext | tickersjsonb | tagsjsonb | meta |
|---|
| sourcetext |
|---|
| endpointtext |
|---|
| request_paramsjsonb |
|---|
| as_ofdate |
|---|
| vintage_tstimestamp with time zone |
|---|
| retrieved_attimestamp with time zone |
|---|
| 2026-07-27 00:27 | 382b409db0e6fd82ca1203d47ec9b9bbe224265872c12a8ceddd0b1c7… | London Tops BCG's First Intelligent Cities Index | PR NewsWire | false | neutral | ["BCG"] | [] | {} | uw_news | /api/news/headlines | {"limit":99} | 2026-09-14 | 2026-09-14 13:15 | 2026-09-14 13:15 |