11v11 : The Association of Football Statisticians
Co-founder / Developer / DBA / Systems Architect
This project has been developed / evolved over the last 9 years or so. It's main focus is a large database of football data : The Football Genome Project... a database which will contain information on every single player, team and match in professional football since the beginning - in the 1800s.
The database is maintained by a number of people in various parts of the world using a web-based admin system. The data is displayed via a fairly large number of queries, focusing around pages for player, matches, and teams
In addition to this there is:
- Various data sources eg: Today in History, Obituries etc
- An interactive googlemap app where people can locate their own team's stadiums
- A content management system
- Recurring subscriptions using paypal
- A gallery of historical photos
- A book reviews section with links/images via the Amazon API
- Graphical and tabular representations of data
- A Mailman mailing list
- A Blog using wordpress
Prior to the last World Cup we also ran a project "The Wisdom of Fans" (inspired by the Wisdom of crowds) in which we set up a sub-site so people could predict the rankings of the participating teams. Given the randomness of the participants the result was unsuprisingly in variance with what actually happened (which was itself something of a surprise (well, to everyone except the Italians)). The aggregated predictions of participants was however, identical to the bookie's odds. Interesting result.
11v11 is an ongoing project.
- PHP
- MySql
- Apache
- Linux
- XML / XSLT
- HTML / CSS