Best Data Format?

[timothyb89]

I had partially dismissed CSV/TSV/PSV/etc before because I wasn't able to export our data tree to it directly. But it's probably the most accessible format we can offer so I think I'll need to find a way

I don't think it could be done in the same manner as JSON or other tree-based formats (XML, etc) so it'd probably multiple files of lists, like:

teams.csv

# number, nickname, location, rookie season, other stats...
1,The Juggernauts,Pontiac, MI  USA,1997,...
4,Team 4 ELEMENT,Van Nuys, CA  USA,1997,...

events.csv

# name, short name, start date, end date, other stats
Ann Arbor FIRST Robotics District Competition,ann-arbor,1268377200000,1268463600000,...

ann-arbor-matches.csv

# number, red 1, red 2, red 3, blue 1, blue 2, blue 3, red score, blue score
1,68,1998,49,2591,2619,862,1,5
2,2611,1684,3415,2627,3302,1940,0,0

...plus more for standings, awards, and the like. Hopefully that should be easy enough for everyone to parse, and we'll have that up and running in a few days!
We've also finished JSON exporting for events, mostly, e.g. http://glass.frcdb.net/event/colorado/json returns basically the same data as the normal event page. (A somewhat more readable example of event JSON here). With any luck, the 2 current choices should make things pretty accessible!