Contributed Stored Queries and Filters

Stored queries and filters created and made public are listed below. Click on the name to edit it, or the 'Filter Log' to see its results.
Name Owner Description
Orphan Search

Filter Log

Roy Williams Looking for Orphan SNe
SN-like candidates

Filter Log

Roy Williams SN-like candidates (Sherlock classifications SN, NT and orphans). Rejects Pan-STARRS star matches
All nuclear transients and TDE candidates

Filter Log

Roy Williams Near core of inactive catalogued galaxies (within 1"), flags Pan-STARRS stellar matches to let user judge star/galaxy separation. Objects discovered in last 30 days.
Sherlock CVs

Filter Log

Roy Williams
RemoteCFroObject

Filter Log

Roy Williams My queries to find galaxies that are somewhat far from a host according to Sherlock. Note that this query also finds very nearby objects that are far from the core of the galaxy, but still within the optical light.
C-SNAILS

Filter Log

Roy Williams
Lightweight

Filter Log

Roy Williams Lightweight stream
TNS sources

Filter Log

Roy Williams ZTF objects that are also listed in the TNS
Ken Test

Ken Smith
BLLac in SDSS

Roy Williams
MattsQuery

Roy Williams
White Dwarf dips

Filter Log

Roy Williams Looking for transients of binaries that have a WD.
Matt's TDEs

Filter Log

Matt Nicholl TDE candidates selected by g-r colour. Excluding events pre-2021 without full LC histories.
Matt's TDEs E+A

Filter Log

Matt Nicholl Crossmatched with French and Zabludoff watchlist
Transients Within 200 Mpc

Filter Log

Michael Fulton Extracts all extragalactic transients within 200 Mpc according to the Sherlock distances.
Query with z

Roy Williams Query with Sherlock says near a galaxy and galaxy is nearby
CLQ-candidates

Filter Log

Matt Nicholl Requested by Sibasish Laha
fink_early_sn

Filter Log

Roy Williams
New TDEs

Filter Log

yael dgany Same as Matt's TDE's but without objects.g_minus_r < 0.05, sherlock_classifications.Mag BETWEEN 0 AND 21, and objects.objectId NOT LIKE 'ZTF20%'
New TDEs E+A

Filter Log

yael dgany Same as Matt's TDE's E+A but without objects.g_minus_r < 0.05, sherlock_classifications.Mag BETWEEN 0 AND 21, and objects.objectId NOT LIKE 'ZTF20%'
SNToClassify

Thomas Killestein Find a bumper list of pre-peak things that can be classified quickly with 2.5m class telescope
Query-272

Gareth Francis
Fastfinder

Roy Williams
Continual TDE (more than 300 days detection)

Filter Log

Oz Amiel This query is an edit to the 14 days TDE. The difference is in the WHERE: 1. The jdmax condition has been changed to the last 30 days (last candidate is in the last 30 days). 2. A jdmin condition has been added to search for objects with first candidates from at least 10 months ago.
SN with centre distance

Roy Williams
SN-like candidates in last 14 days

Filter Log

Stephen Smartt SN-like candidates (Sherlock classifications SN, NT and orphans). Rejects Pan-STARRS star matches
All nuclear transients and TDE candidates

Filter Log

Stephen Smartt Near core of inactive catalogued galaxies (within 1"), flags Pan-STARRS stellar matches to let user judge star/galaxy separation. Objects discovered in last 14 days.
SN Candidates for MCARG

Filter Log

Chris Duston Using Mag < 18, restricting to "SN"-classified, still getting brighter.
bright stars

Filter Log

Roy Williams bright stars
SN-likethings

Filter Log

Rafia Omer None
Continual TDE (more than 300 days detection)

Filter Log

Oz Amiel This query is an edit to the 14 days TDE. The difference is the in the WHERE: 1. The jdmax condition has been changed to the last 50 days.2. A jdmin condition has been added to search for objects with candidates from at least 10 months ago.3. The ncand has been changed to more than 10.
CLQ-candidates-1.5mag

Filter Log

Matt Nicholl Requested by Sibasish Laha
V1117 Her

Roy Williams Check Lasair for any transients at this location
crossmatch CV catalogue

Filter Log

Roy Williams
Bright SNe

Filter Log

Roy Williams Bright SN-like candidates
orphans

Roy Williams