SQL query 'name' field corrupted

[kirstytaggart]

Describe the bug SQL query 'name' field is corrupted.

To Reproduce Happens when grabbing data from SQL query using python requests.

from astropy.io import ascii import requests url='https://ziggy.ucolick.org/yse/explorer/57/download?format=csv' r = requests.get(url) r.status_code table = ascii.read(r.text) print(table[0]) name ra dec disc_date spec_class status_id filter Recent mag

Expected behavior Is there a way to remove the  characters please?

Desktop (please complete the following information):

• iOS

[davecoulter]

If you follow the link itself, the column headers look correct:

[djones1040]

this is through the 3rd-party SQL explorer module so hard to fix. But possible solutions include doing

select t.name as transient_name

in the query