Dataset Overview

The dataset contains year- and company-wise the average yearly net profit earned by each company, the Corporate Social Responsibility (CSR) amount prescribed, the total amount spent on csr projects in both local and other areas. Notes: 1. Year-wise count of companies in dataset may not match with that of the original source as the duplicate entries for each year were removed in the dataset. Th...

Premium

Organisation

Ministry of Corporate Affairs

Sectors

Corporate,

Social Development,

Finance

Update Frequency

Yearly

Granularity

Yearly, Company

Time Saved

4 hours

Number of rows

102711

Number of Columns

Sources

National CSR Portal

Time Period

2016-17 to 2021-22

Units

average_net_profit

prescribed_csr_expenditure

csr_spent and local_area_spent in Indian Rupees

Data Preview

fiscal_year	company_name	cin	average_net_profit	prescribed_csr_expenditure	csr_spent	local_area_spent	unit
2021-22	ORIENTAL STRUCTURAL ENGINEERS PRIVATE LIMITED	U74210DL1971PTC005680	1864406300	-7400000.01	44688126	44688126	average_net_profit, prescribed_csr_expenditure, csr_spent and local_area_spent in indian rupees
2021-22	PERONI PUMPS INDIA PRIVATE LIMITED	U52602GJ2010PTC063393	42507949.67	850158.99	850158.99	700000	average_net_profit, prescribed_csr_expenditure, csr_spent and local_area_spent in indian rupees
2021-22	MAHINDRA TEQO PRIVATE LIMITED	U40100MH2016PTC271679	37637460.67	752749.21	753260	253000	average_net_profit, prescribed_csr_expenditure, csr_spent and local_area_spent in indian rupees
2021-22	ROBO SILICON PRIVATE LIMITED	U26100TG1999PTC033188	2167000	43000	855000	855000	average_net_profit, prescribed_csr_expenditure, csr_spent and local_area_spent in indian rupees
2021-22	KHYATI NILUM ASSOCIATES PRIVATE LTD.	U74900DL1986PTC025171	42206377.67	844127.55	844128	844128	average_net_profit, prescribed_csr_expenditure, csr_spent and local_area_spent in indian rupees
2021-22	SWATI MENTHOL AND ALLIED CHEMICALS LIMITED	U15326UP1990PLC011773	211047899.3	4220957.99	844413	0	average_net_profit, prescribed_csr_expenditure, csr_spent and local_area_spent in indian rupees
2021-22	SPONGE ENTERPRISES PRIVATE LIMITED	U51101CT1997PTC011778	42169387.33	843387.75	845000	0	average_net_profit, prescribed_csr_expenditure, csr_spent and local_area_spent in indian rupees
2021-22	FREEDOM FROM DIABETES PRIVATE LIMITED	U85310PN2017PTC168827	42215968.33	844319.37	845000	400000	average_net_profit, prescribed_csr_expenditure, csr_spent and local_area_spent in indian rupees
2021-22	BALLY JUTE COMPANY LTD	L51909WB1982PLC035245	41531971.33	830639.43	846000	846000	average_net_profit, prescribed_csr_expenditure, csr_spent and local_area_spent in indian rupees
2021-22	FLAMAGAS INDIA PRIVATE LIMITED	U93090TN1995PTC033144	41521377.33	830427.55	846584	826584	average_net_profit, prescribed_csr_expenditure, csr_spent and local_area_spent in indian rupees

Metadata

Name	Number of Distinct Values	Number of Unique Values	Type	Count
fiscal_year	6	0	Text	102711
company_name	33858	9294	Text	102686
cin	35431	10348	Text	102711
average_net_profit	66363	63601	Number	102711
prescribed_csr_expenditure	66701	63497	Number	102711
csr_spent	36311	31683	Number	102711
local_area_spent	22266	19232	Number	102711
unit	1	0	Text	102711
note	0	0	Unsupported	0

Citation

Ministry of Corporate Affairs. Corporate Social Responsibility (CSR) Master Data: Year- and Company-wise Average Net Profit, CSR Amount Prescribed and Spent (In Local area and Overall) (as of 22 April, 2024) [Data set]. Dataful. https://dataful.in/datasets/1613

Corporate Social Responsibility (CSR) Master Data: Year- and Company-wise Average Net Profit, CSR Amount Prescribed and Spent (In Local area and Overall) (as of 22 April, 2024)