Sony doesn't publish a master database of every PSN avatar's origin, but they fall into clear categories.
"PSN avatar [description]" or "[Game name] PSN avatar".The avatar roster rotates; delisted games' avatars may become unobtainable. Grab favorites while available.