# Lasair query against diaSourcesList or equivalent

**URL:** <https://www.rubin.community/t/lasair-query-against-diasourceslist-or-equivalent/11692>\
**Category:** Lasair\
**Created:** [March 4, 2026, 5:47pm UTC](https://www.rubin.community/t/lasair-query-against-diasourceslist-or-equivalent/11692 "2026-03-04T17:47:41Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![skoranda](https://sea2.discourse-cdn.com/flex002/user_avatar/www.rubin.community/skoranda/32/4039_2.png) [@skoranda](https://www.rubin.community/u/skoranda)\
**Post date:** [March 4, 2026, 5:47pm UTC](https://www.rubin.community/t/lasair-query-against-diasourceslist-or-equivalent/11692/1 "2026-03-04T17:47:42Z")

</div>

I used the Lasair API Client object() call with a specific diaObjectId to download the details for that particular object. In the object() call I set lite=False. I see in the returned object the key ‘diaSourcesList’ and within each item in that array the key ‘snr’. How can I write a query/filter for objects where the snr is greater than a particular value? I tried the expression below but received an error that diaSourcesList is not a column in the objects table:

SELECT  
objects.diaObjectId,  
JSON\_EXTRACT(objects.diaSourcesList, ‘$[0].snr’) as snr  
FROM objects  
WHERE  
JSON\_EXTRACT(objects.diaSourcesList, ‘$[0].snr’) \> 25

---

<div class="post-metadata">

**Author:** ![roy](https://sea2.discourse-cdn.com/flex002/user_avatar/www.rubin.community/roy/32/1254_2.png) [@roy](https://www.rubin.community/u/roy)\
**Post date:** [March 5, 2026, 9:41am UTC](https://www.rubin.community/t/lasair-query-against-diasourceslist-or-equivalent/11692/2 "2026-03-05T09:41:52Z")

</div>

Hi Scott –  
Rather than SNR, Lasair has concentrated on the `reliability` value that Rubin offers with each diaSource. This goes from 0 to 1, with 1 most reliable. Your filter might be reframed as `objects.latestR > 0.9`. Another feature you might use is `medianR`, which is the median of the reliability values of all the diaSources.  
– Roy

---

<div class="post-metadata">

**Author:** ![heloise](https://sea2.discourse-cdn.com/flex002/user_avatar/www.rubin.community/heloise/32/3680_2.png) [@heloise](https://www.rubin.community/u/heloise)\
**Post date:** [March 5, 2026, 1:29pm UTC](https://www.rubin.community/t/lasair-query-against-diasourceslist-or-equivalent/11692/3 "2026-03-05T13:29:20Z")

</div>

hi scott!

If you are looking for transients you might want to try using the following annotator (like in [Filter: ExtraGalactic\_NewsLetter\_lvra](https://lasair.lsst.ac.uk/filters/65/))

```auto
  AND r0b_lvra.classification>0.9

```

This real/bogus score looks at reliability, SNR, separation from host and a bunch of other things but SNR is the dominant factor at the minute (because R is a bit hit and miss).

Maybe in future we can add an SNR feature but in the mean time it’s your best bet alongside the reliability score Roy mentioned