{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "\n",
    "\n",
    "<table width=\"100%\" style=\"padding:0; margin-left:-6px;\">\n",
    "    <tr style=\"padding=0;\" width=\"100%\">\n",
    "        <td width=\"auto\">\n",
    "           <hr style=\"border:2px solid darkblue\">\n",
    "            <h1> nb1. Query one source</h1>\n",
    "           <hr style=\"border:2px solid darkblue\">\n",
    "        </td>\n",
    "        <td width=\"60px\">\n",
    "           <img src=\"ALMAsmall.png\" align=\"right\"/> \n",
    "        </td>\n",
    "    </tr>\n",
    "</table>    \n",
    "        \n",
    "\n",
    "In this notebook we query one source in three modes: \n",
    "    \n",
    "* By coordinate:\n",
    "    * within a certain radius around a given coordinate (for point sources) \n",
    "    * within a certain radius around a given coordinate, estimating the distance to the archival sources\n",
    "<br/><br/>\n",
    "* By the resolved source name using [Sesame](http://cds.u-strasbg.fr/cgi-bin/Sesame)\n",
    "<br/><br/>\n",
    "    \n",
    "* By the ALMA source name\n",
    "    * full name   \n",
    "    * part of the name\n",
    "    <br/><br/>\n",
    "    \n",
    "-------------\n",
    "\n",
    "The relevant columns in the [ALMA Science Archive TAP service](https://almascience.org/tap) are \n",
    "* *s_ra*, *s_dec* (RA and Dec in degrees)\n",
    "* *s_region* (STC-S footprint of the observation)\n",
    "* *target_name* (source name)\n",
    " \n",
    "--------- ----- -----\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "First we need to set up the python modules"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "execution": {
     "iopub.execute_input": "2021-11-16T10:25:47.919812Z",
     "iopub.status.busy": "2021-11-16T10:25:47.914391Z",
     "iopub.status.idle": "2021-11-16T10:25:48.841941Z",
     "shell.execute_reply": "2021-11-16T10:25:48.842452Z"
    }
   },
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import astropy\n",
    "import astropy.coordinates\n",
    "import pyvo\n",
    "import pandas as pd\n",
    "\n",
    "service = pyvo.dal.TAPService(\"https://almascience.eso.org/tap\")      # for the EU ALMA TAP service\n",
    "\n",
    "# service = pyvo.dal.TAPService(\"https://almascience.nao.ac.jp/tap\")  # for the EA ALMA TAP service\n",
    "# service = pyvo.dal.TAPService(\"https://almascience.nrao.edu/tap\")   # for the NA ALMA TAP service"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<hr style=\"border:2px solid darkblue\"> </hr>\n",
    "\n",
    "## By coordinate\n",
    "\n",
    "<hr style=\"border:2px solid darkblue\"> </hr>\n",
    "\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "The most basic search of a source is based on its coordinates. To do this we use the INTERSECT function to find all observations where the footprint (s_region) overlaps with the search circle. "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "execution": {
     "iopub.execute_input": "2021-11-16T10:25:48.848925Z",
     "iopub.status.busy": "2021-11-16T10:25:48.848122Z",
     "iopub.status.idle": "2021-11-16T10:25:48.851419Z",
     "shell.execute_reply": "2021-11-16T10:25:48.850795Z"
    }
   },
   "outputs": [],
   "source": [
    "def query_coordinate(service, ra, dec, radius):\n",
    "    \"\"\"Queries ALMA footprints that intersect the search circle\n",
    "    \n",
    "       service        pyvo TAPService instance           \n",
    "       ra             Right Ascension in decimal degrees\n",
    "       dec            Declination in decimal degrees\n",
    "       radius         Search radius in decimal degrees\n",
    "           \n",
    "       returns        pandas table\n",
    "       \"\"\"    \n",
    "    \n",
    "    query = f\"\"\"\n",
    "            SELECT * \n",
    "            FROM ivoa.obscore   \n",
    "            WHERE INTERSECTS(CIRCLE('ICRS',{ra},{dec},{radius}),s_region)=1  \"\"\"\n",
    "    \n",
    "    return service.search(query).to_table().to_pandas()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<hr style=\"border:2px solid darkblue\"> </hr>\n",
    "\n",
    "## By coordinate: Display and sort by distance\n",
    "\n",
    "<hr style=\"border:2px solid darkblue\"> </hr>\n",
    "\n",
    "\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "It is also possible to add a column to the ADQL output. For example we can now display the distance of the positions in the archive catalogue to the searched coordinate and sort by it."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "execution": {
     "iopub.execute_input": "2021-11-16T10:25:48.858767Z",
     "iopub.status.busy": "2021-11-16T10:25:48.858020Z",
     "iopub.status.idle": "2021-11-16T10:25:48.861514Z",
     "shell.execute_reply": "2021-11-16T10:25:48.860712Z"
    }
   },
   "outputs": [],
   "source": [
    "def query_coordinate_display_distance(service, ra, dec, radius):\n",
    "    \"\"\"Queries ALMA footprints that intersect the search circle\n",
    "    \n",
    "       service        pyvo TAPService instance           \n",
    "       ra             Right Ascension in decimal degrees\n",
    "       dec            Declination in decimal degrees\n",
    "       radius         Search radius in decimal degrees\n",
    "           \n",
    "       returns        pandas table including the distance column\n",
    "       \"\"\"    \n",
    "\n",
    "    query = f\"\"\" \n",
    "            SELECT DISTANCE(POINT('ICRS', s_ra, s_dec), POINT('ICRS',{ra},{dec})) AS dist, * \n",
    "            FROM ivoa.obscore \n",
    "            WHERE INTERSECTS(CIRCLE('ICRS',{ra},{dec},{radius}),s_region)=1 \n",
    "            ORDER BY dist\"\"\"\n",
    "\n",
    "    return service.search(query).to_table().to_pandas()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<hr style=\"border:2px solid darkblue\"> </hr>\n",
    "\n",
    "## By the resolved source name\n",
    "\n",
    "<hr style=\"border:2px solid darkblue\"> </hr>"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Astropy comes with functionality to resolve astronomical source names into coordinates using the [Sesame](http://cds.u-strasbg.fr/cgi-bin/Sesame) service of [CDS](http://cds.u-strasbg.fr). This can be combined with the coordinate query above."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "execution": {
     "iopub.execute_input": "2021-11-16T10:25:48.882496Z",
     "iopub.status.busy": "2021-11-16T10:25:48.866803Z",
     "iopub.status.idle": "2021-11-16T10:25:48.899288Z",
     "shell.execute_reply": "2021-11-16T10:25:48.898675Z"
    }
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "201.36506288 -43.01911267\n"
     ]
    }
   ],
   "source": [
    "coordinates = astropy.coordinates.SkyCoord.from_name(\"Cen A\")\n",
    "print(coordinates.ra.degree, coordinates.dec.degree)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<hr style=\"border:2px solid darkblue\"> </hr>\n",
    "\n",
    "## By the ALMA source name\n",
    "<hr style=\"border:2px solid darkblue\"> </hr>"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "These two functions encapsulate the search for a source name **as given by the PI in the proposal to ALMA** (for a search using a name-resolver, see above):"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "execution": {
     "iopub.execute_input": "2021-11-16T10:25:48.907726Z",
     "iopub.status.busy": "2021-11-16T10:25:48.906907Z",
     "iopub.status.idle": "2021-11-16T10:25:48.909457Z",
     "shell.execute_reply": "2021-11-16T10:25:48.910001Z"
    }
   },
   "outputs": [],
   "source": [
    "def query_alma_source_name_exact(service, source_name):\n",
    "    \"\"\" queries the ALMA source name as given by the PI\n",
    "    \n",
    "       service        pyvo TAPService instance           \n",
    "       source_name    complete source name \n",
    "           \n",
    "       returns        pandas table\n",
    "    \"\"\"\n",
    "    \n",
    "    query = f\"\"\"  \n",
    "            SELECT *  \n",
    "            FROM ivoa.obscore  \n",
    "            WHERE target_name = '{source_name}' \"\"\"\n",
    "    \n",
    "    return service.search(query).to_table().to_pandas()\n",
    "\n",
    "\n",
    "def query_alma_source_name_included(service, source_name):\n",
    "    \"\"\" queries a portion of the ALMA source name as given by the PI\n",
    "    \n",
    "       service        pyvo TAPService instance           \n",
    "       source_name    portion of the source name \n",
    "           \n",
    "       returns        pandas table\n",
    "    \"\"\"   \n",
    "    \n",
    "    query = f\"\"\" \n",
    "            SELECT *  \n",
    "            FROM ivoa.obscore  \n",
    "            WHERE target_name LIKE '%{source_name}%'  \"\"\"\n",
    "    \n",
    "    return service.search(query).to_table().to_pandas()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "-----------------\n",
    "\n",
    "## Example 1a: Find sources at coordinate RA: 201.365, DEC: -43.019"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "execution": {
     "iopub.execute_input": "2021-11-16T10:25:48.914674Z",
     "iopub.status.busy": "2021-11-16T10:25:48.914085Z",
     "iopub.status.idle": "2021-11-16T10:25:49.365134Z",
     "shell.execute_reply": "2021-11-16T10:25:49.364521Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>access_url</th>\n",
       "      <th>access_format</th>\n",
       "      <th>proposal_id</th>\n",
       "      <th>data_rights</th>\n",
       "      <th>gal_longitude</th>\n",
       "      <th>gal_latitude</th>\n",
       "      <th>obs_publisher_did</th>\n",
       "      <th>obs_collection</th>\n",
       "      <th>facility_name</th>\n",
       "      <th>instrument_name</th>\n",
       "      <th>...</th>\n",
       "      <th>frequency</th>\n",
       "      <th>velocity_resolution</th>\n",
       "      <th>obs_creator_name</th>\n",
       "      <th>pub_title</th>\n",
       "      <th>first_author</th>\n",
       "      <th>qa2_passed</th>\n",
       "      <th>bib_reference</th>\n",
       "      <th>science_keyword</th>\n",
       "      <th>scientific_category</th>\n",
       "      <th>lastModified</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>http://almascience.org/aq?member_ous_id=uid://...</td>\n",
       "      <td>text/html</td>\n",
       "      <td>2011.0.00008.SV</td>\n",
       "      <td>Public</td>\n",
       "      <td>309.512363</td>\n",
       "      <td>19.416239</td>\n",
       "      <td>ADS/JAO.ALMA#2011.0.00008.SV</td>\n",
       "      <td>ALMA</td>\n",
       "      <td>JAO</td>\n",
       "      <td>ALMA</td>\n",
       "      <td>...</td>\n",
       "      <td>238.261613</td>\n",
       "      <td>1183.847494</td>\n",
       "      <td>observatory, ALMA</td>\n",
       "      <td>ALMA Observations of the Physical and Chemical...</td>\n",
       "      <td>Azeez, Jazeel H. Israel, F. P. McCoy, Mark</td>\n",
       "      <td>T</td>\n",
       "      <td>2014A&amp;A...562A..96I 2017AdAst2017E...6A 2017Ap...</td>\n",
       "      <td>Galactic centres/nuclei, Active Galactic Nucle...</td>\n",
       "      <td>Active galaxies</td>\n",
       "      <td>2021-09-30T16:34:41.133</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>http://almascience.org/aq?member_ous_id=uid://...</td>\n",
       "      <td>text/html</td>\n",
       "      <td>2011.0.00008.SV</td>\n",
       "      <td>Public</td>\n",
       "      <td>309.512363</td>\n",
       "      <td>19.416239</td>\n",
       "      <td>ADS/JAO.ALMA#2011.0.00008.SV</td>\n",
       "      <td>ALMA</td>\n",
       "      <td>JAO</td>\n",
       "      <td>ALMA</td>\n",
       "      <td>...</td>\n",
       "      <td>238.261613</td>\n",
       "      <td>1183.847494</td>\n",
       "      <td>observatory, ALMA</td>\n",
       "      <td>ALMA Observations of the Physical and Chemical...</td>\n",
       "      <td>Azeez, Jazeel H. Israel, F. P. McCoy, Mark</td>\n",
       "      <td>T</td>\n",
       "      <td>2014A&amp;A...562A..96I 2017AdAst2017E...6A 2017Ap...</td>\n",
       "      <td>Galactic centres/nuclei, Active Galactic Nucle...</td>\n",
       "      <td>Active galaxies</td>\n",
       "      <td>2021-09-30T16:34:41.133</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>http://almascience.org/aq?member_ous_id=uid://...</td>\n",
       "      <td>text/html</td>\n",
       "      <td>2011.0.00008.SV</td>\n",
       "      <td>Public</td>\n",
       "      <td>309.512363</td>\n",
       "      <td>19.416239</td>\n",
       "      <td>ADS/JAO.ALMA#2011.0.00008.SV</td>\n",
       "      <td>ALMA</td>\n",
       "      <td>JAO</td>\n",
       "      <td>ALMA</td>\n",
       "      <td>...</td>\n",
       "      <td>238.261613</td>\n",
       "      <td>1183.847494</td>\n",
       "      <td>observatory, ALMA</td>\n",
       "      <td>ALMA Observations of the Physical and Chemical...</td>\n",
       "      <td>Azeez, Jazeel H. Israel, F. P. McCoy, Mark</td>\n",
       "      <td>T</td>\n",
       "      <td>2014A&amp;A...562A..96I 2017AdAst2017E...6A 2017Ap...</td>\n",
       "      <td>Galactic centres/nuclei, Active Galactic Nucle...</td>\n",
       "      <td>Active galaxies</td>\n",
       "      <td>2021-09-30T16:34:41.133</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>http://almascience.org/aq?member_ous_id=uid://...</td>\n",
       "      <td>text/html</td>\n",
       "      <td>2011.0.00008.SV</td>\n",
       "      <td>Public</td>\n",
       "      <td>309.512363</td>\n",
       "      <td>19.416239</td>\n",
       "      <td>ADS/JAO.ALMA#2011.0.00008.SV</td>\n",
       "      <td>ALMA</td>\n",
       "      <td>JAO</td>\n",
       "      <td>ALMA</td>\n",
       "      <td>...</td>\n",
       "      <td>238.261613</td>\n",
       "      <td>1183.847494</td>\n",
       "      <td>observatory, ALMA</td>\n",
       "      <td>ALMA Observations of the Physical and Chemical...</td>\n",
       "      <td>Azeez, Jazeel H. Israel, F. P. McCoy, Mark</td>\n",
       "      <td>T</td>\n",
       "      <td>2014A&amp;A...562A..96I 2017AdAst2017E...6A 2017Ap...</td>\n",
       "      <td>Galactic centres/nuclei, Active Galactic Nucle...</td>\n",
       "      <td>Active galaxies</td>\n",
       "      <td>2021-09-30T16:34:41.133</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>http://almascience.org/aq?member_ous_id=uid://...</td>\n",
       "      <td>text/html</td>\n",
       "      <td>2011.0.00010.S</td>\n",
       "      <td>Public</td>\n",
       "      <td>309.515914</td>\n",
       "      <td>19.417224</td>\n",
       "      <td>ADS/JAO.ALMA#2011.0.00010.S</td>\n",
       "      <td>ALMA</td>\n",
       "      <td>JAO</td>\n",
       "      <td>ALMA</td>\n",
       "      <td>...</td>\n",
       "      <td>219.025328</td>\n",
       "      <td>663.940713</td>\n",
       "      <td>Ott, Juergen</td>\n",
       "      <td>ALMA Observations of the Physical and Chemical...</td>\n",
       "      <td>McCoy, Mark</td>\n",
       "      <td>T</td>\n",
       "      <td>2017ApJ...851...76M</td>\n",
       "      <td>Active Galactic Nuclei (AGN)/Quasars (QSO), Me...</td>\n",
       "      <td>Active galaxies</td>\n",
       "      <td>2021-09-30T16:34:41.133</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 63 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                          access_url access_format  \\\n",
       "0  http://almascience.org/aq?member_ous_id=uid://...     text/html   \n",
       "1  http://almascience.org/aq?member_ous_id=uid://...     text/html   \n",
       "2  http://almascience.org/aq?member_ous_id=uid://...     text/html   \n",
       "3  http://almascience.org/aq?member_ous_id=uid://...     text/html   \n",
       "4  http://almascience.org/aq?member_ous_id=uid://...     text/html   \n",
       "\n",
       "       proposal_id data_rights  gal_longitude  gal_latitude  \\\n",
       "0  2011.0.00008.SV      Public     309.512363     19.416239   \n",
       "1  2011.0.00008.SV      Public     309.512363     19.416239   \n",
       "2  2011.0.00008.SV      Public     309.512363     19.416239   \n",
       "3  2011.0.00008.SV      Public     309.512363     19.416239   \n",
       "4   2011.0.00010.S      Public     309.515914     19.417224   \n",
       "\n",
       "              obs_publisher_did obs_collection facility_name instrument_name  \\\n",
       "0  ADS/JAO.ALMA#2011.0.00008.SV           ALMA           JAO            ALMA   \n",
       "1  ADS/JAO.ALMA#2011.0.00008.SV           ALMA           JAO            ALMA   \n",
       "2  ADS/JAO.ALMA#2011.0.00008.SV           ALMA           JAO            ALMA   \n",
       "3  ADS/JAO.ALMA#2011.0.00008.SV           ALMA           JAO            ALMA   \n",
       "4   ADS/JAO.ALMA#2011.0.00010.S           ALMA           JAO            ALMA   \n",
       "\n",
       "   ...   frequency velocity_resolution   obs_creator_name  \\\n",
       "0  ...  238.261613         1183.847494  observatory, ALMA   \n",
       "1  ...  238.261613         1183.847494  observatory, ALMA   \n",
       "2  ...  238.261613         1183.847494  observatory, ALMA   \n",
       "3  ...  238.261613         1183.847494  observatory, ALMA   \n",
       "4  ...  219.025328          663.940713       Ott, Juergen   \n",
       "\n",
       "                                           pub_title  \\\n",
       "0  ALMA Observations of the Physical and Chemical...   \n",
       "1  ALMA Observations of the Physical and Chemical...   \n",
       "2  ALMA Observations of the Physical and Chemical...   \n",
       "3  ALMA Observations of the Physical and Chemical...   \n",
       "4  ALMA Observations of the Physical and Chemical...   \n",
       "\n",
       "                                 first_author  qa2_passed  \\\n",
       "0  Azeez, Jazeel H. Israel, F. P. McCoy, Mark           T   \n",
       "1  Azeez, Jazeel H. Israel, F. P. McCoy, Mark           T   \n",
       "2  Azeez, Jazeel H. Israel, F. P. McCoy, Mark           T   \n",
       "3  Azeez, Jazeel H. Israel, F. P. McCoy, Mark           T   \n",
       "4                                 McCoy, Mark           T   \n",
       "\n",
       "                                       bib_reference  \\\n",
       "0  2014A&A...562A..96I 2017AdAst2017E...6A 2017Ap...   \n",
       "1  2014A&A...562A..96I 2017AdAst2017E...6A 2017Ap...   \n",
       "2  2014A&A...562A..96I 2017AdAst2017E...6A 2017Ap...   \n",
       "3  2014A&A...562A..96I 2017AdAst2017E...6A 2017Ap...   \n",
       "4                                2017ApJ...851...76M   \n",
       "\n",
       "                                     science_keyword  scientific_category  \\\n",
       "0  Galactic centres/nuclei, Active Galactic Nucle...      Active galaxies   \n",
       "1  Galactic centres/nuclei, Active Galactic Nucle...      Active galaxies   \n",
       "2  Galactic centres/nuclei, Active Galactic Nucle...      Active galaxies   \n",
       "3  Galactic centres/nuclei, Active Galactic Nucle...      Active galaxies   \n",
       "4  Active Galactic Nuclei (AGN)/Quasars (QSO), Me...      Active galaxies   \n",
       "\n",
       "              lastModified  \n",
       "0  2021-09-30T16:34:41.133  \n",
       "1  2021-09-30T16:34:41.133  \n",
       "2  2021-09-30T16:34:41.133  \n",
       "3  2021-09-30T16:34:41.133  \n",
       "4  2021-09-30T16:34:41.133  \n",
       "\n",
       "[5 rows x 63 columns]"
      ]
     },
     "execution_count": 1,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "results = query_coordinate(service, 201.365, -43.019, 0.006)\n",
    "results.head(5)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "The same query but now adding the distance column:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "execution": {
     "iopub.execute_input": "2021-11-16T10:25:49.371972Z",
     "iopub.status.busy": "2021-11-16T10:25:49.371248Z",
     "iopub.status.idle": "2021-11-16T10:25:49.808540Z",
     "shell.execute_reply": "2021-11-16T10:25:49.808001Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>dist</th>\n",
       "      <th>access_url</th>\n",
       "      <th>access_format</th>\n",
       "      <th>proposal_id</th>\n",
       "      <th>data_rights</th>\n",
       "      <th>gal_longitude</th>\n",
       "      <th>gal_latitude</th>\n",
       "      <th>obs_publisher_did</th>\n",
       "      <th>obs_collection</th>\n",
       "      <th>facility_name</th>\n",
       "      <th>instrument_name</th>\n",
       "      <th>obs_id</th>\n",
       "      <th>dataproduct_type</th>\n",
       "      <th>calib_level</th>\n",
       "      <th>target_name</th>\n",
       "      <th>s_ra</th>\n",
       "      <th>s_dec</th>\n",
       "      <th>s_fov</th>\n",
       "      <th>s_region</th>\n",
       "      <th>s_resolution</th>\n",
       "      <th>t_min</th>\n",
       "      <th>t_max</th>\n",
       "      <th>t_exptime</th>\n",
       "      <th>t_resolution</th>\n",
       "      <th>em_min</th>\n",
       "      <th>em_max</th>\n",
       "      <th>em_res_power</th>\n",
       "      <th>pol_states</th>\n",
       "      <th>o_ucd</th>\n",
       "      <th>band_list</th>\n",
       "      <th>em_resolution</th>\n",
       "      <th>authors</th>\n",
       "      <th>pub_abstract</th>\n",
       "      <th>publication_year</th>\n",
       "      <th>proposal_abstract</th>\n",
       "      <th>schedblock_name</th>\n",
       "      <th>proposal_authors</th>\n",
       "      <th>sensitivity_10kms</th>\n",
       "      <th>cont_sensitivity_bandwidth</th>\n",
       "      <th>pwv</th>\n",
       "      <th>group_ous_uid</th>\n",
       "      <th>member_ous_uid</th>\n",
       "      <th>asdm_uid</th>\n",
       "      <th>obs_title</th>\n",
       "      <th>type</th>\n",
       "      <th>scan_intent</th>\n",
       "      <th>science_observation</th>\n",
       "      <th>spatial_scale_max</th>\n",
       "      <th>bandwidth</th>\n",
       "      <th>antenna_arrays</th>\n",
       "      <th>is_mosaic</th>\n",
       "      <th>obs_release_date</th>\n",
       "      <th>spatial_resolution</th>\n",
       "      <th>frequency_support</th>\n",
       "      <th>frequency</th>\n",
       "      <th>velocity_resolution</th>\n",
       "      <th>obs_creator_name</th>\n",
       "      <th>pub_title</th>\n",
       "      <th>first_author</th>\n",
       "      <th>qa2_passed</th>\n",
       "      <th>bib_reference</th>\n",
       "      <th>science_keyword</th>\n",
       "      <th>scientific_category</th>\n",
       "      <th>lastModified</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1.484554</td>\n",
       "      <td>http://almascience.org/aq?member_ous_id=uid://...</td>\n",
       "      <td>text/html</td>\n",
       "      <td>2012.1.00225.S</td>\n",
       "      <td>Public</td>\n",
       "      <td>309.515896</td>\n",
       "      <td>19.417338</td>\n",
       "      <td>ADS/JAO.ALMA#2012.1.00225.S</td>\n",
       "      <td>ALMA</td>\n",
       "      <td>JAO</td>\n",
       "      <td>ALMA</td>\n",
       "      <td>uid://A002/X7d1738/X58</td>\n",
       "      <td>cube</td>\n",
       "      <td>2</td>\n",
       "      <td>Centaurus_a</td>\n",
       "      <td>201.365018</td>\n",
       "      <td>-43.019002</td>\n",
       "      <td>0.018076</td>\n",
       "      <td>Circle ICRS 201.365018 -43.019002 0.009038</td>\n",
       "      <td>1.170768</td>\n",
       "      <td>56815.888687</td>\n",
       "      <td>56815.901698</td>\n",
       "      <td>211.680</td>\n",
       "      <td>211.680</td>\n",
       "      <td>0.003338</td>\n",
       "      <td>0.003374</td>\n",
       "      <td>183907.921659</td>\n",
       "      <td>/XX/YY/</td>\n",
       "      <td>phot.flux.density;phys.polarization</td>\n",
       "      <td>3</td>\n",
       "      <td>613.938003</td>\n",
       "      <td>Espada, D.; Matsushita, S.; Miura, R. E.; Isra...</td>\n",
       "      <td>Previous investigations have employed more tha...</td>\n",
       "      <td>2016</td>\n",
       "      <td>In powerful radio-galaxies the properties of t...</td>\n",
       "      <td>Cen_a_b3</td>\n",
       "      <td>Wiklind, Tommy; Matsushita, Satoki; Impellizze...</td>\n",
       "      <td>1.940705</td>\n",
       "      <td>0.063029</td>\n",
       "      <td>1.475880</td>\n",
       "      <td>uid://A002/X7d1738/X57</td>\n",
       "      <td>uid://A002/X7d1738/X58</td>\n",
       "      <td>uid://A002/X839000/Xb6f</td>\n",
       "      <td>The Warm/Dense Circumnuclear Disk and Black Ho...</td>\n",
       "      <td>S</td>\n",
       "      <td>TARGET WVR</td>\n",
       "      <td>T</td>\n",
       "      <td>10.290043</td>\n",
       "      <td>9.375000e+08</td>\n",
       "      <td>A007:DV23 A010:DV12 A011:DV22 A016:DA62 A019:D...</td>\n",
       "      <td>F</td>\n",
       "      <td>2015-08-19T19:15:57.000</td>\n",
       "      <td>1.170768</td>\n",
       "      <td>[88.00..88.94GHz,488.28kHz,1.9mJy/beam@10km/s,...</td>\n",
       "      <td>89.484582</td>\n",
       "      <td>1609.278532</td>\n",
       "      <td>Espada, Daniel</td>\n",
       "      <td>ALMACAL I: First Dual-band Number Counts from ...</td>\n",
       "      <td>Espada, D. Oteo, I. Thelen, Alexander E.</td>\n",
       "      <td>T</td>\n",
       "      <td>2016ApJ...822...36O 2017ApJ...843..136E 2019Ic...</td>\n",
       "      <td>Active Galactic Nuclei (AGN)/Quasars (QSO), Ou...</td>\n",
       "      <td>Active galaxies</td>\n",
       "      <td>2021-09-30T16:34:41.133</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1.484554</td>\n",
       "      <td>http://almascience.org/aq?member_ous_id=uid://...</td>\n",
       "      <td>text/html</td>\n",
       "      <td>2012.1.00225.S</td>\n",
       "      <td>Public</td>\n",
       "      <td>309.515896</td>\n",
       "      <td>19.417338</td>\n",
       "      <td>ADS/JAO.ALMA#2012.1.00225.S</td>\n",
       "      <td>ALMA</td>\n",
       "      <td>JAO</td>\n",
       "      <td>ALMA</td>\n",
       "      <td>uid://A002/X7d1738/X58</td>\n",
       "      <td>cube</td>\n",
       "      <td>2</td>\n",
       "      <td>Centaurus_a</td>\n",
       "      <td>201.365018</td>\n",
       "      <td>-43.019002</td>\n",
       "      <td>0.018076</td>\n",
       "      <td>Circle ICRS 201.365018 -43.019002 0.009038</td>\n",
       "      <td>1.170768</td>\n",
       "      <td>56815.888687</td>\n",
       "      <td>56815.901698</td>\n",
       "      <td>211.680</td>\n",
       "      <td>211.680</td>\n",
       "      <td>0.003371</td>\n",
       "      <td>0.003407</td>\n",
       "      <td>182136.313740</td>\n",
       "      <td>/XX/YY/</td>\n",
       "      <td>phot.flux.density;phys.polarization</td>\n",
       "      <td>3</td>\n",
       "      <td>613.938003</td>\n",
       "      <td>Espada, D.; Matsushita, S.; Miura, R. E.; Isra...</td>\n",
       "      <td>Previous investigations have employed more tha...</td>\n",
       "      <td>2016</td>\n",
       "      <td>In powerful radio-galaxies the properties of t...</td>\n",
       "      <td>Cen_a_b3</td>\n",
       "      <td>Wiklind, Tommy; Matsushita, Satoki; Impellizze...</td>\n",
       "      <td>1.936746</td>\n",
       "      <td>0.063029</td>\n",
       "      <td>1.475880</td>\n",
       "      <td>uid://A002/X7d1738/X57</td>\n",
       "      <td>uid://A002/X7d1738/X58</td>\n",
       "      <td>uid://A002/X839000/Xb6f</td>\n",
       "      <td>The Warm/Dense Circumnuclear Disk and Black Ho...</td>\n",
       "      <td>S</td>\n",
       "      <td>TARGET WVR</td>\n",
       "      <td>T</td>\n",
       "      <td>10.290043</td>\n",
       "      <td>9.375000e+08</td>\n",
       "      <td>A007:DV23 A010:DV12 A011:DV22 A016:DA62 A019:D...</td>\n",
       "      <td>F</td>\n",
       "      <td>2015-08-19T19:15:57.000</td>\n",
       "      <td>1.170768</td>\n",
       "      <td>[88.00..88.94GHz,488.28kHz,1.9mJy/beam@10km/s,...</td>\n",
       "      <td>89.484582</td>\n",
       "      <td>1609.278532</td>\n",
       "      <td>Espada, Daniel</td>\n",
       "      <td>ALMACAL I: First Dual-band Number Counts from ...</td>\n",
       "      <td>Espada, D. Oteo, I. Thelen, Alexander E.</td>\n",
       "      <td>T</td>\n",
       "      <td>2016ApJ...822...36O 2017ApJ...843..136E 2019Ic...</td>\n",
       "      <td>Active Galactic Nuclei (AGN)/Quasars (QSO), Ou...</td>\n",
       "      <td>Active galaxies</td>\n",
       "      <td>2021-09-30T16:34:41.133</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1.484554</td>\n",
       "      <td>http://almascience.org/aq?member_ous_id=uid://...</td>\n",
       "      <td>text/html</td>\n",
       "      <td>2012.1.00225.S</td>\n",
       "      <td>Public</td>\n",
       "      <td>309.515896</td>\n",
       "      <td>19.417338</td>\n",
       "      <td>ADS/JAO.ALMA#2012.1.00225.S</td>\n",
       "      <td>ALMA</td>\n",
       "      <td>JAO</td>\n",
       "      <td>ALMA</td>\n",
       "      <td>uid://A002/X7d1738/X58</td>\n",
       "      <td>cube</td>\n",
       "      <td>2</td>\n",
       "      <td>Centaurus_a</td>\n",
       "      <td>201.365018</td>\n",
       "      <td>-43.019002</td>\n",
       "      <td>0.018076</td>\n",
       "      <td>Circle ICRS 201.365018 -43.019002 0.009038</td>\n",
       "      <td>1.170768</td>\n",
       "      <td>56815.888687</td>\n",
       "      <td>56815.901698</td>\n",
       "      <td>211.680</td>\n",
       "      <td>211.680</td>\n",
       "      <td>0.003296</td>\n",
       "      <td>0.003330</td>\n",
       "      <td>186289.975282</td>\n",
       "      <td>/XX/YY/</td>\n",
       "      <td>phot.flux.density;phys.polarization</td>\n",
       "      <td>3</td>\n",
       "      <td>613.938003</td>\n",
       "      <td>Espada, D.; Matsushita, S.; Miura, R. E.; Isra...</td>\n",
       "      <td>Previous investigations have employed more tha...</td>\n",
       "      <td>2016</td>\n",
       "      <td>In powerful radio-galaxies the properties of t...</td>\n",
       "      <td>Cen_a_b3</td>\n",
       "      <td>Wiklind, Tommy; Matsushita, Satoki; Impellizze...</td>\n",
       "      <td>1.928636</td>\n",
       "      <td>0.063029</td>\n",
       "      <td>1.475880</td>\n",
       "      <td>uid://A002/X7d1738/X57</td>\n",
       "      <td>uid://A002/X7d1738/X58</td>\n",
       "      <td>uid://A002/X839000/Xb6f</td>\n",
       "      <td>The Warm/Dense Circumnuclear Disk and Black Ho...</td>\n",
       "      <td>S</td>\n",
       "      <td>TARGET WVR</td>\n",
       "      <td>T</td>\n",
       "      <td>10.290043</td>\n",
       "      <td>9.375000e+08</td>\n",
       "      <td>A007:DV23 A010:DV12 A011:DV22 A016:DA62 A019:D...</td>\n",
       "      <td>F</td>\n",
       "      <td>2015-08-19T19:15:57.000</td>\n",
       "      <td>1.170768</td>\n",
       "      <td>[88.00..88.94GHz,488.28kHz,1.9mJy/beam@10km/s,...</td>\n",
       "      <td>89.484582</td>\n",
       "      <td>1609.278532</td>\n",
       "      <td>Espada, Daniel</td>\n",
       "      <td>ALMACAL I: First Dual-band Number Counts from ...</td>\n",
       "      <td>Espada, D. Oteo, I. Thelen, Alexander E.</td>\n",
       "      <td>T</td>\n",
       "      <td>2016ApJ...822...36O 2017ApJ...843..136E 2019Ic...</td>\n",
       "      <td>Active Galactic Nuclei (AGN)/Quasars (QSO), Ou...</td>\n",
       "      <td>Active galaxies</td>\n",
       "      <td>2021-09-30T16:34:41.133</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>5.772087</td>\n",
       "      <td>http://almascience.org/aq?member_ous_id=uid://...</td>\n",
       "      <td>text/html</td>\n",
       "      <td>2012.1.00225.S</td>\n",
       "      <td>Public</td>\n",
       "      <td>309.515937</td>\n",
       "      <td>19.417346</td>\n",
       "      <td>ADS/JAO.ALMA#2012.1.00225.S</td>\n",
       "      <td>ALMA</td>\n",
       "      <td>JAO</td>\n",
       "      <td>ALMA</td>\n",
       "      <td>uid://A002/X7d1738/Xf8</td>\n",
       "      <td>cube</td>\n",
       "      <td>2</td>\n",
       "      <td>Centaurus_a</td>\n",
       "      <td>201.365069</td>\n",
       "      <td>-43.018989</td>\n",
       "      <td>0.009992</td>\n",
       "      <td>Polygon ICRS 201.368089 -43.022662 201.367662 ...</td>\n",
       "      <td>0.165660</td>\n",
       "      <td>56761.195098</td>\n",
       "      <td>56761.420462</td>\n",
       "      <td>462.729</td>\n",
       "      <td>462.729</td>\n",
       "      <td>0.000434</td>\n",
       "      <td>0.000435</td>\n",
       "      <td>707749.592794</td>\n",
       "      <td>/XX/YY/</td>\n",
       "      <td>phot.flux.density;phys.polarization</td>\n",
       "      <td>9</td>\n",
       "      <td>306.991286</td>\n",
       "      <td>Espada, D.; Matsushita, S.; Miura, R. E.; Isra...</td>\n",
       "      <td>Previous investigations have employed more tha...</td>\n",
       "      <td>2016</td>\n",
       "      <td>In powerful radio-galaxies the properties of t...</td>\n",
       "      <td>Cen_a_b9</td>\n",
       "      <td>Wiklind, Tommy; Matsushita, Satoki; Impellizze...</td>\n",
       "      <td>10.803344</td>\n",
       "      <td>0.593166</td>\n",
       "      <td>0.345651</td>\n",
       "      <td>uid://A002/X7d1738/Xf7</td>\n",
       "      <td>uid://A002/X7d1738/Xf8</td>\n",
       "      <td>uid://A002/X7f18fb/X1486</td>\n",
       "      <td>The Warm/Dense Circumnuclear Disk and Black Ho...</td>\n",
       "      <td>S</td>\n",
       "      <td>PHASE TARGET WVR</td>\n",
       "      <td>T</td>\n",
       "      <td>1.425521</td>\n",
       "      <td>1.875000e+09</td>\n",
       "      <td>A006:DV07 A010:DV12 A016:DA62 A018:DA60 A021:D...</td>\n",
       "      <td>T</td>\n",
       "      <td>2015-10-09T14:42:25.000</td>\n",
       "      <td>0.165660</td>\n",
       "      <td>[689.28..691.15GHz,976.56kHz,10.8mJy/beam@10km...</td>\n",
       "      <td>698.902241</td>\n",
       "      <td>413.199446</td>\n",
       "      <td>Espada, Daniel</td>\n",
       "      <td>ALMACAL I: First Dual-band Number Counts from ...</td>\n",
       "      <td>Espada, D. Oteo, I. Thelen, Alexander E.</td>\n",
       "      <td>T</td>\n",
       "      <td>2016ApJ...822...36O 2017ApJ...843..136E 2019Ic...</td>\n",
       "      <td>Active Galactic Nuclei (AGN)/Quasars (QSO), Ou...</td>\n",
       "      <td>Active galaxies</td>\n",
       "      <td>2021-09-30T16:34:41.133</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5.772087</td>\n",
       "      <td>http://almascience.org/aq?member_ous_id=uid://...</td>\n",
       "      <td>text/html</td>\n",
       "      <td>2012.1.00225.S</td>\n",
       "      <td>Public</td>\n",
       "      <td>309.515937</td>\n",
       "      <td>19.417346</td>\n",
       "      <td>ADS/JAO.ALMA#2012.1.00225.S</td>\n",
       "      <td>ALMA</td>\n",
       "      <td>JAO</td>\n",
       "      <td>ALMA</td>\n",
       "      <td>uid://A002/X7d1738/Xf8</td>\n",
       "      <td>cube</td>\n",
       "      <td>2</td>\n",
       "      <td>Centaurus_a</td>\n",
       "      <td>201.365069</td>\n",
       "      <td>-43.018989</td>\n",
       "      <td>0.009992</td>\n",
       "      <td>Polygon ICRS 201.368089 -43.022662 201.367662 ...</td>\n",
       "      <td>0.165660</td>\n",
       "      <td>56761.195098</td>\n",
       "      <td>56761.420462</td>\n",
       "      <td>462.729</td>\n",
       "      <td>462.729</td>\n",
       "      <td>0.000425</td>\n",
       "      <td>0.000426</td>\n",
       "      <td>721784.342900</td>\n",
       "      <td>/XX/YY/</td>\n",
       "      <td>phot.flux.density;phys.polarization</td>\n",
       "      <td>9</td>\n",
       "      <td>306.991286</td>\n",
       "      <td>Espada, D.; Matsushita, S.; Miura, R. E.; Isra...</td>\n",
       "      <td>Previous investigations have employed more tha...</td>\n",
       "      <td>2016</td>\n",
       "      <td>In powerful radio-galaxies the properties of t...</td>\n",
       "      <td>Cen_a_b9</td>\n",
       "      <td>Wiklind, Tommy; Matsushita, Satoki; Impellizze...</td>\n",
       "      <td>10.463668</td>\n",
       "      <td>0.593166</td>\n",
       "      <td>0.345651</td>\n",
       "      <td>uid://A002/X7d1738/Xf7</td>\n",
       "      <td>uid://A002/X7d1738/Xf8</td>\n",
       "      <td>uid://A002/X7f18fb/X1486</td>\n",
       "      <td>The Warm/Dense Circumnuclear Disk and Black Ho...</td>\n",
       "      <td>S</td>\n",
       "      <td>PHASE TARGET WVR</td>\n",
       "      <td>T</td>\n",
       "      <td>1.425521</td>\n",
       "      <td>1.875000e+09</td>\n",
       "      <td>A006:DV07 A010:DV12 A016:DA62 A018:DA60 A021:D...</td>\n",
       "      <td>T</td>\n",
       "      <td>2015-10-09T14:42:25.000</td>\n",
       "      <td>0.165660</td>\n",
       "      <td>[689.28..691.15GHz,976.56kHz,10.8mJy/beam@10km...</td>\n",
       "      <td>698.902241</td>\n",
       "      <td>413.199446</td>\n",
       "      <td>Espada, Daniel</td>\n",
       "      <td>ALMACAL I: First Dual-band Number Counts from ...</td>\n",
       "      <td>Espada, D. Oteo, I. Thelen, Alexander E.</td>\n",
       "      <td>T</td>\n",
       "      <td>2016ApJ...822...36O 2017ApJ...843..136E 2019Ic...</td>\n",
       "      <td>Active Galactic Nuclei (AGN)/Quasars (QSO), Ou...</td>\n",
       "      <td>Active galaxies</td>\n",
       "      <td>2021-09-30T16:34:41.133</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       dist                                         access_url access_format  \\\n",
       "0  1.484554  http://almascience.org/aq?member_ous_id=uid://...     text/html   \n",
       "1  1.484554  http://almascience.org/aq?member_ous_id=uid://...     text/html   \n",
       "2  1.484554  http://almascience.org/aq?member_ous_id=uid://...     text/html   \n",
       "3  5.772087  http://almascience.org/aq?member_ous_id=uid://...     text/html   \n",
       "4  5.772087  http://almascience.org/aq?member_ous_id=uid://...     text/html   \n",
       "\n",
       "      proposal_id data_rights  gal_longitude  gal_latitude  \\\n",
       "0  2012.1.00225.S      Public     309.515896     19.417338   \n",
       "1  2012.1.00225.S      Public     309.515896     19.417338   \n",
       "2  2012.1.00225.S      Public     309.515896     19.417338   \n",
       "3  2012.1.00225.S      Public     309.515937     19.417346   \n",
       "4  2012.1.00225.S      Public     309.515937     19.417346   \n",
       "\n",
       "             obs_publisher_did obs_collection facility_name instrument_name  \\\n",
       "0  ADS/JAO.ALMA#2012.1.00225.S           ALMA           JAO            ALMA   \n",
       "1  ADS/JAO.ALMA#2012.1.00225.S           ALMA           JAO            ALMA   \n",
       "2  ADS/JAO.ALMA#2012.1.00225.S           ALMA           JAO            ALMA   \n",
       "3  ADS/JAO.ALMA#2012.1.00225.S           ALMA           JAO            ALMA   \n",
       "4  ADS/JAO.ALMA#2012.1.00225.S           ALMA           JAO            ALMA   \n",
       "\n",
       "                   obs_id dataproduct_type  calib_level  target_name  \\\n",
       "0  uid://A002/X7d1738/X58             cube            2  Centaurus_a   \n",
       "1  uid://A002/X7d1738/X58             cube            2  Centaurus_a   \n",
       "2  uid://A002/X7d1738/X58             cube            2  Centaurus_a   \n",
       "3  uid://A002/X7d1738/Xf8             cube            2  Centaurus_a   \n",
       "4  uid://A002/X7d1738/Xf8             cube            2  Centaurus_a   \n",
       "\n",
       "         s_ra      s_dec     s_fov  \\\n",
       "0  201.365018 -43.019002  0.018076   \n",
       "1  201.365018 -43.019002  0.018076   \n",
       "2  201.365018 -43.019002  0.018076   \n",
       "3  201.365069 -43.018989  0.009992   \n",
       "4  201.365069 -43.018989  0.009992   \n",
       "\n",
       "                                            s_region  s_resolution  \\\n",
       "0         Circle ICRS 201.365018 -43.019002 0.009038      1.170768   \n",
       "1         Circle ICRS 201.365018 -43.019002 0.009038      1.170768   \n",
       "2         Circle ICRS 201.365018 -43.019002 0.009038      1.170768   \n",
       "3  Polygon ICRS 201.368089 -43.022662 201.367662 ...      0.165660   \n",
       "4  Polygon ICRS 201.368089 -43.022662 201.367662 ...      0.165660   \n",
       "\n",
       "          t_min         t_max  t_exptime  t_resolution    em_min    em_max  \\\n",
       "0  56815.888687  56815.901698    211.680       211.680  0.003338  0.003374   \n",
       "1  56815.888687  56815.901698    211.680       211.680  0.003371  0.003407   \n",
       "2  56815.888687  56815.901698    211.680       211.680  0.003296  0.003330   \n",
       "3  56761.195098  56761.420462    462.729       462.729  0.000434  0.000435   \n",
       "4  56761.195098  56761.420462    462.729       462.729  0.000425  0.000426   \n",
       "\n",
       "    em_res_power pol_states                                o_ucd band_list  \\\n",
       "0  183907.921659    /XX/YY/  phot.flux.density;phys.polarization         3   \n",
       "1  182136.313740    /XX/YY/  phot.flux.density;phys.polarization         3   \n",
       "2  186289.975282    /XX/YY/  phot.flux.density;phys.polarization         3   \n",
       "3  707749.592794    /XX/YY/  phot.flux.density;phys.polarization         9   \n",
       "4  721784.342900    /XX/YY/  phot.flux.density;phys.polarization         9   \n",
       "\n",
       "   em_resolution                                            authors  \\\n",
       "0     613.938003  Espada, D.; Matsushita, S.; Miura, R. E.; Isra...   \n",
       "1     613.938003  Espada, D.; Matsushita, S.; Miura, R. E.; Isra...   \n",
       "2     613.938003  Espada, D.; Matsushita, S.; Miura, R. E.; Isra...   \n",
       "3     306.991286  Espada, D.; Matsushita, S.; Miura, R. E.; Isra...   \n",
       "4     306.991286  Espada, D.; Matsushita, S.; Miura, R. E.; Isra...   \n",
       "\n",
       "                                        pub_abstract  publication_year  \\\n",
       "0  Previous investigations have employed more tha...              2016   \n",
       "1  Previous investigations have employed more tha...              2016   \n",
       "2  Previous investigations have employed more tha...              2016   \n",
       "3  Previous investigations have employed more tha...              2016   \n",
       "4  Previous investigations have employed more tha...              2016   \n",
       "\n",
       "                                   proposal_abstract schedblock_name  \\\n",
       "0  In powerful radio-galaxies the properties of t...        Cen_a_b3   \n",
       "1  In powerful radio-galaxies the properties of t...        Cen_a_b3   \n",
       "2  In powerful radio-galaxies the properties of t...        Cen_a_b3   \n",
       "3  In powerful radio-galaxies the properties of t...        Cen_a_b9   \n",
       "4  In powerful radio-galaxies the properties of t...        Cen_a_b9   \n",
       "\n",
       "                                    proposal_authors  sensitivity_10kms  \\\n",
       "0  Wiklind, Tommy; Matsushita, Satoki; Impellizze...           1.940705   \n",
       "1  Wiklind, Tommy; Matsushita, Satoki; Impellizze...           1.936746   \n",
       "2  Wiklind, Tommy; Matsushita, Satoki; Impellizze...           1.928636   \n",
       "3  Wiklind, Tommy; Matsushita, Satoki; Impellizze...          10.803344   \n",
       "4  Wiklind, Tommy; Matsushita, Satoki; Impellizze...          10.463668   \n",
       "\n",
       "   cont_sensitivity_bandwidth       pwv           group_ous_uid  \\\n",
       "0                    0.063029  1.475880  uid://A002/X7d1738/X57   \n",
       "1                    0.063029  1.475880  uid://A002/X7d1738/X57   \n",
       "2                    0.063029  1.475880  uid://A002/X7d1738/X57   \n",
       "3                    0.593166  0.345651  uid://A002/X7d1738/Xf7   \n",
       "4                    0.593166  0.345651  uid://A002/X7d1738/Xf7   \n",
       "\n",
       "           member_ous_uid                  asdm_uid  \\\n",
       "0  uid://A002/X7d1738/X58   uid://A002/X839000/Xb6f   \n",
       "1  uid://A002/X7d1738/X58   uid://A002/X839000/Xb6f   \n",
       "2  uid://A002/X7d1738/X58   uid://A002/X839000/Xb6f   \n",
       "3  uid://A002/X7d1738/Xf8  uid://A002/X7f18fb/X1486   \n",
       "4  uid://A002/X7d1738/Xf8  uid://A002/X7f18fb/X1486   \n",
       "\n",
       "                                           obs_title type       scan_intent  \\\n",
       "0  The Warm/Dense Circumnuclear Disk and Black Ho...    S        TARGET WVR   \n",
       "1  The Warm/Dense Circumnuclear Disk and Black Ho...    S        TARGET WVR   \n",
       "2  The Warm/Dense Circumnuclear Disk and Black Ho...    S        TARGET WVR   \n",
       "3  The Warm/Dense Circumnuclear Disk and Black Ho...    S  PHASE TARGET WVR   \n",
       "4  The Warm/Dense Circumnuclear Disk and Black Ho...    S  PHASE TARGET WVR   \n",
       "\n",
       "  science_observation  spatial_scale_max     bandwidth  \\\n",
       "0                   T          10.290043  9.375000e+08   \n",
       "1                   T          10.290043  9.375000e+08   \n",
       "2                   T          10.290043  9.375000e+08   \n",
       "3                   T           1.425521  1.875000e+09   \n",
       "4                   T           1.425521  1.875000e+09   \n",
       "\n",
       "                                      antenna_arrays is_mosaic  \\\n",
       "0  A007:DV23 A010:DV12 A011:DV22 A016:DA62 A019:D...         F   \n",
       "1  A007:DV23 A010:DV12 A011:DV22 A016:DA62 A019:D...         F   \n",
       "2  A007:DV23 A010:DV12 A011:DV22 A016:DA62 A019:D...         F   \n",
       "3  A006:DV07 A010:DV12 A016:DA62 A018:DA60 A021:D...         T   \n",
       "4  A006:DV07 A010:DV12 A016:DA62 A018:DA60 A021:D...         T   \n",
       "\n",
       "          obs_release_date  spatial_resolution  \\\n",
       "0  2015-08-19T19:15:57.000            1.170768   \n",
       "1  2015-08-19T19:15:57.000            1.170768   \n",
       "2  2015-08-19T19:15:57.000            1.170768   \n",
       "3  2015-10-09T14:42:25.000            0.165660   \n",
       "4  2015-10-09T14:42:25.000            0.165660   \n",
       "\n",
       "                                   frequency_support   frequency  \\\n",
       "0  [88.00..88.94GHz,488.28kHz,1.9mJy/beam@10km/s,...   89.484582   \n",
       "1  [88.00..88.94GHz,488.28kHz,1.9mJy/beam@10km/s,...   89.484582   \n",
       "2  [88.00..88.94GHz,488.28kHz,1.9mJy/beam@10km/s,...   89.484582   \n",
       "3  [689.28..691.15GHz,976.56kHz,10.8mJy/beam@10km...  698.902241   \n",
       "4  [689.28..691.15GHz,976.56kHz,10.8mJy/beam@10km...  698.902241   \n",
       "\n",
       "   velocity_resolution obs_creator_name  \\\n",
       "0          1609.278532   Espada, Daniel   \n",
       "1          1609.278532   Espada, Daniel   \n",
       "2          1609.278532   Espada, Daniel   \n",
       "3           413.199446   Espada, Daniel   \n",
       "4           413.199446   Espada, Daniel   \n",
       "\n",
       "                                           pub_title  \\\n",
       "0  ALMACAL I: First Dual-band Number Counts from ...   \n",
       "1  ALMACAL I: First Dual-band Number Counts from ...   \n",
       "2  ALMACAL I: First Dual-band Number Counts from ...   \n",
       "3  ALMACAL I: First Dual-band Number Counts from ...   \n",
       "4  ALMACAL I: First Dual-band Number Counts from ...   \n",
       "\n",
       "                               first_author qa2_passed  \\\n",
       "0  Espada, D. Oteo, I. Thelen, Alexander E.          T   \n",
       "1  Espada, D. Oteo, I. Thelen, Alexander E.          T   \n",
       "2  Espada, D. Oteo, I. Thelen, Alexander E.          T   \n",
       "3  Espada, D. Oteo, I. Thelen, Alexander E.          T   \n",
       "4  Espada, D. Oteo, I. Thelen, Alexander E.          T   \n",
       "\n",
       "                                       bib_reference  \\\n",
       "0  2016ApJ...822...36O 2017ApJ...843..136E 2019Ic...   \n",
       "1  2016ApJ...822...36O 2017ApJ...843..136E 2019Ic...   \n",
       "2  2016ApJ...822...36O 2017ApJ...843..136E 2019Ic...   \n",
       "3  2016ApJ...822...36O 2017ApJ...843..136E 2019Ic...   \n",
       "4  2016ApJ...822...36O 2017ApJ...843..136E 2019Ic...   \n",
       "\n",
       "                                     science_keyword scientific_category  \\\n",
       "0  Active Galactic Nuclei (AGN)/Quasars (QSO), Ou...     Active galaxies   \n",
       "1  Active Galactic Nuclei (AGN)/Quasars (QSO), Ou...     Active galaxies   \n",
       "2  Active Galactic Nuclei (AGN)/Quasars (QSO), Ou...     Active galaxies   \n",
       "3  Active Galactic Nuclei (AGN)/Quasars (QSO), Ou...     Active galaxies   \n",
       "4  Active Galactic Nuclei (AGN)/Quasars (QSO), Ou...     Active galaxies   \n",
       "\n",
       "              lastModified  \n",
       "0  2021-09-30T16:34:41.133  \n",
       "1  2021-09-30T16:34:41.133  \n",
       "2  2021-09-30T16:34:41.133  \n",
       "3  2021-09-30T16:34:41.133  \n",
       "4  2021-09-30T16:34:41.133  "
      ]
     },
     "execution_count": 1,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.set_option('display.max_columns', None)\n",
    "\n",
    "results = query_coordinate_display_distance(service, 201.365, -43.019, 0.006)\n",
    "results.head(5)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "-----------------\n",
    "\n",
    "## Example 1b: Query the source Centaurus A using Sesame"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Many sources have a number of names and you can not be sure that the source name the PI placed into the ALMA proposal is the source name you have in mind. We use the name-resolver [Sesame](http://cds.u-strasbg.fr/cgi-bin/Sesame) provided by [CDS](http://cds.u-strasbg.fr) to first resolve the source name into coordinates and then search around those coordinates."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "execution": {
     "iopub.execute_input": "2021-11-16T10:25:49.815217Z",
     "iopub.status.busy": "2021-11-16T10:25:49.813694Z",
     "iopub.status.idle": "2021-11-16T10:25:49.820944Z",
     "shell.execute_reply": "2021-11-16T10:25:49.820217Z"
    }
   },
   "outputs": [],
   "source": [
    "coordinates = astropy.coordinates.SkyCoord.from_name(\"Cen A\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "execution": {
     "iopub.execute_input": "2021-11-16T10:25:49.829214Z",
     "iopub.status.busy": "2021-11-16T10:25:49.828495Z",
     "iopub.status.idle": "2021-11-16T10:25:50.225233Z",
     "shell.execute_reply": "2021-11-16T10:25:50.224643Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>access_url</th>\n",
       "      <th>access_format</th>\n",
       "      <th>proposal_id</th>\n",
       "      <th>data_rights</th>\n",
       "      <th>gal_longitude</th>\n",
       "      <th>gal_latitude</th>\n",
       "      <th>obs_publisher_did</th>\n",
       "      <th>obs_collection</th>\n",
       "      <th>facility_name</th>\n",
       "      <th>instrument_name</th>\n",
       "      <th>obs_id</th>\n",
       "      <th>dataproduct_type</th>\n",
       "      <th>calib_level</th>\n",
       "      <th>target_name</th>\n",
       "      <th>s_ra</th>\n",
       "      <th>s_dec</th>\n",
       "      <th>s_fov</th>\n",
       "      <th>s_region</th>\n",
       "      <th>s_resolution</th>\n",
       "      <th>t_min</th>\n",
       "      <th>t_max</th>\n",
       "      <th>t_exptime</th>\n",
       "      <th>t_resolution</th>\n",
       "      <th>em_min</th>\n",
       "      <th>em_max</th>\n",
       "      <th>em_res_power</th>\n",
       "      <th>pol_states</th>\n",
       "      <th>o_ucd</th>\n",
       "      <th>band_list</th>\n",
       "      <th>em_resolution</th>\n",
       "      <th>authors</th>\n",
       "      <th>pub_abstract</th>\n",
       "      <th>publication_year</th>\n",
       "      <th>proposal_abstract</th>\n",
       "      <th>schedblock_name</th>\n",
       "      <th>proposal_authors</th>\n",
       "      <th>sensitivity_10kms</th>\n",
       "      <th>cont_sensitivity_bandwidth</th>\n",
       "      <th>pwv</th>\n",
       "      <th>group_ous_uid</th>\n",
       "      <th>member_ous_uid</th>\n",
       "      <th>asdm_uid</th>\n",
       "      <th>obs_title</th>\n",
       "      <th>type</th>\n",
       "      <th>scan_intent</th>\n",
       "      <th>science_observation</th>\n",
       "      <th>spatial_scale_max</th>\n",
       "      <th>bandwidth</th>\n",
       "      <th>antenna_arrays</th>\n",
       "      <th>is_mosaic</th>\n",
       "      <th>obs_release_date</th>\n",
       "      <th>spatial_resolution</th>\n",
       "      <th>frequency_support</th>\n",
       "      <th>frequency</th>\n",
       "      <th>velocity_resolution</th>\n",
       "      <th>obs_creator_name</th>\n",
       "      <th>pub_title</th>\n",
       "      <th>first_author</th>\n",
       "      <th>qa2_passed</th>\n",
       "      <th>bib_reference</th>\n",
       "      <th>science_keyword</th>\n",
       "      <th>scientific_category</th>\n",
       "      <th>lastModified</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>http://almascience.org/aq?member_ous_id=uid://...</td>\n",
       "      <td>text/html</td>\n",
       "      <td>2011.0.00008.SV</td>\n",
       "      <td>Public</td>\n",
       "      <td>309.512363</td>\n",
       "      <td>19.416239</td>\n",
       "      <td>ADS/JAO.ALMA#2011.0.00008.SV</td>\n",
       "      <td>ALMA</td>\n",
       "      <td>JAO</td>\n",
       "      <td>ALMA</td>\n",
       "      <td>uid://A002/X259150/X157</td>\n",
       "      <td>cube</td>\n",
       "      <td>2</td>\n",
       "      <td>Centaurus A</td>\n",
       "      <td>201.360719</td>\n",
       "      <td>-43.020553</td>\n",
       "      <td>0.058089</td>\n",
       "      <td>Polygon ICRS 201.401254 -43.032096 201.401354 ...</td>\n",
       "      <td>1.023315</td>\n",
       "      <td>55784.795689</td>\n",
       "      <td>55785.043473</td>\n",
       "      <td>344.261</td>\n",
       "      <td>344.261</td>\n",
       "      <td>0.001221</td>\n",
       "      <td>0.001231</td>\n",
       "      <td>251315.70776</td>\n",
       "      <td>/XX/YY/</td>\n",
       "      <td>phot.flux.density;phys.polarization</td>\n",
       "      <td>6</td>\n",
       "      <td>306.959997</td>\n",
       "      <td>Azeez, Jazeel H.; Abidin, Zamri Z.; Hwang, C. ...</td>\n",
       "      <td>Centaurus A, with its gas-rich elliptical host...</td>\n",
       "      <td>2014</td>\n",
       "      <td>Science Verification (SV) is the process by wh...</td>\n",
       "      <td>CenA mosaic</td>\n",
       "      <td></td>\n",
       "      <td>13.319542</td>\n",
       "      <td>0.432702</td>\n",
       "      <td>1.663192</td>\n",
       "      <td></td>\n",
       "      <td>uid://A002/X259150/X157</td>\n",
       "      <td>uid://A002/X2762c7/X132</td>\n",
       "      <td>Science verification observation of Centaurus A</td>\n",
       "      <td>SV</td>\n",
       "      <td>TARGET WVR</td>\n",
       "      <td>T</td>\n",
       "      <td>9.714115</td>\n",
       "      <td>1.875000e+09</td>\n",
       "      <td>A004:DV07 A008:DV09 A009:DA41 A011:DV12 A015:D...</td>\n",
       "      <td>T</td>\n",
       "      <td>2016-06-24T14:02:07.000</td>\n",
       "      <td>1.023315</td>\n",
       "      <td>[229.20..231.08GHz,976.56kHz,13.2mJy/beam@10km...</td>\n",
       "      <td>238.261613</td>\n",
       "      <td>1183.847494</td>\n",
       "      <td>observatory, ALMA</td>\n",
       "      <td>ALMA Observations of the Physical and Chemical...</td>\n",
       "      <td>Azeez, Jazeel H. Israel, F. P. McCoy, Mark</td>\n",
       "      <td>T</td>\n",
       "      <td>2014A&amp;A...562A..96I 2017AdAst2017E...6A 2017Ap...</td>\n",
       "      <td>Galactic centres/nuclei, Active Galactic Nucle...</td>\n",
       "      <td>Active galaxies</td>\n",
       "      <td>2021-09-30T16:34:41.133</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>http://almascience.org/aq?member_ous_id=uid://...</td>\n",
       "      <td>text/html</td>\n",
       "      <td>2011.0.00008.SV</td>\n",
       "      <td>Public</td>\n",
       "      <td>309.512363</td>\n",
       "      <td>19.416239</td>\n",
       "      <td>ADS/JAO.ALMA#2011.0.00008.SV</td>\n",
       "      <td>ALMA</td>\n",
       "      <td>JAO</td>\n",
       "      <td>ALMA</td>\n",
       "      <td>uid://A002/X259150/X157</td>\n",
       "      <td>cube</td>\n",
       "      <td>2</td>\n",
       "      <td>Centaurus A</td>\n",
       "      <td>201.360719</td>\n",
       "      <td>-43.020553</td>\n",
       "      <td>0.058089</td>\n",
       "      <td>Polygon ICRS 201.401254 -43.032096 201.401354 ...</td>\n",
       "      <td>1.023315</td>\n",
       "      <td>55784.795689</td>\n",
       "      <td>55785.043473</td>\n",
       "      <td>344.261</td>\n",
       "      <td>344.261</td>\n",
       "      <td>0.001212</td>\n",
       "      <td>0.001221</td>\n",
       "      <td>253235.70776</td>\n",
       "      <td>/XX/YY/</td>\n",
       "      <td>phot.flux.density;phys.polarization</td>\n",
       "      <td>6</td>\n",
       "      <td>306.959997</td>\n",
       "      <td>Azeez, Jazeel H.; Abidin, Zamri Z.; Hwang, C. ...</td>\n",
       "      <td>Centaurus A, with its gas-rich elliptical host...</td>\n",
       "      <td>2014</td>\n",
       "      <td>Science Verification (SV) is the process by wh...</td>\n",
       "      <td>CenA mosaic</td>\n",
       "      <td></td>\n",
       "      <td>13.283133</td>\n",
       "      <td>0.432702</td>\n",
       "      <td>1.663192</td>\n",
       "      <td></td>\n",
       "      <td>uid://A002/X259150/X157</td>\n",
       "      <td>uid://A002/X2762c7/X132</td>\n",
       "      <td>Science verification observation of Centaurus A</td>\n",
       "      <td>SV</td>\n",
       "      <td>TARGET WVR</td>\n",
       "      <td>T</td>\n",
       "      <td>9.714115</td>\n",
       "      <td>1.875000e+09</td>\n",
       "      <td>A004:DV07 A008:DV09 A009:DA41 A011:DV12 A015:D...</td>\n",
       "      <td>T</td>\n",
       "      <td>2016-06-24T14:02:07.000</td>\n",
       "      <td>1.023315</td>\n",
       "      <td>[229.20..231.08GHz,976.56kHz,13.2mJy/beam@10km...</td>\n",
       "      <td>238.261613</td>\n",
       "      <td>1183.847494</td>\n",
       "      <td>observatory, ALMA</td>\n",
       "      <td>ALMA Observations of the Physical and Chemical...</td>\n",
       "      <td>Azeez, Jazeel H. Israel, F. P. McCoy, Mark</td>\n",
       "      <td>T</td>\n",
       "      <td>2014A&amp;A...562A..96I 2017AdAst2017E...6A 2017Ap...</td>\n",
       "      <td>Galactic centres/nuclei, Active Galactic Nucle...</td>\n",
       "      <td>Active galaxies</td>\n",
       "      <td>2021-09-30T16:34:41.133</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>http://almascience.org/aq?member_ous_id=uid://...</td>\n",
       "      <td>text/html</td>\n",
       "      <td>2011.0.00008.SV</td>\n",
       "      <td>Public</td>\n",
       "      <td>309.512363</td>\n",
       "      <td>19.416239</td>\n",
       "      <td>ADS/JAO.ALMA#2011.0.00008.SV</td>\n",
       "      <td>ALMA</td>\n",
       "      <td>JAO</td>\n",
       "      <td>ALMA</td>\n",
       "      <td>uid://A002/X259150/X157</td>\n",
       "      <td>cube</td>\n",
       "      <td>2</td>\n",
       "      <td>Centaurus A</td>\n",
       "      <td>201.360719</td>\n",
       "      <td>-43.020553</td>\n",
       "      <td>0.058089</td>\n",
       "      <td>Polygon ICRS 201.401254 -43.032096 201.401354 ...</td>\n",
       "      <td>1.023315</td>\n",
       "      <td>55784.795689</td>\n",
       "      <td>55785.043473</td>\n",
       "      <td>344.261</td>\n",
       "      <td>344.261</td>\n",
       "      <td>0.001297</td>\n",
       "      <td>0.001308</td>\n",
       "      <td>236599.53752</td>\n",
       "      <td>/XX/YY/</td>\n",
       "      <td>phot.flux.density;phys.polarization</td>\n",
       "      <td>6</td>\n",
       "      <td>306.959997</td>\n",
       "      <td>Azeez, Jazeel H.; Abidin, Zamri Z.; Hwang, C. ...</td>\n",
       "      <td>Centaurus A, with its gas-rich elliptical host...</td>\n",
       "      <td>2014</td>\n",
       "      <td>Science Verification (SV) is the process by wh...</td>\n",
       "      <td>CenA mosaic</td>\n",
       "      <td></td>\n",
       "      <td>13.238502</td>\n",
       "      <td>0.432702</td>\n",
       "      <td>1.663192</td>\n",
       "      <td></td>\n",
       "      <td>uid://A002/X259150/X157</td>\n",
       "      <td>uid://A002/X2762c7/X132</td>\n",
       "      <td>Science verification observation of Centaurus A</td>\n",
       "      <td>SV</td>\n",
       "      <td>TARGET WVR</td>\n",
       "      <td>T</td>\n",
       "      <td>9.714115</td>\n",
       "      <td>1.875000e+09</td>\n",
       "      <td>A004:DV07 A008:DV09 A009:DA41 A011:DV12 A015:D...</td>\n",
       "      <td>T</td>\n",
       "      <td>2016-06-24T14:02:07.000</td>\n",
       "      <td>1.023315</td>\n",
       "      <td>[229.20..231.08GHz,976.56kHz,13.2mJy/beam@10km...</td>\n",
       "      <td>238.261613</td>\n",
       "      <td>1183.847494</td>\n",
       "      <td>observatory, ALMA</td>\n",
       "      <td>ALMA Observations of the Physical and Chemical...</td>\n",
       "      <td>Azeez, Jazeel H. Israel, F. P. McCoy, Mark</td>\n",
       "      <td>T</td>\n",
       "      <td>2014A&amp;A...562A..96I 2017AdAst2017E...6A 2017Ap...</td>\n",
       "      <td>Galactic centres/nuclei, Active Galactic Nucle...</td>\n",
       "      <td>Active galaxies</td>\n",
       "      <td>2021-09-30T16:34:41.133</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>http://almascience.org/aq?member_ous_id=uid://...</td>\n",
       "      <td>text/html</td>\n",
       "      <td>2011.0.00008.SV</td>\n",
       "      <td>Public</td>\n",
       "      <td>309.512363</td>\n",
       "      <td>19.416239</td>\n",
       "      <td>ADS/JAO.ALMA#2011.0.00008.SV</td>\n",
       "      <td>ALMA</td>\n",
       "      <td>JAO</td>\n",
       "      <td>ALMA</td>\n",
       "      <td>uid://A002/X259150/X157</td>\n",
       "      <td>cube</td>\n",
       "      <td>2</td>\n",
       "      <td>Centaurus A</td>\n",
       "      <td>201.360719</td>\n",
       "      <td>-43.020553</td>\n",
       "      <td>0.058089</td>\n",
       "      <td>Polygon ICRS 201.401254 -43.032096 201.401354 ...</td>\n",
       "      <td>1.023315</td>\n",
       "      <td>55784.795689</td>\n",
       "      <td>55785.043473</td>\n",
       "      <td>344.261</td>\n",
       "      <td>344.261</td>\n",
       "      <td>0.001287</td>\n",
       "      <td>0.001297</td>\n",
       "      <td>238519.53752</td>\n",
       "      <td>/XX/YY/</td>\n",
       "      <td>phot.flux.density;phys.polarization</td>\n",
       "      <td>6</td>\n",
       "      <td>306.959997</td>\n",
       "      <td>Azeez, Jazeel H.; Abidin, Zamri Z.; Hwang, C. ...</td>\n",
       "      <td>Centaurus A, with its gas-rich elliptical host...</td>\n",
       "      <td>2014</td>\n",
       "      <td>Science Verification (SV) is the process by wh...</td>\n",
       "      <td>CenA mosaic</td>\n",
       "      <td></td>\n",
       "      <td>13.354480</td>\n",
       "      <td>0.432702</td>\n",
       "      <td>1.663192</td>\n",
       "      <td></td>\n",
       "      <td>uid://A002/X259150/X157</td>\n",
       "      <td>uid://A002/X2762c7/X132</td>\n",
       "      <td>Science verification observation of Centaurus A</td>\n",
       "      <td>SV</td>\n",
       "      <td>TARGET WVR</td>\n",
       "      <td>T</td>\n",
       "      <td>9.714115</td>\n",
       "      <td>1.875000e+09</td>\n",
       "      <td>A004:DV07 A008:DV09 A009:DA41 A011:DV12 A015:D...</td>\n",
       "      <td>T</td>\n",
       "      <td>2016-06-24T14:02:07.000</td>\n",
       "      <td>1.023315</td>\n",
       "      <td>[229.20..231.08GHz,976.56kHz,13.2mJy/beam@10km...</td>\n",
       "      <td>238.261613</td>\n",
       "      <td>1183.847494</td>\n",
       "      <td>observatory, ALMA</td>\n",
       "      <td>ALMA Observations of the Physical and Chemical...</td>\n",
       "      <td>Azeez, Jazeel H. Israel, F. P. McCoy, Mark</td>\n",
       "      <td>T</td>\n",
       "      <td>2014A&amp;A...562A..96I 2017AdAst2017E...6A 2017Ap...</td>\n",
       "      <td>Galactic centres/nuclei, Active Galactic Nucle...</td>\n",
       "      <td>Active galaxies</td>\n",
       "      <td>2021-09-30T16:34:41.133</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>http://almascience.org/aq?member_ous_id=uid://...</td>\n",
       "      <td>text/html</td>\n",
       "      <td>2011.0.00010.S</td>\n",
       "      <td>Public</td>\n",
       "      <td>309.515914</td>\n",
       "      <td>19.417224</td>\n",
       "      <td>ADS/JAO.ALMA#2011.0.00010.S</td>\n",
       "      <td>ALMA</td>\n",
       "      <td>JAO</td>\n",
       "      <td>ALMA</td>\n",
       "      <td>uid://A002/X327408/X217</td>\n",
       "      <td>cube</td>\n",
       "      <td>2</td>\n",
       "      <td>CenA</td>\n",
       "      <td>201.365063</td>\n",
       "      <td>-43.019112</td>\n",
       "      <td>0.007385</td>\n",
       "      <td>Circle ICRS 201.365063 -43.019112 0.003692</td>\n",
       "      <td>1.330912</td>\n",
       "      <td>55950.253573</td>\n",
       "      <td>55950.305961</td>\n",
       "      <td>1512.000</td>\n",
       "      <td>1512.000</td>\n",
       "      <td>0.001360</td>\n",
       "      <td>0.001366</td>\n",
       "      <td>451534.98200</td>\n",
       "      <td>/XX/YY/</td>\n",
       "      <td>phot.flux.density;phys.polarization</td>\n",
       "      <td>6</td>\n",
       "      <td>614.023326</td>\n",
       "      <td>McCoy, Mark; Ott, Jürgen; Meier, David S.; Mul...</td>\n",
       "      <td>Centaurus A, with its gas-rich elliptical host...</td>\n",
       "      <td>2017</td>\n",
       "      <td>Centaurus A with its host NGC5128 is the most ...</td>\n",
       "      <td>CenA 13CO, C18O, HNCO, H2CO COMP</td>\n",
       "      <td>Impellizzeri, Violette; Peck, Alison; Walter, ...</td>\n",
       "      <td>1.398342</td>\n",
       "      <td>0.061695</td>\n",
       "      <td>0.852892</td>\n",
       "      <td></td>\n",
       "      <td>uid://A002/X327408/X217</td>\n",
       "      <td>uid://A002/X383b50/Xc45</td>\n",
       "      <td>The Physics and Chemisty of Gas in Centaurus A...</td>\n",
       "      <td>S</td>\n",
       "      <td>TARGET</td>\n",
       "      <td>T</td>\n",
       "      <td>12.599759</td>\n",
       "      <td>9.375000e+08</td>\n",
       "      <td>A002:PM02 A004:DV04 A009:DA43 A011:DV12 A013:D...</td>\n",
       "      <td>F</td>\n",
       "      <td>2015-02-12T13:48:59.000</td>\n",
       "      <td>1.330912</td>\n",
       "      <td>[217.59..218.53GHz,488.28kHz,1.4mJy/beam@10km/...</td>\n",
       "      <td>219.025328</td>\n",
       "      <td>663.940713</td>\n",
       "      <td>Ott, Juergen</td>\n",
       "      <td>ALMA Observations of the Physical and Chemical...</td>\n",
       "      <td>McCoy, Mark</td>\n",
       "      <td>T</td>\n",
       "      <td>2017ApJ...851...76M</td>\n",
       "      <td>Active Galactic Nuclei (AGN)/Quasars (QSO), Me...</td>\n",
       "      <td>Active galaxies</td>\n",
       "      <td>2021-09-30T16:34:41.133</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                          access_url access_format  \\\n",
       "0  http://almascience.org/aq?member_ous_id=uid://...     text/html   \n",
       "1  http://almascience.org/aq?member_ous_id=uid://...     text/html   \n",
       "2  http://almascience.org/aq?member_ous_id=uid://...     text/html   \n",
       "3  http://almascience.org/aq?member_ous_id=uid://...     text/html   \n",
       "4  http://almascience.org/aq?member_ous_id=uid://...     text/html   \n",
       "\n",
       "       proposal_id data_rights  gal_longitude  gal_latitude  \\\n",
       "0  2011.0.00008.SV      Public     309.512363     19.416239   \n",
       "1  2011.0.00008.SV      Public     309.512363     19.416239   \n",
       "2  2011.0.00008.SV      Public     309.512363     19.416239   \n",
       "3  2011.0.00008.SV      Public     309.512363     19.416239   \n",
       "4   2011.0.00010.S      Public     309.515914     19.417224   \n",
       "\n",
       "              obs_publisher_did obs_collection facility_name instrument_name  \\\n",
       "0  ADS/JAO.ALMA#2011.0.00008.SV           ALMA           JAO            ALMA   \n",
       "1  ADS/JAO.ALMA#2011.0.00008.SV           ALMA           JAO            ALMA   \n",
       "2  ADS/JAO.ALMA#2011.0.00008.SV           ALMA           JAO            ALMA   \n",
       "3  ADS/JAO.ALMA#2011.0.00008.SV           ALMA           JAO            ALMA   \n",
       "4   ADS/JAO.ALMA#2011.0.00010.S           ALMA           JAO            ALMA   \n",
       "\n",
       "                    obs_id dataproduct_type  calib_level  target_name  \\\n",
       "0  uid://A002/X259150/X157             cube            2  Centaurus A   \n",
       "1  uid://A002/X259150/X157             cube            2  Centaurus A   \n",
       "2  uid://A002/X259150/X157             cube            2  Centaurus A   \n",
       "3  uid://A002/X259150/X157             cube            2  Centaurus A   \n",
       "4  uid://A002/X327408/X217             cube            2         CenA   \n",
       "\n",
       "         s_ra      s_dec     s_fov  \\\n",
       "0  201.360719 -43.020553  0.058089   \n",
       "1  201.360719 -43.020553  0.058089   \n",
       "2  201.360719 -43.020553  0.058089   \n",
       "3  201.360719 -43.020553  0.058089   \n",
       "4  201.365063 -43.019112  0.007385   \n",
       "\n",
       "                                            s_region  s_resolution  \\\n",
       "0  Polygon ICRS 201.401254 -43.032096 201.401354 ...      1.023315   \n",
       "1  Polygon ICRS 201.401254 -43.032096 201.401354 ...      1.023315   \n",
       "2  Polygon ICRS 201.401254 -43.032096 201.401354 ...      1.023315   \n",
       "3  Polygon ICRS 201.401254 -43.032096 201.401354 ...      1.023315   \n",
       "4         Circle ICRS 201.365063 -43.019112 0.003692      1.330912   \n",
       "\n",
       "          t_min         t_max  t_exptime  t_resolution    em_min    em_max  \\\n",
       "0  55784.795689  55785.043473    344.261       344.261  0.001221  0.001231   \n",
       "1  55784.795689  55785.043473    344.261       344.261  0.001212  0.001221   \n",
       "2  55784.795689  55785.043473    344.261       344.261  0.001297  0.001308   \n",
       "3  55784.795689  55785.043473    344.261       344.261  0.001287  0.001297   \n",
       "4  55950.253573  55950.305961   1512.000      1512.000  0.001360  0.001366   \n",
       "\n",
       "   em_res_power pol_states                                o_ucd band_list  \\\n",
       "0  251315.70776    /XX/YY/  phot.flux.density;phys.polarization         6   \n",
       "1  253235.70776    /XX/YY/  phot.flux.density;phys.polarization         6   \n",
       "2  236599.53752    /XX/YY/  phot.flux.density;phys.polarization         6   \n",
       "3  238519.53752    /XX/YY/  phot.flux.density;phys.polarization         6   \n",
       "4  451534.98200    /XX/YY/  phot.flux.density;phys.polarization         6   \n",
       "\n",
       "   em_resolution                                            authors  \\\n",
       "0     306.959997  Azeez, Jazeel H.; Abidin, Zamri Z.; Hwang, C. ...   \n",
       "1     306.959997  Azeez, Jazeel H.; Abidin, Zamri Z.; Hwang, C. ...   \n",
       "2     306.959997  Azeez, Jazeel H.; Abidin, Zamri Z.; Hwang, C. ...   \n",
       "3     306.959997  Azeez, Jazeel H.; Abidin, Zamri Z.; Hwang, C. ...   \n",
       "4     614.023326  McCoy, Mark; Ott, Jürgen; Meier, David S.; Mul...   \n",
       "\n",
       "                                        pub_abstract  publication_year  \\\n",
       "0  Centaurus A, with its gas-rich elliptical host...              2014   \n",
       "1  Centaurus A, with its gas-rich elliptical host...              2014   \n",
       "2  Centaurus A, with its gas-rich elliptical host...              2014   \n",
       "3  Centaurus A, with its gas-rich elliptical host...              2014   \n",
       "4  Centaurus A, with its gas-rich elliptical host...              2017   \n",
       "\n",
       "                                   proposal_abstract  \\\n",
       "0  Science Verification (SV) is the process by wh...   \n",
       "1  Science Verification (SV) is the process by wh...   \n",
       "2  Science Verification (SV) is the process by wh...   \n",
       "3  Science Verification (SV) is the process by wh...   \n",
       "4  Centaurus A with its host NGC5128 is the most ...   \n",
       "\n",
       "                    schedblock_name  \\\n",
       "0                       CenA mosaic   \n",
       "1                       CenA mosaic   \n",
       "2                       CenA mosaic   \n",
       "3                       CenA mosaic   \n",
       "4  CenA 13CO, C18O, HNCO, H2CO COMP   \n",
       "\n",
       "                                    proposal_authors  sensitivity_10kms  \\\n",
       "0                                                             13.319542   \n",
       "1                                                             13.283133   \n",
       "2                                                             13.238502   \n",
       "3                                                             13.354480   \n",
       "4  Impellizzeri, Violette; Peck, Alison; Walter, ...           1.398342   \n",
       "\n",
       "   cont_sensitivity_bandwidth       pwv group_ous_uid  \\\n",
       "0                    0.432702  1.663192                 \n",
       "1                    0.432702  1.663192                 \n",
       "2                    0.432702  1.663192                 \n",
       "3                    0.432702  1.663192                 \n",
       "4                    0.061695  0.852892                 \n",
       "\n",
       "            member_ous_uid                 asdm_uid  \\\n",
       "0  uid://A002/X259150/X157  uid://A002/X2762c7/X132   \n",
       "1  uid://A002/X259150/X157  uid://A002/X2762c7/X132   \n",
       "2  uid://A002/X259150/X157  uid://A002/X2762c7/X132   \n",
       "3  uid://A002/X259150/X157  uid://A002/X2762c7/X132   \n",
       "4  uid://A002/X327408/X217  uid://A002/X383b50/Xc45   \n",
       "\n",
       "                                           obs_title type scan_intent  \\\n",
       "0    Science verification observation of Centaurus A   SV  TARGET WVR   \n",
       "1    Science verification observation of Centaurus A   SV  TARGET WVR   \n",
       "2    Science verification observation of Centaurus A   SV  TARGET WVR   \n",
       "3    Science verification observation of Centaurus A   SV  TARGET WVR   \n",
       "4  The Physics and Chemisty of Gas in Centaurus A...    S      TARGET   \n",
       "\n",
       "  science_observation  spatial_scale_max     bandwidth  \\\n",
       "0                   T           9.714115  1.875000e+09   \n",
       "1                   T           9.714115  1.875000e+09   \n",
       "2                   T           9.714115  1.875000e+09   \n",
       "3                   T           9.714115  1.875000e+09   \n",
       "4                   T          12.599759  9.375000e+08   \n",
       "\n",
       "                                      antenna_arrays is_mosaic  \\\n",
       "0  A004:DV07 A008:DV09 A009:DA41 A011:DV12 A015:D...         T   \n",
       "1  A004:DV07 A008:DV09 A009:DA41 A011:DV12 A015:D...         T   \n",
       "2  A004:DV07 A008:DV09 A009:DA41 A011:DV12 A015:D...         T   \n",
       "3  A004:DV07 A008:DV09 A009:DA41 A011:DV12 A015:D...         T   \n",
       "4  A002:PM02 A004:DV04 A009:DA43 A011:DV12 A013:D...         F   \n",
       "\n",
       "          obs_release_date  spatial_resolution  \\\n",
       "0  2016-06-24T14:02:07.000            1.023315   \n",
       "1  2016-06-24T14:02:07.000            1.023315   \n",
       "2  2016-06-24T14:02:07.000            1.023315   \n",
       "3  2016-06-24T14:02:07.000            1.023315   \n",
       "4  2015-02-12T13:48:59.000            1.330912   \n",
       "\n",
       "                                   frequency_support   frequency  \\\n",
       "0  [229.20..231.08GHz,976.56kHz,13.2mJy/beam@10km...  238.261613   \n",
       "1  [229.20..231.08GHz,976.56kHz,13.2mJy/beam@10km...  238.261613   \n",
       "2  [229.20..231.08GHz,976.56kHz,13.2mJy/beam@10km...  238.261613   \n",
       "3  [229.20..231.08GHz,976.56kHz,13.2mJy/beam@10km...  238.261613   \n",
       "4  [217.59..218.53GHz,488.28kHz,1.4mJy/beam@10km/...  219.025328   \n",
       "\n",
       "   velocity_resolution   obs_creator_name  \\\n",
       "0          1183.847494  observatory, ALMA   \n",
       "1          1183.847494  observatory, ALMA   \n",
       "2          1183.847494  observatory, ALMA   \n",
       "3          1183.847494  observatory, ALMA   \n",
       "4           663.940713       Ott, Juergen   \n",
       "\n",
       "                                           pub_title  \\\n",
       "0  ALMA Observations of the Physical and Chemical...   \n",
       "1  ALMA Observations of the Physical and Chemical...   \n",
       "2  ALMA Observations of the Physical and Chemical...   \n",
       "3  ALMA Observations of the Physical and Chemical...   \n",
       "4  ALMA Observations of the Physical and Chemical...   \n",
       "\n",
       "                                 first_author qa2_passed  \\\n",
       "0  Azeez, Jazeel H. Israel, F. P. McCoy, Mark          T   \n",
       "1  Azeez, Jazeel H. Israel, F. P. McCoy, Mark          T   \n",
       "2  Azeez, Jazeel H. Israel, F. P. McCoy, Mark          T   \n",
       "3  Azeez, Jazeel H. Israel, F. P. McCoy, Mark          T   \n",
       "4                                 McCoy, Mark          T   \n",
       "\n",
       "                                       bib_reference  \\\n",
       "0  2014A&A...562A..96I 2017AdAst2017E...6A 2017Ap...   \n",
       "1  2014A&A...562A..96I 2017AdAst2017E...6A 2017Ap...   \n",
       "2  2014A&A...562A..96I 2017AdAst2017E...6A 2017Ap...   \n",
       "3  2014A&A...562A..96I 2017AdAst2017E...6A 2017Ap...   \n",
       "4                                2017ApJ...851...76M   \n",
       "\n",
       "                                     science_keyword scientific_category  \\\n",
       "0  Galactic centres/nuclei, Active Galactic Nucle...     Active galaxies   \n",
       "1  Galactic centres/nuclei, Active Galactic Nucle...     Active galaxies   \n",
       "2  Galactic centres/nuclei, Active Galactic Nucle...     Active galaxies   \n",
       "3  Galactic centres/nuclei, Active Galactic Nucle...     Active galaxies   \n",
       "4  Active Galactic Nuclei (AGN)/Quasars (QSO), Me...     Active galaxies   \n",
       "\n",
       "              lastModified  \n",
       "0  2021-09-30T16:34:41.133  \n",
       "1  2021-09-30T16:34:41.133  \n",
       "2  2021-09-30T16:34:41.133  \n",
       "3  2021-09-30T16:34:41.133  \n",
       "4  2021-09-30T16:34:41.133  "
      ]
     },
     "execution_count": 1,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "query_coordinate(service, coordinates.ra.degree, coordinates.dec.degree, 0.006).head(5)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "-----------------\n",
    "\n",
    "\n",
    "## Example 1c: Query the ALMA source name \"Centaurus\""
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Although in most cases, using the name resolver as above is the best way to search for source names, there can be occasions where searching for the name as given by the PI is useful. (Note that SQL queries are case-sensitive)."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "execution": {
     "iopub.execute_input": "2021-11-16T10:25:50.231728Z",
     "iopub.status.busy": "2021-11-16T10:25:50.231030Z",
     "iopub.status.idle": "2021-11-16T10:25:50.428125Z",
     "shell.execute_reply": "2021-11-16T10:25:50.428908Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>access_url</th>\n",
       "      <th>access_format</th>\n",
       "      <th>proposal_id</th>\n",
       "      <th>data_rights</th>\n",
       "      <th>gal_longitude</th>\n",
       "      <th>gal_latitude</th>\n",
       "      <th>obs_publisher_did</th>\n",
       "      <th>obs_collection</th>\n",
       "      <th>facility_name</th>\n",
       "      <th>instrument_name</th>\n",
       "      <th>obs_id</th>\n",
       "      <th>dataproduct_type</th>\n",
       "      <th>calib_level</th>\n",
       "      <th>target_name</th>\n",
       "      <th>s_ra</th>\n",
       "      <th>s_dec</th>\n",
       "      <th>s_fov</th>\n",
       "      <th>s_region</th>\n",
       "      <th>s_resolution</th>\n",
       "      <th>t_min</th>\n",
       "      <th>t_max</th>\n",
       "      <th>t_exptime</th>\n",
       "      <th>t_resolution</th>\n",
       "      <th>em_min</th>\n",
       "      <th>em_max</th>\n",
       "      <th>em_res_power</th>\n",
       "      <th>pol_states</th>\n",
       "      <th>o_ucd</th>\n",
       "      <th>band_list</th>\n",
       "      <th>em_resolution</th>\n",
       "      <th>authors</th>\n",
       "      <th>pub_abstract</th>\n",
       "      <th>publication_year</th>\n",
       "      <th>proposal_abstract</th>\n",
       "      <th>schedblock_name</th>\n",
       "      <th>proposal_authors</th>\n",
       "      <th>sensitivity_10kms</th>\n",
       "      <th>cont_sensitivity_bandwidth</th>\n",
       "      <th>pwv</th>\n",
       "      <th>group_ous_uid</th>\n",
       "      <th>member_ous_uid</th>\n",
       "      <th>asdm_uid</th>\n",
       "      <th>obs_title</th>\n",
       "      <th>type</th>\n",
       "      <th>scan_intent</th>\n",
       "      <th>science_observation</th>\n",
       "      <th>spatial_scale_max</th>\n",
       "      <th>bandwidth</th>\n",
       "      <th>antenna_arrays</th>\n",
       "      <th>is_mosaic</th>\n",
       "      <th>obs_release_date</th>\n",
       "      <th>spatial_resolution</th>\n",
       "      <th>frequency_support</th>\n",
       "      <th>frequency</th>\n",
       "      <th>velocity_resolution</th>\n",
       "      <th>obs_creator_name</th>\n",
       "      <th>pub_title</th>\n",
       "      <th>first_author</th>\n",
       "      <th>qa2_passed</th>\n",
       "      <th>bib_reference</th>\n",
       "      <th>science_keyword</th>\n",
       "      <th>scientific_category</th>\n",
       "      <th>lastModified</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>http://almascience.org/aq?member_ous_id=uid://...</td>\n",
       "      <td>text/html</td>\n",
       "      <td>2011.0.00008.SV</td>\n",
       "      <td>Public</td>\n",
       "      <td>309.512363</td>\n",
       "      <td>19.416239</td>\n",
       "      <td>ADS/JAO.ALMA#2011.0.00008.SV</td>\n",
       "      <td>ALMA</td>\n",
       "      <td>JAO</td>\n",
       "      <td>ALMA</td>\n",
       "      <td>uid://A002/X259150/X157</td>\n",
       "      <td>cube</td>\n",
       "      <td>2</td>\n",
       "      <td>Centaurus A</td>\n",
       "      <td>201.360719</td>\n",
       "      <td>-43.020553</td>\n",
       "      <td>0.058089</td>\n",
       "      <td>Polygon ICRS 201.401254 -43.032096 201.401354 ...</td>\n",
       "      <td>1.023315</td>\n",
       "      <td>55784.795689</td>\n",
       "      <td>55785.043473</td>\n",
       "      <td>344.261</td>\n",
       "      <td>344.261</td>\n",
       "      <td>0.001221</td>\n",
       "      <td>0.001231</td>\n",
       "      <td>251315.70776</td>\n",
       "      <td>/XX/YY/</td>\n",
       "      <td>phot.flux.density;phys.polarization</td>\n",
       "      <td>6</td>\n",
       "      <td>306.959997</td>\n",
       "      <td>Azeez, Jazeel H.; Abidin, Zamri Z.; Hwang, C. ...</td>\n",
       "      <td>Centaurus A, with its gas-rich elliptical host...</td>\n",
       "      <td>2014</td>\n",
       "      <td>Science Verification (SV) is the process by wh...</td>\n",
       "      <td>CenA mosaic</td>\n",
       "      <td></td>\n",
       "      <td>13.319542</td>\n",
       "      <td>0.432702</td>\n",
       "      <td>1.663192</td>\n",
       "      <td></td>\n",
       "      <td>uid://A002/X259150/X157</td>\n",
       "      <td>uid://A002/X2762c7/X132</td>\n",
       "      <td>Science verification observation of Centaurus A</td>\n",
       "      <td>SV</td>\n",
       "      <td>TARGET WVR</td>\n",
       "      <td>T</td>\n",
       "      <td>9.714115</td>\n",
       "      <td>1.875000e+09</td>\n",
       "      <td>A004:DV07 A008:DV09 A009:DA41 A011:DV12 A015:D...</td>\n",
       "      <td>T</td>\n",
       "      <td>2016-06-24T14:02:07.000</td>\n",
       "      <td>1.023315</td>\n",
       "      <td>[229.20..231.08GHz,976.56kHz,13.2mJy/beam@10km...</td>\n",
       "      <td>238.261613</td>\n",
       "      <td>1183.847494</td>\n",
       "      <td>observatory, ALMA</td>\n",
       "      <td>ALMA Observations of the Physical and Chemical...</td>\n",
       "      <td>Azeez, Jazeel H. Israel, F. P. McCoy, Mark</td>\n",
       "      <td>T</td>\n",
       "      <td>2014A&amp;A...562A..96I 2017AdAst2017E...6A 2017Ap...</td>\n",
       "      <td>Galactic centres/nuclei, Active Galactic Nucle...</td>\n",
       "      <td>Active galaxies</td>\n",
       "      <td>2021-09-30T16:34:41.133</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>http://almascience.org/aq?member_ous_id=uid://...</td>\n",
       "      <td>text/html</td>\n",
       "      <td>2011.0.00008.SV</td>\n",
       "      <td>Public</td>\n",
       "      <td>309.512363</td>\n",
       "      <td>19.416239</td>\n",
       "      <td>ADS/JAO.ALMA#2011.0.00008.SV</td>\n",
       "      <td>ALMA</td>\n",
       "      <td>JAO</td>\n",
       "      <td>ALMA</td>\n",
       "      <td>uid://A002/X259150/X157</td>\n",
       "      <td>cube</td>\n",
       "      <td>2</td>\n",
       "      <td>Centaurus A</td>\n",
       "      <td>201.360719</td>\n",
       "      <td>-43.020553</td>\n",
       "      <td>0.058089</td>\n",
       "      <td>Polygon ICRS 201.401254 -43.032096 201.401354 ...</td>\n",
       "      <td>1.023315</td>\n",
       "      <td>55784.795689</td>\n",
       "      <td>55785.043473</td>\n",
       "      <td>344.261</td>\n",
       "      <td>344.261</td>\n",
       "      <td>0.001212</td>\n",
       "      <td>0.001221</td>\n",
       "      <td>253235.70776</td>\n",
       "      <td>/XX/YY/</td>\n",
       "      <td>phot.flux.density;phys.polarization</td>\n",
       "      <td>6</td>\n",
       "      <td>306.959997</td>\n",
       "      <td>Azeez, Jazeel H.; Abidin, Zamri Z.; Hwang, C. ...</td>\n",
       "      <td>Centaurus A, with its gas-rich elliptical host...</td>\n",
       "      <td>2014</td>\n",
       "      <td>Science Verification (SV) is the process by wh...</td>\n",
       "      <td>CenA mosaic</td>\n",
       "      <td></td>\n",
       "      <td>13.283133</td>\n",
       "      <td>0.432702</td>\n",
       "      <td>1.663192</td>\n",
       "      <td></td>\n",
       "      <td>uid://A002/X259150/X157</td>\n",
       "      <td>uid://A002/X2762c7/X132</td>\n",
       "      <td>Science verification observation of Centaurus A</td>\n",
       "      <td>SV</td>\n",
       "      <td>TARGET WVR</td>\n",
       "      <td>T</td>\n",
       "      <td>9.714115</td>\n",
       "      <td>1.875000e+09</td>\n",
       "      <td>A004:DV07 A008:DV09 A009:DA41 A011:DV12 A015:D...</td>\n",
       "      <td>T</td>\n",
       "      <td>2016-06-24T14:02:07.000</td>\n",
       "      <td>1.023315</td>\n",
       "      <td>[229.20..231.08GHz,976.56kHz,13.2mJy/beam@10km...</td>\n",
       "      <td>238.261613</td>\n",
       "      <td>1183.847494</td>\n",
       "      <td>observatory, ALMA</td>\n",
       "      <td>ALMA Observations of the Physical and Chemical...</td>\n",
       "      <td>Azeez, Jazeel H. Israel, F. P. McCoy, Mark</td>\n",
       "      <td>T</td>\n",
       "      <td>2014A&amp;A...562A..96I 2017AdAst2017E...6A 2017Ap...</td>\n",
       "      <td>Galactic centres/nuclei, Active Galactic Nucle...</td>\n",
       "      <td>Active galaxies</td>\n",
       "      <td>2021-09-30T16:34:41.133</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>http://almascience.org/aq?member_ous_id=uid://...</td>\n",
       "      <td>text/html</td>\n",
       "      <td>2011.0.00008.SV</td>\n",
       "      <td>Public</td>\n",
       "      <td>309.512363</td>\n",
       "      <td>19.416239</td>\n",
       "      <td>ADS/JAO.ALMA#2011.0.00008.SV</td>\n",
       "      <td>ALMA</td>\n",
       "      <td>JAO</td>\n",
       "      <td>ALMA</td>\n",
       "      <td>uid://A002/X259150/X157</td>\n",
       "      <td>cube</td>\n",
       "      <td>2</td>\n",
       "      <td>Centaurus A</td>\n",
       "      <td>201.360719</td>\n",
       "      <td>-43.020553</td>\n",
       "      <td>0.058089</td>\n",
       "      <td>Polygon ICRS 201.401254 -43.032096 201.401354 ...</td>\n",
       "      <td>1.023315</td>\n",
       "      <td>55784.795689</td>\n",
       "      <td>55785.043473</td>\n",
       "      <td>344.261</td>\n",
       "      <td>344.261</td>\n",
       "      <td>0.001297</td>\n",
       "      <td>0.001308</td>\n",
       "      <td>236599.53752</td>\n",
       "      <td>/XX/YY/</td>\n",
       "      <td>phot.flux.density;phys.polarization</td>\n",
       "      <td>6</td>\n",
       "      <td>306.959997</td>\n",
       "      <td>Azeez, Jazeel H.; Abidin, Zamri Z.; Hwang, C. ...</td>\n",
       "      <td>Centaurus A, with its gas-rich elliptical host...</td>\n",
       "      <td>2014</td>\n",
       "      <td>Science Verification (SV) is the process by wh...</td>\n",
       "      <td>CenA mosaic</td>\n",
       "      <td></td>\n",
       "      <td>13.238502</td>\n",
       "      <td>0.432702</td>\n",
       "      <td>1.663192</td>\n",
       "      <td></td>\n",
       "      <td>uid://A002/X259150/X157</td>\n",
       "      <td>uid://A002/X2762c7/X132</td>\n",
       "      <td>Science verification observation of Centaurus A</td>\n",
       "      <td>SV</td>\n",
       "      <td>TARGET WVR</td>\n",
       "      <td>T</td>\n",
       "      <td>9.714115</td>\n",
       "      <td>1.875000e+09</td>\n",
       "      <td>A004:DV07 A008:DV09 A009:DA41 A011:DV12 A015:D...</td>\n",
       "      <td>T</td>\n",
       "      <td>2016-06-24T14:02:07.000</td>\n",
       "      <td>1.023315</td>\n",
       "      <td>[229.20..231.08GHz,976.56kHz,13.2mJy/beam@10km...</td>\n",
       "      <td>238.261613</td>\n",
       "      <td>1183.847494</td>\n",
       "      <td>observatory, ALMA</td>\n",
       "      <td>ALMA Observations of the Physical and Chemical...</td>\n",
       "      <td>Azeez, Jazeel H. Israel, F. P. McCoy, Mark</td>\n",
       "      <td>T</td>\n",
       "      <td>2014A&amp;A...562A..96I 2017AdAst2017E...6A 2017Ap...</td>\n",
       "      <td>Galactic centres/nuclei, Active Galactic Nucle...</td>\n",
       "      <td>Active galaxies</td>\n",
       "      <td>2021-09-30T16:34:41.133</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>http://almascience.org/aq?member_ous_id=uid://...</td>\n",
       "      <td>text/html</td>\n",
       "      <td>2011.0.00008.SV</td>\n",
       "      <td>Public</td>\n",
       "      <td>309.512363</td>\n",
       "      <td>19.416239</td>\n",
       "      <td>ADS/JAO.ALMA#2011.0.00008.SV</td>\n",
       "      <td>ALMA</td>\n",
       "      <td>JAO</td>\n",
       "      <td>ALMA</td>\n",
       "      <td>uid://A002/X259150/X157</td>\n",
       "      <td>cube</td>\n",
       "      <td>2</td>\n",
       "      <td>Centaurus A</td>\n",
       "      <td>201.360719</td>\n",
       "      <td>-43.020553</td>\n",
       "      <td>0.058089</td>\n",
       "      <td>Polygon ICRS 201.401254 -43.032096 201.401354 ...</td>\n",
       "      <td>1.023315</td>\n",
       "      <td>55784.795689</td>\n",
       "      <td>55785.043473</td>\n",
       "      <td>344.261</td>\n",
       "      <td>344.261</td>\n",
       "      <td>0.001287</td>\n",
       "      <td>0.001297</td>\n",
       "      <td>238519.53752</td>\n",
       "      <td>/XX/YY/</td>\n",
       "      <td>phot.flux.density;phys.polarization</td>\n",
       "      <td>6</td>\n",
       "      <td>306.959997</td>\n",
       "      <td>Azeez, Jazeel H.; Abidin, Zamri Z.; Hwang, C. ...</td>\n",
       "      <td>Centaurus A, with its gas-rich elliptical host...</td>\n",
       "      <td>2014</td>\n",
       "      <td>Science Verification (SV) is the process by wh...</td>\n",
       "      <td>CenA mosaic</td>\n",
       "      <td></td>\n",
       "      <td>13.354480</td>\n",
       "      <td>0.432702</td>\n",
       "      <td>1.663192</td>\n",
       "      <td></td>\n",
       "      <td>uid://A002/X259150/X157</td>\n",
       "      <td>uid://A002/X2762c7/X132</td>\n",
       "      <td>Science verification observation of Centaurus A</td>\n",
       "      <td>SV</td>\n",
       "      <td>TARGET WVR</td>\n",
       "      <td>T</td>\n",
       "      <td>9.714115</td>\n",
       "      <td>1.875000e+09</td>\n",
       "      <td>A004:DV07 A008:DV09 A009:DA41 A011:DV12 A015:D...</td>\n",
       "      <td>T</td>\n",
       "      <td>2016-06-24T14:02:07.000</td>\n",
       "      <td>1.023315</td>\n",
       "      <td>[229.20..231.08GHz,976.56kHz,13.2mJy/beam@10km...</td>\n",
       "      <td>238.261613</td>\n",
       "      <td>1183.847494</td>\n",
       "      <td>observatory, ALMA</td>\n",
       "      <td>ALMA Observations of the Physical and Chemical...</td>\n",
       "      <td>Azeez, Jazeel H. Israel, F. P. McCoy, Mark</td>\n",
       "      <td>T</td>\n",
       "      <td>2014A&amp;A...562A..96I 2017AdAst2017E...6A 2017Ap...</td>\n",
       "      <td>Galactic centres/nuclei, Active Galactic Nucle...</td>\n",
       "      <td>Active galaxies</td>\n",
       "      <td>2021-09-30T16:34:41.133</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                          access_url access_format  \\\n",
       "0  http://almascience.org/aq?member_ous_id=uid://...     text/html   \n",
       "1  http://almascience.org/aq?member_ous_id=uid://...     text/html   \n",
       "2  http://almascience.org/aq?member_ous_id=uid://...     text/html   \n",
       "3  http://almascience.org/aq?member_ous_id=uid://...     text/html   \n",
       "\n",
       "       proposal_id data_rights  gal_longitude  gal_latitude  \\\n",
       "0  2011.0.00008.SV      Public     309.512363     19.416239   \n",
       "1  2011.0.00008.SV      Public     309.512363     19.416239   \n",
       "2  2011.0.00008.SV      Public     309.512363     19.416239   \n",
       "3  2011.0.00008.SV      Public     309.512363     19.416239   \n",
       "\n",
       "              obs_publisher_did obs_collection facility_name instrument_name  \\\n",
       "0  ADS/JAO.ALMA#2011.0.00008.SV           ALMA           JAO            ALMA   \n",
       "1  ADS/JAO.ALMA#2011.0.00008.SV           ALMA           JAO            ALMA   \n",
       "2  ADS/JAO.ALMA#2011.0.00008.SV           ALMA           JAO            ALMA   \n",
       "3  ADS/JAO.ALMA#2011.0.00008.SV           ALMA           JAO            ALMA   \n",
       "\n",
       "                    obs_id dataproduct_type  calib_level  target_name  \\\n",
       "0  uid://A002/X259150/X157             cube            2  Centaurus A   \n",
       "1  uid://A002/X259150/X157             cube            2  Centaurus A   \n",
       "2  uid://A002/X259150/X157             cube            2  Centaurus A   \n",
       "3  uid://A002/X259150/X157             cube            2  Centaurus A   \n",
       "\n",
       "         s_ra      s_dec     s_fov  \\\n",
       "0  201.360719 -43.020553  0.058089   \n",
       "1  201.360719 -43.020553  0.058089   \n",
       "2  201.360719 -43.020553  0.058089   \n",
       "3  201.360719 -43.020553  0.058089   \n",
       "\n",
       "                                            s_region  s_resolution  \\\n",
       "0  Polygon ICRS 201.401254 -43.032096 201.401354 ...      1.023315   \n",
       "1  Polygon ICRS 201.401254 -43.032096 201.401354 ...      1.023315   \n",
       "2  Polygon ICRS 201.401254 -43.032096 201.401354 ...      1.023315   \n",
       "3  Polygon ICRS 201.401254 -43.032096 201.401354 ...      1.023315   \n",
       "\n",
       "          t_min         t_max  t_exptime  t_resolution    em_min    em_max  \\\n",
       "0  55784.795689  55785.043473    344.261       344.261  0.001221  0.001231   \n",
       "1  55784.795689  55785.043473    344.261       344.261  0.001212  0.001221   \n",
       "2  55784.795689  55785.043473    344.261       344.261  0.001297  0.001308   \n",
       "3  55784.795689  55785.043473    344.261       344.261  0.001287  0.001297   \n",
       "\n",
       "   em_res_power pol_states                                o_ucd band_list  \\\n",
       "0  251315.70776    /XX/YY/  phot.flux.density;phys.polarization         6   \n",
       "1  253235.70776    /XX/YY/  phot.flux.density;phys.polarization         6   \n",
       "2  236599.53752    /XX/YY/  phot.flux.density;phys.polarization         6   \n",
       "3  238519.53752    /XX/YY/  phot.flux.density;phys.polarization         6   \n",
       "\n",
       "   em_resolution                                            authors  \\\n",
       "0     306.959997  Azeez, Jazeel H.; Abidin, Zamri Z.; Hwang, C. ...   \n",
       "1     306.959997  Azeez, Jazeel H.; Abidin, Zamri Z.; Hwang, C. ...   \n",
       "2     306.959997  Azeez, Jazeel H.; Abidin, Zamri Z.; Hwang, C. ...   \n",
       "3     306.959997  Azeez, Jazeel H.; Abidin, Zamri Z.; Hwang, C. ...   \n",
       "\n",
       "                                        pub_abstract  publication_year  \\\n",
       "0  Centaurus A, with its gas-rich elliptical host...              2014   \n",
       "1  Centaurus A, with its gas-rich elliptical host...              2014   \n",
       "2  Centaurus A, with its gas-rich elliptical host...              2014   \n",
       "3  Centaurus A, with its gas-rich elliptical host...              2014   \n",
       "\n",
       "                                   proposal_abstract schedblock_name  \\\n",
       "0  Science Verification (SV) is the process by wh...     CenA mosaic   \n",
       "1  Science Verification (SV) is the process by wh...     CenA mosaic   \n",
       "2  Science Verification (SV) is the process by wh...     CenA mosaic   \n",
       "3  Science Verification (SV) is the process by wh...     CenA mosaic   \n",
       "\n",
       "  proposal_authors  sensitivity_10kms  cont_sensitivity_bandwidth       pwv  \\\n",
       "0                           13.319542                    0.432702  1.663192   \n",
       "1                           13.283133                    0.432702  1.663192   \n",
       "2                           13.238502                    0.432702  1.663192   \n",
       "3                           13.354480                    0.432702  1.663192   \n",
       "\n",
       "  group_ous_uid           member_ous_uid                 asdm_uid  \\\n",
       "0                uid://A002/X259150/X157  uid://A002/X2762c7/X132   \n",
       "1                uid://A002/X259150/X157  uid://A002/X2762c7/X132   \n",
       "2                uid://A002/X259150/X157  uid://A002/X2762c7/X132   \n",
       "3                uid://A002/X259150/X157  uid://A002/X2762c7/X132   \n",
       "\n",
       "                                         obs_title type scan_intent  \\\n",
       "0  Science verification observation of Centaurus A   SV  TARGET WVR   \n",
       "1  Science verification observation of Centaurus A   SV  TARGET WVR   \n",
       "2  Science verification observation of Centaurus A   SV  TARGET WVR   \n",
       "3  Science verification observation of Centaurus A   SV  TARGET WVR   \n",
       "\n",
       "  science_observation  spatial_scale_max     bandwidth  \\\n",
       "0                   T           9.714115  1.875000e+09   \n",
       "1                   T           9.714115  1.875000e+09   \n",
       "2                   T           9.714115  1.875000e+09   \n",
       "3                   T           9.714115  1.875000e+09   \n",
       "\n",
       "                                      antenna_arrays is_mosaic  \\\n",
       "0  A004:DV07 A008:DV09 A009:DA41 A011:DV12 A015:D...         T   \n",
       "1  A004:DV07 A008:DV09 A009:DA41 A011:DV12 A015:D...         T   \n",
       "2  A004:DV07 A008:DV09 A009:DA41 A011:DV12 A015:D...         T   \n",
       "3  A004:DV07 A008:DV09 A009:DA41 A011:DV12 A015:D...         T   \n",
       "\n",
       "          obs_release_date  spatial_resolution  \\\n",
       "0  2016-06-24T14:02:07.000            1.023315   \n",
       "1  2016-06-24T14:02:07.000            1.023315   \n",
       "2  2016-06-24T14:02:07.000            1.023315   \n",
       "3  2016-06-24T14:02:07.000            1.023315   \n",
       "\n",
       "                                   frequency_support   frequency  \\\n",
       "0  [229.20..231.08GHz,976.56kHz,13.2mJy/beam@10km...  238.261613   \n",
       "1  [229.20..231.08GHz,976.56kHz,13.2mJy/beam@10km...  238.261613   \n",
       "2  [229.20..231.08GHz,976.56kHz,13.2mJy/beam@10km...  238.261613   \n",
       "3  [229.20..231.08GHz,976.56kHz,13.2mJy/beam@10km...  238.261613   \n",
       "\n",
       "   velocity_resolution   obs_creator_name  \\\n",
       "0          1183.847494  observatory, ALMA   \n",
       "1          1183.847494  observatory, ALMA   \n",
       "2          1183.847494  observatory, ALMA   \n",
       "3          1183.847494  observatory, ALMA   \n",
       "\n",
       "                                           pub_title  \\\n",
       "0  ALMA Observations of the Physical and Chemical...   \n",
       "1  ALMA Observations of the Physical and Chemical...   \n",
       "2  ALMA Observations of the Physical and Chemical...   \n",
       "3  ALMA Observations of the Physical and Chemical...   \n",
       "\n",
       "                                 first_author qa2_passed  \\\n",
       "0  Azeez, Jazeel H. Israel, F. P. McCoy, Mark          T   \n",
       "1  Azeez, Jazeel H. Israel, F. P. McCoy, Mark          T   \n",
       "2  Azeez, Jazeel H. Israel, F. P. McCoy, Mark          T   \n",
       "3  Azeez, Jazeel H. Israel, F. P. McCoy, Mark          T   \n",
       "\n",
       "                                       bib_reference  \\\n",
       "0  2014A&A...562A..96I 2017AdAst2017E...6A 2017Ap...   \n",
       "1  2014A&A...562A..96I 2017AdAst2017E...6A 2017Ap...   \n",
       "2  2014A&A...562A..96I 2017AdAst2017E...6A 2017Ap...   \n",
       "3  2014A&A...562A..96I 2017AdAst2017E...6A 2017Ap...   \n",
       "\n",
       "                                     science_keyword scientific_category  \\\n",
       "0  Galactic centres/nuclei, Active Galactic Nucle...     Active galaxies   \n",
       "1  Galactic centres/nuclei, Active Galactic Nucle...     Active galaxies   \n",
       "2  Galactic centres/nuclei, Active Galactic Nucle...     Active galaxies   \n",
       "3  Galactic centres/nuclei, Active Galactic Nucle...     Active galaxies   \n",
       "\n",
       "              lastModified  \n",
       "0  2021-09-30T16:34:41.133  \n",
       "1  2021-09-30T16:34:41.133  \n",
       "2  2021-09-30T16:34:41.133  \n",
       "3  2021-09-30T16:34:41.133  "
      ]
     },
     "execution_count": 1,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "query_alma_source_name_exact(service, \"Centaurus A\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "-----------------\n",
    "\n",
    "## Example 1d: Query the source name \"Centaurus\"\n",
    "Since source names in the ALMA proposals might be spelled differently it can be useful to search for parts of the name."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {
    "execution": {
     "iopub.execute_input": "2021-11-16T10:25:50.436599Z",
     "iopub.status.busy": "2021-11-16T10:25:50.435755Z",
     "iopub.status.idle": "2021-11-16T10:25:52.317580Z",
     "shell.execute_reply": "2021-11-16T10:25:52.317036Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>access_url</th>\n",
       "      <th>access_format</th>\n",
       "      <th>proposal_id</th>\n",
       "      <th>data_rights</th>\n",
       "      <th>gal_longitude</th>\n",
       "      <th>gal_latitude</th>\n",
       "      <th>obs_publisher_did</th>\n",
       "      <th>obs_collection</th>\n",
       "      <th>facility_name</th>\n",
       "      <th>instrument_name</th>\n",
       "      <th>obs_id</th>\n",
       "      <th>dataproduct_type</th>\n",
       "      <th>calib_level</th>\n",
       "      <th>target_name</th>\n",
       "      <th>s_ra</th>\n",
       "      <th>s_dec</th>\n",
       "      <th>s_fov</th>\n",
       "      <th>s_region</th>\n",
       "      <th>s_resolution</th>\n",
       "      <th>t_min</th>\n",
       "      <th>t_max</th>\n",
       "      <th>t_exptime</th>\n",
       "      <th>t_resolution</th>\n",
       "      <th>em_min</th>\n",
       "      <th>em_max</th>\n",
       "      <th>em_res_power</th>\n",
       "      <th>pol_states</th>\n",
       "      <th>o_ucd</th>\n",
       "      <th>band_list</th>\n",
       "      <th>em_resolution</th>\n",
       "      <th>authors</th>\n",
       "      <th>pub_abstract</th>\n",
       "      <th>publication_year</th>\n",
       "      <th>proposal_abstract</th>\n",
       "      <th>schedblock_name</th>\n",
       "      <th>proposal_authors</th>\n",
       "      <th>sensitivity_10kms</th>\n",
       "      <th>cont_sensitivity_bandwidth</th>\n",
       "      <th>pwv</th>\n",
       "      <th>group_ous_uid</th>\n",
       "      <th>member_ous_uid</th>\n",
       "      <th>asdm_uid</th>\n",
       "      <th>obs_title</th>\n",
       "      <th>type</th>\n",
       "      <th>scan_intent</th>\n",
       "      <th>science_observation</th>\n",
       "      <th>spatial_scale_max</th>\n",
       "      <th>bandwidth</th>\n",
       "      <th>antenna_arrays</th>\n",
       "      <th>is_mosaic</th>\n",
       "      <th>obs_release_date</th>\n",
       "      <th>spatial_resolution</th>\n",
       "      <th>frequency_support</th>\n",
       "      <th>frequency</th>\n",
       "      <th>velocity_resolution</th>\n",
       "      <th>obs_creator_name</th>\n",
       "      <th>pub_title</th>\n",
       "      <th>first_author</th>\n",
       "      <th>qa2_passed</th>\n",
       "      <th>bib_reference</th>\n",
       "      <th>science_keyword</th>\n",
       "      <th>scientific_category</th>\n",
       "      <th>lastModified</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>http://almascience.org/aq?member_ous_id=uid://...</td>\n",
       "      <td>text/html</td>\n",
       "      <td>2011.0.00008.SV</td>\n",
       "      <td>Public</td>\n",
       "      <td>309.512363</td>\n",
       "      <td>19.416239</td>\n",
       "      <td>ADS/JAO.ALMA#2011.0.00008.SV</td>\n",
       "      <td>ALMA</td>\n",
       "      <td>JAO</td>\n",
       "      <td>ALMA</td>\n",
       "      <td>uid://A002/X259150/X157</td>\n",
       "      <td>cube</td>\n",
       "      <td>2</td>\n",
       "      <td>Centaurus A</td>\n",
       "      <td>201.360719</td>\n",
       "      <td>-43.020553</td>\n",
       "      <td>0.058089</td>\n",
       "      <td>Polygon ICRS 201.401254 -43.032096 201.401354 ...</td>\n",
       "      <td>1.023315</td>\n",
       "      <td>55784.795689</td>\n",
       "      <td>55785.043473</td>\n",
       "      <td>344.261</td>\n",
       "      <td>344.261</td>\n",
       "      <td>0.001221</td>\n",
       "      <td>0.001231</td>\n",
       "      <td>251315.707760</td>\n",
       "      <td>/XX/YY/</td>\n",
       "      <td>phot.flux.density;phys.polarization</td>\n",
       "      <td>6</td>\n",
       "      <td>306.959997</td>\n",
       "      <td>Azeez, Jazeel H.; Abidin, Zamri Z.; Hwang, C. ...</td>\n",
       "      <td>Centaurus A, with its gas-rich elliptical host...</td>\n",
       "      <td>2014</td>\n",
       "      <td>Science Verification (SV) is the process by wh...</td>\n",
       "      <td>CenA mosaic</td>\n",
       "      <td></td>\n",
       "      <td>13.319542</td>\n",
       "      <td>0.432702</td>\n",
       "      <td>1.663192</td>\n",
       "      <td></td>\n",
       "      <td>uid://A002/X259150/X157</td>\n",
       "      <td>uid://A002/X2762c7/X132</td>\n",
       "      <td>Science verification observation of Centaurus A</td>\n",
       "      <td>SV</td>\n",
       "      <td>TARGET WVR</td>\n",
       "      <td>T</td>\n",
       "      <td>9.714115</td>\n",
       "      <td>1.875000e+09</td>\n",
       "      <td>A004:DV07 A008:DV09 A009:DA41 A011:DV12 A015:D...</td>\n",
       "      <td>T</td>\n",
       "      <td>2016-06-24T14:02:07.000</td>\n",
       "      <td>1.023315</td>\n",
       "      <td>[229.20..231.08GHz,976.56kHz,13.2mJy/beam@10km...</td>\n",
       "      <td>238.261613</td>\n",
       "      <td>1183.847494</td>\n",
       "      <td>observatory, ALMA</td>\n",
       "      <td>ALMA Observations of the Physical and Chemical...</td>\n",
       "      <td>Azeez, Jazeel H. Israel, F. P. McCoy, Mark</td>\n",
       "      <td>T</td>\n",
       "      <td>2014A&amp;A...562A..96I 2017AdAst2017E...6A 2017Ap...</td>\n",
       "      <td>Galactic centres/nuclei, Active Galactic Nucle...</td>\n",
       "      <td>Active galaxies</td>\n",
       "      <td>2021-09-30T16:34:41.133</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>http://almascience.org/aq?member_ous_id=uid://...</td>\n",
       "      <td>text/html</td>\n",
       "      <td>2011.0.00008.SV</td>\n",
       "      <td>Public</td>\n",
       "      <td>309.512363</td>\n",
       "      <td>19.416239</td>\n",
       "      <td>ADS/JAO.ALMA#2011.0.00008.SV</td>\n",
       "      <td>ALMA</td>\n",
       "      <td>JAO</td>\n",
       "      <td>ALMA</td>\n",
       "      <td>uid://A002/X259150/X157</td>\n",
       "      <td>cube</td>\n",
       "      <td>2</td>\n",
       "      <td>Centaurus A</td>\n",
       "      <td>201.360719</td>\n",
       "      <td>-43.020553</td>\n",
       "      <td>0.058089</td>\n",
       "      <td>Polygon ICRS 201.401254 -43.032096 201.401354 ...</td>\n",
       "      <td>1.023315</td>\n",
       "      <td>55784.795689</td>\n",
       "      <td>55785.043473</td>\n",
       "      <td>344.261</td>\n",
       "      <td>344.261</td>\n",
       "      <td>0.001212</td>\n",
       "      <td>0.001221</td>\n",
       "      <td>253235.707760</td>\n",
       "      <td>/XX/YY/</td>\n",
       "      <td>phot.flux.density;phys.polarization</td>\n",
       "      <td>6</td>\n",
       "      <td>306.959997</td>\n",
       "      <td>Azeez, Jazeel H.; Abidin, Zamri Z.; Hwang, C. ...</td>\n",
       "      <td>Centaurus A, with its gas-rich elliptical host...</td>\n",
       "      <td>2014</td>\n",
       "      <td>Science Verification (SV) is the process by wh...</td>\n",
       "      <td>CenA mosaic</td>\n",
       "      <td></td>\n",
       "      <td>13.283133</td>\n",
       "      <td>0.432702</td>\n",
       "      <td>1.663192</td>\n",
       "      <td></td>\n",
       "      <td>uid://A002/X259150/X157</td>\n",
       "      <td>uid://A002/X2762c7/X132</td>\n",
       "      <td>Science verification observation of Centaurus A</td>\n",
       "      <td>SV</td>\n",
       "      <td>TARGET WVR</td>\n",
       "      <td>T</td>\n",
       "      <td>9.714115</td>\n",
       "      <td>1.875000e+09</td>\n",
       "      <td>A004:DV07 A008:DV09 A009:DA41 A011:DV12 A015:D...</td>\n",
       "      <td>T</td>\n",
       "      <td>2016-06-24T14:02:07.000</td>\n",
       "      <td>1.023315</td>\n",
       "      <td>[229.20..231.08GHz,976.56kHz,13.2mJy/beam@10km...</td>\n",
       "      <td>238.261613</td>\n",
       "      <td>1183.847494</td>\n",
       "      <td>observatory, ALMA</td>\n",
       "      <td>ALMA Observations of the Physical and Chemical...</td>\n",
       "      <td>Azeez, Jazeel H. Israel, F. P. McCoy, Mark</td>\n",
       "      <td>T</td>\n",
       "      <td>2014A&amp;A...562A..96I 2017AdAst2017E...6A 2017Ap...</td>\n",
       "      <td>Galactic centres/nuclei, Active Galactic Nucle...</td>\n",
       "      <td>Active galaxies</td>\n",
       "      <td>2021-09-30T16:34:41.133</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>http://almascience.org/aq?member_ous_id=uid://...</td>\n",
       "      <td>text/html</td>\n",
       "      <td>2011.0.00008.SV</td>\n",
       "      <td>Public</td>\n",
       "      <td>309.512363</td>\n",
       "      <td>19.416239</td>\n",
       "      <td>ADS/JAO.ALMA#2011.0.00008.SV</td>\n",
       "      <td>ALMA</td>\n",
       "      <td>JAO</td>\n",
       "      <td>ALMA</td>\n",
       "      <td>uid://A002/X259150/X157</td>\n",
       "      <td>cube</td>\n",
       "      <td>2</td>\n",
       "      <td>Centaurus A</td>\n",
       "      <td>201.360719</td>\n",
       "      <td>-43.020553</td>\n",
       "      <td>0.058089</td>\n",
       "      <td>Polygon ICRS 201.401254 -43.032096 201.401354 ...</td>\n",
       "      <td>1.023315</td>\n",
       "      <td>55784.795689</td>\n",
       "      <td>55785.043473</td>\n",
       "      <td>344.261</td>\n",
       "      <td>344.261</td>\n",
       "      <td>0.001297</td>\n",
       "      <td>0.001308</td>\n",
       "      <td>236599.537520</td>\n",
       "      <td>/XX/YY/</td>\n",
       "      <td>phot.flux.density;phys.polarization</td>\n",
       "      <td>6</td>\n",
       "      <td>306.959997</td>\n",
       "      <td>Azeez, Jazeel H.; Abidin, Zamri Z.; Hwang, C. ...</td>\n",
       "      <td>Centaurus A, with its gas-rich elliptical host...</td>\n",
       "      <td>2014</td>\n",
       "      <td>Science Verification (SV) is the process by wh...</td>\n",
       "      <td>CenA mosaic</td>\n",
       "      <td></td>\n",
       "      <td>13.238502</td>\n",
       "      <td>0.432702</td>\n",
       "      <td>1.663192</td>\n",
       "      <td></td>\n",
       "      <td>uid://A002/X259150/X157</td>\n",
       "      <td>uid://A002/X2762c7/X132</td>\n",
       "      <td>Science verification observation of Centaurus A</td>\n",
       "      <td>SV</td>\n",
       "      <td>TARGET WVR</td>\n",
       "      <td>T</td>\n",
       "      <td>9.714115</td>\n",
       "      <td>1.875000e+09</td>\n",
       "      <td>A004:DV07 A008:DV09 A009:DA41 A011:DV12 A015:D...</td>\n",
       "      <td>T</td>\n",
       "      <td>2016-06-24T14:02:07.000</td>\n",
       "      <td>1.023315</td>\n",
       "      <td>[229.20..231.08GHz,976.56kHz,13.2mJy/beam@10km...</td>\n",
       "      <td>238.261613</td>\n",
       "      <td>1183.847494</td>\n",
       "      <td>observatory, ALMA</td>\n",
       "      <td>ALMA Observations of the Physical and Chemical...</td>\n",
       "      <td>Azeez, Jazeel H. Israel, F. P. McCoy, Mark</td>\n",
       "      <td>T</td>\n",
       "      <td>2014A&amp;A...562A..96I 2017AdAst2017E...6A 2017Ap...</td>\n",
       "      <td>Galactic centres/nuclei, Active Galactic Nucle...</td>\n",
       "      <td>Active galaxies</td>\n",
       "      <td>2021-09-30T16:34:41.133</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>http://almascience.org/aq?member_ous_id=uid://...</td>\n",
       "      <td>text/html</td>\n",
       "      <td>2011.0.00008.SV</td>\n",
       "      <td>Public</td>\n",
       "      <td>309.512363</td>\n",
       "      <td>19.416239</td>\n",
       "      <td>ADS/JAO.ALMA#2011.0.00008.SV</td>\n",
       "      <td>ALMA</td>\n",
       "      <td>JAO</td>\n",
       "      <td>ALMA</td>\n",
       "      <td>uid://A002/X259150/X157</td>\n",
       "      <td>cube</td>\n",
       "      <td>2</td>\n",
       "      <td>Centaurus A</td>\n",
       "      <td>201.360719</td>\n",
       "      <td>-43.020553</td>\n",
       "      <td>0.058089</td>\n",
       "      <td>Polygon ICRS 201.401254 -43.032096 201.401354 ...</td>\n",
       "      <td>1.023315</td>\n",
       "      <td>55784.795689</td>\n",
       "      <td>55785.043473</td>\n",
       "      <td>344.261</td>\n",
       "      <td>344.261</td>\n",
       "      <td>0.001287</td>\n",
       "      <td>0.001297</td>\n",
       "      <td>238519.537520</td>\n",
       "      <td>/XX/YY/</td>\n",
       "      <td>phot.flux.density;phys.polarization</td>\n",
       "      <td>6</td>\n",
       "      <td>306.959997</td>\n",
       "      <td>Azeez, Jazeel H.; Abidin, Zamri Z.; Hwang, C. ...</td>\n",
       "      <td>Centaurus A, with its gas-rich elliptical host...</td>\n",
       "      <td>2014</td>\n",
       "      <td>Science Verification (SV) is the process by wh...</td>\n",
       "      <td>CenA mosaic</td>\n",
       "      <td></td>\n",
       "      <td>13.354480</td>\n",
       "      <td>0.432702</td>\n",
       "      <td>1.663192</td>\n",
       "      <td></td>\n",
       "      <td>uid://A002/X259150/X157</td>\n",
       "      <td>uid://A002/X2762c7/X132</td>\n",
       "      <td>Science verification observation of Centaurus A</td>\n",
       "      <td>SV</td>\n",
       "      <td>TARGET WVR</td>\n",
       "      <td>T</td>\n",
       "      <td>9.714115</td>\n",
       "      <td>1.875000e+09</td>\n",
       "      <td>A004:DV07 A008:DV09 A009:DA41 A011:DV12 A015:D...</td>\n",
       "      <td>T</td>\n",
       "      <td>2016-06-24T14:02:07.000</td>\n",
       "      <td>1.023315</td>\n",
       "      <td>[229.20..231.08GHz,976.56kHz,13.2mJy/beam@10km...</td>\n",
       "      <td>238.261613</td>\n",
       "      <td>1183.847494</td>\n",
       "      <td>observatory, ALMA</td>\n",
       "      <td>ALMA Observations of the Physical and Chemical...</td>\n",
       "      <td>Azeez, Jazeel H. Israel, F. P. McCoy, Mark</td>\n",
       "      <td>T</td>\n",
       "      <td>2014A&amp;A...562A..96I 2017AdAst2017E...6A 2017Ap...</td>\n",
       "      <td>Galactic centres/nuclei, Active Galactic Nucle...</td>\n",
       "      <td>Active galaxies</td>\n",
       "      <td>2021-09-30T16:34:41.133</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>http://almascience.org/aq?member_ous_id=uid://...</td>\n",
       "      <td>text/html</td>\n",
       "      <td>2012.1.00019.S</td>\n",
       "      <td>Public</td>\n",
       "      <td>309.515913</td>\n",
       "      <td>19.417223</td>\n",
       "      <td>ADS/JAO.ALMA#2012.1.00019.S</td>\n",
       "      <td>ALMA</td>\n",
       "      <td>JAO</td>\n",
       "      <td>ALMA</td>\n",
       "      <td>uid://A002/X6444ba/X88</td>\n",
       "      <td>cube</td>\n",
       "      <td>2</td>\n",
       "      <td>Centaurus_A</td>\n",
       "      <td>201.365065</td>\n",
       "      <td>-43.019111</td>\n",
       "      <td>0.051984</td>\n",
       "      <td>Polygon ICRS 201.390398 -43.031990 201.392746 ...</td>\n",
       "      <td>4.251107</td>\n",
       "      <td>56658.442943</td>\n",
       "      <td>56680.464690</td>\n",
       "      <td>119.578</td>\n",
       "      <td>119.578</td>\n",
       "      <td>0.001362</td>\n",
       "      <td>0.001375</td>\n",
       "      <td>225399.234508</td>\n",
       "      <td>/XX/YY/</td>\n",
       "      <td>phot.flux.density;phys.polarization</td>\n",
       "      <td>6</td>\n",
       "      <td>2456.090639</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>Many large elliptical galaxies contain embedde...</td>\n",
       "      <td>B6_Cen_A_13CO2-1_7m</td>\n",
       "      <td>Espada, Daniel; Loenen, Edo; de Graauw, Thijs;...</td>\n",
       "      <td>41.183726</td>\n",
       "      <td>1.417465</td>\n",
       "      <td>1.800000</td>\n",
       "      <td>uid://A002/X6444ba/X85</td>\n",
       "      <td>uid://A002/X6444ba/X88</td>\n",
       "      <td>uid://A002/X77da97/X1896</td>\n",
       "      <td>Probing the merger remnant disk in the giant e...</td>\n",
       "      <td>S</td>\n",
       "      <td>TARGET</td>\n",
       "      <td>T</td>\n",
       "      <td>23.072080</td>\n",
       "      <td>1.992188e+09</td>\n",
       "      <td>J502:CM02 J503:CM03 J504:CM12 J505:CM08 J506:C...</td>\n",
       "      <td>T</td>\n",
       "      <td>2015-05-07T00:00:00.000</td>\n",
       "      <td>4.251107</td>\n",
       "      <td>[218.11..220.10GHz,976.56kHz,41.2mJy/beam@10km...</td>\n",
       "      <td>219.548974</td>\n",
       "      <td>166.241262</td>\n",
       "      <td>Israel, Frank</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>T</td>\n",
       "      <td></td>\n",
       "      <td>Merging and interacting galaxies, Early-type g...</td>\n",
       "      <td>Galaxy evolution</td>\n",
       "      <td>2021-09-30T16:34:41.133</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                          access_url access_format  \\\n",
       "0  http://almascience.org/aq?member_ous_id=uid://...     text/html   \n",
       "1  http://almascience.org/aq?member_ous_id=uid://...     text/html   \n",
       "2  http://almascience.org/aq?member_ous_id=uid://...     text/html   \n",
       "3  http://almascience.org/aq?member_ous_id=uid://...     text/html   \n",
       "4  http://almascience.org/aq?member_ous_id=uid://...     text/html   \n",
       "\n",
       "       proposal_id data_rights  gal_longitude  gal_latitude  \\\n",
       "0  2011.0.00008.SV      Public     309.512363     19.416239   \n",
       "1  2011.0.00008.SV      Public     309.512363     19.416239   \n",
       "2  2011.0.00008.SV      Public     309.512363     19.416239   \n",
       "3  2011.0.00008.SV      Public     309.512363     19.416239   \n",
       "4   2012.1.00019.S      Public     309.515913     19.417223   \n",
       "\n",
       "              obs_publisher_did obs_collection facility_name instrument_name  \\\n",
       "0  ADS/JAO.ALMA#2011.0.00008.SV           ALMA           JAO            ALMA   \n",
       "1  ADS/JAO.ALMA#2011.0.00008.SV           ALMA           JAO            ALMA   \n",
       "2  ADS/JAO.ALMA#2011.0.00008.SV           ALMA           JAO            ALMA   \n",
       "3  ADS/JAO.ALMA#2011.0.00008.SV           ALMA           JAO            ALMA   \n",
       "4   ADS/JAO.ALMA#2012.1.00019.S           ALMA           JAO            ALMA   \n",
       "\n",
       "                    obs_id dataproduct_type  calib_level  target_name  \\\n",
       "0  uid://A002/X259150/X157             cube            2  Centaurus A   \n",
       "1  uid://A002/X259150/X157             cube            2  Centaurus A   \n",
       "2  uid://A002/X259150/X157             cube            2  Centaurus A   \n",
       "3  uid://A002/X259150/X157             cube            2  Centaurus A   \n",
       "4   uid://A002/X6444ba/X88             cube            2  Centaurus_A   \n",
       "\n",
       "         s_ra      s_dec     s_fov  \\\n",
       "0  201.360719 -43.020553  0.058089   \n",
       "1  201.360719 -43.020553  0.058089   \n",
       "2  201.360719 -43.020553  0.058089   \n",
       "3  201.360719 -43.020553  0.058089   \n",
       "4  201.365065 -43.019111  0.051984   \n",
       "\n",
       "                                            s_region  s_resolution  \\\n",
       "0  Polygon ICRS 201.401254 -43.032096 201.401354 ...      1.023315   \n",
       "1  Polygon ICRS 201.401254 -43.032096 201.401354 ...      1.023315   \n",
       "2  Polygon ICRS 201.401254 -43.032096 201.401354 ...      1.023315   \n",
       "3  Polygon ICRS 201.401254 -43.032096 201.401354 ...      1.023315   \n",
       "4  Polygon ICRS 201.390398 -43.031990 201.392746 ...      4.251107   \n",
       "\n",
       "          t_min         t_max  t_exptime  t_resolution    em_min    em_max  \\\n",
       "0  55784.795689  55785.043473    344.261       344.261  0.001221  0.001231   \n",
       "1  55784.795689  55785.043473    344.261       344.261  0.001212  0.001221   \n",
       "2  55784.795689  55785.043473    344.261       344.261  0.001297  0.001308   \n",
       "3  55784.795689  55785.043473    344.261       344.261  0.001287  0.001297   \n",
       "4  56658.442943  56680.464690    119.578       119.578  0.001362  0.001375   \n",
       "\n",
       "    em_res_power pol_states                                o_ucd band_list  \\\n",
       "0  251315.707760    /XX/YY/  phot.flux.density;phys.polarization         6   \n",
       "1  253235.707760    /XX/YY/  phot.flux.density;phys.polarization         6   \n",
       "2  236599.537520    /XX/YY/  phot.flux.density;phys.polarization         6   \n",
       "3  238519.537520    /XX/YY/  phot.flux.density;phys.polarization         6   \n",
       "4  225399.234508    /XX/YY/  phot.flux.density;phys.polarization         6   \n",
       "\n",
       "   em_resolution                                            authors  \\\n",
       "0     306.959997  Azeez, Jazeel H.; Abidin, Zamri Z.; Hwang, C. ...   \n",
       "1     306.959997  Azeez, Jazeel H.; Abidin, Zamri Z.; Hwang, C. ...   \n",
       "2     306.959997  Azeez, Jazeel H.; Abidin, Zamri Z.; Hwang, C. ...   \n",
       "3     306.959997  Azeez, Jazeel H.; Abidin, Zamri Z.; Hwang, C. ...   \n",
       "4    2456.090639                                                      \n",
       "\n",
       "                                        pub_abstract  publication_year  \\\n",
       "0  Centaurus A, with its gas-rich elliptical host...              2014   \n",
       "1  Centaurus A, with its gas-rich elliptical host...              2014   \n",
       "2  Centaurus A, with its gas-rich elliptical host...              2014   \n",
       "3  Centaurus A, with its gas-rich elliptical host...              2014   \n",
       "4                                                                 <NA>   \n",
       "\n",
       "                                   proposal_abstract      schedblock_name  \\\n",
       "0  Science Verification (SV) is the process by wh...          CenA mosaic   \n",
       "1  Science Verification (SV) is the process by wh...          CenA mosaic   \n",
       "2  Science Verification (SV) is the process by wh...          CenA mosaic   \n",
       "3  Science Verification (SV) is the process by wh...          CenA mosaic   \n",
       "4  Many large elliptical galaxies contain embedde...  B6_Cen_A_13CO2-1_7m   \n",
       "\n",
       "                                    proposal_authors  sensitivity_10kms  \\\n",
       "0                                                             13.319542   \n",
       "1                                                             13.283133   \n",
       "2                                                             13.238502   \n",
       "3                                                             13.354480   \n",
       "4  Espada, Daniel; Loenen, Edo; de Graauw, Thijs;...          41.183726   \n",
       "\n",
       "   cont_sensitivity_bandwidth       pwv           group_ous_uid  \\\n",
       "0                    0.432702  1.663192                           \n",
       "1                    0.432702  1.663192                           \n",
       "2                    0.432702  1.663192                           \n",
       "3                    0.432702  1.663192                           \n",
       "4                    1.417465  1.800000  uid://A002/X6444ba/X85   \n",
       "\n",
       "            member_ous_uid                  asdm_uid  \\\n",
       "0  uid://A002/X259150/X157   uid://A002/X2762c7/X132   \n",
       "1  uid://A002/X259150/X157   uid://A002/X2762c7/X132   \n",
       "2  uid://A002/X259150/X157   uid://A002/X2762c7/X132   \n",
       "3  uid://A002/X259150/X157   uid://A002/X2762c7/X132   \n",
       "4   uid://A002/X6444ba/X88  uid://A002/X77da97/X1896   \n",
       "\n",
       "                                           obs_title type scan_intent  \\\n",
       "0    Science verification observation of Centaurus A   SV  TARGET WVR   \n",
       "1    Science verification observation of Centaurus A   SV  TARGET WVR   \n",
       "2    Science verification observation of Centaurus A   SV  TARGET WVR   \n",
       "3    Science verification observation of Centaurus A   SV  TARGET WVR   \n",
       "4  Probing the merger remnant disk in the giant e...    S      TARGET   \n",
       "\n",
       "  science_observation  spatial_scale_max     bandwidth  \\\n",
       "0                   T           9.714115  1.875000e+09   \n",
       "1                   T           9.714115  1.875000e+09   \n",
       "2                   T           9.714115  1.875000e+09   \n",
       "3                   T           9.714115  1.875000e+09   \n",
       "4                   T          23.072080  1.992188e+09   \n",
       "\n",
       "                                      antenna_arrays is_mosaic  \\\n",
       "0  A004:DV07 A008:DV09 A009:DA41 A011:DV12 A015:D...         T   \n",
       "1  A004:DV07 A008:DV09 A009:DA41 A011:DV12 A015:D...         T   \n",
       "2  A004:DV07 A008:DV09 A009:DA41 A011:DV12 A015:D...         T   \n",
       "3  A004:DV07 A008:DV09 A009:DA41 A011:DV12 A015:D...         T   \n",
       "4  J502:CM02 J503:CM03 J504:CM12 J505:CM08 J506:C...         T   \n",
       "\n",
       "          obs_release_date  spatial_resolution  \\\n",
       "0  2016-06-24T14:02:07.000            1.023315   \n",
       "1  2016-06-24T14:02:07.000            1.023315   \n",
       "2  2016-06-24T14:02:07.000            1.023315   \n",
       "3  2016-06-24T14:02:07.000            1.023315   \n",
       "4  2015-05-07T00:00:00.000            4.251107   \n",
       "\n",
       "                                   frequency_support   frequency  \\\n",
       "0  [229.20..231.08GHz,976.56kHz,13.2mJy/beam@10km...  238.261613   \n",
       "1  [229.20..231.08GHz,976.56kHz,13.2mJy/beam@10km...  238.261613   \n",
       "2  [229.20..231.08GHz,976.56kHz,13.2mJy/beam@10km...  238.261613   \n",
       "3  [229.20..231.08GHz,976.56kHz,13.2mJy/beam@10km...  238.261613   \n",
       "4  [218.11..220.10GHz,976.56kHz,41.2mJy/beam@10km...  219.548974   \n",
       "\n",
       "   velocity_resolution   obs_creator_name  \\\n",
       "0          1183.847494  observatory, ALMA   \n",
       "1          1183.847494  observatory, ALMA   \n",
       "2          1183.847494  observatory, ALMA   \n",
       "3          1183.847494  observatory, ALMA   \n",
       "4           166.241262      Israel, Frank   \n",
       "\n",
       "                                           pub_title  \\\n",
       "0  ALMA Observations of the Physical and Chemical...   \n",
       "1  ALMA Observations of the Physical and Chemical...   \n",
       "2  ALMA Observations of the Physical and Chemical...   \n",
       "3  ALMA Observations of the Physical and Chemical...   \n",
       "4                                                      \n",
       "\n",
       "                                 first_author qa2_passed  \\\n",
       "0  Azeez, Jazeel H. Israel, F. P. McCoy, Mark          T   \n",
       "1  Azeez, Jazeel H. Israel, F. P. McCoy, Mark          T   \n",
       "2  Azeez, Jazeel H. Israel, F. P. McCoy, Mark          T   \n",
       "3  Azeez, Jazeel H. Israel, F. P. McCoy, Mark          T   \n",
       "4                                                      T   \n",
       "\n",
       "                                       bib_reference  \\\n",
       "0  2014A&A...562A..96I 2017AdAst2017E...6A 2017Ap...   \n",
       "1  2014A&A...562A..96I 2017AdAst2017E...6A 2017Ap...   \n",
       "2  2014A&A...562A..96I 2017AdAst2017E...6A 2017Ap...   \n",
       "3  2014A&A...562A..96I 2017AdAst2017E...6A 2017Ap...   \n",
       "4                                                      \n",
       "\n",
       "                                     science_keyword scientific_category  \\\n",
       "0  Galactic centres/nuclei, Active Galactic Nucle...     Active galaxies   \n",
       "1  Galactic centres/nuclei, Active Galactic Nucle...     Active galaxies   \n",
       "2  Galactic centres/nuclei, Active Galactic Nucle...     Active galaxies   \n",
       "3  Galactic centres/nuclei, Active Galactic Nucle...     Active galaxies   \n",
       "4  Merging and interacting galaxies, Early-type g...    Galaxy evolution   \n",
       "\n",
       "              lastModified  \n",
       "0  2021-09-30T16:34:41.133  \n",
       "1  2021-09-30T16:34:41.133  \n",
       "2  2021-09-30T16:34:41.133  \n",
       "3  2021-09-30T16:34:41.133  \n",
       "4  2021-09-30T16:34:41.133  "
      ]
     },
     "execution_count": 1,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "table = query_alma_source_name_included(service, \"ntaur\")\n",
    "table.head(5) ### showing only first 5 rows"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.10"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}