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 Name | Description | Datatype |
|---|---|---|
| astrometric_delta_q | Hipparcos/Gaia proper motion difference (Hipparcos subset of TGAS only) | REAL |
| astrometric_excess_noise | Excess noise of the source | DOUBLE |
| astrometric_excess_noise_sig | Significance of excess noise | DOUBLE |
| astrometric_n_bad_obs_ac | Number of bad observations AC | INTEGER |
| astrometric_n_bad_obs_al | Number of bad observations AL | INTEGER |
| astrometric_n_good_obs_ac | Number of good observations AC | INTEGER |
| astrometric_n_good_obs_al | Number of good observations AL | INTEGER |
| astrometric_n_obs_ac | Total number of observations AC | INTEGER |
| astrometric_n_obs_al | Total number of observations AL | INTEGER |
| astrometric_primary_flag | Flag 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_used | Type of prior used in the astrometric solution | INTEGER |
| astrometric_relegation_factor | Relegation factor of the source calculated used for the primary selection process | REAL |
| astrometric_weight_ac | Mean astrometric weight of the source in the AC direction | REAL |
| astrometric_weight_al | Mean astrometric weight of the source in the AL direction | REAL |
| b | Galactic 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 |
| dec | Declination (ICRS) | DOUBLE |
| dec_error | Standard error of declination | DOUBLE |
| dec_parallax_corr | Correlation between declination and parallax | REAL |
| dec_pmdec_corr | Correlation between declination and proper motion in declination | REAL |
| dec_pmra_corr | Correlation between declination and proper motion in right ascension | REAL |
| duplicated_source | Source with duplicate sources | SMALLINT |
| ecl_lat | Ecliptic 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_lon | Ecliptic 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 |
| htm9 | HTM index (order 9 => ~10 arcmin size) | BIGINT |
| l | Galactic 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_observations | Amount of observations matched to this source | SMALLINT |
| nest256 | HEALPIX index (Nsides 256, Nest scheme => ~14 arcmin size | INTEGER |
| parallax | Parallax | DOUBLE |
| parallax_error | Standard error of parallax | DOUBLE |
| parallax_pmdec_corr | Correlation between parallax and proper motion in declination | REAL |
| parallax_pmra_corr | Correlation between parallax and proper motion in right ascension | REAL |
| phot_g_mean_flux | G-band mean flux | DOUBLE |
| phot_g_mean_flux_error | Error on G-band mean flux | DOUBLE |
| phot_g_mean_mag | G-band mean magnitude | DOUBLE |
| phot_g_n_obs | Number of observations contributing to G photometry | INTEGER |
| phot_variable_flag | Flag indicating if variability was identified in the photometric G band | 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 | REAL |
| ra | Right Ascension (ICRS) | DOUBLE |
| ra_dec_corr | Correlation between right ascension and declination | REAL |
| ra_error | Standard error of right ascension | DOUBLE |
| ra_parallax_corr | Correlation between right ascension and parallax | REAL |
| ra_pmdec_corr | Correlation between right ascension and proper motion in declination | REAL |
| ra_pmra_corr | Correlation between right ascension and proper motion in right ascension | REAL |
| random_index | Random index used to select subsets | BIGINT |
| ref_epoch | Reference epoch | DOUBLE |
| ring256 | HEALPIX index (Nsides 256, Ring scheme => ~14 arcmin size) | INTEGER |
| 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 | All 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 visit | BIGINT |
| source_id | A unique single numerical identifier o f the source obtained from GaiaSource (for a detailed description see GaiaSource.sourceId) | BIGINT |
