looking up individuals is one thing, but to actually have the full dataset would be something else.
You can download the full datasets, though, at least by city / county / agency. The site I linked to is just one of many pooling from the same source. Local newspapers will run a story with that data once a year or so, which they sometimes put into charts or more readily searchable tables. This graph is missing from the Archive version, but each bubble pops up with this info:

an individual would have to do a shitload of legwork here to actually uncover the patterns or do any critical analysis.
Well, yes. Maybe with non-corporate journalists and coders we could further separate the SF Chronicle's chart so as to move pigs out of the "public safety employee" category.