31:Tcfe,populations = [ { "county": "Beaverhead", "2019_pop": "9,453" }, { "county": "Big Horn", "2019_pop": "13,319" }, { "county": "Blaine", "2019_pop": "6,681" }, { "county": "Broadwater", "2019_pop": "6,237" }, { "county": "Carbon", "2019_pop": "10,725" }, { "county": "Carter", "2019_pop": "1,252" }, { "county": "Cascade", "2019_pop": "81,366" }, { "county": "Chouteau", "2019_pop": "5,635" }, { "county": "Custer", "2019_pop": "11,402" }, { "county": "Daniels", "2019_pop": "1,690" }, { "county": "Dawson", "2019_pop": "8,613" }, { "county": "Deer Lodge", "2019_pop": "9,140" }, { "county": "Fallon", "2019_pop": "2,846" }, { "county": "Fergus", "2019_pop": "11,050" }, { "county": "Flathead", "2019_pop": "103,806" }, { "county": "Gallatin", "2019_pop": "114,434" }, { "county": "Garfield", "2019_pop": "1,258" }, { "county": "Glacier", "2019_pop": "13,753" }, { "county": "Golden Valley", "2019_pop": "821" }, { "county": "Granite", "2019_pop": "3,379" }, { "county": "Hill", "2019_pop": "16,484" }, { "county": "Jefferson", "2019_pop": "12,221" }, { "county": "Judith Basin", "2019_pop": "2,007" }, { "county": "Lake", "2019_pop": "30,458" }, { "county": "Lewis and Clark", "2019_pop": "69,432" }, { "county": "Liberty", "2019_pop": "2,337" }, { "county": "Lincoln", "2019_pop": "19,980" }, { "county": "McCone", "2019_pop": "1,664" }, { "county": "Madison", "2019_pop": "8,600" }, { "county": "Meagher", "2019_pop": "1,862" }, { "county": "Mineral", "2019_pop": "4,397" }, { "county": "Missoula", "2019_pop": "119,600" }, { "county": "Musselshell", "2019_pop": "4,633" }, { "county": "Park", "2019_pop": "16,606" }, { "county": "Petroleum", "2019_pop": "487" }, { "county": "Phillips", "2019_pop": "3,954" }, { "county": "Pondera", "2019_pop": "5,911" }, { "county": "Powder River", "2019_pop": "1,682" }, { "county": "Powell", "2019_pop": "6,890" }, { "county": "Prairie", "2019_pop": "1,077" }, { "county": "Ravalli", "2019_pop": "43,806" }, { "county": "Richland", "2019_pop": "10,803" }, { "county": "Roosevelt", "2019_pop": "11,004" }, { "county": "Rosebud", "2019_pop": "8,937" }, { "county": "Sanders", "2019_pop": "12,113" }, { "county": "Sheridan", "2019_pop": "3,309" }, { "county": "Silver Bow", "2019_pop": "34,915" }, { "county": "Stillwater", "2019_pop": "9,642" }, { "county": "Sweet Grass", "2019_pop": "3,737" }, { "county": "Teton", "2019_pop": "6,147" }, { "county": "Toole", "2019_pop": "4,736" }, { "county": "Treasure", "2019_pop": "696" }, { "county": "Valley", "2019_pop": "7,396" }, { "county": "Wheatland", "2019_pop": "2,126" }, { "county": "Wibaux", "2019_pop": "969" }, { "county": "Yellowstone", "2019_pop": "161,300" } ]32:T2608,raw = [ { "county": "Missoula", "responded": "yes", "gaveNumber": "yes", "include": "yes", "date": "4/10", "tests": "1,160", "caveats": "Likely underestimate" }, { "county": "Glacier", "responded": "yes", "gaveNumber": "yes", "include": "yes", "date": "4/15", "tests": "299", "caveats": "Does not include private lab tests" }, { "county": "Sanders", "responded": "yes", "gaveNumber": "yes", "include": "yes", "date": "4/14", "tests": "41", "caveats": "" }, { "county": "Carbon", "responded": "yes", "gaveNumber": "no", "include": "no", "date": "", "tests": "ND", "caveats": "" }, { "county": "Beaverhead", "responded": "yes", "gaveNumber": "yes", "include": "yes", "date": "4/9", "tests": "105", "caveats": "" }, { "county": "Rosebud", "responded": "yes", "gaveNumber": "yes", "include": "yes", "date": "4/20", "tests": "26", "caveats": "" }, { "county": "Blaine", "responded": "yes", "gaveNumber": "no", "include": "no", "date": "4/14", "tests": "ND", "caveats": "" }, { "county": "Granite", "responded": "yes", "gaveNumber": "no", "include": "yes", "date": "4/20", "tests": "<30", "caveats": "" }, { "county": "Liberty", "responded": "yes", "gaveNumber": "no", "include": "no", "date": "4/14", "tests": "ND", "caveats": "" }, { "county": "Cascade", "responded": "yes", "gaveNumber": "yes", "include": "yes", "date": "4/8", "tests": "~1000", "caveats": "approximate - \"just over 1000 people\" - some may be out-of-county" }, { "county": "Teton", "responded": "yes", "gaveNumber": "yes", "include": "yes", "date": "4/15", "tests": "31", "caveats": "Excludes out-of-county tests on county residents" }, { "county": "Pondera", "responded": "yes", "gaveNumber": "yes", "include": "yes", "date": "4/9", "tests": "50", "caveats": "Excludes residents not tested at health dept or 2 local medical facilities" }, { "county": "Chouteau", "responded": "yes", "gaveNumber": "yes", "include": "yes", "date": "4/8", "tests": "5", "caveats": "" }, { "county": "Toole", "responded": "yes", "gaveNumber": "yes", "include": "yes", "date": "4/9", "tests": "188", "caveats": "" }, { "county": "Mineral", "responded": "yes", "gaveNumber": "yes", "include": "yes", "date": "4/10", "tests": "24", "caveats": "Excludes out-of-county tests" }, { "county": "Phillips", "responded": "yes", "gaveNumber": "yes", "include": "yes", "date": "4/8", "tests": "20", "caveats": "" }, { "county": "Garfield", "responded": "yes", "gaveNumber": "yes", "include": "yes", "date": "4/8", "tests": "3", "caveats": "" }, { "county": "Treasure", "responded": "yes", "gaveNumber": "yes", "include": "yes", "date": "4/8", "tests": "0", "caveats": "" }, { "county": "Fergus", "responded": "yes", "gaveNumber": "yes", "include": "yes", "date": "4/8", "tests": "54", "caveats": "Excludes private tests" }, { "county": "Musselshell", "responded": "yes", "gaveNumber": "yes", "include": "yes", "date": "4/8", "tests": "12", "caveats": "Excludes private tests" }, { "county": "Golden Valley", "responded": "yes", "gaveNumber": "yes", "include": "yes", "date": "4/8", "tests": "0", "caveats": "Excludes private tests" }, { "county": "Petroleum", "responded": "yes", "gaveNumber": "yes", "include": "yes", "date": "4/8", "tests": "0", "caveats": "Excludes private tests" }, { "county": "Judith Basin", "responded": "yes", "gaveNumber": "yes", "include": "yes", "date": "4/8", "tests": "3", "caveats": "Excludes private tests" }, { "county": "Wheatland", "responded": "yes", "gaveNumber": "yes", "include": "yes", "date": "4/8", "tests": "4", "caveats": "Excludes private tests" }, { "county": "Lewis and Clark", "responded": "yes", "gaveNumber": "no", "include": "no", "date": "4/10", "tests": "ND", "caveats": "\"We don't have this number\"" }, { "county": "Ravalli", "responded": "yes", "gaveNumber": "yes", "include": "yes", "date": "4/9", "tests": "218", "caveats": "" }, { "county": "Silver Bow", "responded": "yes", "gaveNumber": "yes", "include": "yes", "date": "4/9", "tests": "251", "caveats": "" }, { "county": "Lake", "responded": "no", "gaveNumber": "yes", "include": "yes", "date": "4/9", "tests": "255", "caveats": "" }, { "county": "Lincoln", "responded": "yes", "gaveNumber": "yes", "include": "yes", "date": "4/15", "tests": "424", "caveats": "" }, { "county": "Hill", "responded": "yes", "gaveNumber": "yes", "include": "yes", "date": "4/10", "tests": "38", "caveats": "" }, { "county": "Big Horn", "responded": "yes", "gaveNumber": "yes", "include": "yes", "date": "4/9", "tests": "54", "caveats": "" }, { "county": "Roosevelt", "responded": "yes", "gaveNumber": "no", "include": "no", "date": "4/9", "tests": "ND", "caveats": "\"We are not giving out test count reports to the public.\"" }, { "county": "Valley", "responded": "yes", "gaveNumber": "no", "include": "no", "date": "NA", "tests": "ND", "caveats": "hard pass on ony response" }, { "county": "Powell", "responded": "yes", "gaveNumber": "yes", "include": "yes", "date": "4/10", "tests": "66", "caveats": "" }, { "county": "Sweet Grass", "responded": "yes", "gaveNumber": "yes", "include": "yes", "date": "4/15", "tests": "20", "caveats": "* see doc" }, { "county": "Gallatin", "responded": "yes", "gaveNumber": "yes", "include": "yes", "date": "4/8", "tests": "1,298", "caveats": "" }, { "county": "Flathead", "responded": "yes", "gaveNumber": "yes", "include": "yes", "date": "4/8", "tests": "853", "caveats": "" }, { "county": "Park", "responded": "yes", "gaveNumber": "no", "include": "no", "date": "NA", "tests": "ND", "caveats": "Referred to website/hospital" }, { "county": "Jefferson", "responded": "yes", "gaveNumber": "yes", "include": "yes", "date": "4/8", "tests": "32", "caveats": "Excludes out-of-county tests on county residents" }, { "county": "Stillwater", "responded": "yes", "gaveNumber": "yes", "include": "yes", "date": "4/8", "tests": "56", "caveats": "" }, { "county": "Deer Lodge", "responded": "yes", "gaveNumber": "yes", "include": "yes", "date": "4/8", "tests": "79", "caveats": "" }, { "county": "Madison", "responded": "no", "gaveNumber": "no", "include": "no", "date": "NA", "tests": "ND", "caveats": "" }, { "county": "Broadwater", "responded": "yes", "gaveNumber": "yes", "include": "yes", "date": "4/14", "tests": "51", "caveats": "" }, { "county": "Meagher", "responded": "yes", "gaveNumber": "yes", "include": "yes", "date": "4/8", "tests": "14", "caveats": "" }, { "county": "Yellowstone", "responded": "yes", "gaveNumber": "yes", "include": "yes", "date": "4/13", "tests": "1,395*", "caveats": "Billings Clinic only - excludes St. Vincents" }, { "county": "Custer", "responded": "yes", "gaveNumber": "yes", "include": "yes", "date": "4/8", "tests": "46", "caveats": "" }, { "county": "Richland", "responded": "yes", "gaveNumber": "yes", "include": "yes", "date": "4/14", "tests": "75", "caveats": "" }, { "county": "Dawson", "responded": "yes", "gaveNumber": "no", "include": "yes", "date": "4/9", "tests": "2-6 a day", "caveats": "range" }, { "county": "Sheridan", "responded": "yes", "gaveNumber": "yes", "include": "yes", "date": "4/10", "tests": "17", "caveats": "" }, { "county": "Fallon", "responded": "yes", "gaveNumber": "yes", "include": "yes", "date": "4/9", "tests": "24", "caveats": "" }, { "county": "Daniels", "responded": "yes", "gaveNumber": "no", "include": "no", "date": "4/9", "tests": "ND", "caveats": "hard pass" }, { "county": "McCone", "responded": "yes", "gaveNumber": "no", "include": "yes", "date": "4/9", "tests": "<10", "caveats": "" }, { "county": "Powder River", "responded": "yes", "gaveNumber": "yes", "include": "yes", "date": "4/9", "tests": "1", "caveats": "" }, { "county": "Prairie", "responded": "yes", "gaveNumber": "yes", "include": "yes", "date": "4/21", "tests": "12", "caveats": "" }, { "county": "Carter", "responded": "yes", "gaveNumber": "yes", "include": "yes", "date": "4/10", "tests": "4", "caveats": "" }, { "county": "Wibaux", "responded": "no", "gaveNumber": "no", "include": "no", "date": "NA", "tests": "ND", "caveats": "" } ]33:[] 2f:{"title":"What we know about local COVID-19 testing in Montana","cells":[{"id":0,"value":"md`# What we know about local COVID-19 testing in Montana`","pinned":false,"hidden":false,"mode":"ojs"},{"id":96,"value":"md`\n\n*Based on reporting from Eric Dietrich / Montana Free Press, Katheryn Houghton / Bozeman Daily Chronicle, Holly Michels / Lee Newspapers, Corin Cates-Carney / Montana Public Radio & Nicky Oullet / Yellowstone Public Radio.*\n\nWe contacted the local health offices serving each of Montana’s 56 counties, requesting data on the number of COVID-19 tests that had been administered on their residents. We were successful in obtaining cumulative numbers from 43 counties. A handful of county health departments either said they don’t have numbers readily available, or declined to release them. A few didn’t respond to repeated calls and emails.\n\nThe test counts we received for each county are listed below, along with the date the figure was current. Note that these numbers are subject to numerous caveats, discussed at length [in the accompanying piece](https://montanafreepress.org/2020/04/24/https-montanafreepress-org-2020-04-23-as-montana-prepares-to-reopen-state-lacks-local-covid-19-testing-data/).`","pinned":false,"hidden":false,"mode":"ojs"},{"id":48,"value":"table = html`\n\n

COVID-19 tests by Montana county

\n\n \n \n \n \n \n \n ${data\n .sort((a,b) => b.population - a.population)\n .map(d => `\n \n \n \n \n `)}\n

County	Reporting date	Est. tests	Population
*${d.county}*	${d.date}	${d.tests}	${d3.format(',')(d.population)}

*Yellowstone Co. figures include only tests conducted at Billings Clinic

\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":12,"value":"d3 = require('d3@5')","pinned":false,"hidden":false,"mode":"ojs"},{"id":19,"value":"$31","pinned":false,"hidden":false,"mode":"ojs"},{"id":77,"value":"$32","pinned":false,"hidden":false,"mode":"ojs"},{"id":14,"value":"data = {\n // const raw = await d3.csv('https://docs.google.com/spreadsheets/d/e/2PACX-1vS_j_GlVOpyE6ngBGP7LPEm6ceQvwNmjEY1MYYXyj4ZWCb1xLQ-rWVnRAw0k9nHsM9zyQPiQDN9QIYa/pub?gid=2072589689&single=true&output=csv')\n return raw\n .filter(d => d.include === 'yes')\n .map(d => {\n const match = populations.find(county => county.county === d.county)\n return {\n county: d.county,\n date: d.date,\n tests: d.tests,\n population: +match['2019_pop'].replace(',','')\n }\n })\n \n}","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W33","stdlib":"1","titling":"auto"}