Working Towards a Comprehensive Criminal Justice Data Repository
For criminal justice and more throughout Oklahoma
Data Sources
The ODX database was originally created for court data scraped from the Oklahoma State Court Network (OSCN) website.
Since then, it has branched out to include data spanning the entire criminal legal system, from jails and prisons to evictions and traffic tickets. See the full list of our sources for all details.
Data Products
Finding the raw data is a start, but it can only take you so far. In order to get real insight into how our state’s systems are working (and how they’re not), the data has to be cleaned, standardized, and reliably linked up across all the myriad sources it’s drawn from. And even once you’ve done that, it’s not worth much sitting alone in a database somewhere. That’s why ODX creates cleaned, ready-to-use data products on top of our raw data, and makes them available through an API that can connect wherever it’s needed.
These include:
Standardization between sources
Standarize columns and table names between district and municipal court data, as well as jail and prison data.
Allow for easy entity resolution and comprehsive timeline creation
Parsed and standardized OSCN case details, beyond what the raw data can provide.
Information on warrants
Information on bonds and pretrial release
Upcoming and past court dates, merged across cases
Offenses, with hand-entered text standardized into clean categories
and more
API integration into existing infrastructure
Because our API is built around existing open standards, it can be used to import data anywhere it needs to go — a CRM (e.g. Salesforce, Bloomerang), a dashboard, another database, a one-time analysis script in R, Python, or any other programming language, or even an Excel spreadsheet.