DARTS/Astro Query System - SQL Search -

All the tables available for SQL Search and information on each table are listed in the Available Data page. Please see the User Guide for the usage of "SQL Search".

Call example

【Basic Syntax】

 SELECT {*|column, column, column,..}
 FROM table name
 [ WHERE conditions ]
 [ ORDER BY column, column,... ]
 [ LIMIT {ALL|number} ] [ OFFSET number ]
 ;

---------------------------------------------------------

This is an example query to obtain the first 10 rows of 
akari_fis_bsc_1 using radial search.

The akari_fis_bsc_1 is an catalogue, and each data has 
the coorinate position of the object. So, search the objects 
contained in the circle area you specify there.

Columns to display -> all
  Table name -> akari_fis_bsc_1
  Search condition -> radial search, 
   center position is (266.0, -28,0) and radius is 10 arcmin
  Displayed results -> from 1st to 10th

---------------------------------------------------------
Point:
  You can use functions of PgSphere(https://pgsphere.github.io/)
  on this system.

Data types:
    Point   ... spoint(coordinate, coordinate)
    Path    ... spath(spoint(), spoint(), ...)
    Circle  ... scircle(spoint(), radius)
    Polygon ... spoly(spoint(), spoint(), ...)

Operators:
    a @ b = '1' ... a contained by b
    a !@ b = '1' ... a is not contained by b
    a && b = '1' ... overlaped each other
    a !&& b = '1' ... do not overlaped each other

Ths function radians needs a parameter in degree.
  Operator '/' means division. 
  Note: integer division truncates the result.
   10.0 / 60.0 = 0.16666...
   10 / 60 = 0

---------------------------------------------------------

This is an example query to obtain the first 10 rows of 
ginga_observation_log using radial search.

The ginga_observation_log has pointing observations and 
scan observation. Each data has the coorinate of the 
observation start point and the end point, and the 
average point. So, search the pointing position contained 
in the circle area you specified, or the scan-path crossed 
over the area.

Columns to display -> all
  Table name -> ginga_observation_log
  Search condition -> radial search,
  center position is M31(10.7, 41.2) and radius is 1 degree
  Displayed results -> from 1st to 10th

---------------------------------------------------------
Point:
  You can use functions of PgSphere(https://pgsphere.github.io/)
  on this system.

Data types:
    Point   ... spoint(coordinate, coordinate)
    Path    ... spath(spoint(), spoint(), ...)
    Circle  ... scircle(spoint(), radius)
    Polygon ... spoly(spoint(), spoint(), ...)

Operators:
    a @ b  ... a contained by b
    a !@ b ... a is not contained by b
    a && b ... overlaped each other
    a !&& b ... do not overlaped each other

---------------------------------------------------------

This is an example query to obtain the data near the 
galactic center of suzaku_xis_observation_log using radial search.

The SUZAKU XIS has rectanglar field of view with 18 arcmin 
x 18 arcmin. Each data of suzaku_xis_observation_log has 
the coorinate of each corner position about field of view.
So, search the rectanglar area overlapd the circle area 
you specified.

Columns to display -> all
  Table name -> suzaku_xis_observation_log
  Search condition -> radial search,
    center position is (0.0, 0.0) with Galactic coordinates
    and radius is 1 arcmin
  Displayed results -> from 1st to 200th

---------------------------------------------------------
Point:

1. Use the column of Galactic coordinates.

2. You can use functions of PgSphere(https://pgsphere.github.io/)
   on this system.

Data types:
    Point   ... spoint(coordinate, coordinate)
    Path    ... spath(spoint(), spoint(), ...)
    Circle  ... scircle(spoint(), radius)
    Polygon ... spoly(spoint(), spoint(), ...)

Operators:
    a @ b  ... a contained by b
    a !@ b ... a is not contained by b
    a && b ... overlaped each other
    a !&& b ... do not overlaped each other

---------------------------------------------------------

This is an example query to obtain the data nearthe 
galactic center of suzaku_xis_observation_log using radial search.

The SUZAKU XIS has rectanglar field of view with 18 arcmin 
x 18 arcmin. Each data of suzaku_xis_observation_log has the 
coorinate of each corner position about field of view. 
So, search the rectanglar area overlapd the rectanglar area 
you specified.

Columns to display -> object_name, center_galactic_lon, 
   center_galactic_lat, data_access_url
  Table name -> suzaku_xis_observation_log
  Search condition -> rectanglar search,
    0.1(deg) <= Galactic Latitude <= .0.1(deg)
    and 0.1(deg) <= Galactic Latitude <= 0.1(deg)
  Displayed results -> from 1st to 100th

---------------------------------------------------------
Point:
  You can use functions of PgSphere(https://pgsphere.github.io/)
  on this system.

Data types:
    Point   ... spoint(coordinate, coordinate)
    Path    ... spath(spoint(), spoint(), ...)
    Circle  ... scircle(spoint(), radius)
    Polygon ... spoly(spoint(), spoint(), ...)

Operators:
    a @ b  ... a contained by b
    a !@ b ... a is not contained by b
    a && b ... overlaped each other
    a !&& b ... do not overlaped each other

---------------------------------------------------------

This is an example query to obtain the first 10 rows of 
akari_fis_bsc_1 using radial search.

The akari_fis_bsc_1 is an catalogue, and each data has 
the coorinate position of the object. So, search the objects 
contained in the circle area you specify there.

Columns to display -> all
  Table name -> akari_fis_bsc_1
  Search condition -> radial search, 
   center position is (266.0, -28,0) and radius is 10 arcmin
  Displayed results -> from 1st to 10th

---------------------------------------------------------
Point:
  You can use functions of PgSphere(https://pgsphere.github.io/)
  on this system.

Data types:
    Point   ... spoint(coordinate, coordinate)
    Path    ... spath(spoint(), spoint(), ...)
    Circle  ... scircle(spoint(), radius)
    Polygon ... spoly(spoint(), spoint(), ...)

Operators:
    a @ b = '1' ... a contained by b
    a !@ b = '1' ... a is not contained by b
    a && b = '1' ... overlaped each other
    a !&& b = '1' ... do not overlaped each other

Ths function radians needs a parameter in degree.
  Operator '/' means division. 
  Note: integer division truncates the result.
   10.0 / 60.0 = 0.16666...
   10 / 60 = 0

---------------------------------------------------------

This is an example query to obtain the first 10 rows of 
ginga_observation_log using radial search.

---------------------------------------------------------
Point:
  You can use functions of PgSphere(https://pgsphere.github.io/)
  on this system.

Data types:
    Point   ... spoint(coordinate, coordinate)
    Path    ... spath(spoint(), spoint(), ...)
    Circle  ... scircle(spoint(), radius)
    Polygon ... spoly(spoint(), spoint(), ...)

Operators:
    a @ b  ... a contained by b
    a !@ b ... a is not contained by b
    a && b ... overlaped each other
    a !&& b ... do not overlaped each other

---------------------------------------------------------

This is an example query to obtain the data near the 
galactic center of suzaku_xis_observation_log using radial search.

---------------------------------------------------------
Point:

1. Use the column of Galactic coordinates.

2. You can use functions of PgSphere(https://pgsphere.github.io/)
   on this system.

Data types:
    Point   ... spoint(coordinate, coordinate)
    Path    ... spath(spoint(), spoint(), ...)
    Circle  ... scircle(spoint(), radius)
    Polygon ... spoly(spoint(), spoint(), ...)

Operators:
    a @ b  ... a contained by b
    a !@ b ... a is not contained by b
    a && b ... overlaped each other
    a !&& b ... do not overlaped each other

---------------------------------------------------------

This is an example query to obtain the data nearthe 
galactic center of suzaku_xis_observation_log using radial search.

The SUZAKU XIS has rectanglar field of view with 18 arcmin 
x 18 arcmin. Each data of suzaku_xis_observation_log has the 
coorinate of each corner position about field of view. 
So, search the rectanglar area overlapd the rectanglar area 
you specified.

---------------------------------------------------------
Point:
  You can use functions of PgSphere(https://pgsphere.github.io/)
  on this system.

Data types:
    Point   ... spoint(coordinate, coordinate)
    Path    ... spath(spoint(), spoint(), ...)
    Circle  ... scircle(spoint(), radius)
    Polygon ... spoly(spoint(), spoint(), ...)

Operators:
    a @ b  ... a contained by b
    a !@ b ... a is not contained by b
    a && b ... overlaped each other
    a !&& b ... do not overlaped each other

---------------------------------------------------------

SQL query

Format

total 83

Download WgetScript

No.	observation_start_time	observation_start_time_mjd	observation_end_time	observation_end_time_mjd	observation_id	object_name	pi_name	proposal_code	object_ra	object_dec	object_ra_b1950	object_dec_b1950	object_galactic_lon	object_galactic_lat	object_ecliptic_lon	object_ecliptic_lat	aot_name	aot_param	aot_type	observation_status	observation_mode	object_id	observation_count	pointing_id	remark_id	remark_title	public_date	public_date_mjd	file_create_date	data_size	data_access_url
1	2007-08-28 06:46:11	54340.2820717593	2007-08-28 06:46:11	54340.2820717593	3111023-001	IRC-Cir-T2S	Kandori Ryo	DEMDC									IRC03	a;N	NORMAL	PV2	MAIN	3111023	1		/1/5/	Earth shine, special operations
2	2007-08-27 13:03:42	54339.5442361111	2007-08-27 13:03:42	54339.5442361111	4101006-001	53w002	Charmandaris Vassilis	BLOBS									IRC05	b;L	NORMAL	PV2	MAIN	4101006	1		/1/5/	Earth shine, special operations
3	2007-08-30 15:42:08	54342.6542592593	2007-08-30 15:42:08	54342.6542592593	4101006-002	53w002	Charmandaris Vassilis	BLOBS									IRC05	b;L	NORMAL	PV2	MAIN	4101006	2		/1/5/	Earth shine, special operations
4	2007-08-27 11:28:56	54339.4784259259	2007-08-27 11:28:56	54339.4784259259	2111056-001	NEP-D_add	LSNEP Team	LSNEP									IRC05	c;L	NORMAL	PV2	MAIN	2111056	1		/1/2/5/	Earth shine, No dithering, special operations
5	2007-08-29 23:11:41	54341.9664467593	2007-08-29 23:11:41	54341.9664467593	2111059-001	NEP-D_add	LSNEP Team	LSNEP									IRC05	a;L	NORMAL	PV2	MAIN	2111059	1		/1/2/5/	Earth shine, No dithering, special operations
6	2007-08-30 12:27:46	54342.5192824074	2007-08-30 12:27:46	54342.5192824074	2111060-001	NEP-D_add	LSNEP Team	LSNEP									IRC05	b;N	NORMAL	PV2	MAIN	2111060	1		/1/2/5/	Earth shine, No dithering, special operations
7	2007-08-31 09:56:52	54343.4144907407	2007-08-31 09:56:52	54343.4144907407	4101006-003	53w002	Charmandaris Vassilis	BLOBS									IRC05	b;L	NORMAL	PV2	MAIN	4101006	3		/1/5/	Earth shine, special operations
8	2007-08-29 09:22:32	54341.3906481481	2007-08-29 09:22:32	54341.3906481481	4111025-001	IRAS 15405-4945	Engels Dieter	DEAGB									IRC04	a;Lc	NORMAL	PV2	MAIN	4111025	1		/1/5/	Earth shine, special operations
9	2007-09-01 18:13:59	54344.7597106481	2007-09-01 18:13:59	54344.7597106481	1402544-001	NGC1808	Kaneda Hidehiro	ISMGN									IRC04	b;Ns	NORMAL	PV2	MAIN	1402544	1		/5/	special operations
10	2007-08-29 20:17:27	54341.8454513889	2007-08-29 20:17:27	54341.8454513889	1800570-001	HIP 20087	Murakami Hiroshi	VEGAD									IRC02	a;N	NORMAL	PV2	MAIN	1800570	1		/1/5/	Earth shine, special operations
11	2007-09-25 03:23:59	54368.1416550926	2007-09-25 03:23:59	54368.1416550926	1210456-001	(parallel)NGC 6528	Kawada Mitsunobu	FISS3									FIS04	0.5;F;0	NORMAL	PV2	PARALLEL	1210456	1		/5/	special operations
12	2007-09-28 01:06:32	54371.0462037037	2007-09-28 01:06:32	54371.0462037037	1210467-001	(parallel)GGD27	Kawada Mitsunobu	FISS3									FIS04	0.5;F;0	NORMAL	PV2	PARALLEL	1210467	1		/5/	special operations
13	2007-09-29 00:21:53	54372.0151967593	2007-09-29 00:21:53	54372.0151967593	1210469-001	(parallel)GL2136	Kawada Mitsunobu	FISS3									FIS04	0.5;F;0	NORMAL	PV2	PARALLEL	1210469	1		/5/	special operations
14	2007-08-29 18:37:57	54341.7763541667	2007-08-29 18:37:57	54341.7763541667	1800571-001	HIP 20087	Murakami Hiroshi	VEGAD									IRC02	a;L	NORMAL	PV2	MAIN	1800571	1		/1/5/	Earth shine, special operations
15	2007-08-30 19:31:31	54342.8135532407	2007-08-30 19:31:31	54342.8135532407	1800576-001	HIP 20614	Murakami Hiroshi	VEGAD									IRC02	a;N	NORMAL	PV2	MAIN	1800576	1		/1/5/	Earth shine, special operations
16	2007-08-31 18:43:59	54343.7805439815	2007-08-31 18:43:59	54343.7805439815	1800579-001	HIP 20641	Murakami Hiroshi	VEGAD									IRC02	a;L	NORMAL	PV2	MAIN	1800579	1		/1/5/	Earth shine, special operations
17	2007-09-09 02:29:10	54352.103587963	2007-09-09 02:29:10	54352.103587963	1210448-001	(parallel)IRAS16362-4845	Kawada Mitsunobu	FISS3									FIS04	0.5;F;0	NORMAL	PV2	PARALLEL	1210448	1		/5/	special operations
18	2007-08-31 12:24:41	54343.5171412037	2007-08-31 12:24:41	54343.5171412037	1800608-001	HIP 24186	Murakami Hiroshi	VEGAD									IRC02	a;N	NORMAL	PV2	MAIN	1800608	1		/1/5/	Earth shine, special operations
19	2007-08-31 13:20:38	54343.5559953704	2007-08-31 13:20:38	54343.5559953704	1332021-001	NEP_SPICY_22	Wada Takehiko	SPICY									IRC04	a;Nc	NORMAL	PV2	MAIN	1332021	1		/1/5/	Earth shine, special operations
20	2007-08-31 15:00:09	54343.6251041667	2007-08-31 15:00:09	54343.6251041667	1332022-001	NEP_SPICY_22	Wada Takehiko	SPICY									IRC04	a;Nc	NORMAL	PV2	MAIN	1332022	1		/1/5/	Earth shine, special operations
21	2007-08-27 09:11:47	54339.3831828704	2007-08-27 09:11:47	54339.3831828704	3261067-001	SPECS_315g	Yamamura Issei	SPECS									IRC04	a;Nc	NORMAL	PV2	MAIN	3261067	1		/1/5/	Earth shine, special operations
22	2007-08-27 10:51:20	54339.4523148148	2007-08-27 10:51:20	54339.4523148148	3261066-001	SPECS_315f	Yamamura Issei	SPECS									IRC04	a;Nc	NORMAL	PV2	MAIN	3261066	1		/1/5/	Earth shine, special operations
23	2007-08-26 11:50:13	54338.4932060185	2007-08-26 11:50:13	54338.4932060185	1501114-001	65803 Didymos	Ueno Munetaka	SOSOS									IRC02	a;L	NORMAL	PV2	MAIN	1501114	1		/1/5/	Earth shine, special operations
24	2007-08-26 17:38:45	54338.7352430556	2007-08-26 17:38:45	54338.7352430556	1800554-001	HIP 19076	Murakami Hiroshi	VEGAD									IRC02	a;N	NORMAL	PV2	MAIN	1800554	1		/1/5/	Earth shine, special operations
25	2007-08-28 17:47:15	54340.7411458333	2007-08-28 17:47:15	54340.7411458333	1800573-001	HIP 20219	Murakami Hiroshi	VEGAD									IRC02	a;L	NORMAL	PV2	MAIN	1800573	1		/1/5/	Earth shine, special operations
26	2007-08-31 03:56:47	54343.1644328704	2007-08-31 03:56:47	54343.1644328704	5125032-001	IRAS 04385-0828	IRC Team	DTIRC									IRC04	b;Np	NORMAL	PV2	MAIN	5125032	1		/1/5/	Earth shine, special operations
27	2007-08-26 11:00:41	54338.4588078704	2007-08-26 11:00:41	54338.4588078704	1800555-001	HIP 19076	Murakami Hiroshi	VEGAD									IRC02	a;L	NORMAL	PV2	MAIN	1800555	1		/1/5/	Earth shine, special operations
28	2007-08-28 19:26:50	54340.8103009259	2007-08-28 19:26:50	54340.8103009259	1800575-001	HIP 20284	Murakami Hiroshi	VEGAD									IRC02	a;L	NORMAL	PV2	MAIN	1800575	1		/1/5/	Earth shine, special operations
29	2007-08-26 08:49:03	54338.3673958333	2007-08-26 08:49:03	54338.3673958333	3071006-004	J165354.61+405402.1	Im Myungshin	HZQSO									IRC04	b;Np	NORMAL	PV2	MAIN	3071006	4		/1/5/	Earth shine, special operations
30	2007-08-26 09:58:26	54338.4155787037	2007-08-26 09:58:26	54338.4155787037	3261069-001	SPECS_315i	Yamamura Issei	SPECS									IRC04	a;Nc	NORMAL	PV2	MAIN	3261069	1		/1/5/	Earth shine, special operations
31	2007-08-26 19:03:39	54338.7942013889	2007-08-26 19:03:39	54338.7942013889	1800523-001	HIP 9598	Murakami Hiroshi	VEGAD									FIS01	2.0;8;70	NORMAL	PV2	MAIN	1800523	1		/1/5/	Earth shine, special operations
32	2007-08-28 10:17:55	54340.4291087963	2007-08-28 10:17:55	54340.4291087963	4171017-001	L1721-2	Habart Emilie	DGPDR									IRC02	a;N	NORMAL	PV2	MAIN	4171017	1		/1/5/	Earth shine, special operations
33	2007-08-28 00:45:02	54340.0312731481	2007-08-28 00:45:02	54340.0312731481	2111057-001	NEP-D_add	LSNEP Team	LSNEP									IRC05	a;N	NORMAL	PV2	MAIN	2111057	1		/1/2/5/	Earth shine, No dithering, special operations
34	2007-08-27 14:44:34	54339.6142824074	2007-08-27 14:44:34	54339.6142824074	3061021-003	J171808.65+551511.1	Im Myungshin	GROTH									IRC05	b;L	NORMAL	PV2	MAIN	3061021	3		/1/2/5/	Earth shine, No dithering, special operations
35	2007-08-28 06:46:11	54340.2820717593	2007-08-28 06:46:11	54340.2820717593	1210437-001	(parallel)IRC-Cir-T2S	Kawada Mitsunobu	FISS3									FIS04	0.5;F;0	NORMAL	PV2	PARALLEL	1210437	1		/1/5/	Earth shine, special operations
36	2007-08-28 12:17:00	54340.5118055556	2007-08-28 12:17:00	54340.5118055556	1300339-002	53W002	Lee HyungMok	CLEVL									IRC05	a;L	NORMAL	PV2	MAIN	1300339	2		/1/5/	Earth shine, special operations
37	2007-08-29 21:59:06	54341.9160416667	2007-08-29 21:59:06	54341.9160416667	1800574-001	HIP 20284	Murakami Hiroshi	VEGAD									IRC02	a;N	NORMAL	PV2	MAIN	1800574	1		/1/5/	Earth shine, special operations
38	2007-08-29 07:43:03	54341.3215625	2007-08-29 07:43:03	54341.3215625	4111026-001	IRAS 15405-4945	Engels Dieter	DEAGB									IRC04	a;Nc	NORMAL	PV2	MAIN	4111026	1		/1/5/	Earth shine, special operations
39	2007-08-29 11:35:02	54341.482662037	2007-08-29 11:35:02	54341.482662037	2111058-001	NEP-D_add	LSNEP Team	LSNEP									IRC05	a;L	NORMAL	PV2	MAIN	2111058	1		/1/2/5/	Earth shine, No dithering, special operations
40	2007-08-30 10:18:19	54342.4293865741	2007-08-30 10:18:19	54342.4293865741	3111019-001	IRC-BHR126	Kandori Ryo	DEMDC									IRC03	a;N	NORMAL	PV2	MAIN	3111019	1		/1/5/	Earth shine, special operations
41	2007-08-30 08:32:39	54342.3560069444	2007-08-30 08:32:39	54342.3560069444	3111028-001	IRC-BHR100	Kandori Ryo	DEMDC									IRC03	a;N	NORMAL	PV2	MAIN	3111028	1		/1/5/	Earth shine, special operations
42	2007-08-30 05:23:55	54342.2249421296	2007-08-30 05:23:55	54342.2249421296	4201012-001	129PShoemakerLevy3	Mazzotta Epifani Elena	ADAMB									IRC02	a;L	NORMAL	PV2	MAIN	4201012	1		/1/5/	Earth shine, special operations
43	2007-08-29 03:17:27	54341.1371180556	2007-08-29 03:17:27	54341.1371180556	5125111-001	UDEEP	IRC Team	DTIRC									IRC05	b;L	NORMAL	PV2	MAIN	5125111	1		/1/2/5/	Earth shine, No dithering, special operations
44	2007-08-29 09:22:32	54341.3906481481	2007-08-29 09:22:32	54341.3906481481	1210440-001	(parallel)IRAS 15405-4945	Kawada Mitsunobu	FISS3									FIS04	0.5;F;0	NORMAL	PV2	PARALLEL	1210440	1		/1/5/	Earth shine, special operations
45	2007-08-29 13:09:46	54341.5484490741	2007-08-29 13:09:46	54341.5484490741	1300339-003	53W002	Lee HyungMok	CLEVL									IRC05	a;L	NORMAL	PV2	MAIN	1300339	3		/1/5/	Earth shine, special operations
46	2007-08-29 14:49:18	54341.6175694444	2007-08-29 14:49:18	54341.6175694444	1300339-004	53W002	Lee HyungMok	CLEVL									IRC05	a;L	NORMAL	PV2	MAIN	1300339	4		/1/5/	Earth shine, special operations
47	2007-08-29 16:28:49	54341.6866782407	2007-08-29 16:28:49	54341.6866782407	1300339-005	53W002	Lee HyungMok	CLEVL									IRC05	a;L	NORMAL	PV2	MAIN	1300339	5		/1/5/	Earth shine, special operations
48	2007-08-30 04:10:13	54342.1737615741	2007-08-30 04:10:13	54342.1737615741	5125112-001	UDEEP	IRC Team	DTIRC									IRC05	b;L	NORMAL	PV2	MAIN	5125112	1		/1/2/5/	Earth shine, No dithering, special operations
49	2007-08-29 06:36:30	54341.2753472222	2007-08-29 06:36:30	54341.2753472222	5125132-001	UDEEP	IRC Team	DTIRC									IRC05	a;L	NORMAL	PV2	MAIN	5125132	1		/1/2/5/	Earth shine, No dithering, special operations
50	2007-08-30 17:52:01	54342.7444560185	2007-08-30 17:52:01	54342.7444560185	1800577-001	HIP 20614	Murakami Hiroshi	VEGAD									IRC02	a;L	NORMAL	PV2	MAIN	1800577	1		/1/5/	Earth shine, special operations
51	2007-08-31 20:23:29	54343.8496412037	2007-08-31 20:23:29	54343.8496412037	1800578-001	HIP 20641	Murakami Hiroshi	VEGAD									IRC02	a;N	NORMAL	PV2	MAIN	1800578	1		/1/5/	Earth shine, special operations
52	2007-08-30 22:52:14	54342.9529398148	2007-08-30 22:52:14	54342.9529398148	1800580-001	HIP 20901	Murakami Hiroshi	VEGAD									IRC02	a;N	NORMAL	PV2	MAIN	1800580	1		/1/5/	Earth shine, special operations
53	2007-09-01 17:32:29	54344.7308912037	2007-09-01 17:32:29	54344.7308912037	5125113-001	UDEEP	IRC Team	DTIRC									IRC03	a;N	NORMAL	PV2	MAIN	5125113	1		/5/	special operations
54	2007-09-01 19:53:30	54344.8288194444	2007-09-01 19:53:30	54344.8288194444	1402545-001	NGC1808	Kaneda Hidehiro	ISMGN									IRC04	b;Ns	NORMAL	PV2	MAIN	1402545	1		/5/	special operations
55	2007-08-30 21:12:44	54342.8838425926	2007-08-30 21:12:44	54342.8838425926	1800581-001	HIP 20901	Murakami Hiroshi	VEGAD									IRC02	a;L	NORMAL	PV2	MAIN	1800581	1		/1/5/	Earth shine, special operations
56	2007-08-30 23:34:42	54342.9824305556	2007-08-30 23:34:42	54342.9824305556	1602257-001	Lup3m1(0.2)	Ueno Munetaka	AFSAS									IRC02	a;N	NORMAL	PV2	MAIN	1602257	1		/1/5/	Earth shine, special operations
57	2007-08-31 22:04:52	54343.9200462963	2007-08-31 22:04:52	54343.9200462963	1800584-001	HIP 20995	Murakami Hiroshi	VEGAD									IRC02	a;L	NORMAL	PV2	MAIN	1800584	1		/1/5/	Earth shine, special operations
58	2007-09-01 11:07:49	54344.4637615741	2007-09-01 11:07:49	54344.4637615741	1711354-001	IRAS 03374+6229	Yamamura Issei	MLHES									IRC02	a;L	NORMAL	PV2	MAIN	1711354	1		/5/	special operations
59	2007-09-01 00:57:17	54344.0397800926	2007-09-01 00:57:17	54344.0397800926	1332025-001	NEP_SPICY_22	Wada Takehiko	SPICY									IRC04	a;Nc	NORMAL	PV2	MAIN	1332025	1		/5/	special operations
60	2007-09-01 12:33:55	54344.5235532407	2007-09-01 12:33:55	54344.5235532407	1332026-001	NEP_SPICY_22	Wada Takehiko	SPICY									IRC04	a;Nc	NORMAL	PV2	MAIN	1332026	1		/5/	special operations
61	2007-09-01 19:12:00	54344.8	2007-09-01 19:12:00	54344.8	1332027-001	NEP_SPICY_22	Wada Takehiko	SPICY									IRC04	a;Nc	NORMAL	PV2	MAIN	1332027	1		/5/	special operations
62	2007-09-01 20:51:32	54344.8691203704	2007-09-01 20:51:32	54344.8691203704	1332028-001	NEP_SPICY_22	Wada Takehiko	SPICY									IRC04	a;Nc	NORMAL	PV2	MAIN	1332028	1		/5/	special operations
63	2007-11-02 04:10:13	54406.1737615741	2007-11-02 04:10:13	54406.1737615741	5124265-001	NPM1p67_0536NS_SP_FX	IRC Team	DTIRC									IRC04	b;Np	NORMAL	PV2	MAIN	5124265	1		/5/	special operations
64	2007-11-02 05:49:44	54406.2428703704	2007-11-02 05:49:44	54406.2428703704	5124275-001	NPM1p67_0536NS_SP_FX	IRC Team	DTIRC									IRC04	b;Np	NORMAL	PV2	MAIN	5124275	1		/5/	special operations
65	2007-08-31 17:31:48	54343.7304166667	2007-08-31 17:31:48	54343.7304166667	1402697-001	ESO 034-IG11	Kaneda Hidehiro	ISMGN									IRC04	b;Ns	NORMAL	PV2	MAIN	1402697	1		/1/5/	Earth shine, special operations
66	2007-08-28 10:56:55	54340.4561921296	2007-08-28 10:56:55	54340.4561921296	1402385-001	PER+144TS002	Kaneda Hidehiro	ISMGN									IRC04	b;Ns	NORMAL	PV2	MAIN	1402385	1		/1/5/	Earth shine, special operations
67	2007-08-30 11:03:01	54342.4604282407	2007-08-30 11:03:01	54342.4604282407	1402386-001	PER+144TS003	Kaneda Hidehiro	ISMGN									IRC04	b;Ns	NORMAL	PV2	MAIN	1402386	1		/1/5/	Earth shine, special operations
68	2007-08-26 13:45:49	54338.5734837963	2007-08-26 13:45:49	54338.5734837963	1100254-001	IRAS 16474+3430	Nakagawa Takao	AGNUL									IRC04	b;Np	NORMAL	PV2	MAIN	1100254	1		/1/5/	Earth shine, special operations
69	2007-09-14 23:32:24	54357.9808333333	2007-09-14 23:32:24	54357.9808333333	1210451-001	(parallel)NGC6334E	Kawada Mitsunobu	FISS3									FIS04	0.25;F;0	NORMAL	PV2	PARALLEL	1210451	1		/5/	special operations
70	2007-08-29 07:43:03	54341.3215625	2007-08-29 07:43:03	54341.3215625	1210439-001	(parallel)IRAS 15405-4945	Kawada Mitsunobu	FISS3									FIS04	0.5;F;0	NORMAL	PV2	PARALLEL	1210439	1		/1/5/	Earth shine, special operations
71	2007-08-30 08:32:39	54342.3560069444	2007-08-30 08:32:39	54342.3560069444	1210441-001	(parallel)IRC-BHR100	Kawada Mitsunobu	FISS3									FIS04	0.5;F;0	NORMAL	PV2	PARALLEL	1210441	1		/1/5/	Earth shine, special operations
72	2007-09-08 16:32:02	54351.688912037	2007-09-08 16:32:02	54351.688912037	1210447-001	(parallel)RCW108/IRS18	Kawada Mitsunobu	FISS3									FIS04	0.5;F;0	NORMAL	PV2	PARALLEL	1210447	1		/5/	special operations
73	2007-09-10 01:44:58	54353.0728935185	2007-09-10 01:44:58	54353.0728935185	1210450-001	(parallel)IRAS16502-4002	Kawada Mitsunobu	FISS3									FIS04	0.5;F;0	NORMAL	PV2	PARALLEL	1210450	1		/5/	special operations
74	2007-09-24 23:17:46	54367.9706712963	2007-09-24 23:17:46	54367.9706712963	1210454-001	(parallel)Sh2-252A	Kawada Mitsunobu	FISS3									FIS04	0.5;F;0	NORMAL	PV2	PARALLEL	1210454	1		/5/	special operations
75	2007-09-25 01:47:42	54368.0747916667	2007-09-25 01:47:42	54368.0747916667	1210455-001	(parallel)Dob479	Kawada Mitsunobu	FISS3									FIS04	0.5;F;0	NORMAL	PV2	PARALLEL	1210455	1		/5/	special operations
76	2007-09-27 01:54:00	54370.0791666667	2007-09-27 01:54:00	54370.0791666667	1210463-001	(parallel)W33A	Kawada Mitsunobu	FISS3									FIS04	0.25;F;0	NORMAL	PV2	PARALLEL	1210463	1		/5/	special operations
77	2007-08-28 03:59:22	54340.1662268518	2007-08-28 03:59:22	54340.1662268518	1300340-002	53W002	Lee HyungMok	CLEVL									IRC05	b;N	NORMAL	PV2	MAIN	1300340	2		/1/2/5/	Earth shine, No dithering, special operations
78	2007-08-31 11:41:06	54343.486875	2007-08-31 11:41:06	54343.486875	1332020-001	NEP_SPICY_22	Wada Takehiko	SPICY									IRC03	a;N	NORMAL	PV2	MAIN	1332020	1		/1/5/	Earth shine, special operations
79	2007-08-31 16:39:40	54343.694212963	2007-08-31 16:39:40	54343.694212963	1332023-001	NEP_SPICY_22	Wada Takehiko	SPICY									IRC04	a;Nc	NORMAL	PV2	MAIN	1332023	1		/1/5/	Earth shine, special operations
80	2007-08-31 23:17:46	54343.9706712963	2007-08-31 23:17:46	54343.9706712963	1332024-001	NEP_SPICY_22	Wada Takehiko	SPICY									IRC04	a;Nc	NORMAL	PV2	MAIN	1332024	1		/1/5/	Earth shine, special operations
81	2007-11-02 02:30:24	54406.1044444444	2007-11-02 02:30:24	54406.1044444444	5124269-001	KF08T3 NS_SP_FX	IRC Team	DTIRC									IRC04	a;Nc	NORMAL	PV2	MAIN	5124269	1		/5/	special operations
82	2007-08-29 04:56:59	54341.2062384259	2007-08-29 04:56:59	54341.2062384259	5125110-001	UDEEP	IRC Team	DTIRC									IRC05	a;L	NORMAL	PV2	MAIN	5125110	1		/1/2/5/	Earth shine, No dithering, special operations
83	2007-09-01 14:13:26	54344.592662037	2007-09-01 14:13:26	54344.592662037	5125133-001	UDEEP	IRC Team	DTIRC									IRC03	a;N	NORMAL	PV2	MAIN	5125133	1		/5/	special operations

Used SQL

SELECT * FROM akari_pointed_rawdata_package_info WHERE aot_type = 'NORMAL' AND observation_status = 'PV2'

Your request has been accepted.
The download will start soon automatically.

Go to top of this page ⏏