prepped ingestor for loading directly into the database