Discovery of brown dwarfs mining the 2MASS and SDSS databases#

F. Jiménez-Esteban¹, K. A. Lutz², E. Solano¹

  1. Spanish Virtual Observatory

  2. Université de Strasbourg, CNRS, Observatoire Astronomique de Strasbourg, UMR 7550, F-67000, Strasbourg, France

This tutorial is based on the EURO-VO tutorial of the same name: http://www.euro-vo.org/sites/default/files/documents/tutorial-brown-dwarfs_2019Apr.pdf .


Introduction#

Brown dwarfs are objects occupying the gap between the least massive stars and the most massive planets. They are intrinsically faint objects. Hence, heir detection is not straightforward and, in fact, was almost impossible until the advent of global surveys at deep optical and near-infrared bands like SDSS, 2MASS or DENIS. We propose here to mine the 2MASS point source catalogue (2MASS-PSC) and SDSS-DR9 databases to identify T-type brown dwarfs through an appropriate combination of colors in the optical and the infrared, an approach that perfectly fits into the Virtual Observatory.

In this use case, we explore different ways to do the same tasks with different VO tools. These tasks include:

  1. obtaining data from the SDSS and 2MASS catalogues in a given sky region,

  2. crossmatching the results of these searches,

  3. filtering the resulting table for brown dwarfs, and

  4. verifying our sample of brown dwarfs.

Software packages needed for this tutorial are Aladin, TOPCAT, STILTS and Python (or you may just use the Binder in your web browser).

# Standard Library
from pathlib import Path

# Astronomy tools
from astropy import units as u
from astropy.coordinates import SkyCoord

# Access astronomical databases
import pyvo
from astroquery.simbad import Simbad
from astroquery.vizier import Vizier
from astroquery.xmatch import XMatch

# Sky visualization
from ipyaladin import Aladin

Step #1: Discovery#

Vizier

We start by searching for the 2MASS point source catalogue (2MASS-PSC) and the SDSS data release 9 catalogue (SDSS DR9). To find and query catalogues, there are two packages we can use: pyVO and astroquery. We will show pyVO for searching the 2MASS-PSC and astroquery for SDSS DR9.

With the pyVo package we are using the TAP service of VizieR. TAP is a Virtual Observatory protocol to query databases of tables. The language we use to compile the query is called ADQL and is similar to SQL. For more details on ADQL see also the dedicated VO tutorial (http://docs.g-vo.org/adql-gaia/html/).

tap_vizier = pyvo.dal.TAPService("https://tapvizier.cds.unistra.fr/TAPVizieR/tap")

query = """
SELECT  * 
FROM tables
WHERE description LIKE '%2MASS%Cutri%'
"""

mass_psc_set = tap_vizier.search(query).to_table()
mass_psc_set["table_name", "description"]
Table length=13
table_namedescription
objectobject
J/ApJ/569/23/table1Optical polarimetry of 2MASS Red QSOs ( Smith P.S., Schmidt G.D., Hines D.C., Cutri R.M., Nelson B.O.)
II/281/2mass6x2MASS-6X catalog ( Cutri R.M., Skrutskie M.F., Van Dyk S., et al.)
J/ApJ/780/92/2mass2MASS JHKs photometry (table5) ( Szabo R., Ivezic Z., Kiss L.L., Kollath Z., Jones L., Sesar B., Becker A.C., Davenport J.R.A., Cutri R.M.)
II/246/out2MASS Point Source Catalogue, output (on a total of 470,992,970 sources) ( Cutri R.M., Skrutskie M.F., Van Dyk S., et al.)
J/ApJ/564/421/table32MASS IDR2 Sources Unconfirmed in Second Epoch Imaging ( Burgasser A.J., Kirkpatrick J.D., Brown M.E., Reid I.N., Burrows A., Liebert J., Matthews K., Gizis J.E., Dahn C.C., Monet D.G., Cutri R.M., Skrutskie M.F.)
VII/233/xsc*The 2MASS Extended Catalog (2MASX) ( Skrutskie M.F., Cutri R.M., Stiening R., et al.)
II/241/out2MASS Point Source Catalogue, 2MASS 2000 Second Incremental Release ( Skrutskie M.F., Schneider S.E., Stiening R., Strom S.E., Weinberg M.D., Beichman C., Chester T., Cutri R., Lonsdale C., Elias J., Elston R., Capps R., Carpenter J., Huchra J., Liebert J., Monet D., Price S., Seitzer P.)
J/ApJ/569/23/table3Galactic interstellar polarization detected in the fields of 2MASS AGNs ( Smith P.S., Schmidt G.D., Hines D.C., Cutri R.M., Nelson B.O.)
J/ApJ/569/23/table2Optical polarimetry of other AGN found by 2MASS ( Smith P.S., Schmidt G.D., Hines D.C., Cutri R.M., Nelson B.O.)
J/AJ/126/63/table12MASS sample and measurements ( Hutchings J.B., Maddox N., Cutri R.M., Nelson B.O.)
J/ApJS/190/100/table1List of 2MASS proper motion candidates ( Kirkpatrick J.D., Looper D.L., Burgasser A.J., Schurr S.D., Cutri R.M., Cushing M.C., Cruz K.L., Sweet A.C., Knapp G.R., Barman T.S., Bochanski J.J., Roellig T.L., McLean I.S., McGovern M.R., Rice E.L.)
J/ApJ/564/421/table5Comparison of NIRC Spectrophotometric colors to 2MASS photometry ( Burgasser A.J., Kirkpatrick J.D., Brown M.E., Reid I.N., Burrows A., Liebert J., Matthews K., Gizis J.E., Dahn C.C., Monet D.G., Cutri R.M., Skrutskie M.F.)
J/ApJ/564/421/table6New T Dwarfs Identified in the 2MASS Catalog ( Burgasser A.J., Kirkpatrick J.D., Brown M.E., Reid I.N., Burrows A., Liebert J., Matthews K., Gizis J.E., Dahn C.C., Monet D.G., Cutri R.M., Skrutskie M.F.)

As mentioned above we are interested in the 2MASS-pSC, which has the table_name II/246/out in VizieR. Before we move on to construct a more complicated query, we have a quick look at the 2MASS-PSC table and all the available columns. We do so by downloading the first 5 rows:

query = 'SELECT TOP 5 * FROM "II/246/out" '
mass_psc_head = tap_vizier.search(query).to_table()
mass_psc_head
Table length=5
RAJ2000DEJ2000errMajerrMinerrPA2MASSJmagJcmsige_JmagJsnrHmagHcmsige_HmagHsnrKmagKcmsige_KmagKsnrQflgRflgBflgCflgNdetproxpxPApxCntrXflgAflgCntrHemisDateScanGLONGLATXscanJDJpsfchiHpsfchiKpsfchiJstdape_JstdapHstdape_HstdapKstdape_KstdapedgeNSedgeEWedgedupuseoptDoptPAoptBmagRmagNoptextKeyscanKeycoaddKeycoadd
degdegarcsecarcsecdegmagmagmagmagmagmagmagmagmagarcsecdegdegdegarcsecdmagmagmagmagmagmagarcsecarcsecarcsecdegmagmag
float64float64float32float32int16objectfloat32float32float32float64float32float32float32float64float32float32float32float64objectobjectobjectobjectobjectfloat32int16int64int16int16int64str1objectint16float32float32float32float64float32float32float32float32float32float32float32float32float32int32int16objectint16int16str1float32int16float32float32int16int32int32int32int16
44.9960550.0055650.170.167602595905+000020016.3760.0970.09711.315.770.1390.148.215.2580.1410.1417.6ABB22211100006060644.52301290669337001290669325s1998-09-28112176.951-48.902-138.92451084.80620.751.211.1316.6510.22115.4340.13415.4780.434521114ne11U0.715617.916.91--6934715949599
45.0048570.0198060.060.069003000116+000111312.5290.0210.024389.811.9540.0290.03273.711.8740.0270.029172.5AAA2221110006666664.83301290669298001290669300s1998-09-28112176.945-48.885-170.62451084.80621.151.311.9712.5080.01911.910.02511.8520.00846982ne11U1.57215.013.81--6934715949599
45.0041930.0209560.060.069003000100+000115414.8450.0550.05646.214.2230.0770.07733.914.0160.0550.05524.0AAA222111ccc6666664.81501290669300001290669298s1998-09-28112176.943-48.885-168.22451084.80620.860.891.1113.8890.10113.0350.12612.970.04346584ne110--------0--6934715949599
44.9950740.0382040.380.31002595881+000217516.7460.1330.1348.015.8140.1390.147.816.1250.3240.3243.4BBD22211100006060670.21521290669298001290669276s1998-09-28112176.914-48.88-135.42451084.80621.220.840.6917.0470.41415.50.22917.5131.964403117ne010--------0--6934715949599
44.9638510.0435870.220.179502595132+000236916.4760.1120.11310.316.0570.1750.1756.315.564------BCU22011000006060089.42071290669295001290669271s1998-09-28112176.875-48.898-23.02451084.80621.131.07--17.1130.3418.7393.527----384229ne11U0.416118.717.71--6934715949599

As in the original tutorial, we only want to get data within a 14arcmin radius of RA=08h30m00s, Dec=01d30m00s. ADQL has a function, which allows to run an astronomical cone search query. From the quick inital inspection of the table we now know that we will need the columns RAJ2000 and DEJ2000 to only get sources at a certain location. Since we want to get colours for our Brown Dwarf candidates, we will also want to get the Jmag, Hmag and Kmag columns. For a different analysis you might want to choose other columns.

coord = SkyCoord(ra="08:30:00", dec="01:30:00", unit=(u.hourangle, u.deg))

query = """
SELECT * 
FROM \"II/246/out\" as tm_psc 
WHERE 1=CONTAINS(POINT(\'ICRS\', tm_psc.RAJ2000, tm_psc.DEJ2000),
                 CIRCLE(\'ICRS\', {:.3f}, {:.3f}, 14/60))
""".format(
    coord.ra.value,
    coord.dec.value,
)

mass_psc = tap_vizier.search(query).to_table()
mass_psc
Table length=683
RAJ2000DEJ2000errMajerrMinerrPA2MASSJmagJcmsige_JmagJsnrHmagHcmsige_HmagHsnrKmagKcmsige_KmagKsnrQflgRflgBflgCflgNdetproxpxPApxCntrXflgAflgCntrHemisDateScanGLONGLATXscanJDJpsfchiHpsfchiKpsfchiJstdape_JstdapHstdape_HstdapKstdape_KstdapedgeNSedgeEWedgedupuseoptDoptPAoptBmagRmagNoptextKeyscanKeycoaddKeycoadd
degdegarcsecarcsecdegmagmagmagmagmagmagmagmagmagarcsecdegdegdegarcsecdmagmagmagmagmagmagarcsecarcsecarcsecdegmagmag
float64float64float32float32int16objectfloat32float32float32float64float32float32float32float64float32float32float32float64objectobjectobjectobjectobjectfloat32int16int64int16int16int64str1objectint16float32float32float32float64float32float32float32float32float32float32float32float32float32int32int16objectint16int16str1float32int16float32float32int16int32int32int32int16
127.5091541.2691730.20.158708300219+011609015.9630.0950.09612.515.5460.1210.1229.014.930.1440.1448.1ABB22211100016060614.234080404058900804040599s2000-01-3058223.55422.408178.52451573.68150.891.010.9215.9390.23515.8990.31914.690.124458974sw010--------0--439561010984221
127.5077791.2728750.120.118608300186+011622315.5940.0830.08417.615.5630.1170.1178.915.2720.1810.1825.9ABC22211100036060614.216080404059900804040589s2000-01-3058223.5522.408183.42451573.68141.640.821.4715.4320.15315.810.42414.9920.114460269sw01U0.227017.116.51--439561010984221
127.5141671.2774950.230.215108300340+011638916.5530.170.1717.316.1790.1940.1945.015.894------CCU22011000006060028.423480404058900804040577s2000-01-3058223.54922.416160.42451573.68140.691.58--16.3350.13918.0143.36----461992sw01U0.01318.017.31--439561010984221
127.4632511.2719030.070.07008295118+011618815.8440.0760.07714.015.110.0950.09613.515.0290.1380.1387.4AAB22211100026060641.016080401955900804019587s2000-01-3057223.52822.369-87.92451573.67391.780.81.1415.9350.23815.0770.16415.1970.4384593164se01U1.028120.018.41--43955101094756
127.4630231.28640.060.06008295112+011711014.0930.0290.03270.013.6520.0330.03551.713.5530.0420.04328.9AAA22211100066663552.217980401958700804019616s2000-01-3057223.51422.376-87.02451573.6740.750.970.9114.0770.02313.5760.0513.6920.144646165se01U0.416016.314.61--43955101094756
127.484651.2711920.060.06008295631+011616213.8480.0260.02987.813.1770.020.02280.012.9320.0230.02451.1AAA22211100066665515.71280401960000804019585s2000-01-3057223.5422.387-164.92451573.67390.880.870.9513.8130.04213.1430.05113.0090.056459187se01U0.224418.816.71--43955101094756
127.4855651.2754560.20.17408295653+011631616.260.1120.1129.515.9080.1720.1726.515.2640.1840.1846.0BCC22211100016060615.719280401958500804019600s2000-01-3057223.53622.39-168.22451573.6740.841.30.816.1250.29115.5290.25315.210.246460684se01U0.423218.117.41--43955101094756
127.4943391.2807340.150.1514508295864+011650616.3170.1190.129.015.8180.1410.1417.015.099------BBU22011000006060036.923980401960000804019605s2000-01-3057223.53622.4-199.82451573.6740.961.62--16.2640.08816.2190.553----462552se110--------0--43955101094756
127.4946451.2962040.070.071708295871+011746315.250.050.05124.115.0620.0770.07814.114.870.1140.1148.6AAB22211100066050647.129980401965200804019639s2000-01-3057223.52122.408-200.92451573.6740.980.891.0115.1780.06415.1950.30214.7790.326468151se11U0.418516.816.11--43955101094756
127.4832471.3026280.060.06008295597+011809413.4840.0250.027122.712.8620.020.022106.912.8070.0330.03457.4AAA22211100066555527.931480401966700804019652s2000-01-3057223.50922.401-159.82451573.6741.060.71.113.4570.02712.8750.0612.7770.069470492se01U2.019516.314.51--43955101094756
127.408521.2860660.060.06008293804+011709813.9360.0310.03380.913.2960.0320.03371.713.1170.0290.0343.1AAA22211100066666625.95780401962400804019615s2000-01-3057223.48622.328109.12451573.6741.010.951.113.9270.0313.2410.04513.1220.0594645144sw01U0.623417.215.71--43955101094756
127.4145461.2899930.060.06008293949+011723914.6660.0320.03441.314.2640.0430.04429.414.2230.0650.06615.6AAA22211100066461623.61380401964000804019624s2000-01-3057223.48522.33587.42451573.6741.40.771.1514.7290.0414.3890.11814.4180.2254659165sw01U0.420516.315.31--43955101094756
127.3980361.2998180.210.188608293552+011759316.0060.0910.09212.015.5140.1240.1249.315.2030.1450.1456.3ABC22211100006160645.2180401967500804019645s2000-01-3057223.46722.325146.92451573.6740.761.571.0816.1740.09315.0850.29115.6870.3764695106sw01U0.825518.017.11--43955101094756
127.4777151.3080560.060.06008295465+011829014.5690.0330.03645.213.9690.0380.03938.613.6780.0450.04525.7AAA22211100045665627.913480401965200804019667s2000-01-3057223.50122.399-139.92451573.6741.111.151.3913.2781.85213.9860.06313.7920.1174723112se01U1.822419.717.41--43955101094756
127.468311.310750.120.11908295239+011838716.0620.0910.09211.415.2930.0930.09411.415.237------AAU2201100000606006.934680401967600804019672s2000-01-3057223.49422.392-106.12451573.6741.381.13--16.0910.21415.4970.178----4733146se01U0.425418.017.01--43955101094756
127.4678571.31260.140.138808295228+011845316.2720.1060.1079.415.3350.1230.12311.015.210.170.1716.3BBC2221110000606066.916680401967200804019676s2000-01-3057223.49222.393-104.42451573.6741.140.940.9716.2250.16215.2190.15715.680.6544740148se01U0.523419.217.91--43955101094756
127.4599551.3212780.070.071708295038+011916615.2540.0580.05924.015.0650.0850.08614.114.920.1270.1288.2AAB22211100066060642.213880401967600804019689s2000-01-3057223.47922.39-76.02451573.6741.181.231.015.1080.09915.0930.20814.9560.1864771176se01U0.521616.916.21--43955101094756
127.4160131.2963850.060.061708293984+011746914.6670.0390.04141.314.2850.0540.05528.814.2260.0820.08215.5AAA22211100066460517.631680401964600804019640s2000-01-3057223.4822.33982.22451573.6741.081.171.0214.7220.02814.2940.10714.3310.1334682171sw01U0.225916.315.31--43955101094756
127.4295051.3004630.080.08008294308+011801615.4820.0580.05919.514.9720.0620.06215.315.060.1260.1277.2AAB22211100036060550.725380401964000804019647s2000-01-3057223.48322.35333.62451573.6741.041.091.1215.5220.12215.2220.12215.1770.34697219sw01U0.622417.616.41--43955101094756
127.4126291.2999270.070.06408293903+011759715.4830.060.06119.514.8480.0770.07817.214.620.10.110.8AAA22211100036261617.613680401964000804019646s2000-01-3057223.47522.33894.32451573.6740.81.081.0415.3820.0914.7120.17514.5080.2464695158sw010--------0--43955101094756
127.4227841.3155960.080.0816308294146+011856115.9310.0860.08712.915.3240.0940.09511.115.5870.2260.2264.4AAD22211100006060624.832280401968800804019682s2000-01-3057223.46522.35557.82451573.6741.240.911.0316.1910.17115.9080.38816.0120.5234751195sw01U0.421817.816.81--43955101094756
127.4185381.3210240.070.07008294044+011915615.2650.0560.05723.814.870.0820.08216.814.7470.1060.1069.6AAB22211100056161621.034680401969800804019688s2000-01-3057223.45822.35473.12451573.6741.060.70.6615.1560.1114.760.11214.4770.174771180sw01U0.520516.916.11--43955101094756
127.4446011.3207080.080.081708294670+011914515.470.0590.0619.714.8840.080.0816.615.1770.1640.1646.5AAC22211100036050555.335780401972100804019686s2000-01-3057223.47222.376-20.72451573.6740.881.090.9715.460.15514.8970.17215.4950.2894769231se01U1.316817.116.01--43955101094756
127.4438331.3360410.080.081708294651+012009715.7390.0770.07815.414.990.090.0915.115.1150.1430.1436.9AAC22211100026061645.933480401974800804019721s2000-01-3057223.45722.383-18.02451573.6740.670.721.6215.6640.13414.9350.11415.210.5374825234se01U0.315919.617.91--43955101094756
127.5511241.2741910.20.193208301226+011627016.5230.1380.1397.515.9780.1780.1786.115.626------BCU22011000006060053.113280404061200804040583s2000-01-3058223.57222.44727.42451573.68140.861.1--17.2530.52815.720.401----4606225sw01U0.520518.217.31--439561010984221
127.5625241.2844660.240.231508301500+011704016.7380.1670.1676.115.5130.1360.1369.315.4870.2540.2544.9CBD22211100006060655.222880404058300804040560s2000-01-3058223.56822.462-13.62451573.68140.980.80.9716.3590.22515.2460.21615.2220.4574643238se01U0.331719.418.01--439561010984221
127.6310181.3130590.090.069008303144+011847012.950.0250.027193.812.4530.0220.024145.512.3670.0210.02386.0AAA22211100055666623.230880404628400804046275s2000-01-3059223.57722.536173.52451573.68370.870.731.1412.9570.00912.4820.03612.4160.03474379sw01U0.421615.513.91--43957101099356
127.6082731.3052590.070.069008302598+011818914.880.0350.03733.914.50.0480.04923.714.4040.0790.0813.2AAA22211100066360650.433580404049000804040515s2000-01-3058223.57222.512-178.32451573.68140.911.270.7714.8090.07514.4670.12514.5530.117471874se01U0.220816.615.71--439561010983209
127.6022831.3179230.070.069008302454+011904512.9830.0230.026194.612.6790.0210.023126.612.6770.0240.02664.7AAA22211100s66556647.11480404046300804040490s2000-01-3058223.55722.513-156.72451573.68140.860.681.0212.9650.02412.7260.05912.7120.033476395se01U0.225714.813.81--439561010983209
127.6259641.3170530.10.078908303023+011901315.0320.0530.05528.514.6670.0580.05818.914.7470.1140.1159.6AAB22211100066260623.212880404627500804046284s2000-01-3059223.5722.533191.72451573.68370.811.051.0615.0070.05114.6720.11814.6010.18475861sw11U0.522216.515.81--43957101099356
127.6328681.3200280.090.069008303188+011912114.0890.0310.03367.913.450.0270.02958.113.1640.0370.03841.3AAA22211100066666626.019580404627500804046292s2000-01-3059223.57122.541166.92451573.68370.961.061.1614.0810.02513.4360.05113.1360.074476886sw01U0.228518.816.81--43957101099356
127.6055261.3305980.080.078308302532+011950115.3850.0470.04921.314.7110.0690.06919.514.7380.1260.1279.7AAB22211100046361647.119480404049000804040463s2000-01-3058223.54722.522-168.42451573.68140.890.841.0715.4850.11314.6270.08314.6930.39480984se01U0.914619.818.21--439561010983209
127.6292591.3336580.130.1310908303102+012001115.9360.0960.09712.415.5010.1090.1098.815.3140.1860.1865.7ABC22211100006060611.01180404632400804046318s2000-01-3059223.55622.544179.82451573.68371.10.821.0615.8040.18415.7830.33115.4660.36481773sw01U0.317417.616.61--43957101099356
127.6478941.3472750.080.068808303549+012050113.560.0260.029110.513.1490.0290.0376.613.0620.0340.03545.4AAA22211100066665529.26680404636600804046354s2000-01-3059223.55322.567112.82451573.68370.940.730.9713.5740.03713.1490.06413.0270.0444866140sw01U0.427015.514.41--43957101099356
127.6298561.3366590.090.078808303116+012011915.6240.0750.07616.515.1160.0780.07812.514.8450.1240.1248.8AAB22211100036060611.019180404631800804046324s2000-01-3059223.55422.546177.72451573.68370.681.111.4215.5360.11315.2480.15815.1160.077482875sw01U0.025717.616.71--43957101099356
127.6411341.3541780.080.069008303387+012115014.4490.0350.03748.713.8440.0240.02640.413.4950.0450.04530.4AAA22211100066666627.634380404639000804046376s2000-01-3059223.54322.564137.12451573.68371.071.290.9714.4230.03213.8640.0713.5290.064891116sw01U1.226418.916.81--43957101099468
127.6593721.3449640.10.089008303824+012041815.7220.0690.0715.115.190.0980.09911.715.1910.1690.1696.4AAC22211100016060624.732480404636600804046346s2000-01-3059223.56122.57671.52451573.68371.170.971.1115.7070.1215.0870.09815.2750.3374858181sw01U0.319017.616.51--43957101099356
127.6658861.3496350.080.069008303981+01205869.3680.0230.0265250.98.80.0630.0654206.48.7610.0190.0212382.4AAA21211100044666628.923480404634600804046361s2000-01-3059223.5622.58448.02451573.68370.750.740.69.3620.018.880.058.7450.0124875205sw01T0.32411.6210.832--43957101099468
....................................................................................................................................................................................
127.6303581.6597140.070.068308303128+013934914.0020.0330.03673.613.7840.0420.04342.713.7090.0490.0525.0AAA22211100066666612.5980404707700804047071s2000-01-3059223.24822.703175.92451573.68391.090.731.1213.9650.0213.7620.03113.7340.082599177sw01U0.221015.114.51--43957101099580
127.6308771.6631420.130.1117908303141+013947315.9030.0970.09812.815.5140.1240.1258.715.560.220.224.5ABD22211100006060612.518980404707100804047077s2000-01-3059223.24522.705174.02451573.68390.941.081.4115.6650.09815.5090.14115.80.593600479sw01U0.814317.316.71--43957101099580
127.6085031.6577050.060.069008302604+013927713.4080.0230.026131.612.9120.0260.027102.112.7560.030.03160.1AAA22211100066666656.430980403968100804039702s2000-01-3058223.23822.682-179.12451573.68121.111.01.0313.3920.01912.8910.04212.7230.036598673se01U0.122415.914.41--439561010982198
127.617931.6703630.060.069008302830+014013312.3310.0210.024354.811.8520.0210.023271.111.7760.0220.024148.3AAA22211100066556648.79780404708700804039676s2000-01-3058223.23122.697-213.02451573.68120.970.850.8712.3250.01511.8630.05211.7950.02603239se11U1.019714.713.21--439561010982198
127.6313771.6688060.060.069008303153+014007714.4170.0370.03950.214.0780.0480.04932.614.0410.0590.05918.4AAA22211100066663620.518580404707700804047087s2000-01-3059223.23922.708172.22451573.68390.890.691.0714.3560.02714.0770.05414.0320.1602480sw01U0.132015.915.11--43957101099580
127.596341.6675810.110.114508302312+014003215.9320.0790.0812.915.5640.1290.1298.915.4940.2070.2074.8ABD22211100026060556.412980403970200804039681s2000-01-3058223.22222.677-135.32451573.68121.420.890.9915.8560.15215.7130.13915.2560.5936022117se01U0.423117.216.61--439561010982198
127.6074121.6802640.070.074508302577+014048915.1870.0450.04725.614.7680.0520.05218.514.6350.1050.10510.7AAA22211100046260619.334180403963900804039656s2000-01-3058223.21622.692-175.12451573.68110.840.990.6615.2670.08314.9390.13914.2720.074606877se01U0.419617.216.21--439561010982198
127.6056751.6853280.070.06408302536+014107115.2080.040.04225.114.6140.050.05121.314.5290.0820.08311.7AAA22211100056261519.316180403965600804039639s2000-01-3058223.2122.693-168.92451573.68111.230.930.615.2380.07414.7430.12414.3940.152608683se01U1.020117.016.11--439561010982198
127.595571.6939480.240.211408302293+014138216.4510.1440.1448.015.8410.1660.1666.915.4030.2210.2215.3BCD22211100016050647.813080403963900804039617s2000-01-3058223.19722.689-132.52451573.68111.161.110.9816.0660.315.2710.19114.6730.146117120se01U0.530618.516.91--439561010982198
127.6124031.6840110.070.068608302697+014102414.8260.0490.0535.714.370.0710.07226.714.4210.090.0913.0AAA2221110006655263.435580404712400804039648s2000-01-3058223.21522.699-193.12451573.68114.162.342.1214.5850.04214.0510.05413.8640.142608159se11U1.118116.115.01--439561010982198
127.6260441.6879860.060.067308303025+014116714.1010.0320.03467.213.8120.0360.03741.613.7890.0510.05123.2AAA22211100066665649.81980404715900804047134s2000-01-3059223.21822.712191.42451573.6840.841.041.0514.1550.02213.9250.08913.7960.148609361sw01U0.118815.914.91--43957101099580
127.6123211.6849470.110.1112508302695+014105814.733------15.0550.0860.08713.214.616------UAU0200100c00056003.417580403964800804047124s2000-01-3059223.21422.699240.82451573.684--0.93------14.1880.073----608212sw00U2.335216.115.01--43957101099580
127.5807611.7013350.060.064508301938+014204814.6310.0360.03842.714.2080.0440.04531.014.0560.0660.06718.2AAA22211100066664656.62280403956600804039599s2000-01-3058223.18222.679-79.22451573.68110.830.970.9414.5940.0614.1520.07413.9850.2096144173se01U0.427516.415.41--439561010982198
127.5593041.6966630.140.13808301423+014147916.0430.0770.07811.615.4930.1210.1229.515.2010.1620.1626.3ABC22211100006060658.018480403965500804039606s2000-01-3058223.17522.658-2.02451573.68110.980.811.3316.3210.22415.3720.18615.020.2416127250se01U0.327020.218.81--439561010982198
127.5946931.7120730.060.069008302272+014243415.060.0360.03828.714.420.0550.05625.514.2190.0660.06715.6AAA22211100066260531.629580403956600804039577s2000-01-3058223.17922.697-129.42451573.68111.021.120.8515.0630.05914.5030.16814.7310.3176182123se01U0.213217.916.41--439561010982198
127.5867721.7158490.070.074508302082+014257015.7230.0660.06715.614.9730.060.0615.314.8120.120.129.1AAB22211100036060528.2080403955200804039566s2000-01-3058223.17122.691-100.92451573.68111.080.961.1115.7050.18115.2110.1614.6640.1196196151se010--------0--439561010982198
127.4471921.6475330.240.198108294732+013851116.5290.1480.1497.416.0280.1950.1955.815.1040.1760.1766.9BCC22211100006050615.912980402042400804020436s2000-01-3057223.16322.536-30.12451573.67421.120.980.8615.8610.06215.1480.20414.5260.2245946222se01U0.722019.018.01--43955101094980
127.4339531.6557580.130.1117608294414+013920716.0650.0950.09611.415.50.1130.1139.415.3840.1830.1835.3ABC22211100006160617.834980402046800804020450s2000-01-3057223.14922.52917.62451573.67421.721.150.9816.6680.2415.5890.42917.985.0255976235sw01U0.419917.817.21--43955101094980
127.4329861.6606080.060.06008294391+013938113.0030.0180.022191.112.4780.0270.029152.312.4180.0270.02982.1AAA22211100066665517.816980402045000804020468s2000-01-3057223.14422.5321.02451573.67420.850.921.1113.0210.02512.4710.06212.4130.0535993232sw01U0.426115.514.31--43955101094980
127.4406031.6670360.060.061708294574+014001312.7160.0310.033248.912.1250.0380.039210.811.8890.0270.029133.6AAA22211100066665535.923080402046800804020477s2000-01-3057223.14222.54-6.42451573.67422.542.873.0312.5720.0111.9180.0411.7870.0326016246se01U0.522116.114.01--43955101094980
127.4490761.6815830.060.06008294777+014053614.8790.0320.03534.014.2190.050.05130.614.1080.0590.0617.3AAA22211100066660660.621080402047700804020514s2000-01-3057223.13222.554-36.92451573.67420.860.70.8514.9270.0514.1970.06314.2620.0976068215se01U0.433418.416.61--43955101094980
127.4290171.6814210.070.071708294296+014053115.0910.0550.05727.914.8060.0670.06717.814.780.1160.1179.3AAB22211100066050644.134780402052900804020512s2000-01-3057223.12222.53735.32451573.67420.770.840.9715.0290.02914.7280.08514.7070.2176068217sw01U0.428516.615.81--43955101094980
127.4262131.6933380.280.276308294229+014136016.7250.1790.1796.215.8430.1540.1546.915.570.2290.2294.5CCD222111c0005060625.61680402054000804020529s2000-01-3057223.10922.5445.42451573.67430.961.01.1116.7190.415.8820.41615.4310.4146111207sw01U0.619619.418.01--43955101094980
127.4281331.7001770.060.06008294275+01420069.7910.0210.0243681.59.5050.0240.0262354.69.4580.0190.0211253.8AAA22211100066666625.619680402052900804020540s2000-01-3057223.10422.54538.52451573.67430.741.050.879.7790.0099.50.0349.4510.026136214sw01T0.15211.4810.791--43955101094980
127.4491641.7080550.060.061708294779+014228914.4570.0350.03750.114.0070.0310.03237.313.9230.060.06120.5AAA22211100066665648.41280402058800804020559s2000-01-3057223.10722.567-37.22451573.67431.090.911.2314.4480.05914.0610.08113.8870.1026164215se01U0.324816.815.41--43955101094980
127.4924061.6851150.310.37008295817+014106416.2370.1060.1069.715.6470.1360.1368.215.6830.2390.2394.1BBD22211100016060624.319480402050900804020518s2000-01-3057223.15122.594-192.82451573.67431.090.751.0316.0860.1615.5140.19115.6390.359608159se110--------0--43955101094980
127.5031051.7009050.060.069008300074+014203214.5710.0390.04145.114.2180.0310.03230.714.1040.0640.06517.4AAA22211100066560624.135380403958300804039600s2000-01-3058223.14222.611200.22451573.68111.340.990.8714.5430.02714.2870.15314.2970.141614353sw11U0.526816.215.21--439561010982198
127.4773041.6978120.230.234208295455+014152116.6850.1540.1556.415.9420.160.1616.315.420.220.225.2CCD22211100006060621.529180402053900804020536s2000-01-3057223.13122.587-138.52451573.67430.90.941.016.4550.26216.2520.61215.2160.4836127114se01U0.315519.118.11--43955101094980
127.4717491.6999810.150.1514508295321+014159916.2780.120.1219.415.6460.1380.1388.215.792------BBU22011000006060021.511180402053600804020539s2000-01-3057223.12722.583-118.52451573.67430.820.93--16.1580.1215.6660.136----6134134se01U0.517818.217.11--43955101094980
127.4854721.7016310.070.071708295651+014205815.2860.0470.04923.314.8050.0690.06917.914.590.1020.10211.1AAA22211100036150632.424580402053600804020544s2000-01-3057223.13222.596-167.82451573.67431.031.11.0215.410.10714.790.12714.3310.225614084se01U0.522717.916.61--43955101094980
127.502331.7075680.060.069008300055+014227213.4420.0230.026127.512.8370.0240.026109.412.6520.0290.0366.2AAA22211100066665524.117380403960000804039583s2000-01-3058223.13522.614203.02451573.68111.130.791.513.4830.01812.9130.02912.710.045616750sw11U1.126217.215.11--439561010982198
127.4694231.713720.120.1110108295266+014249316.1240.0970.09810.815.4080.1010.10210.315.340.1860.1865.6AAC22211100006060650.217080402053900804020569s2000-01-3057223.11222.588-110.12451573.67430.990.990.9316.2560.26915.9290.34715.5740.3286184142se010--------0--43955101094980
127.4519481.7212050.060.06008294846+014316312.4590.0190.023315.412.0560.0240.026224.711.9690.0230.024124.1AAA22211100066666648.419280402055900804020588s2000-01-3057223.09622.576-47.22451573.67430.740.740.8612.470.01912.0380.04611.9730.0296211205se01U1.317614.813.51--43955101094980
127.3954741.697110.340.328808293491+014149516.5510.1640.1647.315.9070.2070.2076.515.7950.2740.2753.7CED22211100006050653.733880402056600804020535s2000-01-3057223.08922.515156.02451573.67430.8510.930.7216.4610.21616.10.26816.1460.828612597sw010--------0--43955101094980
127.4322921.7171160.070.069608294375+014301614.5690.0320.03545.214.2990.0550.05628.514.2190.0840.08415.6AAA22211100066561422.81480402059300804020581s2000-01-3057223.0922.55723.52451573.67430.91.150.6514.5520.0514.1720.08614.2250.2296197229sw01U0.319816.415.31--43955101094980
127.4338571.7232630.070.071708294412+014323715.6780.080.08116.315.2070.1050.10512.314.9650.1380.1387.9AAB222111ccc6656164.531780402059600804020593s2000-01-3057223.08522.56117.92451573.67431.140.831.2214.5170.09714.0720.11214.1790.1446219235sw01U4.013915.814.41--43955101094980
127.5319021.7297570.060.069008300765+014347114.1550.0330.03666.113.840.0320.03343.413.8060.0480.04922.9AAA22211100066664614.18280403953900804039541s2000-01-3058223.1322.6596.62451573.68111.030.881.0114.1360.05113.9720.04813.850.1186247156sw01U0.223015.815.01--439561010982198
127.535771.7302930.370.354508300858+014349017.0470.2310.2314.616.1230.190.195.315.8720.3020.3033.4DCD22211100006060514.126280403954100804039539s2000-01-3058223.13122.65482.72451573.68110.950.740.9816.5370.39917.5291.51516.040.7056249170sw010--------0--439561010982198

Now that we have all the data we want from the 2MASS-PSC, we move on to query SDSS DR9 with astroquery. First we want to find out which tables are available:

catalog_list_sdss = Vizier.find_catalogs("SDSS DR9")
for catalog_ID, catalog in catalog_list_sdss.items():
    print(catalog_ID, ": ", catalog.description)
II/294 :  The SDSS Photometric Catalog, Release 7 (Adelman-McCarthy+, 2009)
V/139 :  The SDSS Photometric Catalog, Release 9 (Adelman-McCarthy+, 2012)
V/147 :  The SDSS Photometric Catalogue, Release 12 (Alam+, 2015)
V/154 :  Sloan Digital Sky Surveys (SDSS), Release 16 (DR16) (Ahumada+, 2020)
VII/289 :  SDSS quasar catalog, sixteenth data release (DR16Q) (Lyke+, 2020)
J/other/NewA/58.61 :  SDSS DR9 galaxy clusters optical catalog (Banerjee+, 2018)

We want to get data from the catalogue called V/139. As before let’s have a look at a few rows (per default Vizier.get_catalogs gives you 50 rows) of the code to figure out, which ones are most interesting for us.

test_sdss = Vizier.get_catalogs("V/139")
print(test_sdss)
test_sdss[0]
TableList with 1 tables:
	'0:V/139/sdss9' with 21 column(s) and 50 row(s) 
Table length=50
modeq_modeclSDSS9m_SDSS9ImRA_ICRSDE_ICRSObsDateQumage_umaggmage_gmagrmage_rmagimage_imagzmage_zmagzsp
degdegyrmagmagmagmagmagmagmagmagmagmag
uint8str1uint8str19str1str2float64float64float64uint8float32float32float32float32float32float32float32float32float32float32float64
26J025955.29+000252.0*Im44.9803860.0477792003.8093323.4500.58022.3450.10121.9480.10422.0440.16321.4740.404--
23J025956.07+000300.0*Im44.9836490.0500161998.8264324.4321.37424.2660.62722.8590.31421.2400.11921.0320.430--
23J025956.06+000259.9*Im44.9836190.0499952002.7581325.9640.60124.0820.48923.2500.41521.6660.14620.3460.189--
23J025956.06+000259.7*Im44.9836180.0499402003.7384325.5930.78324.3450.56722.3580.17421.1240.08420.9420.310--
23J025956.06+000259.9*Im44.9836160.0499762001.7179323.0970.81823.9540.72121.8390.18820.8270.10220.1390.238--
23J025956.06+000259.9*Im44.9836140.0499842007.8858325.5341.70524.4581.28223.1560.45121.5220.11920.8110.229--
23J025956.06+000259.9*Im44.9836070.0499852002.8508324.4031.15223.3700.27322.7220.26121.4450.14820.5300.285--
23J025956.06+000259.9*Im44.9836060.0499811998.7254323.4210.46224.4300.47222.8500.20621.5120.09121.0220.241--
26J025956.06+000300.0*Im44.9835960.0500262003.9076325.9920.68624.3750.76222.5270.22521.5200.12020.6650.249--
23J025956.06+000259.9*Im44.9835830.0499912001.7233322.4700.57623.2870.48821.9950.23720.8190.13320.6800.520--
23J025956.05+000300.0Im44.9835740.0500032002.6788124.2481.59723.6790.57622.1310.21421.0020.11719.7690.180--
23J025956.07+000259.8Im44.9836310.0499511998.8728322.8511.27123.0040.76021.4240.33319.9890.15420.5571.139--
23J025956.05+000259.9Im44.9835670.0499942000.7542326.5990.56626.1330.80922.7080.38720.9900.11820.6770.397--
23J025956.07+000300.0*Im44.9836610.0500181998.8837324.8450.90824.6430.62422.7910.27221.2070.10720.9940.393--
23J025956.07+000259.9*Im44.9836520.0499942002.7774326.0150.70725.2600.79922.6720.27520.9490.09520.7890.371--
23J025956.07+000259.9*Im44.9836490.0499922008.0006323.0190.49423.9630.52622.7860.25721.6180.14520.9310.231--
26J025956.06+000259.7*Im44.9836230.0499372002.0373324.6240.99725.2910.60422.5080.18221.6230.10921.0720.273--
13J025956.07+000259.9Im44.9836380.0499732003.8857323.5640.81123.8900.53623.0390.37221.2790.11820.3310.230--
23J025956.06+000300.0*Im44.9836220.0499992002.8318325.8950.69023.5760.35422.4660.20921.4050.12220.1300.177--
23J025956.09+000300.0Im44.9837330.0500181998.7336326.7010.94623.0910.65821.0530.17020.4150.13219.4970.251--
23J025956.09+000300.1Im44.9837110.0500452003.7410325.4461.16224.2250.59022.7020.23821.6740.15421.0030.359--
23J025956.08+000259.6Im44.9836940.0498902000.9068325.1611.33523.9390.63022.9610.42321.2130.13620.6620.383--
23J025956.08+000259.9Im44.9836870.0499902004.9478323.9811.10125.0690.76622.9890.39921.5840.17520.7050.336--
23J025956.08+000300.0Im44.9836670.0500262001.8653325.6340.82524.1380.51522.8420.29121.3180.11420.7150.257--
23J025956.08+000259.8Im44.9836670.0499712003.8093323.9711.17025.4870.82522.4560.24721.1320.11321.0160.427--
23J025953.60+000241.7Im44.9733630.0449221998.8264324.0761.15823.3910.31121.8700.12421.5250.14020.8920.350--
26J025953.60+000241.9*Im44.9733710.0449962003.7410323.3480.85223.2110.27321.9870.12821.4090.12222.3440.904--
23J025953.58+000241.9*Im44.9732580.0449871998.8728323.2270.76023.0600.34122.1100.25021.1190.17620.9710.654--
23J025953.57+000242.1Im44.9732220.0450391998.7336326.0370.86622.7550.24921.5500.14021.0560.12222.7751.313--
23J025953.57+000241.9Im44.9732210.0449722002.8508323.7300.84923.5880.32022.1210.15721.6990.18420.8640.377--
23J025953.56+000242.1Im44.9731810.0450272002.0373325.8130.71924.3070.58221.7650.12021.5360.13021.0340.346--
23J025953.60+000241.9*Im44.9733390.0449912002.7581323.4980.72623.9700.45921.7020.11021.6520.14421.4050.461--
23J025953.58+000241.7Im44.9732640.0449362000.9068324.8131.21723.5400.37522.1090.15821.4090.13321.0360.422--
23J025953.58+000242.1Im44.9732630.0450292002.6788125.3150.96823.7940.44521.9440.12721.2920.10220.8310.313--
23J025953.58+000242.0Im44.9732630.0450011998.7254324.2400.67823.6580.26522.3100.11821.6100.09221.4370.307--
23J025953.58+000241.8*Im44.9732600.0449442001.7233324.9901.65824.0890.74121.5750.13321.2160.15320.4210.332--
23J025953.58+000241.9*Im44.9732540.0449782003.7384324.2590.96823.5270.29021.9980.11621.4170.09920.9530.281--
23J025953.59+000241.9*Im44.9733250.0449732000.7542323.2140.70624.0150.58922.1290.17721.4350.13521.3570.524--
23J025953.59+000241.8Im44.9733190.0449642002.7774324.2881.27323.0570.23921.6350.11021.1600.11920.6460.316--
23J025953.59+000242.1Im44.9733190.0450372004.9478324.7011.30123.5950.36622.0020.17321.6400.18620.8810.397--
23J025953.59+000242.0Im44.9733160.0450012008.0006325.3460.92924.3080.65822.1730.15521.5770.14520.7210.197--
23J025953.59+000241.9*Im44.9733040.0449762002.8318325.5380.71323.7130.31422.1730.12821.5000.10421.0930.306--
23J025953.60+000242.0Im44.9733500.0450042007.8858322.1520.53223.8010.93922.1740.22021.5270.13521.1100.331--
23J025953.59+000241.9*Im44.9732940.0449972003.9076325.2011.36422.8890.28221.8430.15121.1680.10821.2480.493--
23J025953.59+000241.9*Im44.9732910.0449811998.8837322.8880.40023.1200.24021.7580.12421.3150.13621.4430.637--
23J025953.58+000241.8*Im44.9732860.0449462001.7179323.6540.89223.5920.38922.2940.20121.4240.12122.1250.781--
1+3J025953.58+000241.9Im44.9732840.0449732003.8857323.5190.52923.6500.29822.1820.12321.5910.11221.8920.522--
23J025953.58+000241.9*Im44.9732740.0449922003.8093322.8610.44523.3910.29121.8860.12821.5640.13821.3150.452--
23J025953.58+000241.9*Im44.9732740.0449862001.8653324.4421.26323.4050.30721.9290.13721.1420.10021.1220.373--
23J025952.90+000248.4Im44.9704150.0467852002.8318326.3850.52224.0030.53822.3350.22122.7230.44421.6060.667--

Again we want to get the coordinates of the source as well as magnitudes at all five SDSS bands (u, g, r, i and z), and a classification (cl). Do restrict the query to returning these columns and to get more than 50 rows returned, we create a custom Vizier object and then use this object to again query within 14arcmin of RA=08h30m00s, Dec=01d30m00s.

custom_vizier = Vizier(
    row_limit=-1,
    columns=["RA_ICRS", "DE_ICRS", "umag", "gmag", "rmag", "imag", "zmag", "cl"],
)
coord = SkyCoord(ra="08:30:00", dec="01:30:00", unit=(u.hourangle, u.deg))
sdss_results = custom_vizier.query_region(coord, radius=14 * u.arcmin, catalog="V/139")
sdss_results
TableList with 1 tables:
	'0:V/139/sdss9' with 8 column(s) and 12405 row(s) 

So we have one table in the resulting lists of tables. It is called V/139/sdss9. Let’s have a look at it:

sdss_results[0]
Table length=12405
RA_ICRSDE_ICRSumaggmagrmagimagzmagcl
degdegmagmagmagmagmag
float64float64float32float32float32float32float32uint8
127.2673661.51293021.85319.73218.87018.56418.3796
127.2673721.51292822.25019.69718.85518.56818.3066
127.2673721.51292822.04719.75118.87918.54918.3836
127.2677271.49587322.87922.22321.49221.12220.8723
127.2677541.49593322.97222.43121.46521.16221.0093
127.2678311.50000523.81624.46222.47020.75420.0336
127.2678361.49594722.63822.05121.04520.62720.7853
127.2678531.49996124.52724.69022.38120.67020.0166
127.2679551.49993224.33224.99623.05620.64919.9766
127.2682141.50114719.21018.03417.57217.43517.4146
127.2682211.50114719.22618.01217.58417.42617.4006
127.2682231.50114019.18018.00317.57817.44017.4066
127.2690161.48644121.14620.25319.95819.84119.8416
127.2690201.48643721.18720.30019.95519.85619.9156
127.2690261.48642721.29920.26619.97119.84720.0426
127.2692481.52360725.29423.53621.92221.08620.6206
127.2692801.52356324.08823.38221.70021.11320.8026
127.2693091.52360023.67123.41321.45721.14820.7856
127.2695181.46569323.86523.47922.46622.40422.4026
127.2707831.52427824.99325.75125.50522.17322.5026
127.2708521.47793123.08121.06619.69519.08118.6846
127.2708551.47791723.26221.05219.70419.08418.7236
127.2708661.47793123.01520.97019.72119.09018.7416
127.2716271.50015024.19623.27722.29121.80722.8246
127.2716391.50017923.54423.35422.44122.31121.3126
127.2718291.50299224.08921.89920.57319.62219.0926
127.2718361.50300524.35522.03620.58119.61619.1096
127.2718521.50298724.80622.08620.55519.68719.0906
127.2720761.52458920.72218.23217.14916.76016.5473
127.2721021.52458320.48518.19917.15016.75316.4976
127.2721071.52457920.57418.20917.15116.73816.5036
127.2723511.51611222.08621.38020.92320.67420.9126
127.2723551.51612122.69521.32320.84320.56120.4676
127.2723721.51610022.18121.51920.88020.64720.3026
127.2724301.46762124.13124.41423.48322.01621.8796
127.2724651.46755524.39225.94225.43521.96921.1606
127.2724741.53165422.40725.29825.87324.44022.3886
127.2728321.53514123.05423.29422.87221.99021.2193
........................
127.7105181.45238825.77324.76623.87721.95623.4346
127.7105301.45240025.69524.27122.99621.55221.8913
127.7106411.40343420.67920.68418.76317.90727.5343
127.7108851.41848824.25323.79721.92720.80120.0363
127.7109261.41845324.73223.85622.64321.20520.8876
127.7116461.41993227.02223.51321.39220.78320.4443
127.7116471.42003324.99723.09321.28420.37120.0493
127.7118991.44201123.78424.84122.95622.46422.2396
127.7124011.43097323.86925.36722.62321.46020.6956
127.7125961.41199724.02221.64920.21019.35618.8806
127.7125981.41198124.72521.64620.26419.34918.9976
127.7127041.40703919.16825.08917.66918.27722.8333
127.7129621.40698816.41415.20216.35314.25814.6756
127.7129691.44062622.59622.83820.67719.75619.0593
127.7129821.40700515.75414.60414.25714.15014.0926
127.7132971.43710724.68323.41422.45821.79122.1723
127.7142021.43995923.82521.92320.91020.54820.5426
127.7146571.41031424.51523.16221.82821.77021.2086
127.7146701.44922524.60222.65022.37921.14320.4963
127.7146801.44916324.31523.41923.01521.13720.2336
127.7146861.44921226.24226.01422.41121.28820.6433
127.7147521.41032221.08620.85219.74519.50619.2413
127.7159501.44312725.84624.52322.17321.98723.0483
127.7162231.42576825.13222.71622.69522.42324.1913
127.7172281.43520621.45226.27421.37119.90718.8403
127.7178101.43029123.69323.10123.16222.64622.6096
127.7181941.44306625.65223.39922.61522.15523.6926
127.7193531.42475829.77331.29221.66416.91728.7983
127.7210861.45495225.20622.51821.18020.00319.2206
127.7210921.45494224.14122.40221.29919.98619.3886
127.7211061.45491525.32122.68821.17920.00119.1856
127.7211351.43342124.96523.10221.84821.40820.7906
127.7212941.42870423.00822.73122.15521.61022.7933
127.7217701.43171724.91422.57521.11320.43820.0196
127.7218571.45146922.93322.36521.47221.92320.8953
127.7225341.45552423.44223.37822.51822.91821.8663
127.7226351.43361224.81323.99422.45321.17320.7983
127.7226721.45576522.96125.75222.95022.00323.0706

Step #2: Cross-matching#

Xmatch

In this next step, we find common sources in the 2MASS-PSC and SDSS-DR9 catalogues. One simple way to do this using the CDS XMatch service, which can also be reached with astroquery. The most reliable way to quuery XMatch is by uploading one of the tables (which will also make sure we stay in our region of interest) and crossmatching it to a table available in VizieR.

mass_psc.write("Data/2MASS_PSC.vot", format="votable", overwrite=True)
sdss_results[0].write("Data/SDSS_DR9.vot", format="votable", overwrite=True)
sdss_mass = XMatch.query(
    cat1=Path("Data/2MASS_PSC.vot").open(),
    cat2="vizier:V/139/sdss9",
    max_distance=4 * u.arcsec,
    colRA1="RAJ2000",
    colDec1="DEJ2000",
)
sdss_mass
Table length=717
angDistRAJ2000DEJ2000errMajerrMinerrPA2MASSJmagJcmsige_JmagJsnrHmagHcmsige_HmagHsnrKmagKcmsige_KmagKsnrQflgRflgBflgCflgNdetproxpxPApxCntrXflgAflgCntrHemisDateScanGLONGLATXscanJDJpsfchiHpsfchiKpsfchiJstdape_JstdapHstdape_HstdapKstdape_KstdapedgeNSedgeEWedgedupuseoptDoptPAoptBmagRmagNoptextKeyscanKeycoaddKeycoaddSDSS9RAdegDEdegerrHalfMajerrHalfMinerrPosAngumaggmagrmagimagzmage_umage_gmage_rmage_image_zmagobjIDclq_modeflagsQObsDatepmRAe_pmRApmDEe_pmDESpObjIDzspe_zspf_zspspTypespClsubClass
float64float64float64float64float64int64str16float64float64float64float64float64float64float64float64float64float64float64float64str3int64int64str3int64float64int64int64int64int64int64str1str10int64float64float64float64float64float64float64float64float64float64float64float64float64float64int64int64str2int64int64str1float64int64float64float64int64int64int64int64int64str19float64float64float64float64int64float64float64float64float64float64float64float64float64float64float64int64int64int64str16int64float64int64int64int64int64int64int64int64int64int64int64int64
0.352101127.5091541.2691730.20.158708300219+011609015.9630.0950.09612.515.5460.1210.1229.014.930.1440.1448.1ABB22211100016060614.234080404058900804040599s2000-01-3058223.55422.408178.52451573.68150.891.010.9215.9390.23515.8990.31914.690.124458974sw010--------0--439561010984221J083002.21+011608.9127.5092481.2691460.010.0099023.71220.87619.40218.06817.3380.670.0340.0150.0090.015123765366471216390861000020101000011032000.9155-535-4350------------
0.152435127.5077791.2728750.120.118608300186+011622315.5940.0830.08417.615.5630.1170.1178.915.2720.1810.1825.9ABC22211100036060614.216080404059900804040589s2000-01-3058223.5522.408183.42451573.68141.640.821.4715.4320.15315.810.42414.9920.114460269sw01U0.227017.116.51--439561010984221J083001.86+011622.2127.5077491.2728450.0020.0029018.39417.21316.80616.67416.6230.0140.0040.0040.0050.01123765366471216335861000000101000000032000.9155-33230------------
0.217574127.5141671.2774950.230.215108300340+011638916.5530.170.1717.316.1790.1940.1945.015.894------CCU2201100006060028.423480404058900804040577s2000-01-3058223.54922.416160.42451573.68140.691.58--16.3350.13918.0143.36----461992sw01U0.01318.017.31--439561010984221J083003.39+011638.8127.5141291.2774480.0030.0039019.51318.18917.71417.55917.4850.0280.0060.0060.0070.016123765366471216374161000000101000000032000.915523130------------
0.048922127.4632511.2719030.070.07008295118+011618815.8440.0760.07714.015.110.0950.09613.515.0290.1380.1387.4AAB22211100026060641.016080401955900804019587s2000-01-3057223.52822.369-87.92451573.67391.780.81.1415.9350.23815.0770.16415.1970.4384593164se01U1.028120.018.41--43955101094756J082951.17+011618.8127.4632381.2719070.0050.0059021.97619.79418.38617.5417.0480.1760.0160.0080.0070.012123765366471209829061000000101000000032000.9155-194840------------
0.023156127.4630231.28640.060.06008295112+011711014.0930.0290.03270.013.6520.0330.03551.713.5530.0420.04328.9AAA22211100066663552.217980401958700804019616s2000-01-3057223.51422.376-87.02451573.6740.750.970.9114.0770.02313.5760.0513.6920.144646165se01U0.416016.314.61--43955101094756J082951.12+011711.0127.4630181.2863960.0010.0019017.22315.79615.25915.07414.9930.0080.0030.0030.0030.005123765366471209801561000020109002001032000.915553-530------------
0.102852127.484651.2711920.060.06008295631+011616213.8480.0260.02987.813.1770.020.02280.012.9320.0230.02451.1AAA22211100066665515.71280401960000804019585s2000-01-3057223.5422.387-164.92451573.67390.880.870.9513.8130.04213.1430.05113.0090.056459187se01U0.224418.816.71--43955101094756J082956.31+011616.3127.4846251.2712060.0020.0029021.01118.35916.95915.81415.1690.0810.0070.0040.0040.005123765366471209832461000000101000000032000.9155-33430------------
0.385255127.4855651.2754560.20.17408295653+011631616.260.1120.1129.515.9080.1720.1726.515.2640.1840.1846.0BCC22211100016060615.719280401958500804019600s2000-01-3057223.53622.39-168.22451573.6740.841.30.816.1250.29115.5290.25315.210.246460684se01U0.423218.117.41--43955101094756J082956.55+011631.7127.4856641.2754970.0030.0039020.24518.3417.58417.34317.1850.0460.0070.0050.0060.013123765366471209832861000000101000000032000.915553230------------
0.18744127.4943391.2807340.150.1514508295864+011650616.3170.1190.129.015.8180.1410.1417.015.099------BBU2201100006060036.923980401960000804019605s2000-01-3057223.53622.4-199.82451573.6740.961.62--16.2640.08816.2190.553----462552se110--------0--43955101094756J082958.64+011650.4127.4943411.2806820.0090.0089022.54520.67319.20218.18417.5860.2750.0290.0130.0090.017123765366471209841161000090101002000032000.915575-650------------
0.038231127.4946451.2962040.070.071708295871+011746315.250.050.05124.115.0620.0770.07814.114.870.1140.1148.6AAB22211100066050647.129980401965200804019639s2000-01-3057223.52122.408-200.92451573.6740.980.891.0115.1780.06415.1950.30214.7790.326468151se11U0.418516.816.11--43955101094756J082958.71+011746.3127.4946381.2962120.0020.0019017.96816.73716.30416.18216.1070.0120.0040.0040.0040.007123765366471209807561000020101002101032000.915513-630------------
0.125123127.4832471.3026280.060.06008295597+011809413.4840.0250.027122.712.8620.020.022106.912.8070.0330.03457.4AAA22211100066555527.931480401966700804019652s2000-01-3057223.50922.401-159.82451573.6741.060.71.113.4570.02712.8750.0612.7770.069470492se01U2.019516.314.51--43955101094756J082955.98+011809.3127.4832541.3025940.0010.0019017.95615.89615.03514.72714.5110.0120.0030.0030.0030.004123765366471209803661000020109002001032000.9155-93-4130------------
0.117925127.408521.2860660.060.06008293804+011709813.9360.0310.03380.913.2960.0320.03371.713.1170.0290.0343.1AAA22211100066666625.95780401962400804019615s2000-01-3057223.48622.328109.12451573.6741.010.951.113.9270.0313.2410.04513.1220.0594645144sw01U0.623417.215.71--43955101094756J082938.05+011709.7127.4085461.2860460.0010.0019019.62716.99515.80115.32415.0630.0310.0040.0030.0040.005123765366471209819461000090101002000032000.9155-63-430------------
0.121573127.4145461.2899930.060.06008293949+011723914.6660.0320.03441.314.2640.0430.04429.414.2230.0650.06615.6AAA22211100066461623.61380401964000804019624s2000-01-3057223.48522.33587.42451573.6741.40.771.1514.7290.0414.3890.11814.4180.2254659165sw01U0.420516.315.31--43955101094756J082939.49+011723.9127.4145741.2899740.0010.0019017.7616.32915.79715.61115.5370.010.0030.0030.0040.006123765366471209793561000020109002001032000.915513-530------------
0.136879127.3980361.2998180.210.188608293552+011759316.0060.0910.09212.015.5140.1240.1249.315.2030.1450.1456.3ABC2221110006160645.2180401967500804019645s2000-01-3057223.46722.325146.92451573.6740.761.571.0816.1740.09315.0850.29115.6870.3764695106sw01U0.825518.017.11--43955101094756J082935.53+011759.3127.3980741.2998210.0030.0039020.17518.15617.34817.06716.90.0440.0060.0050.0050.0111237653664712098178610000B0101002001032000.9155-93130------------
0.057062127.4777151.3080560.060.06008295465+011829014.5690.0330.03645.213.9690.0380.03938.613.6780.0450.04525.7AAA22211100045665627.913480401965200804019667s2000-01-3057223.50122.399-139.92451573.6741.111.151.3913.2781.85213.9860.06313.7920.1174723112se01U1.822419.717.41--43955101094756J082954.65+011828.9127.4777241.3080430.0040.0039022.17919.3117.90716.63815.9460.2070.0110.0060.0050.007123765366471209831661000000101002010032000.9155-223-2430------------
0.247647127.468311.310750.120.11908295239+011838716.0620.0910.09211.415.2930.0930.09411.415.237------AAU220110000606006.934680401967600804019672s2000-01-3057223.49422.392-106.12451573.6741.381.13--16.0910.21415.4970.178----4733146se01U0.425418.017.01--43955101094756J082952.40+011838.5127.468351.3106940.0030.0039019.76817.9917.35517.14517.0420.0330.0060.0050.0050.012123765366471209829761000020101002001032000.9155-13-330------------
0.05223127.4678571.31260.140.138808295228+011845316.2720.1060.1079.415.3350.1230.12311.015.210.170.1716.3BBC222111000606066.916680401967200804019676s2000-01-3057223.49222.393-104.42451573.6741.140.940.9716.2250.16215.2190.15715.680.6544740148se01U0.523419.217.91--43955101094756J082952.28+011845.4127.4678611.3126140.0040.0049022.18619.30618.11317.64417.3650.2070.0120.0070.0070.015123765366471209829861000020109002101032000.9155-43030------------
0.120696127.4599551.3212780.070.071708295038+011916615.2540.0580.05924.015.0650.0850.08614.114.920.1270.1288.2AAB22211100066060642.213880401967600804019689s2000-01-3057223.47922.39-76.02451573.6741.181.231.015.1080.09915.0930.20814.9560.1864771176se01U0.521616.916.21--43955101094756J082950.39+011916.7127.4599611.3213110.0020.0029018.12216.86216.41616.27116.2050.0130.0040.0040.0040.008123765366471209800061000020109002001032000.9155-23-130------------
0.081882127.4160131.2963850.060.061708293984+011746914.6670.0390.04141.314.2850.0540.05528.814.2260.0820.08215.5AAA22211100066460517.631680401964600804019640s2000-01-3057223.4822.33982.22451573.6741.081.171.0214.7220.02814.2940.10714.3310.1334682171sw01U0.225916.315.31--43955101094756J082939.84+011746.9127.4160351.2963790.0010.0019017.17516.04415.67415.52915.4880.0080.0030.0030.0040.006123765366471209793861000000101000000032000.9155-23230------------
0.14732127.4295051.3004630.080.08008294308+011801615.4820.0580.05919.514.9720.0620.06215.315.060.1260.1277.2AAB22211100036060550.725380401964000804019647s2000-01-3057223.48322.35333.62451573.6741.041.091.1215.5220.12215.2220.12215.1770.34697219sw01U0.622417.616.41--43955101094756J082943.09+011801.7127.4295451.3004720.0020.0029019.29217.61716.95316.67516.5310.0250.0050.0040.0050.0091237653664712098246600000B0109002001032000.9155-13-330------------
0.085624127.4126291.2999270.070.06408293903+011759715.4830.060.06119.514.8480.0770.07817.214.620.10.110.8AAA22211100036261617.613680401964000804019646s2000-01-3057223.47522.33894.32451573.6740.81.081.0415.3820.0914.7120.17514.5080.2464695158sw010--------0--43955101094756J082939.03+011759.7127.412651.2999160.0060.0069023.72420.21718.77317.54816.8610.6960.0210.010.0070.011123765366471209839860000090101002000032000.9155275-1850------------
0.094559127.4227841.3155960.080.0816308294146+011856115.9310.0860.08712.915.3240.0940.09511.115.5870.2260.2264.4AAD2221110006060624.832280401968800804019682s2000-01-3057223.46522.35557.82451573.6741.240.911.0316.1910.17115.9080.38816.0120.5234751195sw01U0.421817.816.81--43955101094756J082941.47+011856.2127.4228011.3156160.0020.0029019.4917.76417.1316.90216.8130.0280.0050.0050.0050.011123765366471209823261000020109002101032000.915503030------------
0.113296127.4185381.3210240.070.07008294044+011915615.2650.0560.05723.814.870.0820.08216.814.7470.1060.1069.6AAB22211100056161621.034680401969800804019688s2000-01-3057223.45822.35473.12451573.6741.060.70.6615.1560.1114.760.11214.4770.174771180sw01U0.520516.916.11--43955101094756J082940.45+011915.7127.4185691.3210290.0020.0029018.07816.84416.38616.20516.1480.0120.0040.0040.0040.008123765366471209794761000020109000001032000.915513-430------------
0.086304127.4446011.3207080.080.081708294670+011914515.470.0590.0619.714.8840.080.0816.615.1770.1640.1646.5AAC22211100036050555.335780401972100804019686s2000-01-3057223.47222.376-20.72451573.6740.881.090.9715.460.15514.8970.17215.4950.2894769231se01U1.316817.116.01--43955101094756J082946.71+011914.5127.4446251.320710.0020.0029018.03416.96816.5316.35416.2860.0120.0040.0040.0040.008123765366471209799061000000101000000032000.9155103-2330------------
0.084138127.4438331.3360410.080.081708294651+012009715.7390.0770.07815.414.990.090.0915.115.1150.1430.1436.9AAC22211100026061645.933480401974800804019721s2000-01-3057223.45722.383-18.02451573.6740.670.721.6215.6640.13414.9350.11415.210.5374825234se01U0.315919.617.91--43955101094756J082946.52+012009.6127.443851.3360250.0050.0049022.31219.73518.28617.49317.0540.2360.0150.0080.0060.012123765366471209827261000000101000000032000.915573-130------------
0.233934127.5511241.2741910.20.193208301226+011627016.5230.1380.1397.515.9780.1780.1786.115.626------BCU2201100006060053.113280404061200804040583s2000-01-3058223.57222.44727.42451573.68140.861.1--17.2530.52815.720.401----4606225sw01U0.520518.217.31--439561010984221J083012.27+011627.3127.551141.2742540.0030.0039019.8818.21117.59817.3917.3370.0350.0060.0060.0060.015123765366471216378961000000101000000032000.915503030------------
0.264938127.5625241.2844660.240.231508301500+011704016.7380.1670.1676.115.5130.1360.1369.315.4870.2540.2544.9CBD2221110006060655.222880404058300804040560s2000-01-3058223.56822.462-13.62451573.68140.980.80.9716.3590.22515.2460.21615.2220.4574643238se01U0.331719.418.01--439561010984221J083014.99+011703.8127.5624961.2843980.0050.0059021.81419.33618.26117.81617.5410.1570.0120.0070.0080.018123765366471216380461000000101000010032000.9155-54240------------
0.047465127.6310181.3130590.090.069008303144+011847012.950.0250.027193.812.4530.0220.024145.512.3670.0210.02386.0AAA22211100055666623.230880404628400804046275s2000-01-3059223.57722.536173.52451573.68370.870.731.1412.9570.00912.4820.03612.4160.03474379sw01U0.421615.513.91--43957101099356J083031.44+011846.9127.631021.3130460.0010.0019017.11415.09314.33114.07413.9660.0080.0030.0030.0030.004123765366471216364461000020109006101032000.9155-63-530------------
0.010768127.6082731.3052590.070.069008302598+011818914.880.0350.03733.914.50.0480.04923.714.4040.0790.0813.2AAA22211100066360650.433580404049000804040515s2000-01-3058223.57222.512-178.32451573.68140.911.270.7714.8090.07514.4670.12514.5530.117471874se01U0.220816.615.71--439561010983209J083025.98+011818.9127.6082731.3052560.0010.0019017.9416.55816.05215.87415.8010.0110.0040.0040.0040.006123765366471216356161000030109002001032000.915503130------------
0.04973127.6022831.3179230.070.069008302454+011904512.9830.0230.026194.612.6790.0210.023126.612.6770.0240.02664.7AAA22211100s66556647.11480404046300804040490s2000-01-3058223.55722.513-156.72451573.68140.860.681.0212.9650.02412.7260.05912.7120.033476395se01U0.225714.813.81--439561010983209J083024.55+011904.5127.6022951.317930.00.09015.57714.32913.95113.82513.8130.0040.0030.0030.0030.004123765366471216354861000020109002101032000.9155-23530------------
0.051722127.6259641.3170530.10.078908303023+011901315.0320.0530.05528.514.6670.0580.05818.914.7470.1140.1159.6AAB22211100066260623.212880404627500804046284s2000-01-3059223.5722.533191.72451573.68370.811.051.0615.0070.05114.6720.11814.6010.18475861sw11U0.522216.515.81--43957101099356J083030.23+011901.4127.6259771.3170590.0010.0019017.4716.38716.03315.89315.8840.0090.0030.0040.0040.007123765366471216363961000090129402004832000.9155-43-330------------
0.058186127.6328681.3200280.090.069008303188+011912114.0890.0310.03367.913.450.0270.02958.113.1640.0370.03841.3AAA22211100066666626.019580404627500804046292s2000-01-3059223.57122.541166.92451573.68370.961.061.1614.0810.02513.4360.05113.1360.074476886sw01U0.228518.816.81--43957101099356J083031.88+011912.0127.6328661.3200120.0020.0029021.12418.58517.14716.0215.4190.0870.0080.0050.0040.0061237653664712163873610000B0101002001032000.9155-23530------------
0.133695127.6055261.3305980.080.078308302532+011950115.3850.0470.04921.314.7110.0690.06919.514.7380.1260.1279.7AAB22211100046361647.119480404049000804040463s2000-01-3058223.54722.522-168.42451573.68140.890.841.0715.4850.11314.6270.08314.6930.39480984se01U0.914619.818.21--439561010983209J083025.33+011950.1127.6055631.3305940.0060.0069022.34620.15818.71317.47516.8230.2330.020.0090.0060.011123765366471216394761000000101000000032000.9155164-1240------------
0.079876127.6292591.3336580.130.1310908303102+012001115.9360.0960.09712.415.5010.1090.1098.815.3140.1860.1865.7ABC2221110006060611.01180404632400804046318s2000-01-3059223.55622.544179.82451573.68371.10.821.0615.8040.18415.7830.33115.4660.36481773sw01U0.317417.616.61--43957101099356J083031.01+012001.2127.6292461.3336760.0020.0029018.74817.39416.9116.7516.6780.0180.0050.0040.0050.01123765366471216366361000020101002101032000.915533-130------------
0.14186127.6478941.3472750.080.068808303549+012050113.560.0260.029110.513.1490.0290.0376.613.0620.0340.03545.4AAA22211100066665529.26680404636600804046354s2000-01-3059223.55322.567112.82451573.68370.940.730.9713.5740.03713.1490.06413.0270.0444866140sw01U0.427015.514.41--43957101099356J083035.49+012050.0127.6478781.3472390.0010.0019016.66115.15514.64514.50114.4330.0060.0030.0030.0030.004123765366471222888261000020109002101032000.9155-73230------------
0.119708127.6298561.3366590.090.078808303116+012011915.6240.0750.07616.515.1160.0780.07812.514.8450.1240.1248.8AAB22211100036060611.019180404631800804046324s2000-01-3059223.55422.546177.72451573.68370.681.111.4215.5360.11315.2480.15815.1160.077482875sw01U0.025717.616.71--43957101099356J083031.16+012011.8127.6298321.3366360.0020.0029019.13617.60816.96516.73316.6080.0220.0050.0040.0050.01123765366471216366461000020101002101032000.9155-13230------------
0.131932127.6411341.3541780.080.069008303387+012115014.4490.0350.03748.713.8440.0240.02640.413.4950.0450.04530.4AAA22211100066666627.634380404639000804046376s2000-01-3059223.54322.564137.12451573.68371.071.290.9714.4230.03213.8640.0713.5290.064891116sw01U1.226418.916.81--43957101099468J083033.87+012114.9127.6411231.3541430.0020.0029021.45118.8817.46616.38115.8140.1040.0090.0060.0050.007123765362229962408061000000101000030032000.9076-263-130------------
0.093665127.6593721.3449640.10.089008303824+012041815.7220.0690.0715.115.190.0980.09911.715.1910.1690.1696.4AAC22211100016060624.732480404636600804046346s2000-01-3059223.56122.57671.52451573.68371.170.971.1115.7070.1215.0870.09815.2750.3374858181sw01U0.319017.616.51--43957101099356J083038.24+012041.7127.6593621.344940.0020.0029018.617.33716.8716.70916.6190.0160.0040.0040.0050.011237653664712228899600000B0101202001432000.915523-330------------
0.220468127.6658861.3496350.080.069008303981+01205869.3680.0230.0265250.98.80.0630.0654206.48.7610.0190.0212382.4AAA21211100044666628.923480404634600804046361s2000-01-3059223.5622.58448.02451573.68370.750.740.69.3620.018.880.058.7450.0124875205sw01T0.32411.6210.832--43957101099468J083039.81+012058.4127.6658811.3495740.0450.044014.88911.5710.80110.53310.9590.0060.0010.0010.0010.0021237653664712228897600001B8109206101432000.9155--------0------------
..........................................................................................................................................................................................................................................................................................
0.102943127.6085031.6577050.060.069008302604+013927713.4080.0230.026131.612.9120.0260.027102.112.7560.030.03160.1AAA22211100066666656.430980403968100804039702s2000-01-3058223.23822.682-179.12451573.68121.111.01.0313.3920.01912.8910.04212.7230.036598673se01U0.122415.914.41--439561010982198J083026.04+013927.6127.6085091.6576770.0010.0019017.66615.6414.84414.55714.4290.010.0030.0030.0030.004123765366524903444061000000101002000032000.915503230------------
0.075051127.617931.6703630.060.069008302830+014013312.3310.0210.024354.811.8520.0210.023271.111.7760.0220.024148.3AAA22211100066556648.79780404708700804039676s2000-01-3058223.23122.697-213.02451573.68120.970.850.8712.3250.01511.8630.05211.7950.02603239se11U1.019714.713.21--439561010982198J083028.30+014013.2127.6179241.6703430.0470.0419015.93414.38314.12213.7913.3740.0050.0030.010.0020.00412376536652490344666000009810100E100032000.9155-93-1830------------
0.057893127.6313771.6688060.060.069008303153+014007714.4170.0370.03950.214.0780.0480.04932.614.0410.0590.05918.4AAA22211100066663620.518580404707700804047087s2000-01-3059223.23922.708172.22451573.68390.890.691.0714.3560.02714.0770.05414.0320.1602480sw01U0.132015.915.11--43957101099580J083031.53+014007.6127.6313831.6687910.0010.0019017.19215.96215.50715.33415.2770.0080.0030.0030.0030.005123765366524903452561000000101000020032000.915503630------------
0.165563127.596341.6675810.110.114508302312+014003215.9320.0790.0812.915.5640.1290.1298.915.4940.2070.2074.8ABD22211100026060556.412980403970200804039681s2000-01-3058223.22222.677-135.32451573.68121.420.890.9915.8560.15215.7130.13915.2560.5936022117se01U0.423117.216.61--439561010982198J083023.13+014003.2127.5963821.6675620.0020.0029018.41517.2916.90916.76816.720.0150.0040.0040.0050.01123765366524903442661000000101000000032000.9155-13030------------
0.027431127.6074121.6802640.070.074508302577+014048915.1870.0450.04725.614.7680.0520.05218.514.6350.1050.10510.7AAA22211100046260619.334180403963900804039656s2000-01-3058223.21622.692-175.12451573.68110.840.990.6615.2670.08314.9390.13914.2720.074606877se01U0.419617.216.21--439561010982198J083025.78+014048.9127.6074191.6802610.0020.0029018.91317.22116.56116.31916.2120.020.0040.0040.0040.008123765366524903444261000000101000020032000.915503-430------------
0.078476127.6056751.6853280.070.06408302536+014107115.2080.040.04225.114.6140.050.05121.314.5290.0820.08311.7AAA22211100056261519.316180403965600804039639s2000-01-3058223.2122.693-168.92451573.68111.230.930.615.2380.07414.7430.12414.3940.152608683se01U1.020117.016.11--439561010982198J083025.36+014107.1127.6056811.6853070.0020.0029018.89217.15816.47216.22116.110.0190.0040.0040.0040.008123765366524903443761000020101002101032000.9155-83-1930------------
0.649439127.595571.6939480.240.211408302293+014138216.4510.1440.1448.015.8410.1660.1666.915.4030.2210.2215.3BCD22211100016050647.813080403963900804039617s2000-01-3058223.19722.689-132.52451573.68111.161.110.9816.0660.315.2710.19114.6730.146117120se01U0.530618.516.91--439561010982198J083022.94+014137.5127.5956051.6937710.010.0089020.24818.53217.6517.26716.9380.0870.010.0080.0080.022123765366524903473131000020101002111032000.9155-63-430------------
0.100329127.6124031.6840110.070.068608302697+014102414.8260.0490.0535.714.370.0710.07226.714.4210.090.0913.0AAA2221110006655263.435580404712400804039648s2000-01-3058223.21522.699-193.12451573.68114.162.342.1214.5850.04214.0510.05413.8640.142608159se11U1.118116.115.01--439561010982198J083026.97+014102.3127.612411.6839840.0010.0019017.58716.37715.93415.77315.7230.010.0030.0040.0040.006123765366524903444761000020101002001032000.915524-240------------
3.276802127.6124031.6840110.070.068608302697+014102414.8260.0490.0535.714.370.0710.07226.714.4210.090.0913.0AAA2221110006655263.435580404712400804039648s2000-01-3058223.21522.699-193.12451573.68114.162.342.1214.5850.04214.0510.05413.8640.142608159se11U1.118116.115.01--439561010982198J083026.97+014105.7127.6123841.6849210.0030.0039021.67519.06117.81517.26516.9670.1420.0120.0070.0060.013123765366524903444861000060101202001032000.9155--------0------------
0.007957127.6260441.6879860.060.067308303025+014116714.1010.0320.03467.213.8120.0360.03741.613.7890.0510.05123.2AAA22211100066665649.81980404715900804047134s2000-01-3059223.21822.712191.42451573.6840.841.041.0514.1550.02213.9250.08913.7960.148609361sw01U0.118815.914.91--43957101099580J083030.25+014116.7127.6260461.6879850.0010.0019017.12215.66415.19815.04215.0050.0080.0030.0030.0030.005123765366524903451161000020109002101032000.915503430------------
0.245498127.6123211.6849470.110.1112508302695+014105814.733------15.0550.0860.08713.214.616------UAU20100c056003.417580403964800804047124s2000-01-3059223.21422.699240.82451573.684--0.93------14.1880.073----608212sw00U2.335216.115.01--43957101099580J083026.97+014105.7127.6123841.6849210.0030.0039021.67519.06117.81517.26516.9670.1420.0120.0070.0060.013123765366524903444861000060101202001032000.9155--------0------------
3.481436127.6123211.6849470.110.1112508302695+014105814.733------15.0550.0860.08713.214.616------UAU20100c056003.417580403964800804047124s2000-01-3059223.21422.699240.82451573.684--0.93------14.1880.073----608212sw00U2.335216.115.01--43957101099580J083026.97+014102.3127.612411.6839840.0010.0019017.58716.37715.93415.77315.7230.010.0030.0040.0040.006123765366524903444761000020101002001032000.915524-240------------
0.011467127.5807611.7013350.060.064508301938+014204814.6310.0360.03842.714.2080.0440.04531.014.0560.0660.06718.2AAA22211100066664656.62280403956600804039599s2000-01-3058223.18222.679-79.22451573.68110.830.970.9414.5940.0614.1520.07413.9850.2096144173se01U0.427516.415.41--439561010982198J083019.38+014204.8127.5807621.7013380.0010.0019017.73516.28315.7515.56515.5140.010.0030.0040.0040.006123765366524903440061000020109002101032000.9155-83530------------
0.238458127.5593041.6966630.140.13808301423+014147916.0430.0770.07811.615.4930.1210.1229.515.2010.1620.1626.3ABC2221110006060658.018480403965500804039606s2000-01-3058223.17522.658-2.02451573.68110.980.811.3316.3210.22415.3720.18615.020.2416127250se01U0.327020.218.81--439561010982198J083014.24+014147.7127.5593361.6966050.0070.0079022.95520.53619.01317.91517.3630.3960.0250.0110.0080.016123765366524903481461000000101000010032000.915504240------------
0.150187127.5946931.7120730.060.069008302272+014243415.060.0360.03828.714.420.0550.05625.514.2190.0660.06715.6AAA22211100066260531.629580403956600804039577s2000-01-3058223.17922.697-129.42451573.68111.021.120.8515.0630.05914.5030.16814.7310.3176182123se01U0.213217.916.41--439561010982198J083022.72+014243.3127.5946721.7120370.0020.0029020.13817.81416.76216.37416.1790.0430.0050.0040.0040.008123765366524903472861000000101000000032000.915523-230------------
0.108212127.5867721.7158490.070.074508302082+014257015.7230.0660.06715.614.9730.060.0615.314.8120.120.129.1AAB22211100036060528.2080403955200804039566s2000-01-3058223.17122.691-100.92451573.68111.080.961.1115.7050.18115.2110.1614.6640.1196196151se010--------0--439561010982198J083020.82+014256.9127.5867481.7158310.0090.0089023.70321.00619.37417.92517.1140.7060.0370.0140.0080.013123765366524903482561000020101000001032000.9155-145350------------
0.240613127.4471921.6475330.240.198108294732+013851116.5290.1480.1497.416.0280.1950.1955.815.1040.1760.1766.9BCC2221110006050615.912980402042400804020436s2000-01-3057223.16322.536-30.12451573.67421.120.980.8615.8610.06215.1480.20414.5260.2245946222se01U0.722019.018.01--43955101094980J082947.33+013851.2127.4472471.6475710.0150.019020.62219.31618.11917.63617.2850.1110.0170.010.010.027123765366524896924031000020101002021032000.915513-330------------
0.094562127.4339531.6557580.130.1117608294414+013920716.0650.0950.09611.415.50.1130.1139.415.3840.1830.1835.3ABC2221110006160617.834980402046800804020450s2000-01-3057223.14922.52917.62451573.67421.721.150.9816.6680.2415.5890.42917.985.0255976235sw01U0.419917.817.21--43955101094980J082944.15+013920.6127.4339771.6557470.0030.0029019.5217.92317.32117.06516.9410.0290.0050.0050.0050.012123765366524896912261000020101002001032000.915523-330------------
0.107628127.4329861.6606080.060.06008294391+013938113.0030.0180.022191.112.4780.0270.029152.312.4180.0270.02982.1AAA22211100066665517.816980402045000804020468s2000-01-3057223.14422.5321.02451573.67420.850.921.1113.0210.02512.4710.06212.4130.0535993232sw01U0.426115.514.31--43955101094980J082943.92+013938.1127.4330131.6605950.0010.0019016.9615.13814.43917.19314.0230.0070.0030.0030.0170.0041237653665248968917610000B8109006101032000.9155-63330------------
0.717615127.4406031.6670360.060.061708294574+014001312.7160.0310.033248.912.1250.0380.039210.811.8890.0270.029133.6AAA22211100066665535.923080402046800804020477s2000-01-3057223.14222.54-6.42451573.67422.542.873.0312.5720.0111.9180.0411.7870.0326016246se01U0.522116.114.01--43955101094980J082945.69+014001.3127.4404041.6670480.0010.0019019.83217.0915.58315.04714.7650.0410.0040.0030.0030.005123765366524896894961000060101000001032000.9155-233-230------------
0.837076127.4406031.6670360.060.061708294574+014001312.7160.0310.033248.912.1250.0380.039210.811.8890.0270.029133.6AAA22211100066665535.923080402046800804020477s2000-01-3057223.14222.54-6.42451573.67422.542.873.0312.5720.0111.9180.0411.7870.0326016246se01U0.522116.114.01--43955101094980J082945.80+014001.2127.4408341.6670090.0010.0019019.01816.38315.18114.6114.2840.0210.0030.0030.0030.004123765366524896895161000020119000001032000.9155--------0------------
0.099214127.4490761.6815830.060.06008294777+014053614.8790.0320.03534.014.2190.050.05130.614.1080.0590.0617.3AAA22211100066660660.621080402047700804020514s2000-01-3057223.13222.554-36.92451573.67420.860.70.8514.9270.0514.1970.06314.2620.0976068215se01U0.433418.416.61--43955101094980J082947.78+014053.6127.4490971.6815650.0020.0029021.2318.47317.08916.4316.0530.0990.0070.0050.0040.007123765366524896915661000000101000010032000.9155131230------------
0.144389127.4290171.6814210.070.071708294296+014053115.0910.0550.05727.914.8060.0670.06717.814.780.1160.1179.3AAB22211100066050644.134780402052900804020512s2000-01-3057223.12222.53735.32451573.67420.770.840.9715.0290.02914.7280.08514.7070.2176068217sw01U0.428516.615.81--43955101094980J082942.97+014053.0127.4290551.6814080.0010.0019017.67816.55616.16316.02515.9690.010.0040.0040.0040.007123765366524896890661000000101000000032000.9155-53530------------
0.325286127.4262131.6933380.280.276308294229+014136016.7250.1790.1796.215.8430.1540.1546.915.570.2290.2294.5CCD222111c005060625.61680402054000804020529s2000-01-3057223.10922.5445.42451573.67430.961.01.1116.7190.415.8820.41615.4310.4146111207sw01U0.619619.418.01--43955101094980J082942.27+014136.2127.4261611.6934120.0050.0049024.63419.47718.29317.8317.6530.9660.0120.0080.0080.019123765366524896889661000020101006111032000.9155-43030------------
0.148096127.4281331.7001770.060.06008294275+01420069.7910.0210.0243681.59.5050.0240.0262354.69.4580.0190.0211253.8AAA22211100066666625.619680402052900804020540s2000-01-3057223.10422.54538.52451573.67430.741.050.879.7790.0099.50.0349.4510.026136214sw01T0.15211.4810.791--43955101094980J082942.74+014200.5127.4280971.7001570.3990.3999014.89311.21910.82410.68310.9540.0110.0010.0010.0010.0021237653665248968895300001B8009006101032000.9155--------0------------
0.022635127.4491641.7080550.060.061708294779+014228914.4570.0350.03750.114.0070.0310.03237.313.9230.060.06120.5AAA22211100066665648.41280402058800804020559s2000-01-3057223.10722.567-37.22451573.67431.090.911.2314.4480.05914.0610.08113.8870.1026164215se01U0.324816.815.41--43955101094980J082947.80+014228.9127.4491661.7080490.0010.0019018.32116.54615.86115.59915.4480.0140.0040.0040.0040.006123765366524896896361000000101000000032000.9155-33330------------
0.304171127.4924061.6851150.310.37008295817+014106416.2370.1060.1069.715.6470.1360.1368.215.6830.2390.2394.1BBD22211100016060624.319480402050900804020518s2000-01-3057223.15122.594-192.82451573.67431.090.751.0316.0860.1615.5140.19115.6390.359608159se110--------0--43955101094980J082958.15+014106.4127.4923241.6851360.0110.019023.49921.01819.61518.34717.6310.6080.0360.0170.010.019123765366524903485261000000101000010032000.9155185-1550------------
0.133341127.5031051.7009050.060.069008300074+014203214.5710.0390.04145.114.2180.0310.03230.714.1040.0640.06517.4AAA22211100066560624.135380403958300804039600s2000-01-3058223.14222.611200.22451573.68111.340.990.8714.5430.02714.2870.15314.2970.141614353sw11U0.526816.215.21--439561010982198J083000.75+014203.1127.5031341.7008820.0010.0019017.39316.05915.60315.44815.4060.0090.0030.0040.0040.006123765366524903428961000020109002001032000.9155-53430------------
0.273005127.4773041.6978120.230.234208295455+014152116.6850.1540.1556.415.9420.160.1616.315.420.220.225.2CCD2221110006060621.529180402053900804020536s2000-01-3057223.13122.587-138.52451573.67430.90.941.016.4550.26216.2520.61215.2160.4836127114se01U0.315519.118.11--43955101094980J082954.54+014152.3127.4772591.6978730.0040.0049021.38419.09118.12717.81417.5830.110.010.0070.0070.018123765366524896918061000000101000010032000.915533430------------
0.231895127.4717491.6999810.150.1514508295321+014159916.2780.120.1219.415.6460.1380.1388.215.792------BBU2201100006060021.511180402053600804020539s2000-01-3057223.12722.583-118.52451573.67430.820.93--16.1580.1215.6660.136----6134134se01U0.517818.217.11--43955101094980J082953.20+014159.8127.4716861.6999680.0030.0039019.80118.2517.64817.44517.2920.0340.0060.0060.0060.015123765366524896917261000000101000000032000.915503-630------------
0.108018127.4854721.7016310.070.071708295651+014205815.2860.0470.04923.314.8050.0690.06917.914.590.1020.10211.1AAA22211100036150632.424580402053600804020544s2000-01-3057223.13222.596-167.82451573.67431.031.11.0215.410.10714.790.12714.3310.225614084se01U0.522717.916.61--43955101094980J082956.51+014205.7127.4854831.7016030.0020.0029019.85617.7316.8616.54116.350.0360.0050.0040.0040.009123765366524903455861000000101002000032000.9155-43-430------------
0.033205127.502331.7075680.060.069008300055+014227213.4420.0230.026127.512.8370.0240.026109.412.6520.0290.0366.2AAA22211100066665524.117380403960000804039583s2000-01-3058223.13522.614203.02451573.68111.130.791.513.4830.01812.9130.02912.710.045616750sw11U1.126217.215.11--439561010982198J083000.56+014227.2127.5023321.7075590.0010.0019019.46116.82915.52414.97614.6920.0270.0040.0040.0030.005123765366524903458661000020101002001032000.9155-223130------------
0.127126127.4694231.713720.120.1110108295266+014249316.1240.0970.09810.815.4080.1010.10210.315.340.1860.1865.6AAC2221110006060650.217080402053900804020569s2000-01-3057223.11222.588-110.12451573.67430.990.990.9316.2560.26915.9290.34715.5740.3286184142se010--------0--43955101094980J082952.66+014249.2127.4694181.7136850.0090.0089023.47220.75519.28318.18117.5030.5940.0290.0140.0090.017123765366524896926361000000101000010032000.9155-135350------------
0.029366127.4519481.7212050.060.06008294846+014316312.4590.0190.023315.412.0560.0240.026224.711.9690.0230.024124.1AAA22211100066666648.419280402055900804020588s2000-01-3057223.09622.576-47.22451573.67430.740.740.8612.470.01912.0380.04611.9730.0296211205se01U1.317614.813.51--43955101094980J082948.46+014316.3127.4519551.7212010.0470.0429016.12514.4713.78513.75513.4930.0060.0030.0060.0020.0041237653665248968970600000B8109206101032000.915523-2430------------
0.475815127.3954741.697110.340.328808293491+014149516.5510.1640.1647.315.9070.2070.2076.515.7950.2740.2753.7CED2221110006050653.733880402056600804020535s2000-01-3057223.08922.515156.02451573.67430.8510.930.7216.4610.21616.10.26816.1460.828612597sw010--------0--43955101094980J082934.93+014149.9127.3955661.6972050.0170.0169023.31621.50620.04118.67617.9020.5570.0540.0240.0130.0231237653665248969283610100F0101002101032000.9155--------0------------
0.063468127.4322921.7171160.070.069608294375+014301614.5690.0320.03545.214.2990.0550.05628.514.2190.0840.08415.6AAA22211100066561422.81480402059300804020581s2000-01-3057223.0922.55723.52451573.67430.91.150.6514.5520.0514.1720.08614.2250.2296197229sw01U0.319816.415.31--43955101094980J082943.75+014301.6127.4323091.7171210.0010.0019017.45316.13715.68315.53215.4690.0090.0030.0040.0040.006123765366524896892461000000101002020032000.915513-130------------
0.078846127.4338571.7232630.070.071708294412+014323715.6780.080.08116.315.2070.1050.10512.314.9650.1380.1387.9AAB222111ccc6656164.531780402059600804020593s2000-01-3057223.08522.56117.92451573.67431.140.831.2214.5170.09714.0720.11214.1790.1446219235sw01U4.013915.814.41--43955101094980J082944.13+014323.7127.4338771.7232720.0070.0079023.80220.41119.03917.72817.0180.7430.0240.0120.0070.0131237653665248968930610000B0181202101032000.9155--------0------------
0.036173127.5319021.7297570.060.069008300765+014347114.1550.0330.03666.113.840.0320.03343.413.8060.0480.04922.9AAA22211100066664614.18280403953900804039541s2000-01-3058223.1322.6596.62451573.68111.030.881.0114.1360.05113.9720.04813.850.1186247156sw01U0.223015.815.01--439561010982198J083007.65+014347.1127.5319081.7297490.0010.0019017.14515.74115.24615.07915.0390.0080.0030.0030.0030.005123765366524903433261000000101002000032000.9155-33130------------
0.676936127.535771.7302930.370.354508300858+014349017.0470.2310.2314.616.1230.190.195.315.8720.3020.3033.4DCD2221110006060514.126280403954100804039539s2000-01-3058223.13122.65482.72451573.68110.950.740.9816.5370.39917.5291.51516.040.7056249170sw010--------0--439561010982198J083008.62+014348.6127.5359211.7301810.0230.029023.84721.89520.46219.03418.3550.7560.0750.0320.0170.032123765366524903508361000000101000010032000.9155--------0------------

For the SDSS DR9 table this action has given us all the columns. So before we move on, we restrict the table to the columns, we are actually interested in.

sdss_mass = sdss_mass[
    "2MASS",
    "RAJ2000",
    "DEJ2000",
    "Jmag",
    "Hmag",
    "Kmag",
    "SDSS9",
    "RAdeg",
    "DEdeg",
    "umag",
    "gmag",
    "rmag",
    "imag",
    "zmag",
    "cl",
]

print(f"We are currently working with {len(sdss_mass)} sources")
We are currently working with 717 sources

Step #3: Filtering#

In this step we select all those sources from our cross-matched catalogue that have colours and fluxes as expected for brown dwarfs.

The selection cirteria for Brown Dwarfs are:

  • umag > 22.0 –> magnitude in u-band fainter than 22.0mag

  • gmag > 22.2 –> magnitude in g-band fainter than 22.2mag

  • Jmag - Hmag < 0.3 –> J-H band colour smaller than 0.3mag

  • Hmag - Kmag < 0.3 –> H-K band colour smaller than 0.3mag

We now apply these selection criteria to our table of point sources.

# Add columsn with J-H and H-K colour
sdss_mass["J-H"] = sdss_mass["Jmag"] - sdss_mass["Hmag"]
sdss_mass["H-K"] = sdss_mass["Hmag"] - sdss_mass["Kmag"]
# Limit sources to those that fulfil the selection criteria
index_bd = (
    (sdss_mass["umag"] > 22.0)
    & (sdss_mass["gmag"] > 22.2)
    & (sdss_mass["J-H"] < 0.3)
    & (sdss_mass["H-K"] < 0.3)
)
candidates = sdss_mass[index_bd]
print(f"We have {len(candidates)} candidates for Brown Dwarfs")
We have 2 candidates for Brown Dwarfs
candidates
Table length=2
2MASSRAJ2000DEJ2000JmagHmagKmagSDSS9RAdegDEdegumaggmagrmagimagzmagclJ-HH-K
str16float64float64float64float64float64str19float64float64float64float64float64float64float64int64float64float64
08304878+0128311127.7032651.4753216.28916.1416.358J083048.81+012831.0127.7033771.47529325.32224.51425.49225.87819.40130.1490000000000009-0.21799999999999997
08304512+0134404127.6880071.57790116.1816.02115.769J083045.23+013443.5127.6884911.57875924.00422.29921.0320.47820.5360.158999999999998920.25200000000000067

Note that we are using slightly different selection criteria here in the notebook than in the original tutorial. The reason is the following. The CDS XMatch service uses VizieR tables with their default filtering. For the SDSS DR 9 table, VizieR will filter to only use primary sources and disregard secondary sources, which is not the case when downloading the VizieR table with e.g. TOPCAT. Now the primary SDSS source for this brown dwarf is classified as an extended source by the automated SDSS pipeline, probably because it is hardly detected and very faint. So if we remove all extended sources we also throw away the target of our studies. Hence, the filtering in this notebook is less strict to allow

Step #4: Verification of the Brown Dwarf candidates#

Visualization#

Aladin

The ipyaladin package allows to run an instance of Aladin Lite in your Jupyter notebook.

aladin1 = Aladin(
    survey="P/SDSS9/color",
    fov=0.03,
    target="{:.4f} {:.4f}".format(candidates["RAJ2000"][0], candidates["DEJ2000"][0]),
)
aladin1

As with any instance of Aladin Lite you can zoom in and out by scrolling your mouse. In the top left corner of the widget, you may chose which survey to look at, add layers, search for sources, …

You can also add tables to the widget by:

aladin1.add_table(candidates)

If you now click on the small square indicating the location of the source, the widget will show the corresponding table values in the lower part of the widget.

As you can see at one of the locations hardly anything is visible and at the location of the other brown dwarf candidate, there is a bright star. To further investigate these two sources, we now query Simbad for them.

Check in Simbad#

Simbad

In the Simbad database, an object type is assigned to every entry. So if this Brown Dwarf candidate is in the Simbad database, we might learn more about the object type:

# First candidate has an index 0
customSimbad = Simbad()
customSimbad.remove_votable_fields("coordinates")
customSimbad.add_votable_fields(
    "ra(2;A;ICRS;J2000;2000)",
    "dec(2;D;ICRS;J2000;2000)",
    "otype",
)
candidate_coord = SkyCoord(
    ra=candidates["RAJ2000"][0],
    dec=candidates["DEJ2000"][0],
    unit=u.deg,
)
candidate_simbad = customSimbad.query_region(candidate_coord, radius=10 * u.arcsec)
candidate_simbad
Table length=1
MAIN_IDRA_2_A_ICRS_J2000_2000DEC_2_D_ICRS_J2000_2000OTYPESCRIPT_NUMBER_ID
"h:m:s""d:m:s"
objectstr13str13objectint32
2MASS J08304878+012831108 30 48.7836+01 28 31.152BrownD*1
# First candidate has an index 1
customSimbad = Simbad()
customSimbad.remove_votable_fields("coordinates")
customSimbad.add_votable_fields(
    "ra(2;A;ICRS;J2000;2000)",
    "dec(2;D;ICRS;J2000;2000)",
    "otype",
)
candidate_coord = SkyCoord(
    ra=candidates["RAJ2000"][1],
    dec=candidates["DEJ2000"][1],
    unit=u.deg,
)
candidate_simbad = customSimbad.query_region(candidate_coord, radius=1 * u.arcmin)
candidate_simbad
/home/manon.marchand/.conda/envs/build-jupybook/lib/python3.11/site-packages/astroquery/simbad/core.py:135: UserWarning: Warning: The script line number 3 raised an error (recorded in the `errors` attribute of the result table): '8:30:45.12168 +1:34:40.4436': No astronomical object found :
  warnings.warn("Warning: The script line number %i raised "

Indeed the first candidate is classified as a brown dwarf. Within 10arcsec of the second source, no entry is found in Simbad although this is the brighter star. The reason for this might be the following: sources in Simbad are sources that have individually been discussed in the literature. If no papers have been published specifcially about this object, it will not appear in Simbad. However, as the object was included in the SDSS tables it is included in VizieR through the table it belongs to.

If we now want to see, in which papers the Brown Dwarf 2MASS J08304878+0128311 was included, we may use the following query in Simbad.

tap_simbad = pyvo.dal.TAPService("https://simbad.cds.unistra.fr/simbad/sim-tap")

query = """
SELECT BIBCode, Journal, Title, "year", Volume,
       Page || '-' || Last_Page AS "Pages", DOI 
FROM ref JOIN has_ref ON oidbibref = oidbib 
         JOIN ident ON has_ref.oidref = ident.oidref 
WHERE id = '2MASS J08304878+0128311'
ORDER BY "year" DESC; 
"""

result = tap_simbad.search(query).to_table()
result
Table length=22
bibcodejournaltitleyearvolumePagesdoi
objectobjectobjectint16int32objectobject
2021AJ....161...42BAJA volume-limited sample of ultracool dwarfs. I. Construction, space density, and a gap in the L/T transition.202116142-4210.3847/1538-3881/abc893
2020AJ....159..257BAJThe Hawaii infrared parallax program. IV. A comprehensive parallax survey of L0-T8 dwarfs with UKIRT.2020159257-25710.3847/1538-3881/ab84f4
2016ApJ...827...25BApJThe orbit of the L dwarf + T dwarf spectral binary SDSS J080531.84+481233.0.201682725-2510.3847/0004-637X/827/1/25
2016A&A...589A..49SA&APhotometric brown-dwarf classification. II. A homogeneous sample of 1361 L and T dwarfs brighter than J = 17.5 with accurate spectral types.201658949-4910.1051/0004-6361/201527359
2016ApJ...817..112SApJA proper motion survey using the first sky pass of NEOWISE-reactivation data.201681710.3847/0004-637X/817/2/112
2015ApJ...810..158FApJFundamental parameters and spectral energy distributions of young and field age objects with masses spanning the stellar to planetary regime.201581010.1088/0004-637X/810/2/158
2014ApJ...793...75RApJStrong brightness variations signal cloudy-to-clear transition of brown dwarfs.201479310.1088/0004-637X/793/2/75
2013MNRAS.433.2054SMNRASNPARSEC: NTT Parallaxes of Southern Extremely Cool objects. Goals, targets, procedures and first results.20134332054-206310.1093/mnras/stt876
2013MNRAS.433..457BMNRAS76 T dwarfs from the UKIDSS LAS: benchmarks, kinematics and an updated space density.2013433457-49710.1093/mnras/stt740
2012ApJ...752...56FApJThe Brown Dwarf Kinematics Project (BDKP). III. Parallaxes for 70 ultracool dwarfs.201275210.1088/0004-637X/752/1/56
2012ApJ...748...74LApJThe properties of the 500 K dwarf UGPS J072227.51-054031.2 and a study of the far-red flux of cold brown dwarfs.201274810.1088/0004-637X/748/2/74
2012ApJ...757..110BApJDiscovery of a very low mass triple with late-M and T dwarf components: LP 704-48/SDSS J0006-0852AB.201275710.1088/0004-637X/757/2/110
2011ApJS..197...19KApJSThe first hundred brown dwarfs discovered by the Wide-field Infrared Survey Explorer (WISE).201119710.1088/0067-0049/197/2/19
2010A&A...515A..92SA&AHip 63510C, Hip 73786B, and nine new isolated high proper motion T dwarf candidates from UKIDSS DR6 and SDSS DR7.201051592-9210.1051/0004-6361/201014264
2010ApJ...710.1627LApJMid-infrared photometry of cold brown dwarfs: diversity in age, mass, and metallicity.20107101627-164010.1088/0004-637X/710/2/1627
2010ApJ...710.1142BApJSpeX spectroscopy of unresolved very low mass binaries. I. Identification of 17 candidate binaries straddling the L dwarf/T dwarf transition.20107101142-116910.1088/0004-637X/710/2/1142
2009AJ....137....1FAJThe brown dwarf kinematics project I. Proper motions and tangential velocities for a large sample of late-type M, L, and T dwarfs.20091371-1810.1088/0004-6256/137/1/1
2009yCat....1.2023SyCatCatalogue of stellar spectral classifications.20091
2008MNRAS.390.1517CMNRASProper motions of field L and T dwarfs - II.20083901517-152610.1111/j.1365-2966.2008.13855.x
2008ApJ...676.1281MApJA cross-match of 2MASS and SDSS: newly found L and T dwarfs and an estimate of the space density of T dwarfs.20086761281-130610.1086/524721
2006ApJ...637.1067BApJA unified near-infrared spectral classification scheme for T dwarfs.20066371067-109310.1086/498563
2004AJ....127.3553KAJNear-infrared photometry and spectroscopy of L and T dwarfs: the effects of temperature, clouds, and gravity.20041273553-357810.1086/420707

For further reading you could now go to ADS and search for the publications via their bibcode (enter in the search field bibcode:...) or their doi (doi:...).

To design similar queries for your own research, have a look at Simbad database schema.