NASA exoplanet stellar hosts

Source

exoplanetarchive.ipac.caltech.edu

Quality score: 100/100.

Initial recorded revision.

Dataset refresh metadata

Current Source Files

• sync.txt 20260926192308-865b30520f3d Provider source

Contract Versions

• 20260926192308-865b30520f3d Copy YAML link

Current Open Data Contract YAML

Open raw YAML

dataset_id: nasa-stellarhosts
title: NASA exoplanet stellar hosts
description: NASA exoplanet stellar hosts discovered from exoplanetarchive.ipac.caltech.edu.
source_name: exoplanetarchive.ipac.caltech.edu
source_url: https://exoplanetarchive.ipac.caltech.edu/TAP/sync?query=select+%2A+from+stellarhosts&format=csv
update_frequency: weekly
next_scan_at: '2026-09-27T19:23:26.691575+00:00'
license:
  name: Public scientific data; archive and literature citation requested
  url: https://exoplanetarchive.ipac.caltech.edu/docs/acknowledge.html
tags:
- exoplanetarchive.ipac.caltech.edu
- astronomy
geography:
- Space
revisions:
- revision_id: 20260926192308-865b30520f3d
  detected_at: '2026-09-26T19:23:08+00:00'
  source_updated_at: null
  context: sync.txt detected from sync.
  assets:
  - asset_id: asset-792d6225a12775c0
    name: sync.txt
    source_url: https://exoplanetarchive.ipac.caltech.edu/TAP/sync?query=select+%2A+from+stellarhosts&format=csv
    media_type: text/plain
    content_hash: 792d6225a12775c0e5511ab18e8a2da98b4dea9925b3f756895bce4794493028
    size_bytes: 53395537
    parent_archive_id: null
  row_count: 47925
  headers:
  - hostname
  - hd_name
  - hip_name
  - tic_id
  - st_refname
  - sy_refname
  - ra
  - rastr
  - dec
  - decstr
  - glon
  - glat
  - elon
  - elat
  - sy_icmag
  - sy_icmagerr1
  - sy_icmagerr2
  - st_teff
  - st_tefferr1
  - st_tefferr2
  - st_tefflim
  - st_met
  - st_meterr1
  - st_meterr2
  - st_metlim
  - st_radv
  - st_radverr1
  - st_radverr2
  - st_radvlim
  - st_vsin
  - st_vsinerr1
  - st_vsinerr2
  - st_vsinlim
  - st_lum
  - st_lumerr1
  - st_lumerr2
  - st_lumlim
  - st_logg
  - st_loggerr1
  - st_loggerr2
  - st_logglim
  - st_age
  - st_ageerr1
  - st_ageerr2
  - st_agelim
  - st_mass
  - st_masserr1
  - st_masserr2
  - st_masslim
  - st_dens
  - st_denserr1
  - st_denserr2
  - st_denslim
  - st_rad
  - st_raderr1
  - st_raderr2
  - st_radlim
  - sy_snum
  - sy_pnum
  - sy_mnum
  - sy_pm
  - sy_pmerr1
  - sy_pmerr2
  - sy_pmra
  - sy_pmraerr1
  - sy_pmraerr2
  - sy_pmdec
  - sy_pmdecerr1
  - sy_pmdecerr2
  - sy_plx
  - sy_plxerr1
  - sy_plxerr2
  - sy_dist
  - sy_disterr1
  - sy_disterr2
  - sy_bmag
  - sy_bmagerr1
  - sy_bmagerr2
  - sy_vmag
  - sy_vmagerr1
  - sy_vmagerr2
  - sy_jmag
  - sy_jmagerr1
  - sy_jmagerr2
  - sy_hmag
  - sy_hmagerr1
  - sy_hmagerr2
  - sy_kmag
  - sy_kmagerr1
  - sy_kmagerr2
  - sy_umag
  - sy_umagerr1
  - sy_umagerr2
  - sy_rmag
  - sy_rmagerr1
  - sy_rmagerr2
  - sy_imag
  - sy_imagerr1
  - sy_imagerr2
  - sy_zmag
  - sy_zmagerr1
  - sy_zmagerr2
  - sy_w1mag
  - sy_w1magerr1
  - sy_w1magerr2
  - sy_w2mag
  - sy_w2magerr1
  - sy_w2magerr2
  - sy_w3mag
  - sy_w3magerr1
  - sy_w3magerr2
  - sy_w4mag
  - sy_w4magerr1
  - sy_w4magerr2
  - sy_gmag
  - sy_gmagerr1
  - sy_gmagerr2
  - sy_gaiamag
  - sy_gaiamagerr1
  - sy_gaiamagerr2
  - sy_tmag
  - sy_tmagerr1
  - sy_tmagerr2
  - sy_name
  - st_metratio
  - st_spectype
  - sy_kepmag
  - sy_kepmagerr1
  - sy_kepmagerr2
  - st_rotp
  - st_rotperr1
  - st_rotperr2
  - st_rotplim
  - gaia_dr2_id
  - gaia_dr3_id
  - cb_flag
  sample_rows:
  - hostname: Kepler-307
    hd_name: ''
    hip_name: ''
    tic_id: TIC 169930145
    st_refname: <a refstr=HADDEN__AMP__LITHWICK_2016 href=https://ui.adsabs.harvard.edu/abs/2016ApJ...828...44H/abstract
      target=ref>Hadden &amp; Lithwick 2016</a>
    sy_refname: <a refstr=STASSUN_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019AJ....158..138S/abstract
      target=ref>TICv8</a>
    ra: '297.7950939'
    rastr: 19h51m10.82s
    dec: '40.4176403'
    decstr: +40d25m03.51s
    glon: '75.10988'
    glat: '6.95002'
    elon: '314.59552'
    elat: '59.62731'
    sy_icmag: ''
    sy_icmagerr1: ''
    sy_icmagerr2: ''
    st_teff: ''
    st_tefferr1: ''
    st_tefferr2: ''
    st_tefflim: ''
    st_met: ''
    st_meterr1: ''
    st_meterr2: ''
    st_metlim: ''
    st_radv: ''
    st_radverr1: ''
    st_radverr2: ''
    st_radvlim: ''
    st_vsin: ''
    st_vsinerr1: ''
    st_vsinerr2: ''
    st_vsinlim: ''
    st_lum: ''
    st_lumerr1: ''
    st_lumerr2: ''
    st_lumlim: ''
    st_logg: ''
    st_loggerr1: ''
    st_loggerr2: ''
    st_logglim: ''
    st_age: ''
    st_ageerr1: ''
    st_ageerr2: ''
    st_agelim: ''
    st_mass: '0.950000'
    st_masserr1: '0.060000'
    st_masserr2: '-0.050000'
    st_masslim: '0'
    st_dens: ''
    st_denserr1: ''
    st_denserr2: ''
    st_denslim: ''
    st_rad: '0.990000'
    st_raderr1: '0.130000'
    st_raderr2: '-0.080000'
    st_radlim: '0'
    sy_snum: '1'
    sy_pnum: '2'
    sy_mnum: '0'
    sy_pm: '10.7848189'
    sy_pmerr1: '0.0316908'
    sy_pmerr2: '-0.0316908'
    sy_pmra: '-1.9476300'
    sy_pmraerr1: '0.0281334'
    sy_pmraerr2: '-0.0281334'
    sy_pmdec: '-10.6075000'
    sy_pmdecerr1: '0.0318038'
    sy_pmdecerr2: '-0.0318038'
    sy_plx: '1.7086200'
    sy_plxerr1: '0.0156192'
    sy_plxerr2: '-0.0156192'
    sy_dist: '575.58100000'
    sy_disterr1: '5.26100000'
    sy_disterr2: '-5.16700000'
    sy_bmag: '15.7520000'
    sy_bmagerr1: '0.0680000'
    sy_bmagerr2: '-0.0680000'
    sy_vmag: '14.1490000'
    sy_vmagerr1: '0.1030000'
    sy_vmagerr2: '-0.1030000'
    sy_jmag: '12.8330000'
    sy_jmagerr1: '0.0270000'
    sy_jmagerr2: '-0.0270000'
    sy_hmag: '12.4520000'
    sy_hmagerr1: '0.0280000'
    sy_hmagerr2: '-0.0280000'
    sy_kmag: '12.3210000'
    sy_kmagerr1: '0.0200000'
    sy_kmagerr2: '-0.0200000'
    sy_umag: ''
    sy_umagerr1: ''
    sy_umagerr2: ''
    sy_rmag: ''
    sy_rmagerr1: ''
    sy_rmagerr2: ''
    sy_imag: ''
    sy_imagerr1: ''
    sy_imagerr2: ''
    sy_zmag: ''
    sy_zmagerr1: ''
    sy_zmagerr2: ''
    sy_w1mag: '12.2940000'
    sy_w1magerr1: '0.0230000'
    sy_w1magerr2: '-0.0230000'
    sy_w2mag: '12.3560000'
    sy_w2magerr1: '0.0230000'
    sy_w2magerr2: '-0.0230000'
    sy_w3mag: '12.3100000'
    sy_w3magerr1: ''
    sy_w3magerr2: ''
    sy_w4mag: '9.4790000'
    sy_w4magerr1: ''
    sy_w4magerr2: ''
    sy_gmag: ''
    sy_gmagerr1: ''
    sy_gmagerr2: ''
    sy_gaiamag: '14.0561000'
    sy_gaiamagerr1: '0.0002560'
    sy_gaiamagerr2: '-0.0002560'
    sy_tmag: '13.5238000'
    sy_tmagerr1: '0.0108000'
    sy_tmagerr2: '-0.0108000'
    sy_name: Kepler-307
    st_metratio: ''
    st_spectype: ''
    sy_kepmag: '14.072'
    sy_kepmagerr1: ''
    sy_kepmagerr2: ''
    st_rotp: ''
    st_rotperr1: ''
    st_rotperr2: ''
    st_rotplim: ''
    gaia_dr2_id: Gaia DR2 2073691303802278784
    gaia_dr3_id: Gaia DR3 2073691303802278784
    cb_flag: '0'
  - hostname: Kepler-1421
    hd_name: ''
    hip_name: ''
    tic_id: TIC 399826842
    st_refname: <a refstr=GAIA_COLLABORATION_ET_AL__2018 href=https://ui.adsabs.harvard.edu/abs/2018A&A...616A...1G/abstract
      target=ref>Gaia DR2</a>
    sy_refname: <a refstr=STASSUN_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019AJ....158..138S/abstract
      target=ref>TICv8</a>
    ra: '286.5806115'
    rastr: 19h06m19.35s
    dec: '48.5442312'
    decstr: +48d32m39.23s
    glon: '79.03594'
    glat: '17.66824'
    elon: '303.62569'
    elat: '70.05449'
    sy_icmag: ''
    sy_icmagerr1: ''
    sy_icmagerr2: ''
    st_teff: '6314.33'
    st_tefferr1: '28.67'
    st_tefferr2: '-127.33'
    st_tefflim: '0'
    st_met: ''
    st_meterr1: ''
    st_meterr2: ''
    st_metlim: ''
    st_radv: ''
    st_radverr1: ''
    st_radverr2: ''
    st_radvlim: ''
    st_vsin: ''
    st_vsinerr1: ''
    st_vsinerr2: ''
    st_vsinlim: ''
    st_lum: '0.58089'
    st_lumerr1: '0.01337'
    st_lumerr2: '-0.01379'
    st_lumlim: '0'
    st_logg: ''
    st_loggerr1: ''
    st_loggerr2: ''
    st_logglim: ''
    st_age: ''
    st_ageerr1: ''
    st_ageerr2: ''
    st_agelim: ''
    st_mass: ''
    st_masserr1: ''
    st_masserr2: ''
    st_masslim: ''
    st_dens: ''
    st_denserr1: ''
    st_denserr2: ''
    st_denslim: ''
    st_rad: '1.630949'
    st_raderr1: '0.067823'
    st_raderr2: '-0.014709'
    st_radlim: '0'
    sy_snum: '1'
    sy_pnum: '1'
    sy_mnum: '0'
    sy_pm: '11.9969827'
    sy_pmerr1: '0.0391772'
    sy_pmerr2: '-0.0391772'
    sy_pmra: '0.1886120'
    sy_pmraerr1: '0.0413830'
    sy_pmraerr2: '-0.0413830'
    sy_pmdec: '11.9955000'
    sy_pmdecerr1: '0.0391766'
    sy_pmdecerr2: '-0.0391766'
    sy_plx: '1.2478500'
    sy_plxerr1: '0.0212216'
    sy_plxerr2: '-0.0212216'
    sy_dist: '783.40100000'
    sy_disterr1: '13.34100000'
    sy_disterr2: '-12.91000000'
    sy_bmag: '13.9060000'
    sy_bmagerr1: '0.0660000'
    sy_bmagerr2: '-0.0660000'
    sy_vmag: '12.8680000'
    sy_vmagerr1: '0.0920000'
    sy_vmagerr2: '-0.0920000'
    sy_jmag: '11.8390000'
    sy_jmagerr1: '0.0210000'
    sy_jmagerr2: '-0.0210000'
    sy_hmag: '11.6030000'
    sy_hmagerr1: '0.0280000'
    sy_hmagerr2: '-0.0280000'
    sy_kmag: '11.5540000'
    sy_kmagerr1: '0.0220000'
    sy_kmagerr2: '-0.0220000'
    sy_umag: ''
    sy_umagerr1: ''
    sy_umagerr2: ''
    sy_rmag: ''
    sy_rmagerr1: ''
    sy_rmagerr2: ''
    sy_imag: ''
    sy_imagerr1: ''
    sy_imagerr2: ''
    sy_zmag: ''
    sy_zmagerr1: ''
    sy_zmagerr2: ''
    sy_w1mag: '11.5180000'
    sy_w1magerr1: '0.0230000'
    sy_w1magerr2: '-0.0230000'
    sy_w2mag: '11.5490000'
    sy_w2magerr1: '0.0210000'
    sy_w2magerr2: '-0.0210000'
    sy_w3mag: '11.5280000'
    sy_w3magerr1: '0.1230000'
    sy_w3magerr2: '-0.1230000'
    sy_w4mag: '9.0700000'
    sy_w4magerr1: ''
    sy_w4magerr2: ''
    sy_gmag: ''
    sy_gmagerr1: ''
    sy_gmagerr2: ''
    sy_gaiamag: '12.7261000'
    sy_gaiamagerr1: '0.0002250'
    sy_gaiamagerr2: '-0.0002250'
    sy_tmag: '12.3584000'
    sy_tmagerr1: '0.0079000'
    sy_tmagerr2: '-0.0079000'
    sy_name: Kepler-1421
    st_metratio: ''
    st_spectype: ''
    sy_kepmag: '12.788'
    sy_kepmagerr1: ''
    sy_kepmagerr2: ''
    st_rotp: ''
    st_rotperr1: ''
    st_rotperr2: ''
    st_rotplim: ''
    gaia_dr2_id: Gaia DR2 2131173187575866496
    gaia_dr3_id: Gaia DR3 2131173187575866496
    cb_flag: '0'
  - hostname: HATS-68
    hd_name: ''
    hip_name: ''
    tic_id: TIC 322307342
    st_refname: <a refstr=HARTMAN_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019AJ....157...55H/abstract
      target=ref>Hartman et al. 2019</a>
    sy_refname: <a refstr=STASSUN_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019AJ....158..138S/abstract
      target=ref>TICv8</a>
    ra: '15.0060770'
    rastr: 01h00m01.46s
    dec: '-58.9047242'
    decstr: -58d54m17.01s
    glon: '300.82877'
    glat: '-58.18845'
    elon: '336.39718'
    elat: '-57.01793'
    sy_icmag: ''
    sy_icmagerr1: ''
    sy_icmagerr2: ''
    st_teff: '6147.00'
    st_tefferr1: '22.00'
    st_tefferr2: '-22.00'
    st_tefflim: '0'
    st_met: '0.2100'
    st_meterr1: '0.0430'
    st_meterr2: '-0.0430'
    st_metlim: '0'
    st_radv: '11.89460'
    st_radverr1: '0.00590'
    st_radverr2: '-0.00590'
    st_radvlim: '0'
    st_vsin: '7.4200'
    st_vsinerr1: '0.2900'
    st_vsinerr2: '-0.2900'
    st_vsinlim: '0'
    st_lum: '0.59218'
    st_lumerr1: '0.01420'
    st_lumerr2: '-0.01468'
    st_lumlim: '0'
    st_logg: '4.083000'
    st_loggerr1: '0.012000'
    st_loggerr2: '-0.012000'
    st_logglim: '0'
    st_age: '3.0200'
    st_ageerr1: '0.1100'
    st_ageerr2: '-0.1100'
    st_agelim: '0'
    st_mass: '1.351000'
    st_masserr1: '0.014000'
    st_masserr2: '-0.014000'
    st_masslim: '0'
    st_dens: '0.356000'
    st_denserr1: '0.015000'
    st_denserr2: '-0.015000'
    st_denslim: '0'
    st_rad: '1.748000'
    st_raderr1: '0.026000'
    st_raderr2: '-0.026000'
    st_radlim: '0'
    sy_snum: '1'
    sy_pnum: '1'
    sy_mnum: '0'
    sy_pm: '23.7676199'
    sy_pmerr1: '0.0478357'
    sy_pmerr2: '-0.0478357'
    sy_pmra: '22.5217000'
    sy_pmraerr1: '0.0485185'
    sy_pmraerr2: '-0.0485185'
    sy_pmdec: '7.5942600'
    sy_pmdecerr1: '0.0413473'
    sy_pmdecerr2: '-0.0413473'
    sy_plx: '1.6271200'
    sy_plxerr1: '0.0277561'
    sy_plxerr2: '-0.0277561'
    sy_dist: '603.95500000'
    sy_disterr1: '10.37100000'
    sy_disterr2: '-10.03400000'
    sy_bmag: '12.8120000'
    sy_bmagerr1: '0.0220000'
    sy_bmagerr2: '-0.0220000'
    sy_vmag: '12.3120000'
    sy_vmagerr1: '0.0460000'
    sy_vmagerr2: '-0.0460000'
    sy_jmag: '11.2500000'
    sy_jmagerr1: '0.0260000'
    sy_jmagerr2: '-0.0260000'
    sy_hmag: '10.9850000'
    sy_hmagerr1: '0.0240000'
    sy_hmagerr2: '-0.0240000'
    sy_kmag: '10.9490000'
    sy_kmagerr1: '0.0190000'
    sy_kmagerr2: '-0.0190000'
    sy_umag: ''
    sy_umagerr1: ''
    sy_umagerr2: ''
    sy_rmag: ''
    sy_rmagerr1: ''
    sy_rmagerr2: ''
    sy_imag: ''
    sy_imagerr1: ''
    sy_imagerr2: ''
    sy_zmag: ''
    sy_zmagerr1: ''
    sy_zmagerr2: ''
    sy_w1mag: '10.9120000'
    sy_w1magerr1: '0.0220000'
    sy_w1magerr2: '-0.0220000'
    sy_w2mag: '10.9430000'
    sy_w2magerr1: '0.0210000'
    sy_w2magerr2: '-0.0210000'
    sy_w3mag: '11.0030000'
    sy_w3magerr1: '0.1000000'
    sy_w3magerr2: '-0.1000000'
    sy_w4mag: '9.0040000'
    sy_w4magerr1: ''
    sy_w4magerr2: ''
    sy_gmag: ''
    sy_gmagerr1: ''
    sy_gmagerr2: ''
    sy_gaiamag: '12.1631000'
    sy_gaiamagerr1: '0.0001860'
    sy_gaiamagerr2: '-0.0001860'
    sy_tmag: '11.7806000'
    sy_tmagerr1: '0.0060000'
    sy_tmagerr2: '-0.0060000'
    sy_name: HATS-68
    st_metratio: '[Fe/H]'
    st_spectype: ''
    sy_kepmag: ''
    sy_kepmagerr1: ''
    sy_kepmagerr2: ''
    st_rotp: ''
    st_rotperr1: ''
    st_rotperr2: ''
    st_rotplim: ''
    gaia_dr2_id: Gaia DR2 4904279261014267648
    gaia_dr3_id: Gaia DR3 4904279261014267648
    cb_flag: '0'
  - hostname: Kepler-402
    hd_name: ''
    hip_name: ''
    tic_id: TIC 158725491
    st_refname: <a refstr=Q1_Q12_KOI_TABLE href=https://exoplanetarchive.ipac.caltech.edu/docs/Kepler_KOI_docs.html
      target=ref>Q1-Q12 KOI Table</a>
    sy_refname: <a refstr=STASSUN_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019AJ....158..138S/abstract
      target=ref>TICv8</a>
    ra: '288.3701976'
    rastr: 19h13m28.85s
    dec: '43.3546109'
    decstr: +43d21m16.60s
    glon: '74.54275'
    glat: '14.53038'
    elon: '302.47150'
    elat: '64.73643'
    sy_icmag: ''
    sy_icmagerr1: ''
    sy_icmagerr2: ''
    st_teff: '6522.00'
    st_tefferr1: '158.00'
    st_tefferr2: '-206.00'
    st_tefflim: '0'
    st_met: '-0.2200'
    st_meterr1: '0.2200'
    st_meterr2: '-0.3200'
    st_metlim: '0'
    st_radv: ''
    st_radverr1: ''
    st_radverr2: ''
    st_radvlim: ''
    st_vsin: ''
    st_vsinerr1: ''
    st_vsinerr2: ''
    st_vsinlim: ''
    st_lum: ''
    st_lumerr1: ''
    st_lumerr2: ''
    st_lumlim: ''
    st_logg: '4.325000'
    st_loggerr1: '0.091000'
    st_loggerr2: '-0.321000'
    st_logglim: '0'
    st_age: ''
    st_ageerr1: ''
    st_ageerr2: ''
    st_agelim: '0'
    st_mass: '1.140000'
    st_masserr1: '0.267000'
    st_masserr2: '-0.146000'
    st_masslim: '0'
    st_dens: '2.259380'
    st_denserr1: '0.218140'
    st_denserr2: '-1.026870'
    st_denslim: '0'
    st_rad: '1.215000'
    st_raderr1: '0.684000'
    st_raderr2: '-0.170000'
    st_radlim: '0'
    sy_snum: '1'
    sy_pnum: '4'
    sy_mnum: '0'
    sy_pm: '4.4218604'
    sy_pmerr1: '0.0331450'
    sy_pmerr2: '-0.0331450'
    sy_pmra: '-4.3031400'
    sy_pmraerr1: '0.0329932'
    sy_pmraerr2: '-0.0329932'
    sy_pmdec: '1.0177600'
    sy_pmdecerr1: '0.0357496'
    sy_pmdecerr2: '-0.0357496'
    sy_plx: '1.5704100'
    sy_plxerr1: '0.0185278'
    sy_plxerr2: '-0.0185278'
    sy_dist: '625.33900000'
    sy_disterr1: '7.38500000'
    sy_disterr2: '-7.21700000'
    sy_bmag: '13.8840000'
    sy_bmagerr1: '0.0520000'
    sy_bmagerr2: '-0.0520000'
    sy_vmag: '13.2700000'
    sy_vmagerr1: '0.0920000'
    sy_vmagerr2: '-0.0920000'
    sy_jmag: '12.3030000'
    sy_jmagerr1: '0.0230000'
    sy_jmagerr2: '-0.0230000'
    sy_hmag: '12.0820000'
    sy_hmagerr1: '0.0220000'
    sy_hmagerr2: '-0.0220000'
    sy_kmag: '11.9930000'
    sy_kmagerr1: '0.0180000'
    sy_kmagerr2: '-0.0180000'
    sy_umag: ''
    sy_umagerr1: ''
    sy_umagerr2: ''
    sy_rmag: ''
    sy_rmagerr1: ''
    sy_rmagerr2: ''
    sy_imag: ''
    sy_imagerr1: ''
    sy_imagerr2: ''
    sy_zmag: ''
    sy_zmagerr1: ''
    sy_zmagerr2: ''
    sy_w1mag: '11.9240000'
    sy_w1magerr1: '0.0230000'
    sy_w1magerr2: '-0.0230000'
    sy_w2mag: '11.9490000'
    sy_w2magerr1: '0.0210000'
    sy_w2magerr2: '-0.0210000'
    sy_w3mag: '11.8530000'
    sy_w3magerr1: '0.1830000'
    sy_w3magerr2: '-0.1830000'
    sy_w4mag: '9.3540000'
    sy_w4magerr1: ''
    sy_w4magerr2: ''
    sy_gmag: ''
    sy_gmagerr1: ''
    sy_gmagerr2: ''
    sy_gaiamag: '13.1917000'
    sy_gaiamagerr1: '0.0002730'
    sy_gaiamagerr2: '-0.0002730'
    sy_tmag: '12.8187000'
    sy_tmagerr1: '0.0065000'
    sy_tmagerr2: '-0.0065000'
    sy_name: Kepler-402
    st_metratio: '[Fe/H]'
    st_spectype: ''
    sy_kepmag: '13.268'
    sy_kepmagerr1: ''
    sy_kepmagerr2: ''
    st_rotp: ''
    st_rotperr1: ''
    st_rotperr2: ''
    st_rotplim: ''
    gaia_dr2_id: Gaia DR2 2102954187290293120
    gaia_dr3_id: Gaia DR3 2102954187290293120
    cb_flag: '0'
  - hostname: Kepler-670
    hd_name: ''
    hip_name: ''
    tic_id: TIC 27990610
    st_refname: <a refstr=BATALHA_ET_AL__2013 href=https://ui.adsabs.harvard.edu/abs/2013ApJS..204...24B/abstract
      target=ref> Batalha et al. 2013 </a>
    sy_refname: <a refstr=STASSUN_ET_AL__2019 href=https://ui.adsabs.harvard.edu/abs/2019AJ....158..138S/abstract
      target=ref>TICv8</a>
    ra: '297.0154644'
    rastr: 19h48m03.71s
    dec: '49.2252988'
    decstr: +49d13m31.08s
    glon: '82.63553'
    glat: '11.72179'
    elon: '321.89873'
    elat: '67.85461'
    sy_icmag: ''
    sy_icmagerr1: ''
    sy_icmagerr2: ''
    st_teff: '5431.00'
    st_tefferr1: ''
    st_tefferr2: ''
    st_tefflim: '0'
    st_met: ''
    st_meterr1: ''
    st_meterr2: ''
    st_metlim: ''
    st_radv: ''
    st_radverr1: ''
    st_radverr2: ''
    st_radvlim: ''
    st_vsin: ''
    st_vsinerr1: ''
    st_vsinerr2: ''
    st_vsinlim: ''
    st_lum: ''
    st_lumerr1: ''
    st_lumerr2: ''
    st_lumlim: ''
    st_logg: '4.430000'
    st_loggerr1: ''
    st_loggerr2: ''
    st_logglim: '0'
    st_age: ''
    st_ageerr1: ''
    st_ageerr2: ''
    st_agelim: ''
    st_mass: ''
    st_masserr1: ''
    st_masserr2: ''
    st_masslim: ''
    st_dens: ''
    st_denserr1: ''
    st_denserr2: ''
    st_denslim: ''
    st_rad: '0.950000'
    st_raderr1: ''
    st_raderr2: ''
    st_radlim: '0'
    sy_snum: '1'
    sy_pnum: '1'
    sy_mnum: '0'
    sy_pm: '4.5500970'
    sy_pmerr1: '0.0459956'
    sy_pmerr2: '-0.0459956'
    sy_pmra: '-2.4642500'
    sy_pmraerr1: '0.0429272'
    sy_pmraerr2: '-0.0429272'
    sy_pmdec: '-3.8250300'
    sy_pmdecerr1: '0.0472106'
    sy_pmdecerr2: '-0.0472106'
    sy_plx: '1.0355800'
    sy_plxerr1: '0.0201268'
    sy_plxerr2: '-0.0201268'
    sy_dist: '939.74400000'
    sy_disterr1: '18.25000000'
    sy_disterr2: '-17.58000000'
    sy_bmag: '16.0490000'
    sy_bmagerr1: '0.0420000'
    sy_bmagerr2: '-0.0420000'
    sy_vmag: '15.1620000'
    sy_vmagerr1: '0.0460000'
    sy_vmagerr2: '-0.0460000'
    sy_jmag: '13.7320000'
    sy_jmagerr1: '0.0230000'
    sy_jmagerr2: '-0.0230000'
    sy_hmag: '13.3930000'
    sy_hmagerr1: '0.0260000'
    sy_hmagerr2: '-0.0260000'
    sy_kmag: '13.3150000'
    sy_kmagerr1: '0.0390000'
    sy_kmagerr2: '-0.0390000'
    sy_umag: ''
    sy_umagerr1: ''
    sy_umagerr2: ''
    sy_rmag: ''
    sy_rmagerr1: ''
    sy_rmagerr2: ''
    sy_imag: ''
    sy_imagerr1: ''
    sy_imagerr2: ''
    sy_zmag: ''
    sy_zmagerr1: ''
    sy_zmagerr2: ''
    sy_w1mag: '13.2860000'
    sy_w1magerr1: '0.0230000'
    sy_w1magerr2: '-0.0230000'
    sy_w2mag: '13.3640000'
    sy_w2magerr1: '0.0250000'
    sy_w2magerr2: '-0.0250000'
    sy_w3mag: '12.5490000'
    sy_w3magerr1: ''
    sy_w3magerr2: ''
    sy_w4mag: '9.3190000'
    sy_w4magerr1: ''
    sy_w4magerr2: ''
    sy_gmag: ''
    sy_gmagerr1: ''
    sy_gmagerr2: ''
    sy_gaiamag: '15.0268000'
    sy_gaiamagerr1: '0.0005110'
    sy_gaiamagerr2: '-0.0005110'
    sy_tmag: '14.4889000'
    sy_tmagerr1: '0.0075000'
    sy_tmagerr2: '-0.0075000'
    sy_name: Kepler-670
    st_metratio: ''
    st_spectype: ''
    sy_kepmag: '15.052'
    sy_kepmagerr1: ''
    sy_kepmagerr2: ''
    st_rotp: ''
    st_rotperr1: ''
    st_rotperr2: ''
    st_rotplim: ''
    gaia_dr2_id: Gaia DR2 2086830502105850240
    gaia_dr3_id: Gaia DR3 2086830502105850240
    cb_flag: '0'
  parser_errors: []
  logical_asset_id: 6194d0a61acae52c7d433424
related_dataset_ids: []
quality:
  score: 100
  parsing_errors: []
  stale_warning: null
  broken_source_report: null
rss_feed_url: null
odc_version: '0.1'
last_successful_scan_at: '2026-09-26T19:23:08+00:00'

Current dbt Source YAML

Open raw YAML

version: 2
sources:
- name: nasa_stellarhosts
  description: NASA exoplanet stellar hosts discovered from exoplanetarchive.ipac.caltech.edu.
  meta:
    opendataodc:
      dataset_id: nasa-stellarhosts
      revision_id: 20260926192308-865b30520f3d
      detected_at: '2026-09-26T19:23:08+00:00'
      source_url: https://exoplanetarchive.ipac.caltech.edu/TAP/sync?query=select+%2A+from+stellarhosts&format=csv
  tables:
  - name: sync_txt
    description: Source asset sync.txt.
    meta:
      opendataodc:
        source_url: https://exoplanetarchive.ipac.caltech.edu/TAP/sync?query=select+%2A+from+stellarhosts&format=csv
        content_hash: 792d6225a12775c0e5511ab18e8a2da98b4dea9925b3f756895bce4794493028
        row_count: 47925
        parser_errors: []
    columns:
    - name: hostname
    - name: hd_name
    - name: hip_name
    - name: tic_id
    - name: st_refname
    - name: sy_refname
    - name: ra
    - name: rastr
    - name: dec
    - name: decstr
    - name: glon
    - name: glat
    - name: elon
    - name: elat
    - name: sy_icmag
    - name: sy_icmagerr1
    - name: sy_icmagerr2
    - name: st_teff
    - name: st_tefferr1
    - name: st_tefferr2
    - name: st_tefflim
    - name: st_met
    - name: st_meterr1
    - name: st_meterr2
    - name: st_metlim
    - name: st_radv
    - name: st_radverr1
    - name: st_radverr2
    - name: st_radvlim
    - name: st_vsin
    - name: st_vsinerr1
    - name: st_vsinerr2
    - name: st_vsinlim
    - name: st_lum
    - name: st_lumerr1
    - name: st_lumerr2
    - name: st_lumlim
    - name: st_logg
    - name: st_loggerr1
    - name: st_loggerr2
    - name: st_logglim
    - name: st_age
    - name: st_ageerr1
    - name: st_ageerr2
    - name: st_agelim
    - name: st_mass
    - name: st_masserr1
    - name: st_masserr2
    - name: st_masslim
    - name: st_dens
    - name: st_denserr1
    - name: st_denserr2
    - name: st_denslim
    - name: st_rad
    - name: st_raderr1
    - name: st_raderr2
    - name: st_radlim
    - name: sy_snum
    - name: sy_pnum
    - name: sy_mnum
    - name: sy_pm
    - name: sy_pmerr1
    - name: sy_pmerr2
    - name: sy_pmra
    - name: sy_pmraerr1
    - name: sy_pmraerr2
    - name: sy_pmdec
    - name: sy_pmdecerr1
    - name: sy_pmdecerr2
    - name: sy_plx
    - name: sy_plxerr1
    - name: sy_plxerr2
    - name: sy_dist
    - name: sy_disterr1
    - name: sy_disterr2
    - name: sy_bmag
    - name: sy_bmagerr1
    - name: sy_bmagerr2
    - name: sy_vmag
    - name: sy_vmagerr1
    - name: sy_vmagerr2
    - name: sy_jmag
    - name: sy_jmagerr1
    - name: sy_jmagerr2
    - name: sy_hmag
    - name: sy_hmagerr1
    - name: sy_hmagerr2
    - name: sy_kmag
    - name: sy_kmagerr1
    - name: sy_kmagerr2
    - name: sy_umag
    - name: sy_umagerr1
    - name: sy_umagerr2
    - name: sy_rmag
    - name: sy_rmagerr1
    - name: sy_rmagerr2
    - name: sy_imag
    - name: sy_imagerr1
    - name: sy_imagerr2
    - name: sy_zmag
    - name: sy_zmagerr1
    - name: sy_zmagerr2
    - name: sy_w1mag
    - name: sy_w1magerr1
    - name: sy_w1magerr2
    - name: sy_w2mag
    - name: sy_w2magerr1
    - name: sy_w2magerr2
    - name: sy_w3mag
    - name: sy_w3magerr1
    - name: sy_w3magerr2
    - name: sy_w4mag
    - name: sy_w4magerr1
    - name: sy_w4magerr2
    - name: sy_gmag
    - name: sy_gmagerr1
    - name: sy_gmagerr2
    - name: sy_gaiamag
    - name: sy_gaiamagerr1
    - name: sy_gaiamagerr2
    - name: sy_tmag
    - name: sy_tmagerr1
    - name: sy_tmagerr2
    - name: sy_name
    - name: st_metratio
    - name: st_spectype
    - name: sy_kepmag
    - name: sy_kepmagerr1
    - name: sy_kepmagerr2
    - name: st_rotp
    - name: st_rotperr1
    - name: st_rotperr2
    - name: st_rotplim
    - name: gaia_dr2_id
    - name: gaia_dr3_id
    - name: cb_flag

Sample Rows

sync.txt

47925 parsed rows. 20260926192308-865b30520f3d