32:T566,md`Choose rate or total and a county and download a csv that looks like this:

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":"Health Profession Totals or Rates Over Time for Selected County","cells":[{"id":0,"value":"title = md`# Health Profession Totals or Rates Over Time for Selected County`","pinned":false,"hidden":false,"mode":"ojs"},{"id":46,"value":"viewof rateOrTotal = html``","pinned":false,"hidden":false,"mode":"ojs"},{"id":293,"value":"viewof county = html``","pinned":false,"hidden":false,"mode":"ojs"},{"id":111,"value":"dl = DOM.download(\n new Blob(\n [\n d3.csvFormat(professions_over_time_by_county, [\n \"Profession\",\n ...d3.range(yearExtent[0], yearExtent[1] + 1)\n ])\n ],\n { type: \"text/csv\" }\n ),\n `Health_Professions_${\n rateOrTotal == \"providerRate\" ? \"Rate_per_10k\" : \"Total\"\n }_${county}_County.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":327,"value":"yearExtent = d3.extent(\n professions_over_time_by_county\n .map(d =>\n d3.extent(\n Object.keys(d)\n .map(e => +e)\n .filter(e => e != \"Profession\")\n )\n )\n .flat()\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":300,"value":"professions_over_time_by_county = Array.from(\n d3.group(\n professionsData.flat().filter(d => d.region == county),\n d => d.profession\n )\n).map(function(d) {\n let newRow = { Profession: d[0] };\n d[1].forEach(function(e) {\n newRow[e.year] = e[rateOrTotal];\n });\n return newRow;\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":40,"value":"professionsData = getProfessionsData(\n professions.filter(d => d.profession == d.specialty)\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":289,"value":"countyList = Array.from(\n new Set(professionsData[0].filter(d => d.type == \"county\").map(d => d.region))\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":55,"value":"async function getProfessionsData(profs) {\n const pArray = profs.map(async prof => {\n const response = await d3.csv(\n `https://data-dept-healthworkforce.cloudapps.unc.edu/data/region/spec${prof.id.padStart(\n 3,\n \"0\"\n )}.csv`,\n d3.autoType\n );\n return response.map(d => ((d.profession = prof.profession), d));\n });\n const users = await Promise.all(pArray);\n return users;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":186,"value":"integerFormatter = d3.format(\",\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":123,"value":"import {select, slider} from \"@jashkenas/inputs\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":4,"value":"d3 = require(\"d3\", \"d3-array@2\")","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W33","stdlib":"1","titling":"auto"}