Love your yuri aquarium list! I had always assumed that Bloom into You was the catalyst for bringing aquariums to their current trope/meme status in yuri but it's really neat to see the data support that. I hadn't realized A Tropical Fish Yearns for Snow came out the same year as that Bloom chapter so as you said it likely helped too.
Also! Two possible additions to the list: Summer, Lemon, and Overlay chapter 4 - it ran in Yuri Hime in 2022, and episode 5 of the currently airing anime Jellyfish Can't Swim in the Night. That one might depend on the subjectivity of what counts as yuri but at the very least Kano kisses Mahiru on the cheek the same episode they visited the aquarium.
Thank you. I've added them both. Summer, Lemon, and Overlay is quite an oversight, as not only have I read it, I looked at part of that exact chapter again recently. I did expect I was likely missing examples from 2022.
Jellyfish Can't Swim in the Night seems like it might not be done with aquariums.