Advanced queries for this catalog are structured like regular SQLite, except for two things:

1. Only queries that SELECT are allowed to prevent modification of the database.
2. Queries do not need to specify a table (i.e. the FROM keyword is not needed). This is because all information is stored in one table.

Only one query can be executed at a time; as a result, semicolons at the ends of statements are not necessary. For a reference on SQLite, see here.

Below is a list of queryable columns:

• name: The name of the Tidal Disruption Event.
• disc_date: The discovery date of the Tidal Disruption Event.
• ra: The Right Ascension of the TDE in degrees.
• dec: The Declination of the TDE in degrees.
• z: The Redshift of the TDE.
• peak_xray_luminosity: The Peak X-ray Luminosity of the TDE in erg/s.
• optical_association: Whether or not there are optical associations/observations.
• jetted: Whether or not the TDE is jetted.
• black_hole_mass: The Black Hole Mass of the TDE in solar masses ($M_\odot$).
• discovery_telescope: The telescope(s) that discovered the TDE.
• observation_wavelength: The wavelength(s) at which the TDE was observed.
• other_findings: Other findings about the TDE.
• reference: The references for the TDE.

As a reference, here is an example query that will fetch the optical_association and black_hole_mass columns for all the TDEs with "ASASSN" in the name:

SELECT optical_association, black_hole_mass WHERE name LIKE "%ASASSN%"