3e:null 3f:["$","title",null,{"children":"Drug-Checking Reaction Index | Hydrogen Studios's Workspace | Observable"}] 45:T501,substanceLegend = { const substanceResults = html` ${stylesheet} ${viewof select}
${data1 .filter((r) => r.substance == select) .map( (r) => htl.html`

${r["reagentAbbr"]} • ${r["reagent"]} Reagent ${r["notes"]}

` )}`; return substanceResults; }46:[{"id":"49a1fcfc4167a206d77133864ace151428cbd85608e41d2eb553ec2bf7ee8c6179ed371903a3612e756e9a7f482d7bca7f6988c04066508b7138ae9cac559a84","href":"https://static.observableusercontent.com/files/49a1fcfc4167a206d77133864ace151428cbd85608e41d2eb553ec2bf7ee8c6179ed371903a3612e756e9a7f482d7bca7f6988c04066508b7138ae9cac559a84","name":"street-meth.gif","type":"image/gif","lastModified":1702616250724.849,"size":21546368},{"id":"992edd65139e4216e66c1de6650c82f622fb739c688e23c9a963e69d853248ee336ee134ac52e660b6cac40e824d4499e459f58ec16a5cb2df0fcaa50d73a31f","href":"https://static.observableusercontent.com/files/992edd65139e4216e66c1de6650c82f622fb739c688e23c9a963e69d853248ee336ee134ac52e660b6cac40e824d4499e459f58ec16a5cb2df0fcaa50d73a31f","name":"drug_testing@3.db","type":"application/x-sqlite3","lastModified":1702616250724.849,"size":258048},{"id":"c9c920fa90a86ec6f878bbb9650d9f5d951276a895d7bbbfbb5b94b7fea18657697cc18babfddad6098c1e623f979d5d3c9f20d7a665926678582c2084d09b7d","href":"https://static.observableusercontent.com/files/c9c920fa90a86ec6f878bbb9650d9f5d951276a895d7bbbfbb5b94b7fea18657697cc18babfddad6098c1e623f979d5d3c9f20d7a665926678582c2084d09b7d","name":"reactions.json","type":"application/json","lastModified":1702616250724.849,"size":831128}] 43:{"id":"527b4c6d85580a4e","slug":null,"title":"Drug-Checking Reaction Index","thumbnail":"b24c436b05aaffa1bcf7bb3b00520ad40f12df7d17ee35deefc92640bc355006","access_level":"public","create_time":"$D2023-12-15T04:57:30.724Z","update_time":"$D2023-12-15T05:05:16.538Z","view_time":null,"first_public_time":"$D2023-12-15T04:57:30.724Z","has_unpublished_edits":null,"fork":{"id":"c867e1abc89e2f0f","slug":null,"title":"Drug-Checking Reaction Index","owner":{"id":"edf006f20cc12e78","login":"hydrogen-studios","name":"Hydrogen Studios"}},"stars":0,"starred":false,"owner":{"type":"team","id":"43ded178cf3bf5d4","login":"hydrogen-studios-ws","name":"Hydrogen Studios's Workspace","avatar_url":"https://avatars-next.observableusercontent.com/a3819858e41e83faa03c6094f999db9b77b831793e1f01366b038213cdf6879b","tier":"starter_2024","bio":"","following":false},"version":12009,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"f8eaeff3dff9c463","login":"hydrogen-studios","name":"Hydrogen Studios","avatar_url":"https://avatars-next.observableusercontent.com/da7ae7a82e2a63c454a303a0d3502ceeaac43054601ff127b4371b72fe82ca58","tier":null,"bio":"","following":false}],"members":[{"type":"individual","id":"f8eaeff3dff9c463","login":"hydrogen-studios","name":"Hydrogen Studios","avatar_url":"https://avatars-next.observableusercontent.com/da7ae7a82e2a63c454a303a0d3502ceeaac43054601ff127b4371b72fe82ca58","tier":null,"role":"editor"},{"type":"team","id":"43ded178cf3bf5d4","login":"hydrogen-studios-ws","name":"Hydrogen Studios's Workspace","avatar_url":"https://avatars-next.observableusercontent.com/a3819858e41e83faa03c6094f999db9b77b831793e1f01366b038213cdf6879b","tier":"starter_2024","role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Drug-Checking Reaction Index","cells":[{"id":0,"value":"# Drug-Checking Reaction Index\nA comprehensive reference by Know Better","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":10730,"value":"
This notebook will have to serve as a temporary resource until we launch our CV-assisted Web app in November or December (2023). This notebook is a WIP too, and we will very gladly review and accept all pull/merge requests that enhance this public utility – KBHR.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":178,"value":"\nDrug-checking equipment such as reagent test kits and immunoassay strips show clear potential to save lives, but only if people know how—and how _not_—to read the results. This notebook is a public resource and aggregation of data that's maintained in the interest of reducing misuse of drug-checking reagents and misinterpretation of results.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":10792,"value":"## How to Use Drug-Checking Reagents\nProcedurally, these tests are quite simple to perform. How you approach this depends on the form of your substance initially.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":11933,"value":"### What It Looks Like\nFrankly? Looks like _crime_, buddy. Just kidding. Please refer to the GIF below for a high-level overview of the process. Don't worry: If you didn't buy from _Know Better_, you can still test and learn how to do it through this same facility.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":10805,"value":"\nstreetMeth = FileAttachment(\"street-meth.gif\").image()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":11948,"value":"I can tell that you are learning a lot. Proud of you. Us, really.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":11577,"value":"## Substances\n\nIf you have some idea of what you're testing, or at least what it was sold as or how it presents visually, that bias can be healthy in the way that it helps narrow the top most likely reactions to be observing. Further, that likelihood can be derived using historical verified drug-checking data, in which there are many useful fields like the \"Sold As\" name and relative quantities or ratios of verified substances with respect to the same baseline.\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":11359,"value":"$45","pinned":false,"hidden":true,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":11912,"value":"\n

${r[\"substance\"]} ${r[\"notes\"]}

\n `)}","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":10195,"value":"function compareGradients(a, b) {\n const i1 = d3.interpolateHslLong(a.startColor, a.endColor)(1);\n const i2 = d3.interpolateHslLong(b.startColor, b.endColor)(1);\n\n if (i1 < i2) return -1;\n if (i1 == i2) return 0;\n return 1;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3729,"value":"

","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":3648,"value":"### Known Reaction Count by Reagent","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":3025,"value":"Plot.plot({\n color: { legend: false },\n marginLeft: 50,\n width,\n marks: [\n Plot.barX(\n data1,\n Plot.groupY(\n { x: \"count\" },\n { y: \"reagentAbbr\", tip: true, fill: (d) => d.endColor }\n )\n ),\n Plot.ruleX([0])\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":38,"value":"### Exploring Raw Data","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":7,"value":"select \n r2.name reagent,\n case r2.name when 'Simon' then 'SI' when 'Morris' then 'MO' when 'Robadope' then 'RO' when 'Marquis' then 'MQ' when 'Mandelin' then 'MA' when 'Mecke' then 'ME' when 'Froehde' then 'FR' when 'Hofmann' then 'HO' when 'Liebermann' then 'LI' when 'Ehrlich' then 'EH' else r2.name end reagentAbbr,\n s1.name substance,\n r1.reagentId,\n r1.substanceId,\n c1.hex startColor,\n c2.hex endColor,\n r1.notes\nfrom reactions r1\njoin reagents r2 on r2._id = r1.reagentId\njoin substances s1 on s1._id = r1.substanceId\n--left join colors c1 on c1._id = r1.startColorId\njoin colors c1 on c1._id = r1.startColorId\njoin colors c2 on c2._id = r1.endColorId\nwhere c1.hex != c2.hex\nand r2.name not in ('Folin', 'Gallic', 'Cannabis (4-AP)', 'Scott', 'Zimmermann')\norder by startColor","pinned":false,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"data1","database":"drug_testing@3.db"},{"id":3503,"value":"data = substances","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":36,"value":"# Appendix","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":11418,"value":"viewof select = Inputs.select(\n [...new Set(data1.map((r) => r.substance).sort())],\n {\n label: \"Substance\",\n width: 500\n }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3549,"value":"data","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":11990,"value":"","pinned":true,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"reactions.json"},{"id":11991,"value":"","pinned":true,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"drug_testing@3.db"},{"id":12,"value":"theme({\n colors: { primary: \"#7370ff\", secondary: \"#0d978b\", accent: \"#ff4d00\" },\n marker: \"lower-roman\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":17,"value":"stylesheet","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":14,"value":"import { stylesheet, theme } from \"@ajar/css\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3492,"value":"import { substances } from \"@ajar/dose-app\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1134,"value":"db = FileAttachment(\"drug_testing@3.db\").sqlite()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":10307,"value":"import {Icicle} from \"@d3/icicle-component\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":10433,"value":"reactions = FileAttachment(\"reactions.json\").json()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":10422,"value":"reactions.colors = _.flatten()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3094,"value":"viewof selectReagent = Inputs.select(\n [...new Set(data1.map((r) => r.reagent))],\n {\n label: \"Reagent\"\n }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":11008,"value":"### Procure Some Reagents\nIt's not necessary that you have Know Better reagents, so long as they are from an honest vendor and they are not spoiled, expired, or contaminated. If you are trying to purchase reagents and want to go with a more established brand, you can't go wrong with DanceSafe (funds permitting). You can find a list of vendors on the r/ReagentTesting subreddit.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":12005,"value":"","pinned":true,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"var:data1"}],"files":"$W46","stdlib":"1"}} 44:"$43:body"