Baselight
Loading...Loading chart...
1select events.minute, count(distinct m.match_id) as nr_matches
2from @blt.ultimate_soccer_dataset.seasons s
3inner join @blt.ultimate_soccer_dataset.competitions c on (s.competition_id = c.competition_id)
4inner join @blt.ultimate_soccer_dataset.matches m on (m.season_id = s.season_id)
5inner join @blt.ultimate_soccer_dataset.match_events events on (events.match_id = m.match_id)
6where slug = 'premier-league' and s.season_label='2025/2026' and m.status = 'Match Finished' 
7      and events.event_type = 'goal'
8      and events.description not in ('Missed Penalty')
9group by all
10order by 1
minutenr_matches
22
32
43
54
61
72
84
94
102
111
122
131
144
152
161
171
185
192
203
213
221
233
242
253
262
271
292
302
313
321
332
349
355
379
385
392
402
411
422
432
4510
462
472
483
494
502
512
522
531
543
553
563
575
587
603
616
621
633
644
652
662
673
684
691
702
732
741
752
763
773
785
792
801
812
822
831
848
851
861
871
884
894
9031

Share link

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