In [1]:
from astroquery.alma import Alma
from astropy import coordinates
from astropy import units as u
import numpy as np
import pandas as pd
In [2]:
def query_object(obj, theta = 0.005, science = False, public = True, savedb=False, dbname='calibrators.db'):
"""
query per object
obj is an array consist of at least [objname, ra, dec, ...]
ra and dec are in degrees
"""
region = coordinates.SkyCoord(obj[1], obj[2], unit='deg')
alma_data = Alma.query_region(region, theta*u.deg, science = science, public = public)
# it is in astropy Table format
df = alma_data.to_pandas() # convert to pandas Dataframe
#! change Numpy Masked-Array to str, so it can be converted to SQL
#df['Band'] = df['Band'].astype("str")
# save the query result in sql database
# with Table's name = calibrator's name
if savedb:
conn = sql.connect(dbname)
conn.text_factory = str
if not df.dropna().empty:
df.to_sql(obj[0], conn, if_exists='replace') # if the Table exist in the db, just replace it
return alma_data, df
In [3]:
# from astropy.coordinates import SkyCoord
# c = SkyCoord('11h39m10.7025s', '-13d50m43.639s', frame='icrs')
# c
In [4]:
#obj = ["J1833-210B", 278.41633, -21.06108]
#obj = ["J1139-1350", 174.79459375, -13.84545528]
#obj = ['J0541-0211', 85.340401, -2.185662]
obj = ["J0501-0159", 75.3031, -1.98746]
In [5]:
table, df = query_object(obj)
In [6]:
df
Out[6]:
Project code
Source name
RA
Dec
Galactic longitude
Galactic latitude
Band
Spatial resolution
Frequency resolution
Array
...
Project title
Project type
Scan intent
Field of view
Largest angular scale
QA2 Status
COUNT
Science keyword
Scientific category
ASA_PROJECT_CODE
0
b'2012.1.00219.S'
b'J0501-0159'
75.303375
-1.987293
201.451028
-25.295595
[3]
1.348574
976.562500
b'12m'
...
b'Spectroscopy of a normal star forming galaxy...
b'S'
b'PHASE WVR'
58.383127
10.860459
b'Y'
0.0
b'Gravitational lenses, Galaxy structure & evo...
b'Cosmology'
b'2012.1.00219.S'
1
b'2012.1.00239.S'
b'J0501-0159'
75.303375
-1.987293
201.451028
-25.295595
[6]
4.767373
976.562500
b'7m'
...
b'Probing a mass distribution of the central 1...
b'S'
b'BANDPASS'
25.127508
20.085598
b'Y'
1.0
b'Low-mass star formation'
b'ISM and star formation'
b'2012.1.00239.S'
2
b'2012.1.01099.S'
b'J0501-0159'
75.303375
-1.987293
201.451028
-25.295595
[3]
8.757429
31250.000000
b'12m7m'
...
b'The Crab nebula at 100GHz: filling in the gap'
b'S'
b'BANDPASS WVR'
63.003418
36.143275
b'Y'
1.0
b'Pulsars and neutron stars'
b'Stars and stellar evolution'
b'2012.1.01099.S'
3
b'2013.1.00991.S'
b'J0501-0159'
75.303375
-1.987293
201.451028
-25.295595
[3]
2.290930
3906.250000
b'12m'
...
b'The full anatomy of a minor merger'
b'S'
b'BANDPASS WVR'
59.145019
13.472503
b'Y'
2.0
b'Merging and interacting galaxies'
b'Galaxy evolution'
b'2013.1.00991.S'
4
b'2013.1.01241.S'
b'J0501-0159'
75.303375
-1.987293
201.451028
-25.295595
[6]
0.957684
1953.125000
b'12m'
...
b'Detecting [CII] in two strongly lensed z~6 s...
b'S'
b'PHASE WVR'
24.639672
5.602774
b'Y'
1.0
b'Lyman Break Galaxies (LBG), Gravitational le...
b'Galaxy evolution'
b'2013.1.01241.S'
5
b'2013.1.00989.S'
b'J0501-0159'
75.303375
-1.987293
201.451028
-25.295595
[7]
0.850650
31250.000000
b'12m'
...
b'Probing the inner-most region of the relativ...
b'S'
b'BANDPASS WVR'
18.340901
4.185990
b'Y'
1.0
b'Active Galactic Nuclei (AGN)/Quasars (QSO)'
b'Active galaxies'
b'2013.1.00989.S'
6
b'2013.1.00662.S'
b'J0501-0159'
75.303375
-1.987293
201.451028
-25.295595
[3]
2.880367
61.035156
b'12m'
...
b'Orion 2 & 3 mapping'
b'S'
b'BANDPASS WVR'
68.548580
14.029071
b'Y'
0.0
b'High-mass star formation, Pre-stellar cores,...
b'ISM and star formation'
b'2013.1.00662.S'
7
b'2013.1.00662.S'
b'J0501-0159'
75.303375
-1.987293
201.451028
-25.295595
[3]
3.016803
61.035156
b'12m'
...
b'Orion 2 & 3 mapping'
b'S'
b'BANDPASS WVR'
68.548335
15.052100
b'Y'
0.0
b'High-mass star formation, Pre-stellar cores,...
b'ISM and star formation'
b'2013.1.00662.S'
8
b'2013.1.00553.S'
b'J0501-0159'
75.303375
-1.987293
201.451028
-25.295595
[6]
1.209399
976.562500
b'12m'
...
b'Molecular oxygen in Orion'
b'S'
b'BANDPASS WVR'
27.686461
5.954154
b'Y'
2.0
b'Astrochemistry, Inter-Stellar Medium (ISM)/M...
b'ISM and star formation'
b'2013.1.00553.S'
9
b'2015.1.01558.T'
b'J0501-0159'
75.303375
-1.987293
201.451028
-25.295594
[7]
0.016120
31250.000000
b'12m'
...
b'Particle Acceleration in GRB Afterglows'
b'T'
b'PHASE WVR'
18.340901
0.115197
b'Y'
0.0
b'Gamma Ray Bursts (GRB)'
b'Cosmology'
b'2015.1.01558.T'
10
b'2013.1.00048.S'
b'J0501-0159'
75.303375
-1.987293
201.451028
-25.295595
[8]
0.080704
976.562500
b'12m'
...
b'Physical properties of an accretion disk aro...
b'S'
b'PHASE WVR'
14.523808
0.425156
b'Y'
3.0
b'High-mass star formation'
b'ISM and star formation'
b'2013.1.00048.S'
11
b'2013.1.00662.S'
b'J0501-0159'
75.303375
-1.987293
201.451028
-25.295594
[3]
8.452530
61.035156
b'7m'
...
b'Orion 2 & 3 mapping'
b'S'
b'BANDPASS WVR'
68.545376
54.767834
b'Y'
0.0
b'High-mass star formation, Pre-stellar cores,...
b'ISM and star formation'
b'2013.1.00662.S'
12
b'2013.1.00662.S'
b'J0501-0159'
75.303375
-1.987293
201.451028
-25.295595
[3]
13.681222
61.035156
b'7m'
...
b'Orion 2 & 3 mapping'
b'S'
b'BANDPASS'
68.543811
50.608697
b'Y'
0.0
b'High-mass star formation, Pre-stellar cores,...
b'ISM and star formation'
b'2013.1.00662.S'
13
b'2013.1.01172.S'
b'J0501-0159'
75.303375
-1.987293
201.451028
-25.295595
[3]
2.359593
1953.125000
b'12m7m'
...
b'CO isotopic ratio enhancement of Pa alpha-se...
b'S'
b'BANDPASS WVR'
61.994044
12.637058
b'Y'
4.0
b'Merging and interacting galaxies, Surveys of...
b'Galaxy evolution'
b'2013.1.01172.S'
14
b'2013.1.00231.S'
b'J0501-0159'
75.303375
-1.987293
201.451028
-25.295595
[7]
0.953308
62500.000000
b'12m'
...
b'Revealing Magnetic Field Structures: Interme...
b'S'
b'BANDPASS WVR'
18.340901
4.700671
b'Y'
0.0
b'Intermediate-mass star formation'
b'ISM and star formation'
b'2013.1.00231.S'
15
b'2013.1.00231.S'
b'J0501-0159'
75.303375
-1.987293
201.451028
-25.295595
[7]
0.881671
62500.000000
b'12m'
...
b'Revealing Magnetic Field Structures: Interme...
b'S'
b'BANDPASS WVR'
18.340901
4.347928
b'Y'
0.0
b'Intermediate-mass star formation'
b'ISM and star formation'
b'2013.1.00231.S'
16
b'2015.1.00187.S'
b'J0501-0159'
75.303375
-1.987293
201.451028
-25.295594
[6]
0.862255
976.562500
b'12m'
...
b'Gas in the most MASSIVE Galaxies'
b'S'
b'PHASE WVR'
26.780126
4.031615
b'Y'
0.0
b'Early-type galaxies, Galactic centres/nuclei'
b'Galaxy evolution'
b'2015.1.00187.S'
17
b'2015.1.00192.S'
b'J0501-0159'
75.303375
-1.987293
201.451028
-25.295594
[6]
0.239247
122.070312
b'12m'
...
b'Hunting for gaps in HEABE disks'
b'S'
b'PHASE WVR'
27.929815
1.203499
b'Y'
1.0
b'Disks around high-mass stars'
b'Disks and planet formation'
b'2015.1.00192.S'
18
b'2016.1.00376.S'
b'J0501-0159'
75.303375
-1.987293
201.451028
-25.295594
[6]
0.266693
244.140625
b'12m'
...
b'Surveying the chemical nature of protostars ...
b'S'
b'PHASE WVR'
24.921404
1.264530
b'Y'
0.0
b'Astrochemistry'
b'ISM and star formation'
b'2016.1.00376.S'
19
b'2016.1.00683.S'
b'J0501-0159'
75.303375
-1.987293
201.451028
-25.295594
[6]
0.466657
1953.125000
b'12m'
...
b'Black hole mass measurements in the most MAS...
b'S'
b'PHASE WVR'
26.777859
2.284317
b'Y'
1.0
b'Early-type galaxies, Galactic centres/nuclei'
b'Galaxy evolution'
b'2016.1.00683.S'
20
b'2016.1.01082.S'
b'J0501-0159'
75.303375
-1.987293
201.451028
-25.295594
[6]
5.463150
122.070312
b'7m'
...
b'To what extent is the protostellar outflow H...
b'S'
b'PHASE WVR'
27.876625
22.429416
b'Y'
0.0
b'Outflows, jets and ionized winds, Low-mass s...
b'ISM and star formation'
b'2016.1.01082.S'
21
b'2016.2.00006.S'
b'J0501-0159'
75.303375
-1.987293
201.451028
-25.295594
[3]
11.750109
976.562500
b'7m'
...
b'Recovering Extended Structures in Merger Rem...
b'S'
b'PHASE WVR'
60.584694
43.350269
b'Y'
0.0
b'Merging and interacting galaxies'
b'Galaxy evolution'
b'2016.2.00006.S'
22
b'2016.1.00209.S'
b'J0501-0159'
75.303375
-1.987293
201.451028
-25.295594
[6]
7.531851
30.517578
b'7m'
...
b'Multi-scale disk and envelope kinematics aro...
b'S'
b'PHASE WVR'
28.060888
22.577690
b'Y'
0.0
b'Low-mass star formation'
b'ISM and star formation'
b'2016.1.00209.S'
23 rows × 36 columns
In [7]:
table
Out[7]:
Table masked=True length=23
Project code Source name RA Dec Galactic longitude Galactic latitude Band Spatial resolution Frequency resolution Array Mosaic Integration Release date Frequency support Velocity resolution Pol products Observation date PI name SB name Proposal authors Line sensitivity (10 km/s) Continuum sensitivity PWV Group ous id Member ous id Asdm uid Project title Project type Scan intent Field of view Largest angular scale QA2 Status COUNT Science keyword Scientific category ASA_PROJECT_CODE deg deg deg deg kHz s GHz m / s mJy/beam mm arcs arcs bytes64 bytes256 float64 float64 float64 float64 object float64 float64 object bytes1 float64 object bytes2700 float64 bytes64 object bytes256 bytes128 bytes512 float64 float64 float32 bytes64 bytes64 bytes32 bytes256 bytes16 bytes256 float64 float64 bytes1 int64 bytes200 bytes200 bytes64 2012.1.00219.S J0501-0159 75.30337450000002 -1.9872933888888886 201.45102807394835 -25.295594503874504 [3] 1.348574266044391 976.5625 12m 937.44 2015-07-08 [99.98..101.98GHz,31250.00kHz, XX YY] U [100.01..102.01GHz,31250.00kHz, XX YY] U [101.97..103.98GHz,31250.00kHz, XX YY] U [112.89..114.90GHz,31250.00kHz, XX YY] U [113.95..115.84GHz,976.56kHz, XX YY] 2527.4383249803477 XX YY 2014-05-03 21:34:35 Ellis, Richard J0451_114_12m_C32-3456 Rawle, Tim; Blain, Andrew; Swinbank, Mark; Jones, Tucker; Rex, Marie; Dessauges-Zavadsky, Miroslava; Schaerer, Daniel; van der Werf, Paul; Egami, Eiichi; Combes, Francoise; Ivison, Rob; Boone, Frederic; Altieri, Bruno; Bridge, Carrie; Richard, Johan; 1.25754134416051 0.02651154596800142 1.3811207 uid://A002/X5a9a13/X22a uid://A002/X5a9a13/X22b uid://A002/X8081ba/X1cab Spectroscopy of a normal star forming galaxy at z=2 with 200 pc resolution: physical conditions in the cold ISM at high redshift S PHASE WVR 58.38312686415326 10.860458871969787 Y 0 Gravitational lenses, Galaxy structure & evolution Cosmology 2012.1.00219.S 2012.1.00239.S J0501-0159 75.30337450000002 -1.9872933888888886 201.45102807394835 -25.295594503874504 [6] 4.767372952029262 976.5625 7m 604.8 2015-08-20 [240.78..242.77GHz,976.56kHz, XX YY] U [243.48..245.47GHz,976.56kHz, XX YY] U [256.68..258.67GHz,976.56kHz, XX YY] U [258.68..260.67GHz,976.56kHz, XX YY] 1123.1401156961756 XX YY 2014-03-25 22:53:42 Onishi, Toshikazu MC27_b6_7m Tomida, Kengo; Saigo, Kazuya; Fukui, Yasuo; Tokuda, Kazuki; Kawamura, Akiko; Tachihara, Kengo; 12.11921186108871 0.39603430117649135 0.0 uid://A002/X5d7935/X366 uid://A002/X5d7935/X369 uid://A002/X7ebc8f/X3ad Probing a mass distribution of the central 1000AU toward a dense core very close to a moment of the first protostellar core phase in Taurus S BANDPASS 25.127508103045294 20.085598402831696 Y 1 Low-mass star formation ISM and star formation 2012.1.00239.S 2012.1.01099.S J0501-0159 75.30337450000002 -1.9872933888888886 201.45102807394835 -25.295594503874504 [3] 8.757428614331683 31250.0 12m7m 604.8 2015-10-07 [92.03..93.96GHz,31250.00kHz, XX YY] U [93.96..95.90GHz,31250.00kHz, XX YY] U [104.03..105.96GHz,31250.00kHz, XX YY] U [106.03..107.96GHz,31250.00kHz, XX YY] 86781.2499384874 XX YY 2014-03-24 23:13:49 Kargaltsev, Oleg Crab_93_7m Nyman, Lars-Ake; Dubner, Gloria; Bietenholz, Michael; Bykov, Andrei; Pavlov, George; Durant, Martin; Castelletti, Gabriela; 15.251253829346858 0.3205647303908716 1.6180438 uid://A002/X5d7935/Xfe uid://A002/X5d7935/X101 uid://A002/X7d76cc/X2c2 The Crab nebula at 100GHz: filling in the gap S BANDPASS WVR 63.003417935422995 36.143275261579106 Y 1 Pulsars and neutron stars Stars and stellar evolution 2012.1.01099.S 2013.1.00991.S J0501-0159 75.30337450000002 -1.9872933888888886 201.45102807394835 -25.295594503874504 [3] 2.290930262118716 3906.25 12m 302.4 2015-12-19 [98.62..100.62GHz,125000.00kHz, XX YY] U [100.44..102.44GHz,125000.00kHz, XX YY] U [110.67..112.55GHz,3906.25kHz, XX YY] U [112.54..114.42GHz,3906.25kHz, XX YY] 10235.24855164992 XX YY 2014-12-04 06:33:51 König, Sabine NGC_1614_a_03_TC Xu, C. Kevin; Gallagher III, John; Aalto, Susanne; Muller, Sebastien; Beswick, Rob; Evans, Aaron; 2.342064493135897 0.05370997586123042 2.3654366 uid://A001/X122/X4ae uid://A001/X122/X4b1 uid://A002/X95c8aa/X114d The full anatomy of a minor merger S BANDPASS WVR 59.145018638240984 13.472502524562644 Y 2 Merging and interacting galaxies Galaxy evolution 2013.1.00991.S 2013.1.01241.S J0501-0159 75.30337450000002 -1.9872933888888886 201.45102807394835 -25.295594503874508 [6] 0.9576838118131522 1953.125 12m 635.04 2016-03-20 [245.77..247.65GHz,1953.12kHz, XX YY] U [247.71..249.71GHz,31250.00kHz, XX YY] U [261.60..263.61GHz,31250.00kHz, XX YY] U [263.60..265.61GHz,31250.00kHz, XX YY] 2364.3446661623266 XX YY 2014-12-10 04:47:25 Knudsen, Kirsten MS0451_a_06_TE Clément, Benjamin; Drouart, Guillaume; Lindroos, Lukas; Jauzac, Mathilde; Richard, Johan; Kneib, Jean-Paul; Egami, Eiichi; 1.1686126232003695 0.039064632254757745 1.4100766 uid://A001/X145/X371 uid://A001/X145/X372 uid://A002/X9646fb/Xccd Detecting [CII] in two strongly lensed z~6 star-forming galaxies S PHASE WVR 24.63967153491975 5.602773977792555 Y 1 Lyman Break Galaxies (LBG), Gravitational lenses Galaxy evolution 2013.1.01241.S 2013.1.00989.S J0501-0159 75.30337450000002 -1.9872933888888886 201.45102807394835 -25.295594503874504 [7] 0.8506501586433172 31250.0 12m 302.4 2016-03-26 [335.49..337.49GHz,31250.00kHz, XX YY] U [337.43..339.43GHz,31250.00kHz, XX YY] U [347.49..349.49GHz,31250.00kHz, XX YY] U [349.49..351.49GHz,31250.00kHz, XX YY] 26653.960581232415 XX YY 2014-12-12 05:54:58 Akiyama, Kazunori 1ES_0414_a_07_TE Chida, Hikaru; Honma, Mareki; Giroletti, Marcello; Hada, Kazuhiro; Nagai, Hiroshi; Kino, Motoki; Doi, Akihiro; 2.0207960913187057 0.07723551951916573 0.5842098 uid://A001/X120/X57 uid://A001/X120/X58 uid://A002/X969646/X1aa8 Probing the inner-most region of the relativistic jet in extreme TeV blazars S BANDPASS WVR 18.340901017141245 4.185990378585059 Y 1 Active Galactic Nuclei (AGN)/Quasars (QSO) Active galaxies 2013.1.00989.S 2013.1.00662.S J0501-0159 75.30337450000002 -1.9872933888888886 201.45102807394835 -25.295594503874504 [3] 2.88036694386964 61.03515625 12m 302.4 2016-05-04 [90.62..90.68GHz,122.07kHz, XX YY] U [90.94..91.00GHz,122.07kHz, XX YY] U [90.99..92.99GHz,31250.00kHz, XX YY] U [91.93..91.99GHz,61.04kHz, XX YY] U [93.13..93.19GHz,61.04kHz, XX YY] 196.3509360226437 XX YY 2015-01-23 02:56:30 Mardones, Diego OMC-2_a_03_TE Zhang, Qizhou; Ren, Zhiyuan; Zhu, Lei; Rodrigues de Andrade, Lara; Li, Di; 2.070175346308013 0.07710425551191137 4.8240666 uid://A001/X145/Xc3 uid://A001/X145/Xc4 uid://A002/X9a3e71/X1839 Orion 2 & 3 mapping S BANDPASS WVR 68.54857961517044 14.029071168537362 Y 0 High-mass star formation, Pre-stellar cores, Infra-Red Dark Clouds (IRDC) ISM and star formation 2013.1.00662.S 2013.1.00662.S J0501-0159 75.30337450000002 -1.9872933888888886 201.45102807394835 -25.295594503874504 [3] 3.0168028258305783 61.03515625 12m 604.8 2016-05-28 [90.62..90.68GHz,122.07kHz, XX YY] U [90.94..91.00GHz,122.07kHz, XX YY] U [90.99..92.99GHz,31250.00kHz, XX YY] U [91.93..91.99GHz,61.04kHz, XX YY] U [93.13..93.19GHz,61.04kHz, XX YY] 196.35001597663262 XX YY 2015-01-19 03:38:42 Mardones, Diego OMC-3_a_03_TE Zhang, Qizhou; Ren, Zhiyuan; Zhu, Lei; Rodrigues de Andrade, Lara; Li, Di; 1.683431969688719 0.06257117946214086 6.4584036 uid://A001/X145/Xcb uid://A001/X145/Xcc uid://A002/X9a03fb/X404 Orion 2 & 3 mapping S BANDPASS WVR 68.54833469439413 15.05209968376258 Y 0 High-mass star formation, Pre-stellar cores, Infra-Red Dark Clouds (IRDC) ISM and star formation 2013.1.00662.S 2013.1.00553.S J0501-0159 75.30337450000002 -1.9872933888888886 201.45102807394835 -25.295594503874504 [6] 1.2093985256265192 976.5625 12m 302.4 2016-09-25 [219.10..220.04GHz,976.56kHz, XX YY] U [219.76..220.70GHz,976.56kHz, XX YY] U [233.45..234.39GHz,976.56kHz, XX YY] U [235.06..235.99GHz,976.56kHz, XX YY] 1240.564553916522 XX YY 2014-12-29 04:41:20 Goldsmith, Paul BN-KL_c_06_TE Favre, Cecile; Pagani, Laurent; Crockett, Nathan; Bergin, Edwin; Neill, Justin; Snell, Ronald; Melnick, Gary; 1.8246070026778312 0.08525579386795172 1.2921151 uid://A001/X145/X3ef uid://A001/X145/X3f0 uid://A002/X98124f/X59d2 Molecular oxygen in Orion S BANDPASS WVR 27.68646131148405 5.954153991629974 Y 2 Astrochemistry, Inter-Stellar Medium (ISM)/Molecular clouds ISM and star formation 2013.1.00553.S ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... 2013.1.01172.S J0501-0159 75.30337450000002 -1.9872933888888886 201.45102807394835 -25.295594503874504 [3] 2.3595930701018104 1953.125 12m7m 302.4 2016-12-15 [93.84..95.72GHz,1953.12kHz, XX YY] U [95.80..97.67GHz,1953.12kHz, XX YY] U [105.84..107.72GHz,1953.12kHz, XX YY] U [107.53..109.40GHz,1953.12kHz, XX YY] 5352.15399953573 XX YY 2015-03-08 00:14:10 Saito, Toshiki ngc_1614_b_03_TE Kaneko, Hiroyuki; Kawabe, Ryohei; Iono, Daisuke; Ueda, Junko; Lee, Minju; Motohara, Kentaro; Yamashita, Takuji; Tateuchi, Ken; 2.4350386302386013 0.05248179786362813 7.757351 uid://A001/X12a/X1ef uid://A001/X12a/X1f0 uid://A002/X9baf64/X44e CO isotopic ratio enhancement of Pa alpha-selected merging luminous infrared galaxies S BANDPASS WVR 61.994043748337575 12.637057748684889 Y 4 Merging and interacting galaxies, Surveys of galaxies Galaxy evolution 2013.1.01172.S 2013.1.00231.S J0501-0159 75.30337450000002 -1.9872933888888886 201.45102807394835 -25.295594503874504 [7] 0.953307772633577 62500.0 12m 302.4 2017-03-11 [335.49..337.49GHz,62500.00kHz, XX XY YY] U [337.43..339.43GHz,62500.00kHz, XX XY YY] U [347.49..349.49GHz,62500.00kHz, XX XY YY] U [349.49..351.49GHz,62500.00kHz, XX XY YY] 53309.106064531035 XX XY YX YY 2015-01-30 02:27:50 Takahashi, Satoko MMS1_a_07_TE Frau, Pau; Fomalont, Ed; Tomisaka, Kohji; Girart, Josep; Teixeira, Paula Stella; Ho, Paul; Nakanishi, Kouichiro; Rao, Ramprasad; Machida, Masahiro; 10.411502744458282 0.4164091869220925 9.157613 uid://A001/X144/X109 uid://A001/X144/X10a uid://A002/X9ab617/Xad3 Revealing Magnetic Field Structures: Intermediate-mass Prestellar and Protostellar Cores in OMC-3 S BANDPASS WVR 18.340901017141245 4.700670769861588 Y 0 Intermediate-mass star formation ISM and star formation 2013.1.00231.S 2013.1.00231.S J0501-0159 75.30337450000002 -1.9872933888888886 201.45102807394835 -25.295594503874504 [7] 0.8816711326750065 62500.0 12m 302.4 2017-03-14 [335.49..337.49GHz,62500.00kHz, XX XY YY] U [337.43..339.43GHz,62500.00kHz, XX XY YY] U [347.49..349.49GHz,62500.00kHz, XX XY YY] U [349.49..351.49GHz,62500.00kHz, XX XY YY] 53309.106064531035 XX XY YX YY 2015-03-08 23:47:11 Takahashi, Satoko MMS3_a_07_TE Frau, Pau; Fomalont, Ed; Tomisaka, Kohji; Girart, Josep; Teixeira, Paula Stella; Ho, Paul; Nakanishi, Kouichiro; Rao, Ramprasad; Machida, Masahiro; 12.529653591697521 0.5011248608959291 8.057212 uid://A001/X144/X10d uid://A001/X144/X10e uid://A002/X9bb7a8/X3cb Revealing Magnetic Field Structures: Intermediate-mass Prestellar and Protostellar Cores in OMC-3 S BANDPASS WVR 18.340901017141245 4.347927516357693 Y 0 Intermediate-mass star formation ISM and star formation 2013.1.00231.S 2015.1.00187.S J0501-0159 75.30337451254768 -1.9872934027785436 201.45102809412754 -25.29559449971227 [6] 0.8622546477892415 976.5625 12m 90.72 2017-05-03 [226.22..228.09GHz,976.56kHz, XX YY] U [227.98..229.98GHz,31250.00kHz, XX YY] U [240.40..242.28GHz,15625.00kHz, XX YY] U [242.28..244.28GHz,31250.00kHz, XX YY] 1283.5429696666151 XX YY 2016-03-31 22:37:33 Davis, Timothy NGC1684_a_06_TC Greene, Jenny; Blakeslee, John; Ma, Chung-Pei; 3.0626523255689744 0.09946259569971469 2.3756654 uid://A001/X2fe/X21d uid://A001/X2fe/X220 uid://A002/Xb12f3b/X825a Gas in the most MASSIVE Galaxies S PHASE WVR 26.78012554785687 4.031615433172418 Y 0 Early-type galaxies, Galactic centres/nuclei Galaxy evolution 2015.1.00187.S 2015.1.00192.S J0501-0159 75.30337451247986 -1.987293402777937 201.45102809409036 -25.29559449977114 [6] 0.23924658514182504 122.0703125 12m 151.2 2017-11-17 [215.94..217.94GHz,31250.00kHz, XX YY] U [219.52..219.64GHz,244.14kHz, XX YY] U [220.36..220.47GHz,244.14kHz, XX YY] U [230.50..230.61GHz,122.07kHz, XX YY] U [233.19..235.19GHz,31250.00kHz, XX YY] 158.68833786092313 XX YY 2016-08-14 11:07:13 van der Plas, Gerrit HD_34282_a_06_TE Casassus, Simon; Cieza, Lucas; Dominik, Carsten; Perez, Sebastian; Maaskant, Koen; Menard, Francois; Hales, Antonio; van den Ancker, Mario; 2.2432769593752138 0.09578634930513447 0.5599583 uid://A001/X2f6/X13f uid://A001/X2f6/X140 uid://A002/Xb6a8c1/Xc3e8 Hunting for gaps in HEABE disks S PHASE WVR 27.929814680666308 1.2034989189607745 Y 1 Disks around high-mass stars Disks and planet formation 2015.1.00192.S 2016.1.00376.S J0501-0159 75.30337451251782 -1.9872934027778366 201.4510280941107 -25.295594499737984 [6] 0.2666927167584506 244.140625 12m 272.16 2017-12-16 [243.48..243.54GHz,244.14kHz, XX YY] U [243.88..243.94GHz,244.14kHz, XX YY] U [244.20..244.26GHz,244.14kHz, XX YY] U [244.90..244.96GHz,244.14kHz, XX YY] U [245.27..247.14GHz,1953.12kHz, XX YY] U [257.49..257.55GHz,244.14kHz, XX YY] U [258.22..258.28GHz,244.14kHz, XX YY] U [258.97..259.03GHz,244.14kHz, XX YY] U [259.29..259.35GHz,244.14kHz, XX YY] U [260.44..260.55GHz,244.14kHz, XX YY] U [261.79..261.85GHz,244.14kHz, XX YY] U [262.05..262.11GHz,244.14kHz, XX YY] 279.24488312242477 XX YY 2016-10-28 07:34:41 López-Sepulcre, Ana omc_c1_a_06_TM1 Sakai, Nami; Watanabe, Yoshimasa; Oya, Yoko; Ceccarelli, Cecilia; Yamamoto, Satoshi; Imai, Muneaki; Lefloch, Bertrand; 1.5504846246563257 0.08979615734587003 0.47590235 uid://A001/X892/X89 uid://A001/X892/X8a uid://A002/Xb9dfa4/Xa3b1 Surveying the chemical nature of protostars in OMC-2/3 S PHASE WVR 24.92140385203151 1.2645303611756231 Y 0 Astrochemistry ISM and star formation 2016.1.00376.S 2016.1.00683.S J0501-0159 75.30337451250492 -1.9872934027777707 201.45102809410366 -25.295594499749196 [6] 0.4666566678705506 1953.125 12m 60.48 2018-02-22 [226.24..228.11GHz,1953.12kHz, XX YY] U [228.00..230.00GHz,31250.00kHz, XX YY] U [240.42..242.30GHz,15625.00kHz, XX YY] U [242.30..244.30GHz,31250.00kHz, XX YY] 2566.8722554104734 XX YY 2016-11-29 04:59:46 Ma, Chung-Pei NGC1684_a_06_TM2 Greene, Jenny; Blakeslee, John; Davis, Timothy; 3.42142477457462 0.11095069387234291 1.4496403 uid://A001/X8a2/Xd uid://A001/X8a2/X10 uid://A002/Xbb30f0/X1ae5 Black hole mass measurements in the most MASSIVE Galaxies S PHASE WVR 26.777858699842717 2.2843174660864127 Y 1 Early-type galaxies, Galactic centres/nuclei Galaxy evolution 2016.1.00683.S 2016.1.01082.S J0501-0159 75.3033745125108 -1.9872934027785742 201.45102809410764 -25.295594499744467 [6] 5.463150245780173 122.0703125 7m 1935.36 2018-04-25 [216.60..217.60GHz,976.56kHz, XX YY] U [219.52..219.59GHz,244.14kHz, XX YY] U [219.91..219.97GHz,244.14kHz, XX YY] U [220.33..220.45GHz,244.14kHz, XX YY] U [230.50..230.56GHz,122.07kHz, XX YY] U [231.18..231.25GHz,122.07kHz, XX YY] U [234.89..235.39GHz,488.28kHz, XX YY] 158.25515857281786 XX YY 2016-11-25 03:12:13 Moraghan, Anthony HH_212_a_06_7M Lee, Chin-Fei; Huang, Po-Sheng; Jhan, Kai-Syun; 6.277136235560044 0.4004880175653124 0.0 uid://A001/X87d/X14c uid://A001/X87d/X14d uid://A002/Xbb111e/X3bf To what extent is the protostellar outflow HH 212 driven by collimated jets? S PHASE WVR 27.876625386846406 22.42941563246038 Y 0 Outflows, jets and ionized winds, Low-mass star formation ISM and star formation 2016.1.01082.S 2016.2.00006.S J0501-0159 75.303374512496 -1.987293402777795 201.4510280940989 -25.295594499757005 [3] 11.750108943352823 976.5625 7m 302.4 2018-06-02 [96.11..98.11GHz,31250.00kHz, XX YY] U [97.86..99.86GHz,31250.00kHz, XX YY] U [108.11..110.11GHz,31250.00kHz, XX YY] U [109.86..111.86GHz,976.56kHz, XX YY] 2617.226537698543 XX YY 2017-05-09 17:52:19 Ueda, Junko Arp_187_a_03_7M Kaneko, Hiroyuki; Narayanan, Desika; Espada, Daniel; Tamura, Yoichi; Komugi, Shinya; Yun, Min; Iono, Daisuke; Crocker, Alison; Wilner, David; 17.368484815002613 0.3731670984110732 0.0 uid://A001/X1232/X21e uid://A001/X1232/X21f uid://A002/Xc02418/X6f8f Recovering Extended Structures in Merger Remnants S PHASE WVR 60.58469393131945 43.35026949896239 Y 0 Merging and interacting galaxies Galaxy evolution 2016.2.00006.S 2016.1.00209.S J0501-0159 75.30337451255684 -1.9872934027798645 201.4510280941338 -25.295594499704926 [6] 7.531850500398277 30.517578125 7m 241.92 2018-06-20 [215.86..217.90GHz,976.56kHz, XX YY] U [219.49..219.59GHz,61.04kHz, XX YY] U [220.33..220.43GHz,61.04kHz, XX YY] U [230.47..230.57GHz,30.52kHz, XX YY] U [231.16..233.20GHz,976.56kHz, XX YY] 39.680505499430495 XX YY 2016-10-10 11:41:07 Takami, Michihiro Haro_5a__a_06_7M Dong, Ruobing; Kospal, Agnes; Green, Joel; Henning, Thomas; Fehér, Orsolya; Dunham, Michael; Liu, Hauyu Baobab; Csengeri, Timea; Kudo, Tomoyuki; Hashimoto, Jun; Chen, Lei; Abraham, Peter; Vorobyov, Eduard; Hogerheijde, Michiel; 17.751492603463422 0.7550616865526173 0.0 uid://A001/X87a/X968 uid://A001/X87a/X96d uid://A002/Xb9356a/X5236 Multi-scale disk and envelope kinematics around the most extremely accreting young stars S PHASE WVR 28.06088756108639 22.57769041271884 Y 0 Low-mass star formation ISM and star formation 2016.1.00209.S
In [8]:
proj3 = []
proj4 = []
proj6 = []
proj7 = []
proj8 = []
proj9 = []
projelse = []
for i, p, in enumerate(table['Project code']):
if table['Band'][i][0] == 3:
proj3.append([p, table['Band'][i][0], table['Integration'][i]])
elif table['Band'][i][0] == 4:
proj4.append([p, table['Band'][i][0], table['Integration'][i]])
elif table['Band'][i][0] == 6:
proj6.append([p, table['Band'][i][0], table['Integration'][i]])
elif table['Band'][i][0] == 7:
proj7.append([p, table['Band'][i][0], table['Integration'][i]])
elif table['Band'][i][0] == 8:
proj8.append([p, table['Band'][i][0], table['Integration'][i]])
elif table['Band'][i][0] == 9:
proj9.append([p, table['Band'][i][0], table['Integration'][i]])
else:
projelse.append([p, table['Band'][i][0], table['Integration'][i]])
In [9]:
print("Band3:")
for i in proj3:
print(i)
print("Band4:")
for i in proj4:
print(i)
print("Band6:")
for i in proj6:
print(i)
print("Band7:")
for i in proj7:
print(i)
print("Band8:")
for i in proj8:
print(i)
print("Band9:")
for i in proj9:
print(i)
print("Else:")
for i in projelse:
print(i)
Band3:
['2012.1.00219.S', 3, 937.44]
['2012.1.01099.S', 3, 604.8]
['2013.1.00991.S', 3, 302.4]
['2013.1.00662.S', 3, 302.4]
['2013.1.00662.S', 3, 604.8]
['2013.1.00662.S', 3, 6048.0]
['2013.1.00662.S', 3, 604.8]
['2013.1.01172.S', 3, 302.4]
['2016.2.00006.S', 3, 302.4]
Band4:
Band6:
['2012.1.00239.S', 6, 604.8]
['2013.1.01241.S', 6, 635.04]
['2013.1.00553.S', 6, 302.4]
['2015.1.00187.S', 6, 90.72]
['2015.1.00192.S', 6, 151.2]
['2016.1.00376.S', 6, 272.16]
['2016.1.00683.S', 6, 60.48]
['2016.1.01082.S', 6, 1935.36]
['2016.1.00209.S', 6, 241.92]
Band7:
['2013.1.00989.S', 7, 302.4]
['2015.1.01558.T', 7, 181.44]
['2013.1.00231.S', 7, 302.4]
['2013.1.00231.S', 7, 302.4]
Band8:
['2013.1.00048.S', 8, 423.36]
Band9:
Else:
In [10]:
projs = [proj3, proj4, proj6, proj7, proj8, proj9, projelse]
bname = ['3', '4', '6', '7', '8', '9', 'else']
In [11]:
for i, arr in enumerate(projs):
pband = []
for p in arr:
pband.append(p[0])
setpband = set(pband)
print("'''Band "+bname[i]+"''':\n")
for p in setpband:
print("[["+p+"]]\n")
print("\n")
'''Band 3''':
[[2013.1.00991.S]]
[[2013.1.00662.S]]
[[2012.1.00219.S]]
[[2016.2.00006.S]]
[[2013.1.01172.S]]
[[2012.1.01099.S]]
'''Band 4''':
'''Band 6''':
[[2015.1.00192.S]]
[[2013.1.00553.S]]
[[2016.1.01082.S]]
[[2016.1.00209.S]]
[[2016.1.00376.S]]
[[2012.1.00239.S]]
[[2016.1.00683.S]]
[[2013.1.01241.S]]
[[2015.1.00187.S]]
'''Band 7''':
[[2015.1.01558.T]]
[[2013.1.00989.S]]
[[2013.1.00231.S]]
'''Band 8''':
[[2013.1.00048.S]]
'''Band 9''':
'''Band else''':
In [ ]:
Content source: bosscha/alma-calibrator
Similar notebooks: