Choose a database in the left panel then select the table you want!

Table: gaia_dr1.gaia_source
(The bold columns are indexed columns)
Column NameDescriptionDatatype
astrometric_delta_qHipparcos/Gaia proper motion difference (Hipparcos subset of TGAS only)REAL
astrometric_excess_noiseExcess noise of the sourceDOUBLE
astrometric_excess_noise_sigSignificance of excess noiseDOUBLE
astrometric_n_bad_obs_acNumber of bad observations ACINTEGER
astrometric_n_bad_obs_alNumber of bad observations ALINTEGER
astrometric_n_good_obs_acNumber of good observations ACINTEGER
astrometric_n_good_obs_alNumber of good observations ALINTEGER
astrometric_n_obs_acTotal number of observations ACINTEGER
astrometric_n_obs_alTotal number of observations ALINTEGER
astrometric_primary_flagFlag indicating if this source was used as a primary source (true) or secondary source (false). Only primary sources contribute to the estimation of attitude, calibration, and global parameters. The estimation of source parameters is otherwise done in exactly the same way for primary and secondary sources.SMALLINT
astrometric_priors_usedType of prior used in the astrometric solutionINTEGER
astrometric_relegation_factorRelegation factor of the source calculated used for the primary selection processREAL
astrometric_weight_acMean astrometric weight of the source in the AC directionREAL
astrometric_weight_alMean astrometric weight of the source in the AL directionREAL
bGalactic Latitude of the object at reference epoch ref_epoch, see ESA, 1997, The Hipparcos and Tycho Catalogues, ESA SP-1200, Volume 1, Section 1.5.3, for the conversion details.DOUBLE
decDeclination (ICRS)DOUBLE
dec_errorStandard error of declinationDOUBLE
dec_parallax_corrCorrelation between declination and parallaxREAL
dec_pmdec_corrCorrelation between declination and proper motion in declinationREAL
dec_pmra_corrCorrelation between declination and proper motion in right ascensionREAL
duplicated_sourceSource with duplicate sourcesSMALLINT
ecl_latEcliptic Latitude of the object at reference epoch ref_epoch, see ESA, 1997, The Hipparcos and Tycho Catalogues, ESA SP-1200, Volume 1, Section 1.5.3, for the conversion details.DOUBLE
ecl_lonEcliptic Longitude of the object at reference epoch ref_epoch, see ESA, 1997, The Hipparcos and Tycho Catalogues, ESA SP-1200, Volume 1, Section 1.5.3, for the conversion details.DOUBLE
htm9HTM index (order 9 => ~10 arcmin size)BIGINT
lGalactic Longitude of the object at reference epoch ref_epoch, see ESA, 1997, The Hipparcos and Tycho Catalogues, ESA SP-1200, Volume 1, Section 1.5.3, for the conversion details.DOUBLE
matched_observationsAmount of observations matched to this sourceSMALLINT
nest256HEALPIX index (Nsides 256, Nest scheme => ~14 arcmin sizeINTEGER
parallaxParallaxDOUBLE
parallax_errorStandard error of parallaxDOUBLE
parallax_pmdec_corrCorrelation between parallax and proper motion in declinationREAL
parallax_pmra_corrCorrelation between parallax and proper motion in right ascensionREAL
phot_g_mean_fluxG-band mean fluxDOUBLE
phot_g_mean_flux_errorError on G-band mean fluxDOUBLE
phot_g_mean_magG-band mean magnitudeDOUBLE
phot_g_n_obsNumber of observations contributing to G photometryINTEGER
phot_variable_flagFlag indicating if variability was identified in the photometric G bandCHAR
pmdecProper motion in declination directionDOUBLE
pmdec_errorStandard error of proper motion in declination directionDOUBLE
pmraProper motion in right ascension directionDOUBLE
pmra_errorStandard error of proper motion in right ascension directionDOUBLE
pmra_pmdec_corrCorrelation between proper motion in right ascension and proper motion in declinationREAL
raRight Ascension (ICRS)DOUBLE
ra_dec_corrCorrelation between right ascension and declinationREAL
ra_errorStandard error of right ascensionDOUBLE
ra_parallax_corrCorrelation between right ascension and parallaxREAL
ra_pmdec_corrCorrelation between right ascension and proper motion in declinationREAL
ra_pmra_corrCorrelation between right ascension and proper motion in right ascensionREAL
random_indexRandom index used to select subsetsBIGINT
ref_epochReference epochDOUBLE
ring256HEALPIX index (Nsides 256, Ring scheme => ~14 arcmin size)INTEGER
scan_direction_mean_k1Mean position angle of scan directions across the sourceREAL
scan_direction_mean_k2Mean position angle of scan directions across the sourceREAL
scan_direction_mean_k3Mean position angle of scan directions across the sourceREAL
scan_direction_mean_k4Mean position angle of scan directions across the sourceREAL
scan_direction_strength_k1Degree of concentration of scan directions across the sourceREAL
scan_direction_strength_k2Degree of concentration of scan directions across the sourceREAL
scan_direction_strength_k3Degree of concentration of scan directions across the sourceREAL
scan_direction_strength_k4Degree of concentration of scan directions across the sourceREAL
solution_idAll Gaia data processed by the Data Processing and Analysis Consortium comes tagged with a solution identifier. This is a numeric field attached to each table row that can be used to unequivocally identify the version of all the subsystems that where used in the generation of the data as well as the input data used. It is mainly for internal DPAC use but is included in the published data releases to enable end users to examine the provenance of processed data products. To decode a given solution ID visitBIGINT
source_idA unique single numerical identifier o f the source obtained from GaiaSource (for a detailed description see GaiaSource.sourceId)BIGINT