Bulk Data Submission Instructions
For researchers conducting secret shopper studies or organizations with multiple data points (pharmacy chains??? prescribers??? harm reduction orgs???), we offer a bulk submission option to help populate the map quickly.
- To help people make decisions about where they can (and can not) fill their bupe scripts, we need fresh data (ideally less than 30 days old).
- If you have bulk data, you can help us quickly fill out the map. Thank you!
- Use the spreadsheet template below to fill in your data. This format is important for batch uploading.
- Do not include any personally identifiable information in the notes. Simulated patient info can be included in the notes (e.g., pregnant) if relevant.
- We will take care of formatting and uploading to the map!
Step 1: Get the Template
We use a standard template to ensure data quality. Please view or download our official CryptPad template.
Access the TemplateAccess the Template Support Doc
Step 2: Fill Out Your Data
The only required fields are pharmacy_address, report_type (success or denied). Information about formulation, standardized_notes, and notes are optional (but useful!).
Step 3: Securely Submit Your File
Once your sheet is complete, please save it as a TSV file (`File` > `Save as` > `TSV (.tsv)`). We use TSV because some people might use commas in the address or notes line, but no one will use tabs. This makes importing and cleaning the data much more straightforward on our end and is easy to do on your end (win/win). To securely transfer files, please use the free, encrypted service WORMHOLE to send us your file.
- Go to wormhole.app.
- Upload your TSV file (tab separated values).
- Copy the secure link it generates.
- Email that single link to us at: code[at]opioidpolicy[dot]org
- NB - the file link is only active for 24hrs so I might ask you to resend it. Apologies in advanced!
Questions?
If you find a problem with the site or have a question, we want to know. Please contact us using our secure form.