Filter: SN Ia from TNS

'SN Ia from TNS' filter results

Getting SNe type Ia from TNS, crossmatched with Lasair. Lasair keeps a cache of the whole TNS database, and this filter finds objects in both. The filter is streamed via kafka with the topic name lasair_245SNIafromTNS .
Your kafka stream has produced 0 alerts today (0 bytes of your quota of 100,000,000)

Run Filter Duplicate Show Query

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 Ia"
ORDER BY objects.lastDiaSourceMjdTai DESC

Filter Results

A list of objects passing the 'SN Ia from TNS' filter.

diaObjectId	tns_prefix	tns_name	type
170019717277810735	SN	2026ctw	SN Ia
170019717277810735	SN	2026ctw	SN Ia
170028510695916335	SN	2025mbp	SN Ia
170028510695916335	SN	2025mbp	SN Ia
170028526852374631	SN	2024adyk	SN Ia
170028526852374631	SN	2024adyk	SN Ia
170028500610711681	SN	2024xom	SN Ia
170028500610711681	SN	2024xom	SN Ia
170054945860485353	SN	2021bnv	SN Ia
170046116124426314	SN	2021hiz	SN Ia
170028527677079554	SN	2024lah	SN Ia
170028531990397039	SN	2021hiz	SN Ia
170046117870305430	SN	2024bhx	SN Ia
170028526468595755	SN	2016cmq	SN Ia
170028528479240259	SN	2024lah	SN Ia
170050503949418571	SN	2024bhx	SN Ia
170028527962292298	SN	2021ita	SN Ia
170032925741940778	SN	2021ita	SN Ia
170028526852374585	SN	2024adyk	SN Ia
170028527695429710	SN	2021hiz	SN Ia
170032927084118158	SN	2021hiz	SN Ia
170028535640490052	SN	2024bhx	SN Ia
170028536021647398	SN	2016cmq	SN Ia
170046108206628958	SN	2021hiz	SN Ia
170028535346888725	SN	2021hiz	SN Ia
170028526715011142	SN	2024bhx	SN Ia
170046113706934372	SN	2021hiz	SN Ia
170028536319442976	SN	2024adyk	SN Ia
170028536978473039	SN	2021ita	SN Ia
170046114358624361	SN	2024bhx	SN Ia
170046112772653144	SN	2016cmq	SN Ia
170050508933824647	SN	2021hiz	SN Ia
170050508706807954	SN	2018bgb	SN Ia
170028528638623791	SN	2021hiz	SN Ia
170046117202362449	SN	2021hiz	SN Ia
170050508403769397	SN	2021ita	SN Ia
170050508310446161	SN	2018bgb	SN Ia
170050508040437870	SN	2018bgb	SN Ia
170028528479240255	SN	2024bhx	SN Ia
170028535484252216	SN	2024bhx	SN Ia
170028530924519441	SN	2024adyk	SN Ia
170028531059261472	SN	2024adyk	SN Ia
170028535886905403	SN	2024lah	SN Ia
170032918739025997	SN	2024bhx	SN Ia
170028528947953683	SN	2018bgb	SN Ia
170028537898598488	SN	2024lah	SN Ia
170028527002320962	SN	2024bhx	SN Ia
313853517696598125	SN	2020aciz	SN Ia
170028516584718374	SN	2020aciz	SN Ia
170050496549093827	SN	2021bnv	SN Ia
170032906288758949	SN	2020aciz	SN Ia
170028521414459472	SN	2020aciz	SN Ia
170050496458391653	SN	2023dyl	SN Ia
170028520474411115	SN	2020aciz	SN Ia
170032901603721239	SN	2023dyl	SN Ia
170028511148376326	SN	2021bnv	SN Ia
170050489831391369	SN	2021bnv	SN Ia
170028520569307263	SN	2021bnv	SN Ia

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