{"key": "firm-deals", "version": "1", "title": "Issues worked on by firm", "summary": "Issues worked on by firm, using the same records and counting rules as the Data Center table.", "grain": "firm and issue", "source": "BRB published debt tables and Data Center counting rules", "scopes": ["all", "fy"], "scope_parameter": "fy", "issuer_field": null, "as_of": "2026-10-06", "rows": 123365, "prepared": true, "available": true, "fields": [{"key": "firm", "label": "Firm", "type": "text", "definition": "Firm name after the published spelling merges.", "blank": "Not reported by the publisher.", "source_column": "Table column: Firm", "unit": "", "type_label": "Text"}, {"key": "issue", "label": "Issue", "type": "text", "definition": "Issue name as published.", "blank": "Not reported by the publisher.", "source_column": "Table column: Issue", "unit": "", "type_label": "Text"}, {"key": "issue_url", "label": "Issue URL", "type": "url", "definition": "Local page address for this issue.", "blank": "Not reported by the publisher.", "source_column": "Table column: Issue URL", "unit": "URL", "type_label": "Web address"}, {"key": "issuer", "label": "Issuer", "type": "text", "definition": "Government issuing the debt.", "blank": "Not reported by the publisher.", "source_column": "Table column: Issuer", "unit": "", "type_label": "Text"}, {"key": "issuer_url", "label": "Issuer URL", "type": "url", "definition": "Local page address for this issuer.", "blank": "Not reported by the publisher.", "source_column": "Table column: Issuer URL", "unit": "URL", "type_label": "Web address"}, {"key": "closed", "label": "Closed", "type": "date", "definition": "Issue closing date.", "blank": "Not reported by the publisher.", "source_column": "Table column: Closed", "unit": "ISO date (YYYY-MM-DD)", "type_label": "Date"}, {"key": "fy", "label": "FY", "type": "fy", "definition": "Fiscal year in which the issue closed.", "blank": "Not reported by the publisher.", "source_column": "Table column: FY", "unit": "fiscal year", "type_label": "Fiscal year"}, {"key": "roles", "label": "Role", "type": "text", "definition": "Services this firm performed on this issue.", "blank": "Not reported by the publisher.", "source_column": "Table column: Role", "unit": "", "type_label": "Text"}, {"key": "sale", "label": "Sale type", "type": "text", "definition": "Method used to sell the issue.", "blank": "Not reported by the publisher.", "source_column": "Table column: Sale type", "unit": "", "type_label": "Text"}, {"key": "par", "label": "Par", "type": "money", "definition": "Original principal amount of the issue.", "blank": "Not reported by the publisher.", "source_column": "Table column: Par", "unit": "dollars", "type_label": "Money"}, {"key": "fees", "label": "Fees to this firm", "type": "money", "definition": "Reported fees paid to this firm on this issue, excluding spread cross-check rows.", "blank": "Not reported by the publisher.", "source_column": "Table column: Fees to this firm", "unit": "dollars", "type_label": "Money"}, {"key": "cost", "label": "Per $1,000 of par", "type": "per1000", "definition": "This firm's part of the issuer's one-time costs on the issue per $1,000 of par; underwriter-paid rows are excluded.", "blank": "Not reported by the publisher.", "source_column": "Table column: Per $1,000 of par", "unit": "per $1,000", "type_label": "Cost per $1,000"}], "links": {"metadata": "/api/v1/datasets/firm-deals/", "rows": "/api/v1/datasets/firm-deals/rows/", "dictionary": "/data/dictionary/#firm-deals", "csv": "/data/downloads/firm-deals.csv", "xlsx": "/data/downloads/firm-deals.xlsx"}}