Baselight
Sign In
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
14
24
32
46
57
65
76
85
98
104
115
123
135
146
157
162
174
185
195
205
215
222
235
244
257
264
276
286
298
306
317
326
336
3410
358
368
3714
3810
394
404
417
426
436
444
4533
468
474
489
497
5010
517
526
532
549
556
566
579
5810
593
609
618
623
639
647
658
667
677
687
6910
707
715
726
738
742
755
769
776
7814
798
806
817
825
836
8414
854
865
874
889
896
9067

Share link

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