From a 500-row sample across 24 columns.
local_unrealized_gain_lossinterest_ratemajor_industry_name+22local_unrealized_gain_lossinterest_ratemajor_industry_name+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) | 101 WALKER STREET | 1% 01 Dec 2022 | 2022-12-01T00:00:00.000 | 2.87 | 162499.99 | 96580.54 | 98058.30 | 96580.54 | 1477.76 |
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/dy3p-ay2d GET /api/datasets/dy3p-ay2d/quality GET /api/datasets/dy3p-ay2d/related GET /api/columns?dataset=dy3p-ay2d
local_unrealized_gain_lossinterest_ratemajor_industry_namelocal_unrealized_gain_lossinterest_ratemajor_industry_name+22| 0 |
| USD | UNITED STATES OF AMERICA (THE) | 1010 + 1011 RUTLAND ST | 1% 01 Jan 2031 | 2031-01-01T00:00:00.000 | 6.23 | 275500.01 | 218468.61 | 261656.55 | 218468.61 | 43187.94 | 0 |
| USD | UNITED STATES OF AMERICA (THE) | 1011778 BC / NEW RED FIN | 6% 01 Apr 2022 | 2022-04-01T00:00:00.000 | 6 | 0.00 | 1150000.00 | 1191687.50 | 1173794.64 | 17892.86 | 17250.00 |
| USD | UNITED STATES OF AMERICA (THE) | 1011778 BC / NEW RED FIN | 4.25% 15 May 2024 | 2024-05-15T00:00:00.000 | 4.25 | 0.00 | 345000.00 | 342823.05 | 344850.00 | -2026.95 | 1806.25 |
| USD | UNITED STATES OF AMERICA (THE) | 1011778 BC / NEW RED FIN | 4.625% 15 Jan 2022 | 2022-01-15T00:00:00.000 | 4.625 | 0.00 | 335000.00 | 343375.00 | 334762.50 | 8612.50 | 7144.32 |
| USD | UNITED STATES OF AMERICA (THE) | 1011778 BC / NEW RED FIN | 4.25% 15 May 2024 | 2024-05-15T00:00:00.000 | 4.25 | 0.00 | 156000.00 | 155015.64 | 156000.00 | -984.36 | 810.34 |
| USD | UNITED STATES OF AMERICA (THE) | 1011778 BC / NEW RED FIN | 4.25% 15 May 2024 | 2024-05-15T00:00:00.000 | 4.25 | 0.00 | 150000.00 | 149053.50 | 150000.00 | -946.50 | 779.16 |
| USD | UNITED STATES OF AMERICA (THE) | 1020 WINTHROP STREET | 1% 01 May 2043 | 2043-05-01T00:00:00.000 | 6.67 | 77336.00 | 74009.99 | 97796.64 | 74009.99 | 23786.65 | 0 |
| USD | UNITED STATES OF AMERICA (THE) | 1060 UNIVERSITY AVENUE | 1% 01 Oct 2036 | 2036-10-01T00:00:00.000 | 5.75 | 133749.94 | 111797.56 | 132145.85 | 111797.56 | 20348.29 | 0 |
| USD | UNITED STATES OF AMERICA (THE) | 1084 1086 HOME STREET | 1% 01 Apr 2034 | 2034-04-01T00:00:00.000 | 6.57 | 212399.74 | 179113.25 | 219417.56 | 179113.25 | 40304.31 | 0 |
Showing 12 of 24 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. | 29% | 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.54 |
original_face | integer | This column sets for the original face value of the investment instrument, if any | 0% | 0200000250000 |
shares_par_value | integer | 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.00500000.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% | 0.00200000.000.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.01-0.02 |
base_accrued_interest | float | This column sets forth the amount of interest that has accrued on a fixed income investment since acquisition | 0% | 01437.51375.00 |
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% | 0.000.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% | 0.00200000.000.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.02-0.01 |
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% | 01437.51375.00 |
period_end_date | datetime | This column sets forth the end date of the fiscal year | 0% | 2022-06-30T00:00:00.0002020-06-30T00:00:00.0002024-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 INCOME1899-12-31T00:00:00.000of 5 |
investment_type_name | text | This column sets forth the name of the type of investment | 0% | COMMON STOCKCORPORATE BONDS1899-12-31T00:00:00.000 |
major_industry_name | text | This column sets forth the major industry in which the investment falls | 0% | CORPORATEINDUSTRIALS1899-12-31T00:00:00.000 |
minor_industry_name | text | This column sets forth the minor industry in which the investment falls | 0% | INDUSTRIAL1899-12-31T00:00:00.000FINANCE |
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 | 27% | NA1899-12-31T00:00:00.0000 |
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 | 28% | NA1899-12-31T00:00:00.0000 |
direct_group_trust_holding | categorical | Indicates a Direct or Group Trust Holding | 0% | DirectGroup Trustof 2 |
data_as_of | datetime | — | 11% | 2020-01-30T00:00:00.0002023-01-25T00:00:00.0002021-01-29T00:00:00.000of 7 |