hacker_news_posts_atom (view)
3 rows where "atom_updated" is on date 2023-12-01
This data as json, atom, copyable, CSV (advanced)
Suggested facets: atom_title
atom_id | atom_title | url | atom_link | atom_updated | atom_content |
---|---|---|---|---|---|
38493628 | Datasette Enrichments: a new plugin framework for augmenting your data | https://simonwillison.net/2023/Dec/1/datasette-enrichments/ | https://news.ycombinator.com/item?id=38493628 | 2023-12-01T22:48:15Z | Submitter: simonw - 4 points, 0 comments |
38489533 | Llamafile is the new best way to run a LLM on your own computer | http://simonwillison.net/2023/Nov/29/llamafile/ | https://news.ycombinator.com/item?id=38489533 | 2023-12-01T17:36:50Z | Submitter: djha-skin - 195 points, 47 comments |
38483908 | Llamafile is the new best way to run a LLM on your own computer | https://simonwillison.net/2023/Nov/29/llamafile/ | https://news.ycombinator.com/item?id=38483908 | 2023-12-01T06:44:40Z | Submitter: alexzeitler - 3 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;