loop in json_extract_scalar

Question

The json format I have is in the following form

{"0": {...}, "1":{...}, "2":{..}}

and this goes for a variable number of integers. I am trying to create a for loop so I can extract all the values at once instead of separately writing a bunch of code with json_extract_scalar.

I wanted to do something like the following

for x in range (0, (some_number)):
   json_extract_scalar(my_dataset_column, '$.' + x)