### Choose a database in the left panel then select the table you want!

(The bold columns are indexed columns)

Column Name | Description | Datatype |
---|---|---|

dec | Declination (degrees) | DOUBLE |

dec_ok | Declination, good detections only (degrees) | DOUBLE |

elat | Ecliptic Latitude | DOUBLE |

elon | Ecliptic Longitude | DOUBLE |

epochmean | Mean MJD | DOUBLE |

epochmean_ok | Mean good MJD | DOUBLE |

epochrange | MJD difference between first and last detection | DOUBLE |

epochrange_ok | MJD difference between first and last good detection | DOUBLE |

err_g | Uncertainty in mean flux, in g band (statistical only) | REAL |

err_i | Uncertainty in mean flux, in i band (statistical only) | REAL |

err_lbs_g | Uncertainty in mean local background subtracted flux (statistical only), in g band | REAL |

err_lbs_i | Uncertainty in mean local background subtracted flux (statistical only), in i band | REAL |

err_lbs_r | Uncertainty in mean local background subtracted flux (statistical only), in r band | REAL |

err_lbs_y | Uncertainty in mean local background subtracted flux (statistical only), in Y band | REAL |

err_lbs_z | Uncertainty in mean local background subtracted flux (statistical only), in z band | REAL |

err_r | Uncertainty in mean flux, in r band (statistical only) | REAL |

err_y | Uncertainty in mean flux, in Y band (statistical only) | REAL |

err_z | Uncertainty in mean flux, in z band (statistical only) | REAL |

fracflux_g | PSF-weighted fraction of flux coming from this object, in g band (i.e., one minus the the fraction of flux in this objects PSF that comes from neighboring objects?) | REAL |

fracflux_i | PSF-weighted fraction of flux coming from this object, in i band (i.e., one minus the the fraction of flux in this objects PSF that comes from neighboring objects?) | REAL |

fracflux_r | PSF-weighted fraction of flux coming from this object, in r band (i.e., one minus the the fraction of flux in this objects PSF that comes from neighboring objects?) | REAL |

fracflux_y | PSF-weighted fraction of flux coming from this object, in Y band (i.e., one minus the the fraction of flux in this objects PSF that comes from neighboring objects?) | REAL |

fracflux_z | PSF-weighted fraction of flux coming from this object, in z band (i.e., one minus the the fraction of flux in this objects PSF that comes from neighboring objects?) | REAL |

glat | Galactic Latitude | DOUBLE |

glon | Galactic Longitude | DOUBLE |

htm9 | HTM index (order 9 => ~10 arcmin size) | INTEGER |

_id | BIGINT | |

maglimit_g | 5 sigma magnitude limit for deepest detection of this object (AB mag), in g band | REAL |

maglimit_i | 5 sigma magnitude limit for deepest detection of this object (AB mag), in i band | REAL |

maglimit_r | 5 sigma magnitude limit for deepest detection of this object (AB mag), in r band | REAL |

maglimit_y | 5 sigma magnitude limit for deepest detection of this object (AB mag), in Y band | REAL |

maglimit_z | 5 sigma magnitude limit for deepest detection of this object (AB mag), in z band | REAL |

mean_g | Mean flux, in g band, good detections only (3631 Jy) | REAL |

mean_i | Mean flux, in i band, good detections only (3631 Jy) | REAL |

mean_lbs_g | Mean flux, using a local background subtraction, in g band (3631 Jy) | REAL |

mean_lbs_i | Mean flux, using a local background subtraction, in i band (3631 Jy) | REAL |

mean_lbs_r | Mean flux, using a local background subtraction, in r band (3631 Jy) | REAL |

mean_lbs_y | Mean flux, using a local background subtraction, in Y band (3631 Jy) | REAL |

mean_lbs_z | Mean flux, using a local background subtraction, in z band (3631 Jy) | REAL |

mean_mag_g | g color from magnitudes derived from mean fluxes (mag) [NOT YET VALID] | REAL |

mean_mag_g_r | g-r color from magnitudes derived from mean fluxes (mag) [NOT YET VALID] | REAL |

mean_mag_i | i color from magnitudes derived from mean fluxes (mag) [NOT YET VALID] | REAL |

mean_mag_i_z | i-z color from magnitudes derived from mean fluxes (mag) [NOT YET VALID] | REAL |

mean_mag_r | r color from magnitudes derived from mean fluxes (mag) [NOT YET VALID] | REAL |

mean_mag_r_i | r-i color from magnitudes derived from mean fluxes (mag) [NOT YET VALID] | REAL |

mean_mag_y | Y color from magnitudes derived from mean fluxes (mag) [NOT YET VALID] | REAL |

mean_mag_z | z color from magnitudes derived from mean fluxes (mag) [NOT YET VALID] | REAL |

mean_mag_z_y | z-Y color from magnitudes derived from mean fluxes (mag) [NOT YET VALID] | REAL |

mean_r | Mean flux, in r band, good detections only (3631 Jy) | REAL |

mean_y | Mean flux, in Y band, good detections only (3631 Jy) | REAL |

mean_z | Mean flux, in z band, good detections only (3631 Jy) | REAL |

median_g | Median flux, in g band (3631 Jy) | REAL |

median_i | Median flux, in i band (3631 Jy) | REAL |

median_lbs_g | Median local background subtracted flux, in g band (3631 Jy) | REAL |

median_lbs_i | Median local background subtracted flux, in i band (3631 Jy) | REAL |

median_lbs_r | Median local background subtracted flux, in r band (3631 Jy) | REAL |

median_lbs_y | Median local background subtracted flux, in Y band (3631 Jy) | REAL |

median_lbs_z | Median local background subtracted flux, in z band (3631 Jy) | REAL |

median_mag_g | g color from magnitudes derived from median fluxes (mag) [NOT YET VALID] | REAL |

median_mag_g_r | g-r color from magnitudes derived from median fluxes (mag) [NOT YET VALID] | REAL |

median_mag_i | i color from magnitudes derived from median fluxes (mag) [NOT YET VALID] | REAL |

median_mag_i_z | i-z color from magnitudes derived from median fluxes (mag) [NOT YET VALID] | REAL |

median_mag_r | r color from magnitudes derived from median fluxes (mag) [NOT YET VALID] | REAL |

median_mag_r_i | r-i color from magnitudes derived from median fluxes (mag) [NOT YET VALID] | REAL |

median_mag_y | Y color from magnitudes derived from median fluxes (mag) [NOT YET VALID] | REAL |

median_mag_z | z color from magnitudes derived from median fluxes (mag) [NOT YET VALID] | REAL |

median_mag_z_y | z-Y color from magnitudes derived from median fluxes (mag) [NOT YET VALID] | REAL |

median_r | Median flux, in r band (3631 Jy) | REAL |

median_y | Median flux, in Y band (3631 Jy) | REAL |

median_z | Median flux, in z band (3631 Jy) | REAL |

ndet | Total number of detections | SMALLINT |

ndet_lbs | Number of detections | SMALLINT |

ndet_lbs_ok | Number of good detections | SMALLINT |

ndet_ok | Number of good detections | SMALLINT |

nest4096 | HEALPIX index (Nsides 4096, Nest scheme => ~52 arcsec size | INTEGER |

nmag_g | Number of detections in g band | SMALLINT |

nmag_i | Number of detections in i band | SMALLINT |

nmag_lbs_g | Number of detections in g band | SMALLINT |

nmag_lbs_i | Number of detections in i band | SMALLINT |

nmag_lbs_ok_g | Number of good detections in g band | SMALLINT |

nmag_lbs_ok_i | Number of good detections in i band | SMALLINT |

nmag_lbs_ok_r | Number of good detections in r band | SMALLINT |

nmag_lbs_ok_y | Number of good detections in Y band | SMALLINT |

nmag_lbs_ok_z | Number of good detections in z band | SMALLINT |

nmag_lbs_r | Number of detections in r band | SMALLINT |

nmag_lbs_y | Number of detections in Y band | SMALLINT |

nmag_lbs_z | Number of detections in z band | SMALLINT |

nmag_ok_g | Number of good detections in g band | SMALLINT |

nmag_ok_i | Number of good detections in i band | SMALLINT |

nmag_ok_r | Number of good detections in r band | SMALLINT |

nmag_ok_y | Number of good detections in Y band | SMALLINT |

nmag_ok_z | Number of good detections in z band | SMALLINT |

nmag_r | Number of detections in r band | SMALLINT |

nmag_y | Number of detections in Y band | SMALLINT |

nmag_z | Number of detections in z band | SMALLINT |

obj_id | Unique DECaPS object ID | BIGINT |

posstdev | Standard deviation in position of object between different detections (arcsec) | REAL |

posstdev_ok | Standard deviation in position of object between different detections (arcsec) | REAL |

q25_g | 25th percentile flux, in g band (3631 Jy) | REAL |

q25_i | 25th percentile flux, in i band (3631 Jy) | REAL |

q25_lbs_g | 25th percentile local background subtracted flux, in g band (3631 Jy) | REAL |

q25_lbs_i | 25th percentile local background subtracted flux, in i band (3631 Jy) | REAL |

q25_lbs_r | 25th percentile local background subtracted flux, in r band (3631 Jy) | REAL |

q25_lbs_y | 25th percentile local background subtracted flux, in Y band (3631 Jy) | REAL |

q25_lbs_z | 25th percentile local background subtracted flux, in z band (3631 Jy) | REAL |

q25_r | 25th percentile flux, in r band (3631 Jy) | REAL |

q25_y | 25th percentile flux, in Y band (3631 Jy) | REAL |

q25_z | 25th percentile flux, in z band (3631 Jy) | REAL |

q75_g | 75th percentile flux, in g band (3631 Jy) | REAL |

q75_i | 75th percentile flux, in i band (3631 Jy) | REAL |

q75_lbs_g | 75th percentile local background subtracted flux, in g band (3631 Jy) | REAL |

q75_lbs_i | 75th percentile local background subtracted flux, in i band (3631 Jy) | REAL |

q75_lbs_r | 75th percentile local background subtracted flux, in r band (3631 Jy) | REAL |

q75_lbs_y | 75th percentile local background subtracted flux, in Y band (3631 Jy) | REAL |

q75_lbs_z | 75th percentile local background subtracted flux, in z band (3631 Jy) | REAL |

q75_r | 75th percentile flux, in r band (3631 Jy) | REAL |

q75_y | 75th percentile flux, in Y band (3631 Jy) | REAL |

q75_z | 75th percentile flux, in z band (3631 Jy) | REAL |

ra | Right ascension (degrees) | DOUBLE |

random_id | Random ID in the range 0.0 => 100.0 | REAL |

ra_ok | Right ascension, good detections only (degrees) | DOUBLE |

ring256 | HEALPIX index (Nsides 256, Ring scheme => ~14 arcmin size) | INTEGER |

stdev_g | Standard deviation in flux, in g band; may be NaN in rare cases of objects with 1 measurement | REAL |

stdev_i | Standard deviation in flux, in i band; may be NaN in rare cases of objects with 1 measurement | REAL |

stdev_lbs_g | Standard deviation in local background subtracted fluxes, in g band; may be NaN in rare cases of objects with 1 measurement | REAL |

stdev_lbs_i | Standard deviation in local background subtracted fluxes, in i band; may be NaN in rare cases of objects with 1 measurement | REAL |

stdev_lbs_r | Standard deviation in local background subtracted fluxes, in r band; may be NaN in rare cases of objects with 1 measurement | REAL |

stdev_lbs_y | Standard deviation in local background subtracted fluxes, in Y band; may be NaN in rare cases of objects with 1 measurement | REAL |

stdev_lbs_z | Standard deviation in local background subtracted fluxes, in z band; may be NaN in rare cases of objects with 1 measurement | REAL |

stdev_r | Standard deviation in flux, in r band; may be NaN in rare cases of objects with 1 measurement | REAL |

stdev_y | Standard deviation in flux, in Y band; may be NaN in rare cases of objects with 1 measurement | REAL |

stdev_z | Standard deviation in flux, in z band; may be NaN in rare cases of objects with 1 measurement | REAL |