Login | Signup
## Schemas for the tables

*All attributes are floating point or double unless otherwise noted.*
### Schema for "objects" table

### Schema for "sherlock_classifications" table

(for more information see Sherlock documentation)

### Schema for "sherlock_crossmatches" table

(for more information see Sherlock documentation)

### Schema for "candidates" table

(The attributes below are not the full schema. For more documentation and full schema see ZTF schema document).

ncand | number of candidates that cite this object (integer) |

ramean | mean RA in degrees |

decmean | mean Dec in degrees |

rastd | standard deviation of RA in arcseconds |

decstd | standard deviation of Dec in arcseconds |

glonmean | mean galactic longitude in degrees |

glatmean | mean galactic latitude in degrees |

maggmin | minimum g magnitude of candidates that cite this object |

maggmax | maximum g magnitude of candidates that cite this object |

maggmedian | median g magnitude of candidates that cite thisobject |

maggmean | mean g magnitude of candidates that cite thisobject |

magrmin | minimum r magnitude of candidates that cite thisobject |

magrmax | maximum r magnitude of candidates that cite thisobject |

magrmedian | median r magnitude of candidates that cite thisobject |

magrmean | mean r magnitude of candidates that cite thisobject |

latestgmag | latest g magnitude of candidates that cite this object |

latestrmag | latest r magnitude of candidates that cite this object |

jdmin | earliest Julian Day of candidates that cite this object |

jdmax | latest Julian Day of candidates that cite this object |

latest_dc_mag_g | Latest computed apparent g magnitude (see Note about Photometry in this page |

latest_dc_mag_r | Latest computed apparent r magnitude (see Note about Photometry in this page |

latest_dc_mag_g02 | Latest Exponential Moving Average of apparent magnitude in g band, with 2-day timescale (see note) |

latest_dc_mag_g08 | Latest Exponential Moving Average of apparent magnitude in g band, with 8-day timescale (see note) |

latest_dc_mag_g28 | Latest Exponential Moving Average of apparent magnitude in g band, with 28-day timescale (see note) |

latest_dc_mag_r02 | Latest Exponential Moving Average of apparent magnitude in r band, with 2-day timescale (see note) |

latest_dc_mag_r08 | Latest Exponential Moving Average of apparent magnitude in r band, with 8-day timescale (see note) |

latest_dc_mag_r28 | Latest Exponential Moving Average of apparent magnitude in r band, with 28-day timescale (see note) |

classification | Can be NULL, AGN, BS, CV, NT, ORPHAN, SN, UNCLEAR, VS |

summary | Natural language about what Sherlock thinks this object is |

rank | Rank of the match, 1 being best (integer) |

catalogue_object_type | Type of crossmatched catalogued astrophysical source (Can be: star, galaxy, cv, cb, agn, other, unknown) (string) |

association_type | Predicted transient classification if correctly associated with catalogued astrophysical source (VS, SN, CV, BS, NT, AGN, UNKNOWN) (string) |

separationArcsec | Separation from the candidate |

northSeparationArcsec | Separation north |

eastSeparationArcsec | Separation east |

catalogue_table_name | Name of the catalog with the matched object (string) |

catalogue_object_id | ID in the named catalog (integer) |

z | Redshift of the object |

distance | Distance of the object in Mpc |

U | U magnitude if known |

UErr | Error on U magnitude |

B | B magnitude if known |

BErr | Error on B magnitude |

V | V magnitude if known |

VErr | Error on V magnitude |

G | G magnitude if known |

GErr | Error on G magnitude |

R | R magnitude if known |

RErr | Error on R magnitude |

I | I magnitude if known |

IErr | Error on I magnitude |

J | J magnitude if known |

JErr | Error on J magnitude |

H | H magnitude if known |

HErr | Error on H magnitude |

K | K magnitude if known |

KErr | Error on K magnitude |

_u | u magnitude if known |

_uErr | Error on u magnitude |

_g | g magnitude if known |

_gErr | Error on g magnitude |

_r | r magnitude if known |

_rErr | Error on r magnitude |

_i | i magnitude if known |

_iErr | Error on i magnitude |

_z | z magnitude if known |

_zErr | Error on z magnitude |

_y | y magnitude if known |

_yErr | Error on y magnitude |

objectId | Object ID for objects to which this candidate belongs (string) |

candid | unique identifier for the subtraction candidate (integer) |

jd | Observation Julian date at start of exposure |

ra | Right Ascension of candidate; J2000 [deg] |

decl | Declination of candidate; J2000 [deg] |

magpsf | magnitude from PSF-fit photometry [mag] |

sigmapsf | 1-sigma uncertainty in magpsf [mag] |

chipsf | Reduced chi-square for PSF-fit |

magap | Aperture mag using 8 pixel diameter aperture [mag] |

sigmagap | 1-sigma uncertainty in magap [mag] |

isdiffpos | t or 1 if candidate is from positive (sci minus ref) subtraction; f or 0 if candidate is from negative (ref minus sci) subtraction (string) |

nid | Night ID, starts 2017-01-01 (integer) |

field | ZTF field ID (integer) |

xpos | x-image position of candidate [pixels] |

ypos | y-image position of candidate [pixels] |

distnr | distance to nearest source in reference image PSF-catalog within 30 arcsec [pixels] |

magnr | magnitude of nearest source in reference image PSF-catalog within 30 arcsec [mag] |

sigmagnr | 1-sigma uncertainty in magnr within 30 arcsec [mag] |

sky | Local sky background estimate [DN] |

magdiff | Difference: magap - magpsf [mag] |

fwhm | Full Width Half Max assuming a Gaussian core, from SExtractor [pixels] |

classtar | Star/Galaxy classification score from SExtractor (string) |

elong | Ratio: aimage / bimage |

nbad | number of prior-tagged bad pixels in a 5 x 5 pixel stamp (integer) |

rb | RealBogus quality score; range is 0 to 1 where closer to 1 is more reliable |

drb | RealBogus quality score from Deep-Learning-based classifier; range is 0 to 1 where closer to 1 is more reliable |

drbversion | version of Deep-Learning-based classifier model used to assign RealBogus (drb) quality score |

scorr | Peak-pixel signal-to-noise ratio in point source matched-filtered detection image |

Solar System | |

ssdistnr | distance to nearest known solar system object; set to -999.0 if none [arcsec] |

ssmagnr | magnitude of nearest known solar system object (usually V-band from MPC archive); set to -999.0 if none [mag] |

ssnamenr | name of nearest known solar system object (from MPC archive); ‘null’ if none (string) |

Pan-STARRS | |

objectidps1 | Object ID of closest source from PS1 catalog; if exists within 30 arcsec |

sgmag1 | g-band PSF magnitude of closest source from PS1 catalog; if exists within 30 arcsec [mag] |

srmag1 | r-band PSF magnitude of closest source from PS1 catalog; if exists within 30 arcsec [mag] |

simag1 | i-band PSF magnitude of closest source from PS1 catalog; if exists within 30 arcsec [mag] |

szmag1 | z-band PSF magnitude of closest source from PS1 catalog; if exists within 30 arcsec [mag] |

sgscore1 | Star/Galaxy score of closest source from PS1 catalog 0 <= sgscore <= 1 where closer to 1 implies higher likelihood of being a star |

distpsnr1 | Distance of closest source from PS1 catalog; if exists within 30 arcsec [arcsec] |

Gaia DR1 | |

neargaia | Distance to closest source from Gaia DR1 catalog irrespective of magnitude; if exists within 90 arcsec [arcsec] |

neargaiabright | Distance to closest source from Gaia DR1 catalog brighter than magnitude 14; if exists within 90 arcsec [arcsec] |

maggaia | Gaia (G-band) magnitude of closest source from Gaia DR1 catalog irrespective of magnitude; if exists within 90 arcsec [mag] |

maggaiabright | Gaia (G-band) magnitude of closest source from Gaia DR1 catalog brighter than magnitude 14; if exists within 90 arcsec [mag] |

Attributes added by Lasair | |

dc_mag | Computed apparent magnitude (see Note about Photometry in this page |

dc_sigmag | Error in computed apparent magnitude (see Note about Photometry in this page |

dc_mag_g02 | Exponential Moving Average of apparent magnitude in g band, with 2-day timescale (see note) |

dc_mag_g08 | Exponential Moving Average of apparent magnitude in g band, with 8-day timescale (see note) |

dc_mag_g28 | Exponential Moving Average of apparent magnitude in g band, with 28-day timescale (see note) |

dc_mag_r02 | Exponential Moving Average of apparent magnitude in r band, with 2-day timescale (see note) |

dc_mag_r08 | Exponential Moving Average of apparent magnitude in r band, with 8-day timescale (see note) |

dc_mag_r28 | Exponential Moving Average of apparent magnitude in r band, with 28-day timescale (see note) |