read
7 rows where "date" is on date 2022-10-09
This data as json, CSV (advanced)
Suggested facets: description, image, hnurl, domain, date (date)
| Link | rowid ▼ | url | title | description | image | date | hnurl | screenshot | domain | |
|---|---|---|---|---|---|---|---|---|---|---|
| 104 | 104 | https://www.theguardian.com/environment/2022/oct/08/greta-thunberg-climate-delusion-greenwashed-out-of-our-senses | Greta Thunberg on the climate delusion: ‘We’ve been greenwashed out of our senses. It’s time to stand our ground’ | Climate crisis | The Guardian | Governments may say they’re doing all they can to halt the climate crisis. Don’t fall for it – then we might still have time to turn things around | https://i.guim.co.uk/img/media/819c0e6d88cf3f5ed51c3e69641765caa45f2fa8/0_105_6300_3781/master/6300.jpg?width=1200&height=630&quality=85&auto=format&fit=crop&overlay-align=bottom%2Cleft&overlay-width=100p&overlay-base64=L2ltZy9zdGF0aWMvb3ZlcmxheXMvdGctZGVmYXVsdC5wbmc&enable=upscale&s=19068f0fe84c96b3e48ac13c9f6dd913 | 2022-10-09T06:23:01.430604574Z | www.theguardian.com | |||
| 105 | 105 | https://en.wikipedia.org/wiki/Greta_Thunberg | Greta Thunberg - Wikipedia | https://upload.wikimedia.org/wikipedia/commons/1/1a/Glastonbury2022_%28218_of_413%29_%2852182434551%29_%28cropped%29_%28cropped%29.jpg | 2022-10-09T06:28:31.940094438Z | https://news.ycombinator.com/item?id=20014321 | en.wikipedia.org | |||
| 106 | 106 | https://www.geekytidbits.com/date-range-table-sqlite/ | Generating Date Ranges in SQLite | Geeky Tidbits | SQLite supports <a href="https://www.sqlite.org/lang_with.html#x1140">Recursive Common Table Expressions</a> which is very handy sometimes. Although you have to keep an eye on performance, they can help you accomplish something that would otherwise be non-trival. Something like generating a range of dates or months, as I recently had to do. | 2022-10-09T06:46:55.42432143Z | www.geekytidbits.com | ||||
| 107 | 107 | https://www.theage.com.au/politics/victoria/2-a-day-public-transport-fares-under-victorian-opposition-pledge-20221009-p5bo9n.html | Victorian election 2022: Opposition pledges to cut public transport fares to $2 a day | Under the opposition’s plan, daily zone 1 and 2 fares would drop from $9.20 to $2, or from $4.60 to $1 for concession holders, but analysis shows wealthier suburbs better served by public transport would benefit the most. | https://static.ffx.io/images/$zoom_0.9819%2C$multiply_0.7554%2C$ratio_1.776846%2C$width_1059%2C$x_1%2C$y_58/t_crop_custom/q_86%2Ce_sharpen:60%2Cf_auto/t_theage_no_label_no_age_social_wm/493953e89e192a62fe24cd39a66cf42299a55805 | 2022-10-09T20:59:13.008278459Z | www.theage.com.au | |||
| 108 | 108 | https://www.theguardian.com/australia-news/2022/oct/10/victorian-greens-push-for-cannabis-to-be-legalised-taxed-similarly-to-alcohol | Victorian Greens push for cannabis to be legalised, taxed similarly to alcohol | Victoria state election 2022 | The Guardian | Plan would see a 30% tax imposed, which analysis suggests will add $1.21bn in revenue over a decade | https://i.guim.co.uk/img/media/832823e1bc91330924fbee7633c27e280f772e6b/0_118_5814_3488/master/5814.jpg?width=1200&height=630&quality=85&auto=format&fit=crop&overlay-align=bottom%2Cleft&overlay-width=100p&overlay-base64=L2ltZy9zdGF0aWMvb3ZlcmxheXMvdGctZGVmYXVsdC5wbmc&enable=upscale&s=54b99a994fee001e62435a1b31d4e497 | 2022-10-09T21:25:13.132383551Z | www.theguardian.com | |||
| 109 | 109 | https://www.vice.com/en/article/zmp8gy/the-forgotten-operating-system-that-keeps-the-nyc-subway-system-alive | The Forgotten Operating System That Keeps the NYC Subway System Alive | Vintage technology has powered the innards of the NYC subway system for decades—and sometimes, it surfaces in interesting ways. This one’s for you, OS/2 fans. | https://vice-web-statics-cdn.vice.com/images/vice-og.png | 2022-10-09T21:49:51.48461099Z | https://news.ycombinator.com/item?id=33127423 | www.vice.com | ||
| 110 | 110 | https://xenodium.com/emacs-reveal-in-finder-dwim-style/ | Emacs: Reveal in macOS Finder (DWIM style) | 2022-10-09T21:51:19.960536792Z | https://news.ycombinator.com/item?id=33144169 | xenodium.com |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [read] ( [url] TEXT, [title] TEXT, [description] TEXT, [image] TEXT, [date] TEXT, [hnurl] TEXT, [screenshot] TEXT, [pdf] TEXT, [domain] TEXT );