version: 2
sources:
- name: nasa_k2pandc
  description: NASA K2 planets and candidates discovered from exoplanetarchive.ipac.caltech.edu.
  meta:
    opendataodc:
      dataset_id: nasa-k2pandc
      revision_id: 20260926192337-b3559da558f5
      detected_at: '2026-09-26T19:23:37+00:00'
      source_url: https://exoplanetarchive.ipac.caltech.edu/TAP/sync?query=select+%2A+from+k2pandc&format=tsv
  tables:
  - name: sync_txt
    description: Source asset sync.txt.
    meta:
      opendataodc:
        source_url: https://exoplanetarchive.ipac.caltech.edu/TAP/sync?query=select+%2A+from+k2pandc&format=tsv
        content_hash: 63b35a79b0062c36a8ca865d472240d925b0de0c4f9b64eaef2b27e757084d70
        row_count: 4076
        parser_errors: []
    columns:
    - name: pl_name
    - name: pl_letter
    - name: k2_name
    - name: epic_hostname
    - name: epic_candname
    - name: hostname
    - name: hd_name
    - name: hip_name
    - name: tic_id
    - name: gaia_dr2_id
    - name: gaia_dr3_id
    - name: default_flag
    - name: k2_campaigns
    - name: k2_campaigns_num
    - name: pl_refname
    - name: sy_refname
    - name: disposition
    - name: disp_refname
    - name: disc_pubdate
    - name: disc_year
    - name: discoverymethod
    - name: disc_locale
    - name: disc_facility
    - name: disc_instrument
    - name: disc_telescope
    - name: disc_refname
    - name: ra
    - name: rastr
    - name: dec
    - name: decstr
    - name: glon
    - name: glat
    - name: elon
    - name: elat
    - name: pl_orbper
    - name: pl_orbpererr1
    - name: pl_orbpererr2
    - name: pl_orbperlim
    - name: pl_orbperstr
    - name: pl_orblpererr1
    - name: pl_orblper
    - name: pl_orblpererr2
    - name: pl_orblperlim
    - name: pl_orblperstr
    - name: pl_orbsmax
    - name: pl_orbsmaxerr1
    - name: pl_orbsmaxerr2
    - name: pl_orbsmaxlim
    - name: pl_orbsmaxstr
    - name: pl_orbincl
    - name: pl_orbinclerr1
    - name: pl_orbinclerr2
    - name: pl_orbincllim
    - name: pl_orbinclstr
    - name: pl_orbtper
    - name: pl_orbtpererr1
    - name: pl_orbtpererr2
    - name: pl_orbtperlim
    - name: pl_orbtperstr
    - name: pl_orbeccen
    - name: pl_orbeccenerr1
    - name: pl_orbeccenerr2
    - name: pl_orbeccenlim
    - name: pl_orbeccenstr
    - name: pl_eqt
    - name: pl_eqterr1
    - name: pl_eqterr2
    - name: pl_eqtlim
    - name: pl_eqtstr
    - name: pl_occdep
    - name: pl_occdeperr1
    - name: pl_occdeperr2
    - name: pl_occdeplim
    - name: pl_occdepstr
    - name: pl_insol
    - name: pl_insolerr1
    - name: pl_insolerr2
    - name: pl_insollim
    - name: pl_insolstr
    - name: pl_dens
    - name: pl_denserr1
    - name: pl_denserr2
    - name: pl_denslim
    - name: pl_densstr
    - name: pl_trandep
    - name: pl_trandeperr1
    - name: pl_trandeperr2
    - name: pl_trandeplim
    - name: pl_trandepstr
    - name: pl_tranmid
    - name: pl_tranmiderr1
    - name: pl_tranmiderr2
    - name: pl_tranmidlim
    - name: pl_tranmidstr
    - name: pl_trandur
    - name: pl_trandurerr1
    - name: pl_trandurerr2
    - name: pl_trandurlim
    - name: pl_trandurstr
    - name: sy_kmagstr
    - name: sy_umag
    - name: sy_umagerr1
    - name: sy_umagerr2
    - name: sy_umagstr
    - name: sy_rmag
    - name: sy_rmagerr1
    - name: sy_rmagerr2
    - name: sy_rmagstr
    - name: sy_imag
    - name: sy_imagerr1
    - name: sy_imagerr2
    - name: sy_imagstr
    - name: sy_zmag
    - name: sy_zmagerr1
    - name: sy_zmagerr2
    - name: sy_zmagstr
    - name: sy_w1mag
    - name: sy_w1magerr1
    - name: sy_w1magerr2
    - name: sy_w1magstr
    - name: sy_w2mag
    - name: sy_w2magerr1
    - name: sy_w2magerr2
    - name: sy_w2magstr
    - name: sy_w3mag
    - name: sy_w3magerr1
    - name: sy_w3magerr2
    - name: sy_w3magstr
    - name: sy_w4mag
    - name: sy_w4magerr1
    - name: sy_w4magerr2
    - name: sy_w4magstr
    - name: sy_gmag
    - name: sy_gmagerr1
    - name: sy_gmagerr2
    - name: sy_gmagstr
    - name: sy_gaiamag
    - name: sy_gaiamagerr1
    - name: sy_gaiamagerr2
    - name: sy_gaiamagstr
    - name: sy_tmag
    - name: sy_tmagerr1
    - name: sy_tmagerr2
    - name: sy_tmagstr
    - name: pl_controv_flag
    - name: pl_tsystemref
    - name: st_metratio
    - name: st_spectype
    - name: sy_kepmag
    - name: sy_kepmagerr1
    - name: sy_kepmagerr2
    - name: sy_kepmagstr
    - name: st_rotp
    - name: st_rotperr1
    - name: st_rotperr2
    - name: st_rotplim
    - name: st_rotpstr
    - name: pl_projobliq
    - name: pl_projobliqerr1
    - name: pl_projobliqerr2
    - name: pl_projobliqlim
    - name: pl_projobliqstr
    - name: x
    - name: y
    - name: z
    - name: htm20
    - name: pl_rvamp
    - name: pl_rvamperr1
    - name: pl_rvamperr2
    - name: pl_rvamplim
    - name: pl_rvampstr
    - name: pl_radj
    - name: pl_radjerr1
    - name: pl_radjerr2
    - name: pl_radjlim
    - name: pl_radjstr
    - name: pl_rade
    - name: pl_radeerr1
    - name: pl_radeerr2
    - name: pl_radelim
    - name: pl_radestr
    - name: pl_ratror
    - name: pl_ratrorerr1
    - name: pl_ratrorerr2
    - name: pl_ratrorlim
    - name: pl_ratrorstr
    - name: pl_ratdor
    - name: pl_trueobliq
    - name: pl_trueobliqerr1
    - name: pl_trueobliqerr2
    - name: pl_trueobliqlim
    - name: pl_trueobliqstr
    - name: sy_icmag
    - name: sy_icmagerr1
    - name: sy_icmagerr2
    - name: sy_icmagstr
    - name: rowupdate
    - name: pl_pubdate
    - name: st_refname
    - name: releasedate
    - name: dkin_flag
    - name: pl_ratdorerr1
    - name: pl_ratdorerr2
    - name: pl_ratdorlim
    - name: pl_ratdorstr
    - name: pl_imppar
    - name: pl_impparerr1
    - name: pl_impparerr2
    - name: pl_impparlim
    - name: pl_impparstr
    - name: pl_cmassj
    - name: pl_cmassjerr1
    - name: pl_cmassjerr2
    - name: pl_cmassjlim
    - name: pl_cmassjstr
    - name: pl_cmasse
    - name: pl_cmasseerr1
    - name: pl_cmasseerr2
    - name: pl_cmasselim
    - name: pl_cmassestr
    - name: pl_massj
    - name: pl_massjerr1
    - name: pl_massjerr2
    - name: pl_massjlim
    - name: pl_massjstr
    - name: pl_masse
    - name: pl_masseerr1
    - name: pl_masseerr2
    - name: pl_masselim
    - name: pl_massestr
    - name: pl_bmassj
    - name: pl_bmassjerr1
    - name: pl_bmassjerr2
    - name: pl_bmassjlim
    - name: pl_bmassjstr
    - name: pl_bmasse
    - name: pl_bmasseerr1
    - name: pl_bmasseerr2
    - name: pl_bmasselim
    - name: pl_bmassestr
    - name: pl_bmassprov
    - name: pl_msinij
    - name: pl_msinijerr1
    - name: pl_msinijerr2
    - name: pl_msinijlim
    - name: pl_msinijstr
    - name: pl_msinie
    - name: pl_msinieerr1
    - name: pl_msinieerr2
    - name: pl_msinielim
    - name: pl_msiniestr
    - name: st_teff
    - name: st_tefferr1
    - name: st_tefferr2
    - name: st_tefflim
    - name: st_teffstr
    - name: st_met
    - name: st_meterr1
    - name: st_meterr2
    - name: st_metlim
    - name: st_metstr
    - name: st_radv
    - name: st_radverr1
    - name: st_radverr2
    - name: st_radvlim
    - name: st_radvstr
    - name: st_vsin
    - name: st_vsinerr1
    - name: st_vsinerr2
    - name: st_vsinlim
    - name: st_vsinstr
    - name: st_lum
    - name: st_lumerr1
    - name: st_lumerr2
    - name: st_lumlim
    - name: st_lumstr
    - name: st_logg
    - name: st_loggerr1
    - name: st_loggerr2
    - name: st_logglim
    - name: st_loggstr
    - name: st_age
    - name: st_ageerr1
    - name: st_ageerr2
    - name: st_agelim
    - name: st_agestr
    - name: st_mass
    - name: st_masserr1
    - name: st_masserr2
    - name: st_masslim
    - name: st_massstr
    - name: st_dens
    - name: st_denserr1
    - name: st_denserr2
    - name: st_denslim
    - name: st_densstr
    - name: st_rad
    - name: st_raderr1
    - name: st_raderr2
    - name: st_radlim
    - name: st_radstr
    - name: ttv_flag
    - name: ptv_flag
    - name: tran_flag
    - name: rv_flag
    - name: ast_flag
    - name: obm_flag
    - name: micro_flag
    - name: etv_flag
    - name: ima_flag
    - name: pul_flag
    - name: soltype
    - name: sy_snum
    - name: sy_pnum
    - name: sy_mnum
    - name: cb_flag
    - name: st_nphot
    - name: st_nrvc
    - name: st_nspec
    - name: pl_nespec
    - name: pl_ntranspec
    - name: pl_ndispec
    - name: pl_nnotes
    - name: sy_pm
    - name: sy_pmerr1
    - name: sy_pmerr2
    - name: sy_pmstr
    - name: sy_pmra
    - name: sy_pmraerr1
    - name: sy_pmraerr2
    - name: sy_pmrastr
    - name: sy_pmdec
    - name: sy_pmdecerr1
    - name: sy_pmdecerr2
    - name: sy_pmdecstr
    - name: sy_plx
    - name: sy_plxerr1
    - name: sy_plxerr2
    - name: sy_plxstr
    - name: sy_dist
    - name: sy_disterr1
    - name: sy_disterr2
    - name: sy_diststr
    - name: sy_bmag
    - name: sy_bmagerr1
    - name: sy_bmagerr2
    - name: sy_bmagstr
    - name: sy_vmag
    - name: sy_vmagerr1
    - name: sy_vmagerr2
    - name: sy_vmagstr
    - name: sy_jmag
    - name: sy_jmagerr1
    - name: sy_jmagerr2
    - name: sy_jmagstr
    - name: sy_hmag
    - name: sy_hmagerr1
    - name: sy_hmagerr2
    - name: sy_hmagstr
    - name: sy_kmag
    - name: sy_kmagerr1
    - name: sy_kmagerr2
