2d:null 2e:["$","title",null,{"children":"Israel Fatalities 2000-2023 | Evgeny Zislis | Observable"}] 33:T664,Dots represent deaths by day, solid line is the moving average and black text towards the end of each month is the aggregation of total deaths from the beginning of the year up to the end of that month. The light gray line starting the fifth year represents the five year average for the same period of last five years. This is an average of the moving average for the previous five years and not a week-by-week comparison. This can help with seeing if a certain period has "Excess Mortality" compared to the average of the last several years. This is further explained on the [OurWorldInData website](https://ourworldindata.org/excess-mortality-covid).

כל נקודה מסמנת את מספר המתים באותו יום, והקו הצבעוני זה ממוצע נע לפי כמות הימים שנבחרו. המספר השחור בסוף כל חודש זה כמות המתים סה"כ מתחילת השנה עד לסוף אותו חודש. המספר האפור מתחת זה כמות המתים שנוספו עד לסוף אותו חודש.

הקו האפור החל מהשנה החמישית מראה את הממוצע של אותו יום לפי החמש השנים שקדמו לאותה שנה. זה מעיד על "תמותה עודפת" ע"י השוואה של השנה הנוכחית למה שבד"כ קורה באותו זמן בשנים בעבר. בלי לקחת בחשבון גידול באוכלוסיה. מידע נוסף על הקו אפשר למצוא באתר [OurWorldInData](https://ourworldindata.org/excess-mortality-covid).

34:T4bb,viewof N = { const options = [ 'Total','Male','Female','Jews Total','Jews Male','Jews Female','Arabs Total','Arabs Male','Arabs Female','0-19','20-24','25-29','30-34','35-39','40-44','45-49','50-54','55-59','60-64','65-69','70-74','75-79','80-84','85-89','90+' ]; const form = html` `; const value = {} form.i.oninput = () => form.value = { ...form.value, i: form.i.valueAsNumber }; form.i.oninput(); form.segment.oninput = () => form.value = { ...form.value, segment: form.segment.value }; form.segment.oninput(); return form; }35:T91a,vegalite({ data: { values: data_DailyDeaths }, facet: { row: { field: "Year" } }, spec: { width: 860, height: 200, layer: [ /* prior five years average - gray line */ { mark: { type: "line", size: 1, color: "rgba(180,180,180,0.75)" }, encoding: { x: { field: "Date", timeUnit: "monthdate" }, y: { field: "FiveYearAverage", type: "quantitative" } } }, /* per-day circles representing the numbers that day */ { mark: { type: "circle", size: 10 }, encoding: { color: { field: "Year", type: "nominal", legend: false }, x: { field: "Date", timeUnit: "monthdate" }, y: { field: "segment_Total", title: "Deaths", type: "quantitative" } } }, /* weekly error bands */ { mark: { type: "errorband", extent: "iqr", interpolate: "basis-open" }, encoding: { y: { field: "segment_Total", type: "quantitative", title: "" }, x: { field: "Date", timeUnit: "week", title: "" }, color: { field: "Year", type: "nominal", legend: false } } }, /* moving average line */ { mark: { type: "line", size: 3 }, encoding: { color: { field: "Year", type: "nominal", legend: false }, x: { field: "Date", timeUnit: "monthdate" }, y: { field: "ma_Total", type: "quantitative" } } }, /* cumulative since year start */ { mark: { type: "text", fontSize: 15, font: "monospace", baseline: 'top', fontWeight: 'bold', dx: 70, align: 'right', }, encoding: { text: { field: "agg_Total", aggregate: "max" }, x: { field: "Date", timeUnit: "month" }, y: { value: 155 } } }, /* per-month addition for each month */ { mark: { type: "text", fontSize: 12, font: "monospace", fontStyle: "italic", baseline: 'top', dx: 70, align: 'right', color: "#666666" }, encoding: { text: { field: "agg_Month", aggregate: "max", format: "+" }, x: { field: "Date", timeUnit: "month" }, y: { value: 170 } } } ] } })36:T6b2,data_DailyDeaths = { let yearTotal = 0 let monthTotal = 0 let firstYear = 0 const segment = N['segment'] const duration = N['i'] // get data from attached CSV file const bySectorAndAge = d3.csvParse( await FileAttachment("p-1@15.csv").text() ) // parse Date and add Year field .map(d => { const eventDate = new Date(d3.timeFormat('%Y-%m-%d')(d3.timeParse('%m/%d/%Y')(d.Date))) return { ...d, Year: eventDate.getFullYear(), segment_Total: parseInt(d[segment]), Date: eventDate } }) // sort by Date (its already sorted, just make sure) .sort( (a,b) => a.Date - b.Date ) // generate an array of moving averages const ma_Total = movingWindowAvg(bySectorAndAge.map(d => d[segment]), duration) // enrich data with aggregate of Total and with the moving average for each day return bySectorAndAge.map((d,idx) => { if (idx > 1 && d.Year != bySectorAndAge[idx-1].Year) yearTotal = 0 if (idx > 1 && d.Date.getDate() == 1) monthTotal = 0 if (!firstYear) firstYear = d.Year if (d.Year >= firstYear + 5) { d.FiveYearAverage = 1.0 * [1,2,3,4,5].reduce( (acc,yearAgo) => { const previous = ma_Total[idx - (yearAgo * 365)] if (previous > 0) return acc + previous return 0 // return acc + ma_Total[idx - (yearAgo*365)] }, 0) / 5.0 /* fix fifth year going way off scale and messing all scales */ if (d.FiveYearAverage > 700) { d.FiveYearAverage = ma_Total[idx] } } monthTotal += d.segment_Total yearTotal += d.segment_Total const agg_Total = yearTotal const agg_Month = monthTotal return { agg_Total, ma_Total: ma_Total[idx], agg_Month, ...d } }) }37:[{"id":"88a1cb221e9719391d664e826a2d8ffd34254dddf9bd53aef6ec7477f37a1b31d1c5e1b0ff40be1fb624678d07202c56993ad7919d4edbbb394f5eafb2d83578","href":"https://static.observableusercontent.com/files/88a1cb221e9719391d664e826a2d8ffd34254dddf9bd53aef6ec7477f37a1b31d1c5e1b0ff40be1fb624678d07202c56993ad7919d4edbbb394f5eafb2d83578","name":"p-1@2.csv","type":"text/csv","lastModified":1601910262256.842,"size":505217},{"id":"751ceba0d502436689aa14ac14fee226183dd623024d4a3d0cc9f1ec0e9d014da337b8669f4e31f900ceae360f82260ddd8581b858259faacc6585c4e20f6cac","href":"https://static.observableusercontent.com/files/751ceba0d502436689aa14ac14fee226183dd623024d4a3d0cc9f1ec0e9d014da337b8669f4e31f900ceae360f82260ddd8581b858259faacc6585c4e20f6cac","name":"p-1@10.csv","type":"text/csv","lastModified":1636283159578.814,"size":596599},{"id":"f5a7e359d3333413ca9e3560a96fdb73b7d470916dd586aa29df729b3864b7d851b89e869b67f25ee8b58f84e0e795f60337689457ffe088966a966d9f556262","href":"https://static.observableusercontent.com/files/f5a7e359d3333413ca9e3560a96fdb73b7d470916dd586aa29df729b3864b7d851b89e869b67f25ee8b58f84e0e795f60337689457ffe088966a966d9f556262","name":"p-1@11.csv","type":"text/csv","lastModified":1657662975933.096,"size":616165},{"id":"431cb619fd309fb06d4c63901351c7dc85fb1065d2098b93f4f79bec45f90313e9bb39a686c5f3cde32f5cfa8ae7a00d7181e34e35ea5636fcdbaccb0934af65","href":"https://static.observableusercontent.com/files/431cb619fd309fb06d4c63901351c7dc85fb1065d2098b93f4f79bec45f90313e9bb39a686c5f3cde32f5cfa8ae7a00d7181e34e35ea5636fcdbaccb0934af65","name":"p-1@12.csv","type":"text/csv","lastModified":1667755570535.921,"size":624727},{"id":"2a478eb6bd408fb94386ad6f1d0a7a50e85ef93f3c77bb38f27d83f3f57e6632a6c9f8f284fe7fc46285783351076231fc3ce5e5fe56acd3b9adac8bd4a13acf","href":"https://static.observableusercontent.com/files/2a478eb6bd408fb94386ad6f1d0a7a50e85ef93f3c77bb38f27d83f3f57e6632a6c9f8f284fe7fc46285783351076231fc3ce5e5fe56acd3b9adac8bd4a13acf","name":"p-1@9.csv","type":"text/csv","lastModified":1610658722938.699,"size":567017},{"id":"9fbfdeb9c446d2b40bb57657136d92c3cc4137ea3a3dac9937591ae3f6df9bf4f9c4bdc9585d02bc905657d608be3e72b90c4d8f2ebbe9307b6ddc1b50931625","href":"https://static.observableusercontent.com/files/9fbfdeb9c446d2b40bb57657136d92c3cc4137ea3a3dac9937591ae3f6df9bf4f9c4bdc9585d02bc905657d608be3e72b90c4d8f2ebbe9307b6ddc1b50931625","name":"p-1@7.csv","type":"text/csv","lastModified":1609770799908.173,"size":565773},{"id":"c1207b50e2d8439b3f5010687394dcc2823f74ea63e895ceef39b0c9cb246a6c4bfbe9239c5a9e51734f2d9ef91f84e2f05e1e72094245b7d9ff1ee8f9cdc754","href":"https://static.observableusercontent.com/files/c1207b50e2d8439b3f5010687394dcc2823f74ea63e895ceef39b0c9cb246a6c4bfbe9239c5a9e51734f2d9ef91f84e2f05e1e72094245b7d9ff1ee8f9cdc754","name":"p-1@15.csv","type":"text/csv","lastModified":1678572655744.571,"size":634316}] 31:{"id":"efc718a390f65d10","slug":"israel-fatalities","title":"Israel Fatalities 2000-2023","thumbnail":"48a500420f8236948b1e7a2f5175985b378eb76605273656eaa9dfc25cdb880c","access_level":"public","create_time":"$D2020-10-05T14:16:01.382Z","update_time":"$D2023-03-11T23:11:53.777Z","view_time":null,"first_public_time":"$D2020-10-05T16:20:59.775Z","fork":false,"stars":3,"starred":false,"owner":{"type":"team","id":"46a863062e736b11","login":"kesor6","name":"Evgeny Zislis","avatar_url":"https://avatars-next.observableusercontent.com/62ea106a6dd5cd85f4a7882c1a3af351d8bc579ab4d640024d60d8e3d7a4e375","tier":"starter_2024"},"version":1132,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"32bfa0c459d55768","login":"kesor6","name":"Evgeny Zislis","avatar_url":"https://avatars-next.observableusercontent.com/62ea106a6dd5cd85f4a7882c1a3af351d8bc579ab4d640024d60d8e3d7a4e375","tier":null}],"members":[{"type":"individual","id":"32bfa0c459d55768","login":"kesor6","name":"Evgeny Zislis","avatar_url":"https://avatars-next.observableusercontent.com/62ea106a6dd5cd85f4a7882c1a3af351d8bc579ab4d640024d60d8e3d7a4e375","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"title":"Israel Fatalities 2000-2023","cells":[{"id":0,"value":"# Israel Fatalities 2000-2023","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":885,"value":"_Updated based on data as downloaded on the 12th February 2023 from the CBS_","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":7,"value":"Based on the Israel Central Beurau of Statistics Death and Life Expectancy data.\n\n

מבוסס על הנתונים של מוות ותוכלת חיים שפורסמו ע\" הלשכה המרכזית לסטטיסטיקה (למ\"ס).

","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":429,"value":"$33","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":90,"value":"$34","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":46,"value":"$35","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":13,"value":"$36","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":18,"value":"md`### Libraries`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":16,"value":"d3 = require(\"d3@6\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":52,"value":"vegalite = require('@observablehq/vega-lite')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":593,"value":"function movingWindowAvg(arr, step) {\n return arr.map(function (_, idx) { \n var wnd = arr.slice(idx - step, idx + step + 1); \n var result = d3.sum(wnd) / wnd.length\n\n // Check for isNaN, the javascript way\n result = (result == result) ? result : _\n\n return result; \n })\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1131,"value":"p115 = await FileAttachment(\"p-1@15.csv\").csv({typed: \"auto\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"p115","database":"$undefined"}],"files":"$W37","stdlib":"1","titling":"auto"}} 32:"$31:body"