select * from arrests where indictment = null

Probably also group by citizen id and sort by count. :-)

The list is of people who underwent a pre-employment biometric background check. So, roughly, anybody who works for a bank, is a public school teacher, acquires a security clearance, or is in the military. The level of "real patriotism" on the list is going to roughly correspond with the "real patriotism" of those groups of people.

I don't understand why there's so much fascination with the idea that this is some protester-busting tool. The article merely posits the hypothetical scenario that some people could be punished by their employer, because their employer might get a rap back and they wouldn't be able to tell it was First Amendment activity as opposed to some actual serious crime, because the FBI and local law enforcement is bad at data entry. Somehow people read that and think that the point of the whole system is "corporate fascism stopping the patriotic protesting democracy" when none of the employers actually care about that. Or in other words, an emergent problem in the system that might occur is being assumed to be the central planned feature of it.

It is none of my employers business whether I was arrested. It might OK, to be informed about convictions for certain crimes for certain jobs.

Knowing this absolutely has a chilling effect.

I can think of many cases where it could be your employers business that you were arrested:

1. You're going to miss work because you're in jail.

2. You were arrested for a crime that's related to your work. Like, money laundering or fraud if you work at a bank. Or having sex with a minor if you're a teacher.

3. You work in a field that requires lawful behavior from employees at all times preserve the integrity of the organization. Like, say, law enforcement.

Being arrested doesn't mean you are guilty of a crime, that's the issue.

Yes, but your employer still has a PR mess that they have to mop up while you and the criminal justice system figure that out.