Skip to a section:
The interactive tables display data currently stored in the archive, including information provided by the original source, in several interactive tables:
† Due to their sizes, the Kepler Stellar and SuperWASP data sets require an initial search; results are displayed in an interactive table.
The data are presented in tables that can be searched, filtered, sorted and downloaded by end users from within a web page. Note that some tables contain separate tabs for individual releases, such as the Q1-Q16 KOIs. For more information on sorting and filtering data with the multi-tab interface, see the Tables With Tabs section.
For best results, we strongly recommend using Firefox version 15.x or newer when using the interactive tables. Internet Explorer is currently not supported by this interface.
Also, please make sure your browser is set to allow pop-up windows from exoplanetarchive.ipac.caltech.edu. For more information, read the respective help file for your browser version and platform:
Data validation (DV) summaries are PDF documents provided by the Kepler Mission that show the results of the data validation tests conducted for the object.
There are four ways to access DV documentation:
The interactive tables' default display shows all data in the archive, but users may use the Table Upload feature to submit an input file with a pre-selected list of objects. The input file must adhere to a few simple requirements:
|Confirmed Planets:||HIP name
Full KIC identifier (i.e., KIC 757450)
|TCE:||Full KIC identifier (i.e., KIC 757450)|
To use the feature:
If a star name is given, all planets for that host star will be returned. If a planet name is given, only that planet will be returned.
Please note that only one table can be searched at a time, so if your input file lists objects from both tables, you will only see results from the table you selected when you uploaded the file. If your input file does not contain any objects in the specified table, a "No matches found" error displays.
Here is a sample file that can be uploaded to the Confirmed Planets table.
In addition to the data contained in the tables, each entry contains links to other online resources. These links can be accessed by clicking on the information icon next to the planet host star name (), which displays a pop-up window.
You may then point and click on a link to access the online resource.
Entries in the Confirmed Planets table all contain the following links:
All confirmed Kepler planets contain additional links:
Entries in the KOI table contain the following links:
Entries in the Threshold Crossing Events table contain the following links:
If the pop-up window does not disappear after a 5 seconds, you can close it by clicking the in the upper-right corner of the pop-up.
There are several possible parameters given for each planet, one per column. Definitions for each column in each table are linked to the API help document under Data Column Definitions.
Additional parameters can be displayed in the tables by selecting the corresponding checkboxes in the Column Controls panel (click the Select Columns button to view). Up to 50 parameters (columns) can be displayed at a time.
Also, hovering your cursor over any part of a row will display the host name for that specific parameter, which is useful when scrolling horizontally and the Host Name column is no longer on the screen.
The Discovery Method column in the Planets and Host table uses abbreviations to describe each object's discovery method. Here are the descriptions for each:
|pul||pulsar timing variations|
Individual columns can be quickly and easily removed by simply clicking on the icon in the upper-right corner of the column header. To add or remove multiple parameters simultaneously, click the Select Columns button to display the Column Controls panel, then select or de-select the desired checkboxes. Click Update when finished. The table can display up to 50 columns at a time.
Note that selecting a parameter does not automatically select its subordinate parameters. Parameters must be selected individually.
Click the Reset button at the top of the Column Controls panel to reset the parameter selections. This action will select all default parameters, and de-select all others.
Column widths may be resized manually by placing the cursor on the border between two column headings until the cursor becomes one or two arrows (depending on your browser), like in the following image:
You may then hold your mouse button down and drag the cursor to the left or right to resize the columns. Note that clicking the Reset Filters button returns the columns to their default widths.
Columns can also be re-organized by clicking on a column name, holding down the mouse button, and dragging and dropping it to the new location. A red bar will display in the location to which the column will be located when the mouse button is released. In the following example, a column will be relocated between the Dec and Distance columns.
One of the valuable features of the Interactive Visualizer is the ability to sort and filter the data using a slightly extended and simplified form of Structured Query Language (SQL). It is not necessary to have expertise in creating SQL queries to use the visualizer, but it is necessary to follow a specific syntax to do certain things. This section describes the conventions that are supported. For a summary of what is allowed and not allowed, skip to Summary of Allowed Filters for Data String Types and What is Not Allowed.
Important Note About Filtering and Uncertainties and Blend Flags: It's important to remember that filters only apply to the measurement, and not to the uncertainty or blend flag (the values following ±). For example, one entry for Stellar Radius in the Confirmed Planets table has '1.23±0.07*', but the filter only acts on the 1.23 portion. If you include 0.07 in the filter query, this object will not be returned. Filtering on the uncertainty and blend flags will work only if you first display the uncertainty or blend flag columns. Likewise for limit flags. (See Adding and Removing Parameters (Columns).)
To sort data in any column, double-click on a column heading. Note that when the data are sorted, an up or down arrow/triangle displays in the upper-right corner of the column heading. Data are sorted in ascending order (lowest to highest) on the first double-click, and re-sorted in descending order (highest to lowest) on the second double-click.
Note that columns with data containing a mix of letters and numbers (e.g. HD 10069) are sorted based on the first character. So, for example, a column with several planets that begin with the same letter will be ordered based on the alphabetic characters rather than the numeric values (e.g. HD 10069, HD 100077, HD 10180, etc.).
Multi-column sorting: You may hierarchically sort up to two columns. In the following example, we'll sort the multiple entries for the host name 55 Cnc by its planet letters in ascending (b to f) order.
There are two kinds of literal string searches: exact match and substring match.
An exact match calls for results that exclusively contain the search string you specify. The string must be enclosed in single quotation marks (do not use double quotation marks). For example, to find planets with an Orbital Period of exactly 567 days, you would enter '567.' If there were any entries that were variations of 567, such as 567.5 or 567.25, they would not returned because they are not an exact matches.
A substring match returns all results containing the string, but not exclusively. For example, in the Host Name column of the Confirmed Planets table, enter corot in the text field, then wait a few seconds. The column data will refresh and show only the entries containing CoRoT stars. Note that the search string is case-insensitive, so corot is the same as CoRoT.
Note that these types of searches do not recognize Boolean search terms, such as "and," "or" and "not." For example, entering "corot OR cnc" to find CoRoT or CNC Planet Host Star Names will return no results, because the search function will look for stars named "corot OR cnc," which do not exist. You must do separate searches for "corot" and "cnc."
The table allows data to be filtered on multiple parameters, so you can narrow down your results to be very specific. Simply enter your string search in each parameter's search field, giving the table a few seconds to process each parameter before entering the next one. In the example below, the table displays all HD planets that are e planets with an RA less than 200 degrees:
To search for a range of values above or below a specific value, enter < or > followed by the minimum or maximum value.
Example: In the Planet Mass [Jupiter] column, enter >4 in the column's text field, and then wait a few seconds. The column will refresh and show only planet masses greater than 4. You may then double-click on the column heading to sort the filtered results in ascending or descending order. When sorting is activated, a triangle in the upper-right corner of the column heading displays and points up for ascending order and down for descending order.
Another method for searching and displaying ranges of data is to type between followed by the search string range, separated with and, as in:
between 4 and 6.
In the following example, the range for RA [deg] is specified as being between 24 and 100, and a sample of the unsorted results is listed:
The percent symbol (%) can be placed between two search strings that are separated by other characters. For example, entering
corot%7 in the Host Name column returns all CoRoT objects that end in 7 that have multiple characters between CoRoT and 7:
To further narrow your search, you can use an underscore ( _ ) instead of a percent sign, which specifies that there is only one character between the two search strings:
To exclude specific results from a column, type the less-than (<) and greater-than (>) symbols facing each other followed by the search string. For example, typing <>b in the Planet Letter column excludes all b planets:
Typing != and the search string is another way to do the same thing:
This works with both exact and substring matches, for example:
Null values are represented by blank spaces, which means no value has been entered for a specific parameter. Zero is not considered null because it is a value. To remove nulls from filtered result, enter not null in the search field. Conversely, you may type null or =null to only show entries with null values for a particular parameter.
|No Null Values||Only Null Values|
Some syntax may only be used with numeric data or letters. The following table summarizes which commands are appropriate, and if so, how to structure them.
(Three dashes indicates the operation does not work with the string type.)
|Operation||Numeric Syntax||Letter Syntax|
|exclude all nulls||
|show only nulls||
|do not display nulls||
|range of numbers||
|range of letters and numbers
|range of letters and numbers
|less than or equal to||
|greater than or equal to||
Although the RA and Dec can be displayed as sexagesimal strings, they are, in fact, numbers. Therefore, it is possible to perform range filtering on these columns. As discussed above, range filtering on numerical fields uses =, >, >=, <, <=, !=, <>, and BETWEEN val1 AND val2. The interactive table allows for entering RA or Dec in either a decimal notation or a sexagesimal format. Because there can often be an ambiguity in the entry (eg., is the number in hours or degrees?), we have implemented several rules regarding the interpretation of the input.
Below are some examples of user inputs for numerical matching and range filtering and how those inputs are interpreted.
|12:34:56||12h 34m 56s||12d 34m 56s|
|12:34.5||12h 34m 30s||12d 34m 30s|
|12||12h 00m 00s||12d 00m 00s|
|12.0||12h 00m 00s||12d 00m 00s|
|12.5||12h 30m 00s||12d 30m 00s|
|d12.5||not allowed||not allowed|
|12.5d||12.5 degrees||12.5 degrees|
|183.5||not allowed||not allowed|
|183.5d||15h 30m 00s||not allowed|
|-12.0||not allowed||-12 degrees|
|-00:30:00||not allowed||-0.5 degrees|
|-04:30:00||not allowed||-4.5 degrees|
|00:-30:00||not allowed||not allowed|
|-03:+20:30||not allowed||not allowed|
|12:34:56d||not allowed||not allowed|
For best results, avoid using the following characters or commands to filter data:
If you've sorted and filtered data in the table and want to start over, you can revert to the default display by clicking the Reset button in the Column Controls panel.
Clicking Reset Filters in the bottom-right corner of the table reverts the table to the configuration before you last clicked Update. For example, if you have filtered some data, then de-selected columns and clicked Reset Filters, the table will look as it did before you last clicked Update.
Note: You may notice the numbering in the Row ID column (if displayed) appears out of order when data are sorted and filtered. The Row ID is the object's unique identifier in the archive's database and does not reflect any sort of ranking or science value.
Some interactive tables, such as the KOI or transit tables, have multiple tabs within a single window. For these tables, some actions apply to all tabs while other apply only to the active tab.
Actions applied to all tabs:
Once you've filtered and sorted the data to your specifications, you can export them to a table in one of the following formats:
To export to a file, click the Download Table button in the table menu bar to specify a format:
In the same drop-down menu, you may opt to export data from all columns and/or rows or just those filtered and/or checked. A row is checked when the checkbox in the first column contains a checkmark ().
Depending on your browser and platform, the information will either display in new web browser tab or window, or you will be prompted to save the file locally with a new file name.
The constraints used to filter the data will be listed at the top of the table.
Note: The ± symbol embedded with some entries may not be recognized by programs that require 7-bit ASCII characters.
The archive also offers an application programming interface (API) as an alternate method of downloading data directly from the database. This method requires some knowledge of using Structured Query Language (SQL) scripts, which are described in detail on the Application Programming Interface help page.
Please see the Plotting User Guide.
Issue: Scroll bars seem to appear and disappear intermmitently web browser, making it difficult or impossible to scroll.
Possible Solution: In pre-Mavericks versions of Mac OS X, there is a default setting to hide the scroll bars unless they are actively selected. This feature is often most noticeable in web browsers, but actually affects multiple programs. To change this behavior, you must configure the operating system to always show scroll bars.
Issue: After uploading an input file, you get a "No matches found" error.
Possible Solution: You may have selected the wrong table to search in the Table Upload interface. You may only search one table at a time, so try re-submitting your input file and select the other table.
Issue: A table takes a long time to load.
Possible Solution: Try displaying fewer parameters (columns). Each column requires additional loading and processing time that can affect performance.
Issue: The table does not refresh after clicking the web browser's Reload or Refresh button.
Possible Solution: The web browser stores the table data in a local cache, so hold the Shift button while clicking Refresh or Reload to retrieve a fresh batch of data.
Issue: A large strip of whitespace appears at the top or bottom of the table when scrolling up or down.
Possible Solution: This occasionally appears in Safari and Chrome web browsers, usually due to rapid scrolling. Try scrolling in the opposite direction until the white space is off the page, and then resume in the original direction at a slower pace.
Issue: When the web browser window is widened horizontally, the table doesn't expand to the wider size.
Possible Solution: This occasionally occurs in the Safari browser. Try clicking the Update button in the Column Controls panel, or resizing the window again. If that doesn't work, refresh/reload the web page.
Issue: You receive the following error message while trying to filter a parameter:
Possible Solution: You have attempted to use a filter query that is not recognized or allowed by the column. For example, you cannot use the greater-than (>) or less-than (<) symbol with a letter. If you are getting error messages repeatedly, take a moment to review the summary of filter query strings and their usage as well as what is not allowed.
Issue: After clicking Check All, then Clear Checked, then Check All again, the functionality stop working.
Possible Solution: This is a known issue. Click the Reset button in the Column Controls panel to refresh the table.
Issue: If you have filtered data, then de-selected columns, and then clicked Reset Filters in the bottom-right corner of the table, the table revers to the configuration prior to the last time you clicked the Update button.
Possible Solution: This is a known issue. It's best to make your column selections first before filtering the displayed data.
Issue: Clicking Table Plotter brings up the plot in the background, but the screen hangs with a "Loading, Please Wait..." message.
Possible Solution: This is a known issue with Internet Explorer browsers. Try using a different browser, such as Firefox 15.x or newer.
Last updated: 10 November 2014