Machine-readable data dictionary for Forms 3, 4 and 5 (insider ownership and transactions) - SEC Insider Transactions Data Sets: every field (147) with the agency's own definition and source citation, official code lists, the values actually found in the published files (2006q1 to 2026q2), with company identifiers named as CIK, LEI and FIGI.
Download: YAML (all four layers) · CSVW
| Table | Field | Official definition | Form item | Code list |
|---|---|---|---|---|
| DERIV_HOLDING | ACCESSION_NUMBER | Unique identifier assigned by the SEC to each EDGAR submission | ||
| DERIV_HOLDING | DERIV_HOLDING_SK | Derivative holding surrogate key | ||
| DERIV_HOLDING | SECURITY_TITLE | Title of Derivative Security | ||
| DERIV_HOLDING | SECURITY_TITLE_FN | Footnote identifier on Title of Derivative Security | ||
| DERIV_HOLDING | CONV_EXERCISE_PRICE | Conversion Or exercise price | ||
| DERIV_HOLDING | CONV_EXERCISE_PRICE_FN | Footnote identifier on conversion or exercise price | ||
| DERIV_HOLDING | TRANS_FORM_TYPE | Transaction form type | ||
| DERIV_HOLDING | TRANS_FORM_TYPE_FN | Transaction form type footnote | ||
| DERIV_HOLDING | EXERCISE_DATE | Date Exercisable and Expiration Date | ||
| DERIV_HOLDING | EXERCISE_DATE_FN | Date Exercisable and Expiration Date footnote | ||
| DERIV_HOLDING | EXPIRATION_DATE | Date Exercisable and Expiration Date | ||
| DERIV_HOLDING | EXPIRATION_DATE_FN | Date Exercisable and Expiration Date footnote | ||
| DERIV_HOLDING | UNDLYNG_SEC_TITLE | Title of Underlying Securities | ||
| DERIV_HOLDING | UNDLYNG_SEC_TITLE_FN | Foot note on Title of Underlying Securities | ||
| DERIV_HOLDING | UNDLYNG_SEC_SHARES | Number of shares reported of Underlying Securities | ||
| DERIV_HOLDING | UNDLYNG_SEC_SHARES_FN | Footnote identifier on Number of shares reported of Underlying Securities | ||
| DERIV_HOLDING | UNDLYNG_SEC_VALUE | Amount of Underlying Securities value | ||
| DERIV_HOLDING | UNDLYNG_SEC_VALUE_FN | Footnote identifier on Amount of Underlying Securities value | ||
| DERIV_HOLDING | SHRS_OWND_FOLWNG_TRANS | Shares owned at end of Fiscal Year | ||
| DERIV_HOLDING | SHRS_OWND_FOLWNG_TRANS_FN | Shares owned at end of Fiscal Year footnote | ||
| DERIV_HOLDING | VALU_OWND_FOLWNG_TRANS | Value owned of the Securities owned at end of Fiscal Year | ||
| DERIV_HOLDING | VALU_OWND_FOLWNG_TRANS_FN | Value owned of the Securities owned at end of Fiscal Year footnote | ||
| DERIV_HOLDING | DIRECT_INDIRECT_OWNERSHIP | Ownership Form: Direct or Indirect | ||
| DERIV_HOLDING | DIRECT_INDIRECT_OWNERSHIP_FN | Ownership Form: Direct or Indirect footnote | ||
| DERIV_HOLDING | NATURE_OF_OWNERSHIP | Nature of Indirect Beneficial Ownership | ||
| DERIV_HOLDING | NATURE_OF_OWNERSHIP_FN | Nature of Indirect Beneficial Ownership footnote | ||
| DERIV_TRANS | ACCESSION_NUMBER | Unique identifier assigned by the SEC to each EDGAR submission | ||
| DERIV_TRANS | DERIV_TRANS_SK | derivative transaction surrogate key | ||
| DERIV_TRANS | SECURITY_TITLE | Title of Derivative Security | ||
| DERIV_TRANS | SECURITY_TITLE_FN | Title of Derivative Security footnote | ||
| DERIV_TRANS | CONV_EXERCISE_PRICE | Conversion or Exercise Price | ||
| DERIV_TRANS | CONV_EXERCISE_PRICE_FN | conversion or exercise price footnote | ||
| DERIV_TRANS | TRANS_DATE | Transaction date when transaction originally occured | ||
| DERIV_TRANS | TRANS_DATE_FN | Transaction date footnote | ||
| DERIV_TRANS | DEEMED_EXECUTION_DATE | Deemed execution date | ||
| DERIV_TRANS | DEEMED_EXECUTION_DATE_FN | Deemed execution date footnote | ||
| DERIV_TRANS | TRANS_FORM_TYPE | Type of forms submitted as part of Transaction | ||
| DERIV_TRANS | TRANS_CODE | Mandatory transaction code as provided in TransCodeList choices | ||
| DERIV_TRANS | EQUITY_SWAP_INVOLVED | Indicator to show if the transaction involves an equity or swap | ||
| DERIV_TRANS | EQUITY_SWAP_INVOLVED_FN | Footnote for transaction involving equity or swap | ||
| DERIV_TRANS | TRANS_TIMELINESS | Indicator to show timeliness of transaction | ||
| DERIV_TRANS | TRANS_TIMELINESS_FN | Indicator to show timeliness footnote of transaction | ||
| DERIV_TRANS | TRANS_SHARES | Transaction shares reported when Transaction shares reported when Securities Acquired (A) or Disposed of (D) | ||
| DERIV_TRANS | TRANS_SHARES_FN | Transaction shares reported when Securities Acquired (A) or Disposed of (D) footnote | ||
| DERIV_TRANS | TRANS_TOTAL_VALUE | Transaction total value reported when Securities Acquired (A) or Disposed of (D) | ||
| DERIV_TRANS | TRANS_TOTAL_VALUE_FN | Transaction total value reported when Securities Acquired (A) or Disposed of (D) footnote | ||
| DERIV_TRANS | TRANS_PRICEPERSHARE | Price of Derivative Transaction Security | ||
| DERIV_TRANS | TRANS_PRICEPERSHARE_FN | Price of Derivative Transaction Security footnote | ||
| DERIV_TRANS | TRANS_ACQUIRED_DISP_CD | Transaction code reported when Securities Acquired (A) or Disposed of (D) | ||
| DERIV_TRANS | TRANS_ACQUIRED_DISP_CD_FN | Footnote related to Securities transaction (acquired or disposed) | ||
| DERIV_TRANS | EXCERCISE_DATE | Date Exercisable and Expiration Date | ||
| DERIV_TRANS | EXCERCISE_DATE_FN | Date Exercisable and Expiration Date footnote | ||
| DERIV_TRANS | EXPIRATION_DATE | Date Exercisable and Expiration Date | ||
| DERIV_TRANS | EXPIRATION_DATE_FN | Date Exercisable and Expiration Date footnote | ||
| DERIV_TRANS | UNDLYNG_SEC_TITLE | Title of Underlying Securities | ||
| DERIV_TRANS | UNDLYNG_SEC_TITLE_FN | Title of Underlying Securities footnote | ||
| DERIV_TRANS | UNDLYNG_SEC_SHARES | Number of shares owned of Underlying Securities | ||
| DERIV_TRANS | UNDLYNG_SEC_SHARES_FN | Number of shares owned of Underlying Securities footnote | ||
| DERIV_TRANS | UNDLYNG_SEC_VALUE | Value of Underlying Securities | ||
| DERIV_TRANS | UNDLYNG_SEC_VALUE_FN | Value of Underlying Securities footnote | ||
| DERIV_TRANS | SHRS_OWND_FOLWNG_TRANS | Shares owned at end of Fiscal Year | ||
| DERIV_TRANS | SHRS_OWND_FOLWNG_TRANS_FN | Shares owned at end of Fiscal Year footnote | ||
| DERIV_TRANS | VALU_OWND_FOLWNG_TRANS | Value owned at end of Fiscal Year | ||
| DERIV_TRANS | VALU_OWND_FOLWNG_TRANS_FN | Value owned at end of Fiscal Year footnote | ||
| DERIV_TRANS | DIRECT_INDIRECT_OWNERSHIP | Direct or indirect ownership | ||
| DERIV_TRANS | DIRECT_INDIRECT_OWNERSHIP_FN | Direct or indirect ownership footnote | ||
| DERIV_TRANS | NATURE_OF_OWNERSHIP | Nature of ownership | ||
| DERIV_TRANS | NATURE_OF_OWNERSHIP_FN | Nature of ownership footnote | ||
| FOOTNOTES | ACCESSION_NUMBER | Unique identifier assigned by the SEC to each EDGAR submission | ||
| FOOTNOTES | FOOTNOTE_ID | Footnote identifier | ||
| FOOTNOTES | FOOTNOTE_TXT | Footnote text | ||
| NONDERIV_HOLDING | ACCESSION_NUMBER | Unique identifier assigned by the SEC to each EDGAR submission | ||
| NONDERIV_HOLDING | NONDERIV_HOLDING_SK | Nonderivative holding surrogate key | ||
| NONDERIV_HOLDING | SECURITY_TITLE | Security title | ||
| NONDERIV_HOLDING | SECURITY_TITLE_FN | Footnote Identifier on Security title | ||
| NONDERIV_HOLDING | TRANS_FORM_TYPE | Transaction form type | ||
| NONDERIV_HOLDING | TRANS_FORM_TYPE_FN | Footnote Identifier on Transaction form type | ||
| NONDERIV_HOLDING | SHRS_OWND_FOLWNG_TRANS | Shares owned following transaction | ||
| NONDERIV_HOLDING | SHRS_OWND_FOLWNG_TRANS_FN | Footnote Identifier for Shares owned following transaction | ||
| NONDERIV_HOLDING | VALU_OWND_FOLWNG_TRANS | Value owned following transaction | ||
| NONDERIV_HOLDING | VALU_OWND_FOLWNG_TRANS_FN | Footnote Identifier on value owned following transaction | ||
| NONDERIV_HOLDING | DIRECT_INDIRECT_OWNERSHIP | Direct or Indirect ownership | ||
| NONDERIV_HOLDING | DIRECT_INDIRECT_OWNERSHIP_FN | Footnote Identifier on Direct or Indirect ownership | ||
| NONDERIV_HOLDING | NATURE_OF_OWNERSHIP | Nature of Indirect Beneficial Ownership | ||
| NONDERIV_HOLDING | NATURE_OF_OWNERSHIP_FN | Footnote Identifier on Nature of Indirect Beneficial Ownership | ||
| NONDERIV_TRANS | ACCESSION_NUMBER | Unique identifier assigned by the SEC to each EDGAR submission | ||
| NONDERIV_TRANS | NONDERIV_TRANS_SK | Nonderiv transaction surrogate key | ||
| NONDERIV_TRANS | SECURITY_TITLE | Title of Security | ||
| NONDERIV_TRANS | SECURITY_TITLE_FN | Security title footnote | ||
| NONDERIV_TRANS | TRANS_DATE | Transaction date | ||
| NONDERIV_TRANS | TRANS_DATE_FN | Footnote Identifier Transaction date | ||
| NONDERIV_TRANS | DEEMED_EXECUTION_DATE | Deemed execution date | ||
| NONDERIV_TRANS | DEEMED_EXECUTION_DATE_FN | Footnote Identifier Deemed execution date | ||
| NONDERIV_TRANS | TRANS_FORM_TYPE | Transaction form type | ||
| NONDERIV_TRANS | TRANS_CODE | Transaction code | ||
| NONDERIV_TRANS | EQUITY_SWAP_INVOLVED | Indicator to show if the transaction involves an equity or swap | ||
| NONDERIV_TRANS | EQUITY_SWAP_INVOLVED_FN | Footnote Identifier Transaction involving equity or swap | ||
| NONDERIV_TRANS | TRANS_TIMELINESS | Transaction timeliness | ||
| NONDERIV_TRANS | TRANS_TIMELINESS_FN | Transaction timeliness footnote | ||
| NONDERIV_TRANS | TRANS_SHARES | Transaction shares reported when Securities Acquired (A) or Disposed of (D) | ||
| NONDERIV_TRANS | TRANS_SHARES_FN | Footnote Identifier transaction shares reported when Securities Acquired (A) or Disposed of (D) | ||
| NONDERIV_TRANS | TRANS_PRICEPERSHARE | Price of non-Derivative Transaction Security | ||
| NONDERIV_TRANS | TRANS_PRICEPERSHARE_FN | Price of Derivative Transaction Security footnote | ||
| NONDERIV_TRANS | TRANS_ACQUIRED_DISP_CD | Transaction code reported when Securities Acquired (A) or Disposed of (D) | ||
| NONDERIV_TRANS | TRANS_ACQUIRED_DISP_CD_FN | Transaction code reported when Securities Acquired (A) or Disposed of (D) footnote | ||
| NONDERIV_TRANS | SHRS_OWND_FOLWNG_TRANS | Securities owned at end of Fiscal Year | ||
| NONDERIV_TRANS | SHRS_OWND_FOLWNG_TRANS_FN | Securities owned at end of Fiscal Year footnote | ||
| NONDERIV_TRANS | VALU_OWND_FOLWNG_TRANS | following reported transaction(s) | ||
| NONDERIV_TRANS | VALU_OWND_FOLWNG_TRANS_FN | Footnote for following reported transaction(s) | ||
| NONDERIV_TRANS | DIRECT_INDIRECT_OWNERSHIP | Direct or Indirect ownership | ||
| NONDERIV_TRANS | DIRECT_INDIRECT_OWNERSHIP_FN | Direct or Indirect ownership footnote ID | ||
| NONDERIV_TRANS | NATURE_OF_OWNERSHIP | Nature of Indirect Beneficial Ownership | ||
| NONDERIV_TRANS | NATURE_OF_OWNERSHIP_FN | Footnote Identifier on nature of Indirect Beneficial Ownership | ||
| OWNER_SIGNATURE | ACCESSION_NUMBER | Unique identifier assigned by the SEC to each EDGAR submission | ||
| OWNER_SIGNATURE | OWNERSIGNATURENAME | Reporting owner signature name | ||
| OWNER_SIGNATURE | OWNERSIGNATUREDATE | Reporting owner signature date | ||
| REPORTINGOWNER | ACCESSION_NUMBER | Unique identifier assigned by the SEC to each EDGAR submission | ||
| REPORTINGOWNER | RPTOWNERCIK | Central Index Key of reporting owner | ||
| REPORTINGOWNER | RPTOWNERNAME | Reporting ownername | ||
| REPORTINGOWNER | RPTOWNER_RELATIONSHIP | Reporting owner relationship OFFICER, DIRECTOR, TENPERCENTOWNER , OTHER | ||
| REPORTINGOWNER | RPTOWNER_TITLE | Reporting owner title if relationship is DIRECTOR | ||
| REPORTINGOWNER | RPTOWNER_TXT | If Reporting owner relationship is 'OTHER' then provide additional details | ||
| REPORTINGOWNER | RPTOWNER_STREET1 | Reporting owner Street address first line | ||
| REPORTINGOWNER | RPTOWNER_STREET2 | Reporting owner Street address second line | ||
| REPORTINGOWNER | RPTOWNER_CITY | Reporting owner City | ||
| REPORTINGOWNER | RPTOWNER_STATE | Reporting owner State | ||
| REPORTINGOWNER | RPTOWNER_ZIPCODE | Reporting owner address zipcode | ||
| REPORTINGOWNER | RPTOWNER_STATE_DESC | Description of Reporting Owner State | ||
| REPORTINGOWNER | FILE_NUMBER | Filing identifier assigned by SEC when sourced from Edgar | ||
| SUBMISSION | ACCESSION_NUMBER | Unique identifier assigned by the SEC to each EDGAR submission | ||
| SUBMISSION | FILING_DATE | Indicate FILING_DATE is sourced from EDGAR | ||
| SUBMISSION | PERIOD_OF_REPORT | Date of Event Requiring Statement | ||
| SUBMISSION | DATE_OF_ORIG_SUB | If the original form is amended, this field corresponds to the date Date Original Filed | ||
| SUBMISSION | NO_SECURITIES_OWNED | Derived value on Form 3 based on the number of entries in <nonDerativeTable> and <DerativeTable> sections of document. If either table has at least one valid entry, EDGAR will set this element to true. Otherwise, it will be set to false | ||
| SUBMISSION | NOT_SUBJECT_SEC16 | In a Form 4 or Form 5, true for a reporting person not subject to Section 16 and no transaction or holdings reporting in <nonDerativeTable> and <DerativeTable> sections of document | ||
| SUBMISSION | FORM3_HOLDINGS_REPORTED | EDGAR derived value on Form 3 or Form 4 based on the number of <nonDerivativeHolding> and <derivativeHolding> elements with a <transactionFormType> value of “3.” If at least one “3” holding is being reported, EDGAR will set this element to true. Otherwise, it will be set to false | ||
| SUBMISSION | FORM4_TRANS_REPORTED | EDGAR derived value on Form 3 or Form 4 based on the number of <nonDerivativeTransaction> and <derivativeTransaction> elements with a <transactionFormType> value of “4.” If at least one “4” transaction is being reported, EDGAR will set this element to true. Otherwise, it will be set to false | ||
| SUBMISSION | DOCUMENT_TYPE | Submission type is either an initial filing Form 3,4,5 or an amendment of either 3/A, 4/A or 5/A | ||
| SUBMISSION | ISSUERCIK | Central Index Key of Issuer | ||
| SUBMISSION | ISSUERNAME | Name of Issuer | ||
| SUBMISSION | ISSUERTRADINGSYMBOL | Issuer Trading Symbol | ||
| SUBMISSION | CONTACT_NAME | Name of Contact | ||
| SUBMISSION | CONTACT_PHONE_NUMBER | Phone number of Contact | ||
| SUBMISSION | CONTACT_EMAIL_ADDRESS | Email address of Contact | ||
| SUBMISSION | NOTIFICATION_EMAIL_ADDRESS | Email address of NOTIFICATION | ||
| SUBMISSION | REMARKS | Remarks from reporting owner | ||
| SUBMISSION | AFF10B5ONE | The transaction was made pursuant to a contract, instruction or written plan for the purchase or sale of equity securities of the issuer that is intended to satisfy the affirmative defense conditions of Rule 10b5-1(c) |