Difference between revisions of "Main Page"

From CFBHA
Jump to navigation Jump to search
m
m
 
Line 13: Line 13:
 
             </div>
 
             </div>
  
            <div class="card-header text-white text-center bg-primary">
 
                <h3><i class="fa fa-bullhorn fa-lg fa-fw float-left" aria-hidden="true"></i> Loren's updates</h3>
 
            </div>
 
            <div class="card-body">
 
                <p class="card-text">
 
                    {{CFBHA:Loren's updates}}
 
                </p>
 
            </div>
 
 
         </div>
 
         </div>
  
 
     </div>
 
     </div>
 +
 
     <div class="col-xl-4">
 
     <div class="col-xl-4">
  
Line 42: Line 35:
 
             </div>
 
             </div>
 
         </div>
 
         </div>
 +
    </div>
 +
    <div class="col-12">
 +
        <div class="card hvr-glow border-secondary">
 +
            <div class="card-header text-white text-center bg-primary">
 +
                <h3><i class="fa fa-bullhorn fa-lg fa-fw float-left" aria-hidden="true"></i> Loren's updates</h3>
 +
            </div>
 +
            <div class="card-body">
 +
                <p class="card-text">
 +
                    {{CFBHA:Loren's updates}}
 +
                </p>
 +
            </div>
 +
        </div>
 +
 
     </div>
 
     </div>
 
</div>
 
</div>

Latest revision as of 13:16, 11 April 2019

College Football Historians Association

CFBHA: Chronicling the Pageantry, Passion, Tradition, and Religion of College Football

Our extensive collection of college football data is the cornerstone of our site.
Examples: "Grinnell" ... "Illinois College Conference" ... "1916" ... "1930 Buena Vista" ... "1983 Ohio Athletic Conference"
The encyclopedia of college football, a community-driven compilation that anyone can edit!

Navigation

Our collection of college football references provides reearchers with access to source materials.
Our collection of Georgia high school football references provides reearchers with access to source materials.
Tools for groups of college football researchers to assist each other on their common interests!
Database status
  • The CFBHA has 350,828 games from 71,060 teams from 1,128 schools over 137 seasons
  • There are approximately 6,473 teams remaining to be researched
  • 1,799 coaches have been entered and 211 conferences have been identified

Who's online

    Recent changes

    No changes during the given period match these criteria.

    Loren's updates

    3/18

    • Adding some tables to help with reconciling the data; see the "To reconcile" tab on each season page and on the sidebar to the left
    3/17
    • Organizing the Library
    3/4
    • Working on playoff brackets
      • Finished the coding to fill in brackets completely (previously only initial seeding)
      • Finished FCS brackets back to 1978
    3/3
    • Working on playoff brackets
      • Added coding
      • Added FBS brackets back to 2014 and FCS brackets back to 2011; shows initial seeding only
    2/11
    • Updated the 2018 season from Peter Wolfe's data; still need to identify bowl games
    2/10 2/09
    • Updated all 2018 NCAA coaches in FCS, Div II, and Div III
    2/06
    • Finished adding GPS coordinates for all schools playing football in 2018; you can see the results on the Conferences tab for each season such as here
    2/02
    • Although I haven't posted updates here lately, I have been working on the site; specifically I have implemented a new version of the conference maps, which can be seen on the Conferences tab for each season such as here
    • I am also working on updating coaches in the database, specifically trying to reconcile many entries between the NCAA's records, the CFB Data Warehouse, and Wikipedia's entries
    • If you are interested in helping with coaches, conference alignments, or scores and schedules, please contact me!
    • I also plan on eventually adding information on stadiums
    12/11
    • Still working on some improvements to the site and will be updating coaches soon
    11/25
    • Reached out to a few folks in an effort to recruit some interest in the CFBHA. If you are interested or know someone who might be, please reach out to me!
      • As part of the effort to bolster the use of this site, I am considering adding a feature to convert our data easily to wikitext for quick copy and paste into Wikipedia; if you'd find this of interest, please let me know
    • Added Farmingdale State as NY-58
    • Imported 2018 games from Peter Wolfe
    • Currently have the careers 633 coaches entered, although I do not have a good method of displaying this on the site at the moment
    • 655,272 entries
      • 609,042 paired entries, 304,521 unique pairings (unique games)
      • 46,230 unpaired entries (unique games)
        • 10 entries that have the same season and corresponding team and opponent entries but do not match on either the game date, game site, or scores (i.e., 5 games with discrepancies that I cannot find)
        • There are 17,072 I can pair with opponents from the school history table, meaning they were still needing to be added under Rich's duplicate entry system
        • That leaves 29,158 games against "outside" opponents, however these can also be misspelled opponent names or valid opponent names that fall outside the start and end seasons in the school history table (meaning the school history table may need to be updated)
        • There are 5,813 distinct opponent names that I can check against the school history table
    • Notes:
      • None
    11/24
    • Cleaned up the FBS coaches back to 2000
    11/23
    • Cleaned up the FBS coaches back to 2010
    • Worked some on the back end of the site, particularly trying to better accommodate the use of ampersands in team names
    • Redesigned the front end to put my updates in a different location
    11/22
    • Finished identifying all NAIA playoff games.
    11/21
    • Finished identifying all FCS, NCAA II, and NCAA III playoff games and all NAIA playoff games back to 2004.
    11/20
    • Started identifying all FCS playoff games
    • Started a Seasons index for the Library
    • Need to start a page to identify teams on probation and reasons why
    11/19 11/16 to 11/18
    • Working on incorporating coaches into the site
      • Started with this season's FBS and FCS coaches and working from there; Added full careers for all Georgia and Georgia Tech coaches
      • Under the conference standings, missing coaches will be shown as Missing
        • Updating coaches: Manual coaches I need to update
          • Bill Lewis/George O'Leary -> 1994 Georgia Tech
          • Terry Bowden/Bill Oliver -> 1998 Auburn
          • Tommy Tuberville/David Cutcliffe -> 1998 Mississippi
          • Nick Saban/Bobby Williams -> 1999 Michigan State
          • Dennis Franchione/Gary Patterson -> 2000 Texas Christian
          • George O'Leary/Mac McWorter -> 2001 Georgia Tech
          • Frank Solich/Bo Pelini -> 2003 Nebraska
          • Ron Zook/Charlie Strong -> 2004 Florida
          • Brian Kelly -> 2006 Central Michigan/Cincinnati
          • Tommy Tate/Matt Viator -> 2006 McNeese State
          • Chan Gailey/Jon Tenuta -> 2007 Georgia Tech
          • Art Briles/Chris Thurmond -> 2007 Houston
          • Paul Johnson/Ken Niumatalolo -> 2007 Navy
          • Rich Rodriguez/Bill Stewart -> 2007 West Virginia
          • Brady Hoke/Stan Parrish -> 2008 Ball State
          • Dabo Swinney -> 2008 Clemson
          • Butch Jones/Steve Stripling -> 2009 Central Michigan
          • Brian Kelly/Jeff Quinn -> 2009 Cincinnati
          • Dan Hawkins/Brian Cabral -> 2010 Colorado
          • Michael Haywood/Lance Guidry -> 2010 Miami (Ohio)
          • Jerry Kill/Tom Matukewicz -> 2010 Northern Illinois
          • Hugh Freeze/David Gunn -> 2011 Arkansas State
          • Kevin Sumlin/Tony Levine -> 2011 Houston
          • Mike Sherman/Tim DeRuyter -> 2011 Texas A & M
          • Tim Beckman/Matt Campbell -> 2011 Toledo
          • Butch Jones/Steve Stripling -> 2012 Cincinnati
          • Dave DoerenRod Carey -> 2012 Northern Illinois
          • Tommy Tuberville/Chris Thomsen -> 2012 Texas Tech
          • Willie Taggart/Lance Guidry -> 2012 Western Kentucky
          • Bret Bielema/Barry Alvarez -> 2012 Wisconsin
          • Paul Pasqualoni/T. J. Weist -> 2013 Connecticut
          • Ron English/Stan Parrish -> 2013 Eastern Michigan
          • Lane Kiffin/Ed Orgeron/Clay Helton -> 2013 Southern California
          • Jim McElwain/Dave Baldwin -> 2014 Colorado State
          • Will Muschamp/D. J. Durkin -> 2014 Florida
          • Bo Pelini/Barney Cotton -> 2014 Nebraska
          • George O'Leary/Danny Barrett -> 2015 Central Florida
          • Mark Richt/Bryan McClendon -> 2015 Georgia
          • Justin Fuente/Darrell Dickey -> 2015 Memphis
          • Jerry Kill/Tracy Claeys -> 2015 Minnesota
          • Steve Spurrier/Shawn Elliott -> 2015 South Carolina
          • Steve Sarkisian/Clay Helton -> 2015 Southern California
          • Matt Campbell/Jason Candle -> 2015 Toledo
          • Ron Turner/Ron Cooper -> 2016 Florida International
          • Tim DeRuyter/Eric Kiesau -> 2016 Fresno State
          • Trent Miles/Tim Lappano -> 2016 Georgia State
          • Tom Herman/Major Applewhite -> 2016 Houston
          • Kevin Wilson/Tom Allen -> 2016 Indiana
          • Les Miles/Ed Orgeron -> 2016 Louisiana State
          • Darrell Hazell/Gerad Parker -> 2016 Purdue
          • Willie Taggart/T. J. Weist -> 2016 South Florida
          • Matt Rhule/Ed Foley -> 2016 Temple
          • Jeff Brohm/Nick Holt -> 2016 Western Kentucky
          • Jim McElwain/Randy Shannon -> 2017 Florida
          • Jimbo Fisher/Odell Haggins -> 2017 Florida State
          • Tyson Summers/Chad Lunsford -> 2017 Georgia Southern
          • Willie Taggart/Mario Cristobal -> 2017 Oregon
          • Gary Andersen/Cory Hall -> 2017 Oregon State
          • Chad Morris/Sonny Dykes -> 2017 Southern Methodist
          • Butch Jones/Brady Hoke -> 2017 Tennessee
          • Kevin Sumlin/Jeff Banks -> 2017 Texas A & M
          • Sean Kugler/Mike Price -> 2017 Texas-El Paso
          • Jim L. Mora/Jedd Fisch -> 2017 UCLA
          • Mike Jinks/Carl Pelini -> 2018 Bowling Green State
          • Tony Hughes/John Hendrick -> 2018 Jackson State
          • Bobby Petrino/Lorenzo Ward -> 2018 Louisville
    • NOTE: It will be my practice to credit only one head coach for each team per game. This may seem obvious, but there are times when multiple coaches have been awarded credit for the same team in the same game; an example being 2004 Urban Meyer and Kyle Whittingham. In this case I am awarding the game to Urban Meyer, who was the coach all season long and had not left.
    11/15
    • I've been working to get some of the back end of the site changed over, so the progress on the games might not be apparent
    • I'm also working on a way to immediately show what has been verified and what is still to be researched
      • An example are the changes to the conferences pages where next to the team's name indicates that all of the team's games have pairs in the database
    11/12
    • Focusing some on getting Rich's lists of conferences updates. I will revisit the games later.
    • Found 275 discrepancies where the team codes do not match the team names from the school history table; most are probably misspellings
      • Corrected all; in all but two cases it was a misspelled name; two exceptions were listing "Arkansas State" instead of "Arkansas" in 2015 and 2016 for the Southeastern Conference
      • Additionally, there are 82 entries representing designated conference games; these will be eventually eliminated as I work to transition designed conference (and designated non-conference) games into the games table
      • There are also 71 team-seasons that are teams that do not represent a four year university but were members of a conference that had four-year universities; will have to figure out how to represent these in the database
    11/11
    • Along with importing the 2018 season from Peter Wolfe's data, I worked primarily on the 2017 season to input the game types (i.e., bowl, first round, second round, quarterfinal, semifinal, and final games)
      • This is a step toward greater automation in the conference standings and eventually playoff brackets as appropriate
      • Once I get the 2017 season functioning as I would like, I can more easily expand to other seasons
    • 655,086 entries
      • 608,856 paired entries, 304,428 unique pairings (unique games)
      • 46,230 unpaired entries (unique games)
        • 10 entries that have the same season and corresponding team and opponent entries but do not match on either the game date, game site, or scores (i.e., 5 games with discrepancies that I cannot find)
        • There are 16,905 I can pair with opponents from the school history table, meaning they were still needing to be added under Rich's duplicate entry system
        • That leaves 29,325 games against "outside" opponents, however these can also be misspelled opponent names or valid opponent names that fall outside the start and end seasons in the school history table (meaning the school history table may need to be updated)
        • There are 5,924 distinct opponent names that I can check against the school history table
    • Notes:
      • None
    11/08
    • 651,186 entries
    • Finished nearly all discrepancies; will list open ones separately
    • New totals =
      • 604,812 paired entries, 302,406 unique pairings (unique games)
    • 46,374 unpaired entries
      • 50 entries that have the same season and corresponding team and opponent entries but do not match on either the game date, game site, or scores
        • Of these, 40 are from the 2018 season, all of which will reconcile when I update for this year
        • Leaves 5 games with discrepancies that I cannot find
      • There are 16,901 I can pair with opponents from the school history table, meaning they were still needing to be added under Rich's duplicate entry system
      • That leaves 29,473 games against "outside" opponents, however these can also be misspelled opponent names or valid opponent names that fall outside the start and end seasons in the school history table (meaning the school history table may need to be updated)
        • There are 5,924 distinct opponent names that I can check against the school history table
    • Notes:
      • None
    11/07
    • 651,186 entries
    • Finished nearly all discrepancies; will list open ones separately
    • New totals =
      • 604,812 paired entries, 302,406 unique pairings (unique games)
    • 46,374 unpaired entries
      • 50 entries that have the same season and corresponding team and opponent entries but do not match on either the game date, game site, or scores
        • Of these, 40 are from the 2018 season, all of which will reconcile when I update for this year
        • Leaves 5 games with discrepancies that I cannot find
    • Notes:
      • None
    11/06
    • 651,186 entries
    • Worked a large number of discrepancies related to misspellings of team and opponent names
    • New totals =
      • 604,696 paired entries, 302,348 unique games
    • 46,490 unpaired entries
      • 166 entries that have the same season and corresponding team and opponent entries but do not match on either the game date, game site, or scores
        • Of these, 40 are from the 2018 season, all of which will reconcile when I update for this year
    • Notes:
      • None
    11/04
    • 651,186 entries
    • Worked on discrepancies from 1926 to 1959
    • New totals =
      • 604,480 paired entries, 302,240 unique games
    • 46,706 unpaired entries
      • 168 entries that have the same season and corresponding team and opponent entries but do not match on either the game date, game site, or scores
        • Of these, 40 are from the 2018 season, all of which will reconcile when I update for this year
    • Notes:
      • None
    11/03
    • 651,186 entries
    • Worked on discrepancies from 1926 to 1935
    • New totals =
      • 604,288 paired entries, 302,144 unique games
    • 46,898 unpaired entries
      • 346 entries that have the same season and corresponding team and opponent entries but do not match on either the game date, game site, or scores
    • Notes:
      • Appears to be some confusion among the opponents concerning OK-12 and OK-19, Northeastern State Teachers out of Tahlequah and Northeastern Oklahoma JC out of Miami, respectively
    11/02
    • 651,186 entries
    • Worked on discrepancies from 1904 to 1925
    • New totals =
      • 604,224 paired entries, 302,112 unique games
    • 46,962 unpaired entries
      • 414 entries that have the same season and corresponding team and opponent entries but do not match on either the game date, game site, or scores
    • Notes:
      • None
    11/01
    • Worked on discrepancies from 1882 to 1903
    • New totals =
      • 604,134 paired entries, 302,067 unique games
    • 47,057 unpaired entries
      • 514 entries that have the same season and corresponding team and opponent entries but do not match on either the game date, game site, or scores
    • Notes:
      • 1903 Arkansas needs revisiting; CANNOT find game versus Fort Smith High School; suspect is was not played
    10/31
    • Identified 534 entries that have the same season and corresponding team and opponent entries but do not match on either the game date, game site, or scores
      • These are discrepancies I will be working to resolve
    10/27
    • Made several structural changes to the games table; these were changes Rich and I had discussed but never implemented
      • Added fields for game type (i.e., Regular season, Conference championship game, etc.), game name (i.e., Rose Bowl, Sugar Bowl, etc.), opponent code, administrative decisions (to identify vacated and forfeited games), a paired id to identify the corresponding game entry, a verified checkbox to be used later, and a field for any discrepancies
    • Out of the 651,185 entries Rich had, I've identified 604,114 have a pairing, meaning that there are 302,057 unique games
    • Of the 47,071 remaining entries, they are either
      • Games against opponents that are not tracked (i.e., against non-colleges)
      • Games against college opponents that have yet to be entered
      • Games against college opponents that have discrepancies and were not identified as a pairing, to include an error in the opponent's name (such as incorrect opponent or typo)
    I'll first be working to sort out the unpaired games, especially to identify discrepancies 10/26
    • Reset database log to track changes I've done since Rich's last update
    • Started working on reformatting the table for games
    10/08
    • Imported latest version of games database from Rich; 651,185 entries
    7/29