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/
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...
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...
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)
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.
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/...
Reminded of this old post, as Chris Bruce is doing a talk on historical overview of the crime analysis field.
Seattle hotspots are basically unchanged in 100 years (Schmid has a few in the 20's).
andrewpwheeler.com/2015/06/12/f...
Seattle hotspots are basically unchanged in 100 years (Schmid has a few in the 20's).
andrewpwheeler.com/2015/06/12/f...
July 30, 2025 at 12:30 PM
Reminded of this old post, as Chris Bruce is doing a talk on historical overview of the crime analysis field.
Seattle hotspots are basically unchanged in 100 years (Schmid has a few in the 20's).
andrewpwheeler.com/2015/06/12/f...
Seattle hotspots are basically unchanged in 100 years (Schmid has a few in the 20's).
andrewpwheeler.com/2015/06/12/f...
For an example much simpler than a pelican riding a bicycle, both Claude and ChatGPT cannot create an SVG knife.
July 27, 2025 at 4:47 PM
For an example much simpler than a pelican riding a bicycle, both Claude and ChatGPT cannot create an SVG knife.
Besides the fact you could almost do this yourself anymore (you can post pre-prints with self-cites and they get picked up). My personal blog is picked up by Google Scholar.
Blog cited around ~10 times in real papers, and it had references in the posts. Then GS crawled rest of my site.
Blog cited around ~10 times in real papers, and it had references in the posts. Then GS crawled rest of my site.
May 18, 2025 at 10:45 AM
Besides the fact you could almost do this yourself anymore (you can post pre-prints with self-cites and they get picked up). My personal blog is picked up by Google Scholar.
Blog cited around ~10 times in real papers, and it had references in the posts. Then GS crawled rest of my site.
Blog cited around ~10 times in real papers, and it had references in the posts. Then GS crawled rest of my site.
Are you interested in designing network experiments where you control the number of direct treated vs spillover? Check out these functions I have written in python to optimally spread out treatment in your network given constraints
github.com/apwheele/Blo...
github.com/apwheele/Blo...
May 3, 2025 at 1:09 PM
Are you interested in designing network experiments where you control the number of direct treated vs spillover? Check out these functions I have written in python to optimally spread out treatment in your network given constraints
github.com/apwheele/Blo...
github.com/apwheele/Blo...
One of the ideas I had, but have never put the details to paper, is a monitoring system for crimes that looks at the relative mix. Mostly for theft related crimes, to see if displacement occurs from one type to another.
There are all sorts of large scale changes in US.
There are all sorts of large scale changes in US.
April 24, 2025 at 7:41 PM
One of the ideas I had, but have never put the details to paper, is a monitoring system for crimes that looks at the relative mix. Mostly for theft related crimes, to see if displacement occurs from one type to another.
There are all sorts of large scale changes in US.
There are all sorts of large scale changes in US.
gmcirco.github.io/blog/posts/f...
Gio examines the time in between traffic tickets to show implausible distributions in the recorded CT stop data. I.e. officers saying they did multiple stops within 10 minutes.
Gio examines the time in between traffic tickets to show implausible distributions in the recorded CT stop data. I.e. officers saying they did multiple stops within 10 minutes.
March 12, 2025 at 11:45 AM
gmcirco.github.io/blog/posts/f...
Gio examines the time in between traffic tickets to show implausible distributions in the recorded CT stop data. I.e. officers saying they did multiple stops within 10 minutes.
Gio examines the time in between traffic tickets to show implausible distributions in the recorded CT stop data. I.e. officers saying they did multiple stops within 10 minutes.
Even accounting for multiple neighborhoods, this is likely to be so rare (with a baseline mean of 58 surveys), it probably is some type of error in the survey methodology offhand based on the info given.
March 5, 2025 at 4:58 PM
Even accounting for multiple neighborhoods, this is likely to be so rare (with a baseline mean of 58 surveys), it probably is some type of error in the survey methodology offhand based on the info given.
Have a table that is too big to fit into memory? Read it in chunks. Here is an example profiling memory in pandas + sqlalchemy for different databases
andrewpwheeler.com/2021/08/12/c...
andrewpwheeler.com/2021/08/12/c...
February 19, 2025 at 1:32 PM
Have a table that is too big to fit into memory? Read it in chunks. Here is an example profiling memory in pandas + sqlalchemy for different databases
andrewpwheeler.com/2021/08/12/c...
andrewpwheeler.com/2021/08/12/c...
Monthly credit card or ATM fraud in Minneapolis
January 29, 2025 at 1:22 PM
Monthly credit card or ATM fraud in Minneapolis
New blog post, crime analysts make too many BOLOs. They are low value to the department, and should not be the majority of analysts time or products.
crimede-coder.com/blogposts/20...
crimede-coder.com/blogposts/20...
January 26, 2025 at 1:47 PM
New blog post, crime analysts make too many BOLOs. They are low value to the department, and should not be the majority of analysts time or products.
crimede-coder.com/blogposts/20...
crimede-coder.com/blogposts/20...
Early registration for the ASEBP conference at whova.com/portal/regis...
I was one of the reviewers for sessions. The Renee has built something really special with this group.
I was one of the reviewers for sessions. The Renee has built something really special with this group.
January 22, 2025 at 12:55 PM
Early registration for the ASEBP conference at whova.com/portal/regis...
I was one of the reviewers for sessions. The Renee has built something really special with this group.
I was one of the reviewers for sessions. The Renee has built something really special with this group.
Combining reported crime from NIBRS, and estimates of under-reporting from the NCVS, myself and Alex Piquero created a methodology to create a close to real time estimate of the total number of DV incidents. Supported by Council on CJ.
counciloncj.org/toward-a-bet...
counciloncj.org/toward-a-bet...
January 21, 2025 at 1:01 PM
Combining reported crime from NIBRS, and estimates of under-reporting from the NCVS, myself and Alex Piquero created a methodology to create a close to real time estimate of the total number of DV incidents. Supported by Council on CJ.
counciloncj.org/toward-a-bet...
counciloncj.org/toward-a-bet...
Poisson Z for this is < 2, 2*(sqrt(100) - sqrt(82)) ~ 1.9
So going from 80 to 100 is not outside of the range of normal Poisson variation. And looking at monthly it looks like fairly normal variation.
So going from 80 to 100 is not outside of the range of normal Poisson variation. And looking at monthly it looks like fairly normal variation.
January 17, 2025 at 8:21 PM
Poisson Z for this is < 2, 2*(sqrt(100) - sqrt(82)) ~ 1.9
So going from 80 to 100 is not outside of the range of normal Poisson variation. And looking at monthly it looks like fairly normal variation.
So going from 80 to 100 is not outside of the range of normal Poisson variation. And looking at monthly it looks like fairly normal variation.
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.
January 16, 2025 at 8:57 PM
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.