Companies that had a 2016 entry, but not a 2017 entry


In [9]:
for company in EdgarCompanyInfo.objects.all().order_by('conformed_name'):
    _2016 = EdgarSDFiling.objects.filter(company=company, date__year=2016)
    if _2016.count() > 0:
        _2017 = EdgarSDFiling.objects.filter(company=company, date__year=2017)
        if _2017.count() == 0:
            print(company.conformed_name, '({0})'.format(company.cik))


ALCATEL LUCENT (0000886125)
EMC CORP (0000790070)
FMC TECHNOLOGIES INC (0001135152)
HARMAN INTERNATIONAL INDUSTRIES INC /DE/ (0000800459)
JOHNSON CONTROLS INC (0000053669)
ST JUDE MEDICAL, LLC (0000203077)
WAL MART STORES INC (0000104169)

Alcatel was bought by Nokia. Haven't researched others.


Companies with less than four entries


In [8]:
for company in EdgarCompanyInfo.objects.all().order_by('conformed_name'):
    if EdgarSDFiling.objects.filter(company=company).count() < 4:
        print(company.conformed_name, '({0})'.format(company.cik))


ALCATEL LUCENT (0000886125)
Avago Technologies LTD (0001441634)
CAMERON INTERNATIONAL CORP (0000941548)
CHESAPEAKE ENERGY CORP (0000895126)
EMC CORP (0000790070)
FMC TECHNOLOGIES INC (0001135152)
HARMAN INTERNATIONAL INDUSTRIES INC /DE/ (0000800459)
JARDEN CORP (0000895655)
JOHNSON CONTROLS INC (0000053669)
Medtronic plc (0001613103)
Palo Alto Networks Inc (0001327567)
Philip Morris International Inc. (0001413329)
SANDISK CORP (0001000180)
ST JUDE MEDICAL, LLC (0000203077)
VERIZON COMMUNICATIONS INC (0000732712)
WAL MART STORES INC (0000104169)
Weatherford International plc (0001603923)

In [ ]: