Data Dictionary: Filers: id int(11) primary key name varchar(255) street varchar(255) city varchar(255) state varchar(255) state_incorporation varchar(255) zip_code varchar(255) business_phone varchar(255) cik varchar(255) irs_number varchar(255) last_modified date Filings: id int(11) primary key filer_id int(11) foreign key to filers.id form_type varchar ('13F-HR' or '13F-HR/A') sec_file_number varchar(255) period_of_report date filed_as_of_date date mv_multiplier int(11) edgar_url varchar(255) filing_type varchar (Original Restatement Additional Holdings) created_at date quarter_id int(11) foreign key to quarters.id Stocks: id int(11) primary key name varchar(255) ticker varchar(15) new_stock_id int(11) is_delisted tinyint 1=yes, 0=0 delisting_date date sector varchar(255) industry varchar(255) Filing_stock_records: id int(11) unsigned primary key filing_id int(11) foreign key to filings.id stock_id int(11) foreign key to stocks.id name varchar(255) alt_name varchar(255) title varchar(255) cusip_number varchar(25) alt_cusip varchar(25) - A corrected CUSIP number determined by Whalewisdom. If the original cusip is incorrect, this is Whalewisdom's best guess as to what it should be. market_value decimal(20,2) shares decimal(20,0) security_type varchar (SH CALL PUT or PRN) other_managers varchar(100) other_managers id int(11) primary key filer_id int(11) foreign key to filers.id quarter_id int(11) foreign key to quarters.id name varchar(255) file_number varchar(255) manager_number varchar(255) quarters: id int(11) primary key end_of_quarter_date date filing_report_sigs (optional) filing_id int(11) foreign key to filings.id filer_id int(11) foreign key to filers.id form_type varchar ('13F-HR' or '13F-HR/A') sec_file_number varchar(255) period_of_report date quarter_id int(11) foreign key to quarters.id filed_as_of_date date report_sig_name varchar(255) report_sig_title varchar(255) report_sig_phone varchar(255) edgar_url varchar(255) filing_type varchar (Original Restatement Additional Holdings) created_at date