User:Phydeaux

From Barbershop Wiki Project
Jump to navigation Jump to search

Quartet Template Project

I'd like to make a template for quartetters, so names will be automatically linked, and we could have pages auto-populated for the singers. So if I look up a quartet page with a bass I particularly like, I can click on their name to get to a page that shows all the quartets that bass sings in.

I'm not sure how to build the template yet, but I parsed out the singers as best I could from the wiki project's download function of all "Quartets" categorized pages. If anyone is interested in the python script or the table below in xml format, let me know.

Progress

Code

I have uploaded the project to GitHub and intend to keep it updated: https://github.com/dwesely/barbershop

Current Table Notes

  • This isn't scrubbed, other than the couple checks I did scrolling through it. I am improving the algorithm as I go. I hope to have it pretty clean by the time the champion list pages are up to date, then I can just hit the button and generate all the remaining quartet, singer, and disambiguation pages.
  • There may be duplicate or inaccurate entries:
    • Titles are not distinguishable from names ("Jr." and "Sr." end up as new names if they had a comma in front of them) - This has been fixed for Jr. and Sr.
    • Maiden names are not distinguishable from longer sentence fragments (so some sentences are ending up as names, if the sentence starts with a part name like "Lead" or "Tenor")
    • Obvious misspellings are not automatically corrected (A "Johnston" and a "Johnson" singing for the same quartet but listed on different pages show up as two unique singers)
    • Common spelling variations cause singers to be counted more than once ("Steve" and "Steven" on two different pages cause two singers to be recorded)
  • There may be missing entries (for example, if a quartet page was not categorized as "Quartets", it's information would not show up here)
  • If no quartet singers were listed in the champion list page, the championship is not attributed to the quartet
    • There are duplicate quartet names out there, so I didn't want to attach the championship to the quartet name, instead to the individual singers
    • Many of the championship lists do not have singers, my goal is to fill those out the best I can before creating the quartet and singer stub pages
    • After going through several of the lists and being simply unable to find TLBB lists, I think I will have to allow quartets to get championships, not just singers
      • This will require some sort of QA, I'm not sure how that will work yet. Maybe flag a quartet that wins championships in more than one district/region, or keep a list of the quartets that won in the most competitions

Next Steps

  • I plan to parse the champions lists and use TLBB names from there and this table to make stub pages for each champion singer, with the years and competitions they've won, and the quartets they've sang with. I added "List of Champions" category to all the champions list pages, so I will download and parse them next and add them to the table below.
  • Fill in more of the TLBB lists for district champions
    • Should make the script to indicate level of completion for championship lists:
      • Total number of years listed (indicate number without TLBB, and number without Chapter)
      • Total span of years (indicate number of missing years)
  • Parse directors' names and start tracking choruses
    • Include directors' awards in lists of most-awarded singers
  • Use fuzzy searches to identify when two people are likely the same person
    • Produce list of most likely candidates to be merged
  • Decide whether or not to parse and include quartets who placed 2nd and lower (TLBB names are just about non-existent for these, and formatting is not as consistent for these in the contest pages)
  • Settle on Singer and Quartet templates
  • Start generating pages!
    • Fix bug in the xml output, title line is generated twice
  • QC and upload

Results

Download is current as of:

  • 2020-02-25

Quartets that currently have pages in the wiki:

  • 455 Quartets identified.
  • 1674 Singers identified.

Quartets, including those listed in the List of Champions category:

  • 2184 Quartets identified.
  • 6994 Singers identified.

Table of Latest Recorded Championship Details

Championship Earliest Year Recorded Latest Year Recorded % With Quartetters
AAMBS Seniors Champions 1995 2018 58% (100% of all entries)
BABS Youth Champions 2008 2016 100% (100% of all entries)
Barbershop Harmony Australia Quartet Champions 1991 2019 59% (100% of all entries)
BHS International Collegiate Quartet Champions 1992 2017 100% (100% of all entries)
BHS International Quartet Champions 1939 2019 100% (100% of all entries)
BHS International Seniors Quartet Champions 1986 2019 100% (100% of all entries)
CAR Collegiate Champions 1998 2013 81% (81% of all entries)
CAR Novice Champions 1983 2013 26% (25% of all entries)
CAR Quartet Champions 1945 2018 99% (101% of all entries)
CSD Collegiate Champions 1992 2014 35% (34% of all entries)
CSD Quartet Champions 1947 2018 99% (98% of all entries)
DIX Quartet Champions 1948 2018 100% (100% of all entries)
EVG Quartet Champions 1948 2018 99% (98% of all entries)
FWD Novice Champions 1969 2014 33% (88% of all entries)
FWD Quartet Champions 1947 2018 100% (100% of all entries)
FWD Seniors Champions 1991 2014 96% (95% of all entries)
HI International Quartet Champions 1960 2018 100% (100% of all entries)
IABS International Quartet Champions 2008 2015 62% (55% of all entries)
IABS National Quartet Champions 1989 2015 26% (25% of all entries)
ILL Quartet Champions 1943 2018 97% (97% of all entries)
JAD Novice Champions 1971 2018 19% (18% of all entries)
JAD Quartet Champions 1944 2018 100% (100% of all entries)
JAD Seniors Champions 1982 2012 32% (32% of all entries)
LABBS Novice Champions 2006 2015 100% (100% of all entries)
LABBS Quartet Champions 1976 2018 84% (85% of all entries)
LOL Quartet Champions 1945 2018 100% (100% of all entries)
MAD Collegiate Champions 1994 2012 84% (84% of all entries)
MAD Quartet Champions 1945 2018 99% (98% of all entries)
MAD Seniors Champions 1991 2017 96% (96% of all entries)
NED Collegiate Champions 1998 2017 80% (80% of all entries)
NED Novice Champions 1997 2015 32% (31% of all entries)
NED Quartet Champions 1946 2019 100% (100% of all entries)
NED Seniors Champions 1987 2012 15% (15% of all entries)
NSC Quartet Champions 2010 2019 100% (100% of all entries)
NSC Seniors Champions 2010 2016 100% (100% of all entries)
NZABS Quartet Champions 1989 2015 78% (77% of all entries)
ONT Mixed Champions 2017 2018 100% (100% of all entries)
ONT Novice Champions 1958 Fall 2018 Spring 126% (63% of all entries)
ONT Quartet Champions 1947 2018 100% (100% of all entries)
ONT Seniors Champions 1993 2018 92% (92% of all entries)
PIO Collegiate Champions 1998 2010 23% (23% of all entries)
PIO Novice Champions 1947 2014 100% (100% of all entries)
PIO Quartet Champions 1940 2018 100% (100% of all entries)
PIO Seniors Champions 1988 2010 100% (100% of all entries)
Quartet Champion competition 2011 2015 60% (60% of all entries)
R01 Quartet Champions 1967 2015 27% (26% of all entries)
R02 Quartet Champions 1988 2015 57% (57% of all entries)
R03 Quartet Champions 1967 2015 27% (30% of all entries)
R04 Quartet Champions 1957 2015 100% (100% of all entries)
R05 Quartet Champions 1976 2015 35% (35% of all entries)
R06 Quartet Champions 1976 2015 42% (42% of all entries)
R07 Quartet Champions 1999 2012 29% (28% of all entries)
R08 Quartet Champions 1959 2015 100% (100% of all entries)
R09 Quartet Champions 1999 2015 65% (64% of all entries)
R10 Quartet Champions 1961 2015 33% (32% of all entries)
R11 Quartet Champions 1947 2015 23% (23% of all entries)
R12 Quartet Champions 1992 2013 95% (95% of all entries)
R13 Quartet Champions 1957 2015 100% (100% of all entries)
R14 Quartet Champions 1976 2015 40% (40% of all entries)
R15 Quartet Champions 1966 2011 50% (50% of all entries)
R16 Quartet Champions 1972 2015 20% (20% of all entries)
R17 Quartet Champions 1976 2015 95% (100% of all entries)
R19 Quartet Champions 1962 2018 61% (61% of all entries)
R20 Quartet Champions 1978 2002 56% (56% of all entries)
R21 Quartet Champions 1964 2018 35% (34% of all entries)
R22 Quartet Champions 2001 2013 31% (30% of all entries)
R23 Quartet Champions 1968 2013 76% (102% of all entries)
R24 Quartet Champions 1982 2013 100% (100% of all entries)
R25 Quartet Champions 1993 2016 42% (41% of all entries)
R26 Quartet Champions 1982 2015 32% (32% of all entries)
R31 Quartet Champions 1995 2016 59% (59% of all entries)
R32 Quartet Champions 2007 2010 50% (50% of all entries)
R34 Quartet Champions 2004 2010 100% (100% of all entries)
R35 Quartet Champions 1990 2015 85% (100% of all entries)
RMD Quartet Champions 1977 2018 100% (100% of all entries)
SAI International Quartet Champions 1947 2019 99% (98% of all entries)
SAI Rising Star Champions 1999 2018 95% (95% of all entries)
SLD Collegiate Champions 1993 2015 74% (73% of all entries)
SLD Novice Champions 1970 2014 91% (91% of all entries)
SLD Quartet Champions 1946 2018 100% (100% of all entries)
SLD Seniors Champions 1990 2010 86% (85% of all entries)
SNOBS Quartet Champions 1981 2016 94% (94% of all entries)
SUN Collegiate Champions 1999 2011 77% (76% of all entries)
SUN Quartet Champions 1959 2018 100% (100% of all entries)
SUN Seniors Champions 1985 2015 74% (85% of all entries)
SWD Collegiate Champions 1993 2013 38% (38% of all entries)
SWD Novice Champions 1989 2011 39% (39% of all entries)
SWD Quartet Champions 1949 2018 100% (100% of all entries)
SWD Seniors Champions 1987 2011 96% (100% of all entries)
UK Mixed Quartet Champions 2012 2015 100% (100% of all entries)

Champ lists without singers listed

Quartet pages without singers listed (8)

4U has 4 members:

Cantores Maruli has 0 members: Channel Markers has 0 members: Crosstown Celebration has 0 members: Dapper Dans of Disney World has 0 members: Starshine has 0 members: The Ideals has 0 members: WLS High Brau has 0 members:

Quartets with the most awards

Perfect Timing has 8 awards:

The Alumni has 7 awards:

Extravaganza has 7 awards:

Men In Black has 7 awards:

Benchmark has 7 awards:

Accolade has 6 awards:

Chord Company has 6 awards:

Even Time has 6 awards:

Legacy has 6 awards:

Absolut has 6 awards:

Quartets with the most types of awards

Legacy has 6 awards:

Saturday's Heroes has 4 awards:

Men In Black has 7 awards:

Vocal Spectrum has 4 awards:

Trademark has 4 awards:

Ringmasters has 6 awards:

Talk of the Town has 3 awards:

GQ has 5 awards:

Lucky Day has 4 awards:

Bonus Track has 3 awards:

Singers with the most awards

Leo Sisk has 12 awards:

Derek Cosburn has 10 awards:

Ray Johnson has 10 awards:

Kathy Fazekas has 10 awards:

Paul Mahan has 10 awards:

Joacim Stappe has 10 awards:

Richard Öhman has 10 awards:

Amy Ringley has 10 awards:

Toni Griffin has 10 awards:

Bengt Thaysen has 9 awards:

Singers with the most types of awards

Jay Hawkins has 8 awards:

Jeremy Conover has 8 awards:

Ray Johnson has 10 awards:

Gary Lewis has 6 awards:

Oliver Merrill has 9 awards:

Paul Saca has 7 awards:

Aaron Pollard has 4 awards:

[[Andrea Day]] has 5 awards:

Bryan Ziegler has 4 awards:

Richard Lewellen has 4 awards:

Singers in the most quartets

Paul Mahan was in 10 quartets:

Ron Mason was in 8 quartets:

Rob Lamont was in 8 quartets:

Tim Reynolds was in 8 quartets:

Jay Hawkins was in 7 quartets:

John Mallett was in 7 quartets:

Jeremy Conover was in 7 quartets:

Bill Wickstrom was in 7 quartets:

Paul Saca was in 7 quartets:

Bob Fuest was in 6 quartets:

Potential disambiguation pages needed (158)

(18) Legacy

(16) Flipside

  • Tenor - Paul Krenz (Championship: None)
  • Tenor - Rick Spencer (Championship: None)
  • Lead - Mike McCormic (Championship: None)
  • Bari - Tim McCormic (Championship: 2016 EVG)
  • Bass - Kevin Stinson (Championship: 2016 EVG)
  • Tenor - Mike McCormic (Championship: 2016 EVG)
  • Lead - Paul Carter (Championship: 2016 EVG)
  • Lead - Eric Christensen (Championship: None)
  • Tenor - Al Walters (Championship: 1997 PIO Seniors)
  • Lead - Terry Huyge (Championship: 1997 PIO Seniors)
  • Bari - Gary Branch (Championship: 1997 PIO Seniors)
  • Bass - Jack Sidor (Championship: 1997 PIO Seniors)
  • Tenor - Sandy Cope (Championship: 2013 R12)
  • Lead - Kathy Pecsar (Championship: 2013 R12)
  • Bari - Margaret Leggett (Championship: 2013 R12)
  • Bass - Merriann Cree (Championship: 2013 R12)

(14) Lucky Day

  • Tenor - Gene Woolcott (Championship: 1986 ILL)
  • Lead - Ron Rank (Championship: 1986 ILL)
  • Bari - Russ Foris (Championship: 1986 ILL)
  • Bass - Jake Corrough (Championship: 1986 ILL)
  • Tenor - Karen Tate (Championship: 2010 R04)
  • Lead - Gale Connelly (Championship: 2010 R04)
  • Bari - Holly Colon (Championship: 2010 R04)
  • Bass - Kris Wheaton (Championship: 2010 R04)
  • Lead - LeeAnne Vance (Championship: 2008 R04)
  • Bass - Kris (Hawkins) Wheaton (Championship: 2008 R04)
  • Tenor - Roger Ross (Championship: 2009 SUN)
  • Lead - Eric Bell (Championship: 2009 SUN)
  • Bari - Paul Gilman (Championship: 2009 SUN)
  • Bass - Jay Hawkins (Championship: 2009 SUN)

(14) Saturday's Heroes

(14) Premiere

  • Tenor - Rick Savage Jr. (Championship: 1997 MAD)
  • Lead - Fred Womer (Championship: 1997 MAD)
  • Bari - Denny Malone (Championship: 1997 MAD)
  • Bass - Bill Clark (Championship: 1997 MAD)
  • Tenor - Cheryl Doser (Championship: 1999 R20)
  • Lead - Lynn Carlson (Championship: 1999 R20)
  • Bari - Donna Gruis (Championship: 1999 R20)
  • Bass - Russine Morris (Championship: 1999 R20)
  • Tenor - Carole Adams (Championship: 1997 R20)
  • Tenor - Colleen Matt (Championship: 2012 R22)
  • Lead - Nancy Charles (Championship: 2012 R22)
  • Bari - Brenda Krueger (Championship: 2012 R22)
  • Bass - Brenda Follensbee (Championship: 2012 R22)
  • Bari - Renee Rieboldt (Championship: 2009 R22)

(13) Saturday Evening Post

(12) Talk of the Town

(12) GQ

  • Tenor - Amanda McNutt (Championship: 2016 R19)
  • Bari - Ali Hauger (Championship: None)
  • Lead - Katie Gillis (Championship: 2014 R19)
  • Bass - Katie MacDonald (Championship: 2016 R19)
  • Tenor - Keith Olson (Championship: 2011 LOL)
  • Lead - Heath Walker (Championship: 2011 LOL)
  • Bari - Brent Graham (Championship: 2011 LOL)
  • Bass - Steven McDonald (Championship: 2011 LOL)
  • Lead - Alexandra "Ali" Hauger (Championship: 2016 R19)
  • Bari - Katie Gillis (Championship: 2016 R19)
  • Bari - Alexandra "Ali" Hauger (Championship: 2014 R19)
  • Lead - Ali Hauger (Championship: 2012 SAI Rising Star)

(12) Uptown Sound

  • Tenor - Jeff Archer (Championship: 1996 JAD)
  • Tenor - Don Kahl (Championship: None)
  • Lead - David Calland (Championship: None)
  • Bari - Steven Kovach Jr (Championship: None)
  • Bass - Stephen Denino (Championship: None)
  • Lead - David Calland (Championship: 1996 JAD)
  • Bari - Steve Kovach (Championship: 1996 JAD)
  • Bass - Steve Denino (Championship: 1996 JAD)
  • Tenor - Shirley Doss (Championship: 1997 R19)
  • Lead - Karen Matthews (Championship: 1997 R19)
  • Bari - Kelly Mazzoni (Championship: 1997 R19)
  • Bass - Dotty Myers (Championship: 1997 R19)

(12) Esprit de Corps