2c:null 2d:["$","title",null,{"children":"Explore the Solensia sADR Data | d8abased | Observable"}] 32:T589,Plot.plot({ width: width, height: 600, x: { round: true }, marginLeft: 35, marginRight: 0, marginBottom: 40, marginTop: 40, insetTop: -20, caption: htl.html`Solensia Worldwide ADRs (May 2021 - Present): Affected (black), Died (red)`, marks: [ Plot.rectY(weeklyByCountry, {x: "Received date", y: "Animals affected", interval: "Week", fill: "#333333cc", inset: 0}), Plot.rectY(weeklyByCountry, {x: "Received date", y: "Animals died", fill: "red", interval: "Week", inset: 0}), Plot.axisY({label: "Affected (black), Died (red)"}), Plot.gridY({stroke: "#333333", strokeOpacity: 0.3, strokeWidth: 0.5}), Plot.ruleY([0]), Plot.tip(weeklyByCountry, Plot.pointerX({ x: "Received date", y: "Animals affected", title: (d) => { const date = new Date(d["Received date"]); const dateFormat = date.toLocaleDateString('en-US', { timeZone: "UTC", month: 'short', day: 'numeric', year: 'numeric' }); return `${dateFormat}\n\nAffected: ${d["Animals affected"]}\nDied: ${d["Animals died"]}`; } })), selectCountry === "All" ? Plot.tip( [`This was likely a significant reporting delay by Zoetis or EVVet, and represents cases for the prior 6-9 months.`], {x: new Date("2022-02-06"), y: 150, dx: 40, anchor: "middle", background: "white"} ) : [], ] })33:T476,Plot.plot({ width: width, height: 600, x: { round: true }, marginLeft: 20, marginRight: 0, marginBottom: 40, marginTop: 40, insetTop: -20, caption: htl.html`Solensia Worldwide ADRs (Sep 2022 - Present): Affected (black), Died (red)`, marks: [ Plot.rectY(resampledUSA, {x: "Received date", y: "Animals affected", interval: "Week", fill: "#333333cc", inset: 0}), Plot.rectY(resampledUSA, {x: "Received date", y: "Animals died", fill: "red", interval: "Week", inset: 0}), Plot.axisY({label: "Affected (black), Died (red)"}), Plot.gridY({stroke: "#333333", strokeOpacity: 0.3, strokeWidth: 0.5}), Plot.ruleY([0]), Plot.tip(resampledUSA, Plot.pointerX({ x: "Received date", y: "Animals affected", title: (d) => { const date = new Date(d["Received date"]); const dateFormat = date.toLocaleDateString('en-US', { timeZone: "UTC", month: 'short', day: 'numeric', year: 'numeric' }); return `${dateFormat}\n\nAffected: ${d["Animals affected"]}\nDied: ${d["Animals died"]}`; } })) ] })34:T45c,Plot.plot({ height: 140, width: width, marginLeft: 5, marginRight: 10, x: {percent: true, label: "% of cats affected"}, color: {legend: false, range: ({length}) => d3.quantize(d3.interpolateSpectral, length)}, caption: htl.html`The U.S. accounts for ${Math.round((stats.usAffected / stats.wwAffected) * 100)}% of all Solensia sADR affected cats`, marks: [ Plot.barX( dataS.filter(d => d["Animals affected"]), Plot.stackX( {order: "x", reverse: true}, Plot.groupZ( {x: "proportion"}, {z: "Country", inset: 0.5, fill: "Country", tip: true} ) ) ), Plot.text( dataS.filter(d => d["Animals affected"]), Plot.filter( (d) => d.length > 100, Plot.stackX( {order: "x", reverse: true}, Plot.groupZ( {x: "proportion", text: "first"}, {z: "Country", text: "Country", fill: "white", fontSize: 11, fontWeight: 600, rotate: 90} ) ) ) ), Plot.ruleX([0, 1]) ] })35:T43f,Plot.plot({ height: 140, width: width, marginLeft: 5, marginRight: 10, x: {percent: true, label: "% of cats died"}, color: {legend: false, range: ({length}) => d3.quantize(d3.interpolateSinebow, length)}, caption: htl.html`The U.S. accounts for ${Math.round((stats.usDied / stats.wwDied) * 100)}% of all Solensia sADR deaths`, marks: [ Plot.barX( dataS.filter(d => d["Animals died"]), Plot.stackX( {order: "x", reverse: true}, Plot.groupZ( {x: "proportion"}, {z: "Country", inset: 0.5, fill: "Country", tip: true} ) ) ), Plot.text( dataS.filter(d => d["Animals died"]), Plot.filter( (d) => d.length > 10, Plot.stackX( {order: "x", reverse: true}, Plot.groupZ( {x: "proportion", text: "first"}, {z: "Country", text: "Country", fill: "white", fontSize: 11, fontWeight: 600, rotate: 90} ) ) ) ), Plot.ruleX([0, 1]) ] })36:Tc10,mainTickChart = Plot.plot({ marginLeft: 125, marginTop: 40, marginBottom: 0, marginRight: 5, width: width, caption: htl.html`Exploring Across 4 Dimensions: Time (x-axis), Place (y-axis), Affected (black), Died (red)`, x: { label: null, domain: domain.adj_data_extent }, y: { domain: d3.groupSort( data_daily, (g) => d3.min(g, (d) => d["Received date"]), (d) => d.Country ), label: null, padding: 0.1 }, marks: [ Plot.ruleX([0]), Plot.tickX( dataS.filter(d => d["Animals affected"] > 0), { x: "Received date", y: "Country", stroke: "black", strokeWidth: 1, strokeOpacity: (d) => Math.min((d3.interpolateNumber(domain.affected_extent[0], domain.affected_extent[1])(d["Animals affected"])/domain.affected_extent[1]), 0.2) } ), Plot.tickX( dataS.filter(d => d["Animals died"] > 0), { x: "Received date", y: "Country", stroke: "red", strokeWidth: 1, strokeOpacity: (d) => d3.interpolateNumber(domain.died_extent[0], domain.died_extent[1])(d["Animals died"])/domain.died_extent[1], // mixBlendMode: "plus-lighter" } // {x: "Received date", y: "Country", stroke: "red", strokeWidth: 1, strokeOpacity: (d) => 0.5, mixBlendMode: "plus-lighter"} ), Plot.gridX({ interval: "month", strokeDasharray: "1,2", strokeOpacity: 0.2 }), Plot.axisX({ anchor: "top", tickRotate: -90, interval: "month", // tickFormat: d => d.toLocaleDateString('en-US', { month: 'long', year: 'numeric' }) }), Plot.gridY({ x: (y) => dataS.find((d) => d.Country === y)?.['Received date'] }), Plot.axisY({ x: (y) => dataS.find((d) => d.Country === y)?.['Received date'], tickSize: 6, fontWeight: 600 }), // Plot.crosshairX(data_daily, {x: "Received date", y: "Country", ruleStroke: "#E59313", ruleStrokeOpacity: 0.5, textFillOpacity: 0}), // Plot.text(data_daily, Plot.pointerX({px: "Received date", py: "Country", dy: -10, dx: -60, frameAnchor: "bottom-left", fontSize: "11", fontVariant: "tabular-nums", fontWeight: 600, text: (d) => [`Date: ${Plot.formatIsoDate(d["Received date"])}`, `Country: ${d["Country"]}`, `Affected: ${d["Animals affected"]}`, `Died: ${d["Animals died"]}`].join(" | "), maxRadius: 6})), // Plot.dotX( // data_daily, // Plot.pointerX({ // x: "Received date", // y: "Country", // fill: "#ffffffdd", // stroke: "#E59313", // r: 6, // maxRadius: 6 // }) // ), Plot.tip(data_daily, Plot.pointerX({ x: "Received date", y: "Country", title: (d) => `Date: ${new Date(d["Received date"]).toLocaleDateString('en-US', { timeZone: "UTC", month: 'short', day: 'numeric', year: 'numeric' })}\nCountry: ${d.Country}\nAffected: ${ d["Animals affected"] }\nDied: ${d["Animals died"]}` })), ] })37:T4ee,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_.38:T666,// function resample(data, timeframe, country = 'na') { // const startOfPeriod = (date) => { // switch (timeframe) { // case 'Week': // return d3.timeWeek.floor(date); // case 'Month': // return d3.timeMonth.floor(date); // default: // throw new Error("Unsupported timeframe: " + timeframe); // } // }; // // Filter data by country if a specific country is provided // const filteredData = country === 'na' ? data : d3.filter(data, d => d.Country === country); // const aggregated = d3.rollups(filteredData, // v => ({ // 'Animals affected': d3.sum(v, d => d['Animals affected']), // 'Animals died': d3.sum(v, d => d['Animals died']) // }), // d => d3.timeFormat("%Y-%m-%d")(startOfPeriod(new Date(d['Received date']))) // Ensure date is formatted correctly // ).map(([date, values]) => ({ // 'Received date': new Date(date + "T00:00:00Z"), // Parse back into a Date object without time // ...values // })); // return aggregated; // } function resample(data, country = "All") { const filteredData = country === "All" ? data : data.filter(d => d.Country === country); const dataByWeek = d3.rollup( filteredData, v => ({ "Animals affected": d3.sum(v, d => d["Animals affected"]), "Animals died": d3.sum(v, d => d["Animals died"]) }), d => +d3.timeWeek(d["Received date"]) ) const result = Array.from(dataByWeek, ([week, values]) => ({ "Received date": new Date(week), "Animals affected": values["Animals affected"], "Animals died": values["Animals died"] })); return result }39:T415,function reactionStats(data) { // Flatten all reactions into a single array and trim each reaction const allReactions = data.flatMap(d => d.Reaction.split(",").map(r => r.trim())); // Count each unique reaction using d3.rollup const reactionCounts = d3.rollup( allReactions, v => v.length, r => r ); // Calculate total unique reactions const total_unique_reactions = reactionCounts.size; // Calculate average reactions per case, using Math.ceil for ceiling const avg_reactions_per_case = Math.ceil(d3.mean(data, d => d.Reaction.split(",").length)); // Calculate max reactions in any single row const max_reactions = d3.max(data, d => d.Reaction.split(",").length); // Determine the top n reactions by count const top_reactions = Array.from(reactionCounts) .sort((a, b) => b[1] - a[1]) .slice(0, 100) .map(d => ({ "Reaction": d[0], "Animals affected": d[1] })); return { allReactions, total_unique_reactions, avg_reactions_per_case, max_reactions, top_reactions }; }3a:[{"id":"8c5319564a77bc766bea42b547dc17a568c0daed40078e8874207b38f4bb99e7f4b5d3c1f3470499a2dc913f16fb0fa1d9109600daa62af8e82f0252b32c20f5","href":"https://static.observableusercontent.com/files/8c5319564a77bc766bea42b547dc17a568c0daed40078e8874207b38f4bb99e7f4b5d3c1f3470499a2dc913f16fb0fa1d9109600daa62af8e82f0252b32c20f5","name":"download-solensia.png","type":"image/png","lastModified":1725169187758.399,"size":148500}] 30:{"id":"7e00fb6928e94e68","slug":"solensia-explore","title":"Explore the Solensia sADR Data","thumbnail":"aa68ce614537473c927ba42deb072b100ac1bff8248dc57a4964208f46edbb2f","access_level":"public","create_time":"$D2024-08-30T23:38:39.552Z","update_time":"$D2024-09-04T04:38:09.128Z","view_time":null,"first_public_time":"$D2024-09-02T21:00:13.513Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"387bada7be81c746","login":"d8abased","name":"d8abased","avatar_url":"https://avatars-next.observableusercontent.com/5680b5bdb4c31365df3342e07cb358027698748c24682dbd4476d6e8cc3e9e82","tier":"starter_2024","bio":"Based, in data."},"version":522,"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,"bio":""}],"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,"lapsed":null,"subscribed":null,"forks":0,"collection":{"id":"e5ec9e2c380d113f","slug":"solensia","title":"Solensia","owner":{"id":"387bada7be81c746","login":"d8abased","name":"d8abased"}},"type":"notebook","body":{"titling":"auto","title":"Explore the Solensia sADR Data","cells":[{"id":0,"value":"# Explore the Solensia sADR Data\n## A Visual Tour of the Official Solensia Suspected Adverse Drug Reaction (sADR) Data ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":474,"value":"

Correlation doesn't imply causation, but it does waggle its eyebrows suggestively and gesture furtively while mouthing “look over there”.
— Randall Patrick Munroe, Creator of xkcd

","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":119,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":134,"value":"

📝 Note
All the `metrics` and visualizations on this page reflect the data from when it was last updated: **${d3.timeFormat(\"%B %d, %Y, %H:%M:%S UTC\")(new Date(meta.csvs[0].timestamp))}**. They will be refreshed within a day or so of EVVet releasing new data. So, check back often for the latest data.

","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":453,"value":"If you haven’t already, be sure to read the brief 📘 [`Introduction`](https://librela.d8abased.com) notebook for Solensia’s sister product for canines, Librela. It will acquaint you with the source of this data—European Medicines Agency’s [EudraVigilance Veterinary Database of Suspected Adverse Drug Reaction Reports](https://www.adrreports.eu/vet/en/index.html), colloquially known as *EVVet*—and offer some thoughts on how to reason about it. \n\nAdditionally, be sure to check out 📘 [`Explore the Librela sADR Data`](https://librela.d8abased.com/explore) notebook which provides a guided tour of the Librela data to familiarize yourself with concepts around trend skew, underreporting, reporting delays, standardization problems, VeDDRA, etc.–all these concepts are applicable to the Solensia sADR world. \n\n---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":45,"value":"### 🌍 Worldwide Trend\ncases: **`${stats.wwCases.toLocaleString('en-US')}`** affected: **`${stats.wwAffected.toLocaleString('en-US')}`** died: **`${stats.wwDied.toLocaleString('en-US')}`** death rate: **`${Math.round(wwDeathRate[2] * 100)}%`** `${(wwDeathRate[1])}`","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":299,"value":"Much like [Librela](https://observablehq.com/@d8abased/explore#cell-5112), Solensia’s WW trend is obscured by an outlier in Feb 2022 that likely arose from a significant reporting delay by Zoetis and/or EVVet. ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":326,"value":"viewof selectCountry = Inputs.select(all_plus_countries, {label: \"Select a country\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":20,"value":"$32","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":37,"value":"### 🇺🇸 United States Trend\ncases: **`${stats.usCases.toLocaleString('en-US')}`** affected: **`${stats.usAffected.toLocaleString('en-US')} (${Math.round((stats.usAffected / stats.wwAffected) * 100)}%)`** died: **`${stats.usDied.toLocaleString('en-US')} (${Math.round((stats.usDied / stats.wwDied) * 100)}%)`**\n
(percents for affected/died denote proportion of WW)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":294,"value":"United States is broken out given the high proportion of cases that it contributes to the global count. ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":35,"value":"$33","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":343,"value":"$34","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":346,"value":"$35","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":218,"value":"### Exploring Across 4 Dimensions: Time, Place, Affected, Died ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":438,"value":"A different, perhaps more interesting, visualization is this tick chart that takes you on a 4-dimensional journey across the `${total_countries}` countries where adverse drug reactions have been reported for Solensia. \n\nIt shows the sADRs across countries (*y-axis*), over time (*x-axis*). The ticks represent batches of sADR cases submitted for the corresponding country at the corresponding points in time. The opacity (darkness) of the ticks represents the magnitude of the impact: **`black`** represents total cats affected, and **`red`**, cats who died before the report was filed. The y-axis is sorted chronologically by first reported sADR which roughly (we’ll see why this is often misleading) aligns with availability of Solensia in that country.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":168,"value":"$36","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":379,"value":"### Reactions","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":381,"value":"A total of **`${reaction_stats.total_unique_reactions}`** unique reactions have been reported to EVVet, with an average of **`${reaction_stats.avg_reactions_per_case}`** reactions per case, a maximum of **`${reaction_stats.max_reactions}`** reactions for a single case, and a grand total of **`${reaction_stats.allReactions.length.toLocaleString('en-US')}`** reactions, and counting.\n\nZooming into the top **`${reaction_stats.top_reactions.length}`** reported reactions paints a picture of a diversity of multi-systemic symptoms, conditions, and disorders ranging from mild in severity, to disabling, to fatal.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":371,"value":"Plot.plot({\n width: width,\n marginLeft: 0,\n insetRight: 20,\n insetLeft: 5,\n x: { grid: true},\n color: { legend: true, scheme: \"Turbo\" },\n caption: htl.html`Top ${reaction_stats.top_reactions.length} reported reactions for Solensia sADRs`,\n marks: [\n Plot.barX(reaction_stats.top_reactions, {\n x: \"Animals affected\", y: \"Reaction\", sort: {y: \"-x\"}, fill: \"Animals affected\", tip: true,\n }),\n Plot.axisY({\n label: null,\n anchor: \"right\",\n x: (y) => reaction_stats.top_reactions.find((d) => d.Reaction === y)?.[\"Animals affected\"], \n tickSize: 6,\n tickFormat: (d, i, _) => d\n }),\n Plot.axisX({anchor: \"top\"})\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":248,"value":"### Breakdown by _Reporter_","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":241,"value":"\n\nThe following highlights the breakdown of reports by type of _Reporter_, from Animal owner to Veterinarian. As we can see here, **`${percent_vet_health_pro}%`** of Solensia sADR cases were reported by domain experts like veterinarians, physicians, and health care professionals. This is not to say that pet owners are not credible reporters — that’s a _[false dichotomy](https://xkcd.com/2592/)_; after all, it is the pet owners who usually witness the sADRs in the first place. The point here is that veterinarians reporting what pet owners witness adds meaningful confirmation to these signals.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":145,"value":"vetPlot = Plot.plot({\n width: width,\n x: {round: true, axis: null},\n y: {label: \" \"},\n marginLeft: 0,\n marginRight: 0,\n marginTop: 0,\n marginBottom: 4,\n caption: percent_vet_health_pro + \"% of the official \" + stats.wwCases.toLocaleString('en-US') + \" cases have been reported by veterinary professionals\",\n color: { legend: true, range: [\"#E59313\", \"#000000ff\", \"#FFC66D\", \"pink\"], domain: [\"Veterinarian\", \"Physician\", \"Other health care professional\", \"Animal owner\"]},\n marks: [\n Plot.barX(dataS, {\n x: \"Received date\",\n fill: \"Reporter\"\n }),\n Plot.ruleX([0])\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":292,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":114,"value":"## Search & Download the Solensia sADR Data","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":308,"value":"$37","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":5,"value":"solensia = dataS","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"solensia","database":"$undefined"},{"id":441,"value":"**Note:** You can download all or part of the data by hovering over the left side of the data table above until you see a popover menu where you can select the `Download CSV` option (`csv` files open natively in Microsoft Excel & Apple Numbers).","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":445,"value":"download = FileAttachment(\"download-solensia.png\").image({\n style: \"border-radius: 0.3rem; border: 1px solid #eeeeee; box-shadow: 0 0px 12px rgba(0, 0, 0, 0.1);\",\n width: 350\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":495,"value":"cellFooter","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":161,"value":"cellDataLoaders","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":477,"value":"import {globals} from \"@d8abased/introduction\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":492,"value":"import {cellFooter} from \"@d8abased/introduction\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":480,"value":"globals","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":158,"value":"import {cellDataLoaders} from \"@d8abased/introduction\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":6,"value":"dataS = await d3.csv(\n `https://cors.openadverseevents.workers.dev/?destination=${globals.solensia}`,\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)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":499,"value":"meta = await d3.json(\n `https://cors.openadverseevents.workers.dev/?destination=${globals.solensia_meta}`,\n (d) => d\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":335,"value":"weeklyByCountry = resample(dataS, selectCountry)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":170,"value":"function domains() {\n const data_extent = d3.extent(dataS, d => d[\"Received date\"]);\n const adj_data_extent = data_extent.map((date, index) => d3.timeDay.offset(new Date(date), index === 0 ? -14 : 14));\n \n return {\n data_extent: data_extent,\n adj_data_extent: adj_data_extent,\n affected_extent: d3.extent(d3.rollup(dataS, v => d3.sum(v, d => d[\"Animals affected\"]), d => d[\"Received date\"]).values()),\n died_extent: d3.extent(d3.rollup(dataS, v => d3.sum(v, d => d[\"Animals died\"]), d => d[\"Received date\"]).values())\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":175,"value":"domain = domains()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":178,"value":"data_daily = Array.from(d3.rollup(dataS, \n (v) => ({\n AnimalsAffectedSum: d3.sum(v, d => d[\"Animals affected\"]),\n AnimalsDiedSum: d3.sum(v, d => d[\"Animals died\"]) \n }), \n d => d[\"Received date\"], \n d => d.Country\n)).flatMap(([date, countries]) => Array.from(countries, ([country, values]) => ({\n \"Received date\": date,\n \"Country\": country,\n \"Animals affected\": values.AnimalsAffectedSum,\n \"Animals died\": values.AnimalsDiedSum\n})));","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":13,"value":"$38","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":30,"value":"resampledUSA = d3.filter(resample(dataS, \"United States\"), d => new Date(d[\"Received date\"]) >= new Date(\"2022-01-13\"))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":16,"value":"stats = ({\n wwCases: dataS.length,\n wwAffected: d3.sum(dataS, (d) => d[\"Animals affected\"]),\n wwDied: d3.sum(dataS, (d) => d[\"Animals died\"]),\n usCases: d3.filter(dataS, (d) => d.Country === \"United States\").length,\n usAffected: d3.sum(dataS, (d) => d[\"Animals affected\"] & d.Country === \"United States\"),\n usDied: d3.sum(dataS, (d) => d[\"Animals died\"] & d.Country === \"United States\")\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":39,"value":"import {cellStyles} from \"@d8abased/introduction\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":42,"value":"cellStyles","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":54,"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 = 1 / percent;\n return [n, `1 in ${Math.round(n)}`, percent];\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":65,"value":"wwDeathRate = ratio(stats.wwDied / stats.wwAffected)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":87,"value":"usDeathRate = ratio(stats.usDied / stats.usAffected)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":148,"value":"percent_vet_health_pro = Math.round((d3.rollup(dataS, \n v => v.length, \n d => d.Reporter === \"Veterinarian\" || d.Reporter === \"Other health care professional\" || d.Reporter === \"Physician\"\n).get(true) / dataS.length) * 100);","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":220,"value":"total_countries = new Set(dataS.map(d => d.Country)).size - 1","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":330,"value":"all_plus_countries = [\"All\", ...Array.from(new Set(dataS.map(d => d.Country))).sort()];","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":373,"value":"$39","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":376,"value":"reaction_stats = reactionStats(dataS)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":463,"value":"catsAffectedApril2024 = d3.sum(\n dataS.filter(d => d[\"Species\"] === \"Cat\" && new Date(d[\"Received date\"]) <= new Date(\"2024-03-31\")),\n d => d[\"Animals affected\"]\n);","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W3a","stdlib":"1"}} 31:"$30:body"