Elasticsearch Painless Script入门教程--示例数据-sat.json

{"index":{"_index":"sat"}} {"cds":0,"rtype":"X","sname":"","dname":"","cname":"","enroll12":492835,"NumTstTakr":214262,"AvgScrRead":484,"AvgScrMath":494,"AvgScrWrit":477,"NumGE1500":89840,"PctGE1500":41.93,"year":1516} {"index":{"_index":"sat"}} {"cds":1000000000000,"rtype":"C","sname":"","dname":"","cname":"Alameda","enroll12":16662,"NumTstTakr":8611,"AvgScrRead":517,"AvgScrMath":534,"AvgScrWrit":515,"NumGE1500":4696,"PctGE1500":54.53,"year":1516} {"index":{"_index":"sat"}} {"cds":1100170000000,"rtype":"D","sname":"","dname":"Alameda County Office of Education","cname":"Alameda","enroll12":263,"NumTstTakr":95,"AvgScrRead":395,"AvgScrMath":378,"AvgScrWrit":388,"NumGE1500":6,"PctGE1500":6.32,"year":1516} {"index":{"_index":"sat"}} {"cds":1100170112607,"rtype":"S","sname":"Envision Academy for Arts & Technology","dname":"Alameda County Office of Education","cname":"Alameda","enroll12":88,"NumTstTakr":92,"AvgScrRead":391,"AvgScrMath":376,"AvgScrWrit":386,"NumGE1500":5,"PctGE1500":5.43,"year":1516} {"index":{"_index":"sat"}} {"cds":1611190000000,"rtype":"D","sname":"","dname":"Alameda Unified","cname":"Alameda","enroll12":858,"NumTstTakr":472,"AvgScrRead":527,"AvgScrMath":543,"AvgScrWrit":514,"NumGE1500":301,"PctGE1500":63.77,"year":1516} {"index":{"_index":"sat"}} {"cds":1611190106401,"rtype":"S","sname":"Alameda Science and Technology Institute","dname":"Alameda Unified","cname":"Alameda","enroll12":37,"NumTstTakr":35,"AvgScrRead":572,"AvgScrMath":612,"AvgScrWrit":530,"NumGE1500":30,"PctGE1500":85.71,"year":1516} {"index":{"_index":"sat"}} {"cds":1611190119222,"rtype":"S","sname":"Nea Community Learning Center","dname":"Alameda Unified","cname":"Alameda","enroll12":25,"NumTstTakr":14,"AvgScrRead":0,"AvgScrMath":0,"AvgScrWrit":0,"NumGE1500":0,"PctGE1500":0,"year":1516} {"index":{"_index":"sat"}} {"cds":1611190130229,"rtype":"S","sname":"Alameda High","dname":"Alameda Unified","cname":"Alameda","enroll12":381,"NumTstTakr":255,"AvgScrRead":539,"AvgScrMath":562,"AvgScrWrit":533,"NumGE1500":180,"PctGE1500":70.59,"year":1516} {"index":{"_index":"sat"}} {"cds":1611190130609,"rtype":"S","sname":"Alameda Community Learning Center","dname":"Alameda Unified","cname":"Alameda","enroll12":52,"NumTstTakr":46,"AvgScrRead":538,"AvgScrMath":539,"AvgScrWrit":516,"NumGE1500":30,"PctGE1500":65.22,"year":1516} {"index":{"_index":"sat"}} {"cds":1611190130625,"rtype":"S","sname":"Alternatives in Action","dname":"Alameda Unified","cname":"Alameda","enroll12":31,"NumTstTakr":17,"AvgScrRead":366,"AvgScrMath":365,"AvgScrWrit":359,"NumGE1500":0,"PctGE1500":0,"year":1516} {"index":{"_index":"sat"}} {"cds":1611190132142,"rtype":"S","sname":"Encinal Junior/Senior High","dname":"Alameda Unified","cname":"Alameda","enroll12":243,"NumTstTakr":0,"AvgScrRead":0,"AvgScrMath":0,"AvgScrWrit":0,"NumGE1500":0,"PctGE1500":0,"year":1516} {"index":{"_index":"sat"}} {"cds":1611270000000,"rtype":"D","sname":"","dname":"Albany City Unified","cname":"Alameda","enroll12":300,"NumTstTakr":179,"AvgScrRead":585,"AvgScrMath":607,"AvgScrWrit":575,"NumGE1500":148,"PctGE1500":82.68,"year":1516} {"index":{"_index":"sat"}} {"cds":1611270130450,"rtype":"S","sname":"Albany High","dname":"Albany City Unified","cname":"Alameda","enroll12":285,"NumTstTakr":179,"AvgScrRead":585,"AvgScrMath":607,"AvgScrWrit":575,"NumGE1500":148,"PctGE1500":82.68,"year":1516} {"index":{"_index":"sat"}} {"cds":1611430000000,"rtype":"D","sname":"","dname":"Berkeley Unified","cname":"Alameda","enroll12":922,"NumTstTakr":542,"AvgScrRead":561,"AvgScrMath":559,"AvgScrWrit":553,"NumGE1500":357,"PctGE1500":65.87,"year":1516} {"index":{"_index":"sat"}} {"cds":1611430122697,"rtype":"S","sname":"REALM Charter High","dname":"Berkeley Unified","cname":"Alameda","enroll12":77,"NumTstTakr":38,"AvgScrRead":453,"AvgScrMath":429,"AvgScrWrit":425,"NumGE1500":8,"PctGE1500":21.05,"year":1516} {"index":{"_index":"sat"}} {"cds":1611430131177,"rtype":"S","sname":"Berkeley High","dname":"Berkeley Unified","cname":"Alameda","enroll12":798,"NumTstTakr":504,"AvgScrRead":569,"AvgScrMath":568,"AvgScrWrit":563,"NumGE1500":349,"PctGE1500":69.25,"year":1516} {"index":{"_index":"sat"}} {"cds":1611500000000,"rtype":"D","sname":"","dname":"Castro Valley Unified","cname":"Alameda","enroll12":789,"NumTstTakr":411,"AvgScrRead":535,"AvgScrMath":558,"AvgScrWrit":531,"NumGE1500":264,"PctGE1500":64.23,"year":1516} {"index":{"_index":"sat"}} {"cds":1611500132225,"rtype":"S","sname":"Castro Valley High","dname":"Castro Valley Unified","cname":"Alameda","enroll12":702,"NumTstTakr":410,"AvgScrRead":534,"AvgScrMath":558,"AvgScrWrit":531,"NumGE1500":263,"PctGE1500":64.15,"year":1516} {"index":{"_index":"sat"}} {"cds":1611500135533,"rtype":"S","sname":"Redwood Continuation High","dname":"Castro Valley Unified","cname":"Alameda","enroll12":82,"NumTstTakr":1,"AvgScrRead":0,"AvgScrMath":0,"AvgScrWrit":0,"NumGE1500":0,"PctGE1500":0,"year":1516} {"index":{"_index":"sat"}} {"cds":1611680000000,"rtype":"D","sname":"","dname":"Emery Unified","cname":"Alameda","enroll12":50,"NumTstTakr":26,"AvgScrRead":444,"AvgScrMath":451,"AvgScrWrit":424,"NumGE1500":8,"PctGE1500":30.77,"year":1516} {"index":{"_index":"sat"}} {"cds":1611680132746,"rtype":"S","sname":"Emery Secondary","dname":"Emery Unified","cname":"Alameda","enroll12":50,"NumTstTakr":26,"AvgScrRead":444,"AvgScrMath":451,"AvgScrWrit":424,"NumGE1500":8,"PctGE1500":30.77,"year":1516} {"index":{"_index":"sat"}} {"cds":1611760000000,"rtype":"D","sname":"","dname":"Fremont Unified","cname":"Alameda","enroll12":2548,"NumTstTakr":1483,"AvgScrRead":587,"AvgScrMath":627,"AvgScrWrit":595,"NumGE1500":1151,"PctGE1500":77.61,"year":1516} {"index":{"_index":"sat"}} {"cds":1611760130062,"rtype":"S","sname":"American High","dname":"Fremont Unified","cname":"Alameda","enroll12":444,"NumTstTakr":298,"AvgScrRead":576,"AvgScrMath":610,"AvgScrWrit":576,"NumGE1500":229,"PctGE1500":76.85,"year":1516} {"index":{"_index":"sat"}} {"cds":1611760130435,"rtype":"S","sname":"Vista Alternative","dname":"Fremont Unified","cname":"Alameda","enroll12":17,"NumTstTakr":0,"AvgScrRead":0,"AvgScrMath":0,"AvgScrWrit":0,"NumGE1500":0,"PctGE1500":0,"year":1516} {"index":{"_index":"sat"}} {"cds":1611760130534,"rtype":"S","sname":"Circle of Independent Learning","dname":"Fremont Unified","cname":"Alameda","enroll12":40,"NumTstTakr":3,"AvgScrRead":0,"AvgScrMath":0,"AvgScrWrit":0,"NumGE1500":0,"PctGE1500":0,"year":1516} {"index":{"_index":"sat"}} {"cds":1611760134270,"rtype":"S","sname":"Irvington High","dname":"Fremont Unified","cname":"Alameda","enroll12":553,"NumTstTakr":351,"AvgScrRead":582,"AvgScrMath":641,"AvgScrWrit":601,"NumGE1500":288,"PctGE1500":82.05,"year":1516} {"index":{"_index":"sat"}} {"cds":1611760134452,"rtype":"S","sname":"John F. Kennedy High","dname":"Fremont Unified","cname":"Alameda","enroll12":369,"NumTstTakr":171,"AvgScrRead":484,"AvgScrMath":492,"AvgScrWrit":473,"NumGE1500":67,"PctGE1500":39.18,"year":1516} {"index":{"_index":"sat"}} {"cds":1611760135244,"rtype":"S","sname":"Mission San Jose High","dname":"Fremont Unified","cname":"Alameda","enroll12":545,"NumTstTakr":457,"AvgScrRead":656,"AvgScrMath":706,"AvgScrWrit":677,"NumGE1500":435,"PctGE1500":95.19,"year":1516} {"index":{"_index":"sat"}} {"cds":1611760138693,"rtype":"S","sname":"Washington High","dname":"Fremont Unified","cname":"Alameda","enroll12":425,"NumTstTakr":203,"AvgScrRead":540,"AvgScrMath":564,"AvgScrWrit":531,"NumGE1500":130,"PctGE1500":64.04,"year":1516} {"index":{"_index":"sat"}} {"cds":1611920000000,"rtype":"D","sname":"","dname":"Hayward Unified","cname":"Alameda","enroll12":1490,"NumTstTakr":617,"AvgScrRead":440,"AvgScrMath":448,"AvgScrWrit":437,"NumGE1500":143,"PctGE1500":23.18,"year":1516} {"index":{"_index":"sat"}} {"cds":1611920108670,"rtype":"S","sname":"Leadership Public Schools - Hayward","dname":"Hayward Unified","cname":"Alameda","enroll12":113,"NumTstTakr":105,"AvgScrRead":444,"AvgScrMath":467,"AvgScrWrit":446,"NumGE