Archives of Photographic PLates for Astronomical USE

Coordinates, raw magnitudes, and time information (applause_dr1.raw_lightcurve)

The table has 1166230016 rows, 20 columns.


This table contains magnitudes raw magnitudes (from source table), sky coordinates and source designations from the source_calib table, and observation time from the exposure table. Each row in the table has a unique source_id, which is the same as in the source and source_calib tables. It's a convenience for constructing a lightcurve for a selected object. It does not provide periods etc. Unique Identifier source_id


If you have made substantial use of the data provided by APPLAUSE DR1, kindly include this acknowledgement

Funding for APPLAUSE has been provided by DFG (German Research Foundation, Grant), Leibniz Institute for Astrophysics Potsdam (AIP), Dr. Remeis Sternwarte Bamberg (University Nuernberg/Erlangen) and the Hamburger Sternwarte (University of Hamburg).


Name Type UCD Unit Description
rlc_id int
Unique ID for table
source_id int Source identification number
process_id int Process identification number
scan_id int Scan identification number
plate_id int Plate identification number
archive_id int Archive identification number
ut_start timestamp time.start
Time[yyyy-mm-dd hh:mm:ss] UT date and time of the start of exposure
jd_start double time.start
Julian date at the start of exposure
jd_mid double time.epoch
Julian date at the mid-point of exposure
exptime float time.interval
s Exposure time
raj2000 double pos.eq.ra deg Right ascension of the source (equinox J2000)
dej2000 double pos.eq.dec deg Declination of the source (equinox J2000)
tycho2_id char Identification of the matched Tycho-2 catalogue object
ucac4_id char Identification of the matched UCAC4 catalogue object
healpix256 int pos.healpix Source HEALPix number (nside=256, nested ordering)
mag_auto float phot.mag mag Kron-like elliptical aperture magnitude
magerr_auto float stat.error
mag Error for mag_auto
annular_bin short meta.code Annular bin (1-9) where the source belongs (bin 1 is in the center, bin 9 is at the edge)
timestamp_update timestamp time.creation Time[yyyy-mm-dd hh:mm:ss] Timestamp of last update
pos spoint meta.number (radians,radians) GIS index for (ra,dec)