Baselight
SELECT 
  EXTRACT(YEAR FROM STRPTIME("date", '%B %-d, %Y')) "year", 
  COUNT(*) "crashes",
  SUM(CAST(NULLIF(REGEXP_EXTRACT("fatalities", '([0-9]+).*', 1), '') AS INT)) "fatalities"
FROM @kaggle.luiscfrancisco_plane_crashes_dataset.accident_details_compiled
GROUP BY "year"
HAVING "year" < 2024
ORDER BY "year" ASC
yearcrashesfatalities
190811
190911
191215
1913343
1915236
19165108
19177138
1918465
1919923
19201825
19211264
19221389
19231378
1924720
19251134
19261336
19272157
192836113
192939133
193027157
193133102
19322873
193328206
193431140
193542244
193650271
193736251
193857457
193930168
194025253
194127277
194238497
194345727
194456710
1945751373
1946891329
1947821314
1948781265
1949671163
1950711494
1951751258
1952651274
1953701317
195462975
195557913
195653991
1957661115
1958691384
1959661141
1960701684
1961601539
1962792139
1963641403
1964591339
1965641780
1966601648
1967631605
1968691899
1969701928
1970731920
1971581784
1972772796
1973642323
1974582242
1975511460
1976571842
1977632102
1978511444
1979601838
1980451717
1981501168
1982541708
1983481564
198448921
1985562590
1986511405
1987541632
1988832585
1989832210
1990611125
1991691725
1992672017
1993561508
1994741806
1995611490
1996682314
1997561632
1998591508
199962863
2000631430
2001581336
2002551371
2003621279
200446662
2005451294
2006381118
200743888
200863797
2009461083
2010401044
201136720
201226587
201325287
2014231142
201518759
201623515
201715214
201819874
201913305
20208355
20219185
20226189
20234100

Share link

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