>>> pd.read_sql_query('''SELECT id, name, level,
l.jsondata::jsonb ? 'iso_retirement' AS retired
FROM language AS l JOIN languoid AS ll ON l.pk = ll.pk
WHERE status = 'spurious retired' AND father_pk IS NULL
ORDER BY id''', engine)
id name level retired
0 aari1244 Aari language True
1 adze1241 Adzera language True
2 ahea1240 Ahe language True
3 aiku1240 Aiku language True
4 amap1241 Amapá Creole language True
5 amer1256 Amerax language True
6 amik1238 Amikoana language True
7 araf1244 Arafundi language True
8 arak1256 Arakanese language True
9 atue1238 Atuence language True
10 auve1240 Auvergnat language True
.. ... ... ... ...
100 tuto1242 Tutong 1 language True
101 uppe1459 Upper Baram Kenyah language True
102 west2863 Western Frisian language True
103 wume1236 Wumeng Yi language True
104 ying1248 Yinglish language True
105 yuan1242 Yuanjiang-Mojiang Yi language True
[106 rows x 4 columns]