NAQT Statistics Database
NAQT Statistics Database
I'm pleased to announce that a beta version of NAQT's high school statistics database is now available. This is our attempt to record the results of every match that is ever played on our questions (though, as of yet, it is woefully incomplete).
The home page for the site is here:
http://www.naqt.com/stats/
You can see a list of 2007-2008 tournaments here:
http://www.naqt.com/stats/results.jsp?year_code=2007
You can see Elo ratings for the 2007-2008 year here:
http://www.naqt.com/stats/ratings.jsp
You can see a small number of "all-time" records for teams and individuals here:
http://www.naqt.com/stats/records.jsp
We've started to make an effort to clean this data up, but there are probably lots and lots of errors remaining; we'd welcome any information from players and coaches that help us correct those issues.
As a starting point, if you search for your school:
http://www.naqt.com/stats/school-search.jsp
and then click on "Players" in the lower menu list, you can see a list of current and former players for that school's teams. If any of them are actually the same person, please let us know so we can unify their statistics.
If you have results from past tournaments that aren't loaded, please send us the SQBS files or whatever results you do have.
Finally, if there are additional views of this data, records, statistics, or search options that you would like to see, please let us know. We hope to expand this section greatly as time goes on.
The home page for the site is here:
http://www.naqt.com/stats/
You can see a list of 2007-2008 tournaments here:
http://www.naqt.com/stats/results.jsp?year_code=2007
You can see Elo ratings for the 2007-2008 year here:
http://www.naqt.com/stats/ratings.jsp
You can see a small number of "all-time" records for teams and individuals here:
http://www.naqt.com/stats/records.jsp
We've started to make an effort to clean this data up, but there are probably lots and lots of errors remaining; we'd welcome any information from players and coaches that help us correct those issues.
As a starting point, if you search for your school:
http://www.naqt.com/stats/school-search.jsp
and then click on "Players" in the lower menu list, you can see a list of current and former players for that school's teams. If any of them are actually the same person, please let us know so we can unify their statistics.
If you have results from past tournaments that aren't loaded, please send us the SQBS files or whatever results you do have.
Finally, if there are additional views of this data, records, statistics, or search options that you would like to see, please let us know. We hope to expand this section greatly as time goes on.
R. Robert Hentzel, National Academic Quiz Tournaments
- Gonzagapuma1
- Tidus
- Posts: 543
- Joined: Tue May 02, 2006 5:02 pm
- Location: Chicago, IL
Re: NAQT Statistics Database
This is really cool, except the Elo Rankings kinda suck, especially when you get out of the top 15.
Dan Puma
Alum: Gonzaga, Montgomery College, University of Maryland
Currently Unaffiliated
MAQT President-ish, 2014-2015
Champion of the Modern World, 2014
Former Member, PACE
Alum: Gonzaga, Montgomery College, University of Maryland
Currently Unaffiliated
MAQT President-ish, 2014-2015
Champion of the Modern World, 2014
Former Member, PACE
Re: NAQT Statistics Database
I might not go so far as to say that they "suck," at least in a public forum, but I agree that there is more work to be done in making the ratings accurate. We welcome suggestions from statisticians and interested players who are browsing the database.Gonzagapuma1 wrote:This is really cool, except the Elo Rankings kinda suck, especially when you get out of the top 15.
The biggest issue to be tackled is properly handling teams that play very few games, particularly in regions where the competition might be both (1) weak, and (2) only local.
I, personally, am interested in pursuing more complex stats like Pat Matthews' "Points Created" (from way back when), when we have development time.
Re: NAQT Statistics Database
One problem with these stats is that sometimes they aren't correct at all. Neither Dorman A or Dorman B played at the Spartanburg Viking Tournament, yet they have stats from those tournaments. "Dorman B" lost twice at that tournament to teams that would score less than 50 points to the real Dorman B.
George Stevens
Dorman High School 2008
Clemson University 2012
Dorman High School 2008
Clemson University 2012
Re: NAQT Statistics Database
That's certainly true; that's probably the most extreme example (that I know of) in these stats of the general question about when teams are "the same." A school might field three (or two, whatever) of its best players for a given tournament. Should those "A team" stats count toward the overall rating and record of its "true" A team (assuming that such an entity has a clear and uncontroversial existence)?ClemsonQB wrote:One problem with these stats is that sometimes they aren't correct at all. Neither Dorman A or Dorman B played at the Spartanburg Viking Tournament, yet they have stats from those tournaments. "Dorman B" lost twice at that tournament to teams that would score less than 50 points to the real Dorman B.
NAQT has basically decided that whatever teams schools field will be considered to be their A, B, and C teams, regardless of composition. If they aren't named A, B, and C, we'll rank them in order of finish. That is, if Charter Death Star finishes higher than any other Charter team, we'll merge its stats in with Charter A from other tournaments. Without a rule like that, I think, it'll become pretty subjective about whether or not teams are "the same" unless we take the approach that only teams with the exact same players playing the exact same proportion of the time are the "same team."
That said, if I remember correctly, this was a weekend on which Dorman sent teams to multiple tournaments; if that's case, we would probably be willing to relabel Dorman A and B as C an D (or whatever is appropriate) since the tournaments were taking place at the same time. Drop us an e-mail (or have your coach drop us an e-mail) with the details.
This is the sort of thing that we are looking to clean up, particularly for teams as prominent as Dorman.
Re: NAQT Statistics Database
R, Is it possible to get any sort of API or better way of accessing the data programmatically besides just parsing the pages?
Christian Carter
Minneapolis South High School '09 | Emerson College '13
PACE Member (retired)
Minneapolis South High School '09 | Emerson College '13
PACE Member (retired)
Re: NAQT Statistics Database
At the Spartan High tournament, "Dorman A" consisted of four sophomores that compose the JV A Team, or Dorman C. "Dorman B" was similarly the normal Dorman D. The actual A and B team members read at this tournament to help out an inexperienced local club.
George Stevens
Dorman High School 2008
Clemson University 2012
Dorman High School 2008
Clemson University 2012
- Gonzagapuma1
- Tidus
- Posts: 543
- Joined: Tue May 02, 2006 5:02 pm
- Location: Chicago, IL
Re: NAQT Statistics Database
Yea, we have the same problem. Our B/C Team went 0-5 at 2007 WJ. Our A Team had already played the set at Princeton.
Dan Puma
Alum: Gonzaga, Montgomery College, University of Maryland
Currently Unaffiliated
MAQT President-ish, 2014-2015
Champion of the Modern World, 2014
Former Member, PACE
Alum: Gonzaga, Montgomery College, University of Maryland
Currently Unaffiliated
MAQT President-ish, 2014-2015
Champion of the Modern World, 2014
Former Member, PACE
- JackGlerum
- Tidus
- Posts: 660
- Joined: Wed Aug 15, 2007 9:20 pm
Re: NAQT Statistics Database
Very cool.
- Sen. Estes Kefauver (D-TN)
- Chairman of Anti-Music Mafia Committee
- Posts: 5647
- Joined: Wed Jul 26, 2006 11:46 pm
Re: NAQT Statistics Database
I appreciate Joel Knight's top notch performance for Grand Rapids Catholic Central HS.
Charlie Dees, North Kansas City HS '08
"I won't say more because I know some of you parse everything I say." - Jeremy Gibbs
"At one TJ tournament the neg prize was the Hampshire College ultimate frisbee team (nude) calender featuring one Evan Silberman. In retrospect that could have been a disaster." - Harry White
"I won't say more because I know some of you parse everything I say." - Jeremy Gibbs
"At one TJ tournament the neg prize was the Hampshire College ultimate frisbee team (nude) calender featuring one Evan Silberman. In retrospect that could have been a disaster." - Harry White
-
- Wakka
- Posts: 127
- Joined: Fri Aug 03, 2007 7:47 pm
- Location: Rva
Re: NAQT Statistics Database
I think LOT Academy will surprise everyone and win HSNCT this year.
Quint Carr
Maggie Walker A
GSAC XV Question Editor
GSAC XVI Chief Promoter/Celebrity
Maggie Walker A
GSAC XV Question Editor
GSAC XVI Chief Promoter/Celebrity
-
- Rikku
- Posts: 291
- Joined: Fri Jul 25, 2008 11:12 pm
Re: NAQT Statistics Database
I can't tell if you are purposefully misstating, but Joel Knight played at Detroit Catholic Central HS, right?Deesy Does It wrote:I appreciate Joel Knight's top notch performance for Grand Rapids Catholic Central HS.
Neil Gurram
'10 DCDS
'15 MIT
'16 MIT
'10 DCDS
'15 MIT
'16 MIT
- Maxwell Sniffingwell
- Auron
- Posts: 2164
- Joined: Sun Feb 12, 2006 3:22 pm
- Location: Des Moines, IA
Re: NAQT Statistics Database
Ees choke. Ees fonny, ja?master15625 wrote:I can't tell if you are purposefully misstating, but Joel Knight played at Detroit Catholic Central HS, right?Deesy Does It wrote:I appreciate Joel Knight's top notch performance for Grand Rapids Catholic Central HS.
Greg Peterson
Northwestern University '18
Lawrence University '11
Maine South HS '07
"a decent player" - Mike Cheyne
Northwestern University '18
Lawrence University '11
Maine South HS '07
"a decent player" - Mike Cheyne
- Stained Diviner
- Auron
- Posts: 5088
- Joined: Sun Jun 13, 2004 6:08 am
- Location: Chicagoland
- Contact:
Re: NAQT Statistics Database
I sent an email a month ago with some corrections and additions, and nothing happened.
Re: NAQT Statistics Database
can you please tell me the result when A Team had played the set at Princeton?
Re: NAQT Statistics Database
Is NAQT going to update this as the '08-09 season goes on, or is the database only of past completed seasons?
Charles Hang
Francis Howell Central '09
St. Charles Community College '14
Washington University in St. Louis '19, 2x (President, 2017-19)
Owner, Olympia Academic Competition Questions, LLC
Question Writer, National Academic Quiz Tournaments, LLC and National History Bee and Bowl
Francis Howell Central '09
St. Charles Community College '14
Washington University in St. Louis '19, 2x (President, 2017-19)
Owner, Olympia Academic Competition Questions, LLC
Question Writer, National Academic Quiz Tournaments, LLC and National History Bee and Bowl
Re: NAQT Statistics Database
I've seen them make updates as the season goes along for tournaments that they get data back from. As you can see, though, there are several events that they don't get any response back from.Charbroil wrote:Is NAQT going to update this as the '08-09 season goes on, or is the database only of past completed seasons?
Mostly, it's a pretty good repository. When something gets mis-entered or appears to be mis-entered (see TOMCAT from this year, where I can't really figure out anything as to what's going on), it becomes difficult.
Dave Bykowski
Furman '00
Michigan '02
PACE 1998-2009
Director, JROTC National Academic Bowl Championship
Furman '00
Michigan '02
PACE 1998-2009
Director, JROTC National Academic Bowl Championship
- Sen. Estes Kefauver (D-TN)
- Chairman of Anti-Music Mafia Committee
- Posts: 5647
- Joined: Wed Jul 26, 2006 11:46 pm
Re: NAQT Statistics Database
I know I sent them the data for Mizzou's Fall Academic Tournament but they haven't entered them yet, possibly becuase we didn't run the stats as SQBS. I think it would be kind of cool if they got more on entering stats from tournaments that have their results posted but that are sitting blankly on the NAQT page, but whatever.
Charlie Dees, North Kansas City HS '08
"I won't say more because I know some of you parse everything I say." - Jeremy Gibbs
"At one TJ tournament the neg prize was the Hampshire College ultimate frisbee team (nude) calender featuring one Evan Silberman. In retrospect that could have been a disaster." - Harry White
"I won't say more because I know some of you parse everything I say." - Jeremy Gibbs
"At one TJ tournament the neg prize was the Hampshire College ultimate frisbee team (nude) calender featuring one Evan Silberman. In retrospect that could have been a disaster." - Harry White
Re: NAQT Statistics Database
This intent is to update it as soon as possible with whatever results we have, but we haven't been able to completely live up to that.Charbroil wrote:Is NAQT going to update this as the '08-09 season goes on, or is the database only of past completed seasons?
Some of that is because loading results requires database access and the few people at NAQT that have permission to do that are also working, more-or-less continuously, on higher priority tasks (like finishing packets).
The bigger issue is that not all hosts send results, many send incomplete results, and many send results that are in an inconvenient format. For example, a spreadsheet of teams' scores in each round but no indication of which teams were playing. We then have to request a schedule and sort things out manually to enter the data.
I hope that we will become more efficient with this as time goes on and eventually reach a point where every tournament is promptly reported to us and available in the database within a week of it's completion (and hopefully faster). It will take us a while to get there, however.
I currently have quite a few tournaments that will get uploaded as soon as Sectionals are over and IS #83 is completed and shipped.
Re: NAQT Statistics Database
The listed final rankings for TOMCAT teams outside of the top 12 are currently meaningless due to the powermatching format used. I'll be cleaning that up at some point when question production needs are less pressing.Byko wrote:I've seen them make updates as the season goes along for tournaments that they get data back from. As you can see, though, there are several events that they don't get any response back from.Charbroil wrote:Is NAQT going to update this as the '08-09 season goes on, or is the database only of past completed seasons?
Mostly, it's a pretty good repository. When something gets mis-entered or appears to be mis-entered (see TOMCAT from this year, where I can't really figure out anything as to what's going on), it becomes difficult.
Re: NAQT Statistics Database
Getting sent a SQBS data file is the easiest thing for us to process; I typically upload those immediately when I receive them.Jeremy Gibbs Free Energy wrote:I know I sent them the data for Mizzou's Fall Academic Tournament but they haven't entered them yet, possibly becuase we didn't run the stats as SQBS. I think it would be kind of cool if they got more on entering stats from tournaments that have their results posted but that are sitting blankly on the NAQT page, but whatever.
Other formats usually have to manually rearranged into one or another standard format, which takes time. If we have your results, they will get posted eventually. I do apologize for the delay and hope that we become more efficient at keeping the database up to date.
Re: NAQT Statistics Database
No problem--I understand. It just confused me to no end to see some teams playing 6 prelim games and some playing 7, which seemed to differ from years past with TOMCAT. Plus seeing Chaska win the tournament playing 3 playoff games while Eden Prairie played 4 and Wayzata going 3-0 in playoffs but finishing third--I had to make sure my head didn't explode. I'm guessing the semifinals are just missing or something (since nobody appears to have played in round 11), but I just thought you'd want to know. But I can be patient with this.rhentzel wrote:The listed final rankings for TOMCAT teams outside of the top 12 are currently meaningless due to the powermatching format used. I'll be cleaning that up at some point when question production needs are less pressing.Byko wrote:I've seen them make updates as the season goes along for tournaments that they get data back from. As you can see, though, there are several events that they don't get any response back from.Charbroil wrote:Is NAQT going to update this as the '08-09 season goes on, or is the database only of past completed seasons?
Mostly, it's a pretty good repository. When something gets mis-entered or appears to be mis-entered (see TOMCAT from this year, where I can't really figure out anything as to what's going on), it becomes difficult.
Dave Bykowski
Furman '00
Michigan '02
PACE 1998-2009
Director, JROTC National Academic Bowl Championship
Furman '00
Michigan '02
PACE 1998-2009
Director, JROTC National Academic Bowl Championship
Re: NAQT Statistics Database
In 2007 there were 64 teams so everybody played six preliminary games. In 2008 (and 2009) there were 80 teams, so some played six and some played seven as part of the powermatched preliminaries.Byko wrote:No problem--I understand. It just confused me to no end to see some teams playing 6 prelim games and some playing 7, which seemed to differ from years past with TOMCAT. Plus seeing Chaska win the tournament playing 3 playoff games while Eden Prairie played 4 and Wayzata going 3-0 in playoffs but finishing third--I had to make sure my head didn't explode. I'm guessing the semifinals are just missing or something (since nobody appears to have played in round 11), but I just thought you'd want to know. But I can be patient with this.
Some 11th-round games (and some other games, mostly forfeits) are missing from the currently posted stats. I'll have to sort through the scoresheets to identify those and enter them.
R. Robert Hentzel, National Academic Quiz Tournaments
Re: NAQT Statistics Database
Okay, thanks. I'll go see if anyone I know has results for NAQT tournaments that they can send in.
Charles Hang
Francis Howell Central '09
St. Charles Community College '14
Washington University in St. Louis '19, 2x (President, 2017-19)
Owner, Olympia Academic Competition Questions, LLC
Question Writer, National Academic Quiz Tournaments, LLC and National History Bee and Bowl
Francis Howell Central '09
St. Charles Community College '14
Washington University in St. Louis '19, 2x (President, 2017-19)
Owner, Olympia Academic Competition Questions, LLC
Question Writer, National Academic Quiz Tournaments, LLC and National History Bee and Bowl
- BuzzerZen
- Auron
- Posts: 1517
- Joined: Thu Nov 18, 2004 11:01 pm
- Location: Arlington, VA/Hampshire College
Re: NAQT Statistics Database
Speaking of SQBS files, if anyone out there happens to have a specification of the SQBS data format, I'd quite probably attempt to implement an export-to-SQBS-file feature for Taft.
Evan Silberman
Hampshire College 07F
How are you actually reading one of my posts?
Hampshire College 07F
How are you actually reading one of my posts?