Andy Wheeler
@crimede-coder.bsky.social
Data scientist, with background in criminal justice.
Consulting website at https://crimede-coder.com/
Personal blog at https://andrewpwheeler.com/
Consulting website at https://crimede-coder.com/
Personal blog at https://andrewpwheeler.com/
Pinned
Andy Wheeler
@crimede-coder.bsky.social
· Jan 16
Giving BlueSky a try, appreciate the follow.
Mostly technical stats and programming content, with a focus on issues in criminal justice.
Mostly technical stats and programming content, with a focus on issues in criminal justice.
New blog post on Crime De-Coder, coding agents risk leaking secrets.
I discuss two approaches to limit this risk. Whitelist IP were secrets can work from, or whitelist websites websearch tools can use.
crimede-coder.com/blogposts/20...
I discuss two approaches to limit this risk. Whitelist IP were secrets can work from, or whitelist websites websearch tools can use.
crimede-coder.com/blogposts/20...
Coding Agents Risk Leaking Secrets
Coding agents can leak secrets using exfiltration techniques. Here I tell you how to stop them or limit the harm.
crimede-coder.com
November 26, 2025 at 8:28 PM
New blog post on Crime De-Coder, coding agents risk leaking secrets.
I discuss two approaches to limit this risk. Whitelist IP were secrets can work from, or whitelist websites websearch tools can use.
crimede-coder.com/blogposts/20...
I discuss two approaches to limit this risk. Whitelist IP were secrets can work from, or whitelist websites websearch tools can use.
crimede-coder.com/blogposts/20...
New blog post on advice for crime analysts looking to break into data science. Learn a programming language (python is most popular), and pick up some machine learning or LLM skills.
Those are the minimal skills needed for entry level data science jobs. andrewpwheeler.com/2025/11/21/a...
Those are the minimal skills needed for entry level data science jobs. andrewpwheeler.com/2025/11/21/a...
Advice for crime analyst to break into data science
I recently received a question about a crime analyst looking to break into data science. Figured it would be a good topic for my advice in a blog post. I have written many resources over the years …
andrewpwheeler.com
November 21, 2025 at 2:07 PM
New blog post on advice for crime analysts looking to break into data science. Learn a programming language (python is most popular), and pick up some machine learning or LLM skills.
Those are the minimal skills needed for entry level data science jobs. andrewpwheeler.com/2025/11/21/a...
Those are the minimal skills needed for entry level data science jobs. andrewpwheeler.com/2025/11/21/a...
Another application for ARDrive and academics, pre-registrations
app.ardrive.io#/file/9badda...
Can see my grant with Arnold pre-reg data analysis plan, permanently available for everyone. I cannot delete this!
app.ardrive.io#/file/9badda...
Can see my grant with Arnold pre-reg data analysis plan, permanently available for everyone. I cannot delete this!
ArDrive
Secure, permanent storage.
app.ardrive.io
November 9, 2025 at 8:46 PM
Another application for ARDrive and academics, pre-registrations
app.ardrive.io#/file/9badda...
Can see my grant with Arnold pre-reg data analysis plan, permanently available for everyone. I cannot delete this!
app.ardrive.io#/file/9badda...
Can see my grant with Arnold pre-reg data analysis plan, permanently available for everyone. I cannot delete this!
New blog post on Crime De-Coder, a graph is worth 1000 tables, crimede-coder.com/blogposts/20...
There are many patterns just looking at a count of pre vs post crimes cannot tell you in traditional CompStat style tables.
There are many patterns just looking at a count of pre vs post crimes cannot tell you in traditional CompStat style tables.
Graphs are better than tables for CompStat
A graph is worth 1000 tables for CompStat
crimede-coder.com
November 9, 2025 at 2:17 PM
New blog post on Crime De-Coder, a graph is worth 1000 tables, crimede-coder.com/blogposts/20...
There are many patterns just looking at a count of pre vs post crimes cannot tell you in traditional CompStat style tables.
There are many patterns just looking at a count of pre vs post crimes cannot tell you in traditional CompStat style tables.
Seasonal chart of Chicago robberies shows 10 year lows
Example in crimepy library, github.com/apwheele/cri...
Example in crimepy library, github.com/apwheele/cri...
November 6, 2025 at 2:53 PM
Seasonal chart of Chicago robberies shows 10 year lows
Example in crimepy library, github.com/apwheele/cri...
Example in crimepy library, github.com/apwheele/cri...
Because my python book was written in quarto, it is pretty easy to translate to other languages using LLMs.
New blog post with code links, costs a total of $7. andrewpwheeler.com/2025/10/25/i...
New blog post with code links, costs a total of $7. andrewpwheeler.com/2025/10/25/i...
I translated my book for $7 using openai
The other day an officer from the French Gendarmerie commented that they use my python for crime analysis book. I asked that individual, and he stated they all speak English. But given my book is w…
andrewpwheeler.com
October 25, 2025 at 10:27 PM
Because my python book was written in quarto, it is pretty easy to translate to other languages using LLMs.
New blog post with code links, costs a total of $7. andrewpwheeler.com/2025/10/25/i...
New blog post with code links, costs a total of $7. andrewpwheeler.com/2025/10/25/i...
I have a few more European followers on here so will give this a shot -- I am doing translations of my python book to French/Spanish. I used openai for the first pass, and would like to find a French speaker for copy-editing.
Spanish copy-edit had a total of 77 suggested for 310 pages.
Spanish copy-edit had a total of 77 suggested for 310 pages.
October 14, 2025 at 11:01 AM
I have a few more European followers on here so will give this a shot -- I am doing translations of my python book to French/Spanish. I used openai for the first pass, and would like to find a French speaker for copy-editing.
Spanish copy-edit had a total of 77 suggested for 310 pages.
Spanish copy-edit had a total of 77 suggested for 310 pages.
If you are interested in supporting open science in criminology, consider joining the CrimConsortium
app.joinit.com/o/crimconsor...
Paying members help keep the lights on, but if you care about open science in crim, consider joining as a free member.
app.joinit.com/o/crimconsor...
Paying members help keep the lights on, but if you care about open science in crim, consider joining as a free member.
CrimConsortium Memberships - Membership Management Software
CrimRxiv is open access—and it will always be free for authors and readers. Our work is a communal effort. Through the CrimRxiv Consortium, we in ...
app.joinit.com
October 11, 2025 at 2:20 PM
If you are interested in supporting open science in criminology, consider joining the CrimConsortium
app.joinit.com/o/crimconsor...
Paying members help keep the lights on, but if you care about open science in crim, consider joining as a free member.
app.joinit.com/o/crimconsor...
Paying members help keep the lights on, but if you care about open science in crim, consider joining as a free member.
New blog post, having python record your keyboard and mouse and replay those events, andrewpwheeler.com/2025/10/10/r....
This is a way to automate workflows that are not directly scriptable.
This is a way to automate workflows that are not directly scriptable.
Recording your mouse and keyboard with python
The differently LLM providers have released computer use tools, Google’s Gemini being one of the most recent ones. They way these work, it submits and image, and then does tasks given general instr…
andrewpwheeler.com
October 10, 2025 at 6:49 PM
New blog post, having python record your keyboard and mouse and replay those events, andrewpwheeler.com/2025/10/10/r....
This is a way to automate workflows that are not directly scriptable.
This is a way to automate workflows that are not directly scriptable.
Given that NIJ stopped funding additional development of Crime Solutions, I scraped the website and archived the reviews in a permanent location using ardrive.
andrewpwheeler.com/2025/09/26/i...
andrewpwheeler.com/2025/09/26/i...
I scraped the Crime solutions site
Before I get to the main gist, I am going to talk about another site. The National Institute of Justice (NIJ) paid RTI over $10 million dollars to develop a forensic technology center of excellence…
andrewpwheeler.com
September 26, 2025 at 5:25 PM
Given that NIJ stopped funding additional development of Crime Solutions, I scraped the website and archived the reviews in a permanent location using ardrive.
andrewpwheeler.com/2025/09/26/i...
andrewpwheeler.com/2025/09/26/i...
www.crimrxiv.com/pub/lciht0xi...
And I would have got away with it, too, if it weren’t for you meddling kids": Experimentally falsifying Ghost Criminology, by Ian Adams
And I would have got away with it, too, if it weren’t for you meddling kids": Experimentally falsifying Ghost Criminology, by Ian Adams
Crimversations:
www.crimrxiv.com
September 15, 2025 at 12:09 PM
www.crimrxiv.com/pub/lciht0xi...
And I would have got away with it, too, if it weren’t for you meddling kids": Experimentally falsifying Ghost Criminology, by Ian Adams
And I would have got away with it, too, if it weren’t for you meddling kids": Experimentally falsifying Ghost Criminology, by Ian Adams
It is soft-launched, but my python package `crimepy` is intended to contain most of the work in my career. github.com/apwheele/cri...
September 8, 2025 at 11:53 AM
It is soft-launched, but my python package `crimepy` is intended to contain most of the work in my career. github.com/apwheele/cri...
Book review on the Idea Factory: Bell Labs and the Great Age of American Innovation.
Had no idea Bell had its hand in so many of the building blocks of modern computing. It is also interesting how science + engineering can come together to build great things.
andrewpwheeler.com/2025/09/02/r...
Had no idea Bell had its hand in so many of the building blocks of modern computing. It is also interesting how science + engineering can come together to build great things.
andrewpwheeler.com/2025/09/02/r...
Recommend reading The Idea Factory, Docker python tips
A friend recently recommended The Idea Factory: Bell Labs and the Great Age of American Innovation by Jon Gertner. It is one of the best books I have read in awhile, so also want to recommend to th…
andrewpwheeler.com
September 2, 2025 at 1:01 PM
Book review on the Idea Factory: Bell Labs and the Great Age of American Innovation.
Had no idea Bell had its hand in so many of the building blocks of modern computing. It is also interesting how science + engineering can come together to build great things.
andrewpwheeler.com/2025/09/02/r...
Had no idea Bell had its hand in so many of the building blocks of modern computing. It is also interesting how science + engineering can come together to build great things.
andrewpwheeler.com/2025/09/02/r...
I have updated my Sworn Dashboard, according to the FBI, the percent of female sworn has gone down in 2024 after consistent rises over the last 8 years.
This is mostly due to composition though, more agencies are reporting in the FBI database than in prior years.
This is mostly due to composition though, more agencies are reporting in the FBI database than in prior years.
August 29, 2025 at 12:42 PM
I have updated my Sworn Dashboard, according to the FBI, the percent of female sworn has gone down in 2024 after consistent rises over the last 8 years.
This is mostly due to composition though, more agencies are reporting in the FBI database than in prior years.
This is mostly due to composition though, more agencies are reporting in the FBI database than in prior years.
Deep Research tools cite open access work much more often in my experiments than closed source materials. I go over a few examples for Google, ChatGPT, and Perplexity in this blog post.
andrewpwheeler.com/2025/08/28/d...
CJ folks should be posting pre/post prints to plain text HTML (like CrimRXiv)
andrewpwheeler.com/2025/08/28/d...
CJ folks should be posting pre/post prints to plain text HTML (like CrimRXiv)
August 28, 2025 at 11:09 AM
Deep Research tools cite open access work much more often in my experiments than closed source materials. I go over a few examples for Google, ChatGPT, and Perplexity in this blog post.
andrewpwheeler.com/2025/08/28/d...
CJ folks should be posting pre/post prints to plain text HTML (like CrimRXiv)
andrewpwheeler.com/2025/08/28/d...
CJ folks should be posting pre/post prints to plain text HTML (like CrimRXiv)
The local newspaper did a writeup of this in Raleigh -- Cisco does a round of layoffs every year (I guess for quarterly reporting to make expenses look lower). There are people who go on the merry go round and like it (they get several months of severance and then get hired back). Free vacation.
Oh that's fine, Cisco isn't important, hardly anything relies on its technology working correctly at all times without fail cuz only a very small percentage of 85% of the whole internet runs on its systems, it's literally fine, stop panicking and go learn to code
Software engineers among hardest hit in latest Cisco layoffs
More than 200 Cisco workers across the San Francisco Bay area will be cut
www.itpro.com
August 26, 2025 at 7:28 PM
The local newspaper did a writeup of this in Raleigh -- Cisco does a round of layoffs every year (I guess for quarterly reporting to make expenses look lower). There are people who go on the merry go round and like it (they get several months of severance and then get hired back). Free vacation.
Pro python tip, I like to develop in the REPL. That way I can use the reload library to edit functions. E.g.
from src import myfunc
test = myfunc(...) # errors out
Then can do
from importlib import reload
reload(myfunc) # edit the source before this
test = myfunc(...) # works
from src import myfunc
test = myfunc(...) # errors out
Then can do
from importlib import reload
reload(myfunc) # edit the source before this
test = myfunc(...) # works
August 26, 2025 at 2:55 PM
Pro python tip, I like to develop in the REPL. That way I can use the reload library to edit functions. E.g.
from src import myfunc
test = myfunc(...) # errors out
Then can do
from importlib import reload
reload(myfunc) # edit the source before this
test = myfunc(...) # works
from src import myfunc
test = myfunc(...) # errors out
Then can do
from importlib import reload
reload(myfunc) # edit the source before this
test = myfunc(...) # works
New blog post, using the SPPT to monitor changes in crime patterns. crimede-coder.com/blogposts/20...
Many of the other techniques (ESRI's emerging hotspots, or KDE maps) tend to be too noisy. This controls for multiple comparisons.
Many of the other techniques (ESRI's emerging hotspots, or KDE maps) tend to be too noisy. This controls for multiple comparisons.
Using the SPPT to Monitor Changes in Crime
Using the Spatial Point Pattern Test to Monitor Changes in Crime
crimede-coder.com
August 24, 2025 at 10:32 PM
New blog post, using the SPPT to monitor changes in crime patterns. crimede-coder.com/blogposts/20...
Many of the other techniques (ESRI's emerging hotspots, or KDE maps) tend to be too noisy. This controls for multiple comparisons.
Many of the other techniques (ESRI's emerging hotspots, or KDE maps) tend to be too noisy. This controls for multiple comparisons.
San Diego sheriff's office is advertising a *work from home* dispatcher position www.linkedin.com/posts/activi...
August 23, 2025 at 11:29 AM
San Diego sheriff's office is advertising a *work from home* dispatcher position www.linkedin.com/posts/activi...
For folks interested in learning python, grab an epub copy of my Data Science for Crime Analysis with Python, crimede-coder.com/cdcstore/pro....
I made a limited time coupon -- use Ebook20 which lowers the price of the epub to $19.99. Good for the next week.
I made a limited time coupon -- use Ebook20 which lowers the price of the epub to $19.99. Good for the next week.
August 22, 2025 at 5:36 PM
For folks interested in learning python, grab an epub copy of my Data Science for Crime Analysis with Python, crimede-coder.com/cdcstore/pro....
I made a limited time coupon -- use Ebook20 which lowers the price of the epub to $19.99. Good for the next week.
I made a limited time coupon -- use Ebook20 which lowers the price of the epub to $19.99. Good for the next week.
Check out my bookshelf 'Stats & Operations Research' on Bibliome: bibliome.club/shelf/p69ekhpw (via @andreasthinks.me )
Stats & Operations Research - Bibliome
Non-fiction books broadly related to statistical topics and operations research
bibliome.club
August 20, 2025 at 12:31 PM
Check out my bookshelf 'Stats & Operations Research' on Bibliome: bibliome.club/shelf/p69ekhpw (via @andreasthinks.me )
Recently found James Tuttle's substack on macro crime trends in the US. It is an excellent follow crimeforecast.substack.com/p/the-smartp...
The Smartphone-Induced Teen Crime Decline
Gen Z made crime rates 'crash out'
crimeforecast.substack.com
August 20, 2025 at 11:29 AM
Recently found James Tuttle's substack on macro crime trends in the US. It is an excellent follow crimeforecast.substack.com/p/the-smartp...
Using Chicago open data for some example graphs, here is the time series trends for street robberies. Basically as low as it has been going back to 2015
August 16, 2025 at 9:17 PM
Using Chicago open data for some example graphs, here is the time series trends for street robberies. Basically as low as it has been going back to 2015
My peer reviewed paper on up-adjusted NIBRS crime estimates based on domestic violence victimization reporting rates (with Alex Piquero) is now out in Crime & Delinquency.
journals.sagepub.com/doi/10.1177/...
journals.sagepub.com/doi/10.1177/...
August 9, 2025 at 6:48 PM
My peer reviewed paper on up-adjusted NIBRS crime estimates based on domestic violence victimization reporting rates (with Alex Piquero) is now out in Crime & Delinquency.
journals.sagepub.com/doi/10.1177/...
journals.sagepub.com/doi/10.1177/...