Choose a database in the left panel then select the table you want!
Table: gaia_dr2.gaia_source
(The bold columns are indexed columns)
| Column Name | Description | Datatype |
|---|---|---|
| a_g_percentile_lower | aGVal lower uncertainty | REAL |
| a_g_percentile_upper | aGVal upper uncertainty | REAL |
| a_g_val | line-of-sight extinction in the G band, A_G) | REAL |
| astrometric_chi2_al | AL chi-square value | DOUBLE |
| astrometric_excess_noise | Excess noise of the source | DOUBLE |
| astrometric_excess_noise_sig | Significance of excess noise | DOUBLE |
| astrometric_gof_al | Goodness of fit statistic of model wrt along-scan observations | DOUBLE |
| astrometric_matched_observations | 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? | SMALLINT |
| astrometric_primary_flag | Primary or seconday | SMALLINT |
| astrometric_pseudo_colour | Astrometrically determined pseudocolour of the source | DOUBLE |
| astrometric_pseudo_colour_error | Standard error of the pseudocolour of the source | DOUBLE |
| astrometric_sigma5d_max | The longest semi-major axis of the 5-d error ellipsoid | DOUBLE |
| astrometric_weight_al | Mean astrometric weight of the source | DOUBLE |
| b | Galactic latitude | DOUBLE |
| bp_g | BP - G colour | DOUBLE |
| bp_rp | BP - RP colour | 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 |
| designation | Unique source designation (unique across all Data Releases) | CHAR |
| duplicated_source | Source with duplicate sources | SMALLINT |
| e_bp_min_rp_percentile_lower | eBPminRPVal lower uncertainty | REAL |
| e_bp_min_rp_percentile_upper | eBPminRPVal upper uncertainty | REAL |
| e_bp_min_rp_val | line-of-sight reddening E(BP-RP) | REAL |
| ecl_lat | Ecliptic latitude | DOUBLE |
| ecl_lon | Ecliptic longitude | DOUBLE |
| flame_flags | Flags for the Apsis-FLAME results | INTEGER |
| frame_rotator_object_type | The type of the source mainly used for frame rotation | SMALLINT |
| g_rp | G - RP colour | DOUBLE |
| htm9 | Ninth level (~10 arcmin resolution) Hierarchical Triangular Mesh index (Szalay et al. 2007) | INTEGER |
| l | Galactic longitude | DOUBLE |
| lum_percentile_lower | lumVal lower uncertainty | DOUBLE |
| lum_percentile_upper | lumVal upper uncertainty | DOUBLE |
| lum_val | stellar luminosity | DOUBLE |
| matched_observations | Amount of observations matched to this source | SMALLINT |
| mean_varpi_factor_al | Mean Parallax factor AL | DOUBLE |
| nest4096 | Nested-scheme HEALPix (Gorski et al. 2005) index with NSIDE=4096 (~1 arcmin resolution) | INTEGER |
| parallax | Parallax | DOUBLE |
| parallax_error | Standard error of parallax | DOUBLE |
| parallax_over_error | Parallax divided by its error | 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_bp_mean_flux | Integrated BP mean flux | DOUBLE |
| phot_bp_mean_flux_error | Error on the integrated BP mean flux | DOUBLE |
| phot_bp_mean_flux_over_error | Integrated BP mean flux divided by its error | DOUBLE |
| phot_bp_mean_mag | Integrated BP mean magnitude | DOUBLE |
| 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 | DOUBLE |
| phot_g_mean_flux_error | Error on G-band mean flux | DOUBLE |
| phot_g_mean_flux_over_error | G-band mean flux divided by its error | DOUBLE |
| phot_g_mean_mag | G-band mean magnitude | 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 | DOUBLE |
| phot_rp_mean_flux_error | Error on the integrated RP mean flux | DOUBLE |
| phot_rp_mean_flux_over_error | Integrated RP mean flux divided by its error | DOUBLE |
| phot_rp_mean_mag | Integrated RP mean magnitude | DOUBLE |
| phot_rp_n_obs | Number of observations contributing to RP 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 |
| priam_flags | flags for the Apsis-Priam results | INTEGER |
| 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 |
| radial_velocity | Radial velocity | DOUBLE |
| radial_velocity_error | Radial velocity error | DOUBLE |
| radius_percentile_lower | radiusVal lower uncertainty | DOUBLE |
| radius_percentile_upper | radiusVal upper uncertainty | DOUBLE |
| radius_val | stellar radius | DOUBLE |
| random_id | Unique random number between 0 and 100 | REAL |
| 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 |
| rv_nb_transits | Number of transits used to compute radial velocity | SMALLINT |
| rv_template_fe_h | Fe/H of the template used to compute radial velocity | REAL |
| rv_template_logg | logg of the template used to compute radial velocity | REAL |
| rv_template_teff | Teff of the template used to compute radial velocity | REAL |
| solution_id | Solution Identifier | BIGINT |
| source_id | Unique source identifier (unique within a particular Data Release) | BIGINT |
| teff_percentile_lower | teffVal lower uncertainty | DOUBLE |
| teff_percentile_upper | teffVal upper uncertainty | DOUBLE |
| teff_val | stellar effective temperature | DOUBLE |
| visibility_periods_used | Number of visibility periods used in Astrometric solution | SMALLINT |
