Jump to content


Photo

Most weeks at number 1


  • Please log in to reply
8 replies to this topic

#1 BobbyHodges

BobbyHodges

    Football Sage

  • Members.
  • PipPipPipPipPipPipPipPip
  • 2,445 posts
  • Gender:Male
  • Location:Evans, GA

Posted 12 April 2005 - 01:30 PM

This was Todd's idea

The top 10
Valdosta 235
Lincoln County 114
Americus 81
Carrollton 75
Thomasville 65
TCC 51
Clinch County 48
Washington-Wilkes 48
LaGrange 47
Thomson 47 (GO DOGS!!!)
Warner Robins 47

The rest: Attached File  gRankings.csv   3.13KB   107 downloads


SELECT aSchool,Count(aSchool) as aTotal
FROM `gRankings`
WHERE aRank=1
Group by aSchool
ORDER BY aTotal desc, aSchool ASC

#2 Ira

Ira

    Football Sage

  • Members
  • PipPipPipPipPipPipPip
  • 1,434 posts
  • Location:McDonough

Posted 12 April 2005 - 04:32 PM

How many weeks were possible? I wonder how many weeks Valdosta has NOT been ranked. Interesting info. Thanks.

#3 BobbyHodges

BobbyHodges

    Football Sage

  • Members.
  • PipPipPipPipPipPipPipPip
  • 2,445 posts
  • Gender:Male
  • Location:Evans, GA

Posted 12 April 2005 - 05:15 PM

looks like 594 different dates. Some of the dates aren't verified yet though, so it's probably a few more than that. For example, there are some cases where we have the same date for the last reg season ranking and the final ranking, which would only count as one, but should be two.

#4 THOLCOMB

THOLCOMB

    Football Research Master

  • Mod
  • PipPipPipPipPipPipPipPip
  • 2,419 posts
  • Gender:Male

Posted 12 April 2005 - 05:27 PM

That's been fixed. I just haven't sent the new copy. That would add another 40-50 weeks, or so.

#5 BobbyHodges

BobbyHodges

    Football Sage

  • Members.
  • PipPipPipPipPipPipPipPip
  • 2,445 posts
  • Gender:Male
  • Location:Evans, GA

Posted 12 April 2005 - 05:50 PM

there will also be some overlap to consider as well. 1961 for example, we have two different polls with a different date in the same week, essentially doubling that week.

#6 THOLCOMB

THOLCOMB

    Football Research Master

  • Mod
  • PipPipPipPipPipPipPipPip
  • 2,419 posts
  • Gender:Male

Posted 09 June 2005 - 08:57 PM

Hey Bobby, how many weeks was Commerce at No. 1?

#7 BobbyHodges

BobbyHodges

    Football Sage

  • Members.
  • PipPipPipPipPipPipPipPip
  • 2,445 posts
  • Gender:Male
  • Location:Evans, GA

Posted 09 June 2005 - 09:41 PM

42

That Excel file has all of them in it.

#8 THOLCOMB

THOLCOMB

    Football Research Master

  • Mod
  • PipPipPipPipPipPipPipPip
  • 2,419 posts
  • Gender:Male

Posted 09 June 2005 - 10:07 PM

Thanks. I couldn't download the excel file for some reason. Or it might be that I'm just sleepy.

The reason I asked was because I sent this list to JW, the Lincoln County webmaster, who put it on his site, and somebody e-mailed him that Commerce was No. 1 for 54 weeks and sited our site. Just wondered if I was missing something.

#9 BobbyHodges

BobbyHodges

    Football Sage

  • Members.
  • PipPipPipPipPipPipPipPip
  • 2,445 posts
  • Gender:Male
  • Location:Evans, GA

Posted 10 June 2005 - 09:13 AM

no that should be current based on whats in there right now. I ran the SQL again just to be certain.