My filter isn't grabbing all the relevant data

I have a data set of ~300,000 rows and 8 columns. I have selected all the data and added a filter.

I filter column C to include the word "restaurant" and it returns a lot of results, but not all of them. It appears that it captures all of the data in the first few thousand rows but then it's only selects a few of the data points from each 5,000 rows ongoing.

I can resort the data based on column d or column e and run the same filter on Column C - it will returns different results.

I need it to display ALL of the data in Column C containing this particular word.

Please help.