Recently someone shared a Mercor link on the Crime Analysis subreddit to help with AI product design. I collected a few different positions Mercor is recruiting for that may be of interest to my network -- writers, GIS, gov workers, and more. andrewpwheeler.com/2026/01/15/p...

New blog post, R code showing how to plan how long to monitor an intervention intended to increase arrest rates crimede-coder.com/blogposts/20...

Looking to hire part time help at Crime De-Coder. Get in touch or forward to interested students. crimede-coder.com/contact

Blog post for the new year is a reprint of a Criminal Justician post I did, We don't know what causes wide spread crime trends. crimede-coder.com/blogposts/20...

New blog post, year in review and putting together my predictions on whether AI will take all of our jobs. Short answer no I do not think that will happen, and it may induce demand for more work in the end. andrewpwheeler.com/2025/12/24/y...

Really important video about lack of physical security, and various lack of data security measures in Flock cameras. www.youtube.com/watch?v=uB0g...

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...

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...

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!

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.

Seasonal chart of Chicago robberies shows 10 year lows Example in crimepy library, github.com/apwheele/cri...

New blog post, what I think you should show in your tech resume andrewpwheeler.com/2025/11/01/w...

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...

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.

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.

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.

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...

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

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...

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.

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)

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

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.

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.

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...

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/...

Reminded of this old blog post in a thread on X, if you want to know how to fit a plateau in a regression model, this shows one way to constrain the coefficients and fit the model in scipy. andrewpwheeler.com/2022/05/02/f...

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...

New blog post, in which I discuss the error of "the difference between stat significant and not is not itself stat significant". It often causes people to post-hoc try to explain things that are easily just due to the standard error of estimates, andrewpwheeler.com/2025/07/28/t...

For an example much simpler than a pelican riding a bicycle, both Claude and ChatGPT cannot create an SVG knife.

Is gun shot detection tech worth the cost? I give an example cost-benefit analysis in this blog post, discussing lives saved. There is no consistent evidence at this point GSD reduces crime or increases clearances. crimede-coder.com/blogposts/20...

New blog post on project management, andrewpwheeler.com/2025/07/20/s... High level goal make a list of things to-do and do them in a reasonable amount of time. Everything you do should keep these high level goals in mind.

Another example of a prof selling their own self published (likely mediocre) book to thousands of students. The article does not say online, but this prof may have made over 100k profit per year from sales. dailyemerald.com/152165/featu...

New blog post, I show how to use LLMs to extract pieces of information from plain text, with an example of extracting out info like modus operandi from police narratives crimede-coder.com/blogposts/20...

Purchases for the Data Science for Crime Analysis with Python continue to trickle in, crimede-coder.com/blogposts/20..., One of the reasons I promote python is because python jobs are much more common in private sector. It is IMO a better personal investment than R.

Weekend project, using R2 + DuckDB wasm to build a low price frontend for big data analytics crimede-coder.com/graphs/GSUBo...

New blog post, finding outliers in proportions crimede-coder.com/blogposts/20... Useful for flagging officers in early intervention systems, or examining data with varying denominators.

Nerdsniped by a sequential decision problem on X, wrote up a few different solutions + simulations in python github.com/apwheele/Blo...

Interesting post of self teaching coding and now working in software dev in prison, turso.tech/blog/working...

New blog post, academic criminologists should be more focused on building stuff than writing papers, andrewpwheeler.com/2025/06/12/b...

With the new ASEBP site, my Criminal Justician essays were not transferred over. Putting them up on my crime de-coder site. First one is description why I am skeptical of a study of Denver alt response having large crime reductions, crimede-coder.com/blogposts/20....

I recently received a question on Poisson vs OLS models for a dose response relationship, and posted the exchange to my blog. Long story short even with count data OLS models can make sense, it depends on the functional form. andrewpwheeler.com/2025/05/28/a...

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.

Paper with Scott Jacques on stripping sensitive information from narratives is out, www.qualitativecriminology.com/pub/zhiuy6jg.... Ultimate goal to make it easier for qual people to share there data for replication. Has links to python code and uses open source models.

Please make your papers open access: there really are people out there who want to read them but don’t have access to subscription journals. Fortunately, making your work open access is both very easy and 100% free: www.lesscrime.info/post/how-to-...