Category Archives: football match result database

Categories

Archive

FMRD-Summary Table Description: What’s inherited from FMRD

This post is the first of a multi-part series that describes the tables of the FMRD-Summary schema.  As the name suggests, this schema is derived from the Football Match Result Database, so I will show which FMRD tables have been retained.  A more detailed description is in the FMRD-Summary wiki page. Personnel tables I included [...] Read more ›

AuthorHoward Hamilton
Categories
Database Development, FMRD-Summary, football match result database

Introducing the Football Match Result and Summary Database

The ‘lite’ dataset released by the MCFC Analytics project last weekend is a massive dump of almost 200 summary in-match metrics for every player who participated in every match of the 2011-12 English Premier League — more than 10,000 records and 2 million data cells.  We set out to convert that dataset into something more [...] Read more ›

AuthorHoward Hamilton
Categories
#MCFCAnalytics, Database Development, football match result database, MCFC Analytics

Further comments on the MCFC Analytics dataset

A few hours have passed since my initial post in reaction to the ‘basic’ dataset released by Man City’s performance analysis department, and I have some further comments. First of all, I hold Manchester City’s Performance Analysis department, and especially Gavin Fleig, in very high regard.  I’ve gotten to know Gavin professionally and personally over [...] Read more ›

AuthorHoward Hamilton
Categories
#MCFCAnalytics, Database Development, Football Match Event Database, football match result database, Match Data Collection

MCFC Analytics ‘basic’ dataset: Not good enough

Like many of the visitors to this site, I eagerly awaited the release of the MCFC Analytics dataset. I don’t expect everyone to agree with me, but I’ll just get to the point and say it: the basic dataset that MCFC and Opta have released is simply not good enough. The MCFC/Opta dataset is a [...] Read more ›

AuthorHoward Hamilton
Categories
#MCFCAnalytics, 2011-12 English Premier League, Database Development, football match result database, Match Data Collection

Introducing the Football Match Event Database

Manchester City Football Club have launched an exciting initiative in which they have released the full set of 2011-12 Premier League touch-by-touch data compiled by Opta Sports.  This initiative creates an opportunity to support the development of new team and player performance metrics in football, but also creates challenges in modeling a very rich in-match [...] Read more ›

AuthorHoward Hamilton
Categories
#MCFCAnalytics, Database Development, Football Match Event Database, football match result database

More on substitutions at Euro 2012

My previous post on substitutions at UEFA Euro 2012 drew a comment on Soccermetrics Research’s Facebook page that asked if I could control for the substitute’s position in my analysis.  I was curious about the results myself, so here they are.Below is a table of the default positions of players who were substituted in and [...] Read more ›

AuthorHoward Hamilton
Categories
football match result database, Player Performance, soccer match database, Team Performance, UEFA Euro 2012

Substitutions and their impact at Euro 2012

I continue my statistical review of UEFA Euro 2012 with a look at the substitution patterns over the duration of the tournament.  The analysis is similar to what I did for the 2012 Africa Cup of Nations. The following chart is the distribution of the substitution events at Euro 2012. Time segments are 5 minutes [...] Read more ›

AuthorHoward Hamilton
Categories
football match result database, Player Performance, Team Performance, UEFA Euro 2012

Football Match Result Database Project: The roadmap and the call

This is the fifth and final part of my week-long presentation of the Football Match Result Database project. Here are the previous articles: Part I: Selected screenshots Part II: Motivation, design and implementation histories Part III: Database objective, design, and features Part IV: Code release Now that my codebase for the FMRD has been made public, this will be the last post I make on the project on the blog. There will still be development, of course, and if there is a major release it will be announced here, but I will confine discussion to the project to the project… Read more ›

AuthorHoward Hamilton
Categories
football match result database, Soccer Database Development

Football Match Result Database Project: Release Day!

This is the fourth part of my week-long presentation of the Football Match Result Database project. Here are the other articles in the series: Part I: Selected screenshots Part II: Motivation, design and implementation histories Part III: Database objective, design, and features Part V: Roadmap and call for contributors This is the moment that you — and I — have been waiting for. It’s Release Day. I have submitted an announcement to Freshmeat, and if approved, you should see that announcement in a few hours. (And here is the Freshmeat announcement.) Below is the information you need to know: The… Read more ›

AuthorHoward Hamilton
Categories
football match result database, Soccer Database Development

Football Match Result Database Project: Philosophy and functionality

This is the third part of my week-long presentation of the Football Match Result Database project. Here are the other articles in the series: Part I: Selected screenshots Part II: Motivation, design and implementation histories Part IV: Code release Part V: Roadmap and call for contributors Yesterday I wrote a long article on the origins of the FMRD and the various turns I took in developing the database design and its data-entry application. In this article I will discuss the functionality of the design and application: its purpose, its main features, and the philosophical rationale for the design and implementation… Read more ›

AuthorHoward Hamilton
Categories
football match result database, Soccer Database Development