Watford FC Database

Discussion in 'The Hornets' Nest - Watford Chat' started by R55BKR, Jan 2, 2019.

  1. R55BKR

    R55BKR Academy Graduate

    As a little project, I have created a searchable Watford game/result database and made it available on t'interweb.

    Works a bit like Google in that you can search for pretty much anything and it will return all matching games. You can then click on a game to see the full details.

    For example, you can search for:
    • bournemouth away premier (to get all Premier league games away versus Bournemouth)
    • 2-1 mooney (all games that Watford won 2-1 where Tommy Mooney featured)
    • foxes 3-1 (to find "that" game)
    • "doyley scored"
    • "vydra sub" "vydra scored" (games where Matej came off the bench to score)
    • "vydra subbed" "vydra scored" (games where Matej scored and was then subbed off)
    It goes back to 1898 (who knew we had a player called Tuggy Beach?!) using all Trefor's data up to a certain point and is now updated after each match with the help of Jon from wfc.net

    Its kinda new and still in "beta" to a certain extent as I do intend to improve it, so please be kind, but do let me know if you find any problems or if you find something isn't as you'd expect!

    http://watford.fcdb.info
     
    Vespa Crabro, reids, 533 and 19 others like this.
  2. The undeniable truth

    The undeniable truth First Team Captain

    Great, if it works.
    I searched for "phillips scored 2" and "phillips scored 1". it only brought up about 5 games in total.
    In the "scored 1" search it brought up;
    a 3-0 win vs Bristol City where it happily tells me that Phillips scored 2.
    a 1-2 defeat vs oldham where Ramage was our only scorer.
     
  3. R55BKR

    R55BKR Academy Graduate

    Yeah, slight pain with searching for players scoring is that you need it in quotes current;y (looking to improve that)
    "phillips scored 1" and
    "phillips scored 2" should work fine
    (or click on the goal/ball icons after their name in a match where they have scored)
     
  4. Hmm - I searched for 'Doyley scored 1' and it told me to hop off the scales...
     
  5. Thanks for that - I inserted quotation marks and it worked fine.
     
  6. GoingDown

    GoingDown "The Stability"

    Is this available on Kindle?
     
    RookeryDad and Burnsy like this.
  7. Burnsy

    Burnsy First Team

    I searched for ‘tinpot’ and ‘entitled fans’.

    It’s a treasure trove of info.
     
  8. The undeniable truth

    The undeniable truth First Team Captain

    It's a brilliant tool. Just looked at all Blissetts goals data.
    Another anomaly - why can't I find "coffill scored 1" or indeed 2 when he scored 6 goals for the club per wiki and scored in the first match I ever saw. Is data missing for that period ?

    How does it cope with the changing names of the leagues, 4=>2, 3=>1, 2=> champ, 1 => prem etc ? Will a search for games vs swansea in div 1 bring up a mix of different leagues for example ?
     
    heftiehornet likes this.
  9. Stevohorn

    Stevohorn Watching Grass Grow

    I searched for "Tuggy Beach scores" but was redirected to a porn site :eek:
     
  10. R55BKR

    R55BKR Academy Graduate

    Re Coffill...
    Nope the data not missing, just a developer's error preventing it from being found - sorry!

    Try now...!
     
  11. The undeniable truth

    The undeniable truth First Team Captain

    Yes has my first game vs Bournemouth in '77 now.
    Shows 7 goals, so Wiki was wrong with only 6.

    What about the leagues name-changing issue ?
     
  12. R55BKR

    R55BKR Academy Graduate

    Hopefully all leagues can be found under their name at the time.

    If you wanted to find top division games you could add tier:1 into your search (similarly tier:2 for all Old Div 2, Championship etc games)
     
  13. R55BKR

    R55BKR Academy Graduate

    Looks like it didnt count the cup goal!
     
  14. nornironhorn

    nornironhorn Administrator Staff Member

    Wikipedia doesn't show cup goals or appearances in their 'factfile'.

    You have done a great job with the site! Probably not easily implemented, but I'd be interested in searching players based on nationality.

    For example:
    • Goalscorers from France
    • Players from Italy
     
  15. Cthulhu

    Cthulhu Keyboard Warrior Staff Member

    Can you change your avatar please. It reminds me of the white bear glyph from Bandersnatch and now I am questioning my own free will
     
    folkestone orn likes this.
  16. GoingDown

    GoingDown "The Stability"

    I bet you chose Sugar Puffs.
     
    Bwood_Horn likes this.
  17. The undeniable truth

    The undeniable truth First Team Captain

    Ah yes.....
     
  18. The undeniable truth

    The undeniable truth First Team Captain

    Perfect if you can search by tiers. All games vs a team played in league 1 would otherwise be meaningless.
     
  19. Cthulhu

    Cthulhu Keyboard Warrior Staff Member

    Yes of couse. I also took the opportunity to kill or be killed whenever possible, knowing Charlie Brooker that always leads to the best and most entertaining outcomes.

    "Stab them" or "talk about your mother"

    Never really an option
     
  20. Davidmsawyer

    Davidmsawyer Statto Statto Statto

    This is really impressive! It is getting my Statto juices flowing! Fantastic work, I know I'll be dipping into this a lot.
     
  21. Davidmsawyer

    Davidmsawyer Statto Statto Statto

    On thing that would be good would be to have the option of choosing how many results to output so that it isn't limited to ten.
     
  22. I searched for ‘that time we threw pasties on the pitch at Grimsby’ but it’s not working for some reason
     
  23. Klein Lust

    Klein Lust Uber Keine

    Brilliant!

    James Panayi...great for finding out info about random players, bit more statistical that BS&D
     
  24. SkylaRose

    SkylaRose Administrator Staff Member

    Great work. Really like the idea. I’m pretty sure it’s a club first. Any chance WFC.com could upload it to the official site? Definitely worth an email. You may even make slight royalties off adverts.

    Of course, get it out of Beta first so it’s eorking at least 99% perfectly. Any bug fixes etc.
     
  25. lowerrous

    lowerrous First Team


    Yep, it works.
     
  26. leighton buzzard horn

    leighton buzzard horn Squad Player

    That must have taken an age to put together. It is brilliant though - so thank you very much.
     
  27. RookeryDad

    RookeryDad Squad Player

    Can you search for Coffill’s top ten albums?
     
  28. folkestone orn

    folkestone orn Squad Player

    A superstitious man would say you deserve some credit for his goals tonight.
     
  29. The undeniable truth

    The undeniable truth First Team Captain

    http://watford.fcdb.info/
    This database is brilliant but denies the existence of Alan Mayes.
    It lists him in team line ups (for example the cup SF vs Nottm Forest) but when you search using his name alone it denies anyone of that name ever played for us. Not sure why ? Was just using it to look up and see when his last game for us was....
     
  30. Leighton Buzzer

    Leighton Buzzer Reservist

    Oh dear!, are you any good at removing viruses from your device, or did you have to get a new one?
     
  31. Stevohorn

    Stevohorn Watching Grass Grow

    All cleaned up now :)
     
    Leighton Buzzer likes this.
  32. R55BKR

    R55BKR Academy Graduate

    Hi there, thanks for your feedback and for alerting me to a problem with one of the searches.
    Without getting too technical, I have to do some funky stuff with dates with short names (eg May) and because of this, it meant that searching for Mayes was not working properly.
    I have adjusted it now so that your search for Alan Mayes works fine..
     

Share This Page