Table information for 'alerce_tap.magstat'

General

Table Description:

Per-band photometric statistics for each object including mean, median, minimum, maximum magnitudes, standard deviation, first/last magnitudes, rate of change, and corrected values accounting for host galaxy flux.

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

Resource Description:

Multi-survey astronomical object catalog containing astrometric and statistical information from multiple surveys. This table provides aggregated properties for astronomical objects including position, detection statistics, and temporal coverage.

For a list of all services and tables belonging to this table's resource, see Information on resource 'ALeRCE Multi-Survey Object Catalog'

Citing this table

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

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

Columns

Sorted alphabetically. [Sort by DB column index]

NameTable Head DescriptionUnitUCD
band Band Photometric band N/A instr.bandpass
corrected Corrected Correction applied flag N/A meta.code.qual
dm_first Dm_first First magnitude difference mag phot.mag;arith.diff
dmdt_first Dmdt_first First magnitude rate of change mag/d arith.rate;phot.mag
dt_first Dt_first First time interval d time.interval
firstmjd Firstmjd First observation MJD d time.start
lastmjd Lastmjd Last observation MJD d time.end
magfirst Magfirst First magnitude mag phot.mag
magfirst_corr Magfirst_corr Corrected first magnitude mag phot.mag;arith.corrected
maglast Maglast Last magnitude mag phot.mag
maglast_corr Maglast_corr Corrected last magnitude mag phot.mag;arith.corrected
magmax Magmax Maximum magnitude mag phot.mag;stat.max
magmax_corr Magmax_corr Corrected maximum magnitude mag phot.mag;stat.max;arith.corrected
magmean Magmean Mean magnitude mag phot.mag;stat.mean
magmean_corr Magmean_corr Corrected mean magnitude mag phot.mag;stat.mean;arith.corrected
magmedian Magmedian Median magnitude mag phot.mag;stat.median
magmedian_corr Magmedian_corr Corrected median magnitude mag phot.mag;stat.median;arith.corrected
magmin Magmin Minimum magnitude mag phot.mag;stat.min
magmin_corr Magmin_corr Corrected minimum magnitude mag phot.mag;stat.min;arith.corrected
magsigma Magsigma Magnitude standard deviation mag stat.stdev;phot.mag
magsigma_corr Magsigma_corr Corrected magnitude standard deviation mag stat.stdev;phot.mag;arith.corrected
n_det N_det Number of detections N/A meta.number
ndubious Ndubious Number of dubious measurements N/A meta.number
oid Oid Object identifier N/A meta.id;src
saturation_rate Saturation_rate Saturation rate N/A arith.rate
sid Sid Survey identifier N/A meta.id
sigmadm_first Sigmadm_first First magnitude difference error mag stat.error;phot.mag
stellar Stellar Stellar classification flag N/A src.class.starGalaxy
step_id_corr Step_id_corr Correction step identifier N/A meta.id
updated_date Updated_date Date record was last updated N/A time.processing

Columns that are parts of indices are marked like this.

VOResource

VO nerds may sometimes need VOResource XML for this table.