| |
Click on the table name to see the schema:
objectId | ZTF object identifier |
decmean | Mean Dec in degrees |
decstd | Standard deviation of Dec in arcseconds |
ramean | Mean RA in degrees |
rastd | Standard deviation of RA in arcseconds |
glatmean | Mean galactic latitude in degrees |
glonmean | Mean galactic longitude in degrees |
jdgmax | Latest Julian Day of g mag candidates |
gmag | Latest g magnitude |
dmdt_g | most recent increase in g magnitude divided by time difference, (brightening = positive) |
dmdt_g_2 | deprecated -- always Null |
mag_g02 | Latest Exponential Moving Average of difference magnitude in g band, with 2-day timescale (see note) |
mag_g08 | Latest Exponential Moving Average of difference magnitude in g band, with 8-day timescale (see note) |
mag_g28 | Latest Exponential Moving Average of difference magnitude in g band, with 28-day timescale (see note) |
maggmax | Maximum g magnitude of light curve (faintest) |
maggmean | Mean g magnitude of light curve |
maggmin | Minimum g magnitude of light curve (brightest) |
jdrmax | Latest Julian Day of r mag candidates |
mag_r02 | Latest Exponential Moving Average of difference magnitude in r band, with 2-day timescale (see note) |
mag_r08 | Latest Exponential Moving Average of difference magnitude in r band, with 8-day timescale (see note) |
mag_r28 | Latest Exponential Moving Average of difference magnitude in r band, with 28-day timescale (see note) |
rmag | latest r magnitude |
dmdt_r | most recent increase in r magnitude divided by time difference, (brightening = positive) |
dmdt_r_2 | deprecated -- always Null |
magrmax | Maximum r magnitude of light curve (faintest) |
magrmean | Mean r magnitude of light curve |
magrmin | Minimum r magnitude of light curve (brightest) |
jdmax | Maximum of jdgmax and jdrmax |
jdmin | Earliest Julian Day of candidates that cite this object |
ncand | Number in light curve |
ncandgp | Number in light curve with good quality and brighter than reference |
distpsnr1 | Distance of closest source from PS1 catalog; if exists within 30 arcsec [arcsec] |
sgscore1 | Star/Galaxy score of closest source from PS1 catalog 0 <= sgscore <= 1 where closer to 1 implies higher likelihood of being a star |
sgmag1 | g-band PSF magnitude of closest source from PS1 catalog; if exists within 30 arcsec |
srmag1 | r-band PSF magnitude of closest source from PS1 catalog; if exists within 30 arcsec |
htm16 | Hierarchical Triangular Mesh level 16 |
g_minus_r | Value of g-r on most recent night when both were available and both positive difference magnitudes |
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 |
ncandgp_7 | Number in light curve with good quality and brighter than reference in last 7 days |
ncandgp_14 | Number in light curve with good quality and brighter than reference in last 14 days |
ssnamenr | MPC name of Solar System object |
dmdt_g_err | Error estimate for dmdt_g |
dmdt_r_err | Error estimate for dmdt_r |
objectId | ZTF object identifier, also known as transient_object_id |
classification | Top-ranked contextual classification for the transient (NULL, AGN, BS, CV, NT, ORPHAN, SN, UNCLEAR, VS) |
association_type | Association classification for the transient (NULL, AGN, BS, CV, NT, ORPHAN, SN, UNCLEAR, VS) |
catalogue_table_name | Name/s of catalogue/s from which the best crossmatch is made |
catalogue_object_id | Identifier in the catalogue/s from which the best crossmatch is made |
catalogue_object_type | Type of catalogue from which the best crossmatch is made |
raDeg | RA in degrees of the transient |
decDeg | Dec in degrees of the transient |
separationArcsec | Transient's angular separation (arcseconds) from the top-ranked catalogue source match |
northSeparationArcsec | Transient's angular separation (arcseconds) from the top-ranked catalogue source match |
eastSeparationArcsec | Transient's angular separation (arcseconds) from the top-ranked catalogue source match |
physical_separation_kpc | Distance in kilo parsec between transient and top-ranked catalogue source match |
direct_distance | Determined from a non-redshift related measurement - e.g. Cepheids/standard candle (Mpc) |
distance | Luminosity distance -- conversion from the spectral redshift (Mpc) |
z | Redshift of the top-ranked catalogue source match |
photoZ | Redshift of the top-ranked catalogue source match |
photoZErr | Redshift of the top-ranked catalogue source match |
Mag | Magnitude |
MagFilter | Magnitude filter |
MagErr | Magnitude error |
classificationReliability | Reliability of classification |
major_axis_arcsec | Size of associated galaxy in arcsec |
annotator | Information about this annotation |
additional_output | Addititonal information about this annotation |
description | Long-form, human-readable summary of the transient's characteristics as infered from Sherlock's classification |
summary | Short-form summary of the transient's context usual for webpage quick-look summaries |
ra | Right ascension in decimal degrees |
decl | Declination in decimal degrees |
tns_name | TNS name, for example 2021iru |
tns_prefix | For example SN or AT |
disc_mag | Discovery magnitude |
disc_mag_filter | string |
type | Astrophysical type of supernova, eg SN Ia |
z | Redshift |
hostz | Redshift of host galaxy |
host_name | Name of host galaxy |
ext_catalogs | External catalogues used |
disc_int_name | Discoverers internal name |
disc_date | Discovery date |
lastmodified_date | Last Modified date |
sender | Discoverers internal name |
reporters | Discoverers internal name |
source_group | Discoverers internal name |
htm16 | Hierarchical Triangular Mesh level 16 |
lasairmodified_date | Lasair last Modified date |
annotationID | auto increment counter |
objectId | ObjectId of the object that this annotator applies to |
topic | The topic name of the annotator -- acts as primary key |
version | Version information for the annotator software |
timestamp | Time at which this annotation was added to the database |
classification | Short, non-trivial string expressing the classification of this object by this annotator |
explanation | Natural language explanation of the classification |
classdict | Machine readable informayion about the classification |
url | URL for further information about this annotation of this object |
|