NOTE: This page is experimental. Bug reports to carter.barry@gmail.com. Query language is SQLite3.

Prepend rss. to the URL for an RSS feed, csv. to the URL for CSV output.

QUERY: SELECT event,MIN(time) AS time FROM abqastro WHERE time >= DATETIME('now','localtime') GROUP BY event UNION SELECT "NOW", DATETIME('now', 'localtime') UNION SELECT event,MAX(time) AS time FROM abqastro WHERE time <= DATETIME('now','localtime') GROUP BY event ORDER BY time

To edit query (or if query above is munged), see textbox at bottom of page

Empty result may indicate error: I'm not sure why my error checking code isn't working.

Source code

event time
Full Moon 2017-12-03 08:47:00
Last Quarter 2017-12-10 00:51:00
New Moon 2017-12-17 23:30:00
First Quarter 2017-12-26 02:20:00
ATE 2018-01-15 18:47
ATS 2018-01-16 05:45
NTS 2018-01-16 06:15
CTS 2018-01-16 06:46
MR 2018-01-16 06:50
SR 2018-01-16 07:14
MS 2018-01-16 17:14
SS 2018-01-16 17:19
CTE 2018-01-16 17:46
NTE 2018-01-16 18:17
NOW 2018-01-16 18:39:38
ATE 2018-01-16 18:48
ATS 2018-01-17 05:45
NTS 2018-01-17 06:15
CTS 2018-01-17 06:46
SR 2018-01-17 07:13
MR 2018-01-17 07:33
SS 2018-01-17 17:20
CTE 2018-01-17 17:47
MS 2018-01-17 18:07
NTE 2018-01-17 18:18

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query