json record ingest and other json/sql cleanup