Skip to main content
Messagefields26topicsec-filings

Fields

The number on the right of each row is the protobuf field number.
tickerstring1
the ticker traded by the insider in the filing that company is the filing’s issuer
filing_datestring2
the date the filing was published to the SEC on
transaction_datestring3
the date the filing’s transactions were executed
formtypestring4
the SEC filing form type 3: initial statement of beneficial ownership 4: statement of changes of beneficial ownership 5: annual statement 144: notice of proposed sale of restricted or control securities (intended sale, NOT yet completed) …/A: amendment to a prior filing
owner_namestring5
the name of the reporting person owning the traded equity securities
officer_titlestring6
the reporting person’s officer title in the issuer company, if any exists (e.g. CEO)
is_directorbool7
whether the reporting person serves on the issuer’s board of directors
is_officerbool8
whether the reporting person is an officer of the issuer (e.g., CEO, CFO) typically paired with an officer title field
is_ten_percent_ownerbool9
whether the reporting person beneficially owns more than 10% of a class of the issuer’s registered equity securities
security_ad_codestring10
composite transaction type: NA: Non-derivative, Acquired -> insider gained common stock (a buy, grant, or vesting) ND: Non-derivative, Disposed -> insider gave up common stock (a sale, gift, or withholding). DA: Derivative, Acquired -> insider gained a derivative (option/warrant grant, etc.). DD: Derivative, Disposed -> insider gave up a derivative (exercise, expiration, sale).
transaction_codestring11
type of the transaction (e.g. S=Sale, P=Purchase, A=Grant, …)
shares_owned_beforeint6412
the number of holdings owned before the transaction
amountint6413
the total number of holdings traded, summed across the aggregated transactions
shares_owned_afterint6414
the number of holdings owned after the transaction
pricedouble15
the amount-weighted average price per security across the aggregated transactions
security_titlestring16
the name of the security (e.g. “Common Stock”)
director_indirectstring17
whether the reporter directly or indirectly owns the equity securities
natureofownershipstring18
explains indirect ownership (e.g. “By Spouse”, “By Trust”)
date_excercisablestring19
date when the derivative becomes exercisable
price_excercisabledouble20
the derivative’s price to exercise
expiration_datestring21
date when the derivative lapses
idsstringrepeated22
the primary-key ids of the raw rows of the raw aggregated insider trades
transactionsint6423
the amount of aggregated transactions (rows)
is_10b5_1bool24
whether the transactions were part of a 10b5-1 plan (prearranged trading plan, that lets insiders buy or sell at a preset schedule)
reporter_is_public_companybool25
whether the reporting person is a public company
reporter_cikstring26
the CIK of the reporting person
Last modified on September 23, 2026