Split nested json into correct rows using Pandas

We can modify your current output with explode

s = pd.json_normalize(result_json, record_path=["response"]).explode('statistics').reset_index(drop=True)
s = s.join(pd.DataFrame(s.pop('statistics').tolist()))
s
Out[112]: 
   team.id          team.name            type  value
0       33  Manchester United   Shots on Goal      6
1       33  Manchester United  Shots off Goal      1
2       33  Manchester United     Total Shots      8
3       33  Manchester United   Blocked Shots      1
4       46          Leicester   Shots on Goal      4
5       46          Leicester  Shots off Goal      3
6       46          Leicester     Total Shots     13
7       46          Leicester   Blocked Shots      6