AstrodbWeb: BDNYC Database

The BDNYC Database contains records for 1530 brown dwarfs and includes information such as photometry, parallaxes, spectra, etc.
The list of all available tables within the database can be found here.
The forms below allow you to explore the database by submitting an SQL query; performing a search by source ID, name, or coordinates; plot a spectrum; and check the inventory for a specific source.
You can also browse the database and examine the sources in a sky plot.

The current version of this database is that of Filippazzo et al. 2015. You can grab a copy of the BDNYC database here.
We encourage additions to the database via its Github repository.

This application runs on Python and utilizes the astrodbkit package to generate queries to the database. We recommend using astrodbkit to work with your astronomy SQL databases.
This application has been created by David R. Rodriguez; you can grab a copy of the code here for use with your own databases.

Publications that benefit from the BDNYC database should cite its Zenodo record; those that benefit from this application should also cite this record.

Browse the Database

Please type your SQL query below

Want some example queries? Try these out:

Search for objects by partial name matching (e.g., 0355 to find 2M0355+11) or within 1 arcminute of an RA, Dec coordinate (in degrees):

Plot a Spectrum

Plot the spectrum of an object by providing the spectrum ID (from the spectra table):
To get the IDs, you can do something like: SELECT, s.shortname, s.names FROM spectra AS sp JOIN sources as s WHERE

Check Inventory

Search the database for information on a particular source ID:

Created by David R. Rodriguez for the Brown Dwarfs in New York City (BDNYC) research team. 10.5281/zenodo.47866
This material is based upon work supported by the National Science Foundation under Grant Number 1313278.
Any opinions, findings, and conclusions or recommendations expressed in this material are those of the authors and do not necessarily reflect the views of the National Science Foundation.

Running astrodbkit version 0.5.2         Latest edits on database: 2015