{"key": "reported-issues", "version": "1", "title": "Final Reports and Debt Service", "summary": "Final reports and scheduled debt service, with published values and stable field names.", "grain": "published issue and payment date", "source": "Final reports accepted by BRB", "scopes": ["all", "fy"], "scope_parameter": "fy", "issuer_field": "issuer_id", "as_of": null, "rows": 0, "fields": [{"key": "reference", "label": "Final report", "type": "text", "unit": "", "definition": "Stable reference identifying the published final report.", "blank": "Not reported by the source.", "source_column": "Published final report reference"}, {"key": "issuer_id", "label": "Issuer ID", "type": "text", "unit": "", "definition": "Stable issuer identifier assigned by the source.", "blank": "Not reported by the source.", "source_column": "GovernmentId"}, {"key": "issuer", "label": "Issuer", "type": "text", "unit": "", "definition": "Name of the government or agency responsible for this issue.", "blank": "Not reported by the source.", "source_column": "GovernmentName"}, {"key": "series", "label": "Series", "type": "text", "unit": "", "definition": "Debt series named in the final report or payment schedule.", "blank": "Not reported by the source.", "source_column": "Published report: series"}, {"key": "par", "label": "Par", "type": "money", "unit": "dollars", "definition": "Face amount of the issue at issuance.", "blank": "Not reported by the source.", "source_column": "ActualPar"}, {"key": "new_money_par", "label": "New money par", "type": "money", "unit": "dollars", "definition": "Par issued to finance new expenditures rather than refund existing debt.", "blank": "Not reported by the source.", "source_column": "NewMoneyPar"}, {"key": "refunding_par", "label": "Refunding par", "type": "money", "unit": "dollars", "definition": "Par issued to refinance outstanding debt.", "blank": "Not reported; the source does not establish a refunding amount.", "source_column": "RefundingPar"}, {"key": "closed", "label": "Closed", "type": "date", "unit": "Central Time date", "definition": "Date the issue closed and its proceeds became available.", "blank": "Not reported by the source.", "source_column": "ClosingDate"}, {"key": "accepted_on", "label": "Accepted on", "type": "date", "unit": "Central Time date", "definition": "Date the agency accepted the final report.", "blank": "Not reported by the source.", "source_column": "Published report: accepted_on"}, {"key": "fy", "label": "Fiscal year", "type": "fy", "unit": "ending year", "definition": "Fiscal year named for its ending year; September 1 through August 31 in Texas.", "blank": "Not reported by the source.", "source_column": "FiscalYear"}, {"key": "payment_date", "label": "Payment date", "type": "date", "unit": "Central Time date", "definition": "Scheduled date of this principal and interest payment.", "blank": "Not reported: the final report has no published debt-service schedule.", "source_column": "Published schedule: payment_date"}, {"key": "payment_series", "label": "Payment series", "type": "text", "unit": "", "definition": "Series identifying this scheduled payment within the final report.", "blank": "Not reported: the payment schedule does not identify a separate series.", "source_column": "Published schedule: series"}, {"key": "principal", "label": "Principal outstanding", "type": "money", "unit": "dollars", "definition": "Principal still owed at the fiscal year end shown.", "blank": "Not reported by the source.", "source_column": "TotalPrincipalOutstanding"}, {"key": "interest", "label": "Interest outstanding", "type": "money", "unit": "dollars", "definition": "Remaining scheduled interest reported at the fiscal year end shown.", "blank": "Not reported by the source.", "source_column": "TotalInterestOutstanding"}, {"key": "total", "label": "Total debt service outstanding", "type": "money", "unit": "dollars", "definition": "Remaining principal and interest reported at the fiscal year end shown.", "blank": "Not reported by the source.", "source_column": "TotalDebtServiceOutstanding"}, {"key": "payments", "label": "Payments", "type": "int", "unit": "count", "definition": "Number of scheduled payment rows in the published final report.", "blank": "Not reported by the source.", "source_column": "Published schedule: row count"}, {"key": "final_payment", "label": "Final payment", "type": "date", "unit": "Central Time date", "definition": "Latest scheduled payment date in the published final report.", "blank": "Not reported: the final report has no published debt-service schedule.", "source_column": "Published schedule: final payment"}, {"key": "sale", "label": "Sale", "type": "text", "unit": "", "definition": "Method used to sell the issue, such as competitive or negotiated.", "blank": "Not reported by the source.", "source_column": "SaleType"}, {"key": "pledge", "label": "Pledge", "type": "text", "unit": "", "definition": "Revenue or taxing authority pledged to repay the debt.", "blank": "Not reported by the source.", "source_column": "PledgeType"}], "links": {"metadata": "/api/v1/datasets/reported-issues/", "rows": "/api/v1/datasets/reported-issues/rows/", "dictionary": "/data/dictionary/#reported-issues", "csv": "/data/downloads/reported-issues.csv", "xlsx": "/data/downloads/reported-issues.xlsx"}}