All business segment country/region codes

Harlan.tufford

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?

jason.ramchandani01

@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

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

Kindest regards,