Lasair Schema Browser

Click to jump to the schema for the objects, crossmatch_tns, sherlock_classifications, <annotator> or the watchlist_hits table.

objects Table Browser

Use the search bar below to find the columns required. Click on to copy the table.column name to your clipboard.
table.column Description
objects.objectId ZTF object identifier
objects.decmean Mean Dec in degrees
objects.decstd Standard deviation of Dec in arcseconds
objects.ramean Mean RA in degrees
objects.rastd Standard deviation of RA in arcseconds
objects.glatmean Mean galactic latitude in degrees
objects.glonmean Mean galactic longitude in degrees
objects.jdgmax Latest Julian Day of g mag candidates
objects.gmag Latest g magnitude
objects.dmdt_g Most recent increase in g magnitude divided by time difference, (brightening = positive). Units are Mags per day, and measurement can have large errors (dmdt_g_err).
objects.dmdt_g_2 Deprecated -- always Null
objects.mag_g02 Latest Exponential Moving Average of difference magnitude in g band, with 2-day timescale (see note)
objects.mag_g08 Latest Exponential Moving Average of difference magnitude in g band, with 8-day timescale (see note)
objects.mag_g28 Latest Exponential Moving Average of difference magnitude in g band, with 28-day timescale (see note)
objects.maggmax Maximum g magnitude of light curve (faintest)
objects.maggmean Mean g magnitude of light curve
objects.maggmin Minimum g magnitude of light curve (brightest)
objects.jdrmax Latest Julian Day of r mag candidates
objects.mag_r02 Latest Exponential Moving Average of difference magnitude in r band, with 2-day timescale (see note)
objects.mag_r08 Latest Exponential Moving Average of difference magnitude in r band, with 8-day timescale (see note)
objects.mag_r28 Latest Exponential Moving Average of difference magnitude in r band, with 28-day timescale (see note)
objects.rmag Latest r magnitude
objects.dmdt_r Most recent increase in r magnitude divided by time difference, (brightening = positive). Units are Mags per day, and measurement can have large errors (dmdt_r_err).
objects.dmdt_r_2 Deprecated -- always Null
objects.magrmax Maximum r magnitude of light curve (faintest)
objects.magrmean Mean r magnitude of light curve
objects.magrmin Minimum r magnitude of light curve (brightest)
objects.jdmax Maximum of jdgmax and jdrmax
objects.jdmin Earliest Julian Day of candidates that cite this object
objects.ncand Number in light curve
objects.ncandgp Number in light curve with good quality and brighter than reference
objects.distpsnr1 Distance of closest source from PS1 catalog; if exists within 30 arcsec [arcsec]
objects.sgscore1 Star/Galaxy score of closest source from PS1 catalog 0 <= sgscore <= 1 where closer to 1 implies higher likelihood of being a star
objects.sgmag1 g-band PSF magnitude of closest source from PS1 catalog; if exists within 30 arcsec
objects.srmag1 r-band PSF magnitude of closest source from PS1 catalog; if exists within 30 arcsec
objects.htm16 Hierarchical Triangular Mesh level 16
objects.g_minus_r Value of g-r on most recent night when both were available and both positive difference magnitudes
objects.jd_g_minus_r Julian date of most recent g measure on a night when both ag and r were available and both positive difference magnitudes
objects.ncandgp_7 Number in light curve with good quality and brighter than reference in last 7 days
objects.ncandgp_14 Number in light curve with good quality and brighter than reference in last 14 days
objects.ssnamenr MPC name of Solar System object
objects.dmdt_g_err Error estimate for dmdt_g
objects.dmdt_r_err Error estimate for dmdt_r

crossmatch_tns Table Browser

Use the search bar below to find the columns required. Click on to copy the table.column name to your clipboard.
table.column Description
crossmatch_tns.ra Right Ascension in decimal degrees
crossmatch_tns.decl Declination in decimal degrees
crossmatch_tns.tns_name TNS name, for example 2021iru
crossmatch_tns.tns_prefix For example SN or AT
crossmatch_tns.disc_mag Discovery magnitude
crossmatch_tns.disc_mag_filter Discovery magnitude filter
crossmatch_tns.type Astrophysical type of supernova, eg SN Ia
crossmatch_tns.z Redshift
crossmatch_tns.hostz Redshift of host galaxy
crossmatch_tns.host_name Name of host galaxy
crossmatch_tns.ext_catalogs External catalogues used
crossmatch_tns.disc_int_name Discoverers internal name
crossmatch_tns.disc_date Discovery date
crossmatch_tns.lastmodified_date Last Modified date
crossmatch_tns.sender Discoverers internal name
crossmatch_tns.reporters Discoverers internal name
crossmatch_tns.source_group Discoverers internal name
crossmatch_tns.htm16 Hierarchical Triangular Mesh level 16
crossmatch_tns.lasairmodified_date Lasair last Modified date

sherlock_classifications Table Browser

Use the search bar below to find the columns required. Click on to copy the table.column name to your clipboard.
table.column Description
sherlock_classifications.objectId ZTF object identifier, also known as transient_object_id
sherlock_classifications.classification Top-ranked contextual classification for the transient (NULL, AGN, BS, CV, NT, ORPHAN, SN, UNCLEAR, VS)
sherlock_classifications.association_type Association classification for the transient (NULL, AGN, BS, CV, NT, ORPHAN, SN, UNCLEAR, VS)
sherlock_classifications.catalogue_table_name Name/s of catalogue/s from which the best crossmatch is made
sherlock_classifications.catalogue_object_id Identifier in the catalogue/s from which the best crossmatch is made
sherlock_classifications.catalogue_object_type Type of catalogue from which the best crossmatch is made
sherlock_classifications.raDeg RA in degrees of the transient
sherlock_classifications.decDeg Dec in degrees of the transient
sherlock_classifications.separationArcsec Transient's angular separation (arcseconds) from the top-ranked catalogue source match
sherlock_classifications.northSeparationArcsec Transient's angular separation (arcseconds) from the top-ranked catalogue source match
sherlock_classifications.eastSeparationArcsec Transient's angular separation (arcseconds) from the top-ranked catalogue source match
sherlock_classifications.physical_separation_kpc Distance in kilo parsec between transient and top-ranked catalogue source match
sherlock_classifications.direct_distance Determined from a non-redshift related measurement - e.g. Cepheids/standard candle (Mpc)
sherlock_classifications.distance Luminosity distance -- conversion from the spectral redshift (Mpc)
sherlock_classifications.z Redshift of the top-ranked catalogue source match
sherlock_classifications.photoZ Redshift of the top-ranked catalogue source match
sherlock_classifications.photoZErr Redshift of the top-ranked catalogue source match
sherlock_classifications.Mag Magnitude
sherlock_classifications.MagFilter Magnitude filter
sherlock_classifications.MagErr Magnitude error
sherlock_classifications.classificationReliability Reliability of classification
sherlock_classifications.major_axis_arcsec Size of associated galaxy in arcsec
sherlock_classifications.annotator Information about this annotation
sherlock_classifications.additional_output Addititonal information about this annotation
sherlock_classifications.description Long-form, human-readable summary of the transient's characteristics as infered from Sherlock's classification
sherlock_classifications.summary Short-form summary of the transient's context usual for webpage quick-look summaries

<annotator> Table Browser

Use the search bar below to find the columns required. Click on to copy the table.column name to your clipboard.
table.column Description
<annotator>.annotationID Auto increment counter
<annotator>.objectId ObjectId of the object that this annotator applies to
<annotator>.topic The topic name of the annotator -- acts as primary key
<annotator>.version Version information for the annotator software
<annotator>.timestamp Time at which this annotation was added to the database
<annotator>.classification Short, non-trivial string expressing the classification of this object by this annotator
<annotator>.explanation Natural language explanation of the classification
<annotator>.classdict Machine readable information about the classification
<annotator>.url URL for further information about this annotation of this object

watchlist_hits Table Browser

Use the search bar below to find the columns required. Click on to copy the table.column name to your clipboard.
table.column Description
watchlist_hits.objectId ZTF object identifier
watchlist_hits.wl_id Watchlist identifier in watchlists
watchlist_hits.cone_id Cone identifier in watchlist_cones
watchlist_hits.arcsec Distance between ZTF and watchlist source (arcsec)
watchlist_hits.name Name of cone given by user
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