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

Table: gaia_dr1.tgas_source
(The bold columns are indexed columns)
Column NameDescriptionDatatype
astrometric_delta_qHipparcos/Gaia data discrepancy (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_flagPrimary or secondardSMALLINT
astrometric_priors_usedType of prior used in the astrometric solutionINTEGER
astrometric_relegation_factorRelegation factorREAL
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 at epoch 2015.0DOUBLE
decDeclination (ICRS) at epoch 2015.0 (deg)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 at epoch 2015.0DOUBLE
ecl_lonEcliptic longitude at epoch 2015.0DOUBLE
hipHipparcos identifierINTEGER
lGalactic longitude at epoch 2015.0DOUBLE
matched_observationsAmount of observations matched to this sourceSMALLINT
parallaxAbsolute barycentric stellar parallax of the source at the reference epoch EpochDOUBLE
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_flagPhotometric variability flagCHAR
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) at epoch 2015.0 (deg)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 ascention and proper motion in declinationREAL
ra_pmra_corrCorrelation between right ascention and proper motion in right ascensionREAL
random_indexRandom index used to select subsetsBIGINT
ref_epoch[2015.0] Reference epoch in Julian yearsDOUBLE
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
tycho2_idTycho 2 identifierCHAR