Choose a database in the left panel then select the table you want!
Table: gaia_dr3.gaia_source
(The bold columns are indexed columns)
| Column Name | Description | Datatype |
|---|---|---|
| ag_gspphot | Extinction in G band from GSP-Phot Aeneas best library using BP/RP spectra (Magnitude[mag]) | REAL |
| ag_gspphot_lower | Lower confidence level (16%) of extinction in G band from GSP-Phot Aeneas best library using BP/RP spectra (Magnitude[mag]) | REAL |
| ag_gspphot_upper | Upper confidence level (84%) of extinction in G band from GSP-Phot Aeneas best library using BP/RP spectra (Magnitude[mag]) | REAL |
| astrometric_chi2_al | AL chi-square value Astrometric goodness-of-fit (chi^2) | REAL |
| astrometric_excess_noise | Excess noise of the source Angle[mas] | REAL |
| astrometric_excess_noise_sig | Significance of excess noise | REAL |
| astrometric_gof_al | Goodness of fit statistic of model wrt along-scan observations | REAL |
| 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 | Flag indicating if this source was used as a primary source (true) or secondary source (false) | CHAR |
| astrometric_sigma5d_max | Matched FOV transits used in the AGIS solution | REAL |
| azero_gspphot | Monochromatic extinction A0 at 547.7nm from GSP-Phot Aeneas best library using BP/RP spectra (Magnitude[mag]) | REAL |
| azero_gspphot_lower | Lower confidence level (16%) of monochromatic extinction A0 at 547.7nm from GSP-Phot Aeneas best library using BP/RP spectra (Magnitude[mag]) | REAL |
| azero_gspphot_upper | Upper confidence level (84%) of monochromatic extinction A0 at 547.7nm from GSP-Phot Aeneas best library using BP/RP spectra (Magnitude[mag]) | REAL |
| b | Galactic latitude Angle[deg] | DOUBLE |
| bp_g | BP - G colour Magnitude[mag] | DOUBLE |
| bp_rp | BP - RP colour Magnitude[mag] | REAL |
| classprob_dsc_combmod_galaxy | Probability from DSC-Combmod of being a galaxy (data used: BP/RP spectrum, photometry, astrometry) | REAL |
| classprob_dsc_combmod_quasar | Probability from DSC-Combmod of being a quasar (data used: BP/RP spectrum, photometry, astrometry) | REAL |
| classprob_dsc_combmod_star | Probability from DSC-Combmod of being a single star (but not a white dwarf) (data used: BP/RP spectrum, photometry, astrometry) | REAL |
| dec | Declination Angle[deg] | DOUBLE |
| dec_error | Standard error of declination Angle[mas] | REAL |
| dec_parallax_corr | Correlation between declination and parallax [-1,+1] | REAL |
| dec_pmdec_corr | Correlation between declination and proper motion in declination [-1,+1] | REAL |
| dec_pmra_corr | Correlation between declination and proper motion in right ascension [-1,+1] | REAL |
| dec_pseudocolour_corr | Correlation between declination and pseudocolour [-1,+1] | REAL |
| designation | Unique source designation (unique across all Data Releases) | CHAR |
| distance_gspphot | Distance from GSP-Phot Aeneas best library using BP/RP spectra (Length & Distance[pc]) | REAL |
| distance_gspphot_lower | Lower confidence level (16%) of distance from GSP-Phot Aeneas best library using BP/RP spectra (Length & Distance[pc]) | REAL |
| distance_gspphot_upper | Upper confidence level (84%) of distance from GSP-Phot Aeneas best library using BP/RP spectra (Length & Distance[pc]) | REAL |
| duplicated_source | Source with multiple source identifiers | SMALLINT |
| ebpminrp_gspphot | Reddening E(G_BP - G_RP) from GSP-Phot Aeneas best library using BP/RP spectra (Magnitude[mag]) | REAL |
| ebpminrp_gspphot_lower | Lower confidence level (16%) of reddening E(G_BP - G_RP) from GSP-Phot Aeneas best library using BP/RP spectra (Magnitude[mag]) | REAL |
| ebpminrp_gspphot_upper | Upper confidence level (84%) of reddening E(G_BP - G_RP) from GSP-Phot Aeneas best library using BP/RP spectra (Magnitude[mag]) | REAL |
| ecl_lat | Ecliptic latitude Angle[deg] | DOUBLE |
| ecl_lon | Ecliptic longitude Angle[deg] | DOUBLE |
| g_rp | G - RP colour Magnitude[mag] | REAL |
| grvs_mag | Integrated Grvs magnitude (Magnitude[mag]) | REAL |
| grvs_mag_error | Grvs magnitude uncertainty (Magnitude[mag]) | REAL |
| grvs_mag_nb_transits | Number of transits used to compute Grvs | SMALLINT |
| has_epoch_photometry | Flag indicating the availability of epoch photometry for this source | CHAR |
| has_epoch_rv | Flag indicating the availability of epoch radial velocity for this source | CHAR |
| has_mcmc_gspphot | Flag indicating the availability of GSP-Phot MCMC samples for this source | CHAR |
| has_mcmc_msc | Flag indicating the availability of MSC MCMC samples for this source | CHAR |
| has_rvs | Flag indicating the availability of mean RVS spectrum for this source | CHAR |
| has_xp_continuous | Flag indicating the availability of mean BP/RP spectrum in continuous representation for this source | CHAR |
| has_xp_sampled | Flag indicating the availability of mean BP/RP spectrum in sampled form for this source | CHAR |
| htm9 | HTM index (order 9 => ~10 arcmin size) | INTEGER |
| in_andromeda_survey | Flag indicating that the source is present in the Gaia Andromeda Photometric Survey (GAPS) | CHAR |
| in_galaxy_candidates | Flag indicating the availability of additional information in the galaxy_candidates table | CHAR |
| in_qso_candidates | Flag indicating the availability of additional information in the qso_candidates table | CHAR |
| 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 | REAL |
| ipd_gof_harmonic_phase | Phase of the IPD GoF versus position angle of scan Angle[deg] | REAL |
| l | Galactic longitude Angle[deg] | DOUBLE |
| libname_gspphot | Name of library that achieves the highest mean log-posterior in MCMC samples and was used to derive GSP-Phot parameters in this table | CHAR |
| logg_gspphot | Surface gravity from GSP-Phot Aeneas best library using BP/RP spectra | REAL |
| logg_gspphot_lower | Lower confidence level (16%) of surface gravity from GSP-Phot Aeneas best library using BP/RP spectra (GravitySurface[log cgs]) | REAL |
| logg_gspphot_upper | Upper confidence level (84%) of surface gravity from GSP-Phot Aeneas best library using BP/RP spectra (GravitySurface[log cgs]) | REAL |
| 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 |
| mh_gspphot | Iron abundance from GSP-Phot Aeneas best library using BP/RP spectra (Abundances[dex]) | REAL |
| mh_gspphot_lower | Lower confidence level (16%) of iron abundance from GSP-Phot Aeneas best library using BP/RP spectra (Abundances[dex]) | REAL |
| mh_gspphot_upper | Upper confidence level (84%) of iron abundance from GSP-Phot Aeneas best library using BP/RP spectra (Abundances[dex]) | REAL |
| 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 |
| non_single_star | Flag indicating the availability of additional information in the various Non-Single Star tables | SMALLINT |
| nu_eff_used_in_astrometry | Effective wavenumber of the source used in the astrometric solution Misc[um^-1] | REAL |
| parallax | Parallax Angle[mas] | DOUBLE |
| parallax_error | Standard error of Parallax Angle[mas] | REAL |
| parallax_over_error | Standard error of parallax Angle[mas] | REAL |
| parallax_pmdec_corr | Correlation between parallax and proper motion in declination [-1,+1] | REAL |
| parallax_pmra_corr | Correlation between parallax and proper motion in right ascension [-1,+1] | REAL |
| parallax_pseudocolour_corr | Correlation between parallax and pseudocolour [-1,+1] | REAL |
| 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] | REAL |
| phot_bp_mean_flux_over_error | Integrated BP mean flux divided by its error | REAL |
| phot_bp_mean_mag | Integrated BP mean magnitude Magnitude[mag] | REAL |
| 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 | REAL |
| 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] | REAL |
| phot_g_mean_flux_over_error | G-band mean flux divided by its error | REAL |
| phot_g_mean_mag | G-band mean magnitude Magnitude[mag] | REAL |
| 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] | REAL |
| phot_rp_mean_flux_over_error | Integrated RP mean flux divided by its error | REAL |
| phot_rp_mean_mag | Integrated RP mean magnitude Magnitude[mag] | REAL |
| 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 |
| phot_variable_flag | Photometric variability flag | CHAR |
| pm | Total proper motion Angular Velocity[mas/year] | REAL |
| 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] | REAL |
| pmdec_pseudocolour_corr | Correlation between proper motion in declination and pseudocolour [-1,+1] | REAL |
| 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] | REAL |
| pmra_pmdec_corr | Correlation between proper motion in right ascension and proper motion in declination [-1,+1] | REAL |
| pmra_pseudocolour_corr | Correlation between proper motion in right asension and pseudocolour [-1,+1] | REAL |
| pseudocolour | Astrometrically estimated pseudocolour of the source Misc[um^-1] | REAL |
| pseudocolour_error | Standard error of the pseudocolour of the source Misc[um^-1] | REAL |
| ra | Barycentric right ascension alpha of the source in ICRS at the reference epoch ref_epoch | DOUBLE |
| ra_dec_corr | Correlation between right ascension and declination [-1,+1] | REAL |
| radial_velocity | Radial velocity [km/s] | REAL |
| radial_velocity_error | Radial velocity error [km/s] | REAL |
| ra_error | Standard error of the right ascension of the source in ICRS at the reference epoch ref_epoch. | REAL |
| 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] | REAL |
| ra_pmdec_corr | Correlation between right ascension and proper motion in declination [-1,+1] | REAL |
| ra_pmra_corr | Correlation between right ascension and proper motion in right ascension [-1,+1] | REAL |
| ra_pseudocolour_corr | Correlation between right ascension and pseudocolour [-1,+1] | REAL |
| ref_epoch | Reference epoch Time[Julian Years] | DOUBLE |
| ring256 | HEALPIX index (Nsides 256, Ring scheme => ~14 arcmin size) | INTEGER |
| ruwe | Renormalised unit weight error | REAL |
| rv_amplitude_robust | Total amplitude in the radial velocity time series after outlier removal (Velocity[km/s]) | REAL |
| rv_atm_param_origin | Origin of the atmospheric parameters associated to the template | SMALLINT |
| rv_chisq_pvalue | P-value for constancy based on a chi-squared criterion | REAL |
| rv_expected_sig_to_noise | Expected signal to noise ratio in the combination of the spectra used to obtain the radial velocity | REAL |
| rv_method_used | Method used to obtain the radial velocity | SMALLINT |
| rv_nb_deblended_transits | Number of valid transits that have undergone deblending | SMALLINT |
| rv_nb_transits | Number of transits used to compute radial velocity | SMALLINT |
| rv_renormalised_gof | Radial velocity renormalised goodness of fit | REAL |
| rvs_spec_sig_to_noise | Signal to noise ratio in the mean RVS spectrum | REAL |
| rv_template_fe_h | Fe/H of the template used to compute radial velocity [dex] | REAL |
| rv_template_logg | logg of the template used to compute radial velocity (GravitySurface[log cgs]) | REAL |
| rv_template_teff | Teff of the template used to compute the radial velocity (Temperature[K]) | REAL |
| rv_time_duration | Time coverage of the radial velocity time series (Time[day]) | REAL |
| rv_visibility_periods_used | Number of visibility periods used to estimate the radial velocity | SMALLINT |
| 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. 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 |
| teff_gspphot | Effective temperature from GSP-Phot Aeneas best library using BP/RP spectra (Temperature[K]) | REAL |
| teff_gspphot_lower | Lower confidence level (16%) of effective temperature from GSP- Phot Aeneas best library using BP/RP spectra (Temperature[K]) | REAL |
| teff_gspphot_upper | Upper confidence level (84%) of effective temperature from GSP-Phot Aeneas best library using BP/RP spectra (Temperature[K]) | REAL |
| vbroad | Spectral line broadening parameter (Velocity[km/s] ) | REAL |
| vbroad_error | Uncertainty on the spectral line broadening (Velocity[km/s] ) | REAL |
| vbroad_nb_transits | Number of transits used to compute vbroad | SMALLINT |
| visibility_periods_used | Number of visibility periods used in Astrometric solution | SMALLINT |
