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
