Help to find my missing events in DB tables

You may recall from another thread that I've got my 'OPEN / CLOSED / INVITE' event options set to be hidden during event creation (because I only want Open events)

This has caused an issue in that the default (OPEN) doesn't get selected and I think nothing is registered because at the back-end I can filter events by OPEN / CLOSED / INVITE but none return the events I'm missing.

I know how to fix them - I just have to edit the events and save again... I think I've 'found' them all but am not sure... Can you tell me the best DB table to look in to see the number of events (past and future) that exist on the site? That way I can check the number to what's showing on the front-end to confirm none as still 'missing'

Thanks!