Filter: AT from TNS

'AT from TNS' filter results

Getting AT from TNS, crossmatched with Lasair. Lasair keeps a cache of the whole TNS database, and this filter finds objects in both. Checks if any alert is associated with an interacting transient from TNS. The filter is streamed via kafka with the topic name lasair_245ATfromTNS .
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 IN ("SN IIn",
                              "SN Ibn",
                              "SN Icn",
                              "LRN",
                              "ILRT",
                              "LBV",
                              "Gap")
ORDER BY objects.lastDiaSourceMjdTai DESC

Filter Results

A list of objects passing the 'AT from TNS' filter.

diaObjectId	tns_prefix	tns_name	type
170028527055274044	AT	2017jfs	Gap
170032919440523419	AT	2017jfs	Gap
170050514315116675	AT	2017jfs	Gap
170028532962427082	AT	2017jfs	Gap
170046108752412731	AT	2017jfs	Gap
170032919576838208	AT	2017jfs	Gap
170050511919644776	SN	2020noz	SN IIn
170032916528103800	AT	2017jfs	Gap
170028530279645216	AT	2017jfs	Gap
170046111051415605	AT	2017jfs	Gap
170028528776511510	AT	2017jfs	Gap
170032924578021415	AT	2017jfs	Gap
170032925081337884	AT	2017jfs	Gap
170032925638656042	AT	2017jfs	Gap
170032926591287352	AT	2017jfs	Gap

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