ｐ２ｐ００９ - 経済統計練習帳

google.load("visualization", "1", {packages:["corechart"]});
var point = new Array();
 var a = new Array();
 var credit = new Array();
 var dic = new Array();
 var number;
 var v = new Array();
 
function sample() {
 
 
 
credit[1]="農林水産業";
credit[2]="鉱業";
credit[3]="製造業";
credit[4]="建設";
credit[5]="電力・ガス・水道";
credit[6]="商業";
credit[7]="金融・保険";
credit[8]="不動産";
credit[9]="運輸・郵便";
credit[10]="情報通信";
credit[11]="公務";
credit[12]="サービス";
credit[13]="分類不明";
credit[14]="内生部門計";
credit[15]="家計外消費支出（列）";
credit[16]="民間消費支出";
credit[17]="一般政府消費支出";
credit[18]="国内総固定資本形成";
credit[19]="在庫純増";
credit[20]="調整項";
credit[21]="国内最終需要計";
credit[22]="国内需要合計";
credit[23]="輸出計";
credit[24]="最終需要計";
credit[25]="需要合計";
credit[26]="（控除）輸入";
credit[27]="（控除）関税";
credit[28]="（控除）輸入品商品税";
credit[29]="（控除）輸入計";
credit[30]="最終需要部門計";
credit[31]="国内生産額";
 
 
 
 
        var query = "SELECT * FROM " +
            '1LeCBrUItth4nVQIiP6iMrXH20kqe7qh6sTjaGG77';
        var encodedQuery = encodeURIComponent(query);
 
        var url = ['https://www.googleapis.com/fusiontables/v1/query'];
        url.push('?sql=' + encodedQuery);
        url.push('&key=AIzaSyAH0WCAXRIdHdbI-6bnMSN4kVDDZZmGyqY');
        url.push('&callback=?');
 
 
 
 
 
        $.ajax({
            url: url.join(''),
            dataType: 'jsonp',
            success: function (data) {
                var rows = data['rows'];
 
 
 
                sx = 0;
for (var i in rows) {
sx=sx+1;
a[sx]=new Array();
for(s=0;s<32;s++){
a[sx][s]=rows[i][s];    
}
}
 
 
                number = sx;
 
 
 
 
 
paint(); 
 
 
 
 
 
            }
        });
 
}
 
function paint(){
 
 
   str1="<table class=\"mdl-data-table mdl-js-data-table mdl-data-table--selectable mdl-shadow--2dp\">";
  str2="<th class=\"mdl-data-table__cell--non-numeric\">";
  str3="<td class=\"mdl-data-table__cell--non-numeric\">";
 
    str=str1;
    str=str+"<thead>";
   str=str+"<tr>";
   str=str+"<th>会社</th>";
for(s=1;s<32;s++){
str=str+"<th>"+credit[s]+"</th>";
}
    str=str+"</tr>"
  str=str+"</thead>";
 
  str=str+"<tbody>";
   for(s=1;s<number+1;s++){
   str=str+"<tr>";
for(sx=0;sx<32;sx++){
str=str+"<td>"+a[s][sx]+"</td>";
}
str=str+"</tr>";
}
str=str+"</table>";
 
 
 
 $("#memo").html(str);
 
 
 
 
}