hacker_news_posts_atom (view)
2 rows where "atom_updated" is on date 2024-04-22
This data as json, atom, copyable, CSV (advanced)
atom_id | atom_title | url | atom_link | atom_updated | atom_content |
---|---|---|---|---|---|
40114311 | Options for accessing Llama 3 from the terminal using LLM | https://simonwillison.net/2024/Apr/22/llama-3/ | https://news.ycombinator.com/item?id=40114311 | 2024-04-22T13:45:33Z | Submitter: simonw - 3 points, 2 comments |
40111784 | AI for Data Journalism: demonstrating what we can do with this stuff | https://simonwillison.net/2024/Apr/17/ai-for-data-journalism/ | https://news.ycombinator.com/item?id=40111784 | 2024-04-22T06:09:34Z | Submitter: duck - 167 points, 32 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;