Be careful if one of the column names is "SELECT * FROM SECRET_PASSWORDS"

I can't believe I get to do this - but I have a blog post on it! gmcirco.github.io/blog/posts/d...

Currently working on a small analysis, using some open-source data from the ATF on the origin of seized crime guns.

And in my home state of Illinois, a close to 40% of seized crime guns come across the border from Indiana:

In fact, most of these guns come from South-Atlantic states with much looser gun laws than New York:

Where do crime guns in your state come from? In many places, NOT the same state the gun was registered in! For example, more than 80% of seized crime guns in New York were bought or registered somewhere else:

It's a lot harder to get good engagement on here, compared to what Twitter was, but the situation over there is just unacceptable.

Bit of a preview of something I've been working on - revisiting Project Green Light Detroit. One thing I always wanted to delve a bit deeper into was the relationship between PGLD and the proactive police presence. Below is a plot showing the pretty stark change post-Green Light.

Yeah, I agree. It is such a a crucial skill that it surprises me that fewer "scientists" aren't aware of it. That being said, many of us don't really get training on this in the typical stats+methods courses

Here's a blog post about the one important skill I *didn't* learn in grad school: SQL! Here I talk a bit about using SQL inside of R, and how to use DuckDB to speed up analysis of large datasets. Looking back, something I wish I had learned a lot earlier. gmcirco.github.io/blog/posts/d...