Data Column Definitions
This page contains the complete list of all public data columns in the Atmospheric Spectroscopy table.
User Guide
Querying the Table Using TAP
The Atmospheric Spectroscopy Table is supported by the archive's Table Access Query (TAP) service, which allows users to programmatically access and retrieve data as an alternative to the interactive web interface. More information about the archive's TAP service is on the Using TAP page.
Note: Only the Spectra data columns in panel 1 are retrievable through TAP.
Spectra Columns
These columns appear in the upper-left panel (panel 1) of the table's web interface. Column names denoted with a † are default parameters that display in the web interface when first loaded.
| Table Label and Unit | Database Column Name |
Description |
|---|---|---|
| Planet Name† | pl_name | Planetary name most commonly used in the literature. |
| Type of Spectrum† | spec_type | Specifies the type of spectral data in that row:
|
| Bibcode | bibcode | The bibliographic code that identifies the reference paper in the Astrophysics Data System (ADS). |
| Reference† | authors | Link to the refereed publication describing the observation. |
| # Datapoints† | num_datapoints | The number of data points in the spectrum. |
| Instrument† | instrument | Name of the instrument used to perform the observation. |
| Facility† | facility | Name of the facility/telescope used to perform the observation. |
| Minimum Wavelength [microns]† | minwavelng | The minimum wavelength value from the spectrum file. |
| Maximum Wavelength [microns]† | maxwavelng | The maximum wavelength value from the spectrum file . |
| Min. Obs. Date [BJD]† | mintranmid | If the spectrum is from a single epoch, the date of observation—either transit/eclipse midpoint, or time of observation If the spectrum is combined from multiple transits, the first (smallest) date of observation. |
| Max. Obs. Date [BJD]† | maxtranmid | If the spectrum is from a single epoch, the date of observation—either transit/eclipse midpoint or time of observation. If the spectrum is combined from multiple transits, the last (largest) date of observation. |
| Notes† | note | Additional information about the spectrum (e.g., the specific table in the reference paper where data were taken). |
| File Path | spec_path | The spectrum's file name, which can be used to map downloaded files to the metadata. |
Note: Transmisson, eclipse, and direct imaging data described in the following tables are not accessible through TAP, but are listed here to provide units and descriptions.
Transmission Spectra Data Points (Upper-right Panel)
These columns display in panel 2 when a transmission spectrum in panel 1 is highlighted.
Database column names are provided for users who want to add new column that displays the output of a calculation or conversion from available data (see Tips and Troubleshooting in this user guide for more information on that feature).
Column names denoted with a † are default parameters that display in the web interface when initially loaded or refreshed. To view non-default parameters, click the Table Options button 
in the upper-right corner of panel 2, check the box(es) for your desired parameters, and click Close. Your new selection of data columns will automatically display in panel 2.
| Table Label and Unit | Database Column Name | Description |
|---|---|---|
| Central Wave. [microns]† | centralwavelng | Central wavelength of the spectral observation. |
| Band Width [microns]† | bandwidth | Band width of the spectral observation. |
| Transit Depth [%]† | pl_trandep | The measured wavelength-dependent decrement in relative flux caused by the planet transiting in front of the star. |
| Transit Depth [+err]† | pl_trandeperr1 | Upper uncertainty in the transit depth. |
| Transit Depth [-err]† | pl_trandeperr2 | Lower uncertainty in the transit depth. |
| Transit Depth Limit Flag | pl_trandeplim | Whether the transit depth was calculated by the Exoplanet Archive (Calculated) or directly from the literature source (Reference). |
| Transit Depth Prov.† | pl_trandep_authors | The measured wavelength-dependent ratio of the planet's radius to the host star's radius. |
| Planet / Stellar Rad. | pl_ratror | The planet radius divided by the stellar radius. |
| Planet / Stellar Rad. [+err]† | pl_ratrorerr1 |
Upper uncertainty in the planet/stellar radius. |
| Planet / Stellar Rad. [-err]† | pl_ratrorerr2 | Lower uncertainty in the planet/stellar radius. |
| Planet / Stellar Rad. Limit Flag | pl_ratrorlim | Flag is set if Planet/Stellar Radius is only an upper limit. |
| Planet / Stellar Rad. Prov.† | pl_ratror_authors | Whether the Planet/Stellar Radius was calculated by the Exoplanet Archive (Calculated) or directly from the literature source (Reference). |
| Planet Rad. [Jupiter radii] | pl_radj | The measured wavelength-dependent radius of the planet . |
| Planet Rad. [+err]† | pl_radj1 | Upper uncertainty in the Planet Radius. |
| Planet Rad. [-err]† | pl_radj2 | Lower uncertainty in the Planet Radius. |
| Planet Rad. Limit Flag | pl_radjlim | Flag is set if Planet Radius is only an upper limit. |
| Planet Rad Prov.† | pl_radj_authors | Whether the Planet Radius was calculated by the Exoplanet Archive (Calculated) or directly from the literature source (Reference). |
| Transit Mid-Point [days] | pl_tranmid | The date of the transit mid-point when the observation was collected. |
| Transit Mid-Point [+err] | pl_tranmiderr1 | Upper uncertainty on the transit mid-point. |
| Transit Mid-Point [-err] | pl_trandmiderr2 | Lower uncertainty on the transit mid-point. |
| Transit Mid-Point Limit Flag | pl_tranmidlim | |
| Stellar Rad. [Solar radii] | st_rad | Radius of the exoplanet host star. |
| Stellar Rad. [+err] | st_raderr1 | Upper uncertainty on the stellar radius. |
| Stellar Rad. [-err] | st_raderr2 | Lower uncertainty on the stellar radius. |
| Stellar Rad. Ref. | st_rad_authors | The literature source for the stellar radius. |
Eclipse Spectra Data Points (Upper-right Panel)
These columns display in panel 2 when an eclipse spectrum is highlighted in panel 1. These data are not accessible through TAP, but are listed here to provide units and descriptions.
Database column names are provided for users who want to add new column that displays the output of a calculation or conversion from available data (see Tips and Troubleshooting in this user guide for more information on that feature).
Column names denoted with a † are default parameters that display in the web interface when initially loaded or refreshed. To view non-default parameters, click the Table Options button in the upper-right corner of panel 2, check the box(es) for your desired parameters, and click Close. Your new selection of data columns will automatically display in panel 2.
| Table Label and Unit | Database Column Name | Description |
|---|---|---|
| Central Wave. [microns]† | centralwavelng | Central wavelength of the spectral observation. |
| Band Width [microns]† | bandwidth | Band width of the spectral observation. |
| Eclipse Depth [%]† | especlipdep | The size of the relative flux decrement caused by the star transiting in front of the planet; also often referred to as the flux ratio between the planetary flux and the stellar flux. |
| Eclipse Depth [+err]† | especlipdeperr1 | Upper uncertainty on the eclipse depth. |
| Eclipse Depth [-err]† | especlipdeperr2 | Lower uncertainty on the eclipse depth. |
| Eclipse Depth Limit Flag | especlipdeplim | |
| Brightness Temperature [Kelvin]† | espbritemp | The temperature of a black body of the same size and flux as the exoplanet at the observed wavelength. |
| Brightness Temperature [+err]† | espbritemperr1 | Upper uncertainty on the brightness temperature. |
| Brightness Temperature [-err]† | espbritemperr2 | Lower uncertainty on the brightness temperature. |
| Brightness Temperature Limit Flag | espbritemplim | |
| Observation Date [days] | obs_date | The time given by the average of the time the star begins to eclipse the planet and the time the star finishes eclipsing. |
Direct Imaging Spectra Data Points (Upper-right Panel)
These columns display in panel 2 when a direct imaging spectrum is highlighted in panel 1. These data are not accessible through TAP, but are listed here to provide units and descriptions.
Database column names are provided for users who want to add new column that displays the output of a calculation or conversion from available data (see Tips and Troubleshooting in this user guide for more information on that feature).
Column names denoted with a † are default parameters that display in the web interface when initially loaded or refreshed. To view non-default parameters, click the Table Options button in the upper-right corner of panel 2, check the box(es) for your desired parameters, and click Close. Your new selection of data columns will automatically display in panel 2.
| Table Label and Unit | Database Column Name | Description |
|---|---|---|
| Central Wave. [microns]† | centralwavelng | Central wavelength of the spectral observation. |
| Band Width [microns]† | bandwidth | Band width of the spectral observation. |
| F_lambda W / (m2 micron)† | flam | Flux density (per unit wavelength). |
| F_lambda (-Err) W / [m2 micron]† | flamerr1 | Upper uncertainty on flux density (per unit wavelength) (-Err). |
| F_lambda (+Err) W / [m2 micron]† | flamerr2 | Lower uncertainty on flux density (per unit wavelength) (+Err). |
| FLAMLIM | flamlim | Flag is set if the flux value is only an upper limit. |
| F_lambda Prov.† | flam_authors | Whether the flux value wave calculated by the Exoplanet Archive (Calculated) or is directly from the literature source (Reference). |
| F_nu [Jy]† | fnu | Flux density (per unit frequency). |
| F_nu (-Err) [Jy]† | fnuerr1 | Upper uncertainty on flux density (per unit frequency) (-Err). |
| F_nu (+Err) [Jy]† | fnuerr2 | Lower uncertainty on flux density (per unit frequency) (+Err). |
| FNULIM | fnulim | Flag is set if the flux value is only an upper limit. |
| F_nu Prov.† | fnu_authors | Whether the flux value wave calculated by the Exoplanet Archive (Calculated) or is directly from the literature source (Reference). |
| Observation Date [days]† | obs_date | The time of observation. |
| Observation Date (-Err) [days]† | obs_dateerr1 | Upper uncertainty on the observation date. |
| Observation Date (+Err) [days]† | obs_dateerr2 | Lower uncertainty on the observation date. |
«Previous Spectroscopy Calculations Tips and Troubleshooting Next »
Last updated: 13 August 2024
