All-in-one: setup → source → process → results → audit
Click or drag & drop your base CSV
ori, Agency Name, Murder…, Year, Month, State, Type
Or drag/click to upload manually
Click or drag & drop CDE CSV (Colab output or CDE Processor output)
Click or drag & drop aggregated scrape CSV (output from manual parser tool)
Agency Name, Murder, Rape, …, Year, Month
Download new RTCI submissions from Gmail to the Manual Uploads folder. Requires the email fetcher server: python3 fetch-rtci-attachments.py --serve
Select the Manual Uploads folder to auto-detect and parse files. Files are matched by name: Spokane*.xlsx, *city*.csv / *county*.csv (Ohio), Wisconsin*.csv, Miami*.xlsx, *SanJose* / *SJPD* (.html).
Preloaded data from agency PDFs and dashboards. Upload newer PDFs to replace, or update preloaded values when new months complete.
Upload 3 BCP files from NC SBI NIBRS extract. Agency.bcp is built-in (577 agencies). Streams large files — no memory issues.
Incident.bcp
ORI+OCA → date
Offense.bcp
Property crimes
VictimOffense.bcp
Violent crimes
Agencies with property z-score below −2 in the most recent 12 months
Upload the fully audited and corrected Combined CSV. All analytics below will run on the audited data.
Click or drag & drop audited CSV
Same format as the exported Combined CSV
Pulls latest population per ORI from S3 CDE data. Requires Agency Sourcing to be loaded (for ORI lookup).