2b:null 2c:["$","title",null,{"children":"Search & Download the Librela sADR Data | d8abased | Observable"}] 31:T4ff,## Search EVVet Apart from research and signal detection, an invaluable benefit of such a large and growing dataset of sADRs, is its usefulness to diagnosticians (including pet owners) worldwide. Prior to the publication of this page, searching the EVVet data required downloading, merging & sanitizing, and then feeding the results into a search engine: a task mostly only accessible to data/computer scientists. Thanks to some good ol’ data wrangling and helpful features of [Observable](https://observablehq.com), the full EVVet dataset is now indexed and searchable below. The obvious use case is to search for a specific reaction, but do explore the many other columns available. For example, say your or your patient’s dog has bloodshot eyes, and you suspect *uveitis*. Simply type in *bloodshot* or *uveitis* into the search field, and then scroll to see all the matches. It’s worth trying different terms for your symptom as case reports describe the same symptom in different ways. The results include many useful columns, from co-occurring reactions to breed. Again, bear in mind that the totals themselves are likely [grossly underreported](https://pubmed.ncbi.nlm.nih.gov/16689555/), so be careful before you assume that a small number like _5_ is truly _5_.32:[{"id":"73cbeb4887bac22e0e73e5327ca76b1ad37d0052fae86c9287f165cdfee1faf6d58bcd6bfa12317589bb5df556f2fbd5fa37a58beffc48a4e5cfa1cb5293edd7","href":"https://static.observableusercontent.com/files/73cbeb4887bac22e0e73e5327ca76b1ad37d0052fae86c9287f165cdfee1faf6d58bcd6bfa12317589bb5df556f2fbd5fa37a58beffc48a4e5cfa1cb5293edd7","name":"search-download.jpg","type":"image/jpeg","lastModified":1720743986941.195,"size":137549}] 2f:{"id":"1e0a624a28a2e71c","slug":"searchanddownload","title":"Search & Download the Librela sADR Data","thumbnail":"f0b7c9e7759bf7a0a13ce406539dafe3e98d8019dba29a7cad84c07c789061cb","access_level":"public","create_time":"$D2024-07-12T00:26:26.941Z","update_time":"$D2024-09-26T04:51:07.688Z","view_time":null,"first_public_time":"$D2024-07-13T05:28:52.055Z","fork":true,"stars":0,"starred":false,"owner":{"type":"team","id":"387bada7be81c746","login":"d8abased","name":"d8abased","avatar_url":"https://avatars-next.observableusercontent.com/5680b5bdb4c31365df3342e07cb358027698748c24682dbd4476d6e8cc3e9e82","tier":"starter_2024"},"version":4781,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"ad011ae0dc79cf45","login":"d8abased","name":"the d8a team","avatar_url":"https://avatars-next.observableusercontent.com/70386b934552f1ef82ce5a323c14a14824b8e72ac7d241df9ecb75c85c27608b","tier":null}],"members":[{"type":"team","id":"387bada7be81c746","login":"d8abased","name":"d8abased","avatar_url":"https://avatars-next.observableusercontent.com/5680b5bdb4c31365df3342e07cb358027698748c24682dbd4476d6e8cc3e9e82","tier":"starter_2024","role":"editor"},{"type":"individual","id":"ad011ae0dc79cf45","login":"d8abased","name":"the d8a team","avatar_url":"https://avatars-next.observableusercontent.com/70386b934552f1ef82ce5a323c14a14824b8e72ac7d241df9ecb75c85c27608b","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":true,"trashed":false,"subscribed":null,"forks":1,"collection":{"id":"8e2a9ac146d4c315","slug":"librela","title":"Librela","owner":{"id":"387bada7be81c746","login":"d8abased","name":"d8abased"}},"type":"notebook","body":{"title":"Search & Download the Librela sADR Data","cells":[{"id":0,"value":"# Search & Download the Librela sADR Data\n## A Fast & Convenient Tool to Search & Download Librela sADR and VeDDRA Data","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":407,"value":"

The search for something can prove as interesting as finding it.
— Paulo Coelho

","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined"},{"id":375,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":4325,"value":"renderMenu()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":99,"value":"$31","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":3419,"value":"

💡 tip
EVVet is based in Europe, so be sure to try U.K. spellings for certain words. For example, **_diarrhoea_**, **_anaemia_**, etc.

","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":115,"value":"Try the search yourself...","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":27,"value":"viewof search_dashboard = {\n return Inputs.form(\n {\n search: viewof search,\n only_veddra: viewof only_veddra\n },\n {\n template: (inputs) => htl.html`\n \n

${inputs.search}

${inputs.only_veddra}

\n `\n }\n )\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":30,"value":"Inputs.table(search_dashboard.search, {\n rows: 30.7,\n // height: 600,\n columns: [\n \"Received date\",\n \"Case number\",\n \"Reporter\",\n \"Country\",\n \"Reaction\",\n // search_dashboard['veddra'][0] === \"Include VeDDRA (beta)\" ? \"VeDDRA SOC\" : \"\",\n // search_dashboard['veddra'][0] === \"Include VeDDRA (beta)\" ? \"VeDDRA HLT\" : \"\",\n \"VeDDRA SOC\",\n \"VeDDRA HLT\",\n \"Gender\",\n \"Breed\", \n \"Animals affected\",\n \"Animals treated\",\n \"Animals died\",\n \"Species\", \n \"Drug\"\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":4019,"value":"
\n## Search VeDDRA\n\nThe _Veterinary Dictionary for Drug Related Affairs_, colloquially known as **VeDDRA**, is a harmonized system for categorizing reactions: a standardized way for veterinary health professionals worldwide to identify a reaction and the systemic disorder underlying that reaction. The European Medicines Agency provides [a document that outlines the principles of VeDDRA and how clinicians should use it](https://www.ema.europa.eu/en/documents/regulatory-procedural-guideline/guidance-notes-use-veterinary-dictionary-drug-regulatory-activities-veddra-terminology-reporting-suspected-adverse-events-animals-and-humans_en.pdf).\n\nYou can look up individual reactions and disorders to cross-reference them in VeDDRA. ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":4370,"value":"

📝 Note
We only include the `A`nimal and `C`ommon terminology. `H`uman has been filtered out of this dataset for obvious reasons.

","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":4115,"value":"viewof search_veddra = Inputs.search(veddra, {\n placeholder: \"Search VeDDRA...\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":4113,"value":"Inputs.table(search_veddra, {\n rows: 20.7,\n columns: [\n \"Current Low Level Term (LLT)\",\n \"Current System Organ Class (SOC) Term\",\n \"Current High Level Term (HLT)\",\n \"Current Preferred Term (PT)\"\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":4333,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":2494,"value":"## A Few Useful (Somewhat Hidden) Features","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":33,"value":"The search interface has several useful features that aren’t entirely obvious. So here’s a quick list:\n\n#### Automatic search on every column\nThe keyword you type will search against every column. Search for *veterinarian* in the EVVet data, for instance, and you’ll see only the rows reported by vets.\n\n#### Click column header to sort\nYou can click on any column header to sort by that column. \n\n#### Download your search results\nIf you want more control over the search results, you can click the three vertical dots next to the search results table and download the search results in various formats (including `csv` which _Excel_ and _Numbers_ both support). ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":43,"value":"image = FileAttachment(\"search-download.jpg\").image({\n width: 300,\n style: \"border-radius: 1rem;\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":387,"value":"#### 📦 Download *all* the data\nIf you leave the search field blank, you can download the entire dataset. Alternatively, here’s a handy direct link to [`download the data →`](https://github.com/d8abased/librela/raw/refs/heads/main/data/output/evvet/librela/librela.csv) from github.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":2386,"value":"Ignore everything below this; it’s for the 🤓s. It contains all the code that transforms the data for display above.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":4329,"value":"renderMenu()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":4308,"value":"cellFooter","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":4311,"value":"cellDataLoaders","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":4354,"value":"import {openSomeLinksInNewTab} from \"@d8abased/introduction\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":4345,"value":"import {globals} from \"@d8abased/introduction\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":4322,"value":"import {renderMenu} from \"@d8abased/introduction\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":4301,"value":"import {cellFooter} from \"@d8abased/introduction\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":4304,"value":"import {cellDataLoaders} from \"@d8abased/introduction\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":4337,"value":"import {cfa} from \"@d8abased/introduction\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":4314,"value":"import {cellStyles} from \"@d8abased/introduction\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":4351,"value":"cfa()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":4358,"value":"openSomeLinksInNewTab","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":4317,"value":"cellStyles","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":768,"value":"data = await d3.csv(\n `https://cors.openadverseevents.workers.dev/?destination=${globals.librela}`,\n (d) => {\n return {\n \"Received date\": new Date(d[\"Received date\"]),\n \"Case number\": d[\"Case number\"],\n \"Reporter\": d[\"Reporter\"],\n \"Country\": d[\"Country\"],\n \"Gender\": d[\"Gender\"],\n \"Species\": d[\"Species\"],\n \"Breed\": d[\"Breed\"],\n \"Reaction\": d[\"Reaction\"],\n \"VeDDRA SOC\": d[\"VeDDRA SOC\"],\n \"VeDDRA HLT\": d[\"VeDDRA HLT\"],\n \"Animals affected\": +d[\"Animals affected\"],\n \"Animals died\": +d[\"Animals died\"],\n \"Animals treated\": +d[\"Animals treated\"],\n \"AER form\": d[\"AER form\"],\n \"Drug\": d[\"Drug\"],\n };\n }\n)\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":4010,"value":"veddra = await d3.csv(\n `https://cors.openadverseevents.workers.dev/?destination=${globals.veddra}`,\n (d) => {\n return {\n \"New Line No.\": +d[\"New Line No. \"],\n \"New line no.\": +d[\"New line no.\"],\n \"Current System Organ Class (SOC) Term\": d[\"Current System Organ Class (SOC) Term\"],\n \"Current SOC Key\": +d[\"Current SOC Key\"],\n \"Current High Level Term (HLT)\": d[\"Current High Level Term (HLT)\"],\n \"Current HLT Key\": +d[\"Current HLT Key\"],\n \"Current Preferred Term (PT)\": d[\"Current Preferred Term (PT)\"],\n \"Current PT Key\": +d[\"Current PT Key\"],\n \"Current Low Level Term (LLT)\": d[\"Current Low Level Term (LLT)\"],\n \"Current LLT Key\": +d[\"Current LLT Key\"],\n \"Current Term Type\": d[\"Current Term Type\"]\n };\n }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":4529,"value":"function ratio(percent) {\n if (percent <= 0 || percent >= 1) {\n throw new Error(\"Percent must be between 0 and 1 (exclusive).\");\n }\n \n const n = Math.round(1 / percent);\n return `1 in ${n}`;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":4696,"value":"viewof only_veddra = Inputs.checkbox([\"Search only VeDDRA\"])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":4699,"value":"viewof search = Inputs.search(data, {\n placeholder: \"Search for a keyword...\",\n format: (d) => d == 0 ? \"no matches\" : d.toLocaleString() + \" cases (\" + (d/data.length < 1 ? ratio(d/data.length) + \" • \" : \"\") + Math.round(d/data.length * 100) + \"%)\",\n width: 100,\n columns: only_veddra[0] === \"Search only VeDDRA\" ? [\"VeDDRA SOC\"] : data.columns\n });","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"}],"files":"$W32","stdlib":"1","titling":"auto"}} 30:"$2f:body"