Choose a database in the left panel then select the table you want!
Table: hipparcos.main
(The bold columns are indexed columns)
| Column Name | Description | Datatype |
|---|---|---|
| astoref | Reference flag for astrometry: this flag indicates that the astrometric parameters in H3-4 and H8-30 refer to: A to Z: the letter indicates the component of a double or multiple system *: the photocentre of a double or multiple system +: the centre of mass | CHAR |
| b_v | Johnson B-V colour | REAL |
| bd | Bonner DM , | VARCHAR |
| btmag | Mean BT magnitude | REAL |
| catalog | [H] Catalogue (H=Hipparcos) | CHAR |
| ccdm | CCDM identifier; the flag takes the following values: H : determined multiple by Hipparcos, previously unknown I : system previously identified as multiple in HIC (annex1) M : miscellaneous (system identified after publication of HIC) | VARCHAR |
| chart | [DG] Identification Chart: the chart was produced: D : from the STScI Digitized Sky Survey G : from the Guide Star Catalog | CHAR |
| cod | Cordoba Durchmusterung (DM) | VARCHAR |
| combmag | Flag for combined Vmag, B-V, V-I | CHAR |
| cpd | Cape Photographic DM | VARCHAR |
| de_ra | Correlation, DE/RA*cos(delta) | REAL |
| dedeg | Declination in deg m s, ICRS (J1991.25): right ascension and declination are expressed in degrees for epoch J1991.25 (JD2448349.0625 (TT)) in the ICRS (International Celestial Reference System, consistent with J2000) reference system. There are 263 cases where these fields are missing (no astrometric solution could be found) | DOUBLE |
| dedms | Declination in deg m s, ICRS (J1991.25) | VARCHAR |
| dhp | Magnitude difference of components | REAL |
| e_b_v | Standard error on B-V | REAL |
| e_btmag | Standard error on BTmag | REAL |
| e_dedeg | Standard error in DE; The standard errors refer to the epoch J1991.25, and represent a minimum of the error on the position. The actual standard error on the positions is increasing for epochs increasingly differing from the nominal J1991.25 epoch. | REAL |
| e_dhp | Standard error on dHp | REAL |
| e_hpmag | Standard error on Hpmag | REAL |
| e_plx | Standard error in Plx | REAL |
| e_pmde | Standard error in pmDE | REAL |
| e_pmra | Standard error in pmRA | REAL |
| e_radeg | Standard error in RA*cos(DEdeg); The standard errors refer to the epoch J1991.25, and represent a minimum of the error on the position. The actual standard error on the positions is increasing for epochs increasingly differing from the nominal J1991.25 epoch. | REAL |
| e_rho | Standard error on rho | REAL |
| e_v_i | Standard error on V-I | REAL |
| e_vtmag | Standard error on VTmag | REAL |
| elat | Ecliptic Latitude | DOUBLE |
| elon | Ecliptic Longitude | DOUBLE |
| f1 | Percentage of rejected data | SMALLINT |
| f2 | Goodness-of-fit parameter:values exceeding +3 indicate a bad fit to the data | REAL |
| glat | Galactic Latitude | DOUBLE |
| glon | Galactic Longitude | DOUBLE |
| hd | [1/359083]? HD number | INTEGER |
| hip | Identifier (HIP number) | INTEGER |
| hip2 | HIP number (repetition) | INTEGER |
| hpmag | Median magnitude in Hipparcos system | REAL |
| hpmax | Hpmag at maximum (5th percentile) | REAL |
| hpmin | Hpmag at minimum (95th percentile) | REAL |
| hpscat | Scatter on Hpmag | REAL |
| htm9 | Ninth level (~10 arcmin resolution) Hierarchical Triangular Mesh index (Szalay et al. 2007) | INTEGER |
| hvartype | [CDMPRU]? variability type: Hipparcos-defined type of variability (a blank entry signifies that the entry could not be classified as variable or constant): C : no variability detected ("constant") D : duplicity-induced variability M : possibly micro-variable (amplitude < 0.03mag) P : periodic variable R : V-I colour index was revised due to variability analysis U : unsolved variable which does not fall in the other categories | CHAR |
| m_btmag | Reference flag for BT and VTmag: this flag indicates the component or combined photometry: A to Z : the letter indicates the component measured in Tycho (non-single star) * : the photometry refers to all components of the Hipparcos entry * - : single-pointing triple or quadruple system | CHAR |
| m_hip | Component identifiers | VARCHAR |
| m_hpmag | [A-Z*-] Reference flag for Hpmag: this flag indicates for double or multiple entries: A to Z : the letter indicates the specified component measured * : combined Hpmag of a double system, corrected for attenuation * - : combined Hpmag of a multiple system, not corrected for attenuation | CHAR |
| morephoto | [ABC] Light curve Annex | CHAR |
| morevar | [12] Additional data about variability; more data about periodic variability are provided | SMALLINT |
| multflag | [CGOVX] Double/Multiple Systems flag; indicates that further details are given in the Double and Multiple Systems Annex: C : solutions for the components G : acceleration or higher order terms O : orbital solutions V : variability-induced movers (apparent motion arises from variability) X : stochastic solution (probably astrometric binaries with short period) | CHAR |
| n_ccdm | [HIM] Historical status flag | CHAR |
| ncomp | Number of components in this entry | SMALLINT |
| nest4096 | Nested-scheme HEALPix (Gorski et al. 2005) index with NSIDE=4096 (~1 arcmin resolution) | INTEGER |
| notes | [DGPWXYZ] Existence of notes: the flag has the following meaning: D : double and multiple systems note only (note in hd_notes.doc file) G : general note only (note in hg_notes.doc file) P : photometric notes only (note in hp_notes.doc file) W : D + P X : D + G Y : G + P Z : D + G + P | CHAR |
| nsys | Number of entries with same CCDM | SMALLINT |
| o_hpmag | Number of observations for Hpmag | SMALLINT |
| period | Variability period (days) | REAL |
| plx | Trigonometric parallax | REAL |
| plx_de | Correlation, Plx/DE | REAL |
| plx_ra | Correlation, Plx/RA*cos(delta) | REAL |
| pmde | Proper motion mu_delta, ICRS epoch J1991.25 | DOUBLE |
| pmde_de | Correlation, pmDE/DE | REAL |
| pmde_plx | Correlation, pmDE/Plx | REAL |
| pmde_pmra | Correlation, pmDE/pmRA | REAL |
| pmde_ra | Correlation, pmDE/RA*cos(delta) | REAL |
| pmra | Proper motion mu_alpha.cos(delta), ICRS epoch J1991.25 | REAL |
| pmra_de | Correlation, pmRA/DE | REAL |
| pmra_plx | Correlation, pmRA/Plx | REAL |
| pmra_ra | Correlation, pmRA/RA*cos(delta) | REAL |
| proxy | [HT] Proximity flag this flag provides a coarse indication of the presence of nearby objects within 10arcsec of the given entry. If non-blank, it indicates that H there is one or more distinct Hipparcos Catalogue entries, or distinct components of system from h_dm_com.dat T there is one or more distinct Tycho entries If H and T apply, H is adopted. The T flag implies either an inconsistency between the Hipparcos and Tycho catalogues, or a deficiency in one or both of the catalogues. | CHAR |
| qual | [ABCDS] Solution quality: Reliability of the double or multiple star solution: A=good, B=fair, C=poor, D=uncertain, S=suspected non-single | CHAR |
| r_b_v | Source of B-V from [G]round or [T]ycho | CHAR |
| r_sptype | [1234GKSX] Source of spectral type: the flag indicates the source, as: 1 : Michigan catalogue for the HD stars, vol. 1 (Houk+, 1975) 2 : Michigan catalogue for the HD stars, vol. 2 (Houk, 1978) 3 : Michigan Catalogue for the HD stars, vol. 3 (Houk, 1982) 4 : Michigan Catalogue for the HD stars, vol. 4 (Houk+, 1988) G : updated after publication of the HIC K : General Catalog of Variable Stars, 4th Ed. (Kholopov+ 1988) S : SIMBAD data-base X : Miscellaneous A blank entry has no corresponding information. | REAL |
| r_v_i | Source of V-I; the origin of the V-I colour, in summary: A for an observation of V-I in Cousins system; B to K when V-I derived from measurements in other bands/photoelectric systems L to P when V-I derived from Hipparcos and Star Mapper photometry Q for long-period variables R to T when colours are unknown | CHAR |
| r_vmag | Source of magnitude (G = ground-based, H=HIP, T=Tycho) | CHAR |
| radeg | alpha, degrees (ICRS, Epoch=J1991.25):right ascension and declination are expressed in degrees for epoch J1991.25 (JD2448349.0625 (TT)) in the ICRS (International Celestial Reference System, consistent with J2000) reference system. There are 263 cases where these fields are missing (no astrometric solution could be found) | DOUBLE |
| rahms | Right ascension in h m s, ICRS (J1991.25) | VARCHAR |
| random_id | Random ID in the range 0.0 => 100.0 | REAL |
| rho | Angular separation between components | REAL |
| ring256 | Ring-scheme HEALPix (Gorski et al. 2005) index with NSIDE=256 (~14 arcmin resolution) | INTEGER |
| source | [PFILS] Astrometric source flag : qualifies the source of the astrometric parameters H8-30 with a C in MultFlag: P : primary target of a 2- or 3-pointing system F : secondary or tertiary of a 2- or 3-pointing fixed system (common parallax and proper motions) I : secondary or tertiary of a 2- or 3-pointing independent system (no constraints on parallax or proper motions) L : secondary or tertiary of a 2- or 3-pointing linear system (common parallax) S : astrometric parameters from single-star merging process. | CHAR |
| sptype | Spectral type | REAL |
| survey | [S] Flag indicating a Survey Star | CHAR |
| theta | Position angle between components | SMALLINT |
| v_i | Colour index in Cousins system | REAL |
| v_i_red | V-I used for reductions | REAL |
| varflag | Coarse variability flag (1: < 0.06mag ; 2: 0.06-0.6mag ; 3: >0.6mag) | SMALLINT |
| vmag | Magnitude in Johnson V | REAL |
| vtmag | Mean VT magnitude | REAL |
