Select data missing from detail view

On my home page I have a set of cards that when clicked on go to another page that provides a more detailed view. This is only some of the records are showing up on the page 2.

It’s all coming from the same tables and the cards on the home page are showing correctly.

I’m lost on how to find the reason why there’s only certain records being displayed on page 2.

Thanks in advance for your inisghts…