Football Players Deaths

footballers who died while playing the game

@kaggle.shivamb_football_deaths

Table List

1 table(38.59 KB)

Football Deaths

@kaggle.shivamb_football_deaths.football_deaths

38.59 KB
229 rows
13 columns

row_id Row Id	incident_date Incident Date	player_name Player Name	player_country Player Country	team_country Team Country	player_age Player Age	player_team_name Player Team Name	incident_description Incident Description	heart_related Heart Related
1	Sun Jan 13 1889 00:00:00 GMT+0000 (Coordinated Universal Time)	William Cropper	England	England	26	Staveley	Ruptured bowel in a match against Grimsby Town led to death the next day.
2	Mon Jan 11 1892 00:00:00 GMT+0000 (Coordinated Universal Time)	James Dunlop	Scotland	Scotland	21	St Mirren	Tetanus from fall on piece of glass in a friendly game against Abercorn led to death ten days later.
3	Sun Nov 12 1893 00:00:00 GMT+0000 (Coordinated Universal Time)	John Henry Morris	England	England	26	Shrewsbury Town	Internal haemorrhage following a bad tackle in a bad tempered match. A verdict of accidental death was returned.
4	Thu Nov 23 1893 00:00:00 GMT+0000 (Coordinated Universal Time)	Walter Bannister	England	England	24	Chesterfield Town	Rupture of the kidney from a tackle in game against Derby Junction; he died almost three weeks later.
5	Sat Mar 28 1896 00:00:00 GMT+0000 (Coordinated Universal Time)	Teddy Smith	England	England	27	Bedminster	Suffered severe concussion following a clash of heads in the Gloucestershire Cup semi-final against Eastville Rovers. He continued playing initially, but was eventually forced to leave the game and died from his injury the next morning.
6	Mon May 25 1896 00:00:00 GMT+0000 (Coordinated Universal Time)	James Logan	Scotland	England	25	Loughborough F.C.	Pneumonia while playing.
7	Sun Nov 29 1896 00:00:00 GMT+0000 (Coordinated Universal Time)	Joe Powell	England	England	25	Woolwich Arsenal	Blood poisoning and tetanus after breaking his arm in game against Kettering Town in .
8	Mon Jan 01 1900 00:00:00 GMT+0000 (Coordinated Universal Time)	James Collins	England	England		Sheppey United	Tetanus caused by on-field injury.
9	Wed Aug 27 1902 00:00:00 GMT+0000 (Coordinated Universal Time)	Di Jones	Wales	England	35	Manchester City	Gashed knee turned septic leading to death.
10	Sat Oct 27 1906 00:00:00 GMT+0000 (Coordinated Universal Time)	David "Soldier" Wilson	England	England	23	Leeds City	Heart attack while playing against Burnley, probably from heavy smoking. He attempted to return to the field of play even when in great pain.	1


CREATE TABLE football_deaths (
  "row_id" BIGINT,
  "incident_date" TIMESTAMP,
  "player_name" VARCHAR,
  "player_country" VARCHAR,
  "team_country" VARCHAR,
  "player_age" DOUBLE,
  "player_team_name" VARCHAR,
  "incident_description" VARCHAR,
  "heart_related" BIGINT,
  "cardiac_related" BIGINT,
  "collapsed" BIGINT,
  "lightning" BIGINT,
  "collision" BIGINT
);