factor json.dumps() calls together
factor handlers together
make small fixes to sql handling
factor scrape schemes together