All business segment country/region codes

Is there a comprehensive list of all the potential country/region codes (across the global universe) in TR.BGS.GeoTotalRevenue.SegmentCode or an easy way to pull that together with the corresponding name?

Best Answer

  • @Harlan.tufford Thanks for your question - so please see the following example which actually contains the country names - this uses the Refinitiv Company Fundamentals content set:

    df1 = rd.get_data(['VOD.L'], 
                            fields=['TR.F.GEOTotRevBizActiv(Period=FY0).SegmGeoIncl',
                              'TR.F.GEOTotRevBizActiv(Period=FY0).segmentName','TR.F.GEOTotRevBizActiv(Period=FY0)'])

    df1.sort_values('Standardized Revenue - Geographic Segment', ascending=False, inplace=True)
    df1.reset_index(inplace=True)
    df1

    1701180500496.png

    Note: the first row is the Total for all segments. I hope this can help.

    Kindest regards,