Identifiers and reference

One file of the LatAm Bonds by SQX data dictionary. Field list (.csv)

Identifiers and reference

Field	Type	Nullable	Description
`isin`	text	never blank (key)	International Securities Identification Number of the bond; with pricing_date, the key of the file.
`pricing_date`	date	never blank (key)	The date the evaluated price is for (YYYY-MM-DD); with isin, the key of the file.
`cusip`	text	blank when not on file	CUSIP or CINS of the bond (nine characters).
`secid`	integer	never blank	Exchange Data International security id of the bond line the row prices.
`issuer_name`	text	never blank	Legal name of the issuer.
`issuer_country`	code	never blank	Country of the issuer's business, read past a foreign financing subsidiary or guarantor. Unit: ISO 3166-1 alpha-2.
`issuer_type`	text	never blank	Sovereign, State-owned, Sub-sovereign, Supranational, Bank and financial, or Corporate.
`issuer_sector`	text	blank when not on file	The issuer's sector in the SQX industry taxonomy.
`issuer_industry`	text	blank when not on file	The issuer's industry in the SQX industry taxonomy.
`security_description`	text	never blank	Short description of the bond: coupon, form, maturity, currency and minimum denomination.
`currency`	code	never blank	Currency the bond is denominated in. Unit: ISO 4217.
`coupon_type`	code	never blank	FIXED, FLOATING, FIXED_TO_FLOATING, STEP, VARIABLE, or NONE (zero coupon).
`coupon_rate`	decimal	blank unless the bond pays a coupon	Current annual coupon rate. Unit: percent per year.
`coupon_frequency`	code	blank unless the bond pays a coupon	MONTHLY, QUARTERLY, SEMI_ANNUAL, ANNUAL, or AT_MATURITY.
`day_count`	text	blank unless the bond pays a coupon, or when not on file	Day count convention interest accrues on.
`issue_date`	date	never blank	Date the bond was issued.
`dated_date`	date	blank unless the bond pays a coupon	Date interest starts to accrue (interest commencement date).
`first_coupon_date`	date	blank unless the bond pays a coupon, or when not on file	Date of the first coupon payment.
`maturity_date`	date	never blank	Date the principal is due.
`seniority`	text	blank when not on file	Rank of the bond in the issuer's capital structure (Senior, Senior Non Preferred, Junior).
`subordinated`	flag	blank when not on file	Y when the bond is subordinated to the issuer's senior debt, else N. Where Exchange Data International states no flag, it follows seniority: Junior and Mezzanine are subordinated.
`issue_size`	decimal	never blank	Amount issued, in units of the bond's currency (millions as Exchange Data International states it, times one million). Unit: currency units.
`amount_outstanding`	decimal	never blank	Amount outstanding on amount_outstanding_date, in units of the bond's currency. Unit: currency units.
`amount_outstanding_date`	date	never blank	Date the amount outstanding was last stated.