Choose a database in the left panel then select the table you want!
Table: catwise2020.main
(The bold columns are indexed columns)
| Column Name | Description | Datatype |
|---|---|---|
| ab_flags | unWISE artifact bitmask contamination flags | VARCHAR |
| cc_flags | Worst case 4 character cc_flag from AllWISE | VARCHAR |
| chi2pmdec | Chi-square for PMDEC difference (1 degree of freedom) | REAL |
| chi2pmra | Chi-square for PMRA difference (1 degree of freedom) | REAL |
| dec | Declination in degrees (ICRS) | DOUBLE |
| dec_pm | Declination at epoch MJD=57170 (2015.405) from psf model incl. motion | DOUBLE |
| delat | Descending scan - ascending scan ecliptic latitude | REAL |
| delatsig | One-sigma uncertainty in Delat | REAL |
| delatsnr | |Delat|/DelatSig | REAL |
| delon | Descending scan - ascending scan ecliptic longitude | REAL |
| delonsig | One-sigma uncertainty in Delon | REAL |
| delonsnr | |Delon|/DelonSig | REAL |
| dist | Radial distance between source positions in ascending and descending scans | REAL |
| dist_x | Distance between CatWISE and AllWISE source | DOUBLE |
| dw1mag | Difference in w1mpro between ascending and descending scans | REAL |
| dw2mag | Difference in w1mpro between ascending and descending scans | REAL |
| elat | Ecliptic latitude | DOUBLE |
| elat_avg | Average ecliptic latitude | DOUBLE |
| elatsig | One-sigma uncertainty in ecliptic latitude | REAL |
| elon | Ecliptic longitude | DOUBLE |
| elon_avg | Average ecliptic longitude | DOUBLE |
| elonsig | One-sigma uncertainty in ecliptic longitude | REAL |
| glat | Galactic latitude | DOUBLE |
| glon | Galactic longitude | DOUBLE |
| htm9 | HTM index (order 9 => ~10 arcmin size) | INTEGER |
| k1 | W1 photometry usage code | INTEGER |
| k2 | W2 photometry usage code | INTEGER |
| ka | Astrometry usage code | INTEGER |
| km | Proper motion usage code | INTEGER |
| mdetid | Source ID in mdet list | INTEGER |
| meanobsmjd | Mean observation epoch | DOUBLE |
| n_aw | Number of AllWISE matches within 2.75 asec | INTEGER |
| na | Number of actively deblended components | INTEGER |
| nb | Number of blend components used in each fit | INTEGER |
| nest4096 | HEALPIX index (Nsides 4096, Nest scheme => ~52 arcsec size | INTEGER |
| niters | Number of chi-square-minimization iterations | INTEGER |
| niters_pm | Number of chi-square-minimization iterations | INTEGER |
| nsteps | Number of steps in all iterations | INTEGER |
| nsteps_pm | Number of steps in all iterations | INTEGER |
| p1 | Vector from the mdet position to the wphot template-fit position, component 1 | REAL |
| p2 | Vector from the mdet position to the wphot template-fit position, component 2 | REAL |
| par_pm | Parallax from PM desc-asce elon | REAL |
| par_pmsig | One-sigma uncertainty in par_pm | REAL |
| par_sigma | One-sigma uncertainty in par_stat | REAL |
| par_stat | Parallax estimate from stationary solution | REAL |
| pmcode | Motion estimate quality code | VARCHAR |
| pmdec | Aparent motion in Dec | REAL |
| pmra | Aparent motion in RA | REAL |
| q12 | -log10(1-P(rho12)) given no real correlation | INTEGER |
| ra | Right ascension in degrees (ICRS) | DOUBLE |
| ra_pm | Right ascension at epoch MJD=57170 (2015.405) from psf model incl. motion | DOUBLE |
| random_id | Random ID in the range 0.0 => 100.0 | REAL |
| rch2w1 | Chi-square for dw1mag (1 degree of freedom) | REAL |
| rch2w2 | Chi-square for dw2mag (1 degree of freedom) | REAL |
| rchi2 | Instrumental profile-fit photometry reduced chi squared, total | REAL |
| rchi2_pm | Combined Reduced chi^2 in all bands for the psf photometry includes src motion | REAL |
| rho12 | band 1 - band 2 correlation coefficient | INTEGER |
| ring256 | HEALPIX index (Nsides 256, Ring scheme => ~14 arcmin size) | INTEGER |
| sigdec | Uncertainty in Dec (arcsec) | REAL |
| sigdec_pm | Uncertainty in the Dec motion estimate | REAL |
| sigpmdec | Uncertainty in Dec motion estimate | REAL |
| sigpmra | Uncertainty in RA motion estimate | REAL |
| sigra | Uncertainty in RA (arcsec) | REAL |
| sigra_pm | Uncertainty in the RA motion estimate | REAL |
| sigradec | Cross-term of RA and Dec uncertainty (arcsec) | REAL |
| sigradec_pm | The co-sigma of the equatorial position uncertainties from psf model incl motion | REAL |
| source_id | Tile name + processing code + wphot index | VARCHAR |
| source_name | Source hexagesimal designation | VARCHAR |
| unwise_objid | unWISE catalog object ID | VARCHAR |
| w1ab_map | unWISE artifact bitmask contamination map for W1 | INTEGER |
| w1ab_map_str | unWISE artifact bitmask contamination string for W1 | VARCHAR |
| w1cc_map | Worst case w1cc_map from AllWISE | INTEGER |
| w1cc_map_str | Worst case w1cc_map_str from AllWISE | VARCHAR |
| w1conf | Frame sky confusion based on the uncertainty images, band-1 | REAL |
| w1cov | Mean coverage depth, band-1 | REAL |
| w1fitr | Fitting radius, band-1 (clipped at 999.99) | REAL |
| w1flg | Instrumental standard aperture flag, band-1 | INTEGER |
| w1flg_1 | Aperture 1, instrumental aperture flag, band-1 | INTEGER |
| w1flg_2 | Aperture 2, instrumental aperture flag, band-1 | INTEGER |
| w1flg_3 | Aperture 3, instrumental aperture flag, band-1 | INTEGER |
| w1flg_4 | Aperture 4, instrumental aperture flag, band-1 | INTEGER |
| w1flg_5 | Aperture 5, instrumental aperture flag, band-1 | INTEGER |
| w1flg_6 | Aperture 6, instrumental aperture flag, band-1 | INTEGER |
| w1flg_7 | Aperture 7, instrumental aperture flag, band-1 | INTEGER |
| w1flg_8 | Aperture 8, instrumental aperture flag, band-1 | INTEGER |
| w1flux | Profile-fit photometry raw flux, band-1 | REAL |
| w1flux_pm | Raw flux W1 profile-fit photometry including motion | REAL |
| w1k | Stetson k index for variability; band-1 | REAL |
| w1m | Number of profile-fit flux measurements for source, band-1 | INTEGER |
| w1mag | Instrumental standard aperture mag w/ correction applied, band-1 | REAL |
| w1mag_1 | Aperture 1, instrumental aperture mag, band-1 | REAL |
| w1mag_2 | Aperture 2, instrumental aperture mag, band-1 | REAL |
| w1mag_3 | Aperture 3, instrumental aperture mag, band-1 | REAL |
| w1mag_4 | Aperture 4, instrumental aperture mag, band-1 | REAL |
| w1mag_5 | Aperture 5, instrumental aperture mag, band-1 | REAL |
| w1mag_6 | Aperture 6, instrumental aperture mag, band-1 | REAL |
| w1mag_7 | Aperture 7, instrumental aperture mag, band-1 | REAL |
| w1mag_8 | Aperture 8, instrumental aperture mag, band-1 | REAL |
| w1magp | Profile-fit repeatability mag, band-1 | REAL |
| w1mjdmax | Maximum modified Julian Date of frame extractions, band 1 | DOUBLE |
| w1mjdmean | Mean modified Julian Date of frame extractions, band 1 | DOUBLE |
| w1mjdmin | Minimum modified Julian Date of frame extractions, band 1 | DOUBLE |
| w1mlq | -ln(Q), where Q = 1-P(chi^2); band-1 | REAL |
| w1mpro | Instrumental profile-fit photometry magnitud, band-1 | REAL |
| w1mpro_pm | W1 magnitude from profile-fit photometry including motion | REAL |
| w1ndf | Number degrees of freedom in variability chi^2; band-1 | INTEGER |
| w1nm | Number of profile-fit flux measurements for source with SNR >= 3, band-1 | INTEGER |
| w1rchi2 | Instrumental profile-fit photometry reduced chi^2, band-1 | REAL |
| w1rchi2_pm | Reduced chi^2 of the W1 profile-fit photometry measurement including motion estimate | REAL |
| w1sat | Fraction of pixels affected by saturation, band-1 | REAL |
| w1sigflux | profile-fit photometry raw flux uncertainty, band-1 | REAL |
| w1sigflux_pm | Raw flux uncertainty W1 profile-fit photometry including motion1 | REAL |
| w1sigm | Instrumental standard aperture mag uncertainty applied, band-1 | REAL |
| w1sigm_1 | Aperture 1, instrumental aperture mag uncertainty, band-1 | REAL |
| w1sigm_2 | Aperture 2, instrumental aperture mag uncertainty, band-1 | REAL |
| w1sigm_3 | Aperture 3, instrumental aperture mag uncertainty, band-1 | REAL |
| w1sigm_4 | Aperture 4, instrumental aperture mag uncertainty, band-1 | REAL |
| w1sigm_5 | Aperture 5, instrumental aperture mag uncertainty, band-1 | REAL |
| w1sigm_6 | Aperture 6, instrumental aperture mag uncertainty, band-1 | REAL |
| w1sigm_7 | Aperture 7, instrumental aperture mag uncertainty, band-1 | REAL |
| w1sigm_8 | Aperture 8, instrumental aperture mag uncertainty, band-1 | REAL |
| w1sigmpro | Instrumental profile-fit photometry flux uncertainty in mag units, band-1 | REAL |
| w1sigmpro_pm | W1 flux uncertainty from profile-fit photometry including motion | REAL |
| w1sigp1 | Standard deviation of population of profile-fit repeatability mag; band-1 | REAL |
| w1sigp2 | Standard deviation of the mean of profile-fit repeatability mag the mean; band-1 | REAL |
| w1sigsk | Frame sky background value uncertainty, band-1 | REAL |
| w1sky | Frame sky background value, band-1 | REAL |
| w1snr | Instrumental profile-fit photometry S/N ratio, band-1 | REAL |
| w1snr_pm | S/N ratio of the W1 profile-fit photometry including motion | REAL |
| w2ab_map | unWISE artifact bitmask contamination map for W2 | INTEGER |
| w2ab_map_str | unWISE artifact bitmask contamination string for W2 | VARCHAR |
| w2cc_map | Worst case w2cc_map from AllWISE | INTEGER |
| w2cc_map_str | Worst case w2cc_map_str from AllWISE | VARCHAR |
| w2conf | Frame sky confusion based on the uncertainty images, band-2 | REAL |
| w2cov | Mean coverage depth, band-2 | REAL |
| w2fitr | Fitting radius, band-2 (clipped at 999.99) | REAL |
| w2flg | Instrumental standard aperture flag, band-2 | INTEGER |
| w2flg_1 | Aperture 1, instrumental aperture flag, band-2 | INTEGER |
| w2flg_2 | Aperture 2, instrumental aperture flag, band-2 | INTEGER |
| w2flg_3 | Aperture 3, instrumental aperture flag, band-2 | INTEGER |
| w2flg_4 | Aperture 4, instrumental aperture flag, band-2 | INTEGER |
| w2flg_5 | Aperture 5, instrumental aperture flag, band-2 | INTEGER |
| w2flg_6 | Aperture 6, instrumental aperture flag, band-2 | INTEGER |
| w2flg_7 | Aperture 7, instrumental aperture flag, band-2 | INTEGER |
| w2flg_8 | Aperture 8, instrumental aperture flag, band-2 | INTEGER |
| w2flux | profile-fit photometry raw flux, band-2 | REAL |
| w2flux_pm | Raw flux W2 profile-fit photometry including motion | REAL |
| w2k | Stetson k index for variability; band-2 | REAL |
| w2m | Number of profile-fit flux measurements for source, band-2 | INTEGER |
| w2mag | Instrumental standard aperture mag w/ correction applied, band-2 | REAL |
| w2mag_1 | Aperture 1, instrumental aperture mag, band-2 | REAL |
| w2mag_2 | Aperture 2, instrumental aperture mag, band-2 | REAL |
| w2mag_3 | Aperture 3, instrumental aperture mag, band-2 | REAL |
| w2mag_4 | Aperture 4, instrumental aperture mag, band-2 | REAL |
| w2mag_5 | Aperture 5, instrumental aperture mag, band-2 | REAL |
| w2mag_6 | Aperture 6, instrumental aperture mag, band-2 | REAL |
| w2mag_7 | Aperture 7, instrumental aperture mag, band-2 | REAL |
| w2mag_8 | Aperture 8, instrumental aperture mag, band-2 | REAL |
| w2magp | Profile-fit repeatability mag, band-1 | REAL |
| w2mjdmax | Maximum modified Julian Date of frame extractions, band 2 | DOUBLE |
| w2mjdmean | Mean modified Julian Date of frame extractions, band 2 | DOUBLE |
| w2mjdmin | Minimum modified Julian Date of frame extractions, band 2 | DOUBLE |
| w2mlq | -ln(Q), where Q = 1-P(chi^2); band-2 | REAL |
| w2mpro | Instrumental profile-fit photometry magnitud, band-2 | REAL |
| w2mpro_pm | W2 magnitude from profile-fit photometry including motion | REAL |
| w2ndf | No. degrees of freedom in variability chi^2; band-2 | INTEGER |
| w2nm | Number of profile-fit flux measurements for source with SNR >= 3, band-2 | INTEGER |
| w2rchi2 | Instrumental profile-fit photometry reduced chi^2, band-2 | REAL |
| w2rchi2_pm | Reduced chi^2 of the W2 profile-fit photometry measurement including motion estimate | REAL |
| w2sat | Fraction of pixels affected by saturation, band-2 | REAL |
| w2sigflux | profile-fit photometry raw flux uncertainty, band-2 | REAL |
| w2sigflux_pm | Raw flux uncertainty W2 profile-fit photometry including motion1 | REAL |
| w2sigm | Instrumental standard aperture mag uncertainty applied, band-2 | REAL |
| w2sigm_1 | Aperture 1, instrumental aperture mag uncertainty, band-2 | REAL |
| w2sigm_2 | Aperture 2, instrumental aperture mag uncertainty, band-2 | REAL |
| w2sigm_3 | Aperture 3, instrumental aperture mag uncertainty, band-2 | REAL |
| w2sigm_4 | Aperture 4, instrumental aperture mag uncertainty, band-2 | REAL |
| w2sigm_5 | Aperture 5, instrumental aperture mag uncertainty, band-2 | REAL |
| w2sigm_6 | Aperture 6, instrumental aperture mag uncertainty, band-2 | REAL |
| w2sigm_7 | Aperture 7, instrumental aperture mag uncertainty, band-2 | REAL |
| w2sigm_8 | Aperture 8, instrumental aperture mag uncertainty, band-2 | REAL |
| w2sigmpro | Instrumental profile-fit photometry flux uncertainty in mag units, band-2 | REAL |
| w2sigmpro_pm | W2 flux uncertainty from profile-fit photometry including motion | REAL |
| w2sigp1 | Standard deviation of population of profile-fit repeatability mag; band-2 | REAL |
| w2sigp2 | Standard deviation of the mean of profile-fit repeatability mag the mean; band-1 | REAL |
| w2sigsk | Frame sky background value uncertainty, band-2 | REAL |
| w2sky | Frame sky background value, band-2 | REAL |
| w2snr | Instrumental profile-fit photometry S/N ratio, band-2 | REAL |
| w2snr_pm | S/N ratio of the W2 profile-fit photometry including motion | REAL |
| wx | X-pixel value | REAL |
| wy | Y-pixel value | REAL |
