Choose a database in the left panel then select the table you want!

Table: sparcl.main
(The bold columns are indexed columns)
Column NameDescriptionDatatype
data_releaseData release of a given recordVARCHAR
datasetgroupHuman-readable common name for a coherent set of spectra that go togetherVARCHAR
dateobsRange of observational dates for a given spectrum (single value for a single date)VARCHAR
dateobs_centerCentral value of the dateobs rangeVARCHAR
decDeclination in degreesDOUBLE
elatEcliptic latitudeDOUBLE
elonEcliptic longitudeDOUBLE
exptimeExposure time in secondsREAL
glatGalactic latitudeDOUBLE
glonGalactic longitudeDOUBLE
htm9HTM Level-9 indexINTEGER
instrumentInstrument used for observationVARCHAR
nest4096Healpix ID with nside 4096, nested schemaINTEGER
raRight Ascension in degreesDOUBLE
random_idRandom ID in the range 0 to 100 (decimal)REAL
redshiftObserved redshift, or radial velocity in units of redshiftDOUBLE
redshift_errUncertainty on the observed redshift, or radial velocity in units of redshiftDOUBLE
redshift_warningBitmask with warning on redshift resultSMALLINT
ring256Healpix ID with nside 256, ring schemaINTEGER
siteSite of observationsVARCHAR
sparcl_idUniversally Unique Identifier for spectrum in SPARCLVARCHAR
specidDataset-specific spectrum identifier (may not be unique)BIGINT
specprimaryWhether an entry is the primary spectrum for a given target objectSMALLINT
spectypeSpectral type of the object (STAR, GALAXY, QSO)VARCHAR
targetidDataset-specific photometric target identifierBIGINT
telescopeTelescope used for the observationVARCHAR
wavemaxMaximum value of wavelength coverageDOUBLE
waveminMinimum value of wavelength coverageDOUBLE