Memory card issues

On May 12,2019, I went to Gibbon Junction and a few crossings to sodtown road along Union Pacific's Kearney Sub. I took 225 pictures of trains, 31 clips for my vlog, and 168 clips of trains. It was a very busy day. I did a food review from Subway called "American club". The trains was non stop in the afternoon along the Marysville Sub and Kearney Sub. When I tried to get the pictures and put it on my hard drive so I can put it on Facebook. Here is the problems I had. I lost 187 photos, and 20 videos due to the bad memory card. I checked the camera works fine for me.