Choose a database in the left panel then select the table you want!
Table: gaia_edr3.gaia_source
(The bold columns are indexed columns)
| Column Name | Description | Datatype |
|---|---|---|
| astrometric_chi2_al | AL chi-square value Astrometric goodness-of-fit (chi^2) | DOUBLE |
| astrometric_excess_noise | Excess noise of the source Angle[mas] | DOUBLE |
| astrometric_excess_noise_sig | Significance of excess noise | DOUBLE |
| astrometric_gof_al | Goodness of fit statistic of model wrt along-scan observations Values exceeding, say, +3 thus indicate a bad fit to the data. | DOUBLE |
| astrometric_matched_transits | Matched FOV transits used in the AGIS solution | SMALLINT |
| astrometric_n_bad_obs_al | Number of bad observations AL | SMALLINT |
| 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_params_solved | Which parameters have been solved for [byte] | SMALLINT |
| astrometric_primary_flag | Primary or secondary | SMALLINT |
| astrometric_sigma5d_max | Matched FOV transits used in the AGIS solution | DOUBLE |
| b | Galactic latitude Angle[deg] | DOUBLE |
| bp_g | BP - G colour Magnitude[mag] | DOUBLE |
| bp_rp | BP - RP colour Magnitude[mag] | DOUBLE |
| dec | Declination Angle[deg] | DOUBLE |
| dec_error | Standard error of declination Angle[mas] | DOUBLE |
| dec_parallax_corr | Correlation between declination and parallax [-1,+1] | DOUBLE |
| dec_pmdec_corr | Correlation between declination and proper motion in declination [-1,+1] | DOUBLE |
| dec_pmra_corr | Correlation between declination and proper motion in right ascension [-1,+1] | DOUBLE |
| dec_pseudocolour_corr | Correlation between declination and pseudocolour [-1,+1] | DOUBLE |
| designation | Unique source designation (unique across all Data Releases) | VARCHAR |
| dr2_radial_velocity | Radial velocity from Gaia DR2 [km/s] | DOUBLE |
| dr2_radial_velocity_error | Radial velocity error from Gaia DR2 Velocity[km/s] | DOUBLE |
| dr2_rv_nb_transits | Number of transits used to compute radial velocity in Gaia DR2 | SMALLINT |
| dr2_rv_template_fe_h | Fe/H of the template used to compute radial velocity in Gaia DR2 Abundances[dex] | REAL |
| dr2_rv_template_logg | logg of the template used to compute radial velocity in Gaia DR2 GravitySurface[log cgs] | REAL |
| dr2_rv_template_teff | Teff of the template used to compute radial velocity in Gaia DR2 Temperature[K] | REAL |
| duplicated_source | Source with multiple source identifiers | SMALLINT |
| ecl_lat | Ecliptic latitude Angle[deg] | DOUBLE |
| ecl_lon | Ecliptic longitude Angle[deg] | DOUBLE |
| elat | Ecliptic lattitude autogenerated Data Lab | DOUBLE |
| elon | Ecliptic longitude autogenerated Data Lab | DOUBLE |
| glat | Galactic lattitude autogenerated Data Lab | DOUBLE |
| glon | Galactic longitude autogenerated Data Lab | DOUBLE |
| g_rp | G - RP colour Magnitude[mag] | DOUBLE |
| htm9 | HTM index (order 9 => ~10 arcmin size) | INTEGER |
| ipd_frac_multi_peak | Percent of successful-IPD windows with more than one peak | SMALLINT |
| ipd_frac_odd_win | Percent of transits with truncated windows or multiple gate | SMALLINT |
| ipd_gof_harmonic_amplitude | Amplitude of the IPD GoF versus position angle of scan | DOUBLE |
| ipd_gof_harmonic_phase | Phase of the IPD GoF versus position angle of scan Angle[deg] | DOUBLE |
| l | Galactic longitude Angle[deg] | DOUBLE |
| matched_transits | The number of transits matched to this source | SMALLINT |
| matched_transits_removed | The number of transits removed from an existing source in the current cycle | SMALLINT |
| nest4096 | HEALPIX index (Nsides 4096, Nest scheme => ~52 arcsec size | INTEGER |
| new_matched_transits | The number of transits newly incorporated into an existing source in the current cycle | SMALLINT |
| nu_eff_used_in_astrometry | Effective wavenumber of the source used in the astrometric solution Misc[um^-1] | DOUBLE |
| parallax | Parallax Angle[mas] | DOUBLE |
| parallax_error | Standard error of Parallax Angle[mas] | DOUBLE |
| parallax_over_error | Standard error of parallax Angle[mas] | DOUBLE |
| parallax_pmdec_corr | Correlation between parallax and proper motion in declination [-1,+1] | DOUBLE |
| parallax_pmra_corr | Correlation between parallax and proper motion in right ascension [-1,+1] | DOUBLE |
| parallax_pseudocolour_corr | Correlation between parallax and pseudocolour [-1,+1] | DOUBLE |
| phot_bp_mean_flux | Integrated BP mean flux Flux[e-/s] | DOUBLE |
| phot_bp_mean_flux_error | Error on the integrated BP mean flux Flux[e-/s] | DOUBLE |
| phot_bp_mean_flux_over_error | Integrated BP mean flux divided by its error | DOUBLE |
| phot_bp_mean_mag | Integrated BP mean magnitude Magnitude[mag] | DOUBLE |
| phot_bp_n_blended_transits | Number of BP blended transits | SMALLINT |
| phot_bp_n_contaminated_transits | Number of BP contaminated transits | SMALLINT |
| phot_bp_n_obs | Number of observations contributing to BP photometry | SMALLINT |
| phot_bp_rp_excess_factor | BP/RP excess factor | DOUBLE |
| phot_g_mean_flux | G-band mean flux Flux[e-/s] | DOUBLE |
| phot_g_mean_flux_error | Error on G-band mean flux Flux[e-/s] | DOUBLE |
| phot_g_mean_flux_over_error | G-band mean flux divided by its error | DOUBLE |
| phot_g_mean_mag | G-band mean magnitude Magnitude[mag] | DOUBLE |
| phot_g_n_obs | Number of observations contributing to G photometry | SMALLINT |
| phot_proc_mode | Photometry processing mode | SMALLINT |
| phot_rp_mean_flux | Integrated RP mean flux Flux[e-/s] | DOUBLE |
| phot_rp_mean_flux_error | Error on the integrated RP mean flux Flux[e-/s] | DOUBLE |
| phot_rp_mean_flux_over_error | Integrated RP mean flux divided by its error | DOUBLE |
| phot_rp_mean_mag | Integrated RP mean magnitude Magnitude[mag] | DOUBLE |
| phot_rp_n_blended_transits | Number of RP blended transits | SMALLINT |
| phot_rp_n_contaminated_transits | Number of RP contaminated transits | SMALLINT |
| phot_rp_n_obs | Number of observations contributing to RP photometry | SMALLINT |
| pm | Total proper motion Angular Velocity[mas/year] | DOUBLE |
| pmdec | Proper motion in declination direction Angular Velocity[mas/year] | DOUBLE |
| pmdec_error | Standard error of proper motion in declination direction Angular Velocity[mas/year] | DOUBLE |
| pmdec_pseudocolour_corr | Correlation between proper motion in declination and pseudocolour [-1,+1] | DOUBLE |
| pmra | Proper motion in right ascension direction Angular Velocity[mas/year] | DOUBLE |
| pmra_error | Standard error of proper motion in right ascension direction Angular Velocity[mas/year] | DOUBLE |
| pmra_pmdec_corr | Correlation between proper motion in right ascension and proper motion in declination [-1,+1] | DOUBLE |
| pmra_pseudocolour_corr | Correlation between proper motion in right asension and pseudocolour [-1,+1] | DOUBLE |
| pseudocolour | Astrometrically estimated pseudocolour of the source Misc[um^-1] | DOUBLE |
| pseudocolour_error | Standard error of the pseudocolour of the source Misc[um^-1] | DOUBLE |
| ra | Barycentric right ascension of the source in ICRS at the reference epoch ref_epoch | DOUBLE |
| ra_dec_corr | Correlation between right ascension and declination [-1,+1] | DOUBLE |
| ra_error | Standard error of the right ascension of the source in ICRS at the reference epoch ref_epoch. | DOUBLE |
| random_id | Random ID in the range 0.0 => 100.0 (not unique) | REAL |
| random_index | Random index used to select subsets | INTEGER |
| ra_parallax_corr | Correlation between right ascension and parallax [-1,+1] | DOUBLE |
| ra_pmdec_corr | Correlation between right ascension and proper motion in declination [-1,+1] | DOUBLE |
| ra_pmra_corr | Correlation between right ascension and proper motion in right ascension [-1,+1] | DOUBLE |
| ra_pseudocolour_corr | Correlation between right ascension and pseudocolour [-1,+1] | DOUBLE |
| ref_epoch | Reference epoch Time[Julian years] | REAL |
| ring256 | HEALPIX index (Nsides 256, Ring scheme => ~14 arcmin size) | INTEGER |
| ruwe | Renormalised unit weight error | DOUBLE |
| scan_direction_mean_k1 | Mean position angle of scan directions across the source | DOUBLE |
| scan_direction_mean_k2 | Mean position angle of scan directions across the source | DOUBLE |
| scan_direction_mean_k3 | Mean position angle of scan directions across the source | DOUBLE |
| scan_direction_mean_k4 | Mean position angle of scan directions across the source | DOUBLE |
| scan_direction_strength_k1 | Degree of concentration of scan directions across the source | DOUBLE |
| scan_direction_strength_k2 | Degree of concentration of scan directions across the source | DOUBLE |
| scan_direction_strength_k3 | Degree of concentration of scan directions across the source | DOUBLE |
| scan_direction_strength_k4 | Degree of concentration of scan directions across the source | DOUBLE |
| solution_id | Solution Identifier. To decode a given solution ID visit https://gaia.esac.esa.int/decoder/solnDecoder.jsp | BIGINT |
| source_id | Unique source identifier (unique within a particular Data Release) | BIGINT |
| visibility_periods_used | Number of visibility periods used in Astrometric solution | SMALLINT |
