Display data from paper

Reference: [JEW91]

Download as: Table (CSV)
View as list of objects

Detection table from JEW91

Hide / Show individual components

ID	Obs. RA	Obs. Dec	l	b	Group id	Source name	V_range	V_peak	F_peak	∫F dv	RMS	List	Detection	Class	Dist. (parallax)	Ref.
	(J2000)	(J2000)	(deg.)	(deg.)			(km/s)	(km/s)	(Jy)	(Jy*km/s)	(Jy)		Yes/No		(kpc)
1	00 03 21.6	+55 40 48	116.1445	-6.5569	G116.144-6.556	*Y Cas	0.00	-15.9	52	2790	0.500	ENG_SIO	+H₂O +OH +SiO	EVOLVED		JEW91
2	00 04 19.9	+40 06 36.9	113.2486	-21.8741	G113.249-21.875	SV And	0.00	-91.4	5.2	230	0.500	ENG_SIO	-H₂O -OH +SiO	SFR_MIXED		JEW91
3	00 23 14.1	+55 47 33.5	118.9463	-6.8607	G118.947-6.861	T Cas	0.00	-8	10	330	0.500	ENG_SIO	-H₂O -OH +SiO	EVOLVED		JEW91
4	01 06 25.9	+12 35 52.8	128.6413	-50.1074	G128.642-50.107	IRC +10011	0.00	7.1	260	14039.999	0.600	ENG_SIO	+H₂O +OH +SiO	EVOLVED		JEW91
5	01 33 51.1	+62 26 53.1	127.8146	-0.0209	G127.815-0.021	OH 127.8-0.0	0.00	-56	30.5	840	0.500	ENG_SIO	-H₂O -CH₃OH II +OH +SiO	EVOLVED		JEW91
6	01 58 44	+45 26 6.9	135.1195	-15.8380	G135.120-15.838	HD 11979	0.00	-6.6	6.1	110	0.600	ENG_SIO	+H₂O -CH₃OH II -OH +SiO	EVOLVED		JEW91
7	02 19 20.6	-02 58 27.4	167.7501	-57.9804	G167.754-57.983	o Ceti	0.00	48.6	400	9680	0.800	ENG_SIO	+H₂O -OH +SiO	EVOLVED		JEW91
8	02 22 51.7	+58 35 12.2	134.6205	-2.1949	G134.621-2.195	S Per	0.00	-40	94	5320	0.700	ENG_SIO	+H₂O +OH +SiO	EVOLVED		JEW91
9	02 26 2.7	+00 37 39.7	166.1173	-54.1139	G166.117-54.114	R Cet	0.00	30.2	2.7	120	0.700	ENG_SIO				JEW91
10	02 33 43.6	-13 08 54.8	187.6995	-62.3115	G187.700-62.311	U Cet	0.00	-46.1	2.8	100	0.600	ENG_SIO	+H₂O -OH +SiO	EVOLVED		JEW91
11	03 25 8.4	+65 32 7.3	137.9699	7.2557	G137.970+7.256	0H 138.0+7.3	0.00	-38	1.5	60	0.300	ENG_SIO	-H₂O -CH₃OH II +OH +SiO	EVOLVED		JEW91
12	03 33 30.6	+60 20 8.9	141.7247	3.5189	G141.725+3.519	0H 141.7+3.5	0.00	-56.6	5.2	200	0.600	ENG_SIO	+H₂O -CH₃OH II +OH +SiO	EVOLVED		JEW91
13	03 53 28.6	+11 24 22.6	177.9538	-31.4125	G177.955-31.412	IK Tau	0.00	33.6	210	7800	0.800	ENG_SIO	+H₂O -CH₃OH II +OH +SiO	EVOLVED		JEW91
14	04 28 18.1	+10 09 44.8	185.2178	-25.5809	G185.217-25.581	*R Tau	0.00	12.3	4.4	350	0.500	ENG_SIO	+H₂O +OH +SiO	EVOLVED		JEW91
15	04 29 11.4	+09 56 44.2	185.5553	-25.5354	G185.557-25.534	S Tau	0.00	17.3	9.1	280	0.500	ENG_SIO	-H₂O +OH +SiO	EVOLVED		JEW91
16	05 11 19.4	+52 52 33.8	156.4376	7.8349	G156.438+7.835	IRC +50137	0.00	2.7	186	7380	1.700	ENG_SIO	+H₂O -CH₃OH I +OH +SiO	EVOLVED		JEW91
17	05 17 17.7	+53 35 11.3	156.3657	8.9744	G156.366+8.974	R Aur	0.00	-9	5.6	250	1.400	ENG_SIO	-H₂O -OH +SiO	EVOLVED		JEW91
18	05 29 0.9	-04 41 31.6	207.5957	-20.4547	G207.596-20.455	S Ori	0.00	12.9	63	2880	0.800	ENG_SIO	-H₂O +OH +SiO	EVOLVED		JEW91
19	05 35 14.4	-05 22 29.6	208.9927	-19.3849	G208.993-19.385	Ori IRc2	0.00	16.2	1110	87600	1.200	ENG_SIO	+H₂O +CH₃OH I +CH₃OH II +OH +SiO	SFR_MIXED		JEW91
20	05 55 49.2	+20 10 30.8	188.7152	-2.4919	G188.715-2.492	*U Ori	0.00	-41.5	189	7000	0.400	ENG_SIO	+H₂O +OH +SiO	EVOLVED		JEW91
21	06 02 32.4	+74 30 26.3	139.3945	22.8971	G139.394+22.897	V Cam	0.00	6.5	42	2670	0.500	ENG_SIO	+H₂O -OH +SiO	EVOLVED		JEW91
22	06 22 43.6	-02 11 43.7	211.6122	-7.3883	G211.612-7.388	V Mon	0.00	1.8	52	1170	0.500	ENG_SIO	-H₂O -OH +SiO	EVOLVED		JEW91
23	06 33 15.7	+40 42 50.7	174.1136	14.1219	G174.114+14.122	IRC +40156	0.00	-18	14.2	570	0.700	ENG_SIO	+H₂O +OH +SiO	EVOLVED		JEW91
24	06 34 33.4	+60 56 29.3	154.3092	21.5169	G154.310+21.517	IRC +60169	0.00	-23.9	75	4360	1.000	ENG_SIO	+H₂O +OH +SiO	EVOLVED		JEW91
25	06 40 46.5	+59 52 1.3	155.6569	21.9367	G155.657+21.937	U Lyn	0.00	-8.7	10.5	640	0.800	ENG_SIO	+H₂O +OH +SiO	EVOLVED		JEW91
26	06 44 33.5	+57 54 37.7	157.8281	21.8469	G157.828+21.848	S Lyn	0.00	-31.4	2.6	40	0.500	ENG_SIO	-H₂O -OH +SiO	EVOLVED		JEW91
27	06 47 07	+30 16 34.3	185.0861	12.4390	G185.086+12.439	X Gern	0.00	28	8	210	0.500	ENG_SIO	-H₂O +OH +SiO	EVOLVED		JEW91
28	07 22 58.2	-25 46 2.7	239.3523	-5.0656	G239.352-5.065	VY CMa	0.00	22.3	3660	324000	1.900	ENG_SIO	+H₂O -CH₃OH I -CH₃OH II +OH +SiO	EVOLVED		JEW91
29	07 32 43	+08 19 06	210.1132	12.9280	G210.113+12.928	S CMi	0.00	54	8	370	0.500	ENG_SIO	-H₂O -OH +SiO	EVOLVED		JEW91
30	07 42 16.8	-14 42 50.9	231.8351	4.2196	G231.835+4.220	0H 231.8+4.2	0.00	25.8	13.8	480	0.500	ENG_SIO	+H₂O -CH₃OH II +OH +SiO	EVOLVED		JEW91
31	07 43 2.5	+23 26 58.4	196.6752	21.3307	G196.675+21.331	*S Gern	0.00	95.6	9	360	0.500	ENG_SIO	+H₂O +OH +SiO	EVOLVED		JEW91
32	08 16 33.8	+11 43 34.6	211.7493	24.1389	G211.749+24.139	R Cnc	0.00	13.5	37.5	810	0.500	ENG_SIO	+H₂O +OH +SiO	EVOLVED		JEW91
33	08 53 33.9	+03 04 6.8	224.9861	28.4172	G224.986+28.417	S Hya	0.00	70	1.2	10	1.200	ENG_SIO	-H₂O -CH₃OH II -OH +SiO	EVOLVED		JEW91
34	09 09 52.2	+25 14 52	201.8825	40.6686	G201.882+40.670	W Cnc	0.00	37.5	5.2	200	0.400	ENG_SIO	+H₂O -OH +SiO	EVOLVED		JEW91
35	09 35 30.3	-14 41 30.3	248.1494	26.7012	G248.149+26.701	*X Hya	0.00	26.5	10.5	480	0.500	ENG_SIO	+H₂O +OH +SiO	EVOLVED		JEW91
36	09 45 15.3	-22 01 45	255.7958	23.3529	G255.796+23.353	IRC -20197	0.00	42	24	1050	1.300	ENG_SIO	+H₂O -CH₃OH II +OH +SiO	EVOLVED		JEW91
37	09 47 33.4	+11 25 45.9	223.7197	44.1597	G223.721+44.160	R Leo	0.00	-1	170	9950	0.800	ENG_SIO	+H₂O +OH +SiO	EVOLVED		JEW91
38	09 53 43.1	+34 55 30.7	190.0237	51.4567	G190.022+51.457	S LMi	0.00	-13	1.6	40	0.500	ENG_SIO	+H₂O -OH +SiO	EVOLVED		JEW91
39	10 44 38.4	+68 46 37.2	138.3616	44.3604	G138.362+44.361	R UMa	0.00	38	10.5	380	0.500	ENG_SIO	+H₂O -OH +SiO	EVOLVED		JEW91
40	10 53 37.5	+13 42 55.4	233.0217	59.4266	G233.022+59.426	W Leo	0.00	47	14	580	0.900	ENG_SIO	+H₂O +OH +SiO	EVOLVED		JEW91
41	11 00 33.9	-18 19 29.1	269.2698	37.1961	G269.270+37.196	*R Crt	0.00	16.2	25.5	810	0.800	ENG_SIO	+H₂O +OH +SiO	EVOLVED		JEW91
42	12 04 15.1	+18 46 57.1	248.0315	76.3158	G248.030+76.316	R Com	0.00	-5.7	2.5	120	0.600	ENG_SIO	+H₂O +OH +SiO	EVOLVED		JEW91
43	12 14 36.7	-06 02 9.3	286.5490	55.6600	G286.549+55.660	*T Vir	0.00	5.8	4.6	140	0.400	ENG_SIO	+H₂O +OH +SiO	EVOLVED		JEW91
44	12 38 29.9	+06 59 19.2	293.6736	69.6275	G293.674+69.627	R Vir	0.00	-25.9	0.8	30	0.200	ENG_SIO	-H₂O +OH +SiO	EVOLVED		JEW91
45	13 29 42.9	-23 16 53.5	314.2236	38.7495	G314.223+38.750	*R Hya	0.00	-11.3	205	11200	1.700	ENG_SIO	+H₂O +SiO	EVOLVED		JEW91
46	13 33 0.4	-07 11 41.9	320.7611	54.2315	G320.759+54.232	*S Vir	0.00	9	17	630	0.500	ENG_SIO	+H₂O -OH +SiO	EVOLVED		JEW91
47	13 48 57	+39 32 32.9	82.6563	72.7699	G82.656+72.770	R CVn	0.00	-2.6	17	840	0.900	ENG_SIO	-H₂O -OH +SiO	EVOLVED		JEW91
48	13 49 2.1	-28 22 0.6	318.0231	32.8114	G318.022+32.811	*W Hya	0.00	40.5	6560	246000	2.400	ENG_SIO	+H₂O +OH +SiO	EVOLVED		JEW91
49	14 17 19.8	+66 47 39.2	110.4347	48.1967	G110.434+48.197	U UMi	0.00	-17.2	2	70	0.400	ENG_SIO	-H₂O +OH +SiO	EVOLVED		JEW91
50	14 24 11.5	+25 42 16	34.2791	69.2133	G34.278+69.213	RX Boo	0.00	-3.8	45.9	1830	1.600	ENG_SIO	+H₂O -CH₃OH I +OH +SiO	EVOLVED		JEW91
51	15 21 23.8	+31 22 4.2	49.4733	57.1732	G49.473+57.174	S CrB	0.00	1.8	103	5580	0.500	ENG_SIO	+H₂O +OH +SiO	EVOLVED		JEW91
52	15 27 47	+19 33 51.5	29.5147	53.4769	G29.515+53.477	WX Ser	0.00	6.8	24	1150	0.400	ENG_SIO	+H₂O +OH +SiO	EVOLVED		JEW91
53	16 10 13.9	+25 04 14.1	41.9772	45.6132	G41.978+45.611	RU Her	0.00	-13.5	131	4890	1.000	ENG_SIO	-H₂O +OH +SiO	EVOLVED		JEW91
54	16 25 47.6	+18 53 33.2	35.3455	40.3504	G35.345+40.351	*U Her	0.00	-16.1	321	10300	1.100	ENG_SIO	+H₂O +OH +SiO	EVOLVED		JEW91
55	17 53 18.5	-26 56 36.1	2.5823	-0.4314	G2.583-0.432	OH 2.6-0.4	0.00	-3.9	120	6600	1.000	ENG_SIO	+H₂O +OH +SiO	EVOLVED		JEW91
56	17 55 44.9	-15 03 41.8	13.1441	5.0654	G13.145+5.065	OH 13.1+5.1	0.00	-65.7	2.3	60	0.500	ENG_SIO	-H₂O -CH₃OH II +OH +SiO	EVOLVED		JEW91
57	18 08 4.2	-22 13 37.3	8.3418	-1.0038	G8.344-1.002	*VX Sgr	0.00	7.8	881	92900	2.200	ENG_SIO	+H₂O +OH +SiO	SFR_MIXED		JEW91
58	18 09 6.1	+31 01 15.6	57.5995	22.0293	G57.600+22.029	T Her	0.00	-105.5	2.1	40	0.300	ENG_SIO	-H₂O -OH +SiO	EVOLVED		JEW91
59	18 16 25.3	-14 55 5.5	15.7021	0.7735	G15.701+0.770	OH 15.7+0.8	0.00	-6.5	1.2	80	0.400	ENG_SIO	+H₂O -CH₃OH I -CH₃OH II +OH +SiO	EVOLVED		JEW91
60	18 16 36.8	+03 41 34.1	32.2607	9.4278	G32.261+9.427	RY Oph	0.00	-48.6	2.4	70	0.400	ENG_SIO	+H₂O -OH +SiO	EVOLVED		JEW91
61	18 28 14	-11 16 15.9	20.2729	-0.0517	G20.274-0.050	*OH 20.3-0.1	0.00	25.5	2.4	80	0.700	ENG_SIO	+H₂O +OH +SiO	EVOLVED		JEW91
62	18 28 30.9	-09 58 15.6	21.4562	0.4913	G21.457+0.491	0H 21.5+0.5	0.00	115.5	1.8	90	0.400	ENG_SIO	+H₂O +OH +SiO	EVOLVED		JEW91
63	18 29 28.6	-12 37 47.6	19.2104	-0.9516	G19.209-0.953	0H 19.2-1.0	0.00	48.1	4	100	0.500	ENG_SIO	+H₂O +OH +SiO	EVOLVED		JEW91
64	18 37 32.4	-05 23 59.4	26.5434	0.6179	G26.543+0.618	OH 26.5+0.6	0.00	27.4	22.2	400	1.100	ENG_SIO	+H₂O +OH +SiO	EVOLVED		JEW91
65	18 38 21.1	+08 50 1.7	39.3493	6.9045	G39.349+6.905	X Oph	0.00	-59	1.5	90	0.500	ENG_SIO	+H₂O +OH +SiO	EVOLVED		JEW91
66	18 38 38.7	-05 49 8.6	26.2971	0.1813	G26.297+0.181	OH 26.3+0.2	0.00	-29.2	4.8	190	0.500	ENG_SIO	+H₂O +OH +SiO	EVOLVED		JEW91
67	18 38 39.7	-08 41 16.7	23.7493	-1.1378	G23.751-1.138	0H 23.7-1.1	0.00	47	2.8	60	0.900	ENG_SIO	+OH +SiO	EVOLVED		JEW91
68	18 41 14	-06 15 1.5	26.2084	-0.5883	G26.209-0.589	OH 26.2-0.6	0.00	73.9	2.1	90	0.500	ENG_SIO	+H₂O -CH₃OH II +OH +SiO	EVOLVED		JEW91
69	18 45 48.1	-04 00 48.7	28.7180	-0.5778	G28.719-0.578	0H 28.7-0.6	0.00	45.7	3.1	70	0.500	ENG_SIO	+H₂O -CH₃OH II +OH +SiO	EVOLVED		JEW91
70	18 46 26.7	-06 40 32.1	26.4212	-1.9341	G26.421-1.935	0H 26.4-1.9	0.00	25.2	15	520	0.700	ENG_SIO	-H₂O -CH₃OH II +OH +SiO	EVOLVED		JEW91
71	18 47 9.6	-02 35 40.9	30.1352	-0.2319	G30.137-0.232	0H 30.1-0.2	0.00	47.5	2.5	30	0.400	ENG_SIO	+H₂O -CH₃OH II +OH +SiO	SFR_MIXED		JEW91
72	18 52 1.8	-01 26 38	31.7142	-0.7899	G31.712-0.790	0H 31.7-0.8	0.00	78.2	8.5	320	1.300	ENG_SIO	+H₂O +OH +SiO	EVOLVED		JEW91
73	19 02 6.4	+03 20 16	37.1186	-0.8477	G37.118-0.847	OH 37.1-0.8	0.00	84	1.1	30	0.400	ENG_SIO	+H₂O -CH₃OH I -CH₃OH II +OH +SiO	EVOLVED		JEW91
74	19 04 9.6	+06 13 15.7	39.9160	0.0185	G39.916+0.018	OH 39.9+0.0	0.00	150	2.2	40	0.500	ENG_SIO	-H₂O +OH +SiO	SFR_MIXED		JEW91
75	19 06 22.2	+08 13 51.1	41.9530	0.4546	G41.952+0.454	R Aql	0.00	49.8	48.1	2240	3.200	ENG_SIO	+H₂O -CH₃OH I +OH +SiO	EVOLVED		JEW91
76	19 09 8.3	+08 16 40.7	42.3103	-0.1320	G42.308-0.132	*OH 42.3-0.1	0.00	64	13	460	1.000	ENG_SIO	+H₂O +OH +SiO	EVOLVED		JEW91
77	19 09 59.9	+67 16 37.2	98.1821	23.1277	G98.182+23.128	U Dra	0.00	14	2.5	90	0.300	ENG_SIO	+H₂O -OH +SiO	EVOLVED		JEW91
78	19 14 19.7	+11 10 34.4	45.4712	0.0757	G45.471+0.076	*OH 45.5+0.1	0.00	33.5	4.8	140	0.500	ENG_SIO	-H₂O +OH +SiO	EVOLVED		JEW91
79	19 38 0.1	+11 43 20.9	48.7064	-4.7721	G48.709-4.778	RT Aql	0.00	-29.7	44.3	1370	1.900	ENG_SIO	+H₂O +OH +SiO	EVOLVED		JEW91
80	19 50 33.9	+32 54 53.1	68.5392	3.2767	G68.539+3.276	X Cyg	0.00	15	12.5	370	0.700	ENG_SIO	-H₂O -OH +SiO	EVOLVED		JEW91
81	19 51 21.3	+29 12 59	65.4389	1.2492	G65.439+1.250	*OH 65.4+1.3	0.00	-17.9	4	290	0.500	ENG_SIO	+H₂O +OH +SiO	EVOLVED		JEW91
82	19 57 36	-01 53 10.1	38.9172	-15.5597	G38.917-15.560	RR Aql	0.00	26.9	35.6	2040	1.100	ENG_SIO	+H₂O +OH +SiO	EVOLVED		JEW91
83	20 01 25.9	+50 02 35.7	84.4409	10.2339	G84.442+10.230	Z Cyg	0.00	-148	5.2	190	0.300	ENG_SIO	+H₂O -CH₃OH II +OH +SiO	EVOLVED		JEW91
84	20 06 22.4	+27 02 15.1	65.3171	-2.7122	G65.317-2.715	OH 65.3-2.7	0.00	-5.2	5	110	0.500	ENG_SIO	-H₂O +OH +SiO	EVOLVED		JEW91
85	20 10 27.9	-06 16 6.8	36.3598	-20.4157	G36.357-20.415	IRC -10529	0.00	-17.5	25.9	570	1.000	ENG_SIO	-H₂O -CH₃OH II +OH +SiO	EVOLVED		JEW91
86	20 14 55	+09 05 22	50.9998	-13.9479	G51.000-13.948	R Del	0.00	-31.6	13.5	330	0.500	ENG_SIO	+H₂O -OH +SiO	EVOLVED		JEW91
87	20 25 57.2	+38 21 10.6	77.0044	0.1835	G77.005+0.183	KY Cyg	0.00	-2	14	810	0.700	ENG_SIO	+H₂O -OH +SiO	EVOLVED		JEW91
88	20 46 25.4	+40 06 59.3	80.7980	-1.9206	G80.798-1.921	NML Cyg	0.00	-0.5	25.5	1190	1.000	ENG_SIO	+H₂O -CH₃OH I -CH₃OH II +OH +SiO	EVOLVED		JEW91
89	21 09 32	+68 29 29.4	104.8059	13.8451	G104.805+13.845	T Cep	0.00	-0.9	1.9	90	0.700	ENG_SIO	+H₂O +OH +SiO	EVOLVED		JEW91
90	22 01 1.2	+06 07 15.3	65.4204	-37.0646	G65.423-37.070	V Peg	0.00	-20	2.5	70	0.800	ENG_SIO	-H₂O -OH +SiO	EVOLVED		JEW91
91	22 05 41.9	+35 20 54.7	88.7148	-16.2852	G88.715-16.285	SV Peg	0.00	5.5	1.5	50	0.500	ENG_SIO	+H₂O +OH +SiO	EVOLVED		JEW91
92	22 19 27.5	+59 51 21.5	104.9082	2.4134	G104.908+2.413	OH 104.9+2.5	0.00	-27.8	2.4	50	0.500	ENG_SIO	+H₂O +OH +SiO	EVOLVED		JEW91
93	23 06 39.1	+10 32 35.7	85.4069	-44.5600	G85.407-44.560	R Peg	0.00	19.2	112	3690	1.100	ENG_SIO	+H₂O +OH +SiO	EVOLVED		JEW91
94	23 11 40.5	+59 41 58.8	110.6471	-0.7712	G110.648-0.771	V Cas	0.00	-29.2	5.5	190	0.500	ENG_SIO	-H₂O -OH +SiO	EVOLVED		JEW91
95	23 20 32.9	+08 55 8.2	88.3479	-47.7563	G88.347-47.756	S Peg	0.00	1.6	4.8	160	0.200	ENG_SIO	-H₂O +OH +SiO	EVOLVED		JEW91
96	23 43 49.3	-15 17 2.9	66.5163	-70.3247	G66.517-70.325	R Aqr	0.00	-26.3	45.5	930	1.800	ENG_SIO	-H₂O +OH +SiO	EVOLVED		JEW91
97	23 58 24.3	+51 23 17.9	114.5594	-10.6193	G114.561-10.619	R Cas	0.00	24	292	11700	0.500	ENG_SIO	+H₂O +OH +SiO	EVOLVED		JEW91

DSS colored	2MASS colored	WISE colored
SDSS color	IRAC color I1,I2,I4	GLIMPSE 360
PACS color (70-160 um)	SPIRE color (250-500 um)	NVSS (1.4GHz)
ATLASGAL 870 um	ATLASGAL 870 um + Planck	Bolocam 1.1 mm
UKIDSS K Download UKIDSS K FITS	2MASS K Download 2MASS K FITS

select MAX(sio_data_all.ra_hms) as ra_hms,MAX(sio_data_all.dec_dms) as dec_dms,MAX(sio_data_all.source_name) as source_name,MAX(sio_data_all.ra) as ra,MAX(sio_data_all.dec) as dec,MAX(sio_data_all.l) as l,MAX(sio_data_all.b) as b,MAX(sio_data_all.grp) as grp,MAX(sio_data_all.other_name) as other_name,MAX(sio_data_all.other_desc) as other_desc,BOOL_OR(thermal) as thermal,MAX(sio_data_all.line) as line,MAX(sio_data_all.vrange) as vrange,MAX(sio_data_all.vpeak) as vpeak,MAX(sio_data_all.peak) as peak,MAX(sio_data_all.fwhm) as fwhm,MAX(sio_data_all.int) as int,MAX(sio_data_all.rms) as rms,MAX(sio_data_all.units) as units,MAX(sio_data_all.units_rms) as units_rms,MAX(sio_data_all.date_txt) as date_txt,MAX(sio_data_all.telescope_ref) as telescope_ref,MAX(sio_data_all.telescope_conf) as telescope_conf,MAX(sio_data_all.v_step) as v_step,MAX(sio_data_all.beam) as beam,MAX(sio_data_all.beam_maj) as beam_maj,MAX(sio_data_all.beam_min) as beam_min,MAX(sio_data_all.beam_pa) as beam_pa,MAX(sio_data_all.ref) as ref,MAX(sio_data_all.list_ref) as list_ref,MAX(sio_data_all.ascii) as ascii,MAX(sio_data_all.url) as url,MAX(sio_data_all.image) as image,MAX(sio_data_all.image2) as image2,MAX(sio_data_all.image3) as image3,MAX(sio_data_all.descr) as descr,MAX(sio_data_all.id) as id,BOOL_OR(mjy_flag) as mjy_flag,BOOL_OR(rms_mjy_flag) as rms_mjy_flag,MAX(sio_data_all.dist) as dist,1 as dist_parallax,MAX(sio_data_all.date_txt) as date_txt,MAX(line_det) as line_det,MAX(type) as type,MAX(simbad_types_cat) as simbad_types_cat FROM sio_data_all  LEFT JOIN all_objects_withmet ON sio_data_all.grp=all_objects_withmet.group_name LEFT JOIN object_categories ON all_objects_withmet.group_name = object_categories.group_name_cat AND object_categories.tbl_cat = 'all_objects_withmet' WHERE ref ilike 'JEW91' AND detected=true AND hide=false GROUP BY ref

select sio_data_all.ra_hms,sio_data_all.dec_dms,sio_data_all.source_name,sio_data_all.ra,sio_data_all.dec,sio_data_all.l,sio_data_all.b,sio_data_all.grp,sio_data_all.other_name,sio_data_all.other_desc,sio_data_all.thermal,sio_data_all.line,sio_data_all.vrange,sio_data_all.vpeak,sio_data_all.peak,sio_data_all.fwhm,sio_data_all.int,sio_data_all.rms,sio_data_all.units,sio_data_all.units_rms,sio_data_all.date_txt,sio_data_all.telescope_ref,sio_data_all.telescope_conf,sio_data_all.v_step,sio_data_all.beam,sio_data_all.beam_maj,sio_data_all.beam_min,sio_data_all.beam_pa,sio_data_all.ref,sio_data_all.list_ref,sio_data_all.ascii,sio_data_all.url,sio_data_all.image,sio_data_all.image2,sio_data_all.image3,sio_data_all.descr,sio_data_all.id,sio_data_all.mjy_flag,sio_data_all.rms_mjy_flag,sio_data_all.dist,sio_data_all.dist_parallax,sio_data_all.date_txt,line_det,type,simbad_types_cat FROM sio_data_all   LEFT JOIN all_objects_withmet ON sio_data_all.grp=all_objects_withmet.group_name LEFT JOIN object_categories ON all_objects_withmet.group_name = object_categories.group_name_cat AND object_categories.tbl_cat = 'all_objects_withmet' WHERE ref ilike 'JEW91' AND detected=true AND hide=false ORDER BY detected DESC,id

Display data from paper

Reference: [JEW91]

View as list of objects

Detection table from JEW91