qqq000 - 経済統計練習帳

import os
import shutil
import requests
 
str1="%20"
id="1HycIC5UZ34VyshPYcQK5fRV2OPv2wqFUfjEjUMZ3"
urlx="https://www.googleapis.com/fusiontables/v1/query?sql=SELECT"
urlx=urlx+str1+"*"+str1+"FROM"+str1+id+str1
urlx=urlx+"&key=AIzaSyAH0WCAXRIdHdbI-6bnMSN4kVDDZZmGyqY"
 
r = requests.get(urlx)
m=r.text
 
a=[]
de=m.split("]")
for dex in de: 
    d1=dex.split(",")
    for d2 in d1:
        d2=d2.replace("\n","")
        a.append(d2)
print(a)