31:Tcb1,md`Incidence data from Our World in Data, colors from sledilnik.org **See also:** - **[Slovenia's list of green, yellow and red countries.](https://observablehq.com/@mkadunc/14-days-incidence-and-slovenias-list-of-yellow-and-red-count)** - **[Maps of COVID-19 Incidence in Europe and globally.](https://observablehq.com/@mkadunc/map-of-14-days-incidence-sledilnik-covid-19)** Rules for colors from https://ec.europa.eu/info/live-work-travel-eu/health/coronavirus-response/travel-during-coronavirus-pandemic/common-approach-travel-measures-eu_en : (a) **green**, if the 14-day cumulative COVID-19 case notification rate is less than **25** and the weekly test positivity rate of tests for COVID-19 infection is less than **4%**;

(b) **orange**,
(b.1) if the 14-day cumulative COVID-19 case notification rate is less than **50** but the weekly test positivity rate of tests for COVID-19 infection is **4% or more**,
(b.2) or, if the 14-day cumulative COVID-19 case notification rate ranges from **25 to 150** but the weekly test positivity rate of tests for COVID-19 infection is less than **4%**;

(c) **red**, (c.1) if the 14-day cumulative COVID-19 case notification rate is **50 or more** and the weekly test positivity rate of tests for COVID-19 infection is **4% or more**,
(c.2) or, if the 14-day cumulative COVID-19 case notification rate is **more than 150** per 100 000 population; (d) **dark red**, if the 14-day cumulative COVID-19 case notification rate is **more than 500** per 100 000 population; (e) **grey-nodata**, if not sufficient information is available to assess the criteria in point 10 *(required info are 14d notification rate, weekly test positivity rate, weekly testing rate per population)* (e.1) **grey-orange** (not in the EU rules, but used here when testing rate per population is lower than 250/100k and criteria for orange are met, or when **no testing data** available and rate is less than **50**, same as b.1) (e.2) **grey-red** (not in the EU rules, but used here when testing rate per population is lower than 250/100k and criteria for red are met, or when **no testing data** available and rate is **50 or more**, same as c.1) (e.3) **grey-green**, if the weekly testing rate per population is **250 or less** COVID-19 tests for infection per 100000 population and criteria for green are met. (e.4) **grey-darkred**, if the weekly testing rate per population is **250 or less** COVID-19 tests for infection per 100000 population and criteria for dark red are met.

Phase diagram of proposed color given 14d notification rate and 7d test positivity rate. Gray diagonal area depicts the region where 7d testing rate (tests performed / population) is below 250/100k

`32:Tacb,doChart = function (rawData) { const data = rawData .map(a => ({ ...a, value: a ? Math.max(0, !a.incidence14d ? 0 : a.incidence14d) : 0 })) .sort((a,b) => (b.value) - (a.value)) ; // return data.slice(-25); const margin = ({top: 30, right: 0, bottom: 10, left: 0}); const barHeight = 20; const height = Math.ceil((data.length + 0.1) * barHeight) + margin.top + margin.bottom; const y = d3.scaleBand() .domain(d3.range(data.length)) .rangeRound([margin.top, height - margin.bottom]) .padding(0.1); const tickText = (a => d3.timeFormat('%Y-%m-%d ')(a.endDate) + a.location); const x = d3.scaleLinear() .domain([Math.max(-4000, -d3.max(data, d => d.incidenceFirstWk7d)), d3.max(data, d => d.incidenceLastWk7d)]) .range([margin.left, width - margin.right]); const yAxis = g => g .attr("transform", `translate(${x(0)},0)`) .attr("fill", "#ccaa00") .call(d3.axisLeft(y).tickFormat(i => tickText(data[i]))); const format = x.tickFormat(20); const formatPct = a => d3.format(".2r")(100*a); const svg = d3.create("svg") .attr("viewBox", [0, 0, width, height]); svg.append("g") .selectAll("rect") .data(data) .join("rect") .attr("x", d => x(-d.incidenceFirstWk7d)) .attr("y", (d, i) => y(i)) .attr("width", d => x(d.incidenceLastWk7d) - x(-d.incidenceFirstWk7d)) .attr("height", y.bandwidth()) .attr("fill", d => d.color.css); const bartext = d => { const ratio = d.incidenceLastWk7d/d.incidenceFirstWk7d*100.0; const incText = format(d.incidence14d/10) + ' '; //const weeksText = ' ('+format(d.incidenceFirstWk7d)+' + '+format(d.incidenceLastWk7d)+')'; const testText = (+d.positivityRateLastWk7d) ? ' tpr: ' + formatPct(d.positivityRateLastWk7d)+'% | tpop: ' + format(d.testingRateLastWk7d/10) : ''; if (d.incidenceLastWk7d >= d.incidenceFirstWk7d) { return incText + '(+' + format(ratio-100) +'%)' + testText; } return incText + '(-' + format(100-ratio) +'%)' + testText; }; svg.append("g") .attr("fill", "white") .attr("font-family", "sans-serif") .attr("font-size", 12) .selectAll("text") .data(data) .join("text") .attr("text-anchor", "start") .attr("x", d => x(d.incidenceLastWk7d)) .attr("y", (d, i) => y(i) + y.bandwidth() / 2) .attr("dy", "0.35em") .attr("dx", +4) .attr("fill", d => d.color.css) .attr("font-weight", "bold") .text(d => bartext(d)) .call(text => text.filter(d => width - x(d.value) < 100) // long bars .attr("dx", -4) .attr("fill", "white") .attr("text-anchor", "end")); svg.append("g") .call(yAxis); return svg.node(); }33:Taae,data_lookup = { const zeroToNaN = function(a) { return a===0 ? NaN : a; }; const dataLast = dataOwid.reduce((out, val) => { if ( !out[val.iso_code] || (d3.timeDay.count(val.date, new Date()) > 7) || ( (+val.new_cases_per_million) && (+val.total_tests_per_thousand || !+out[val.iso_code].tests) ) ) { out[val.iso_code] = { "date": val.date, "tests": val.total_tests_per_thousand }; } return out; }, {}); const ret = {}; Object.keys(dataLast).map(key => { const allCountry = dataOwid.filter(a => (a.iso_code == key)).sort((a,b) => (a.date - b.date)); if (allCountry.length < 1) { return {iso_code: key}; } const endDate = dataLast[key].date; const startDate = d3.utcDay.offset(d3.isoParse(endDate), -14); const obj = { iso_code: allCountry[0].iso_code, continent: allCountry[0].continent, location: allCountry[0].location, startDate: d3.isoParse(d3.isoFormat(allCountry[0].date)), startCases: allCountry[0].total_cases_per_million, startTests: allCountry[0].total_tests_per_thousand * 1000 }; allCountry.forEach(a => { const aDate = a.date; if (d3.timeDay.count(a.date, endDate) >= 14) { obj.startDate = d3.isoParse(aDate); obj.startCases = zeroToNaN(a.total_cases_per_million); obj.startTests = zeroToNaN(a.total_tests_per_thousand * 1000); } else if (d3.timeDay.count(a.date, endDate) >= 7) { obj.midDate = d3.isoParse(aDate); obj.midCases = zeroToNaN(a.total_cases_per_million); obj.midTests = zeroToNaN(a.total_tests_per_thousand * 1000); } else if (aDate == endDate) { obj.endDate = d3.isoParse(aDate); obj.endCases = zeroToNaN(a.total_cases_per_million); obj.endTests = zeroToNaN(a.total_tests_per_thousand * 1000); } }); obj.incidence = (obj.endCases - obj.startCases); obj.incidence14d = Math.round(obj.incidence * 14 / d3.timeDay.count(obj.startDate, obj.endDate)); obj.incidence = Math.round(obj.incidence); obj.incidenceFirstWk = (obj.midCases - obj.startCases); obj.incidenceLastWk = (obj.endCases - obj.midCases); obj.incidenceFirstWk7d = Math.round(obj.incidenceFirstWk * 7 / d3.timeDay.count(obj.startDate, obj.midDate)); obj.incidenceLastWk7d = Math.round(obj.incidenceLastWk * 7 / d3.timeDay.count(obj.midDate, obj.endDate)); obj.testingRateLastWk7d = (obj.endTests - obj.midTests) * 7 / d3.timeDay.count(obj.midDate, obj.endDate); obj.positivityRateLastWk7d = obj.incidenceLastWk7d / obj.testingRateLastWk7d; obj.color = makeColor(obj); ret[key] = obj; }); return ret; }34:[{"id":"fd7c6028418eef9a253bf86a023e3c24d06e99cd6f82397bdf7c182bc11cf69eae19dfddc356887357cd78a0e42609899e2e90482851357609ea1226779b9f84","href":"https://static.observableusercontent.com/files/fd7c6028418eef9a253bf86a023e3c24d06e99cd6f82397bdf7c182bc11cf69eae19dfddc356887357cd78a0e42609899e2e90482851357609ea1226779b9f84","name":"eu-colors-diagram@1.png","type":"image/png","lastModified":1603063167787.775,"size":18512},{"id":"8758119e227a6d0caf1dfb79c340584b445fc3c0edb62ca099a34d183ef819eff3bd651f8de2e18efe1fc67759a859261a92ddae7a4fc127830154c6becedbd8","href":"https://static.observableusercontent.com/files/8758119e227a6d0caf1dfb79c340584b445fc3c0edb62ca099a34d183ef819eff3bd651f8de2e18efe1fc67759a859261a92ddae7a4fc127830154c6becedbd8","name":"eu-colors-diagram.png","type":"image/png","lastModified":1599734792231.708,"size":15291},{"id":"aea69cad47ff103e9df7eac5ab637ddce2989862f55ec86b8e5d1d01be85c2719ee1ea1e1b488ab3e0c2b7feca8a64ae2e2a98f7c62e166d3d0eac15406e0d3c","href":"https://static.observableusercontent.com/files/aea69cad47ff103e9df7eac5ab637ddce2989862f55ec86b8e5d1d01be85c2719ee1ea1e1b488ab3e0c2b7feca8a64ae2e2a98f7c62e166d3d0eac15406e0d3c","name":"EU_color_codes_darkred.png","type":"image/png","lastModified":1611578923175.895,"size":18122}] 2f:{"title":"EU color coding — Sledilnik COVID-19","cells":[{"id":0,"value":"md`# EU color coding — Sledilnik COVID-19`","pinned":false,"hidden":false,"mode":"ojs"},{"id":267,"value":"$31","pinned":false,"hidden":false,"mode":"ojs"},{"id":261,"value":"md`### Europe`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1152,"value":"md`Bar size is relative to incidence in 14 days; this number is also used for ordering. Position is relative to weekly (7d) incidence one week ago, so that the bar is split into two parts by the vertical axis:\n- left of the axis: confirmed cases in the week before last (\\`\\`cases-week-before\\`\\`)\n- right of the axis: confirmed cases in the last week (\\`\\`cases-last-week\\`\\`)\n\nInformation written in text is as follows:\n- the text on the axis shows the date of last data point and country name\n- the text on the bar shows:
\\`\\`<14d-rate> () \\`\\`:\n - **14 days notification rate**, up to the last data point
(\\`\\`cases-week-before + cases-last-week\\`\\`) per 100k\n - week-on-week **relative increase** of new cases
(\\`\\`cases-last-week/cases-week-before - 1\\`\\`)\n - **tpr: test positivity rate** in the last week (\\`\\`cases-last-week/tests-last-week\\`\\`)\n - **tpop: share of population tested** in the last week (\\`\\`tests-last-week\\`\\`) per 100k`","pinned":false,"hidden":false,"mode":"ojs"},{"id":202,"value":"doChart(arr.filter(a => a.continent == 'Europe'))","pinned":false,"hidden":false,"mode":"ojs"},{"id":264,"value":"md`### World`","pinned":false,"hidden":false,"mode":"ojs"},{"id":246,"value":"doChart(arr)","pinned":false,"hidden":false,"mode":"ojs"},{"id":277,"value":"md`## Code`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1522,"value":"(!!NaN )","pinned":true,"hidden":false,"mode":"ojs"},{"id":35,"value":"$32","pinned":false,"hidden":false,"mode":"ojs"},{"id":484,"value":"arr = Object.keys(data_lookup).map(a => data_lookup[a]);","pinned":false,"hidden":false,"mode":"ojs"},{"id":1473,"value":"data_lookup[\"SVN\"]","pinned":false,"hidden":false,"mode":"ojs"},{"id":38,"value":"$33","pinned":false,"hidden":false,"mode":"ojs"},{"id":9,"value":"import {dataOwid} from '@mkadunc/14-days-incidence-and-slovenias-list-of-yellow-and-red-count'","pinned":false,"hidden":false,"mode":"ojs"},{"id":24,"value":"colors = ({\n green : {name: 'green', css: '#70bc43', mapCss: 'darkgreen'},\n orange : {name: 'orange', css: '#dc8b2a', mapCss: 'chocolate'},\n red : {name: 'red', css: '#e94f5a', mapCss: 'red'},\n darkred: {name: 'darkred', css: '#a91f2a', mapCss: 'darkred'},\n grey_nodata: {name: 'grey-nodata', css: '#999999', mapCss: '#999999'},\n grey_green: {name: 'grey-green', css: '#7B926D', mapCss: '#7B926D'},\n grey_orange: {name: 'grey-orange', css: '#9B8366', mapCss: '#9B8366'},\n grey_red: {name: 'grey-red', css: '#9F7174', mapCss: '#9F7174'},\n grey_darkred: {name: 'grey-darkred', css: '#7F5154', mapCss: '#7F5154'}\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":178,"value":"makeColor = function(dataObj) {\n const inc = dataObj.incidence14d/10; //per million -> per 100k\n const tpr = dataObj.positivityRateLastWk7d;\n const tRatePop = dataObj.testingRateLastWk7d/10; //per million -> per 100k\n \n if (tpr < 0.04) {\n return inc < 25 ? tRatePop >= 250 ? colors.green : colors.grey_green\n : inc <= 150 ? tRatePop >= 250 ? colors.orange : colors.grey_orange\n : inc <= 500 ? tRatePop >= 250 ? colors.red : colors.grey_red\n : inc > 500 ? tRatePop >= 250 ? colors.darkred : colors.grey_darkred\n : colors.grey_nodata;\n \n }\n return inc < 50 ? tRatePop >= 250 ? colors.orange : colors.grey_orange\n : inc <= 500 ? tRatePop >= 250 ? colors.red : colors.grey_red\n : inc > 500 ? tRatePop >= 250 ? colors.darkred : colors.grey_darkred\n : colors.grey_nodata;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":11,"value":"d3 = require('d3','d3-time')","pinned":false,"hidden":false,"mode":"ojs"},{"id":1553,"value":"html``","pinned":true,"hidden":false,"mode":"ojs"},{"id":1560,"value":"style = html`\n\n\n\n`","pinned":true,"hidden":false,"mode":"ojs"}],"files":"$W34","stdlib":"1","titling":"auto"}