From a 500-row sample across 25 columns.
trade_country_namedata_as_ofdirect_group_trust_holding+22trade_country_namedata_as_ofdirect_group_trust_holding+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) | 1011778 BC / NEW RED FIN | 4.25% 15 May 2024 | 2024-05-15T00:00:00.000 | 4.25 | 0.00 | 325000.00 | 322949.25 | 325000.00 | -2050.75 |
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/95aa-k2ka GET /api/datasets/95aa-k2ka/quality GET /api/datasets/95aa-k2ka/related GET /api/columns?dataset=95aa-k2ka
trade_country_namedata_as_ofdirect_group_trust_holdingtrade_country_namedata_as_ofdirect_group_trust_holding+22| 1688.20 |
| USD | UNITED STATES OF AMERICA (THE) | 21ST CENTURY FOX AMERICA | 7.625% 30 Nov 2028 | 2028-11-30T00:00:00.000 | 7.63 | 0.00 | 75000.00 | 98187.75 | 80998.50 | 17189.25 | 492.45 |
| USD | UNITED STATES OF AMERICA (THE) | 21ST CENTURY FOX AMERICA | 6.2% 15 Dec 2034 | 2034-12-15T00:00:00.000 | 6.20 | 0.00 | 225000.00 | 277024.50 | 243814.23 | 33210.27 | 620.00 |
| USD | UNITED STATES OF AMERICA (THE) | 21ST CENTURY FOX AMERICA | 7.85% 01 Mar 2039 | 2039-03-01T00:00:00.000 | 7.85 | 0.00 | 290000.00 | 418101.70 | 320151.64 | 97950.06 | 7588.33 |
| USD | UNITED STATES OF AMERICA (THE) | 21ST CENTURY FOX AMERICA | 8.25% 10 Aug 2018 | 2018-08-10T00:00:00.000 | 8.25 | 0.00 | 515000.00 | 549963.35 | 645351.65 | -95388.30 | 16640.94 |
| USD | UNITED STATES OF AMERICA (THE) | ABBOTT LABORATORIES | 3.875% 15 Sep 2025 | 2025-09-15T00:00:00.000 | 3.88 | 0.00 | 35000.00 | 35998.55 | 35062.90 | 935.65 | 399.34 |
| USD | UNITED STATES OF AMERICA (THE) | ABBOTT LABORATORIES | 3.75% 30 Nov 2026 | 2026-11-30T00:00:00.000 | 3.75 | 0.00 | 50000.00 | 51040.50 | 49628.00 | 1412.50 | 161.46 |
| USD | UNITED STATES OF AMERICA (THE) | ABBOTT LABORATORIES | 4.75% 15 Apr 2043 | 2043-04-15T00:00:00.000 | 4.75 | 0.00 | 62000.00 | 65608.40 | 61273.24 | 4335.16 | 621.72 |
| USD | UNITED STATES OF AMERICA (THE) | ABBOTT LABORATORIES | 2.9% 30 Nov 2021 | 2021-11-30T00:00:00.000 | 2.90 | 0.00 | 170000.00 | 171898.90 | 169699.10 | 2199.80 | 424.53 |
| USD | UNITED STATES OF AMERICA (THE) | ABBOTT LABORATORIES | 4.9% 30 Nov 2046 | 2046-11-30T00:00:00.000 | 4.90 | 0.00 | 500000.00 | 550720.00 | 514105.00 | 36615.00 | 2109.72 |
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% |
0COMMON STOCKCOMMON STOCK USD.01 |
maturity_date | datetime | This column sets forth the maturity date of the investment, if any. | 25% | 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% | 0.003.54 |
original_face | integer | This column sets for the original face value of the investment instrument, if any | 0% | 0.00100000.00200000.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% | 050000.00100000.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.0025000.0050000.00 |
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% | 01125.001250.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.0025000.0050000.00 |
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.01-0.02 |
local_accrued_interest | text | 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% | - 001899-12-31T00:00:00.000 |
period_end_date | datetime | This column sets forth the end date of the fiscal year | 0% | 1899-12-31T00:00:00.0002020-06-30T00:00:00.0002019-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 STOCK1899-12-31T00:00:00.000CORPORATE BONDS |
major_industry_name | text | This column sets forth the major industry in which the investment falls | 0% | 1899-12-31T00:00:00.000CORPORATEINDUSTRIALS |
minor_industry_name | text | This column sets forth the minor industry in which the investment falls | 0% | 1899-12-31T00:00:00.000INDUSTRIALBANKS |
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 | 21% | 1899-12-31T00:00:00.000NABaa2 |
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 | 22% | 1899-12-31T00:00:00.000NANR |
direct_group_trust_holding | categorical | Indicates a Direct or Group Trust Holding | 0% | Group TrustDirectof 2 |
data_as_of | datetime | — | 10% | 2021-01-26T00:00:00.0002020-01-30T00:00:00.0002023-01-25T00:00:00.000of 7 |