New Chat Logo Shared · Read-only

Provide a list of the top 10 companies with the highest CSR expenditure on health-related projects in Hyderabad district during 2023–24

Health Sectors 
SELECT DISTINCT sector FROM gp_hOxoMhzVGgrPR WHERE sector ILIKE '%health%' OR sector ILIKE '%medical%'
Hyderabad Districts 
SELECT DISTINCT district_as_per_lgd FROM gp_hOxoMhzVGgrPR WHERE district_as_per_lgd ILIKE '%hyderabad%'
Top 10 Companies in Hyderabad for Healthcare CSR (2023-24) 
SELECT company_name, sum(amount_spent) as total_spent FROM gp_hOxoMhzVGgrPR WHERE fiscal_year = '2023-24' AND sector = 'Health Care' AND district_as_per_lgd = 'Hyderabad' GROUP BY company_name ORDER BY total_spent DESC LIMIT 10

Here are the top 10 companies with the highest Corporate Social Responsibility (CSR) expenditure on Health Care projects in the Hyderabad district during the 2023–24 fiscal year:

  1. Biological E. Limited: ₹10.14 Crore
  2. Asian Institute Of Gastroenterology Private Limited: ₹6.22 Crore
  3. GAIL (India) Limited: ₹3.94 Crore
  4. Divi's Laboratories Limited: ₹3.87 Crore
  5. Laurus Labs Limited: ₹3.37 Crore
  6. Infosys Limited: ₹3.37 Crore
  7. GVK Jaipur Expressway Limited: ₹3.31 Crore
  8. Optum Global Solutions (India) Private Limited: ₹3.08 Crore
  9. Virchow Petrochemical Private Limited: ₹2.50 Crore
  10. PNB Gilts Limited: ₹1.87 Crore

Note: This data is sourced from the Corporate Social Responsibility master dataset. The expenditures are reported in Indian Rupee Crores. The geographic location relies on standardized mapping using Local Government Directory (LGD) district codes (in this case, Hyderabad), and the sector relies on projects categorized under "Health Care" for the specific 2023-24 fiscal year.

For the complete dataset and further details, please refer to the results tab.

27.9K in / 1.4K out
Shared read-only conversation. Sign in to create your own. Sign in