[Theft/Loss of Controlled Substances](https://github.com/data-liberation-project/dea-theft-and-loss-counts/tree/main) ### Overview This repository contains [spreadsheets](https://github.com/data-liberation-project/dea-theft-and-loss-counts/blob/main/data/raw) from the US Drug Enforcement Administration (DEA), counting the number of controlled substance (and regulated chemical) thefts/losses reported to the agency — by state, business activity, loss type, and year — plus the overall quantities stolen/lost. The spreadsheets were obtained in May 2023 via a [Freedom of Information Act (FOIA) request](https://www.data-liberation-project.org/requests/controlled-substance-theft-and-loss/) submitted by the [Data Liberation Project](https://www.data-liberation-project.org/). This repository also contains [“tidy” CSV representations](https://github.com/data-liberation-project/dea-theft-and-loss-counts/blob/main/data/tidy) of the same data, plus the [Python code](https://github.com/data-liberation-project/dea-theft-and-loss-counts/blob/main/scripts/convert-to-csv.py) used for the conversion. ### Background The DEA [requires](https://www.deadiversion.usdoj.gov/21cfr_reports/theft/index.html) all entities it has authorized to manufacture or handle [controlled substances](https://www.deadiversion.usdoj.gov/schedules/) and “[listed chemicals](https://www.deadiversion.usdoj.gov/chem_prog/34chems.htm)” to inform the agency about any “theft or significant loss of any controlled substance, disposal receptacles or listed chemicals within one business day of discovery of such loss or theft.” Those reports are collected via the DEA’s [Theft Loss Reporting (TLR) system](https://apps.deadiversion.usdoj.gov/TLR/), which allows registrants to submit the following forms electronically: - [Form DEA-106](https://deadiversion.usdoj.gov/21cfr_reports/theft/DEA_Form_106.pdf), “Report of Theft or Loss of Controlled Substances,” [OMB Control No. 1117-0001](https://www.reginfo.gov/public/do/PRAOMBHistory?ombControlNumber=1117-0001) - [Form DEA-107](https://www.reginfo.gov/public/do/DownloadDocument?objectID=103735201), “Report of Theft or Loss of Listed Chemical,” [OMB Control No. 1117-0024](https://www.reginfo.gov/public/do/PRAOMBHistory?ombControlNumber=1117-0024) The Data Liberation Project’s [FOIA request](https://www.documentcloud.org/documents/22925202-2022-09-23-dojdea-tlr-foia-request), submitted in September 2022, sought database records collected through the TLR system, Form DEA-106, and Form DEA-107 (excluding narrative data fields and data fields that contain personal information about individual persons), plus all relevant database documentation. --- #### Related #data_source