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) ="";

"You’re not wrong, Walter, you’re just an asshole."