Thoth, the public cloud resolver discussed in Thoth - an enhanced server-side resolution offered to the Python community, runs background data aggregation to collect similar information about Python packages (see handlers available). The pipeline collects information about GitHub repositories and links them to projects. If the project repository is archived, the resolver prints out a warning when such packages are resolved.
We maintain a database similar to pypa/advisory-db which collects “prescriptions”. The “archived project” knowledge is recorded there - see thoth-station/prescriptions. The prescription database is consumed by the resolver. If you would be interested, feel free to consume data we have about packages - we can combine efforts. Also, if such deprecate mechanism would be available on PyPI, we would like to consume it. It could be valuable to users.