amillion.py

gistfile1.py

L=[{'name':'e'+str(i), 
    'explanation':'objection1',
    'law':(),
    'CS':('barcelona','Vigo')} for i in range(1000000)]

#%%timeit
next(item for item in L if item["name"] == "e300000")
# 22.3 ms ± 2.58 ms per loop (mean ± std. dev. of 7 runs, 10 loops each)

#%%timeit
[d for d in L if d['name']=='e300000'][0]
# 73.8 ms ± 9.35 ms per loop (mean ± std. dev. of 7 runs, 10 loops each)

#%%timeit
next(item for item in L if item["name"] == "e800000")
# 56.1 ms ± 4.42 ms per loop (mean ± std. dev. of 7 runs, 10 loops each)

#%%timeit
[d for d in L if d['name']=='e800000'][0]
# 73.3 ms ± 5.55 ms per loop (mean ± std. dev. of 7 runs, 10 loops each)

df = pd.DataFrame(L).set_index('name')

#%%timeit
df.loc[['e800000']].reset_index().to_dict('records')
# 1.71 ms ± 901 µs per loop (mean ± std. dev. of 7 runs, 1 loop each)