[ English | Japanese ]

Searchable Data with the DARTS/Astro Query System

Schema of Tables about XRISM

Satelite/Project Abstract of the data product Database table name Number of entries in the database Searhcable with Basic Search Searchable with SQL/ADQL Search
XRISM Observation logs and URL of observation data with XRISM. xrism_master_data Comming Soon Yes Yes
XRISM Description of the observations and URL of observation data by the Soft X-ray Spectrometer (Resolve) onboard XRISM, including the detector placements. xrism_resolve_data Comming Soon Yes Yes
XRISM Description of the observations and URL of observation data by the Soft X-ray Imager (Xtend) onboard XRISM, including the detector placements. xrism_xtend_data Comming Soon Yes Yes
XRISM Adopted Observation Proposals for XRISM xrism_proposal Comming Soon Yes Yes

xrism_master_data

Observation log of the XRISM observations.

No. Column Name Type Unit Description
1 observation_id character varying(11) The unique number to identify an observation/sequence. This is a 9-digit number.
2 object_name character varying(50) Designation of the Pointed Source. Observations that look at black sky have names related to the type of operations that occurred during that period.
3 center_ra double precision degree Nominal satellite pointing direction, Right Ascension J2000. Note that the pointing position can be different from the target position.
4 center_dec double precision degree Nominal satellite pointing direction, Declination J2000. Note that the pointing position can be different from the target position.
5 center_ra_b1950 double precision degree Nominal satellite pointing direction, Right Ascension B1950. Calculated from (center_ra, center_dec). Note that the pointing position can be different from the target position.
6 center_dec_b1950 double precision degree Nominal satellite pointing direction, Declination B1950. Calculated from (center_ra, center_dec). Note that the pointing position can be different from the target position.
7 center_ecliptic_lon double precision degree Nominal satellite pointing direction, Ecliptic Longitude. Calculated from (center_ra, center_dec). Note that the pointing position can be different from the target position.
8 center_ecliptic_lat double precision degree Nominal satellite pointing direction, Ecliptic Latitude. Calculated from (center_ra, center_dec). Note that the pointing position can be different from the target position.
9 center_galactic_lon double precision degree Nominal satellite pointing direction, Galactic Longitude. Note that the pointing position can be different from the target position.
10 center_galactic_lat double precision degree Nominal satellite pointing direction, Galactic Latitude. Note that the pointing position can be different from the target position.
11 roll_angle double precision degree Roll Angle
12 observation_start_time_mjd numeric(10,5) MJD Start Time of the Observation in MJD. If the sequence contains the incoming slew, the start time corresponds to the start of the incoming slew.
13 observation_start_time timestamp without time zone UTC Start Time of the Observation in UTC. If the sequence contains the incoming slew, the start time corresponds to the start of the incoming slew.
14 observation_end_time_mjd numeric(10,5) MJD Stop Time of the Observation in MJD. If the sequence contains the incoming slew, the start time corresponds to the start of the incoming slew.
15 observation_end_time timestamp without time zone UTC Stop Time of the Observation in UTC. If the sequence contains the incoming slew, the start time corresponds to the start of the incoming slew.
16 exposure numeric(6,3) ksec Effective total observation exposure (ks).
17 awarded_exposure numeric(6,3) ksec Accepted observation exposure (ks)
18 resolve_exposure numeric(6,3) ksec Effective exposure (ks) on source for the Resolve.
19 xtend_exposure numeric(6,3) ksec Effective exposure (ks) on source for the Xtend.
20 resolve_data_mode character varying(10) Resolve Datamode
21 resolve_with_filter_be character varying(1) Flag [YN] indicates Resolve observation was collected with Be filter on.
22 resolve_with_filter_fe55 character varying(1) Flag [YN] indicates Resolve observation was collected with Fe55 filter on.
23 resolve_with_filter_nd character varying(1) Flag [YN] indicates Resolve observation was collecter with ND25 filter on.
24 resolve_with_filter_poly character varying(1) Flag [YN] indicates Resolve observation was collecter with POLYMIDE filter on.
25 resolve_with_filter_open character varying(1) Flag [YN] indicates Resolve observation was collected with OPEN1 or OPEN2 filter on.
26 resolve_with_filter_undef character varying(1) Flag [YN] indicates Resolve observation was collecter with UNDEF filter on.
27 is_resolve_gatevalve_closed character varying(6) Flag [OPEN, CLOSE] indicates Resolve Gatevalve
28 is_resolve_mxs1 character varying(10) Flag [OFF, STANDBY, DIM, MEDIUM, BRIGHT] indicates Resolve MXS source 1 status.
29 is_resolve_mxs2 character varying(10) Flag [OFF, STANDBY, DIM, MEDIUM, BRIGHT] indicates Resolve MXS source 2 status.
30 is_resolve_mxs3 character varying(10) Flag [OFF, STANDBY, DIM, MEDIUM, BRIGHT] indicates Resolve MXS source 3 status.
31 is_resolve_mxs4 character varying(10) Flag [OFF, STANDBY, DIM, MEDIUM, BRIGHT] indicates Resolve MXS source 4 status.
32 xtend_number_modes smallint Xtend number of mode.
33 xtend_dataclass_file1 character varying(10) The data class for Xtend first second data mode. The following 32-bit data class is represented by AAAAAAAAAh converted in HEX. 0-3 bit: Definition version of data class. The following is the definition of 1000b for nominal observation. 4-5 bit: data mode (0: All CCD 1: CCD12 2: CCD34). 6-7 bit: Reserved. 8 bit: Window size (0: full, 1: 1/8). 9 bit: Burst (0: off, 1: on). 10 bit: bright mode (0: w/o area discrimination 1: w/ AD for bight source mode). 11bit: charge injection (0: CI on, 1 CI off). 12-27 bit: other settings (evth, spth, area, discri., ADC setting, readnode, DarkTh, HotPixTh, HOCSUMskip, etc. It is managed in a separate table). 28-31 bit: Reserved.
34 xtend_dataclass_file2 character varying(10) The data class for Xtend second data mode. The following 32-bit data class is represented by AAAAAAAAAh converted in HEX. 0-3 bit: Definition version of data class. The following is the definition of 1000b for nominal observation. 4-5 bit: data mode (0: All CCD 1: CCD12 2: CCD34). 6-7 bit: Reserved. 8 bit: Window size (0: full, 1: 1/8). 9 bit: Burst (0: off, 1: on). 10 bit: bright mode (0: w/o area discrimination 1: w/ AD for bight source mode). 11bit: charge injection (0: CI on, 1 CI off). 12-27 bit: other settings (evth, spth, area, discri., ADC setting, readnode, DarkTh, HotPixTh, HOCSUMskip, etc. It is managed in a separate table). 28-31 bit: Reserved.
35 xtend_window1_exposure numeric(6,3) ksec Xtend window1 exposure in kilo-seconds calculated using the GTI from the cleaned event file where the DATAMODE keyword is set to window1. Set to 0 if Xtend is not operating in window1 mode.
36 xtend_window2_exposure numeric(6,3) ksec Xtend window2 exposure in kilo-seconds calculated using the GTI from the cleaned event file where the DATAMODE keyword is set to window1. Set to 0 if Xtend is not operating in window2 mode.
37 xtend_window1_burst_exposure numeric(6,3) ksec Xtend window1 burst exposure in kilo-seconds calculated using the GTI from the cleaned event file where the DATAMODE keyword is set to window1. Set to 0 if Xtend is not operating in window1 mode.
38 xtend_window2_burst_exposure numeric(6,3) ksec Xtend window2 burst exposure in kilo-seconds calculated using the GTI from the cleaned event file where the DATAMODE keyword is set to window2. Set to 0 if Xtend is not operating in window2 mode.
39 xtend_code character varying(6) Five-digit number, ABCDE, to identify the type of data present for the Xtend. The value A=1 indicates if the Xtend science data are present. The value B=1 indicates if the Xtend exposure is present. The value C=1 indicates if Xtend HK is present and D=1 if the hot pixel table is present. E is not used and set to 0.
40 resolve_code character varying(6) Five-digit number, ABCDE, to identify the type of data present for the Resolve. The values for A indicate if the Resolve science data are present: A=1 only Resolve pixel data, A=2 only the Resolve antico data, A=3 both are present. The value B=1 indicates if the Resolve lost GTIs are present. The values for C indicate if the Resolve housekeeping data are present: C=1 means only Resolve HK1 data, C=2 means only the Resolve HK2 data, and C=3 means both HK1 and HK2 are present. The value for D indicates if other diagnostic data associated with the pixel array: D=1 for noise data, D=2 for pulse data, D=3 for wfrb, D=4 all, D=5 for noise and wfrb, D=6 for noise and pulse, and D= 7 for wfrb and pulse. The value for E indicates if other diagnostic data associated with the antico array: E=1 for noise data, E=2 for wfrb, E=3 for both.
41 gen_code character varying(6) Five-digit number, ABCDE, to identify the general auxiliary type of data present in the observation. The value A=1 indicates if the attitude data are present. The value B=1 indicates if the orbit data are present. The value of C is for the HK: C=1 for the HK1, C=2 for the HK2 and C=3 for both. The value D=1 indicates if the time file is present. E is not used and set to 0.
42 processing_status character varying(24) Data processing status [PROCESSED or NOTPROCESSED]
43 processing_date timestamp without time zone UTC Date of data processing in UTC
44 public_date timestamp without time zone UTC Date when the data became public in UTC
45 distribution_date timestamp without time zone UTC Date when the data were first distributed to the SWG in UTC
46 processing_version character varying(15) Version of processing script
47 caldb_version character varying(40) Version of CALDB Hitomi version for each of the instrument and used in the processing pipeline. The version is encoded as genYYYYMMDD_rslYYYMMDD_xtdYYYYMMDD. The date corresponds to the date to when the CALDB index was created.
48 processing_software character varying(80) Version of the HEAsoft and Hitomi software used in the processing pipeline to generate the data products of the observation.
49 proposal_id character varying(11) Proposal Number
50 proposal_abstract character varying(800) Full abstract?
51 proposal_category character varying(60) Proposal category The following are the possible subject categories: non-pointing data; calibration; galactic point sources; galactic diffuse emission; extragalactic compact sources; extragalactic diffuse sources; Gamma-ray bursts and other non-proposed TOOs.
52 proposal_category_code smallint Category code. 0=non-pointing data; 1=calibration; 4=galactic point sources; 5=galactic diffuse emission; 7=extragalactic compact sources; 8=extragalactic diffuse sources; 9=Gamma-ray bursts and other non-proposed TOOs.
53 proposal_priority character varying(5) Target observing priority
54 pi_name character varying(61) Proposal Principal Investigator (PI) name
55 co_pi_name character varying(61) Proposal Co-PI name
56 proposal_affiliated_country character varying(30) Proposal Principal Investigator (PI) country or collaboration
57 proposal_cycle integer XRISM observing Cycle (0 for pre-GO data).
58 proposal_type character varying(10) Proposal type, with allowed values of NOR / NOR-TOO (normal, normal TOO), LAR/ LAR-TOO (large, large TOO), KEY / KEY-TOO (key, key TOO), CAL / CAL-TOO (calibration, calibration TOO), DDT / DDT-TOO (Director's Discretionary Time, Director's Discretionary Time TOO).
59 proposal_title character varying(120) Proposal title
60 observation_status character varying(15) The present status of the observation: unobserved, scheduled, observed, processed, or archived.
61 data_access_url character varying(255) URL used to access dataset
62 xtend_data_mode1 character varying(15) Xtend Datamode1
63 xtend_data_mode2 character varying(15) Xtend Datamode2
64 processing_count smallserial Number of Times Sequence Has Been Processed
65 remarks character varying(300) Remarks

Scroll Back to Top ⏏

xrism_resolve_data

Description of the observations by the Soft X-ray Spectrometer (Resolve) onboard XRISM, including the detector placements.

No. Column Name Type Unit Description
1 observation_id character varying(11) The unique number to identify an observation/sequence. This is a 9-digit number.
2 object_name character varying(50) Designation of the Pointed Source. Observations that look at black sky have names related to the type of operations that occurred during that period.
3 center_ra double precision degree Nominal satellite pointing direction, Right Ascension J2000. Note that the pointing position can be different from the target position.
4 center_dec double precision degree Nominal satellite pointing direction, Declination J2000. Note that the pointing position can be different from the target position.
5 center_ra_b1950 double precision degree Nominal satellite pointing direction, Right Ascension B1950. Calculated from (center_ra, center_dec). Note that the pointing position can be different from the target position.
6 center_dec_b1950 double precision degree Nominal satellite pointing direction, Declination B1950. Calculated from (center_ra, center_dec). Note that the pointing position can be different from the target position.
7 center_ecliptic_lon double precision degree Nominal satellite pointing direction, Ecliptic Longitude. Calculated from (center_ra, center_dec). Note that the pointing position can be different from the target position.
8 center_ecliptic_lat double precision degree Nominal satellite pointing direction, Ecliptic Latitude. Calculated from (center_ra, center_dec). Note that the pointing position can be different from the target position.
9 center_galactic_lon double precision degree Nominal satellite pointing direction, Galactic Longitude. Note that the pointing position can be different from the target position.
10 center_galactic_lat double precision degree Nominal satellite pointing direction, Galactic Latitude. Note that the pointing position can be different from the target position.
11 roll_angle double precision degree Roll Angle
12 observation_start_time_mjd numeric(10,5) MJD Start Time of the Observation in MJD. If the sequence contains the incoming slew, the start time corresponds to the start of the incoming slew.
13 observation_start_time timestamp without time zone UTC Start Time of the Observation in UTC. If the sequence contains the incoming slew, the start time corresponds to the start of the incoming slew.
14 observation_end_time_mjd numeric(10,5) MJD Stop Time of the Observation in MJD. If the sequence contains the incoming slew, the start time corresponds to the start of the incoming slew.
15 observation_end_time timestamp without time zone UTC Stop Time of the Observation in UTC. If the sequence contains the incoming slew, the start time corresponds to the start of the incoming slew.
16 exposure numeric(6,3) ks Effective total observation exposure (ks).
17 awarded_exposure numeric(6,3) ks ks
18 resolve_exposure numeric(6,3) ks Effective exposure (ks) on source for the Resolve.
19 resolve_data_mode character varying(10) Resolve Datamode
20 resolve_with_filter_be character varying(1) Flag [YN] indicates Resolve observation was collected with Be filter on.
21 resolve_with_filter_fe55 character varying(1) Flag [YN] indicates Resolve observation was collected with Fe55 filter on.
22 resolve_with_filter_nd character varying(1) Flag [YN] indicates Resolve observation was collecter with ND25 filter on.
23 resolve_with_filter_poly character varying(1) Flag [YN] indicates Resolve observation was collecter with POLYMIDE filter on.
24 resolve_with_filter_open character varying(1) Flag [YN] indicates Resolve observation was collected with OPEN1 or OPEN2 filter on.
25 resolve_with_filter_undef character varying(1) Flag [YN] indicates Resolve observation was collecter with UNDEF filter on.
26 is_resolve_gatevalve_closed character varying(6) Flag [OPEN, CLOSE] indicates Resolve Gatevalve
27 is_resolve_mxs1 character varying(10) Flag [OFF, STANDBY, DIM, MEDIUM, BRIGHT] indicates Resolve MXS source 1 status.
28 is_resolve_mxs2 character varying(10) Flag [OFF, STANDBY, DIM, MEDIUM, BRIGHT] indicates Resolve MXS source 2 status.
29 is_resolve_mxs3 character varying(10) Flag [OFF, STANDBY, DIM, MEDIUM, BRIGHT] indicates Resolve MXS source 3 status.
30 is_resolve_mxs4 character varying(10) Flag [OFF, STANDBY, DIM, MEDIUM, BRIGHT] indicates Resolve MXS source 4 status.
31 resolve_code character varying(6) Five-digit number, ABCDE, to identify the type of data present for the Resolve. The values for A indicate if the Resolve science data are present: A=1 only Resolve pixel data, A=2 only the Resolve antico data, A=3 both are present. The value B=1 indicates if the Resolve lost GTIs are present. The values for C indicate if the Resolve housekeeping data are present: C=1 means only Resolve HK1 data, C=2 means only the Resolve HK2 data, and C=3 means both HK1 and HK2 are present. The value for D indicates if other diagnostic data associated with the pixel array: D=1 for noise data, D=2 for pulse data, D=3 for wfrb, D=4 all, D=5 for noise and wfrb, D=6 for noise and pulse, and D= 7 for wfrb and pulse. The value for E indicates if other diagnostic data associated with the antico array: E=1 for noise data, E=2 for wfrb, E=3 for both.
32 gen_code character varying(6) Five-digit number, ABCDE, to identify the general auxiliary type of data present in the observation. The value A=1 indicates if the attitude data are present. The value B=1 indicates if the orbit data are present. The value of C is for the HK: C=1 for the HK1, C=2 for the HK2 and C=3 for both. The value D=1 indicates if the time file is present. E is not used and set to 0.
33 processing_status character varying(24) Data processing status [PROCESSED or NOTPROCESSED]
34 processing_date timestamp without time zone UTC Date of data processing in UTC
35 public_date timestamp without time zone UTC Date when the data became public in UTC
36 distribution_date timestamp without time zone UTC Date when the data were first distributed to the SWG in UTC
37 processing_version character varying(15) Version of processing script
38 caldb_version character varying(40) Version of CALDB Hitomi version for each of the instrument and used in the processing pipeline. The version is encoded as genYYYYMMDD_rslYYYMMDD_xtdYYYYMMDD. The date corresponds to the date to when the CALDB index was created.
39 processing_software character varying(80) Version of the HEAsoft and Hitomi software used in the processing pipeline to generate the data products of the observation.
40 proposal_id character varying(11) Proposal Number
41 proposal_abstract character varying(800) Full abstract?
42 proposal_category character varying(60) Proposal category The following are the possible subject categories: non-pointing data; calibration; galactic point sources; galactic diffuse emission; extragalactic compact sources; extragalactic diffuse sources; Gamma-ray bursts and other non-proposed TOOs.
43 proposal_category_code smallint Category code. 0=non-pointing data; 1=calibration; 4=galactic point sources; 5=galactic diffuse emission; 7=extragalactic compact sources; 8=extragalactic diffuse sources; 9=Gamma-ray bursts and other non-proposed TOOs.
44 proposal_priority character varying(5) Target observing priority
45 pi_name character varying(61) Proposal Principal Investigator (PI) name
46 co_pi_name character varying(61) Proposal Co-PI name
47 proposal_affiliated_country character varying(30) Proposal Principal Investigator (PI) country or collaboration
48 proposal_cycle integer XRISM observing Cycle (0 for pre-GO data).
49 proposal_type character varying(10) Proposal type, with allowed values of NOR / NOR-TOO (normal, normal TOO), LAR/ LAR-TOO (large, large TOO), KEY / KEY-TOO (key, key TOO), CAL / CAL-TOO (calibration, calibration TOO), DDT / DDT-TOO (Director's Discretionary Time, Director's Discretionary Time TOO).
50 proposal_title character varying(120) Proposal title
51 observation_status character varying(15) The present status of the observation: unobserved, scheduled, observed, processed, or archived.
52 data_access_url character varying(255) URL used to the dataset
53 ql_access_url character varying(255) URL to the observation information page
54 ql_image_url character varying(255) URL to the quick look image
55 corner1_ra double precision degree Coordinate of the vertex1 of the Resolve observation field of view, Right Ascension J2000.
56 corner1_dec double precision degree Coordinate of the vertex1 of the Resolve observation field of view, Declination J2000.
57 corner2_ra double precision degree Coordinate of the vertex2 of the Resolve observation field of view, Right Ascension J2000.
58 corner2_dec double precision degree Coordinate of the vertex2 of the Resolve observation field of view, Declination J2000.
59 corner3_ra double precision degree Coordinate of the vertex3 of the Resolve observation field of view, Right Ascension J2000.
60 corner3_dec double precision degree Coordinate of the vertex3 of the Resolve observation field of view, Declination J2000.
61 corner4_ra double precision degree Coordinate of the vertex4 of the Resolve observation field of view, Right Ascension J2000.
62 corner4_dec double precision degree Coordinate of the vertex4 of the Resolve observation field of view, Declination J2000.
63 corner5_ra double precision degree Coordinate of the vertex5 of the Resolve observation field of view, Right Ascension J2000.
64 corner5_dec double precision degree Coordinate of the vertex5 of the Resolve observation field of view, Declination J2000.
65 corner6_ra double precision degree Coordinate of the vertex6 of the Resolve observation field of view, Right Ascension J2000.
66 corner6_dec double precision degree Coordinate of the vertex6 of the Resolve observation field of view, Declination J2000.
67 corner1_ra_b1950 double precision degree Coordinate of the vertex1 of the Resolve observation field of view, Right Ascension B1950.
68 corner1_dec_b1950 double precision degree Coordinate of the vertex1 of the Resolve observation field of view, Declination B1950.
69 corner2_ra_b1950 double precision degree Coordinate of the vertex2 of the Resolve observation field of view, Right Ascension B1950.
70 corner2_dec_b1950 double precision degree Coordinate of the vertex2 of the Resolve observation field of view, Declination B1950.
71 corner3_ra_b1950 double precision degree Coordinate of the vertex3 of the Resolve observation field of view, Right Ascension B1950.
72 corner3_dec_b1950 double precision degree Coordinate of the vertex3 of the Resolve observation field of view, Declination B1950.
73 corner4_ra_b1950 double precision degree Coordinate of the vertex4 of the Resolve observation field of view, Right Ascension B1950.
74 corner4_dec_b1950 double precision degree Coordinate of the vertex4 of the Resolve observation field of view, Declination B1950.
75 corner5_ra_b1950 double precision degree Coordinate of the vertex5 of the Resolve observation field of view, Right Ascension B1950.
76 corner5_dec_b1950 double precision degree Coordinate of the vertex5 of the Resolve observation field of view, Declination B1950.
77 corner6_ra_b1950 double precision degree Coordinate of the vertex6 of the Resolve observation field of view, Right Ascension B1950.
78 corner6_dec_b1950 double precision degree Coordinate of the vertex6 of the Resolve observation field of view, Declination B1950.
79 corner1_ecliptic_lon double precision degree Coordinate of the vertex1 of the Resolve observation field of view, Ecliptic Longitude.
80 corner1_ecliptic_lat double precision degree Coordinate of the vertex1 of the Resolve observation field of view, Ecliptic Latitude.
81 corner2_ecliptic_lon double precision degree Coordinate of the vertex2 of the Resolve observation field of view, Ecliptic Longitude.
82 corner2_ecliptic_lat double precision degree Coordinate of the vertex2 of the Resolve observation field of view, Ecliptic Latitude.
83 corner3_ecliptic_lon double precision degree Coordinate of the vertex3 of the Resolve observation field of view, Ecliptic Longitude.
84 corner3_ecliptic_lat double precision degree Coordinate of the vertex3 of the Resolve observation field of view, Ecliptic Latitude.
85 corner4_ecliptic_lon double precision degree Coordinate of the vertex4 of the Resolve observation field of view, Ecliptic Longitude.
86 corner4_ecliptic_lat double precision degree Coordinate of the vertex4 of the Resolve observation field of view, Ecliptic Latitude.
87 corner5_ecliptic_lon double precision degree Coordinate of the vertex5 of the Resolve observation field of view, Ecliptic Longitude.
88 corner5_ecliptic_lat double precision degree Coordinate of the vertex5 of the Resolve observation field of view, Ecliptic Latitude.
89 corner6_ecliptic_lon double precision degree Coordinate of the vertex6 of the Resolve observation field of view, Ecliptic Longitude.
90 corner6_ecliptic_lat double precision degree Coordinate of the vertex6 of the Resolve observation field of view, Ecliptic Latitude.
91 corner1_galactic_lon double precision degree Coordinate of the vertex1 of the Resolve observation field of view, Galactic Longitude.
92 corner1_galactic_lat double precision degree Coordinate of the vertex1 of the Resolve observation field of view, Galactic Latitude.
93 corner2_galactic_lon double precision degree Coordinate of the vertex2 of the Resolve observation field of view, Galactic Longitude.
94 corner2_galactic_lat double precision degree Coordinate of the vertex2 of the Resolve observation field of view, Galactic Latitude.
95 corner3_galactic_lon double precision degree Coordinate of the vertex3 of the Resolve observation field of view, Galactic Longitude.
96 corner3_galactic_lat double precision degree Coordinate of the vertex3 of the Resolve observation field of view, Galactic Latitude.
97 corner4_galactic_lon double precision degree Coordinate of the vertex4 of the Resolve observation field of view, Galactic Longitude.
98 corner4_galactic_lat double precision degree Coordinate of the vertex4 of the Resolve observation field of view, Galactic Latitude.
99 corner5_galactic_lon double precision degree Coordinate of the vertex5 of the Resolve observation field of view, Galactic Longitude.
100 corner5_galactic_lat double precision degree Coordinate of the vertex5 of the Resolve observation field of view, Galactic Latitude.
101 corner6_galactic_lon double precision degree Coordinate of the vertex6 of the Resolve observation field of view, Galactic Longitude.
102 corner6_galactic_lat double precision degree Coordinate of the vertex6 of the Resolve observation field of view, Galactic Latitude.
103 resolve_adr_mode character varying(12) Resolve ADR Mode
104 resolve_thr_name character varying(10) Resolve Version Name of Pulse Thresholds
105 resolve_shp_date timestamp without time zone UTC Resolve Version Name of Pulse-shape Templates (YYYYMMDD)

Scroll Back to Top ⏏

xrism_xtend_data

Description of the observations by the Soft X-ray Imager (Xtend) onboard XRISM, including the detector placements.

No. Column Name Type Unit Description
1 observation_id character varying(11) The unique number to identify an observation/sequence. This is a 9-digit number.
2 object_name character varying(50) Designation of the Pointed Source. Observations that look at black sky have names related to the type of operations that occurred during that period.
3 center_ra double precision degree Nominal satellite pointing direction, Right Ascension J2000. Note that the pointing position can be different from the target position.
4 center_dec double precision degree Nominal satellite pointing direction, Declination J2000. Note that the pointing position can be different from the target position.
5 center_ra_b1950 double precision degree Nominal satellite pointing direction, Right Ascension B1950. Calculated from (center_ra, center_dec). Note that the pointing position can be different from the target position.
6 center_dec_b1950 double precision degree Nominal satellite pointing direction, Declination B1950. Calculated from (center_ra, center_dec). Note that the pointing position can be different from the target position.
7 center_ecliptic_lon double precision degree Nominal satellite pointing direction, Ecliptic Longitude. Calculated from (center_ra, center_dec). Note that the pointing position can be different from the target position.
8 center_ecliptic_lat double precision degree Nominal satellite pointing direction, Ecliptic Latitude. Calculated from (center_ra, center_dec). Note that the pointing position can be different from the target position.
9 center_galactic_lon double precision degree Nominal satellite pointing direction, Galactic Longitude. Note that the pointing position can be different from the target position.
10 center_galactic_lat double precision degree Nominal satellite pointing direction, Galactic Latitude. Note that the pointing position can be different from the target position.
11 roll_angle double precision degree Roll Angle
12 observation_start_time_mjd numeric(10,5) MJD Start Time of the Observation in MJD. If the sequence contains the incoming slew, the start time corresponds to the start of the incoming slew.
13 observation_start_time timestamp without time zone UTC Start Time of the Observation in UTC. If the sequence contains the incoming slew, the start time corresponds to the start of the incoming slew.
14 observation_end_time_mjd numeric(10,5) MJD Stop Time of the Observation in MJD. If the sequence contains the incoming slew, the start time corresponds to the start of the incoming slew.
15 observation_end_time timestamp without time zone UTC Stop Time of the Observation in UTC. If the sequence contains the incoming slew, the start time corresponds to the start of the incoming slew.
16 exposure numeric(6,3) ks Effective total observation exposure (ks).
17 awarded_exposure numeric(6,3) ks Accepted observation exposure (ks)
18 xtend_exposure numeric(6,3) ks Effective exposure (ks) on source for the Xtend.
19 xtend_number_modes smallint Xtend number of mode.
20 xtend_dataclass_file1 character varying(10) The data class for Xtend first second data mode. The following 32-bit data class is represented by AAAAAAAAAh converted in HEX. 0-3 bit: Definition version of data class. The following is the definition of 1000b for nominal observation. 4-5 bit: data mode (0: All CCD 1: CCD12 2: CCD34). 6-7 bit: Reserved. 8 bit: Window size (0: full, 1: 1/8). 9 bit: Burst (0: off, 1: on). 10 bit: bright mode (0: w/o area discrimination 1: w/ AD for bight source mode). 11bit: charge injection (0: CI on, 1 CI off). 12-27 bit: other settings (evth, spth, area, discri., ADC setting, readnode, DarkTh, HotPixTh, HOCSUMskip, etc. It is managed in a separate table). 28-31 bit: Reserved.
21 xtend_dataclass_file2 character varying(10) The data class for Xtend second data mode. The following 32-bit data class is represented by AAAAAAAAAh converted in HEX. 0-3 bit: Definition version of data class. The following is the definition of 1000b for nominal observation. 4-5 bit: data mode (0: All CCD 1: CCD12 2: CCD34). 6-7 bit: Reserved. 8 bit: Window size (0: full, 1: 1/8). 9 bit: Burst (0: off, 1: on). 10 bit: bright mode (0: w/o area discrimination 1: w/ AD for bight source mode). 11bit: charge injection (0: CI on, 1 CI off). 12-27 bit: other settings (evth, spth, area, discri., ADC setting, readnode, DarkTh, HotPixTh, HOCSUMskip, etc. It is managed in a separate table). 28-31 bit: Reserved.
22 xtend_window1_exposure numeric(6,3) ks Xtend window1 exposure in kilo-seconds calculated using the GTI from the cleaned event file where the DATAMODE keyword is set to window1. Set to 0 if Xtend is not operating in window1 mode.
23 xtend_window2_exposure numeric(6,3) ks Xtend window2 exposure in kilo-seconds calculated using the GTI from the cleaned event file where the DATAMODE keyword is set to window1. Set to 0 if Xtend is not operating in window2 mode.
24 xtend_window1_burst_exposure numeric(6,3) ks Xtend window1 burst exposure in kilo-seconds calculated using the GTI from the cleaned event file where the DATAMODE keyword is set to window1. Set to 0 if Xtend is not operating in window1 mode.
25 xtend_window2_burst_exposure numeric(6,3) ks Xtend window2 burst exposure in kilo-seconds calculated using the GTI from the cleaned event file where the DATAMODE keyword is set to window2. Set to 0 if Xtend is not operating in window2 mode.
26 xtend_code character varying(6) Five-digit number, ABCDE, to identify the type of data present for the Xtend. The value A=1 indicates if the Xtend science data are present. The value B=1 indicates if the Xtend exposure is present. The value C=1 indicates if Xtend HK is present and D=1 if the hot pixel table is present. E is not used and set to 0.
27 gen_code character varying(6) Five-digit number, ABCDE, to identify the general auxiliary type of data present in the observation. The value A=1 indicates if the attitude data are present. The value B=1 indicates if the orbit data are present. The value of C is for the HK: C=1 for the HK1, C=2 for the HK2 and C=3 for both. The value D=1 indicates if the time file is present. E is not used and set to 0.
28 processing_status character varying(24) Data processing status [PROCESSED or NOTPROCESSED]
29 processing_date timestamp without time zone UTC Date of data processing in UTC
30 public_date timestamp without time zone UTC Date when the data became public in UTC
31 distribution_date timestamp without time zone UTC Date when the data were first distributed to the SWG in UTC
32 processing_version character varying(15) Version of processing script
33 caldb_version character varying(40) Version of CALDB Hitomi version for each of the instrument and used in the processing pipeline. The version is encoded as genYYYYMMDD_rslYYYMMDD_xtdYYYYMMDD. The date corresponds to the date to when the CALDB index was created.
34 processing_software character varying(80) Version of the HEAsoft and Hitomi software used in the processing pipeline to generate the data products of the observation.
35 proposal_id character varying(11) Proposal Number
36 proposal_abstract character varying(800) Full abstract?
37 proposal_category character varying(60) Proposal category The following are the possible subject categories: non-pointing data; calibration; galactic point sources; galactic diffuse emission; extragalactic compact sources; extragalactic diffuse sources; Gamma-ray bursts and other non-proposed TOOs.
38 proposal_category_code smallint Category code. 0=non-pointing data; 1=calibration; 4=galactic point sources; 5=galactic diffuse emission; 7=extragalactic compact sources; 8=extragalactic diffuse sources; 9=Gamma-ray bursts and other non-proposed TOOs.
39 proposal_priority character varying(5) Target observing priority
40 pi_name character varying(61) Proposal Principal Investigator (PI) name
41 co_pi_name character varying(61) Proposal Co-PI name
42 proposal_affiliated_country character varying(30) Proposal Principal Investigator (PI) country or collaboration
43 proposal_cycle integer XRISM observing Cycle (0 for pre-GO data).
44 proposal_type character varying(10) Proposal type, with allowed values of NOR / NOR-TOO (normal, normal TOO), LAR/ LAR-TOO (large, large TOO), KEY / KEY-TOO (key, key TOO), CAL / CAL-TOO (calibration, calibration TOO), DDT / DDT-TOO (Director's Discretionary Time, Director's Discretionary Time TOO).
45 proposal_title character varying(120) Proposal title
46 observation_status character varying(15) The present status of the observation: unobserved, scheduled, observed, processed, or archived.
47 data_access_url character varying(255) URL used to the dataset
48 ql_access_url character varying(255) URL to the observation information page
49 ql_image_url character varying(255) URL to the quick look image
50 corner1_ra double precision degree Coordinate of the vertex1 of the Xtend observation field of view, Right Ascension J2000.
51 corner1_dec double precision degree Coordinate of the vertex1 of the Xtend observation field of view, Declination J2000.
52 corner2_ra double precision degree Coordinate of the vertex2 of the Xtend observation field of view, Right Ascension J2000.
53 corner2_dec double precision degree Coordinate of the vertex2 of the Xtend observation field of view, Declination J2000.
54 corner3_ra double precision degree Coordinate of the vertex3 of the Xtend observation field of view, Right Ascension J2000.
55 corner3_dec double precision degree Coordinate of the vertex3 of the Xtend observation field of view, Declination J2000.
56 corner4_ra double precision degree Coordinate of the vertex4 of the Xtend observation field of view, Right Ascension J2000.
57 corner4_dec double precision degree Coordinate of the vertex4 of the Xtend observation field of view, Declination J2000.
58 corner1_ra_b1950 double precision degree Coordinate of the vertex1 of the Xtend observation field of view, Right Ascension B1950.
59 corner1_dec_b1950 double precision degree Coordinate of the vertex1 of the Xtend observation field of view, Declination B1950.
60 corner2_ra_b1950 double precision degree Coordinate of the vertex2 of the Xtend observation field of view, Right Ascension B1950.
61 corner2_dec_b1950 double precision degree Coordinate of the vertex2 of the Xtend observation field of view, Declination B1950.
62 corner3_ra_b1950 double precision degree Coordinate of the vertex3 of the Xtend observation field of view, Right Ascension B1950.
63 corner3_dec_b1950 double precision degree Coordinate of the vertex3 of the Xtend observation field of view, Declination B1950.
64 corner4_ra_b1950 double precision degree Coordinate of the vertex4 of the Xtend observation field of view, Right Ascension B1950.
65 corner4_dec_b1950 double precision degree Coordinate of the vertex4 of the Xtend observation field of view, Declination B1950.
66 corner1_ecliptic_lon double precision degree Coordinate of the vertex1 of the Xtend observation field of view, Ecliptic Longitude.
67 corner1_ecliptic_lat double precision degree Coordinate of the vertex1 of the Xtend observation field of view, Ecliptic Latitude.
68 corner2_ecliptic_lon double precision degree Coordinate of the vertex2 of the Xtend observation field of view, Ecliptic Longitude.
69 corner2_ecliptic_lat double precision degree Coordinate of the vertex2 of the Xtend observation field of view, Ecliptic Latitude.
70 corner3_ecliptic_lon double precision degree Coordinate of the vertex3 of the Xtend observation field of view, Ecliptic Longitude.
71 corner3_ecliptic_lat double precision degree Coordinate of the vertex3 of the Xtend observation field of view, Ecliptic Latitude.
72 corner4_ecliptic_lon double precision degree Coordinate of the vertex4 of the Xtend observation field of view, Ecliptic Longitude.
73 corner4_ecliptic_lat double precision degree Coordinate of the vertex4 of the Xtend observation field of view, Ecliptic Latitude.
74 corner1_galactic_lon double precision degree Coordinate of the vertex1 of the Xtend observation field of view, Galactic Longitude.
75 corner1_galactic_lat double precision degree Coordinate of the vertex1 of the Xtend observation field of view, Galactic Latitude.
76 corner2_galactic_lon double precision degree Coordinate of the vertex2 of the Xtend observation field of view, Galactic Longitude.
77 corner2_galactic_lat double precision degree Coordinate of the vertex2 of the Xtend observation field of view, Galactic Latitude.
78 corner3_galactic_lon double precision degree Coordinate of the vertex3 of the Xtend observation field of view, Galactic Longitude.
79 corner3_galactic_lat double precision degree Coordinate of the vertex3 of the Xtend observation field of view, Galactic Latitude.
80 corner4_galactic_lon double precision degree Coordinate of the vertex4 of the Xtend observation field of view, Galactic Longitude.
81 corner4_galactic_lat double precision degree Coordinate of the vertex4 of the Xtend observation field of view, Galactic Latitude.
82 xtend_data_mode1 character varying(15) Xtend Datamode1
83 xtend_data_mode2 character varying(15) Xtend Datamode2

Scroll Back to Top ⏏

xrism_proposal

Adopted Observation Proposals for XRISM

No. Column Name Type Unit Description
1 object_id_in_proposal character varying(12) The unique number to identify an observation target across all observations. proposal_id + "_" + Object ID assigned to each observation proposal
2 proposal_id character varying(11) The proposal number. This is a 9-digit number.
3 object_name character varying(50) Designation of the Pointed Source. Observations that look at black sky have names related to the type of operations that occurred during that period.
4 center_ra double precision degree Nominal satellite pointing direction, Right Ascension J2000. Note that the pointing position can be different from the target position.
5 center_dec double precision degree Nominal satellite pointing direction, Declination J2000. Note that the pointing position can be different from the target position.
6 center_ra_b1950 double precision degree Nominal satellite pointing direction, Right Ascension B1950. Calculated from (center_ra, center_dec). Note that the pointing position can be different from the target position.
7 center_dec_b1950 double precision degree Nominal satellite pointing direction, Declination B1950. Calculated from (center_ra, center_dec). Note that the pointing position can be different from the target position.
8 center_ecliptic_lon double precision degree Nominal satellite pointing direction, Ecliptic Longitude. Calculated from (center_ra, center_dec). Note that the pointing position can be different from the target position.
9 center_ecliptic_lat double precision degree Nominal satellite pointing direction, Ecliptic Latitude. Calculated from (center_ra, center_dec). Note that the pointing position can be different from the target position.
10 center_galactic_lon double precision degree Nominal satellite pointing direction, Galactic Longitude. Note that the pointing position can be different from the target position.
11 center_galactic_lat double precision degree Nominal satellite pointing direction, Galactic Latitude. Note that the pointing position can be different from the target position.
12 is_too character varying(1) Flag [Y/N] of ToO proposal.
13 proposal_type character varying(10) Proposal type, with allowed values of NOR / NOR-TOO (normal, normal TOO), LAR/ LAR-TOO (large, large TOO), KEY / KEY-TOO (key, key TOO), CAL / CAL-TOO (calibration, calibration TOO), DDT / DDT-TOO (Director's Discretionary Time, Director's Discretionary Time TOO).
14 proposal_cycle integer XRISM observing Cycle (0 for pre-GO data).
15 proposal_category character varying(60) Proposal category The following are the possible subject categories: non-pointing data; calibration; galactic point sources; galactic diffuse emission; extragalactic compact sources; extragalactic diffuse sources; Gamma-ray bursts and other non-proposed TOOs.
16 proposal_title character varying(120) Proposal title
17 awarded_total_exposure smallint ks Total awarded time (ks)
18 proposal_abstract character varying(800) Full abstract?
19 proposal_priority character varying(5) Target observing priority
20 observation_id character varying(11) The number to identify an observation/sequence. This is a 9-digit number.
21 proposal_exposure numeric(6,3) ks Proposed observation exposure for target (ks)
22 awarded_exposure numeric(6,3) ks Accepted observation exposure for target (ks)
23 recurrence_of_observations integer Number of onseravtion for target.
24 pi_name character varying(61) Proposal Principal Investigator (PI) name
25 co_pi_name character varying(61) Proposal Co-PI name
26 proposal_total_exposure smallint ks Total proposed time (ks)

Scroll Back to Top ⏏

Last Modified: 02 August 2023