What’s a good way to look at and explore this data? Where did you learn about the patterns you mention above?
Personally I downloaded their database and then converted into an SQLite database that I could run queries against. They do have an online tool, but I have no experience with that.