Table information for 'ztf.magstat'

General

Table Description:

Per-filter magnitude statistics for each ZTF object including mean, median, min, max magnitudes both raw and corrected, along with temporal extent and variability metrics.

This table is available for ADQL queries and through the TAP endpoint.

Resource Description:

Legacy ZTF astronomical catalog containing objects, detections, photometric measurements, classifications, and cross-matches from the Zwicky Transient Facility (ZTF) survey, as processed by the ALeRCE broker pipeline.

For a list of all services and tables belonging to this table's resource, see Information on resource 'ALeRCE ZTF Legacy Catalog'

Citing this table

To cite the table as such, we suggest the following BibTeX entry:

@MISC{vo:ztf_magstat,
  year=2026,
  title={{ZTF} Magnitude Statistics},
  author={{ALeRCE} Team},
  url={http://tap.alerce.online/tableinfo/ztf.magstat},
  howpublished={{VO} resource provided by the {ALeRCE} {TAP} service}
}

Columns

Sorted by DB column index. [Sort alphabetically]

NameTable Head DescriptionUnitUCD
oid Oid Object identifier N/A meta.id;src
fid Fid Filter identifier (1=g, 2=r, 3=i) N/A meta.id;instr.filter
stellar Stellar Whether object is classified as stellar in this filter N/A src.class.starGalaxy
corrected Corrected Whether corrected magnitudes are available for this filter N/A meta.code.qual
ndet Ndet Number of detections in this filter N/A meta.number;src
ndubious Ndubious Number of dubious (unreliable) detections in this filter N/A meta.number;src
dmdt_first Dmdt_first Rate of magnitude change around first detection (mag/day) mag/d phot.mag;arith.rate
dm_first Dm_first Magnitude change around first detection mag phot.mag;arith.diff
sigmadm_first Sigmadm_first Uncertainty in dm_first mag stat.error;phot.mag
dt_first Dt_first Time baseline used to compute dm_first d time.interval
magmean Magmean Mean magnitude mag phot.mag;stat.mean
magmedian Magmedian Median magnitude mag phot.mag;stat.median
magmax Magmax Maximum (faintest) magnitude mag phot.mag;stat.max
magmin Magmin Minimum (brightest) magnitude mag phot.mag;stat.min
magsigma Magsigma Standard deviation of magnitude mag stat.stdev;phot.mag
maglast Maglast Last observed magnitude mag phot.mag
magfirst Magfirst First observed magnitude mag phot.mag
magmean_corr Magmean_corr Mean corrected magnitude mag phot.mag;stat.mean
magmedian_corr Magmedian_corr Median corrected magnitude mag phot.mag;stat.median
magmax_corr Magmax_corr Maximum corrected magnitude mag phot.mag;stat.max
magmin_corr Magmin_corr Minimum corrected magnitude mag phot.mag;stat.min
magsigma_corr Magsigma_corr Standard deviation of corrected magnitude mag stat.stdev;phot.mag
maglast_corr Maglast_corr Last observed corrected magnitude mag phot.mag
magfirst_corr Magfirst_corr First observed corrected magnitude mag phot.mag
firstmjd Firstmjd MJD of first detection in this filter d time.start;obs
lastmjd Lastmjd MJD of last detection in this filter d time.end;obs
step_id_corr Step_id_corr Step identifier for the photometric correction pipeline N/A meta.id
saturation_rate Saturation_rate Fraction of detections that are saturated in this filter N/A stat.probability

Columns that are parts of indices are marked like this.

VOResource

VO nerds may sometimes need VOResource XML for this table.