SELECT * FROM closures WHERE closures.id = "T5AA";
SELECT * FROM closures WHERE closures.id = "T55AB";

/* closureid + lognum */
SELECT * FROM closures WHERE closureid = "T55AA" and lognum = 1;
SELECT * FROM closures WHERE closureid = "T55AA" and lognum = 5;

/* Route */
SELECT * FROM closures WHERE route = 5;
SELECT * FROM closures WHERE route = 13;

/* Route + direction */
SELECT * FROM closures WHERE route = 5 and direction = "N";
SELECT * FROM closures WHERE route = 5 and direction = "E";

/* Route + start date */
SELECT * FROM closures WHERE route = 5 and startdate >= "2020-04-01";

SELECT * FROM closures WHERE route = 5 and startdate >= "2020-05-01";

/* Route + end date */
SELECT * FROM closures WHERE route = 5 and startdate <= "2020-01-23";
/* entry 71 */
SELECT * FROM closures WHERE route = 5 and startdate <= "2019-01-07";

/* Route + end date */
SELECT * FROM closures WHERE route = 5 and startdate >= "2020-03-17" and startdate <= "2020-03-20";
/* entry 69 */
SELECT * FROM closures WHERE route = 5 and startdate <= "2019-01-07";