☰
Navigation :

Counterparties

Download sample file: Counterparties.csv

File pattern match

The pattern match for the Counterparties file is **Counterparties*.csv

For information on the glob patterns used and how to customize them, see note on File name patterns.

Field Key Null FieldType Description Example
AsOfDate Y N String with format ‘YYYY-MM-DD’ Indicates the date of the file. See Note on AsOfDate.
CounterpartyId Y N String Counterparty identifier. Used as a foreign key when counterparty is referenced. “HSBC Group”, “EBRD”
CounterpartyName N Y String Full counterparty name. “HSBC Holdings PLC”, “European Bank for Reconstruction and Development”
Rating N Y String Rating of the counterparty. “AAA”, “BB”
Sector N Y String Sector of the counterparty.
CountryOfAddress N Y String Country where the counterparty is located, in the form of a unique three-letter country identifier code.
CountryOfRisk N Y String Country the risk of counterparty can be attributed to, in the form of a unique three-letter country identifier code.
search.js