So, I saw a link to the 1/6 cases charged already. I got curious and File>Internet Open>:
Local( {dt},
dt = Open(
"https://www.justice.gov/usao-dc/capitol-breach-cases",
HTML Table( 1, Column Names( 1 ), Data Starts( 2 ) )
);
dt << Set Name( "capitol-breach-cases" );
dt;
)
Thankfully, the charge(s) per case are separated by semicolons (;). I used the formula: Words(:"Charge(s)"n, ";"). This created a column with lists like this in each row:
{"Entering and Remaining in a Restricted Building", " Disorderly and Disruptive Conduct in a Restricted Building", " Violent Entry and Disorderly Conduct in a Capitol Building", " Parading, Demonstrating, or Picketing in a Capitol Building"}
So, now that I have that, how can I determine the counts for each charge phrase? Would make a great packed bar chart...
Or can I do this with Text Explorer and somehow customizing Regex?
Other?