Baselight
select me.minute, me.stoppage_time, teams.name, me.event_type, me.description, me.notes
from @blt.ultimate_soccer_dataset.match_events me
inner join @blt.ultimate_soccer_dataset.teams teams ON (me.team_id = teams.team_id)
where me.match_id = 'f1598530-2d28-5684-9c22-3fa6d65a1e34'
order by 1, 2
limit 100
minutestoppage_timenameevent_typedescriptionnotes
22nullSpaingoalNormal GoalNone
25nullSpaingoalNormal GoalNone
33nullSpaincardYellow CardTripping
44nullSpainvarGoal Disallowed - offsideNone
51nullFrancecardYellow CardTripping
54nullSpaingoalPenaltyNone
55nullSpaingoalNormal GoalNone
59nullFrancegoalPenaltyNone
63nullFrancesubstSubstitution 1None
63nullFrancesubstSubstitution 2None
63nullFrancesubstSubstitution 3None
64nullSpainsubstSubstitution 1None
64nullSpainsubstSubstitution 2None
67nullSpaingoalNormal GoalNone
72nullFrancesubstSubstitution 4None
76nullFrancesubstSubstitution 5None
77nullSpainsubstSubstitution 3None
77nullSpainsubstSubstitution 4None
79nullFrancegoalNormal GoalNone
82nullFrancecardYellow CardHolding
84nullFrancegoalOwn GoalNone
901SpainsubstSubstitution 5None
903FrancegoalNormal GoalNone
904FrancecardYellow CardRoughing
906SpaincardYellow CardUnsportsmanlike conduct
907FrancecardYellow CardNone

Share link

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