Fusion tables to csv via pandas.

fusion_tables_to_csv.py

import pandas as pd
import json
import urllib2

"""
Strip out the callback parameter from your url
"&callback=jQuery17105043562010396272_1404232573870&_=1404232574998"
"""
url = 'https://www.googleapis.com/fusiontables/v1/query?key=AIzaSyAYkamn8YeEjHRpv892i26Mfv6i09eEdPM&sql=SELECT%20beach_id,%20name,%20county,%20mid_lat,%20mid_lon,%20samples,%20pct_samples_bav,%20loc_valid%20FROM%201uK8UlIIOG59txfGjH2WxrDIr_KIxR9lGixkqTple%20WHERE%20state%20=%20%27FL%27&typed=true'

f = urllib2.urlopen(url)
ftab_json =json.load(f)

ftab_df = pd.DataFrame(ftab_json[u'rows'], columns = ftab_json[u'columns'])

ftab_df.to_csv('ftab.csv')