Duplicated and missing observations in ESG data

xiang.zheng

Hi, I have a question regarding the ESG data. When I tried to access the data via API, it turns out that there are duplicated observations for the same period of a firm. You can find two examples as follows.

fields_esg = ["TR.TRESGScore.date","TR.TRESGScore"]

## Example 1:

data,err =ek.get_data('US9663875089', fields_esg,{'Period': 'FY0','SDate': '-10Y', 'EDate': '0'})

******* In Example 1, you can find that the firm US9663875089 has duplicated observations for year 2016 (see attachment 1). Instead, the 2015 and 2017 ESG data for the same firm is missing with this API request.

However, it becomes available in the EIKON desktop. Due to the restriction of the attachment numbers, you can search this company in EIKON desktop by yourself and you should be able to replicate my findings.

## Example 2:

data,err =ek.get_data('US74270Y1038,US7427181091,CA74272N1050,CA74273V1067,US74273Y1001,US74275C2052,US74275G1076,US74280R2058,CA74283A1003,US7429621037', fields_esg,{'Period': 'FY0','SDate': '-10Y', 'EDate': '0'})

******* In Example 2, you can find that the firm US7427181091 has duplicated observations for year 2013 and 2017. Instead, the 2012 and 2016 ESG data for the same firm is missing (see attachment 2).

In the meanwhile, if I only request the ESG data for the firm US7427181091, it turns out that the firm has ESG data available in both 2012 and 2016. Due to the restriction of attachment numbers, I just post the code as follows and you should be able to replicate my findings.

data,err =ek.get_data('US7427181091', fields_esg,{'Period': 'FY0','SDate': '-10Y', 'EDate': '0'})

It would be great if anyone can kindly help me on this issue. Thanks!

chavalit-jintamalit

Hi @xiang.zheng

I reformat your API call a bit.

For 1:

For 2: