Infrastructure 360 (GINFR) through Python API

I'm looking for a way to access the data available in LSEG Workspace under "Infrastructure 360" (GINFR) through the Python API. They don't appear in the DEALS_MERGERS_AND_ACQUISITIONS and LOAN_INSTRUMENTS views, which is reasonable. However, I haven't been able to find any record of them by just searching for the (supposed) PermID/DealID either. How can I get a pull of all projects in the dataset straight into Python to then perform further analyses on?

Best Answer

  • Dhruv Singal
    Dhruv Singal Newcomer
    Answer ✓

    I came up with the following, which matches the number of obervations the Screener returns. It's (significantly) less than in GINFR, though there seemingly are duplicated in the latter. pjf_fields is a list of the fields related to project finance (TR.PJF) I found in the CodeCreator.


    pjf_data = []

    for year in trange(1990,2024):
    df,err = ek.get_data("SCREEN(U(IN(DEALS)/*UNV:DEALSPROJECTFINANCE*/), IN(TR.PJFProjectUniverseType,""SDCPJF""), BETWEEN(TR.PJFFinancedDate," + str(year) + "0101," + str(year) + "1231)/*dt:Date*/)",
    pjf_fields)
    pjf_data.append(df)

    pjf_data = pd.concat(pjf_data,ignore_index=True)

Answers

  • @eikon29 So I don't believe this content set is available via API search views. The only way I think you can get this data in Workspace is by pulling it via the excel button. I have asked the content team to confirm and I will report back here. Please bear with me.

Welcome!

It looks like you're new here. Sign in or register to get started.

Welcome!

It looks like you're new here. Sign in or register to get started.