|
| |
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 |
|
