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 (χ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 |
g_rp | G - RP colour Magnitude[mag] | DOUBLE |
glat | Galactic lattitude autogenerated Data Lab | DOUBLE |
glon | Galactic longitude autogenerated Data Lab | 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[μ-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[μ-1] | DOUBLE |
pseudocolour_error | Standard error of the pseudocolour of the source Misc[μ-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 |
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 |
random_id | Random ID in the range 0.0 => 100.0 (not unique) | REAL |
random_index | Random index used to select subsets | INTEGER |
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 |