the problem
National crime data exists at enormous scale, but the people who need it — agencies, analysts, local government — need it at the level of one jurisdiction, one agency, one year against another. The raw UCR datasets are too large and too irregular for that question to be answered in a spreadsheet.
what we built
An analytics platform that ingests FBI Uniform Crime Reporting data at full scale and makes it queryable for trend analysis and cross-jurisdiction comparison. A second layer resolves records to ORI identifiers — the originating-agency code behind every report — so performance and reporting can be examined per agency rather than per county or state.
what it changed
Questions that required a research team become queries. An agency can see itself against comparable agencies on the same definitions, and reporting gaps are visible rather than hidden in aggregates.