Refinitiv Data Library for Python

get_db_data

Sends a request to the previously created database to retrieve the previously defined ESG data.

Module

refinitiv.data.content.esg.bulk

Syntax

get_db_data()

Parameters

None.

Returned value

Response

Usage

The following example demonstrates how to create and update the database with the ESG package and retrieve the previously defined ESG data:

import refinitiv.data as rd
from refinitiv.data.content import esg
from refinitiv.data.content.esg import PackageManager

# Open the session
rd.open_session()

# Define ESG data package
pkg = PackageManager('esg.standard_scores')

# update local ESG bulk files.
pkg.update_files()

# update a local in-memory database
pkg.update_db()

# Retrieve data
response = esg.bulk.Definition("esg.standard_scores", universe = "4295865175").get_db_data()

print(response.data.df.to_markdown())
Response
OrganizationName InsertDate Instrument PeriodEndDate TR.TRESGCScore TR.TRESGScore TR.EnvironmentPillarScore TR.SocialPillarScore TR.GovernancePillarScore
0 null 2022-04-24 4295865175 2018-12-31T00:00:00.000Z 0.3468755803443543 0.3468755803443543 0.017336485421591788 0.11923662461939981 0.637965760322256
1 null 2022-04-24 4295865175 2018-12-31T00:00:00.000Z 0.29530709944901445 0.29530709944901445 0.017000607164541572 0.18270285087719315 0.4738870792616723
2 null 2022-04-24 4295865175 2018-12-31T00:00:00.000Z 0.2661717831757612 0.2661717831757612 0.019367991845056047 0.23895899053627767 0.36319261213720333

esg.bulk.PackageManager
esg.bulk.PackageManager.update_files method
esg.bulk.PackageManager.update_db method
esg.bulk.PackageManager.reset_files method
esg.bulk.PackageManager.cleanup_files method
esg.bulk.PackageManager.cleanup_db method