Choose a database in the left panel then select the table you want!
Table: stripe82.gaia_dr1
(The bold columns are indexed columns)
| Column Name | Description | Datatype |
|---|---|---|
| astrometric_delta_q | Hipparcos/Gaia data discrepancy | REAL |
| astrometric_excess_noise | Excess noise of the source | DOUBLE |
| astrometric_excess_noise_sig | Significance of excess noise | DOUBLE |
| astrometric_n_bad_obs_ac | Number of bad observations AC | INTEGER |
| astrometric_n_bad_obs_al | Number of bad observations AL | SMALLINT |
| astrometric_n_good_obs_ac | Number of good observations AC | INTEGER |
| astrometric_n_good_obs_al | Number of good observations AL | SMALLINT |
| astrometric_n_obs_ac | Total number of observations AC | SMALLINT |
| astrometric_n_obs_al | Total number of observations AL | SMALLINT |
| astrometric_primary_flag | Primary or seconday | SMALLINT |
| astrometric_priors_used | Type of prior used in the astrometric solution | INTEGER |
| astrometric_relegation_factor | Relegation factor of the source | REAL |
| astrometric_weight_ac | Mean astrometric weight of the source | REAL |
| astrometric_weight_al | Mean astrometric weight of the source | DOUBLE |
| b | Galactic latitude | DOUBLE |
| dec | Declination | DOUBLE |
| dec_error | Standard error of declination | DOUBLE |
| dec_parallax_corr | Correlation between declination and parallax | DOUBLE |
| dec_pmdec_corr | Correlation between declination and proper motion in declination | DOUBLE |
| dec_pmra_corr | Correlation between declination and proper motion in right ascension | DOUBLE |
| duplicated_source | Source with duplicate sources | SMALLINT |
| ecl_lat | Ecliptic latitude | DOUBLE |
| ecl_lon | Ecliptic longitude | DOUBLE |
| htm9 | Ninth level (~10 arcmin resolution) Hierarchical Triangular Mesh index (Szalay et al. 2007) | INTEGER |
| l | Galactic longitude | DOUBLE |
| matched_observations | Amount of observations matched to this source | SMALLINT |
| nest256 | HEALPIX index (Nsides 256, Nest scheme => ~14 arcmin size) | BIGINT |
| parallax | Parallax | DOUBLE |
| parallax_error | Standard error of parallax | DOUBLE |
| parallax_pmdec_corr | Correlation between parallax and proper motion in declination | DOUBLE |
| parallax_pmra_corr | Correlation between parallax and proper motion in right ascension | DOUBLE |
| phot_g_mean_flux | G-band mean flux | DOUBLE |
| phot_g_mean_flux_error | Error on G-band mean flux | DOUBLE |
| phot_g_mean_mag | G-band mean magnitude | DOUBLE |
| phot_g_n_obs | Number of observations contributing to G photometry | SMALLINT |
| phot_variable_flag | Photometric variability flag | CHAR |
| pmdec | Proper motion in declination direction | DOUBLE |
| pmdec_error | Standard error of proper motion in declination direction | DOUBLE |
| pmra | Proper motion in right ascension direction | DOUBLE |
| pmra_error | Standard error of proper motion in right ascension direction | DOUBLE |
| pmra_pmdec_corr | Correlation between proper motion in right ascension and proper motion in declination | DOUBLE |
| ra | Right ascension | DOUBLE |
| ra_dec_corr | Correlation between right ascension and declination | DOUBLE |
| ra_error | Standard error of right ascension | DOUBLE |
| ra_parallax_corr | Correlation between right ascension and parallax | DOUBLE |
| ra_pmdec_corr | Correlation between right ascension and proper motion in declination | DOUBLE |
| ra_pmra_corr | Correlation between right ascension and proper motion in right ascension | DOUBLE |
| random_index | Random index used to select subsets | INTEGER |
| ref_epoch | Reference epoch | REAL |
| ring256 | Ring-scheme HEALPix (Gorski et al. 2005) index with NSIDE=256 (~14 arcmin resolution) | INTEGER |
| scan_direction_mean_k1 | Mean position angle of scan directions across the source | REAL |
| scan_direction_mean_k2 | Mean position angle of scan directions across the source | REAL |
| scan_direction_mean_k3 | Mean position angle of scan directions across the source | REAL |
| scan_direction_mean_k4 | Mean position angle of scan directions across the source | REAL |
| scan_direction_strength_k1 | Degree of concentration of scan directions across the source | REAL |
| scan_direction_strength_k2 | Degree of concentration of scan directions across the source | REAL |
| scan_direction_strength_k3 | Degree of concentration of scan directions across the source | REAL |
| scan_direction_strength_k4 | Degree of concentration of scan directions across the source | REAL |
| solution_id | Solution Identifier | BIGINT |
| source_id | Unique source identifier (unique within a particular Data Release) | BIGINT |
