NASA TESS objects of interest

Source

exoplanetarchive.ipac.caltech.edu

Quality score: 100/100.

Initial recorded revision.

Dataset refresh metadata

Current Source Files

• sync.txt 20260926192329-aee270f2bfe6 Provider source

Contract Versions

• 20260926192329-aee270f2bfe6 Copy YAML link

Current Open Data Contract YAML

Open raw YAML

dataset_id: nasa-toi
title: NASA TESS objects of interest
description: NASA TESS objects of interest 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+toi&format=csv
update_frequency: weekly
next_scan_at: '2026-09-27T19:23:32.950949+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: 20260926192329-aee270f2bfe6
  detected_at: '2026-09-26T19:23:29+00:00'
  source_updated_at: null
  context: sync.txt detected from sync.
  assets:
  - asset_id: asset-e52ed881a4ff5726
    name: sync.txt
    source_url: https://exoplanetarchive.ipac.caltech.edu/TAP/sync?query=select+%2A+from+toi&format=csv
    media_type: text/plain
    content_hash: e52ed881a4ff5726e6db392b559756f4b5ed7f1f9504e27fd216b4d6fedcc06a
    size_bytes: 5039298
    parent_archive_id: null
  row_count: 8148
  headers:
  - tid
  - toi
  - toidisplay
  - toipfx
  - ctoi_alias
  - pl_pnum
  - tfopwg_disp
  - st_tmag
  - st_tmagerr1
  - st_tmagerr2
  - st_tmagsymerr
  - st_tmaglim
  - rastr
  - ra
  - raerr1
  - raerr2
  - rasymerr
  - decstr
  - dec
  - decerr1
  - decerr2
  - decsymerr
  - st_pmra
  - st_pmraerr1
  - st_pmraerr2
  - st_pmrasymerr
  - st_pmralim
  - st_pmdec
  - st_pmdecerr1
  - st_pmdecerr2
  - st_pmdecsymerr
  - st_pmdeclim
  - pl_tranmid
  - pl_tranmiderr1
  - pl_tranmiderr2
  - pl_tranmidsymerr
  - pl_tranmidlim
  - pl_orbper
  - pl_orbpererr1
  - pl_orbpererr2
  - pl_orbpersymerr
  - pl_orbperlim
  - pl_trandurh
  - pl_trandurherr1
  - pl_trandurherr2
  - pl_trandurhsymerr
  - pl_trandurhlim
  - pl_trandep
  - pl_trandeperr1
  - pl_trandeperr2
  - pl_trandepsymerr
  - pl_trandeplim
  - pl_rade
  - pl_radeerr1
  - pl_radeerr2
  - pl_radesymerr
  - pl_radelim
  - pl_insol
  - pl_insolerr1
  - pl_insolerr2
  - pl_insolsymerr
  - pl_insollim
  - pl_eqt
  - pl_eqterr1
  - pl_eqterr2
  - pl_eqtsymerr
  - pl_eqtlim
  - st_dist
  - st_disterr1
  - st_disterr2
  - st_distsymerr
  - st_distlim
  - st_teff
  - st_tefferr1
  - st_tefferr2
  - st_teffsymerr
  - st_tefflim
  - st_logg
  - st_loggerr1
  - st_loggerr2
  - st_loggsymerr
  - st_logglim
  - st_rad
  - st_raderr1
  - st_raderr2
  - st_radsymerr
  - st_radlim
  - sectors
  - toi_created
  - rowupdate
  - release_date
  sample_rows:
  - tid: '384549882'
    toi: '1048.01'
    toidisplay: TOI-1048.01
    toipfx: '1048'
    ctoi_alias: '384549882.01'
    pl_pnum: '1'
    tfopwg_disp: FP
    st_tmag: '8.8020000'
    st_tmagerr1: '0.006'
    st_tmagerr2: '-0.006'
    st_tmagsymerr: '1'
    st_tmaglim: '0'
    rastr: 09h06m06.65s
    ra: '136.5277020'
    raerr1: ''
    raerr2: ''
    rasymerr: ''
    decstr: -54d54m14.12s
    dec: '-54.9039220'
    decerr1: ''
    decerr2: ''
    decsymerr: ''
    st_pmra: '-10.8630000'
    st_pmraerr1: '0.096'
    st_pmraerr2: '-0.096'
    st_pmrasymerr: '1'
    st_pmralim: '0'
    st_pmdec: '7.0630000'
    st_pmdecerr1: '0.089'
    st_pmdecerr2: '-0.089'
    st_pmdecsymerr: '1'
    st_pmdeclim: '0'
    pl_tranmid: '2458518.3760000'
    pl_tranmiderr1: '0.000750'
    pl_tranmiderr2: '-0.000750'
    pl_tranmidsymerr: '1'
    pl_tranmidlim: '0'
    pl_orbper: '0.3041200'
    pl_orbpererr1: '0.0000100'
    pl_orbpererr2: '-0.0000100'
    pl_orbpersymerr: '1'
    pl_orbperlim: '0'
    pl_trandurh: '0.7480000'
    pl_trandurherr1: '0.1000000'
    pl_trandurherr2: '-0.1000000'
    pl_trandurhsymerr: '1'
    pl_trandurhlim: '0'
    pl_trandep: '1330.0000000'
    pl_trandeperr1: '3.8310700'
    pl_trandeperr2: '-3.8310700'
    pl_trandepsymerr: '1'
    pl_trandeplim: '0'
    pl_rade: '10.4170000'
    pl_radeerr1: '0.6680570'
    pl_radeerr2: '-0.6680570'
    pl_radesymerr: '1'
    pl_radelim: '0'
    pl_insol: '280833.0000000'
    pl_insolerr1: ''
    pl_insolerr2: ''
    pl_insolsymerr: ''
    pl_insollim: ''
    pl_eqt: '6413.0000000'
    pl_eqterr1: ''
    pl_eqterr2: ''
    pl_eqtsymerr: ''
    pl_eqtlim: ''
    st_dist: '440.4260000'
    st_disterr1: '9.4840000'
    st_disterr2: '-9.4840000'
    st_distsymerr: '1'
    st_distlim: '0'
    st_teff: '11892.0000000'
    st_tefferr1: '235.8000000'
    st_tefferr2: '-235.8000000'
    st_teffsymerr: '1'
    st_tefflim: '0'
    st_logg: '4.1400000'
    st_loggerr1: '0.0700000'
    st_loggerr2: '-0.0700000'
    st_loggsymerr: '1'
    st_logglim: '0'
    st_rad: '2.5200000'
    st_raderr1: '0.0900000'
    st_raderr2: '-0.0900000'
    st_radsymerr: '1'
    st_radlim: '0'
    sectors: ''
    toi_created: '2019-07-24 18:44:12'
    rowupdate: '2021-10-29 12:59:15'
    release_date: '2026-09-22 16:38:23'
  - tid: '16288184'
    toi: '1049.01'
    toidisplay: TOI-1049.01
    toipfx: '1049'
    ctoi_alias: '16288184.01'
    pl_pnum: '1'
    tfopwg_disp: KP
    st_tmag: '11.0657000'
    st_tmagerr1: '0.006'
    st_tmagerr2: '-0.006'
    st_tmagsymerr: '1'
    st_tmaglim: '0'
    rastr: 16h55m04.52s
    ra: '253.7688480'
    raerr1: ''
    raerr2: ''
    rasymerr: ''
    decstr: -28d42m38.1s
    dec: '-28.7105840'
    decerr1: ''
    decerr2: ''
    decsymerr: ''
    st_pmra: '-8.5680000'
    st_pmraerr1: '0.100'
    st_pmraerr2: '-0.100'
    st_pmrasymerr: '1'
    st_pmralim: '0'
    st_pmdec: '-5.5620000'
    st_pmdecerr1: '0.055'
    st_pmdecerr2: '-0.055'
    st_pmdecsymerr: '1'
    st_pmdeclim: '0'
    pl_tranmid: '2458626.8015460'
    pl_tranmiderr1: '0.000243'
    pl_tranmiderr2: '-0.000243'
    pl_tranmidsymerr: '1'
    pl_tranmidlim: '0'
    pl_orbper: '2.1805333'
    pl_orbpererr1: '0.0000016'
    pl_orbpererr2: '-0.0000016'
    pl_orbpersymerr: '1'
    pl_orbperlim: '0'
    pl_trandurh: '2.9443745'
    pl_trandurherr1: '0.0347185'
    pl_trandurherr2: '-0.0347185'
    pl_trandurhsymerr: '1'
    pl_trandurhlim: '0'
    pl_trandep: '16399.8584641'
    pl_trandeperr1: '356.3999300'
    pl_trandeperr2: '-356.3999300'
    pl_trandepsymerr: '1'
    pl_trandeplim: '0'
    pl_rade: '16.6994623'
    pl_radeerr1: '0.8662543'
    pl_radeerr2: '-0.8662543'
    pl_radesymerr: '1'
    pl_radelim: '0'
    pl_insol: '1770.4590366'
    pl_insolerr1: ''
    pl_insolerr2: ''
    pl_insolsymerr: ''
    pl_insollim: ''
    pl_eqt: '1654.4026623'
    pl_eqterr1: ''
    pl_eqterr2: ''
    pl_eqtsymerr: ''
    pl_eqtlim: ''
    st_dist: '314.9950000'
    st_disterr1: '7.0655000'
    st_disterr2: '-7.0655000'
    st_distsymerr: '1'
    st_distlim: '0'
    st_teff: '6599.0000000'
    st_tefferr1: '200.0000000'
    st_tefferr2: '-200.0000000'
    st_teffsymerr: '1'
    st_tefflim: '0'
    st_logg: '4.2101700'
    st_loggerr1: '1.9641100'
    st_loggerr2: '-1.9641100'
    st_loggsymerr: '1'
    st_logglim: '0'
    st_rad: '1.2714601'
    st_raderr1: '0.0635578'
    st_raderr2: '-0.0635578'
    st_radsymerr: '1'
    st_radlim: '0'
    sectors: ''
    toi_created: '2019-07-15 19:20:04'
    rowupdate: '2026-01-15 16:00:02'
    release_date: '2026-09-22 16:38:23'
  - tid: '144065872'
    toi: '105.01'
    toidisplay: TOI-105.01
    toipfx: '105'
    ctoi_alias: '144065872.01'
    pl_pnum: '1'
    tfopwg_disp: KP
    st_tmag: '9.4995000'
    st_tmagerr1: '0.006'
    st_tmagerr2: '-0.006'
    st_tmagsymerr: '1'
    st_tmaglim: '0'
    rastr: 22h29m49.88s
    ra: '337.4578240'
    raerr1: ''
    raerr2: ''
    rasymerr: ''
    decstr: -48d00m11.16s
    dec: '-48.0030990'
    decerr1: ''
    decerr2: ''
    decsymerr: ''
    st_pmra: '91.9760000'
    st_pmraerr1: '0.052'
    st_pmraerr2: '-0.052'
    st_pmrasymerr: '1'
    st_pmralim: '0'
    st_pmdec: '-6.8610000'
    st_pmdecerr1: '0.069'
    st_pmdecerr2: '-0.069'
    st_pmdecsymerr: '1'
    st_pmdeclim: '0'
    pl_tranmid: '2460904.4126750'
    pl_tranmiderr1: '0.000093'
    pl_tranmiderr2: '-0.000093'
    pl_tranmidsymerr: '1'
    pl_tranmidlim: '0'
    pl_orbper: '2.1846669'
    pl_orbpererr1: '0.0000001'
    pl_orbpererr2: '-0.0000001'
    pl_orbpersymerr: '1'
    pl_orbperlim: '0'
    pl_trandurh: '2.6989102'
    pl_trandurherr1: '0.1819118'
    pl_trandurherr2: '-0.1819118'
    pl_trandurhsymerr: '1'
    pl_trandurhlim: '0'
    pl_trandep: '11535.5475157'
    pl_trandeperr1: '39.4665166'
    pl_trandeperr2: '-39.4665166'
    pl_trandepsymerr: '1'
    pl_trandeplim: '0'
    pl_rade: '13.7127047'
    pl_radeerr1: '0.6628323'
    pl_radeerr2: '-0.6628323'
    pl_radesymerr: '1'
    pl_radelim: '0'
    pl_insol: '2841.0561889'
    pl_insolerr1: ''
    pl_insolerr2: ''
    pl_insolsymerr: ''
    pl_insollim: ''
    pl_eqt: '2033.9398041'
    pl_eqterr1: ''
    pl_eqterr2: ''
    pl_eqtsymerr: ''
    pl_eqtlim: ''
    st_dist: '137.5440000'
    st_disterr1: '0.7905000'
    st_disterr2: '-0.7905000'
    st_distsymerr: '1'
    st_distlim: '0'
    st_teff: '5630.0000000'
    st_tefferr1: ''
    st_tefferr2: ''
    st_teffsymerr: '1'
    st_tefflim: '0'
    st_logg: '4.3775900'
    st_loggerr1: ''
    st_loggerr2: ''
    st_loggsymerr: '1'
    st_logglim: '0'
    st_rad: '1.2382400'
    st_raderr1: '0.0596985'
    st_raderr2: '-0.0596985'
    st_radsymerr: '1'
    st_radlim: '0'
    sectors: ''
    toi_created: '2018-09-05 18:49:20'
    rowupdate: '2026-04-08 16:00:02'
    release_date: '2026-09-22 16:38:23'
  - tid: '66818296'
    toi: '1050.01'
    toidisplay: TOI-1050.01
    toipfx: '1050'
    ctoi_alias: '66818296.01'
    pl_pnum: '1'
    tfopwg_disp: KP
    st_tmag: '11.0261000'
    st_tmagerr1: '0.006'
    st_tmagerr2: '-0.006'
    st_tmagsymerr: '1'
    st_tmaglim: '0'
    rastr: 15h59m50.94s
    ra: '239.9622480'
    raerr1: ''
    raerr2: ''
    rasymerr: ''
    decstr: -28d03m42.46s
    dec: '-28.0617940'
    decerr1: ''
    decerr2: ''
    decsymerr: ''
    st_pmra: '-8.1000000'
    st_pmraerr1: '0.102'
    st_pmraerr2: '-0.102'
    st_pmrasymerr: '1'
    st_pmralim: '0'
    st_pmdec: '-9.6390000'
    st_pmdecerr1: '0.055'
    st_pmdecerr2: '-0.055'
    st_pmdecsymerr: '1'
    st_pmdeclim: '0'
    pl_tranmid: '2459355.5456300'
    pl_tranmiderr1: '0.000257'
    pl_tranmiderr2: '-0.000257'
    pl_tranmidsymerr: '1'
    pl_tranmidlim: '0'
    pl_orbper: '3.7354838'
    pl_orbpererr1: '0.0000021'
    pl_orbpererr2: '-0.0000021'
    pl_orbpersymerr: '1'
    pl_orbperlim: '0'
    pl_trandurh: '4.1420000'
    pl_trandurherr1: '0.0450000'
    pl_trandurherr2: '-0.0450000'
    pl_trandurhsymerr: '1'
    pl_trandurhlim: '0'
    pl_trandep: '17030.0000000'
    pl_trandeperr1: '0.2717320'
    pl_trandeperr2: '-0.2717320'
    pl_trandepsymerr: '1'
    pl_trandeplim: '0'
    pl_rade: '21.2315000'
    pl_radeerr1: '1.1957900'
    pl_radeerr2: '-1.1957900'
    pl_radesymerr: '1'
    pl_radelim: '0'
    pl_insol: '1292.1900000'
    pl_insolerr1: ''
    pl_insolerr2: ''
    pl_insolsymerr: ''
    pl_insollim: ''
    pl_eqt: '1670.0000000'
    pl_eqterr1: ''
    pl_eqterr2: ''
    pl_eqtsymerr: ''
    pl_eqtlim: ''
    st_dist: '405.9080000'
    st_disterr1: '8.6000000'
    st_disterr2: '-8.6000000'
    st_distsymerr: '1'
    st_distlim: '0'
    st_teff: '6650.0000000'
    st_tefferr1: ''
    st_tefferr2: ''
    st_teffsymerr: '1'
    st_tefflim: '0'
    st_logg: '4.1639000'
    st_loggerr1: ''
    st_loggerr2: ''
    st_loggsymerr: '1'
    st_logglim: '0'
    st_rad: '1.5700000'
    st_raderr1: '0.0900000'
    st_raderr2: '-0.0900000'
    st_radsymerr: '1'
    st_radlim: '0'
    sectors: ''
    toi_created: '2019-07-15 19:20:05'
    rowupdate: '2022-10-05 10:10:01'
    release_date: '2026-09-22 16:38:23'
  - tid: '259863352'
    toi: '1051.01'
    toidisplay: TOI-1051.01
    toipfx: '1051'
    ctoi_alias: '259863352.01'
    pl_pnum: '1'
    tfopwg_disp: FA
    st_tmag: '7.1278000'
    st_tmagerr1: '0.006'
    st_tmagerr2: '-0.006'
    st_tmagsymerr: '1'
    st_tmaglim: '0'
    rastr: 02h41m27.83s
    ra: '40.3659390'
    raerr1: ''
    raerr2: ''
    rasymerr: ''
    decstr: -71d27m45.9s
    dec: '-71.4627490'
    decerr1: ''
    decerr2: ''
    decsymerr: ''
    st_pmra: '168.1700000'
    st_pmraerr1: '2.000'
    st_pmraerr2: '-2.000'
    st_pmrasymerr: '1'
    st_pmralim: '0'
    st_pmdec: '-56.0400000'
    st_pmdecerr1: '2.000'
    st_pmdecerr2: '-2.000'
    st_pmdecsymerr: '1'
    st_pmdeclim: '0'
    pl_tranmid: '2458657.7366250'
    pl_tranmiderr1: '0.007425'
    pl_tranmiderr2: '-0.007425'
    pl_tranmidsymerr: '1'
    pl_tranmidlim: '0'
    pl_orbper: '21.7016690'
    pl_orbpererr1: '0.0095323'
    pl_orbpererr2: '-0.0095323'
    pl_orbpersymerr: '1'
    pl_orbperlim: '0'
    pl_trandurh: '8.2676424'
    pl_trandurherr1: '0.5088978'
    pl_trandurherr2: '-0.5088978'
    pl_trandurhsymerr: '1'
    pl_trandurhlim: '0'
    pl_trandep: '211.6567325'
    pl_trandeperr1: '25.1326920'
    pl_trandeperr2: '-25.1326920'
    pl_trandepsymerr: '1'
    pl_trandeplim: '0'
    pl_rade: '2.3751494'
    pl_radeerr1: '0.6983451'
    pl_radeerr2: '-0.6983451'
    pl_radesymerr: '1'
    pl_radelim: '0'
    pl_insol: '52.0950000'
    pl_insolerr1: ''
    pl_insolerr2: ''
    pl_insolsymerr: ''
    pl_insollim: ''
    pl_eqt: '685.2000000'
    pl_eqterr1: ''
    pl_eqterr2: ''
    pl_eqtsymerr: ''
    pl_eqtlim: ''
    st_dist: '53.1914900'
    st_disterr1: ''
    st_disterr2: ''
    st_distsymerr: '1'
    st_distlim: '0'
    st_teff: '5625.0000000'
    st_tefferr1: '80.0000000'
    st_tefferr2: '-80.0000000'
    st_teffsymerr: '1'
    st_tefflim: '0'
    st_logg: '4.4380000'
    st_loggerr1: ''
    st_loggerr2: ''
    st_loggsymerr: '1'
    st_logglim: '0'
    st_rad: '1.5648600'
    st_raderr1: '0.1866290'
    st_raderr2: '-0.1866290'
    st_radsymerr: '1'
    st_radlim: '0'
    sectors: ''
    toi_created: '2019-08-16 20:20:45'
    rowupdate: '2024-09-17 10:08:02'
    release_date: '2026-09-22 16:38:23'
  parser_errors: []
  logical_asset_id: f8bc825d2e5de971b78ba126
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:29+00:00'

Current dbt Source YAML

Open raw YAML

version: 2
sources:
- name: nasa_toi
  description: NASA TESS objects of interest discovered from exoplanetarchive.ipac.caltech.edu.
  meta:
    opendataodc:
      dataset_id: nasa-toi
      revision_id: 20260926192329-aee270f2bfe6
      detected_at: '2026-09-26T19:23:29+00:00'
      source_url: https://exoplanetarchive.ipac.caltech.edu/TAP/sync?query=select+%2A+from+toi&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+toi&format=csv
        content_hash: e52ed881a4ff5726e6db392b559756f4b5ed7f1f9504e27fd216b4d6fedcc06a
        row_count: 8148
        parser_errors: []
    columns:
    - name: tid
    - name: toi
    - name: toidisplay
    - name: toipfx
    - name: ctoi_alias
    - name: pl_pnum
    - name: tfopwg_disp
    - name: st_tmag
    - name: st_tmagerr1
    - name: st_tmagerr2
    - name: st_tmagsymerr
    - name: st_tmaglim
    - name: rastr
    - name: ra
    - name: raerr1
    - name: raerr2
    - name: rasymerr
    - name: decstr
    - name: dec
    - name: decerr1
    - name: decerr2
    - name: decsymerr
    - name: st_pmra
    - name: st_pmraerr1
    - name: st_pmraerr2
    - name: st_pmrasymerr
    - name: st_pmralim
    - name: st_pmdec
    - name: st_pmdecerr1
    - name: st_pmdecerr2
    - name: st_pmdecsymerr
    - name: st_pmdeclim
    - name: pl_tranmid
    - name: pl_tranmiderr1
    - name: pl_tranmiderr2
    - name: pl_tranmidsymerr
    - name: pl_tranmidlim
    - name: pl_orbper
    - name: pl_orbpererr1
    - name: pl_orbpererr2
    - name: pl_orbpersymerr
    - name: pl_orbperlim
    - name: pl_trandurh
    - name: pl_trandurherr1
    - name: pl_trandurherr2
    - name: pl_trandurhsymerr
    - name: pl_trandurhlim
    - name: pl_trandep
    - name: pl_trandeperr1
    - name: pl_trandeperr2
    - name: pl_trandepsymerr
    - name: pl_trandeplim
    - name: pl_rade
    - name: pl_radeerr1
    - name: pl_radeerr2
    - name: pl_radesymerr
    - name: pl_radelim
    - name: pl_insol
    - name: pl_insolerr1
    - name: pl_insolerr2
    - name: pl_insolsymerr
    - name: pl_insollim
    - name: pl_eqt
    - name: pl_eqterr1
    - name: pl_eqterr2
    - name: pl_eqtsymerr
    - name: pl_eqtlim
    - name: st_dist
    - name: st_disterr1
    - name: st_disterr2
    - name: st_distsymerr
    - name: st_distlim
    - name: st_teff
    - name: st_tefferr1
    - name: st_tefferr2
    - name: st_teffsymerr
    - name: st_tefflim
    - name: st_logg
    - name: st_loggerr1
    - name: st_loggerr2
    - name: st_loggsymerr
    - name: st_logglim
    - name: st_rad
    - name: st_raderr1
    - name: st_raderr2
    - name: st_radsymerr
    - name: st_radlim
    - name: sectors
    - name: toi_created
    - name: rowupdate
    - name: release_date

Sample Rows

sync.txt

8148 parsed rows. 20260926192329-aee270f2bfe6