Shared · Read-onlyIdentify companies whose lost-time injury frequency rate or number of fatalities exceeded 1 for employees in 2024-25, then summarise the occupational health-and-safety management system each describes in its BRSR report.
SELECT DISTINCT company_name, cin_number
FROM gp_LWctib66AtdSK
WHERE employment_category = 'Employees'
AND category IN ('Lost Time Injury Frequency Rate', 'Number Of Fatalities')
AND value > 1
AND start_date >= '2024-04-01' AND end_date <= '2025-03-31'SELECT DISTINCT category FROM gp_LWctib66AtdSK WHERE LOWER(category) LIKE '%lost%' OR LOWER(category) LIKE '%fatality%' OR LOWER(category) LIKE '%fatalities%';
SELECT DISTINCT EXTRACT(YEAR FROM start_date) as sy, EXTRACT(YEAR FROM end_date) as ey FROM gp_LWctib66AtdSK ORDER BY sy;
SELECT DISTINCT company_name, cin_number
FROM gp_LWctib66AtdSK
WHERE
LOWER(employment_category) = 'employees'
AND EXTRACT(YEAR FROM start_date) = 2024
AND EXTRACT(YEAR FROM end_date) = 2025
AND value > 1
AND (
category = 'Lost Time Injury Frequency Rate'
OR category = 'Number Of Fatalities'
)
ORDER BY company_name;Based on the 2024-25 data, there are 82 companies where the Lost Time Injury Frequency Rate (LTIFR) or the Number of Fatalities for employees exceeded 1. A complete list of these companies can be found in the results tab.
Here is a summary of the occupational health and safety (OHS) management systems described in the Business Responsibility and Sustainability (BRSR) reports for a sample of these companies:
- Abbott India Limited: Abbott India has an OHS system covering its Goa plant, field forces, and offices 1. It identifies hazards through risk gap assessments, incident investigations, and ergonomic assessments 1. At the Goa plant, safety governance includes daily leadership and safety committee meetings, and they introduced a QR-code-based reporting process in 2024 1.
- Adani Energy Solutions Limited: Adani operates as an ISO 45001:2018 certified company, striving for a safe working environment for employees, contract workers, and visitors 1. They conduct in-depth inquiries into incidents and mandate pre-qualification and periodic safety audits for contractors, using tools like "Safe Eye" and "Safe Alert" to disseminate safety practices 1, 5, 8.
- Coal India Limited: The company places high priority on safety by formulating an Occupational Health and Safety Policy and instituting Internal Safety Organizations (ISO) across all subsidiaries 3, 4. A Hazard Identification and Risk Assessment (HIRA) based Safety Management Plan has been prepared, with senior executives heading these bodies and reviewing safety protocols 4, 5.
- Tata Chemicals Limited: Tata Chemicals maintains a working setup conforming to ISO 45001, Responsible Care, the Tata Group Safety & Health Management System, and British Safety Council guidelines 5. Their risk management spans manufacturing locations, offices, research laboratories, warehouses, and supply chain partners through thorough hazard identification approaches 1, 5.
- UltraTech Cement Limited: Their OHS management system adheres to ISO 45001 standards across practically all certified units 15. An OH&S board chaired by their Managing Director reviews the system's effectiveness every two months 14. They deploy a comprehensive HIRA standard, utilizing cross-functional teams and the hierarchy of controls to minimize risks to the As Low As Reasonably Practicable (ALARP) level 16.
Note: The data analysis is limited to the employment category "Employees" (excluding manual "Workers") for the reporting period 2024-25. Tracking metrics are sourced from the P3 8 Health Safety dataset, capturing absolute frequencies and incident rates for high-consequence work-related injuries and fatalities.***
Sources cited: