20
'SN II from TNS' filter results
'SN II from TNS' filter results
Getting SNe type II from TNS, crossmatched with Lasair. Lasair keeps a cache of the whole TNS database, and this filter finds objects in both. You can change the type of TNS entry, or use the syntax 'crossmatch_tns.tns_name in ["SN II", "AGN"]' to select from multiple types. The filter is streamed via kafka with the topic name lasair_14SNIIfromTNS .
Your kafka stream has produced 0 alerts today (0 bytes of your quota of 100,000,000)
Run Filter Duplicate 

SELECT objects.diaObjectId,
       crossmatch_tns.tns_prefix,
       crossmatch_tns.tns_name,
       crossmatch_tns.type
FROM objects,
     watchlist_hits,
     crossmatch_tns
WHERE objects.diaObjectId=watchlist_hits.diaObjectId
  AND watchlist_hits.wl_id=46
  AND watchlist_hits.name=crossmatch_tns.tns_name
  AND crossmatch_tns.type = "SN II"
ORDER BY objects.lastDiaSourceMjdTai DESC

Filter Results

A list of objects passing the 'SN II from TNS' filter.
diaObjectId tns_prefix tns_name type
313853517428162578 SN 2026bbl SN II
313853517428162578 SN 2026bbl SN II
170028527544959074 SN 2025hlf SN II
170028527544959074 SN 2025hlf SN II
170028520341766169 SN 2022and SN II
170050506519478374 SN 2022hss SN II
170046109144055918 SN 2022hss SN II
170028528238067732 SN 2022hss SN II
170046108343992428 SN 2022hss SN II
170046109948313615 SN 2022hss SN II
314007379963805782 SN 2022and SN II
170032908006326285 SN 2022and SN II
170050499437396186 SN 2022and SN II
313888627015286944 SN 2022and SN II
314007379158499424 SN 2022and SN II
313998569751183527 SN 2022and SN II
313871014369951753 SN 2022and SN II
313862203201028173 SN 2022and SN II
313980949406154811 SN 2022and SN II
170032903338066042 SN 2022and SN II
Need Help?

Start with our documentation on readthedocs, you might find the FAQ section especially useful.

If you still have questions, want to report a bug, or make a feature request, please reach out to us on the Lasair topic on the Rubin Community pages.

 readthedocs Lasair Community
Help