Our datasets can be viewed through the SQL interface at db001.gda-score.org. This article gives a few quick pointers on how to use the interface.
On going to db001.gda-score.org for the first time, you may see the following:
Clicking on the server labeled “PostgreSQL” (red arrow) shows a list of available databases:
Clicking on a database (here pseudo_banking) produces a page with a variety of options for viewing the data:
Clicking on the button labeled “SQL”, for instance, provides a text box where SQL queries may be input:
Here we have input the query “select * from accounts limit 10”. After clicking “Execute”, this displays all column values for the first 10 rows of the accounts table in the database pseudo_banking:
Clicking “Edit SQL” displays the SQL query text box again.