Hi CD,
After a tremendous first season for CowScout, we’ve been looking at ways to improve our service. One common request we received was to open a public API. CowScout’s API will provide complete access to our information about awards, match results, rankings, OPR, CCWM, and more.
In order for developers to provide some early feedback, we’re releasing a list of example API calls. The API will support JSON, XML, and Excel file downloads. So far JSON and Excel have been implemented in testing. JavaScript and PHP wrappers for the API will be released at launch.
Any feedback or interest is greatly appreciated.
Examples
Examples
[spoiler]
api.php?query=getEventAwards&year=2011&eventCode=SJ
{"year":"2011","eventCode":"SJ","awardName":"Chrysler Team Spirit Award","teamNumber":"812"},{"year":"2011","eventCode":"SJ","awardName":"Coopertition Award","teamNumber":"254"},{"year":"2011","eventCode":"SJ","awardName":"Engineering Excellence Award sponsored by Delphi","teamNumber":"1323"},{"year":"2011","eventCode":"SJ","awardName":"Engineering Inspiration Award","teamNumber":"3256"},{"year":"2011","eventCode":"SJ","awardName":"Entrepreneurship Award sponsored by Kleiner Perkins Caufield and Byers","teamNumber":"1351"},{"year":"2011","eventCode":"SJ","awardName":"General Motors Industrial Design Award","teamNumber":"254"},{"year":"2011","eventCode":"SJ","awardName":"Highest Rookie Seed","teamNumber":"3501"},{"year":"2011","eventCode":"SJ","awardName":"Imagery Award","teamNumber":"100"},{"year":"2011","eventCode":"SJ","awardName":"Innovation in Control Award","teamNumber":"1868"},{"year":"2011","eventCode":"SJ","awardName":"Johnson & Johnson Gracious Professionalism Award","teamNumber":"701"},{"year":"2011","eventCode":"SJ","awardName":"Judge's Award","teamNumber":"115"},{"year":"2011","eventCode":"SJ","awardName":"Motorola Quality Award","teamNumber":"1538"},{"year":"2011","eventCode":"SJ","awardName":"Regional Chairman's Award","teamNumber":"1868"},{"year":"2011","eventCode":"SJ","awardName":"Regional Finalist","teamNumber":"1323"},{"year":"2011","eventCode":"SJ","awardName":"Regional Finalist","teamNumber":"1868"},{"year":"2011","eventCode":"SJ","awardName":"Regional Finalist","teamNumber":"604"},{"year":"2011","eventCode":"SJ","awardName":"Regional Winner","teamNumber":"254"},{"year":"2011","eventCode":"SJ","awardName":"Regional Winner","teamNumber":"1538"},{"year":"2011","eventCode":"SJ","awardName":"Regional Winner","teamNumber":"751"},{"year":"2011","eventCode":"SJ","awardName":"Rookie All Star Award","teamNumber":"3505"},{"year":"2011","eventCode":"SJ","awardName":"Rookie Inspiration Award","teamNumber":"3503"},{"year":"2011","eventCode":"SJ","awardName":"Safety Award","teamNumber":"1622"},{"year":"2011","eventCode":"SJ","awardName":"Website Award","teamNumber":"115"},{"year":"2011","eventCode":"SJ","awardName":"Xerox Creativity Award","teamNumber":"1622"}]
api.php?query=getTeamAwards&teamNumber=1538
{"awardName":"Imagery Award","year":"2006","eventCode":"NV"},{"awardName":"Delphi \"Driving Tomorrow's Technology\" Award","year":"2007","eventCode":"SDC"},{"awardName":"Imagery Award","year":"2007","eventCode":"NV"},{"awardName":"Imagery Award","year":"2008","eventCode":"SDC"},{"awardName":"Engineering Inspiration Award","year":"2008","eventCode":"CA"},{"awardName":"Xerox Creativity Award","year":"2008","eventCode":"CA"},{"awardName":"Woodie Flowers Award","year":"2008","eventCode":"SDC"},{"awardName":"Regional Finalist","year":"2009","eventCode":"SDC"},{"awardName":"Regional Chairman's Award","year":"2009","eventCode":"SDC"},{"awardName":"Imagery Award","year":"2009","eventCode":"NV"},{"awardName":"Woodie Flowers Award","year":"2009","eventCode":"SDC"},{"awardName":"Engineering Excellence Award sponsored by Delphi","year":"2010","eventCode":"SDC"},{"awardName":"Regional Chairman's Award","year":"2010","eventCode":"SDC"},{"awardName":"Engineering Excellence Award sponsored by Delphi","year":"2010","eventCode":"UT"},{"awardName":"Coopertition Award","year":"2010","eventCode":"UT"},{"awardName":"Regional Finalist","year":"2010","eventCode":"UT"},{"awardName":"Regional Chairman's Award","year":"2011","eventCode":"SDC"},{"awardName":"Motorola Quality Award","year":"2011","eventCode":"SJ"},{"awardName":"Regional Winner","year":"2011","eventCode":"SJ"},{"awardName":"Motorola Quality Award","year":"2011","eventCode":"CMP"}]
api.php?query=getCCWM&year=2011&eventCode=SJ
{"8":"-10.09","100":"-20.23","114":"13.49","115":"8.43","192":"4.72","253":"-23.63","254":"55.87","256":"8.54","295":"11.05","581":"-9.27","604":"6.4","649":"-9.69","668":"-8.48","670":"18.07","675":"-14.09","691":"9.67","692":"-1.58","701":"3.99","751":"-3.34","766":"-14.08","812":"3.45","846":"5.77","852":"-5.67","971":"21.38","1072":"-16.06","1280":"1.61","1323":"21.56","1351":"8.88","1458":"3.44","1516":"-24.75","1538":"42.9","1622":"-1.05","1662":"11.79","1700":"-6.35","1868":"36.48","1967":"-19.5","2035":"-3.13","2135":"-27.9","2141":"15.36","2144":"-6.32","2159":"15.42","2367":"-16.02","2456":"4.6","2473":"3.92","2489":"-10.24","2643":"-13.33","2813":"-10.76","2854":"-27.29","3022":"9.11","3045":"-7.92","3256":"9.29","3482":"-6.66","3501":"6.73","3503":"-12.41","3505":"-9.36","3717":"-23.3"}
api.php?query=getTeamCCWMByEvent&year=2011&eventCode=SJ&teamNumber=1538
"42.9"
api.php?query=getEventCodesByYear&year=2011
"STX","WC","Archimedes","AZ","OR","NH","LA","IN","MA","OH","CMP","MD","CO","Curie","DA","DT","ROC","FL","Galileo","KC","ON","ON2","HI","IS","GG","DMN","NV","WW","TX","CA","GL","IL","MN","MN2","NJ","NY","Newton","SWM","NC","CT","OK","SC","GA","PA","PIT","SAC","SDC","LI","WA2","WA","SJ","TN","MO","GT","OC","UT","VA","DC","OC1","WAT","MI","WI","WOR"]
api.php?query=getEventByYearAndCode&year=2011&eventCode=SJ
{"year":"2011","eventCode":"SJ","eventName":"Silicon Valley Regional","week":"5","startTime":"0000-00-00 00:00:00","stopTime":"0000-00-00 00:00:00","venueName":"San Jose State Event Center","address":"290 South 7th Street","city":"San Jose","state":"California","country":"USA","postalCode":"95112","startDay":"1301529600","stopDay":"1301702400"}
api.php?query=getMatch&year=2011&eventCode=SJ&matchNumber=1
{"year":"2011","eventCode":"SJ","matchNumber":"1","time":"9:02 AM","red1":"254","red2":"3717","red3":"2159","blue1":"2813","blue2":"1662","blue3":"971","redScore":"90","blueScore":"60","result":"Red"}
api.php?query=getMatches&year=2011&eventCode=SJ
{"Final 1-1":{"time":"4:08 PM","red1":"254","red2":"1538","red3":"751","blue1":"1323","blue2":"1868","blue3":"604","redScore":"69","blueScore":"61","result":"Red"},"Final 1-2":{"time":"4:20 PM","red1":"254","red2":"751","red3":"1538","blue1":"1323","blue2":"604","blue3":"1868","redScore":"76","blueScore":"65","result":"Red"},"Qtr 1-1":{"time":"1:58 PM","red1":"751","red2":"254","red3":"1538","blue1":"2035","blue2":"675","blue3":"2456","redScore":"109","blueScore":"0","result":"Red"},"Qtr 1-2":{"time":"2:26 PM","red1":"1538","red2":"751","red3":"254","blue1":"2456","blue2":"2035","blue3":"675","redScore":"124","blueScore":"0","result":"Red"},"Qtr 2-1":{"time":"2:06 PM","red1":"1351","red2":"846","red3":"670","blue1":"971","blue2":"1622","blue3":"295","redScore":"80","blueScore":"61","result":"Red"},"Qtr 2-2":{"time":"2:33 PM","red1":"1351","red2":"846","red3":"670","blue1":"971","blue2":"1622","blue3":"295","redScore":"80","blueScore":"101","result":"Blue"},"Qtr 2-3":{"time":"2:53 PM","red1":"846","red2":"670","red3":"1351","blue1":"295","blue2":"1622","blue3":"971","redScore":"60","blueScore":"95","result":"Blue"},"Qtr 3-1":{"time":"2:13 PM","red1":"1868","red2":"1323","red3":"604","blue1":"100","blue2":"2159","blue3":"766","redScore":"77","blueScore":"23","result":"Red"},"Qtr 3-2":{"time":"2:39 PM","red1":"604","red2":"1323","red3":"1868","blue1":"100","blue2":"766","blue3":"2159","redScore":"83","blueScore":"38","result":"Red"},"Qtr 4-1":{"time":"2:19 PM","red1":"2141","red2":"256","red3":"701","blue1":"2473","blue2":"1280","blue3":"192","redScore":"39","blueScore":"59","result":"Blue"},"Qtr 4-2":{"time":"2:46 PM","red1":"701","red2":"2141","red3":"256","blue1":"192","blue2":"1280","blue3":"2473","redScore":"55","blueScore":"33","result":"Red"},"Qtr 4-3":{"time":"3:03 PM","red1":"256","red2":"701","red3":"2141","blue1":"2473","blue2":"1280","blue3":"192","redScore":"26","blueScore":"51","result":"Blue"},"Semi 1-2":{"time":"3:36 PM","red1":"1538","red2":"751","red3":"254","blue1":"1622","blue2":"295","blue3":"971","redScore":"125","blueScore":"85","result":"Red"},"Semi 2-1":{"time":"3:23 PM","red1":"1868","red2":"604","red3":"1323","blue1":"2473","blue2":"192","blue3":"1280","redScore":"53","blueScore":"38","result":"Red"},"Semi 2-2":{"time":"3:45 PM","red1":"604","red2":"1323","red3":"1868","blue1":"1280","blue2":"2473","blue3":"192","redScore":"52","blueScore":"42","result":"Red"},"Semi 1-1":{"time":"3:15 PM","red1":"751","red2":"1538","red3":"254","blue1":"295","blue2":"1622","blue3":"971","redScore":"125","blueScore":"71","result":"Red"},"1":{"time":"9:02 AM","red1":"254","red2":"3717","red3":"2159","blue1":"2813","blue2":"1662","blue3":"971","redScore":"90","blueScore":"60","result":"Red"},"2":{"time":"9:11 AM","red1":"1622","red2":"1458","red3":"115","blue1":"581","blue2":"668","blue3":"1072","redScore":"54","blueScore":"4","result":"Red"},"3":{"time":"9:17 AM","red1":"100","red2":"812","red3":"1351","blue1":"2854","blue2":"192","blue3":"670","redScore":"21","blueScore":"31","result":"Blue"},"4":{"time":"9:23 AM","red1":"1967","red2":"2643","red3":"3022","blue1":"2473","blue2":"766","blue3":"649","redScore":"0","blueScore":"18","result":"Blue"},"5":{"time":"9:30 AM","red1":"256","red2":"2456","red3":"751","blue1":"1516","blue2":"3482","blue3":"675","redScore":"36","blueScore":"8","result":"Red"},"6":{"time":"9:39 AM","red1":"2144","red2":"1700","red3":"3503","blue1":"3256","blue2":"692","blue3":"604","redScore":"0","blueScore":"0","result":"Tie"},"7":{"time":"9:46 AM","red1":"2035","red2":"846","red3":"1323","blue1":"3501","blue2":"1280","blue3":"2489","redScore":"72","blueScore":"16","result":"Red"},"8":{"time":"9:52 AM","red1":"691","red2":"3045","red3":"295","blue1":"1868","blue2":"852","blue3":"2367","redScore":"70","blueScore":"70","result":"Tie"},"9":{"time":"10:00 AM","red1":"701","red2":"8","red3":"2135","blue1":"1538","blue2":"114","blue3":"3505","redScore":"15","blueScore":"60","result":"Blue"},"10":{"time":"10:09 AM","red1":"253","red2":"1072","red3":"2854","blue1":"2141","blue2":"254","blue3":"670","redScore":"0","blueScore":"91","result":"Blue"},"11":{"time":"10:15 AM","red1":"1700","red2":"3256","red3":"2456","blue1":"3717","blue2":"115","blue3":"812","redScore":"42","blueScore":"12","result":"Red"},"12":{"time":"10:19 AM","red1":"2813","red2":"675","red3":"100","blue1":"692","blue2":"2473","blue3":"1622","redScore":"18","blueScore":"55","result":"Blue"},"13":{"time":"10:27 AM","red1":"256","red2":"2643","red3":"2144","blue1":"2159","blue2":"2035","blue3":"691","redScore":"0","blueScore":"30","result":"Blue"},"14":{"time":"10:35 AM","red1":"846","red2":"751","red3":"1280","blue1":"1538","blue2":"668","blue3":"1967","redScore":"30","blueScore":"42","result":"Blue"},"15":{"time":"10:41 AM","red1":"581","red2":"3482","red3":"3501","blue1":"192","blue2":"253","blue3":"8","redScore":"0","blueScore":"30","result":"Blue"},"16":{"time":"10:47 AM","red1":"3045","red2":"1662","red3":"1516","blue1":"604","blue2":"701","blue3":"2489","redScore":"9","blueScore":"53","result":"Blue"},"17":{"time":"10:53 AM","red1":"766","red2":"3505","red3":"971","blue1":"2367","blue2":"2141","blue3":"114","redScore":"32","blueScore":"43","result":"Blue"},"18":{"time":"10:59 AM","red1":"649","red2":"1351","red3":"3503","blue1":"295","blue2":"3022","blue3":"1323","redScore":"3","blueScore":"79","result":"Blue"},"19":{"time":"11:05 AM","red1":"1868","red2":"2135","red3":"675","blue1":"852","blue2":"1458","blue3":"2159","redScore":"6","blueScore":"33","result":"Blue"},"20":{"time":"11:13 AM","red1":"846","red2":"2813","red3":"1622","blue1":"1280","blue2":"115","blue3":"670","redScore":"45","blueScore":"59","result":"Blue"},"21":{"time":"11:20 AM","red1":"1662","red2":"253","red3":"2489","blue1":"2643","blue2":"2456","blue3":"668","redScore":"0","blueScore":"0","result":"Tie"},"22":{"time":"11:27 AM","red1":"3482","red2":"812","red3":"114","blue1":"581","blue2":"3045","blue3":"1967","redScore":"62","blueScore":"0","result":"Red"},"23":{"time":"11:52 AM","red1":"692","red2":"3717","red3":"751","blue1":"1351","blue2":"2367","blue3":"8","redScore":"12","blueScore":"24","result":"Blue"},"24":{"time":"12:00 PM","red1":"3022","red2":"3503","red3":"2854","blue1":"852","blue2":"1516","blue3":"3501","redScore":"0","blueScore":"2","result":"Blue"},"25":{"time":"12:05 PM","red1":"2473","red2":"256","red3":"254","blue1":"3505","blue2":"649","blue3":"295","redScore":"102","blueScore":"45","result":"Red"},"26":{"time":"12:12 PM","red1":"971","red2":"2135","red3":"604","blue1":"3256","blue2":"1072","blue3":"691","redScore":"41","blueScore":"33","result":"Red"},"27":{"time":"12:19 PM","red1":"701","red2":"192","red3":"1458","blue1":"1323","blue2":"1700","blue3":"766","redScore":"0","blueScore":"23","result":"Blue"},"28":{"time":"12:26 PM","red1":"1868","red2":"1538","red3":"2141","blue1":"100","blue2":"2035","blue3":"2144","redScore":"100","blueScore":"0","result":"Red"},"29":{"time":"1:11 PM","red1":"3501","red2":"2367","red3":"3503","blue1":"1516","blue2":"668","blue3":"670","redScore":"0","blueScore":"36","result":"Blue"},"30":{"time":"1:16 PM","red1":"2159","red2":"2854","red3":"692","blue1":"2473","blue2":"2456","blue3":"3045","redScore":"6","blueScore":"27","result":"Blue"},"31":{"time":"1:24 PM","red1":"1280","red2":"852","red3":"675","blue1":"114","blue2":"253","blue3":"254","redScore":"50","blueScore":"72","result":"Blue"},"32":{"time":"1:30 PM","red1":"846","red2":"3022","red3":"1458","blue1":"1622","blue2":"3256","blue3":"701","redScore":"33","blueScore":"44","result":"Blue"},"33":{"time":"1:38 PM","red1":"649","red2":"2035","red3":"1662","blue1":"2135","blue2":"115","blue3":"3482","redScore":"45","blueScore":"4","result":"Red"},"34":{"time":"1:44 PM","red1":"581","red2":"2813","red3":"2489","blue1":"751","blue2":"3505","blue3":"2144","redScore":"0","blueScore":"9","result":"Blue"},"35":{"time":"1:54 PM","red1":"1072","red2":"2643","red3":"2141","blue1":"256","blue2":"192","blue3":"3717","redScore":"20","blueScore":"46","result":"Blue"},"36":{"time":"2:00 PM","red1":"1700","red2":"1538","red3":"691","blue1":"295","blue2":"1967","blue3":"1351","redScore":"80","blueScore":"42","result":"Red"},"37":{"time":"2:10 PM","red1":"1323","red2":"604","red3":"812","blue1":"766","blue2":"100","blue3":"8","redScore":"49","blueScore":"24","result":"Red"},"38":{"time":"2:16 PM","red1":"971","red2":"3503","red3":"670","blue1":"1868","blue2":"1662","blue3":"2456","redScore":"46","blueScore":"71","result":"Blue"},"39":{"time":"2:27 PM","red1":"668","red2":"751","red3":"3256","blue1":"2473","blue2":"114","blue3":"2159","redScore":"36","blueScore":"51","result":"Blue"},"40":{"time":"2:35 PM","red1":"256","red2":"649","red3":"2367","blue1":"1458","blue2":"2144","blue3":"253","redScore":"33","blueScore":"0","result":"Red"},"41":{"time":"2:44 PM","red1":"2141","red2":"3505","red3":"2813","blue1":"2643","blue2":"1351","blue3":"3045","redScore":"27","blueScore":"26","result":"Red"},"42":{"time":"2:51 PM","red1":"295","red2":"3501","red3":"701","blue1":"604","blue2":"675","blue3":"581","redScore":"51","blueScore":"41","result":"Red"},"43":{"time":"2:57 PM","red1":"1967","red2":"3482","red3":"691","blue1":"1323","blue2":"2854","blue3":"1622","redScore":"27","blueScore":"34","result":"Blue"},"44":{"time":"3:03 PM","red1":"192","red2":"3022","red3":"692","blue1":"1538","blue2":"2135","blue3":"1280","redScore":"64","blueScore":"76","result":"Blue"},"45":{"time":"3:10 PM","red1":"3717","red2":"766","red3":"1516","blue1":"115","blue2":"100","blue3":"254","redScore":"17","blueScore":"108","result":"Blue"},"46":{"time":"3:18 PM","red1":"8","red2":"852","red3":"812","blue1":"1072","blue2":"2489","blue3":"2035","redScore":"16","blueScore":"36","result":"Blue"},"47":{"time":"3:23 PM","red1":"1868","red2":"971","red3":"581","blue1":"846","blue2":"1700","blue3":"256","redScore":"88","blueScore":"30","result":"Red"},"48":{"time":"3:28 PM","red1":"1662","red2":"2141","red3":"3256","blue1":"1622","blue2":"3501","blue3":"751","redScore":"59","blueScore":"37","result":"Red"},"49":{"time":"3:35 PM","red1":"3482","red2":"1280","red3":"604","blue1":"2473","blue2":"1351","blue3":"1458","redScore":"68","blueScore":"58","result":"Red"},"50":{"time":"3:41 PM","red1":"670","red2":"766","red3":"1538","blue1":"675","blue2":"649","blue3":"691","redScore":"90","blueScore":"21","result":"Red"},"51":{"time":"3:47 PM","red1":"2035","red2":"701","red3":"1516","blue1":"2813","blue2":"1967","blue3":"692","redScore":"21","blueScore":"33","result":"Blue"},"52":{"time":"3:54 PM","red1":"295","red2":"971","red3":"2854","blue1":"8","blue2":"2489","blue3":"2144","redScore":"30","blueScore":"0","result":"Red"},"53":{"time":"4:06 PM","red1":"3505","red2":"253","red3":"668","blue1":"1868","blue2":"3717","blue3":"3022","redScore":"3","blueScore":"42","result":"Blue"},"54":{"time":"4:11 PM","red1":"2456","red2":"852","red3":"114","blue1":"192","blue2":"1700","blue3":"100","redScore":"50","blueScore":"17","result":"Red"},"55":{"time":"4:19 PM","red1":"115","red2":"846","red3":"1072","blue1":"1323","blue2":"2159","blue3":"3045","redScore":"43","blueScore":"46","result":"Blue"},"56":{"time":"4:26 PM","red1":"812","red2":"2367","red3":"2135","blue1":"3503","blue2":"2643","blue3":"254","redScore":"18","blueScore":"70","result":"Blue"},"57":{"time":"4:33 PM","red1":"1458","red2":"2854","red3":"766","blue1":"692","blue2":"1662","blue3":"1538","redScore":"3","blueScore":"101","result":"Blue"},"58":{"time":"4:38 PM","red1":"253","red2":"670","red3":"2035","blue1":"295","blue2":"2473","blue3":"751","redScore":"0","blueScore":"57","result":"Blue"},"59":{"time":"4:46 PM","red1":"2144","red2":"691","red3":"1868","blue1":"1280","blue2":"701","blue3":"3717","redScore":"88","blueScore":"41","result":"Red"},"60":{"time":"9:01 AM","red1":"852","red2":"192","red3":"668","blue1":"649","blue2":"2813","blue3":"604","redScore":"26","blueScore":"42","result":"Blue"},"61":{"time":"9:16 AM","red1":"100","red2":"2159","red3":"1072","blue1":"3482","blue2":"3505","blue3":"3503","redScore":"9","blueScore":"3","result":"Red"},"62":{"time":"9:24 AM","red1":"114","red2":"1700","red3":"581","blue1":"2141","blue2":"1516","blue3":"1323","redScore":"16","blueScore":"63","result":"Blue"},"63":{"time":"9:29 AM","red1":"2489","red2":"3045","red3":"2135","blue1":"1351","blue2":"3501","blue3":"256","redScore":"6","blueScore":"57","result":"Blue"},"64":{"time":"5:44 PM","red1":"8","red2":"254","red3":"2456","blue1":"846","blue2":"2643","blue3":"3256","redScore":"60","blueScore":"47","result":"Red"},"65":{"time":"5:49 PM","red1":"2367","red2":"1967","red3":"115","blue1":"3022","blue2":"675","blue3":"971","redScore":"0","blueScore":"59","result":"Blue"},"66":{"time":"9:35 AM","red1":"1622","red2":"649","red3":"253","blue1":"812","blue2":"701","blue3":"2159","redScore":"12","blueScore":"60","result":"Blue"},"67":{"time":"9:45 AM","red1":"1323","red2":"1868","red3":"1458","blue1":"2854","blue2":"2813","blue3":"751","redScore":"90","blueScore":"15","result":"Red"},"68":{"time":"9:50 AM","red1":"295","red2":"100","red3":"256","blue1":"1662","blue2":"668","blue3":"1280","redScore":"29","blueScore":"59","result":"Blue"},"69":{"time":"9:56 AM","red1":"1700","red2":"2473","red3":"2141","blue1":"8","blue2":"691","blue3":"3503","redScore":"9","blueScore":"0","result":"Red"},"70":{"time":"10:06 AM","red1":"670","red2":"3482","red3":"846","blue1":"852","blue2":"3505","blue3":"3717","redScore":"51","blueScore":"26","result":"Red"},"71":{"time":"10:10 AM","red1":"2144","red2":"1351","red3":"971","blue1":"1516","blue2":"812","blue3":"1622","redScore":"89","blueScore":"60","result":"Red"},"72":{"time":"10:17 AM","red1":"766","red2":"1967","red3":"2456","blue1":"3501","blue2":"1072","blue3":"2135","redScore":"30","blueScore":"6","result":"Red"},"73":{"time":"10:23 AM","red1":"192","red2":"3256","red3":"2035","blue1":"675","blue2":"2367","blue3":"3045","redScore":"34","blueScore":"5","result":"Red"},"74":{"time":"10:29 AM","red1":"692","red2":"254","red3":"581","blue1":"3022","blue2":"2489","blue3":"1538","redScore":"85","blueScore":"65","result":"Red"},"75":{"time":"10:44 AM","red1":"604","red2":"115","red3":"295","blue1":"114","blue2":"2643","blue3":"2854","redScore":"69","blueScore":"42","result":"Red"},"76":{"time":"10:53 AM","red1":"3505","red2":"8","red3":"1516","blue1":"1458","blue2":"691","blue3":"1280","redScore":"0","blueScore":"80","result":"Blue"},"77":{"time":"10:59 AM","red1":"2813","red2":"766","red3":"1351","blue1":"253","blue2":"846","blue3":"3503","redScore":"36","blueScore":"60","result":"Blue"},"78":{"time":"11:04 AM","red1":"675","red2":"701","red3":"668","blue1":"3482","blue2":"971","blue3":"2141","redScore":"66","blueScore":"94","result":"Blue"},"79":{"time":"11:16 AM","red1":"2144","red2":"1662","red3":"3022","blue1":"1700","blue2":"3045","blue3":"1072","redScore":"9","blueScore":"0","result":"Red"},"80":{"time":"11:24 AM","red1":"3717","red2":"3501","red3":"114","blue1":"649","blue2":"812","blue3":"692","redScore":"44","blueScore":"13","result":"Red"},"81":{"time":"11:32 AM","red1":"256","red2":"1538","red3":"852","blue1":"1323","blue2":"2367","blue3":"3256","redScore":"86","blueScore":"63","result":"Red"},"82":{"time":"11:39 AM","red1":"2135","red2":"2159","red3":"2643","blue1":"581","blue2":"670","blue3":"100","redScore":"0","blueScore":"18","result":"Blue"},"83":{"time":"11:44 AM","red1":"1967","red2":"2473","red3":"2489","blue1":"1868","blue2":"115","blue3":"192","redScore":"28","blueScore":"54","result":"Blue"},"84":{"time":"11:50 AM","red1":"1622","red2":"604","red3":"2456","blue1":"751","blue2":"254","blue3":"2035","redScore":"32","blueScore":"87","result":"Blue"},"85":{"time":"11:56 AM","red1":"8","red2":"1662","red3":"114","blue1":"2813","blue2":"691","blue3":"3022","redScore":"18","blueScore":"19","result":"Blue"},"86":{"time":"12:02 PM","red1":"3505","red2":"1280","red3":"2367","blue1":"2854","blue2":"1700","blue3":"649","redScore":"30","blueScore":"30","result":"Tie"},"87":{"time":"12:09 PM","red1":"100","red2":"2643","red3":"852","blue1":"971","blue2":"1458","blue3":"3501","redScore":"26","blueScore":"83","result":"Blue"},"88":{"time":"12:14 PM","red1":"692","red2":"1516","red3":"1072","blue1":"295","blue2":"1868","blue3":"846","redScore":"10","blueScore":"99","result":"Blue"},"89":{"time":"12:19 PM","red1":"3503","red2":"192","red3":"751","blue1":"701","blue2":"256","blue3":"115","redScore":"30","blueScore":"68","result":"Blue"},"90":{"time":"12:24 PM","red1":"1351","red2":"3256","red3":"581","blue1":"2035","blue2":"668","blue3":"766","redScore":"97","blueScore":"23","result":"Red"},"91":{"time":"12:32 PM","red1":"2489","red2":"670","red3":"2159","blue1":"2141","blue2":"604","blue3":"1967","redScore":"29","blueScore":"18","result":"Red"},"92":{"time":"12:37 PM","red1":"3482","red2":"1323","red3":"2473","blue1":"2144","blue2":"2135","blue3":"254","redScore":"25","blueScore":"86","result":"Blue"},"93":{"time":"12:45 PM","red1":"1622","red2":"3045","red3":"1538","blue1":"253","blue2":"3717","blue3":"2456","redScore":"86","blueScore":"22","result":"Red"},"94":{"time":"12:50 PM","red1":"675","red2":"846","red3":"1662","blue1":"812","blue2":"1280","blue3":"2643","redScore":"59","blueScore":"50","result":"Red"}}
api.php?query=getTeamMatches&year=2011&eventCode=SJ&teamNumber=1538
{"Final 1-1":{"time":"4:08 PM","red1":"254","red2":"1538","red3":"751","blue1":"1323","blue2":"1868","blue3":"604","redScore":"69","blueScore":"61","result":"Red"},"Final 1-2":{"time":"4:20 PM","red1":"254","red2":"751","red3":"1538","blue1":"1323","blue2":"604","blue3":"1868","redScore":"76","blueScore":"65","result":"Red"},"Qtr 1-1":{"time":"1:58 PM","red1":"751","red2":"254","red3":"1538","blue1":"2035","blue2":"675","blue3":"2456","redScore":"109","blueScore":"0","result":"Red"},"Qtr 1-2":{"time":"2:26 PM","red1":"1538","red2":"751","red3":"254","blue1":"2456","blue2":"2035","blue3":"675","redScore":"124","blueScore":"0","result":"Red"},"Semi 1-2":{"time":"3:36 PM","red1":"1538","red2":"751","red3":"254","blue1":"1622","blue2":"295","blue3":"971","redScore":"125","blueScore":"85","result":"Red"},"Semi 1-1":{"time":"3:15 PM","red1":"751","red2":"1538","red3":"254","blue1":"295","blue2":"1622","blue3":"971","redScore":"125","blueScore":"71","result":"Red"},"9":{"time":"10:00 AM","red1":"701","red2":"8","red3":"2135","blue1":"1538","blue2":"114","blue3":"3505","redScore":"15","blueScore":"60","result":"Blue"},"14":{"time":"10:35 AM","red1":"846","red2":"751","red3":"1280","blue1":"1538","blue2":"668","blue3":"1967","redScore":"30","blueScore":"42","result":"Blue"},"28":{"time":"12:26 PM","red1":"1868","red2":"1538","red3":"2141","blue1":"100","blue2":"2035","blue3":"2144","redScore":"100","blueScore":"0","result":"Red"},"36":{"time":"2:00 PM","red1":"1700","red2":"1538","red3":"691","blue1":"295","blue2":"1967","blue3":"1351","redScore":"80","blueScore":"42","result":"Red"},"44":{"time":"3:03 PM","red1":"192","red2":"3022","red3":"692","blue1":"1538","blue2":"2135","blue3":"1280","redScore":"64","blueScore":"76","result":"Blue"},"50":{"time":"3:41 PM","red1":"670","red2":"766","red3":"1538","blue1":"675","blue2":"649","blue3":"691","redScore":"90","blueScore":"21","result":"Red"},"57":{"time":"4:33 PM","red1":"1458","red2":"2854","red3":"766","blue1":"692","blue2":"1662","blue3":"1538","redScore":"3","blueScore":"101","result":"Blue"},"74":{"time":"10:29 AM","red1":"692","red2":"254","red3":"581","blue1":"3022","blue2":"2489","blue3":"1538","redScore":"85","blueScore":"65","result":"Red"},"81":{"time":"11:32 AM","red1":"256","red2":"1538","red3":"852","blue1":"1323","blue2":"2367","blue3":"3256","redScore":"86","blueScore":"63","result":"Red"},"93":{"time":"12:45 PM","red1":"1622","red2":"3045","red3":"1538","blue1":"253","blue2":"3717","blue3":"2456","redScore":"86","blueScore":"22","result":"Red"}}
api.php?query=getEventOPR&year=2011&eventCode=SJ
{"8":"-6","100":"1.4","114":"22.6","115":"14.74","192":"16.46","253":"-2.89","254":"71.59","256":"15.59","295":"28.86","581":"5.44","604":"13.15","649":"6.51","668":"7.28","670":"13.28","675":"6.71","691":"22.78","692":"9.92","701":"20.87","751":"6.64","766":"7.68","812":"13.52","846":"27.64","852":"14.12","971":"42.76","1072":"2.22","1280":"27.37","1323":"30.25","1351":"28.29","1458":"9.4","1516":"3","1538":"55.88","1622":"19.82","1662":"15.8","1700":"-2.74","1868":"37.73","1967":"-4.86","2035":"5.93","2135":"-8.14","2141":"17.42","2144":"3.75","2159":"10.37","2367":"4.98","2456":"11.59","2473":"12.5","2489":"4.96","2643":"-0.12","2813":"6.3","2854":"-3.89","3022":"5.86","3045":"2.74","3256":"19.14","3482":"8.34","3501":"3.78","3503":"-3.3","3505":"-2.07","3717":"4.35"}
api.php?query=getTeamOPRByEvent&year=2011&eventCode=SJ&teamNumber=1538
"55.88"
api.php?query=getTeamEventRanking&year=2011&eventCode=SJ&teamNumber=1538
{"rank":"2","wins":"9","loss":"1","ties":"0","played":"10","qs":"18.00","rs":"34.90","highScore":"","seedingScore":"","coopertitionBonus":"","hangingPoints":"","average":""}
api.php?query=getEventRank&year=2011&eventCode=SJ&rank=1
{"teamNumber":"254","wins":"10","loss":"0","ties":"0","played":"10","qs":"20.00","rs":"39.50","highScore":"","seedingScore":"","coopertitionBonus":"","hangingPoints":"","average":""}
api.php?query=getEventRankings&year=2011&eventCode=SJ
{"1":{"teamNumber":"254","wins":"10","loss":"0","ties":"0","played":"10","qs":"20.00","rs":"39.50","highScore":"","seedingScore":"","coopertitionBonus":"","hangingPoints":"","average":""},"2":{"teamNumber":"1538","wins":"9","loss":"1","ties":"0","played":"10","qs":"18.00","rs":"34.90","highScore":"","seedingScore":"","coopertitionBonus":"","hangingPoints":"","average":""},"3":{"teamNumber":"1323","wins":"8","loss":"2","ties":"0","played":"10","qs":"16.00","rs":"24.40","highScore":"","seedingScore":"","coopertitionBonus":"","hangingPoints":"","average":""},"4":{"teamNumber":"2141","wins":"8","loss":"2","ties":"0","played":"10","qs":"16.00","rs":"24.20","highScore":"","seedingScore":"","coopertitionBonus":"","hangingPoints":"","average":""},"5":{"teamNumber":"670","wins":"8","loss":"2","ties":"0","played":"10","qs":"16.00","rs":"20.10","highScore":"","seedingScore":"","coopertitionBonus":"","hangingPoints":"","average":""},"6":{"teamNumber":"1868","wins":"7","loss":"1","ties":"1","played":"9","qs":"15.00","rs":"27.30","highScore":"","seedingScore":"","coopertitionBonus":"","hangingPoints":"","average":""},"7":{"teamNumber":"971","wins":"7","loss":"3","ties":"0","played":"10","qs":"14.00","rs":"36.20","highScore":"","seedingScore":"","coopertitionBonus":"","hangingPoints":"","average":""},"8":{"teamNumber":"256","wins":"7","loss":"3","ties":"0","played":"10","qs":"14.00","rs":"23.40","highScore":"","seedingScore":"","coopertitionBonus":"","hangingPoints":"","average":""},"9":{"teamNumber":"2473","wins":"7","loss":"3","ties":"0","played":"10","qs":"14.00","rs":"22.20","highScore":"","seedingScore":"","coopertitionBonus":"","hangingPoints":"","average":""},"10":{"teamNumber":"2159","wins":"7","loss":"1","ties":"0","played":"8","qs":"14.00","rs":"19.30","highScore":"","seedingScore":"","coopertitionBonus":"","hangingPoints":"","average":""},"11":{"teamNumber":"2456","wins":"7","loss":"1","ties":"0","played":"8","qs":"14.00","rs":"17.90","highScore":"","seedingScore":"","coopertitionBonus":"","hangingPoints":"","average":""},"12":{"teamNumber":"604","wins":"6","loss":"3","ties":"1","played":"10","qs":"13.00","rs":"29.20","highScore":"","seedingScore":"","coopertitionBonus":"","hangingPoints":"","average":""},"13":{"teamNumber":"295","wins":"6","loss":"3","ties":"1","played":"10","qs":"13.00","rs":"29.10","highScore":"","seedingScore":"","coopertitionBonus":"","hangingPoints":"","average":""},"14":{"teamNumber":"115","wins":"6","loss":"4","ties":"0","played":"10","qs":"12.00","rs":"24.60","highScore":"","seedingScore":"","coopertitionBonus":"","hangingPoints":"","average":""},"15":{"teamNumber":"114","wins":"6","loss":"3","ties":"0","played":"9","qs":"12.00","rs":"21.90","highScore":"","seedingScore":"","coopertitionBonus":"","hangingPoints":"","average":""},"16":{"teamNumber":"2035","wins":"6","loss":"3","ties":"0","played":"9","qs":"12.00","rs":"12.90","highScore":"","seedingScore":"","coopertitionBonus":"","hangingPoints":"","average":""},"17":{"teamNumber":"3256","wins":"5","loss":"4","ties":"1","played":"10","qs":"11.00","rs":"29.80","highScore":"","seedingScore":"","coopertitionBonus":"","hangingPoints":"","average":""},"18":{"teamNumber":"691","wins":"5","loss":"3","ties":"1","played":"9","qs":"11.00","rs":"26.70","highScore":"","seedingScore":"","coopertitionBonus":"","hangingPoints":"","average":""},"19":{"teamNumber":"1622","wins":"5","loss":"5","ties":"0","played":"10","qs":"10.00","rs":"30.20","highScore":"","seedingScore":"","coopertitionBonus":"","hangingPoints":"","average":""},"20":{"teamNumber":"701","wins":"5","loss":"5","ties":"0","played":"10","qs":"10.00","rs":"27.10","highScore":"","seedingScore":"","coopertitionBonus":"","hangingPoints":"","average":""},"21":{"teamNumber":"192","wins":"5","loss":"5","ties":"0","played":"10","qs":"10.00","rs":"23.80","highScore":"","seedingScore":"","coopertitionBonus":"","hangingPoints":"","average":""},"22":{"teamNumber":"3022","wins":"5","loss":"5","ties":"0","played":"10","qs":"10.00","rs":"19.50","highScore":"","seedingScore":"","coopertitionBonus":"","hangingPoints":"","average":""},"23":{"teamNumber":"1662","wins":"5","loss":"2","ties":"0","played":"7","qs":"10.00","rs":"19.40","highScore":"","seedingScore":"","coopertitionBonus":"","hangingPoints":"","average":""},"24":{"teamNumber":"3501","wins":"5","loss":"5","ties":"0","played":"10","qs":"10.00","rs":"15.40","highScore":"","seedingScore":"","coopertitionBonus":"","hangingPoints":"","average":""},"25":{"teamNumber":"1700","wins":"4","loss":"3","ties":"2","played":"9","qs":"10.00","rs":"14.00","highScore":"","seedingScore":"","coopertitionBonus":"","hangingPoints":"","average":""},"26":{"teamNumber":"1280","wins":"4","loss":"5","ties":"1","played":"10","qs":"9.00","rs":"37.40","highScore":"","seedingScore":"","coopertitionBonus":"","hangingPoints":"","average":""},"27":{"teamNumber":"852","wins":"4","loss":"5","ties":"1","played":"10","qs":"9.00","rs":"30.90","highScore":"","seedingScore":"","coopertitionBonus":"","hangingPoints":"","average":""},"28":{"teamNumber":"692","wins":"4","loss":"5","ties":"1","played":"10","qs":"9.00","rs":"21.80","highScore":"","seedingScore":"","coopertitionBonus":"","hangingPoints":"","average":""},"29":{"teamNumber":"649","wins":"4","loss":"5","ties":"1","played":"10","qs":"9.00","rs":"15.40","highScore":"","seedingScore":"","coopertitionBonus":"","hangingPoints":"","average":""},"30":{"teamNumber":"2144","wins":"4","loss":"4","ties":"1","played":"9","qs":"9.00","rs":"11.60","highScore":"","seedingScore":"","coopertitionBonus":"","hangingPoints":"","average":""},"31":{"teamNumber":"846","wins":"4","loss":"5","ties":"0","played":"9","qs":"8.00","rs":"31.40","highScore":"","seedingScore":"","coopertitionBonus":"","hangingPoints":"","average":""},"32":{"teamNumber":"1351","wins":"4","loss":"6","ties":"0","played":"10","qs":"8.00","rs":"29.30","highScore":"","seedingScore":"","coopertitionBonus":"","hangingPoints":"","average":""},"33":{"teamNumber":"2813","wins":"4","loss":"6","ties":"0","played":"10","qs":"8.00","rs":"27.40","highScore":"","seedingScore":"","coopertitionBonus":"","hangingPoints":"","average":""},"34":{"teamNumber":"3717","wins":"4","loss":"6","ties":"0","played":"10","qs":"8.00","rs":"24.10","highScore":"","seedingScore":"","coopertitionBonus":"","hangingPoints":"","average":""},"35":{"teamNumber":"2367","wins":"3","loss":"5","ties":"2","played":"10","qs":"8.00","rs":"23.90","highScore":"","seedingScore":"","coopertitionBonus":"","hangingPoints":"","average":""},"36":{"teamNumber":"3482","wins":"4","loss":"6","ties":"0","played":"10","qs":"8.00","rs":"22.00","highScore":"","seedingScore":"","coopertitionBonus":"","hangingPoints":"","average":""},"37":{"teamNumber":"581","wins":"4","loss":"6","ties":"0","played":"10","qs":"8.00","rs":"18.50","highScore":"","seedingScore":"","coopertitionBonus":"","hangingPoints":"","average":""},"38":{"teamNumber":"751","wins":"4","loss":"5","ties":"0","played":"9","qs":"8.00","rs":"18.20","highScore":"","seedingScore":"","coopertitionBonus":"","hangingPoints":"","average":""},"39":{"teamNumber":"766","wins":"4","loss":"6","ties":"0","played":"10","qs":"8.00","rs":"16.50","highScore":"","seedingScore":"","coopertitionBonus":"","hangingPoints":"","average":""},"40":{"teamNumber":"1458","wins":"4","loss":"5","ties":"0","played":"9","qs":"8.00","rs":"14.10","highScore":"","seedingScore":"","coopertitionBonus":"","hangingPoints":"","average":""},"41":{"teamNumber":"668","wins":"3","loss":"6","ties":"1","played":"10","qs":"7.00","rs":"22.30","highScore":"","seedingScore":"","coopertitionBonus":"","hangingPoints":"","average":""},"42":{"teamNumber":"3045","wins":"3","loss":"5","ties":"1","played":"9","qs":"7.00","rs":"20.20","highScore":"","seedingScore":"","coopertitionBonus":"","hangingPoints":"","average":""},"43":{"teamNumber":"2854","wins":"3","loss":"5","ties":"1","played":"9","qs":"7.00","rs":"14.70","highScore":"","seedingScore":"","coopertitionBonus":"","hangingPoints":"","average":""},"44":{"teamNumber":"1967","wins":"3","loss":"7","ties":"0","played":"10","qs":"6.00","rs":"17.80","highScore":"","seedingScore":"","coopertitionBonus":"","hangingPoints":"","average":""},"45":{"teamNumber":"100","wins":"3","loss":"7","ties":"0","played":"10","qs":"6.00","rs":"16.10","highScore":"","seedingScore":"","coopertitionBonus":"","hangingPoints":"","average":""},"46":{"teamNumber":"1516","wins":"3","loss":"7","ties":"0","played":"10","qs":"6.00","rs":"14.10","highScore":"","seedingScore":"","coopertitionBonus":"","hangingPoints":"","average":""},"47":{"teamNumber":"3505","wins":"2","loss":"6","ties":"1","played":"9","qs":"5.00","rs":"17.40","highScore":"","seedingScore":"","coopertitionBonus":"","hangingPoints":"","average":""},"48":{"teamNumber":"253","wins":"2","loss":"5","ties":"1","played":"8","qs":"5.00","rs":"7.90","highScore":"","seedingScore":"","coopertitionBonus":"","hangingPoints":"","average":""},"49":{"teamNumber":"812","wins":"2","loss":"7","ties":"0","played":"9","qs":"4.00","rs":"22.60","highScore":"","seedingScore":"","coopertitionBonus":"","hangingPoints":"","average":""},"50":{"teamNumber":"675","wins":"2","loss":"7","ties":"0","played":"9","qs":"4.00","rs":"22.10","highScore":"","seedingScore":"","coopertitionBonus":"","hangingPoints":"","average":""},"51":{"teamNumber":"2135","wins":"2","loss":"7","ties":"0","played":"9","qs":"4.00","rs":"15.00","highScore":"","seedingScore":"","coopertitionBonus":"","hangingPoints":"","average":""},"52":{"teamNumber":"3503","wins":"2","loss":"6","ties":"0","played":"8","qs":"4.00","rs":"13.90","highScore":"","seedingScore":"","coopertitionBonus":"","hangingPoints":"","average":""},"53":{"teamNumber":"1072","wins":"2","loss":"8","ties":"0","played":"10","qs":"4.00","rs":"13.80","highScore":"","seedingScore":"","coopertitionBonus":"","hangingPoints":"","average":""},"54":{"teamNumber":"8","wins":"2","loss":"7","ties":"0","played":"9","qs":"4.00","rs":"9.40","highScore":"","seedingScore":"","coopertitionBonus":"","hangingPoints":"","average":""},"55":{"teamNumber":"2489","wins":"1","loss":"6","ties":"1","played":"8","qs":"3.00","rs":"12.70","highScore":"","seedingScore":"","coopertitionBonus":"","hangingPoints":"","average":""},"56":{"teamNumber":"2643","wins":"1","loss":"7","ties":"0","played":"8","qs":"2.00","rs":"21.50","highScore":"","seedingScore":"","coopertitionBonus":"","hangingPoints":"","average":""}}
api.php?query=getTeam&teamNumber=1538
{"longName":"Nordson Asymtek \/ BlueChip Machine & Fabrication \/ BAE SYSTEMS \/ SAIC \/ Qualcomm \/ SRT-Nypro \/ Vivid Hosting \/ San Diego County Sheriff's Department & High Tech High School","city":"San Diego","state":"CA","country":"USA","rookieYear":"2005","name":"The Holy Cows"}
api.php?query=getTeamlistByEventAndYear&year=2011&eventCode=SJ
"8","100","114","115","192","253","254","256","295","581","604","649","668","670","675","691","692","701","751","766","812","846","852","971","1072","1280","1323","1351","1458","1516","1538","1622","1662","1700","1868","1967","2035","2135","2141","2144","2159","2367","2456","2473","2489","2643","2813","2854","3022","3045","3256","3482","3501","3503","3505","3717"]
api.php?query=getEventsByTeamNumber&teamNumber=1538
{"year":"2012","eventCode":"SDC"},{"year":"2012","eventCode":"SJ"},{"year":"2011","eventCode":"SDC"},{"year":"2011","eventCode":"SJ"},{"year":"2011","eventCode":"Newton"},{"year":"2011","eventCode":"CMP"},{"year":"2010","eventCode":"SDC"},{"year":"2010","eventCode":"UT"},{"year":"2010","eventCode":"CMP"},{"year":"2010","eventCode":"Curie"},{"year":"2009","eventCode":"SDC"},{"year":"2009","eventCode":"NV"},{"year":"2009","eventCode":"CMP"},{"year":"2009","eventCode":"Archimedes"},{"year":"2008","eventCode":"SDC"},{"year":"2008","eventCode":"CA"},{"year":"2008","eventCode":"Newton"},{"year":"2007","eventCode":"SDC"},{"year":"2007","eventCode":"NV"},{"year":"2006","eventCode":"Archimedes"},{"year":"2005","eventCode":"NV"}]
api.php?query=getTeamRecordByEvent&year=2011&eventCode=SJ&teamNumber=1538
{"overallWins":"15","overallLoss":"1","overallTies":"0","qualWins":"9","qualLoss":"1","qualTies":"0","elimWins":6,"elimLoss":0,"elimTies":0}
[/spoiler]