It was simple enough to dump the complete raw data without any processing, however, some simple reporting using recursion was possible using SQLite. This document explained the basics.
- export the data
- create the new tables in SQLite
- import the data
- execute and refine the SQL
Now I need to take the resulting data and convert it from TSV to JSON and import the data into the web page (example)