hacker_news_posts_atom (view)
3 rows where "atom_updated" is on date 2023-10-24
This data as json, atom, copyable, CSV (advanced)
atom_id | atom_title | url | atom_link | atom_updated | atom_content |
---|---|---|---|---|---|
38006251 | Embeddings: What they are and why they matter | https://simonwillison.net/2023/Oct/23/embeddings/ | https://news.ycombinator.com/item?id=38006251 | 2023-10-24T21:58:24Z | Submitter: mpweiher - 4 points, 0 comments |
37998983 | Embeddings: What they are and why they matter | https://simonwillison.net/2023/Oct/23/embeddings/ | https://news.ycombinator.com/item?id=37998983 | 2023-10-24T13:35:42Z | Submitter: rrampage - 10 points, 0 comments |
37993985 | Embeddings: What they are and why they matter | https://simonwillison.net/2023/Oct/23/embeddings/ | https://news.ycombinator.com/item?id=37993985 | 2023-10-24T01:42:02Z | Submitter: jonbaer - 1 points, 1 comments |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW hacker_news_posts_atom as select id as atom_id, title as atom_title, url, commentsUrl as atom_link, dt || 'Z' as atom_updated, 'Submitter: ' || submitter || ' - ' || points || ' points, ' || numComments || ' comments' as atom_content from hacker_news_posts order by dt desc limit 100;