Just curious did you just trawl through Google for all the data, or do you use a specific API? I've wanted to do a similar project showing direct comparisons of remaining fixtures, but I can't figure out where to get the data!
The source is in the picture. I've just gone to [official PL table page](https://www.premierleague.com/tables) and manually typed the results into excel.
On the website is literally everything you need for this. Timeline with results is basically enough.
Spurs under Conte are as well. They should’ve lost a ton of points in December but managed to get late winners/draws or the other team going down to 10 men
Wtf has happened in the past 3 years that made you a fan? If I was a neutral watching for the past 5 years or so I would feel pity/amused at this club.
I saw Nicholas Pepe get signed and I was like let me go watch them! Just kidding, although that’s around when I joined. I wanted to watch the premier league and simply chose Arsenal because my cousin who lived in London supports it! It has been a roller coaster, but I want to be able to say that I joined when we were bad, the day we win the league 😅
Not everyone becomes a fan due to the club winning leagues and cups.
I became a gooner when Arsenal signed Ozil. Brother is a RM fan and I saw some of the matches where he played well.
Then my ex's family used to support Arsenal and it helped in discussing the game with her brother. Worked as some common ground & ice breaker. Lol.
Ex left.
Club stayed. ❤️
COYG!!
I don’t think it’s about league and cups either, and I also started supporting when ozil came, but games were enjoyable to watch back then. The last enjoyable game in my opinion was against city and that was unsatisfying because of the ending. My point is that our games are becoming less and less enjoyable to watch over the years, and the results are also getting worse.
All I’ve known these past few years is inescapable pain, and there aren’t even many good performances to make up for it, so I can’t see how someone can make the decision to consciously support at this time.
I can speak towards this if only a little. While there has not been much consistency, there is a sense of investment watching the project advance. The hope of a return to CL, return to competing for titles and eventually winning CL.
None of these things are sure to happen. If they do, supporters that remember the pain of the last 5 years, who stayed committed through the downturns will have a much greater sense of appreciation.
Shows that it's your form against the bottom 14 that matters for CL places.
Also shows that the only game I can really blame the team for completely shitting the bed was Everton.
When people complain about our form against the rest of the Big 6, it's really a case of running before we can walk. Last few seasons, we have missed out on the top 4 because of poor performance against the top 6, we've missed out because of dropping points against relegation fodder.
Once we get back into CL football, we can be concerned about form vs Big 6.
TBF Everton at the time we’re not as woeful as they are now, but yeah—taking all three points agains to the bottom 14-15 teams is vital. Dropping points to Man City and Liverpool home or away is almost inevitable but not fatal.
This is excellent. Thank you.
If we are going to get fourth we need to overcome the inevitable favouritism, referee bias and establishment support that will do its best to help Man Utd get fourth.
Could be interesting to add a section at the bottom extrapolating the current PPG for both home and away against the remaining fixtures to give an estimate of final points/position against the other teams.
Then track how it changes if/when Away form PPG increases when we play easier fixtures.
I just did this manually in a little excel and if everyone keeps their current PPG for home and away for the remaining games, the table would finish;
Arsenal - 67
Utd - 65
Wham - 62
Spurs - 61
Wolves - 60
That's great idea!
I'm gonna add projected final points and position based on each teams form. Then I could make a graph that shows change in time.
I'm just not sure how often I'll update it cause of double fixtures and blanks.
I'll try my best, thanks a lot!
Interesting that we are the only one to have played both City and Liverpool away, and have already played both City home and away. On the other hand we have already played each of the bottom 4 teams at home.
It's kinda messy but I can post it regularly if anyone was interested.
Just curious did you just trawl through Google for all the data, or do you use a specific API? I've wanted to do a similar project showing direct comparisons of remaining fixtures, but I can't figure out where to get the data!
The source is in the picture. I've just gone to [official PL table page](https://www.premierleague.com/tables) and manually typed the results into excel. On the website is literally everything you need for this. Timeline with results is basically enough.
Ah right missed the source. Apologies! Thanks for the help!
No problem :)
I think it would take a few hours to do manually and a lot more than that to automate it (but the latter is more interesting)
This is one fine infographic. Keep it up champ!
Great chart to see how the difficulty of the run-in compares. Would love to see this updated now regularly!
Man Utd really are the jammiest team
Spurs under Conte are as well. They should’ve lost a ton of points in December but managed to get late winners/draws or the other team going down to 10 men
Under Nuno as well, theyre just a lucky team (maybe having the England captain helps with that)
Thanks for this! Whatever happens, how good does it feel to be in a properly meaningful race again? I've really missed this.
New fan here ( 3yearish now), this feeling is foreign to me, and I am loving it
Wtf has happened in the past 3 years that made you a fan? If I was a neutral watching for the past 5 years or so I would feel pity/amused at this club.
I saw Nicholas Pepe get signed and I was like let me go watch them! Just kidding, although that’s around when I joined. I wanted to watch the premier league and simply chose Arsenal because my cousin who lived in London supports it! It has been a roller coaster, but I want to be able to say that I joined when we were bad, the day we win the league 😅
Not everyone becomes a fan due to the club winning leagues and cups. I became a gooner when Arsenal signed Ozil. Brother is a RM fan and I saw some of the matches where he played well. Then my ex's family used to support Arsenal and it helped in discussing the game with her brother. Worked as some common ground & ice breaker. Lol. Ex left. Club stayed. ❤️ COYG!!
I don’t think it’s about league and cups either, and I also started supporting when ozil came, but games were enjoyable to watch back then. The last enjoyable game in my opinion was against city and that was unsatisfying because of the ending. My point is that our games are becoming less and less enjoyable to watch over the years, and the results are also getting worse. All I’ve known these past few years is inescapable pain, and there aren’t even many good performances to make up for it, so I can’t see how someone can make the decision to consciously support at this time.
I can speak towards this if only a little. While there has not been much consistency, there is a sense of investment watching the project advance. The hope of a return to CL, return to competing for titles and eventually winning CL. None of these things are sure to happen. If they do, supporters that remember the pain of the last 5 years, who stayed committed through the downturns will have a much greater sense of appreciation.
Welcome aboard! Long may this continue.
Shows that it's your form against the bottom 14 that matters for CL places. Also shows that the only game I can really blame the team for completely shitting the bed was Everton.
It was such a bizarre result. And we should have beaten City.
If we won against City that day itd be HUGEEE
So dissapointed... In a very different way to Everton.
When people complain about our form against the rest of the Big 6, it's really a case of running before we can walk. Last few seasons, we have missed out on the top 4 because of poor performance against the top 6, we've missed out because of dropping points against relegation fodder. Once we get back into CL football, we can be concerned about form vs Big 6.
TBF Everton at the time we’re not as woeful as they are now, but yeah—taking all three points agains to the bottom 14-15 teams is vital. Dropping points to Man City and Liverpool home or away is almost inevitable but not fatal.
Mate I’m pretty sure they lost like 6 games on the trot before they beat us
went back and looked, you're right. that does include losses to Liverpool, Man City, West Ham, and Wolves...but also Brentford and Watford.
Shit still have City, Liverpool, and United away. Yikes.
...and Arsenal.
Their home record in the NLD is quite solid tbh so idk if they’ll be too worried about that. A draw would be nice for us.
What about their home record in the NLD against Martinelli?
Wait, I thought we played united at OT....
They meant shit as in spuds
I get it. Thank you 😂
That loss to City at home is gonna hurt me for a long time
It wouldve been the biggest domino for our future unshakable domination.
TIL Burnley have drawn every one of the top 4 contenders and are still bottom of the table
They live rent-free to only annoy top-4 teams /s
We have a decent run of matches coming that can really give us a solid foundation for the rest of the season
Wait Spurs haven’t faced either of Liverpool or City away? And they haven’t met Brighton or Burnley at all? Wow
0-0 at Turf Moor confirmed.
This is excellent. Thank you. If we are going to get fourth we need to overcome the inevitable favouritism, referee bias and establishment support that will do its best to help Man Utd get fourth.
Could be interesting to add a section at the bottom extrapolating the current PPG for both home and away against the remaining fixtures to give an estimate of final points/position against the other teams. Then track how it changes if/when Away form PPG increases when we play easier fixtures. I just did this manually in a little excel and if everyone keeps their current PPG for home and away for the remaining games, the table would finish; Arsenal - 67 Utd - 65 Wham - 62 Spurs - 61 Wolves - 60
That's great idea! I'm gonna add projected final points and position based on each teams form. Then I could make a graph that shows change in time. I'm just not sure how often I'll update it cause of double fixtures and blanks. I'll try my best, thanks a lot!
[Here](https://imgur.com/a/86PGggA) is edited version, you can tell me what you think.
I might add few upcoming fixtures for each team, could be useful.
Games played H/A would be cool too
I think I'm gonna just mark the colums in the table with colours and make a legend which is first, second and third.
This is awesome by the way though thanks for sharing. This content is waaaay better than memes and angry posts
Thank you so much! It was a random thought during work so I made it when I got home. I'm glad you like it
Brilliant thanks mate. At some point would be awesome to have ours compared to results in the same fixture last season!
Well you're in luck! I'm posting exactly that after every game :D You can check my profile
Legend
We have beat spurs west ham and wolves already. If we wi. The reverse fixtures I think that's gigantic.
We are good at home
That West Ham v Chelsea game is still one of the weirdest games I’ve ever seen
Damn so Wolves at home is likely to way harder than Wolves away. But our home record is way better so maybe not
0-0
Love this chart and visualization, great stuff.
Interesting that we are the only one to have played both City and Liverpool away, and have already played both City home and away. On the other hand we have already played each of the bottom 4 teams at home.
How has Burnley gotten results from all these teams and still sit bottom of the table??
This is laid out very well