documentation.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "7bebc52e-3034-4981-9e46-294726924a40",
   "metadata": {},
   "source": [
    "# Searching the Roman_DESC Sims\n",
    "\n",
    "The web server at https://roman-desc-simdex.lbl.gov has indexes of the transient truth tables and the Roman images.  (Hopefully in the not-too-distant future it will have the Rubin images as well.)\n",
    "\n",
    "Search it by hitting a URL like  `https:://roman/desc/simdex.lbl.gov/<command>`, where `<command>` is one of `findromanimages`, `findtransients`, and eventually maybe other things.  You can pass additional parameters by adding one or more `/<kw>=<val>` to the end of the URL (sparating each kw/val pair with a slash), or sending a dictionary in the POST data.  Examples of both of these are below.\n",
    "    \n",
    "## Finding Roman Images\n",
    "    \n",
    "**NOTE**: As of this writing, about 500 out of 58,000 Roman pointings are not in the database.  Reason: the images on NERSC were missing at least one SCA for those pointings.  Hopefully this will be addressed in the not-too-distant future.\n",
    "    \n",
    "The URL for finding images is https://roman-desc-simdex.lbl.gov/findromanimages.  (If you click on that link as-is, you will get an error return because you specified no criteria.)  You can filter on the following keywords:\n",
    "* `num` — the pointing number\n",
    "* `pointing_ra` — the RA of the pointing itself (not of any individual SCA)\n",
    "* `pointing_dec` — the Dec of the pointing itself\n",
    "* `exptime` — the time of the exposure\n",
    "* `mjd` — the MJD of the exposure\n",
    "* `pa` — the position angle of the exposure\n",
    "* `sca` — the number of the SCA within the exposure\n",
    "* `ra` — the central RA of the SCA (this is not useful, because you would have to match the float value exactly)\n",
    "* `dec` — the central Dec of the SCA (also not useful)\n",
    "* `containing` — a (ra,dec) (in decimal degrees): find images that include this position on the sky (this _is_ useful)\n",
    "    \n",
    "Examples are below.\n",
    "    \n",
    "## Finding Transients\n",
    "    \n",
    "The URL for finding transients is `/findtransients`.  These search the parquet files with information about transients injected into the simulations.  Right now, you can't get \"truth\" lightcurves from the server, just information about the transients as a whole.\n",
    "    \n",
    "The fields you get back when searching a transient may include:\n",
    "* `id` — int, SNANA id of the transient\n",
    "* `healpix` — int, parsed from the parquet filename\n",
    "* `ra` — float, decimal degrees\n",
    "* `dec` — float, decimal degrees\n",
    "* `host_id` — int, SNANA host ID (not sure how this corresponds to IDs in other tables)\n",
    "* `gentype` — int, SNANA gentype\n",
    "* `model_name` — str, name of the modle\n",
    "* `start_mjd` — float, first mjd that the transient was injected into the sims.  (May have been well below detection!)\n",
    "* `end_mjd` — float, last mjd that the transient was injected into the sims.  (May have been well below detection!)\n",
    "* `z_cmb` — float\n",
    "* `mw_ebv` — float, but I think this is always a bogus number as the MW reddening was not applied at the transient truth stage\n",
    "* `mw_extinction_applied` — bool, I think always False\n",
    "* `AV` — float, TBD\n",
    "* `RV` — float, TBD\n",
    "* `v_pec` — float, TBD\n",
    "* `host_ra` — float, decimal degrees\n",
    "* `host_dec` — float, decimal degrees\n",
    "* `host_mag_*` — float, where `*` is `g`, `i`, or `f` (note: lowercase `f`, not uppercase as in the parquet files!)\n",
    "* `host_sn_sep` — float, units ??\n",
    "* `peak_mjd` — float, mjd of the nominal (B-band? probably model dependent definition) peak of the transient lightcurve\n",
    "* `peak_mag_*` — float, where `*` is `g`, `i`, or `f`\n",
    "* `lens_dmu` — float (always bogus?)\n",
    "* `lens_dmu_applied` — bool (always False?)\n",
    "* `model_params` — dict of parameters saved from the particular model for this transient.  This is probably only interesting for SNeIa (gentype 10)\n",
    "    \n",
    "You can search on most of these parameters, though in many cases that would not be meaningful.  Apply search criterion for transients in one of two ways.  First, you can append `/<kw>=<val>` to the end of the URL (with as many slash-separated `kw/val` pairs as you want).  Second, you can include `{kw:val}` in the POST dictionary you send to the server.  Examples of both of these are below.  For numeric parameters, you can append `_min` or `_max` to the end of `kw` to do a range search.  (E.g., if you wanted all transients between `0.15≤z≤0.18`, you could do `/findtransients/z_cmb_min=0.15/z_cmb_max=0.18`.)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "6db70abb-bef0-4438-b950-1e8201a1dea5",
   "metadata": {},
   "source": [
    "# Examples\n",
    "\n",
    "The only python library you need is `requests`.  I also import `pandas` for convenience in showing the results of example searches.\n",
    "\n",
    "Below, we set up the variable `server_url` to be used throughout the rest of the examples.  We also create a `requests` Session in `req` for use throughout the rest of the examples.\n",
    "\n",
    "In many examples below, I check the `status_code` of the value returned by any requests to the webserver.  If this is not 200 (which is HTTP-speak for a normal return), it means something went wrong.  In that case, the `text` field of the return value may have useful information; if not to you, then potentially to give to Rob for debugging purposes.\n",
    "\n",
    "If the `status_code` is 200, then all is well, and you can call the `json()` method on the return value to get a dictionary of values.  This dictionary is formatted so that it's suitable for immediate import into a pandas DataFrame (as you will see in the examples below)."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "f4335ad5-6612-4223-8b42-083d0c12b1be",
   "metadata": {},
   "outputs": [],
   "source": [
    "import requests\n",
    "import pandas\n",
    "\n",
    "server_url = 'https://roman-desc-simdex.lbl.gov'\n",
    "req = requests.Session()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "c3d2b10a-e25c-4527-a5f3-d6b99cc95e22",
   "metadata": {
    "tags": []
   },
   "source": [
    "## Examples: Finding Roman Images"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "ffd46f9d-ee67-4143-8903-f40b15885185",
   "metadata": {},
   "source": [
    "### Image Example 1: finding all images containing a point\n",
    "\n",
    "In the first way, we'll encode the ra and dec in the URL itself."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "c2df5562-2066-4aa9-b1a9-39a4c2a78a91",
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Got 187 images.\n"
     ]
    },
    {
     "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>boredec</th>\n",
       "      <th>borera</th>\n",
       "      <th>dec</th>\n",
       "      <th>dec_00</th>\n",
       "      <th>dec_01</th>\n",
       "      <th>dec_10</th>\n",
       "      <th>dec_11</th>\n",
       "      <th>exptime</th>\n",
       "      <th>filter</th>\n",
       "      <th>mjd</th>\n",
       "      <th>pa</th>\n",
       "      <th>pointing</th>\n",
       "      <th>ra</th>\n",
       "      <th>ra_00</th>\n",
       "      <th>ra_01</th>\n",
       "      <th>ra_10</th>\n",
       "      <th>ra_11</th>\n",
       "      <th>sca</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>-45.6541</td>\n",
       "      <td>7.60523</td>\n",
       "      <td>-45.439134</td>\n",
       "      <td>-45.498363</td>\n",
       "      <td>-45.38106</td>\n",
       "      <td>-45.497173</td>\n",
       "      <td>-45.379864</td>\n",
       "      <td>161.025</td>\n",
       "      <td>R062</td>\n",
       "      <td>62000.02139</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>7.315209</td>\n",
       "      <td>7.226437</td>\n",
       "      <td>7.229427</td>\n",
       "      <td>7.401124</td>\n",
       "      <td>7.403751</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>-45.6229</td>\n",
       "      <td>7.63643</td>\n",
       "      <td>-45.407934</td>\n",
       "      <td>-45.467167</td>\n",
       "      <td>-45.34986</td>\n",
       "      <td>-45.465973</td>\n",
       "      <td>-45.348663</td>\n",
       "      <td>101.700</td>\n",
       "      <td>Z087</td>\n",
       "      <td>62000.22446</td>\n",
       "      <td>0.0</td>\n",
       "      <td>55</td>\n",
       "      <td>7.346569</td>\n",
       "      <td>7.257846</td>\n",
       "      <td>7.260835</td>\n",
       "      <td>7.432437</td>\n",
       "      <td>7.435062</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>-45.6541</td>\n",
       "      <td>7.60523</td>\n",
       "      <td>-45.439134</td>\n",
       "      <td>-45.498363</td>\n",
       "      <td>-45.38106</td>\n",
       "      <td>-45.497173</td>\n",
       "      <td>-45.379864</td>\n",
       "      <td>302.275</td>\n",
       "      <td>Y106</td>\n",
       "      <td>62000.39804</td>\n",
       "      <td>0.0</td>\n",
       "      <td>110</td>\n",
       "      <td>7.315209</td>\n",
       "      <td>7.226437</td>\n",
       "      <td>7.229427</td>\n",
       "      <td>7.401124</td>\n",
       "      <td>7.403751</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>-45.6229</td>\n",
       "      <td>7.63643</td>\n",
       "      <td>-45.407934</td>\n",
       "      <td>-45.467167</td>\n",
       "      <td>-45.34986</td>\n",
       "      <td>-45.465973</td>\n",
       "      <td>-45.348663</td>\n",
       "      <td>302.275</td>\n",
       "      <td>J129</td>\n",
       "      <td>62000.73412</td>\n",
       "      <td>0.0</td>\n",
       "      <td>165</td>\n",
       "      <td>7.346569</td>\n",
       "      <td>7.257846</td>\n",
       "      <td>7.260835</td>\n",
       "      <td>7.432437</td>\n",
       "      <td>7.435062</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>-45.6541</td>\n",
       "      <td>7.60523</td>\n",
       "      <td>-45.439134</td>\n",
       "      <td>-45.498363</td>\n",
       "      <td>-45.38106</td>\n",
       "      <td>-45.497173</td>\n",
       "      <td>-45.379864</td>\n",
       "      <td>302.275</td>\n",
       "      <td>H158</td>\n",
       "      <td>62001.07020</td>\n",
       "      <td>0.0</td>\n",
       "      <td>220</td>\n",
       "      <td>7.315209</td>\n",
       "      <td>7.226437</td>\n",
       "      <td>7.229427</td>\n",
       "      <td>7.401124</td>\n",
       "      <td>7.403751</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>182</th>\n",
       "      <td>-45.6541</td>\n",
       "      <td>7.60523</td>\n",
       "      <td>-45.439134</td>\n",
       "      <td>-45.498363</td>\n",
       "      <td>-45.38106</td>\n",
       "      <td>-45.497173</td>\n",
       "      <td>-45.379864</td>\n",
       "      <td>302.275</td>\n",
       "      <td>Y106</td>\n",
       "      <td>63550.39804</td>\n",
       "      <td>0.0</td>\n",
       "      <td>56320</td>\n",
       "      <td>7.315209</td>\n",
       "      <td>7.226437</td>\n",
       "      <td>7.229427</td>\n",
       "      <td>7.401124</td>\n",
       "      <td>7.403751</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183</th>\n",
       "      <td>-45.6229</td>\n",
       "      <td>7.63643</td>\n",
       "      <td>-45.407934</td>\n",
       "      <td>-45.467167</td>\n",
       "      <td>-45.34986</td>\n",
       "      <td>-45.465973</td>\n",
       "      <td>-45.348663</td>\n",
       "      <td>302.275</td>\n",
       "      <td>J129</td>\n",
       "      <td>63550.73412</td>\n",
       "      <td>0.0</td>\n",
       "      <td>56375</td>\n",
       "      <td>7.346569</td>\n",
       "      <td>7.257846</td>\n",
       "      <td>7.260835</td>\n",
       "      <td>7.432437</td>\n",
       "      <td>7.435062</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>184</th>\n",
       "      <td>-45.6541</td>\n",
       "      <td>7.60523</td>\n",
       "      <td>-45.439134</td>\n",
       "      <td>-45.498363</td>\n",
       "      <td>-45.38106</td>\n",
       "      <td>-45.497173</td>\n",
       "      <td>-45.379864</td>\n",
       "      <td>302.275</td>\n",
       "      <td>H158</td>\n",
       "      <td>63551.07020</td>\n",
       "      <td>0.0</td>\n",
       "      <td>56430</td>\n",
       "      <td>7.315209</td>\n",
       "      <td>7.226437</td>\n",
       "      <td>7.229427</td>\n",
       "      <td>7.401124</td>\n",
       "      <td>7.403751</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>185</th>\n",
       "      <td>-45.6229</td>\n",
       "      <td>7.63643</td>\n",
       "      <td>-45.407934</td>\n",
       "      <td>-45.467167</td>\n",
       "      <td>-45.34986</td>\n",
       "      <td>-45.465973</td>\n",
       "      <td>-45.348663</td>\n",
       "      <td>901.175</td>\n",
       "      <td>F184</td>\n",
       "      <td>63551.46174</td>\n",
       "      <td>0.0</td>\n",
       "      <td>56485</td>\n",
       "      <td>7.346569</td>\n",
       "      <td>7.257846</td>\n",
       "      <td>7.260835</td>\n",
       "      <td>7.432437</td>\n",
       "      <td>7.435062</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>186</th>\n",
       "      <td>-45.6541</td>\n",
       "      <td>7.60523</td>\n",
       "      <td>-45.439134</td>\n",
       "      <td>-45.498363</td>\n",
       "      <td>-45.38106</td>\n",
       "      <td>-45.497173</td>\n",
       "      <td>-45.379864</td>\n",
       "      <td>901.175</td>\n",
       "      <td>K213</td>\n",
       "      <td>63552.33849</td>\n",
       "      <td>0.0</td>\n",
       "      <td>56540</td>\n",
       "      <td>7.315209</td>\n",
       "      <td>7.226437</td>\n",
       "      <td>7.229427</td>\n",
       "      <td>7.401124</td>\n",
       "      <td>7.403751</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>187 rows × 18 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     boredec   borera        dec     dec_00    dec_01     dec_10     dec_11  \\\n",
       "0   -45.6541  7.60523 -45.439134 -45.498363 -45.38106 -45.497173 -45.379864   \n",
       "1   -45.6229  7.63643 -45.407934 -45.467167 -45.34986 -45.465973 -45.348663   \n",
       "2   -45.6541  7.60523 -45.439134 -45.498363 -45.38106 -45.497173 -45.379864   \n",
       "3   -45.6229  7.63643 -45.407934 -45.467167 -45.34986 -45.465973 -45.348663   \n",
       "4   -45.6541  7.60523 -45.439134 -45.498363 -45.38106 -45.497173 -45.379864   \n",
       "..       ...      ...        ...        ...       ...        ...        ...   \n",
       "182 -45.6541  7.60523 -45.439134 -45.498363 -45.38106 -45.497173 -45.379864   \n",
       "183 -45.6229  7.63643 -45.407934 -45.467167 -45.34986 -45.465973 -45.348663   \n",
       "184 -45.6541  7.60523 -45.439134 -45.498363 -45.38106 -45.497173 -45.379864   \n",
       "185 -45.6229  7.63643 -45.407934 -45.467167 -45.34986 -45.465973 -45.348663   \n",
       "186 -45.6541  7.60523 -45.439134 -45.498363 -45.38106 -45.497173 -45.379864   \n",
       "\n",
       "     exptime filter          mjd   pa  pointing        ra     ra_00     ra_01  \\\n",
       "0    161.025   R062  62000.02139  0.0         0  7.315209  7.226437  7.229427   \n",
       "1    101.700   Z087  62000.22446  0.0        55  7.346569  7.257846  7.260835   \n",
       "2    302.275   Y106  62000.39804  0.0       110  7.315209  7.226437  7.229427   \n",
       "3    302.275   J129  62000.73412  0.0       165  7.346569  7.257846  7.260835   \n",
       "4    302.275   H158  62001.07020  0.0       220  7.315209  7.226437  7.229427   \n",
       "..       ...    ...          ...  ...       ...       ...       ...       ...   \n",
       "182  302.275   Y106  63550.39804  0.0     56320  7.315209  7.226437  7.229427   \n",
       "183  302.275   J129  63550.73412  0.0     56375  7.346569  7.257846  7.260835   \n",
       "184  302.275   H158  63551.07020  0.0     56430  7.315209  7.226437  7.229427   \n",
       "185  901.175   F184  63551.46174  0.0     56485  7.346569  7.257846  7.260835   \n",
       "186  901.175   K213  63552.33849  0.0     56540  7.315209  7.226437  7.229427   \n",
       "\n",
       "        ra_10     ra_11  sca  \n",
       "0    7.401124  7.403751   15  \n",
       "1    7.432437  7.435062   15  \n",
       "2    7.401124  7.403751   15  \n",
       "3    7.432437  7.435062   15  \n",
       "4    7.401124  7.403751   15  \n",
       "..        ...       ...  ...  \n",
       "182  7.401124  7.403751   15  \n",
       "183  7.432437  7.435062   15  \n",
       "184  7.401124  7.403751   15  \n",
       "185  7.432437  7.435062   15  \n",
       "186  7.401124  7.403751   15  \n",
       "\n",
       "[187 rows x 18 columns]"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "result = req.post( f'{server_url}/findromanimages/containing=(7.3152,-45.4391)' )\n",
    "if result.status_code != 200:\n",
    "    raise RuntimeError( f\"Got status code {result.status_code}\\n{result.text}\" )\n",
    "\n",
    "# If all went well (status_code was 200 and there was no exception), then you can pull\n",
    "#  out the returned data with result.json()\n",
    "df = pandas.DataFrame( result.json() )\n",
    "print( f\"Got {len(df)} images.\" )\n",
    "display( df )\n",
    "# Somebody somewhere seems to have sorted the columns alphabetically, which isn't really\n",
    "#  what you would want, but oh well, they're all there"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "b374a423-fd0b-45f3-acc8-fbe68e60c50b",
   "metadata": {},
   "source": [
    "If you prefer, instead of packing all of the search parameters in slash-separated keyword-value pairs in the URL, you can send POST data using the `json=` parameter:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "b985765f-4016-452b-87d6-0fa65ba5e03d",
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Got 187 images\n"
     ]
    },
    {
     "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>boredec</th>\n",
       "      <th>borera</th>\n",
       "      <th>dec</th>\n",
       "      <th>dec_00</th>\n",
       "      <th>dec_01</th>\n",
       "      <th>dec_10</th>\n",
       "      <th>dec_11</th>\n",
       "      <th>exptime</th>\n",
       "      <th>filter</th>\n",
       "      <th>mjd</th>\n",
       "      <th>pa</th>\n",
       "      <th>pointing</th>\n",
       "      <th>ra</th>\n",
       "      <th>ra_00</th>\n",
       "      <th>ra_01</th>\n",
       "      <th>ra_10</th>\n",
       "      <th>ra_11</th>\n",
       "      <th>sca</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>-45.6541</td>\n",
       "      <td>7.60523</td>\n",
       "      <td>-45.439134</td>\n",
       "      <td>-45.498363</td>\n",
       "      <td>-45.38106</td>\n",
       "      <td>-45.497173</td>\n",
       "      <td>-45.379864</td>\n",
       "      <td>161.025</td>\n",
       "      <td>R062</td>\n",
       "      <td>62000.02139</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>7.315209</td>\n",
       "      <td>7.226437</td>\n",
       "      <td>7.229427</td>\n",
       "      <td>7.401124</td>\n",
       "      <td>7.403751</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>-45.6229</td>\n",
       "      <td>7.63643</td>\n",
       "      <td>-45.407934</td>\n",
       "      <td>-45.467167</td>\n",
       "      <td>-45.34986</td>\n",
       "      <td>-45.465973</td>\n",
       "      <td>-45.348663</td>\n",
       "      <td>101.700</td>\n",
       "      <td>Z087</td>\n",
       "      <td>62000.22446</td>\n",
       "      <td>0.0</td>\n",
       "      <td>55</td>\n",
       "      <td>7.346569</td>\n",
       "      <td>7.257846</td>\n",
       "      <td>7.260835</td>\n",
       "      <td>7.432437</td>\n",
       "      <td>7.435062</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>-45.6541</td>\n",
       "      <td>7.60523</td>\n",
       "      <td>-45.439134</td>\n",
       "      <td>-45.498363</td>\n",
       "      <td>-45.38106</td>\n",
       "      <td>-45.497173</td>\n",
       "      <td>-45.379864</td>\n",
       "      <td>302.275</td>\n",
       "      <td>Y106</td>\n",
       "      <td>62000.39804</td>\n",
       "      <td>0.0</td>\n",
       "      <td>110</td>\n",
       "      <td>7.315209</td>\n",
       "      <td>7.226437</td>\n",
       "      <td>7.229427</td>\n",
       "      <td>7.401124</td>\n",
       "      <td>7.403751</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>-45.6229</td>\n",
       "      <td>7.63643</td>\n",
       "      <td>-45.407934</td>\n",
       "      <td>-45.467167</td>\n",
       "      <td>-45.34986</td>\n",
       "      <td>-45.465973</td>\n",
       "      <td>-45.348663</td>\n",
       "      <td>302.275</td>\n",
       "      <td>J129</td>\n",
       "      <td>62000.73412</td>\n",
       "      <td>0.0</td>\n",
       "      <td>165</td>\n",
       "      <td>7.346569</td>\n",
       "      <td>7.257846</td>\n",
       "      <td>7.260835</td>\n",
       "      <td>7.432437</td>\n",
       "      <td>7.435062</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>-45.6541</td>\n",
       "      <td>7.60523</td>\n",
       "      <td>-45.439134</td>\n",
       "      <td>-45.498363</td>\n",
       "      <td>-45.38106</td>\n",
       "      <td>-45.497173</td>\n",
       "      <td>-45.379864</td>\n",
       "      <td>302.275</td>\n",
       "      <td>H158</td>\n",
       "      <td>62001.07020</td>\n",
       "      <td>0.0</td>\n",
       "      <td>220</td>\n",
       "      <td>7.315209</td>\n",
       "      <td>7.226437</td>\n",
       "      <td>7.229427</td>\n",
       "      <td>7.401124</td>\n",
       "      <td>7.403751</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>182</th>\n",
       "      <td>-45.6541</td>\n",
       "      <td>7.60523</td>\n",
       "      <td>-45.439134</td>\n",
       "      <td>-45.498363</td>\n",
       "      <td>-45.38106</td>\n",
       "      <td>-45.497173</td>\n",
       "      <td>-45.379864</td>\n",
       "      <td>302.275</td>\n",
       "      <td>Y106</td>\n",
       "      <td>63550.39804</td>\n",
       "      <td>0.0</td>\n",
       "      <td>56320</td>\n",
       "      <td>7.315209</td>\n",
       "      <td>7.226437</td>\n",
       "      <td>7.229427</td>\n",
       "      <td>7.401124</td>\n",
       "      <td>7.403751</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183</th>\n",
       "      <td>-45.6229</td>\n",
       "      <td>7.63643</td>\n",
       "      <td>-45.407934</td>\n",
       "      <td>-45.467167</td>\n",
       "      <td>-45.34986</td>\n",
       "      <td>-45.465973</td>\n",
       "      <td>-45.348663</td>\n",
       "      <td>302.275</td>\n",
       "      <td>J129</td>\n",
       "      <td>63550.73412</td>\n",
       "      <td>0.0</td>\n",
       "      <td>56375</td>\n",
       "      <td>7.346569</td>\n",
       "      <td>7.257846</td>\n",
       "      <td>7.260835</td>\n",
       "      <td>7.432437</td>\n",
       "      <td>7.435062</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>184</th>\n",
       "      <td>-45.6541</td>\n",
       "      <td>7.60523</td>\n",
       "      <td>-45.439134</td>\n",
       "      <td>-45.498363</td>\n",
       "      <td>-45.38106</td>\n",
       "      <td>-45.497173</td>\n",
       "      <td>-45.379864</td>\n",
       "      <td>302.275</td>\n",
       "      <td>H158</td>\n",
       "      <td>63551.07020</td>\n",
       "      <td>0.0</td>\n",
       "      <td>56430</td>\n",
       "      <td>7.315209</td>\n",
       "      <td>7.226437</td>\n",
       "      <td>7.229427</td>\n",
       "      <td>7.401124</td>\n",
       "      <td>7.403751</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>185</th>\n",
       "      <td>-45.6229</td>\n",
       "      <td>7.63643</td>\n",
       "      <td>-45.407934</td>\n",
       "      <td>-45.467167</td>\n",
       "      <td>-45.34986</td>\n",
       "      <td>-45.465973</td>\n",
       "      <td>-45.348663</td>\n",
       "      <td>901.175</td>\n",
       "      <td>F184</td>\n",
       "      <td>63551.46174</td>\n",
       "      <td>0.0</td>\n",
       "      <td>56485</td>\n",
       "      <td>7.346569</td>\n",
       "      <td>7.257846</td>\n",
       "      <td>7.260835</td>\n",
       "      <td>7.432437</td>\n",
       "      <td>7.435062</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>186</th>\n",
       "      <td>-45.6541</td>\n",
       "      <td>7.60523</td>\n",
       "      <td>-45.439134</td>\n",
       "      <td>-45.498363</td>\n",
       "      <td>-45.38106</td>\n",
       "      <td>-45.497173</td>\n",
       "      <td>-45.379864</td>\n",
       "      <td>901.175</td>\n",
       "      <td>K213</td>\n",
       "      <td>63552.33849</td>\n",
       "      <td>0.0</td>\n",
       "      <td>56540</td>\n",
       "      <td>7.315209</td>\n",
       "      <td>7.226437</td>\n",
       "      <td>7.229427</td>\n",
       "      <td>7.401124</td>\n",
       "      <td>7.403751</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>187 rows × 18 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     boredec   borera        dec     dec_00    dec_01     dec_10     dec_11  \\\n",
       "0   -45.6541  7.60523 -45.439134 -45.498363 -45.38106 -45.497173 -45.379864   \n",
       "1   -45.6229  7.63643 -45.407934 -45.467167 -45.34986 -45.465973 -45.348663   \n",
       "2   -45.6541  7.60523 -45.439134 -45.498363 -45.38106 -45.497173 -45.379864   \n",
       "3   -45.6229  7.63643 -45.407934 -45.467167 -45.34986 -45.465973 -45.348663   \n",
       "4   -45.6541  7.60523 -45.439134 -45.498363 -45.38106 -45.497173 -45.379864   \n",
       "..       ...      ...        ...        ...       ...        ...        ...   \n",
       "182 -45.6541  7.60523 -45.439134 -45.498363 -45.38106 -45.497173 -45.379864   \n",
       "183 -45.6229  7.63643 -45.407934 -45.467167 -45.34986 -45.465973 -45.348663   \n",
       "184 -45.6541  7.60523 -45.439134 -45.498363 -45.38106 -45.497173 -45.379864   \n",
       "185 -45.6229  7.63643 -45.407934 -45.467167 -45.34986 -45.465973 -45.348663   \n",
       "186 -45.6541  7.60523 -45.439134 -45.498363 -45.38106 -45.497173 -45.379864   \n",
       "\n",
       "     exptime filter          mjd   pa  pointing        ra     ra_00     ra_01  \\\n",
       "0    161.025   R062  62000.02139  0.0         0  7.315209  7.226437  7.229427   \n",
       "1    101.700   Z087  62000.22446  0.0        55  7.346569  7.257846  7.260835   \n",
       "2    302.275   Y106  62000.39804  0.0       110  7.315209  7.226437  7.229427   \n",
       "3    302.275   J129  62000.73412  0.0       165  7.346569  7.257846  7.260835   \n",
       "4    302.275   H158  62001.07020  0.0       220  7.315209  7.226437  7.229427   \n",
       "..       ...    ...          ...  ...       ...       ...       ...       ...   \n",
       "182  302.275   Y106  63550.39804  0.0     56320  7.315209  7.226437  7.229427   \n",
       "183  302.275   J129  63550.73412  0.0     56375  7.346569  7.257846  7.260835   \n",
       "184  302.275   H158  63551.07020  0.0     56430  7.315209  7.226437  7.229427   \n",
       "185  901.175   F184  63551.46174  0.0     56485  7.346569  7.257846  7.260835   \n",
       "186  901.175   K213  63552.33849  0.0     56540  7.315209  7.226437  7.229427   \n",
       "\n",
       "        ra_10     ra_11  sca  \n",
       "0    7.401124  7.403751   15  \n",
       "1    7.432437  7.435062   15  \n",
       "2    7.401124  7.403751   15  \n",
       "3    7.432437  7.435062   15  \n",
       "4    7.401124  7.403751   15  \n",
       "..        ...       ...  ...  \n",
       "182  7.401124  7.403751   15  \n",
       "183  7.432437  7.435062   15  \n",
       "184  7.401124  7.403751   15  \n",
       "185  7.432437  7.435062   15  \n",
       "186  7.401124  7.403751   15  \n",
       "\n",
       "[187 rows x 18 columns]"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "result = req.post( f'{server_url}/findromanimages', json={ 'containing': [ 7.3152, -45.4391 ] } )\n",
    "if result.status_code != 200:\n",
    "    raise RuntimeError( f\"Got status code {result.status_code}\\n{result.text}\" )\n",
    "    \n",
    "df = pandas.DataFrame( result.json() )\n",
    "print( f\"Got {len(df)} images\" )\n",
    "display( df )"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "467590b3-67a7-4bd6-b653-e9c5e829b5d4",
   "metadata": {},
   "source": [
    "## Examples: Finding Transients"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "98b0a4ba-981b-4db1-bc2d-a2d666414171",
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Got 381 transients\n"
     ]
    },
    {
     "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>av</th>\n",
       "      <th>dec</th>\n",
       "      <th>end_mjd</th>\n",
       "      <th>gentype</th>\n",
       "      <th>healpix</th>\n",
       "      <th>host_dec</th>\n",
       "      <th>host_id</th>\n",
       "      <th>host_mag_f</th>\n",
       "      <th>host_mag_g</th>\n",
       "      <th>host_mag_i</th>\n",
       "      <th>...</th>\n",
       "      <th>mw_extinction_applied</th>\n",
       "      <th>peak_mag_f</th>\n",
       "      <th>peak_mag_g</th>\n",
       "      <th>peak_mag_i</th>\n",
       "      <th>peak_mjd</th>\n",
       "      <th>ra</th>\n",
       "      <th>rv</th>\n",
       "      <th>start_mjd</th>\n",
       "      <th>v_pec</th>\n",
       "      <th>z_cmb</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>-9.0</td>\n",
       "      <td>-39.580721</td>\n",
       "      <td>63570.0</td>\n",
       "      <td>99</td>\n",
       "      <td>9923</td>\n",
       "      <td>-39.580380</td>\n",
       "      <td>9923000008570</td>\n",
       "      <td>19.982</td>\n",
       "      <td>21.460</td>\n",
       "      <td>20.694</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>19.011585</td>\n",
       "      <td>19.011585</td>\n",
       "      <td>19.011585</td>\n",
       "      <td>63560.082</td>\n",
       "      <td>10.079961</td>\n",
       "      <td>-9.0</td>\n",
       "      <td>63550.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.1597</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>-9.0</td>\n",
       "      <td>-39.074532</td>\n",
       "      <td>63570.0</td>\n",
       "      <td>99</td>\n",
       "      <td>9923</td>\n",
       "      <td>-39.074525</td>\n",
       "      <td>9923000009970</td>\n",
       "      <td>22.605</td>\n",
       "      <td>23.775</td>\n",
       "      <td>23.192</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>18.583853</td>\n",
       "      <td>18.583853</td>\n",
       "      <td>18.583853</td>\n",
       "      <td>63560.555</td>\n",
       "      <td>9.658906</td>\n",
       "      <td>-9.0</td>\n",
       "      <td>63550.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.1563</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>-9.0</td>\n",
       "      <td>-39.468878</td>\n",
       "      <td>62128.0</td>\n",
       "      <td>32</td>\n",
       "      <td>9923</td>\n",
       "      <td>-39.468887</td>\n",
       "      <td>9923000010017</td>\n",
       "      <td>20.079</td>\n",
       "      <td>21.592</td>\n",
       "      <td>20.813</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>24.572828</td>\n",
       "      <td>23.391932</td>\n",
       "      <td>23.388239</td>\n",
       "      <td>61898.324</td>\n",
       "      <td>10.019425</td>\n",
       "      <td>-9.0</td>\n",
       "      <td>61896.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.1597</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>-9.0</td>\n",
       "      <td>-39.543361</td>\n",
       "      <td>61774.0</td>\n",
       "      <td>32</td>\n",
       "      <td>9923</td>\n",
       "      <td>-39.543640</td>\n",
       "      <td>9923000008073</td>\n",
       "      <td>19.549</td>\n",
       "      <td>20.943</td>\n",
       "      <td>20.211</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>26.009110</td>\n",
       "      <td>24.400398</td>\n",
       "      <td>24.820340</td>\n",
       "      <td>61624.470</td>\n",
       "      <td>10.006852</td>\n",
       "      <td>-9.0</td>\n",
       "      <td>61622.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.1591</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>-9.0</td>\n",
       "      <td>-39.028209</td>\n",
       "      <td>63267.0</td>\n",
       "      <td>10</td>\n",
       "      <td>9923</td>\n",
       "      <td>-39.028204</td>\n",
       "      <td>9923000008350</td>\n",
       "      <td>19.056</td>\n",
       "      <td>21.078</td>\n",
       "      <td>20.139</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>22.196590</td>\n",
       "      <td>19.921576</td>\n",
       "      <td>20.196531</td>\n",
       "      <td>63079.145</td>\n",
       "      <td>9.869027</td>\n",
       "      <td>-9.0</td>\n",
       "      <td>63056.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.1594</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>376</th>\n",
       "      <td>-9.0</td>\n",
       "      <td>-43.793157</td>\n",
       "      <td>63026.0</td>\n",
       "      <td>32</td>\n",
       "      <td>10307</td>\n",
       "      <td>-43.793111</td>\n",
       "      <td>10307000004025</td>\n",
       "      <td>22.590</td>\n",
       "      <td>23.755</td>\n",
       "      <td>23.175</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>23.119951</td>\n",
       "      <td>21.672802</td>\n",
       "      <td>21.937930</td>\n",
       "      <td>62796.176</td>\n",
       "      <td>8.900338</td>\n",
       "      <td>-9.0</td>\n",
       "      <td>62792.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.1552</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>377</th>\n",
       "      <td>-9.0</td>\n",
       "      <td>-42.400943</td>\n",
       "      <td>61866.0</td>\n",
       "      <td>10</td>\n",
       "      <td>10307</td>\n",
       "      <td>-42.400961</td>\n",
       "      <td>10307000003819</td>\n",
       "      <td>18.650</td>\n",
       "      <td>21.090</td>\n",
       "      <td>19.966</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>22.161100</td>\n",
       "      <td>20.368229</td>\n",
       "      <td>20.403765</td>\n",
       "      <td>61522.110</td>\n",
       "      <td>10.668302</td>\n",
       "      <td>-9.0</td>\n",
       "      <td>61499.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.1575</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>378</th>\n",
       "      <td>-9.0</td>\n",
       "      <td>-42.673976</td>\n",
       "      <td>62701.0</td>\n",
       "      <td>10</td>\n",
       "      <td>10307</td>\n",
       "      <td>-42.673889</td>\n",
       "      <td>10307000002794</td>\n",
       "      <td>20.818</td>\n",
       "      <td>22.156</td>\n",
       "      <td>21.468</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>22.172995</td>\n",
       "      <td>20.448359</td>\n",
       "      <td>20.387297</td>\n",
       "      <td>62356.293</td>\n",
       "      <td>11.074662</td>\n",
       "      <td>-9.0</td>\n",
       "      <td>62334.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.1566</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>379</th>\n",
       "      <td>-9.0</td>\n",
       "      <td>-44.764562</td>\n",
       "      <td>63268.0</td>\n",
       "      <td>21</td>\n",
       "      <td>10307</td>\n",
       "      <td>-44.764505</td>\n",
       "      <td>10307000002194</td>\n",
       "      <td>20.624</td>\n",
       "      <td>21.933</td>\n",
       "      <td>21.263</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>24.003310</td>\n",
       "      <td>23.862898</td>\n",
       "      <td>23.451912</td>\n",
       "      <td>63200.004</td>\n",
       "      <td>9.354777</td>\n",
       "      <td>-9.0</td>\n",
       "      <td>63182.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.1516</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>380</th>\n",
       "      <td>-9.0</td>\n",
       "      <td>-43.272530</td>\n",
       "      <td>63269.0</td>\n",
       "      <td>21</td>\n",
       "      <td>10307</td>\n",
       "      <td>-43.272505</td>\n",
       "      <td>10307000003247</td>\n",
       "      <td>20.806</td>\n",
       "      <td>22.146</td>\n",
       "      <td>21.459</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>23.393867</td>\n",
       "      <td>23.017466</td>\n",
       "      <td>22.645355</td>\n",
       "      <td>63276.324</td>\n",
       "      <td>8.984739</td>\n",
       "      <td>-9.0</td>\n",
       "      <td>63262.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.1559</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>381 rows × 28 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      av        dec  end_mjd  gentype  healpix   host_dec         host_id  \\\n",
       "0   -9.0 -39.580721  63570.0       99     9923 -39.580380   9923000008570   \n",
       "1   -9.0 -39.074532  63570.0       99     9923 -39.074525   9923000009970   \n",
       "2   -9.0 -39.468878  62128.0       32     9923 -39.468887   9923000010017   \n",
       "3   -9.0 -39.543361  61774.0       32     9923 -39.543640   9923000008073   \n",
       "4   -9.0 -39.028209  63267.0       10     9923 -39.028204   9923000008350   \n",
       "..   ...        ...      ...      ...      ...        ...             ...   \n",
       "376 -9.0 -43.793157  63026.0       32    10307 -43.793111  10307000004025   \n",
       "377 -9.0 -42.400943  61866.0       10    10307 -42.400961  10307000003819   \n",
       "378 -9.0 -42.673976  62701.0       10    10307 -42.673889  10307000002794   \n",
       "379 -9.0 -44.764562  63268.0       21    10307 -44.764505  10307000002194   \n",
       "380 -9.0 -43.272530  63269.0       21    10307 -43.272505  10307000003247   \n",
       "\n",
       "     host_mag_f  host_mag_g  host_mag_i  ...  mw_extinction_applied  \\\n",
       "0        19.982      21.460      20.694  ...                  False   \n",
       "1        22.605      23.775      23.192  ...                  False   \n",
       "2        20.079      21.592      20.813  ...                  False   \n",
       "3        19.549      20.943      20.211  ...                  False   \n",
       "4        19.056      21.078      20.139  ...                  False   \n",
       "..          ...         ...         ...  ...                    ...   \n",
       "376      22.590      23.755      23.175  ...                  False   \n",
       "377      18.650      21.090      19.966  ...                  False   \n",
       "378      20.818      22.156      21.468  ...                  False   \n",
       "379      20.624      21.933      21.263  ...                  False   \n",
       "380      20.806      22.146      21.459  ...                  False   \n",
       "\n",
       "     peak_mag_f  peak_mag_g  peak_mag_i   peak_mjd         ra   rv  start_mjd  \\\n",
       "0     19.011585   19.011585   19.011585  63560.082  10.079961 -9.0    63550.0   \n",
       "1     18.583853   18.583853   18.583853  63560.555   9.658906 -9.0    63550.0   \n",
       "2     24.572828   23.391932   23.388239  61898.324  10.019425 -9.0    61896.0   \n",
       "3     26.009110   24.400398   24.820340  61624.470  10.006852 -9.0    61622.0   \n",
       "4     22.196590   19.921576   20.196531  63079.145   9.869027 -9.0    63056.0   \n",
       "..          ...         ...         ...        ...        ...  ...        ...   \n",
       "376   23.119951   21.672802   21.937930  62796.176   8.900338 -9.0    62792.0   \n",
       "377   22.161100   20.368229   20.403765  61522.110  10.668302 -9.0    61499.0   \n",
       "378   22.172995   20.448359   20.387297  62356.293  11.074662 -9.0    62334.0   \n",
       "379   24.003310   23.862898   23.451912  63200.004   9.354777 -9.0    63182.0   \n",
       "380   23.393867   23.017466   22.645355  63276.324   8.984739 -9.0    63262.0   \n",
       "\n",
       "     v_pec   z_cmb  \n",
       "0      0.0  0.1597  \n",
       "1      0.0  0.1563  \n",
       "2      0.0  0.1597  \n",
       "3      0.0  0.1591  \n",
       "4      0.0  0.1594  \n",
       "..     ...     ...  \n",
       "376    0.0  0.1552  \n",
       "377    0.0  0.1575  \n",
       "378    0.0  0.1566  \n",
       "379    0.0  0.1516  \n",
       "380    0.0  0.1559  \n",
       "\n",
       "[381 rows x 28 columns]"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "# Find all transients between redshift 0.15 and 0.16\n",
    "result = req.post( f'{server_url}/findtransients/z_cmb_min=0.15/z_cmb_max=0.16' )\n",
    "if result.status_code != 200:\n",
    "    raise RuntimeError( f\"Got status code {result.status_code}\\n{result.text}\" )\n",
    "    \n",
    "df = pandas.DataFrame( result.json() )\n",
    "print( f\"Got {len(df)} transients\" )\n",
    "display( df )"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "f795e1d6-58ea-496f-939c-2524ce43c54d",
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Got 381 transients\n"
     ]
    },
    {
     "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>av</th>\n",
       "      <th>dec</th>\n",
       "      <th>end_mjd</th>\n",
       "      <th>gentype</th>\n",
       "      <th>healpix</th>\n",
       "      <th>host_dec</th>\n",
       "      <th>host_id</th>\n",
       "      <th>host_mag_f</th>\n",
       "      <th>host_mag_g</th>\n",
       "      <th>host_mag_i</th>\n",
       "      <th>...</th>\n",
       "      <th>mw_extinction_applied</th>\n",
       "      <th>peak_mag_f</th>\n",
       "      <th>peak_mag_g</th>\n",
       "      <th>peak_mag_i</th>\n",
       "      <th>peak_mjd</th>\n",
       "      <th>ra</th>\n",
       "      <th>rv</th>\n",
       "      <th>start_mjd</th>\n",
       "      <th>v_pec</th>\n",
       "      <th>z_cmb</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>-9.0</td>\n",
       "      <td>-39.580721</td>\n",
       "      <td>63570.0</td>\n",
       "      <td>99</td>\n",
       "      <td>9923</td>\n",
       "      <td>-39.580380</td>\n",
       "      <td>9923000008570</td>\n",
       "      <td>19.982</td>\n",
       "      <td>21.460</td>\n",
       "      <td>20.694</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>19.011585</td>\n",
       "      <td>19.011585</td>\n",
       "      <td>19.011585</td>\n",
       "      <td>63560.082</td>\n",
       "      <td>10.079961</td>\n",
       "      <td>-9.0</td>\n",
       "      <td>63550.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.1597</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>-9.0</td>\n",
       "      <td>-39.074532</td>\n",
       "      <td>63570.0</td>\n",
       "      <td>99</td>\n",
       "      <td>9923</td>\n",
       "      <td>-39.074525</td>\n",
       "      <td>9923000009970</td>\n",
       "      <td>22.605</td>\n",
       "      <td>23.775</td>\n",
       "      <td>23.192</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>18.583853</td>\n",
       "      <td>18.583853</td>\n",
       "      <td>18.583853</td>\n",
       "      <td>63560.555</td>\n",
       "      <td>9.658906</td>\n",
       "      <td>-9.0</td>\n",
       "      <td>63550.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.1563</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>-9.0</td>\n",
       "      <td>-39.468878</td>\n",
       "      <td>62128.0</td>\n",
       "      <td>32</td>\n",
       "      <td>9923</td>\n",
       "      <td>-39.468887</td>\n",
       "      <td>9923000010017</td>\n",
       "      <td>20.079</td>\n",
       "      <td>21.592</td>\n",
       "      <td>20.813</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>24.572828</td>\n",
       "      <td>23.391932</td>\n",
       "      <td>23.388239</td>\n",
       "      <td>61898.324</td>\n",
       "      <td>10.019425</td>\n",
       "      <td>-9.0</td>\n",
       "      <td>61896.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.1597</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>-9.0</td>\n",
       "      <td>-39.543361</td>\n",
       "      <td>61774.0</td>\n",
       "      <td>32</td>\n",
       "      <td>9923</td>\n",
       "      <td>-39.543640</td>\n",
       "      <td>9923000008073</td>\n",
       "      <td>19.549</td>\n",
       "      <td>20.943</td>\n",
       "      <td>20.211</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>26.009110</td>\n",
       "      <td>24.400398</td>\n",
       "      <td>24.820340</td>\n",
       "      <td>61624.470</td>\n",
       "      <td>10.006852</td>\n",
       "      <td>-9.0</td>\n",
       "      <td>61622.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.1591</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>-9.0</td>\n",
       "      <td>-39.028209</td>\n",
       "      <td>63267.0</td>\n",
       "      <td>10</td>\n",
       "      <td>9923</td>\n",
       "      <td>-39.028204</td>\n",
       "      <td>9923000008350</td>\n",
       "      <td>19.056</td>\n",
       "      <td>21.078</td>\n",
       "      <td>20.139</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>22.196590</td>\n",
       "      <td>19.921576</td>\n",
       "      <td>20.196531</td>\n",
       "      <td>63079.145</td>\n",
       "      <td>9.869027</td>\n",
       "      <td>-9.0</td>\n",
       "      <td>63056.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.1594</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>376</th>\n",
       "      <td>-9.0</td>\n",
       "      <td>-43.793157</td>\n",
       "      <td>63026.0</td>\n",
       "      <td>32</td>\n",
       "      <td>10307</td>\n",
       "      <td>-43.793111</td>\n",
       "      <td>10307000004025</td>\n",
       "      <td>22.590</td>\n",
       "      <td>23.755</td>\n",
       "      <td>23.175</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>23.119951</td>\n",
       "      <td>21.672802</td>\n",
       "      <td>21.937930</td>\n",
       "      <td>62796.176</td>\n",
       "      <td>8.900338</td>\n",
       "      <td>-9.0</td>\n",
       "      <td>62792.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.1552</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>377</th>\n",
       "      <td>-9.0</td>\n",
       "      <td>-42.400943</td>\n",
       "      <td>61866.0</td>\n",
       "      <td>10</td>\n",
       "      <td>10307</td>\n",
       "      <td>-42.400961</td>\n",
       "      <td>10307000003819</td>\n",
       "      <td>18.650</td>\n",
       "      <td>21.090</td>\n",
       "      <td>19.966</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>22.161100</td>\n",
       "      <td>20.368229</td>\n",
       "      <td>20.403765</td>\n",
       "      <td>61522.110</td>\n",
       "      <td>10.668302</td>\n",
       "      <td>-9.0</td>\n",
       "      <td>61499.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.1575</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>378</th>\n",
       "      <td>-9.0</td>\n",
       "      <td>-42.673976</td>\n",
       "      <td>62701.0</td>\n",
       "      <td>10</td>\n",
       "      <td>10307</td>\n",
       "      <td>-42.673889</td>\n",
       "      <td>10307000002794</td>\n",
       "      <td>20.818</td>\n",
       "      <td>22.156</td>\n",
       "      <td>21.468</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>22.172995</td>\n",
       "      <td>20.448359</td>\n",
       "      <td>20.387297</td>\n",
       "      <td>62356.293</td>\n",
       "      <td>11.074662</td>\n",
       "      <td>-9.0</td>\n",
       "      <td>62334.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.1566</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>379</th>\n",
       "      <td>-9.0</td>\n",
       "      <td>-44.764562</td>\n",
       "      <td>63268.0</td>\n",
       "      <td>21</td>\n",
       "      <td>10307</td>\n",
       "      <td>-44.764505</td>\n",
       "      <td>10307000002194</td>\n",
       "      <td>20.624</td>\n",
       "      <td>21.933</td>\n",
       "      <td>21.263</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>24.003310</td>\n",
       "      <td>23.862898</td>\n",
       "      <td>23.451912</td>\n",
       "      <td>63200.004</td>\n",
       "      <td>9.354777</td>\n",
       "      <td>-9.0</td>\n",
       "      <td>63182.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.1516</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>380</th>\n",
       "      <td>-9.0</td>\n",
       "      <td>-43.272530</td>\n",
       "      <td>63269.0</td>\n",
       "      <td>21</td>\n",
       "      <td>10307</td>\n",
       "      <td>-43.272505</td>\n",
       "      <td>10307000003247</td>\n",
       "      <td>20.806</td>\n",
       "      <td>22.146</td>\n",
       "      <td>21.459</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>23.393867</td>\n",
       "      <td>23.017466</td>\n",
       "      <td>22.645355</td>\n",
       "      <td>63276.324</td>\n",
       "      <td>8.984739</td>\n",
       "      <td>-9.0</td>\n",
       "      <td>63262.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.1559</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>381 rows × 28 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      av        dec  end_mjd  gentype  healpix   host_dec         host_id  \\\n",
       "0   -9.0 -39.580721  63570.0       99     9923 -39.580380   9923000008570   \n",
       "1   -9.0 -39.074532  63570.0       99     9923 -39.074525   9923000009970   \n",
       "2   -9.0 -39.468878  62128.0       32     9923 -39.468887   9923000010017   \n",
       "3   -9.0 -39.543361  61774.0       32     9923 -39.543640   9923000008073   \n",
       "4   -9.0 -39.028209  63267.0       10     9923 -39.028204   9923000008350   \n",
       "..   ...        ...      ...      ...      ...        ...             ...   \n",
       "376 -9.0 -43.793157  63026.0       32    10307 -43.793111  10307000004025   \n",
       "377 -9.0 -42.400943  61866.0       10    10307 -42.400961  10307000003819   \n",
       "378 -9.0 -42.673976  62701.0       10    10307 -42.673889  10307000002794   \n",
       "379 -9.0 -44.764562  63268.0       21    10307 -44.764505  10307000002194   \n",
       "380 -9.0 -43.272530  63269.0       21    10307 -43.272505  10307000003247   \n",
       "\n",
       "     host_mag_f  host_mag_g  host_mag_i  ...  mw_extinction_applied  \\\n",
       "0        19.982      21.460      20.694  ...                  False   \n",
       "1        22.605      23.775      23.192  ...                  False   \n",
       "2        20.079      21.592      20.813  ...                  False   \n",
       "3        19.549      20.943      20.211  ...                  False   \n",
       "4        19.056      21.078      20.139  ...                  False   \n",
       "..          ...         ...         ...  ...                    ...   \n",
       "376      22.590      23.755      23.175  ...                  False   \n",
       "377      18.650      21.090      19.966  ...                  False   \n",
       "378      20.818      22.156      21.468  ...                  False   \n",
       "379      20.624      21.933      21.263  ...                  False   \n",
       "380      20.806      22.146      21.459  ...                  False   \n",
       "\n",
       "     peak_mag_f  peak_mag_g  peak_mag_i   peak_mjd         ra   rv  start_mjd  \\\n",
       "0     19.011585   19.011585   19.011585  63560.082  10.079961 -9.0    63550.0   \n",
       "1     18.583853   18.583853   18.583853  63560.555   9.658906 -9.0    63550.0   \n",
       "2     24.572828   23.391932   23.388239  61898.324  10.019425 -9.0    61896.0   \n",
       "3     26.009110   24.400398   24.820340  61624.470  10.006852 -9.0    61622.0   \n",
       "4     22.196590   19.921576   20.196531  63079.145   9.869027 -9.0    63056.0   \n",
       "..          ...         ...         ...        ...        ...  ...        ...   \n",
       "376   23.119951   21.672802   21.937930  62796.176   8.900338 -9.0    62792.0   \n",
       "377   22.161100   20.368229   20.403765  61522.110  10.668302 -9.0    61499.0   \n",
       "378   22.172995   20.448359   20.387297  62356.293  11.074662 -9.0    62334.0   \n",
       "379   24.003310   23.862898   23.451912  63200.004   9.354777 -9.0    63182.0   \n",
       "380   23.393867   23.017466   22.645355  63276.324   8.984739 -9.0    63262.0   \n",
       "\n",
       "     v_pec   z_cmb  \n",
       "0      0.0  0.1597  \n",
       "1      0.0  0.1563  \n",
       "2      0.0  0.1597  \n",
       "3      0.0  0.1591  \n",
       "4      0.0  0.1594  \n",
       "..     ...     ...  \n",
       "376    0.0  0.1552  \n",
       "377    0.0  0.1575  \n",
       "378    0.0  0.1566  \n",
       "379    0.0  0.1516  \n",
       "380    0.0  0.1559  \n",
       "\n",
       "[381 rows x 28 columns]"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "# The same search, only using POST data\n",
    "searchparams = { 'z_cmb_min': 0.15,\n",
    "                 'z_cmb_max': 0.16 }\n",
    "result = req.post( f'{server_url}/findtransients', json=searchparams )\n",
    "if result.status_code != 200:\n",
    "    raise RuntimeError( f\"Got status code {result.status_code}\\n{result.text}\" )\n",
    "    \n",
    "df = pandas.DataFrame( result.json() )\n",
    "print( f\"Got {len(df)} transients\" )\n",
    "display( df )"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "4038a50a-9f31-4ee0-932e-ab0315f082b3",
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Got 53 transients\n"
     ]
    },
    {
     "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>dec</th>\n",
       "      <th>host_sn_sep</th>\n",
       "      <th>model_name</th>\n",
       "      <th>peak_mag_g</th>\n",
       "      <th>peak_mjd</th>\n",
       "      <th>ra</th>\n",
       "      <th>z_cmb</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>-39.028209</td>\n",
       "      <td>0.034226</td>\n",
       "      <td>SALT3.NIR_WAVEEXT</td>\n",
       "      <td>19.921576</td>\n",
       "      <td>63079.145</td>\n",
       "      <td>9.869027</td>\n",
       "      <td>0.1594</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>-39.182274</td>\n",
       "      <td>0.132200</td>\n",
       "      <td>SALT3.NIR_WAVEEXT</td>\n",
       "      <td>19.851212</td>\n",
       "      <td>62542.703</td>\n",
       "      <td>9.485179</td>\n",
       "      <td>0.1562</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>-44.175518</td>\n",
       "      <td>0.420599</td>\n",
       "      <td>SALT3.NIR_WAVEEXT</td>\n",
       "      <td>19.957037</td>\n",
       "      <td>62647.633</td>\n",
       "      <td>6.505097</td>\n",
       "      <td>0.1502</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>-42.882932</td>\n",
       "      <td>1.292025</td>\n",
       "      <td>SALT3.NIR_WAVEEXT</td>\n",
       "      <td>20.169504</td>\n",
       "      <td>62068.797</td>\n",
       "      <td>8.388646</td>\n",
       "      <td>0.1588</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>-43.415390</td>\n",
       "      <td>0.897424</td>\n",
       "      <td>SALT3.NIR_WAVEEXT</td>\n",
       "      <td>19.629564</td>\n",
       "      <td>62221.830</td>\n",
       "      <td>7.690245</td>\n",
       "      <td>0.1510</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>-42.429656</td>\n",
       "      <td>3.851046</td>\n",
       "      <td>SALT3.NIR_WAVEEXT</td>\n",
       "      <td>19.686953</td>\n",
       "      <td>62917.890</td>\n",
       "      <td>7.706417</td>\n",
       "      <td>0.1588</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>-46.087521</td>\n",
       "      <td>0.641850</td>\n",
       "      <td>SALT3.NIR_WAVEEXT</td>\n",
       "      <td>20.338213</td>\n",
       "      <td>61519.207</td>\n",
       "      <td>6.042713</td>\n",
       "      <td>0.1579</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>-39.492079</td>\n",
       "      <td>0.552117</td>\n",
       "      <td>SALT3.NIR_WAVEEXT</td>\n",
       "      <td>19.861431</td>\n",
       "      <td>62468.504</td>\n",
       "      <td>10.810230</td>\n",
       "      <td>0.1600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>-48.630583</td>\n",
       "      <td>0.724232</td>\n",
       "      <td>SALT3.NIR_WAVEEXT</td>\n",
       "      <td>19.881230</td>\n",
       "      <td>63126.920</td>\n",
       "      <td>10.967062</td>\n",
       "      <td>0.1552</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>-47.467754</td>\n",
       "      <td>0.013745</td>\n",
       "      <td>SALT3.NIR_WAVEEXT</td>\n",
       "      <td>20.312267</td>\n",
       "      <td>61420.460</td>\n",
       "      <td>11.213291</td>\n",
       "      <td>0.1590</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>-39.356796</td>\n",
       "      <td>1.138700</td>\n",
       "      <td>SALT3.NIR_WAVEEXT</td>\n",
       "      <td>19.806269</td>\n",
       "      <td>62646.273</td>\n",
       "      <td>13.250615</td>\n",
       "      <td>0.1594</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>-39.431316</td>\n",
       "      <td>-9.000000</td>\n",
       "      <td>SALT3.NIR_WAVEEXT</td>\n",
       "      <td>20.280052</td>\n",
       "      <td>61991.170</td>\n",
       "      <td>13.329910</td>\n",
       "      <td>0.1576</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>-47.505399</td>\n",
       "      <td>0.483003</td>\n",
       "      <td>SALT3.NIR_WAVEEXT</td>\n",
       "      <td>20.100517</td>\n",
       "      <td>61950.113</td>\n",
       "      <td>5.259762</td>\n",
       "      <td>0.1561</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>-48.051886</td>\n",
       "      <td>0.610329</td>\n",
       "      <td>SALT3.NIR_WAVEEXT</td>\n",
       "      <td>20.079620</td>\n",
       "      <td>62435.676</td>\n",
       "      <td>6.329367</td>\n",
       "      <td>0.1528</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>-48.138402</td>\n",
       "      <td>1.222584</td>\n",
       "      <td>SALT3.NIR_WAVEEXT</td>\n",
       "      <td>20.060863</td>\n",
       "      <td>62498.914</td>\n",
       "      <td>5.732115</td>\n",
       "      <td>0.1547</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>-41.768190</td>\n",
       "      <td>0.066350</td>\n",
       "      <td>SALT3.NIR_WAVEEXT</td>\n",
       "      <td>19.448399</td>\n",
       "      <td>62957.832</td>\n",
       "      <td>10.867562</td>\n",
       "      <td>0.1513</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>-43.257328</td>\n",
       "      <td>0.968628</td>\n",
       "      <td>SALT3.NIR_WAVEEXT</td>\n",
       "      <td>19.702734</td>\n",
       "      <td>63280.336</td>\n",
       "      <td>8.719373</td>\n",
       "      <td>0.1599</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>-41.158293</td>\n",
       "      <td>0.083044</td>\n",
       "      <td>SALT3.NIR_WAVEEXT</td>\n",
       "      <td>20.463644</td>\n",
       "      <td>61697.430</td>\n",
       "      <td>9.992236</td>\n",
       "      <td>0.1557</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>-42.986296</td>\n",
       "      <td>0.948230</td>\n",
       "      <td>SALT3.NIR_WAVEEXT</td>\n",
       "      <td>20.061668</td>\n",
       "      <td>62413.055</td>\n",
       "      <td>8.841654</td>\n",
       "      <td>0.1535</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>-40.464882</td>\n",
       "      <td>0.051797</td>\n",
       "      <td>SALT3.NIR_WAVEEXT</td>\n",
       "      <td>20.002250</td>\n",
       "      <td>62492.395</td>\n",
       "      <td>14.246160</td>\n",
       "      <td>0.1597</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>-43.238941</td>\n",
       "      <td>0.120616</td>\n",
       "      <td>SALT3.NIR_WAVEEXT</td>\n",
       "      <td>20.001596</td>\n",
       "      <td>61998.480</td>\n",
       "      <td>14.263506</td>\n",
       "      <td>0.1550</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>-45.594388</td>\n",
       "      <td>1.081561</td>\n",
       "      <td>SALT3.NIR_WAVEEXT</td>\n",
       "      <td>19.847466</td>\n",
       "      <td>63053.445</td>\n",
       "      <td>12.002251</td>\n",
       "      <td>0.1501</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>-45.973734</td>\n",
       "      <td>2.034674</td>\n",
       "      <td>SALT3.NIR_WAVEEXT</td>\n",
       "      <td>20.135891</td>\n",
       "      <td>63078.766</td>\n",
       "      <td>12.053401</td>\n",
       "      <td>0.1594</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>-46.240460</td>\n",
       "      <td>0.497418</td>\n",
       "      <td>SALT3.NIR_WAVEEXT</td>\n",
       "      <td>20.465555</td>\n",
       "      <td>62593.098</td>\n",
       "      <td>9.547982</td>\n",
       "      <td>0.1500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>-46.152607</td>\n",
       "      <td>0.219971</td>\n",
       "      <td>SALT3.NIR_WAVEEXT</td>\n",
       "      <td>19.896038</td>\n",
       "      <td>62857.203</td>\n",
       "      <td>9.258352</td>\n",
       "      <td>0.1509</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>-44.935905</td>\n",
       "      <td>0.766870</td>\n",
       "      <td>SALT3.NIR_WAVEEXT</td>\n",
       "      <td>19.738455</td>\n",
       "      <td>61920.580</td>\n",
       "      <td>11.710560</td>\n",
       "      <td>0.1540</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>-42.094119</td>\n",
       "      <td>0.755302</td>\n",
       "      <td>SALT3.NIR_WAVEEXT</td>\n",
       "      <td>19.876411</td>\n",
       "      <td>62094.914</td>\n",
       "      <td>6.614016</td>\n",
       "      <td>0.1576</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>-42.134217</td>\n",
       "      <td>0.769385</td>\n",
       "      <td>SALT3.NIR_WAVEEXT</td>\n",
       "      <td>20.538708</td>\n",
       "      <td>63290.414</td>\n",
       "      <td>5.789556</td>\n",
       "      <td>0.1591</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>-41.762016</td>\n",
       "      <td>0.507672</td>\n",
       "      <td>SALT3.NIR_WAVEEXT</td>\n",
       "      <td>19.812908</td>\n",
       "      <td>61800.285</td>\n",
       "      <td>7.403628</td>\n",
       "      <td>0.1562</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>-42.383330</td>\n",
       "      <td>0.378388</td>\n",
       "      <td>SALT3.NIR_WAVEEXT</td>\n",
       "      <td>19.757633</td>\n",
       "      <td>62219.164</td>\n",
       "      <td>6.584039</td>\n",
       "      <td>0.1556</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>-44.331992</td>\n",
       "      <td>0.204711</td>\n",
       "      <td>SALT3.NIR_WAVEEXT</td>\n",
       "      <td>20.352108</td>\n",
       "      <td>61584.977</td>\n",
       "      <td>7.664515</td>\n",
       "      <td>0.1524</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>-44.449972</td>\n",
       "      <td>3.798382</td>\n",
       "      <td>SALT3.NIR_WAVEEXT</td>\n",
       "      <td>19.733387</td>\n",
       "      <td>61759.805</td>\n",
       "      <td>7.498038</td>\n",
       "      <td>0.1584</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>-44.548932</td>\n",
       "      <td>0.072734</td>\n",
       "      <td>SALT3.NIR_WAVEEXT</td>\n",
       "      <td>19.895552</td>\n",
       "      <td>62880.625</td>\n",
       "      <td>7.565206</td>\n",
       "      <td>0.1586</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>-45.806270</td>\n",
       "      <td>2.028315</td>\n",
       "      <td>SALT3.NIR_WAVEEXT</td>\n",
       "      <td>20.487461</td>\n",
       "      <td>62972.080</td>\n",
       "      <td>6.828105</td>\n",
       "      <td>0.1540</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>-40.243949</td>\n",
       "      <td>0.195505</td>\n",
       "      <td>SALT3.NIR_WAVEEXT</td>\n",
       "      <td>20.292630</td>\n",
       "      <td>61579.590</td>\n",
       "      <td>4.723518</td>\n",
       "      <td>0.1589</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>-48.606684</td>\n",
       "      <td>0.744214</td>\n",
       "      <td>SALT3.NIR_WAVEEXT</td>\n",
       "      <td>19.786154</td>\n",
       "      <td>63270.060</td>\n",
       "      <td>6.817667</td>\n",
       "      <td>0.1546</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>-42.174724</td>\n",
       "      <td>2.922677</td>\n",
       "      <td>SALT3.NIR_WAVEEXT</td>\n",
       "      <td>20.210710</td>\n",
       "      <td>61612.920</td>\n",
       "      <td>13.034210</td>\n",
       "      <td>0.1543</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>-47.349400</td>\n",
       "      <td>0.415412</td>\n",
       "      <td>SALT3.NIR_WAVEEXT</td>\n",
       "      <td>20.471792</td>\n",
       "      <td>63290.266</td>\n",
       "      <td>13.856316</td>\n",
       "      <td>0.1590</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>-46.763301</td>\n",
       "      <td>0.117683</td>\n",
       "      <td>SALT3.NIR_WAVEEXT</td>\n",
       "      <td>19.702990</td>\n",
       "      <td>61379.880</td>\n",
       "      <td>12.688524</td>\n",
       "      <td>0.1567</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>-47.046869</td>\n",
       "      <td>1.696920</td>\n",
       "      <td>SALT3.NIR_WAVEEXT</td>\n",
       "      <td>20.297840</td>\n",
       "      <td>63161.395</td>\n",
       "      <td>14.461346</td>\n",
       "      <td>0.1516</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>-46.588217</td>\n",
       "      <td>0.032236</td>\n",
       "      <td>SALT3.NIR_WAVEEXT</td>\n",
       "      <td>19.844728</td>\n",
       "      <td>62099.965</td>\n",
       "      <td>7.572108</td>\n",
       "      <td>0.1598</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>-46.584142</td>\n",
       "      <td>0.387905</td>\n",
       "      <td>SALT3.NIR_WAVEEXT</td>\n",
       "      <td>19.960674</td>\n",
       "      <td>62253.215</td>\n",
       "      <td>6.807156</td>\n",
       "      <td>0.1578</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>-45.415448</td>\n",
       "      <td>4.847655</td>\n",
       "      <td>SALT3.NIR_WAVEEXT</td>\n",
       "      <td>19.565819</td>\n",
       "      <td>62230.630</td>\n",
       "      <td>5.124612</td>\n",
       "      <td>0.1570</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>-45.416395</td>\n",
       "      <td>4.342964</td>\n",
       "      <td>SALT3.NIR_WAVEEXT</td>\n",
       "      <td>19.579582</td>\n",
       "      <td>62474.690</td>\n",
       "      <td>5.119526</td>\n",
       "      <td>0.1570</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>-45.181935</td>\n",
       "      <td>0.796064</td>\n",
       "      <td>SALT3.NIR_WAVEEXT</td>\n",
       "      <td>20.344444</td>\n",
       "      <td>62835.990</td>\n",
       "      <td>5.627284</td>\n",
       "      <td>0.1536</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>-48.535665</td>\n",
       "      <td>2.061682</td>\n",
       "      <td>SALT3.NIR_WAVEEXT</td>\n",
       "      <td>20.212776</td>\n",
       "      <td>61938.617</td>\n",
       "      <td>14.322889</td>\n",
       "      <td>0.1556</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>-48.173435</td>\n",
       "      <td>1.226619</td>\n",
       "      <td>SALT3.NIR_WAVEEXT</td>\n",
       "      <td>20.209553</td>\n",
       "      <td>62661.953</td>\n",
       "      <td>13.323043</td>\n",
       "      <td>0.1567</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>-47.250740</td>\n",
       "      <td>0.248790</td>\n",
       "      <td>SALT3.NIR_WAVEEXT</td>\n",
       "      <td>19.989403</td>\n",
       "      <td>63064.273</td>\n",
       "      <td>14.440314</td>\n",
       "      <td>0.1502</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>-40.324633</td>\n",
       "      <td>0.507644</td>\n",
       "      <td>SALT3.NIR_WAVEEXT</td>\n",
       "      <td>19.999987</td>\n",
       "      <td>62207.440</td>\n",
       "      <td>8.911262</td>\n",
       "      <td>0.1561</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>-41.707170</td>\n",
       "      <td>1.263075</td>\n",
       "      <td>SALT3.NIR_WAVEEXT</td>\n",
       "      <td>19.811577</td>\n",
       "      <td>61626.520</td>\n",
       "      <td>8.504355</td>\n",
       "      <td>0.1554</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>-39.637867</td>\n",
       "      <td>0.478750</td>\n",
       "      <td>SALT3.NIR_WAVEEXT</td>\n",
       "      <td>19.593570</td>\n",
       "      <td>61875.754</td>\n",
       "      <td>9.190041</td>\n",
       "      <td>0.1561</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>-42.400943</td>\n",
       "      <td>0.197069</td>\n",
       "      <td>SALT3.NIR_WAVEEXT</td>\n",
       "      <td>20.368229</td>\n",
       "      <td>61522.110</td>\n",
       "      <td>10.668302</td>\n",
       "      <td>0.1575</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>-42.673976</td>\n",
       "      <td>0.377163</td>\n",
       "      <td>SALT3.NIR_WAVEEXT</td>\n",
       "      <td>20.448359</td>\n",
       "      <td>62356.293</td>\n",
       "      <td>11.074662</td>\n",
       "      <td>0.1566</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          dec  host_sn_sep         model_name  peak_mag_g   peak_mjd  \\\n",
       "0  -39.028209     0.034226  SALT3.NIR_WAVEEXT   19.921576  63079.145   \n",
       "1  -39.182274     0.132200  SALT3.NIR_WAVEEXT   19.851212  62542.703   \n",
       "2  -44.175518     0.420599  SALT3.NIR_WAVEEXT   19.957037  62647.633   \n",
       "3  -42.882932     1.292025  SALT3.NIR_WAVEEXT   20.169504  62068.797   \n",
       "4  -43.415390     0.897424  SALT3.NIR_WAVEEXT   19.629564  62221.830   \n",
       "5  -42.429656     3.851046  SALT3.NIR_WAVEEXT   19.686953  62917.890   \n",
       "6  -46.087521     0.641850  SALT3.NIR_WAVEEXT   20.338213  61519.207   \n",
       "7  -39.492079     0.552117  SALT3.NIR_WAVEEXT   19.861431  62468.504   \n",
       "8  -48.630583     0.724232  SALT3.NIR_WAVEEXT   19.881230  63126.920   \n",
       "9  -47.467754     0.013745  SALT3.NIR_WAVEEXT   20.312267  61420.460   \n",
       "10 -39.356796     1.138700  SALT3.NIR_WAVEEXT   19.806269  62646.273   \n",
       "11 -39.431316    -9.000000  SALT3.NIR_WAVEEXT   20.280052  61991.170   \n",
       "12 -47.505399     0.483003  SALT3.NIR_WAVEEXT   20.100517  61950.113   \n",
       "13 -48.051886     0.610329  SALT3.NIR_WAVEEXT   20.079620  62435.676   \n",
       "14 -48.138402     1.222584  SALT3.NIR_WAVEEXT   20.060863  62498.914   \n",
       "15 -41.768190     0.066350  SALT3.NIR_WAVEEXT   19.448399  62957.832   \n",
       "16 -43.257328     0.968628  SALT3.NIR_WAVEEXT   19.702734  63280.336   \n",
       "17 -41.158293     0.083044  SALT3.NIR_WAVEEXT   20.463644  61697.430   \n",
       "18 -42.986296     0.948230  SALT3.NIR_WAVEEXT   20.061668  62413.055   \n",
       "19 -40.464882     0.051797  SALT3.NIR_WAVEEXT   20.002250  62492.395   \n",
       "20 -43.238941     0.120616  SALT3.NIR_WAVEEXT   20.001596  61998.480   \n",
       "21 -45.594388     1.081561  SALT3.NIR_WAVEEXT   19.847466  63053.445   \n",
       "22 -45.973734     2.034674  SALT3.NIR_WAVEEXT   20.135891  63078.766   \n",
       "23 -46.240460     0.497418  SALT3.NIR_WAVEEXT   20.465555  62593.098   \n",
       "24 -46.152607     0.219971  SALT3.NIR_WAVEEXT   19.896038  62857.203   \n",
       "25 -44.935905     0.766870  SALT3.NIR_WAVEEXT   19.738455  61920.580   \n",
       "26 -42.094119     0.755302  SALT3.NIR_WAVEEXT   19.876411  62094.914   \n",
       "27 -42.134217     0.769385  SALT3.NIR_WAVEEXT   20.538708  63290.414   \n",
       "28 -41.762016     0.507672  SALT3.NIR_WAVEEXT   19.812908  61800.285   \n",
       "29 -42.383330     0.378388  SALT3.NIR_WAVEEXT   19.757633  62219.164   \n",
       "30 -44.331992     0.204711  SALT3.NIR_WAVEEXT   20.352108  61584.977   \n",
       "31 -44.449972     3.798382  SALT3.NIR_WAVEEXT   19.733387  61759.805   \n",
       "32 -44.548932     0.072734  SALT3.NIR_WAVEEXT   19.895552  62880.625   \n",
       "33 -45.806270     2.028315  SALT3.NIR_WAVEEXT   20.487461  62972.080   \n",
       "34 -40.243949     0.195505  SALT3.NIR_WAVEEXT   20.292630  61579.590   \n",
       "35 -48.606684     0.744214  SALT3.NIR_WAVEEXT   19.786154  63270.060   \n",
       "36 -42.174724     2.922677  SALT3.NIR_WAVEEXT   20.210710  61612.920   \n",
       "37 -47.349400     0.415412  SALT3.NIR_WAVEEXT   20.471792  63290.266   \n",
       "38 -46.763301     0.117683  SALT3.NIR_WAVEEXT   19.702990  61379.880   \n",
       "39 -47.046869     1.696920  SALT3.NIR_WAVEEXT   20.297840  63161.395   \n",
       "40 -46.588217     0.032236  SALT3.NIR_WAVEEXT   19.844728  62099.965   \n",
       "41 -46.584142     0.387905  SALT3.NIR_WAVEEXT   19.960674  62253.215   \n",
       "42 -45.415448     4.847655  SALT3.NIR_WAVEEXT   19.565819  62230.630   \n",
       "43 -45.416395     4.342964  SALT3.NIR_WAVEEXT   19.579582  62474.690   \n",
       "44 -45.181935     0.796064  SALT3.NIR_WAVEEXT   20.344444  62835.990   \n",
       "45 -48.535665     2.061682  SALT3.NIR_WAVEEXT   20.212776  61938.617   \n",
       "46 -48.173435     1.226619  SALT3.NIR_WAVEEXT   20.209553  62661.953   \n",
       "47 -47.250740     0.248790  SALT3.NIR_WAVEEXT   19.989403  63064.273   \n",
       "48 -40.324633     0.507644  SALT3.NIR_WAVEEXT   19.999987  62207.440   \n",
       "49 -41.707170     1.263075  SALT3.NIR_WAVEEXT   19.811577  61626.520   \n",
       "50 -39.637867     0.478750  SALT3.NIR_WAVEEXT   19.593570  61875.754   \n",
       "51 -42.400943     0.197069  SALT3.NIR_WAVEEXT   20.368229  61522.110   \n",
       "52 -42.673976     0.377163  SALT3.NIR_WAVEEXT   20.448359  62356.293   \n",
       "\n",
       "           ra   z_cmb  \n",
       "0    9.869027  0.1594  \n",
       "1    9.485179  0.1562  \n",
       "2    6.505097  0.1502  \n",
       "3    8.388646  0.1588  \n",
       "4    7.690245  0.1510  \n",
       "5    7.706417  0.1588  \n",
       "6    6.042713  0.1579  \n",
       "7   10.810230  0.1600  \n",
       "8   10.967062  0.1552  \n",
       "9   11.213291  0.1590  \n",
       "10  13.250615  0.1594  \n",
       "11  13.329910  0.1576  \n",
       "12   5.259762  0.1561  \n",
       "13   6.329367  0.1528  \n",
       "14   5.732115  0.1547  \n",
       "15  10.867562  0.1513  \n",
       "16   8.719373  0.1599  \n",
       "17   9.992236  0.1557  \n",
       "18   8.841654  0.1535  \n",
       "19  14.246160  0.1597  \n",
       "20  14.263506  0.1550  \n",
       "21  12.002251  0.1501  \n",
       "22  12.053401  0.1594  \n",
       "23   9.547982  0.1500  \n",
       "24   9.258352  0.1509  \n",
       "25  11.710560  0.1540  \n",
       "26   6.614016  0.1576  \n",
       "27   5.789556  0.1591  \n",
       "28   7.403628  0.1562  \n",
       "29   6.584039  0.1556  \n",
       "30   7.664515  0.1524  \n",
       "31   7.498038  0.1584  \n",
       "32   7.565206  0.1586  \n",
       "33   6.828105  0.1540  \n",
       "34   4.723518  0.1589  \n",
       "35   6.817667  0.1546  \n",
       "36  13.034210  0.1543  \n",
       "37  13.856316  0.1590  \n",
       "38  12.688524  0.1567  \n",
       "39  14.461346  0.1516  \n",
       "40   7.572108  0.1598  \n",
       "41   6.807156  0.1578  \n",
       "42   5.124612  0.1570  \n",
       "43   5.119526  0.1570  \n",
       "44   5.627284  0.1536  \n",
       "45  14.322889  0.1556  \n",
       "46  13.323043  0.1567  \n",
       "47  14.440314  0.1502  \n",
       "48   8.911262  0.1561  \n",
       "49   8.504355  0.1554  \n",
       "50   9.190041  0.1561  \n",
       "51  10.668302  0.1575  \n",
       "52  11.074662  0.1566  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "# There is a special parameter \"fields\" that can be used to reduce how much is returned.\n",
    "# (Also going to limit to gentype 10, which is SN Ia.)\n",
    "# This also demostrates that you can freely mix URL parameters and POST parameters\n",
    "result = req.post( f'{server_url}/findtransients/z_cmb_min=0.15/z_cmb_max=0.16/gentype=10',\n",
    "                     json={ 'fields': ( 'ra', 'dec', 'z_cmb', 'host_sn_sep', \n",
    "                                        'peak_mjd', 'peak_mag_g', 'model_name' ) } )\n",
    "if result.status_code != 200:\n",
    "    raise RuntimeError( f\"Got status code {result.status_code}\\n{result.text}\" )\n",
    "    \n",
    "df = pandas.DataFrame( result.json() )\n",
    "print( f\"Got {len(df)} transients\" )\n",
    "display( df )\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "cb6d404c-0b97-48ca-a04f-4ca356abacd1",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "NERSC Python",
   "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.11.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}