London Bus Safety

Quarterly report of London Transport that provide analysis of incidents

@kaggle.darrylljk_london_bus_safety_performance

Table List

1 table(127.84 KB)

Tfl Bus Safety

@kaggle.darrylljk_london_bus_safety_performance.tfl_bus_safety

127.84 KB
23158 rows
12 columns

year Year	date_of_incident Date Of Incident	route Route	operator Operator	group_name Group Name	bus_garage Bus Garage	borough Borough	injury_result_description Injury Result Description	incident_event_type Incident Event Type	victim_category Victim Category	victims_sex Victims Sex	victims_age Victims Age
2015	Thu Jan 01 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	1	London General	Go-Ahead	Garage Not Available	Southwark	Injuries treated on scene	Onboard Injuries	Passenger	Male	Child
2015	Thu Jan 01 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	4	Metroline	Metroline	Garage Not Available	Islington	Injuries treated on scene	Onboard Injuries	Passenger	Male	Unknown
2015	Thu Jan 01 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	5	East London	Stagecoach	Garage Not Available	Havering	Taken to Hospital – Reported Serious Injury or Severity Unknown	Onboard Injuries	Passenger	Male	Elderly
2015	Thu Jan 01 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	5	East London	Stagecoach	Garage Not Available	None London Borough	Taken to Hospital – Reported Serious Injury or Severity Unknown	Onboard Injuries	Passenger	Male	Elderly
2015	Thu Jan 01 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	6	Metroline	Metroline	Garage Not Available	Westminster	Reported Minor Injury - Treated at Hospital	Onboard Injuries	Pedestrian	Female	Elderly
2015	Thu Jan 01 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	6	Metroline	Metroline	Garage Not Available	Westminster	Taken to Hospital – Reported Serious Injury or Severity Unknown	Onboard Injuries	Passenger	Female	Elderly
2015	Thu Jan 01 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	8	Selkent	Stagecoach	Garage Not Available	City of London	Injuries treated on scene	Onboard Injuries	Passenger	Male	Adult
2015	Thu Jan 01 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	9	London United	London United	Garage Not Available	Hammersmith & Fulham	Injuries treated on scene	Onboard Injuries	Conductor	Unknown	Unknown
2015	Thu Jan 01 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	10	London United	London United	Garage Not Available	Westminster	Injuries treated on scene	Onboard Injuries	Passenger	Female	Elderly
2015	Thu Jan 01 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	11	London General	Go-Ahead	Garage Not Available	City of London	Taken to Hospital – Reported Serious Injury or Severity Unknown	Onboard Injuries	Passenger	Female	Adult


CREATE TABLE tfl_bus_safety (
  "year" BIGINT,
  "date_of_incident" TIMESTAMP,
  "route" VARCHAR,
  "operator" VARCHAR,
  "group_name" VARCHAR,
  "bus_garage" VARCHAR,
  "borough" VARCHAR,
  "injury_result_description" VARCHAR,
  "incident_event_type" VARCHAR,
  "victim_category" VARCHAR,
  "victims_sex" VARCHAR,
  "victims_age" VARCHAR
);