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 p1.time, p1.planet, p1.type, p1.xinit, p1.slope FROM (SELECT p1.planet,p1.type,MAX(p1.time) AS max FROM planetpos p1 WHERE time<=datetime('now') GROUP BY p1.planet,p1.type) AS t1 JOIN planetpos p1 ON (t1.planet=p1.planet AND t1.max=p1.time AND t1.type=p1.type)

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

time planet type xinit slope
2459143.35 jupiter dec -22.4798248 0.0253649631151514
2459175.5875 jupiter ra 296.1599948 0.210742265234082
2459185.37916667 mars dec 6.6469295 0.142959496626692
2459193.14166667 mars ra 17.3223065 0.293483781966791
2459208.175 mercury dec -25.0943884 0.0757992264446425
2459189.24583333 mercury ra 243.9404693 1.6711356598181
2459214.28333333 moon dec 24.7684261 -1.08713188561669
2459211.74583333 moon ra 73.7865802 13.3360345125186
2459114.38333333 saturn dec -21.4130827 0.00475852110025608
2459171.55416667 saturn ra 299.1576344 0.0957992858095828
2459191.02916667 sun dec -22.6569781 -0.0702766614982448
2459176.20416667 sun ra 238.4139158 1.07824499944436
2459045.09583333 uranus dec 14.3798906 0.000721226754651553
2459162.87916667 uranus ra 35.8245143 -0.031961239804319
2459195.51666667 venus dec -17.7059295 -0.285860563710546
2459189.425 venus ra 225.5351823 1.26559787520416

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query