

In [46]:

    
import requests
from bs4 import BeautifulSoup as BSoup
import pandas as pd

Setting up for testing

Use sqlite3 to connect to the edgar_idx database



In [47]:

    
import sqlite3
conn3 = sqlite3.connect('edgar_idx.db')
cursor=conn3.cursor()

Set the ticker and pull out the list of 10-Q's and 10-K's for it from the database. Save each to a CSV file.



In [48]:

    
ticker = "MMM"

If necessary, update the idx and cik_ticker_name tables in the database



In [4]:

    
from MyEdgarDb import get_list_sec_filings, get_cik_ticker_lookup_db, lookup_cik_ticker
print("Updating master index.")
get_list_sec_filings ()
print("Updating CIK-ticker lookup table.")
get_cik_ticker_lookup_db ()









    



Updating master index.
Updating CIK-ticker lookup table.



In [50]:

    
#cursor.execute('''SELECT * FROM idx WHERE Symbol=?;''', ("ABBV",))
cursor.execute('''SELECT * FROM cik_ticker_name WHERE ticker=?;''',(ticker,))
res=cursor.fetchall()
print(res)
cursor.execute('''SELECT * FROM idx WHERE cik=?;''', (res[0][0],))
recs = cursor.fetchall()
names = list(map(lambda x: x[0], cursor.description))
print(names)
df = pd.DataFrame(data=recs, columns=names)
df['date'] = pd.to_datetime(df['date'])
df.columns
df.size
df.dtypes
## Sort by date in descending order (most recent is first)
df.sort_values(by=['date'], inplace=True, ascending=False)
#print(type(recs))
print(recs)
#conn3.close()
df[df.type == "10-Q"].to_csv("TestData\\"+ticker.lower()+"_all_10qs.csv", index=None)
df[df.type == "10-K"].to_csv("TestData\\"+ticker.lower()+"_all_10ks.csv", index=None)
#df[df.type == "20-F"].to_csv("TestData\\"+ticker.lower()+"_all_20fs.csv", index=None)









    



[('66740', 'MMM', '3M Co')]
['cik', 'conm', 'type', 'date', 'path']
[('66740', '3M CO', '10-K', '2014-02-13', 'edgar/data/66740/0001104659-14-009773.txt'), ('66740', '3M CO', '3', '2014-01-03', 'edgar/data/66740/0001127602-14-000432.txt'), ('66740', '3M CO', '4/A', '2014-02-18', 'edgar/data/66740/0001127602-14-006865.txt'), ('66740', '3M CO', '4', '2014-01-06', 'edgar/data/66740/0001127602-14-001073.txt'), ('66740', '3M CO', '4', '2014-01-06', 'edgar/data/66740/0001127602-14-001075.txt'), ('66740', '3M CO', '4', '2014-01-06', 'edgar/data/66740/0001127602-14-001078.txt'), ('66740', '3M CO', '4', '2014-01-06', 'edgar/data/66740/0001127602-14-001081.txt'), ('66740', '3M CO', '4', '2014-01-06', 'edgar/data/66740/0001127602-14-001084.txt'), ('66740', '3M CO', '4', '2014-01-06', 'edgar/data/66740/0001127602-14-001087.txt'), ('66740', '3M CO', '4', '2014-01-06', 'edgar/data/66740/0001127602-14-001089.txt'), ('66740', '3M CO', '4', '2014-01-06', 'edgar/data/66740/0001127602-14-001091.txt'), ('66740', '3M CO', '4', '2014-01-06', 'edgar/data/66740/0001127602-14-001093.txt'), ('66740', '3M CO', '4', '2014-01-06', 'edgar/data/66740/0001127602-14-001096.txt'), ('66740', '3M CO', '4', '2014-01-06', 'edgar/data/66740/0001127602-14-001100.txt'), ('66740', '3M CO', '4', '2014-01-07', 'edgar/data/66740/0001127602-14-001340.txt'), ('66740', '3M CO', '4', '2014-01-07', 'edgar/data/66740/0001127602-14-001342.txt'), ('66740', '3M CO', '4', '2014-01-07', 'edgar/data/66740/0001127602-14-001344.txt'), ('66740', '3M CO', '4', '2014-02-06', 'edgar/data/66740/0001127602-14-004672.txt'), ('66740', '3M CO', '4', '2014-02-06', 'edgar/data/66740/0001127602-14-004674.txt'), ('66740', '3M CO', '4', '2014-02-06', 'edgar/data/66740/0001127602-14-004676.txt'), ('66740', '3M CO', '4', '2014-02-06', 'edgar/data/66740/0001127602-14-004678.txt'), ('66740', '3M CO', '4', '2014-02-06', 'edgar/data/66740/0001127602-14-004680.txt'), ('66740', '3M CO', '4', '2014-02-06', 'edgar/data/66740/0001127602-14-004684.txt'), ('66740', '3M CO', '4', '2014-02-06', 'edgar/data/66740/0001127602-14-004687.txt'), ('66740', '3M CO', '4', '2014-02-06', 'edgar/data/66740/0001127602-14-004784.txt'), ('66740', '3M CO', '4', '2014-02-06', 'edgar/data/66740/0001127602-14-004791.txt'), ('66740', '3M CO', '4', '2014-02-06', 'edgar/data/66740/0001127602-14-004800.txt'), ('66740', '3M CO', '4', '2014-02-06', 'edgar/data/66740/0001127602-14-004804.txt'), ('66740', '3M CO', '4', '2014-02-06', 'edgar/data/66740/0001127602-14-004810.txt'), ('66740', '3M CO', '4', '2014-02-06', 'edgar/data/66740/0001127602-14-004814.txt'), ('66740', '3M CO', '4', '2014-02-06', 'edgar/data/66740/0001127602-14-004818.txt'), ('66740', '3M CO', '4', '2014-02-06', 'edgar/data/66740/0001127602-14-004821.txt'), ('66740', '3M CO', '4', '2014-02-06', 'edgar/data/66740/0001127602-14-004828.txt'), ('66740', '3M CO', '4', '2014-02-06', 'edgar/data/66740/0001127602-14-004832.txt'), ('66740', '3M CO', '4', '2014-02-06', 'edgar/data/66740/0001127602-14-004836.txt'), ('66740', '3M CO', '4', '2014-02-06', 'edgar/data/66740/0001127602-14-004842.txt'), ('66740', '3M CO', '4', '2014-02-06', 'edgar/data/66740/0001127602-14-004846.txt'), ('66740', '3M CO', '4', '2014-02-06', 'edgar/data/66740/0001127602-14-004851.txt'), ('66740', '3M CO', '4', '2014-02-06', 'edgar/data/66740/0001127602-14-004853.txt'), ('66740', '3M CO', '4', '2014-02-06', 'edgar/data/66740/0001127602-14-004856.txt'), ('66740', '3M CO', '4', '2014-02-06', 'edgar/data/66740/0001127602-14-004860.txt'), ('66740', '3M CO', '4', '2014-02-11', 'edgar/data/66740/0001127602-14-005589.txt'), ('66740', '3M CO', '4', '2014-02-19', 'edgar/data/66740/0001127602-14-006937.txt'), ('66740', '3M CO', '4', '2014-02-19', 'edgar/data/66740/0001127602-14-006939.txt'), ('66740', '3M CO', '4', '2014-02-20', 'edgar/data/66740/0001127602-14-007292.txt'), ('66740', '3M CO', '4', '2014-02-20', 'edgar/data/66740/0001127602-14-007299.txt'), ('66740', '3M CO', '4', '2014-02-24', 'edgar/data/66740/0001127602-14-007815.txt'), ('66740', '3M CO', '4', '2014-02-24', 'edgar/data/66740/0001127602-14-007820.txt'), ('66740', '3M CO', '4', '2014-02-24', 'edgar/data/66740/0001127602-14-007824.txt'), ('66740', '3M CO', '4', '2014-02-24', 'edgar/data/66740/0001127602-14-007826.txt'), ('66740', '3M CO', '5', '2014-01-07', 'edgar/data/66740/0001127602-14-001347.txt'), ('66740', '3M CO', '5', '2014-01-07', 'edgar/data/66740/0001127602-14-001349.txt'), ('66740', '3M CO', '8-K', '2014-01-30', 'edgar/data/66740/0001104659-14-005042.txt'), ('66740', '3M CO', '8-K', '2014-03-05', 'edgar/data/66740/0001104659-14-016372.txt'), ('66740', '3M CO', 'ARS', '2014-03-27', 'edgar/data/66740/9999999997-14-006869.txt'), ('66740', '3M CO', 'DEF 14A', '2014-03-26', 'edgar/data/66740/0001047469-14-002977.txt'), ('66740', '3M CO', 'DEFA14A', '2014-03-26', 'edgar/data/66740/0001104659-14-022752.txt'), ('66740', '3M CO', 'DEFA14A', '2014-03-28', 'edgar/data/66740/0001104659-14-023946.txt'), ('66740', '3M CO', 'NO ACT', '2014-02-07', 'edgar/data/66740/9999999997-14-001118.txt'), ('66740', '3M CO', 'SC 13G/A', '2014-01-28', 'edgar/data/66740/0001086364-14-000288.txt'), ('66740', '3M CO', 'SC 13G', '2014-02-03', 'edgar/data/66740/0001519058-14-000099.txt'), ('66740', '3M CO', 'SC 13G', '2014-02-10', 'edgar/data/66740/0000932471-14-002751.txt'), ('66740', '3M CO', '10-Q', '2014-05-01', 'edgar/data/66740/0001104659-14-033499.txt'), ('66740', '3M CO', '11-K', '2014-06-27', 'edgar/data/66740/0001104659-14-048767.txt'), ('66740', '3M CO', '3', '2014-05-21', 'edgar/data/66740/0001127602-14-018318.txt'), ('66740', '3M CO', '3', '2014-06-18', 'edgar/data/66740/0001127602-14-021161.txt'), ('66740', '3M CO', '4/A', '2014-04-08', 'edgar/data/66740/0001127602-14-014311.txt'), ('66740', '3M CO', '424B2', '2014-05-16', 'edgar/data/66740/0001104659-14-039670.txt'), ('66740', '3M CO', '424B2', '2014-05-30', 'edgar/data/66740/0001104659-14-042777.txt'), ('66740', '3M CO', '424B2', '2014-06-04', 'edgar/data/66740/0001104659-14-044032.txt'), ('66740', '3M CO', '4', '2014-05-01', 'edgar/data/66740/0001127602-14-015749.txt'), ('66740', '3M CO', '4', '2014-05-01', 'edgar/data/66740/0001127602-14-015755.txt'), ('66740', '3M CO', '4', '2014-05-02', 'edgar/data/66740/0001127602-14-016109.txt'), ('66740', '3M CO', '4', '2014-05-07', 'edgar/data/66740/0001127602-14-016681.txt'), ('66740', '3M CO', '4', '2014-05-07', 'edgar/data/66740/0001127602-14-016683.txt'), ('66740', '3M CO', '4', '2014-05-07', 'edgar/data/66740/0001127602-14-016686.txt'), ('66740', '3M CO', '4', '2014-05-07', 'edgar/data/66740/0001127602-14-016688.txt'), ('66740', '3M CO', '4', '2014-05-07', 'edgar/data/66740/0001127602-14-016690.txt'), ('66740', '3M CO', '4', '2014-05-14', 'edgar/data/66740/0001127602-14-017540.txt'), ('66740', '3M CO', '4', '2014-05-14', 'edgar/data/66740/0001127602-14-017542.txt'), ('66740', '3M CO', '4', '2014-05-14', 'edgar/data/66740/0001127602-14-017544.txt'), ('66740', '3M CO', '4', '2014-05-14', 'edgar/data/66740/0001127602-14-017548.txt'), ('66740', '3M CO', '4', '2014-05-14', 'edgar/data/66740/0001127602-14-017551.txt'), ('66740', '3M CO', '4', '2014-05-14', 'edgar/data/66740/0001127602-14-017553.txt'), ('66740', '3M CO', '4', '2014-05-14', 'edgar/data/66740/0001127602-14-017556.txt'), ('66740', '3M CO', '4', '2014-05-14', 'edgar/data/66740/0001127602-14-017561.txt'), ('66740', '3M CO', '4', '2014-05-14', 'edgar/data/66740/0001127602-14-017565.txt'), ('66740', '3M CO', '4', '2014-05-14', 'edgar/data/66740/0001127602-14-017569.txt'), ('66740', '3M CO', '4', '2014-05-14', 'edgar/data/66740/0001127602-14-017574.txt'), ('66740', '3M CO', '4', '2014-05-20', 'edgar/data/66740/0001127602-14-018175.txt'), ('66740', '3M CO', '4', '2014-06-03', 'edgar/data/66740/0001127602-14-019513.txt'), ('66740', '3M CO', '4', '2014-06-11', 'edgar/data/66740/0001127602-14-020617.txt'), ('66740', '3M CO', '8-K', '2014-04-08', 'edgar/data/66740/0001104659-14-026449.txt'), ('66740', '3M CO', '8-K', '2014-04-24', 'edgar/data/66740/0001104659-14-029727.txt'), ('66740', '3M CO', '8-K', '2014-05-14', 'edgar/data/66740/0001104659-14-038531.txt'), ('66740', '3M CO', '8-K', '2014-05-15', 'edgar/data/66740/0001104659-14-039325.txt'), ('66740', '3M CO', '8-K', '2014-05-16', 'edgar/data/66740/0001104659-14-039687.txt'), ('66740', '3M CO', '8-K', '2014-06-04', 'edgar/data/66740/0001104659-14-043981.txt'), ('66740', '3M CO', '8-K', '2014-06-09', 'edgar/data/66740/0001104659-14-044812.txt'), ('66740', '3M CO', '8-K', '2014-06-09', 'edgar/data/66740/0001104659-14-044814.txt'), ('66740', '3M CO', 'CORRESP', '2014-05-09', 'edgar/data/66740/0001104659-14-037034.txt'), ('66740', '3M CO', 'DEFA14A', '2014-04-15', 'edgar/data/66740/0001104659-14-027715.txt'), ('66740', '3M CO', 'FWP', '2014-05-29', 'edgar/data/66740/0001104659-14-042450.txt'), ('66740', '3M CO', 'S-3ASR', '2014-05-16', 'edgar/data/66740/0001104659-14-039616.txt'), ('66740', '3M CO', 'SD', '2014-06-02', 'edgar/data/66740/0001104659-14-043157.txt'), ('66740', '3M CO', 'UPLOAD', '2014-04-29', 'edgar/data/66740/0000000000-14-021652.txt'), ('66740', '3M CO', 'UPLOAD', '2014-05-15', 'edgar/data/66740/0000000000-14-024853.txt'), ('66740', '3M CO', '10-Q', '2014-07-31', 'edgar/data/66740/0001104659-14-055558.txt'), ('66740', '3M CO', '3', '2014-07-24', 'edgar/data/66740/0001127602-14-023771.txt'), ('66740', '3M CO', '3', '2014-08-12', 'edgar/data/66740/0001127602-14-025196.txt'), ('66740', '3M CO', '4/A', '2014-07-31', 'edgar/data/66740/0001127602-14-024300.txt'), ('66740', '3M CO', '4/A', '2014-07-31', 'edgar/data/66740/0001127602-14-024307.txt'), ('66740', '3M CO', '4', '2014-07-02', 'edgar/data/66740/0001127602-14-022293.txt'), ('66740', '3M CO', '4', '2014-07-30', 'edgar/data/66740/0001127602-14-024173.txt'), ('66740', '3M CO', '4', '2014-07-30', 'edgar/data/66740/0001127602-14-024175.txt'), ('66740', '3M CO', '4', '2014-08-01', 'edgar/data/66740/0001127602-14-024374.txt'), ('66740', '3M CO', '4', '2014-08-06', 'edgar/data/66740/0001127602-14-024880.txt'), ('66740', '3M CO', '4', '2014-08-06', 'edgar/data/66740/0001127602-14-024882.txt'), ('66740', '3M CO', '4', '2014-08-06', 'edgar/data/66740/0001127602-14-024885.txt'), ('66740', '3M CO', '4', '2014-08-13', 'edgar/data/66740/0001127602-14-025541.txt'), ('66740', '3M CO', '4', '2014-08-13', 'edgar/data/66740/0001127602-14-025543.txt'), ('66740', '3M CO', '4', '2014-08-13', 'edgar/data/66740/0001127602-14-025545.txt'), ('66740', '3M CO', '4', '2014-08-13', 'edgar/data/66740/0001127602-14-025547.txt'), ('66740', '3M CO', '4', '2014-08-13', 'edgar/data/66740/0001127602-14-025550.txt'), ('66740', '3M CO', '4', '2014-08-13', 'edgar/data/66740/0001127602-14-025554.txt'), ('66740', '3M CO', '4', '2014-08-13', 'edgar/data/66740/0001127602-14-025556.txt'), ('66740', '3M CO', '4', '2014-09-03', 'edgar/data/66740/0001127602-14-027130.txt'), ('66740', '3M CO', '8-K', '2014-07-24', 'edgar/data/66740/0001104659-14-053127.txt'), ('66740', '3M CO', '8-K', '2014-08-08', 'edgar/data/66740/0001104659-14-058719.txt'), ('66740', '3M CO', '8-K', '2014-08-12', 'edgar/data/66740/0001104659-14-059840.txt'), ('66740', '3M CO', '10-Q', '2014-10-30', 'edgar/data/66740/0001104659-14-075312.txt'), ('66740', '3M CO', '3', '2014-11-26', 'edgar/data/66740/0001127602-14-033517.txt'), ('66740', '3M CO', '4/A', '2014-10-31', 'edgar/data/66740/0001127602-14-030641.txt'), ('66740', '3M CO', '4/A', '2014-10-31', 'edgar/data/66740/0001127602-14-030646.txt'), ('66740', '3M CO', '424B2', '2014-11-05', 'edgar/data/66740/0001047469-14-008830.txt'), ('66740', '3M CO', '424B2', '2014-11-06', 'edgar/data/66740/0001047469-14-008921.txt'), ('66740', '3M CO', '4', '2014-10-29', 'edgar/data/66740/0001127602-14-030449.txt'), ('66740', '3M CO', '4', '2014-10-30', 'edgar/data/66740/0001127602-14-030499.txt'), ('66740', '3M CO', '4', '2014-10-30', 'edgar/data/66740/0001127602-14-030503.txt'), ('66740', '3M CO', '4', '2014-10-30', 'edgar/data/66740/0001127602-14-030505.txt'), ('66740', '3M CO', '4', '2014-10-30', 'edgar/data/66740/0001127602-14-030539.txt'), ('66740', '3M CO', '4', '2014-10-30', 'edgar/data/66740/0001127602-14-030541.txt'), ('66740', '3M CO', '4', '2014-11-05', 'edgar/data/66740/0001127602-14-031173.txt'), ('66740', '3M CO', '4', '2014-11-12', 'edgar/data/66740/0001127602-14-031934.txt'), ('66740', '3M CO', '4', '2014-11-12', 'edgar/data/66740/0001127602-14-031936.txt'), ('66740', '3M CO', '4', '2014-11-12', 'edgar/data/66740/0001127602-14-031938.txt'), ('66740', '3M CO', '4', '2014-11-12', 'edgar/data/66740/0001127602-14-031942.txt'), ('66740', '3M CO', '4', '2014-11-12', 'edgar/data/66740/0001127602-14-031945.txt'), ('66740', '3M CO', '4', '2014-11-12', 'edgar/data/66740/0001127602-14-031949.txt'), ('66740', '3M CO', '4', '2014-12-03', 'edgar/data/66740/0001127602-14-034160.txt'), ('66740', '3M CO', '4', '2014-12-03', 'edgar/data/66740/0001127602-14-034165.txt'), ('66740', '3M CO', '4', '2014-12-03', 'edgar/data/66740/0001127602-14-034167.txt'), ('66740', '3M CO', '4', '2014-12-03', 'edgar/data/66740/0001127602-14-034169.txt'), ('66740', '3M CO', '8-A12B', '2014-11-10', 'edgar/data/66740/0001104659-14-078910.txt'), ('66740', '3M CO', '8-K', '2014-10-23', 'edgar/data/66740/0001104659-14-073202.txt'), ('66740', '3M CO', '8-K', '2014-11-10', 'edgar/data/66740/0001104659-14-078911.txt'), ('66740', '3M CO', '8-K', '2014-12-16', 'edgar/data/66740/0001104659-14-086883.txt'), ('66740', '3M CO', 'CERTNYS', '2014-11-12', 'edgar/data/66740/9999999997-14-014956.txt'), ('66740', '3M CO', 'FWP', '2014-11-05', 'edgar/data/66740/0001104659-14-077121.txt'), ('66740', '3M CO', 'NO ACT', '2014-12-31', 'edgar/data/66740/9999999997-15-000142.txt'), ('66740', '3M CO', '10-K', '2015-02-12', 'edgar/data/66740/0001104659-15-009560.txt'), ('66740', '3M CO', '3/A', '2015-01-07', 'edgar/data/66740/0001127602-15-001307.txt'), ('66740', '3M CO', '3', '2015-01-07', 'edgar/data/66740/0001127602-15-001303.txt'), ('66740', '3M CO', '4/A', '2015-01-06', 'edgar/data/66740/0001127602-15-001192.txt'), ('66740', '3M CO', '4/A', '2015-01-06', 'edgar/data/66740/0001127602-15-001202.txt'), ('66740', '3M CO', '4/A', '2015-02-18', 'edgar/data/66740/0001127602-15-006552.txt'), ('66740', '3M CO', '4/A', '2015-02-18', 'edgar/data/66740/0001127602-15-006554.txt'), ('66740', '3M CO', '4/A', '2015-02-18', 'edgar/data/66740/0001127602-15-006556.txt'), ('66740', '3M CO', '4/A', '2015-02-18', 'edgar/data/66740/0001127602-15-006558.txt'), ('66740', '3M CO', '4/A', '2015-02-18', 'edgar/data/66740/0001127602-15-006561.txt'), ('66740', '3M CO', '4/A', '2015-02-18', 'edgar/data/66740/0001127602-15-006564.txt'), ('66740', '3M CO', '4/A', '2015-02-18', 'edgar/data/66740/0001127602-15-006566.txt'), ('66740', '3M CO', '4/A', '2015-02-18', 'edgar/data/66740/0001127602-15-006573.txt'), ('66740', '3M CO', '4/A', '2015-02-18', 'edgar/data/66740/0001127602-15-006575.txt'), ('66740', '3M CO', '4', '2015-02-04', 'edgar/data/66740/0001127602-15-004276.txt'), ('66740', '3M CO', '4', '2015-02-04', 'edgar/data/66740/0001127602-15-004278.txt'), ('66740', '3M CO', '4', '2015-02-04', 'edgar/data/66740/0001127602-15-004280.txt'), ('66740', '3M CO', '4', '2015-02-04', 'edgar/data/66740/0001127602-15-004284.txt'), ('66740', '3M CO', '4', '2015-02-04', 'edgar/data/66740/0001127602-15-004286.txt'), ('66740', '3M CO', '4', '2015-02-04', 'edgar/data/66740/0001127602-15-004289.txt'), ('66740', '3M CO', '4', '2015-02-05', 'edgar/data/66740/0001127602-15-004463.txt'), ('66740', '3M CO', '4', '2015-02-05', 'edgar/data/66740/0001127602-15-004465.txt'), ('66740', '3M CO', '4', '2015-02-05', 'edgar/data/66740/0001127602-15-004469.txt'), ('66740', '3M CO', '4', '2015-02-05', 'edgar/data/66740/0001127602-15-004475.txt'), ('66740', '3M CO', '4', '2015-02-05', 'edgar/data/66740/0001127602-15-004482.txt'), ('66740', '3M CO', '4', '2015-02-05', 'edgar/data/66740/0001127602-15-004489.txt'), ('66740', '3M CO', '4', '2015-02-05', 'edgar/data/66740/0001127602-15-004494.txt'), ('66740', '3M CO', '4', '2015-02-05', 'edgar/data/66740/0001127602-15-004500.txt'), ('66740', '3M CO', '4', '2015-02-05', 'edgar/data/66740/0001127602-15-004502.txt'), ('66740', '3M CO', '4', '2015-02-05', 'edgar/data/66740/0001127602-15-004510.txt'), ('66740', '3M CO', '4', '2015-02-05', 'edgar/data/66740/0001127602-15-004514.txt'), ('66740', '3M CO', '4', '2015-02-05', 'edgar/data/66740/0001127602-15-004524.txt'), ('66740', '3M CO', '4', '2015-02-05', 'edgar/data/66740/0001127602-15-004531.txt'), ('66740', '3M CO', '4', '2015-02-05', 'edgar/data/66740/0001127602-15-004537.txt'), ('66740', '3M CO', '4', '2015-02-05', 'edgar/data/66740/0001127602-15-004542.txt'), ('66740', '3M CO', '4', '2015-02-05', 'edgar/data/66740/0001127602-15-004552.txt'), ('66740', '3M CO', '4', '2015-02-05', 'edgar/data/66740/0001127602-15-004562.txt'), ('66740', '3M CO', '4', '2015-02-05', 'edgar/data/66740/0001127602-15-004566.txt'), ('66740', '3M CO', '4', '2015-02-06', 'edgar/data/66740/0001127602-15-004781.txt'), ('66740', '3M CO', '4', '2015-02-06', 'edgar/data/66740/0001127602-15-004785.txt'), ('66740', '3M CO', '4', '2015-02-06', 'edgar/data/66740/0001127602-15-004794.txt'), ('66740', '3M CO', '4', '2015-02-06', 'edgar/data/66740/0001127602-15-004801.txt'), ('66740', '3M CO', '4', '2015-02-06', 'edgar/data/66740/0001127602-15-004805.txt'), ('66740', '3M CO', '4', '2015-02-06', 'edgar/data/66740/0001127602-15-004812.txt'), ('66740', '3M CO', '4', '2015-02-06', 'edgar/data/66740/0001127602-15-004815.txt'), ('66740', '3M CO', '4', '2015-02-06', 'edgar/data/66740/0001127602-15-004818.txt'), ('66740', '3M CO', '4', '2015-02-09', 'edgar/data/66740/0001127602-15-004936.txt'), ('66740', '3M CO', '4', '2015-02-10', 'edgar/data/66740/0001127602-15-005235.txt'), ('66740', '3M CO', '5', '2015-01-07', 'edgar/data/66740/0001127602-15-001338.txt'), ('66740', '3M CO', '5', '2015-01-07', 'edgar/data/66740/0001127602-15-001344.txt'), ('66740', '3M CO', '8-K', '2015-01-27', 'edgar/data/66740/0001104659-15-004598.txt'), ('66740', '3M CO', '8-K', '2015-02-23', 'edgar/data/66740/0001104659-15-012994.txt'), ('66740', '3M CO', 'ARS', '2015-03-26', 'edgar/data/66740/9999999997-15-007536.txt'), ('66740', '3M CO', 'DEF 14A', '2015-03-25', 'edgar/data/66740/0001047469-15-002717.txt'), ('66740', '3M CO', 'DEFA14A', '2015-03-25', 'edgar/data/66740/0001104659-15-022698.txt'), ('66740', '3M CO', 'DEFA14A', '2015-03-27', 'edgar/data/66740/0001104659-15-023513.txt'), ('66740', '3M CO', 'SC 13G/A', '2015-02-09', 'edgar/data/66740/0000215457-15-000087.txt'), ('66740', '3M CO', 'SC 13G/A', '2015-02-10', 'edgar/data/66740/0000932471-15-003606.txt'), ('66740', '3M CO', 'SC 13G', '2015-02-12', 'edgar/data/66740/0001519058-15-000161.txt'), ('66740', '3M CO', '10-Q', '2015-04-30', 'edgar/data/66740/0001104659-15-032226.txt'), ('66740', '3M CO', '11-K/A', '2015-06-29', 'edgar/data/66740/0001104659-15-048479.txt'), ('66740', '3M CO', '11-K', '2015-06-29', 'edgar/data/66740/0001104659-15-048483.txt'), ('66740', '3M CO', '4/A', '2015-06-03', 'edgar/data/66740/0001127602-15-019572.txt'), ('66740', '3M CO', '424B2', '2015-05-13', 'edgar/data/66740/0001047469-15-004692.txt'), ('66740', '3M CO', '424B2', '2015-05-14', 'edgar/data/66740/0001047469-15-004778.txt'), ('66740', '3M CO', '4', '2015-05-14', 'edgar/data/66740/0001127602-15-017212.txt'), ('66740', '3M CO', '4', '2015-05-14', 'edgar/data/66740/0001127602-15-017214.txt'), ('66740', '3M CO', '4', '2015-05-14', 'edgar/data/66740/0001127602-15-017216.txt'), ('66740', '3M CO', '4', '2015-05-14', 'edgar/data/66740/0001127602-15-017218.txt'), ('66740', '3M CO', '4', '2015-05-14', 'edgar/data/66740/0001127602-15-017220.txt'), ('66740', '3M CO', '4', '2015-05-14', 'edgar/data/66740/0001127602-15-017222.txt'), ('66740', '3M CO', '4', '2015-05-14', 'edgar/data/66740/0001127602-15-017224.txt'), ('66740', '3M CO', '4', '2015-05-14', 'edgar/data/66740/0001127602-15-017226.txt'), ('66740', '3M CO', '4', '2015-05-14', 'edgar/data/66740/0001127602-15-017228.txt'), ('66740', '3M CO', '4', '2015-05-18', 'edgar/data/66740/0001127602-15-017579.txt'), ('66740', '3M CO', '4', '2015-06-03', 'edgar/data/66740/0001127602-15-019568.txt'), ('66740', '3M CO', '4', '2015-06-03', 'edgar/data/66740/0001127602-15-019570.txt'), ('66740', '3M CO', '8-A12B', '2015-05-18', 'edgar/data/66740/0001104659-15-038964.txt'), ('66740', '3M CO', '8-K', '2015-04-23', 'edgar/data/66740/0001104659-15-029530.txt'), ('66740', '3M CO', '8-K', '2015-05-13', 'edgar/data/66740/0001104659-15-037720.txt'), ('66740', '3M CO', '8-K', '2015-05-18', 'edgar/data/66740/0001104659-15-038992.txt'), ('66740', '3M CO', '8-K', '2015-06-24', 'edgar/data/66740/0000903423-15-000399.txt'), ('66740', '3M CO', 'CERTNYS', '2015-05-19', 'edgar/data/66740/9999999997-15-009942.txt'), ('66740', '3M CO', 'CORRESP', '2015-04-13', 'edgar/data/66740/0001104659-15-027292.txt'), ('66740', '3M CO', 'DEFA14A', '2015-04-27', 'edgar/data/66740/0001104659-15-030595.txt'), ('66740', '3M CO', 'FWP', '2015-05-13', 'edgar/data/66740/0001104659-15-037718.txt'), ('66740', '3M CO', 'SD', '2015-06-01', 'edgar/data/66740/0001104659-15-042396.txt'), ('66740', '3M CO', 'UPLOAD', '2015-04-01', 'edgar/data/66740/0000000000-15-019049.txt'), ('66740', '3M CO', 'UPLOAD', '2015-04-16', 'edgar/data/66740/0000000000-15-021544.txt'), ('66740', '3M CO', '10-Q', '2015-07-30', 'edgar/data/66740/0001104659-15-054810.txt'), ('66740', '3M CO', '3', '2015-08-13', 'edgar/data/66740/0001127602-15-024834.txt'), ('66740', '3M CO', '4/A', '2015-09-09', 'edgar/data/66740/0001127602-15-026740.txt'), ('66740', '3M CO', '424B2', '2015-08-05', 'edgar/data/66740/0001104659-15-056455.txt'), ('66740', '3M CO', '4', '2015-08-13', 'edgar/data/66740/0001127602-15-024836.txt'), ('66740', '3M CO', '4', '2015-08-13', 'edgar/data/66740/0001127602-15-024838.txt'), ('66740', '3M CO', '4', '2015-08-13', 'edgar/data/66740/0001127602-15-024840.txt'), ('66740', '3M CO', '4', '2015-08-13', 'edgar/data/66740/0001127602-15-024842.txt'), ('66740', '3M CO', '4', '2015-08-13', 'edgar/data/66740/0001127602-15-024844.txt'), ('66740', '3M CO', '4', '2015-08-13', 'edgar/data/66740/0001127602-15-024846.txt'), ('66740', '3M CO', '4', '2015-08-13', 'edgar/data/66740/0001127602-15-024849.txt'), ('66740', '3M CO', '4', '2015-09-03', 'edgar/data/66740/0001127602-15-026512.txt'), ('66740', '3M CO', '4', '2015-09-03', 'edgar/data/66740/0001127602-15-026514.txt'), ('66740', '3M CO', '4', '2015-09-03', 'edgar/data/66740/0001127602-15-026516.txt'), ('66740', '3M CO', '4', '2015-09-03', 'edgar/data/66740/0001127602-15-026519.txt'), ('66740', '3M CO', '8-K', '2015-07-23', 'edgar/data/66740/0001104659-15-052731.txt'), ('66740', '3M CO', '8-K', '2015-08-04', 'edgar/data/66740/0001104659-15-055789.txt'), ('66740', '3M CO', '8-K', '2015-08-07', 'edgar/data/66740/0001104659-15-057617.txt'), ('66740', '3M CO', '8-K', '2015-08-10', 'edgar/data/66740/0001104659-15-058019.txt'), ('66740', '3M CO', '8-K', '2015-08-26', 'edgar/data/66740/0001104659-15-061821.txt'), ('66740', '3M CO', '8-K', '2015-09-10', 'edgar/data/66740/0001104659-15-064478.txt'), ('66740', '3M CO', 'FWP', '2015-08-04', 'edgar/data/66740/0001104659-15-055942.txt'), ('66740', '3M CO', '10-Q', '2015-10-29', 'edgar/data/66740/0001558370-15-002024.txt'), ('66740', '3M CO', '4', '2015-10-13', 'edgar/data/66740/0001127602-15-029025.txt'), ('66740', '3M CO', '4', '2015-10-28', 'edgar/data/66740/0001127602-15-029658.txt'), ('66740', '3M CO', '4', '2015-10-28', 'edgar/data/66740/0001127602-15-029660.txt'), ('66740', '3M CO', '4', '2015-10-29', 'edgar/data/66740/0001127602-15-029737.txt'), ('66740', '3M CO', '4', '2015-10-29', 'edgar/data/66740/0001127602-15-029771.txt'), ('66740', '3M CO', '4', '2015-11-03', 'edgar/data/66740/0001127602-15-030055.txt'), ('66740', '3M CO', '4', '2015-11-03', 'edgar/data/66740/0001127602-15-030058.txt'), ('66740', '3M CO', '4', '2015-11-06', 'edgar/data/66740/0001127602-15-030499.txt'), ('66740', '3M CO', '4', '2015-11-06', 'edgar/data/66740/0001127602-15-030508.txt'), ('66740', '3M CO', '4', '2015-11-12', 'edgar/data/66740/0001127602-15-031100.txt'), ('66740', '3M CO', '4', '2015-11-12', 'edgar/data/66740/0001127602-15-031102.txt'), ('66740', '3M CO', '4', '2015-11-12', 'edgar/data/66740/0001127602-15-031105.txt'), ('66740', '3M CO', '4', '2015-11-12', 'edgar/data/66740/0001127602-15-031107.txt'), ('66740', '3M CO', '4', '2015-11-12', 'edgar/data/66740/0001127602-15-031110.txt'), ('66740', '3M CO', '4', '2015-11-12', 'edgar/data/66740/0001127602-15-031112.txt'), ('66740', '3M CO', '4', '2015-11-24', 'edgar/data/66740/0001127602-15-032435.txt'), ('66740', '3M CO', '4', '2015-12-10', 'edgar/data/66740/0001127602-15-033710.txt'), ('66740', '3M CO', '8-K', '2015-10-22', 'edgar/data/66740/0001104659-15-072044.txt'), ('66740', '3M CO', '8-K', '2015-11-05', 'edgar/data/66740/0001104659-15-076256.txt'), ('66740', '3M CO', '8-K', '2015-11-06', 'edgar/data/66740/0001104659-15-076736.txt'), ('66740', '3M CO', '8-K', '2015-11-10', 'edgar/data/66740/0001104659-15-077663.txt'), ('66740', '3M CO', '8-K', '2015-12-15', 'edgar/data/66740/0001104659-15-084790.txt'), ('66740', '3M CO', 'S-8 POS', '2015-12-03', 'edgar/data/66740/0001104659-15-082715.txt'), ('66740', '3M CO', '10-K', '2016-02-11', 'edgar/data/66740/0001558370-16-003162.txt'), ('66740', '3M CO', '3', '2016-01-06', 'edgar/data/66740/0001127602-16-036249.txt'), ('66740', '3M CO', '3', '2016-02-03', 'edgar/data/66740/0001127602-16-039258.txt'), ('66740', '3M CO', '3', '2016-02-04', 'edgar/data/66740/0001127602-16-039424.txt'), ('66740', '3M CO', '4/A', '2016-01-22', 'edgar/data/66740/0001127602-16-037631.txt'), ('66740', '3M CO', '4/A', '2016-02-11', 'edgar/data/66740/0001127602-16-040508.txt'), ('66740', '3M CO', '4/A', '2016-02-11', 'edgar/data/66740/0001127602-16-040517.txt'), ('66740', '3M CO', '4/A', '2016-02-11', 'edgar/data/66740/0001127602-16-040525.txt'), ('66740', '3M CO', '4/A', '2016-02-11', 'edgar/data/66740/0001127602-16-040540.txt'), ('66740', '3M CO', '4/A', '2016-02-12', 'edgar/data/66740/0001127602-16-040786.txt'), ('66740', '3M CO', '4/A', '2016-02-12', 'edgar/data/66740/0001127602-16-040789.txt'), ('66740', '3M CO', '4', '2016-02-03', 'edgar/data/66740/0001127602-16-039231.txt'), ('66740', '3M CO', '4', '2016-02-03', 'edgar/data/66740/0001127602-16-039234.txt'), ('66740', '3M CO', '4', '2016-02-03', 'edgar/data/66740/0001127602-16-039236.txt'), ('66740', '3M CO', '4', '2016-02-03', 'edgar/data/66740/0001127602-16-039241.txt'), ('66740', '3M CO', '4', '2016-02-03', 'edgar/data/66740/0001127602-16-039243.txt'), ('66740', '3M CO', '4', '2016-02-03', 'edgar/data/66740/0001127602-16-039271.txt'), ('66740', '3M CO', '4', '2016-02-04', 'edgar/data/66740/0001127602-16-039513.txt'), ('66740', '3M CO', '4', '2016-02-04', 'edgar/data/66740/0001127602-16-039515.txt'), ('66740', '3M CO', '4', '2016-02-04', 'edgar/data/66740/0001127602-16-039517.txt'), ('66740', '3M CO', '4', '2016-02-04', 'edgar/data/66740/0001127602-16-039519.txt'), ('66740', '3M CO', '4', '2016-02-04', 'edgar/data/66740/0001127602-16-039523.txt'), ('66740', '3M CO', '4', '2016-02-04', 'edgar/data/66740/0001127602-16-039525.txt'), ('66740', '3M CO', '4', '2016-02-04', 'edgar/data/66740/0001127602-16-039529.txt'), ('66740', '3M CO', '4', '2016-02-04', 'edgar/data/66740/0001127602-16-039532.txt'), ('66740', '3M CO', '4', '2016-02-04', 'edgar/data/66740/0001127602-16-039534.txt'), ('66740', '3M CO', '4', '2016-02-04', 'edgar/data/66740/0001127602-16-039536.txt'), ('66740', '3M CO', '4', '2016-02-04', 'edgar/data/66740/0001127602-16-039540.txt'), ('66740', '3M CO', '4', '2016-02-04', 'edgar/data/66740/0001127602-16-039543.txt'), ('66740', '3M CO', '4', '2016-02-04', 'edgar/data/66740/0001127602-16-039570.txt'), ('66740', '3M CO', '4', '2016-02-04', 'edgar/data/66740/0001127602-16-039584.txt'), ('66740', '3M CO', '4', '2016-02-04', 'edgar/data/66740/0001127602-16-039596.txt'), ('66740', '3M CO', '4', '2016-02-04', 'edgar/data/66740/0001127602-16-039613.txt'), ('66740', '3M CO', '4', '2016-02-04', 'edgar/data/66740/0001127602-16-039620.txt'), ('66740', '3M CO', '4', '2016-02-09', 'edgar/data/66740/0001127602-16-040118.txt'), ('66740', '3M CO', '4', '2016-02-11', 'edgar/data/66740/0001127602-16-040596.txt'), ('66740', '3M CO', '4', '2016-02-17', 'edgar/data/66740/0001127602-16-041733.txt'), ('66740', '3M CO', '4', '2016-02-17', 'edgar/data/66740/0001127602-16-041735.txt'), ('66740', '3M CO', '4', '2016-02-17', 'edgar/data/66740/0001127602-16-041737.txt'), ('66740', '3M CO', '4', '2016-02-19', 'edgar/data/66740/0001127602-16-042331.txt'), ('66740', '3M CO', '4', '2016-02-19', 'edgar/data/66740/0001127602-16-042354.txt'), ('66740', '3M CO', '4', '2016-02-25', 'edgar/data/66740/0001127602-16-043308.txt'), ('66740', '3M CO', '5', '2016-01-22', 'edgar/data/66740/0001127602-16-037620.txt'), ('66740', '3M CO', '8-K', '2016-01-26', 'edgar/data/66740/0001104659-16-091334.txt'), ('66740', '3M CO', '8-K', '2016-02-02', 'edgar/data/66740/0001104659-16-093125.txt'), ('66740', '3M CO', '8-K', '2016-02-03', 'edgar/data/66740/0001104659-16-093509.txt'), ('66740', '3M CO', '8-K', '2016-03-11', 'edgar/data/66740/0001104659-16-104498.txt'), ('66740', '3M CO', '8-K', '2016-03-15', 'edgar/data/66740/0001558370-16-004144.txt'), ('66740', '3M CO', '8-K', '2016-03-29', 'edgar/data/66740/0001104659-16-108099.txt'), ('66740', '3M CO', 'DEF 14A', '2016-03-23', 'edgar/data/66740/0001206774-16-005067.txt'), ('66740', '3M CO', 'DEFA14A', '2016-03-23', 'edgar/data/66740/0001206774-16-005068.txt'), ('66740', '3M CO', 'DEFA14A', '2016-03-25', 'edgar/data/66740/0001206774-16-005095.txt'), ('66740', '3M CO', 'NO ACT', '2016-01-19', 'edgar/data/66740/9999999997-16-016642.txt'), ('66740', '3M CO', 'SC 13G/A', '2016-02-10', 'edgar/data/66740/0000215457-16-005427.txt'), ('66740', '3M CO', 'SC 13G/A', '2016-02-10', 'edgar/data/66740/0000932471-16-010562.txt'), ('66740', '3M CO', 'SC 13G/A', '2016-02-12', 'edgar/data/66740/0000093751-16-000277.txt'), ('66740', '3M CO', '10-Q', '2016-05-03', 'edgar/data/66740/0001558370-16-005213.txt'), ('66740', '3M CO', '11-K', '2016-06-28', 'edgar/data/66740/0001104659-16-129747.txt'), ('66740', '3M CO', '424B2', '2016-05-23', 'edgar/data/66740/0001047469-16-013354.txt'), ('66740', '3M CO', '424B2', '2016-05-25', 'edgar/data/66740/0001047469-16-013423.txt'), ('66740', '3M CO', '424B5', '2016-05-19', 'edgar/data/66740/0001104659-16-122100.txt'), ('66740', '3M CO', '4', '2016-04-20', 'edgar/data/66740/0001127602-16-049557.txt'), ('66740', '3M CO', '4', '2016-05-04', 'edgar/data/66740/0001127602-16-050969.txt'), ('66740', '3M CO', '4', '2016-05-05', 'edgar/data/66740/0001127602-16-051200.txt'), ('66740', '3M CO', '4', '2016-05-06', 'edgar/data/66740/0001127602-16-051332.txt'), ('66740', '3M CO', '4', '2016-05-12', 'edgar/data/66740/0001127602-16-051852.txt'), ('66740', '3M CO', '4', '2016-05-12', 'edgar/data/66740/0001127602-16-051855.txt'), ('66740', '3M CO', '4', '2016-05-12', 'edgar/data/66740/0001127602-16-051858.txt'), ('66740', '3M CO', '4', '2016-05-12', 'edgar/data/66740/0001127602-16-051871.txt'), ('66740', '3M CO', '4', '2016-05-12', 'edgar/data/66740/0001127602-16-051877.txt'), ('66740', '3M CO', '4', '2016-05-12', 'edgar/data/66740/0001127602-16-051879.txt'), ('66740', '3M CO', '4', '2016-05-12', 'edgar/data/66740/0001127602-16-051881.txt'), ('66740', '3M CO', '4', '2016-05-12', 'edgar/data/66740/0001127602-16-051883.txt'), ('66740', '3M CO', '4', '2016-05-12', 'edgar/data/66740/0001127602-16-051885.txt'), ('66740', '3M CO', '4', '2016-05-12', 'edgar/data/66740/0001127602-16-051887.txt'), ('66740', '3M CO', '4', '2016-05-12', 'edgar/data/66740/0001127602-16-051893.txt'), ('66740', '3M CO', '4', '2016-05-12', 'edgar/data/66740/0001127602-16-051897.txt'), ('66740', '3M CO', '4', '2016-05-12', 'edgar/data/66740/0001127602-16-051900.txt'), ('66740', '3M CO', '4', '2016-05-12', 'edgar/data/66740/0001127602-16-051903.txt'), ('66740', '3M CO', '4', '2016-05-12', 'edgar/data/66740/0001127602-16-051905.txt'), ('66740', '3M CO', '4', '2016-05-13', 'edgar/data/66740/0001127602-16-052084.txt'), ('66740', '3M CO', '4', '2016-05-13', 'edgar/data/66740/0001127602-16-052118.txt'), ('66740', '3M CO', '4', '2016-06-06', 'edgar/data/66740/0001127602-16-054810.txt'), ('66740', '3M CO', '4', '2016-06-06', 'edgar/data/66740/0001127602-16-054812.txt'), ('66740', '3M CO', '8-A12B', '2016-05-26', 'edgar/data/66740/0001104659-16-123652.txt'), ('66740', '3M CO', '8-K', '2016-04-26', 'edgar/data/66740/0001104659-16-113961.txt'), ('66740', '3M CO', '8-K', '2016-05-11', 'edgar/data/66740/0001104659-16-120065.txt'), ('66740', '3M CO', '8-K', '2016-05-12', 'edgar/data/66740/0001104659-16-120442.txt'), ('66740', '3M CO', '8-K', '2016-05-17', 'edgar/data/66740/0001558370-16-006059.txt'), ('66740', '3M CO', '8-K', '2016-05-19', 'edgar/data/66740/0001104659-16-122104.txt'), ('66740', '3M CO', '8-K', '2016-05-26', 'edgar/data/66740/0001104659-16-123653.txt'), ('66740', '3M CO', 'CERTNYS', '2016-05-26', 'edgar/data/66740/9999999997-16-023217.txt'), ('66740', '3M CO', 'DEFA14A', '2016-04-14', 'edgar/data/66740/0001104659-16-111507.txt'), ('66740', '3M CO', 'DEFA14A', '2016-04-29', 'edgar/data/66740/0001104659-16-115619.txt'), ('66740', '3M CO', 'FWP', '2016-05-23', 'edgar/data/66740/0001104659-16-122654.txt'), ('66740', '3M CO', 'S-8', '2016-05-18', 'edgar/data/66740/0001104659-16-121794.txt'), ('66740', '3M CO', 'SD', '2016-05-27', 'edgar/data/66740/0001104659-16-123835.txt'), ('66740', '3M CO', '10-Q', '2016-08-02', 'edgar/data/66740/0001558370-16-007105.txt'), ('66740', '3M CO', '4/A', '2016-09-08', 'edgar/data/66740/0001127602-16-062177.txt'), ('66740', '3M CO', '424B2', '2016-09-15', 'edgar/data/66740/0001104659-16-144893.txt'), ('66740', '3M CO', '4', '2016-08-01', 'edgar/data/66740/0001127602-16-059083.txt'), ('66740', '3M CO', '4', '2016-08-01', 'edgar/data/66740/0001127602-16-059092.txt'), ('66740', '3M CO', '4', '2016-08-02', 'edgar/data/66740/0001127602-16-059211.txt'), ('66740', '3M CO', '4', '2016-08-02', 'edgar/data/66740/0001127602-16-059290.txt'), ('66740', '3M CO', '4', '2016-08-10', 'edgar/data/66740/0001127602-16-059972.txt'), ('66740', '3M CO', '4', '2016-08-10', 'edgar/data/66740/0001127602-16-059974.txt'), ('66740', '3M CO', '4', '2016-08-10', 'edgar/data/66740/0001127602-16-059976.txt'), ('66740', '3M CO', '4', '2016-08-10', 'edgar/data/66740/0001127602-16-059978.txt'), ('66740', '3M CO', '4', '2016-08-10', 'edgar/data/66740/0001127602-16-059980.txt'), ('66740', '3M CO', '4', '2016-08-10', 'edgar/data/66740/0001127602-16-059982.txt'), ('66740', '3M CO', '4', '2016-08-10', 'edgar/data/66740/0001127602-16-059984.txt'), ('66740', '3M CO', '4', '2016-09-06', 'edgar/data/66740/0001127602-16-061862.txt'), ('66740', '3M CO', '4', '2016-09-06', 'edgar/data/66740/0001127602-16-061864.txt'), ('66740', '3M CO', '8-K', '2016-07-26', 'edgar/data/66740/0001104659-16-134253.txt'), ('66740', '3M CO', '8-K', '2016-09-19', 'edgar/data/66740/0001104659-16-145376.txt'), ('66740', '3M CO', 'FWP', '2016-09-15', 'edgar/data/66740/0001104659-16-144700.txt'), ('66740', '3M CO', '10-Q', '2016-11-01', 'edgar/data/66740/0001558370-16-008937.txt'), ('66740', '3M CO', '4', '2016-11-02', 'edgar/data/66740/0001127602-16-065866.txt'), ('66740', '3M CO', '4', '2016-11-08', 'edgar/data/66740/0001127602-16-066334.txt'), ('66740', '3M CO', '4', '2016-11-08', 'edgar/data/66740/0001127602-16-066337.txt'), ('66740', '3M CO', '4', '2016-11-09', 'edgar/data/66740/0001127602-16-066578.txt'), ('66740', '3M CO', '4', '2016-11-09', 'edgar/data/66740/0001127602-16-066589.txt'), ('66740', '3M CO', '4', '2016-11-09', 'edgar/data/66740/0001127602-16-066591.txt'), ('66740', '3M CO', '4', '2016-11-09', 'edgar/data/66740/0001127602-16-066594.txt'), ('66740', '3M CO', '4', '2016-11-09', 'edgar/data/66740/0001127602-16-066596.txt'), ('66740', '3M CO', '4', '2016-11-09', 'edgar/data/66740/0001127602-16-066598.txt'), ('66740', '3M CO', '4', '2016-11-09', 'edgar/data/66740/0001127602-16-066600.txt'), ('66740', '3M CO', '4', '2016-11-15', 'edgar/data/66740/0001127602-16-067164.txt'), ('66740', '3M CO', '4', '2016-11-17', 'edgar/data/66740/0001127602-16-067517.txt'), ('66740', '3M CO', '4', '2016-11-18', 'edgar/data/66740/0001127602-16-067701.txt'), ('66740', '3M CO', '4', '2016-12-08', 'edgar/data/66740/0001127602-16-069469.txt'), ('66740', '3M CO', '4', '2016-12-14', 'edgar/data/66740/0001127602-16-069967.txt'), ('66740', '3M CO', '8-K', '2016-10-25', 'edgar/data/66740/0001104659-16-151786.txt'), ('66740', '3M CO', '8-K', '2016-11-15', 'edgar/data/66740/0001104659-16-157269.txt'), ('66740', '3M CO', '8-K', '2016-11-17', 'edgar/data/66740/0001104659-16-157839.txt'), ('66740', '3M CO', '8-K', '2016-12-13', 'edgar/data/66740/0001104659-16-161775.txt'), ('66740', '3M CO', '10-K', '2017-02-09', 'edgar/data/66740/0001558370-17-000479.txt'), ('66740', '3M CO', '4/A', '2017-02-09', 'edgar/data/66740/0001127602-17-004847.txt'), ('66740', '3M CO', '4/A', '2017-02-09', 'edgar/data/66740/0001127602-17-004849.txt'), ('66740', '3M CO', '4/A', '2017-02-09', 'edgar/data/66740/0001127602-17-004851.txt'), ('66740', '3M CO', '4/A', '2017-02-09', 'edgar/data/66740/0001127602-17-004853.txt'), ('66740', '3M CO', '4/A', '2017-02-09', 'edgar/data/66740/0001127602-17-004856.txt'), ('66740', '3M CO', '4/A', '2017-02-09', 'edgar/data/66740/0001127602-17-004858.txt'), ('66740', '3M CO', '4/A', '2017-02-09', 'edgar/data/66740/0001127602-17-004860.txt'), ('66740', '3M CO', '4/A', '2017-02-09', 'edgar/data/66740/0001127602-17-004862.txt'), ('66740', '3M CO', '4/A', '2017-02-09', 'edgar/data/66740/0001127602-17-004864.txt'), ('66740', '3M CO', '4/A', '2017-02-09', 'edgar/data/66740/0001127602-17-004868.txt'), ('66740', '3M CO', '4/A', '2017-02-09', 'edgar/data/66740/0001127602-17-004870.txt'), ('66740', '3M CO', '4/A', '2017-02-09', 'edgar/data/66740/0001127602-17-004874.txt'), ('66740', '3M CO', '4/A', '2017-02-09', 'edgar/data/66740/0001127602-17-004878.txt'), ('66740', '3M CO', '4/A', '2017-02-09', 'edgar/data/66740/0001127602-17-004880.txt'), ('66740', '3M CO', '4/A', '2017-02-09', 'edgar/data/66740/0001127602-17-004882.txt'), ('66740', '3M CO', '4/A', '2017-02-22', 'edgar/data/66740/0001127602-17-007785.txt'), ('66740', '3M CO', '4/A', '2017-02-22', 'edgar/data/66740/0001127602-17-007787.txt'), ('66740', '3M CO', '4/A', '2017-02-22', 'edgar/data/66740/0001127602-17-007789.txt'), ('66740', '3M CO', '4/A', '2017-02-22', 'edgar/data/66740/0001127602-17-007791.txt'), ('66740', '3M CO', '4/A', '2017-02-22', 'edgar/data/66740/0001127602-17-007794.txt'), ('66740', '3M CO', '4/A', '2017-02-22', 'edgar/data/66740/0001127602-17-007798.txt'), ('66740', '3M CO', '4/A', '2017-02-22', 'edgar/data/66740/0001127602-17-007803.txt'), ('66740', '3M CO', '4/A', '2017-02-22', 'edgar/data/66740/0001127602-17-007807.txt'), ('66740', '3M CO', '4/A', '2017-02-22', 'edgar/data/66740/0001127602-17-007809.txt'), ('66740', '3M CO', '4/A', '2017-02-22', 'edgar/data/66740/0001127602-17-007812.txt'), ('66740', '3M CO', '4/A', '2017-02-22', 'edgar/data/66740/0001127602-17-007814.txt'), ('66740', '3M CO', '4/A', '2017-02-22', 'edgar/data/66740/0001127602-17-007816.txt'), ('66740', '3M CO', '4/A', '2017-02-22', 'edgar/data/66740/0001127602-17-007818.txt'), ('66740', '3M CO', '4/A', '2017-02-22', 'edgar/data/66740/0001127602-17-007822.txt'), ('66740', '3M CO', '4/A', '2017-02-22', 'edgar/data/66740/0001127602-17-007824.txt'), ('66740', '3M CO', '4/A', '2017-02-22', 'edgar/data/66740/0001127602-17-007827.txt'), ('66740', '3M CO', '4', '2017-02-08', 'edgar/data/66740/0001127602-17-004505.txt'), ('66740', '3M CO', '4', '2017-02-08', 'edgar/data/66740/0001127602-17-004511.txt'), ('66740', '3M CO', '4', '2017-02-08', 'edgar/data/66740/0001127602-17-004513.txt'), ('66740', '3M CO', '4', '2017-02-08', 'edgar/data/66740/0001127602-17-004516.txt'), ('66740', '3M CO', '4', '2017-02-08', 'edgar/data/66740/0001127602-17-004519.txt'), ('66740', '3M CO', '4', '2017-02-08', 'edgar/data/66740/0001127602-17-004523.txt'), ('66740', '3M CO', '4', '2017-02-08', 'edgar/data/66740/0001127602-17-004527.txt'), ('66740', '3M CO', '4', '2017-02-09', 'edgar/data/66740/0001127602-17-004736.txt'), ('66740', '3M CO', '4', '2017-02-09', 'edgar/data/66740/0001127602-17-004744.txt'), ('66740', '3M CO', '4', '2017-02-09', 'edgar/data/66740/0001127602-17-004746.txt'), ('66740', '3M CO', '4', '2017-02-09', 'edgar/data/66740/0001127602-17-004748.txt'), ('66740', '3M CO', '4', '2017-02-09', 'edgar/data/66740/0001127602-17-004750.txt'), ('66740', '3M CO', '4', '2017-02-09', 'edgar/data/66740/0001127602-17-004752.txt'), ('66740', '3M CO', '4', '2017-02-09', 'edgar/data/66740/0001127602-17-004754.txt'), ('66740', '3M CO', '4', '2017-02-09', 'edgar/data/66740/0001127602-17-004756.txt'), ('66740', '3M CO', '4', '2017-02-09', 'edgar/data/66740/0001127602-17-004760.txt'), ('66740', '3M CO', '4', '2017-02-09', 'edgar/data/66740/0001127602-17-004763.txt'), ('66740', '3M CO', '4', '2017-02-09', 'edgar/data/66740/0001127602-17-004765.txt'), ('66740', '3M CO', '4', '2017-02-09', 'edgar/data/66740/0001127602-17-004767.txt'), ('66740', '3M CO', '4', '2017-02-09', 'edgar/data/66740/0001127602-17-004772.txt'), ('66740', '3M CO', '4', '2017-02-09', 'edgar/data/66740/0001127602-17-004774.txt'), ('66740', '3M CO', '4', '2017-02-09', 'edgar/data/66740/0001127602-17-004778.txt'), ('66740', '3M CO', '4', '2017-02-09', 'edgar/data/66740/0001127602-17-004781.txt'), ('66740', '3M CO', '4', '2017-02-10', 'edgar/data/66740/0001127602-17-004915.txt'), ('66740', '3M CO', '4', '2017-02-10', 'edgar/data/66740/0001127602-17-004921.txt'), ('66740', '3M CO', '4', '2017-02-10', 'edgar/data/66740/0001127602-17-004925.txt'), ('66740', '3M CO', '4', '2017-02-10', 'edgar/data/66740/0001127602-17-004938.txt'), ('66740', '3M CO', '4', '2017-02-14', 'edgar/data/66740/0001127602-17-005928.txt'), ('66740', '3M CO', '4', '2017-02-14', 'edgar/data/66740/0001127602-17-005934.txt'), ('66740', '3M CO', '4', '2017-02-14', 'edgar/data/66740/0001127602-17-005943.txt'), ('66740', '3M CO', '4', '2017-02-15', 'edgar/data/66740/0001127602-17-006212.txt'), ('66740', '3M CO', '4', '2017-02-15', 'edgar/data/66740/0001127602-17-006222.txt'), ('66740', '3M CO', '4', '2017-02-15', 'edgar/data/66740/0001127602-17-006227.txt'), ('66740', '3M CO', '5', '2017-01-10', 'edgar/data/66740/0001127602-17-001431.txt'), ('66740', '3M CO', '5', '2017-01-11', 'edgar/data/66740/0001127602-17-001552.txt'), ('66740', '3M CO', '5', '2017-01-26', 'edgar/data/66740/0001127602-17-002496.txt'), ('66740', '3M CO', '8-K', '2017-01-24', 'edgar/data/66740/0001104659-17-003686.txt'), ('66740', '3M CO', '8-K', '2017-03-09', 'edgar/data/66740/0001558370-17-001519.txt'), ('66740', '3M CO', 'DEF 14A', '2017-03-22', 'edgar/data/66740/0001206774-17-000922.txt'), ('66740', '3M CO', 'DEFA14A', '2017-03-22', 'edgar/data/66740/0001206774-17-000926.txt'), ('66740', '3M CO', 'DEFA14A', '2017-03-24', 'edgar/data/66740/0001104659-17-019059.txt'), ('66740', '3M CO', 'NO ACT', '2017-01-10', 'edgar/data/66740/9999999997-17-000767.txt'), ('66740', '3M CO', 'S-3ASR', '2017-02-24', 'edgar/data/66740/0001104659-17-011511.txt'), ('66740', '3M CO', 'SC 13G/A', '2017-01-19', 'edgar/data/66740/0000215457-17-001187.txt'), ('66740', '3M CO', 'SC 13G/A', '2017-02-09', 'edgar/data/66740/0000932471-17-000586.txt'), ('66740', '3M CO', 'SC 13G', '2017-02-14', 'edgar/data/66740/0000093751-17-000231.txt'), ('66740', '3M CO', '10-Q', '2017-05-03', 'edgar/data/66740/0001558370-17-003391.txt'), ('66740', '3M CO', '11-K', '2017-06-28', 'edgar/data/66740/0001104659-17-042063.txt'), ('66740', '3M CO', '4/A', '2017-05-19', 'edgar/data/66740/0001127602-17-018755.txt'), ('66740', '3M CO', '424B5', '2017-05-05', 'edgar/data/66740/0001104659-17-030177.txt'), ('66740', '3M CO', '4', '2017-05-04', 'edgar/data/66740/0001127602-17-016832.txt'), ('66740', '3M CO', '4', '2017-05-08', 'edgar/data/66740/0001127602-17-017215.txt'), ('66740', '3M CO', '4', '2017-05-10', 'edgar/data/66740/0001127602-17-017492.txt'), ('66740', '3M CO', '4', '2017-05-10', 'edgar/data/66740/0001127602-17-017497.txt'), ('66740', '3M CO', '4', '2017-05-10', 'edgar/data/66740/0001127602-17-017510.txt'), ('66740', '3M CO', '4', '2017-05-10', 'edgar/data/66740/0001127602-17-017570.txt'), ('66740', '3M CO', '4', '2017-05-10', 'edgar/data/66740/0001127602-17-017577.txt'), ('66740', '3M CO', '4', '2017-05-10', 'edgar/data/66740/0001127602-17-017583.txt'), ('66740', '3M CO', '4', '2017-05-10', 'edgar/data/66740/0001127602-17-017588.txt'), ('66740', '3M CO', '4', '2017-05-10', 'edgar/data/66740/0001127602-17-017591.txt'), ('66740', '3M CO', '4', '2017-05-10', 'edgar/data/66740/0001127602-17-017594.txt'), ('66740', '3M CO', '4', '2017-05-10', 'edgar/data/66740/0001127602-17-017597.txt'), ('66740', '3M CO', '4', '2017-05-11', 'edgar/data/66740/0001127602-17-017702.txt'), ('66740', '3M CO', '4', '2017-05-12', 'edgar/data/66740/0001127602-17-017843.txt'), ('66740', '3M CO', '4', '2017-05-19', 'edgar/data/66740/0001127602-17-018736.txt'), ('66740', '3M CO', '4', '2017-06-05', 'edgar/data/66740/0001127602-17-020488.txt'), ('66740', '3M CO', '4', '2017-06-05', 'edgar/data/66740/0001127602-17-020493.txt'), ('66740', '3M CO', '8-K', '2017-04-25', 'edgar/data/66740/0001104659-17-025639.txt'), ('66740', '3M CO', '8-K', '2017-05-04', 'edgar/data/66740/0001558370-17-003500.txt'), ('66740', '3M CO', '8-K', '2017-05-05', 'edgar/data/66740/0001104659-17-030189.txt'), ('66740', '3M CO', '8-K', '2017-05-10', 'edgar/data/66740/0001104659-17-031510.txt'), ('66740', '3M CO', '8-K', '2017-06-20', 'edgar/data/66740/0001104659-17-040411.txt'), ('66740', '3M CO', 'CORRESP', '2017-05-12', 'edgar/data/66740/0001558370-17-004251.txt'), ('66740', '3M CO', 'DEFA14A', '2017-04-28', 'edgar/data/66740/0001104659-17-027406.txt'), ('66740', '3M CO', 'SD', '2017-05-31', 'edgar/data/66740/0001104659-17-036452.txt'), ('66740', '3M CO', 'UPLOAD', '2017-05-02', 'edgar/data/66740/0000000000-17-015318.txt'), ('66740', '3M CO', 'UPLOAD', '2017-05-17', 'edgar/data/66740/0000000000-17-017395.txt'), ('66740', '3M CO', '10-Q', '2017-08-01', 'edgar/data/66740/0001558370-17-005582.txt'), ('66740', '3M CO', '3', '2017-07-07', 'edgar/data/66740/0001127602-17-023345.txt'), ('66740', '3M CO', '3', '2017-07-11', 'edgar/data/66740/0001127602-17-023475.txt'), ('66740', '3M CO', '3', '2017-08-16', 'edgar/data/66740/0001127602-17-025815.txt'), ('66740', '3M CO', '424B2', '2017-09-22', 'edgar/data/66740/0001104659-17-058441.txt'), ('66740', '3M CO', '4', '2017-07-05', 'edgar/data/66740/0001127602-17-022694.txt'), ('66740', '3M CO', '4', '2017-08-14', 'edgar/data/66740/0001127602-17-025578.txt'), ('66740', '3M CO', '4', '2017-08-16', 'edgar/data/66740/0001127602-17-025807.txt'), ('66740', '3M CO', '4', '2017-08-16', 'edgar/data/66740/0001127602-17-025809.txt'), ('66740', '3M CO', '4', '2017-08-16', 'edgar/data/66740/0001127602-17-025813.txt'), ('66740', '3M CO', '4', '2017-08-16', 'edgar/data/66740/0001127602-17-025822.txt'), ('66740', '3M CO', '4', '2017-08-16', 'edgar/data/66740/0001127602-17-025831.txt'), ('66740', '3M CO', '4', '2017-08-16', 'edgar/data/66740/0001127602-17-025833.txt'), ('66740', '3M CO', '4', '2017-08-16', 'edgar/data/66740/0001127602-17-025835.txt'), ('66740', '3M CO', '4', '2017-08-18', 'edgar/data/66740/0001127602-17-026001.txt'), ('66740', '3M CO', '4', '2017-08-18', 'edgar/data/66740/0001127602-17-026003.txt'), ('66740', '3M CO', '8-K', '2017-07-25', 'edgar/data/66740/0001104659-17-046666.txt'), ('66740', '3M CO', '8-K', '2017-08-14', 'edgar/data/66740/0001104659-17-051808.txt'), ('66740', '3M CO', '8-K', '2017-09-21', 'edgar/data/66740/0001104659-17-058200.txt'), ('66740', '3M CO', 'FWP', '2017-09-21', 'edgar/data/66740/0001104659-17-058201.txt'), ('66740', '3M CO', 'FWP', '2017-09-21', 'edgar/data/66740/0001104659-17-058311.txt'), ('66740', '3M CO', '10-Q', '2017-10-31', 'edgar/data/66740/0001558370-17-007801.txt'), ('66740', '3M CO', '15-15D', '2017-12-19', 'edgar/data/66740/0001104659-17-073987.txt'), ('66740', '3M CO', '4', '2017-10-30', 'edgar/data/66740/0001127602-17-030470.txt'), ('66740', '3M CO', '4', '2017-10-30', 'edgar/data/66740/0001127602-17-030501.txt'), ('66740', '3M CO', '4', '2017-10-30', 'edgar/data/66740/0001127602-17-030515.txt'), ('66740', '3M CO', '4', '2017-10-30', 'edgar/data/66740/0001127602-17-030527.txt'), ('66740', '3M CO', '4', '2017-11-01', 'edgar/data/66740/0001127602-17-030725.txt'), ('66740', '3M CO', '4', '2017-11-02', 'edgar/data/66740/0001127602-17-030878.txt'), ('66740', '3M CO', '4', '2017-11-02', 'edgar/data/66740/0001127602-17-030882.txt'), ('66740', '3M CO', '4', '2017-11-03', 'edgar/data/66740/0001127602-17-031129.txt'), ('66740', '3M CO', '4', '2017-11-03', 'edgar/data/66740/0001127602-17-031135.txt'), ('66740', '3M CO', '4', '2017-11-03', 'edgar/data/66740/0001127602-17-031141.txt'), ('66740', '3M CO', '4', '2017-11-03', 'edgar/data/66740/0001127602-17-031145.txt'), ('66740', '3M CO', '4', '2017-11-03', 'edgar/data/66740/0001127602-17-031147.txt'), ('66740', '3M CO', '4', '2017-11-16', 'edgar/data/66740/0001127602-17-032283.txt'), ('66740', '3M CO', '4', '2017-11-16', 'edgar/data/66740/0001127602-17-032285.txt'), ('66740', '3M CO', '4', '2017-11-16', 'edgar/data/66740/0001127602-17-032289.txt'), ('66740', '3M CO', '4', '2017-11-16', 'edgar/data/66740/0001127602-17-032292.txt'), ('66740', '3M CO', '4', '2017-11-16', 'edgar/data/66740/0001127602-17-032294.txt'), ('66740', '3M CO', '4', '2017-11-16', 'edgar/data/66740/0001127602-17-032296.txt'), ('66740', '3M CO', '4', '2017-12-04', 'edgar/data/66740/0001127602-17-033806.txt'), ('66740', '3M CO', '4', '2017-12-04', 'edgar/data/66740/0001127602-17-033816.txt'), ('66740', '3M CO', '4', '2017-12-04', 'edgar/data/66740/0001127602-17-033846.txt'), ('66740', '3M CO', '8-K', '2017-10-02', 'edgar/data/66740/0001104659-17-060104.txt'), ('66740', '3M CO', '8-K', '2017-10-06', 'edgar/data/66740/0001104659-17-061234.txt'), ('66740', '3M CO', '8-K', '2017-10-24', 'edgar/data/66740/0001104659-17-063455.txt'), ('66740', '3M CO', '8-K', '2017-12-07', 'edgar/data/66740/0001104659-17-072302.txt'), ('66740', '3M CO', '8-K', '2017-12-12', 'edgar/data/66740/0001104659-17-072834.txt'), ('66740', '3M CO', 'S-8 POS', '2017-12-18', 'edgar/data/66740/0001104659-17-073809.txt'), ('66740', '3M CO', '10-K', '2018-02-08', 'edgar/data/66740/0001558370-18-000535.txt'), ('66740', '3M CO', '3', '2018-01-10', 'edgar/data/66740/0001127602-18-001524.txt'), ('66740', '3M CO', '4/A', '2018-02-20', 'edgar/data/66740/0001127602-18-007230.txt'), ('66740', '3M CO', '4/A', '2018-02-20', 'edgar/data/66740/0001127602-18-007287.txt'), ('66740', '3M CO', '4/A', '2018-02-21', 'edgar/data/66740/0001127602-18-007441.txt'), ('66740', '3M CO', '4/A', '2018-02-21', 'edgar/data/66740/0001127602-18-007448.txt'), ('66740', '3M CO', '4/A', '2018-02-21', 'edgar/data/66740/0001127602-18-007452.txt'), ('66740', '3M CO', '4/A', '2018-02-21', 'edgar/data/66740/0001127602-18-007454.txt'), ('66740', '3M CO', '4/A', '2018-02-21', 'edgar/data/66740/0001127602-18-007531.txt'), ('66740', '3M CO', '4/A', '2018-02-21', 'edgar/data/66740/0001127602-18-007561.txt'), ('66740', '3M CO', '4/A', '2018-02-21', 'edgar/data/66740/0001127602-18-007565.txt'), ('66740', '3M CO', '4/A', '2018-02-22', 'edgar/data/66740/0001127602-18-007711.txt'), ('66740', '3M CO', '4/A', '2018-02-22', 'edgar/data/66740/0001127602-18-007753.txt'), ('66740', '3M CO', '4/A', '2018-02-22', 'edgar/data/66740/0001127602-18-007756.txt'), ('66740', '3M CO', '4/A', '2018-02-22', 'edgar/data/66740/0001127602-18-007773.txt'), ('66740', '3M CO', '4/A', '2018-02-22', 'edgar/data/66740/0001127602-18-007780.txt'), ('66740', '3M CO', '4/A', '2018-02-23', 'edgar/data/66740/0001127602-18-008025.txt'), ('66740', '3M CO', '4', '2018-02-01', 'edgar/data/66740/0001127602-18-003263.txt'), ('66740', '3M CO', '4', '2018-02-01', 'edgar/data/66740/0001127602-18-003275.txt'), ('66740', '3M CO', '4', '2018-02-01', 'edgar/data/66740/0001127602-18-003304.txt'), ('66740', '3M CO', '4', '2018-02-01', 'edgar/data/66740/0001127602-18-003314.txt'), ('66740', '3M CO', '4', '2018-02-02', 'edgar/data/66740/0001127602-18-003523.txt'), ('66740', '3M CO', '4', '2018-02-02', 'edgar/data/66740/0001127602-18-003526.txt'), ('66740', '3M CO', '4', '2018-02-02', 'edgar/data/66740/0001127602-18-003530.txt'), ('66740', '3M CO', '4', '2018-02-02', 'edgar/data/66740/0001127602-18-003535.txt'), ('66740', '3M CO', '4', '2018-02-02', 'edgar/data/66740/0001127602-18-003538.txt'), ('66740', '3M CO', '4', '2018-02-02', 'edgar/data/66740/0001127602-18-003544.txt'), ('66740', '3M CO', '4', '2018-02-02', 'edgar/data/66740/0001127602-18-003547.txt'), ('66740', '3M CO', '4', '2018-02-02', 'edgar/data/66740/0001127602-18-003553.txt'), ('66740', '3M CO', '4', '2018-02-02', 'edgar/data/66740/0001127602-18-003569.txt'), ('66740', '3M CO', '4', '2018-02-02', 'edgar/data/66740/0001127602-18-003601.txt'), ('66740', '3M CO', '4', '2018-02-02', 'edgar/data/66740/0001127602-18-003611.txt'), ('66740', '3M CO', '4', '2018-02-05', 'edgar/data/66740/0001127602-18-003940.txt'), ('66740', '3M CO', '4', '2018-02-05', 'edgar/data/66740/0001127602-18-003948.txt'), ('66740', '3M CO', '4', '2018-02-06', 'edgar/data/66740/0001127602-18-004227.txt'), ('66740', '3M CO', '4', '2018-02-06', 'edgar/data/66740/0001127602-18-004234.txt'), ('66740', '3M CO', '4', '2018-02-06', 'edgar/data/66740/0001127602-18-004239.txt'), ('66740', '3M CO', '4', '2018-02-06', 'edgar/data/66740/0001127602-18-004290.txt'), ('66740', '3M CO', '4', '2018-02-06', 'edgar/data/66740/0001127602-18-004299.txt'), ('66740', '3M CO', '4', '2018-02-06', 'edgar/data/66740/0001127602-18-004306.txt'), ('66740', '3M CO', '4', '2018-02-06', 'edgar/data/66740/0001127602-18-004318.txt'), ('66740', '3M CO', '4', '2018-02-06', 'edgar/data/66740/0001127602-18-004328.txt'), ('66740', '3M CO', '4', '2018-02-06', 'edgar/data/66740/0001127602-18-004347.txt'), ('66740', '3M CO', '4', '2018-02-08', 'edgar/data/66740/0001127602-18-004565.txt'), ('66740', '3M CO', '4', '2018-02-08', 'edgar/data/66740/0001127602-18-004572.txt'), ('66740', '3M CO', '4', '2018-02-08', 'edgar/data/66740/0001127602-18-004583.txt'), ('66740', '3M CO', '4', '2018-02-08', 'edgar/data/66740/0001127602-18-004588.txt'), ('66740', '3M CO', '4', '2018-02-08', 'edgar/data/66740/0001127602-18-004596.txt'), ('66740', '3M CO', '4', '2018-02-08', 'edgar/data/66740/0001127602-18-004610.txt'), ('66740', '3M CO', '4', '2018-02-08', 'edgar/data/66740/0001127602-18-004613.txt'), ('66740', '3M CO', '4', '2018-02-08', 'edgar/data/66740/0001127602-18-004616.txt'), ('66740', '3M CO', '4', '2018-02-08', 'edgar/data/66740/0001127602-18-004622.txt'), ('66740', '3M CO', '4', '2018-02-08', 'edgar/data/66740/0001127602-18-004628.txt'), ('66740', '3M CO', '4', '2018-02-08', 'edgar/data/66740/0001127602-18-004632.txt'), ('66740', '3M CO', '4', '2018-02-08', 'edgar/data/66740/0001127602-18-004637.txt'), ('66740', '3M CO', '4', '2018-02-08', 'edgar/data/66740/0001127602-18-004639.txt'), ('66740', '3M CO', '4', '2018-02-08', 'edgar/data/66740/0001127602-18-004641.txt'), ('66740', '3M CO', '4', '2018-02-08', 'edgar/data/66740/0001127602-18-004643.txt'), ('66740', '3M CO', '4', '2018-02-08', 'edgar/data/66740/0001127602-18-004648.txt'), ('66740', '3M CO', '4', '2018-02-08', 'edgar/data/66740/0001127602-18-004655.txt'), ('66740', '3M CO', '4', '2018-02-08', 'edgar/data/66740/0001127602-18-004661.txt'), ('66740', '3M CO', '4', '2018-02-26', 'edgar/data/66740/0001127602-18-008423.txt'), ('66740', '3M CO', '5', '2018-01-19', 'edgar/data/66740/0001127602-18-002174.txt'), ('66740', '3M CO', '5', '2018-01-22', 'edgar/data/66740/0001127602-18-002191.txt'), ('66740', '3M CO', '8-K/A', '2018-01-25', 'edgar/data/66740/0001104659-18-004014.txt'), ('66740', '3M CO', '8-K', '2018-01-25', 'edgar/data/66740/0001104659-18-003876.txt'), ('66740', '3M CO', '8-K', '2018-02-20', 'edgar/data/66740/0001104659-18-010779.txt'), ('66740', '3M CO', '8-K', '2018-03-06', 'edgar/data/66740/0001104659-18-015215.txt'), ('66740', '3M CO', '8-K', '2018-03-15', 'edgar/data/66740/0001558370-18-002122.txt'), ('66740', '3M CO', 'DEF 14A', '2018-03-21', 'edgar/data/66740/0001206774-18-000890.txt'), ('66740', '3M CO', 'DEFA14A', '2018-03-21', 'edgar/data/66740/0001206774-18-000891.txt'), ('66740', '3M CO', 'DEFA14A', '2018-03-23', 'edgar/data/66740/0001104659-18-019839.txt'), ('66740', '3M CO', 'SC 13G/A', '2018-02-08', 'edgar/data/66740/0000215457-18-005144.txt'), ('66740', '3M CO', 'SC 13G/A', '2018-02-13', 'edgar/data/66740/0000932471-18-004940.txt'), ('66740', '3M CO', 'SC 13G', '2018-02-12', 'edgar/data/66740/0000093751-18-000008.txt'), ('66740', '3M CO', 'SC 13G', '2018-02-13', 'edgar/data/66740/0000093751-18-000021.txt'), ('66740', '3M CO', '10-Q', '2018-05-08', 'edgar/data/66740/0001558370-18-004248.txt'), ('66740', '3M CO', '4', '2018-05-10', 'edgar/data/66740/0001127602-18-016920.txt'), ('66740', '3M CO', '4', '2018-05-10', 'edgar/data/66740/0001127602-18-016925.txt'), ('66740', '3M CO', '4', '2018-05-10', 'edgar/data/66740/0001127602-18-016936.txt'), ('66740', '3M CO', '4', '2018-05-10', 'edgar/data/66740/0001127602-18-016951.txt'), ('66740', '3M CO', '4', '2018-05-10', 'edgar/data/66740/0001127602-18-016953.txt'), ('66740', '3M CO', '4', '2018-05-10', 'edgar/data/66740/0001127602-18-016955.txt'), ('66740', '3M CO', '4', '2018-05-10', 'edgar/data/66740/0001127602-18-016958.txt'), ('66740', '3M CO', '4', '2018-05-10', 'edgar/data/66740/0001127602-18-016962.txt'), ('66740', '3M CO', '4', '2018-05-10', 'edgar/data/66740/0001127602-18-016965.txt'), ('66740', '3M CO', '4', '2018-05-10', 'edgar/data/66740/0001127602-18-016975.txt'), ('66740', '3M CO', '4', '2018-05-10', 'edgar/data/66740/0001127602-18-017005.txt'), ('66740', '3M CO', '4', '2018-06-05', 'edgar/data/66740/0001127602-18-019935.txt'), ('66740', '3M CO', '4', '2018-06-05', 'edgar/data/66740/0001127602-18-019956.txt'), ('66740', '3M CO', '8-K/A', '2018-05-24', 'edgar/data/66740/0001104659-18-035756.txt'), ('66740', '3M CO', '8-K', '2018-04-24', 'edgar/data/66740/0001104659-18-025950.txt'), ('66740', '3M CO', '8-K', '2018-05-08', 'edgar/data/66740/0001558370-18-004256.txt'), ('66740', '3M CO', '8-K', '2018-05-09', 'edgar/data/66740/0001104659-18-031666.txt'), ('66740', '3M CO', 'CORRESP', '2018-05-08', 'edgar/data/66740/0001558370-18-004237.txt'), ('66740', '3M CO', 'DEFA14A', '2018-04-27', 'edgar/data/66740/0001104659-18-027486.txt'), ('66740', '3M CO', 'SD', '2018-05-31', 'edgar/data/66740/0001104659-18-037044.txt'), ('66740', '3M CO', 'UPLOAD', '2018-04-27', 'edgar/data/66740/0000000000-18-013119.txt'), ('66740', '3M CO', 'UPLOAD', '2018-05-22', 'edgar/data/66740/0000000000-18-015741.txt'), ('66740', '3M CO', '10-Q', '2018-07-26', 'edgar/data/66740/0001558370-18-005773.txt'), ('66740', '3M CO', '3', '2018-07-10', 'edgar/data/66740/0001127602-18-023023.txt'), ('66740', '3M CO', '3', '2018-08-14', 'edgar/data/66740/0001127602-18-025240.txt'), ('66740', '3M CO', '424B2', '2018-09-12', 'edgar/data/66740/0001104659-18-056434.txt'), ('66740', '3M CO', '4', '2018-07-05', 'edgar/data/66740/0001127602-18-022803.txt'), ('66740', '3M CO', '4', '2018-08-13', 'edgar/data/66740/0001127602-18-025215.txt'), ('66740', '3M CO', '4', '2018-08-15', 'edgar/data/66740/0001127602-18-025402.txt'), ('66740', '3M CO', '4', '2018-08-15', 'edgar/data/66740/0001127602-18-025404.txt'), ('66740', '3M CO', '4', '2018-08-15', 'edgar/data/66740/0001127602-18-025406.txt'), ('66740', '3M CO', '4', '2018-08-15', 'edgar/data/66740/0001127602-18-025408.txt'), ('66740', '3M CO', '4', '2018-08-15', 'edgar/data/66740/0001127602-18-025410.txt'), ('66740', '3M CO', '4', '2018-08-15', 'edgar/data/66740/0001127602-18-025413.txt'), ('66740', '3M CO', '4', '2018-09-11', 'edgar/data/66740/0001127602-18-027331.txt'), ('66740', '3M CO', '8-K', '2018-07-24', 'edgar/data/66740/0001104659-18-046631.txt'), ('66740', '3M CO', '8-K', '2018-08-10', 'edgar/data/66740/0001104659-18-051185.txt'), ('66740', '3M CO', '8-K', '2018-08-13', 'edgar/data/66740/0001104659-18-051383.txt'), ('66740', '3M CO', '8-K', '2018-08-17', 'edgar/data/66740/0001104659-18-052645.txt'), ('66740', '3M CO', '8-K', '2018-09-14', 'edgar/data/66740/0001104659-18-056889.txt'), ('66740', '3M CO', 'FWP', '2018-09-11', 'edgar/data/66740/0001104659-18-056219.txt'), ('66740', '3M CO', '10-Q', '2018-10-25', 'edgar/data/66740/0001558370-18-007892.txt'), ('66740', '3M CO', '25-NSE', '2018-11-09', 'edgar/data/66740/0000876661-18-001191.txt'), ('66740', '3M CO', '4', '2018-10-02', 'edgar/data/66740/0001127602-18-029095.txt'), ('66740', '3M CO', '4', '2018-10-29', 'edgar/data/66740/0001127602-18-031183.txt'), ('66740', '3M CO', '4', '2018-11-14', 'edgar/data/66740/0001127602-18-032961.txt'), ('66740', '3M CO', '4', '2018-11-14', 'edgar/data/66740/0001127602-18-032968.txt'), ('66740', '3M CO', '4', '2018-11-14', 'edgar/data/66740/0001127602-18-032971.txt'), ('66740', '3M CO', '4', '2018-11-14', 'edgar/data/66740/0001127602-18-032974.txt'), ('66740', '3M CO', '4', '2018-11-14', 'edgar/data/66740/0001127602-18-032976.txt'), ('66740', '3M CO', '4', '2018-11-14', 'edgar/data/66740/0001127602-18-032978.txt'), ('66740', '3M CO', '8-K', '2018-10-23', 'edgar/data/66740/0001104659-18-063417.txt'), ('66740', '3M CO', '8-K', '2018-11-09', 'edgar/data/66740/0001104659-18-067277.txt'), ('66740', '3M CO', '8-K', '2018-11-15', 'edgar/data/66740/0001104659-18-068651.txt'), ('66740', '3M CO', '10-K', '2019-02-07', 'edgar/data/66740/0001558370-19-000470.txt'), ('66740', '3M CO', '4/A', '2019-02-19', 'edgar/data/66740/0001127602-19-006709.txt'), ('66740', '3M CO', '4/A', '2019-02-19', 'edgar/data/66740/0001127602-19-006791.txt'), ('66740', '3M CO', '4/A', '2019-02-19', 'edgar/data/66740/0001127602-19-006820.txt'), ('66740', '3M CO', '4/A', '2019-02-19', 'edgar/data/66740/0001127602-19-006896.txt'), ('66740', '3M CO', '4/A', '2019-02-19', 'edgar/data/66740/0001127602-19-006914.txt'), ('66740', '3M CO', '4/A', '2019-02-19', 'edgar/data/66740/0001127602-19-006954.txt'), ('66740', '3M CO', '4/A', '2019-02-20', 'edgar/data/66740/0001127602-19-007041.txt'), ('66740', '3M CO', '4/A', '2019-02-20', 'edgar/data/66740/0001127602-19-007043.txt'), ('66740', '3M CO', '4/A', '2019-02-20', 'edgar/data/66740/0001127602-19-007046.txt'), ('66740', '3M CO', '4/A', '2019-02-20', 'edgar/data/66740/0001127602-19-007048.txt'), ('66740', '3M CO', '4/A', '2019-02-20', 'edgar/data/66740/0001127602-19-007050.txt'), ('66740', '3M CO', '4/A', '2019-02-20', 'edgar/data/66740/0001127602-19-007052.txt'), ('66740', '3M CO', '4/A', '2019-02-20', 'edgar/data/66740/0001127602-19-007054.txt'), ('66740', '3M CO', '4/A', '2019-02-20', 'edgar/data/66740/0001127602-19-007056.txt'), ('66740', '3M CO', '4/A', '2019-02-20', 'edgar/data/66740/0001127602-19-007058.txt'), ('66740', '3M CO', '4/A', '2019-02-20', 'edgar/data/66740/0001127602-19-007060.txt'), ('66740', '3M CO', '4/A', '2019-03-27', 'edgar/data/66740/0001127602-19-013300.txt'), ('66740', '3M CO', '424B2', '2019-02-14', 'edgar/data/66740/0001104659-19-008043.txt'), ('66740', '3M CO', '4', '2019-02-01', 'edgar/data/66740/0001127602-19-003273.txt'), ('66740', '3M CO', '4', '2019-02-01', 'edgar/data/66740/0001127602-19-003287.txt'), ('66740', '3M CO', '4', '2019-02-04', 'edgar/data/66740/0001127602-19-003664.txt'), ('66740', '3M CO', '4', '2019-02-07', 'edgar/data/66740/0001127602-19-004370.txt'), ('66740', '3M CO', '4', '2019-02-07', 'edgar/data/66740/0001127602-19-004389.txt'), ('66740', '3M CO', '4', '2019-02-07', 'edgar/data/66740/0001127602-19-004395.txt'), ('66740', '3M CO', '4', '2019-02-07', 'edgar/data/66740/0001127602-19-004404.txt'), ('66740', '3M CO', '4', '2019-02-07', 'edgar/data/66740/0001127602-19-004417.txt'), ('66740', '3M CO', '4', '2019-02-07', 'edgar/data/66740/0001127602-19-004426.txt'), ('66740', '3M CO', '4', '2019-02-07', 'edgar/data/66740/0001127602-19-004429.txt'), ('66740', '3M CO', '4', '2019-02-07', 'edgar/data/66740/0001127602-19-004440.txt'), ('66740', '3M CO', '4', '2019-02-07', 'edgar/data/66740/0001127602-19-004460.txt'), ('66740', '3M CO', '4', '2019-02-07', 'edgar/data/66740/0001127602-19-004480.txt'), ('66740', '3M CO', '4', '2019-02-07', 'edgar/data/66740/0001127602-19-004488.txt'), ('66740', '3M CO', '4', '2019-02-07', 'edgar/data/66740/0001127602-19-004490.txt'), ('66740', '3M CO', '4', '2019-02-07', 'edgar/data/66740/0001127602-19-004492.txt'), ('66740', '3M CO', '4', '2019-02-07', 'edgar/data/66740/0001127602-19-004495.txt'), ('66740', '3M CO', '4', '2019-02-07', 'edgar/data/66740/0001127602-19-004500.txt'), ('66740', '3M CO', '4', '2019-02-07', 'edgar/data/66740/0001127602-19-004504.txt'), ('66740', '3M CO', '4', '2019-02-11', 'edgar/data/66740/0001127602-19-004981.txt'), ('66740', '3M CO', '4', '2019-02-11', 'edgar/data/66740/0001127602-19-004983.txt'), ('66740', '3M CO', '4', '2019-02-11', 'edgar/data/66740/0001127602-19-004986.txt'), ('66740', '3M CO', '4', '2019-02-11', 'edgar/data/66740/0001127602-19-004988.txt'), ('66740', '3M CO', '4', '2019-02-11', 'edgar/data/66740/0001127602-19-004990.txt'), ('66740', '3M CO', '4', '2019-02-11', 'edgar/data/66740/0001127602-19-004992.txt'), ('66740', '3M CO', '4', '2019-02-11', 'edgar/data/66740/0001127602-19-004994.txt'), ('66740', '3M CO', '4', '2019-02-11', 'edgar/data/66740/0001127602-19-004998.txt'), ('66740', '3M CO', '4', '2019-02-13', 'edgar/data/66740/0001127602-19-005578.txt'), ('66740', '3M CO', '4', '2019-02-19', 'edgar/data/66740/0001127602-19-006658.txt'), ('66740', '3M CO', '5', '2019-02-01', 'edgar/data/66740/0001127602-19-003271.txt'), ('66740', '3M CO', '8-K', '2019-01-29', 'edgar/data/66740/0001104659-19-003838.txt'), ('66740', '3M CO', '8-K', '2019-02-07', 'edgar/data/66740/0001104659-19-006320.txt'), ('66740', '3M CO', '8-K', '2019-02-22', 'edgar/data/66740/0001104659-19-010100.txt'), ('66740', '3M CO', '8-K', '2019-03-08', 'edgar/data/66740/0001558370-19-001708.txt'), ('66740', '3M CO', '8-K', '2019-03-18', 'edgar/data/66740/0001104659-19-015661.txt'), ('66740', '3M CO', 'DEF 14A', '2019-03-27', 'edgar/data/66740/0001206774-19-001068.txt'), ('66740', '3M CO', 'DEFA14A', '2019-03-27', 'edgar/data/66740/0001206774-19-001069.txt'), ('66740', '3M CO', 'DEFA14A', '2019-03-29', 'edgar/data/66740/0001104659-19-018589.txt'), ('66740', '3M CO', 'FWP', '2019-02-13', 'edgar/data/66740/0001104659-19-007561.txt'), ('66740', '3M CO', 'SC 13G/A', '2019-02-04', 'edgar/data/66740/0000215457-19-003332.txt'), ('66740', '3M CO', 'SC 13G/A', '2019-02-11', 'edgar/data/66740/0000932471-19-004765.txt'), ('66740', '3M CO', 'SC 13G', '2019-02-13', 'edgar/data/66740/0000093751-19-000141.txt'), ('66740', '3M CO', '10-Q', '2019-04-26', 'edgar/data/66740/0001558370-19-003408.txt'), ('66740', '3M CO', '3', '2019-04-09', 'edgar/data/66740/0001127602-19-015034.txt'), ('66740', '3M CO', '3', '2019-04-09', 'edgar/data/66740/0001127602-19-015036.txt'), ('66740', '3M CO', '3', '2019-04-10', 'edgar/data/66740/0001127602-19-015132.txt'), ('66740', '3M CO', '3', '2019-04-11', 'edgar/data/66740/0001127602-19-015297.txt'), ('66740', '3M CO', '3', '2019-05-20', 'edgar/data/66740/0001127602-19-019110.txt'), ('66740', '3M CO', '4', '2019-04-01', 'edgar/data/66740/0001127602-19-013830.txt'), ('66740', '3M CO', '4', '2019-04-01', 'edgar/data/66740/0001127602-19-013838.txt'), ('66740', '3M CO', '4', '2019-04-01', 'edgar/data/66740/0001127602-19-013842.txt'), ('66740', '3M CO', '4', '2019-04-01', 'edgar/data/66740/0001127602-19-013854.txt'), ('66740', '3M CO', '4', '2019-04-01', 'edgar/data/66740/0001127602-19-013861.txt'), ('66740', '3M CO', '4', '2019-05-02', 'edgar/data/66740/0001127602-19-016849.txt'), ('66740', '3M CO', '4', '2019-05-02', 'edgar/data/66740/0001127602-19-016852.txt'), ('66740', '3M CO', '4', '2019-05-02', 'edgar/data/66740/0001127602-19-016859.txt'), ('66740', '3M CO', '4', '2019-05-02', 'edgar/data/66740/0001127602-19-016863.txt'), ('66740', '3M CO', '4', '2019-05-02', 'edgar/data/66740/0001127602-19-016865.txt'), ('66740', '3M CO', '4', '2019-05-02', 'edgar/data/66740/0001127602-19-016870.txt'), ('66740', '3M CO', '4', '2019-05-09', 'edgar/data/66740/0001127602-19-017840.txt'), ('66740', '3M CO', '4', '2019-05-10', 'edgar/data/66740/0001127602-19-018086.txt'), ('66740', '3M CO', '4', '2019-05-15', 'edgar/data/66740/0001127602-19-018546.txt'), ('66740', '3M CO', '4', '2019-05-15', 'edgar/data/66740/0001127602-19-018548.txt'), ('66740', '3M CO', '4', '2019-05-15', 'edgar/data/66740/0001127602-19-018551.txt'), ('66740', '3M CO', '4', '2019-05-15', 'edgar/data/66740/0001127602-19-018555.txt'), ('66740', '3M CO', '4', '2019-05-15', 'edgar/data/66740/0001127602-19-018558.txt'), ('66740', '3M CO', '4', '2019-05-15', 'edgar/data/66740/0001127602-19-018571.txt'), ('66740', '3M CO', '4', '2019-05-15', 'edgar/data/66740/0001127602-19-018573.txt'), ('66740', '3M CO', '4', '2019-05-15', 'edgar/data/66740/0001127602-19-018575.txt'), ('66740', '3M CO', '4', '2019-05-15', 'edgar/data/66740/0001127602-19-018583.txt'), ('66740', '3M CO', '4', '2019-05-15', 'edgar/data/66740/0001127602-19-018585.txt'), ('66740', '3M CO', '4', '2019-05-16', 'edgar/data/66740/0001127602-19-018624.txt'), ('66740', '3M CO', '4', '2019-05-16', 'edgar/data/66740/0001127602-19-018666.txt'), ('66740', '3M CO', '4', '2019-05-20', 'edgar/data/66740/0001127602-19-019106.txt'), ('66740', '3M CO', '4', '2019-05-20', 'edgar/data/66740/0001127602-19-019130.txt'), ('66740', '3M CO', '8-K', '2019-04-25', 'edgar/data/66740/0001104659-19-023560.txt'), ('66740', '3M CO', '8-K', '2019-05-02', 'edgar/data/66740/0001104659-19-026418.txt'), ('66740', '3M CO', '8-K', '2019-05-15', 'edgar/data/66740/0001104659-19-029725.txt'), ('66740', '3M CO', '8-K', '2019-05-30', 'edgar/data/66740/0001558370-19-005388.txt'), ('66740', '3M CO', '8-K', '2019-06-11', 'edgar/data/66740/0001410578-19-000454.txt'), ('66740', '3M CO', 'IRANNOTICE', '2019-04-26', 'edgar/data/66740/0001558370-19-003415.txt'), ('66740', '3M CO', 'SD', '2019-05-31', 'edgar/data/66740/0001104659-19-033036.txt'), ('66740', '3M CO', '10-Q', '2019-07-26', 'edgar/data/66740/0001558370-19-006397.txt'), ('66740', '3M CO', '424B5', '2019-08-19', 'edgar/data/66740/0001047469-19-004797.txt'), ('66740', '3M CO', '424B5', '2019-08-21', 'edgar/data/66740/0001047469-19-004810.txt'), ('66740', '3M CO', '4', '2019-07-02', 'edgar/data/66740/0001127602-19-023366.txt'), ('66740', '3M CO', '4', '2019-07-31', 'edgar/data/66740/0001127602-19-025521.txt'), ('66740', '3M CO', '4', '2019-07-31', 'edgar/data/66740/0001127602-19-025544.txt'), ('66740', '3M CO', '4', '2019-07-31', 'edgar/data/66740/0001127602-19-025546.txt'), ('66740', '3M CO', '4', '2019-07-31', 'edgar/data/66740/0001127602-19-025564.txt'), ('66740', '3M CO', '4', '2019-08-01', 'edgar/data/66740/0001127602-19-025603.txt'), ('66740', '3M CO', '4', '2019-08-01', 'edgar/data/66740/0001127602-19-025608.txt'), ('66740', '3M CO', '4', '2019-08-05', 'edgar/data/66740/0001127602-19-025998.txt'), ('66740', '3M CO', '8-K', '2019-07-25', 'edgar/data/66740/0001104659-19-041709.txt'), ('66740', '3M CO', '8-K', '2019-08-26', 'edgar/data/66740/0001410578-19-000918.txt'), ('66740', '3M CO', 'CORRESP', '2019-07-26', 'edgar/data/66740/0001558370-19-006401.txt'), ('66740', '3M CO', 'FWP', '2019-08-19', 'edgar/data/66740/0001104659-19-046542.txt'), ('66740', '3M CO', 'UPLOAD', '2019-07-17', 'edgar/data/66740/0000000000-19-011245.txt'), ('66740', '3M CO', 'UPLOAD', '2019-08-08', 'edgar/data/66740/0000000000-19-012220.txt'), ('66740', '3M CO', '8-K', '2019-10-11', 'edgar/data/66740/0001410578-19-001637.txt')]

The thus created CSV files can be read back in



In [ ]:

    
all_10Ks =pd.read_csv("TestData\\{:s}_all_10ks.csv".format(ticker.lower()), parse_dates=['date'], dtype={'cik':str, 'conm':str, 'type':str,'path':str})
all_10Qs =pd.read_csv("TestData\\{:s}_all_10qs.csv".format(ticker.lower()), parse_dates=['date'], dtype={'cik':str, 'conm':str, 'type':str,'path':str})

Verifying Canslim is correctly loaded/populated

First, create the Canslim object, which should load all SecFilings*



In [ ]:

    
from CanslimParams import CanslimParams
canslim = CanslimParams(ticker, all_10Qs, all_10Ks)
canslim.loadData()

Print some diagnostics



In [ ]:

    
print(canslim.n10Ks)
print(canslim.n10Qs)
print(canslim.errorLog)

Print EPS's for all quarters and years



In [ ]:

    
for i in range(0, canslim.n10Qs):
    print(canslim.getEpsQuarter(i))



In [ ]:

    
for i in range(0, canslim.n10Ks):
    print(canslim.getEpsAnnual(i))

After the SecFilings have actually been accessed (through getting the EPS values), the quartersList and yearsList should be populated now.



In [ ]:

    
print(canslim.quartersList)
print(canslim.yearsList)

Verifying that a 10Q filing is loaded correctly

First, set the correct path to the filing to load (be sure to update the last two arguments, if necessary). Then, load the SecFiling.



In [ ]:

    
ticker = "OSK"  ## Note that this will overwrite the `ticker` set above



In [ ]:

    
from os import path, getenv
#file_path = path.join("C:", "Users", "Carola", "jupyternbs", "SECDATA", "OSHKOSH CORP", "775158_OSHKOSH CORP_10-Q_2019-08-000000")
file_path = "C:\\Users\\Carola\\jupyternbs\\SECDATA\\OSHKOSH CORP\\775158_OSHKOSH CORP_10-Q_2019-08-000000"



In [ ]:

    
from SecFiling10Q import SecFiling10Q
filing = SecFiling10Q(ticker)
filing.load(file_path)

Now we can print some things that should be loaded from the filing.



In [ ]:

    
print(filing.getReportDate())
print("Eps=", filing.getEps())

Print some diagnostics (all_tags contains the section from the filing-file that should contain all the relevant tags)



In [ ]:

    
type(filing.all_tags)



In [ ]:

    
c=0
for t in filing.all_tags:
    if 'us-gaap:IncomeLossFromContinuingOperationsPerBasicShare'.lower() in t.name.lower():
        print(t)
        c+=1
print(c)

Verifying calculated data



In [31]:

    
import numpy as np
import matplotlib.pyplot as plt
from datetime import date, timedelta

Verifying "Stability of EPS Growth"

First, enter all the values into numpy-arrays. Hint: if these are in an Excel spreadsheet, one can copy+paste values only, then copy+paste transpose. Then, one can copy+paste these into notepad++ and find+replace tabs with commas, etc. Then paste here. For dates: format in Excel spreadsheet. in Notepad++: search for ([0-9]*-[0-9]*-[0-9]*), replace with date\(\1\)



In [17]:

    
## NVDA
#y= np.array([3123000000, 3207000000, 2911000000, 2636000000, 2230000000]) #sales
#y= np.array([1.81, 2.05, 1.86, 1.39, 0.98]) #eps
#x=np.array([0.0, -91, -182, -273, -364])
## AAPL
#se = np.array([114949, 126878, 140199]) * 1000.0
#ni = np.array([11519, 13822, 20065 ]) * 1000000.0
#sales = np.array([53265, 61137, 88293, 52579, 45408, 52896, 78351]) * 1000000.0
#eps = np.array([2.36, 2.75, 3.92, 2.18, 1.68, 2.11, 3.38])
## ACLS
#se= np.array([397074, 385614, 371527])*1000.0
#ni = np.array([8838, 14669, 13915])*1000.0
#sales = np.array([95374, 119333, 122185])*1000.0
#eps = np.array([0.95, 2.26, 1.71])
#days = np.array([0.0, -91, -182, -273, -364, -455, -546])
## MMM
eps = np.array([1.54, 2.3, 2.64, 3.14, 1.01, 0.88, 2.39, 2.65, 2.21, 1.92, 2.2, 2.13, 2.1, 1.69, 2.09, 2.06, 1.88])
dates=np.array([date(2019, 3, 31), date(2018, 12, 31), date(2018, 9, 30), date(2018, 6, 30), date(2018, 3, 31), date(2017, 12, 31), date(2017, 9, 30), date(2017, 6, 30), date(2017, 3, 31), date(2016, 12, 31), date(2016, 9, 30), date(2016, 6, 30), date(2016, 3, 31), date(2015, 12, 31), date(2015, 9, 30), date(2015, 6, 30), date(2015, 3, 31)])
sales=np.array([7863000000, 7945000000, 8152000000, 8390000000, 8278000000, 8008000000, 8172000000, 7810000000, 7685000000, 7329000000, 7709000000, 7662000000, 7409000000, 7298000000, 7712000000, 7686000000, 7578000000])
se=np.array([9703000000, 10407000000, 10248000000, 10365000000, 10977000000, 11672000000, 12146000000, 11591000000, 10989000000, 11316000000, 12002000000, 11894000000, 11733000000, 12484000000, 12186000000, 13093000000, 13917000000])
ni=np.array([891000000, 1361000000, 1543000000, 1857000000, 602000000, 534000000, 1429000000, 1583000000, 1323000000, 1163000000, 1329000000, 1291000000, 1275000000, 1041000000, 1296000000, 1303000000, 1201000000])
delta=dates-dates[0]
l=[]
for d in delta:
    l.append(d.days)
days=np.array(l)



In [56]:

    
np.sum(eps[0:4]) / np.average(eps[0:4])









    Out[56]:





4.0

Then, the data can be fitted. Set x and y to the appropriate data (ranges) to be fitted.



In [57]:

    
y = eps[:-5]
x = days[:-5]
## Fit a polynomial of degree 2 through the data: ax**2 + bx + c. 'a' should be the acceleration
p = np.polyfit(x, y, 2)
## Calculate fitted y-values
yfit = np.polyval(p, x)
## Calculate the "error"
sigma = (y - yfit) / y
error = sigma * sigma
res = error.sum()
print("Total error (sum(sigma_i^2)): {:g}".format(res))









    



Total error (sum(sigma_i^2)): 3.2385



In [44]:

    
plt.plot(x,y)
plt.plot(x,yfit)
plt.show()



In [ ]:

    
print(p)
print(error)
print(res)
print((sales[2] - sales[1])/(days[2] - days[1]))
print((eps[2] - eps[1])/(days[2] - days[1]))
print((y[2] - y[0])/(x[2] - x[0]))