The table has 1834993024 rows, 27 columns.
Description
This table contains calibrated magnitudes, 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
Attribution
If you have made substantial use of the data provided by APPLAUSE DR2, 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), the Hamburger Sternwarte (University of Hamburg) and Tartu Observatory.
Columns
| Name | Type | UCD | Unit | Description |
|---|---|---|---|---|
| source_id | long |
meta.id meta.main |
Source identification number |
|
| process_id | int | meta.id |
Process identification number |
|
| scan_id | int | meta.id |
Scan identification number |
|
| plate_id | int | meta.id |
Plate identification number |
|
| archive_id | int | meta.id |
Archive identification number |
|
| ut_start | char |
time.start obs.exposure |
Time[yyyy-mm-dd hh:mm:ss] |
UT date and time of the start of exposure |
| jd_start | double |
time.start obs.exposure |
Julian date at the start of exposure |
|
| jd_mid | double |
time.epoch obs.exposure |
Julian date at the mid-point of exposure |
|
| year_mid | double |
time.epoch obs.exposure |
Decimal year of the mid-point of exposure |
|
| exptime | float |
time.interval obs.exposure |
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 | meta.id.cross |
Identification of the matched Tycho-2 catalogue object |
|
| ucac4_id | char | meta.id.cross |
Identification of the matched UCAC4 catalogue object |
|
| healpix256 | int | pos.healpix |
Source HEALPix number (nside=256, nested ordering) |
|
| natmag | float |
phot.mag em.opt |
mag |
Calibrated magnitude of the source in the plate natural photometric system |
| natmagerr | float |
stat.error phot.mag em.opt |
mag |
Estimated error on the calibrated magnitude of the source in the plate natural photometric system |
| bmag | float |
phot.mag em.opt.B |
mag |
Calibrated B magnitude of the source |
| bmagerr | float |
stat.error phot.mag em.opt.B |
mag |
Estimated error on the calibrated B magnitude of the source |
| vmag | float |
phot.mag em.opt.V |
mag |
Calibrated V magnitude of the source |
| vmagerr | float |
stat.error phot.mag em.opt.V |
mag |
Estimated error on the calibrated V magnitude of the source |
| color_term | float | stat.fit.param |
Color term of the plate, characterizing color response of the emulsion and filter used |
|
| color_bv | float |
phot.color em.opt.B em.opt.V |
mag |
B-V color index of the source, based on the UCAC4 or Tycho-2 catalogue |
| 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) |
|
| nn_dist | float | pos.distance | arcsec |
Distance to the nearest neighbor among extracted sources |
| sextractor_flags | short | meta.code |
Flags given by SExtractor |
|
| pos | char | meta.number | (radians,radians) |
GIS index for (ra,dec) |
You can access this table using the query interface and download the results afterwards.
You can use the following DOI to cite this table in a publication:
This dataset is published under the CC0 1.0 Universal (CC0 1.0).