standardizing on snake_case for readability and consistency with upper case columns from data frames

updates to condition by type query for consolidation of condition types

restrict to male and female genders, excluding unknown

rounded to 5 decimal places for data file size optimization and required precision

new double pipe (||) delimiters for hierarchy paths