This is a quick page that tries to unravel the current (as of 2007-06-26) JSON output data structure format coming out of HTSQL.

The key thing to remember is that for each record in an aspect, there will be a nested list next to it that contains either records from the next aspect in the chain, or an empty list if the parent aspect is the last in the chain.

In the diagram, 'var' represents a variable that is holding the decoded JSON data structure.