32:T582,explain = md`Choose a profession and either rate or total and download a csv that looks like this (in Excel):

Data include active, licensed health professionals practicing in North Carolina as of October 31 of each data year. County counts are based on primary practice location. Some providers may practice in additional locations not shown in primary practice location counts. The [North Carolina Health Professions Data System (HPDS)](https://nchealthworkforce.unc.edu/supply/) collects and disseminates descriptive data on selected licensed health professionals in North Carolina. With annual files dating back to 1979, the HPDS is the oldest continuous state health workforce data system in the country. The HPDS is maintained by the Program on Health Workforce Research and Policy at the Cecil G. Sheps Center for Health Services Research at the University of North Carolina at Chapel Hill, in collaboration with the North Carolina Area Health Education Centers Program (AHEC), and the state’s independent health professional licensing boards. Ongoing financial support is provided by the NC AHEC Program Office and the Office of the Provost at the University of North Carolina at Chapel Hill. Although the NC HPDS maintains the data system, the data remain the property of their respective licensing board. `33:[] 30:{"title":"Number or Rate of Health Professionals Over Time by County, North Carolina","cells":[{"id":0,"value":"title = md`# Number or Rate of Health Professionals Over Time by County, North Carolina`","pinned":false,"hidden":false,"mode":"ojs"},{"id":337,"value":"viewof rateOrTotal = html``","pinned":false,"hidden":false,"mode":"ojs"},{"id":276,"value":"viewof profession = html``","pinned":false,"hidden":false,"mode":"ojs"},{"id":111,"value":"dl = DOM.download(\n new Blob([d3.csvFormat(county_by_year, [\"County\", ...d3.range(yearExtent[0], yearExtent[1] + 1)])], {type: \"text/csv\"}),\n `NC_${currProfessionName(profession).split(\" \").join(\"\")}_${yearExtent.join(\"_\")}.csv`\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":266,"value":"$32","pinned":false,"hidden":false,"mode":"ojs"},{"id":10,"value":"professions = d3.csv(\"https://data-dept-healthworkforce.cloudapps.unc.edu/data/specialties.csv\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":283,"value":"professionsMap = new Map(professions.map(d=>[d.id, d]))","pinned":false,"hidden":false,"mode":"ojs"},{"id":333,"value":"county_by_year = Array.from(d3.group(professionals, d=>d.county)).map(function(d){\n let newRow = {County: d[0]};\n d[1].forEach(function(e){\n newRow[e.year] = e[rateOrTotal]\n })\nreturn newRow;\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":311,"value":"yearExtent = d3.extent(professionals, d=>d.year)","pinned":false,"hidden":false,"mode":"ojs"},{"id":314,"value":"function currProfessionName(id) {\n const currObject = professionsMap.get(id);\n return currObject.profession == currObject.specialty\n ? currObject.profession\n : `${currObject.profession} - ${currObject.display_name}`\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":40,"value":"professionals = d3.csv(\n `https://data-dept-healthworkforce.cloudapps.unc.edu/data/region/spec${profession.padStart(\n 3,\n \"0\"\n )}.csv`,\n function(d) {\n if (d.type == \"ahec\") return null;\n return {\n county: d.region,\n year: +d.year,\n total: +d.total,\n population: +d.population,\n rate: +d.providerRate\n };\n }\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":4,"value":"d3 = require(\"d3-array@2\", \"d3-fetch\", \"d3-dsv\")","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W33","stdlib":"1","titling":"auto"}