{"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, "fields": [{"key": "firm", "label": "Firm", "type": "text", "unit": "", "definition": "Firm name after the published spelling merges.", "blank": "Not reported by the publisher.", "source_column": "Computed table: firm"}, {"key": "issue", "label": "Issue", "type": "text", "unit": "", "definition": "Issue name as published.", "blank": "Not reported by the publisher.", "source_column": "Computed table: issue"}, {"key": "issue_url", "label": "Issue URL", "type": "url", "unit": "", "definition": "Local page address for this issue.", "blank": "Not reported by the publisher.", "source_column": "Computed table: issue_url"}, {"key": "issuer", "label": "Issuer", "type": "text", "unit": "", "definition": "Government issuing the debt.", "blank": "Not reported by the publisher.", "source_column": "Computed table: issuer"}, {"key": "issuer_url", "label": "Issuer URL", "type": "url", "unit": "", "definition": "Local page address for this issuer.", "blank": "Not reported by the publisher.", "source_column": "Computed table: issuer_url"}, {"key": "closed", "label": "Closed", "type": "date", "unit": "Central Time date", "definition": "Issue closing date.", "blank": "Not reported by the publisher.", "source_column": "Computed table: closed"}, {"key": "fy", "label": "FY", "type": "fy", "unit": "", "definition": "Fiscal year in which the issue closed.", "blank": "Not reported by the publisher.", "source_column": "Computed table: fy"}, {"key": "roles", "label": "Role", "type": "text", "unit": "", "definition": "Reader roles this firm performed on this issue.", "blank": "Not reported by the publisher.", "source_column": "Computed table: roles"}, {"key": "sale", "label": "Sale type", "type": "text", "unit": "", "definition": "Method used to sell the issue.", "blank": "Not reported by the publisher.", "source_column": "Computed table: sale"}, {"key": "par", "label": "Par", "type": "money", "unit": "dollars", "definition": "Original principal amount of the issue.", "blank": "Not reported by the publisher.", "source_column": "Computed table: par"}, {"key": "fees", "label": "Fees to this firm", "type": "money", "unit": "dollars", "definition": "Reported fees paid to this firm on this issue, excluding spread cross-check rows.", "blank": "Not reported by the publisher.", "source_column": "Computed table: fees"}, {"key": "cost", "label": "Per $1,000 of par", "type": "per1000", "unit": "per $1,000", "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": "Computed table: cost"}], "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"}}