The U.S. Census has CSVs for all U.S. surnames that occur more than 100 times: https://www.census.gov/topics/population/genealogy/data.html