We are starting to move all of the Forms 3/4/5 data to a database format. The first (and easiest) step of this was to pull the REMARKS field from these filings and insert them into their own database.

One potential use is to identify those filings that describe transactions that were made pursuant to a 10b plan. While many of the filings include information about that reason for particular transactions in a footnote attached to the transaction some use a global indicator in the REMARKS section.

We include the CIK field as the CIK of the issuer and the rptownercik field has the CIK of the person reporting the transaction. You can merge with issuer related data or person related data using the appropriate column. The image below shows the results of a search to identify all remarks fields where there is mention of either 10B or 10-B (I noticed some users seem to reference 10-B rather than 10B).

We will be working to port over separate tables for derivative and then non-derivative transactions. Because the accession number will be included in all of the related tables it should be trivial to merge across the various tables. I will report that the ACCEPTANCE_TIME value was pulled from the FILING_TIMES data set by ACCESSION_NUMBER.