From a 500-row sample across 25 columns.
base_accrued_interestperiod_end_datelocal_market_value+22base_accrued_interestperiod_end_datelocal_market_value+22| local_currency_code | trade_country_name | security_name | security_description | maturity_date | interest_rate | original_face | shares_par_value | base_market_value | base_total_cost | base_unrealized_gain_loss | base_accrued_interest |
|---|---|---|---|---|---|---|---|---|---|---|---|
| USD | UNITED STATES OF AMERICA (THE) | ACCO BRANDS CORP | 4.25% 15 Mar 2029 | 2029-03-15T00:00:00.000 | 4.25 | 0 | 2335000.00 | 1913766.00 | 2348425 | -434659 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
local_currency_code | text | This column sets forth the currency code of the country in which the security or financial instrument originates | 0% | USD0JPY |
trade_country_name | text | This column lists the country from which the security or financial instrument originates | 0% | UNITED STATES OF AMERICA…0JAPAN |
security_name | text | This column sets forth the name of the security or financial instrument. In the case of stock and corporate bonds, this will be the company name or bond name. In the case of currency holdings, this will be the name of the currency. In the case of investment funds, it will be the name of the company operating the investment fund. | 0% | 0US TREASURY N/BSTATE STREET BANK + TRUS… |
security_description | text |
GET /api/datasets/p3e6-t4zv GET /api/datasets/p3e6-t4zv/quality GET /api/datasets/p3e6-t4zv/related GET /api/columns?dataset=p3e6-t4zv
base_accrued_interestperiod_end_datelocal_market_valuebase_accrued_interestperiod_end_datelocal_market_value+22| 29219.93 |
| USD | UNITED STATES OF AMERICA (THE) | AEP TEXAS INC | 4.7% 15 May 2032 | 2032-05-15T00:00:00.000 | 4.7 | 0 | 3175000.00 | 3159633.00 | 3165983 | -6350 | 17824.1 |
| USD | UNITED STATES OF AMERICA (THE) | ADT SEC CORP | 4.125% 01 Aug 2029 | 2029-08-01T00:00:00.000 | 4.125 | 0 | 1500000.00 | 1217340.00 | 1500000 | -282660 | 25781.25 |
| USD | UNITED STATES OF AMERICA (THE) | ADT SEC CORP | 4.125% 01 Aug 2029 | 2029-08-01T00:00:00.000 | 4.125 | 0 | 200000.00 | 162312.00 | 200000 | -37688 | 3437.5 |
| USD | UNITED STATES OF AMERICA (THE) | ADT SEC CORP | 4.125% 01 Aug 2029 | 2029-08-01T00:00:00.000 | 4.125 | 0 | 250000.00 | 202890.00 | 250000 | -47110 | 4296.87 |
| USD | UNITED STATES OF AMERICA (THE) | AEP TRANSMISSION CO LLC | 3.1% 01 Dec 2026 | 2026-12-01T00:00:00.000 | 3.1 | 0 | 370000.00 | 357272.00 | 403200.1 | -45928.1 | 955.83 |
| USD | UNITED STATES OF AMERICA (THE) | AG ISSUER LLC | 6.25% 01 Mar 2028 | 2028-03-01T00:00:00.000 | 6.25 | 0 | 515000.00 | 449435.35 | 505364.35 | -55929 | 8136.28 |
| USD | UNITED STATES OF AMERICA (THE) | AG ISSUER LLC | 6.25% 01 Mar 2028 | 2028-03-01T00:00:00.000 | 6.25 | 0 | 625000.00 | 545431.25 | 638993.5 | -93562.25 | 13020.83 |
| USD | UNITED STATES OF AMERICA (THE) | AG ISSUER LLC | 6.25% 01 Mar 2028 | 2028-03-01T00:00:00.000 | 6.25 | 0 | 1629000.00 | 1421612.01 | 1600181.75 | -178569.74 | 33937.5 |
| USD | UNITED STATES OF AMERICA (THE) | AES CORP/THE | 3.3% 15 Jul 2025 | 2025-07-15T00:00:00.000 | 3.3 | 0 | 7297000.00 | 6844440.06 | 7506249.84 | -661809.78 | 111036.01 |
Showing 12 of 25 columns. All of them are listed below.
| This column provides a basic description of the security or financial investment, if any. |
| 1% |
COMMON STOCK0COMMON STOCK USD.01 |
maturity_date | datetime | This column sets forth the maturity date of the investment, if any. | 68% | 1899-12-31T00:00:00.0002030-12-31T00:00:00.0002028-01-15T00:00:00.000 |
interest_rate | float | This column sets for the interest rate paid on the investment, if any. | 0% | 03.504.00 |
original_face | integer | This column sets for the original face value of the investment instrument, if any | 0% | 0500000.00100000.00 |
shares_par_value | float | In the case of fixed income investments (such as bonds), this column sets forth the “par value,” or face value, of the investment instrument; in the case of stock and other financial instruments, this column sets forth the number of shares or units held | 0% | 0200000.00250000.00 |
base_market_value | float | This column sets forth the average market value of the investment as of the date set forth in the Period End Date column | 0% | 0.000.010.02 |
base_total_cost | float | This column sets forth the total cost basis of the investment | 0% | 02000000.01 |
base_unrealized_gain_loss | float | This column sets forth the unrealized gain or loss in value of the investment since acquisition | 0% | 0-0.010.01 |
base_accrued_interest | float | This column sets forth the amount of interest that has accrued on a fixed income investment since acquisition | 0% | 022501875 |
local_market_value | float | This column sets forth the average value of the investment in the investment’s local market as of the date set forth in the Period End Date column | 0% | 00.010.02 |
local_total_cost_amount | float | This column sets forth the total cost basis of the investment in the investment’s local market | 0% | 02000000.01 |
local_unrealized_gain_loss | float | This column sets forth the unrealized gain or loss in value of the investment since acquisition in the investment’s local market | 0% | 0-0.013000.00 |
local_accrued_interest | float | This column sets forth the amount of interest that has accrued on a fixed income investment since acquisition in the investment’s local market | 0% | 022501875 |
period_end_date | datetime | This column sets forth the end date of the fiscal year | 0% | 1899-12-31T00:00:00.0002019-06-30T00:00:00.0002020-06-30T00:00:00.000of 10 |
asset_class | categorical | This column sets forth the investment category into which the investment falls (equity, fixed income, cash or cash equivalent) | 0% | EQUITYFIXED INCOME0of 5 |
investment_type_name | text | This column sets forth the name of the type of investment | 0% | COMMON STOCKCORPORATE BONDS0 |
major_industry_name | text | This column sets forth the major industry in which the investment falls | 0% | CORPORATE0INDUSTRIALS |
minor_industry_name | text | This column sets forth the minor industry in which the investment falls | 0% | 0INDUSTRIALBANKS |
moody_s_quality_rating | text | This column sets forth the rating that has been assigned to the investment by Moody's, where a rating is available | 30% | NA0Ba3 |
s_and_p_quality_rating | text | This column sets forth the rating that has been assigned to the investment by S&P, where a rating is available | 31% | NA0NR |
direct_group_trust_holding | categorical | Indicates a Direct or Group Trust Holding | 9% | DirectGroup TrustGroupt Trustof 3 |
data_as_of | datetime | — | 9% | 2020-01-30T00:00:00.0002021-01-27T00:00:00.0002023-01-25T00:00:00.000of 7 |