%%capture
# ^ capture here just supresses any output
!pip install flatterer noteql
!wget http://api.nobelprize.org/v1/prize.json -q -O prize.json
!cat prize.json
import flatterer
output = flatterer.flatten('prize.json', 'output', sqlite=True)
output
output['fields']
import noteql
session = noteql.Session('sqlite:///output/sqlite.db')
%%nql
select * from prizes
%%nql
select * from prizes_laureates