[ English | Japanese ]

Searchable Data with the DARTS/Astro Query System

Schema of Tables about GINGA

Satelite/Project Abstract of the data product Database table name
(Jump to description of table columns)
Number of entries in the database Searhcable with Basic Search Searchable with SQL/ADQL Search Name in the previous query system
GINGA Observation log of the Large Area Counter (LAC) onboard GINGA. ginga_observation_log 7,318 Yes Yes OBS
GINGA Light-curves of the 208 point sources produced by the All Sky Monitor (ASM) onboard GINGA. ginga_asm_1_2 208 Yes Yes -

ginga_observation_log

Observation log of the Large Area Counter (LAC) onboard GINGA.

No. Column Name Type Unit Description Former Column Name Former Type Former Unit
1 observation_id bigint Sequence number of the observation. The number begins with [yymm] where yy and mm is two-digit year and month, respectively, of the observation start. Last digit of the sequence number is 0 for a target observation and 9 for a background observation. SEQ_NO bigint(11)
2 object_name character varying(80) Target name. TARGET_NAME char(80)
3 center_ra_b1950 double precision degree Average coordinate of pointing direction, Right Ascension B1950. AVE_ALPHA double degree
4 center_dec_b1950 double precision degree Average coordinate of pointing direction, Declination B1950. AVE_DELTA double degree
5 center_ra double precision degree Average coordinate of pointing direction, Right Ascension J2000. Calculated from (center_ra_b1950, center_dec_b1950).
6 center_dec double precision degree Average coordinate of pointing direction, Declination J2000. Calculated from (center_ra_b1950, center_dec_b1950).
7 center_ecliptic_lon double precision degree Average coordinate of pointing direction, Ecliptic Longitude. Calculated from (center_ra_b1950, center_dec_b1950).
8 center_ecliptic_lat double precision degree Average coordinate of pointing direction, Ecliptic Latitude. Calculated from (center_ra_b1950, center_dec_b1950).
9 center_galactic_lon double precision degree Average coordinate of pointing direction, Galactic Longitude. Calculated from (center_ra_b1950, center_dec_b1950).
10 center_galactic_lat double precision degree Average coordinate of pointing direction, Galactic Latitude. Calculated from (center_ra_b1950, center_dec_b1950).
11 max_ra_b1950 double precision degree Maximum coordinate of the pointing direction, Right Ascension B1950. MAX_ALPHA double degree
12 max_dec_b1950 double precision degree Maximum coordinate of the pointing direction, Declination B1950. MAX_DELTA double degree
13 max_ra_J2000 double precision degree Maximum coordinate of the pointing direction, Right Ascension J2000. Calculated from (max_ra_b1950, max_dec_b1950).
14 max_dec_J2000 double precision degree Maximum coordinate of the pointing direction, Declination J2000. Calculated from (max_ra_b1950, max_dec_b1950).
15 max_ecliptic_lon double precision degree Maximum coordinate of the pointing direction, Ecliptic Longitude. Calculated from (max_ra_b1950, max_dec_b1950).
16 max_ecliptic_lat double precision degree Maximum coordinate of the pointing direction, Ecliptic Latitude. Calculated from (max_ra_b1950, max_dec_b1950).
17 max_galactic_lon double precision degree Maximum coordinate of the pointing direction, Galactic Longitude. Calculated from (max_ra_b1950, max_dec_b1950).
18 max_galactic_lat double precision degree Maximum coordinate of the pointing direction, Galactic Latitude. Calculated from (max_ra_b1950, max_dec_b1950).
19 min_ra_b1950 double precision degree Minimum coordinate of the pointing direction, Right Ascension B1950. MIN_ALPHA double degree
20 min_dec_b1950 double precision degree Minimum coordinate of the pointing direction, Declination B1950. MIN_DELTA double degree
21 min_ra_J2000 double precision degree Minimum coordinate of the pointing direction, Right Ascension J2000. Calculated from (min_ra_b1950, min_dec_b1950).
22 min_dec_J2000 double precision degree Minimum coordinate of the pointing direction, Declination J2000. Calculated from (min_ra_b1950, min_dec_b1950).
23 min_ecliptic_lon double precision degree Minimum coordinate of the pointing direction, Ecliptic Longitude. Calculated from (min_ra_b1950, min_dec_b1950).
24 min_ecliptic_lat double precision degree Minimum coordinate of the pointing direction, Ecliptic Latitude. Calculated from (min_ra_b1950, min_dec_b1950).
25 min_galactic_lon double precision degree Minimum coordinate of the pointing direction, Galactic Longitude. Calculated from (min_ra_b1950, min_dec_b1950).
26 min_galactic_lat double precision degree Minimum coordinate of the pointing direction, Galactic Latitude. Calculated from (min_ra_b1950, min_dec_b1950).
27 distance_from_observation_center double precision degree Distance between the target and poiting directions. RIKAKU double degree
28 observation_start_time timestamp without timezone UTC Start date of the observation in UTC. STARTTIME date UTC
29 observation_start_time_mjd double precision MJD Start date of the observation in MJD.
30 observation_end_time timestamp without timezone UTC End date of the observation in UTC. ENDTIME date UTC
31 observation_end_time_mjd double precision MJD End date of the observation in MJD.
32 exposure double precision ksec Duration of the pointing. POINTING double hour
33 orbit_pass_name character varying(255) Orbit pass name. PASSNAME char(80)
34 pi_name character varying(27) All records have "GINGA" in this column. PI_NAME char(27)
35 db_create_date double precision UTC UTC date when this database table was created. All records have "2004-06-25" in this column. ENTRY_DATE date UTC
36 db_create_date_mjd double precision MJD MJD date when this database table was created. All records have "53181" (="2004-06-25 in UTC") in this column.
37 data_access_url character varying(255) URL to the dataset

Scroll Back to Top ⏏

ginga_asm_1_2

Light-curves of the 208 point sources produced by the All Sky Monitor (ASM) onboard GINGA.

No. Column Name Type Unit Description
1 ql_image_url character varying(255) URL to the quick look image
2 object_ra double precision degree Source position, Right Ascension J2000. Calculated from (object_ra_b1950, object_dec_b1950).
3 object_dec double precision degree Source position, Declination B1950. Calculated from (object_ra_b1950, object_dec_b1950).
4 object_ra_b1950 double precision degree Source position, Right Ascension B1950.
5 object_dec_b1950 double precision degree Source position, Declination B1950.
6 object_ecliptic_lon double precision degree Source position, Ecliptic Longitude. Calculated from (object_ra_b1950, object_dec_b1950).
7 object_ecliptic_lat double precision degree Source position, Ecliptic Latitude. Calculated from (object_ra_b1950, object_dec_b1950).
8 object_galactic_lon double precision degree Source position, Galactic Longitude. Calculated from (object_ra_b1950, object_dec_b1950).
9 object_galactic_lat double precision degree The source position, Galactic Latitude. Calculated from (object_ra_b1950, object_dec_b1950).
10 observation_start_time timestamp without timezone UTC Start date of the observation in UTC.
11 observation_start_time_mjd double precision MJD Start date of the observation in MJD.
12 observation_end_time timestamp without timezone UTC End date of the observation in UTC.
13 observation_end_time_mjd double precision MJD End date of the observation in MJD.
14 data_access_url character varying(255) URL to the dataset

Scroll Back to Top ⏏

Last Modified: 28 August 2024