Download Tables of All Public Observations

KOA provides ASCII tables, updated weekly on Wednesday, which contain records of all public science and calibration data for each instrument (except GUIDER which does not have public data yet.)

These tables may be useful for researchers who have large lists of search positions, who expect to download large volumes of data, or who prefer to perform filtering/searching using their own tools or scripts.

The tables are made available in two ASCII formats: in Comma Separated Values (CSV) format, which may be imported into Microsoft Excel, and as IPAC table format, which is a column-delimited and self-describing format.

The tables include a subset of the full attributes (keywords) of each instrument.

Column descriptions are unique to each instrument, and summarized in the documentation links included.

Last Updated: Nov 13 2024
Instrument CSV (size) IPAC ASCII (size) # Observations Column Descriptions
DEIMOS [CSV] 78.8 MB [IPAC] 212.6 MB 201,046 Column Descriptions
ESI [CSV] 31.0 MB [IPAC] 87.4 MB 80,855 Column Descriptions
GUIDER [CSV] 2.9 MB [IPAC] 7.3 MB 6,685 Column Descriptions
HIRES [CSV] 192.6 MB [IPAC] 646.8 MB 474,960 Column Descriptions
KCWI [CSV] 28.0 MB [IPAC] 85.0 MB 66,062 Column Descriptions
KPF [CSV] 89.5 MB [IPAC] 306.1 MB 245,597 Column Descriptions
LRIS [CSV] 276.8 MB [IPAC] 843.5 MB 632,632 Column Descriptions
LWS [CSV] 8.3 MB [IPAC] 24.1 MB 23,737 Column Descriptions
MOSFIRE [CSV] 171.4 MB [IPAC] 435.2 MB 368,624 Column Descriptions
NIRC [CSV] 92.2 MB [IPAC] 264.2 MB 260,117 Column Descriptions
NIRC2 [CSV] 556.9 MB [IPAC] 1.7 GB 1,182,871 Column Descriptions
NIRES [CSV] 36.6 MB [IPAC] 102.1 MB 91,847 Column Descriptions
NIRSPEC [CSV] 672.5 MB [IPAC] 1.8 GB 1,499,122 Column Descriptions
OSIRIS [CSV] 132.9 MB [IPAC] 420.2 MB 319,269 Column Descriptions

There are two methods where the tables can be used for direct download:

  • Use the contents of the fileurl column: Contains the URL for directly downloading individual KOAID files for all instruments.
  • Use the IPAC formatted table to download Level 0 (raw) for all instruments and Level 1 data for: HIRES, LWS, NIRC2, NIRSPEC, and OSIRIS with PyKOA. While the IPAC tables can be used with PyKOA for downloading data, given that the IPAC tables contain all public data, they are not meant to be used as-is given the volume of data.
    Level 0 (raw) data: Edit the IPAC formatted table file to include all the header lines and all the columns and only the rows with data you are interested in. Do not try to download all the rows at once, but create a file for a few nights at a time. Here is a HIRES example where a table has been created called "your_hires_table.tbl' from the downloaded IPAC table to download the level 0 (raw) data:
    from pykoa.koa import Koa
    Koa.download ('./your_hires_table.tbl', 'ipac', 'dnload_dir_hires_lev0')
    Level 1 data: Edit the IPAC formatted table to include all the header lines and the columns and only those rows where koaimtyp = 'object' files for data you are interested in. Do not try to download all the rows at once, but create a file for few nights at a time. Here is a HIRES example where a table has been created called "your_hires_table.tbl' from the downloaded IPAC table to download the level 0 (raw) and level 1 data for the koaimtype = 'object' files:
    from pykoa.koa import Koa
    Koa.download ('./your_hires_table.tbl', 'ipac', 'dnload_dir_hires_lev1', lev1file=1)