Archives of Photographic PLates for Astronomical USE

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

The table has 1165879808 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 char 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

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

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 char time.creation Time[yyyy-mm-dd hh:mm:ss]

Timestamp of last update

pos char meta.number (radians,radians)

GIS index for (ra,dec)