Find all files with the extension .csv in the current directory and all subdirectories, and search for the pattern 'some_pattern' in each of those files.
find ~ -mindepth 1 -type f -name '*.csv' | xargs grep 'some_pattern'