Capital-colname.ipynb

{"metadata":{"kernelspec":{"name":"conda-root-py","display_name":"Python [conda env:root] *","language":"python"},"language_info":{"name":"python","version":"3.10.12","mimetype":"text/x-python","codemirror_mode":{"name":"ipython","version":3},"pygments_lexer":"ipython3","nbconvert_exporter":"python","file_extension":".py"}},"nbformat_minor":5,"nbformat":4,"cells":[{"id":"61a429db-e44a-4f68-9d58-f783876861a4","cell_type":"code","source":"import astroquery\n\nastroquery.__version__","metadata":{"trusted":true,"execution":{"iopub.status.busy":"2023-12-30T23:20:11.260956Z","iopub.execute_input":"2023-12-30T23:20:11.261078Z","iopub.status.idle":"2023-12-30T23:20:11.629778Z","shell.execute_reply.started":"2023-12-30T23:20:11.261068Z","shell.execute_reply":"2023-12-30T23:20:11.629145Z"}},"outputs":[{"execution_count":1,"output_type":"execute_result","data":{"text/plain":"'0.4.7.dev9015'"},"metadata":{}}],"execution_count":1},{"id":"4c4958b6-553a-4ce7-88f7-d9a372e87a06","cell_type":"code","source":"from astroquery.gaia import Gaia","metadata":{"trusted":true,"execution":{"iopub.status.busy":"2023-12-30T23:20:11.633202Z","iopub.execute_input":"2023-12-30T23:20:11.633536Z","iopub.status.idle":"2023-12-30T23:20:12.444602Z","shell.execute_reply.started":"2023-12-30T23:20:11.633506Z","shell.execute_reply":"2023-12-30T23:20:12.443622Z"}},"outputs":[],"execution_count":2},{"id":"2866eb2b-f3bd-4866-bc80-a4cd99fe87e2","cell_type":"code","source":"query = \"\"\"\nSELECT * FROM gaiadr2.gaia_source AS gaia\nWHERE gaia.source_id = 4205572950572486656\n\"\"\"\njob = Gaia.launch_job(query)","metadata":{"trusted":true,"execution":{"iopub.status.busy":"2023-12-30T23:20:12.449526Z","iopub.execute_input":"2023-12-30T23:20:12.450869Z","iopub.status.idle":"2023-12-30T23:20:12.959903Z","shell.execute_reply.started":"2023-12-30T23:20:12.450823Z","shell.execute_reply":"2023-12-30T23:20:12.959581Z"}},"outputs":[],"execution_count":3},{"id":"ae3d9341-e968-4947-a33a-864f49c14d8a","cell_type":"code","source":"r = job.get_results()","metadata":{"trusted":true,"execution":{"iopub.status.busy":"2023-12-30T23:20:12.960415Z","iopub.execute_input":"2023-12-30T23:20:12.960506Z","iopub.status.idle":"2023-12-30T23:20:12.962302Z","shell.execute_reply.started":"2023-12-30T23:20:12.960498Z","shell.execute_reply":"2023-12-30T23:20:12.962036Z"}},"outputs":[],"execution_count":4},{"id":"696fc751-1135-427c-98b8-8c280b4f2170","cell_type":"code","source":"r","metadata":{"trusted":true,"execution":{"iopub.status.busy":"2023-12-30T23:20:12.963814Z","iopub.execute_input":"2023-12-30T23:20:12.964304Z","iopub.status.idle":"2023-12-30T23:20:12.978437Z","shell.execute_reply.started":"2023-12-30T23:20:12.964260Z","shell.execute_reply":"2023-12-30T23:20:12.977972Z"}},"outputs":[{"execution_count":5,"output_type":"execute_result","data":{"text/plain":"<Table length=1>\n    solution_id             DESIGNATION               source_id      random_index ref_epoch         ra               ra_error             dec         ... radius_percentile_lower radius_percentile_upper lum_val lum_percentile_lower lum_percentile_upper                                     datalink_url                                    epoch_photometry_url\n                                                                                      yr           deg                 mas                deg         ...          solRad                  solRad          solLum        solLum               solLum                                                                                                                \n       int64                   object                   int64           int64      float64       float64             float64            float64       ...         float32                 float32         float32       float32              float32                                               object                                              object       \n------------------- ---------------------------- ------------------- ------------ --------- ------------------ ------------------- ------------------ ... ----------------------- ----------------------- ------- -------------------- -------------------- ----------------------------------------------------------------------------------- --------------------\n1635721458409799680 Gaia DR2 4205572950572486656 4205572950572486656            0    2015.5 284.99739676167115 0.32021322712716477 -7.213793616274905 ...                      --                      --      --                   --                   -- https://gea.esac.esa.int/data-server/datalink/links?ID=Gaia+DR2+4205572950572486656                     ","text/html":"<div><i>Table length=1</i>\n<table id=\"table4734169008\" class=\"table-striped table-bordered table-condensed\">\n<thead><tr><th>solution_id</th><th>DESIGNATION</th><th>source_id</th><th>random_index</th><th>ref_epoch</th><th>ra</th><th>ra_error</th><th>dec</th><th>dec_error</th><th>parallax</th><th>parallax_error</th><th>parallax_over_error</th><th>pmra</th><th>pmra_error</th><th>pmdec</th><th>pmdec_error</th><th>ra_dec_corr</th><th>ra_parallax_corr</th><th>ra_pmra_corr</th><th>ra_pmdec_corr</th><th>dec_parallax_corr</th><th>dec_pmra_corr</th><th>dec_pmdec_corr</th><th>parallax_pmra_corr</th><th>parallax_pmdec_corr</th><th>pmra_pmdec_corr</th><th>astrometric_n_obs_al</th><th>astrometric_n_obs_ac</th><th>astrometric_n_good_obs_al</th><th>astrometric_n_bad_obs_al</th><th>astrometric_gof_al</th><th>astrometric_chi2_al</th><th>astrometric_excess_noise</th><th>astrometric_excess_noise_sig</th><th>astrometric_params_solved</th><th>astrometric_primary_flag</th><th>astrometric_weight_al</th><th>astrometric_pseudo_colour</th><th>astrometric_pseudo_colour_error</th><th>mean_varpi_factor_al</th><th>astrometric_matched_observations</th><th>visibility_periods_used</th><th>astrometric_sigma5d_max</th><th>frame_rotator_object_type</th><th>matched_observations</th><th>duplicated_source</th><th>phot_g_n_obs</th><th>phot_g_mean_flux</th><th>phot_g_mean_flux_error</th><th>phot_g_mean_flux_over_error</th><th>phot_g_mean_mag</th><th>phot_bp_n_obs</th><th>phot_bp_mean_flux</th><th>phot_bp_mean_flux_error</th><th>phot_bp_mean_flux_over_error</th><th>phot_bp_mean_mag</th><th>phot_rp_n_obs</th><th>phot_rp_mean_flux</th><th>phot_rp_mean_flux_error</th><th>phot_rp_mean_flux_over_error</th><th>phot_rp_mean_mag</th><th>phot_bp_rp_excess_factor</th><th>phot_proc_mode</th><th>bp_rp</th><th>bp_g</th><th>g_rp</th><th>radial_velocity</th><th>radial_velocity_error</th><th>rv_nb_transits</th><th>rv_template_teff</th><th>rv_template_logg</th><th>rv_template_fe_h</th><th>phot_variable_flag</th><th>l</th><th>b</th><th>ecl_lon</th><th>ecl_lat</th><th>priam_flags</th><th>teff_val</th><th>teff_percentile_lower</th><th>teff_percentile_upper</th><th>a_g_val</th><th>a_g_percentile_lower</th><th>a_g_percentile_upper</th><th>e_bp_min_rp_val</th><th>e_bp_min_rp_percentile_lower</th><th>e_bp_min_rp_percentile_upper</th><th>flame_flags</th><th>radius_val</th><th>radius_percentile_lower</th><th>radius_percentile_upper</th><th>lum_val</th><th>lum_percentile_lower</th><th>lum_percentile_upper</th><th>datalink_url</th><th>epoch_photometry_url</th></tr></thead>\n<thead><tr><th></th><th></th><th></th><th></th><th>yr</th><th>deg</th><th>mas</th><th>deg</th><th>mas</th><th>mas</th><th>mas</th><th></th><th>mas / yr</th><th>mas / yr</th><th>mas / yr</th><th>mas / yr</th><th></th><th></th><th></th><th></th><th></th><th></th><th></th><th></th><th></th><th></th><th></th><th></th><th></th><th></th><th></th><th></th><th>mas</th><th></th><th></th><th></th><th>1 / mas2</th><th>1 / um</th><th>1 / um</th><th></th><th></th><th></th><th>mas</th><th></th><th></th><th></th><th></th><th>electron / s</th><th>electron / s</th><th></th><th>mag</th><th></th><th>electron / s</th><th>electron / s</th><th></th><th>mag</th><th></th><th>electron / s</th><th>electron / s</th><th></th><th>mag</th><th></th><th></th><th>mag</th><th>mag</th><th>mag</th><th>km / s</th><th>km / s</th><th></th><th>K</th><th>log(cm.s**-2)</th><th>dex</th><th></th><th>deg</th><th>deg</th><th>deg</th><th>deg</th><th></th><th>K</th><th>K</th><th>K</th><th>mag</th><th>mag</th><th>mag</th><th>mag</th><th>mag</th><th>mag</th><th></th><th>solRad</th><th>solRad</th><th>solRad</th><th>solLum</th><th>solLum</th><th>solLum</th><th></th><th></th></tr></thead>\n<thead><tr><th>int64</th><th>object</th><th>int64</th><th>int64</th><th>float64</th><th>float64</th><th>float64</th><th>float64</th><th>float64</th><th>float64</th><th>float64</th><th>float32</th><th>float64</th><th>float64</th><th>float64</th><th>float64</th><th>float32</th><th>float32</th><th>float32</th><th>float32</th><th>float32</th><th>float32</th><th>float32</th><th>float32</th><th>float32</th><th>float32</th><th>int32</th><th>int32</th><th>int32</th><th>int32</th><th>float32</th><th>float32</th><th>float64</th><th>float64</th><th>int16</th><th>bool</th><th>float32</th><th>float64</th><th>float64</th><th>float32</th><th>int16</th><th>int16</th><th>float32</th><th>int32</th><th>int16</th><th>bool</th><th>int32</th><th>float64</th><th>float64</th><th>float32</th><th>float32</th><th>int32</th><th>float64</th><th>float64</th><th>float32</th><th>float32</th><th>int32</th><th>float64</th><th>float64</th><th>float32</th><th>float32</th><th>float32</th><th>int16</th><th>float32</th><th>float32</th><th>float32</th><th>float64</th><th>float64</th><th>int32</th><th>float32</th><th>float32</th><th>float32</th><th>object</th><th>float64</th><th>float64</th><th>float64</th><th>float64</th><th>int64</th><th>float32</th><th>float32</th><th>float32</th><th>float32</th><th>float32</th><th>float32</th><th>float32</th><th>float32</th><th>float32</th><th>int64</th><th>float32</th><th>float32</th><th>float32</th><th>float32</th><th>float32</th><th>float32</th><th>object</th><th>object</th></tr></thead>\n<tr><td>1635721458409799680</td><td>Gaia DR2 4205572950572486656</td><td>4205572950572486656</td><td>0</td><td>2015.5</td><td>284.99739676167115</td><td>0.32021322712716477</td><td>-7.213793616274905</td><td>0.250721742560638</td><td>0.3368539525614086</td><td>0.2571070860175622</td><td>1.3101698</td><td>0.2710929173544655</td><td>0.6386887441973075</td><td>-0.8245084067543891</td><td>0.4678652748248424</td><td>0.4700719</td><td>0.42733705</td><td>-0.8003847</td><td>-0.48682573</td><td>0.019714236</td><td>-0.42549297</td><td>-0.69080716</td><td>-0.5605439</td><td>-0.04946403</td><td>0.54531914</td><td>97</td><td>0</td><td>97</td><td>0</td><td>0.80534214</td><td>102.64346</td><td>0.24166039386492902</td><td>0.2542542394472767</td><td>31</td><td>False</td><td>0.6448313</td><td>1.4974294542379536</td><td>0.054770738563812094</td><td>0.06562022</td><td>11</td><td>8</td><td>0.6980315</td><td>0</td><td>11</td><td>False</td><td>95</td><td>947.8486560009569</td><td>2.411390449458365</td><td>393.0714</td><td>18.24652</td><td>11</td><td>406.9520828279932</td><td>18.000334291644847</td><td>22.608028</td><td>18.82753</td><td>10</td><td>777.7130881135372</td><td>14.03050693560755</td><td>55.43015</td><td>17.534872</td><td>1.2498463</td><td>0</td><td>1.2926579</td><td>0.5810108</td><td>0.71164703</td><td>--</td><td>--</td><td>0</td><td>--</td><td>--</td><td>--</td><td>NOT_AVAILABLE</td><td>27.465051949212157</td><td>-5.174943757191669</td><td>285.4454044280279</td><td>15.42496849132661</td><td>--</td><td>--</td><td>--</td><td>--</td><td>--</td><td>--</td><td>--</td><td>--</td><td>--</td><td>--</td><td>--</td><td>--</td><td>--</td><td>--</td><td>--</td><td>--</td><td>--</td><td>https://gea.esac.esa.int/data-server/datalink/links?ID=Gaia+DR2+4205572950572486656</td><td></td></tr>\n</table></div>"},"metadata":{}}],"execution_count":5},{"id":"64930756-2673-4700-9cca-7b1ff072820e","cell_type":"code","source":"from astroquery.utils.tap import TapPlus","metadata":{"trusted":true,"execution":{"iopub.status.busy":"2023-12-30T23:20:12.979663Z","iopub.execute_input":"2023-12-30T23:20:12.979826Z","iopub.status.idle":"2023-12-30T23:20:12.982741Z","shell.execute_reply.started":"2023-12-30T23:20:12.979813Z","shell.execute_reply":"2023-12-30T23:20:12.982092Z"}},"outputs":[],"execution_count":6},{"id":"a847e61a-924d-4e5e-b63f-7449c9a680e7","cell_type":"code","source":"tap = TapPlus(\n    url=\"https://gea.esac.esa.int/\",\n    server_context=\"data-server\",\n    tap_context=\"tap\",\n    upload_context=\"Upload\",\n    table_edit_context=\"TableTool\",\n    data_context=\"data\",\n    datalink_context=\"datalink\",\n    verbose=False,\n)","metadata":{"trusted":true,"execution":{"iopub.status.busy":"2023-12-30T23:20:12.983354Z","iopub.execute_input":"2023-12-30T23:20:12.983453Z","iopub.status.idle":"2023-12-30T23:20:12.985887Z","shell.execute_reply.started":"2023-12-30T23:20:12.983445Z","shell.execute_reply":"2023-12-30T23:20:12.985553Z"}},"outputs":[],"execution_count":7},{"id":"92519067-aee7-4c82-a3a6-5d8b0de957ab","cell_type":"code","source":"job = tap.launch_job(query)\njob.get_results()","metadata":{"trusted":true,"execution":{"iopub.status.busy":"2023-12-30T23:20:13.091243Z","iopub.execute_input":"2023-12-30T23:20:13.091717Z","iopub.status.idle":"2023-12-30T23:20:13.570486Z","shell.execute_reply.started":"2023-12-30T23:20:13.091686Z","shell.execute_reply":"2023-12-30T23:20:13.570062Z"}},"outputs":[{"execution_count":8,"output_type":"execute_result","data":{"text/plain":"<Table length=1>\n    solution_id             designation               source_id      random_index ref_epoch         ra               ra_error             dec             dec_error     ... radius_val radius_percentile_lower radius_percentile_upper lum_val lum_percentile_lower lum_percentile_upper                      datalink_url                     epoch_photometry_url\n                                                                                      yr           deg                 mas                deg                mas        ...   solRad            solRad                  solRad          solLum        solLum               solLum                                                                                  \n       int64                   object                   int64           int64      float64       float64             float64            float64            float64      ...  float32           float32                 float32         float32       float32              float32                                object                               object       \n------------------- ---------------------------- ------------------- ------------ --------- ------------------ ------------------- ------------------ ----------------- ... ---------- ----------------------- ----------------------- ------- -------------------- -------------------- ----------------------------------------------------- --------------------\n1635721458409799680 Gaia DR2 4205572950572486656 4205572950572486656            0    2015.5 284.99739676167115 0.32021322712716477 -7.213793616274905 0.250721742560638 ...         --                      --                      --      --                   --                   -- https://gea.esac.esa.int?Gaia DR2 4205572950572486656                     ","text/html":"<div><i>Table length=1</i>\n<table id=\"table4399566416\" class=\"table-striped table-bordered table-condensed\">\n<thead><tr><th>solution_id</th><th>designation</th><th>source_id</th><th>random_index</th><th>ref_epoch</th><th>ra</th><th>ra_error</th><th>dec</th><th>dec_error</th><th>parallax</th><th>parallax_error</th><th>parallax_over_error</th><th>pmra</th><th>pmra_error</th><th>pmdec</th><th>pmdec_error</th><th>ra_dec_corr</th><th>ra_parallax_corr</th><th>ra_pmra_corr</th><th>ra_pmdec_corr</th><th>dec_parallax_corr</th><th>dec_pmra_corr</th><th>dec_pmdec_corr</th><th>parallax_pmra_corr</th><th>parallax_pmdec_corr</th><th>pmra_pmdec_corr</th><th>astrometric_n_obs_al</th><th>astrometric_n_obs_ac</th><th>astrometric_n_good_obs_al</th><th>astrometric_n_bad_obs_al</th><th>astrometric_gof_al</th><th>astrometric_chi2_al</th><th>astrometric_excess_noise</th><th>astrometric_excess_noise_sig</th><th>astrometric_params_solved</th><th>astrometric_primary_flag</th><th>astrometric_weight_al</th><th>astrometric_pseudo_colour</th><th>astrometric_pseudo_colour_error</th><th>mean_varpi_factor_al</th><th>astrometric_matched_observations</th><th>visibility_periods_used</th><th>astrometric_sigma5d_max</th><th>frame_rotator_object_type</th><th>matched_observations</th><th>duplicated_source</th><th>phot_g_n_obs</th><th>phot_g_mean_flux</th><th>phot_g_mean_flux_error</th><th>phot_g_mean_flux_over_error</th><th>phot_g_mean_mag</th><th>phot_bp_n_obs</th><th>phot_bp_mean_flux</th><th>phot_bp_mean_flux_error</th><th>phot_bp_mean_flux_over_error</th><th>phot_bp_mean_mag</th><th>phot_rp_n_obs</th><th>phot_rp_mean_flux</th><th>phot_rp_mean_flux_error</th><th>phot_rp_mean_flux_over_error</th><th>phot_rp_mean_mag</th><th>phot_bp_rp_excess_factor</th><th>phot_proc_mode</th><th>bp_rp</th><th>bp_g</th><th>g_rp</th><th>radial_velocity</th><th>radial_velocity_error</th><th>rv_nb_transits</th><th>rv_template_teff</th><th>rv_template_logg</th><th>rv_template_fe_h</th><th>phot_variable_flag</th><th>l</th><th>b</th><th>ecl_lon</th><th>ecl_lat</th><th>priam_flags</th><th>teff_val</th><th>teff_percentile_lower</th><th>teff_percentile_upper</th><th>a_g_val</th><th>a_g_percentile_lower</th><th>a_g_percentile_upper</th><th>e_bp_min_rp_val</th><th>e_bp_min_rp_percentile_lower</th><th>e_bp_min_rp_percentile_upper</th><th>flame_flags</th><th>radius_val</th><th>radius_percentile_lower</th><th>radius_percentile_upper</th><th>lum_val</th><th>lum_percentile_lower</th><th>lum_percentile_upper</th><th>datalink_url</th><th>epoch_photometry_url</th></tr></thead>\n<thead><tr><th></th><th></th><th></th><th></th><th>yr</th><th>deg</th><th>mas</th><th>deg</th><th>mas</th><th>mas</th><th>mas</th><th></th><th>mas / yr</th><th>mas / yr</th><th>mas / yr</th><th>mas / yr</th><th></th><th></th><th></th><th></th><th></th><th></th><th></th><th></th><th></th><th></th><th></th><th></th><th></th><th></th><th></th><th></th><th>mas</th><th></th><th></th><th></th><th>1 / mas2</th><th>1 / um</th><th>1 / um</th><th></th><th></th><th></th><th>mas</th><th></th><th></th><th></th><th></th><th>electron / s</th><th>electron / s</th><th></th><th>mag</th><th></th><th>electron / s</th><th>electron / s</th><th></th><th>mag</th><th></th><th>electron / s</th><th>electron / s</th><th></th><th>mag</th><th></th><th></th><th>mag</th><th>mag</th><th>mag</th><th>km / s</th><th>km / s</th><th></th><th>K</th><th>log(cm.s**-2)</th><th>dex</th><th></th><th>deg</th><th>deg</th><th>deg</th><th>deg</th><th></th><th>K</th><th>K</th><th>K</th><th>mag</th><th>mag</th><th>mag</th><th>mag</th><th>mag</th><th>mag</th><th></th><th>solRad</th><th>solRad</th><th>solRad</th><th>solLum</th><th>solLum</th><th>solLum</th><th></th><th></th></tr></thead>\n<thead><tr><th>int64</th><th>object</th><th>int64</th><th>int64</th><th>float64</th><th>float64</th><th>float64</th><th>float64</th><th>float64</th><th>float64</th><th>float64</th><th>float32</th><th>float64</th><th>float64</th><th>float64</th><th>float64</th><th>float32</th><th>float32</th><th>float32</th><th>float32</th><th>float32</th><th>float32</th><th>float32</th><th>float32</th><th>float32</th><th>float32</th><th>int32</th><th>int32</th><th>int32</th><th>int32</th><th>float32</th><th>float32</th><th>float64</th><th>float64</th><th>int16</th><th>bool</th><th>float32</th><th>float64</th><th>float64</th><th>float32</th><th>int16</th><th>int16</th><th>float32</th><th>int32</th><th>int16</th><th>bool</th><th>int32</th><th>float64</th><th>float64</th><th>float32</th><th>float32</th><th>int32</th><th>float64</th><th>float64</th><th>float32</th><th>float32</th><th>int32</th><th>float64</th><th>float64</th><th>float32</th><th>float32</th><th>float32</th><th>int16</th><th>float32</th><th>float32</th><th>float32</th><th>float64</th><th>float64</th><th>int32</th><th>float32</th><th>float32</th><th>float32</th><th>object</th><th>float64</th><th>float64</th><th>float64</th><th>float64</th><th>int64</th><th>float32</th><th>float32</th><th>float32</th><th>float32</th><th>float32</th><th>float32</th><th>float32</th><th>float32</th><th>float32</th><th>int64</th><th>float32</th><th>float32</th><th>float32</th><th>float32</th><th>float32</th><th>float32</th><th>object</th><th>object</th></tr></thead>\n<tr><td>1635721458409799680</td><td>Gaia DR2 4205572950572486656</td><td>4205572950572486656</td><td>0</td><td>2015.5</td><td>284.99739676167115</td><td>0.32021322712716477</td><td>-7.213793616274905</td><td>0.250721742560638</td><td>0.3368539525614086</td><td>0.2571070860175622</td><td>1.3101698</td><td>0.2710929173544655</td><td>0.6386887441973075</td><td>-0.8245084067543891</td><td>0.4678652748248424</td><td>0.4700719</td><td>0.42733705</td><td>-0.8003847</td><td>-0.48682573</td><td>0.019714236</td><td>-0.42549297</td><td>-0.69080716</td><td>-0.5605439</td><td>-0.04946403</td><td>0.54531914</td><td>97</td><td>0</td><td>97</td><td>0</td><td>0.80534214</td><td>102.64346</td><td>0.24166039386492902</td><td>0.2542542394472767</td><td>31</td><td>False</td><td>0.6448313</td><td>1.4974294542379536</td><td>0.054770738563812094</td><td>0.06562022</td><td>11</td><td>8</td><td>0.6980315</td><td>0</td><td>11</td><td>False</td><td>95</td><td>947.8486560009569</td><td>2.411390449458365</td><td>393.0714</td><td>18.24652</td><td>11</td><td>406.9520828279932</td><td>18.000334291644847</td><td>22.608028</td><td>18.82753</td><td>10</td><td>777.7130881135372</td><td>14.03050693560755</td><td>55.43015</td><td>17.534872</td><td>1.2498463</td><td>0</td><td>1.2926579</td><td>0.5810108</td><td>0.71164703</td><td>--</td><td>--</td><td>0</td><td>--</td><td>--</td><td>--</td><td>NOT_AVAILABLE</td><td>27.465051949212157</td><td>-5.174943757191669</td><td>285.4454044280279</td><td>15.42496849132661</td><td>--</td><td>--</td><td>--</td><td>--</td><td>--</td><td>--</td><td>--</td><td>--</td><td>--</td><td>--</td><td>--</td><td>--</td><td>--</td><td>--</td><td>--</td><td>--</td><td>--</td><td>https://gea.esac.esa.int?Gaia DR2 4205572950572486656</td><td></td></tr>\n</table></div>"},"metadata":{}}],"execution_count":8},{"id":"36e738c7-af87-45c8-8209-b06989339520","cell_type":"code","source":"job = tap.launch_job(\n    query,\n    name=None,\n    output_file=None,\n    output_format=\"votable\",\n    verbose=False,\n    dump_to_file=False,\n    upload_resource=None,\n    upload_table_name=None,\n)\njob.get_results()","metadata":{"trusted":true,"execution":{"iopub.status.busy":"2023-12-30T23:20:13.571551Z","iopub.execute_input":"2023-12-30T23:20:13.571825Z","iopub.status.idle":"2023-12-30T23:20:14.051456Z","shell.execute_reply.started":"2023-12-30T23:20:13.571815Z","shell.execute_reply":"2023-12-30T23:20:14.051196Z"}},"outputs":[{"execution_count":9,"output_type":"execute_result","data":{"text/plain":"<Table length=1>\n    solution_id             designation               source_id      random_index ref_epoch         ra               ra_error             dec             dec_error     ... radius_val radius_percentile_lower radius_percentile_upper lum_val lum_percentile_lower lum_percentile_upper                      datalink_url                     epoch_photometry_url\n                                                                                      yr           deg                 mas                deg                mas        ...   solRad            solRad                  solRad          solLum        solLum               solLum                                                                                  \n       int64                   object                   int64           int64      float64       float64             float64            float64            float64      ...  float32           float32                 float32         float32       float32              float32                                object                               object       \n------------------- ---------------------------- ------------------- ------------ --------- ------------------ ------------------- ------------------ ----------------- ... ---------- ----------------------- ----------------------- ------- -------------------- -------------------- ----------------------------------------------------- --------------------\n1635721458409799680 Gaia DR2 4205572950572486656 4205572950572486656            0    2015.5 284.99739676167115 0.32021322712716477 -7.213793616274905 0.250721742560638 ...         --                      --                      --      --                   --                   -- https://gea.esac.esa.int?Gaia DR2 4205572950572486656                     ","text/html":"<div><i>Table length=1</i>\n<table id=\"table4419942048\" class=\"table-striped table-bordered table-condensed\">\n<thead><tr><th>solution_id</th><th>designation</th><th>source_id</th><th>random_index</th><th>ref_epoch</th><th>ra</th><th>ra_error</th><th>dec</th><th>dec_error</th><th>parallax</th><th>parallax_error</th><th>parallax_over_error</th><th>pmra</th><th>pmra_error</th><th>pmdec</th><th>pmdec_error</th><th>ra_dec_corr</th><th>ra_parallax_corr</th><th>ra_pmra_corr</th><th>ra_pmdec_corr</th><th>dec_parallax_corr</th><th>dec_pmra_corr</th><th>dec_pmdec_corr</th><th>parallax_pmra_corr</th><th>parallax_pmdec_corr</th><th>pmra_pmdec_corr</th><th>astrometric_n_obs_al</th><th>astrometric_n_obs_ac</th><th>astrometric_n_good_obs_al</th><th>astrometric_n_bad_obs_al</th><th>astrometric_gof_al</th><th>astrometric_chi2_al</th><th>astrometric_excess_noise</th><th>astrometric_excess_noise_sig</th><th>astrometric_params_solved</th><th>astrometric_primary_flag</th><th>astrometric_weight_al</th><th>astrometric_pseudo_colour</th><th>astrometric_pseudo_colour_error</th><th>mean_varpi_factor_al</th><th>astrometric_matched_observations</th><th>visibility_periods_used</th><th>astrometric_sigma5d_max</th><th>frame_rotator_object_type</th><th>matched_observations</th><th>duplicated_source</th><th>phot_g_n_obs</th><th>phot_g_mean_flux</th><th>phot_g_mean_flux_error</th><th>phot_g_mean_flux_over_error</th><th>phot_g_mean_mag</th><th>phot_bp_n_obs</th><th>phot_bp_mean_flux</th><th>phot_bp_mean_flux_error</th><th>phot_bp_mean_flux_over_error</th><th>phot_bp_mean_mag</th><th>phot_rp_n_obs</th><th>phot_rp_mean_flux</th><th>phot_rp_mean_flux_error</th><th>phot_rp_mean_flux_over_error</th><th>phot_rp_mean_mag</th><th>phot_bp_rp_excess_factor</th><th>phot_proc_mode</th><th>bp_rp</th><th>bp_g</th><th>g_rp</th><th>radial_velocity</th><th>radial_velocity_error</th><th>rv_nb_transits</th><th>rv_template_teff</th><th>rv_template_logg</th><th>rv_template_fe_h</th><th>phot_variable_flag</th><th>l</th><th>b</th><th>ecl_lon</th><th>ecl_lat</th><th>priam_flags</th><th>teff_val</th><th>teff_percentile_lower</th><th>teff_percentile_upper</th><th>a_g_val</th><th>a_g_percentile_lower</th><th>a_g_percentile_upper</th><th>e_bp_min_rp_val</th><th>e_bp_min_rp_percentile_lower</th><th>e_bp_min_rp_percentile_upper</th><th>flame_flags</th><th>radius_val</th><th>radius_percentile_lower</th><th>radius_percentile_upper</th><th>lum_val</th><th>lum_percentile_lower</th><th>lum_percentile_upper</th><th>datalink_url</th><th>epoch_photometry_url</th></tr></thead>\n<thead><tr><th></th><th></th><th></th><th></th><th>yr</th><th>deg</th><th>mas</th><th>deg</th><th>mas</th><th>mas</th><th>mas</th><th></th><th>mas / yr</th><th>mas / yr</th><th>mas / yr</th><th>mas / yr</th><th></th><th></th><th></th><th></th><th></th><th></th><th></th><th></th><th></th><th></th><th></th><th></th><th></th><th></th><th></th><th></th><th>mas</th><th></th><th></th><th></th><th>1 / mas2</th><th>1 / um</th><th>1 / um</th><th></th><th></th><th></th><th>mas</th><th></th><th></th><th></th><th></th><th>electron / s</th><th>electron / s</th><th></th><th>mag</th><th></th><th>electron / s</th><th>electron / s</th><th></th><th>mag</th><th></th><th>electron / s</th><th>electron / s</th><th></th><th>mag</th><th></th><th></th><th>mag</th><th>mag</th><th>mag</th><th>km / s</th><th>km / s</th><th></th><th>K</th><th>log(cm.s**-2)</th><th>dex</th><th></th><th>deg</th><th>deg</th><th>deg</th><th>deg</th><th></th><th>K</th><th>K</th><th>K</th><th>mag</th><th>mag</th><th>mag</th><th>mag</th><th>mag</th><th>mag</th><th></th><th>solRad</th><th>solRad</th><th>solRad</th><th>solLum</th><th>solLum</th><th>solLum</th><th></th><th></th></tr></thead>\n<thead><tr><th>int64</th><th>object</th><th>int64</th><th>int64</th><th>float64</th><th>float64</th><th>float64</th><th>float64</th><th>float64</th><th>float64</th><th>float64</th><th>float32</th><th>float64</th><th>float64</th><th>float64</th><th>float64</th><th>float32</th><th>float32</th><th>float32</th><th>float32</th><th>float32</th><th>float32</th><th>float32</th><th>float32</th><th>float32</th><th>float32</th><th>int32</th><th>int32</th><th>int32</th><th>int32</th><th>float32</th><th>float32</th><th>float64</th><th>float64</th><th>int16</th><th>bool</th><th>float32</th><th>float64</th><th>float64</th><th>float32</th><th>int16</th><th>int16</th><th>float32</th><th>int32</th><th>int16</th><th>bool</th><th>int32</th><th>float64</th><th>float64</th><th>float32</th><th>float32</th><th>int32</th><th>float64</th><th>float64</th><th>float32</th><th>float32</th><th>int32</th><th>float64</th><th>float64</th><th>float32</th><th>float32</th><th>float32</th><th>int16</th><th>float32</th><th>float32</th><th>float32</th><th>float64</th><th>float64</th><th>int32</th><th>float32</th><th>float32</th><th>float32</th><th>object</th><th>float64</th><th>float64</th><th>float64</th><th>float64</th><th>int64</th><th>float32</th><th>float32</th><th>float32</th><th>float32</th><th>float32</th><th>float32</th><th>float32</th><th>float32</th><th>float32</th><th>int64</th><th>float32</th><th>float32</th><th>float32</th><th>float32</th><th>float32</th><th>float32</th><th>object</th><th>object</th></tr></thead>\n<tr><td>1635721458409799680</td><td>Gaia DR2 4205572950572486656</td><td>4205572950572486656</td><td>0</td><td>2015.5</td><td>284.99739676167115</td><td>0.32021322712716477</td><td>-7.213793616274905</td><td>0.250721742560638</td><td>0.3368539525614086</td><td>0.2571070860175622</td><td>1.3101698</td><td>0.2710929173544655</td><td>0.6386887441973075</td><td>-0.8245084067543891</td><td>0.4678652748248424</td><td>0.4700719</td><td>0.42733705</td><td>-0.8003847</td><td>-0.48682573</td><td>0.019714236</td><td>-0.42549297</td><td>-0.69080716</td><td>-0.5605439</td><td>-0.04946403</td><td>0.54531914</td><td>97</td><td>0</td><td>97</td><td>0</td><td>0.80534214</td><td>102.64346</td><td>0.24166039386492902</td><td>0.2542542394472767</td><td>31</td><td>False</td><td>0.6448313</td><td>1.4974294542379536</td><td>0.054770738563812094</td><td>0.06562022</td><td>11</td><td>8</td><td>0.6980315</td><td>0</td><td>11</td><td>False</td><td>95</td><td>947.8486560009569</td><td>2.411390449458365</td><td>393.0714</td><td>18.24652</td><td>11</td><td>406.9520828279932</td><td>18.000334291644847</td><td>22.608028</td><td>18.82753</td><td>10</td><td>777.7130881135372</td><td>14.03050693560755</td><td>55.43015</td><td>17.534872</td><td>1.2498463</td><td>0</td><td>1.2926579</td><td>0.5810108</td><td>0.71164703</td><td>--</td><td>--</td><td>0</td><td>--</td><td>--</td><td>--</td><td>NOT_AVAILABLE</td><td>27.465051949212157</td><td>-5.174943757191669</td><td>285.4454044280279</td><td>15.42496849132661</td><td>--</td><td>--</td><td>--</td><td>--</td><td>--</td><td>--</td><td>--</td><td>--</td><td>--</td><td>--</td><td>--</td><td>--</td><td>--</td><td>--</td><td>--</td><td>--</td><td>--</td><td>https://gea.esac.esa.int?Gaia DR2 4205572950572486656</td><td></td></tr>\n</table></div>"},"metadata":{}}],"execution_count":9},{"id":"edd0fc30-e081-47d7-8519-34478f81602a","cell_type":"code","source":"","metadata":{"trusted":true},"outputs":[],"execution_count":null}]}