edhiphy is implemented as a SQLite database, which is documented in the schema. Here you can formulate your own SELECT statements to explore the database. One place to learn more about SQL is the interactive tutorial at w3schools. You can also cycle through query examples.
Query to edhiphy:
Hits in edhiphy: Click Preview
Columns returned: Click Preview
First 20 rows of result:
This interface is for exploratory purposes. The preview shows up to 20 rows, .csv downloads are truncated at 1,000 rows. As the database and its web application is in development, we cannot yet guarantee reproducibility of results. Contact us for further support.