There isn’t any way to query these values the way that the OP is looking for, mostly because MySQL doesn’t have any way to match up the field names that are used for each row or the repeater. The best way to get them is to get the entire repeater an then loop through it.
$value = get_field($repeater, $options);
should return the entire repeater in an array and then you can loop through the array to get what you need.
Hope that helps someone.
Welcome to the Advanced Custom Fields community forum.
Browse through ideas, snippets of code, questions and answers between fellow ACF users