SQLite: Find NOT NULL empty records

-- find NOT NULL empty records

SELECT COUNT(*) FROM big_list WHERE pubchem_cid IS NULL OR trim(pubchem_cid) ="";