Baselight
select c.country, c.name as competition, s.season_label, teams.name as team, m_stats.type as stat_type, m_stats.value as stat_value, m.referee_name, m.match_id, m.date
from @blt.ultimate_soccer_dataset.matches m
     INNER JOIN @blt.ultimate_soccer_dataset.match_stats m_stats ON (m.match_id = m_stats.match_id)
     INNER JOIN @blt.ultimate_soccer_dataset.teams teams ON (m_stats.team_id = teams.team_id)
     INNER JOIN @blt.ultimate_soccer_dataset.seasons s ON (m.season_id = s.season_id)
     INNER JOIN @blt.ultimate_soccer_dataset.competitions c ON (s.competition_id = c.competition_id)
where c.name = 'Premier League' 
order by m.date, m.match_id, stat_type, team
limit 100
countrycompetitionseason_labelteamstat_typestat_valuereferee_namematch_iddate
EnglandPremier League2014/2015LeicesterBall Possession47Mike Jones2666d419-f24b-5a78-b6f8-71b81d278eea2015-01-01 00:00:00+00
EnglandPremier League2014/2015LiverpoolBall Possession53Mike Jones2666d419-f24b-5a78-b6f8-71b81d278eea2015-01-01 00:00:00+00
EnglandPremier League2014/2015LeicesterBlocked ShotsnullMike Jones2666d419-f24b-5a78-b6f8-71b81d278eea2015-01-01 00:00:00+00
EnglandPremier League2014/2015LiverpoolBlocked ShotsnullMike Jones2666d419-f24b-5a78-b6f8-71b81d278eea2015-01-01 00:00:00+00
EnglandPremier League2014/2015LeicesterCorner Kicks5Mike Jones2666d419-f24b-5a78-b6f8-71b81d278eea2015-01-01 00:00:00+00
EnglandPremier League2014/2015LiverpoolCorner Kicks4Mike Jones2666d419-f24b-5a78-b6f8-71b81d278eea2015-01-01 00:00:00+00
EnglandPremier League2014/2015LeicesterFouls7Mike Jones2666d419-f24b-5a78-b6f8-71b81d278eea2015-01-01 00:00:00+00
EnglandPremier League2014/2015LiverpoolFouls13Mike Jones2666d419-f24b-5a78-b6f8-71b81d278eea2015-01-01 00:00:00+00
EnglandPremier League2014/2015LeicesterGoalkeeper Saves4Mike Jones2666d419-f24b-5a78-b6f8-71b81d278eea2015-01-01 00:00:00+00
EnglandPremier League2014/2015LiverpoolGoalkeeper Saves1Mike Jones2666d419-f24b-5a78-b6f8-71b81d278eea2015-01-01 00:00:00+00
EnglandPremier League2014/2015LeicesterOffsides1Mike Jones2666d419-f24b-5a78-b6f8-71b81d278eea2015-01-01 00:00:00+00
EnglandPremier League2014/2015LiverpoolOffsides2Mike Jones2666d419-f24b-5a78-b6f8-71b81d278eea2015-01-01 00:00:00+00
EnglandPremier League2014/2015LeicesterPasses %nullMike Jones2666d419-f24b-5a78-b6f8-71b81d278eea2015-01-01 00:00:00+00
EnglandPremier League2014/2015LiverpoolPasses %nullMike Jones2666d419-f24b-5a78-b6f8-71b81d278eea2015-01-01 00:00:00+00
EnglandPremier League2014/2015LeicesterPasses accuratenullMike Jones2666d419-f24b-5a78-b6f8-71b81d278eea2015-01-01 00:00:00+00
EnglandPremier League2014/2015LiverpoolPasses accuratenullMike Jones2666d419-f24b-5a78-b6f8-71b81d278eea2015-01-01 00:00:00+00
EnglandPremier League2014/2015LeicesterRed Cards0Mike Jones2666d419-f24b-5a78-b6f8-71b81d278eea2015-01-01 00:00:00+00
EnglandPremier League2014/2015LiverpoolRed Cards0Mike Jones2666d419-f24b-5a78-b6f8-71b81d278eea2015-01-01 00:00:00+00
EnglandPremier League2014/2015LeicesterShots insideboxnullMike Jones2666d419-f24b-5a78-b6f8-71b81d278eea2015-01-01 00:00:00+00
EnglandPremier League2014/2015LiverpoolShots insideboxnullMike Jones2666d419-f24b-5a78-b6f8-71b81d278eea2015-01-01 00:00:00+00
EnglandPremier League2014/2015LeicesterShots off Goal7Mike Jones2666d419-f24b-5a78-b6f8-71b81d278eea2015-01-01 00:00:00+00
EnglandPremier League2014/2015LiverpoolShots off Goal9Mike Jones2666d419-f24b-5a78-b6f8-71b81d278eea2015-01-01 00:00:00+00
EnglandPremier League2014/2015LeicesterShots on Goal4Mike Jones2666d419-f24b-5a78-b6f8-71b81d278eea2015-01-01 00:00:00+00
EnglandPremier League2014/2015LiverpoolShots on Goal6Mike Jones2666d419-f24b-5a78-b6f8-71b81d278eea2015-01-01 00:00:00+00
EnglandPremier League2014/2015LeicesterShots outsideboxnullMike Jones2666d419-f24b-5a78-b6f8-71b81d278eea2015-01-01 00:00:00+00
EnglandPremier League2014/2015LiverpoolShots outsideboxnullMike Jones2666d419-f24b-5a78-b6f8-71b81d278eea2015-01-01 00:00:00+00
EnglandPremier League2014/2015LeicesterTotal ShotsnullMike Jones2666d419-f24b-5a78-b6f8-71b81d278eea2015-01-01 00:00:00+00
EnglandPremier League2014/2015LiverpoolTotal ShotsnullMike Jones2666d419-f24b-5a78-b6f8-71b81d278eea2015-01-01 00:00:00+00
EnglandPremier League2014/2015LeicesterTotal passesnullMike Jones2666d419-f24b-5a78-b6f8-71b81d278eea2015-01-01 00:00:00+00
EnglandPremier League2014/2015LiverpoolTotal passesnullMike Jones2666d419-f24b-5a78-b6f8-71b81d278eea2015-01-01 00:00:00+00
EnglandPremier League2014/2015LeicesterYellow Cards2Mike Jones2666d419-f24b-5a78-b6f8-71b81d278eea2015-01-01 00:00:00+00
EnglandPremier League2014/2015LiverpoolYellow Cards2Mike Jones2666d419-f24b-5a78-b6f8-71b81d278eea2015-01-01 00:00:00+00
EnglandPremier League2014/2015QPRBall Possession45Anthony Taylor3cc4ce7d-143e-5fa4-8bb4-1b1379c4203e2015-01-01 00:00:00+00
EnglandPremier League2014/2015SwanseaBall Possession55Anthony Taylor3cc4ce7d-143e-5fa4-8bb4-1b1379c4203e2015-01-01 00:00:00+00
EnglandPremier League2014/2015QPRBlocked ShotsnullAnthony Taylor3cc4ce7d-143e-5fa4-8bb4-1b1379c4203e2015-01-01 00:00:00+00
EnglandPremier League2014/2015SwanseaBlocked ShotsnullAnthony Taylor3cc4ce7d-143e-5fa4-8bb4-1b1379c4203e2015-01-01 00:00:00+00
EnglandPremier League2014/2015QPRCorner Kicks4Anthony Taylor3cc4ce7d-143e-5fa4-8bb4-1b1379c4203e2015-01-01 00:00:00+00
EnglandPremier League2014/2015SwanseaCorner Kicks9Anthony Taylor3cc4ce7d-143e-5fa4-8bb4-1b1379c4203e2015-01-01 00:00:00+00
EnglandPremier League2014/2015QPRFouls22Anthony Taylor3cc4ce7d-143e-5fa4-8bb4-1b1379c4203e2015-01-01 00:00:00+00
EnglandPremier League2014/2015SwanseaFouls6Anthony Taylor3cc4ce7d-143e-5fa4-8bb4-1b1379c4203e2015-01-01 00:00:00+00
EnglandPremier League2014/2015QPRGoalkeeper Saves2Anthony Taylor3cc4ce7d-143e-5fa4-8bb4-1b1379c4203e2015-01-01 00:00:00+00
EnglandPremier League2014/2015SwanseaGoalkeeper Saves4Anthony Taylor3cc4ce7d-143e-5fa4-8bb4-1b1379c4203e2015-01-01 00:00:00+00
EnglandPremier League2014/2015QPROffsides3Anthony Taylor3cc4ce7d-143e-5fa4-8bb4-1b1379c4203e2015-01-01 00:00:00+00
EnglandPremier League2014/2015SwanseaOffsides4Anthony Taylor3cc4ce7d-143e-5fa4-8bb4-1b1379c4203e2015-01-01 00:00:00+00
EnglandPremier League2014/2015QPRPasses %nullAnthony Taylor3cc4ce7d-143e-5fa4-8bb4-1b1379c4203e2015-01-01 00:00:00+00
EnglandPremier League2014/2015SwanseaPasses %nullAnthony Taylor3cc4ce7d-143e-5fa4-8bb4-1b1379c4203e2015-01-01 00:00:00+00
EnglandPremier League2014/2015QPRPasses accuratenullAnthony Taylor3cc4ce7d-143e-5fa4-8bb4-1b1379c4203e2015-01-01 00:00:00+00
EnglandPremier League2014/2015SwanseaPasses accuratenullAnthony Taylor3cc4ce7d-143e-5fa4-8bb4-1b1379c4203e2015-01-01 00:00:00+00
EnglandPremier League2014/2015QPRRed Cards0Anthony Taylor3cc4ce7d-143e-5fa4-8bb4-1b1379c4203e2015-01-01 00:00:00+00
EnglandPremier League2014/2015SwanseaRed Cards1Anthony Taylor3cc4ce7d-143e-5fa4-8bb4-1b1379c4203e2015-01-01 00:00:00+00
EnglandPremier League2014/2015QPRShots insideboxnullAnthony Taylor3cc4ce7d-143e-5fa4-8bb4-1b1379c4203e2015-01-01 00:00:00+00
EnglandPremier League2014/2015SwanseaShots insideboxnullAnthony Taylor3cc4ce7d-143e-5fa4-8bb4-1b1379c4203e2015-01-01 00:00:00+00
EnglandPremier League2014/2015QPRShots off Goal6Anthony Taylor3cc4ce7d-143e-5fa4-8bb4-1b1379c4203e2015-01-01 00:00:00+00
EnglandPremier League2014/2015SwanseaShots off Goal9Anthony Taylor3cc4ce7d-143e-5fa4-8bb4-1b1379c4203e2015-01-01 00:00:00+00
EnglandPremier League2014/2015QPRShots on Goal6Anthony Taylor3cc4ce7d-143e-5fa4-8bb4-1b1379c4203e2015-01-01 00:00:00+00
EnglandPremier League2014/2015SwanseaShots on Goal3Anthony Taylor3cc4ce7d-143e-5fa4-8bb4-1b1379c4203e2015-01-01 00:00:00+00
EnglandPremier League2014/2015QPRShots outsideboxnullAnthony Taylor3cc4ce7d-143e-5fa4-8bb4-1b1379c4203e2015-01-01 00:00:00+00
EnglandPremier League2014/2015SwanseaShots outsideboxnullAnthony Taylor3cc4ce7d-143e-5fa4-8bb4-1b1379c4203e2015-01-01 00:00:00+00
EnglandPremier League2014/2015QPRTotal ShotsnullAnthony Taylor3cc4ce7d-143e-5fa4-8bb4-1b1379c4203e2015-01-01 00:00:00+00
EnglandPremier League2014/2015SwanseaTotal ShotsnullAnthony Taylor3cc4ce7d-143e-5fa4-8bb4-1b1379c4203e2015-01-01 00:00:00+00
EnglandPremier League2014/2015QPRTotal passesnullAnthony Taylor3cc4ce7d-143e-5fa4-8bb4-1b1379c4203e2015-01-01 00:00:00+00
EnglandPremier League2014/2015SwanseaTotal passesnullAnthony Taylor3cc4ce7d-143e-5fa4-8bb4-1b1379c4203e2015-01-01 00:00:00+00
EnglandPremier League2014/2015QPRYellow Cards4Anthony Taylor3cc4ce7d-143e-5fa4-8bb4-1b1379c4203e2015-01-01 00:00:00+00
EnglandPremier League2014/2015SwanseaYellow Cards0Anthony Taylor3cc4ce7d-143e-5fa4-8bb4-1b1379c4203e2015-01-01 00:00:00+00
EnglandPremier League2014/2015Manchester CityBall Possession68Chris Foy58e329b8-9553-5a34-b83f-06973b8a0cf32015-01-01 00:00:00+00
EnglandPremier League2014/2015SunderlandBall Possession32Chris Foy58e329b8-9553-5a34-b83f-06973b8a0cf32015-01-01 00:00:00+00
EnglandPremier League2014/2015Manchester CityBlocked ShotsnullChris Foy58e329b8-9553-5a34-b83f-06973b8a0cf32015-01-01 00:00:00+00
EnglandPremier League2014/2015SunderlandBlocked ShotsnullChris Foy58e329b8-9553-5a34-b83f-06973b8a0cf32015-01-01 00:00:00+00
EnglandPremier League2014/2015Manchester CityCorner Kicks10Chris Foy58e329b8-9553-5a34-b83f-06973b8a0cf32015-01-01 00:00:00+00
EnglandPremier League2014/2015SunderlandCorner Kicks4Chris Foy58e329b8-9553-5a34-b83f-06973b8a0cf32015-01-01 00:00:00+00
EnglandPremier League2014/2015Manchester CityFouls13Chris Foy58e329b8-9553-5a34-b83f-06973b8a0cf32015-01-01 00:00:00+00
EnglandPremier League2014/2015SunderlandFouls7Chris Foy58e329b8-9553-5a34-b83f-06973b8a0cf32015-01-01 00:00:00+00
EnglandPremier League2014/2015Manchester CityGoalkeeper Saves2Chris Foy58e329b8-9553-5a34-b83f-06973b8a0cf32015-01-01 00:00:00+00
EnglandPremier League2014/2015SunderlandGoalkeeper Saves10Chris Foy58e329b8-9553-5a34-b83f-06973b8a0cf32015-01-01 00:00:00+00
EnglandPremier League2014/2015Manchester CityOffsides1Chris Foy58e329b8-9553-5a34-b83f-06973b8a0cf32015-01-01 00:00:00+00
EnglandPremier League2014/2015SunderlandOffsides3Chris Foy58e329b8-9553-5a34-b83f-06973b8a0cf32015-01-01 00:00:00+00
EnglandPremier League2014/2015Manchester CityPasses %nullChris Foy58e329b8-9553-5a34-b83f-06973b8a0cf32015-01-01 00:00:00+00
EnglandPremier League2014/2015SunderlandPasses %nullChris Foy58e329b8-9553-5a34-b83f-06973b8a0cf32015-01-01 00:00:00+00
EnglandPremier League2014/2015Manchester CityPasses accuratenullChris Foy58e329b8-9553-5a34-b83f-06973b8a0cf32015-01-01 00:00:00+00
EnglandPremier League2014/2015SunderlandPasses accuratenullChris Foy58e329b8-9553-5a34-b83f-06973b8a0cf32015-01-01 00:00:00+00
EnglandPremier League2014/2015Manchester CityRed Cards0Chris Foy58e329b8-9553-5a34-b83f-06973b8a0cf32015-01-01 00:00:00+00
EnglandPremier League2014/2015SunderlandRed Cards0Chris Foy58e329b8-9553-5a34-b83f-06973b8a0cf32015-01-01 00:00:00+00
EnglandPremier League2014/2015Manchester CityShots insideboxnullChris Foy58e329b8-9553-5a34-b83f-06973b8a0cf32015-01-01 00:00:00+00
EnglandPremier League2014/2015SunderlandShots insideboxnullChris Foy58e329b8-9553-5a34-b83f-06973b8a0cf32015-01-01 00:00:00+00
EnglandPremier League2014/2015Manchester CityShots off Goal11Chris Foy58e329b8-9553-5a34-b83f-06973b8a0cf32015-01-01 00:00:00+00
EnglandPremier League2014/2015SunderlandShots off Goal0Chris Foy58e329b8-9553-5a34-b83f-06973b8a0cf32015-01-01 00:00:00+00
EnglandPremier League2014/2015Manchester CityShots on Goal14Chris Foy58e329b8-9553-5a34-b83f-06973b8a0cf32015-01-01 00:00:00+00
EnglandPremier League2014/2015SunderlandShots on Goal4Chris Foy58e329b8-9553-5a34-b83f-06973b8a0cf32015-01-01 00:00:00+00
EnglandPremier League2014/2015Manchester CityShots outsideboxnullChris Foy58e329b8-9553-5a34-b83f-06973b8a0cf32015-01-01 00:00:00+00
EnglandPremier League2014/2015SunderlandShots outsideboxnullChris Foy58e329b8-9553-5a34-b83f-06973b8a0cf32015-01-01 00:00:00+00
EnglandPremier League2014/2015Manchester CityTotal ShotsnullChris Foy58e329b8-9553-5a34-b83f-06973b8a0cf32015-01-01 00:00:00+00
EnglandPremier League2014/2015SunderlandTotal ShotsnullChris Foy58e329b8-9553-5a34-b83f-06973b8a0cf32015-01-01 00:00:00+00
EnglandPremier League2014/2015Manchester CityTotal passesnullChris Foy58e329b8-9553-5a34-b83f-06973b8a0cf32015-01-01 00:00:00+00
EnglandPremier League2014/2015SunderlandTotal passesnullChris Foy58e329b8-9553-5a34-b83f-06973b8a0cf32015-01-01 00:00:00+00
EnglandPremier League2014/2015Manchester CityYellow Cards2Chris Foy58e329b8-9553-5a34-b83f-06973b8a0cf32015-01-01 00:00:00+00
EnglandPremier League2014/2015SunderlandYellow Cards3Chris Foy58e329b8-9553-5a34-b83f-06973b8a0cf32015-01-01 00:00:00+00
EnglandPremier League2014/2015BurnleyBall Possession56Mike Dean5bebd933-df22-56e2-a067-f48f22e3aff02015-01-01 00:00:00+00
EnglandPremier League2014/2015NewcastleBall Possession44Mike Dean5bebd933-df22-56e2-a067-f48f22e3aff02015-01-01 00:00:00+00
EnglandPremier League2014/2015BurnleyBlocked ShotsnullMike Dean5bebd933-df22-56e2-a067-f48f22e3aff02015-01-01 00:00:00+00
EnglandPremier League2014/2015NewcastleBlocked ShotsnullMike Dean5bebd933-df22-56e2-a067-f48f22e3aff02015-01-01 00:00:00+00

Share link

Anyone who has the link will be able to view this.