nb3. Query objects by proposal id or bibliography code

import numpy as np
import pyvo
import pandas as pd
pd.set_option('display.max_columns', None)

service = pyvo.dal.TAPService("https://almascience.eso.org/tap")      # for the EU ALMA TAP service

# service = pyvo.dal.TAPService("https://almascience.nao.ac.jp/tap")  # for the EA ALMA TAP service
# service = pyvo.dal.TAPService("https://almascience.nrao.edu/tap")   # for the NA ALMA TAP service

def query_proposal_id(service, proposal_id):
    """Queries for an ALMA project code
    
       service         pyvo TAPService instance
       proposal_id     ALMA proposal id in the form "2012.1.00123.S" or in the form "ADS/JAO.ALMA#2012.1.00123.S"
       
       returns         pandas table
       """

    query = f""" 
            SELECT *  
            FROM ivoa.obscore  
            WHERE obs_publisher_did like '%{proposal_id}%' 
            """    
    
    return service.search(query).to_table().to_pandas()

def query_bib_reference(service, bibcode):
    """Queries for ALMA observations that have been used in a particular observation
    
       service         pyvo TAPService instance
       bibcode         BibCode in the NASA ADS format, e.g. "2017ApJ...834..140R. ""
                       Also supports part of the BibCode, e.g. "Natur"
       
       returns         pandas table
    """
    
    query = f""" 
            SELECT *  
            FROM ivoa.obscore  
            WHERE bib_reference like '%{bibcode}%' 
            """

    return service.search(query).to_table().to_pandas()

def query_member_ous(service, member_ous_id):
    """Queries for an ALMA Member OUS dataset
    
       service         pyvo TAPService instance
       member_ous_id   ALMA Member OUS dataset ID in the form "uid://A001/X123/X456" 
                       or in the form "uid___A001_X123_X456"
                       
       returns         pandas table
    """                       
    
    query = f""" 
            SELECT * 
            FROM ivoa.obscore  
            WHERE member_ous_uid = '{member_ous_id.replace("___","://").replace("_","/")}'  
            """
    
    return service.search(query).to_table().to_pandas()

def query_proposal_id_and_alma_source_name(service, proposal_id, source_name):
    """queries for a an ALMA project code and also for an ALMA source name
    
       service         pyvo TAPService instance
       proposal_id     ALMA proposal id in the form "2012.1.00123.S" or 
                       in the form "ADS/JAO.ALMA#2012.1.00123.S"
       source_name     ALMA source name as given by the PI in the proposal                
       
       returns         pandas table
    """    
    
    query = f"""  
            SELECT  *  
            FROM ivoa.obscore  
            WHERE obs_publisher_did like '%{proposal_id}%' 
            AND target_name like '%{source_name}%'  
            """
    
    return service.search(query).to_table().to_pandas()