From a 500-row sample across 25 columns.
investment_type_namelocal_unrealized_gain_lossmoody_s_quality_rating+22investment_type_namelocal_unrealized_gain_lossmoody_s_quality_rating+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) | STATE STREET BANK + TRUST CO | SHORT TERM INVESTMENT FUND | 2030-12-31T00:00:00.000 | 1.12176 | 0 | 16357775.64 | 16357775.64 | 16357775.64 | 0 |
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/5u2d-n46s GET /api/datasets/5u2d-n46s/quality GET /api/datasets/5u2d-n46s/related GET /api/columns?dataset=5u2d-n46s
investment_type_namelocal_unrealized_gain_lossmoody_s_quality_ratinginvestment_type_namelocal_unrealized_gain_lossmoody_s_quality_rating+22| 0 |
| USD | UNITED STATES OF AMERICA (THE) | STATE STREET BANK + TRUST CO | SHORT TERM INVESTMENT FUND | 2030-12-31T00:00:00.000 | 1.12176 | 0 | 5185238.35 | 5185238.35 | 5185238.35 | 0 | 0 |
| USD | UNITED STATES OF AMERICA (THE) | STATE STREET BANK + TRUST CO | SHORT TERM INVESTMENT FUND | 2030-12-31T00:00:00.000 | 1.12176 | 0 | 1466.62 | 1466.62 | 1466.62 | 0 | 0 |
| USD | UNITED STATES OF AMERICA (THE) | STATE STREET BANK + TRUST CO | SHORT TERM INVESTMENT FUND | 2030-12-31T00:00:00.000 | 1.12176 | 0 | 105.58 | 105.58 | 105.58 | 0 | 0 |
| USD | UNITED STATES OF AMERICA (THE) | STATE STREET BANK + TRUST CO | SHORT TERM INVESTMENT FUND | 2030-12-31T00:00:00.000 | 1.12176 | 0 | 254612.59 | 254612.59 | 254612.59 | 0 | 0 |
| USD | UNITED STATES OF AMERICA (THE) | US DOLLAR | — | — | 0 | 0 | -4.23 | -4.23 | -4.23 | 0 | 0 |
| USD | UNITED STATES OF AMERICA (THE) | STATE STREET BANK + TRUST CO | SHORT TERM INVESTMENT FUND | 2030-12-31T00:00:00.000 | 1.12176 | 0 | 54.39 | 54.39 | 54.39 | 0 | 0 |
| USD | UNITED STATES OF AMERICA (THE) | STATE STREET BANK + TRUST CO | SHORT TERM INVESTMENT FUND | 2030-12-31T00:00:00.000 | 1.12176 | 0 | 12571685.70 | 12571685.70 | 12571685.70 | 0 | 0 |
| USD | UNITED STATES OF AMERICA (THE) | STATE STREET BANK + TRUST CO | SHORT TERM INVESTMENT FUND | 2030-12-31T00:00:00.000 | 1.12176 | 0 | 9267.36 | 9267.36 | 9267.36 | 0 | 0 |
| CAD | CANADA | CANADIAN DOLLAR | — | — | 0 | 0 | 318.75 | 245.44 | 231.91 | 13.53 | 0 |
Showing 12 of 22 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. | 44% | 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% | 0300000.00500000.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.00400000.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.000.01200000.00 |
base_unrealized_gain_loss | float | This column sets forth the unrealized gain or loss in value of the investment since acquisition | 0% | 00.01-0.01 |
base_accrued_interest | float | This column sets forth the amount of interest that has accrued on a fixed income investment since acquisition | 0% | 02500.001750 |
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.000.01200000.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-2500.001500.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% | 02500.001750 |
period_end_date | datetime | This column sets forth the end date of the fiscal year | 0% | 2020-06-30T00:00:00.0002019-06-30T00:00:00.0002022-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.000FNMA |
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 | 31% | NA1899-12-31T00:00:00.000Baa2 |
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 | 33% | NA1899-12-31T00:00:00.000NR |
direct_group_trust_holding | categorical | Indicates a Direct or Group Trust Holding | 0% | DirectGroup Trustof 2 |
data_as_of | datetime | — | 9% | 2020-01-30T00:00:00.0002021-01-29T00:00:00.0002023-01-25T00:00:00.000of 7 |